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

Khaled LABIDI

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Why does mysqldump not add a drop database?
5933
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.