Re: Import/Export error

[Massimiliano A]

Thank you Jay, it helped.
I made the backup using mysqldump with the appropriate options, in this way:
mysqldump -uroot -p --opt --triggers --R --databases mydb > mydb.sql
and I got all stored procedures and triggers in the dump .

The strange thing, however, is that in the backup script all the tables are listed in alphabetic order, and if there are dependencies between them (FK) the restore will probably put out an error because a linked table was not yet created during the restore.

Best Regards
massimiliano