Hi Friends,



I need a document on why tables crash in MYSQL and what are the repair
methods?

I would also like to know if there are any preventive measures to avoid
table crashes?



Regards,
Amarnath Shivashankar
SQL Database Management






The information contained in this electronic message and any attachments tothis message are intended for the exclusive use of the addressee(s) andmay contain proprietary, confidential or privileged information. If youare not the intended recipient, you should not disseminate, distribute orcopy this e-mail. Please notify the sender immediately and destroy allcopies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipientshould check this email and any attachments for the presence of viruses.The company accepts no liability for any damage caused by any virustransmitted by this email.

www.wipro.com

Can someone 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

________________________________

From: Amarnath Shivashankar (WI01 - Services)
Sent: Tuesday, October 23, 2007 11:40 AM
To: 'mysql@lists.mysql.com'
Subject: Table crashes



Hi Friends,



I need a document on why tables crash in MYSQL and what are the repair
methods?

I would also like to know if there are any preventive measures to avoid
table crashes?



Regards,
Amarnath Shivashankar
SQL Database Management






The information contained in this electronic message and any attachments tothis message are intended for the exclusive use of the addressee(s) andmay contain proprietary, confidential or privileged information. If youare not the intended recipient, you should not disseminate, distribute orcopy this e-mail. Please notify the sender immediately and destroy allcopies of this message and any attachments.

WARNING: Computer viruses can be transmitted via email. The recipientshould check this email and any attachments for the presence of viruses.The company accepts no liability for any damage caused by any virustransmitted by this email.

www.wipro.com

amarnath.shivashankar@wipro.com wrote:
>
> Can someone 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.

good application + DB design/descent HW sizing and great monitoring
will reduce the crashes ....

If you do some more research on this topic you can figure out some
reasons and some pointers to avoid failures.

Regards,
Ranjeet Walunj







>
> Hi Friends,
>
>
>
> I need a document on why tables crash in MYSQL and what are the repair
> methods?
>
> I would also like to know if there are any preventive measures to avoid
> table crashes?
>
>
>
> Regards,
> Amarnath Shivashankar
> SQL Database Management
>
>
>
>
>
>
> The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
>
> www.wipro.com

this has been a problem to me from mysql 3.1 version
now in 4.1 also the same problem
during the instant configuration wizard the last screen which has start
service does not turn green and mysql doesnt start ive tried removing mysql
and reinstalling
does this problem has anything to do with port or what is it
please ?

rao

The manual is your friend for everything, besides any additional book
like Paul Dubois (cool book).

But, in order to 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
send us more details and we'll be happy to .

Carlos

amarnath.shivashankar@wipro.com wrote:
> Can someone 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
>
> ________________________________
>
> From: Amarnath Shivashankar (WI01 - Services)
> Sent: Tuesday, October 23, 2007 11:40 AM
> To: 'mysql@lists.mysql.com'
> Subject: Table crashes
>
>
>
> Hi Friends,
>
>
>
> I need a document on why tables crash in MYSQL and what are the repair
> methods?
>
> I would also like to know if there are any preventive measures to avoid
> table crashes?
>
>
>
> Regards,
> Amarnath Shivashankar
> SQL Database Management
>
>
>
>
>
>
> The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments.
>
> WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.
>
> www.wipro.com
>