[joomla] ERROR 1062 (23000) at line 3472: Duplicate entry ... for key 'idx_link_old'
David Roth
davidalanroth at gmail.com
Sat Jul 21 23:13:06 EDT 2012
Hi Scott.
Thanks! I got it working now.
Best regards,
David
On Sat, Jul 21, 2012 at 10:47 PM, Scott Wolpow <scott at wolpow.com> wrote:
> Try using the custom for export.
> Then create a new blank db, import into that,then switch dbs.
>
> SW
>
> On 7/21/2012 10:34 PM, David Roth wrote:
>
> I have phpMyAdmin installed. What do I look for in the add/delete tables?
> What might be out of place? Thanks!
>
> David
>
> On Sat, Jul 21, 2012 at 10:31 PM, Scott Wolpow <scott at wolpow.com> wrote:
>
>> Are using phpMyAdmin or cli?
>> Check add/delete tables if using phpMyAdmin
>>
>> SW
>>
>> On 7/21/2012 10: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 <contact at 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 Listhttp://lists.nyphp.org/mailman/listinfo/joomla
>>
>> NYPHPCon 2006 Presentations Onlinehttp://www.nyphpcon.com
>>
>> Show Your Participation in New York PHPhttp://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 Listhttp://lists.nyphp.org/mailman/listinfo/joomla
>
> NYPHPCon 2006 Presentations Onlinehttp://www.nyphpcon.com
>
> Show Your Participation in New York PHPhttp://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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/joomla/attachments/20120721/52b8b72d/attachment.html>
More information about the Joomla
mailing list