Jump to:

4951 Posts in 13999 Topics by 1491 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » MySQL troubles with server changes

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: 1025 Views
  • pangpang
    Avatar
    Community Member
    1 Post

    MySQL troubles with server changes Link to this post

    Hi!

    Read through the forum and other channels aviable. But my problem is still to be answered.

    Everything works fine on my local WAMP setup and the problem accours when I move from my personal test server to a live server.

    Tried a fresh install on the new server, then uploaded specific files and images and exported the database and imported it on the live server. And I even tried a update and replace statement.

    The problem is that on my localserver all the tables are in written like tablea, tableb, tablec and so on. But on the live server everything goes like TableA, TableB, TableC and so on. And this happens with I flush the db to try to build again. With just an import SS wouldnt find the tables.

    So with an database import, update and so on on the live server fails with the site.

    There is no problems with the mysql side. Just that the difference in the namesetting on the live and personal server.

    How do I fix this matter?

  • Mindfusion
    Avatar
    Community Member
    7 Posts

    Re: MySQL troubles with server changes Link to this post

    Hello,

    Did anyone find a workaround for this or do i have to manually type in the table names in mysql dump (i hope there is a better solution)

  • Mindfusion
    Avatar
    Community Member
    7 Posts

    Re: MySQL troubles with server changes Link to this post

    Replaced the table names in my mysql dump file and got and error when i tried to run dev/build . Is there a solution to exporting from my windows dev machine to a linux server?

  • Mindfusion
    Avatar
    Community Member
    7 Posts
    1025 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.