Restoring a mysqldump Leads to Syntax Error: ERROR 1064 (42000) at line 1: 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: [Warning] Using a password on the (Doc ID 2953188.1)

Last updated on JUNE 13, 2023

Applies to:

Symptoms

Syntax error in dumpfile created by mysqldump:

 The syntax error could be a different message, for example about a deprecated option used,  but the key is they it's a Warning and near the top of the file.

Changes

 mysqldump version 8.0.29 or earlier was used to create the dump.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.