How to export if I have foreign keys?

[mehtarenu]

hi,

i want to take a backup of my mysql database from one server to another server and import it on the other new server. But as my original database table have a lot of foreign keys and constraints defined in them if I simply take a dump and then try to create a database from it then it fails beecause the dump does not create and insert the data in the proper sequence based on references? Is there any way that I can maintain the proper sequence of table creations and inserts?

Thanks.