1SET @orig = @@global.innodb_buffer_pool_filename;
2SELECT @orig;
3@orig
4ib_buffer_pool
5SELECT variable_value
6FROM information_schema.global_status
7WHERE LOWER(variable_name) = 'innodb_buffer_pool_dump_status';
8variable_value
9Dumping of buffer pool not started
10SET GLOBAL innodb_buffer_pool_filename = 'innodb_foobar_dump';
11SET GLOBAL innodb_buffer_pool_dump_now = ON;
12SET GLOBAL innodb_buffer_pool_filename = @orig;
13