![\"\"](\"http:\/\/www.zoyinc.com\/wp-content\/uploads\/2019\/06\/BackupAndRestoreWordPress02.jpg\")
I run WordPress on Apache 2.2 on RedHat. A WordPress instance, is just a bunch of PHP files, various image files and uploaded files and a database – that’s pretty much it. So to backup and restore you need to back up one directory tree and a DB.<\/p>\n
This post details what I did to go from a backup of WordPress on one server to a completely new server. The old host was PHP 5.4 and Apache httpd 2.4.4-3. The new server is PHP 7.2 and Apache httpd 2.4.6-88. The original host is Fedora 18, August 2013 and the new one is CentOS 7 June 2019 – so six years difference.<\/p>\n
When I am doing this restore I am doing it as root because if I really screw it up it’s only a VM and I can roll back. Clearly on an important server you would do as much as possible as a non-root user.<\/p>\n
Backup shell script for folders:daily_backup.sh<\/a> I have two backup scripts that run on my servers, one for backing up the folders “daily_backup.sh” and another for backing up the DB “mysql_dumps.sh” – both can be download for you to review – see “Resources” section of this post.<\/p>\n The folder backup includes backing up the wordpress folder “\/srv\/wordpress” and the apache config “\/etc\/httpd”. The other folders in the example script, like “\/svr\/conf” are non-WordPress folders.<\/p>\n The MySQL backup simply backs up the database by running:<\/p>\n Then the dump is zipped up.<\/p>\n First thing to do is the DB. I have copied the DB dump to:<\/p>\n So open a terminal and run the following to extract the dump file:<\/p>\n Then restore it by first logging in to the DB as root<\/p>\n Then run the following:<\/p>\n Now that your DB is setup run the following to restore the DB dump:<\/p>\n In my case the backup script I run creates a structure like:<\/p>\n To be safe we will extract to a temp location. So the file is in “\/svr\/backup” so I run:<\/p>\n You need to copy the folder to where you are putting the files, so it is most likely different for you but for me:<\/p>\n Obvious the last part is ensuring apache has access to the folders. Because it was a tar copy the permissions will already be correct.<\/p>\n Firstly we need to fix the DB details etc. These are contained in the php config file, in my case:<\/p>\n Edit this file and change any DB details as required.<\/p>\n Next on the list is the Apache config file. One of the side tasks things my backup script does is to backup the Apache folders under “\/etc\/httpd” which brings httpd.conf along with the ssl.conf and any certificates.<\/p>\n When I upgrade Apache or JBoss or anything like that I find the best thing is do a compare between the out-of-the-box for the new instance against the original config – using a tool like BeyondCompare or kdiff. In this case the versions are both on Apache 2.4.x and comparing the configs I can still keep using the old one, so great.<\/p>\n So just copy of the following to the new Apache folder:<\/p>\n Its really important to have everything in the same directories as they were in the old server otherwise you will need to carefully go over all the configs to see if there is anything you need to change.<\/p>\n Also don’t simply take all files across because that won’t work either.<\/p>\n Simply run:<\/p>\n To start Apache and you are done<\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n","protected":false},"excerpt":{"rendered":" I run WordPress on Apache 2.2 on RedHat. A WordPress instance, is just a bunch of PHP files, various image files and uploaded files and a database – that’s pretty much it. So to backup and restore you need to back up one directory tree and a DB. This post details what I did to […]<\/p>\n","protected":false},"author":2,"featured_media":3696,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[537,536,10],"tags":[327,542,540,235,539,538,541,497,297],"class_list":["post-3675","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mariadb","category-mysql","category-wordpress","tag-backup","tag-export","tag-file-system","tag-import","tag-mariadb","tag-mysql","tag-recovery","tag-restore","tag-wordpress"],"_links":{"self":[{"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=\/wp\/v2\/posts\/3675","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3675"}],"version-history":[{"count":14,"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=\/wp\/v2\/posts\/3675\/revisions"}],"predecessor-version":[{"id":4758,"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=\/wp\/v2\/posts\/3675\/revisions\/4758"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=\/wp\/v2\/media\/3696"}],"wp:attachment":[{"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3675"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.zoyinc.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nBackup MySQL databases: mysql_dumps.sh.v2<\/a><\/p>\nBackup<\/h2>\n
mysqldump -f -u${DBUSER[$i]} -p${DBPASSWD[$i]} ${DBNAME[$i]} > $ARCHIVE_NAME<\/pre>\nRestoring the backups<\/h2>\n
Restoring the DB<\/h3>\n
\/srv\/backup\/MySQL_DB_Dump_#0_wordp_VMValiant.gz<\/pre>\n
gunzip -cd MySQL_DB_Dump_#0_wordp_VMValiant.gz > MySQL_DB_Dump_#0_wordp_VMValiant.dmp<\/pre>\n
mysql -u root -p<\/pre>\n
drop database wordpress; -- Drop the database, if it exists and is called 'wordpress'\r\ndrop user wordp; -- Delete the user 'wordp'\r\ncreate user wordp identified by '<my secret password>'; -- Create DB user\r\ncreate database wordpress; -- Create the DB called 'wordpress'\r\ngrant all privileges on wordpress.* to 'wordp'@'%'; -- Give the user full rights to the DB from any location<\/pre>\n
mysql -f -u wordp -p wordpress< \/srv\/backup\/MySQL_DB_Dump_#0_wordp_VMValiant.dmp<\/pre>\n
Restoring the file system<\/h3>\n
![\"\"](\"http:\/\/www.zoyinc.com\/wp-content\/uploads\/2019\/06\/BackupAndRestoreWordPress01.jpg\")
<\/p>\ncd \/srv\/backup\r\ntar xvzf WordPress_WWW_Dir_on_VMValiant.tar.gz<\/pre>\n
mkdir -p \/srv\/www\r\ncd \/srv\/backup\/srv\/www\r\ncp -r wordpress \/srv\/www\r\ncd \/srv\r\nchown -R apache.apache www<\/pre>\n
Fix the configs<\/h3>\n
\/srv\/www\/wordpress\/wp-config.php<\/pre>\n
etc\\httpd\\conf.d\\zoyinc.com.pem\r\netc\\httpd\\conf.d\\zoyinc.com.cacert.pem\r\netc\\httpd\\conf.d\\zoyinc.com.v2.key\r\netc\\httpd\\conf.d\\zoyinc.com.v2.crt\r\netc\\httpd\\conf.d\\ssl.conf\r\netc\\httpd\\conf\\httpd.conf<\/pre>\n
systemctl stop httpd.service\r\ncd \/var\/tmp\r\ntar xvzf HTTPD_Conf_Dir_on_VMValiant.tar.gz\r\n\r\nmv \/etc\/httpd\/conf.d\/zoyinc.com.pem \/etc\/httpd\/conf.d\/zoyinc.com.pem.ootb\r\nmv \/etc\/httpd\/conf.d\/zoyinc.com.cacert.pem \/etc\/httpd\/conf.d\/zoyinc.com.cacert.pem.ootb\r\nmv \/etc\/httpd\/conf.d\/zoyinc.com.v2.key \/etc\/httpd\/conf.d\/zoyinc.com.v2.key.ootb\r\nmv \/etc\/httpd\/conf.d\/zoyinc.com.v2.crt \/etc\/httpd\/conf.d\/zoyinc.com.v2.crt.ootb\r\nmv \/etc\/httpd\/conf.d\/ssl.conf \/etc\/httpd\/conf.d\/ssl.conf.ootb\r\nmv \/etc\/httpd\/conf\/httpd.conf\u00a0 \/etc\/httpd\/conf\/httpd.conf.ootb\r\n\r\ncp etc\/httpd\/conf.d\/zoyinc.com.pem \/etc\/httpd\/conf.d\/zoyinc.com.pem\r\ncp etc\/httpd\/conf.d\/zoyinc.com.cacert.pem \/etc\/httpd\/conf.d\/zoyinc.com.cacert.pem\r\ncp etc\/httpd\/conf.d\/zoyinc.com.v2.key \/etc\/httpd\/conf.d\/zoyinc.com.v2.key\r\ncp etc\/httpd\/conf.d\/zoyinc.com.v2.crt \/etc\/httpd\/conf.d\/zoyinc.com.v2.crt\r\ncp etc\/httpd\/conf.d\/ssl.conf \/etc\/httpd\/conf.d\/ssl.conf\r\ncp etc\/httpd\/conf\/httpd.conf\u00a0 \/etc\/httpd\/conf\/httpd.conf<\/pre>\n
Restart Apache<\/h3>\n
systemctl start httpd.service<\/pre>\n