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

This article introduces the knowledge of "how to back up Mysql to the Windows sharing path". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

The following is a simple implementation of how to back up MySQL's database to a remote Windows server.

First, you need to create a share path above Windows (IP:192.168.1.5): create a directory named HugoShare under disk D, click the Share tab in the properties of the HugoShare directory, find Everyone in the drop-down box, then click Add to add to the shared user group, select Read/Write in permissions, and Share again. Find the user Everyone in the Securiy tab to see if his permission to the directory is Full, and if not edit it, set it to Full for convenience. At this point, your\ 192.168.1.5\ HugoShare should be accessible to anyone.

Test whether the above shared directory can be mounted in the MySQL server

First create a directory, mkdir / mnt/HugoShare/, and then install the cifs tool. When the apt-get install cifs-utils installation is complete, enter the following command mount.cifs / / 192.168.1.5/HugoShare / mnt/HugoShare-o user= "hugo", pass= "woaini". If the mount is successful, it will return 0tech echo $? 0 will be displayed. You can also mount-l | grep "/ mnt/HugoShare" to see if it is actually mounted.

Looks like the preparation is done, so let's write a script.

#! / bin/bash

# mysql database backup script

# Database configuration

USERNAME=root

PASSWORD= "woaini"

DATABASE= "hugo"

HOSTNAME= "localhost"

# backup option configuration

BACKUP_SERVER= "/ / 192.168.1.5/HugoShare/"

BACKUP_SERVER_OPTIONS= "user=zed,pass=woaini"

BACKUP_DIR=/mnt/HugoShare

LOGFILE=$BACKUP_DIR/backup.log

DATE= `date'+% Y% m% dmurf% H% M``

DUMPFILE=$DATE.bak.sql

ARCHIVE=$DATE.bak.sql.tgz

OPTIONS= "- h$HOSTNAME-u$USERNAME-p$PASSWORD $DATABASE"

# check whether the backup directory exists

If [!-d $BACKUP_DIR]

Then

Mkdir-p $BACKUP_DIR

Fi

# check whether the windows directory is mounted

Mount-l | grep $BACKUP_DIR > / dev/null 2 > & 1

If [$? = = 1]

Then

Mount.cifs $BACKUP_SERVER $BACKUP_DIR-o $BACKUP_SERVER_OPTIONS

Echo "=" > > $LOGFILE

Echo "Windows netshare mounted:$BACKUP_SERVER" > > $LOGFILE

Fi

# Log feature

Echo "" > > $LOGFILE

Echo "=" > > $LOGFILE

Echo "BACKUP DATE:" $(date + "% y-%m-%d% H:%M:%S") > > $LOGFILE

Echo "=" > > $LOGFILE

# backup and archive

Cd $BACKUP_DIR

Mysqldump $OPTIONS > $DUMPFILE

If [$? = = 0]

Then

Tar czvf $ARCHIVE $DUMPFILE > > $LOGFILE 2 > & 1

Echo "[$ARCHIVE] backup successful!" > > $LOGFILE

Rm-f $DUMPFILE

Else

Echo "Backup failed" > > $LOGFILE

Fi

The script adds execution permissions chmod 777 mysql_dump.sh to see how it works.

Areas where improvements can be made:

The next job is to set up security for the Windows shared directory and specify user access. The second is to modify the script to specify whether the entire database to be backed up or a single table to be backed up, you can add scheduled tasks in crond, and set up log polling. A better way is to set up the ability to log forward messages.

This is the end of the content of "how Mysql is backed up to the Windows share path". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.