Re: BLOCK_SYNC_ERROR truncates my data
1. Nothing is compressed by default. As long as you didn't use 'myisampack', everything should be in plain in .MYD.
2. To create a new index file from .MYD and .frm is to use the command REPAIR TABLE ... USE_FRM.
3. Are you sure that your backup was done from a consistent state? I.e. was the server inactive or did you hold a global read lock? If so, there should be a way to get your data back.
4. Do you use the same MySQL version with wich you made the backups?
Subject
Views
Written By
Posted
3862
March 21, 2005 09:06AM
Re: BLOCK_SYNC_ERROR truncates my data
2463
April 26, 2005 06:10AM
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.