Re: Table crashes

2007-10-24 Thread Carlos Proal
The manual is your friend for everything, besides any additional book like Paul Dubois (cool book). But, in order to help you, we need more information about the crash: errors, version, table type, hardware, logs, etc. in that way we can offer solutions to your specific issue. feel free to s

Re: Table crashes

2007-10-24 Thread ranjeet walunj
[EMAIL PROTECTED] wrote: > > Can someone help me out on this..I need a detailed document Dude, you need to be specific. Why tables in MySQL crash is very broad topic. which engine you are referring to ? Tables can crash due to various reasons and they have different recovery/repair procedures. g

RE: Table crashes

2007-10-23 Thread amarnath.shivashankar
Can someone help me out on this..I need a detailed document Regards, Amarnath Shivashankar SQL Database Management | GSMC | Wipro Infotech | Mysore | Toll free: 1800-345-5656 | Spirit of Wipro : Intensity to Win | Act with Sensitivity | Unyielding Integrity F

Re: Table crashes

2003-10-07 Thread Thierno Cissé
Hello, > MyODBC 3.51 is the only way that I access the database. (MyODBC is used in a multithreaded server and in >InternetInformationServer (asp)) >The server is coded in c++ and got a class that acts like a odbc pool (keeps connections open during the lifetime of the server >and handles them to

Re: Table crashes

2003-10-07 Thread Thierno Cissé
Hi, Jonas crashes occurs for some reasons like : - unclean tables ( tables are closed improprely), - hardware problems - something goes wrong in the system - know bugs Check that your tables are clean, before start using them. It seems that you said the REPAIR doesn't occurs after you configuring

Re: Table crashes after optimize

2003-09-25 Thread Antony Dovgal
On Thu, 25 Sep 2003 09:23:13 -0500 Ben Ricker <[EMAIL PROTECTED]> wrote: > Here is the output we got this morning: > > test.MESSAGES optimizeerror 13 when fixing table > test.MESSAGES optimizestatus Operation failed # perror 13 Error code 13: Permission denied check if

Re: Table Crashes Constantly on prod server!!

2001-10-25 Thread joseph . bueno
Heikki Tuuri wrote: > > Hi! > > >Michael Blood wrote: > > > >> I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram. > >> > >> I have been getting an table handler returns error 127 error > >> > >> If I fix the table with myisamchk -r or -o it will work for a while and then > >> I will g

Re: Table Crashes Constantly on prod server!!

2001-10-24 Thread Heikki Tuuri
Hi! >Michael Blood wrote: > >> I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram. >> >> I have been getting an table handler returns error 127 error >> >> If I fix the table with myisamchk -r or -o it will work for a while and then >> I will get the same error again. > >Try dumping and

Re: Table Crashes Constantly on prod server!!

2001-10-24 Thread Bill Adams
Michael Blood wrote: > I am running 3.23.40 on a dual pentium III 800 with 1 GB Ram. > > I have been getting an table handler returns error 127 error > > If I fix the table with myisamchk -r or -o it will work for a while and then > I will get the same error again. Try dumping and restroing the