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

872 Views

Avatar
steve_nyhof

16 March 2009 at 4:43am (Last edited: 16 March 2009 5:15am), Community Member, 224 Posts

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 - ?!?!