Jump to:

4950 Posts in 13940 Topics by 1490 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » Problems moving local site to live server

Getting SilverStripe up and running on your computer and on your web server.

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

Page: 1
Go to End
Author Topic: 640 Views
  • Cgull
    Avatar
    Community Member
    23 Posts

    Problems moving local site to live server Link to this post

    Hello,

    I tried two ways to move my local site to a live server:
    1. I copied all the files from my local machine to the live server, created the database and imported my local database.
    Got server errors.

    2. Installed silverstripe on my live server 2 problems:
    2.1 It creates the database collation as latin1_swedish when I want it utf8_general_ci
    2.2 Tt creates all the table names with Capital letters and then when I import my local database I get all my local tables as well which are named with small letters for example:
    Local machine:
    table name: group_members
    Live server:
    table name: Group_Members

    How do I fix that?

  • frankmullenger
    Avatar
    Forum Moderator
    51 Posts

    Re: Problems moving local site to live server Link to this post

    I'm guessing you probably use Windows on your local machine and the server is Unix. You probably want to configure MySQL lower_case_table_names=2 on your Windows machine so that the table names are cased in the same way to the server (not lower case).

    http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

  • Cgull
    Avatar
    Community Member
    23 Posts

    Re: Problems moving local site to live server Link to this post

    Thank you, is there anyway for me to fix this problem now after everything has been created already?

    Is there no way to just copy all the files from my local machine to the live server without installing silverstrip online?

  • frankmullenger
    Avatar
    Forum Moderator
    51 Posts

    Re: Problems moving local site to live server Link to this post

    Not sure if there is an easier way but you could dump the MySQL from your local into a file, then replace all the references to table names in the file so that they are "capitalised" and will therefore match the names of the tables on the server when you import the data...

  • Cgull
    Avatar
    Community Member
    23 Posts

    Re: Problems moving local site to live server Link to this post

    Thanks, that's an idea. Anyway, for now I stopped developing with Silverstripe until I get an answer about fileinfo

    640 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.