linux mysql database backup

Shadow answered on May 7, 2020 Popularity 9/10 Helpfulness 4/10

answer linux mysql database backup

related how to backup mysql database linux

related mysql backup database command line

linux mysql database backup

Comment

# (1) set up all the mysqldump variables
DATE=`date +"%d_%b_%Y_%H%M"`
SQLFILE=/backup/db_backup_megaimkon_prod_${DATE}.sql
DATABASE=name
USER=username
PASSWORD='passsword'

# (2) in case you run this more than once a day,
# remove the previous version of the file
unalias rm     2> /dev/null
rm ${SQLFILE}     2> /dev/null
rm ${SQLFILE}.gz  2> /dev/null

# (3) do the mysql database backup (dump)
mysqldump -u ${USER} -p${PASSWORD} ${DATABASE}|gzip > ${SQLFILE}.gz

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: backup database database-dump linux mysql sql

Link to this answer
Share Copy Link

Contributed on Nov 29 2022

Shadow

0 Answers Avg Quality 2/10

Closely Related Answers

how to backup mysql database linux

Comment

mysqldump -u username -p databasename > database_backup.sql

Popularity 10/10 Helpfulness 9/10 Language sql

Source: Grepper

Tags: backup ba

Link to this answer
Share Copy Link

Contributed on Sep 27 2021

guruwalker

0 Answers Avg Quality 2/10

mysql backup database command line

Comment

mysqldump database_name > database_name.sql

Popularity 10/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: command-line command-li

Link to this answer
Share Copy Link

Contributed on May 07 2020

Friendly Hawk

0 Answers Avg Quality 2/10

linux mysql database backup

Contents

More Related Answers

linux mysql database backup

Closely Related Answers

how to backup mysql database linux

mysql backup database command line

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.