User Tools
computing:linux:mysql_backup
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
computing:linux:mysql_backup [2016/10/29 16:33] gcooper |
computing:linux:mysql_backup [2018/10/01 14:33] (current) gcooper |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== MySQL and PostgreSQL Backup Script ====== | ====== MySQL and PostgreSQL Backup Script ====== | ||
| - | touch ~/.pgpass | + | ===== Reset Forgotten PostgreSQL Password ===== |
| - | $ chmod 0600 ~/.pgpass | + | |
| + | If necessary, as '' | ||
| + | < | ||
| + | sudo su postgres && psql | ||
| + | |||
| + | ALTER USER postgres with password ' | ||
| + | |||
| + | \q | ||
| + | |||
| + | exit | ||
| + | </ | ||
| + | |||
| + | ===== PostgreSQL Password ===== | ||
| + | |||
| + | For scripts that run as '' | ||
| + | |||
| + | < | ||
| + | touch ~/.pgpass && chmod 0600 ~/.pgpass && vim ~/.pgpass | ||
| + | </ | ||
| + | |||
| + | and add: | ||
| + | |||
| + | < | ||
| + | # | ||
| + | localhost: | ||
| + | </ | ||
| ===== db_backup.sh ===== | ===== db_backup.sh ===== | ||
| Line 23: | Line 47: | ||
| # Mysql password | # Mysql password | ||
| - | MYSQLPW=" | + | MYSQLPW=" |
| # Mysql username | # Mysql username | ||
| MYSQLUSER=" | MYSQLUSER=" | ||
| Line 103: | Line 127: | ||
| exit | exit | ||
| </ | </ | ||
| + | |||
| + | ====== Restore A MySQL Backup ====== | ||
| + | |||
| + | One-liner to restore a gzipped MySQL backup: | ||
| + | |||
| + | < | ||
| + | gunzip < mysql-database-name.sql.gz | mysql -p -h localhost mysql-database-name | ||
| + | </ | ||
| + | |||
| + | :!: You will need to enter the database password of the database on ' | ||
computing/linux/mysql_backup.1477780425.txt.gz · Last modified: 2016/10/29 16:33 by gcooper
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
