Migrating MySQL database

radicalblues

Joined: 2007-06-05
Posts: 36
Posted: Thu, 2010-08-12 02:22

Hi!

I use v23, this is my gallery link: http://lnx.xradicaldreamers.net/azuland/main.php

My current host (aruba.it) had assigned me a really old MySQL version (4.0.30.), so I requested an updated version to install some other things like WordPress. So I got this newer version MySQL database for 1 free year, w00t.

Anyway, since it's a new version, it's empty. So I did what I had to do: went to backup the MySQL database as the wiki says, checking all the appropriate boxes. Then went to the new MySQL database and restored the old database in the new one. All that's done.

I only don't know what to do next. How do I recalibrate Gallery to read the new MySQL database and stop reading the old one? You know, make it recognize the new host, login, pass, database name, etc.

 
radicalblues

Joined: 2007-06-05
Posts: 36
Posted: Thu, 2010-08-12 02:27

That was obviously v 2.3, sorry. Edit buttons.

 
suprsidr
suprsidr's picture

Joined: 2005-04-17
Posts: 8339
Posted: Thu, 2010-08-12 02:38

edit azuland/config.php line ~101
make sure $storeConfig['type'] = 'mysqli'; for the new DB

-s
FlashYourWeb and Your Gallery with The E2 XML Media Player for Gallery2

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Thu, 2010-08-12 02:38

Edit your config.php file under your gallery's directory.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
radicalblues

Joined: 2007-06-05
Posts: 36
Posted: Thu, 2010-08-12 03:12

Thank you, haha. That was simple enough, I'm finished now. =]