SET @orig = @@global.innodb_buffer_pool_filename;
SELECT @orig;
@orig
ib_buffer_pool
SELECT variable_value
FROM information_schema.global_status
WHERE LOWER(variable_name) = 'innodb_buffer_pool_dump_status';
variable_value
not started
SET GLOBAL innodb_buffer_pool_filename = 'innodb_foobar_dump';
SET GLOBAL innodb_buffer_pool_dump_now = ON;
SET GLOBAL innodb_buffer_pool_filename = @orig;