Menu

#494 (ok 3.3.1) don't export data of merge table

closed-accepted
1
2010-03-16
2010-03-01
No

patch for bug #2960816 : merged tables not exported correctly

When exporting a server/database/table, data of a table of type MRG_myISAM is not exported, only the structure is exported.

Discussion

  • Marc Delisle

    Marc Delisle - 2010-03-02
    • assigned_to: nobody --> lem9
     
  • Dieter Adriaenssens

    patch (rev. 2)

     
  • Dieter Adriaenssens

    The new patch :
    - disables the 'dump # rows' and 'dump all rows' options on the export page
    - checks if the table is not a view before checking the Engine (views don't have an Engine parameter)

     
  • Marc Delisle

    Marc Delisle - 2010-03-03

    Hi,
    the patch applied cleanly to trunk. However, when testing with the sample MERGE table as explained on http://dev.mysql.com/doc/refman/5.1/en/merge-storage-engine.html and MySQL 5.1.40, the data of the MERGE table is still exported. Testing with on-screen export and with saving as file.

     
  • Dieter Adriaenssens

    patch (rev. 3)

     
  • Dieter Adriaenssens

    New patch (rev. 3) was tested against MySQL 5.1.31 and 5.0.45 and now exports no data (in case of a merge table) in both MySQL versions.
    Changes : The name of the merge table engine is changed in MySQL 5.1.x to MRG_MYISAM (is MRG_MyISAM until 5.0.x), patch (rev. 3) counters this.

     
  • Marc Delisle

    Marc Delisle - 2010-03-05

    Merged in subversion, thanks.

     
  • Marc Delisle

    Marc Delisle - 2010-03-05
    • priority: 5 --> 1
    • summary: don't export data of merge table --> (ok 3.3.1) don't export data of merge table
    • status: open --> open-accepted
     
  • Marc Delisle

    Marc Delisle - 2010-03-16
    • status: open-accepted --> closed-accepted
     
MongoDB Logo MongoDB