Home | Mirror | Search |
文檔始創于2010-11-18
版權 © 2011, 2012, 2013 Netkiller(Neo Chan). All rights reserved.
版權聲明
轉載請與作者聯繫,轉載時請務必標明文章原始出處和作者信息及本聲明。
|
|
$Date: 2013-02-04 09:33:18 +0800 (Mon, 04 Feb 2013) $
我的系列文檔
您可以使用iBook閲讀當前文檔
目錄
範例清單
mysqldump -hlocalhost -proot -p**** mydb > mydb.sql
gzip
mysqldump -hlocalhost -proot -p**** mydb | gzip > mydb.sql.gz
mysql -hlocalhost -proot -p**** mydb < mydb.sql
gunzip
gunzip mydb.sql.gz -c | mysql -hlocalhost -proot -p**** mydb
SELECT * INTO OUTFILE 'file_name' FROM tbl_name LOAD DATA INFILE 'file_name' REPLACE INTO TABLE tbl_name
mysql:~# mysqlhotcopy --user=neo --password=chen shop /tmp/backup Locked 100 tables in 0 seconds. Flushed tables (`shop`.`account_log`, `shop`.`ad`, `shop`.`ad_custom`, `shop`.`ad_position`, `shop`.`admin_action`, `shop`.`admin_log`, `shop`.`admin_message`, `shop`.`admin_user`, `shop`.`adsense`, `shop`.`affiliate_log`, ... ... ... `shop`.`user_rank`, `shop`.`users`, `shop`.`virtual_card`, `shop`.`volume_price`, `shop`.`vote`, `shop`.`vote_log`, `shop`.`vote_option`, `shop`.`wholesale`) in 0 seconds. Copying 299 files... Copying indices for 0 files... Unlocked tables. mysqlhotcopy copied 100 tables (299 files) in 0 seconds (0 seconds overall).
https://launchpad.net/percona-xtrabackup
$ rpm -Uhv http://www.percona.com/downloads/percona-release/percona-release-0.0-1.x86_64.rpm
# yum search xtrabackup ================================================================ N/S Matched: XtraBackup ================================================================= holland-xtrabackup.noarch : Xtrabackup plugin for Holland percona-xtrabackup.x86_64 : XtraBackup online backup for MySQL / InnoDB percona-xtrabackup-debuginfo.x86_64 : Debug information for package percona-xtrabackup percona-xtrabackup-test.x86_64 : Test suite for Percona Xtrabackup
# yum install percona-xtrabackup