Jump to content

At what point do I upload the SQL database?


Connor Hawke

Recommended Posts

It's been a long time and I'm a little rusty...

I have a database backup of a community I used to run and want to reopen on IPB 4 by upgrading from 3. I have uploaded the IPS files of the app versions matching the database backup.

Now, do I install the suite first (after creating an empty database), or do I first upload the database backup and install afterwards? I tried the former first and got some weird error which I don't recall ever seeing before.

Link to comment
Share on other sites

Okay, I tried uploading the database first (using bigdump), but on installation I wasn't allowed to 'integrate' it so I chose to overwrite it. Again got an error:

'Unknown column 'field_9' in 'field list'' (sql error code 1054)

Happened with mySQL query error: INSERT INTO ibf_ccs_custom_database_1

 

Link to comment
Share on other sites

4 minutes ago, Rhett said:

You would need the file system too along with the database for a complete and proper upgrade (in the least the uploads folder) , do you have a full backup of the site or just the database?

Yeah. I uploaded the latest full backup I had, then uploaded files for newer versions so that they matched up with the versions in the database backup. More info here: https://invisionpower.com/forums/topic/429799-okay-to-import-ipb-3-sql-database-to-ipb-4/

So seems like it should be working but I got the error above.

Link to comment
Share on other sites

You just need to upload your IPB 3 files and the backup database you created with those IPB 3 files.

Make sure everything is working on IPB 3 board

If it is then upload the IPB 4 files and run upgrade (your_board_url/admin/upgrade)

You then follow instructions

Would first suggest you run the requirements checker to make sure you are able to run IPB 4

More info here or here

Link to comment
Share on other sites

8 hours ago, steve00 said:

You just need to upload your IPB 3 files and the backup database you created with those IPB 3 files.

Make sure everything is working on IPB 3 board

If it is then upload the IPB 4 files and run upgrade (your_board_url/admin/upgrade)

You then follow instructions

Would first suggest you run the requirements checker to make sure you are able to run IPB 4

More info here or here

yeah, got a little confused before because the board index wasnt appearing after i uploaded the database backup, but eventually i found that the admin cp worked and some modified settings just need to be tweaked to get the board index showing

as for the errors that were appearing before, i might be wrong but i think those were showing up if i retried an upload before dropping all existing tables

in any case i got there in the end and its now on ipb 4

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...