[SOLVED] database wiped out, data ok... next step?

mystavash

Joined: 2004-09-12
Posts: 69

Posted: Sun, 2005-04-10 21:17

I had an install of G2 Nice Commits for my personal pictures. A very recent database crash on my server has left my g2 database completely empty, which is naturally causing all sorts of problems. I don't have a back up for anything but the pictures.

I am not sure what is the best way to proceed. Should I just remake the database tables? I'd also like to be able to upgrade to the next beta release...should I just take this as an opportunity to start over?

Advice appreciated!

Anisa.
PS: my production site, www.animecards.org cannot live without the gallery, but was not affected because G1 does not use a database! Go figure. ;p

----

Gallery URL (optional): http://www.mystavash.net/gallery/
Gallery version: G2 Nice Commits
Webserver (with version):
Datatabase (with version): mysql
PHP version (eg 4.2.1):
phpinfo URL (optional):
Graphics Toolkit(s):
Operating system:
Web browser/version:
G1 version (for migration bugs):

valiant

Joined: 2003-01-04
Posts: 32509

Posted: Sun, 2005-04-10 21:25

if there is no backup of the database, you have to start over.

1. if you have no other copy of your images than the one in g2data/albums, then copy/move the pictures from there to another place on the harddisk
2. get the newest version of g2 (current.gallery2.tar.gz) from http://galleryupdates.jpmullan.com
3. empty your g2data directory (make it really empty!)
4. empty the db, really empty
5. install the new g2 version as if it was a new install, no upgrade (no upgrade possible, because there's no metadata. it was lost with your database tables).
6. set up the "Local Server Upload Paths" in "site admin".
7. copy everything from the old g2data/albums/ to the local server upload path (do this in your filesystem, this has nothing to do with G2).
8. go to your gallery, add item -> From Local Server -> add items, select whole directories to add all items recursively in it.

mystavash

Joined: 2004-09-12
Posts: 69

Posted: Mon, 2005-04-25 10:14

Thank you for your prompt response.

My host updated the database with a newer backup and the site came back. I upgraded to the latest beta instead.

I'm sure someone else will find this info useful though!

Anisa.

mystavash Joined: 2004-09-12 Posts: 69	Posted: Sun, 2005-04-10 21:17
	I had an install of G2 Nice Commits for my personal pictures. A very recent database crash on my server has left my g2 database completely empty, which is naturally causing all sorts of problems. I don't have a back up for anything but the pictures. I am not sure what is the best way to proceed. Should I just remake the database tables? I'd also like to be able to upgrade to the next beta release...should I just take this as an opportunity to start over? Advice appreciated! Anisa. PS: my production site, www.animecards.org cannot live without the gallery, but was not affected because G1 does not use a database! Go figure. ;p ---- Gallery URL (optional): http://www.mystavash.net/gallery/ Gallery version: G2 Nice Commits Webserver (with version): Datatabase (with version): mysql PHP version (eg 4.2.1): phpinfo URL (optional): Graphics Toolkit(s): Operating system: Web browser/version: G1 version (for migration bugs):
	XUser login Username: * Password: * Create new account Request new password
valiant Joined: 2003-01-04 Posts: 32509	Posted: Sun, 2005-04-10 21:25
	if there is no backup of the database, you have to start over. 1. if you have no other copy of your images than the one in g2data/albums, then copy/move the pictures from there to another place on the harddisk 2. get the newest version of g2 (current.gallery2.tar.gz) from http://galleryupdates.jpmullan.com 3. empty your g2data directory (make it really empty!) 4. empty the db, really empty 5. install the new g2 version as if it was a new install, no upgrade (no upgrade possible, because there's no metadata. it was lost with your database tables). 6. set up the "Local Server Upload Paths" in "site admin". 7. copy everything from the old g2data/albums/ to the local server upload path (do this in your filesystem, this has nothing to do with G2). 8. go to your gallery, add item -> From Local Server -> add items, select whole directories to add all items recursively in it.

mystavash Joined: 2004-09-12 Posts: 69	Posted: Mon, 2005-04-25 10:14
	Thank you for your prompt response. My host updated the database with a newer backup and the site came back. I upgraded to the latest beta instead. I'm sure someone else will find this info useful though! Anisa.

[SOLVED] database wiped out, data ok... next step?

XUser login