Web hosting control panel - 354 Part III . Administration The final main
354 Part III . Administration The final main function with mysqlcheck is to repair the table. This function is called with the -r or –repairoption. The repair function can fix most any problem with a table. However, the repair function can sometimes lose data; therefore I ll stress again to make sure you have backups. If mysqlcheck reports an error and you re going to repair it, it is always a good idea to check the integrity of your backups before proceeding. Figure 13-25 shows an example of mysqlcheck repairing a table. (Note that I purposely corrupted the table for this example.) Figure 13-25: Using mysqlcheck to repair a corrupt table When you use the main (default) option to check databases and tables with which mysqlcheck, you have several levels or degrees at which to examine the table(s) for errors: Command Function -c or –check The default option; checks all tables. -C or –check-only-changed Checks only tables that have changed since the last check. -F or –fast Looks for and examines tables that weren t closed properly. -q or –quick Does not check row-level objects. -m or –medium-check -e or –extended If you want for mysqlcheck to automatically repair any errors it finds, add the -auto- repair switch. Figure 13-26 shows an example of using the auto-repair switch with mysqlcheckto repair a broken table.
If you are looking for affordable and reliable webhost to host and run your business application visit our ftp web hosting services.