Debian Codegraph @

mysql-test/suite/sysschema/t/mysqldump.test

raw
1 -- source include/not_embedded.inc
2 -- source include/have_innodb.inc
3 # Dump all databases
4 --exec $MYSQL_DUMP -uroot --all-databases > $MYSQLTEST_VARDIR/tmp/bug20902791.sql
5
6 # Save a copy of the user/tables_priv, to restore later
7 # Otherwise the final mysql_upgrade will REPLACE and update timestamps etc.
8 CREATE TEMPORARY TABLE tmp_global_priv AS SELECT * FROM mysql.global_priv;
9 CREATE TEMPORARY TABLE tmp_tables_priv AS SELECT * FROM mysql.tables_priv;
10
11 # Remove the sys schema
12 DROP DATABASE sys;
13
14 # Reload the dump
15 --exec $MYSQL < $MYSQLTEST_VARDIR/tmp/bug20902791.sql
16
17 # The sys schema should not exist
18 SHOW DATABASES;
19
20 # Finally reload the sys schema to return to normal
21 --exec $MYSQL_UPGRADE --skip-verbose --force 2>&1
22 SHOW DATABASES;
23
24 # Restore the saved privileges
25 TRUNCATE TABLE mysql.global_priv;
26 INSERT INTO mysql.global_priv (SELECT * FROM tmp_global_priv);
27 DROP TEMPORARY TABLE tmp_global_priv;
28
29 TRUNCATE TABLE mysql.tables_priv;
30 INSERT INTO mysql.tables_priv (SELECT * FROM tmp_tables_priv);
31 DROP TEMPORARY TABLE tmp_tables_priv;
32
33 FLUSH PRIVILEGES;
34 --let $MYSQLD_DATADIR= `select @@datadir`
35 --remove_file $MYSQLD_DATADIR/mariadb_upgrade_info