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 ...