Richard Teasdale
asked on
Error reading from backup file mysql
HI:
Stupidly I I entered the wrong delete command and managed to lose 97% of 2million records.
Cleverly I had a backup.
Not so cleverly I get a message 'error reading from backup file' 'unknown object in backup file'
However I have managed to backup AND restore the db since then. The difference is that the offending table was > 1GB (it still reads that even though now tiny).
Does this mean that my old backups are corrupt? I have read that there is 1Gb limit so should I run the script mysql -u<user> -p<password> < <backupfile> .. and do I have to drop ALL the existing tables first (the other 17 tables in the db are fine)?
Finally - a question: I had kept all the data now lost in a dbf file.. IS it easier to reimport rather than restore? And if so how will I know future backups are OK?
Thanks!
Stupidly I I entered the wrong delete command and managed to lose 97% of 2million records.
Cleverly I had a backup.
Not so cleverly I get a message 'error reading from backup file' 'unknown object in backup file'
However I have managed to backup AND restore the db since then. The difference is that the offending table was > 1GB (it still reads that even though now tiny).
Does this mean that my old backups are corrupt? I have read that there is 1Gb limit so should I run the script mysql -u<user> -p<password> < <backupfile> .. and do I have to drop ALL the existing tables first (the other 17 tables in the db are fine)?
Finally - a question: I had kept all the data now lost in a dbf file.. IS it easier to reimport rather than restore? And if so how will I know future backups are OK?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Looking good so far.....
ASKER
....And Done!
Thank you very much!
Four years work recovered. Points well earned.
Thank you very much!
Four years work recovered. Points well earned.
ASKER
Change of plan. I am working on the premise that the restore is failing because the table size has gone over 1gb. I should really reduce the table size (I can do some normalisation) but instead am willing to buy navicat to use instead of mysqladmin.
Does anybody have experience of using navicat; specifically restoring tables over 1gb?
And I do like the idea of navicat allowing import of dbf....
Thanks!