Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Panic! Sqlyog Crashes In The Middle Of An Sql File Upload

forums › forums › SQLyog › Using SQLyog › Panic! Sqlyog Crashes In The Middle Of An Sql File Upload

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • March 9, 2011 at 1:46 pm #12270
      Larry Woods
      Member

      I am using 8.82 and am using SQLyogTunnel.php dated 1/12/2011 (46K) that is included in the install of 8.82. I need to upload 10 different SQL dumps into a database. I have been able to upload most of them but when I get to a particular one SQLYog executes the queries for the first 60 records and then stops, with the following error:

      Error occured at:2011-03-09 06:26:08

      Error Code: 3 – SQLyog tunneling file version mismatch or PHP Error.

      Please upload the latest SQLyogTunnel.php from the installation folder of SQLyog.

      It also dumps a record in the log. I copy/pasted this record into SQLYog and executed it manually and it loaded just fine!

      Also, I have run this sql file twice and it stops at the same record.

      HELP!

    • March 9, 2011 at 2:25 pm #32003
      Larry Woods
      Member

      More information that is VERY strange.

      I created a new SQL dump that includes all of the INSERTS up to, and including the INSERT where SQLYog stops. There are 94 INSERTS. BUT when I execute the SQL dump it stops with an error after loading 60 records, but with the 94th record being displayed as the one in error. So, I remove the last record (INSERT # 94) in the SQL dump and upload it again. No problems!!! I loads 93 records correctly. Something is very confusing. Error after loading 60 records IF the 94th record is included in the file. Remove the 94th INSERT and 93 records get loaded.

      'Larry wrote:

      I am using 8.82 and am using SQLyogTunnel.php dated 1/12/2011 (46K) that is included in the install of 8.82. I need to upload 10 different SQL dumps into a database. I have been able to upload most of them but when I get to a particular one SQLYog executes the queries for the first 60 records and then stops, with the following error:

      Error occured at:2011-03-09 06:26:08

      Error Code: 3 – SQLyog tunneling file version mismatch or PHP Error.

      Please upload the latest SQLyogTunnel.php from the installation folder of SQLyog.

      It also dumps a record in the log. I copy/pasted this record into SQLYog and executed it manually and it loaded just fine!

      Also, I have run this sql file twice and it stops at the same record.

      HELP!

    • March 9, 2011 at 2:38 pm #32004
      peterlaursen
      Participant

      You have created a ticket too and I replied there.

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.