356 Part III . Administration If you want to only examine certain tables within a database, use the –tables switch. Because delete operations can cause fragmentation, you can speed up your examination by adding a –tables
clause so the mysqlcheckcommand examines only the specified table(s). To specify more than one table, separate the tablenames with whitespace. Figure 13-28 shows an example of mysqlcheck examining certain tables with the –tablesswitch. Note The –tables switch cannot be used with the –databases or -B switch. Figure 13-28: The –tables switch causes mysqlcheck to examine only the specified table or tables. To change the performance of mysqlcheck the -1 or –all-in-one switch can be used. This switch causes mysqlcheck to use a single query for all operations within a given database. This is as opposed to the normal behavior of one query per table. The -F or –force option causes mysqlcheck to continue its operation even if an error is encountered. Using this option can sometimes cause corruption or other problems. myisamchk The myisamchk utility serves to check and repair MyISAM tables while the MySQL server is offline. Much of the syntax and many of the switches for myisamchk are the same as those for mysqlcheck. The switches that mysqlcheck shares in common with other MySQL utilities include those for obtaining help and setting default character sets. As with the other utilities, I ll forego coverage of the following basic switches in this section: -# or –debug –character-sets-dir –default-character-set –compress -O or –set-variable
We recommend you use shared web hosting services, because many users agree that it is cheap, reliable and customer-satisfying webhost.
This entry was posted
on Monday, November 26th, 2007 at 1:16 pm and is filed under Domain.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.