MySQL 8 Cookbook

Backup of a single table

The following command takes the backup of the employees table of the employees database into the /backups directory:

shell> mydumper -u root --password=<password> -B employees -T employees --triggers --events --routines  --outputdir /backups/employee_table

shell> ls -lhtr /backups/employee_table/total 17M-rw-r--r-- 1 root root 71 Aug 13 10:35 employees-schema-create.sql-rw-r--r-- 1 root root 397 Aug 13 10:35 employees.employees-schema.sql-rw-r--r-- 1 root root 3.4K Aug 13 10:35 employees-schema-post.sql-rw-r--r-- 1 root root 75 Aug 13 10:35 metadata-rw-r--r-- 1 root root 17M Aug 13 10:35 employees.employees.sql

The convention of the files are as follows:

• employees-schema-create.sql contains the CREATE DATABASE statement ...