[EMAIL PROTECTED] wrote: > I'm switching over to a bigger better faster server. My old server is running > version 3.23.22-6 mysql on RH and I need to move all the db's to my new box > using 3.23.41 installed on RH7.2. So do I just simply move all of the db > directories from /var/lib/mysql from one box to the next or are there other > files that I need to copy as well.
Just move all of the files, watch those permissions. e.g.: oldbox: mysqladmin shutdown newbox: adduser mysql ...bla bla bla mysqladmin shutdown (if it is running) cd /var/lib mv mysql mysql.orig cp -Rva /net/oldbox/var/lib/mysql . safe_mysqld & b. --------------------------------------------------------------------- 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
