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