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!
Richard TeasdaleFinancial ControllerAsked:
Who is Participating?
 
mankowitzConnect With a Mentor Commented:
Navicat is a good program, but I'm not sure you need it. Sometimes you can get backup errors if the max_packet_size is too small to load blobs in one slurp. Also if you backup using one version of mysql and restore using another. If you use the migration toolkit, it should give you more specific errors (i.e. malformed data).

But start by making your max_packet to 1 gb, and see if it works.

see http://stackoverflow.com/questions/291369/what-would-lead-to-an-unknown-object-in-backup-file-problem-when-restoring-a-ba
0
 
Richard TeasdaleFinancial ControllerAuthor Commented:
Hi Again.
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!
0
 
Richard TeasdaleFinancial ControllerAuthor Commented:
Looking good so far.....
0
 
Richard TeasdaleFinancial ControllerAuthor Commented:
....And Done!
Thank you very much!
Four years work recovered. Points well earned.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.