{"id":186,"date":"2023-04-11T14:16:56","date_gmt":"2023-04-11T07:16:56","guid":{"rendered":"https:\/\/blog.gormedosmotr.ru\/?page_id=186"},"modified":"2023-04-11T14:16:56","modified_gmt":"2023-04-11T07:16:56","slug":"%d0%a1%d0%ba%d1%80%d0%b8%d0%bf%d1%82%d1%8b","status":"publish","type":"page","link":"https:\/\/blog.gormedosmotr.ru\/?page_id=186","title":{"rendered":"\u0421\u043a\u0440\u0438\u043f\u0442\u044b"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>#!\/bin\/bash\r\n \r\n# your backups will use these filenames.\r\ndb_backup_name=\"wp-db-backup-\"`date \"+%Y-%m-%d\"`\".sql.gz\"\r\nwpfiles_backup_name=\"wp-files-backup-\"`date \"+%Y-%m-%d\"`\".tar.gz\"\r\n\r\n## 1: database connection info. You can get these details from your wp-config file.\r\ndb_name=\"database_name\"\r\ndb_username=\"database_username\"\r\ndb_password=\"database_password\"\r\n\r\n## 2: Path to your WordPress Upload and Theme directories. Replace \/home\/username\/ with path to your home directory.\r\nwp_upload_folder=\"\/home\/username\/public_html\/wp-content\/themes\"\r\nwp_theme_folder=\"\/home\/username\/public_html\/wp-content\/uploads\"\r\n \r\n## 3: Path to your backup folder. Replace \/home\/username\/ with path to your home directory.\r\nbackup_folder_path=\"\/home\/username\/wp_backup\"\r\n\r\n# backup MYSQL database, gzip it and send to backup folder.\r\nmysqldump --opt -u$db_username -p$db_password $db_name | gzip > $backup_folder_path\/$db_backup_name\r\n\r\n# create a tarball of the wordpress files, gzip it and send to backup folder.\r\ntar -czf $backup_folder_path\/$wpfiles_backup_name $wp_upload_folder $wp_theme_folder\r\n\r\n# delete all but 5 recent wordpress database back-ups (files having .sql.gz extension) in backup folder.\r\nfind $backup_folder_path -maxdepth 1 -name \"*.sql.gz\" -type f | xargs -x ls -t | awk 'NR>5' | xargs -L1 rm\r\n\r\n# delete all but 5 recent wordpress files back-ups (files having .tar.gz extension) in backup folder.\r\nfind $backup_folder_path -maxdepth 1 -name \"*.tar.gz\" -type f | xargs -x ls -t | awk 'NR>5' | xargs -L1 rm\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-186","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blog.gormedosmotr.ru\/index.php?rest_route=\/wp\/v2\/pages\/186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.gormedosmotr.ru\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blog.gormedosmotr.ru\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blog.gormedosmotr.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.gormedosmotr.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=186"}],"version-history":[{"count":1,"href":"https:\/\/blog.gormedosmotr.ru\/index.php?rest_route=\/wp\/v2\/pages\/186\/revisions"}],"predecessor-version":[{"id":188,"href":"https:\/\/blog.gormedosmotr.ru\/index.php?rest_route=\/wp\/v2\/pages\/186\/revisions\/188"}],"wp:attachment":[{"href":"https:\/\/blog.gormedosmotr.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}