On: Fast MySQL Backup and Restore Using Mydumper and Myloader

[lathiat]

Watch out last time I looked most of these tools miss some things like stored procedures, though I haven't checked mydumper specifically recently. mysqlpdump certainly did, and I think I tried mydumper.

There's also other things to potentially worry about; events, functions, etc.

[disago → lathiat]

Since version 0.9.1 mydumper supports all schema objects [1]

[1] https://www.percona.com/blog/2015/11/12/logical-mysql-backup...

[roselan → lathiat]

Mainly users.

I'm probably too dumb to find it, but I have found no utility to export/import db users and grants. Not that it's hard to roll your own thou.