On Sat, 2002-07-13 at 04:50, Chris Barnes wrote: > i use mysql --user=whoever --password=whatever --host=whereever < > dabase_backup.txt > all is well so it seems but its actually not...i keep getting the error > "Error 1062 at line 3: Duplicate entry '1' for key 1 > > so i use the --force argument with the command i issued above but it reports > the same thing.. > No idea why myisamchk isn't working (not that I have ever used it), the error you are getting about duplicate entries is because you are try to load the data back into a table that has a unique key, and you can't have two entries with the same key value.
If you are sure your backup is good, just delete * from table_name then try to reload it. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
