You can use sql statement (not myisamchk) also mysql> REPAIR TABLE tablename
its useful when used with a port forwading script since you will get the status of the table repair, if error is detected just have the script execute: iptables -A PREROUTING -d this_machine_ip -p tcp -m tcp --dport 3306 -j DNAT --to-destination backup_machine:3306 and make sure to issue FLUSH TABLES after REPAIR On 2/12/07, Ariz Jacinto <[EMAIL PROTECTED]> wrote:
UPS is one thing, you should also have a power generator or at least a script that will read the SNMP (battery status) of the UPS so that the server may perform an auto shutdown if the battery level is critical (a good stuff when those machines are mostly unattended). On 2/10/07, Roberto Verzola <[EMAIL PROTECTED]> wrote: > On Sunday 11 February 2007 1:11 pm, Orlando Andico wrote: > > The more sinister part of this is, the repair method sometimes loses rows. > > :P But then you'll never know. But it happened to me before, with rather > > ill results. > > Yes, I can imagine that can happen, if power is lost while files are open. A > reliable UPS would be one solution. Or are you driving at an even better > solution? |-) > > Obet > _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
-- -- MSG GODIE <YOUR MESSAGE> then send to 2948 for Globe/Sun and 3940 for Smart. Get yours at www.TxtDomain.com -- Roger P. Filomeno Mobile Specialist / R&D Finger Apps Inc, http://fingerapps.com Blog: http://corruptedpartition.blogspot.com/
_________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
