Our photo gallery is back on-line.
I was able to bring it back much more quickly than I had first anticipated, because I used an old Gallery 1.x back-up to seed the albums in the Gallery 2.x installation. That copied hundreds of extra, unnecessary files, but they were easily removed afterwards by rsync.
I did this by getting a list of all the album directories on the remote server:
cd /var/www/g2data/albums find -type d > /tmp/file_list |
I then copied this over to the new server with the Gallery 1.x back-up:
for i in `cat /tmp/file_list`; do album=${i##*/} src=`find /var/www/html/albums -type d -name $album` [ -n "$src" ] && rsync -av $src/ /var/www/g2data/albums/$i done |
In the end, I needed to copy from New Jersey only the photos we had taken since mid-February, which is when I had done a full back-up in preparation for migrating from Gallery 1.x to 2.x.
Somehow, one of the tables in the MySQL database had got corrupted in the move:
060518 18:02:38 [ERROR] Got error 134 when reading table './gallery2/g2_ImageBlockCacheMap' |
This was easily corrected:
mysql> repair table g2_ImageBlockCacheMap; +-----------------------------+-------+---------+----------------------------------------+ | Table | Op | Msg_type | Msg_text | +-----------------------------+-------+---------+----------------------------------------+ | gallery2.g2_ImageBlockCacheMap | repair | warning | Number of rows changed from 45465 to 45460 | | gallery2.g2_ImageBlockCacheMap | repair | status | OK | +-----------------------------+-------+---------+----------------------------------------+ |
And, with that, the rescue and salvage operation to yank caliban.org from the incompetent clutches of the unholy alliance of Managed.com and Web Host Plus is 95% or more complete.
Once the residual DNS propagation issues evaporate, I’ll be able to fully exhale once again.