Hi people, Would anyone be able to explain to me why the 'myisamchk' tool damages my tables in mysql. It is supposed to fix any inconsistancies but it actually makes the tables worse. example: first i use myisamchk --check on my tables, then i use myisamchk -r to repair any tables that are no good (keep in mind all the front end programs to these databases work fine before hand). i dont get any errors from myisamchk so i'm assuming it repaired the tables. I start my applications and i find that some of my tables dont have anything in them, some have jumbled data, etc
thats problem number 1...now for number 2 Luckily i run a backup of these databases every 45 minutes so i have a nice recent copy of the database that was made worse. 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.. can anyone suggest a way for me to get the databack in the database, and suggest a way to fix table problems with out making it worse, and suggest a better way to backup my databases....at the moment i use mysqldump.... thanx very much. -- SLUG - Sydney Linux User's Group - http://slug.org.au/ More Info: http://lists.slug.org.au/listinfo/slug
