Solved

Error reading from backup file mysql

Posted on 2011-09-12
4
783 Views
Last Modified: 2012-05-12
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
Comment
Question by:ClaytonGlass
  • 3
4 Comments
 

Author Comment

by:ClaytonGlass
ID: 36528405
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
 
LVL 24

Accepted Solution

by:
mankowitz earned 250 total points
ID: 36528961
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
 

Author Comment

by:ClaytonGlass
ID: 36529286
Looking good so far.....
0
 

Author Closing Comment

by:ClaytonGlass
ID: 36529371
....And Done!
Thank you very much!
Four years work recovered. Points well earned.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
insert row field data graphically 4 24
UPDATE query not working in mysqli php 8 52
Display images from mysql blob type (Not working) 9 30
MySQL Memory Keeps Increasing 4 36
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question