Edit File: mysqldump.inc
################################################################################ # mysqldump.inc # # SUMMARY: include file to facilitate testing the quality of mysqldump output # # INPUTS: Two variables: # $table_name - the name of the table that was dumped # $mysqldumpfile - the name of the file that captured mysqldump output # # OUTPUTS: minor echo data: # We 'echo' some stage information to the .result file: # 'altering original table', 'restoring from dumpfile', 'comparing' # # OTHER FILES: We use include/diff_tables.inc to compare the original, renamed # table with the 'restored' one. # # DESCRIPTION: This file works by being fed the name of the original table # and a mysqldump output file. The original table is then renamed # to <table_name>_orig, the mysqldump file is used to recreate the # table, then diff_tables.inc is called to compare them. # # LIMITATIONS: Does *NOT* work with xml output! # # AUTHOR: pcrews 2009-05-21 # Bug#40465 mysqldump.test does no checking of dump or restore # # LAST CHANGE: 2009-05-21 # ################################################################################ --echo # Begin testing mysqldump output + restore --echo # Create 'original table name - <table>_orig # NOTE: We use SET then let as query_get_value has issues with the extra commas # used in the CONCAT statement. eval SET @orig_table_name = CONCAT('$table_name', '_orig'); let $orig_table_name = query_get_value(SELECT @orig_table_name,@orig_table_name,1); --echo # Rename original table eval ALTER TABLE $table_name RENAME to $orig_table_name; --echo # Recreate table from mysqldump output --exec $MYSQL test < $mysqldumpfile --echo # Compare original and recreated tables --echo # Recreated table: $table_name --echo # Original table: $orig_table_name let $diff_tables = $table_name, $orig_table_name; --source include/diff_tables.inc --echo # Cleanup --remove_file $mysqldumpfile eval DROP TABLE $table_name, $orig_table_name;