How to back up MYSQL database in mysqldump

This article will explain in detail how to back up the MYSQL database in mysqldump. The content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

1. Backup the contents of the script

[david_yeung@localhost ~] $cat fast_backup

#! / bin/sh

#

# Created by david yeung.

#

# 20080707.

#

# Backup & apos;s full data.

#

DBNAME=$1

BACKUPDIR=/home/david_yeung/backup_new

USERNAME=backup_user

PASSWD=123456

TARNAME= "$BACKUPDIR" / backup "$1" `date & apos;+%Y%m%d' `

# Add your own database name here.

Case "$1" in

My_site)

*) exit

Esac

# Get all the tables' name.

NUM= `/ usr/local/mysql/bin/mysql-u$USERNAME-p$PASSWD-s-vv-e "show tables"-D $DBNAME | wc-l`

HEADNUM= `expr ${NUM}-3`

TAILNUM= `expr ${NUM}-7`

ARR1= `/ usr/local/mysql/bin/mysql-u$USERNAME-p$PASSWD-s-vv-e "show tables"-D $DBNAME | head-n "$HEADNUM" | tail-n "$TAILNUM"`

ARR2= ($ARR1)

ITunes 0

While ["$I"-lt "${# ARR2 [@]}"]

Do

TmpFileName=$ {ARR2 [$I]}

# The real dump process.

/ usr/local/mysql/bin/mysqldump-u$USERNAME-p "$PASSWD"$DBNAME"$tmpFileName" > > "$TARNAME"

Let "iTunes +"

Done

2. Because we have been using stored procedures, we have to back them up separately.

[david_yeung@localhost ~] $cat fast_sp

#! / bin/sh

# Created by david yeung 20080122.

#

# Backup site's routine.

TARNAME=/home/david_yeung/backup_new/spBackup "$1" `date & apos;+%Y%m%d' `

/ usr/local/mysql/bin/mysqldump-ubackup_user-p123456-n-t-d-R my_site > "$TARNAME"

3. Throw it into the planned task and leave it alone.

[root@localhost backup_new] # crontab-l

0 01 * / home/david_yeung/fast_backup my_site

0 0 * 5 / home/david_yeung/fast_sp

On how to back up the MYSQL database in mysqldump to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.