File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes using a mysql db on web. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "using a mysql db on web." Watch "using a mysql db on web." New topic

using a mysql db on web.

Justin Fox
Ranch Hand

Joined: Jan 24, 2006
Posts: 802
i want to make a mysql database, and I know how, but how do I get the .database file? I've tried before but I don't know how to "dump" the database into a file so i can manipulate it on my server.


Justin Fox

You down with OOP? Yeah you know me!
Wayan Saryada
Ranch Hand

Joined: Feb 05, 2004
Posts: 105

You can export your local MySQL database table including their data into SQL script, and then import it to your online database in your web server.
[ November 28, 2007: Message edited by: I Wayan Saryada ]

Website: Learn Java by Examples
Justin Fox
Ranch Hand

Joined: Jan 24, 2006
Posts: 802
ok thanks, I'll look into the different mysql commands to do so.

also, can php connect to any database, or is mysql pretty much it?

Thanks again,

Justin Fox
Joachim Rohde
Ranch Hand

Joined: Nov 27, 2006
Posts: 430

Taken from :
"Drivers for the following extensions pass
the complete test suite and provide
interchangeability when all of DB's
portability options are enabled:

fbsql, ibase, informix, msql, mssql,
mysql, mysqli, oci8, odbc, pgsql,
sqlite and sybase."
I agree. Here's the link:
subject: using a mysql db on web.
It's not a secret anymore!