MySQL Shell Dump & Load
This functionality was introduced in MySQL Shell 8.0.21
Backup
Backup
util.dumpInstance(): dump an entire database instance, including usersutil.dumpSchemas(): dump a set of schemas
Restore
Restore
util.loadDump(): load a dump into a target database
Bibliography
Bibliography
https://mysqlserverteam.com/mysql-shell-dump-load-part-1-demo/ https://mysqlserverteam.com/mysql-shell-dump-load-part-2-benchmarks/ https://mysqlserverteam.com/mysql-shell-dump-load-part-3-load-dump/ https://mysqlserverteam.com/mysql-shell-8-0-21-speeding-up-the-dump-process/ (MySQL Shell Dump & Load part 4: Dump Instance & Schemas)
https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-dump-instance-schema.html https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-load-dump.html