Mysqlsh file and position of a consistent backup created by dumpInstance utility

MySQL & MariaDB
1

Hi,
Taking backups with the util.dumpInstance() and then restoring them with utils.dumpLoad() has proven incredibly faster than any other tool.
That said I would like to use the utility to seed a replica but I would need to know what’s the file/position of the “consistent” backup created with it. Does anybody knows how?

2

Hi @zerg2k - I haven’t used the util.loadDump() routine but the docs say you can get the GTID information from the @.json dump file. See Note #3 from the following page:
https://dev.mysql.com/doc/mysql-shell/8.0/en/mysql-shell-utilities-load-dump.html

1 Like
3

Thanks @Michael_Coburn . I am aware of the GTID Executed metadata. I am asking here because I see nothing about file/position.
For what is worth if the server is using file/position replication instead of GTID the GTIDExecuted entry in @.json is empty.

2 Likes