Unable to restore a backuped version (foreign key errors)

See CSP-2113 for an history of the issue on your support system.

We just started using confluence in production and I had once an annoying message regarding foreign key errors:

2005-12-28 17:45:55,735 ERROR [hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: alter table os_user_group add constraint FK932472461E2E76DB foreign key (group_id) references os_group (id)
2005-12-28 17:45:55,735 ERROR [hibernate.tool.hbm2ddl.SchemaExport] General error message from server: "Can't create table '.\conf#sql-a30_a.frm' (errno: 150)"
[...] others (see attachment)

I was using mysql 4.0 so I thought it was a DB problem. I have just installed 4.1.16 and created a few pages (20 with 2 attachments). I did not have any foreign key errors this time. I then backuped, cleaned everything and tried to restor from backup and I still have those foreing key errors.

It means that I cannot use confluence in production at the moment because I will be unable to restore from it if I have any problem.