transfer InnoDb in correct order ??

[Eddie Post]

Hellu,

I want to transfer the structure of my InnoDb database to another mysql
server 3.23.
However, I don't seem to get this to work correctly as the tables are not
transfered in the correct order such that I get a bunch a foreign key
constraints.
Even if I use the MysqlPhp admin tool, Mysql Manager, SqlYog, it doesn't
work: they make an export of the db structure but the db structure, that
consists of create table statements, isn't in the correct order, such that
when I use the export script to make the new database somewhere else, the
tables can't be created because of foreign key constraints.

How can solve this, without putting the create statements in the correct
order manually ? Isn't there a handy tool that first checks if other tables
should be created, and if so, it does this, before adding the table itself
??

Please some help, because ordering it manually isn't an option at this
moment with so periodically transfers and so many tables :(

Eddie

_______________ _______________ _______________ _______________ _____
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw