360 Part III . Administration If you suspect
360 Part III . Administration If you suspect a table contains errors or corruption and want to prevent further use of the table, the -U or –update-state switch with myisamchkmarks any table where an error is found as a crashed table which effectively prevents any further use of the table, even with a SELECT statement, until the table is repaired. Clients attempting to work with the table receive an error message. Figure 13-34 shows an example of a simple SELECT statement performed on a table, using the MySQL CLI. Figure 13-34: A simple SELECT statement, performed through the CLI on a table that I suspect to be corrupt Although there s no way to tell from the SELECT statement, I suspect that this table might be corrupt. Therefore I perform a myisamchk on the table and use the -U switch, as shown in Figure 13-35. Figure 13-35: Running myisamchk with the -U switch to mark the table as crashed and prevent further use Figure 13-36 shows what happens when I attempt to run the previously successful SELECT statement on the table again. The SELECTstatement fails because the table is marked as crashed which (even if it seems inconvenient at the moment) actually helps by preventing further corruption or invalid results.
If you are looking for cheap and quality webhost to host and run your website check Jboss Web Hosting services.