Moving a MySQL database

[Rick Root]

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 to the new server, or is it more complicated than that?

The version of mysql will be exactly the same.

I'm moving the sites to a temporary server so I can rebuild my production server with RAID, more reliable filesystems, etc.

I'm running MySQL 3.23.41 from a binary RPM distribution on RedHat 7.2

Thanks.

P.S. - is there a mailing list archive? I didn't see a refernece to one on the MySQL web site.


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php