MySQL Forums
Forum List  »  MySQL Administrator

Restore from MySQLDump - Truncate First?
Posted by: jason wilcox
Date: June 22, 2010 11:10AM

If I've done a mysqldump of a DB and later wish to restore from that dump would I need to do a truncate or drop of the tables first to ensure a clean restore?

From what I've read it would seem that an import of a dump file into an existing database would simply insert the additional data from the dump. But this could potentially leave data entered after the mysqldump intact. So I'd end up with a merge of data from my mysqldump and what was entered after. Or, does the import process truncate/drop existing tables prior to the import?

Options: ReplyQuote

Written By
Restore from MySQLDump - Truncate First?
June 22, 2010 11:10AM

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.