Here’s a quick how to:<\/p>\n
1. Tar up the directory: 2. Dump the database. I personally use extended-insert set to false because I often have to read the SQL.<\/p>\n Here is how to restore from backup:<\/p>\n Be sure to replace user_name, example.com and database_name with the appropriate values for your system.<\/p>\n I hope this helps.<\/p>\n","protected":false},"excerpt":{"rendered":" Here’s a quick how to: 1. Tar up the directory: tar cvf WordPress.tar wordpress\/. bzip2 WordPress.tar 2. Dump the database. mysqldump –user user_name –password –host example.com –extended-insert=FALSE database_name > database_name.sql I personally use extended-insert set to false because I often have to read the SQL. Here is how to restore from backup: tar zxvf WordPress.tar.bz […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[312,4,315,33,122],"tags":[370,86,369,395],"class_list":["post-1300","post","type-post","status-publish","format-standard","hentry","category-databases","category-how-to","category-mysql-databases","category-webapps","category-wordpress","tag-backup","tag-mysql","tag-mysqldump","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/posts\/1300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/comments?post=1300"}],"version-history":[{"count":0,"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/posts\/1300\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/media?parent=1300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/categories?post=1300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.codebelay.com\/blog\/wp-json\/wp\/v2\/tags?post=1300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\n
\ntar cvf WordPress.tar wordpress\/.
\nbzip2 WordPress.tar
\n<\/code><\/p>\n
\n
\nmysqldump --user user_name --password --host example.com --extended-insert=FALSE database_name > database_name.sql
\n<\/code><\/p>\n
\ntar zxvf WordPress.tar.bz
\nmysql --user user_name -p -hexample.com database_name < database_name.sql
\n<\/code><\/p>\n