On condition that WordPress is the most well-liked running a blog software program on this planet, many customers anticipate there to be a simple, backup system constructed into it. Sadly, there isn’t, so customers who need to backup a WordPress web site, must do it manually.
SQL Database
A vital facet of backing up any WordPress set up on Linux is the SQL database. Fortunately, backing up SQL on Linux could be very simple. To create a backup of the WordPress database, we’ll be utilizing “sqldump”. It’s a easy software, that, if used accurately can be utilized to simply export the contents SQL databases on Linux.
To export your WordPress database, open up a terminal and acquire a root shell with su (or sudo -s, if the basis account is disabled).
su -
Now that the shell has full root permissions, create a brand new backup folder, together with the SQL and set up information sub-directories.
mkdir -p /root/wp-backup mkdir -p /root/wp-backup/sql mkdir -p /root/wp-backup/wp-installation-files
Utilizing the CD command, transfer the terminal to the sql sub-folder inside the wp-backup listing.
cd /root/wp-backup/sql
Subsequent, export the WP database to an SQL file on the Linux server. Take into account that the sqldump command won’t work in case you have no idea the right database particulars (appropriate DB title, person, and password). When you adopted the directions on the best way to set up WordPress on Ubuntu server, the WP SQL database title is “wordpressdb,” and the person is “ubuntuwordpress”.
mysqldump -u username -p databasename > db.wp__backup.sql
Run the ls command to substantiate that the brand new wp_backup.sql is within the /root/wp-backup/sql folder.
ls -a
When you may verify the SQL file is there, the WordPress SQL backup is full!
Again Up WordPress Set up
With the WordPress SQL database taken care of, the following step within the backup course of is to protect the WordPress set up itself. Backing up the set up begins by utilizing the cp command to maneuver all information from /var/www/html to /root/wp-backup/wp-installation-files.
Within the terminal, use cp to create an entire copy of your present WordPress set up.
cp -rp /var/www/html/* /root/wp-backup/wp-installation-files/
The copy command could take a little bit of time to finish, relying on how giant your WordPress set up is. When the cp command finishes operating, cd into the backup listing and use the ls command to substantiate the information are there. When you discover any information lacking, it could be a good suggestion to re-run the command.
cd /root/wp-backup/wp-installation-files/ ls -a
Compressing The Backup
All vital WordPress information are in a backup location. The subsequent step within the backup course of is to compress every part right into a Tar archive. Compressing information could seem tedious, however it’s price it because it’ll be a lot simpler to archive and transport the backup later. To create a brand new Tar archive of the backup, run the next command:
tar -zcvpf wordpress-backup.tar.gz /root/wp-backup
As soon as the compression winds up, at this level the backup is able to transport. Be happy to add the backup, however be warned that it’s unencrypted. Leaving the backup unencrypted is a really dangerous concept, particularly because it signifies that anybody might look via the SQL database file, web site construction, and so forth.
Encrypting the WP backup archive is straightforward, and it begins by putting in GnuPG in your server. Within the package deal supervisor, seek for “gpg” and set up it. Then, use the next command to encrypt the backup archive.
gpg -c wordpress-backup.tar.gz
Gpg asks for a password in the course of the encryption course of. Enter a memorable password within the terminal, and press the enter key on the keyboard.
When the encryption course of finishes, the output file is wordpress-backup.tar.gz.gpg. That is the safe type of the backup, and the one file you’ll want. DO NOT KEEP THE UNENCRYPTED ARCHIVE!
Restore The Backup
Want to revive the backup? Do the next.
First, acquire a root shell with su or sudo -s.
su -
or
sudo -s
Then, navigate to /root and paste the wordpress-backup.tar.gz.gpg file there.
Decrypt the encrypted backup:
gpg wordpress-backup.tar.gz.gpg
Extract the backup archive with Tar.
tar -xvpf wordpress-backup.tar.gz
Subsequent, CD into the SQL folder and import the database.
cd /root/wp-backup/sql
mysqldump -u username -p databasename < db.wp__backup.sql
Importing the SQL database will immediately re-import all weblog knowledge, person info, posts and and so forth. After that, all that’s left is to maneuver the WordPress system information within the appropriate place.
Utilizing the cp command, transfer the information into place.
cp -rp /root/wp-backup/* /var/www/html
Lastly, take away the archive information and clear out the /root folder.
rm wordpress-backup.tar.gz rm wordpress-backup.tar.gz.gpg rm -rf wordpress-backup
