I have a database backup file (.tar) that I made on my previous version of gallery 2 and i want to install it on my new version. Im sure this is pretty easy but I cant find any way to do this....Thanks in advance for your help.
chris
Gallery URL = http://www.photobychris.com/gallery2/main.php
Gallery version = 2.3.2 core 1.3.0.2
API = Core 7.54, Module 3.9, Theme 2.6, Embed 1.5
PHP version = 5.3.15 cgi-fcgi
Webserver = Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/1.0.0-fips mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635 mod_fcgid/2.3.6
Database = mysqli 5.1.63-cll, lock.system=flock
Toolkits =
Acceleration = none, none
Operating system = Linux bastet.lunarservers.com 2.6.32-320.17.1.lve1.1.7.3.el6.x86_64 #1 SMP Mon Jul 2 10:46:27 EDT 2012 x86_64
Default theme = matrix
gettext = enabled
Locale = en_US
Browser = Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.89 Safari/537.1
Rows in GalleryAccessMap table = 12
Rows in GalleryAccessSubscriberMap table = 1
Rows in GalleryUser table = 2
Rows in GalleryItem table = 1
Rows in GalleryAlbumItem table = 1
Rows in GalleryCacheMap table = 0
Posted: Wed, 2012-09-19 15:56
Posts: 8339
you'll need to use a tool like phpMyAdmin or similar.
These tools are common in cpanel or plesk or whatever your host provides for you.
You'll want to drop any existing gallery2 tables and replace w/ your backup. There is no way to merge.
-s
All New jQuery Minislideshow for G2/G3
Posts: 23
so phpadmin will inport my .tar file into my new database?
Thanks for the quick reply
chris
Posts: 8339
yes
-s
All New jQuery Minislideshow for G2/G3
Posts: 23
so there is no tool on gallery 2 to install the database backup back into gallery 2?
Posts: 8339
gallery did not create the tar file gallery creates an xml file, so no.
-s
All New jQuery Minislideshow for G2/G3
Posts: 23
so when you back up the data base through the gallery it creates a xml file? Can that file be restored backing into gallery 2 by a plugin or something in gallery 2?
Posts: 8339
gallery performs a DB backup when you upgrade, or manually through gallery admin -> maintenance -> Backup database
backups are stored in g2data/backups
naming convention: database_name_date.xml
These can be restored by placing your backup.xml in g2data/backups and pointing your browser to yoursite.com/gallery2/lib/support
-s
All New jQuery Minislideshow for G2/G3
Posts: 23
where are the actual image files
located in gallery2 ?
Posts: 8339
g2data/albums
-s
All New jQuery Minislideshow for G2/G3