1# Embedded server doesn't support external clients
2--source include/not_embedded.inc
3
4#
5# Bug #30126: semicolon before closing */ in /*!... CREATE DATABASE ;*/
6#
7
8--let $file = $MYSQLTEST_VARDIR/tmp/bug30126.sql
9
10CREATE DATABASE mysqldump_30126;
11USE mysqldump_30126;
12CREATE TABLE t1 (c1 int);
13--exec $MYSQL_DUMP --add-drop-database mysqldump_30126 > $file
14--exec $MYSQL mysqldump_30126 < $file
15DROP DATABASE mysqldump_30126;
16
17--remove_file $file
18use test;
19
20#
21# MDEV-19182 mysqldump not always handling SHOW CREATE TRIGGER failures correctly
22#
23create table t1 (a int);
24create trigger tr after insert on t1 for each row set @a=1;
25let $datadir=`select @@datadir`;
26move_file $datadir/test/tr.TRN $datadir/test/tr-1.TRN;
27error 2;
28exec $MYSQL_DUMP test t1 >/dev/null;
29move_file $datadir/test/tr-1.TRN $datadir/test/tr.TRN;
30drop table t1;
31