Skip to content

Instantly share code, notes, and snippets.

@lvnilesh

lvnilesh/backup-restore.md

Last active February 15, 2024 17:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lvnilesh/8ad022ca9b3e1c4e4e759a42db65dda8 to your computer and use it in GitHub Desktop.
Save lvnilesh/8ad022ca9b3e1c4e4e759a42db65dda8 to your computer and use it in GitHub Desktop.
Download ZIP
backup restore
Raw
backup-restore.md 
docker-compose.yaml			/root/dockerfiles/step-by-step/3-docker-compose-cloudflared.yaml


A		$PWD/cloudflared	/root/dockerfiles/step-by-step/cloudflared.tar.gz

cd $PWD # also known as step-by-step folder
tar -czf cloudflared.tar.gz cloudflared/

B		/var/www/html/		/root/dockerfiles/step-by-step/wpbackup/wp_today.tar.gz

cd /var/www/
tar -czf wp_today.tar.gz html/
mv wp_today.tar.gz /wpbackup


C		/var/lib/mysql		/root/dockerfiles/step-by-step/dbbackup/WORDPRESS_MYSQLdump.sql.gz



Wordpress app

docker exec -it app bash
	apt update && apt install mariadb-client -y


gunzip -c WORDPRESS_MYSQLdump.sql.gz | mysql -h mysql -uusername -ppassword wordpress

gunzip -c WORDPRESS_MYSQLdump.sql.gz | mariadb -h mysql -uusername -ppassword wordpress

mariadb -h mysql -uusername -ppassword

cd /dbbackup
mariadb-dump -h mysql -uusername -ppassword wordpress --no-tablespaces | gzip > WORDPRESS_MYSQLdump.sql.gz


https://github.com/beacloudgenius/ghost-backup-restore

# restore

A		tar xzf cloudflared.tar.gz
B		tar xzf wp_today.tar.gz
C		gunzip -c WORDPRESS_MYSQLdump.sql.gz | mysql -h mysql -uusername -ppassword wordpress

gunzip -c WORDPRESS_MYSQLdump.sql.gz |

mysql -h mysql -uusername -ppassword wordpress
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment