MySQL Forums
Forum List  »  NDB clusters

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How to check mysqldump backups are consistance or good to restore
1579
Athaullah Mohammed
January 27, 2016 11:27AM
Re: How to check mysqldump backups are consistance or good to restore
820
George lin
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.