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: un...@debian.org jabber://un...@uvw.ru `. `~’ GPGKey: 1024D / F8E26537 2006-11-21 `- 1B23 D4F8 8EC0 D902 0555 E438 AB8C 00CF F8E2 6537
signature.asc
Description: Digital signature
