Mysql Database Backup Using Batch file

Question

I am trying to backup my MySql databases on Windows via a batch file. It works fine. but i want to remove the default use "database" and create "database" command.from that .sql file which is by default created while creating backup.

these are the lines i want to remove before taking backup for each .sql file

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `database name` /*!40100 DEFAULT CHARACTER SET utf8 */;

USE database name;

Param · Accepted Answer · 2015-09-11 14:11:27Z

1

Ya I got the answer from mysql official site. I have used '--databases' in my batch file. to backup all databases.present in server. just removing that and now it works fine.

answered Sep 11, 2015 at 14:11

Param

551 silver badge6 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

AdrianBR · Accepted Answer · 2015-09-11 10:01:14Z

0

--no-create-db

Do not write CREATE DATABASE statements

https://dev.mysql.com/doc/refman/5.6/en/mysqldump.html#option_mysqldump_create-options

answered Sep 11, 2015 at 10:01

AdrianBR

2,5881 gold badge17 silver badges29 bronze badges

1 Comment

Param Over a year ago

Thank's For your reply but how to remove use "database".

Collectives™ on Stack Overflow

Mysql Database Backup Using Batch file

2 Answers 2

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Related