Jump to:

4938 Posts in 16827 Topics by 1490 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » Mysql database naming

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: 1715 Views
  • Kate
    Avatar
    Community Member
    16 Posts

    Mysql database naming Link to this post

    I am trying to understand if I need to have "SS_" as a prefix in the database name? If so my server is making me use "lasergra" as a prefix and I so I chose "lasergraphfr". While installing on the server (http://www.lasergraph.fr/SS/install.php) I can get it to accept only "lasergraphfr" to replace SS_mysite and not SS_lasergraphfr. Also does SS need a dedicated database to make it work? Or can something else be using it?

    Thanks, this is all new to me. Designer brain....stretching to the other side.

  • rbquirke
    Avatar
    Community Member
    70 Posts

    Re: Mysql database naming Link to this post

    Hi Kate

    No, you don't need a prefix for the database name, it should take anything you put in there.
    Your problem might be that you should create the database before installing SilverStripe - the installation script might not have rights on your hosting to create a new database.

    Go to your hosting control panel, either create a new database name or use check the name of an existing one and enter that into the installation page.

    SS doesn't need a dedicated database of it's own. Everything should be ok provided there are no tables in the existing database that SS needs to create. eg: you already have a "Member" table, but silverstripe tries to create a "Member" table when installing.

  • Kate
    Avatar
    Community Member
    16 Posts

    Re: Mysql database naming Link to this post

    Thank you for the quick response. I had a problem getting my content and theme to show up after the first install and I assumed it was the Mysql database. After uninstalling and reinstalling it seems to be working and even remembering the SS_mysite.sql I imported on the server's phpmyadmin! Still don't know what didn't work the first time, but it all looks good so far.

  • Kate
    Avatar
    Community Member
    16 Posts

    Re: Mysql database naming Link to this post

    I spoke too soon. SS got installed with success and even imported the SS_mysite.sql DB from my first installation of SS. When I tried to upload my own local files from the "mysite" folder I get the following error screen. (See attached file).

    Attached Files
  • rbquirke
    Avatar
    Community Member
    70 Posts

    Re: Mysql database naming Link to this post

    ok, that is because in the mysite folder, there is a _config.php file - this has the database connection details.
    When you uploaded the mysite folder, the _config.php file for your local computer had different username, password etc.

    Install again and this time when you upload the mysite folder, don't upload _config.php : you are nearly there!

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