Duplicate entry for 'x' for key y means that there exists a unique key (key
1) on a certain column that already contains the entry '4'.. You are trying
to insert something with '4' and hence it complains since that key says it
must be unique.
In order to find out what line is #46... its the 46th line from the top of
the file.
ryan
> Hi;
>
> I'm trying to learn MySQL, having some difficulties:
>
> mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)
> for pc-linux-gnu (i686)
>
> Getting the following error:
>
> ERROR 1062 at line 46: Duplicate entry '4' for key 1
>
> What I did was:
>
> mysqldump -u jimjones -p XxXJimmy > lovingdata-Db-test.txt
>
> Deleted all the Db files in /var/lib/mysql/lovingdata
>
> mysql --user=jimjones --password=XxXJimmy lovingdata <
lovingdata-Db-test.txt
>
> So there must be an error in the database. So how do I fix the error?
> How do I figure out which line is #46?
> How do I use the isamchk utility for an entire database, not just tables?
>
> Where is the documentation (besides man pages) for
> mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)
>
> Joe
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
