source include/have_log_bin.inc; let $MYSQLD_DATADIR= `select @@datadir`; # Create some data USE test; CREATE TABLE t1 (id INT PRIMARY KEY, f2 TEXT); INSERT INTO t1 VALUES (1, REPEAT("1234567890", 1024)); INSERT INTO t1 VALUES (2, REPEAT("2345678901", 1024)); INSERT INTO t1 VALUES (3, REPEAT("3456789012", 1024)); INSERT INTO t1 VALUES (4, REPEAT("4567890123", 1024)); --echo # Displaying the list of binlog files --list_files $MYSQLD_DATADIR mysql.* --echo # End list of binlog files # Only one binlog is created and it is not numbered # however, multiple entries are created in the binlog index file --file_exists $MYSQLD_DATADIR/mysql.file source include/show_binary_logs.inc; --echo # Dumping contents of binlog index file --cat_file $MYSQLD_DATADIR/mysql.index --echo # END of binlog index # Test cleanup DROP TABLE t1; --echo End of tests