dbutil restore from backup problem (order of tables)

[eluser]Jaffer Haider[/eluser]
Hey guys,

I'm using the internal dbutil ($this->load->dbutil()) to backup a database. Backup works fine, but when I run the .sql file to restore the database, I run into a problem because the tables are sorted alphabetically, and not by their foreign key constraints.

I've used phpMyAdmin's import feature, as well as simply pasting in the SQL script into the SQL tab of phpMyAdmin (after creating an empty database).

I don't see any topic in the forum related to this. Hasn't anyone run into this problem? What's a common workaround for this?

Thanks!