MySQL FAQs - Administrator Tools for Managing MySQL Server

Home >> FAQs/Tutorials >> MySQL Tutorials

By: FYIcenter.com

Part: 1 2 3 4

(Continued from previous part...)

How To Analyze Tables with "mysqlcheck"?

If you want analyze tables with "mysqlcheck", you need to use the "--analyze" option. The following tutorial exercise shows you how to analyze all tables in "mysql" database:

>cd \mysql\bin
>mysqlcheck -u root --analyze mysql
mysql.columns_priv              Table is already up to date
mysql.db                        Table is already up to date
mysql.func                      Table is already up to date
mysql.help_category             Table is already up to date
mysql.help_keyword              Table is already up to date
mysql.help_relation             Table is already up to date
mysql.help_topic                Table is already up to date
mysql.host                      Table is already up to date
mysql.proc                      Table is already up to date
mysql.tables_priv               Table is already up to date
mysql.time_zone                 Table is already up to date
mysql.time_zone_leap_second     Table is already up to date
mysql.time_zone_name            Table is already up to date
mysql.time_zone_transition      Table is already up to date
mysql.time_zone_transition_type Table is already up to date
mysql.user                      Table is already up to date

What Is "mysqlshow"?

"mysqlshow" is a command-line interface for end users to see information on tables and columns. Here are some sample commands supported by "mysqlshow":

"mysqlshow" - Shows all the databases.
"mysqlshow databaseName" - Shows all the tables in the specified database.
"mysqlshow databaseName tableName" - Shows all the columns in the specified table.
"mysqlshow --verbose" - Shows all the databases with extra information.
"mysqlshow --verbose my%" - Shows all the databases who's names match the pattern "my%" with extra information.
"mysqlshow --verbose mysql time%" - Shows all the tables who's names match the pattern "time%" in "mysql" database with extra information.

To know about "mysqlshow", read other parts of this FAQ collection.

How To Show Table Names with "mysqlshow"?

If you want to show table names with "mysqlshow", you need to specify a database name. The followings tutorial exercise shows you how to get all table names that match a pattern:

If you want analyze tables with "mysqlcheck", you need to use the "--analyze" option. The following tutorial exercise shows you how to analyze all tables in "mysql" database:

>cd \mysql\bin
>mysqlshow --verbose mysql time%
Database: mysql  Wildcard: time%
+---------------------------+----------+
|          Tables           | Columns  |
+---------------------------+----------+
| time_zone                 |        2 |
| time_zone_leap_second     |        2 |
| time_zone_name            |        2 |
| time_zone_transition      |        3 |
| time_zone_transition_type |        5 |
+---------------------------+----------+
5 rows in set.

What Is "mysqldump"?

"mysqldump" - A command-line interface for administrators or end users to export data from the server to files. Here are some sample commands supported by "mysqldump":

"mysqldump databaseName tableName" - Dumps the specified table in the specified database.
"mysqldump databaseName" - Dumps all the tables in the specified database.

To know about "mysqldump", read other parts of this FAQ collection.

(Continued on next part...)

Part: 1 2 3 4

MySQL Tutorials:

More...