Re: corrupted tables

2007-03-19 Thread Steve Musumeche
How about your disk space? I had a similar problem on a large table and it ended up being caused by filling up the disk. Steve Musumeche CIO, Internet Retail Connection [EMAIL PROTECTED] Octavian Rasnita wrote: From: "Steve Edberg" <[EMAIL PROTECTED]> Sometimes I see that some tables from m

Re: corrupted tables

2007-03-16 Thread Octavian Rasnita
From: "Steve Edberg" <[EMAIL PROTECTED]> Sometimes I see that some tables from my database get corrupted. Why does this happpen and how can I avoid it? It is not hard to go and use "repair table" but it seems that in this way some records could be deleted and this is not ok. If I want to have a

Re: corrupted tables

2007-03-16 Thread Steve Edberg
At 6:56 PM +0200 3/16/07, Octavian Rasnita wrote: Hi, Sometimes I see that some tables from my database get corrupted. Why does this happpen and how can I avoid it? It is not hard to go and use "repair table" but it seems that in this way some records could be deleted and this is not ok. If I

Re: corrupted tables

2007-03-16 Thread John Nichel
Octavian Rasnita wrote: Hi, Sometimes I see that some tables from my database get corrupted. Why does this happpen and how can I avoid it? It is not hard to go and use "repair table" but it seems that in this way some records could be deleted and this is not ok. If I want to have a very secure

Re: Corrupted tables -- for 'no apparent' reason

2001-09-07 Thread Adams, Bill TQO
Mark Papadakis wrote: > We are using mySQL on over 6 servers here, we have been doing so for over 2 years, >and we are constaly facing problems with corrupted tables, especially on two of our >busiest servers. > Tables seem to corrupt out of the blue and we have to shut them down ( the servers

Re: Corrupted tables -- for 'no apparent' reason

2001-09-07 Thread Jeremy Zawodny
On Fri, Sep 07, 2001 at 10:29:31AM +0300, Mark Papadakis wrote: > Hello, > > We are using mySQL on over 6 servers here, we have been doing so for > over 2 years, and we are constaly facing problems with corrupted > tables, especially on two of our busiest servers. Tables seem to > corrupt out of

Re: Corrupted tables

2001-01-24 Thread Mikel King
I've had some db corruption on a few occasions, and luckily I was running the following in a nightly cron...it has since first install saved my butt on many an occasion. http://www.ocsny.com/main/index.ocs?url=mysqlbackup It doesn't do anything magickal just uses mysqldump and a basic routine to a

Re: Corrupted tables

2001-01-24 Thread Joseph Bueno
"Kissandrakis S. George" wrote : > > Hello > > I have mysql 3.23.31 on x86 linux > Some big tables .ISM get corrupted without any crash or shutdown of > mysqld > Any suggestions? > > -- > Kissandrakis S. George [[EMAIL PROTECTED]] > Network and System Administrator [http:/