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.

Archive

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


Reply

4 Posts   1400 Views

Avatar
Briohny

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.

i.e.
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?

Thanks

Avatar
Briohny

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

Just saw this link: http://www.silverstripe.co.nz/site-builders-forum/reply/115620

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

Avatar
Piklets

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.

Avatar
Briohny

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

Hi Piklets,

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