Unable to export entire db

Question

I'm unable to export my database. I have tried several times unsuccessfully including:

mysqldump -u root -p --opt --db_2 -r backup.sql;

and

mysqldump --database --user=root --password db_2 > export_into_db.sql;

I get this error with both of them:

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 --database --user=root --password db_2 > export_into_db.sql' at line 1

Possible duplicate of [How to export a mysql database using Command Prompt?](http://stackoverflow.com/questions/3031412/how-to-export-a-mysql-database-using-command-prompt) — Martin, May 01 '17 at 16:04
@Arslan.H It looks very much like you're trying to run this as an SQL query. — Siguza, May 01 '17 at 16:04
Sorry, I meant are you running this from a command line prompt or from within the mysql environment? — j08691, May 01 '17 at 16:04
What does the prompt (the text in the terminal to the left of what you enter) say? — j08691, May 01 '17 at 16:07

score -1 · Accepted Answer · answered May 01 '17 at 16:09

For anyone who is using mac you need to do the following steps in order to export the sql:

1.open a new terminal window
2.type this to enter the mysql if your unable to enter it PATH=$PATH:/usr/local/mysql/bin
3.mysqldump -u root -p db_2 >/Users/your_name/Desktop/sql.sql;
4.type password

Unable to export entire db

1 Answers1