!/bin/shfind/tmp/homeworkmaxdepth1typed|whilereaddir;docount$(find"$dir"typef|wcl)echo"$dir:$count"done!/bin

clientport3306socket/tmp/mysql.sockdefaultcharactersetutf8mysqlddefaultcharactersetutf8usermysqlpo

一：搭建docker1.1 部署控制器curlSsLo/tmp/csphereinstall.shhttps://csphere.cn/static/csphereinstallv2.shsudoenvROLEcontrollerCSPHERE\_

1.05Ansible远程执行脚本首先创建一个shell脚本vim /tmp/test.sh //加入内容!/bin/bashechodate/tmp/ansible_test.txt然后把该脚本分发到各个机器上ansibletesthostmcop

在mysql命令行下执行以下sql语句:mysqlselect\fromxi\_tableintooutfile’/tmp/test.xls’;一句话搞定。linux系统尽量导出在/tmp目录下，不会涉及读写权限问题！导出为txt文件：select\fromxi\_tableintooutfile’/tmp/

1、把下载的JDK软件包上传到服务器/tmp路径下，然后复制到/usr/local路径下进行解压。进入/usr/local路径下cd/usr/local将文件复制到此路径下cp/tmp/jdk7u79linuxx64.tar.gz./解压tarzxvfjdk7u79li

（一）\client\port3306socket/tmp/mysql.sock\mysqld\port3306socket/tmp/mysql.sockbasedir/usr/local/mysqldatadir/data/mysqlpidfile/data

1、二进制日志备份    mysqlbinlogbinlog.000001/tmp/bak.sql//备份binlog.000001二进制文件，在tmp目录下生成bak.sql文件。2、二进制日志恢复    2.1SQL文件恢复        mysqlurootproote"source/tmp/bak.s

\mkdirp/home/mysql/3306/{data,binlog,logs}clientport3306socket/tmp/my3306.sockmysqlnoautorehashmysqldusermysql

1.类型转换代码Int32转换为int16会丢失精度，这是总所周知的，但是具体如何丢失精度的，请看下面的代码：vartmp1int32123424021vartmp2int16vartmp3uint16tmp2int16(tmp1)tmp3uint16(t