convert 1.1.1x to 2.0 RC4 without upgrade files

[merlin_nl]

Hi All,

I have a running 1.1.11 SMF on www . luipaardgekkoforum . nl and would like to testmigrate to test . luipaardgekkoforum . nl to test the migration of SMF 1.1.11 -> 2.0 RC4.
This because we have several mods and theme options on the old forum that needs to be tested with the RC4 before going live.

I installed SMF 2.0 RC4 in a seperate vhost, created a 2nd MySQL db and am looking into how to migrate/copy the current userinfo/posts.

Anyone has some hints ?

Thx in advance

[Oldiesmann]

You can easily copy the tables from one database to another in phpMyAdmin...

Go into phpMyAdmin and select the database that your current SMF forum is using.
In the main window, click on the "export" tab
Enter the name of the database you want to copy it to in the "copy to database" textbox
Check the box next to "Add DROP TABLE / DROP VIEW" so it will drop the existing tables first and leave the other options alone
Click the "Go" button

You can then perform the upgrade on the test site to test things out, but you will still need to reinstall any mods and extra themes after the upgrade.

[LoneWolf]

I was planning to do much the same. Out of curiosity are the table structures much different? It is not possible to use the old database by merely pointing to it? No fields dropped?

[Dzonny]

Hello there.

There is many differences between 1.1.x and 2.0x vesions in database structures, so its impossible to run 2.0 version wit 1.1.x database. You must perform upgrade to get it working.

Regards.

[LoneWolf]

Well, I'll go with a full install in parallel and insert the current table data after I've done a comparison so as to not have the SQL error of non-existent fields and the work that needs to be done to get past that... which was my main concern. Thanks.