HTML Logo by World Wide Web Consortium (www.w3.org). Click to learn more about our commitment to accessibility and standards.

Moving forward with Composr

ocPortal has been relaunched as Composr CMS, which is now in beta. ocPortal 9 will be superseded by Composr 10.

Head over to compo.sr for our new site, and to our migration roadmap. Existing ocPortal member accounts have been mirrored.


[RESOLVED!] Advance migration question

Login / Search

 [ Join | More ]
 Add topic 
Posted
Rating:
#93217 (In Topic #18646)
Avatar

Honoured member

Hi Everyone,

Being the fan of OCP that I am, one of the organizations I support is going to let me move our hosting service to a different provider (our current one sucks, trust me).

That being said, the current site is primarily HTML pages with links in and out of an SMF forum with an ADK portal front end.  My plan is to move the HTML pages over to the new provider as-is, but I'm going to change the entire back end of the site over to OCP.  Since I've never migrated users and posts between forums, I thought I would ask here in advance for any suggestions or guidance before I get started.

I think I've seen some discussion on this in the past, so if you want to point me to a prior thread, I'm ok with that as well.

Thanks!

Mark


Last edit: by superiorpyro
Back to the top
 
Posted
Rating:
#93226
Avatar

Community saint

Hi Mark,

Try referring to some of these. They aren't comprehensive, nor are they in any order, but I was involved in each of these hair-pulling episodes, and following the thread(s) might give you that 'lightbulb' moment.

 :thumbs:

Take my advice. I'm not using it!

View my working ocPortal site (version 9.x.x) at Anglo-Indian Portal
Back to the top
 
Posted
Rating:
#93253
Avatar

Community saint

I switched my SMF 1.x forum to ocP 7.x (at that time) and everything went smooth. Of course I made several test migrations to flush out any glitches.

I believe I read somewhere what host you're using now and if it was the same as the one I had before, I will agree they totally suck. I stayed only 4 months with them.

After I found a new host and once I set up ocP on the new host I changed the old ocP to use the database on the new host. This allowed me to not have any interruptions while DNS propagated. It was a little dicey doing it this way, but it worked for me on a slower forum. I don't know how well it would work on a busy forum.

Steve
Back to the top
 
Posted
Rating:
#93282
Avatar

Honoured member

Fletch and Steve,

Thanks for the info.  I'll probably start the migration in the next week or so, so I'll keep this thread open and post updates if it goes well, or issues that could potentially benefit others.

Cheers!

Mark

PS:  In this case Steve, the existing SMF forum is 2.02 and will be migrating to OCP 9.0.3
Back to the top
 
Posted
Rating:
#93284
Avatar

Community saint

superiorpyro said

Fletch and Steve,

Thanks for the info.  I'll probably start the migration in the next week or so, so I'll keep this thread open and post updates if it goes well, or issues that could potentially benefit others.

Cheers!

Mark

PS:  In this case Steve, the existing SMF forum is 2.02 and will be migrating to OCP 9.0.3

I hope your migration goes as smoothly as mine did. I think Duck built (or updated) the SMF v2 migration tool so he would be the one to ask if you run into glitches during the migration.

Steve
Back to the top
 
Posted
Rating:
#93336
Avatar

Community saint

So far all reports i have had of the migration using SMF2 importer I worked  on have been good. Everythings been pretty smooth for most so I have no extra advice that might be benificial pre-import other than it is always good to make back-ups of existing files and databases first of course but what might be also good to do is to backup the ocPortal database after you've installed and set-up but before import. This way if something doesn't go well with the import you can just reset (so to speak) if need be.

Also note if you have large database (and/or lots of user files) it is definitely a good idea to set a high timeout period during import.
Back to the top
 
Posted
Rating:
#93343
Avatar

Honoured member

Ok, first attempt -- no luck, but I know it's related to my own inexperience with the import process.  Here's what I've done:

I have a copy of my SMF Db "xxx_smf.sql", went into OCP tools menu and selected import.
Chose the SMF 2.0.x importer
Created a new import session and deleted any old sessions
Left the base directory as OCP filled in the field and changed the refresh time to 30 seconds
Clicked proceed and get this message:



I have tried changing the import path to my rootdirectory/old with no luck and even searched for the settings.php file and copied it in the same directory, but same error.

