Re: rescue Inno tables from an abandoned data directory?
- Date: Sat, 3 Dec 2016 16:58:03 -0600
- From: Peter Brawley <peter.brawley@xxxxxxxxxxxxx>
- Subject: Re: rescue Inno tables from an abandoned data directory?
On 12/3/2016 14:23, Martin Mueller wrote:
I abandoned a MySQL 5.22 database
There's been 5.0m 5,1, 5,4 (briefly), 5.5, 5.6 and now 5.7. No 5,.2.
that quite suddenly andthat I wasn’t able to start up again. The data directory consists of a mix of ISAM and Inno tables.
You mean MyISAM?
I was able to copy the ISAM tables into a new 5.6 version, and they work.
I understand that INNO tables are different because different tables share a common table space.
Not just that.
The MySQL documentation refers to a “cold backup,” where you copy the separate files after a “slow shutdown.” It doesn’t tell you what to do with them after you’ve put them in a “safe place.”
This refers to
Copy into identical folders on the new machine, or to corresponding
folders named in a new my.cnf.
In my case, I can reproduce Time machine backups of data directories at varying times. At one point I was able to replace the non-working installation with an earlier installation, but then it failed unpredictably.
Are the Inno tables on Time Machine useless, or can I rescue data from them?
Mysqlbackup (Enterprise) and Percona Xtrabackup are known to do reliable
I’ll be grateful for help
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql