MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

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

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


Subject
Views
Written By
Posted
Why does mysqldump not add a drop database?
8289
peter.hamilton-scott
October 29, 2005 11:24AM
Re: Why does mysqldump not add a drop database?
4164
Julio Borges
November 16, 2005 07:09PM
Re: Why does mysqldump not add a drop database?
5994
khaled labidi
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.