Transferring from local server to hosting service

Permalink 1 user found helpful
I am new to Concrete5 and have been working on a website on my local machine using WAMP on Windows. How do I upload this to my web hosting service?

I tried manually creating the databases, importing the data into them, and then manually uploading all of my files through FTP. However, I couldn't connect to the database on the hosting server after this. I double checked the site.php file and all the settings appeared to be correct.

After this, I used my hosting provider's "one-click install" of C5, giving me a fresh install. However, I was unable to find anywhere, a way of importing an existing site.

 
Remo replied on at Permalink Reply
Remo
Well, there are quirky ways to import existing data but I wouldn't recommend that to you.

Have you tried this:
* copy the content site.php you got from the one-click install
* upload your local site and override all the files
* open site.php on the remote server (the file you just uploaded) and take all database related settings from the file you've got from the one-click installation and change them accordingly

By doing this, you're sure that you're using correct database credentials.
seatjweb replied on at Permalink Reply
I will need to export my local database and import it onto the server as
well, correct?
Remo replied on at Permalink Reply
Remo
Yes!
seatjweb replied on at Permalink Reply
I followed those instructions and received the same error I had gotten
before:

*Fatal error*: Uncaught exception 'ADODB_Exception' with message 'mysql
error: [1146: Table 'seatjo5_seatjDB.Config' doesn't exist] in
EXECUTE("select * from Config where uID = 0 order by cfKey asc") ' in
/home/seatjo5/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78
Stack trace: #0
/home/seatjo5/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037):
adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'seatjo5_...', 'select * from
C...', false, Object(ADODB_mysql)) #1
/home/seatjo5/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1012):
ADOConnection->_Execute('select * from C...', false) #2
/home/seatjo5/public_html/concrete/core/models/config.php(182):
ADOConnection->Execute('select * from C...') #3
/home/seatjo5/public_html/concrete/core/models/config.php(173):
Concrete5_Model_ConfigStore->load() #4
/home/seatjo5/public_html/concrete/core/models/config.php(48):
Concrete5_Model_ConfigStore->__construct() #5
/home/seatjo5/public_html/concrete/core/models/config.php(68): Concrete5_Mo
in *
/home/seatjo5/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php
* on line *78*
Remo replied on at Permalink Best Answer Reply
Remo
okay, that's not about the database access.

That's because table names on Windows are by default lower case but aren't on *nix. Your table is called "config" but the *nix server is looking or "Config".

http://www.concrete5.org/documentation/how-tos/developers/mysql-dat...

Check this add-on, I haven't tried it but I think it should help you:http://www.concrete5.org/marketplace/addons/database-case-sensitivi...
seatjweb replied on at Permalink Reply
Thank you for your help! I have everything working now!