mysqldump command does not run in mysql shell

Question

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

Steps:

SSH'ed to a machine
Moved into the mysql session
Executed the following command

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

mysqldump is a separate program. You're trying to run it from within the mysql monitor as if it was a query. — Marc B
– Marc B, Commented Sep 8, 2014 at 17:26

gandaliter · Accepted Answer · 2014-09-08 17:26:38Z

2

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.

answered Sep 8, 2014 at 17:26

gandaliter

10.1k1 gold badge19 silver badges23 bronze badges

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

8 Comments

Zain Over a year ago

could you please list down the steps?

Marc B Over a year ago

what steps? it's a SEPARATE PROGRAM.

Zain Over a year ago

then how should I be able to take a dump?

gandaliter Over a year ago

You do exactly what you have done, but skip the bit where you move into a mysql session.

Zain Over a year ago

then it gives me the following error $ mysqldump -urefill -p refill Refill > Users/zainbutt/Documents/Refill.sql; -bash: Users/zainbutt/Documents/Refill.sql: No such file or directory

|

Roshan Dandgavhal · Accepted Answer · 2014-09-10 09:28:31Z

0

Please try this

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

answered Sep 10, 2014 at 9:28

Roshan Dandgavhal

5593 silver badges12 bronze badges

Collectives™ on Stack Overflow

mysqldump command does not run in mysql shell

2 Answers 2

8 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related