Moving mySQL DBs between servers

Moving mySQL DBs from one server to another:

mysqldump -uUSER -pPASSWORD txp_database > txp_database.sql

puts the entire thing in one nicely portable text file.

on a new server it takes

mysql -uUSER -pPASSWORD txp_database < txp_database.sql

to import it.

Taking backup of mysql database using cron Taking backup of mysql database using cron Create a file...
How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1 This tutorial is based on Falko Timme’s tutorial for MySQL...
Turbo charging MySQL by setting up the query cache To make sure MySQL uses the query cache, there are...
Linux Server Type: Restoring MySQL SimLink. If you’re unable to restart mysqld and troubleshooting the cause:...

This entry was posted on March 27, 2009, 23:02 and is filed under Linux Tutorials, MySQL, Techno Babble. You can follow any responses to this entry through RSS 2.0. You can leave a response, or trackback from your own site.