Exporting images and metadata

JanP

Joined: 2005-10-05
Posts: 34
Posted: Tue, 2009-10-20 14:25

I want to migrate my photo's from one gallery2 installation to another. Sadly, due to circumstances I'm not able to simply copy the entire database, I need just the images. Ofcourse I've already downloaded the g2data/albums directory, so basically all I need is the SQL data for the images. Sadly, I'm unfamiliar with G2's database structure and I have no clue which tables I'd need. The reason I don't want to simply add those photo's again in my new gallery installation is that there's lots and lots of metadata like captions and descriptions, that would take many hours to add.


Gallery version = 2.3 core 1.3.0
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.2.10 cgi
Webserver = Apache/2.2.13 (Unix) mod_ssl/2.2.13 OpenSSL/0.9.8e-fips-rhel5 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
Database = mysql 4.1.22-standard-log, lock.system=database
Toolkits = ArchiveUpload, Exif, Gd, LinkItemToolkit
Acceleration = none, none
Operating system = Linux 2.6.27.10-JS-grsec
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows; U; Windows NT 5.1; nl; rv:1.9.1.3) Gecko/20090824 Firefox/3.5.3 (.NET CLR 3.5.30729)
 
nivekiam
nivekiam's picture

Joined: 2002-12-10
Posts: 16501
Posted: Tue, 2009-10-20 16:36

If you're not able to copy the entire database, how are you going to get the sql data out?

Why can't you follow this guide?

FAQ: How can I move my gallery installation from one server to another?
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
 
JanP

Joined: 2005-10-05
Posts: 34
Posted: Tue, 2009-10-20 19:51

Because the database also contains a lot of infomation that I do not want; it's an embedded install that's not functioning properly.