NYCPHP Meetup

[Scott Wolpow]

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 
> <mailto: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 <mailto: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 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/joomla/attachments/20120721/8da94bce/attachment.html>