Web Development

Ask something
Question Locked

SQLyog -SQL Dump Import Error

0 helpful
8 replies

by ft85

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi everyone

Please can somebody tell me what is wrong with my SQL yog?
everytime i am trying to restore sql dump i get this error message: There was an error while executing a query.
The query and the error message has been logged at:
C:\Users\Bitas\AppData\Roaming\SQLyog\sqlyog.err.
Please click on "Open Error File..." to open the error file.

any help ?

Thanks in Advance for your help

Best regards

8 replies

by chirantan_skc

Hello Bitas,
Please answer the following questions :

1) The exact error you get. (Check the SQLyog.err file)
2) SQLyog version and MySQL version (for MySQL Version, execute "SELECT VERSION();").
3) Was the dump created with SQLyog. If not then with what program and does the dump have a SET SQL_MODE and SET NAMES statement on top?
4) What is global SQL_mode setting on the server? (Execute "SELECT @@GLOBAL.sql_mode;" command)
4) Please provide a small sample dump where the error can be reproduced.

Please come to our Forums(http://www.webyog.com/forums) to discuss this or create a support ticket by sending details to support@webyog.com so that we can help with this.

by ft85

thanks very much for having find time to answer follow my post

in all the questions i just managed to get few answers
1) The exact error you get. (Check the SQLyog.err file)

R:Line no.:32 ,Error Code: 1153 - Got a packet bigger than 'max_allowed_packet' bytes
2) SQLyog version and MySQL version (for MySQL Version, execute "SELECT VERSION();").
R: SQLyog Entreprise GUI V 7.02 and MSQL 5.0.51a-24+lenny4-log
3) Was the dump created with SQLyog. If not then with what program and does the dump have a SET SQL_MODE and SET NAMES statement on top?
R:Yes dump is created with SQLyog
4) What is global SQL_mode setting on the server? (Execute "SELECT @@GLOBAL.sql_mode;" command)
R:this one i get empty result
4) Please provide a small sample dump where the error can be reproduced.

by chirantan_skc

Hello Bitas,

I guess, this is same as http://www.webyog.com/forums/index.php?showtopic=863.

This error comes when MySQL server receives a packet bigger than 'max_allowed_packet' size. By default, max_allowed_packet is 16MB.

Please try any of the following.
1) Create a dump file again, but this time, uncheck the "Create bulk INSERT statement(s)" option. Then restore that newly created dump..

OR

2) Open the file my.ini. You will find it in the MySQL installation folder.
Find "[mysqld]" phrase without double quotes, Add (max_allowed_packet=1024M) option without brackets.
Now Retart the MySQL Service and restore old dump(The dump which was giving error).

For more information about this error, please refer to http://dev.mysql.com/doc/refman/5.5/en/packet-too-large.html

by ft85

Thanks a million , i have uncheck the create bulk INSERT Statement options and it worked fine

by thuctidvn

Hi everyone
Please can somebody tell me what is wrong with SQLyog Enterprise 7.15 gui ?
I am trying to restore sql dump i get this error message
"copy file error " when it runs is 37%
I tried unsuccessfully to run again
I should expect people to help
Thanks in Advance for your help

by thuctidvn

Hi everyone
Please can somebody tell me what is wrong with SQLyog Enterprise 7.15 gui ?
I am trying to restore sql dump i get this error message
"copy file error " when it runs is 37%
I tried unsuccessfully to run again
I should expect people to help
Thanks in Advance for your help

This discussion is closed to new replies.