Re: How to restore dates from ibdata1 and old dump.
If you have copied the MySQL data directory from /var/lib/mysql to /path/to/new/dir, but only copy the database folders (i.e. mysql, wpdb, ecommerce, etc) AND you do have innodb tables, your innodb tables will show up in 'show tables' but queries on them (select and describe) will fail, with the error Mysql error: "table db.tableName doesn't exist". You'll see the .frm file in the db directory.
For innodb tables, it's important to copy over the ib* files like ibdata1, ib_logfile0, and ib_logfile1. Once you will have copied over, everything worked as expected.
If your my.cnf file contains "innodb_file_per_table" the .ibd file will be present in the db directory but you still need the ib* files.
Subject
Views
Written By
Posted
6346
October 21, 2012 05:52AM
2990
October 22, 2012 03:21AM
2387
October 28, 2012 03:04AM
Re: How to restore dates from ibdata1 and old dump.
2888
October 28, 2012 09:40PM
2246
November 08, 2012 12:19AM
1936
November 18, 2012 10:30PM
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.