backup the database using MySql

Question

hi i want to backup my MySql database, i write this command :

mysqldump -u root -ppassword -h localhost --all-databases > backup.sql;

and it give this error:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mysql
dump -u root -pmanager -h localhost --all-databases > backup.sql' at line 1

why? and what should be do? thanks...

Jim · Accepted Answer · 2013-09-23 12:40:47Z

3

You are running this command in mysql. You should be running it from the command line instead.

answered Sep 23, 2013 at 12:40

Jim

22.7k6 gold badges55 silver badges81 bronze badges

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

3 Comments

ooo Over a year ago

it give me: Access is denied. why?

ooo Over a year ago

is there a command or a way to know the open sessions in mysq?

Jim Over a year ago

@ooo SHOW PROCESSLIST; will list open sessions.

Collectives™ on Stack Overflow

backup the database using MySql

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related