Uploading Invisionfree Database Dump

[Goss]

I just got my database dump from invisionfree and am trying to get it uploaded so I can start the conversion process.

The instructions I got from IF were as follows:

Be sure you have a freshly installed IPB (v1.3.x) with the default mysql table prefix (ibf_).
Next empty the following tables on the fresh install (again make sure the install is using the prefix ibf_):
ibf_badwords
ibf_posts
ibf_calendar_events
ibf_categories
ibf_contacts
ibf_emoticons
ibf_forums
ibf_groups
ibf_members
ibf_messages
ibf_moderators
ibf_polls
ibf_stats
ibf_titles
ibf_topics
ibf_tracker
ibf_voters
ibf_cache_store
ibf_forum_perms
ibf_topic_mmod
ibf_validating;

or you can use these queries:

         

    DELETE FROM ibf_badwords;
    DELETE FROM ibf_posts;
    DELETE FROM ibf_calendar_events;
    DELETE FROM ibf_categories;
    DELETE FROM ibf_contacts;
    DELETE FROM ibf_emoticons;
    DELETE FROM ibf_forums;
    DELETE FROM ibf_groups;
    DELETE FROM ibf_members;
    DELETE FROM ibf_messages;
    DELETE FROM ibf_moderators;
    DELETE FROM ibf_polls;
    DELETE FROM ibf_stats;
    DELETE FROM ibf_titles;
    DELETE FROM ibf_topics;
    DELETE FROM ibf_tracker;
    DELETE FROM ibf_voters;
    DELETE FROM ibf_cache_store;
    DELETE FROM ibf_forum_perms;
    DELETE FROM ibf_topic_mmod;
    DELETE FROM ibf_validating;




Then run the queries in the file you downloaded. See http://dev.mysql.com/doc/mysql/en/batch-commands.html

In another post, someone said I did not need an install of ipb and gave me a file that I could upload instead that the conversion would use.  Now, I just created a new, empty database and tried to upload the sql into that, but I'm getting the following error:

ERROR 1146 (42S02) at Line 1: Table 'ipbmarked.ibf_posts' doesn't exist

Is there some database structure I need to add first and how do I go about doing this?

I'm feeling a bit lost at the moment.  XD

[Goss]

Ok, so it seems like I need an existing database in ipb 1.3 format.  I downloaded and tried to install ipb 1.3 on my server, but the installation doesn't work (it's apparently not compatible with newer technology?)

Is there anyone who can get me a database export in the smf 1.3 structure?  I'm really not sure what else to do at this point.  I did find a link to a supposed download here on the IPB forums, but after registration at both forums I still get an access denied message.  :/

[Goss]

Okay, so I managed to successfully install IPB 1.3 on a different server and then exported that database and uploaded it to my own server.  I ran the queries on that database above and then tried to import my backup database from my invisionfree forum. 

It went fine until I got the following error:

ERROR 1054 (42S22) at line 16948: Unknown column 'last_post' in 'field list'

[Norv]

Are you sure it was the same version of IPB, as the backup file was made from...?

Is there any possibility you could have the full backup of your former IPB forum, a backup which would contain structure as well?

[Goss]

I realized I had a version of IPB 1.3.1 Final.  Switched and installed IPB 1.3 Final instead, which is what is used with Invisionfree (according to the credit at the bottom, at least).  I tried the database queries again though, but I'm getting the same error.

And I'm afraid I can't really get a structured backup.  I'm not sure why I can't, but that's just not how Invisionfree does it.

I'd be happy to give a link to my raw database file if someone thinks they can figure this out?

[Norv]

We can try, sure.

Please, feel free to PM me on this, if you wish.

[Goss]

PM sent.  Thank you.  ^_^