Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » Variations in localhost and host databases

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

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

Page: 1
Go to End
Author Topic: 1308 Views
  • Briohny
    Avatar
    Community Member
    199 Posts

    Variations in localhost and host databases Link to this post

    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

  • Briohny
    Avatar
    Community Member
    199 Posts

    Re: Variations in localhost and host databases Link to this post

    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!

  • Piklets
    Avatar
    Community Member
    36 Posts

    Re: Variations in localhost and host databases Link to this post

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

  • Briohny
    Avatar
    Community Member
    199 Posts

    Re: Variations in localhost and host databases Link to this post

    Hi Piklets,

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

    1308 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.