Различия

Показаны различия между двумя версиями страницы.

--- tasks:restore [09.02.2021 08:56] – viacheslav
+++ tasks:restore [30.07.2024 19:21] (текущий) – внешнее изменение 127.0.0.1
@@ Строка 1: / Строка 1: @@
+FIXME
+<code bash>
+sudo apt-get install davfs2 -y
+mkdir /media/webdav
+mkdir ~/restore
+mount -t davfs https://remotesite.com/remote.php/webdav/backup /media/webdav
+</code>
+Найти РК файлов начиная с последней полной и скопировать их
+<code bash>
+find /media/webdav -name '*files*' -mtime -$(( ( $(date +'%s') - $(date --date 'last Saturday' +'%s') )/60/60/24 )) -exec cp -p {} ~/restore \;
+</code>
+Найти РК баз новее 24 часов и скопировать их
+<code bash>
+find /media/webdav -name '*sql*' -mtime -1 -exec cp -p {} ~/restore \;
+</code>
+http://stackoverflow.com/questions/4946785/how-to-find-the-difference-in-days-between-two-dates
+http://stackoverflow.com/questions/5241625/find-and-copy-files
+http://stackoverflow.com/questions/9203747/how-do-i-get-the-bash-date-script-to-return-a-day-of-the-week-relative-to-a-non
+http://stackoverflow.com/questions/1015678/linux-most-recent-file-in-a-directory
+<code bash>
+for encrypted in ~/restore/*.aes ; do [ -f $encrypted ] && openssl enc -d -aes-256-cbc -in $encrypted -out $encrypted.dec -k your_password ; done
+</code>
+http://scunster.co.uk/?p=1116
+https://wiki.openssl.org/index.php/Command_Line_Utilities
+<code bash>
+history -c && history -w
+</code>
+<code bash>
+for f in *.gz.aes.dec; do mv ./"$f" "${f%gz.aes.dec}gz"; done
+</code>
+https://ss64.com/bash/mv.html
+https://ss64.com/bash/rename.html
+http://ashep.org/2010/osnovy-bash-cikly/
+<code bash>
+for f in ~/restore/*files*.gz ; do [ -f $f ] &&  tar -xzf $f -C / ; done
+</code>
+Restore DBs:
+<code bash>
+gzip -d ~/restore/*.sql.gz
+mysql -u root -p wordpress < ~/restore/*wordpress*.sql
+chown -R www-data:www-data /var/www/html
+mysqladmin -u root -p'abc' password '123456'
+</code>
+https://www.cyberciti.biz/faq/mysql-change-root-password/
+https://codex.wordpress.org/Restoring_Your_Database_From_Backup