Running a Database on a Live Public Server?

[eluser]Phil Sturgeon[/eluser]
To get it sent to a file use:

mysqldump --opt -u dbuser -pPASSWORD dbname > /home/someuser/my_backup.sql

Your file is then ready to be SCP/FTPed to your live server. Do this over the command line if you know how or crack open an FTP client and download the file. Then upload it to your live server.

mysql -u dbuser -pPASSWORD dbname < /home/someuser/my_backup.sql

This method is clearly more complicated than phpMyAdmin but has the added advantage of working with crazy-f**k-huge files.