connect (other,localhost,root,,,); --connection default SET @@autocommit=0; CREATE TABLE t1 (s1 CHAR(2)) ENGINE=innodb; INSERT INTO t1 VALUES ('a1'); --connection other SELECT * FROM t1; --connection default BACKUP DATABASE test TO 'test.bak'; --connection other SELECT * FROM t1;