moving server and mySQL version upgrade

LesleyHayes
LesleyHayes's picture

Joined: 2007-03-27
Posts: 21
Posted: Mon, 2013-02-11 16:53

I am needing to move my gallery 2.3.2 from one server to another and my hosting company has offered to do it but they are concerned with capatibility. Currently mySQL is version 4.0.2 but the new servers is 5.2.3 - will this cause a problem with the tables and import and if so, any help would be appreciated.


Gallery URL = http://gallery.barlowtyrie.co.uk/main.php
Gallery version = 2.3.2 core 1.3.0.2
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 4.3.10-2 cgi-fcgi
Webserver = Apache/2.0.51 (Debian GNU/Linux) PHP/4.3.10-2 mod_ssl/2.0.51 OpenSSL/0.9.7e
Database = mysqlt 4.0.24_Debian-10sarge3-log, lock.system=flock
Toolkits = Exif, Gd, SquareThumb
Acceleration = none, none
Operating system = Linux chimp.keme.net 2.4.27-3-386 #1 Wed Dec 6 00:38:33 UTC 2006 i686
Default theme = matrix
gettext = enabled
Locale = en_GB
Browser = Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.17 (KHTML, like Gecko) Chrome/24.0.1312.52 Safari/537.17 2
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Mon, 2013-02-11 17:20

there should not be a problem. make sure you follow our instructions.
FAQ: How can I move my Gallery installation from one server to another?

-s
________________________________
All New jQuery Minislideshow for G2/G3
 
Dayo

Joined: 2005-11-04
Posts: 1642
Posted: Mon, 2013-02-11 19:22

I am running mine with MySQL 5.5.30.

However, I am sure your host knows the value of backing things up before such major changes.

--
dakanji.com
 
LesleyHayes
LesleyHayes's picture

Joined: 2007-03-27
Posts: 21
Posted: Wed, 2013-02-13 15:43

Thanks for that.

second problem..... I cannot have the database on the new server named the same as on the old server (it's all server_account number etc etc and out of my control). Is there a work around?
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Wed, 2013-02-13 15:49

edit gallery2/config.php

-s
________________________________
All New jQuery Minislideshow for G2/G3
 
LesleyHayes
LesleyHayes's picture

Joined: 2007-03-27
Posts: 21
Posted: Wed, 2013-02-13 15:59

at which step in the instructions do I do this? (sorry i'm being a thicko here)
 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Wed, 2013-02-13 16:10

copy your old gallery2 files from old server to new server
copy your old g2data from old server to new
export old database tables from old DB
import those tables into new DB

Edit gallery2/config.php on the new server with the new path to the new g2data and any DB info that has changed.

If you read through config.php it is in plain English and this step will be evident.

-s
________________________________
All New jQuery Minislideshow for G2/G3
 
LesleyHayes
LesleyHayes's picture

Joined: 2007-03-27
Posts: 21
Posted: Wed, 2013-02-13 16:25

thank you for your help