Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

using a mysql db on web.

 
Justin Fox
Ranch Hand
Posts: 802
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

Thanks,

Justin Fox
 
Wayan Saryada
Ranch Hand
Posts: 105
IntelliJ IDE MySQL Database Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Justin Fox
Ranch Hand
Posts: 802
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 433
Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Taken from http://pear.php.net/package/DB :
"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."
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic