Save table with foreign keys in wrong order
phpMyBackupPro is the MySQL backup tool - especially without ssh!
Status: Abandoned
Brought to you by:
datz
Hi,
I've a database which uses foreign keys between tables.
When I save the database with phpMyBackupPro 1.4, I'm
unable to restore (import) correctly the database as
the order or the tables doesn't check foreign keys...
The tables seems to be ordered by ascending name
I get this error messages :
Can't create table '.\evol\concerne.frm' (errno: 150)
Can't create table '.\evol\lien.frm' (errno: 150)
Can't create table '.\evol\liste.frm' (errno: 150)
And says :"Successfully imported 19 tables and 0 rows"
But only 13 tables were created...
I've attached to .sql file for testing
The initial file
the backuped file
Logged In: YES
user_id=1047659
You're right this is a bug! Try to fix it in next release!