Hi The safest way to do this is to use "mysqldump" utility.
mysqldump -u [username] -p dbname > /path/to/dumpfile and then mysql -u [username] -p dbname < /path/to/dumpfile Regards ____________________________________ Daniel Łaś e-direct Polska sp. z o.o. WWW: http://www.e-direct.pl E-mail: [EMAIL PROTECTED] 45-072 Opole ul. Reymonta 45 tel. +48 77 44 26 073 fax. +48 77 44 26 074 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Monday, November 12, 2001 8:57 PM > To: [EMAIL PROTECTED] > Subject: how to move db > > > > > 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. > > Thanks for the assist > > > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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