mysqldump 导出MYSQL数据库脚本
创建一个txt文本,将下列内容复制进文本内,修改文件名后缀为bat即可
@echo off
set hour=%time:~0,2%
if "%time:~0,1%"==" " set hour=0%time:~1,1%
set now=%Date:~0,4%%Date:~5,2%%Date:~8,2%%hour%%Time:~3,2%%Time:~6,2%
echo %now%
set backup_path=E:\DataBase-Backup
set database_name=test
set mysqldump="D:\Program Files\MySQL\MySQL Server 5.5\bin\mysqldump.exe"
set user=root
set password=password
set host=localhost
set backupfile=E:\DataBase-Backup\%database_name%-%now%.sql
if not exist %backup_path% md %backup_path%
%mysqldump% -h%host% -u%user% -p%password% %database_name% >E:\DataBase-Backup\%database_name%-%now%.sql
@echo on
pause
如果出现mysqldump: Got error: 1045: Access denied for user ‘root’@‘localhost’ (using password: YES) when trying to connect错误,两种处理方法:
1.在查询语句中加入-hlocalhost 或者-h127.0.0.1
2.查询账号密码是否正确,看密码是否有特殊符号,GRANT SELECT, LOCK TABLES, SHOW VIEW, EVENT, TRIGGER, RELOAD, REPLICATION CLIENT ON . TO ‘root’@‘localhost’ IDENTIFIED BY ‘password’;
可以修改密码