Home > Database > Mysql Tutorial > body text

数据库定时备份脚本

WBOY
Release: 2016-06-07 17:09:52
Original
918 people have browsed it

为了防止数据库服务器损坏,需要每天备份数据到客户端,数据保存在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)

linux

Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!