Difference between revisions of "Gallery2:How To Backup and Sync the DB" - Gallery Codex
Personal tools

Difference between revisions of "Gallery2:How To Backup and Sync the DB"

From Gallery Codex

m (Backing up syn moved to Backing up and Syncing DB)
(No difference)

Revision as of 12:50, 2 November 2005

So have created your production gallery site with a few custom bits but wish to test the cvs version as well

This is what I have done

wrote this PHP page ( havn't worked how to display the shell output onto screen the print isn't working )


<?php $output = shell_exec( 'sh update.sh' ); print($output); ?>

which runs this Shell script

update.sh --------------------------------
  1. update code

cvs -d:pserver:anonymous@cvs.sourceforge.net:/cvsroot/gallery update -P gallery2

  1. copy the images to dev folder If you have space to product production

cp -ru /path to /albums /path to /g2data_dev/

  1. back db done this so I get a db backup

mysqldump --add-drop-table -u ProductionDBname username password > g2.sql

  1. write the data back into dev db

mysql -u DevDBname username password < g2.sql

Both file need to be in the root of the dev web site

So all I have to is run the php and I get backup of the DB called G2.sql and a fresh copy of the code

I have set my dev site up as a third level site ie dev.gallerysite.com/gallery2

You will need to change the path and username password in the shell to make it work

I am sure this can be inproved on and that is have the reson I have posted it here