When I dump a MySQL db data to a .sql file from phpmyadmin and try to restore to the loca version of the db on my machine i get the following error;
Error Code 1452. Cannot add or update child row. a foreign key constraint fails.
Now I assume this is because it is trying to insert the data out of sequence (for example trying to insert a relationship table such as userole before user table is populated??)
Is there a way of clmbatting this when we dump the data?