InMotion Hosting Support Center

Can different database settings prevent site from working properly?

Category: New Customers

2013-03-16 3:57 pm EST

Hits: 460
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?

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!