mysql导入、导出、查看binlog命令

-- mysql 导出

mysqldump -h 172.xx.xx.xx -u [username] -p [database]> db.sql

-- mysql 导入

msql -u[username] -p

source d:/db.sql

 --创建数据库

CREATE DATABASE IF NOT EXISTS ifaes default charset utf8 COLLATE utf8_general_ci; 

 -- 授权

grant select,delete,update,insert on ifaes.* to dev@'%' identified by 'dev';

grant all privileges on *.* to shuzzcuser@'localhost';

GRANT INSERT,DELETE,UPDATE,SELECT ON fcex.* TO 'fcex'@'localhost';

flush privileges;

 

 -- 查看binlog

cd /usr/local/mysql/bin

/mysqlbinlog -v --start-datetime='yyyy-MM-dd HH:mm:ss' --stop-datetime='yyyy-MM-dd HH:mm:ss' /data/mysql/logs/mysql-bin.000004 >/tmp/tmp.sql

 

 

-- 拷贝文件到远程服务器

scp -P port web.zip [e-mail]:/data/www

 

拷贝覆盖

\cp -rf /source /target