生产环境无法使用mysqldump，报SQL语法错误1064（42000）求助

The Root Cause #

The error you’re hitting is a common one—you’re trying to run mysqldump from inside the MySQL interactive shell (the screen with the mysql> prompt), but mysqldump isn’t a SQL command. It’s a standalone system utility that you need to run directly from your terminal (like Bash, Command Prompt, or PowerShell), not within the MySQL client.

How to Correctly Run mysqldump #

Exit the MySQL shell first (we’ll cover how to do that below), then run these commands in your system’s terminal:

• Specify host, username, and database:

  mysqldump -h 127.0.0.1 -u username -p db_name > dumpfile.sql
  

  After running this, you’ll be prompted to enter your password (don’t add the password right after -p unless you’re okay with it being visible in your command history).

• If you must include the password in the command (not recommended for security):

  mysqldump -u username -ppassword db_name > dumpfile.sql
  

  Important: There’s no space between -p and your password here.

• Simplest form (for default local host and credentials):

  mysqldump db_name > dumpfile.sql
  

  You’ll still get a password prompt if your MySQL user requires one.

How to Exit the MySQL Shell #

If you’re currently stuck inside the mysql> prompt, type this command to return to your system terminal:

exit;

Or use keyboard shortcuts: Ctrl+D (on Linux/macOS) or Ctrl+Z (on Windows).

Quick Extra Tips #

• Ensure mysqldump is in your system’s PATH so you can run it from any directory. If not, use the full path to the executable (e.g., /usr/bin/mysqldump on Linux or C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe on Windows).
• Avoid putting your password in the command line—it gets logged in your shell history, which is a security risk.

内容的提问来源于stack exchange，提问作者shalini