MySQL Forums
Forum List  »  Backup

Re: Why does mysqldump not add a drop database?
Posted by: khaled labidi
Date: December 25, 2005 02:20PM

I had the same problem as Peter Hamilton.

In fact, it's only when I try a single Database backup that the "DROP DATABASE IF EXISTS" does not appear in the output sql file. But when I use the option "--all-databases", the "Drop database ..." statement is right there before each create statement.

Also, when I use --database DB1 DB2 DB3 ... the "drop databse" is right there in the sql outputfile.

So I wonder why does a single database bakup is not producing the "drop database" statement ?

MySQL version : 5.0.16/Win32


Options: ReplyQuote

Written By
Re: Why does mysqldump not add a drop database?
December 25, 2005 02:20PM

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.