@echo off
echo.
echo Database backup echo *****************************
echo.
echo Today is %date%
echo Time is %time%
echo.
echo *****************************
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"cd C:\Program Files\MySQL\MySQL Server 5.0\bin
mysqldump -uroot -psuntoyo --add-drop-database -B winning > c:\3.sqlmysql -uroot -psuntoyo astar -e "Call deletesalesdata("%date%");"echo.echo MySQL database backup successful,please check it...echo.
echo.pause
备份后,Call deletesalesdata
echo.
echo Database backup echo *****************************
echo.
echo Today is %date%
echo Time is %time%
echo.
echo *****************************
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"cd C:\Program Files\MySQL\MySQL Server 5.0\bin
mysqldump -uroot -psuntoyo --add-drop-database -B winning > c:\3.sqlmysql -uroot -psuntoyo astar -e "Call deletesalesdata("%date%");"echo.echo MySQL database backup successful,please check it...echo.
echo.pause
备份后,Call deletesalesdata
还是 Call deletesalesdata(date)呢?
不好意思,是我误解了,你的目的是先备份,然后调用存储过程处理deletesalesdata(Date)数据是吧!
现在是mysql -uroot -psuntoyo astar -e "Call deletesalesdata("%date%");"有问题
估计是时间没传进去。
改成 mysql -uroot -psuntoyo astar -e "Call deletesalesdata($date);"试试看。
可能是你备份的时候没有用 -r 参数,你mysqldump里面有drop database的语句吧。
-R, --routines Dump stored routines (functions and procedures).加上-R
1. cd C:\Program Files\MySQL\MySQL Server 5.0\bin
应该用:
cd /d "C:\Program Files\MySQL\MySQL Server 5.0\bin"
2. mysql -uroot -psuntoyo astar -e "Call deletesalesdata("%date%")
应该用:
mysql -uroot -psuntoyo astar -e "Call deletesalesdata("%Ymd%")
MYSQLDUMP -uroot --add-drop-database -B -E -R -p >r:\temp\123.TXT
可备份SP
2、
mysql -uroot -psuntoyo astar -e "Call deletesalesdata("%Ymd%")
楼主已经mysql导入过了,所以现在的存储过程已经丢了,需要重新写或者有保留的procedure的sql文件,直接导入。
echo off
echo.
echo MySQL数据库备份echo *****************************
echo.
echo 今天是 %date%
echo 时间是 %time%
echo.
echo *****************************
set "Ymd=%date:~,4%%date:~5,2%%date:~8,2%"md "D:\JDBC\%Ymd%""C:\Program Files\MySQL\MySQL Server 5.1\bin\mysqldump" --opt -Q -uroot -pabc123 --default-character-set=latin1 test > "D:\JDBC\%Ymd%\test_bak.sql"echo.echo MySQL数据库备份完成,请进行检查echo.
echo.pause
cd C:\Program Files\MySQL\MySQL Server 5.0\bin
mysql -uroot -psuntoyo astar< c:\astar201104081603.sql
一闪而过,提示还原成功,但是我用工具打开的时候,发现里面什么也没有。
一旦删除掉ASTAR,就有问题。
CREATE DATABASE ASTAR
USE ASTAR
OR
在备份时加-B参数