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]
Posts: 36
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?
Posts: 1642
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.
--
dakanji.com
Posts: 36
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)
Posts: 36
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.
Posts: 36
I guess the next question is how do I make the versions.dat file in g2data match the database version - or visa virsa?
Posts: 36
It appears I worked my way through it all - thanks for all the help - lol