Restore from MySQLDump - Truncate First?
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?
Subject
Written By
Posted
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.