29- How to Take backup using mysqlpump and Restore backup MySQL DBA Tutorial | MySQL 8 DBA Training

preview_player
Показать описание
Why backups?
Taking backups using mysqldump
Taking backups using mysqlpump
Taking backups using mydumper
Taking backups using flat files
Taking backups using XtraBackup
Locking instances for backup
Parallel processing mysqlpump
Exclude/include database objects using mysqlpump
Backup users using mysqlpump
how to take Compressed backup using mysqlpump
Recovering from mysqldump
restore MySQL backup
Binary log backup
Clone Plugin MySQL 8
Physical backup
Logical backups
Full Backups
Incremental Backups
Differential backups
Physical backup utilities
Logical backup utilities
Please Follow me on Social Media
Рекомендации по теме
Комментарии
Автор

Subscribed to your channel. Thanks for your efforts. Learning MySQL from your YouTube channel.

jamsher
Автор

Its very helpful to learn. how to restore single table from mysqldump.
please make one video about restoration secnarios

govardhanreddy
Автор

ASA, I am Facing an issue in windows, mysqlpump working fine with compression lz4 but when I try to decompress even for lz4 utility its through error. commands are below.

lz4.exe -d D:\backup\dbdump_lz4Comp.lz4 D:\backup\dump.text
D:\backup\dbdump_lz4Comp.lz4: is not a regular file

ahsanrafiq