Debian Codegraph @

mysql-test/suite/sysschema/r/mysqldump.result

raw
1 CREATE TABLE mysql.tmp_backup_tables_priv AS SELECT * FROM mysql.tables_priv;
2 CREATE TABLE mysql.tmp_backup_user AS SELECT * FROM mysql.user;
3 DROP DATABASE sys;
4 SHOW DATABASES;
5 Database
6 information_schema
7 mtr
8 mysql
9 performance_schema
10 test
11 # restart:--upgrade=FORCE
12 SHOW DATABASES;
13 Database
14 information_schema
15 mtr
16 mysql
17 performance_schema
18 sys
19 test
20 TRUNCATE TABLE mysql.tables_priv;
21 INSERT INTO mysql.tables_priv (SELECT * FROM mysql.tmp_backup_tables_priv);
22 DROP TABLE mysql.tmp_backup_tables_priv;
23 TRUNCATE TABLE mysql.user;
24 INSERT INTO mysql.user (SELECT * FROM mysql.tmp_backup_user);
25 DROP TABLE mysql.tmp_backup_user;
26 FLUSH PRIVILEGES;