Differences

This shows you the differences between two versions of the page.

--- computing:linux:mysql_backup [2016/10/29 16:28]
gcooper
+++ computing:linux:mysql_backup [2018/10/01 14:33] (current)
gcooper
@@ Line 1: / Line 1: @@
 ====== MySQL and PostgreSQL Backup Script ======
-You can modify this script to only backup MySQL or only PostgreSQL.
+===== Reset Forgotten PostgreSQL Password =====
+If necessary, as ''root'':
+<file>
+sudo su postgres && psql
+ALTER USER postgres with password 'newpostgresuserpassword';
+\q
+exit
+</file>
+===== PostgreSQL Password =====
+For scripts that run as ''root'':
+<file>
+touch ~/.pgpass && chmod 0600 ~/.pgpass && vim ~/.pgpass
+</file>
+and add:
+<file>
+#server:port:database:username:password
+localhost:*:*:postgres:yourpostgresuserpass
+</file>
 ===== db_backup.sh =====
 :!: You must edit the script, at least for the MySQL 'root' password.
+You can easily modify this script to only backup MySQL or only PostgreSQL.  However, the script checks to see if either PostgreSQL or MySQL database is running, then only backs up if they are.
 <file>
@@ Line 18: / Line 47: @@
 # Mysql password
-MYSQLPW="bad1egg!!"
+MYSQLPW="password"
 # Mysql username
 MYSQLUSER="root"
@@ Line 98: / Line 127: @@
 exit
 </file>
+====== Restore A MySQL Backup ======
+One-liner to restore a gzipped MySQL backup:
+<file>
+gunzip < mysql-database-name.sql.gz | mysql -p -h localhost mysql-database-name
+</file>
+:!: You will need to enter the database password of the database on 'localhost' being restored to.

Virtual Architects Support Wiki