Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Import SQL data problems


Reply


899 Views

Avatar
steve_nyhof

Community Member, 224 Posts

16 March 2009 at 4:43am

Edited: 16/03/2009 5:15am

Hi All,

I have been successful on this several times, but I have also not been successful at importing the sql file into another site to duplicate sites - then just make a few changes.

Does anyone have a "best" way to export (phpmyadmin options???)
Then import without issues. I have the same server, nothing different going on. I tried Insert/Update/Replace options, but even when I did not get an error, nothing was added to the new site.
Also, I thought an INSERT would add what ever columns missing??
This is the error I get...
.
.
.
Error
SQL query:

--
-- Dumping data for table `Group`
--
INSERT IGNORE INTO `Group` ( `ID` , `ClassName` , `Created` , `LastEdited` , `Title` , `Description` , `Code` , `CanCMS` , `CanCMSAdmin` , `Locked` , `Sort` , `ParentID` , `IPRestrictions` )
VALUES ( 1, 'Group', '2008-08-29 16:20:09', '2008-08-29 16:20:09', 'Administrators', NULL , 'administrators', 0, 0, 0, 0, 0, NULL ) , ( 2, 'Group', '2008-12-14 17:10:03', '2008-12-14 17:10:31', 'Mailing List: Websites', NULL , 'websites', 0, 0, 0, 0, 0, NULL ) ;

MySQL said:

#1054 - Unknown column 'IPRestrictions' in 'field list'

----

I also get this...
.
.
.
Error
SQL query:

--
-- Dumping data for table `ArchiveWidget`
--
INSERT INTO `ArchiveWidget` ( `ID` , `DisplayMode` )
VALUES ( 3, 'month' ) , ( 6, 'month' ) ;

MySQL said:

#1062 - Duplicate entry '3' for key 1

----------------
No mater what I try I get errors, over and over. I have in the past imported, and all worked perfect - ?!?!