MySQL utility commands

Posted December 30th, 2009 in MySql

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

• Copy a table in MySQL
• Copy a table in MySQL with CREATE TABLE LIKE

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

• Show indexes for a table with the MySQL INFORMATION_SCHEMA
• Show indexes for a table with MySQL

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

Logging

• Logging slow queries with MySQL

Dropping columns, tables and databases

• How to drop a database with MySQL
• How to drop a table with MySQL
• Drop multiple MySQL tables
• MySQL: SQL to drop a column from a table

Server information

• Showing running queries in MySQL
• Get MySQL status information from the command line