List:Commits« Previous MessageNext Message »
From:Hema Sridharan Date:July 7 2008 10:26pm
Subject:bzr commit into mysql-6.0-backup branch (hema:2650) WL#4227
View as plain text  
#At file:///data0/backupjul2/mysql-6.0-backup/

 2650 Hema Sridharan	2008-07-08
      WL#4227(Test of identifiers for character sets). The test included are test of partitions and different datatypes.
added:
  mysql-test/suite/backup_charsets/
  mysql-test/suite/backup_charsets/combinations
  mysql-test/suite/backup_charsets/include/
  mysql-test/suite/backup_charsets/include/charset.inc
  mysql-test/suite/backup_charsets/include/not_have_falcon.inc
  mysql-test/suite/backup_charsets/r/
  mysql-test/suite/backup_charsets/r/backup_datatypes.result
  mysql-test/suite/backup_charsets/r/backup_partitions.result
  mysql-test/suite/backup_charsets/t/
  mysql-test/suite/backup_charsets/t/backup_datatypes.test
  mysql-test/suite/backup_charsets/t/backup_partitions.test

=== added directory 'mysql-test/suite/backup_charsets'
=== added file 'mysql-test/suite/backup_charsets/combinations'
--- a/mysql-test/suite/backup_charsets/combinations	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/backup_charsets/combinations	2008-07-07 22:22:55 +0000
@@ -0,0 +1,1500 @@
+[myisam big5 big5_chinese_ci]
+--default-storage-engine=myisam
+--default-character-set=big5 
+--default-collation=big5_chinese_ci 
+[innodb big5 big5_chinese_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=big5 
+--default-collation=big5_chinese_ci 
+[falcon big5 big5_chinese_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=big5 
+--default-collation=big5_chinese_ci 
+[myisam big5 big5_bin]
+--default-storage-engine=myisam
+--default-character-set=big5 
+--default-collation=big5_bin 
+[innodb big5 big5_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=big5 
+--default-collation=big5_bin 
+[falcon big5 big5_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=big5 
+--default-collation=big5_bin 
+[myisam dec8 dec8_swedish_ci]
+--default-storage-engine=myisam
+--default-character-set=dec8 
+--default-collation=dec8_swedish_ci 
+[innodb dec8 dec8_swedish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=dec8 
+--default-collation=dec8_swedish_ci 
+[falcon dec8 dec8_swedish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=dec8 
+--default-collation=dec8_swedish_ci 
+[myisam dec8 dec8_bin]
+--default-storage-engine=myisam
+--default-character-set=dec8 
+--default-collation=dec8_bin 
+[innodb dec8 dec8_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=dec8 
+--default-collation=dec8_bin 
+[falcon dec8 dec8_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=dec8 
+--default-collation=dec8_bin 
+[myisam cp850 cp850_general_ci]
+--default-storage-engine=myisam
+--default-character-set=cp850 
+--default-collation=cp850_general_ci 
+[innodb cp850 cp850_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp850 
+--default-collation=cp850_general_ci 
+[falcon cp850 cp850_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp850 
+--default-collation=cp850_general_ci 
+[myisam cp850 cp850_bin]
+--default-storage-engine=myisam
+--default-character-set=cp850 
+--default-collation=cp850_bin 
+[innodb cp850 cp850_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp850 
+--default-collation=cp850_bin 
+[falcon cp850 cp850_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp850 
+--default-collation=cp850_bin 
+[myisam hp8 hp8_english_ci]
+--default-storage-engine=myisam
+--default-character-set=hp8 
+--default-collation=hp8_english_ci 
+[innodb hp8 hp8_english_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=hp8 
+--default-collation=hp8_english_ci 
+[falcon hp8 hp8_english_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=hp8 
+--default-collation=hp8_english_ci 
+[myisam hp8 hp8_bin]
+--default-storage-engine=myisam
+--default-character-set=hp8 
+--default-collation=hp8_bin 
+[innodb hp8 hp8_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=hp8 
+--default-collation=hp8_bin 
+[falcon hp8 hp8_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=hp8 
+--default-collation=hp8_bin 
+[myisam koi8r koi8r_general_ci]
+--default-storage-engine=myisam
+--default-character-set=koi8r 
+--default-collation=koi8r_general_ci 
+[innodb koi8r koi8r_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=koi8r 
+--default-collation=koi8r_general_ci 
+[falcon koi8r koi8r_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=koi8r 
+--default-collation=koi8r_general_ci 
+[myisam koi8r koi8r_bin]
+--default-storage-engine=myisam
+--default-character-set=koi8r 
+--default-collation=koi8r_bin 
+[innodb koi8r koi8r_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=koi8r 
+--default-collation=koi8r_bin 
+[falcon koi8r koi8r_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=koi8r 
+--default-collation=koi8r_bin 
+[myisam latin1 latin1_german1_ci]
+--default-storage-engine=myisam
+--default-character-set=latin1 
+--default-collation=latin1_german1_ci 
+[innodb latin1 latin1_german1_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1 
+--default-collation=latin1_german1_ci 
+[falcon latin1 latin1_german1_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1 
+--default-collation=latin1_german1_ci 
+[myisam latin1 latin1_swedish_ci]
+--default-storage-engine=myisam
+--default-character-set=latin1 
+--default-collation=latin1_swedish_ci 
+[innodb latin1 latin1_swedish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1 
+--default-collation=latin1_swedish_ci 
+[falcon latin1 latin1_swedish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1 
+--default-collation=latin1_swedish_ci 
+[myisam latin1 latin1_danish_ci]
+--default-storage-engine=myisam
+--default-character-set=latin1 
+--default-collation=latin1_danish_ci 
+[innodb latin1 latin1_danish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1 
+--default-collation=latin1_danish_ci 
+[falcon latin1 latin1_danish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1 
+--default-collation=latin1_danish_ci 
+[myisam latin1 latin1_german2_ci]
+--default-storage-engine=myisam
+--default-character-set=latin1 
+--default-collation=latin1_german2_ci 
+[innodb latin1 latin1_german2_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1 
+--default-collation=latin1_german2_ci 
+[falcon latin1 latin1_german2_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1 
+--default-collation=latin1_german2_ci 
+[myisam latin1 latin1_bin]
+--default-storage-engine=myisam
+--default-character-set=latin1 
+--default-collation=latin1_bin 
+[innodb latin1 latin1_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1 
+--default-collation=latin1_bin 
+[falcon latin1 latin1_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1 
+--default-collation=latin1_bin 
+[myisam latin1 latin1_general_ci]
+--default-storage-engine=myisam
+--default-character-set=latin1 
+--default-collation=latin1_general_ci 
+[innodb latin1 latin1_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1 
+--default-collation=latin1_general_ci 
+[falcon latin1 latin1_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1 
+--default-collation=latin1_general_ci 
+[myisam latin1 latin1_general_cs]
+--default-storage-engine=myisam
+--default-character-set=latin1 
+--default-collation=latin1_general_cs 
+[innodb latin1 latin1_general_cs]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1 
+--default-collation=latin1_general_cs 
+[falcon latin1 latin1_general_cs]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1 
+--default-collation=latin1_general_cs 
+[myisam latin1 latin1_spanish_ci]
+--default-storage-engine=myisam
+--default-character-set=latin1 
+--default-collation=latin1_spanish_ci 
+[innodb latin1 latin1_spanish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin1 
+--default-collation=latin1_spanish_ci 
+[falcon latin1 latin1_spanish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin1 
+--default-collation=latin1_spanish_ci 
+[myisam latin2 latin2_czech_cs]
+--default-storage-engine=myisam
+--default-character-set=latin2 
+--default-collation=latin2_czech_cs 
+[innodb latin2 latin2_czech_cs]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin2 
+--default-collation=latin2_czech_cs 
+[falcon latin2 latin2_czech_cs]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin2 
+--default-collation=latin2_czech_cs 
+[myisam latin2 latin2_general_ci]
+--default-storage-engine=myisam
+--default-character-set=latin2 
+--default-collation=latin2_general_ci 
+[innodb latin2 latin2_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin2 
+--default-collation=latin2_general_ci 
+[falcon latin2 latin2_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin2 
+--default-collation=latin2_general_ci 
+[myisam latin2 latin2_hungarian_ci]
+--default-storage-engine=myisam
+--default-character-set=latin2 
+--default-collation=latin2_hungarian_ci 
+[innodb latin2 latin2_hungarian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin2 
+--default-collation=latin2_hungarian_ci 
+[falcon latin2 latin2_hungarian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin2 
+--default-collation=latin2_hungarian_ci 
+[myisam latin2 latin2_croatian_ci]
+--default-storage-engine=myisam
+--default-character-set=latin2 
+--default-collation=latin2_croatian_ci 
+[innodb latin2 latin2_croatian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin2 
+--default-collation=latin2_croatian_ci 
+[falcon latin2 latin2_croatian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin2 
+--default-collation=latin2_croatian_ci 
+[myisam latin2 latin2_bin]
+--default-storage-engine=myisam
+--default-character-set=latin2 
+--default-collation=latin2_bin 
+[innodb latin2 latin2_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin2 
+--default-collation=latin2_bin 
+[falcon latin2 latin2_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin2 
+--default-collation=latin2_bin 
+[myisam ascii ascii_general_ci]
+--default-storage-engine=myisam
+--default-character-set=ascii 
+--default-collation=ascii_general_ci 
+[innodb ascii ascii_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=ascii 
+--default-collation=ascii_general_ci 
+[falcon ascii ascii_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=ascii 
+--default-collation=ascii_general_ci 
+[myisam ascii ascii_bin]
+--default-storage-engine=myisam
+--default-character-set=ascii 
+--default-collation=ascii_bin 
+[innodb ascii ascii_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=ascii 
+--default-collation=ascii_bin 
+[falcon ascii ascii_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=ascii 
+--default-collation=ascii_bin 
+[myisam ujis ujis_japanese_ci]
+--default-storage-engine=myisam
+--default-character-set=ujis 
+--default-collation=ujis_japanese_ci 
+[innodb ujis ujis_japanese_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=ujis 
+--default-collation=ujis_japanese_ci 
+[falcon ujis ujis_japanese_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=ujis 
+--default-collation=ujis_japanese_ci 
+[myisam ujis ujis_bin]
+--default-storage-engine=myisam
+--default-character-set=ujis 
+--default-collation=ujis_bin 
+[innodb ujis ujis_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=ujis 
+--default-collation=ujis_bin 
+[falcon ujis ujis_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=ujis 
+--default-collation=ujis_bin 
+[myisam sjis sjis_japanese_ci]
+--default-storage-engine=myisam
+--default-character-set=sjis 
+--default-collation=sjis_japanese_ci 
+[innodb sjis sjis_japanese_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=sjis 
+--default-collation=sjis_japanese_ci 
+[falcon sjis sjis_japanese_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=sjis 
+--default-collation=sjis_japanese_ci 
+[myisam sjis sjis_bin]
+--default-storage-engine=myisam
+--default-character-set=sjis 
+--default-collation=sjis_bin 
+[innodb sjis sjis_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=sjis 
+--default-collation=sjis_bin 
+[falcon sjis sjis_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=sjis 
+--default-collation=sjis_bin 
+[myisam hebrew hebrew_general_ci]
+--default-storage-engine=myisam
+--default-character-set=hebrew 
+--default-collation=hebrew_general_ci 
+[innodb hebrew hebrew_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=hebrew 
+--default-collation=hebrew_general_ci 
+[falcon hebrew hebrew_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=hebrew 
+--default-collation=hebrew_general_ci 
+[myisam hebrew hebrew_bin]
+--default-storage-engine=myisam
+--default-character-set=hebrew 
+--default-collation=hebrew_bin 
+[innodb hebrew hebrew_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=hebrew 
+--default-collation=hebrew_bin 
+[falcon hebrew hebrew_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=hebrew 
+--default-collation=hebrew_bin 
+[myisam tis620 tis620_thai_ci]
+--default-storage-engine=myisam
+--default-character-set=tis620 
+--default-collation=tis620_thai_ci 
+[innodb tis620 tis620_thai_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=tis620 
+--default-collation=tis620_thai_ci 
+[falcon tis620 tis620_thai_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=tis620 
+--default-collation=tis620_thai_ci 
+[myisam tis620 tis620_bin]
+--default-storage-engine=myisam
+--default-character-set=tis620 
+--default-collation=tis620_bin 
+[innodb tis620 tis620_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=tis620 
+--default-collation=tis620_bin 
+[falcon tis620 tis620_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=tis620 
+--default-collation=tis620_bin 
+[myisam euckr euckr_korean_ci]
+--default-storage-engine=myisam
+--default-character-set=euckr 
+--default-collation=euckr_korean_ci 
+[innodb euckr euckr_korean_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=euckr 
+--default-collation=euckr_korean_ci 
+[falcon euckr euckr_korean_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=euckr 
+--default-collation=euckr_korean_ci 
+[myisam euckr euckr_bin]
+--default-storage-engine=myisam
+--default-character-set=euckr 
+--default-collation=euckr_bin 
+[innodb euckr euckr_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=euckr 
+--default-collation=euckr_bin 
+[falcon euckr euckr_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=euckr 
+--default-collation=euckr_bin 
+[myisam koi8u koi8u_general_ci]
+--default-storage-engine=myisam
+--default-character-set=koi8u 
+--default-collation=koi8u_general_ci 
+[innodb koi8u koi8u_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=koi8u 
+--default-collation=koi8u_general_ci 
+[falcon koi8u koi8u_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=koi8u 
+--default-collation=koi8u_general_ci 
+[myisam koi8u koi8u_bin]
+--default-storage-engine=myisam
+--default-character-set=koi8u 
+--default-collation=koi8u_bin 
+[innodb koi8u koi8u_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=koi8u 
+--default-collation=koi8u_bin 
+[falcon koi8u koi8u_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=koi8u 
+--default-collation=koi8u_bin 
+[myisam gb2312 gb2312_chinese_ci]
+--default-storage-engine=myisam
+--default-character-set=gb2312 
+--default-collation=gb2312_chinese_ci 
+[innodb gb2312 gb2312_chinese_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=gb2312 
+--default-collation=gb2312_chinese_ci 
+[falcon gb2312 gb2312_chinese_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=gb2312 
+--default-collation=gb2312_chinese_ci 
+[myisam gb2312 gb2312_bin]
+--default-storage-engine=myisam
+--default-character-set=gb2312 
+--default-collation=gb2312_bin 
+[innodb gb2312 gb2312_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=gb2312 
+--default-collation=gb2312_bin 
+[falcon gb2312 gb2312_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=gb2312 
+--default-collation=gb2312_bin 
+[myisam greek greek_general_ci]
+--default-storage-engine=myisam
+--default-character-set=greek 
+--default-collation=greek_general_ci 
+[innodb greek greek_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=greek 
+--default-collation=greek_general_ci 
+[falcon greek greek_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=greek 
+--default-collation=greek_general_ci 
+[myisam greek greek_bin]
+--default-storage-engine=myisam
+--default-character-set=greek 
+--default-collation=greek_bin 
+[innodb greek greek_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=greek 
+--default-collation=greek_bin 
+[falcon greek greek_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=greek 
+--default-collation=greek_bin 
+[myisam cp1250 cp1250_general_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1250 
+--default-collation=cp1250_general_ci 
+[innodb cp1250 cp1250_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1250 
+--default-collation=cp1250_general_ci 
+[falcon cp1250 cp1250_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1250 
+--default-collation=cp1250_general_ci 
+[myisam cp1250 cp1250_czech_cs]
+--default-storage-engine=myisam
+--default-character-set=cp1250 
+--default-collation=cp1250_czech_cs 
+[innodb cp1250 cp1250_czech_cs]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1250 
+--default-collation=cp1250_czech_cs 
+[falcon cp1250 cp1250_czech_cs]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1250 
+--default-collation=cp1250_czech_cs 
+[myisam cp1250 cp1250_croatian_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1250 
+--default-collation=cp1250_croatian_ci 
+[innodb cp1250 cp1250_croatian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1250 
+--default-collation=cp1250_croatian_ci 
+[falcon cp1250 cp1250_croatian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1250 
+--default-collation=cp1250_croatian_ci 
+[myisam cp1250 cp1250_bin]
+--default-storage-engine=myisam
+--default-character-set=cp1250 
+--default-collation=cp1250_bin 
+[innodb cp1250 cp1250_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1250 
+--default-collation=cp1250_bin 
+[falcon cp1250 cp1250_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1250 
+--default-collation=cp1250_bin 
+[myisam cp1250 cp1250_polish_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1250 
+--default-collation=cp1250_polish_ci 
+[innodb cp1250 cp1250_polish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1250 
+--default-collation=cp1250_polish_ci 
+[falcon cp1250 cp1250_polish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1250 
+--default-collation=cp1250_polish_ci 
+[myisam gbk gbk_chinese_ci]
+--default-storage-engine=myisam
+--default-character-set=gbk 
+--default-collation=gbk_chinese_ci 
+[innodb gbk gbk_chinese_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=gbk 
+--default-collation=gbk_chinese_ci 
+[falcon gbk gbk_chinese_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=gbk 
+--default-collation=gbk_chinese_ci 
+[myisam gbk gbk_bin]
+--default-storage-engine=myisam
+--default-character-set=gbk 
+--default-collation=gbk_bin 
+[innodb gbk gbk_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=gbk 
+--default-collation=gbk_bin 
+[falcon gbk gbk_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=gbk 
+--default-collation=gbk_bin 
+[myisam latin5 latin5_turkish_ci]
+--default-storage-engine=myisam
+--default-character-set=latin5 
+--default-collation=latin5_turkish_ci 
+[innodb latin5 latin5_turkish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin5 
+--default-collation=latin5_turkish_ci 
+[falcon latin5 latin5_turkish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin5 
+--default-collation=latin5_turkish_ci 
+[myisam latin5 latin5_bin]
+--default-storage-engine=myisam
+--default-character-set=latin5 
+--default-collation=latin5_bin 
+[innodb latin5 latin5_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin5 
+--default-collation=latin5_bin 
+[falcon latin5 latin5_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin5 
+--default-collation=latin5_bin 
+[myisam armscii8 armscii8_general_ci]
+--default-storage-engine=myisam
+--default-character-set=armscii8 
+--default-collation=armscii8_general_ci 
+[innodb armscii8 armscii8_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=armscii8 
+--default-collation=armscii8_general_ci 
+[falcon armscii8 armscii8_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=armscii8 
+--default-collation=armscii8_general_ci 
+[myisam armscii8 armscii8_bin]
+--default-storage-engine=myisam
+--default-character-set=armscii8 
+--default-collation=armscii8_bin 
+[innodb armscii8 armscii8_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=armscii8 
+--default-collation=armscii8_bin 
+[falcon armscii8 armscii8_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=armscii8 
+--default-collation=armscii8_bin 
+[myisam utf8mb3 utf8mb3_general_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_general_ci 
+[innodb utf8mb3 utf8mb3_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_general_ci 
+[falcon utf8mb3 utf8mb3_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_general_ci 
+[myisam utf8mb3 utf8mb3_bin]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_bin 
+[innodb utf8mb3 utf8mb3_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_bin 
+[falcon utf8mb3 utf8mb3_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_bin 
+[myisam utf8mb3 utf8mb3_unicode_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_unicode_ci 
+[innodb utf8mb3 utf8mb3_unicode_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_unicode_ci 
+[falcon utf8mb3 utf8mb3_unicode_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_unicode_ci 
+[myisam utf8mb3 utf8mb3_icelandic_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_icelandic_ci 
+[innodb utf8mb3 utf8mb3_icelandic_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_icelandic_ci 
+[falcon utf8mb3 utf8mb3_icelandic_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_icelandic_ci 
+[myisam utf8mb3 utf8mb3_latvian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_latvian_ci 
+[innodb utf8mb3 utf8mb3_latvian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_latvian_ci 
+[falcon utf8mb3 utf8mb3_latvian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_latvian_ci 
+[myisam utf8mb3 utf8mb3_romanian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_romanian_ci 
+[innodb utf8mb3 utf8mb3_romanian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_romanian_ci 
+[falcon utf8mb3 utf8mb3_romanian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_romanian_ci 
+[myisam utf8mb3 utf8mb3_slovenian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_slovenian_ci 
+[innodb utf8mb3 utf8mb3_slovenian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_slovenian_ci 
+[falcon utf8mb3 utf8mb3_slovenian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_slovenian_ci 
+[myisam utf8mb3 utf8mb3_polish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_polish_ci 
+[innodb utf8mb3 utf8mb3_polish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_polish_ci 
+[falcon utf8mb3 utf8mb3_polish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_polish_ci 
+[myisam utf8mb3 utf8mb3_estonian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_estonian_ci 
+[innodb utf8mb3 utf8mb3_estonian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_estonian_ci 
+[falcon utf8mb3 utf8mb3_estonian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_estonian_ci 
+[myisam utf8mb3 utf8mb3_spanish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_spanish_ci 
+[innodb utf8mb3 utf8mb3_spanish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_spanish_ci 
+[falcon utf8mb3 utf8mb3_spanish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_spanish_ci 
+[myisam utf8mb3 utf8mb3_swedish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_swedish_ci 
+[innodb utf8mb3 utf8mb3_swedish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_swedish_ci 
+[falcon utf8mb3 utf8mb3_swedish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_swedish_ci 
+[myisam utf8mb3 utf8mb3_turkish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_turkish_ci 
+[innodb utf8mb3 utf8mb3_turkish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_turkish_ci 
+[falcon utf8mb3 utf8mb3_turkish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_turkish_ci 
+[myisam utf8mb3 utf8mb3_czech_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_czech_ci 
+[innodb utf8mb3 utf8mb3_czech_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_czech_ci 
+[falcon utf8mb3 utf8mb3_czech_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_czech_ci 
+[myisam utf8mb3 utf8mb3_danish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_danish_ci 
+[innodb utf8mb3 utf8mb3_danish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_danish_ci 
+[falcon utf8mb3 utf8mb3_danish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_danish_ci 
+[myisam utf8mb3 utf8mb3_lithuanian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_lithuanian_ci 
+[innodb utf8mb3 utf8mb3_lithuanian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_lithuanian_ci 
+[falcon utf8mb3 utf8mb3_lithuanian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_lithuanian_ci 
+[myisam utf8mb3 utf8mb3_slovak_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_slovak_ci 
+[innodb utf8mb3 utf8mb3_slovak_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_slovak_ci 
+[falcon utf8mb3 utf8mb3_slovak_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_slovak_ci 
+[myisam utf8mb3 utf8mb3_spanish2_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_spanish2_ci 
+[innodb utf8mb3 utf8mb3_spanish2_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_spanish2_ci 
+[falcon utf8mb3 utf8mb3_spanish2_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_spanish2_ci 
+[myisam utf8mb3 utf8mb3_roman_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_roman_ci 
+[innodb utf8mb3 utf8mb3_roman_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_roman_ci 
+[falcon utf8mb3 utf8mb3_roman_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_roman_ci 
+[myisam utf8mb3 utf8mb3_persian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_persian_ci 
+[innodb utf8mb3 utf8mb3_persian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_persian_ci 
+[falcon utf8mb3 utf8mb3_persian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_persian_ci 
+[myisam utf8mb3 utf8mb3_esperanto_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_esperanto_ci 
+[innodb utf8mb3 utf8mb3_esperanto_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_esperanto_ci 
+[falcon utf8mb3 utf8mb3_esperanto_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_esperanto_ci 
+[myisam utf8mb3 utf8mb3_hungarian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_hungarian_ci 
+[innodb utf8mb3 utf8mb3_hungarian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_hungarian_ci 
+[falcon utf8mb3 utf8mb3_hungarian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8mb3 
+--default-collation=utf8mb3_hungarian_ci 
+[myisam cp866 cp866_general_ci]
+--default-storage-engine=myisam
+--default-character-set=cp866 
+--default-collation=cp866_general_ci 
+[innodb cp866 cp866_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp866 
+--default-collation=cp866_general_ci 
+[falcon cp866 cp866_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp866 
+--default-collation=cp866_general_ci 
+[myisam cp866 cp866_bin]
+--default-storage-engine=myisam
+--default-character-set=cp866 
+--default-collation=cp866_bin 
+[innodb cp866 cp866_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp866 
+--default-collation=cp866_bin 
+[falcon cp866 cp866_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp866 
+--default-collation=cp866_bin 
+[myisam keybcs2 keybcs2_general_ci]
+--default-storage-engine=myisam
+--default-character-set=keybcs2 
+--default-collation=keybcs2_general_ci 
+[innodb keybcs2 keybcs2_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=keybcs2 
+--default-collation=keybcs2_general_ci 
+[falcon keybcs2 keybcs2_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=keybcs2 
+--default-collation=keybcs2_general_ci 
+[myisam keybcs2 keybcs2_bin]
+--default-storage-engine=myisam
+--default-character-set=keybcs2 
+--default-collation=keybcs2_bin 
+[innodb keybcs2 keybcs2_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=keybcs2 
+--default-collation=keybcs2_bin 
+[falcon keybcs2 keybcs2_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=keybcs2 
+--default-collation=keybcs2_bin 
+[myisam macce macce_general_ci]
+--default-storage-engine=myisam
+--default-character-set=macce 
+--default-collation=macce_general_ci 
+[innodb macce macce_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=macce 
+--default-collation=macce_general_ci 
+[falcon macce macce_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=macce 
+--default-collation=macce_general_ci 
+[myisam macce macce_bin]
+--default-storage-engine=myisam
+--default-character-set=macce 
+--default-collation=macce_bin 
+[innodb macce macce_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=macce 
+--default-collation=macce_bin 
+[falcon macce macce_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=macce 
+--default-collation=macce_bin 
+[myisam macroman macroman_general_ci]
+--default-storage-engine=myisam
+--default-character-set=macroman 
+--default-collation=macroman_general_ci 
+[innodb macroman macroman_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=macroman 
+--default-collation=macroman_general_ci 
+[falcon macroman macroman_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=macroman 
+--default-collation=macroman_general_ci 
+[myisam macroman macroman_bin]
+--default-storage-engine=myisam
+--default-character-set=macroman 
+--default-collation=macroman_bin 
+[innodb macroman macroman_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=macroman 
+--default-collation=macroman_bin 
+[falcon macroman macroman_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=macroman 
+--default-collation=macroman_bin 
+[myisam cp852 cp852_general_ci]
+--default-storage-engine=myisam
+--default-character-set=cp852 
+--default-collation=cp852_general_ci 
+[innodb cp852 cp852_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp852 
+--default-collation=cp852_general_ci 
+[falcon cp852 cp852_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp852 
+--default-collation=cp852_general_ci 
+[myisam cp852 cp852_bin]
+--default-storage-engine=myisam
+--default-character-set=cp852 
+--default-collation=cp852_bin 
+[innodb cp852 cp852_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp852 
+--default-collation=cp852_bin 
+[falcon cp852 cp852_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp852 
+--default-collation=cp852_bin 
+[myisam latin7 latin7_estonian_cs]
+--default-storage-engine=myisam
+--default-character-set=latin7 
+--default-collation=latin7_estonian_cs 
+[innodb latin7 latin7_estonian_cs]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin7 
+--default-collation=latin7_estonian_cs 
+[falcon latin7 latin7_estonian_cs]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin7 
+--default-collation=latin7_estonian_cs 
+[myisam latin7 latin7_general_ci]
+--default-storage-engine=myisam
+--default-character-set=latin7 
+--default-collation=latin7_general_ci 
+[innodb latin7 latin7_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin7 
+--default-collation=latin7_general_ci 
+[falcon latin7 latin7_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin7 
+--default-collation=latin7_general_ci 
+[myisam latin7 latin7_general_cs]
+--default-storage-engine=myisam
+--default-character-set=latin7 
+--default-collation=latin7_general_cs 
+[innodb latin7 latin7_general_cs]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin7 
+--default-collation=latin7_general_cs 
+[falcon latin7 latin7_general_cs]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin7 
+--default-collation=latin7_general_cs 
+[myisam latin7 latin7_bin]
+--default-storage-engine=myisam
+--default-character-set=latin7 
+--default-collation=latin7_bin 
+[innodb latin7 latin7_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=latin7 
+--default-collation=latin7_bin 
+[falcon latin7 latin7_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=latin7 
+--default-collation=latin7_bin 
+[myisam utf8 utf8_general_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_general_ci 
+[innodb utf8 utf8_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_general_ci 
+[falcon utf8 utf8_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_general_ci 
+[myisam utf8 utf8_bin]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_bin 
+[innodb utf8 utf8_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_bin 
+[falcon utf8 utf8_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_bin 
+[myisam utf8 utf8_unicode_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_unicode_ci 
+[innodb utf8 utf8_unicode_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_unicode_ci 
+[falcon utf8 utf8_unicode_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_unicode_ci 
+[myisam utf8 utf8_icelandic_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_icelandic_ci 
+[innodb utf8 utf8_icelandic_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_icelandic_ci 
+[falcon utf8 utf8_icelandic_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_icelandic_ci 
+[myisam utf8 utf8_latvian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_latvian_ci 
+[innodb utf8 utf8_latvian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_latvian_ci 
+[falcon utf8 utf8_latvian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_latvian_ci 
+[myisam utf8 utf8_romanian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_romanian_ci 
+[innodb utf8 utf8_romanian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_romanian_ci 
+[falcon utf8 utf8_romanian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_romanian_ci 
+[myisam utf8 utf8_slovenian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_slovenian_ci 
+[innodb utf8 utf8_slovenian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_slovenian_ci 
+[falcon utf8 utf8_slovenian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_slovenian_ci 
+[myisam utf8 utf8_polish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_polish_ci 
+[innodb utf8 utf8_polish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_polish_ci 
+[falcon utf8 utf8_polish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_polish_ci 
+[myisam utf8 utf8_estonian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_estonian_ci 
+[innodb utf8 utf8_estonian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_estonian_ci 
+[falcon utf8 utf8_estonian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_estonian_ci 
+[myisam utf8 utf8_spanish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_spanish_ci 
+[innodb utf8 utf8_spanish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_spanish_ci 
+[falcon utf8 utf8_spanish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_spanish_ci 
+[myisam utf8 utf8_swedish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_swedish_ci 
+[innodb utf8 utf8_swedish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_swedish_ci 
+[falcon utf8 utf8_swedish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_swedish_ci 
+[myisam utf8 utf8_turkish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_turkish_ci 
+[innodb utf8 utf8_turkish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_turkish_ci 
+[falcon utf8 utf8_turkish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_turkish_ci 
+[myisam utf8 utf8_czech_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_czech_ci 
+[innodb utf8 utf8_czech_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_czech_ci 
+[falcon utf8 utf8_czech_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_czech_ci 
+[myisam utf8 utf8_danish_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_danish_ci 
+[innodb utf8 utf8_danish_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_danish_ci 
+[falcon utf8 utf8_danish_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_danish_ci 
+[myisam utf8 utf8_lithuanian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_lithuanian_ci 
+[innodb utf8 utf8_lithuanian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_lithuanian_ci 
+[falcon utf8 utf8_lithuanian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_lithuanian_ci 
+[myisam utf8 utf8_slovak_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_slovak_ci 
+[innodb utf8 utf8_slovak_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_slovak_ci 
+[falcon utf8 utf8_slovak_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_slovak_ci 
+[myisam utf8 utf8_spanish2_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_spanish2_ci 
+[innodb utf8 utf8_spanish2_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_spanish2_ci 
+[falcon utf8 utf8_spanish2_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_spanish2_ci 
+[myisam utf8 utf8_roman_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_roman_ci 
+[innodb utf8 utf8_roman_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_roman_ci 
+[falcon utf8 utf8_roman_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_roman_ci 
+[myisam utf8 utf8_persian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_persian_ci 
+[innodb utf8 utf8_persian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_persian_ci 
+[falcon utf8 utf8_persian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_persian_ci 
+[myisam utf8 utf8_esperanto_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_esperanto_ci 
+[innodb utf8 utf8_esperanto_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_esperanto_ci 
+[falcon utf8 utf8_esperanto_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_esperanto_ci 
+[myisam utf8 utf8_hungarian_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_hungarian_ci 
+[innodb utf8 utf8_hungarian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_hungarian_ci 
+[falcon utf8 utf8_hungarian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_hungarian_ci 
+[myisam utf8 utf8_sinhala_ci]
+--default-storage-engine=myisam
+--default-character-set=utf8 
+--default-collation=utf8_sinhala_ci 
+[innodb utf8 utf8_sinhala_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=utf8 
+--default-collation=utf8_sinhala_ci 
+[falcon utf8 utf8_sinhala_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=utf8 
+--default-collation=utf8_sinhala_ci 
+[myisam cp1251 cp1251_bulgarian_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1251 
+--default-collation=cp1251_bulgarian_ci 
+[innodb cp1251 cp1251_bulgarian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1251 
+--default-collation=cp1251_bulgarian_ci 
+[falcon cp1251 cp1251_bulgarian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1251 
+--default-collation=cp1251_bulgarian_ci 
+[myisam cp1251 cp1251_ukrainian_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1251 
+--default-collation=cp1251_ukrainian_ci 
+[innodb cp1251 cp1251_ukrainian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1251 
+--default-collation=cp1251_ukrainian_ci 
+[falcon cp1251 cp1251_ukrainian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1251 
+--default-collation=cp1251_ukrainian_ci 
+[myisam cp1251 cp1251_bin]
+--default-storage-engine=myisam
+--default-character-set=cp1251 
+--default-collation=cp1251_bin 
+[innodb cp1251 cp1251_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1251 
+--default-collation=cp1251_bin 
+[falcon cp1251 cp1251_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1251 
+--default-collation=cp1251_bin 
+[myisam cp1251 cp1251_general_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1251 
+--default-collation=cp1251_general_ci 
+[innodb cp1251 cp1251_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1251 
+--default-collation=cp1251_general_ci 
+[falcon cp1251 cp1251_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1251 
+--default-collation=cp1251_general_ci 
+[myisam cp1251 cp1251_general_cs]
+--default-storage-engine=myisam
+--default-character-set=cp1251 
+--default-collation=cp1251_general_cs 
+[innodb cp1251 cp1251_general_cs]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1251 
+--default-collation=cp1251_general_cs 
+[falcon cp1251 cp1251_general_cs]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1251 
+--default-collation=cp1251_general_cs 
+[myisam cp1256 cp1256_general_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1256 
+--default-collation=cp1256_general_ci 
+[innodb cp1256 cp1256_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1256 
+--default-collation=cp1256_general_ci 
+[falcon cp1256 cp1256_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1256 
+--default-collation=cp1256_general_ci 
+[myisam cp1256 cp1256_bin]
+--default-storage-engine=myisam
+--default-character-set=cp1256 
+--default-collation=cp1256_bin 
+[innodb cp1256 cp1256_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1256 
+--default-collation=cp1256_bin 
+[falcon cp1256 cp1256_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1256 
+--default-collation=cp1256_bin 
+[myisam cp1257 cp1257_lithuanian_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1257 
+--default-collation=cp1257_lithuanian_ci 
+[innodb cp1257 cp1257_lithuanian_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1257 
+--default-collation=cp1257_lithuanian_ci 
+[falcon cp1257 cp1257_lithuanian_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1257 
+--default-collation=cp1257_lithuanian_ci 
+[myisam cp1257 cp1257_bin]
+--default-storage-engine=myisam
+--default-character-set=cp1257 
+--default-collation=cp1257_bin 
+[innodb cp1257 cp1257_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1257 
+--default-collation=cp1257_bin 
+[falcon cp1257 cp1257_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1257 
+--default-collation=cp1257_bin 
+[myisam cp1257 cp1257_general_ci]
+--default-storage-engine=myisam
+--default-character-set=cp1257 
+--default-collation=cp1257_general_ci 
+[innodb cp1257 cp1257_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp1257 
+--default-collation=cp1257_general_ci 
+[falcon cp1257 cp1257_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp1257 
+--default-collation=cp1257_general_ci 
+[myisam geostd8 geostd8_general_ci]
+--default-storage-engine=myisam
+--default-character-set=geostd8 
+--default-collation=geostd8_general_ci 
+[innodb geostd8 geostd8_general_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=geostd8 
+--default-collation=geostd8_general_ci 
+[falcon geostd8 geostd8_general_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=geostd8 
+--default-collation=geostd8_general_ci 
+[myisam geostd8 geostd8_bin]
+--default-storage-engine=myisam
+--default-character-set=geostd8 
+--default-collation=geostd8_bin 
+[innodb geostd8 geostd8_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=geostd8 
+--default-collation=geostd8_bin 
+[falcon geostd8 geostd8_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=geostd8 
+--default-collation=geostd8_bin 
+[myisam cp932 cp932_japanese_ci]
+--default-storage-engine=myisam
+--default-character-set=cp932 
+--default-collation=cp932_japanese_ci 
+[innodb cp932 cp932_japanese_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp932 
+--default-collation=cp932_japanese_ci 
+[falcon cp932 cp932_japanese_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp932 
+--default-collation=cp932_japanese_ci 
+[myisam cp932 cp932_bin]
+--default-storage-engine=myisam
+--default-character-set=cp932 
+--default-collation=cp932_bin 
+[innodb cp932 cp932_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=cp932 
+--default-collation=cp932_bin 
+[falcon cp932 cp932_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=cp932 
+--default-collation=cp932_bin 
+[myisam eucjpms eucjpms_japanese_ci]
+--default-storage-engine=myisam
+--default-character-set=eucjpms 
+--default-collation=eucjpms_japanese_ci 
+[innodb eucjpms eucjpms_japanese_ci]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=eucjpms 
+--default-collation=eucjpms_japanese_ci 
+[falcon eucjpms eucjpms_japanese_ci]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=eucjpms 
+--default-collation=eucjpms_japanese_ci 
+[myisam eucjpms eucjpms_bin]
+--default-storage-engine=myisam
+--default-character-set=eucjpms 
+--default-collation=eucjpms_bin 
+[innodb eucjpms eucjpms_bin]
+--init-file=../../suite/backup/include/innodb.init
+--default-character-set=eucjpms 
+--default-collation=eucjpms_bin 
+[falcon eucjpms eucjpms_bin]
+--init-file=../../suite/backup/include/falcon.init
+--default-character-set=eucjpms 
+--default-collation=eucjpms_bin 

=== added directory 'mysql-test/suite/backup_charsets/include'
=== added file 'mysql-test/suite/backup_charsets/include/charset.inc'
--- a/mysql-test/suite/backup_charsets/include/charset.inc	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/backup_charsets/include/charset.inc	2008-07-07 22:22:55 +0000
@@ -0,0 +1,15 @@
+###############################################################################
+# Author: Hema
+# Date: 2008-04-01
+# Purpose:To define the charset and collate variable.
+###############################################################################
+
+
+--replace_column 2 #
+SHOW VARIABLES LIKE 'character_set_database';
+let $cset=query_get_value(SHOW VARIABLES LIKE 'character_set_database', Value,1);
+
+--replace_column 2 #
+SHOW VARIABLES LIKE 'collation_database';
+let $coll=query_get_value(SHOW VARIABLES LIKE 'collation_database', Value, 1);
+

=== added file 'mysql-test/suite/backup_charsets/include/not_have_falcon.inc'
--- a/mysql-test/suite/backup_charsets/include/not_have_falcon.inc	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/backup_charsets/include/not_have_falcon.inc	2008-07-07 22:22:55 +0000
@@ -0,0 +1,6 @@
+--replace_result $ENGINE ENGINE
+if(`SELECT '$ENGINE'='falcon'`)
+{
+ skip "This test does'nt support falcon engine BUG#33566" ;
+}
+

=== added directory 'mysql-test/suite/backup_charsets/r'
=== added file 'mysql-test/suite/backup_charsets/r/backup_datatypes.result'
--- a/mysql-test/suite/backup_charsets/r/backup_datatypes.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/backup_charsets/r/backup_datatypes.result	2008-07-07 22:22:55 +0000
@@ -0,0 +1,158 @@
+SHOW VARIABLES LIKE 'storage_engine';
+Variable_name	Value
+storage_engine	#
+SHOW VARIABLES LIKE 'character_set_database';
+Variable_name	Value
+character_set_database	#
+SHOW VARIABLES LIKE 'collation_database';
+Variable_name	Value
+collation_database	#
+
+starting the test for backup
+
+DROP DATABASE IF EXISTS bup_datatype;
+SET NAMES cset;
+CREATE DATABASE bup_datatype;
+USE bup_datatype;
+Creating table with all storage engines and csets/coll
+CREATE TABLE d1(
+rint INT, 
+tint TINYINT,
+sint SMALLINT,
+bint BIGINT,
+mint MEDIUMINT,
+name CHAR(100), 
+city  VARCHAR(100),
+fl FLOAT(7,4), 
+pers DECIMAL(8,2), 
+sal DOUBLE,
+colours SET('red','blue','yellow'), 
+continent ENUM('Asia', 'Europe','Africa','Antartica'),
+ts TIMESTAMP DEFAULT 0, 
+dob DATE,
+y YEAR
+);
+creating table with blob and text columns
+CREATE TABLE d2(
+region TEXT, 
+summary LONGTEXT, 
+data BLOB, 
+details MEDIUMBLOB,
+queries TINYTEXT, 
+query2 TINYBLOB, 
+extract LONGBLOB, 
+paras MEDIUMTEXT
+);
+INSERT INTO d1 VALUES
+(785,127,7288,278829899,3777,'testing1','sweden','678.299',200.23,829899.909,
+'red','Asia','2008-06-01 16:23:30','1984-09-08','1984');
+INSERT INTO d2 VALUES
+('xxxxxxxx','Testofonline backup','aaaaaaaaaa','bbbbbbbbbbb','hhhhhhhhhhh',
+'kkkkkkkkkkkkk','mmmmmmmmmmmm','onlinebackup1');
+UPDATE d2 SET extract=repeat('z',100);
+SELECT * FROM d1;;
+rint	785
+tint	127
+sint	7288
+bint	278829899
+mint	3777
+name	testing1
+city	sweden
+fl	678.2990
+pers	200.23
+sal	829899.909
+colours	red
+continent	Asia
+ts	2008-06-01 16:23:30
+dob	1984-09-08
+y	1984
+SELECT * FROM d2;
+region	summary	data	details	queries	query2	extract	paras
+xxxxxxxx	Testofonline backup	aaaaaaaaaa	bbbbbbbbbbb	hhhhhhhhhhh	kkkkkkkkkkkkk	zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz	onlinebackup1
+DESCRIBE d1;
+Field	Type	Null	Key	Default	Extra
+rint	int(11)	YES		NULL	
+tint	tinyint(4)	YES		NULL	
+sint	smallint(6)	YES		NULL	
+bint	bigint(20)	YES		NULL	
+mint	mediumint(9)	YES		NULL	
+name	char(100)	YES		NULL	
+city	varchar(100)	YES		NULL	
+fl	float(7,4)	YES		NULL	
+pers	decimal(8,2)	YES		NULL	
+sal	double	YES		NULL	
+colours	set('red','blue','yellow')	YES		NULL	
+continent	enum('Asia','Europe','Africa','Antartica')	YES		NULL	
+ts	timestamp	NO		0000-00-00 00:00:00	
+dob	date	YES		NULL	
+y	year(4)	YES		NULL	
+DESCRIBE d2;
+Field	Type	Null	Key	Default	Extra
+region	text	YES		NULL	
+summary	longtext	YES		NULL	
+data	blob	YES		NULL	
+details	mediumblob	YES		NULL	
+queries	tinytext	YES		NULL	
+query2	tinyblob	YES		NULL	
+extract	longblob	YES		NULL	
+paras	mediumtext	YES		NULL	
+**backup data**
+
+BACKUP DATABASE bup_datatype TO 'bup_datatype.bak';
+backup_id
+#
+DROP DATABASE bup_datatype;
+**Restore**
+RESTORE FROM 'bup_datatype.bak';
+backup_id
+#
+DESCRIBE d1;
+Field	Type	Null	Key	Default	Extra
+rint	int(11)	YES		NULL	
+tint	tinyint(4)	YES		NULL	
+sint	smallint(6)	YES		NULL	
+bint	bigint(20)	YES		NULL	
+mint	mediumint(9)	YES		NULL	
+name	char(100)	YES		NULL	
+city	varchar(100)	YES		NULL	
+fl	float(7,4)	YES		NULL	
+pers	decimal(8,2)	YES		NULL	
+sal	double	YES		NULL	
+colours	set('red','blue','yellow')	YES		NULL	
+continent	enum('Asia','Europe','Africa','Antartica')	YES		NULL	
+ts	timestamp	NO		0000-00-00 00:00:00	
+dob	date	YES		NULL	
+y	year(4)	YES		NULL	
+DESCRIBE d2;
+Field	Type	Null	Key	Default	Extra
+region	text	YES		NULL	
+summary	longtext	YES		NULL	
+data	blob	YES		NULL	
+details	mediumblob	YES		NULL	
+queries	tinytext	YES		NULL	
+query2	tinyblob	YES		NULL	
+extract	longblob	YES		NULL	
+paras	mediumtext	YES		NULL	
+SELECT * FROM d1;;
+rint	785
+tint	127
+sint	7288
+bint	278829899
+mint	3777
+name	testing1
+city	sweden
+fl	678.2990
+pers	200.23
+sal	829899.909
+colours	red
+continent	Asia
+ts	2008-06-01 16:23:30
+dob	1984-09-08
+y	1984
+SELECT * FROM d2;
+region	summary	data	details	queries	query2	extract	paras
+xxxxxxxx	Testofonline backup	aaaaaaaaaa	bbbbbbbbbbb	hhhhhhhhhhh	kkkkkkkkkkkkk	zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz	onlinebackup1
+
+***  DROP bup_datatype DATABASE ****
+
+DROP DATABASE bup_datatype;

=== added file 'mysql-test/suite/backup_charsets/r/backup_partitions.result'
--- a/mysql-test/suite/backup_charsets/r/backup_partitions.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/backup_charsets/r/backup_partitions.result	2008-07-07 22:22:55 +0000
@@ -0,0 +1,492 @@
+SHOW VARIABLES LIKE 'storage_engine';
+Variable_name	Value
+storage_engine	#
+SHOW VARIABLES LIKE 'character_set_database';
+Variable_name	Value
+character_set_database	#
+SHOW VARIABLES LIKE 'collation_database';
+Variable_name	Value
+collation_database	#
+
+starting the test for backup
+
+DROP DATABASE IF EXISTS partitions;
+Bug #34391 Character sets: crash if char(), utf32, innodb
+Bug #33566 Backup: crash with partitions and Falcon
+Bug #37551 Junk detected in data contents sometimes when utf8mb3
+character set is used.
+Bug #37554 Use of character set and collate as 'filename' shows 
+unusual behaviour.
+Bug #35499 View when created with swe7 character set fails.
+SET NAMES cset;
+CREATE DATABASE partitions;
+USE partitions;
+*****Creating table with range partition*********
+CREATE TABLE `range`(
+ID INT NOT NULL,
+NAME CHAR(20),
+AGE TINYINT,
+DOB DATE,
+SAL FLOAT,
+PRIMARY KEY(DOB)) PARTITION BY RANGE(Year(DOB))(
+PARTITION P0 values less than (1970),
+PARTITION P1 values less than (1980),
+PARTITION P2 values less than (1990),
+PARTITION P3 values less than (2000),
+PARTITION P4 values less than maxvalue);
+loading data
+INSERT INTO `range`VALUES
+(10,'aa','20','1988-12-19',2345.89),(11,'bb',31,'1977-10-19',6009.89),
+(12,'cc',78,'1945-09-12',3897),(13,'dd',12,'1994-09-18',7892.78),
+(14,'ee',45,'1960-12-23',7845.90),(15,'ff',25,'1984-02-07',3500.89);
+select data
+SELECT * FROM `range` ORDER BY DOB;
+ID	NAME	AGE	DOB	SAL
+12	cc	78	1945-09-12	3897
+14	ee	45	1960-12-23	7845.9
+11	bb	31	1977-10-19	6009.89
+15	ff	25	1984-02-07	3500.89
+10	aa	20	1988-12-19	2345.89
+13	dd	12	1994-09-18	7892.78
+SELECT COUNT(*) FROM `range`;
+COUNT(*)
+6
+
+******Creating table partition with List**************
+CREATE TABLE `left`(`numeric` INT, `char` CHAR(20))  
+PARTITION BY LIST (`numeric`)
+(
+PARTITION p0 VALUES IN (1,3,5),
+PARTITION p1 VALUES IN (2,4,6)
+);
+insert data
+INSERT INTO `left` VALUES(1,'a'),(6,'c'),(5,'j'),(2,'l');
+selecting data
+SELECT * FROM `left` ORDER BY `numeric`;
+numeric	char
+1	a
+2	l
+5	j
+6	c
+SELECT COUNT(*) FROM `left`;
+COUNT(*)
+4
+
+*******Creating table partition with Hash***********
+CREATE TABLE `modifies`(
+col1 INT,
+col2 CHAR(20),
+col3 DATE)
+PARTITION BY HASH (YEAR(col3))
+PARTITIONS 4;
+Insert data
+INSERT INTO `modifies` VALUES
+(1,'a','1942-10-09'),(2,'b','1950-08-07'),
+(3,'c','1952-10-10'),(4,'d','1954-10-04');
+selecting data
+SELECT * FROM `modifies` ORDER BY col3;
+col1	col2	col3
+1	a	1942-10-09
+2	b	1950-08-07
+3	c	1952-10-10
+4	d	1954-10-04
+SELECT COUNT(*) FROM `modifies`;
+COUNT(*)
+4
+********Creating table partition with keys*******
+CREATE TABLE `key`(id INT) 
+PARTITION BY KEY(id)
+PARTITIONS 2;
+insert data
+INSERT INTO `key` VALUES(1),(2),(3),(4);
+selecting the data
+SELECT * FROM `key`;
+id
+1
+3
+2
+4
+SELECT COUNT(*) FROM `key`;
+COUNT(*)
+4
+***Creating views from partitoned Tables****
+CREATE VIEW `values` AS SELECT * FROM `range`;
+Obtaining information about Partitions
+SHOW FULL TABLES;
+Tables_in_partitions	Table_type
+key	BASE TABLE
+left	BASE TABLE
+modifies	BASE TABLE
+range	BASE TABLE
+values	VIEW
+EXPLAIN PARTITIONS SELECT * FROM `key`;;
+id	#
+select_type	SIMPLE
+table	key
+partitions	p0,p1
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+EXPLAIN PARTITIONS SELECT * FROM `modifies`;;
+id	#
+select_type	SIMPLE
+table	modifies
+partitions	p0,p1,p2,p3
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+EXPLAIN PARTITIONS SELECT * FROM `left`;;
+id	#
+select_type	SIMPLE
+table	left
+partitions	p0,p1
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+EXPLAIN PARTITIONS SELECT * FROM `range`;;
+id	#
+select_type	SIMPLE
+table	range
+partitions	P0,P1,P2,P3,P4
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+backup data
+BACKUP DATABASE partitions TO 'partitions.bak';
+backup_id
+#
+dropping  database.
+DROP DATABASE partitions;
+Restore
+RESTORE FROM 'partitions.bak';
+backup_id
+#
+
+** RESULTS AFTER RESTORE **
+
+Obtaining Information about Partitions
+SHOW FULL TABLES;;
+Tables_in_partitions	key
+Table_type	BASE TABLE
+Tables_in_partitions	left
+Table_type	BASE TABLE
+Tables_in_partitions	modifies
+Table_type	BASE TABLE
+Tables_in_partitions	range
+Table_type	BASE TABLE
+Tables_in_partitions	values
+Table_type	VIEW
+EXPLAIN PARTITIONS SELECT * FROM `key`;;
+id	#
+select_type	SIMPLE
+table	key
+partitions	p0,p1
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+EXPLAIN PARTITIONS SELECT * FROM `modifies`;;
+id	#
+select_type	SIMPLE
+table	modifies
+partitions	p0,p1,p2,p3
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+EXPLAIN PARTITIONS SELECT * FROM `left`;;
+id	#
+select_type	SIMPLE
+table	left
+partitions	p0,p1
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+EXPLAIN PARTITIONS SELECT * FROM `range`;;
+id	#
+select_type	SIMPLE
+table	range
+partitions	P0,P1,P2,P3,P4
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
+ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));
+INSERT INTO `left` VALUES(10,'h'),(3,'b'),(10,'s'),(5,'l');
+SELECT * FROM `left`;
+numeric	char
+1	a
+5	j
+3	b
+5	l
+6	c
+2	l
+10	h
+10	s
+SELECT COUNT(*) FROM `left`;
+COUNT(*)
+8
+INSERT INTO `values` VALUES(17,'kk','90','2020-12-19',2000);
+SELECT COUNT(*) FROM `values`;
+COUNT(*)
+7
+SELECT COUNT(*) FROM  `range`;
+COUNT(*)
+7
+
+**Creating table with subpartitions**
+CREATE TABLE `change` (`int` INT)
+PARTITION BY range (`int`)
+SUBPARTITION BY key (`int`)
+(PARTITION p0 VALUES LESS THAN (2));
+INSERT INTO `change` VALUES(0),(1);
+SHOW FULL TABLES;
+Tables_in_partitions	Table_type
+change	BASE TABLE
+key	BASE TABLE
+left	BASE TABLE
+modifies	BASE TABLE
+range	BASE TABLE
+values	VIEW
+EXPLAIN PARTITIONS SELECT * FROM `left`;;
+id	#
+select_type	SIMPLE
+table	left
+partitions	p0,p1,p2
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+EXPLAIN PARTITIONS SELECT * FROM `range`;;
+id	#
+select_type	SIMPLE
+table	range
+partitions	p0,p1
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+EXPLAIN PARTITIONS SELECT * FROM `change`;;
+id	#
+select_type	SIMPLE
+table	change
+partitions	p0_p0sp0
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+BACKUP DATABASE partitions TO 'partitions.bak';
+backup_id
+#
+DROP DATABASE partitions;
+RESTORE FROM 'partitions.bak';
+backup_id
+#
+showing objects and create statements
+EXPLAIN PARTITIONS SELECT * FROM `key`;;
+id	#
+select_type	SIMPLE
+table	key
+partitions	p0,p1
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+EXPLAIN PARTITIONS SELECT * FROM `modifies`;;
+id	#
+select_type	SIMPLE
+table	modifies
+partitions	p0,p1,p2,p3
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+EXPLAIN PARTITIONS SELECT * FROM `left`;;
+id	#
+select_type	SIMPLE
+table	left
+partitions	p0,p1,p2
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+EXPLAIN PARTITIONS SELECT * FROM `range`;;
+id	#
+select_type	SIMPLE
+table	range
+partitions	p0,p1
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+SELECT * FROM `left` ORDER BY `numeric`;
+numeric	char
+1	a
+2	l
+3	b
+5	j
+5	l
+6	c
+10	h
+10	s
+SELECT * FROM `key`;
+id
+1
+3
+2
+4
+SELECT * FROM `modifies` ORDER BY col3;
+col1	col2	col3
+1	a	1942-10-09
+2	b	1950-08-07
+3	c	1952-10-10
+4	d	1954-10-04
+SELECT * FROM `range`  ORDER BY DOB;
+ID	NAME	AGE	DOB	SAL
+12	cc	78	1945-09-12	3897
+14	ee	45	1960-12-23	7845.9
+11	bb	31	1977-10-19	6009.89
+15	ff	25	1984-02-07	3500.89
+10	aa	20	1988-12-19	2345.89
+13	dd	12	1994-09-18	7892.78
+17	kk	90	2020-12-19	2000
+SELECT * FROM `change`;
+int
+0
+1
+**creating view from view***
+CREATE VIEW v2 AS SELECT * FROM `values`;
+INSERT INTO v2 VALUES(18,'pp',51,'1990-10-19',6009.89);
+SELECT COUNT(*) FROM `values`;
+COUNT(*)
+8
+SELECT COUNT(*) FROM  `range`;
+COUNT(*)
+8
+Make some changes and then perform Restore.
+ALTER TABLE `change` ADD PARTITION (PARTITION p1 VALUES LESS THAN (4));
+INSERT INTO `change` VALUES(2),(3),(1);
+EXPLAIN PARTITIONS SELECT * FROM `change`;;
+id	#
+select_type	SIMPLE
+table	change
+partitions	p0_p0sp0,p1_p1sp0
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+SHOW FULL TABLES;
+Tables_in_partitions	Table_type
+change	BASE TABLE
+key	BASE TABLE
+left	BASE TABLE
+modifies	BASE TABLE
+range	BASE TABLE
+v2	VIEW
+values	VIEW
+BACKUP DATABASE partitions to 'partitions.bak';
+backup_id
+#
+DROP DATABASE partitions;
+RESTORE FROM 'partitions.bak';
+backup_id
+#
+SHOW FULL TABLES;
+Tables_in_partitions	Table_type
+change	BASE TABLE
+key	BASE TABLE
+left	BASE TABLE
+modifies	BASE TABLE
+range	BASE TABLE
+v2	VIEW
+values	VIEW
+SELECT * FROM `change`;
+int
+0
+1
+1
+2
+3
+EXPLAIN PARTITIONS SELECT * FROM `change`;;
+id	#
+select_type	SIMPLE
+table	change
+partitions	p0_p0sp0,p1_p1sp0
+type	ALL
+possible_keys	NULL
+key	NULL
+key_len	NULL
+ref	NULL
+rows	#
+Extra	
+SELECT * FROM `values` ORDER BY DOB;
+ID	NAME	AGE	DOB	SAL
+12	cc	78	1945-09-12	3897
+14	ee	45	1960-12-23	7845.9
+11	bb	31	1977-10-19	6009.89
+15	ff	25	1984-02-07	3500.89
+10	aa	20	1988-12-19	2345.89
+18	pp	51	1990-10-19	6009.89
+13	dd	12	1994-09-18	7892.78
+17	kk	90	2020-12-19	2000
+SELECT COUNT(*) FROM  `range`;
+COUNT(*)
+8
+
+***  DROP partitions DATABASE ****
+
+DROP DATABASE partitions;

=== added directory 'mysql-test/suite/backup_charsets/t'
=== added file 'mysql-test/suite/backup_charsets/t/backup_datatypes.test'
--- a/mysql-test/suite/backup_charsets/t/backup_datatypes.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/backup_charsets/t/backup_datatypes.test	2008-07-07 22:22:55 +0000
@@ -0,0 +1,122 @@
+########################################################################
+# Author: Hema
+# Date: 2008-03-11
+# Purpose: To test the backup/restore of all datatypes for different storage    
+# engines.
+#########################################################################
+--source include/not_embedded.inc
+--source include/have_debug.inc
+--source suite/backup/include/backup_engine.inc
+--source suite/backup_charsets/include/charset.inc
+
+connect (backup,localhost,root,,);
+connect (breakpoints,localhost,root,,);
+
+##############################################################
+--echo
+--echo starting the test for backup
+--echo
+##############################################################
+
+--error 0,1
+--remove_file $MYSQLTEST_VARDIR/master-data/bup_datatype.bak
+
+
+#Create Database and tables with different datatypes for this test.
+
+--disable_warnings
+DROP DATABASE IF EXISTS bup_datatype;
+--enable_warnings
+
+--replace_result $cset cset
+eval SET NAMES $cset;
+CREATE DATABASE bup_datatype;
+USE bup_datatype;
+
+#Bug#37854 Test fails/aborts for collate latin2_czech_cs used with SET 
+#and ENUM datatypes
+--replace_result $coll coll
+if(`SELECT '$coll'='latin2_czech_cs'`)
+{
+ skip "This test does'nt support latin2_czech_cs collation BUG#37854" ;
+}
+
+#Create table and load with data.
+
+--echo Creating table with all storage engines and csets/coll
+
+CREATE TABLE d1(
+rint INT, 
+tint TINYINT,
+sint SMALLINT,
+bint BIGINT,
+mint MEDIUMINT,
+name CHAR(100), 
+city  VARCHAR(100),
+fl FLOAT(7,4), 
+pers DECIMAL(8,2), 
+sal DOUBLE,
+colours SET('red','blue','yellow'), 
+continent ENUM('Asia', 'Europe','Africa','Antartica'),
+ts TIMESTAMP DEFAULT 0, 
+dob DATE,
+y YEAR
+);
+
+--echo creating table with blob and text columns
+CREATE TABLE d2(
+region TEXT, 
+summary LONGTEXT, 
+data BLOB, 
+details MEDIUMBLOB,
+queries TINYTEXT, 
+query2 TINYBLOB, 
+extract LONGBLOB, 
+paras MEDIUMTEXT
+);
+
+INSERT INTO d1 VALUES
+(785,127,7288,278829899,3777,'testing1','sweden','678.299',200.23,829899.909,
+'red','Asia','2008-06-01 16:23:30','1984-09-08','1984');
+
+INSERT INTO d2 VALUES
+('xxxxxxxx','Testofonline backup','aaaaaaaaaa','bbbbbbbbbbb','hhhhhhhhhhh',
+'kkkkkkkkkkkkk','mmmmmmmmmmmm','onlinebackup1');
+
+# Bug #37212  Restore crashes if table has longblob of size 1MB
+UPDATE d2 SET extract=repeat('z',100);
+--query_vertical SELECT * FROM d1;
+SELECT * FROM d2;
+
+DESCRIBE d1;
+DESCRIBE d2;
+
+--echo **backup data**
+--echo
+--replace_column 1 #
+BACKUP DATABASE bup_datatype TO 'bup_datatype.bak';
+
+--echo** dropping  database**
+DROP DATABASE bup_datatype;
+
+--echo **Restore**
+--replace_column 1 #
+RESTORE FROM 'bup_datatype.bak';
+
+#show data table columns
+DESCRIBE d1;
+DESCRIBE d2;
+
+--query_vertical SELECT * FROM d1;
+SELECT * FROM d2;
+
+# Test cleanup section
+
+--echo
+--echo ***  DROP bup_datatype DATABASE ****
+--echo
+
+DROP DATABASE bup_datatype;
+--remove_file $MYSQLTEST_VARDIR/master-data/bup_datatype.bak
+
+

=== added file 'mysql-test/suite/backup_charsets/t/backup_partitions.test'
--- a/mysql-test/suite/backup_charsets/t/backup_partitions.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/suite/backup_charsets/t/backup_partitions.test	2008-07-07 22:22:55 +0000
@@ -0,0 +1,269 @@
+###########################################################################
+# Author: Hema
+# Date: 2008-03-11
+# Purpose: To test the backup and Restore of different partitions using
+# Reserved words as  identifiers for all Character sets
+###############################################################################
+--source include/not_embedded.inc
+--source include/have_debug.inc
+--source suite/backup/include/backup_engine.inc
+--source suite/backup_charsets/include/not_have_falcon.inc
+--source suite/backup_charsets/include/charset.inc
+
+connect (backup,localhost,root,,);
+connect (breakpoints,localhost,root,,);
+
+##############################################################
+--echo
+--echo starting the test for backup
+--echo
+##############################################################
+
+--error 0,1
+--remove_file $MYSQLTEST_VARDIR/master-data/partitions.bak
+
+#Create Database and and tables with different types of partitions.
+
+--disable_warnings
+DROP DATABASE IF EXISTS partitions;
+--enable_warnings
+
+--echo Bug #34391 Character sets: crash if char(), utf32, innodb
+--echo Bug #33566 Backup: crash with partitions and Falcon
+--echo Bug #37551 Junk detected in data contents sometimes when utf8mb3
+--echo character set is used.
+--echo Bug #37554 Use of character set and collate as 'filename' shows 
+--echo unusual behaviour.
+--echo Bug #35499 View when created with swe7 character set fails.
+
+--replace_result $cset cset
+eval SET NAMES $cset;
+
+CREATE DATABASE partitions;
+USE partitions;
+
+#Create table and load with data.
+
+--echo *****Creating table with range partition*********
+
+CREATE TABLE `range`(
+ ID INT NOT NULL,
+NAME CHAR(20),
+AGE TINYINT,
+DOB DATE,
+SAL FLOAT,
+PRIMARY KEY(DOB)) PARTITION BY RANGE(Year(DOB))(
+        PARTITION P0 values less than (1970),
+        PARTITION P1 values less than (1980),
+        PARTITION P2 values less than (1990),
+        PARTITION P3 values less than (2000),
+        PARTITION P4 values less than maxvalue);
+
+--echo loading data
+
+INSERT INTO `range`VALUES
+(10,'aa','20','1988-12-19',2345.89),(11,'bb',31,'1977-10-19',6009.89),
+(12,'cc',78,'1945-09-12',3897),(13,'dd',12,'1994-09-18',7892.78),
+(14,'ee',45,'1960-12-23',7845.90),(15,'ff',25,'1984-02-07',3500.89);
+
+--echo select data
+
+SELECT * FROM `range` ORDER BY DOB;
+SELECT COUNT(*) FROM `range`;
+
+--echo
+--echo ******Creating table partition with List**************
+
+CREATE TABLE `left`(`numeric` INT, `char` CHAR(20))  
+PARTITION BY LIST (`numeric`)
+(
+   PARTITION p0 VALUES IN (1,3,5),
+   PARTITION p1 VALUES IN (2,4,6)
+);
+--echo insert data
+
+INSERT INTO `left` VALUES(1,'a'),(6,'c'),(5,'j'),(2,'l');
+
+--echo selecting data
+
+SELECT * FROM `left` ORDER BY `numeric`;
+SELECT COUNT(*) FROM `left`;
+
+--echo
+--echo *******Creating table partition with Hash***********
+
+CREATE TABLE `modifies`(
+col1 INT,
+col2 CHAR(20),
+col3 DATE)
+PARTITION BY HASH (YEAR(col3))
+PARTITIONS 4;
+
+--echo Insert data
+
+INSERT INTO `modifies` VALUES
+(1,'a','1942-10-09'),(2,'b','1950-08-07'),
+(3,'c','1952-10-10'),(4,'d','1954-10-04');
+
+--echo selecting data
+
+SELECT * FROM `modifies` ORDER BY col3;
+SELECT COUNT(*) FROM `modifies`;
+--echo ********Creating table partition with keys*******
+
+CREATE TABLE `key`(id INT) 
+PARTITION BY KEY(id)
+PARTITIONS 2;
+
+--echo insert data
+
+INSERT INTO `key` VALUES(1),(2),(3),(4);
+
+--echo selecting the data
+
+SELECT * FROM `key`;
+SELECT COUNT(*) FROM `key`;
+
+--echo ***Creating views from partitoned Tables****
+
+CREATE VIEW `values` AS SELECT * FROM `range`;
+
+# We mask some of the columns in Explain Partitions command because of 
+# Bug #37532 Explain command shows incorrect rows, 
+# when table is partitioned and innodb.
+
+--echo Obtaining information about Partitions
+SHOW FULL TABLES;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `key`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `modifies`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `left`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `range`;
+
+--echo backup data
+--replace_column 1 #
+BACKUP DATABASE partitions TO 'partitions.bak';
+
+--echo dropping  database.
+
+DROP DATABASE partitions;
+
+--echo Restore
+--replace_column 1 #
+RESTORE FROM 'partitions.bak';
+--remove_file $MYSQLTEST_VARDIR/master-data/partitions.bak
+
+--echo
+--echo ** RESULTS AFTER RESTORE **
+--echo
+
+#show data and create statements
+--echo Obtaining Information about Partitions
+--query_vertical SHOW FULL TABLES;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `key`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `modifies`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `left`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `range`;
+
+# Make some changes to existing partitions, take backup and then perform
+# Restore
+
+ALTER TABLE `range` PARTITION BY KEY(DOB) PARTITIONS 2;
+ALTER TABLE `left` ADD PARTITION (PARTITION p2 VALUES IN (10,20,30));
+INSERT INTO `left` VALUES(10,'h'),(3,'b'),(10,'s'),(5,'l');
+SELECT * FROM `left`;
+SELECT COUNT(*) FROM `left`;
+
+INSERT INTO `values` VALUES(17,'kk','90','2020-12-19',2000);
+SELECT COUNT(*) FROM `values`;
+SELECT COUNT(*) FROM  `range`;
+
+--echo 
+--echo **Creating table with subpartitions**
+
+CREATE TABLE `change` (`int` INT)
+PARTITION BY range (`int`)
+SUBPARTITION BY key (`int`)
+(PARTITION p0 VALUES LESS THAN (2));
+
+INSERT INTO `change` VALUES(0),(1);
+
+#show data and create statements
+SHOW FULL TABLES;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `left`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `range`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `change`;
+
+--replace_column 1 #
+BACKUP DATABASE partitions TO 'partitions.bak';
+DROP DATABASE partitions;
+--replace_column 1 #
+RESTORE FROM 'partitions.bak';
+--remove_file $MYSQLTEST_VARDIR/master-data/partitions.bak
+
+#show data and create statements
+--echo showing objects and create statements
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `key`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `modifies`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `left`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `range`;
+
+SELECT * FROM `left` ORDER BY `numeric`;
+SELECT * FROM `key`;
+SELECT * FROM `modifies` ORDER BY col3;
+SELECT * FROM `range`  ORDER BY DOB;
+SELECT * FROM `change`;
+
+--echo **creating view from view***
+CREATE VIEW v2 AS SELECT * FROM `values`;
+INSERT INTO v2 VALUES(18,'pp',51,'1990-10-19',6009.89);
+
+
+SELECT COUNT(*) FROM `values`;
+SELECT COUNT(*) FROM  `range`;
+
+--echo Make some changes and then perform Restore.
+
+ALTER TABLE `change` ADD PARTITION (PARTITION p1 VALUES LESS THAN (4));
+INSERT INTO `change` VALUES(2),(3),(1);
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `change`;
+SHOW FULL TABLES;
+
+--replace_column 1 #
+BACKUP DATABASE partitions to 'partitions.bak';
+
+DROP DATABASE partitions;
+--replace_column 1 #
+RESTORE FROM 'partitions.bak';
+
+SHOW FULL TABLES;
+SELECT * FROM `change`;
+--replace_column 1 # 10 #
+--query_vertical EXPLAIN PARTITIONS SELECT * FROM `change`;
+SELECT * FROM `values` ORDER BY DOB;
+SELECT COUNT(*) FROM  `range`;
+
+# Test cleanup section
+
+--echo
+--echo ***  DROP partitions DATABASE ****
+--echo
+DROP DATABASE partitions;
+
+--remove_file $MYSQLTEST_VARDIR/master-data/partitions.bak
+

Thread
bzr commit into mysql-6.0-backup branch (hema:2650) WL#4227Hema Sridharan8 Jul
  • Re: bzr commit into mysql-6.0-backup branch (hema:2650) WL#4227Rafal Somla17 Jul
    • RE: bzr commit into mysql-6.0-backup branch (hema:2650) WL#4227Hema Sridharan17 Jul
      • Re: bzr commit into mysql-6.0-backup branch (hema:2650) WL#4227Rafal Somla21 Jul
        • RE: bzr commit into mysql-6.0-backup branch (hema:2650) WL#4227Hema Sridharan26 Jul
  • RE: bzr commit into mysql-6.0-backup branch (hema:2650) WL#4227Chuck Bell21 Jul