It is a bit hidden in "graphics opackage" /admin/plugins/mediagallery/cfgedit.php
OK..
In phpMyAdmin I check marked all the tables that start with gl_mg_ and in Export block I highlighted all gl_mg_ ,I check marked to select "SQL" and I clicked on "Go".
Then huge tekst dokument "phpMyAdmin SQL Dump"showed up .
This is copy of one small part of this document:
-- phpMyAdmin SQL Dump
-- version 2.10.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 20, 2007 at 10:17 PM
-- Server version: 4.1.22
-- PHP Version: 4.4.2
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `nine_gklg3`
--
-- --------------------------------------------------------
--
-- Table structure for table `gl_mg_albums`
--
CREATE TABLE `gl_mg_albums` (
`album_id` int(11) NOT NULL default '0',
`album_title` varchar(255) NOT NULL default '',
`album_desc` text NOT NULL,
`album_parent` int(11) NOT NULL default '0',
`album_order` int(11) NOT NULL default '0',
`album_cover` varchar(40) NOT NULL default '-1',
`album_cover_filename` varchar(255) default '',
`media_count` int(11) unsigned NOT NULL default '0',
`last_update` int(11) NOT NULL default '0',
`enable_comments` tinyint(4) NOT NULL default '0',
`exif_display` tinyint(4) NOT NULL default '0',
`enable_rating` tinyint(4) NOT NULL default '0',
`playback_type` tinyint(4) NOT NULL default '0',
`tn_attached` tinyint(4) NOT NULL default '0',
`enable_slideshow` tinyint(4) NOT NULL default '0',
`enable_random` tinyint(4) NOT NULL default '0',
`enable_shutterfly` tinyint(4) NOT NULL default '0',
`enable_views` tinyint(4) NOT NULL default '0',
`enable_sort` tinyint(4) NOT NULL default '0',
`albums_first` tinyint(4) NOT NULL default '1',
`full_display` tinyint(4) NOT NULL default '0',
`tn_size` tinyint(4) NOT NULL default '0',
`display_rows` tinyint(4) NOT NULL default '3',
`display_columns` tinyint(4) NOT NULL default '3',
`member_uploads` tinyint(4) NOT NULL default '0',
`moderate` tinyint(4) NOT NULL default '0',
`email_mod` tinyint(4) NOT NULL default '0',
`featured` tinyint(4) NOT NULL default '0',
`cbposition` tinyint(1) NOT NULL default '0',
`cbpage` varchar(20) NOT NULL default '',
`owner_id` mediumint(9) NOT NULL default '0',
`group_id` mediumint(9) NOT NULL default '0',
`mod_group_id` mediumint(9) NOT NULL default '0',
`perm_owner` tinyint(1) unsigned NOT NULL default '0',
`perm_group` tinyint(1) unsigned NOT NULL default '0',
`perm_members` tinyint(1) unsigned NOT NULL default '0',
`perm_anon` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`album_id`),
KEY `album_parent` (`album_parent`),
KEY `last_update` (`last_update`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;
--
-- Dumping data for table `gl_mg_albums`
--
INSERT INTO `gl_mg_albums` VALUES (1, 'Syracuse', , 0, 10, '-1', '5491734814897f0176f821d0bc992176', 230, 1182686119, 1, 0, 1, 2, 0, 1, 1, 1, 1, 1, 1, 0, 1, 3, 3, 1, 0, 1, 0, 1, 'all', 2, 26, 26, 3, 3, 2, 0);
INSERT INTO `gl_mg_albums` VALUES (2, ' America', '', 0, 11, '-1', '89c6e9769462f60cc7f58e8f2803c2c8', 187, 1182379266, 1, 0, 1, 2, 0, 1, 1, 1, 1, 1, 1, 0, 1, 3, 3, 1, 0, 1, 0, 1, 'all', 2, 26, 26, 3, 3, 2, 0);
INSERT INTO `gl_mg_albums` VALUES (61, 'Norvegen', '', 0, 70, '-1', '77c761d8134c470c4bd344423cd389ad', 9, 1175927623, 1, 0, 1, 2, 0, 1, 1, 1, 1, 1, 1, 0, 1, 3, 3, 1, 0, 1, 0, 1, 'all', 35, 26, 26, 3, 3, 2, 0);
INSERT INTO `gl_mg_albums` VALUES (62, 'Attention', '', 0, 71, '-1', 'df82d7764aa7b3582e1c52bb483bfde4', 1, 1158536245, 1, 0, 1, 2, 0, 1, 1, 1, 1, 1, 1, 0, 1, 3, 3, 1, 0, 1, 0, 1, 'all', 35, 17, 26, 3, 3, 2, 2);
INSERT INTO `gl_mg_albums` VALUES (63, 'Friends', 0, 72, '-1', '01cf2363a470b495dca1be9207cb2915', 31, 1176016784, 1, 0, 1, 2, 0, 1, 1, 1, 1, 1, 1, 0, 1, 3, 3, 1, 0, 1, 0, 1, 'all', 35, 26, 26, 3, 3, 2, 0);
INSERT INTO `gl_mg_albums` VALUES (64, 'Family', 0, 73, '-1', '184df115a4908900fb4782138ebda1fb', 8, 1163910905, 1, 0, 1, 2, 0, 1, 1, 1, 1, 1, 1, 0, 1, 3, 3, 1, 0, 1, 0, 1, 'all', 35, 26, 26, 3, 3, 2, 0);
INSERT INTO `gl_mg_albums` VALUES (67, 'Richy', 0, 76, '-1', 'd7cc3d730df0a0aa0ed2d36c80f057a4', 1, 1173278937, 1, 0, 1, 2, 0, 1, 1, 1, 1, 1, 1, 0, 1, 3, 3, 1, 0, 0, 0, 1, 'all', 35, 26, 26, 3, 2, 2, 0);
INSERT INTO `gl_mg_albums` VALUES (66, 'Pets.', 0, 75, '-1', '75d5f9d0e9350e2c47dcdaa2ac05ff21', 1, 1172515833, 1, 0, 1, 2, 0, 1, 1, 1, 1, 1, 1, 0, 1, 3, 3, 0, 0, 0, 0, 1, 'all', 35, 26, 26, 3, 2, 2, 2);
INSERT INTO `gl_mg_albums` VALUES (65, 'Greetings', 0, 74, '-1', 'f71a196d676cefb14085c1d6a994b608', 2, 1167082101, 1, 0, 1, 2, 0, 1, 1, 1, 1, 1, 1, 0, 1, 3, 3, 1, 0, 0, 0, 1, 'all', 35, 26, 26, 3, 2, 2, 0);
INSERT INTO `gl_mg_albums` VALUES (30, 'Australia', '', 0, 39, '-1', '', 0, 0, 1, 0, 1, 2, 0, 1, 1, 1, 1, 1, 1, 0, 1, 3, 3, 1, 0, 1, 0, 1, 'all', 2, 26, 26, 3, 3, 2, 0);
INSERT INTO `gl_mg_albums` VALUES (31, 'Austria', '', 0, 40, '-1', 'bdf9f1cbdfb7f0e73a5f455a60d8effe', 17, 1176668827, 1, 0, 1, 2, 0, 1, 1, 1, 1, 1, 1, 0, 1, 3, 3, 1, 0, 1, 0, 1, 'all', 2, 26, 26, 3, 3, 2, 0);
Now...I don't know how to import this stuff in my new website. :banghead:
Great! The division by zero error is probably caused by missing thumbnail images. You might double check that everything FTP'ed over OK.
Version 1.2.6 of Media Gallery is actually pretty old. We are up to v1.5.0 now. You might want to consider upgrading, if you are up to that challenge (actually it is pretty simple). The later releases do a much better job of dealing with missing images, instead of erroring out, it will simply show a generic missing thumbnail. There are several other improvements and enhancements as well too.
Thanks!
Mark
No i dont think that you can directly move files from one place to another. You will have to carry out a freash installation of geeklog software to the desired place i think so.. Please correct me if i am wrong.