Restoring G2

chris48178

Joined: 2003-05-28
Posts: 66

Posted: Fri, 2005-11-04 16:52

Gallery version = 2.0 core 1.0.0
PHP version = 4.3.6 apache2handler
Webserver = Apache/2.0.49 (Win32) PHP/4.3.6
Database = mysql 4.0.13-max-debug
Toolkits = Exif, NetPBM, Gd
Operating system = Windows NT APOLLO 5.1 build 2600
Browser = Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)

This morning someone with administrative access to an album, deleted all the contents of that album.

What are my options for restoring this data?
I am using NTBackup to run daily backups of my WinXP Pro PC.

I see a g2data directory with the list of albums, but also my MySQL Data directory which contains a lot of files with MYD and MYI extensions.

mindless

Joined: 2004-01-04
Posts: 8601

Posted: Fri, 2005-11-04 18:10

you can restore the entire backup (entire g2data and database), or you can get that album dir from your backup, place it somewhere else own your filesystem and add those images again using "add from local server" (to restore the images, but not captions, comments, etc)

chris48178

Joined: 2003-05-28
Posts: 66

Posted: Mon, 2005-11-07 15:10

I was able to restore from NTBackup after a couple tries. For anyone else using a similar cofig to mine, I will post the procedure that worked.

I shut down MySql.
I created a new empty folder, and restored the G2Data directory as well as the MySql/Data/Database directory to it.
I renamed the old G2Data directory to G2DataBACKUP, and the obsolete Database Directory to DatabaseBACKUP.
Then copied the restored data to their original directory, verified the gallery had been restored, and deleted the BACKUP files.

Note: for some reason restoring to their original location instead of the New Folder was not working. Don't know why...

Hope this info is usefull to someone.

chris48178 Joined: 2003-05-28 Posts: 66	Posted: Fri, 2005-11-04 16:52
	Gallery version = 2.0 core 1.0.0 PHP version = 4.3.6 apache2handler Webserver = Apache/2.0.49 (Win32) PHP/4.3.6 Database = mysql 4.0.13-max-debug Toolkits = Exif, NetPBM, Gd Operating system = Windows NT APOLLO 5.1 build 2600 Browser = Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322) This morning someone with administrative access to an album, deleted all the contents of that album. What are my options for restoring this data? I am using NTBackup to run daily backups of my WinXP Pro PC. I see a g2data directory with the list of albums, but also my MySQL Data directory which contains a lot of files with MYD and MYI extensions.
	XUser login Username: * Password: * Create new account Request new password
mindless Joined: 2004-01-04 Posts: 8601	Posted: Fri, 2005-11-04 18:10
	you can restore the entire backup (entire g2data and database), or you can get that album dir from your backup, place it somewhere else own your filesystem and add those images again using "add from local server" (to restore the images, but not captions, comments, etc)

chris48178 Joined: 2003-05-28 Posts: 66	Posted: Mon, 2005-11-07 15:10
	I was able to restore from NTBackup after a couple tries. For anyone else using a similar cofig to mine, I will post the procedure that worked. I shut down MySql. I created a new empty folder, and restored the G2Data directory as well as the MySql/Data/Database directory to it. I renamed the old G2Data directory to G2DataBACKUP, and the obsolete Database Directory to DatabaseBACKUP. Then copied the restored data to their original directory, verified the gallery had been restored, and deleted the BACKUP files. Note: for some reason restoring to their original location instead of the New Folder was not working. Don't know why... Hope this info is usefull to someone.

XUser login