[SOLVED] Old Gallery Installation, New Server - having issues

redrider

Joined: 2008-06-08
Posts: 36
Posted: Fri, 2012-06-08 11:55

I had a gallery 2 installation on VDS with Godaddy but lost the server.
I made a backup of the entire gallery 2 directory before it went down.
Currently, I am trying to put it back up on a shared host with godaddy and have Gallery 2.31 "Skidoo" installed but having some issues when I import the old database.

I need some advice on how to proceed please

PS
I am not afraid to go rummaging through a database - with adequate direction of course

Gallery version (not just "2"): 2.31
PHP version (e.g. 5.1.6): PHP Version: PHP 5.2
PHPInfo Link (see FAQ):
Webserver (e.g. Apache 1.3.33): Apache version 2.2.13
Database (e.g. MySql 5.0.32): MySql Server version: 5.0.92-log
Activated toolkits (e.g. NetPbm, GD):
Operating system (e.g. Linux): Linux
Browser (e.g. Firefox 2.0): Firefox 12.1
[/size]
 
redrider

Joined: 2008-06-08
Posts: 36
Posted: Sat, 2012-06-09 13:41

I need to set up my new database with my old password but I cannot use the old password because it begins with a number and database manager wants the password to begin with a letter - what do I do now?
 
Dayo

Joined: 2005-11-04
Posts: 1642
Posted: Sat, 2012-06-09 15:21

Setup the db by meeting the requirements of the db manager on the new server.
G2 stores the db info in the config.php file during installation so just open it and manually edit these lines as required.

$storeConfig['type'] = 'xxxxx';
$storeConfig['hostname'] = 'xxxxx';
$storeConfig['database'] = 'xxxxx';
$storeConfig['username'] = 'xxxxx';
$storeConfig['password'] = 'xxxxx';

--
dakanji.com
 
redrider

Joined: 2008-06-08
Posts: 36
Posted: Sat, 2012-06-09 14:24

I get an error when I try to set up the database and I do not know what it means

Warning: mysqli_real_connect() [function.mysqli-real-connect]: (HY000/2005): Unknown MySQL server host '261180b987fbffb7a6658944e07cafc8' (1) in /home/content/15/6010415/html/cri/gallery2/lib/adodb/drivers/adodb-mysqli.inc.php on line 109
Could't connect :
261180b987fbffb7a6658944e07cafc8: Unknown MySQL server host '261180b987fbffb7a6658944e07cafc8' (1)
 
redrider

Joined: 2008-06-08
Posts: 36
Posted: Sat, 2012-06-09 14:29

Gallery tables already exist in the database and there is a versions.dat file in the Gallery storage directory. But the version of the installed Gallery database tables does not match the version of the installed data in the Gallery storage directory. Select a clean install to erase all data in the database and in the storage directory and to advance to the next step.

 
redrider

Joined: 2008-06-08
Posts: 36
Posted: Sat, 2012-06-09 14:39

I guess the next question is how do I make the versions.dat file in g2data match the database version - or visa virsa?
 
redrider

Joined: 2008-06-08
Posts: 36
Posted: Sat, 2012-06-09 15:06

It appears I worked my way through it all - thanks for all the help - lol