This post is a summary of MySQL posts from this blog relating to MySQL utility commands, such as describing table structure, dropping columns from a table, and so on; and server settings.
Table maintenance
- Renaming a table in MySQL
- Rename multiple tables in MySQL
- Reset the auto increment value for a MySQL table
- Optimize a table in MySQL from the command line interface
- Check if a MySQL table exists
Copying tables
Listing tables and table structure
- Listing tables and their structure with the MySQL Command Line Client
- Get a MySQL table structure with DESCRIBE
- Get a MySQL table structure from the INFORMATION_SCHEMA
Indexes
Storage engines
- How to tell which storage engine a MySQL table uses
- How to change the storage engine a MySQL table uses
- Find which tables use INNODB with MySQL
- Use one file per table with MySQL’s INNODB storage engine
Server Settings
- How to update the max_connections setting in MySQL
- How to enable remote access to a MySQL database server
- Change the full text index minimum word length with MySQL