As I said, I know this is something simple that I'm missing having not done this before, so any guidance is greatly appreciated.

Cheers!

Mark
Back to the top
 
Posted
Rating:
#93346
Avatar

Community saint

It should be a file system path. Are you installing this on a live hosted site or locally?

Typically on the hosted site your path would look something like this:

MYHOSTEDSITENAME/public_html
or
MYHOSTEDSITENAME/public_html/OLDROOTDIRICTORYOFSMF
(or www instead of public_html)

locally it might look like this:

C:\SERVERSOFTWAREDIRECTORY\www\smf
Back to the top
 
Posted
Rating:
#93358
Avatar

Honoured member

Thanks Duck.

The server that's hosting the site isn't a local machine, so I can't point to a directory on the host directly.

I think I've identified another part of the issue as well in that, based on your description, I believe you are assuming that the new implementation of OCP is also going on the same server that is currently hosting the SMF instance, and that's not the case.

In this case, the SMF instance is on a server hosted by company "ABC" where the OCP instance is on a completely different server, hosted by a completely different company, "XYZ".

So when I use the parameters you have listed below, the import script on the server at XYZ is not going to have access to the SMF directory at ABC  (I would have to make that directory publicly viewable and obviously that's not a good idea).

Have you or anyone else ever done an import between instances that are hosted by two completely independent companies?  Or, if I've really confused myself and am missing something obvious, could you please point me in the right direction!

Thanks!

Mark
Back to the top
 
Posted
Item has a rating of 5 (Liked by sholzy)  
Rating:
#93377
Avatar

Community saint

I think what might work best for you is to set up both locally and do the upgrade from there then just upload the finished product when done. Probably less headache that way. There is a tutorial here on how to clone a site.

View topic: How to clone your ocPortal site - ocPortal.com

Back to the top
 
Posted
Rating:
#93382
Avatar

Honoured member

I've got the time and I have nothing to lose, so I'll give it a try.  Thank you!!
Back to the top
 
Posted
Item has a rating of 5 (Liked by sholzy)  
Rating:
#93659
Avatar

Honoured member

Ok, time to follow up on this one:  First things first - a BIG thank you to Duck for the SMF 2.0 importer, and for all the support in making this an option within OCPortal.  Here are some lessons learned that others might benefit from:

Due to my situation (read above), I followed Ducks advice and moved the entire SMF instance from remote hosting server #1 to my new remote hosting server #2.  Note: depending on how complex your old SMF site is, the directory can be quite large, and you may be forced to use an FTP client to upload it to your new hosted server (again, be sure if you're doing it from work that port 21 is opened or you wont have any luck!).  Also please understand:  Simply copying the SMF directory is not sufficient, you are also going to have to back up and move your MySQL database to the new server.

Once you move the .sql file, it has to be imported into a new database, if you're not familiar, then you should spend some time working with PHPMyAdmin and practice!  It bears noting that most Cpanel based hosting services predefine the prefix of all the MySQL databases that you create, so if you are going to import it into a new one on a new hosted server, the new database is going to have a different prefix than the old one.  Here is an example of what I'm referring to:

youroldclub_smf    ---   This example can represent the "old" database that is currently in use by SMF

thenewclub_smf    ---  This represents the new DB created on the new server (data will be imported into this DB)

The import process is actually very simple and straightforward, and most shouldn't have any issues with this step. 

Before the import function can be executed from within your OCPortal site under the tools menu, you will have to locate the "settings.php" file within the SMF directory that you copied from the old server to your new one.  Within that file, the name of the database will need to be changed from the old one to the new one that you imported the data into.  Also, the DB user name and DB password need to be updated in the settings.php file.

I realize that my situation isn't unique and that as more people adopt OCPortal as their solution, they may also be facing the need to import or migrate data from other MySQL based applications, as well as from one hosting service to another as I did.  Hopefully this will help someone out down the road.

Cheers, and thanks again Duck!

Mark
Back to the top
 
Posted
Rating:
#93660
Avatar

Community saint

Thanks for sharing and I am glad everything worked out for you!
Back to the top
 
1 guests and 0 members have just viewed this: None
Control functions:

Quick reply   Contract

Your name:
Your message: