No idea why it is happening, but it has to do with #__redirect_links if you not making heavy use of that you should be totally fine forcing the import.
Here is a reference to it http://phpcrossref.com/joomla/installation/sql/sqlazure/joomla.sql.html SET QUOTED_IDENTIFIER ON; 1208 1209 IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[#__redirect_links]') AND type in (N'U')) 1210 BEGIN 1211 CREATE TABLE [#__redirect_links]( 1212 [id] [bigint] IDENTITY(1,1) NOT NULL, 1213 [old_url] [nvarchar](255) NOT NULL, 1214 [new_url] [nvarchar](255) NOT NULL, 1215 [referer] [nvarchar](150) NOT NULL, 1216 [comment] [nvarchar](255) NOT NULL, 1217 [hits] [bigint] NOT NULL, 1218 [published] [smallint] NOT NULL, 1219 [created_date] [datetime] NOT NULL, 1220 [modified_date] [datetime] NOT NULL, 1221 CONSTRAINT [PK_#__redirect_links_id] PRIMARY KEY CLUSTERED 1222 ( 1223 [id] ASC 1224 )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF), 1225 CONSTRAINT [#__redirect_links$idx_link_old] UNIQUE NONCLUSTERED 1226 ( 1227 [old_url] ASC 1228 )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) 1229 ) 1230 END; 1231 1232 IF NOT EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[#__redirect_links]') AND name = N'idx_link_modifed') 1233 CREATE NONCLUSTERED INDEX [idx_link_modifed] ON [#__redirect_links] 1234 ( 1235 [modified_date] ASC 1236 )WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF); 1237 On Jul 21, 2012, at 7:26 PM, David Roth wrote: > Thanks, Chris for the reply. > > I've never had to use those options on MySQL before. I will give it a try. > Any idea what this error message is all about? Thanks! > > David Roth > > On Sat, Jul 21, 2012 at 9:52 PM, Chris French <cont...@chrisfrench.me> wrote: > That is weird, > > if you are using the command line just ad -f or --force to your import and > it should continue passed it and your install will probably be fine. > > > > > On Jul 21, 2012, at 6:44 PM, David Roth wrote: > > > I did a MySQL dump of a Joomla 2.5.6 website to publish it in another > > directory. When I went to load the MySQL database from the edited *.sql > > file for the new installation I got this error message from the mysql > > command: > > > > ERROR 1062 (23000) at line 3472: Duplicate entry ... for key 'idx_link_old' > > > > I never saw this before. Any suggestions what to do about it? Thanks for > > any insight! > > > > David Roth > > > > > > _______________________________________________ > > New York PHP SIG: Joomla! Mailing List > > http://lists.nyphp.org/mailman/listinfo/joomla > > > > NYPHPCon 2006 Presentations Online > > http://www.nyphpcon.com > > > > Show Your Participation in New York PHP > > http://www.nyphp.org/show_participation.php > > _______________________________________________ > New York PHP SIG: Joomla! Mailing List > http://lists.nyphp.org/mailman/listinfo/joomla > > NYPHPCon 2006 Presentations Online > http://www.nyphpcon.com > > Show Your Participation in New York PHP > http://www.nyphp.org/show_participation.php > > _______________________________________________ > New York PHP SIG: Joomla! Mailing List > http://lists.nyphp.org/mailman/listinfo/joomla > > NYPHPCon 2006 Presentations Online > http://www.nyphpcon.com > > Show Your Participation in New York PHP > http://www.nyphp.org/show_participation.php
_______________________________________________ New York PHP SIG: Joomla! Mailing List http://lists.nyphp.org/mailman/listinfo/joomla NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
