mysqldump create database if not exist

Question

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?

score 3 · Accepted Answer · answered Jan 29 '11 at 15:34

3

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.

answered Jan 29 '11 at 15:34

Sam Cogan

38,736
6
78
114

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
2

'IF NOT EXIST' added, if --databases or --all-databases option was given. – alvosu Jan 29 '11 at 16:13

score 1 · Answer 2 · edited Mar 26 '21 at 10:53

1

--add-drop-database and --databases <database_name> (or --all-databases).

If you use mysqldump --add-drop-database <database_name>, DROP DATABASE and CREATE DATABASE statements will not be added.

edited Mar 26 '21 at 10:53

Phistrom

113
6

answered Jan 29 '11 at 15:42

alvosu

8,437
25
22

mysqldump create database if not exist

2 Answers2