Question

Locked

SQLyog -SQL Dump Import Error

By ft85 ·
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

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Not without seeing what's in sqlyog.err

by Tony Hopkinson In reply to SQLyog -SQL Dump Import E ...
Collapse -

SQLyog -SQL Dump Import Error

by chirantan_skc In reply to SQLyog -SQL Dump Import E ...

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.

Collapse -

Reponse To Answer

by ft85 In reply to SQLyog -SQL Dump Import E ...

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.

Collapse -

Solution

by chirantan_skc In reply to SQLyog -SQL Dump Import E ...

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

Collapse -

Reponse To Answer

by ft85 In reply to Solution

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

Collapse -

SQLyog Enterprise gui 7.15 gui -SQL Dump Import Error

by thuctidvn In reply to SQLyog -SQL Dump Import E ...

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

Collapse -

SQLyog Enterprise gui 7.15 gui -SQL Dump Import Error

by thuctidvn In reply to SQLyog -SQL Dump Import E ...

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

Back to Web Development Forum
8 total posts (Page 1 of 1)  

Software Forums