News for hackers. Stuff that matters.

A comment on Fast MySQL Backup and Restore Using Mydumper and Myloader.

Re:Fast MySQL Backup and Restore Using Mydumper and Myloader by lathiat on Sunday July 23, 2017 @12:21AM (#14830883)
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.

[ Parent | on HN ]
Re:Fast MySQL Backup and Restore Using Mydumper and Myloader by disago on Sunday July 23, 2017 @03:15AM (#14831221)
Since version 0.9.1 mydumper supports all schema objects [1]

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

[ Parent | on HN ]
Re:Fast MySQL Backup and Restore Using Mydumper and Myloader by roselan on Sunday July 23, 2017 @03:10AM (#14831211)
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.

[ Parent | on HN ]