Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.


Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Variations in localhost and host databases


4 Posts   1400 Views


15 October 2008 at 11:07pm (Last edited: 15 October 2008 11:15pm), Community Member, 199 Posts

I have successfully exported my localhost database to import onto the live webserver. I noticed however that when i imported the database, the fields and tables were named different hence adding them to the table and not replacing as they should be.

localhost: 'editablecheckbox' - collation 'latin1_swedish_ci'
host: 'EditableCheckbox' - collation 'utf8_general_ci'

How do I change the localhost database fields to match? I noticed that i could go into each field and change the collation and rename the label but there must be an easier way.

Any suggestions?



15 October 2008 at 11:25pm Community Member, 199 Posts

Just saw this link:

But i think that's too late for me. Will i have to change all the tables manually? please no!


15 October 2008 at 11:27pm (Last edited: 15 October 2008 11:30pm), Community Member, 36 Posts

Try exporting a structure of a correct table in SQL and importing it onto your one.


16 October 2008 at 12:31am Community Member, 199 Posts

Hi Piklets,

Sorry... I'm not sure what you mean.