RE: how to move db

2001-11-12 Thread Daniel Las
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:

Re: how to move db

2001-11-12 Thread Bill Adams
[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