• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
The Electric Toolbox Blog

The Electric Toolbox Blog

Linux, Apache, Nginx, MySQL, Javascript and PHP articles

  • Applications
  • FCKEditor
  • Apache
  • Windows
  • Contact Us
Home / MySQL utility commands

MySQL utility commands

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

  • 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

Check Out These Related posts:

  1. How to tell which storage engine a MySQL table uses
  2. PHP script to convert MySQL tables to a new storage engine
  3. How to change the storage engine a MySQL table uses
  4. Listing tables and their structure with the MySQL Command Line Client

Filed Under: MySql

Primary Sidebar

Categories

  • Apache
  • Applications
  • Article
  • Case Studies
  • Email Servers
  • FCKEditor
  • HTML And CSS
  • Javascript
  • Linux/Unix/BSD
  • Microsoft SQL Server
  • Miscellaneous Postings
  • MySql
  • Networking
  • Nginx Web Server
  • Offsite Articles
  • OSX
  • PHP
  • Quick Tips
  • RFC – Request for Comments
  • SilverStripe
  • VMWare
  • VPN
  • Windows
  • WordPress

Recent Posts

  • Vim Show Line Numbers
  • Add User To Group Linux
  • Chmod 777 Tutorial
  • How to Copy Directory Linux
  • Linux create user

Copyright © 2021. ElectricToolBox. All Rights Reserved.

  • Contact Us
  • Copyright Info
  • Privacy Policy
  • Sitemap