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.

Upgrading SilverStripe /

Ask questions about upgrading SilverStripe to the latest version.

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

Issues in moving SS website to local WampServer


Reply


3 Posts   892 Views

Avatar
WittySmitty

Community Member, 4 Posts

30 April 2013 at 4:01pm

I am an amateur SilverStripe hack and I am in a mess.

Background: About three years ago, I put together a website for our church using SS (V2.3.4). It has served us well.
However, I did not upgrade the SS base code. It was working well and I did not have the time to improve the site.

A few days ago our web hosting company upgraded PHP to the latest verson (5.4) and our website went down hard. I suspect either the SS core and/or the and extensions clashed with PHP 5.4.

Since I do not know PHP, I decided to rebuild the site instead of fixing code I do not understand.

Attempt #1: I decided that starting a new SS build (V3.0.5). The new SS build works with a new DB and with my template. But when i link it to the existing Database, the site crashes (I believe the crash is a simple white screen with no error message - I may need to run it again, to record any error message). I cannot get to the original web content.

Attempt #2: I decided to pull the original website down to my laptop and run it local via WampServer. I can dial back the PHP to an older version. I have a generic SS V2,3,4 running in one folder. When I started the church website via WampServer, I got this error:
"[Warning] mysql_connect() [function.mysql-connect]: Access denied for user 'sbtindyo_smitty'@'localhost' (using password: YES)"
So I suspect the SQL database is not copied to the local WampServer

Attempt #3: I exported the MySQL database from the original church website. However, Wampserver has a 2Mb limit on importing databases. As luck would have it, the database I have is 5.5Mb in size.

At this time all I want to do is to bring up the website one more time to copy the content to our new SS build. There has to be a better way.

I am open to any suggestions.

-WittySmitty

Avatar
swaiba

Forum Moderator, 1799 Posts

30 April 2013 at 10:51pm

I normally use http://www.heidisql.com/ to copy dbs locally on windows... it has an export feature that you can select a DB and it will duplicate the DB there (either server to localhost or reverse)

Avatar
copernican

Community Member, 189 Posts

1 May 2013 at 12:33am

I believe the error "[Warning] mysql_connect() [function.mysql-connect]: Access denied for user 'sbtindyo_smitty'@'localhost' (using password: YES)" means that you database config isn't setup properly. Open up the _config.php file in the mysite folder. You should see something that looks like

$databaseConfig = array(
"type" => 'MySQLDatabase',
"server" => 'localhost',
"username" => 'db-username',
"password" => 'db-password',
"database" => 'db-name',
"path" => '',
);

You'll want to make sure the username, password, and database are all set correctly for your local wamp server.