Bug #30373 mysql_convert_table_format random fixes
Submitted: 11 Aug 2007 16:55 Modified: 5 May 2009 16:35
Reporter: Tobias Asplund Email Updates:
Status: Patch approved Impact on me:
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:5.0.45 OS:Any
Assigned to: CPU Architecture:Any
Tags: Contribution

[11 Aug 2007 16:55] Tobias Asplund
This patch modifies the mysql_convert_table_format perl script in a few ways.

1. It fixes the bug below ( http://bugs.mysql.com/bug.php?id=27150 )
2. It allows you to specify multiple entries for table in the format
mysql_convert_table_format db table1 table2 table3
3. It also accepts wildcards in the place of tables
mysql_convert_table_format db t% s%
4. It complained on HEAP saying it'd destroy data, now also complains on using MEMORY as the engine name ( http://bugs.mysql.com/bug.php?id=27149 )
5. Added short options to conform more with normal mysql command line tools.
   When an option existed in mysql I added the same, all except --engine existed
   there. the --engine took its -e from mysqlslap which is the only other one I
   found with this option. (also http://bugs.mysql.com/bug.php?id=27150 )
6. It now also continues to run even if it fails to match one of the table patterns when multiple patterns are supplied if the --force flag is set.

How to repeat:
flupps@piglet:~$ mysql_convert_table_format --help
  Converts tables to the given table type (Default: MYISAM)
  MySQL 3.23 supports at least the BDB, ISAM and MYISAM types.

flupps@piglet:~$ mysql_convert_table_format --ENGINE=InnoDB world
Unknown option: engine
[11 Aug 2007 18:09] MySQL Verification Team
Thank you for the bug report.
[27 Aug 2007 18:48] Brian Aker
+if (uc($opt_type) eq "HEAP" || uc($opt_type) eq "MEMORY" )

Should be expanded to handle "blackhole" as well.
[28 Apr 2009 18:49] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:


2884 Jim Winstead	2009-04-28
      Add support for wildcards in mysql_convert_table_format, and add
      short options for all of the long options. (Bug #30373, original
      contribution by Tobias Asplund)
[28 May 2009 8:19] Bugs System
Pushed into 5.1.36 (revid:joro@sun.com-20090528073639-yohsb4q1jzg7ycws) (version source revid:mats@sun.com-20090511132802-nnkiyb2huih1tklz) (merge vers: 5.1.35) (pib:6)
[17 Jun 2009 19:25] Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090616183122-chjzbaa30qopdra9) (version source revid:jimw@mysql.com-20090505173706-9ze3q4qzngw8kt2b) (merge vers: 6.0.12-alpha) (pib:11)
[26 Aug 2009 13:46] Bugs System
Pushed into 5.1.37-ndb-7.0.8 (revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)
[26 Aug 2009 13:46] Bugs System
Pushed into 5.1.37-ndb-6.3.27 (revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (version source revid:jonas@mysql.com-20090826105955-bkj027t47gfbamnc) (merge vers: 5.1.37-ndb-6.3.27) (pib:11)
[26 Aug 2009 13:48] Bugs System
Pushed into 5.1.37-ndb-6.2.19 (revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (version source revid:jonas@mysql.com-20090825194404-37rtosk049t9koc4) (merge vers: 5.1.37-ndb-6.2.19) (pib:11)
[27 Aug 2009 16:33] Bugs System
Pushed into 5.1.35-ndb-7.1.0 (revid:magnus.blaudd@sun.com-20090827163030-6o3kk6r2oua159hr) (version source revid:jonas@mysql.com-20090826132541-yablppc59e3yb54l) (merge vers: 5.1.37-ndb-7.0.8) (pib:11)