How to make a backup of the full Piwigo DBM as I can't find any DB backup plugin.
hello
Your host provider should provide a phpmyadmin or cpanel or any administration panel to view the database
Offline
Actually I am running this on a seperate PC with WAMP. As I did make an export of the database with the PHPadmin function, it seems the photo's are not in the SQL database. They are lost during an subsequent import ..in order to recover from a fatal error!
Looking back at the old PIWIGO files I noticed an upload folder with all pictures and a DATA folder wich includes a folder called "i" It's here where I found again the full range of pictures.
So when I do an PHPadmin import I get a full description of the database in the WAMP server including names of the albums and jpeg's but not the pictures themselves. Only an explamantion mark when opening the Gallery.
When I throw the old files of the "i" folder in the new piwigo everything seems to work again. The exlamation marks are gone and jpeg is visible again. Strange as I thought everything should be in the SQL DBM. I have tried syncronize but no files are updated. I not sure what this function does anyway.
My question is if there is not such thing as an DBM backup plug-in what should I then make a copy of in order to preserve the full gallery build incl the pictures in case of disasters.
Thanks
Pictures are files, so they are physically stored
so if you want to backup your installation, like any other CMS, you need to backup files and db Then not all the files are useful but that's 'peanuts' compared to the weight of pictures
Offline
Thank you for the prompt answere. So I understand that the actual picture (jpeg file ) is stored in an upload folder of the Piwigo environment and all refrences/links in the SQL-DBM. Further that I should copy all files of the current Piwigo environment plus the export PHP-admin ( SQL) file for backup purposes.
In case of disaster install an new piwigo album - duplicated/copy the old piwigo over it ( recovering all content ) and import the SQL file in order to have the server up again. Is this how to proceed as a backup process ? - ps I am not worried about the size but why store twice the same picture (_data/upload/i and piwigo/upload )
What is then ( if I may ) the function of the syncronisation - I thought it would take the actual picture from the upload and move them into the DBM leaving the folder upload empty.
First read the doc http://piwigo.org/doc/doku.php?id=user_ … dd_picture Informations are also available on your gallery under Add Photo->ftp+synchro
_data are for temporary files and can be deleted
a Piwigo installation is not linked to a folder so it can be easily moved on another folder or server: on a new server, just be sure the mysql identification is the same or at least match the info inside database.inc.php
Offline
In case the db cannot be recovered could you tell me the path where the photo files are stored. I would need it in case of disaster.
sawjer
Offline
Physical albums and their images (those you synchronize after ftp upload) are under galleries/
Virtual albums' images are under upload/
Online