The backup-my.cnf is not available since the backup file was not created, following are contents of /etc/my.cnf
[mysql]
# CLIENT # port = 3306 socket = /u01/mysql06/mysqllogs/mysql.sock
[client] port = 3306 socket = /u01/mysql06/mysqllogs/mysql.sock
[mysqld]
# GENERAL # server_id = 300640 character_set_server = utf8 user = mysql default-storage-engine = InnoDB socket = /u01/mysql06/mysqllogs/mysql.sock pid-file = /u01/mysql06/mysqllogs/mysql.pid port = 3306
# MyISAM # key-buffer-size = 32M myisam-recover-options = FORCE,BACKUP
# PASSWORD PLUGIN # #plugin-load-add = validate_password.so #validate-password = FORCE_PLUS_PERMANENT #validate_password_policy = STRONG
# SAFETY # max-allowed-packet = 52M max-connect-errors = 1000000 sql_mode = ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION skip-name-resolve sysdate-is-now = 1 default-time-zone = '+05:30' #innodb = FORCE innodb-strict-mode = 1 interactive_timeout = 180 wait_timeout = 180 skip-symbolic-links
# DATA STORAGE # datadir = /u01/mysql06/mysqldata
# BINARY LOGGING # binlog_format = ROW binlog_row_image = FULL log-bin = /u01/mysql06/mysqllogs/binlogs/mysql-bin expire-logs-days = 10 sync-binlog = 0 binlog_rows_query_log_events = OFF binlog_checksum = CRC32
# REPLICATION # read_only = 0 skip-slave-start = 1 relay-log = /u01/mysql06/mysqllogs/relaylogs/relay-bin slave-net-timeout = 60 master_info_repository = TABLE relay_log_info_repository = TABLE relay_log_recovery = ON master_verify_checksum = ON log_slave_updates = ON sync_master_info = 1000
# CACHES AND LIMITS # tmp-table-size = 32M max-heap-table-size = 32M query-cache-type = 0 query-cache-size = 0 max-connections = 500 thread-cache-size = 50 open-files-limit = 65535 table-definition-cache = 1024 table-open-cache = 500
# INNODB # innodb_io_capacity = 250 innodb-flush-method = O_DIRECT innodb_data_file_path = ibdata1:100M:autoextend innodb-log-files-in-group = 2 innodb-log-file-size = 56M innodb-flush-log-at-trx-commit = 0 innodb-file-per-table = 1 innodb-buffer-pool-size = 128M innodb_buffer_pool_instances = 12 innodb_thread_concurrency = 0 innodb_commit_concurrency = 0 innodb_online_alter_log_max_size = 5368709120 innodb_buffer_pool_dump_at_shutdown = ON innodb_buffer_pool_load_at_startup = ON innodb_monitor_enable = all innodb_adaptive_hash_index = OFF
# LOGGING # log-error = /u01/mysql06/mysqllogs/mysql-error.log long_query_time = 1 slow-query-log = 1 slow-query-log-file = /u01/mysql06/mysqllogs/mysql-slow.log
# TEMPORARY STORAGE # tmpdir = /u01/mysql06/mysqltmp
The backup-my.cnf is not available since the backup file was not created, following are contents of /etc/my.cnf
[mysql]
# CLIENT # mysqllogs/ mysql.sock
port = 3306
socket = /u01/mysql06/
[client] mysqllogs/ mysql.sock
port = 3306
socket = /u01/mysql06/
[mysqld]
# GENERAL # set_server = utf8 storage- engine = InnoDB mysqllogs/ mysql.sock mysqllogs/ mysql.pid
server_id = 300640
character_
user = mysql
default-
socket = /u01/mysql06/
pid-file = /u01/mysql06/
port = 3306
# MyISAM # recover- options = FORCE,BACKUP
key-buffer-size = 32M
myisam-
# PASSWORD PLUGIN # password. so PERMANENT password_ policy = STRONG
#plugin-load-add = validate_
#validate-password = FORCE_PLUS_
#validate_
# SAFETY # GROUP_BY, STRICT_ TRANS_TABLES, NO_ENGINE_ SUBSTITUTION
max-allowed-packet = 52M
max-connect-errors = 1000000
sql_mode = ONLY_FULL_
skip-name-resolve
sysdate-is-now = 1
default-time-zone = '+05:30'
#innodb = FORCE
innodb-strict-mode = 1
interactive_timeout = 180
wait_timeout = 180
skip-symbolic-links
# DATA STORAGE # mysqldata
datadir = /u01/mysql06/
# BINARY LOGGING # mysqllogs/ binlogs/ mysql-bin rows_query_ log_events = OFF
binlog_format = ROW
binlog_row_image = FULL
log-bin = /u01/mysql06/
expire-logs-days = 10
sync-binlog = 0
binlog_
binlog_checksum = CRC32
# REPLICATION # mysqllogs/ relaylogs/ relay-bin info_repository = TABLE info_repository = TABLE verify_ checksum = ON
read_only = 0
skip-slave-start = 1
relay-log = /u01/mysql06/
slave-net-timeout = 60
master_
relay_log_
relay_log_recovery = ON
master_
log_slave_updates = ON
sync_master_info = 1000
# CACHES AND LIMITS # n-cache = 1024
tmp-table-size = 32M
max-heap-table-size = 32M
query-cache-type = 0
query-cache-size = 0
max-connections = 500
thread-cache-size = 50
open-files-limit = 65535
table-definitio
table-open-cache = 500
# INNODB # data_file_ path = ibdata1: 100M:autoextend log-files- in-group = 2 log-file- size = 56M flush-log- at-trx- commit = 0 file-per- table = 1 buffer- pool-size = 128M buffer_ pool_instances = 12 thread_ concurrency = 0 commit_ concurrency = 0 online_ alter_log_ max_size = 5368709120 buffer_ pool_dump_ at_shutdown = ON buffer_ pool_load_ at_startup = ON monitor_ enable = all adaptive_ hash_index = OFF
innodb_io_capacity = 250
innodb-flush-method = O_DIRECT
innodb_
innodb-
innodb-
innodb-
innodb-
innodb-
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
innodb_
# LOGGING # mysqllogs/ mysql-error. log mysqllogs/ mysql-slow. log
log-error = /u01/mysql06/
long_query_time = 1
slow-query-log = 1
slow-query-log-file = /u01/mysql06/
# TEMPORARY STORAGE # mysqltmp
tmpdir = /u01/mysql06/