Questions

SQLyog -SQL Dump Import Error

+
0 Votes
Locked

SQLyog -SQL Dump Import Error

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
  • +
    0 Votes
    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.

    +
    0 Votes
    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.

    +
    0 Votes
    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

    +
    0 Votes
    ft85

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

    +
    0 Votes
    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

    +
    0 Votes
    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

  • +
    0 Votes
    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.

    +
    0 Votes
    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.

    +
    0 Votes
    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

    +
    0 Votes
    ft85

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

    +
    0 Votes
    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

    +
    0 Votes
    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