C:\Program Files\MySQL\MySQL Server 5.0\bin>mysqldump --opt -u root -p yup >
f:\backyup.sql
回车
Enter password:
由于我的root没有密码,所以直接回车
得到提示
mysqldump: Got error: 2003: Can't connect to MySQL server on 'localhost' (10061)
when trying to connect
我的MYSQL5.0.2服务已打开
f:\backyup.sql
回车
Enter password:
由于我的root没有密码,所以直接回车
得到提示
mysqldump: Got error: 2003: Can't connect to MySQL server on 'localhost' (10061)
when trying to connect
我的MYSQL5.0.2服务已打开
f:\backyup.sql
楼主试试看。DB_HOST不要用127.0.0.1,用本机的网卡IP。@echo onREM
REM 生成新建数据库和基本设置的SQL脚本,
REM
REM Copyright Bobby
REM
REMset DB_USER=root
set DB_HOST=192.168.19.251
set DB_NAME=cs
set BACKUP_DB_OPT=-d --opt -R
set CREATE_DB_SCRIPT_NAME=createdb.sql
set BACKUP_BASESETTING_OPT=--opt -t
set BASESETTING_SCRIPT_NAME=basesetting.sql
set BASESETTING_TABLES_NAME=page user permitmysqldump -u %DB_USER% -p -h %DB_HOST% %BACKUP_DB_OPT% -r %CREATE_DB_SCRIPT_NAME% %DB_NAME%mysqldump -u %DB_USER% -p -h %DB_HOST% %BACKUP_BASESETTING_OPT% -r %BASESETTING_SCRIPT_NAME% %DB_NAME% %BASESETTING_TABLES_NAME%