Linux ip-172-26-2-223 5.4.0-1018-aws #18-Ubuntu SMP Wed Jun 24 01:15:00 UTC 2020 x86_64
Apache
: 172.26.2.223 | : 18.224.5.46
Cant Read [ /etc/named.conf ]
8.1.13
www
www.github.com/MadExploits
Terminal
AUTO ROOT
Adminer
Backdoor Destroyer
Linux Exploit
Lock Shell
Lock File
Create User
CREATE RDP
PHP Mailer
BACKCONNECT
UNLOCK SHELL
HASH IDENTIFIER
CPANEL RESET
CREATE WP USER
BLACK DEFEND!
README
+ Create Folder
+ Create File
/
www /
server /
mysql /
mysql-test /
suite /
ndb /
r /
[ HOME SHELL ]
Name
Size
Permission
Action
bug36547.result
455
B
-rw-r--r--
loaddata_autocom_ndb.result
740
B
-rw-r--r--
ndb_add_partition.result
13.36
KB
-rw-r--r--
ndb_addnode_restart.result
384
B
-rw-r--r--
ndb_addnode_restart2.result
454
B
-rw-r--r--
ndb_alter_table.result
19.49
KB
-rw-r--r--
ndb_alter_table2.result
685
B
-rw-r--r--
ndb_alter_table3.result
1.48
KB
-rw-r--r--
ndb_alter_table_backup.result
1.76
KB
-rw-r--r--
ndb_alter_table_dml.result
1.83
KB
-rw-r--r--
ndb_alter_table_error.result
664
B
-rw-r--r--
ndb_alter_table_online.result
29.02
KB
-rw-r--r--
ndb_alter_table_online2.result
3.21
KB
-rw-r--r--
ndb_alter_table_online_multi.r...
2
KB
-rw-r--r--
ndb_auto_increment.result
11.49
KB
-rw-r--r--
ndb_autoinc.result
2.69
KB
-rw-r--r--
ndb_backup_rate.result
912
B
-rw-r--r--
ndb_basic.result
32.68
KB
-rw-r--r--
ndb_bitfield.result
8.39
KB
-rw-r--r--
ndb_blob.result
26.47
KB
-rw-r--r--
ndb_blob_big.result
1.24
KB
-rw-r--r--
ndb_blob_partition.result
9.03
KB
-rw-r--r--
ndb_bug13563280.result
224
B
-rw-r--r--
ndb_bug14166590.result
416
B
-rw-r--r--
ndb_bug17624736.result
1.71
KB
-rw-r--r--
ndb_bug17719439.result
439
B
-rw-r--r--
ndb_bug19390895.result
1.67
KB
-rw-r--r--
ndb_bug26793.result
286
B
-rw-r--r--
ndb_bug31477.result
1.85
KB
-rw-r--r--
ndb_bulk_delete.result
1.87
KB
-rw-r--r--
ndb_bushy_joins.result
88.95
KB
-rw-r--r--
ndb_cache.result
9.35
KB
-rw-r--r--
ndb_cache2.result
13.9
KB
-rw-r--r--
ndb_cache_multi.result
2.44
KB
-rw-r--r--
ndb_cache_multi2.result
3.04
KB
-rw-r--r--
ndb_cache_trans.result
6.65
KB
-rw-r--r--
ndb_charset.result
5.77
KB
-rw-r--r--
ndb_checksum.result
38
B
-rw-r--r--
ndb_column_properties.result
16.01
KB
-rw-r--r--
ndb_condition_pushdown.result
131.71
KB
-rw-r--r--
ndb_config.result
3.36
KB
-rw-r--r--
ndb_config2.result
475
B
-rw-r--r--
ndb_create_table.result
1.02
KB
-rw-r--r--
ndb_cursor.result
792
B
-rw-r--r--
ndb_database.result
1.25
KB
-rw-r--r--
ndb_dbug_lock.result
1.64
KB
-rw-r--r--
ndb_dbug_tc_select.result
6.71
KB
-rw-r--r--
ndb_dd_alter.result
28.43
KB
-rw-r--r--
ndb_dd_basic.result
21.17
KB
-rw-r--r--
ndb_dd_bug12581213.result
334
B
-rw-r--r--
ndb_dd_ddl.result
5.94
KB
-rw-r--r--
ndb_dd_disk2memory.result
15.44
KB
-rw-r--r--
ndb_dd_dump.result
15.97
KB
-rw-r--r--
ndb_dd_initial_lg.result
941
B
-rw-r--r--
ndb_dd_restore_check_tablespac...
8.3
KB
-rw-r--r--
ndb_dd_restore_compat.result
3.73
KB
-rw-r--r--
ndb_dd_sql_features.result
22.62
KB
-rw-r--r--
ndb_ddl_open_trans.result
1.44
KB
-rw-r--r--
ndb_disconnect_ddl.result
291
B
-rw-r--r--
ndb_discover_db.result
1.92
KB
-rw-r--r--
ndb_dist_priv.result
6.36
KB
-rw-r--r--
ndb_dist_priv_bug_13340854.res...
248
B
-rw-r--r--
ndb_err4012.result
2.22
KB
-rw-r--r--
ndb_error_reporter.result
5.61
KB
-rw-r--r--
ndb_fired_trigger_shortage.res...
694
B
-rw-r--r--
ndb_fk_addnode.result
1.39
KB
-rw-r--r--
ndb_fk_alter.result
8.34
KB
-rw-r--r--
ndb_fk_bugs.result
27.58
KB
-rw-r--r--
ndb_fk_build.result
2.31
KB
-rw-r--r--
ndb_fk_cascade_delete.result
4.82
KB
-rw-r--r--
ndb_fk_cascade_delete_multi.re...
2.56
KB
-rw-r--r--
ndb_fk_cascade_update.result
1.66
KB
-rw-r--r--
ndb_fk_create_drop.result
4.8
KB
-rw-r--r--
ndb_fk_db.result
7.18
KB
-rw-r--r--
ndb_fk_deferred_cascade.result
2.82
KB
-rw-r--r--
ndb_fk_disable.result
11.64
KB
-rw-r--r--
ndb_fk_is.result
8.49
KB
-rw-r--r--
ndb_fk_locase.result
2.44
KB
-rw-r--r--
ndb_fk_locking.result
1.47
KB
-rw-r--r--
ndb_fk_multi_column.result
2.04
KB
-rw-r--r--
ndb_fk_mysqldump.result
2.93
KB
-rw-r--r--
ndb_fk_mysqldump2.result
72
B
-rw-r--r--
ndb_fk_no_fk.result
30.14
KB
-rw-r--r--
ndb_fk_no_fk_legacy.result
2.77
KB
-rw-r--r--
ndb_fk_noaction.result
5.68
KB
-rw-r--r--
ndb_fk_resources.result
2.58
KB
-rw-r--r--
ndb_fk_restore.result
14.08
KB
-rw-r--r--
ndb_fk_restrict.result
6.82
KB
-rw-r--r--
ndb_fk_self_ref.result
3.74
KB
-rw-r--r--
ndb_fk_setdefault.result
1.03
KB
-rw-r--r--
ndb_fk_setnull.result
3.23
KB
-rw-r--r--
ndb_global_schema_lock.result
3.6
KB
-rw-r--r--
ndb_global_schema_lock_error.r...
1.88
KB
-rw-r--r--
ndb_grant.result
17.65
KB
-rw-r--r--
ndb_hashmap.result
624
B
-rw-r--r--
ndb_hidden_pk.result
10.55
KB
-rw-r--r--
ndb_index.result
17.84
KB
-rw-r--r--
ndb_index_ordered.result
16.73
KB
-rw-r--r--
ndb_index_stat.result
17.74
KB
-rw-r--r--
ndb_index_stat_partitions.resu...
3.82
KB
-rw-r--r--
ndb_index_stat_restart.result
2.2
KB
-rw-r--r--
ndb_index_unique.result
20.29
KB
-rw-r--r--
ndb_insert.result
36.52
KB
-rw-r--r--
ndb_join_pushdown_bka.result
949.68
KB
-rw-r--r--
ndb_join_pushdown_default.resu...
865.61
KB
-rw-r--r--
ndb_join_pushdown_nobnl.result
864.87
KB
-rw-r--r--
ndb_join_pushdown_none.result
865.08
KB
-rw-r--r--
ndb_limit.result
1.99
KB
-rw-r--r--
ndb_load.result
2.66
KB
-rw-r--r--
ndb_loaddatalocal.result
1.57
KB
-rw-r--r--
ndb_lock.result
4.17
KB
-rw-r--r--
ndb_lock_table.result
205
B
-rw-r--r--
ndb_many_fragments.result
26.72
KB
-rw-r--r--
ndb_mgm.result
5.7
KB
-rw-r--r--
ndb_mgmd.result
198
B
-rw-r--r--
ndb_minmax.result
1.47
KB
-rw-r--r--
ndb_multi.result
8.83
KB
-rw-r--r--
ndb_multi_row.result
1.33
KB
-rw-r--r--
ndb_multi_update_delete.result
1.83
KB
-rw-r--r--
ndb_native_default_support.res...
50.29
KB
-rw-r--r--
ndb_one_fragment.result
4.05
KB
-rw-r--r--
ndb_optimize_table.result
2
KB
-rw-r--r--
ndb_optimized_node_selection.r...
1017
B
-rw-r--r--
ndb_partition_error.result
1.44
KB
-rw-r--r--
ndb_partition_error2.result
150
B
-rw-r--r--
ndb_partition_hash.result
890
B
-rw-r--r--
ndb_partition_key.result
8.82
KB
-rw-r--r--
ndb_partition_list.result
2.31
KB
-rw-r--r--
ndb_partition_range.result
7.91
KB
-rw-r--r--
ndb_print_file.result
709
B
-rw-r--r--
ndb_rbwr.result
0
B
-rw-r--r--
ndb_read_multi_range.result
15
KB
-rw-r--r--
ndb_reconnect.result
1.7
KB
-rw-r--r--
ndb_rename.result
910
B
-rw-r--r--
ndb_replace.result
3.64
KB
-rw-r--r--
ndb_restore_bug17916243.result
537
B
-rw-r--r--
ndb_restore_compat_downward.re...
132.43
KB
-rw-r--r--
ndb_restore_compat_endianness....
10.97
KB
-rw-r--r--
ndb_restore_conv_lossy_charbin...
15.46
KB
-rw-r--r--
ndb_restore_conv_lossy_integra...
20.72
KB
-rw-r--r--
ndb_restore_conv_more.result
56.57
KB
-rw-r--r--
ndb_restore_conv_padding.resul...
6.14
KB
-rw-r--r--
ndb_restore_conv_promotion.res...
23.26
KB
-rw-r--r--
ndb_restore_discover.result
540
B
-rw-r--r--
ndb_restore_misc.result
25.16
KB
-rw-r--r--
ndb_restore_print.result
9.8
KB
-rw-r--r--
ndb_restore_schema_blobs.resul...
6.44
KB
-rw-r--r--
ndb_restore_schema_partitions....
13.25
KB
-rw-r--r--
ndb_restore_schema_rewrites.re...
12.22
KB
-rw-r--r--
ndb_restore_schema_subsets.res...
95.9
KB
-rw-r--r--
ndb_restore_schema_tolerance.r...
4.53
KB
-rw-r--r--
ndb_restore_undolog.result
18.76
KB
-rw-r--r--
ndb_row_count.result
5.19
KB
-rw-r--r--
ndb_row_format.result
1.74
KB
-rw-r--r--
ndb_select_count.result
334
B
-rw-r--r--
ndb_share.result
11.29
KB
-rw-r--r--
ndb_short_sigs.result
2.54
KB
-rw-r--r--
ndb_single_user.result
4.01
KB
-rw-r--r--
ndb_sp.result
1.17
KB
-rw-r--r--
ndb_spj_dict.result
11.63
KB
-rw-r--r--
ndb_sql_allow_batching.result
918
B
-rw-r--r--
ndb_startup.result
358
B
-rw-r--r--
ndb_statistics0.result
16.23
KB
-rw-r--r--
ndb_statistics1.result
15.99
KB
-rw-r--r--
ndb_subquery.result
9.29
KB
-rw-r--r--
ndb_suma_handover.result
427
B
-rw-r--r--
ndb_temporary.result
949
B
-rw-r--r--
ndb_tmp_table_and_DDL.result
3.11
KB
-rw-r--r--
ndb_transaction.result
4.62
KB
-rw-r--r--
ndb_trigger.result
9.38
KB
-rw-r--r--
ndb_truncate.result
425
B
-rw-r--r--
ndb_types.result
4.91
KB
-rw-r--r--
ndb_update.result
2.97
KB
-rw-r--r--
ndb_update_no_read.result
11.23
KB
-rw-r--r--
ndb_view.result
597
B
-rw-r--r--
ndb_wait_until_ready.result
533
B
-rw-r--r--
ndb_wl946_main.result
19.39
KB
-rw-r--r--
ndb_wl946_post.result
3.7
KB
-rw-r--r--
ndb_wl946_pre.result
6.62
KB
-rw-r--r--
ndbapi-examples.result
3.34
KB
-rw-r--r--
ndbinfo.result
44.04
KB
-rw-r--r--
ndbinfo_cache.result
775
B
-rw-r--r--
ndbinfo_dump.result
95
B
-rw-r--r--
ndbinfo_upgrade.result
382
B
-rw-r--r--
ps_7ndb.result
103.05
KB
-rw-r--r--
strict_autoinc_5ndb.result
894
B
-rw-r--r--
wl10837.result
524
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ndb_restore_schema_rewrites.result
************************************************************ * Creating multiple databases with identical tables * (have blobs and indexes to cover the hidden tables) ************************************************************ CREATE DATABASE db0; CREATE DATABASE db1; CREATE DATABASE db2; USE db0; CREATE TABLE t0 ( id INT PRIMARY KEY, cint INT, cvarchar VARCHAR(5), cblob BLOB(1000004), UNIQUE INDEX UNIQUE_t0_0 USING BTREE (cint ASC), UNIQUE INDEX UNIQUE_t0_2 USING BTREE (cvarchar ASC) ) ENGINE=NDB; USE db1; CREATE TABLE t0 ( id INT PRIMARY KEY, cint INT, cvarchar VARCHAR(5), cblob BLOB(1000004), UNIQUE INDEX UNIQUE_t0_0 USING BTREE (cint ASC), UNIQUE INDEX UNIQUE_t0_2 USING BTREE (cvarchar ASC) ) ENGINE=NDB; USE db2; CREATE TABLE t0 ( id INT PRIMARY KEY, cint INT, cvarchar VARCHAR(5), cblob BLOB(1000004), UNIQUE INDEX UNIQUE_t0_0 USING BTREE (cint ASC), UNIQUE INDEX UNIQUE_t0_2 USING BTREE (cvarchar ASC) ) ENGINE=NDB; ************************************************************ * Inserting data * (create disjunct sets of rows to merge without conflicts; * at this time, ndb_restore does not offer any detection * of data conflicts between databases in the backup or in * memory; databases are restored in an unspecified order) * (make blob data long enough to be held in extra table) ************************************************************ USE db0; INSERT INTO t0 VALUES (0, 0, '00000', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890'); INSERT INTO t0 VALUES (1, 1, '11111', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890'); INSERT INTO t0 VALUES (2, 2, '22222', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890'); USE db1; INSERT INTO t0 VALUES (3, 3, '33333', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890'); INSERT INTO t0 VALUES (4, 4, '44444', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890'); INSERT INTO t0 VALUES (5, 5, '55555', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890'); USE db2; INSERT INTO t0 VALUES (6, 6, '66666', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890'); INSERT INTO t0 VALUES (7, 7, '77777', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890'); INSERT INTO t0 VALUES (8, 8, '88888', '123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890'); ************************************************************ * Creating in-memory copies of the NDB tables ************************************************************ CREATE TABLE db0.t0_data ENGINE=MYISAM AS SELECT * FROM db0.t0; CREATE TABLE db1.t0_data ENGINE=MYISAM AS SELECT * FROM db1.t0; CREATE TABLE db2.t0_data ENGINE=MYISAM AS SELECT * FROM db2.t0; ************************************************************ * Backing up databases ************************************************************ ************************************************************ * Restoring databases with no rewrite (sanity check) ************************************************************ CREATE TABLE db0.t0_temp ENGINE=MYISAM AS SELECT * FROM db0.t0_data; CREATE TABLE db1.t0_temp ENGINE=MYISAM AS SELECT * FROM db1.t0_data; CREATE TABLE db2.t0_temp ENGINE=MYISAM AS SELECT * FROM db2.t0_data; DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; SELECT COUNT(*) FROM db0.t0; COUNT(*) 3 SELECT COUNT(*) FROM db1.t0; COUNT(*) 3 SELECT COUNT(*) FROM db2.t0; COUNT(*) 3 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; COUNT(*) 3 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; COUNT(*) 3 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; COUNT(*) 3 DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; ************************************************************ * Negative testing: check wrong usage of command-line option * (expected exit code for usage errors: NDBT_WRONGARGS = 2) ************************************************************ ************************************************************ * Restoring databases with redundant/self-rewrite options ************************************************************ CREATE TABLE db0.t0_temp ENGINE=MYISAM AS SELECT * FROM db0.t0_data; CREATE TABLE db1.t0_temp ENGINE=MYISAM AS SELECT * FROM db1.t0_data; CREATE TABLE db2.t0_temp ENGINE=MYISAM AS SELECT * FROM db2.t0_data; DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; SELECT COUNT(*) FROM db0.t0; COUNT(*) 3 SELECT COUNT(*) FROM db1.t0; COUNT(*) 3 SELECT COUNT(*) FROM db2.t0; COUNT(*) 3 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; COUNT(*) 3 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; COUNT(*) 3 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; COUNT(*) 3 DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; ************************************************************ * Restoring databases with overriding rewrite options ************************************************************ CREATE TABLE db0.t0_temp ENGINE=MYISAM AS SELECT * FROM db0.t0_data; CREATE TABLE db1.t0_temp ENGINE=MYISAM AS SELECT * FROM db1.t0_data; CREATE TABLE db2.t0_temp ENGINE=MYISAM AS SELECT * FROM db2.t0_data; DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; SELECT COUNT(*) FROM db0.t0; COUNT(*) 3 SELECT COUNT(*) FROM db1.t0; COUNT(*) 3 SELECT COUNT(*) FROM db2.t0; COUNT(*) 3 SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; COUNT(*) 3 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; COUNT(*) 3 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; COUNT(*) 3 DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; ************************************************************ * Restoring databases with a single rewrite ************************************************************ CREATE TABLE db0.t0_temp LIKE db0.t0_data; CREATE TABLE db1.t0_temp LIKE db1.t0_data; CREATE TABLE db2.t0_temp LIKE db2.t0_data; DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; SELECT COUNT(*) FROM db0.t0; COUNT(*) 0 SELECT COUNT(*) FROM db1.t0; COUNT(*) 6 SELECT COUNT(*) FROM db2.t0; COUNT(*) 3 INSERT db1.t0_temp SELECT * FROM db0.t0_data; INSERT db1.t0_temp SELECT * FROM db1.t0_data; INSERT db2.t0_temp SELECT * FROM db2.t0_data; SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; COUNT(*) 0 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; COUNT(*) 6 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; COUNT(*) 3 DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; ************************************************************ * Restoring databases with multiple rewrites ************************************************************ CREATE TABLE db0.t0_temp LIKE db0.t0_data; CREATE TABLE db1.t0_temp LIKE db1.t0_data; CREATE TABLE db2.t0_temp LIKE db2.t0_data; DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; SELECT COUNT(*) FROM db0.t0; COUNT(*) 0 SELECT COUNT(*) FROM db1.t0; COUNT(*) 3 SELECT COUNT(*) FROM db2.t0; COUNT(*) 6 INSERT db1.t0_temp SELECT * FROM db0.t0_data; INSERT db2.t0_temp SELECT * FROM db1.t0_data; INSERT db2.t0_temp SELECT * FROM db2.t0_data; SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; COUNT(*) 0 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; COUNT(*) 3 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; COUNT(*) 6 DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; ************************************************************ * Restoring databases with multiple rewrites into same target ************************************************************ CREATE TABLE db0.t0_temp LIKE db0.t0_data; CREATE TABLE db1.t0_temp LIKE db1.t0_data; CREATE TABLE db2.t0_temp LIKE db2.t0_data; DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; SELECT COUNT(*) FROM db0.t0; COUNT(*) 0 SELECT COUNT(*) FROM db1.t0; COUNT(*) 0 SELECT COUNT(*) FROM db2.t0; COUNT(*) 9 INSERT db2.t0_temp SELECT * FROM db0.t0_data; INSERT db2.t0_temp SELECT * FROM db1.t0_data; INSERT db2.t0_temp SELECT * FROM db2.t0_data; SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; COUNT(*) 0 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; COUNT(*) 0 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; COUNT(*) 9 DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; ************************************************************ * Restoring databases with swapping rewrites ************************************************************ CREATE TABLE db0.t0_temp LIKE db0.t0_data; CREATE TABLE db1.t0_temp LIKE db1.t0_data; CREATE TABLE db2.t0_temp LIKE db2.t0_data; DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; SELECT COUNT(*) FROM db0.t0; COUNT(*) 3 SELECT COUNT(*) FROM db1.t0; COUNT(*) 3 SELECT COUNT(*) FROM db2.t0; COUNT(*) 3 INSERT db1.t0_temp SELECT * FROM db0.t0_data; INSERT db0.t0_temp SELECT * FROM db1.t0_data; INSERT db2.t0_temp SELECT * FROM db2.t0_data; SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; COUNT(*) 3 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; COUNT(*) 3 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; COUNT(*) 3 DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; ************************************************************ * Restoring databases with permutating rewrites ************************************************************ CREATE TABLE db0.t0_temp LIKE db0.t0_data; CREATE TABLE db1.t0_temp LIKE db1.t0_data; CREATE TABLE db2.t0_temp LIKE db2.t0_data; DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; SELECT COUNT(*) FROM db0.t0; COUNT(*) 3 SELECT COUNT(*) FROM db1.t0; COUNT(*) 3 SELECT COUNT(*) FROM db2.t0; COUNT(*) 3 INSERT db1.t0_temp SELECT * FROM db0.t0_data; INSERT db2.t0_temp SELECT * FROM db1.t0_data; INSERT db0.t0_temp SELECT * FROM db2.t0_data; SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; COUNT(*) 3 SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; COUNT(*) 3 SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; COUNT(*) 3 DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; ************************************************************ * Deleting tables and databases ************************************************************ DROP DATABASE db0; DROP DATABASE db1; DROP DATABASE db2;
Close