ERROR NAVICAT GK & BUFFER SQL

[DennisGR]

οταν βαζω της gk και της buffer τα sql μου βγαζει τα εξεις προβληματα......στο navicat ....

1)[Err] 1136 - Column count doesn't match value count at row 1

[Msg] Finished - Unsuccessfully

2)[Err] 1062 - Duplicate entry '121212' for key 1

[Msg] Finished - Unsuccessfully

 

[mirsadse]

if your backup isn't .sql file format :

1.) Install xampp

 

2.) ( use this stap only if you dont use password for mysql if you use then skip it ) go to your

http://localhost/security/xamppsecurity.php

and enter MySQL password

 

3.) create new db in navicat or create it in

http://127.0.0.1/phpmyadmin/ 

and inport your backuped files over navicat

 

4.) go to your

http://127.0.0.1/phpmyadmin/

and export tables you need

 

5.) edit table where is duplicate entry 121212 and remove unnecessary Columns

6.) then inport them in your db

 

if your backup is .sql file then:

1.) edit table where is duplicate entry 121212 and remove unnecessary Columns

2.) then inport it in your db

 

It is really sample thing to do

[xdem]

οταν βαζω της gk και της buffer τα sql μου βγαζει τα εξεις προβληματα......στο navicat ....

1)[Err] 1136 - Column count doesn't match value count at row 1

[Msg] Finished - Unsuccessfully

2)[Err] 1062 - Duplicate entry '121212' for key 1

[Msg] Finished - Unsuccessfully

 

 

re anio9e edw kaneis [sHARE] ti akrivos den exeis katalavei? gam1sate ola ta section me ta help sas, idika esu