Use DB replications then make a port forwading script to switch from primary to slaves.
On 2/10/07, Orlando Andico <[EMAIL PROTECTED]> wrote:
welcome to the craptacular world of MySQL :P yes, power interruptions can do that. try an isamchk or myisamchk that usually can recover something from the crap that MySQL leaves behind... On 2/10/07, Roberto Verzola <[EMAIL PROTECTED]> wrote: > error : Can't open file: 'phones.MYI' (errno: 145) > nocheats.provinces Table is already up to date > nocheats.queue Table is already up to date > nocheats.reports > error : Can't open file: 'reports.MYI' (errno: 145) > nocheats.results Table is already up to date > nocheats.towns Table is already up to date > nocheats.unconfirmed > error : Can't open file: 'unconfirmed.MYI' (errno: 145) > > > So the above .MYI files were really corrupted. > > I really would like to know how the files were corrupted. The top suspect > seems to be the power outage. I just want to make sure I didn't miss > anything. _________________________________________________ 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
