cp /etc/passwd /tmp
awk -F ':' '{print $1,$3,$4,$6,$7}' passwd > abc
mysql
create table pwd (a char(30),b int,c int,d int,e int);
mysql> load data infile '/tmp/abc' into table pwd passwd fields terminated by ' ';
使用mydumper,myload进行备份还原，并与mysqldump进行速度比较
1 Requirements
yum install gcc gcc-c++ glib2-devel mysql-devel zlib-devel pcre-devel -y
rpm -ivh cmake-2.6.4-7.el5.i386.rpm
2 install
tar fvxz mydumper-0.2.3.tar.gz
cd mysqldumper-0.2.3
cmake .
make
make install
3 op
mkdir -pv /tmp/sqlbak
mkdir: 已创建目录 “/tmp/sqlbak”
4
[root@localhost mydumper-0.2.3]# mydumper -B test -u root -o /tmp/sqlbak
mysql> drop database test;
Query OK, 5 rows affected (0.15 sec)
mysql> create database test;
Query OK, 1 row affected (0.00 sec)
[root@localhost mydumper-0.2.3]# myloader -u root -d /tmp/sqlbak -B test
备份
[root@localhost mysql]# mysqldump -u root -p test > /tmp/mysql.bak
Enter password: cd
mysql> drop database test;
恢复
mysql> create database test;
[root@localhost mysql]# mysql -u root -p test < /tmp/mysql.bak
Enter password:
