CODEWITHSUNDEEP
sqlmysql-workbenchmysqlmysql-error-1064
Zain
Zain

Reputation: 5571

mysqldump command does not run in mysql shell

I am getting the following error when I try to dump a specific table of mysql database.

Steps:

mysql> mysqldump -urefill -p refill Refill > Users/zainbutt/Documents/Refill.sql; 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 'mysqldump -urefill -p refill Refill > Refill2.sql' at line 1

Upvotes: 0

Views: 302

Answers (2)

Roshan Dandgavhal
Roshan Dandgavhal

Reputation: 559

Please try this

mysql> mysqldump -u refill -prefill Refill > Users/zainbutt/Documents/Refill.sql

Upvotes: 0

gandaliter
gandaliter

Reputation: 10111

mysqldump is a program in its own right, not a query to be called from within mysql. You call it from a shell, not from a mysql prompt.

Upvotes: 2

Related Questions