Mysql备份脚本
2019-03-31 本文已影响0人
yahzon
版本1
rem ---move old bakupfile to tmp folder /y means no prompt ---
if not exist "D:\bak\tmp" md "D:\bak\tmp"
move /y D:\bak\mysqlbak D:\bak\tmp
if not exist "D:\bak\mysqlbak" md "D:\bak\mysqlbak"
rem ----------------------------------------------------------
rem ---use mysqldump dump database to sql---
c:
cd "C:\Program Files\MySQL\MySQL Server 5.7\bin"
mysqldump -uroot -proot portal > D:\bak\mysqlbak\%date:~0,4%%date:~5,2%%date:~8,2%.sql
rem ---del old backupfile in D:\bak\tmp
rd /s /q D:\bak\tmp\
版本2
@echo off
d:
cd D:\bak\mysqlbak\
del mysqldata2.sql
ren mysqldata1.sql mysqldata2.sql
ren mysqldata.sql mysqldata1.sql
c:
cd "C:\Program Files\MySQL\MySQL Server 5.7\bin"
mysqldump -uroot -proot portal > D:\bak\mysqlbak\mysqldata.sql
远程dump语法：
mysqldump -uUSERNAME -pPASSWORD -h 192.168.0.1 DATABASE TABLENAME > /localpath/datafile.sql
linux版本：
DATE=`date + %Y%m%d_%H%M%S`
mv /home/mysqldata/data/* /home/mysqldata/tmp
$MYSQLBIN/mysqldump --opt -uroot -ppwd dbname > /home/mysqldata/data/dbname_$DATE.sql
rm -rf /home/mysqldata/tmp
