windows batch file for mysqldump command

Question

this is first time I am upto making a windows batch file.I wish not to do experiments first as its related to live server. I use to back up mySql database by following open cmd write

mysqldump -u user -p DBname >C:\DBname.sql

then cmd ask password

password = password

I want to make a windows batch file ,upon click I wish to perform the above functionality. Can any one please give some instructions related script of .bat file

So far I wrote this

ECHO OFF
mysqldump -u user -p DBname >C:\DBname.sql
GO
SET password = password 
Go

but still it prompts me for password . I wish password get enter automatically

Sean409 · Accepted Answer · 2014-10-22 22:13:16Z

15

The above was still prompting me for a password I used whats below to get it to work correctly.

"C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\mysqldump.exe" -uroot -pDBPass DBName > C:\DBname.sql

answered Oct 22, 2014 at 22:13

Sean409

1731 silver badge5 bronze badges

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

1 Comment

kapitan Over a year ago

when you do -ppassword instead of -p password it worked as expected, upvoted!

Jay Lee · Accepted Answer · 2013-01-03 13:41:53Z

10

The one-liner:

mysqldump -u user -p DBname --password YOURPASSWORD > C:\DBname.sql

should do it.

answered Jan 3, 2013 at 13:41

Jay Lee

13.5k3 gold badges32 silver badges60 bronze badges

3 Comments

Learnner Over a year ago

yes ,thanks , i did following ECHO OFF mysqldump -u user -ppassword DBname >C:\DBname.sql GO

caglaror Over a year ago

great thank you. I forgot -p for password parameter. Because of my password has 'p' for first character. ;)

Kellen Stuart Over a year ago

Could you maybe write out the whole program in your answer? I'm a beginner with .bat and it's hard for me to piece it together from this answer/question above.

Martin Evans · Accepted Answer · 2017-10-31 09:22:00Z

1

You can use this:

"C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe" -u root -proot test > D:\DBname.sql

Please note this: -proot, the p and root must be together

edited Oct 31, 2017 at 9:22

Martin Evans

46.9k17 gold badges88 silver badges104 bronze badges

answered Oct 31, 2017 at 9:01

邱林和

411 bronze badge

Comments

Edmunds22 · Accepted Answer · 2021-08-11 07:35:12Z

0

"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump.exe" -u root -pmypassword --databases mydatabase --hex-blob > C:\mybackup.sql

Paste into a bat file, I couldnt get the plain command to work in task scheduler so used a BAT

You can omit the --hex-blob, its there incase you're using blob columns

answered Aug 11, 2021 at 7:35

Edmunds22

80910 silver badges11 bronze badges

Collectives™ on Stack Overflow

windows batch file for mysqldump command

4 Answers 4

1 Comment

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related