Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Products: CMS Builder:
Uploading to remote server

 
 


Jeffncou
User

Dec 1, 2008, 1:05 PM

Post #1 of 5 (8391 views)
Shortcut
Uploading to remote server Can't Post
I have installed cmsbuilder on a local testing server. Everything is finished and I am ready to upload the site to the remote server.

Can someone help me to do this. I can upload the php files without any problems but I am not sure how to upload the database files.

I have created a database on my remote server with the same name as the one on my local testing server.

Is it simply a case of changing the settings in the admin panel so that the details of the remote server are used instead of the local one.

I am frightened to do anything without further advice because I don't want to mess anything up and lose all my hard work!


Dave
Staff / Moderator


Dec 1, 2008, 6:08 PM

Post #2 of 5 (8381 views)
Shortcut
Re: [Jeffie] Uploading to remote server [In reply to] Can't Post
Hi Jeff,

Do you have all the sections recreated on the remote server or not yet?

And have you entered a lot of data locally (records you created) that you need to move over or do you just need to move over the section setup?

And are you able to login to your remote install yet?

Let me know and I'll give you some suggestions.

Dave Edis - Senior Developer
interactivetools.com
 


Jeffncou
User

Dec 2, 2008, 2:41 AM

Post #3 of 5 (8365 views)
Shortcut
Re: [Dave] Uploading to remote server [In reply to] Can't Post
Hi Dave

I have created a database and named it with the same name as the database on my local server. I have done this using the control panel that comes with my hosting package.

I haven't created any sections on the database on the remote server.

I haven't installed cmsbuilder on the server either. Am I allowed to do that as I have already installed it once. (I assume the licence covers installation on two servers if they are ultimately only going to be used for one domain name)

I have entered a lot of data locally that I need to move over

Thanks
Jeff


Jeffncou
User

Dec 2, 2008, 8:57 AM

Post #4 of 5 (8354 views)
Shortcut
Re: [Dave] Uploading to remote server [In reply to] Can't Post
Hi Dave

Further to my last post in reply to your questions. I have now exported my local database and successfully imported it onto my remote server. I did this using phpMyAdmin.

I am still at a loss as to how I can get my php files on the remote server to 'talk' to the database.

When I go to the website www.brixhamcc.co.uk it is trying to find the files in the old location. I get the following message:

Warning: require_once(/Applications/MAMP/htdocs/brixhamcc/cmsAdmin/lib/viewer_functions.php) [function.require-once]: failed to open stream: No such file or directory in /home/jeffncou/public_html/brixhamcc/index.php on line 3

Fatal error: require_once() [function.require]: Failed opening required '/Applications/MAMP/htdocs/brixhamcc/cmsAdmin/lib/viewer_functions.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/jeffncou/public_html/brixhamcc/index.php on line 3


Dave
Staff / Moderator


Dec 2, 2008, 10:38 PM

Post #5 of 5 (8324 views)
Shortcut
Re: [Jeffie] Uploading to remote server [In reply to] Can't Post
Hi Jeff,

Yes you can do a second install. Having a "staging" or "development" install in addition to the live website is fine.

There's probably a few steps still to go through. There's a few ways to do it. You can do a fresh install on the live server, and then move over your databases and uploads. Sometimes that's simpler.

But from where you are now, update the database settings in Admin > General or by editing the file /data/settings.dat.php so you're connecting to the live server database instead of your development server.

Once that's done you'll need to update the require_once line in your viewer files because it looks like it's hard coded to use the path on your local development server.
If you know how you can even use relative paths for the require_once line so they will work in both locations without having to make changes.

Hope that helps, let me know when you get that far and if there are any problems remaining.

Dave Edis - Senior Developer
interactivetools.com