Jump to content

Archived

This topic is now archived and is closed to further replies.

NeMoD

Importing DB question

Recommended Posts

I had a coppermine photo gallery, installed a year ago, before I got rid of my site I backed up all the files and the db.
Now I have a new site and would like to import it, I copied over the files, pointed the config to the newly created db, and tried
importing the old db into the new one, but I keep getting this error

[code]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]

heres up to the line, where it errors out

[code] 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 ) [/code]

any help is appreciated
I'm positive I'm using mysql5 for my new host, my old host had 4.1.18

Share this post


Link to post
Share on other sites
Strange... it all looks fine, maybe just a missing semi-colon between statements.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.