MySQL Forums
Forum List  »  Backup

mysqlbackup backup one of databases and restore issue
Posted by: Justin Xu
Date: April 09, 2013 01:18AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqlbackup backup one of databases and restore issue
2513
April 09, 2013 01:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.