create database if not exists in mysqldump command while importing database

Asked Oct 16 '19 at 07:44

Active Oct 16 '19 at 07:44

Viewed 179 times

I've exported database by using following command.

mysqldump -u root myDB -R > E:\Java\AkshayProject\Dump\DBbackup.sql

I want to import this database to another machine. I tried,

mysqldump -u root myDB -R < E:\Java\AkshayProject\Dump\DBbackup.sql

but it is saying that myDB does not exists. I want to dynamically create database named myDB if not exists and then import it. How can I achieve this?

asked Oct 16 '19 at 07:44

अक्षय परूळेकर

Possible duplicate of [mysqldump with create database line](https://stackoverflow.com/questions/16452523/mysqldump-with-create-database-line) – Oct 16 '19 at 08:06
One way is to use mysqlpump instead. This adds create database statements by default. – Oct 16 '19 at 08:08
@Lunc give me example please. – अक्षय परूळेकर Oct 17 '19 at 13:47
Please tell me Where should I use --add-drop-database etc keywords in the example I've given in question description? – अक्षय परूळेकर Oct 17 '19 at 13:49

create database if not exists in mysqldump command while importing database

0 Answers0