Migrating from 2.0.17 to new host with 3.2.4

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
User avatar
warmweer
Registered User
Posts: 1476
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by warmweer » Thu Dec 06, 2018 4:01 pm

odsw wrote:
Thu Dec 06, 2018 3:44 pm
There is no option to update the database:
http://www.bilddump.se/bilder/201812061 ... 64.100.JPG
OK, I'm not sure about the app.php (in 3.1) (it is in 3.2)
In 3.1 I think it's /install/database_update.php
A bug is a feature that hasn't made it to the manual (yet)

User avatar
warmweer
Registered User
Posts: 1476
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by warmweer » Thu Dec 06, 2018 4:16 pm

janus_zonstraal wrote:
Thu Dec 06, 2018 3:22 pm
I've copied the folder containing the database and I can browse it in phpMyAdmin on the new server.
A database is a file not a container?

And if you see your database in phpmyadmin are the tables there?
Screen print maybe?
A database is a set of files.
in MYSQL there's either MyISAM and then each table has 3 files, or InnoDB and then each table has 2 files (see printscreen).
An InnoDB directory should never be copied - it won't work - InnoDBs have to be exported/imported
A MyISAM directory can be copied to anywhere without losing structure.
dbfiles.gif
printscreen of tables in InnoDB
Clipboard25.gif
printscreen of tables in MyISAM
Clipboard25.gif (2.89 KiB) Viewed 136 times
Last edited by warmweer on Fri Dec 07, 2018 8:12 am, edited 1 time in total.
A bug is a feature that hasn't made it to the manual (yet)

odsw
Registered User
Posts: 13
Joined: Mon Dec 03, 2018 5:46 pm

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by odsw » Fri Dec 07, 2018 7:24 am

It seems like I hit a wall with this.
Is there any kind soul who would like to remote my server (teamviewer or similar) and have a look?

User avatar
warmweer
Registered User
Posts: 1476
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by warmweer » Fri Dec 07, 2018 8:23 am

odsw wrote:
Fri Dec 07, 2018 7:24 am
It seems like I hit a wall with this.
Is there any kind soul who would like to remote my server (teamviewer or similar) and have a look?
I can have a look at it if you can send me the dump you made of the 3.0 database. I can probably quickly see if it's upgradable and try to update to 3.2.4 and send it back.
PM me if necessary.
A bug is a feature that hasn't made it to the manual (yet)

User avatar
warmweer
Registered User
Posts: 1476
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by warmweer » Fri Dec 07, 2018 12:45 pm

Quick update.
The conversion from 2.0.17 to 3.0.0 (which I what I received) went well but odsw failed to upgrade further because of a mix of old and new tables (inexperience with editing the config table and the config.php to point to the correct tables). It also took me some time before I had identified the cause of the problem.
Upgrade to 3.0.14 went flawlessly, the next upgrade is postponed until after a needed lunchbreak 8-)

Added at 16:20

Update to 3.2.1 (through 3.1.12) went flawlessly.
I'm leaving the update to 3.2.4 for odsw to do (the experience will come in handy).
A bug is a feature that hasn't made it to the manual (yet)

User avatar
warmweer
Registered User
Posts: 1476
Joined: Fri Jul 04, 2003 6:34 am
Location: Van Allen Belt ... well actually Belgium

Re: Migrating from 2.0.17 to new host with 3.2.4

Post by warmweer » Tue Dec 11, 2018 11:15 am

And a last update.
odsw managed to update his board form 3.2.1 to 3.2.4.
My compliments to odsw for hanging on in there and his willingness to learn (e.g. installing an old version of Easyphp in order to upgrade from 2.0.17 to 3 on localhost).
A bug is a feature that hasn't made it to the manual (yet)

Post Reply

Return to “[3.2.x] Support Forum”

Who is online

Users browsing this forum: </Solidjeuh>, actane, fanmail, lopoto, panhead, Zanzazaar and 24 guests