Chapter 6 Administrative Tasks

Table of Contents

6.1 Server Administration

6.1.1 Server Logs

6.1.2 Service Control

6.1.3 Configuration (Options File)

6.2 Users and Privileges

6.3 Server Status

6.4 Status and System Variables

6.5 Data Export and Import

6.5.1 Table Data Export and Import Wizard

6.5.2 SQL Data Export and Import Wizard

6.5.3 Result Data Export and Import

6.6 MySQL Audit Inspector Interface

6.7 MySQL Enterprise Backup Interface

6.7.1 General Requirements

6.7.2 Online Backup

6.7.3 Backup Recovery

6.8 MySQL Enterprise Firewall Interface

6.9 wbcopytables Utility

MySQL Workbench provides a visual interface to administer your MySQL environment. The available visual tools help configure your MySQL servers, administer users, perform backup and recovery, inspect audit data, and view database health.