Re: Copy database to another Server

2003-06-11 Thread gerald_clark
William IT wrote: I do mysqlamin shutdown and copy all /var/lib/mysql file from another MySQL server. And then run: chmod -R 660 * Try 770 Mysql needs to be able to scan the directories to find tables. chown -R mysql:mysql * shutdown now -r But I can't logon to Mysql. What's wrong? --

Copy database to another Server

2003-06-10 Thread William IT
I do mysqlamin shutdown and copy all /var/lib/mysql file from another MySQL server. And then run: chmod -R 660 * chown -R mysql:mysql * shutdown now -r But I can't logon to Mysql. What's wrong? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Copy database to another Server

2003-06-10 Thread Paul DuBois
At 11:54 +0800 6/11/03, William IT wrote: I do mysqlamin shutdown and copy all /var/lib/mysql file from another MySQL server. And then run: chmod -R 660 * chown -R mysql:mysql * shutdown now -r But I can't logon to Mysql. What's wrong? We don't know. Did the server start up correctly? If it did,