教你如何恢復使用MEB備份的MySQL數據庫
更新時間：2016年09月28日 08:53:40 作者：Linux公社
這篇文章主要介紹了教你如何恢復使用MEB備份的MySQL數據庫的具體方法,需要的朋友可以參考下
恢復使用MEB備份的MySQL數據庫，執(zhí)行一個普通備份
[root@test bin]# ./mysqlbackup --defaults-file=/service/mysql5.5/my.cnf --socket=/data/mysql5.5/mysql.sock --user=root --backup-dir=/backup/5.5/normal --password backup MySQL Enterprise Backup version 3.8.2 [2013/06/18] Copyright (c) 2003, 2012,Oracle and/or its affiliates. All Rights Reserved. mysqlbackup: INFO: Starting with following command line ... ./mysqlbackup --defaults-file=/service/mysql5.5/my.cnf --socket=/data/mysql5.5/mysql.sock --user=root --backup-dir=/backup/5.5/normal --password backup Enter password: mysqlbackup: INFO: MySQL server version is '5.5.25-log'. 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' run mysqlbackup prints "mysqlbackup completed OK!".
--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
datadir = /data/mysql5.5/ innodb_data_home_dir = innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /data/mysql5.5/ innodb_log_files_in_group = 3 innodb_log_file_size = 536870912 innodb_page_size = Null innodb_checksum_algorithm = innodb
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /backup/5.5/normal/datadir innodb_data_home_dir = /backup/5.5/normal/datadir innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /backup/5.5/normal/datadir innodb_log_files_in_group = 3 innodb_log_file_size = 536870912 innodb_page_size = 16384 innodb_checksum_algorithm = innodb mysqlbackup: INFO: Unique generated backup id for this is 13851351066141087 mysqlbackup: INFO: Uses posix_fadvise() for performance optimization. mysqlbackup: INFO: Creating 14 buffers each of size 16777216. 131122 23:45:08 mysqlbackup: INFO: Full Backup operation starts with following threads 1 read-threads 6 process-threads 1 write-threads 131122 23:45:08 mysqlbackup: INFO: System tablespace file format is Antelope. 131122 23:45:08 mysqlbackup: INFO: Starting to copy all innodb files... 131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/ibdata1 (Antelope file format). 131122 23:45:08 mysqlbackup: INFO: Found checkpoint at lsn 3406087628. 131122 23:45:08 mysqlbackup: INFO: Starting log scan from lsn 3406087168. 131122 23:45:08 mysqlbackup: INFO: Copying log... 131122 23:45:08 mysqlbackup: INFO: Log copied, lsn 3406087628. 131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_qs_variables.ibd (Antelope file format). 131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_script_report_data.ibd (Antelope file format). 131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_split_column_names_table.ibd (Antelope file format). 131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_sql_tokens.ibd (Antelope file format). 131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_known_thread_states.ibd (Antelope file format). 131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_named_scripts.ibd (Antelope file format). 131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_script_statements.ibd (Antelope file format). 131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_waits.ibd (Antelope file format). 131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/help_content.ibd (Antelope file format). 131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/metadata.ibd (Antelope file format). 131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/numbers.ibd (Antelope file format). 131122 23:45:08 mysqlbackup: INFO: Copying /data/mysql5.5/zwc/t2.ibd (Antelope file format). mysqlbackup: Progress in MB: 200 400 131122 23:45:20 mysqlbackup: INFO: Completing the copy of innodb files. 131122 23:45:21 mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server. 131122 23:45:21 mysqlbackup: INFO: Starting to lock all the tables... 131122 23:45:21 mysqlbackup: INFO: All tables are locked and flushed to disk 131122 23:45:21 mysqlbackup: INFO: Opening backup source directory '/data/mysql5.5/' 131122 23:45:21 mysqlbackup: INFO: Starting to backup all non-innodb files in subdirectories of '/data/mysql5.5/' 131122 23:45:21 mysqlbackup: INFO: Copying the database directory 'common_schema' 131122 23:45:21 mysqlbackup: INFO: Copying the database directory 'mysql' 131122 23:45:21 mysqlbackup: INFO: Copying the database directory 'performance_schema' 131122 23:45:21 mysqlbackup: INFO: Copying the database directory 'test' 131122 23:45:21 mysqlbackup: INFO: Copying the database directory 'zwc' mysqlbackup: Progress in MB: 600 800 131122 23:45:33 mysqlbackup: INFO: Completing the copy of all non-innodb files. 131122 23:45:35 mysqlbackup: INFO: A copied database page was modified at 3406087628. (This is the highest lsn found on page) Scanned log up to lsn 3406090810. Was able to parse the log up to lsn 3406090810. Maximum page number for a log record 315 131122 23:45:35 mysqlbackup: INFO: All tables unlocked 131122 23:45:35 mysqlbackup: INFO: All MySQL tables were locked for 13.758 seconds. 131122 23:45:35 mysqlbackup: INFO: Full Backup operation completed successfully. 131122 23:45:35 mysqlbackup: INFO: Backup created in directory '/backup/5.5/normal' 131122 23:45:35 mysqlbackup: INFO: MySQL binlog position: filename ZWC-TEST.000024, position 16178 ------------------------------------------------------------- Parameters Summary ------------------------------------------------------------- Start LSN : 3406087168 End LSN : 3406090810 ------------------------------------------------------------- mysqlbackup completed OK!
或者壓縮備份
[root@test bin]# ./mysqlbackup --defaults-file=/service/mysql5.5/my.cnf --socket=/data/mysql5.5/mysql.sock --user=root --backup-dir=/backup/5.5/compress --compress --password backup MySQL Enterprise Backup version 3.8.2 [2013/06/18] Copyright (c) 2003, 2012, Oracle and/or its affiliates. All Rights Reserved. mysqlbackup: INFO: Starting with following command line ... ./mysqlbackup --defaults-file=/service/mysql5.5/my.cnf --socket=/data/mysql5.5/mysql.sock --user=root --backup-dir=/backup/5.5/compress --compress --password backup Enter password: mysqlbackup: INFO: MySQL server version is '5.5.25-log'. 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' run mysqlbackup prints "mysqlbackup completed OK!".
--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
datadir = /data/mysql5.5/ innodb_data_home_dir = innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /data/mysql5.5/ innodb_log_files_in_group = 3 innodb_log_file_size = 536870912 innodb_page_size = Null innodb_checksum_algorithm = innodb
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /backup/5.5/compress/datadir innodb_data_home_dir = /backup/5.5/compress/datadir innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /backup/5.5/compress/datadir innodb_log_files_in_group = 3 innodb_log_file_size = 536870912 innodb_page_size = 16384 innodb_checksum_algorithm = innodb mysqlbackup: INFO: Unique generated backup id for this is 13851352214073555 mysqlbackup: INFO: Uses posix_fadvise() for performance optimization. mysqlbackup: INFO: Creating 18 buffers each of size 16794070. 131122 23:47:03 mysqlbackup: INFO: Compress Backup operation starts with following threads 1 read-threads 6 process-threads 1 write-threads 131122 23:47:03 mysqlbackup: INFO: System tablespace file format is Antelope. 131122 23:47:03 mysqlbackup: INFO: Starting to copy all innodb files... 131122 23:47:03 mysqlbackup: INFO: Copying /data/mysql5.5/ibdata1 (Antelope file format). 131122 23:47:03 mysqlbackup: INFO: Found checkpoint at lsn 3406092146. 131122 23:47:03 mysqlbackup: INFO: Starting log scan from lsn 3406091776. 131122 23:47:03 mysqlbackup: INFO: Copying log... 131122 23:47:03 mysqlbackup: INFO: Log copied, lsn 3406092146. 131122 23:47:03 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_qs_variables.ibd (Antelope file format). 131122 23:47:03 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_script_report_data.ibd (Antelope file format). 131122 23:47:03 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_split_column_names_table.ibd (Antelope file format). 131122 23:47:03 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_global_sql_tokens.ibd (Antelope file format). 131122 23:47:03 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_known_thread_states.ibd (Antelope file format). 131122 23:47:03 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_named_scripts.ibd (Antelope file format). 131122 23:47:03 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_script_statements.ibd (Antelope file format). 131122 23:47:03 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/_waits.ibd (Antelope file format). 131122 23:47:03 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/help_content.ibd (Antelope file format). 131122 23:47:03 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/metadata.ibd (Antelope file format). 131122 23:47:03 mysqlbackup: INFO: Copying /data/mysql5.5/common_schema/numbers.ibd (Antelope file format). 131122 23:47:03 mysqlbackup: INFO: Copying /data/mysql5.5/zwc/t2.ibd (Antelope file format). mysqlbackup: Progress in MB: 200 400 131122 23:47:11 mysqlbackup: INFO: Completing the copy of innodb files. 131122 23:47:14 mysqlbackup: INFO: Preparing to lock tables: Connected to mysqld server. 131122 23:47:14 mysqlbackup: INFO: Starting to lock all the tables... 131122 23:47:14 mysqlbackup: INFO: All tables are locked and flushed to disk 131122 23:47:14 mysqlbackup: INFO: Opening backup source directory '/data/mysql5.5/' 131122 23:47:14 mysqlbackup: INFO: Starting to backup all non-innodb files in subdirectories of '/data/mysql5.5/' 131122 23:47:14 mysqlbackup: INFO: Copying the database directory 'common_schema' 131122 23:47:14 mysqlbackup: INFO: Copying the database directory 'mysql' 131122 23:47:15 mysqlbackup: INFO: Copying the database directory 'performance_schema' 131122 23:47:15 mysqlbackup: INFO: Copying the database directory 'test' 131122 23:47:15 mysqlbackup: INFO: Copying the database directory 'zwc' mysqlbackup: Progress in MB: 600 800 131122 23:47:26 mysqlbackup: INFO: Completing the copy of all non-innodb files. 131122 23:47:28 mysqlbackup: INFO: A copied database page was modified at 3406092146. (This is the highest lsn found on page) Scanned log up to lsn 3406095314. Was able to parse the log up to lsn 3406095314. Maximum page number for a log record 319 131122 23:47:29 mysqlbackup: INFO: All tables unlocked 131122 23:47:29 mysqlbackup: INFO: All MySQL tables were locked for 14.330 seconds. 131122 23:47:29 mysqlbackup: INFO: Compressed 496 MB of data files to 200577 kbytes (compression 60.51%). 131122 23:47:29 mysqlbackup: INFO: Compress Backup operation completed successfully. 131122 23:47:29 mysqlbackup: INFO: Backup created in directory '/backup/5.5/compress' 131122 23:47:29 mysqlbackup: INFO: MySQL binlog position: filename ZWC-TEST.000024, position 24831 ------------------------------------------------------------- Parameters Summary ------------------------------------------------------------- Start LSN : 3406091776 End LSN : 3406095314 ------------------------------------------------------------- mysqlbackup completed OK!
停止MySQL服務
[root@test mysql5.5]# /service/mysql5.5/bin/mysqladmin shutdown -uroot -p
刪除數據目錄里的文件
[root@test mysql5.5]# rm -rf common_schema/ mysql/ performance_schema/ test/ zwc/
從備份中還原
[root@test bin]# ./mysqlbackup --defaults-file=/service/mysql5.5/my.cnf --backup-dir=/backup/5.5/normal apply-log MySQL Enterprise Backup version 3.8.2 [2013/06/18] Copyright (c) 2003, 2012, Oracle and/or its affiliates. All Rights Reserved. mysqlbackup: INFO: Starting with following command line ... ./mysqlbackup --defaults-file=/service/mysql5.5/my.cnf --backup-dir=/backup/5.5/normal apply-log IMPORTANT: Please check that mysqlbackup run completes successfully. At the end of a successful 'apply-log' run mysqlbackup prints "mysqlbackup completed OK!".
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /backup/5.5/normal/datadir innodb_data_home_dir = /backup/5.5/normal/datadir innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /backup/5.5/normal/datadir innodb_log_files_in_group = 3 innodb_log_file_size = 536870912 innodb_page_size = 16384 innodb_checksum_algorithm = innodb mysqlbackup: INFO: Uses posix_fadvise() for performance optimization. mysqlbackup: INFO: Creating 14 buffers each of size 65536. 131122 23:59:39 mysqlbackup: INFO: Apply-log operation starts with following threads 1 read-threads 1 process-threads 131122 23:59:39 mysqlbackup: INFO: ibbackup_logfile's creation parameters: start lsn 3406087168, end lsn 3406090810, start checkpoint 3406087628. InnoDB: Doing recovery: scanned up to log sequence number 3406090810 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 49 50 51 52 53 54 55 56 57 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 Setting log file size to 536870912 InnoDB: Progress in MB: 100 200 300 400 500 Setting log file size to 536870912 InnoDB: Progress in MB: 100 200 300 400 500 Setting log file size to 536870912 InnoDB: Progress in MB: 100 200 300 400 500 131123 00:00:01 mysqlbackup: INFO: We were able to parse ibbackup_logfile up to lsn 3406090810. mysqlbackup: INFO: Last MySQL binlog file position 0 16178, file name ./ZWC-TEST.000024 131123 00:00:01 mysqlbackup: INFO: The first data file is '/backup/5.5/normal/datadir/ibdata1' and the new created log files are at '/backup/5.5/normal/datadir' 131123 00:00:01 mysqlbackup: INFO: Apply-log operation completed successfully. 131123 00:00:01 mysqlbackup: INFO: Full backup prepared for recovery successfully. mysqlbackup completed OK![root@test bin]# ./mysqlbackup --defaults-file=/service/mysql5.5/my.cnf --backup-dir=/backup/5.5/normal copy-back MySQL Enterprise Backup version 3.8.2 [2013/06/18] Copyright (c) 2003, 2012, Oracle and/or its affiliates. All Rights Reserved. mysqlbackup: INFO: Starting with following command line ... ./mysqlbackup --defaults-file=/service/mysql5.5/my.cnf --backup-dir=/backup/5.5/normal copy-back IMPORTANT: Please check that mysqlbackup run completes successfully. At the end of a successful 'copy-back' run mysqlbackup prints "mysqlbackup completed OK!".
--------------------------------------------------------------------
Server Repository Options:
--------------------------------------------------------------------
datadir = /data/mysql5.5 innodb_data_home_dir = /data/mysql5.5 innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /data/mysql5.5 innodb_log_files_in_group = 3 innodb_log_file_size = 512M innodb_page_size = Null innodb_checksum_algorithm = innodb
--------------------------------------------------------------------
Backup Config Options:
--------------------------------------------------------------------
datadir = /backup/5.5/normal/datadir innodb_data_home_dir = /backup/5.5/normal/datadir innodb_data_file_path = ibdata1:10M:autoextend innodb_log_group_home_dir = /backup/5.5/normal/datadir innodb_log_files_in_group = 3 innodb_log_file_size = 536870912 innodb_page_size = 16384 innodb_checksum_algorithm = innodb mysqlbackup: INFO: Uses posix_fadvise() for performance optimization. mysqlbackup: INFO: Creating 14 buffers each of size 16777216. 131123 00:00:44 mysqlbackup: INFO: Copy-back operation starts with following threads 1 read-threads 1 write-threads 131123 00:00:45 mysqlbackup: INFO: Copying /backup/5.5/normal/datadir/ibdata1. 131123 00:00:45 mysqlbackup: INFO: Copying /backup/5.5/normal/datadir/common_schema/_global_qs_variables.ibd. 131123 00:00:45 mysqlbackup: INFO: Copying /backup/5.5/normal/datadir/common_schema/_global_script_report_data.ibd. 131123 00:00:45 mysqlbackup: INFO: Copying /backup/5.5/normal/datadir/common_schema/_global_split_column_names_table.ibd. 131123 00:00:45 mysqlbackup: INFO: Copying /backup/5.5/normal/datadir/common_schema/_global_sql_tokens.ibd. 131123 00:00:45 mysqlbackup: INFO: Copying /backup/5.5/normal/datadir/common_schema/_known_thread_states.ibd. 131123 00:00:45 mysqlbackup: INFO: Copying /backup/5.5/normal/datadir/common_schema/_named_scripts.ibd. 131123 00:00:45 mysqlbackup: INFO: Copying /backup/5.5/normal/datadir/common_schema/_script_statements.ibd. 131123 00:00:45 mysqlbackup: INFO: Copying /backup/5.5/normal/datadir/common_schema/_waits.ibd. 131123 00:00:45 mysqlbackup: INFO: Copying /backup/5.5/normal/datadir/common_schema/help_content.ibd. 131123 00:00:45 mysqlbackup: INFO: Copying /backup/5.5/normal/datadir/common_schema/metadata.ibd. 131123 00:00:45 mysqlbackup: INFO: Copying /backup/5.5/normal/datadir/common_schema/numbers.ibd. 131123 00:00:45 mysqlbackup: INFO: Copying /backup/5.5/normal/datadir/zwc/t2.ibd. mysqlbackup: Progress in MB: 200 400 131123 00:00:54 mysqlbackup: INFO: Copying the database directory 'common_schema' 131123 00:00:55 mysqlbackup: INFO: Copying the database directory 'mysql' 131123 00:00:55 mysqlbackup: INFO: Copying the database directory 'performance_schema' 131123 00:00:55 mysqlbackup: INFO: Copying the database directory 'test' 131123 00:00:55 mysqlbackup: INFO: Copying the database directory 'zwc' mysqlbackup: Progress in MB: 600 800 131123 00:01:06 mysqlbackup: INFO: Completing the copy of all non-innodb files. 131123 00:01:06 mysqlbackup: INFO: Copying the log file 'ib_logfile0' mysqlbackup: Progress in MB: 1000 1200 1400 131123 00:01:16 mysqlbackup: INFO: Copying the log file 'ib_logfile1' mysqlbackup: Progress in MB: 1600 1800 131123 00:01:27 mysqlbackup: INFO: Copying the log file 'ib_logfile2' mysqlbackup: Progress in MB: 2000 2200 2400 131123 00:01:38 mysqlbackup: INFO: Copy-back operation completed successfully. 131123 00:01:38 mysqlbackup: INFO: Finished copying backup files to '/data/mysql5.5' mysqlbackup completed OK!
設置權限，啟動MySQL服務
[root@test mysql5.5]# chown -R mysql.mysql * [root@test mysql5.5]# /service/mysql5.5/bin/mysqld_safe --defaults-file=/service/mysql5.5/my.cnf --basedir=/service/mysql5.5 --datadir=/data/mysql5.5 --user=mysql & [1] 6525 [root@test mysql5.5]# 131123 00:04:00 mysqld_safe Logging to '/data/mysql5.5/test.err'. 131123 00:04:00 mysqld_safe Starting mysqld daemon with databases from /data/mysql5.5[root@test mysql5.5]# cat test.err 131123 00:04:00 mysqld_safe Starting mysqld daemon with databases from /data/mysql5.5 131123 0:04:00 InnoDB: The InnoDB memory heap is disabled 131123 0:04:00 InnoDB: Mutexes and rw_locks use GCC atomic builtins 131123 0:04:00 InnoDB: Compressed tables use zlib 1.2.3 131123 0:04:00 InnoDB: Initializing buffer pool, size = 2.4G 131123 0:04:00 InnoDB: Completed initialization of buffer pool 131123 0:04:00 InnoDB: highest supported file format is Barracuda. InnoDB: Log scan progressed past the checkpoint lsn 3406091276 131123 0:04:00 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 3406091710 131123 0:04:01 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 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 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 16178, file name ./ZWC-TEST.000024 131123 0:04:01 InnoDB: Waiting for the background threads to start 131123 0:04:02 InnoDB: 1.1.8 started; log sequence number 3406091710 131123 0:04:02 [Note] Recovering after a crash using ZWC-TEST 131123 0:04:02 [Note] Starting crash recovery... 131123 0:04:02 [Note] Crash recovery finished. 131123 0:04:02 [Note] Server hostname (bind-address): '0.0.0.0'; port: 30306 131123 0:04:02 [Note] - '0.0.0.0' resolves to '0.0.0.0'; 131123 0:04:02 [Note] Server socket created on IP: '0.0.0.0'. 131123 0:04:02 [Warning] 'user' entry 'root@test' ignored in --skip-name-resolve mode. 131123 0:04:02 [Warning] 'user' entry '@test' ignored in --skip-name-resolve mode. 131123 0:04:02 [Warning] 'proxies_priv' entry '@ root@test' ignored in --skip-name-resolve mode. 131123 0:04:02 [Note] Event Scheduler: Loaded 0 events 131123 0:04:02 [Note] /service/mysql5.5/bin/mysqld: ready for connections. Version: '5.5.25-log' socket: '/data/mysql5.5/mysql.sock' port: 30306 ZWC 131123 0:04:02 [Note] Event Scheduler: scheduler thread started with id 1
數據庫已經恢復
[root@test mysql5.5]# /service/mysql5.5/bin/mysql -uroot -p -D zwc Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.5.25-log ZWC Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. root@linuxidc12:05:07>select count(*),now() from t1; +----------+---------------------+ | count(*) | now() | +----------+---------------------+ | 10000000 | 2013-11-23 00:05:17 | +----------+---------------------+ 1 row in set (0.04 sec) root@linuxidc12:05:17>select count(*),now() from t2; +----------+---------------------+ | count(*) | now() | +----------+---------------------+ | 10000000 | 2013-11-23 00:05:19 | +----------+---------------------+ 1 row in set (2.91 sec)
相關文章
Mysql自動備份與還原方法，需要的朋友可以參考下。2011-06-06
這篇文章主要介紹了MySQL常用命令，總結了經常使用的MySQL命令，需要的朋友可以參考下2014-02-02
MySQL配置文件my.cnf中文版，使用mysql的朋友可以參考下，了解每個參數的重要性。2011-09-09
這篇文章主要介紹了MySQL數據庫之觸發(fā)器的相關資料，幫助大家更好的理解和使用MySQL，感興趣的朋友可以了解下2020-09-09
這篇文章主要介紹了mysql數據庫的分區(qū)表的相關資料,文章介紹了兩種創(chuàng)建SQL表分區(qū)的方法,分別是手動創(chuàng)建和使用MySQL的定時事件來自動創(chuàng)建分區(qū),手動創(chuàng)建分區(qū)時,需要在代碼中判斷分區(qū)并新增,可能會引入一些問題,需要的朋友可以參考下2024-11-11
這篇文章主要為大家詳細介紹了MySQL安裝步驟配置方法圖文，具有一定的參考價值，感興趣的小伙伴們可以參考一下2017-10-10
本文主要介紹了Mysql ALTER TABLE加字段的時候到底鎖不鎖表，文中通過示例代碼介紹的非常詳細，具有一定的參考價值，感興趣的小伙伴們可以參考一下2021-08-08
MySQL InnoDB ReplicaSet(副本集)簡單介紹
這篇文章主要介紹了MySQL InnoDB ReplicaSet(副本集)的相關資料，幫助大家更好的理解和學習使用MySQL，感興趣的朋友可以了解下2021-04-04
MySQL提示Accessdeniedforuser‘‘@‘localhost‘”的解決方案
在使用MySQL數據庫的過程中,有時會遇到錯誤提示：“Access denied for user ''@'localhost'”,這個錯誤通常意味著MySQL服務器拒絕了當前用戶的連接請求,本文將詳細探討該問題的原因及解決方法,需要的朋友可以參考下2025-01-01
mysql優(yōu)化的重要參數 key_buffer_size table_cache
MySQL服務器端的參數有很多，但是對于大多數初學者來說，眾多的參數往往使得我們不知所措，但是哪些參數是需要我們調整的，哪些對服務器的性能影響最大呢2016-05-05