I need to move a whole bunch of web sites from one server to another.
This means moving cold fusion, MySQL, qmail, etc.. fun stuff.
What's the best way to move *ALL* of the MySQL databases on my system?
Do I basically just shut down the database, tar up the /var/lib/mysql
directory and move it
Well,
My best method has been to do the following:
1. Dumb the existing database to a file: mysqldump databasename
database.txt.
2. On the new machine, create the new database. create databasename
3. Copy the file (database.txt) to the new machine.
4. Type.. mysql databasename
How do I move a MySQL database to a new computer?