Uploading to remote server

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.

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

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

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.