This page summarises most common administration commands you will need for your MySQL server administration duties.
User management and access control is at the heart of any database server. This page explains how to create and maintain user accounts, and how to grant and revoke privileges to users.
This page presents the MySQL temporal types (DATE, TIME, DATETIME and TIMESTAMP) and explains how they are impacted when used from clients in different time zones.
A backup is the process of copying and archiving data so that it can be restored later in case of disaster. mysqldump is a MySQL program that creates logical backups. This page explains the best practises to back up and restore a MySQL database using mysqldump.
MyISAM is a non-transactional storage engine with small system footprint. This page provides an introduction to MyISAM storage engine and how to configure it.
InnoDB is a transactional and ACID compliant MySQL storage engine. This page analyses in detail the internals and configuration of the InnoDB storage engine.
Introduction This page provides an introduction to configure the MySQL server. It first explains how to locate the MySQL configuration file and how it is structured. It then explains how to show and change system variables at runtime. Finally, it shows how to monitor the current server status. This page is part of the MySQL administration series: MySQL … Continue reading MySQL Configuration
Introduction MySQL is an open source and widely used database server. This page provides an overview of the main MySQL components. This is the introductory page to the MySQL administration series: MySQL Components MySQL Configuration InnoDB Storage Engine MyISAM Storage Engine MySQL Backup and Restore with mysqldump MySQL Date Types and Time Zone support MySQL User … Continue reading MySQL Components