By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,246 Members | 1,480 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,246 IT Pros & Developers. It's quick & easy.

transfer InnoDb in correct order ??

P: n/a
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

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.