 |
InHouse
User
Apr 22, 2008, 5:58 AM
Post #1 of 6
(913 views)
Shortcut
|
|
Moving to Production Server
|
Can't Post
|
|
We will soon be moving our CMSB site from our sandbox server to the production one. Are there any recommended suggestions or known 'gotchas' that we need to address?
The one thing I'm concerned about is that the development site was in a sub-directory under the public_html folder. The production server will have the site posted at the public level. This means that all the internal references to images, uploads, internal links, etc. need to be updated. Sounds like several hours of SQL scrubbing. Any suggestions about this process?
Jayme
|
|
| |
|
Dave
Staff
/ Moderator
Apr 22, 2008, 9:19 AM
Post #2 of 6
(908 views)
Shortcut
|
|
Re: [InHouse] Moving to Production Server
[In reply to]
|
Can't Post
|
|
You'll need to copy this data over:
- MySQL data (use phpMyAdmin, etc)
- /data/ folder (with schema files and settings)
- /uploads/ folder
- viewer files
Then you'll need to update these settings:
- Admin > General > Upload Dir
- Admin > General > Upload Url
- Any custom upload dirs in the field editor (if you've used those)
- The require_once "" path in any viewers (you can get this from the code generator on the live server or use a relative path that will be the same on both servers).
Finally, all the image paths are relative from the root of the website, but if that path has changed you'll have to either put the new the uploads folder in the same place as the staging server and/or update the values in the section and upload tables.
I think we could do a few MySQL UPDATE statements with the MySQL replace function to replace all the old paths with new ones. Let me know if I can provide some help with that.
We hadn't anticipated staging and production servers having different web paths, but it's come up a couple times now, so perhaps there's some kind of automated solution we can add to make updating that easier...
Let's go through this process, figure out anything else that's missing and I can create a doc page for it for future.
Hope that helps.
Dave Edis - Senior Developer
interactivetools.com
|
|
| |
|
InHouse
User
Apr 22, 2008, 10:16 AM
Post #3 of 6
(906 views)
Shortcut
|
|
Re: [Dave] Moving to Production Server
[In reply to]
|
Can't Post
|
|
Thanks Dave. Great info as usual. Nothing you've said comes as a surpise so that's really good news.
I'd be happy to have you keeping an eye on me during this process. Will be in touch regarding this.
Cheers,
J.
|
|
| |
|
blukabm
User
Aug 28, 2008, 6:43 AM
Post #4 of 6
(739 views)
Shortcut
|
|
Re: [Dave] Moving to Production Server
[In reply to]
|
Can't Post
|
|
Dave, we are about to move Stage site to the production site at a customer's on-site server. I was wondering if there is more that you came up with after this post.
So what I understand, we do not have to run the installation again? By copying over ALL files of the cmsAdmin which includes:
- /data/ folder (with schema files and settings)
- /uploads/ folder
- viewer files
And updating the URLS:
- Admin > General > Upload Dir
- Admin > General > Upload Url
We should be in good shape?
We only have dummy content in the MySQL, so do we need to still copy over? OR is the CMSAdmin going to look for the tables and cells that have been set up already, and regardless we should copy it over too. If so, it sounds like we are going to run into path issues.
HELP!
-Troy
|
|
| |
|
Dave
Staff
/ Moderator
Aug 28, 2008, 8:35 AM
Post #5 of 6
(731 views)
Shortcut
|
|
Re: [blukabm] Moving to Production Server
[In reply to]
|
Can't Post
|
|
Hi Troy,
I'd start with a clean install - this will create a user account for you to login with. Otherwise you'll need to move over your user accounts database.
Then upload your /data/schema/ folder which has all your section settings.
The click on Admin > Section Editors and CMS Builder will generate any database tables or fields that don't exist already.
Then upload your viewers. Note that the "require_once ..." line in the viewers might need to be changed. You can get the correct filepath for this from: Admin > Code Generator
And that should do it.
Hope that helps, let me know if you need anything else or if you run into any problems.
Dave Edis - Senior Developer
interactivetools.com
|
|
| |
|
cmsweb
Novice
Aug 28, 2008, 12:44 PM
Post #6 of 6
(719 views)
Shortcut
|
|
Re: [Dave] Moving to Production Server
[In reply to]
|
Can't Post
|
|
Glad I read this post. We're in the same boat with 2 new sites in production server that we'll need to move to a different location. Didn't realize the uploads were being referenced the way they are so we'll need to clean up the records before we migrate.
|
|
| |
|
