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/[EMAIL PROTECTED]
