need your help guys!

[shaife]

Hi all of you,
I have created a database, all tables engine=innodb
Show tables:

table1
table2
table3
table4

sql orders my tables from a - z
In table 2 is my primary key, its 1:n and all other tables only have foreign keys. On dumping, table1 is on the top => one of the foreign key tables table2, the prime key table, is 2nd.

On restoring the backup on my server, he can't create table1 may be because there is no primary key table. So i have to copy paste my backup.sql, change table 2 to the top and all is working fine. Inserting table1 manually, tried to insert table 2 after table1.
Means the only way to restore my backup is to change my backup.sql?
Can some one here solve my problem?
Thank you. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[domin]

Try disabling the foreign key checks: set foreign_key_check=0 or something like that. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --