for the problem importing the IPB backup, if you add the line
Code:
drop table if exists table_name;
just before each create table call, then your ddl code will run and the table will be re-created and re-populated.
I doubt this will solve your problem however. Most likely between versions the database design changed and your old database is out of date. Also most likely the IPB should have the tools needed to update the database. So, if you can, get your hands on whatever IPB uses to migrate old databases to the new format.
Next, alter the IPB generated script as i suggested above and get that database up and loaded with all your data.
Finally, run the IPB tool to migrate your database to the new format.
If IPB won't give you the tools to migrate the db, you would have to write your own.