NeMoD Posted September 26, 2006 Share Posted September 26, 2006 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 triedimporting 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 appreciatedI'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 More sharing options...
fenway Posted September 27, 2006 Share Posted September 27, 2006 Strange... it all looks fine, maybe just a missing semi-colon between statements. Link to comment https://forums.phpfreaks.com/topic/22180-importing-db-question/#findComment-99744 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.