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

Merge Tables

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Merge Tables

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • September 9, 2009 at 9:06 am #11661
      L-W
      Member

      Copy to database… or backup/restore if a (or more) MRG_MyISAM table exists.

      If you want to copy “source” and “union” tables to another host where an old version exists (drop if exists checked) but not with the same structure, order is important, you must copy, in first, “source” tables, and after, the “union” table. It's the same thing for a backup/restore.

      Data… This type of tables dont have “real” data. It's uneeded to copy/dump records. You may have some troubles with this : if the merge table have a 'insert method' specified and not unique key in the underlying tables, the first (or last) table got all the rows from the union…

      Of course, you can do manually each step, but…

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