InMotion Hosting Support Center

Can different database settings prevent site from working properly?

Category: New Customers

webjockey
Asked:
2013-03-16 3:57 pm EST

Hits: 415
Moving sql database from host that uses InnoDB default storage engine and utf8_general_ci collation to InMotion which uses MyISAM default storage engine and latin1_swedish_ci collation. Site is not working well (to put it mildly). Could the different storage engine/collation settings be the problem or should I look elsewhere?

You must login before you can ask a follow up question.

You must login before you can submit an answer.

Finally got this figured out. I somehow managed to usa a Joomla 1.5 configuration.php file instead of the file used with 2.5. I still have the old 1.5 site in a sub-domain as an archive and got them mixed up. Older copyright dates finally got my attention. Anyway, all is well now. Case closed!
webjockey
5 Points
2013-04-06 05:47 pm EST

OTHER ANSWERS

0

jamesr
Staff
5,889 Points
2013-03-18 12:05 pm EST
Thank you for yoru question webjockey!

You should be ok to import your database the way you did as long as there were no charset-dependent data in the database and code. The database may have become corrupt after the collation change. Try running a repair on the database.

How to Check and Repair a MySQL Database

You may want to create the DB first, then set the collation, then import with a file which has the collation in the "create table" section. The data has to be imported into table with the correct collation.

Best Regards,
James R

You must login before you can post a comment about this answer.

Like this Question?

Support Center Login


Social Media Login

Currently Disabled, Please check back later.

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!