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

Error Importing Mysql Database Dump

forums › forums › SQLyog › Using SQLyog › Error Importing Mysql Database Dump

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 9, 2015 at 12:36 pm #35208
      peterlaursen
      Participant

      The dump does not have the statement “SET FOREIGN_KEY_CHECKS = 0;” on top. It should have if you are using Foreign Keys in the database. There is no way to ensure that ‘parent’ tables are written to the dump file before ‘child’ tables. 

       

      Refer MySQL documentation http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_foreign_key_checks ” Disabling foreign key checking can be useful for reloading such tables in an order different from that required by their parent/child relationships”. 

       

      SQLyog does write “SET FOREIGN_KEY_CHECKS = 0;” on top as default? Did you use SQLyog to create the dump? If so, did you uncheck this? 

    • March 25, 2015 at 8:36 am #35209
      lucatoni
      Member

      wow!

      Thank you so so much.

      It worked. I am using sqlyog and the “SET FOREIGN_KEY_CHECKS = 0;” was not checked.

      Thanks

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.