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 related variables in the my.cnf file ? Because the daemon will not start when the my.cnf contains any errors (variable names), the format is to be correct. Can you indicates what MySQL version you run and your OS version. Regards Thierno6C - MySQL 4.0.15 ----- Original Message ----- From: "Datatal AB - Gauffin, Jonas" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 07, 2003 7:05 AM Subject: Table crashes Hello Some one my tables have crashed (again). I had to repair them ASAP since the db is in my production enviroment. 1. How can I find the cause of the crashes? 2. I've created a my.cnf and added the following lines. Is the format correct? [mysqld] set-variable = myisam-recover=BACKUP,FORCE set-variable = myisam_sort_buffer_size=4M I need to get this going without getting crashes every week, please help. /Jonas -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
