MYSQL Error after migrating local site to live server - help!

Permalink 1 user found helpful
I have just moved my site from my computer to a hosting service, and I am getting the following error when I type in the domain name:

An unexpected error occurred.
mysql error: [1146: Table 'auspacjo_Concrete5db2.Config' doesn't exist] in EXECUTE("select * from Config where uID = 0 order by cfKey asc")

These are the steps I used to migrate it over:

1. Setup new database and mysql user on server and added user to database
2. Moved entire contents of concrete5 site to server
3. Exported original database using myPhpAdmin on local machine
4. Opened server's myPhpAdmin, selected new database, and imported old database file from local machine
5. Opened config/site.php in live site and updated with new database and username/password. server is 'localhost'.

Typed in domain address in browser, and got the above error.
Did miss something?

Cheers.

PatrickCassidy
 
mnakalay replied on at Permalink Best Answer Reply
mnakalay
Hello,
it looks like you developed your website under windows or mac and your host is under linux so you probably have a problem due to mysql case sensitivity in table names.

Try this (free) add-on after reading the explanationhttp://www.concrete5.org/marketplace/addons/database-case-sensitivi...
You can also read this how-tohttp://www.concrete5.org/documentation/how-tos/developers/mysql-dat...

it should solve the problem
Good luck
PatrickCassidy replied on at Permalink Reply
PatrickCassidy
Hey, thanks for this heaps... yes appears that it may be case issue. I have installed the add-on, however being new to all this, have a couple of questions:

1. I'm using WAMP, so where exactly do I find the my.ini file so that in future I can add the snippet to avoid this issue?

2. If I choose to "Download Migration Script" with the add-on, how do I implement that in myPhpAdmin? (steps would be nice)

Cheers!
mnakalay replied on at Permalink Reply
mnakalay
hi,

1. I'm using xampp so it should be the same. In the wamp installaton folder you should have a folder called mysql. Inside the folder you will find either a my.ini file or several my-something.ini. For instance I have my-huge.ini, my-medium.ini, my-small.ini. You get the idea.
Here's the info from my-small.ini
# Example MySQL config file for small systems.
#
# This is for a system with little memory (<= 64M) where MySQL is only used
# from time to time and it's important that the mysqld daemon
# doesn't use much resources.


you just choose one of the files and rename it to my.ini and voila.

2. So I assume you understand how to get the migration script. It's a .sql file. You go to phpMyAdmin (I'm talking about the live site, not in your wamp), you select the database you want to work with from the column on the left. There should be no tables in it as I believe the migration script is going to recreate all the tables. If you have tables in it, click on the tab "Structure" at the top of the screen. It should show you a list of all the tables. At the bottom of the list you click on "select all" then from the list next to it you select "Drop". You confirm. All tables are now deleted and your Database is empty.
You now click on the tab "Import" at the top of the screen. You choose your .sql file using the button "Choose file". The character set of the file should be set to utf-8. Format should be set to SQL and leave the rest as it is. Then push the button Go. All your tables with content and proper names should be recreated.

Good luck