Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > linux系统mysql数据库自动备份_MySQL

linux系统mysql数据库自动备份_MySQL

WBOY
Release： 2016-06-01 13:34:04
Original
874 people have browsed it

bitsCN.com

linux系统mysql数据库自动备份

 

1、建一个shell脚本 

 

   vi bak.sh 

 

  mysqldump -u用户名 -p密码 --database 数据库名 > data.sql 

 

2、脚本授权 

 

   chmod +x bak.sh 

 

3、使用crontab命令定期执行脚本 

 

   crontab -e 

 

   在任务中输入： 

 

   0 0 * * * /脚本路径/bak.sh 

bitsCN.com
Related labels：
database linux m database username
source：php.cn
Previous article：mysql用户权限管理_MySQL Next article：Mysql之左连接右连接内连接示例_MySQL
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
Latest Articles by Author
Latest Issues
Illuminate\Database\QueryException: SQLSTATE: General error: 1364 Why can't I enter data? In the appointment table you don't want to enter the userid attrib...
From 2024-04-03 22:39:00
0
1
363
add jpg image from mysql to html As a preface, I'm very new to this so this might be a stupid question, but... I'm trying t...
From 2024-04-02 13:27:34
0
1
344
How to update Laravel Eloquent column cast to collection I'm using Laravel10. I utilize the conversion of JSON columns via: namespaceApp\Models; us...
From 2024-03-30 09:54:00
0
2
352
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template