Bug #19659 mysqldump not dumping tables in order with innodb

• Submitted: 10 May 2006 1:30
• Modified: 10 May 2006 2:07
• Reporter: Morgan Tocker
• Status: Duplicate
• Category: MySQL Server: Backup
• Severity: S4 (Feature request)
• Version: 4.1.18
• CPU Architecture: Any

[10 May 2006 1:30] Morgan Tocker

Description:
morgo@morguntu:~$ mysql test;

mysql> select version();
+---------------------+
| version()           |
+---------------------+
| 4.1.18-standard-log |
+---------------------+

mysql> show tables;
Empty set (0.00 sec)

mysql> create table t2 (id int);
mysql> create table t1 (id int);
mysql> create table t3 (id int);
mysql> exit;

morgo@morguntu:~$ mysqldump test t3 t2 t1
(shows dump in order t3, t2, t1 - correct)

morgo@morguntu:~$ mysqldump test t1 t2 t3
(shows dump in order t1, t2, t3 - correct)

mysql> alter table t1 engine=innodb;
mysql> alter table t2 engine=innodb;
mysql> alter table t3 engine=innodb;

morgo@morguntu:~$ mysqldump test t3 t2 t1
(shows dump in order t3, t2, t1 - correct)

morgo@morguntu:~$ mysqldump test t1 t2 t3
(shows dump in order t3, t2, t1 - incorrect)

How to repeat:
Testcase provided.

[10 May 2006 1:39] Morgan Tocker

Eek. Duplicate of BUG# 18536