Forums

What are do's / don't on moving an SQL file.

Permalink
I've recently setup a C5 site, but the content was created on a Local development system with exactly the same files. When the Local database SQL file via export is imported into the Website I get the following error when starting up C5. (see attached jpeg)

Yet, in exporting the Database from the Website and back into the Local system with an import, C5 startups fine.

I've checked via PhpMyAdmin the table list and the info looks the same.

Could use some help on this, as I'm totally stuck.

1 Attachment

 
tdpss555 replied on at Permalink Reply 1 Attachment
Sorry, previous post has wrong attachment. The following is correct.
nteaviation replied on at Permalink Reply
nteaviation
Check to make sure that the database (tdpss_c5) actually exists under the exact name (case sensitive) on both systems. Then check the same on the tables in question (PageStatistics).
jgarcia replied on at Permalink Reply
jgarcia
You need to run the import on an empty database. The one you are trying to import into looks as though it already has C5 installed. Drop all the table and re-run the import and you should be fine.
tdpss555 replied on at Permalink Reply
I believe my problem is the "case sensitive" table names issue. This is more a MySQL setup difference between my LocalHost system (Windows7) and the Website (Linux).

I working on how to correct and will post later.
nteaviation replied on at Permalink Reply
nteaviation
This may save you some time :)
http://www.concrete5.org/community/forums/installation/uncaught_exc...