2012年8月23日 星期四

error 1164 database.table doesn't exit fix

if you can't dump all sql file with mysqldump command, use this method to instead of

1. stop mysql services on original server
# stop mysql

2. on target computer copy all data database and ibdata1 to this host
# mount  //X.X.X.X:/var/lib/mysql/  /mnt
# cp -rf  /mnt/databasename  /var/lib/mysql
# cp /mnt/ibdata1

remember don't copy ib_logfile0 and ib_logfile1
3. start mysql-server services
# start mysql