Changing Over Servers

[kerrsmithws]

Hello I am the administrator for a site. Now I had the old server but I moved over to a new one. I have the gallery folder moved over too. But unforchanately the gallery is still stuck to the old MySQL server. Is there a way I can change the MySQL so I dont have to start the gallery all over again?

[pulz]

Just export the old database with for instance phpmyadmin from the old server and import it in the DB of the new server.

Just keep the album names etc the same on your new server and it will work, i've done it several times without any problems


1) On your old server, goto your database programm (mostly) phpmyadmin so I will give instructions for the phpmyadmin version:

2) On the first page select export.

3) In the following screen select under the export drop down menu your database

4) Select SQL

5) Leave the SQL options as they are

6) Select the box send

7) click on start

Go to your new server

9) Start your database programm

10) Click on the left upper button with the SQL tekst on it (next to the home button)

11) In the pop up screen select import file (= second tab)

12) Select the file you previously stored and click on start

13) That it

[Abbas Ali]

Also edit include/config.inc.php and change the database variables as per the new server.

[kerrsmithws]

12) Select the file you previously stored and click on start

Okay im back, which file would that be?

[Abbas Ali]

The sql file which you saved from your old server. It means the file containing old database.

[Lennon]

Hey!

I'm having the same problem too and I'm with you up until here: 10) Click on the left upper button with the SQL tekst on it (next to the home button)

Myphpadmin isn't set up that way so what do I do next? Thanks!