Shulou(Shulou.com)05/31 Report--

It is believed that many inexperienced people don't know what to do about how to back up MySQL regularly and upload it to git warehouse in Linux. Therefore, this paper summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem.

Server New backup

Create a new backup directory on the server to store the backed-up files

$mkdir / bak

After entering this directory, continue to create two new folders mysqlBak and shDir, one is to put the script files, and the other is to put the backup files.

Next, we can create a new script and execute it after entering the shDir directory.

$vim mysqlBak.sh

The specific code is as follows:

#! bin/sh

# Database configuration information #

CreateAt= `date +% Y-%m-%d-%H:%M:% s`

User=root

Passwd=ghc1996

Dbname=ispace

Mysql_back_path=/bak/mysqlBak

# execute command #

Mysqldump-u $user-p$passwd $dbname > $mysql_back_path/$createAt.sql

Cd / bak/mysqlBak

/ usr/local/git/bin/git add.

/ usr/local/git/bin/git commit-m $createAt

/ usr/local/git/bin/git push

Here is just a simple script, I want to know linux is easy to understand, the implementation is to back up the database and push to the remote warehouse.

So since it is a script, we need to specify when to execute the script and specify that the script is executed.

$crontab-e

We want to perform a backup in the early morning of every day and add it to the remote warehouse, so add

$0 0 * / bin/sh / bak/shDir/mysqlbak.sh

The time specified for the crontab of linux has only five parts

Use the command crontab-e and edit the timing script directly. Time + specific name

For example, Liezi is:

00 bin/sh 3 7 9 12 15 18 21 23 * / bin/sh / bak/shell/mysqlBak.sh

In this way, I will execute this script file at 23 o'clock every day, which means that I will execute this script file at 23 o'clock every day, so that I can backup the basic database.

Perform scheduled tasks:

$crontab-l

Restart the scheduled task if the service is not started

$systemctl restart crond

Now that the scheduled task has been started, the prerequisite for submitting remote repositories is to generate ssh key on the server and add it to the cloud, which is also mentioned above.

Initialize the git directory for the directory that needs to submit files, so that the bureau can constitute the task we need.

Of course, there may be some problems in the process, I have listed the relevant links below.

In this way, we can back up our database every morning and submit it to our remote warehouse, which is what we want.

I also said that the backup cycle depends on the amount of data in our project.

Each framework has its own backup mechanism. What I write here is a general backup mechanism that we have implemented.

After reading the above, have you mastered the method of how to back up and upload MySQL to git warehouse regularly in Linux? If you want to learn more skills or want to know more about it, you are welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.