Embedded Files
Backup
Backup
util.dumpInstance()
util.dumpSchemas()
dump an entire database instance, including users
dump a set of schemas
mysqlsh
\c root@localhost
\js
util.dumpInstance("/backup/mydump")
Where /backup/mydump is an empty local directoryRestore
Restore
util.dumpInstance()
load a dump into a target database
mysqlsh
\c root@localhost
\js
util.loadDump("/backup/mydump",
{ ignoreVersion: true,
threads: 4,
loadData: true,
resetProgress: true } )
Where /backup/mydump is a local directory containing a backup made using util.dumpInstance or util.dumpSchemaStart MySQL Shell
Connect as root@localhost
javascript
Tell loadDump where to find the backup
Allow restore of a backup made using an older version (e.g. import a MySQL 5.7 backup into MySQL 8.0)
Number of parallel threads
Load the data
Don't try to continue a previous interrupted backup
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
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
Page updated
Google Sites
Report abuse