Home >Database >Mysql Tutorial >数据库定时备份脚本
数据库定时备份脚本
- WBOYOriginal
- 2016-06-07 17:09:52979browse
为了防止数据库服务器损坏，需要每天备份数据到客户端，数据保存在export目录下，下面是备份脚本：
为了防止数据库服务器损坏，，需要每天备份数据到客户端，数据保存在export目录下，下面是备份脚本：
cd export
setlocal
set NLS_LANG=AMERICAN_AMERICA.AL32UTF8
set rq=%date:~0,4%%date:~5,2%%date:~8,2%
exp system/manager@clienttns file=all_%rq%.dmp rows=y log=all_%rq%.log owner=(user1,user2,user3)
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Oracle Flashback之Flashback table和flashback dropNext article：Linux Oracle 10.2.0.1 lsnrctl无法启动