Help with rebuilding installation?

[lancemcvay]

Years ago, I put in Coppermine 1.4.8 on my website and had it running well.  Then my hosting company upped the version of MySQL that was required, and my Coppermine installation no longer works.  I still have all the files and everything in place, but I do not know how to rebuild it from the MySQL 4.x to MySQL 5.1.   

What steps would I take to transform the database to 5.1 or should I do a totally new install?  I had thousands of photos that were done in albums that I would like to keep.    If that can't be done, is there a way to build a new instance of the install that would rebuild itself from all the files still in place?

[phill104]

Simply upgrade to the latest release, 1.5.38. Make sure you back up both your files and database first to mitigate any small risk.

http://documentation.coppermine-gallery.net/en/upgrading.htm

[gmc]

I do not know how to rebuild it from the MySQL 4.x to MySQL 5.1.   

While the CPG upgrade Phil indicates is needed, I read your question differently.
The change from MySQL 4 to 5 is handled outside of Coppermine... In my experience, your ISP host should have a migration utility to copy the data, and then provide you with new connection information.
CPG's config file then needs to be updated with new database information:
In include/config.inc.PHP:

Code Select Expand

$CONFIG['dbserver'] = '';
$CONFIG['dbuser'] = '';
$CONFIG['dbpass'] = '';
$CONFIG['dbname'] = '';

are the values that likely will change.

While the change in MySQL versions shouldn't affect Coppermine, other changes (like PHP version) will break CPG V4.

[phill104]

Some hosts do the MySQL version behind the scenes leaving you to wake up one morning with a headache and a dead site. Had it happen a few times to me. I was guessing this is what has happened to the OP.