mysqldump not working!

[Anon]

Using this syntax:
mysqldump -u username -p db_name table_name > output.txt

Creates this error:
ERROR 1064: You have an error in your SQL syntax near 'mysqldump -u username -p db_name table_name > output.txt' at line 1

Why?

[katzkek]

You have to do it from the command line.

bash$ /path/to/mysql/bin/mysqldump -u -p db_name table_name > output.txt

[[deleted]]

mysqldump is not an SQL query, it is an executable.

[Anon]

mysqldump is not an SQL query. Try same command (you are using) at command prompt.
I just tested it again before reply you.

[Anon]

Thanks, doh! I figured that out on my own late last night. But it still isn't working:
asks for pasword but then I get the error shown below.

bash$ mysqldump -u username -p db_name table_name > table_name.sql
Enter password:
mysqldump: Got error: 2002: Can't connect to local MySQL server through
socket '/tmp/mysql.sock' (111)

[[deleted]]

It'll stop asking for the password if you put the password immediately after the -p:
bash$ mysqldump -u username -ppassword_here db_name table_name > table_name.sql

Note: make sure this file is not world-readable!