InMotion Hosting Support Center

Can different database settings prevent site from working properly?

Category: New Customers

2013-03-16 3:57 pm EST

Hits: 467
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!
5 Points
2013-04-06 05:47 pm EST



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.

<a href="">How to Check and Repair a MySQL Database</a>

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

Our Login page has moved, Click the button below to be taken to the login page.

Need more Help?


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:
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!