Source:http://dev.mysql.com/doc/refman/4.1/en/mysqlcheck.html
The mysqlcheck client checks, repairs, optimizes, and analyzes tables. mysqlcheck is available as of MySQL 3.23.38.
mysqlcheck is similar in function to myisamchk, but works differently. The main operational difference is that mysqlcheck must be used when the mysqld server is running, whereas myisamchk should be used when it is not. The benefit of using [...]
MYSQL
Source: http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html
If there is database page corruption, you may want to dump your tables from the database with SELECT INTO … OUTFILE. Usually, most of the data obtained in this way is intact. However, it is possible that the corruption might cause SELECT * FROM tbl_name statements or InnoDB background operations to crash or assert, [...]
MYSQL
Source: http://dev.mysql.com/doc/refman/5.1/en/repair.html
The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD).
You can also (and should, if possible) use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. See Section 12.5.2.3, “CHECK TABLE Syntax”, and Section 12.5.2.6, “REPAIR TABLE Syntax”.
Symptoms of corrupted tables [...]
How To, MYSQL, Repair
Source: http://www.v-nessa.net/2007/07/20/upgrading-to-mysql-5120-on-cpanel
If you have server that run on cPanel, you’ll probably know how big of a Nazi it is in regards to the MySQL versions it can run. We just got this new line of servers at work and one of them I was pretty heartset on installing MySQL 5.1, mainly because of its loadable [...]
Cpanel, MYSQL, Upgrade
Source : http://www.ducea.com/2006/07/16/cpanel-upgrading-to-mysql5/
CPanel has included support for MySQL 5 in all its latest releases – 10.8.2-xxx – (Stable/Release/Current). I find this very cool and it is a big difference in trying to get MySQL4 to run on Plesk for example. Anyway the upgrade process is very simple, and probably no one will need any additional [...]
Cpanel, MYSQL, Upgrade
Source: http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1130131,00.html
If a company is running MySQL 4 now and is happy with it, shouldn’t it stick with that version? Yes and no, says Mike Hillyer, this site’s resident MySQL expert. In this tip, he discusses when and why MySQL users should upgrade, the benefits of MySQL’s new features, and how to evaluate and deploy [...]
Article, MYSQL, Upgrade
Source: http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
Note
It is good practice to back up your data before installing any new version of software. Although MySQL works very hard to ensure a high level of quality, you should protect your data by making a backup. MySQL recommends that you dump and reload your tables from any previous version to upgrade to 5.0. [...]
MYSQL, Upgrade