mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
b24ecd7ca6
- mariadb-dump utility performs logical backups by producing set of sql statements that can be executed. By enabling this no-autocommit option, InnoDB can load the data in an efficient way and writes the only one undo log for the whole operation. Only first insert statement undergoes bulk insert operation, remaining insert statement doesn't write undo log and undergoes normal insert code path.
59 lines
1.2 KiB
Text
59 lines
1.2 KiB
Text
#
|
|
# New lines in identifiers
|
|
#
|
|
|
|
# embedded server doesn't support external clients
|
|
--source include/not_embedded.inc
|
|
# cmd.exe doesn't like new lines on the command line
|
|
--source include/not_windows.inc
|
|
--source include/default_charset.inc
|
|
|
|
create database `mysqltest1
|
|
1tsetlqsym`;
|
|
use `mysqltest1
|
|
1tsetlqsym`;
|
|
|
|
create table `t1
|
|
1t` (`foobar
|
|
raboof` int);
|
|
create view `v1
|
|
1v` as select * from `t1
|
|
1t`;
|
|
|
|
create procedure sp() select * from `v1
|
|
1v`;
|
|
|
|
flush tables;
|
|
use test;
|
|
|
|
exec $MYSQL_DUMP --compact --comments --routines --add-drop-database --databases --no-autocommit=0 'mysqltest1
|
|
1tsetlqsym';
|
|
|
|
exec $MYSQL_DUMP --compact --comments --routines --add-drop-database --databases --no-autocommit=0 'mysqltest1
|
|
1tsetlqsym' | $MYSQL;
|
|
|
|
show tables from `mysqltest1
|
|
1tsetlqsym`;
|
|
|
|
drop database `mysqltest1
|
|
1tsetlqsym`;
|
|
|
|
create database `test```;
|
|
create database `test\``
|
|
\! ls
|
|
#`;
|
|
|
|
show databases like 'test%';
|
|
|
|
exec $MYSQL_DUMP --compact --comments --add-drop-database --no-autocommit=0 --databases 'test`' 'test\`
|
|
\! ls
|
|
#';
|
|
|
|
exec $MYSQL_DUMP --compact --comments --add-drop-database --no-autocommit=0 --databases 'test`' 'test\`
|
|
\! ls
|
|
#' | $MYSQL;
|
|
|
|
drop database `test```;
|
|
drop database `test\``
|
|
\! ls
|
|
#`;
|