1) Identify the right package for your operating system & download. I have choose "MySQL Enterprise Backup 4.0.3 RPM for Oracle Linux / RHEL 7 x86 (64bit)" based on my operating system.
2) Execute the following command to install,
$yum install meb-4.0.3-el7.x86_64.rpm
3) If you type the command 'mysqlbackup' now you will get command not found error this is expected because the system doesn't know where the executable is located. By default the executable's are installed at location "/opt/mysql/meb-4.0"
$cd /opt/mysql/meb-4.0
4) We have to execute following command to add the path to environment variable where the system looks for all executable's when you try to execute a command. (note this is valid until your session is live, to make it permanent you have to add this to user's .bash_profile file)
$PATH=$PATH:/opt/mysql/meb-4.0/bin
5) Now execute following command to run the backup of mysql server, (I have included complete shell output)
$mysqlbackup --user=root --password --port=3306 --socket=/var/lib/mysql/mysql.sock --backup-dir=/usr/siva/mysql_backup_new/ backup-and-appl MySQL Enterprise Backup version 4.0.3 Linux-3.8.13-118.4.2.el7uek.x86_64-x86_64 [2016/08/04] Copyright (c) 2003, 2016, Oracle and/or its affiliates. All Rights Reserved. mysqlbackup: INFO: Starting with following command line ... mysqlbackup --user=root --password --port=3306 --socket=/var/lib/mysql/mysql.sock --backup-dir=/usr/siva/mysql_backup_new/ backup-and-apply-log mysqlbackup: INFO: Enter password: mysqlbackup: INFO: MySQL server version is '5.7.14-log' mysqlbackup: INFO: MySQL server compile os version is 'Linux' mysqlbackup: INFO: Got some server configuration information from running server. IMPORTANT: Please check that mysqlbackup run completes successfully. At the end of a successful 'backup-and-apply-log' run mysqlbackup prints "mysqlbackup completed OK!". 160831 19:56:33 mysqlbackup: INFO: MEB logfile created at /usr/siva/mysql_backup_new/meta/MEB_2016-08-31.19-56-33_backup_apply_log.log -------------------------------------------------------------------- Server Repository Options: -------------------------------------------------------------------- datadir = /var/lib/mysql/ innodb_data_home_dir = innodb_data_file_path = ibdata1:12M:autoextend innodb_log_group_home_dir = /var/lib/mysql/ innodb_log_files_in_group = 2 innodb_log_file_size = 50331648 innodb_page_size = 16384 innodb_checksum_algorithm = crc32 innodb_buffer_pool_filename = ib_buffer_pool innodb_undo_directory = /var/lib/mysql/ innodb_undo_tablespaces = 0 innodb_undo_logs = 128 -------------------------------------------------------------------- Backup Config Options: -------------------------------------------------------------------- datadir = /usr/siva/mysql_backup_new/datadir innodb_data_home_dir = /usr/siva/mysql_backup_new/datadir innodb_data_file_path = ibdata1:12M:autoextend innodb_log_group_home_dir = /usr/siva/mysql_backup_new/datadir innodb_log_files_in_group = 2 innodb_log_file_size = 50331648 innodb_page_size = 16384 innodb_checksum_algorithm = crc32 innodb_buffer_pool_filename = ib_buffer_pool innodb_undo_directory = /usr/siva/mysql_backup_new/datadir innodb_undo_tablespaces = 0 innodb_undo_logs = 128 mysqlbackup: INFO: Unique generated backup id for this is 14726985936584861 mysqlbackup: INFO: Creating 14 buffers each of size 16777216. 160831 19:56:33 mysqlbackup: INFO: Full Backup operation starts with following threads 1 read-threads 6 process-threads 1 write-threads 160831 19:56:33 mysqlbackup: INFO: System tablespace file format is Barracuda. 160831 19:56:33 mysqlbackup: INFO: Starting to copy all innodb files... 160831 19:56:33 mysqlbackup: INFO: Found checkpoint at lsn 2530912. 160831 19:56:33 mysqlbackup: INFO: Starting log scan from lsn 2530816. 160831 19:56:33 mysqlbackup: INFO: Copying log... 160831 19:56:33 mysqlbackup: INFO: Log copied, lsn 2530921. 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/ibdata1 (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/engine_cost.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/gtid_executed.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/help_category.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/help_keyword.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/help_relation.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/help_topic.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/innodb_index_stats.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/innodb_table_stats.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/plugin.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/server_cost.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/servers.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/slave_master_info.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/slave_relay_log_info.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/slave_worker_info.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/time_zone.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/time_zone_leap_second.ibd (Barracuda file format). 160831 19:56:33 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/time_zone_name.ibd (Barracuda file format). 160831 19:56:34 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/time_zone_transition.ibd (Barracuda file format). 160831 19:56:34 mysqlbackup: INFO: Copying /var/lib/mysql/mysql/time_zone_transition_type.ibd (Barracuda file format). 160831 19:56:34 mysqlbackup: INFO: Copying /var/lib/mysql/repl01/first.ibd (Barracuda file format). 160831 19:56:34 mysqlbackup: INFO: Copying /var/lib/mysql/sys/sys_config.ibd (Barracuda file format). 160831 19:56:34 mysqlbackup: INFO: Completing the copy of innodb files. 160831 19:56:34 mysqlbackup: INFO: Starting to copy Binlog files... 160831 19:56:34 mysqlbackup: INFO: Copying /var/lib/mysql/mysql-bin.000001. 160831 19:56:34 mysqlbackup: INFO: Copying /var/lib/mysql/mysql-bin.000002. 160831 19:56:34 mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server. 160831 19:56:34 mysqlbackup: INFO: Starting to lock all the tables... 160831 19:56:34 mysqlbackup: INFO: All tables are locked and flushed to disk 160831 19:56:34 mysqlbackup: INFO: Copying /var/lib/mysql/mysql-bin.000003. 160831 19:56:34 mysqlbackup: INFO: Completed the copy of binlog files... 160831 19:56:34 mysqlbackup: INFO: Opening backup source directory '/var/lib/mysql' 160831 19:56:34 mysqlbackup: INFO: Starting to backup all non-innodb files in subdirectories of '/var/lib/mysql' 160831 19:56:34 mysqlbackup: INFO: Copying the database directory 'mysql' 160831 19:56:34 mysqlbackup: INFO: Copying the database directory 'performance_schema' 160831 19:56:34 mysqlbackup: INFO: Copying the database directory 'repl01' 160831 19:56:34 mysqlbackup: INFO: Copying the database directory 'sys' 160831 19:56:34 mysqlbackup: INFO: Completing the copy of all non-innodb files. 160831 19:56:34 mysqlbackup: INFO: A copied database page was modified at 2530912. (This is the highest lsn found on page) Scanned log up to lsn 2530921. Was able to parse the log up to lsn 2530921. 160831 19:56:34 mysqlbackup: INFO: All tables unlocked 160831 19:56:34 mysqlbackup: INFO: All MySQL tables were locked for 0.642 seconds. 160831 19:56:34 mysqlbackup: INFO: Reading all global variables from the server. 160831 19:56:34 mysqlbackup: INFO: Completed reading of all global variables from the server. mysqlbackup: INFO: Writing config file for server '5.7.14-log'. 160831 19:56:34 mysqlbackup: INFO: Creating server config files server-my.cnf and server-all.cnf in /usr/siva/mysql_backup_new/ 160831 19:56:34 mysqlbackup: INFO: Full Backup operation completed successfully. 160831 19:56:34 mysqlbackup: INFO: Backup created in directory '/usr/siva/mysql_backup_new/' 160831 19:56:34 mysqlbackup: INFO: MySQL binlog position: filename mysql-bin.000003, position 154 ------------------------------------------------------------- Parameters Summary ------------------------------------------------------------- Start LSN : 2530816 End LSN : 2530921 ------------------------------------------------------------- mysqlbackup: INFO: Creating 14 buffers each of size 65536. 160831 19:56:34 mysqlbackup: INFO: Apply-log operation starts with following threads 1 read-threads 1 process-threads mysqlbackup: INFO: Using up to 100 MB of memory. 160831 19:56:34 mysqlbackup: INFO: ibbackup_logfile's creation parameters: start lsn 2530816, end lsn 2530921, start checkpoint 2530912. mysqlbackup: INFO: InnoDB: Doing recovery: scanned up to log sequence number 2530921. mysqlbackup: INFO: InnoDB: Starting an apply batch of log records to the database... . InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 mysqlbackup: INFO: InnoDB: Setting log file size to 50331648. mysqlbackup: INFO: InnoDB: Setting log file size to 50331648. 160831 19:56:36 mysqlbackup: INFO: We were able to parse ibbackup_logfile up to lsn 2530921. mysqlbackup: INFO: Last MySQL binlog file position 0 154, file name mysql-bin.000003:154 160831 19:56:36 mysqlbackup: INFO: The first data file is '/usr/siva/mysql_backup_new/datadir/ibdata1' and the new created log files are at '/usr/siva/mysql_backup_new/datadir' 160831 19:56:36 mysqlbackup: INFO: Apply-log operation completed successfully. 160831 19:56:36 mysqlbackup: INFO: Full backup prepared for recovery successfully. mysqlbackup completed OK!
Where did you download the mysqbackup 4.0 rpm?
ReplyDelete