Exporting PHPMyAdmin database to live server.

Hollister11

I have been working on a college project for the last while, and I need to deploy it . My database is with phpmyadmin, so my question is how do a export this to use with my application when it's live.

Buford T Justice

mysqldump -u [username] -p [database_name] > [location-to-save.sql]

next prompt will ask for your password, assuming you have one set.


On the live site, its a case of:

mysql -u [username] -p [database_name] < [location-to-file.sql]

next prompt will ask for password, assuming you have one set.

Have you command line access to both databases?

daymobrew

Or, if you are used to using phpMyAdmin, export to SQL from there and then go to phpMyAdmin on the live server and import. Obviously this relies on the live server having phpMyAdmin.

While this is slower than using the command line that Buford has suggested, it sounds like you may be more comfortable with a web interface like phpMyAdmin.

Buford T Justice

daymobrew wrote: »

Or, if you are used to using phpMyAdmin, export to SQL from there and then go to phpMyAdmin on the live server and import. Obviously this relies on the live server having phpMyAdmin.

While this is slower than using the command line that Buford has suggested, it sounds like you may be more comfortable with a web interface like phpMyAdmin.

Remember, you are limited to the size of the database doing it this way.

daymobrew

Buford T Justice wrote: »

Remember, you are limited to the size of the database doing it this way.

True - though gzip can help for upload size issues.

I suggested the simpler web interface because OP says My database is with phpmyadmin instead of "I have a SQL database".