摘要:
[client]port = 3306socket = /tmp/mysql.sock[mysqld]log-bin = /data/mysql/bin/mysqlbinlogserver-id = 1 log-bin-trust-function-creators = 1 #binlog-do-d 阅读全文
摘要:
#!/bin/shDUMP=/usr/bin/mysqldump OUT_DIR=/var/ftp/iips/mysqlbak LINUX_USER=root DB_NAME=yfdmbd DB_USER=root DB_PASS=123456 DAYS=7 cd $OUT_DIR date=`da 阅读全文
摘要:
———————————————-库操作———————————————-1.①导出一个库结构 mysqldump -d dbname -u root -p > xxx.sql mysqldump -d dbname -u root -p > xxx.sql ②导出多个库结构 mysqldump -d 阅读全文