Problem with ugrading

[cleo_33]

I tried to ugrade my gallery but I ended with reinstalled gallery. http://weheartbella.com/photogallery/
I made a back up but I don't know how to use it to return it.

[phill104]

If your database is in tact and your albums folder is still present with all its files then it should be a very simple task to restore your old gallery. If the albums folder is still there in the current install then you would probably just need to copy the old /include/config.inc.php file from your backup into the same location in the new install. The run update.php and hopefully things will be back.

[cleo_33]

Yes the albums folder is still there. But the back up is .sql and I don't know how to use it..

[Αndré]

From our docs:

Restore the database
Restore the mySQL table by running the queries of the dump files you created on the old server. To accomplish that, you will need the same tool on the new server (the target server) that you have used on the old server to create the backup; if you have used phpMyAdmin on the old server to create the backup you should use phpMyAdmin on the new server as well to restore the dump.

Edit the database settings
Your new webhost must have provided you with the mySQL access data (you already had to use that data to restore the dump on the new server). That mySQL data usually will differ from the mySQL data on the old webserver, so you will have to edit the file that contains those data. Use a plain text editor (notepad.exe is fine) and edit include/config.inc.php: inside that file, you will find the old mySQL data that you will need to overwrite with the mySQL data for the new server.

If you don't know how to use phpMyAdmin, please google for it.

[cleo_33]

I did what you told me and completed the update but the photos still don't appear.

[Αndré]

Then you have done something wrong. Have a look at your restored database. The tables "albums" and "pictures" should contain the references to your albums and pictures. If it's empty, you're either browsing the wrong database or haven't imported anything.

If you verified your MySQL data has been restored successful, check if the values in include/config.inc.php match your restored MySQL database (carefully look at $CONFIG['dbname'] and $CONFIG['TABLE_PREFIX']).