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
