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