How can I use mysqldump correctly

Question

I am working with MySQL Server 5.5 and I have a problem retrieving my database, this is how I used this command:

mysql> mysqldump -uroot -pkail mybase > C:\Program Files\MySQL\MySQL Server 5.5\b in\base.sql; 

and this is the error I get:

 ERROR: Unknown command '\P'. ERROR: Unknown command '\M'. ERROR: Unknown command '\M'. ERROR: Unknown command '\b'. Outfile disabled. 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 'mysq dump -uroot -pkail mybase > C:\Program Files\MySQL\MySQL Server 5.5\bin' at line 1 

how can i solve the problem and thanks for any help :)

Answer 1

Mysqldump should not be run from MySQL. This is a separate team.

Close the MySQL console and try there.

---

If you look in C: \ Program Files \ MySQL \ MySQL Server 5.5 \ bin, you will see mysql.exe, and you will also see mysqldump.exe. Thus, mysqldump is a completely separate executable file from mysql.exe, so you start it from the Windows command prompt and not from the MySQL console.