mysqldump目录下有每天导出的gz文件，现在需要通过一个命令，批量创建带日期格式的目录，并将当天日期导出的文件mv到相应目录中。
例如：20160108，文件 mysql_10.0.0.11_all_20160108_2100.sql.gz mv 到目录 20160108_mysqldump_10.0.0.11_3306

1、文件如下

[ftpuser01@linux-node1 mysqldump]$ ll
total 30804
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:20 20160108_mysqldump_10.0.0.11_3306
-rw-r--r-- 1 ftpuser01 ftpgrp01 2158414 Jan 8 17:29 mysql_10.0.0.11_all_20151225_2100.sql.gz
-rw-r--r-- 1 ftpuser01 ftpgrp01 2172565 Jan 8 17:29 mysql_10.0.0.11_all_20151226_2100.sql.gz
-rw-r--r-- 1 ftpuser01 ftpgrp01 2186811 Jan 8 17:29 mysql_10.0.0.11_all_20151227_2100.sql.gz
-rw-r--r-- 1 ftpuser01 ftpgrp01 2201111 Jan 8 17:29 mysql_10.0.0.11_all_20151228_2100.sql.gz
-rw-r--r-- 1 ftpuser01 ftpgrp01 2215431 Jan 8 17:29 mysql_10.0.0.11_all_20151229_2100.sql.gz
-rw-r--r-- 1 ftpuser01 ftpgrp01 2229360 Jan 8 17:29 mysql_10.0.0.11_all_20151230_2100.sql.gz
-rw-r--r-- 1 ftpuser01 ftpgrp01 2243729 Jan 8 17:29 mysql_10.0.0.11_all_20151231_2100.sql.gz
-rw-r--r-- 1 ftpuser01 ftpgrp01 2258170 Jan 8 17:29 mysql_10.0.0.11_all_20160101_2100.sql.gz
-rw-r--r-- 1 ftpuser01 ftpgrp01 2272444 Jan 8 17:29 mysql_10.0.0.11_all_20160102_2100.sql.gz
-rw-r--r-- 1 ftpuser01 ftpgrp01 2286784 Jan 8 17:29 mysql_10.0.0.11_all_20160103_2100.sql.gz
-rw-r--r-- 1 ftpuser01 ftpgrp01 2300978 Jan 8 17:29 mysql_10.0.0.11_all_20160104_2100.sql.gz
-rw-r--r-- 1 ftpuser01 ftpgrp01 2315247 Jan 8 17:29 mysql_10.0.0.11_all_20160105_2100.sql.gz
-rw-r--r-- 1 ftpuser01 ftpgrp01 2329819 Jan 8 17:29 mysql_10.0.0.11_all_20160106_2100.sql.gz
-rw-r--r-- 1 ftpuser01 ftpgrp01 2344475 Jan 8 17:30 mysql_10.0.0.11_all_20160107_2100.sql.gz

2、答案：

点击(此处)折叠或打开

[ftpuser01@linux-node1 mysqldump]$ ls *.gz|tr ' ' '\n'|awk -F'_' '{print $4}'|sed -r 's/(.*)/mkdir \1_mysqldump_10.0.0.11_3306;mv mysql_*\1*.sql.gz \1_mysqldump_10.0.0.11_3306;/' | bash

3、结果如下：

点击(此处)折叠或打开

[ftpuser01@linux-node1 mysqldump]$ ll
total 60
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:46 20151225_mysqldump_10.0.0.11_3306
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:46 20151226_mysqldump_10.0.0.11_3306
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:46 20151227_mysqldump_10.0.0.11_3306
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:46 20151228_mysqldump_10.0.0.11_3306
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:46 20151229_mysqldump_10.0.0.11_3306
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:46 20151230_mysqldump_10.0.0.11_3306
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:46 20151231_mysqldump_10.0.0.11_3306
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:46 20160101_mysqldump_10.0.0.11_3306
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:46 20160102_mysqldump_10.0.0.11_3306
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:46 20160103_mysqldump_10.0.0.11_3306
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:46 20160104_mysqldump_10.0.0.11_3306
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:46 20160105_mysqldump_10.0.0.11_3306
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:46 20160106_mysqldump_10.0.0.11_3306
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:46 20160107_mysqldump_10.0.0.11_3306
drwxr-xr-x 2 ftpuser01 ftpgrp01 4096 Jan 8 17:20 20160108_mysqldump_10.0.0.11_3306
[ftpuser01@linux-node1 mysqldump]$ tree .
[ftpuser01@linux-node1 mysqldump]$ export LANG=
[ftpuser01@linux-node1 mysqldump]$ tree .
.
|-- 20151225_mysqldump_10.0.0.11_3306
| `-- mysql_10.0.0.11_all_20151225_2100.sql.gz
|-- 20151226_mysqldump_10.0.0.11_3306
| `-- mysql_10.0.0.11_all_20151226_2100.sql.gz
|-- 20151227_mysqldump_10.0.0.11_3306
| `-- mysql_10.0.0.11_all_20151227_2100.sql.gz
|-- 20151228_mysqldump_10.0.0.11_3306
| `-- mysql_10.0.0.11_all_20151228_2100.sql.gz
|-- 20151229_mysqldump_10.0.0.11_3306
| `-- mysql_10.0.0.11_all_20151229_2100.sql.gz
|-- 20151230_mysqldump_10.0.0.11_3306
| `-- mysql_10.0.0.11_all_20151230_2100.sql.gz
|-- 20151231_mysqldump_10.0.0.11_3306
| `-- mysql_10.0.0.11_all_20151231_2100.sql.gz
|-- 20160101_mysqldump_10.0.0.11_3306
| `-- mysql_10.0.0.11_all_20160101_2100.sql.gz
|-- 20160102_mysqldump_10.0.0.11_3306
| `-- mysql_10.0.0.11_all_20160102_2100.sql.gz
|-- 20160103_mysqldump_10.0.0.11_3306
| `-- mysql_10.0.0.11_all_20160103_2100.sql.gz
|-- 20160104_mysqldump_10.0.0.11_3306
| `-- mysql_10.0.0.11_all_20160104_2100.sql.gz
|-- 20160105_mysqldump_10.0.0.11_3306
| `-- mysql_10.0.0.11_all_20160105_2100.sql.gz
|-- 20160106_mysqldump_10.0.0.11_3306
| `-- mysql_10.0.0.11_all_20160106_2100.sql.gz
|-- 20160107_mysqldump_10.0.0.11_3306
| `-- mysql_10.0.0.11_all_20160107_2100.sql.gz
`-- 20160108_mysqldump_10.0.0.11_3306
`-- mysqldump_10.0.0.11_3306_20160108.sql.gz
15 directories, 15 files
[ftpuser01@linux-node1 mysqldump]$

ITPub博客

企业生产案例：批量创建目录并移动带日期文件到相应目录

最新文章