Jump to content


Photo

Importing DB question


  • Please log in to reply
1 reply to this topic

#1 NeMoD

NeMoD
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 26 September 2006 - 11:11 PM

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

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

heres up to the line, where it errors out

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 )

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

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 27 September 2006 - 06:30 PM

Strange... it all looks fine, maybe just a missing semi-colon between statements.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users