Page 1 of 1

Errors restoring mysqldump backup

Posted: 28 Mar 2023, 14:53
by zoomiest
I installed the new 0.9.7 and it went flawlessly. Wonderful.
However, as I go through normal commands to restore my data, I get new errors.
When I google my error it says that I have the SQL command wrong (?)

$ sudo mysql -u cats -p -f -D cats < dbackup.sql

but, I get:
ERROR 1064 (42000) at line 616: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' Current\n * Online Marketer at Indipendente (Sole Proprietorship...' at line 1

It looks like it hit some data, it didn't like and it coughed.

Have you seen anything like this before?
Is this a version mismatch from my database and a new version of MariaDB?
Did that bracket in my data throw off MariadB?
Even the -f switch is not letting me skip errors

Environment: Ubuntu server 22.04.2 LTS
MariaDB 15.1

Re: Errors restoring mysqldump backup

Posted: 05 Feb 2024, 03:02
by williamshane
The error notice indicates that there is a syntax problem in your SQL dump file (dbackup.sql) around line 616. There appears to be a SQL data string that is either formatted incorrectly or contains unexpected characters.

Here are several recommendations to resolve this matter:

Verify the SQL dump file:
Access the dbackup.sql file and locate line 616. Analyze the SQL command or data in the vicinity of that line to detect any syntax problems or atypical characters. Revise or amend the problematic portion.

Quotation marks (' and ") and special characters should be carefully considered while dealing with your data. Make sure that they are adequately encoded if necessary. Syntax errors can occur when quotations or special characters are mishandled.

Database Version Compatibility: Ensure that the version of MariaDB you are utilizing is compatible with the SQL dump. Although slight variations in versions may not result in problems, significant version updates can bring about modifications in syntax. Make sure that you are importing the dump into a compatible version of MariaDB.

Re: Errors restoring mysqldump backup

Posted: 26 Feb 2024, 09:01
by honkoptimistic
it's work. thx

Re: Errors restoring mysqldump backup

Posted: 22 Mar 2024, 08:20
by nimoprteva
doesnot work for me