You could also check tables for all your (Web design online)
You could also check tables for all your databases at once as follows: # myisamchk /var/lib/mysql/*/*.MYI The example above shows a simple, 5-record database where no errors were encountered. If instead of the output shown above, you see output like the following you may need to repair the database: Checking MyISAM file: names.MYI Data records: 5 Deleted blocks: 0 - check file-size myisamchk: warning: Size of datafile is: 689 Should be: 204 - check key delete-chain - check record delete-chain - check index reference - check record links myisamchk: error: Found wrong record at 0 MyISAM-table ‘names.MYI’ is corrupted Fix it using switch “-r” or “-o” 3. To fix a corrupted database, you could run the following command # myisamchk -r /var/lib/allusers/names.MYI - recovering (with keycache) MyISAM-table ‘names.MYI’ Data records: 5 Found wrong stored record at 0 Data records: 4 4. If for some reason the -r options doesn’t work, you can try running the myisamchk command with the -o option. This is a slower, older method of repair, but it can handle a few problems that the -r option cannot. Here is an example: # myisamchk -o /var/lib/allusers/names.MYI Tip If your computer has a lot of memory, raise the key buffer size value on the myisamchk command line, which will lessen the time it takes to check the databases. For example, you could use the following command line: # myisamchk -r -O –key_buffer_size=64M *.MYI This would set the key buffer size to 64 Megabytes. Summary MySQL is a Structured Query Language (SQL) server that runs on Red Hat Linux, as well as other operating systems. Using a start-up script (/etc/init.d/mysqld) and a configuration file (/etc/my.cnf), you can quickly get a MySQL server up and running. With tools such as the mysqladmin and mysql commands, you can administer the MySQL server and create databases and tables that are as simple or complex as you need. During mysql sessions, you can modify the structure of your database tables or add, update, or delete database records. You have a variety of options for querying data and sorting the output. You also have a lot of control over who can access your database tables and what privileges users have to modify, add to, or delete from the databases you control.
If you are looking for cheap and quality webhost to host and run your website check Jboss Web Hosting services.