最近小弟在网上查了一些资料。想写个备份mysql数据库的存储过程
CREATE DEFINER=`root`@`localhost` PROCEDURE `prc_rcuk`()
BEGIN
String sql='backup database rcuk to disk="d:\rcuk.dat" '
exec(sql)
END但是保存的时候老报错。提示各位前辈不知道能否帮忙,mysql备份/恢复数据库的存储过程怎么写?在jsp页面里如何调用?小弟万分感谢。稽首顿拜!
CREATE DEFINER=`root`@`localhost` PROCEDURE `prc_rcuk`()
BEGIN
String sql='backup database rcuk to disk="d:\rcuk.dat" '
exec(sql)
END但是保存的时候老报错。提示各位前辈不知道能否帮忙,mysql备份/恢复数据库的存储过程怎么写?在jsp页面里如何调用?小弟万分感谢。稽首顿拜!
@echo off
echo %date:~0,4%-%date:~5,2%-%date:~8,2%
echo .
echo .success!
mkdir %date:~0,4%-%date:~5,2%-%date:~8,2%
echo 开始备份数据库到%date:~0,4%-%date:~5,2%-%date:~8,2%中,请稍候......
echo .
echo .success!mysqldump --user=root --password=123 ruck>%date:~0,4%-%date:~5,2%-%date:~8,2%\Backup.sqlecho 成功创建所有文件,备份时间:%date:~0,4%-%date:~5,2%-%date:~8,2%,按任意键退出!
echo .
echo .......................备份文件..............................
dir %date:~0,4%-%date:~5,2%-%date:~8,2%\
echo .......................备份文件...............................
echo. & pause
但是backup.sql是空的。不知道哪里出问题了