List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:January 10 2000 10:46pm
Subject:Re: what is the best way to do unattended recovery of myisam
tables?
View as plain text  
>>>>> "Bill" == Bill Marrs <bill@stripped> writes:

>> The command is, as I said: cd your_database; myisamchk -fe *.MYI

Bill> -f will restart with -r if it finds there are any errors in the table.  My 
Bill> desire for this recovery to work the first time without a need for someone 
Bill> to re-run it (the --help for -o says "Slower than '-r' but can handle a 
Bill> couple of cases where '-r' reports that it can't fix the data file"), made 
Bill> me think that using -ef might not always fix everything.

Note that it's VERY unlikely that -r shouldn't be able to fix the
error.  The main difference between -r and -ro is that -r needs
disk space to sort indexes and -ro doesn't need this.  -r is also MUCH
faster than -ro.

Bill> Also, why isn't the functionality of -A (auto-increment repair) 
Bill> incorporated into -r and -o?

-A will set the auto_increment value to max(auto_incrmeent_value) +1

If you have deleted rows, this may not be the value you want and
because of this the -A is optional.

-r will however correct auto_increment values that are lower than
  max(auto_increment_value) +1

Regards,
Monty
Thread
what is the best way to do unattended recovery of myisamtables?Bill Marrs9 Jan
  • Re: what is the best way to do unattended recovery of myisamtables?sinisa9 Jan
    • Re: what is the best way to do unattended recovery of myisamtables?Bill Marrs9 Jan
      • Re: what is the best way to do unattended recovery of myisam tables?Tim Bunce10 Jan
        • Re: what is the best way to do unattended recovery of myisam tables?Michael Widenius10 Jan
          • Re: what is the best way to do unattended recovery of myisam tables?Tim Bunce11 Jan
      • Re: what is the best way to do unattended recovery of myisamtables?sinisa10 Jan
        • Re: what is the best way to do unattended recovery of myisamtables?Bill Marrs10 Jan
          • Re: what is the best way to do unattended recovery of myisamtables?sinisa10 Jan
            • Re: what is the best way to do unattended recovery of myisamtables?Bill Marrs10 Jan
              • Re: what is the best way to do unattended recovery of myisamtables?sinisa10 Jan
                • Re: what is the best way to do unattended recovery of myisamtables?Bill Marrs10 Jan
                  • Re: what is the best way to do unattended recovery of myisam tables?Tim Bunce11 Jan
                    • Re: what is the best way to do unattended recovery of myisam tables?Michael Widenius11 Jan
                  • Re: what is the best way to do unattended recovery of myisamtables?Michael Widenius11 Jan
                    • Re: what is the best way to do unattended recovery of myisam tables?jcole11 Jan
      • Re: what is the best way to do unattended recovery of myisamtables?Michael Widenius10 Jan
  • Re: what is the best way to do unattended recovery of myisam tables?apocoliptica10 Jan
    • Re: what is the best way to do unattended recovery of myisamtables?Bill Marrs10 Jan
  • Re: what is the best way to do unattended recovery of myisamtables?Sasha Pachev10 Jan
RE: what is the best way to do unattended recovery of myisam tables?John Foley11 Jan
Re: what is the best way to do unattended recovery of myisam tables?Andy12 Jan
  • Re: what is the best way to do unattended recovery of myisam tables?Michael Widenius12 Jan