Home  >  Article  >  Operation and Maintenance  >  Do you know how to regularly back up the database under Linux?

Do you know how to regularly back up the database under Linux?

藏色散人
藏色散人forward
2021-09-14 15:40:212160browse

The following column linux system tutorial will introduce to you the method of regularly backing up the database under Linux. I hope it will be helpful to friends in need!

Do you know how to regularly back up the database under Linux?

How to use crontab to backup MYSQL database regularly under Linux

Just follow the following 3 steps, everything is under your control:

Step one: Configure the backup directory code on the server:

 mkdir /var/lib/mysqlbackup 
 cd /var/lib/mysqlbackup

Step two: Write backup script code:

 vi dbbackup.sh
 粘帖以下代码,务必更改其中的username,password和dbname。
 #!/bin/sh
 mysqldump -uuser -ppassword dbname | gzip > /var/lib/mysqlbackup/dbnamedate +%Y-%m-%d_%H%M%S.sql.gz
 cd  /var/lib/mysqlbackup
 rm -rf find . -name '*.sql.gz' -mtime 10  #删除10天前的备份文件

Step 3: Change backup script permissions

 chmod +x dbbackup.sh

Step 4: Use crontab to execute backup script code regularly:

crontab -e

If you back up at 21:00 every night, add the following code

00 21 * /var/lib/mysqlbackup/dbbackup.sh

Problems you will encounter:
1.mysqldump is the command to back up the database. If you don’t understand, just Baidu it .
2. Crontab is a command for scheduled tasks. If you don’t understand, you can visit http://www.thinkphp.cn/code/1...
3. When backing up data, you must first make sure you have set a password for root. Otherwise, Got error: 1045: Access denied for user 'root'@'localhost' (using password: YES) when trying to connect

will be reported when mysqldump is executed. Solution:

Log in to mysql client

 mysql -hserverip -uroot -p
 mysql> use mysql; Database changed
 mysql> update user set password=password('new password') where user='root'; Query OK, 4 rows affected (0.00 sec) Rows matched: 4  Changed: 4  Warnings: 0
 mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) //这个命令是给用户赋予了新的权限或者密码,直接读到内存中不需要重启数据库防止出错
 mysql> quit

Recommended learning: "linux video tutorial"

The above is the detailed content of Do you know how to regularly back up the database under Linux?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:segmentfault.com. If there is any infringement, please contact admin@php.cn delete