[debian-mysql] Bug#524439: mysqldump works incorrectly with innodb tables

[Dmitry E. Oboukhov]

Package: mysql-client-5.0
Version: 5.0.51a-21

My database has a few innodb tables like as:

 a_table
 b_table has constraint foreign to c_table
 c_table has constraint foreign to a_table
 d_table
 e_table
 ...

If I make sqldump, all these tables will be inserted into it in
alphabetic order. SQLdump would include the following instructions:

1. drop table a_table
2. create table a_table
3. drop table b_table
4. create table b_table
etc

If somebody try to restore database from such sqldump then hi will
derive the error on step 4: The c_table has not existsed yet, but
process creating b_table depends to c_table.

I think that a simple sorting sequence order of tables can resolve
this problem: if a table depends to the other table, it must
follow after the other tables.

--
... mpd paused: U.D.O. - Bad Luck

. ''`.                               Dmitry E. Oboukhov
: :’  :   email: unera at debian.org jabber://UNera@uvw.ru
`. `~’              GPGKey: 1024D / F8E26537 2006-11-21
  `- 1B23 D4F8 8EC0 D902 0555  E438 AB8C 00CF F8E2 6537
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20090417/271cadf3/attachment.pgp>