[SLUG] MySQL problems

2002-07-12 Thread Chris Barnes
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

Re: [SLUG] MySQL problems

2002-07-12 Thread Malcolm V
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 argume

Re: [SLUG] MySQL problems

2002-07-12 Thread James Gregory
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 > > I suspect this is actually the problem with isamchk as we

RE: [SLUG] MySQL problems

2002-07-12 Thread Chris Barnes
s for your help. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Malcolm V Sent: Saturday, 13 July 2002 12:59 PM To: Sydney Linux Users Group Mailing List Subject: Re: [SLUG] MySQL problems On Sat, 2002-07-13 at 04:50, Chris Barnes wrote: > i use mysql --user=