MySQL Forums
Forum List  »  NDB clusters

Re: How to check mysqldump backups are consistance or good to restore
Posted by: George lin
Date: February 01, 2016 07:01PM

There are two feasible ways:
1, open the dump SQL file to review the SQL grammar whether is correct or not.
2, create a new DB and same table architecture as the dumped table, and use
mysqlimport to import to the new empty table to have a check.

hope to help you.

more questions can be posted on this forum or on www.gloCalHelp.com or gloCalHelp.servebeer.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to check mysqldump backups are consistance or good to restore
756
February 01, 2016 07:01PM


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.