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   1428 Views

Avatar
Briohny

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.

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

Community Member, 199 Posts

15 October 2008 at 11:25pm

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

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.

Avatar
Briohny

Community Member, 199 Posts

16 October 2008 at 12:31am

Hi Piklets,

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