1SELECT sys.format_path(NULL); 2sys.format_path(NULL) 3NULL 4SET @mypath := CONCAT(@@global.basedir, 'logs/binlog.000001'); 5SELECT sys.format_path(@mypath); 6sys.format_path(@mypath) 7@@basedir/logs/binlog.000001 8SET @mypath := CONCAT(@@global.datadir, 'foo/bar.foo'); 9SELECT sys.format_path(@mypath); 10sys.format_path(@mypath) 11@@datadir/foo/bar.foo 12SET @mypath := CONCAT(@@global.tmpdir, '/foo/bar.foo'); 13SELECT sys.format_path(@mypath); 14sys.format_path(@mypath) 15@@tmpdir/foo/bar.foo 16SET @mypath := CONCAT(@@global.innodb_data_home_dir, '/foo/bar.ibd'); 17SELECT sys.format_path(@mypath); 18sys.format_path(@mypath) 19@@innodb_data_home_dir/foo/bar.ibd 20SET @mypath := CONCAT(@@global.innodb_log_group_home_dir, '/ib_logfile0'); 21SELECT sys.format_path(@mypath); 22sys.format_path(@mypath) 23@@innodb_log_group_home_dir/ib_logfile0 24SET @mypath := CONCAT(@@global.innodb_undo_directory, '/undo0'); 25SELECT sys.format_path(@mypath); 26sys.format_path(@mypath) 27@@innodb_undo_directory/undo0 28SELECT sys.format_path('/foo/bar/baz.foo'); 29sys.format_path('/foo/bar/baz.foo') 30/foo/bar/baz.foo 31