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

BUG – Copy InnoDB db/tables

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › BUG – Copy InnoDB db/tables

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 23, 2003 at 5:07 pm #8177
      mark2300
      Member

      BUG:

      If you attempt to “Copy Database to Different Host/DB…” from a database containing InnoDB tables with foreign key constraints, SQLyog will copy the tables from the source database in alphabetical order. This can lead to foreign key constraint problems, as foreign keys may refer to tables that have not yet been created.

      FIX:

      SQLyog should issue a SET FOREIGN_KEY_CHECKS=0 before copying the tables.

      From the MySQL documentation:

      Quote:
      If you want to ignore foreign key constraints during, for example for a LOAD DATA operation, you can do SET FOREIGN_KEY_CHECKS=0.
    • September 23, 2003 at 5:45 pm #14949
      Ritesh
      Member

      Thanks for the info 😀

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