Menu

#11 Save table with foreign keys in wrong order

closed-accepted
nobody
None
7
2005-04-14
2005-03-31
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

  • Jérôme Couderc

    The initial file

     
  • Jérôme Couderc

    the backuped file

     
  • 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
     

Log in to post a comment.