#11 Save table with foreign keys in wrong order

closed-accepted
nobody
None
7
2005-04-14
2005-03-31
Jérôme Couderc
No

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

Discussion

  • The initial file

     
    Attachments
  • Dirk
    Dirk
    2005-04-07

    Logged In: YES
    user_id=1047659

    You're right this is a bug! Try to fix it in next release!

     
  • Dirk
    Dirk
    2005-04-07

    • priority: 5 --> 7
    • status: open --> open-accepted
     
  • Dirk
    Dirk
    2005-04-14

    • status: open-accepted --> closed-accepted