MySQL Forums
Forum List  »  Data Recovery

recovering a single table from database dump
Posted by: Ravi Thati
Date: March 24, 2010 09:09AM

Hi All,

I have been searching for methods to restore a table from full database dump.

The two methods i found from googling are:
To parse dump file and identify table starting, ending locations in the dump and filter them using any shell utility/program. And apply those lines to MySQL server.

2. First restore the database dump to temporary server and take dump of that table from the temporary mysql server to restore to actual mysql server.

Is there a real good MySQL supported way of doing it??
using any mysqlbinlog utility OR any such utility which can filter entire Table from dump file

Ravi Thati

Options: ReplyQuote

Written By
recovering a single table from database dump
March 24, 2010 09:09AM

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.