Mysql database backup by using query

Question

I wanna dump file for MySQL database using query.I got the dump file when i used shell.but i could not get dump file while using heidisql.

In Shell:

C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin>
mysqldump -uroot -proot >"D:\backups\student.sql"

In Heidisql:

C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqldump -u root -p root databases student >"D:\student.sql"
mysqldump -u root -p[root] [student] > D:/student.sql

And the error is . . .

Kamil Gosciminski
– Kamil Gosciminski

2016-09-26 07:27:04 +00:00
Commented Sep 26, 2016 at 7:27 — Kamil Gosciminski
– Kamil Gosciminski, Commented Sep 26, 2016 at 7:27

Anse · Accepted Answer · 2016-09-26 17:16:47Z

2

mysqldump is an application, HeidiSQL is another one. You're creating an .sql file by telling an application to create it, either mysqldump or HeidiSQL. You cannot use both applications at the same time.

In HeidiSQL, click on Tools > Export database as SQL, then follow the dialog.

answered Sep 26, 2016 at 17:16

Anse

1,71014 silver badges30 bronze badges

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

2 Comments

Kanika Over a year ago

Thanks for your answer.

Anse Over a year ago

You can accept the answer as the correct one by clicking on the marker on the left of it. That's how that works here on StackOverflow.

Collectives™ on Stack Overflow

Mysql database backup by using query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related