Not able to get Backup of MYSQL Database by Batch File in Windows

Question

i wrote following command in a file and made it a Batch File,and after running Batch File i am getting a Blank SQL File.

mysqldump –u root –proot lakshmimbar > db_test.sql

open your Batch File in notepad and in the end of all line write pause and run the batch file again see what error your getting and show the error here once you can't understand what that error means — Vivek S.
– Vivek S., Commented Aug 20, 2014 at 10:34
and if your batch file only contains mysqldump –u root –proot lakshmimbar > db_test.sql then it wont take backup — Vivek S.
– Vivek S., Commented Aug 20, 2014 at 10:37
@WingedPanther thanx for reply.if it wont work,then what i need to do take backup of mysql database using batch file..and i have written pause at end but it didn't throw any error..still getting a blank sql file. — Surya Rawat
– Surya Rawat, Commented Aug 20, 2014 at 10:47
this is the only statement i have written inside Batch file,see i don't have much idea about it,plz tell me if any other thing i need to add. — Surya Rawat
– Surya Rawat, Commented Aug 20, 2014 at 10:53

Vivek S. · Accepted Answer · 2014-08-20 11:08:28Z

1

for example, if mysqldump is located in D:\MySQL\MySQL Server 5.5\bin\mysqldump(in your case the place where you have installed Mysql probabily in C:\Program Files)

create a batch file like below

    cd /D D:\\MySQL
    cd MySQL Server 5.5
    cd bin
    mysqldump -u user -p database > backup_file_name.sql

run the script and comment if any error occurs

edited Aug 20, 2014 at 11:08

answered Aug 20, 2014 at 11:01

Vivek S.

22.3k9 gold badges71 silver badges87 bronze badges

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

1 Comment

Surya Rawat Over a year ago

its done..thanx a lot for solution..c:\ cd C:\Program Files\MySQL\MySQL Server 5.5\bin mysqldump -u root -proot lakshmibar>C:\lakshmibar.sql

Collectives™ on Stack Overflow

Not able to get Backup of MYSQL Database by Batch File in Windows

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related