Importing question

[NeMoD]

I had a gallery, over a year ago, at which I would like to use again.

for the gallery, i have the whole directory, with all the files, and the mysqldb file, with all the info, how would I do this?
I know how to import db's thru phpmyadmin, but I'm not sure where to start, should I copy over the files
from the gallery, to the ftp, make a new db, then import the mysql db to it?

[Sami]

yes, and after that edit your include/config.inc.php and put the new db info ...
Don't forget to update it to the most recent version (currently 1.4.9)

[NeMoD]

 I keep getting this error

Code Select Expand

MySQL said: Documentation
#1064 - You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `cpg133_albums` VALUES (1, 'IG Community', 'Click h

Code Select Expand

SQL query:

--
-- Table structure for table `cpg133_albums`
--
CREATE TABLE `cpg133_albums` (
`aid` int( 11 ) NOT NULL AUTO_INCREMENT ,
`title` varchar( 255 ) NOT NULL default '',
`description` text NOT NULL ,
`visibility` int( 11 ) NOT NULL default '0',
`uploads` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`comments` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`votes` enum( 'YES', 'NO' ) NOT NULL default 'YES',
`pos` int( 11 ) NOT NULL default '0',
`category` int( 11 ) NOT NULL default '0',
`pic_count` int( 11 ) NOT NULL default '0',
`thumb` int( 11 ) NOT NULL default '0',
`last_addition` datetime NOT NULL default '0000-00-00 00:00:00',
`stat_uptodate` enum( 'YES', 'NO' ) NOT NULL default 'NO',
`keyword` varchar( 50 ) default NULL ,
PRIMARY KEY ( `aid` ) ,
KEY `alb_category` ( `category` )
)--
-- Dumping data for table `cpg133_albums`
--
INSERT INTO `cpg133_albums`
VALUES ( 1, 'IG Community', 'Click here for pictures of some active (and inactive) unreal instagib players.', 0, 'YES', 'YES', 'YES', 100, 0, 0, 0, '0000-00-00 00:00:00', 'NO', NULL )


ah I just noticed this isn't 1.4 sorry if it's in the wrong category :O

[Joachim Müller]

Don't try to import your old mySQL data from cpg1.3.x into a fresh cpg1.4.x database - this will not work. Upgrade exactly as suggested in the docs.