Can't recover G2 site from XML backup after clean FC10 upgrade!
|Posted: Sun, 2009-03-08 17:43|
I have been running Gallery2 for a while on Fedora Core 8, and recently upgraded my machine to Fedora Core 10 with a clean install (I had to reinstall MySQL, Gallery2, etc.). After getting Gallery2 installed, I tried to recover from my XML backup and it didn't work - no albums are visible, and there is only 1 record in g2_Item. Please help!
My old system was already running Gallery 2.3, so I had done both a backup from the Admin/Maintenance UI and a backup of the entire g2data directory. The XML backup file is ~7MB, and the g2data.tgz is ~10GB, and both appear ok (I can find the list of image filenames in the XML file, etc.).
I did a clean install of everything Gallery2, going through the web-based install without problems. I then mounted my backed-up g2data directory in place of the new (clean) one and attempted to run the db recovery on the /lib/support page, accessing the XML file in the /backup directory. (I did have to make some SELinux-related mods for the new install, as my FC10 SELinux now requires 'httpd_sys_content_rw_t' type on writable files instead of just 'httpd_sys_content_t' as before.) Afterwards, the import webpage claims success, but my db is still essentially empty, and thus no albums appear on the site (even though the /albums directory is fully populated).
Is there some special process I must follow to make this work? Do I have to run the import before running the install process? Do I need to have the new/clean g2data directory in place when I run the XML db import, then copy over the /albums directory? I have tried a number of different combinations, to no avail.. And since I relied on the Gallery2 XML db backup (which is full of XML encoding mess) instead of the MySQL backup, I can't easily just recover directly in MySQL. What do I do?
Gallery URL = http://www.jbwarren.net:8080/gallery2/main.php