Restoring database from XML backup?

nejko

Joined: 2008-09-09
Posts: 3
Posted: Thu, 2008-09-25 10:01

Hello,

I was trying to upgrade G2 2.2 to 2.3rc1 but in the middle of upgrade, the imagemagick's "verify" kind of leaked the memory and the upgrade process crashed. If I try to continue the interrupted upgrade, it says I don't have good config.php. However, I would just like to restore 2.2 now, but I didn't make DB backup "by hand", I only have that XML db-backup file (in g2.../backups) that was created by g2's upgrade process. How can I rebuild the database with that file?

Thanks,
Nejc

 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Thu, 2008-09-25 18:58

G2 DB backups in the form of G2's DB XML file format can only be restored with Gallery 2.3 (and later versions).

What you're trying to do is importing a G2 DB XML backup file of G2.2. Not sure if that works.

First, please create a real MySQL database backup (e.g. with phpmyadmin or other MySQL tools, command line tools work best).
Once and only if you have such a real MySQL database of your current state of the database, you can try to use G2's XML backup import tool.

To use that tool, I assume you have the gallery2/ folder of G2.3 in place (with your existing config.php file).
Browse to gallery2/lib/support/index.php where you can choose to import the DB backup file.

Please let me know how it goes.

--------------
Documentation: Support / Troubleshooting | Installation, Upgrade, Configuration and Usage

 
valiant

Joined: 2003-01-04
Posts: 32509
Posted: Thu, 2008-09-25 19:01

PS: Please verify that your MySQL database backup file looks fine. The feeling of false security is really bad. E.g. doing a backup and later finding out that the backup file is worthless because something went bad during the backup process. With the feeling of false security you'd think you couldn't make things worse (like deleting the current DB and trying to restore from G2's DB XML file). If the G2 DB XML import fails for some reason, you'd want to restore your MySQL DB backup file. And if that's worthless as well, you're left with less options than you had to start with.

 
KeithLM

Joined: 2009-07-05
Posts: 19
Posted: Sun, 2009-07-05 00:41
Quote:
Browse to gallery2/lib/support/index.php where you can choose to import the DB backup file.

What does this mean? I've tried this and get a blank page. Is this http://localhost/gallery2/lib/support/index.php or something else?

I just wiped my system and installed Fedora 11. I kept my entire gallery2 directory intact and I have an xml backup of the database. I need to get that xml file back into the database but I'm completely lost on how to do this. It seems like these instructions are what I need, but since this page doesn't come up I'm stuck.

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Sun, 2009-07-05 06:38

So you get a blank page when you browse to http://localhost/gallery2/lib/support/index.php with your browser?
What if you browse to http://localhost/gallery2/main.php ?

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team

 
KeithLM

Joined: 2009-07-05
Posts: 19
Posted: Sun, 2009-07-05 08:03

I found this problem was a bug in the Fedora package. I had to comment out a line of code in one of the php files and it ran. I removed the fedora package and downloaded the tar.gz here and reinstalled. I still have problems, but not related to this post. I've posted that here: http://gallery.menalto.com/node/88845. Thanks.

 
bobob

Joined: 2003-07-12
Posts: 110
Posted: Tue, 2010-11-09 11:00

floridave, i have similair problem. i accidentaly deleted the gallery2 database. i have however a xml backup which was made during the upgrade from 2.2.4 to 2.3.1. i am in big trouble, so any help is much appreciated. i posted the issue here http://gallery.menalto.com/node/99037#comment-359289 (as part of a wider operation)

 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16504
Posted: Tue, 2010-11-09 13:53
valiant wrote:
G2 DB backups in the form of G2's DB XML file format can only be restored with Gallery 2.3 (and later versions).

What you're trying to do is importing a G2 DB XML backup file of G2.2. Not sure if that works.

Since that XML backup you have is of 2.2.4, I really doubt it's going to work. Heck, I've tried testing backing up a 2.3 install, deleting it, restoring it and that didn't work. That was a couple years ago through, but I could never get it to work.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

 
floridave
floridave's picture

Joined: 2003-12-22
Posts: 27300
Posted: Tue, 2010-11-09 14:46

I could never recover from a XML backup either.

Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team