• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 840
  • Last Modified:

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!
0
ClaytonGlass
Asked:
ClaytonGlass
  • 3
1 Solution
 
ClaytonGlassAuthor 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
 
mankowitzCommented:
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
 
ClaytonGlassAuthor Commented:
Looking good so far.....
0
 
ClaytonGlassAuthor Commented:
....And Done!
Thank you very much!
Four years work recovered. Points well earned.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now