List of MySQL Programs

MySQL Tutorials - Herong's Tutorial Examples

∟Introduction of MySQL Programs

∟List of MySQL Programs

This section provides a list of main executable programs provided in MySQL 5.0 Community Edition.

Based on the Community Edition of MySQL 8.0 manual, these are main executable programs provided in the MySQL Server package:

mysqld - The main server program - MySQL server daemon.
mysqladmin - Command line based administrator tool to manage the server.
mysql - Command line based user tool to manage databases.
mysqldump - Tool to dump data from tables into text files.
mysqlimport - Tool to load data into tables from text files.
mysqlcheck - Tool to check and repair databases.
mysqlshow - Tool to display information about databases and tables.
mysqlbinlog - Tool to process binary MySQL server log files.
myisamchk - Tool to perform table maintenance operations.
myisampack - Tool to produce compressed, read-only tables.
myisamlog - Tool to process the contents of a MyISAM log file.
myisam_ftdump - Tool to display information about FULLTEXT indexes in MyISAM tables.
perror - Tool to display the meaning of error codes.
mysqlpump - A Database Backup Program.
mysqlslap - Load Emulation Client.
innochecksum - Offline InnoDB File Checksum Utility.
mysql_config_editor - MySQL Configuration Utility.
mysqldumpslow - Summarize Slow Query Log Files. Supported in MySQL 5.7 and older releases.

Table of Contents

About This Book

Introduction of SQL

MySQL Introduction and Installation

►Introduction of MySQL Programs

►List of MySQL Programs

mysqld - The MySQL Server Program

mysqladmin - The Client Tool for Administrators

mysql - The Client Tool for End Users

Using "mysql" Command to Run SQL Statements

mysqldump - Dumping Data to Files

--secure-file-priv="" - MySQL Server Option

mysqlimport - Loading Data from Files

PHP Programs and MySQL Server

Perl Programs and MySQL Servers

Java Programs and MySQL Servers

Datatypes and Data Literals

Operations and Expressions

Character Strings and Bit Strings

Commonly Used Functions

Table Column Types for Different Types of Values

Using DDL to Create Tables and Indexes

Using DML to Insert, Update and Delete Records

Using SELECT to Query Database

Window Functions for Statistical Analysis

Use Index for Better Performance

Transaction Management and Isolation Levels

Locks Used in MySQL

Defining and Calling Stored Procedures

Variables, Loops and Cursors Used in Stored Procedures

System, User-Defined and Stored Procedure Variables

MySQL Server Administration

Storage Engines in MySQL Server

InnoDB Storage Engine - Primary and Secondary Indexes

Performance Tuning and Optimization

Bulk Changes on Large Tables

MySQL Server on macOS

Installing MySQL Server on Linux

Connection, Performance and Second Instance on Linux

Archived Tutorials

Full Version in PDF/EPUB