Announcement

#1 2013-09-11 12:24:04

Peter de Bruin
Guest

Piwigo backup

How to make a backup of the full Piwigo DBM as I can't find any DB backup plugin.

 

#2 2013-09-11 13:39:30

flop25
Piwigo Team
2006-07-06
6965

Re: Piwigo backup

hello
Your host provider should provide a phpmyadmin or cpanel or any administration panel to view the database


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#3 2013-09-11 16:02:01

Peter de Bruin
Guest

Re: Piwigo backup

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

 

#4 2013-09-11 16:14:50

flop25
Piwigo Team
2006-07-06
6965

Re: Piwigo backup

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


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#5 2013-09-11 19:22:52

Peter de Bruin
Guest

Re: Piwigo backup

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.

 

#6 2013-09-11 19:28:52

flop25
Piwigo Team
2006-07-06
6965

Re: Piwigo backup

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


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#7 2018-11-27 10:54:48

sawjer
Member
2018-11-27
2

Re: Piwigo backup

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

 

#8 2018-11-27 16:17:29

erAck
Piwigo Team
2015-09-06
256

Re: Piwigo backup

Physical albums and their images (those you synchronize after ftp upload) are under galleries/
Virtual albums' images are under upload/


Running Piwigo at https://erack.net/gallery/

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2019 · Contact