Hello,
In my MySQL server 5.5 there are 5 databases, I need to backup one of them and restore it in another new Mysql server.
$./mysqlbackup --defaults-file=/usr/local/mysql/my.cnf --user=root --password='p123456' --host=10.10.10.102 --include='db1\.*' --backup-dir=/data3/mysqldata_3/mysqlbackup1410 --only-innodb-with-frm backup-and-apply-log
Then transfer backup data files to new server ,run
-bash-3.2$ ./mysqlbackup --defaults-file=/usr/local/mysql/my.cnf --innodb_log_files_in_group=2 --backup-dir=/export/home/mysql/mysqlbackup04091122 copy-back
130409 14:02:11 mysqlbackup: INFO: Copy-back operation completed successfully.
130409 14:02:11 mysqlbackup: INFO: Finished copying backup files to '/usr/local/mysql/data'
But when I start the new MysQL server, the error happened.
130409 14:02:54 InnoDB: Error: table 'db2012/tab1'
InnoDB: in InnoDB data dictionary has tablespace id 49947,
InnoDB: but tablespace with that id or name does not exist. Have
InnoDB: you deleted or moved .ibd files?
InnoDB: This may also be a table created with CREATE TEMPORARY TABLE
InnoDB: whose .ibd and .frm files MySQL automatically removed, but the
InnoDB: table still exists in the InnoDB internal data dictionary.
InnoDB: Please refer to
InnoDB:
http://dev.mysql.com/doc/refman/5.5/en/innodb-troubleshooting-datadict.html
InnoDB: for how to resolve the issue.
there are lots of this kind of error for each table in original databases and tables , I tried to resolve it by the method in document ,but did not work. please give me an idea to resolve it.
Thanks a lot.