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.

We're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

Archive /

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

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

Variations in localhost and host databases

Go to End

4 Posts   1855 Views


Community Member, 199 Posts

15 October 2008 at 11:07pm

Edited: 15/10/2008 11:15pm

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?



Community Member, 199 Posts

15 October 2008 at 11:25pm

Just saw this link:

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


Community Member, 36 Posts

15 October 2008 at 11:27pm

Edited: 15/10/2008 11:30pm

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


Community Member, 199 Posts

16 October 2008 at 12:31am

Hi Piklets,

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