up vote 0 down vote favorite
share [g+] share [fb]

i want to use mysqldump so that it includes the statement to create database if not exists, and drop database if exists. is this possible? what options can I use?

link|improve this question
72% accept rate
feedback

2 Answers

up vote 1 down vote accepted

You can get MYSQLDump to drop the database before creating it by adding

--add-drop-database

To your MYSQLDump command. You should already have the create database command in there.

link|improve this answer
how do I make create table statement use namespace(db name) – user12145 Jan 29 '11 at 15:56
Only to correct the source code client/mysqldump.c. mysqldump add 'USE DBNAME;' statement. – alvosu Jan 29 '11 at 16:11
'IF NOT EXIST' added, if --databases or --all-databases option was given. – alvosu Jan 29 '11 at 16:13
feedback
up vote 0 down vote

--add-drop-database and --database name(or --all-databases). If use mysqldump db_name --add-drop-database, DROP DATABASE and CREATE DATABASE not be added.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.