Home› General support

Restoring ZP Database

sunkast Member
in General support
Last month I had to switch hosts for my domain unexpectedly. On my new host I installed version 1.0.8.2 which is newer than what I had installed on my previous host. I'm not sure if I had 1.0.3 or 1.0.7. I luckily have a back up of the ZenPhoto images and database. So my question is, what is the best way to restore the old database/images to the new ZenPhoto installation that I'm already using?

Comments

  • sunkast Member
    Just to clearify something from an obvious possible solution... I have ZenPhoto 1.0.8.2 installed and with new images and comments. I want to restore the older images and comments that I have backed up in an SQL file. I have attempted to import the SQL entries through phpmyadmin and then run upgrade.php, but this does not work. No data will show up in the zp admin section, even though the data is in the database.
  • trisweb Administrator
    Are all the images in the same place? (In the albums directory)

    That's really all that is needed. You don't even need to run upgrade.php.

    Zenphoto runs off the filesystem, not the database. If the images are there and Zenphoto is working, that's all you need. You can then overwrite the new database with the old backup.
  • sunkast Member
    Yeah, that was my problem. I was trying to restore the database before uploading the images. At least it gave me something interesting to do for the night. Thanks for your help.
Sign In or Register to comment.