MySQL Forums
Forum List  »  Data Recovery

Use File Offset for Recover?
Posted by: Mike Nicewarner
Date: September 19, 2011 12:40PM

I'm fighting with a huge backup file, over 50GB, which is a total server backup of 10 databases. Right now I need to recover the most critical DBs first, and I'll get the other ones later. However, when MySQL reads the file, it starts at the beginning and just chugs through, even when it is not in the right database to recover.
I have a suggestion.
During the Analyze phase, as the DBs and tables are located in the file, store the offsets to the location in the file. Then, when recovering, use the offsets to position the load right where it should start for each database. Of course, if you just restore everything, disregard the offsets and just process like normal. But if you are only restoring some tables, it would really make it better/faster/happier to skip large sections of the file.

Just my thoughts.

Options: ReplyQuote

Written By
Use File Offset for Recover?
September 19, 2011 12:40PM

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.