MySQL possible problems

[codewrecker]

I hear from time to time people report that they have problems and have to "re-build" their data bases. I am new to MySQL and php but plan to build a fairly elaborate site build on these two technologies. I'm just afraid once built I could experience major unforseen problems??

Just for my information what are some of the major things that could go wrong with a databases (MySQL specifically) I guess what I'm trying to do is anticipate possible problems then maybe read up on it ahead of time just in case.

I hope this questions doesn't sound too stupid or general.

[samsm]

I was curious about this topic and found this link:

4.4 Disaster Prevention and Recovery
http://www.mysql.com/documentation/m...ter_Prevention

[codewrecker]

I should have thought to look there. Thanks for the link...good info!

[samsm]

Some printed info I have on the topic suggests using the utility myisamchk on various data files in the event of trouble. Thing is you shouldn't have mysql running while you use it.

Anyway, it's in the same chapter of mySQL documentation...
4.8.4 Using mysqlcheck for Table Maintenance and Crash Recovery
http://www.mysql.com/doc/U/s/Using_mysqlcheck.html

<edit> I got twisted up with that link... there really isn't much info about myisamchk there but there is info about mysqlcheck which actually souds more helpful.