Jump to content

Importing DB question


NeMoD

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
Link to comment
https://forums.phpfreaks.com/topic/22180-importing-db-question/
Share on other sites

Archived

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

×
×
  • Create New...

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.