Questions about myslq data recovery?

拔刀断水

I accidentally deleted the information in my database completely. Before, but I backed up. In my data recovery, I used two methods:
1: Read text directly with import, but prompt that text cannot be read
2: Use sql, prompt during the recovery process: MySQL said:


# 1064-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 'GROUP,' 1 '), (29,' 1 ', group_users,' 1 ') , (30, '1'

The text just exported, why is it that the version is different? ?

獠牙精英

use near 'GROUP,' 1 '
Is the GROUP here in the SQL statement or the data content to be restored?
If it is in SQL, it should be written as GROUP BY, if it is the content of the data to be restored, enclose it in single quotes ~
Since you are recovering data, it should be the latter!

拔刀断水

Enclose it in single quotes
 Where is it added? ?

noendenergy

How to export?