| |

VerySource

 Forgot password?
 Register
Search
View: 27|Reply: 3

Questions about myslq data recovery?

[Copy link]

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

Post time: 2020-2-16 12:00:02
| Show all posts |Read mode
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? ?
Reply

Use magic Report

0

Threads

22

Posts

14

Credits

Newbie

Rank: 1

Credits
14

 China

Post time: 2020-4-21 14:30:01
| Show all posts
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!
Reply

Use magic Report

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 China

 Author| Post time: 2020-4-28 13:15:02
| Show all posts
Enclose it in single quotes
 Where is it added? ?
Reply

Use magic Report

0

Threads

16

Posts

13

Credits

Newbie

Rank: 1

Credits
13

 China

Post time: 2020-5-4 12:30:01
| Show all posts
How to export?
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list