欧美bbbwbbbw肥妇,免费乱码人妻系列日韩,一级黄片

教你如何恢復(fù)使用MEB備份的MySQL數(shù)據(jù)庫(kù)

 更新時(shí)間：2016年09月28日 08:53:40   作者：Linux公社  
這篇文章主要介紹了教你如何恢復(fù)使用MEB備份的MySQL數(shù)據(jù)庫(kù)的具體方法,需要的朋友可以參考下

恢復(fù)使用MEB備份的MySQL數(shù)據(jù)庫(kù)，執(zhí)行一個(gè)普通備份

[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服務(wù)

[root@test mysql5.5]# /service/mysql5.5/bin/mysqladmin shutdown -uroot -p

刪除數(shù)據(jù)目錄里的文件

[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!

設(shè)置權(quán)限，啟動(dòng)MySQL服務(wù)

[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

數(shù)據(jù)庫(kù)已經(jīng)恢復(fù)

[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)

相關(guān)文章

  • mysql中字符串截取與拆分的實(shí)現(xiàn)示例

    mysql中字符串截取與拆分的實(shí)現(xiàn)示例

    mysql 字符串截取與拆分在很多地方都可以用得到,本文主要介紹了mysql中字符串截取與拆分的實(shí)現(xiàn)示例,具有一定的參考價(jià)值,感興趣的可以了解一下
    2023-12-12
  • MySQL切分查詢用法分析

    MySQL切分查詢用法分析

    這篇文章主要介紹了MySQL切分查詢用法,結(jié)合實(shí)例形式分析了通過(guò)do while語(yǔ)句進(jìn)行切分查詢的具體實(shí)現(xiàn)技巧,需要的朋友可以參考下
    2016-04-04
  • Oracle開(kāi)啟和關(guān)閉的四種模式

    Oracle開(kāi)啟和關(guān)閉的四種模式

    這篇文章主要介紹了Oracle開(kāi)啟和關(guān)閉的四種模式 ,本文給大家介紹的非常詳細(xì)，具有一定的參考借鑒價(jià)值，需要的朋友可以參考下
    2019-05-05
  • 為什么mysql字段要使用NOT NULL

    為什么mysql字段要使用NOT NULL

    數(shù)據(jù)庫(kù)字段一定要設(shè)置為 not null,不然會(huì)有很大的bug，下面就一起來(lái)介紹一下，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧
    2021-05-05
  • 初步介紹MySQL中的集合操作

    初步介紹MySQL中的集合操作

    這篇文章主要介紹了初步的MySQL中的集合操作,即UNION DISTINCT和UNION ALL兩個(gè)命令,需要的朋友可以參考下
    2015-04-04
  • MySQL查看所有用戶的實(shí)現(xiàn)

    MySQL查看所有用戶的實(shí)現(xiàn)

    本文主要介紹了MySQL查看所有用戶的實(shí)現(xiàn)，文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧
    2023-03-03
  • 詳解MySQL InnoDB存儲(chǔ)引擎的內(nèi)存管理

    詳解MySQL InnoDB存儲(chǔ)引擎的內(nèi)存管理

    這篇文章主要介紹了詳解MySQL InnoDB存儲(chǔ)引擎的內(nèi)存管理，幫助大家更好的理解和學(xué)習(xí)使用MySQL數(shù)據(jù)庫(kù)，感興趣的朋友可以了解下
    2021-04-04
  • MySQL如何更改數(shù)據(jù)庫(kù)數(shù)據(jù)存儲(chǔ)目錄詳解

    MySQL如何更改數(shù)據(jù)庫(kù)數(shù)據(jù)存儲(chǔ)目錄詳解

    這篇文章主要給大家介紹了關(guān)于MySQL如何更改數(shù)據(jù)庫(kù)數(shù)據(jù)存儲(chǔ)目錄的相關(guān)資料，文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧
    2018-11-11
  • mysql MGR 單主多主模式切換知識(shí)點(diǎn)詳解

    mysql MGR 單主多主模式切換知識(shí)點(diǎn)詳解

    在本篇文章里小編給大家整理了關(guān)于mysql MGR 單主多主模式切換知識(shí)點(diǎn)詳解內(nèi)容，需要的朋友們可以參考下。
    2020-03-03
  • MySQL 8.0 驅(qū)動(dòng)與阿里druid版本兼容問(wèn)題解決

    MySQL 8.0 驅(qū)動(dòng)與阿里druid版本兼容問(wèn)題解決

    MySQL 8.0 驅(qū)動(dòng)與阿里druid版本不兼容會(huì)導(dǎo)致有報(bào)錯(cuò)問(wèn)題，本文就詳細(xì)的介紹一下解決方法，具有一定的參考價(jià)值，感興趣的可以了解一下
    2021-07-07

最新評(píng)論