March 15, 2005
A few days ago, I wrote about a simple method of backing up that is accessible to all bloggers but one that only saves the posts, and nothing more. I was challenged by Ruth’s question about having a short and easy way of having an offline copy of everything she has published and I remembered reading about the One Click Backup for 1.5 from Weblog Tools Collection.
This plugin requires the blogger to have ftp access to their root folder or they can have their blog hosts do the uploading for them. The backup tool creates copies of the database within the blog folder (under the wp-contents subdirectory) and names it according to the date of backup. A word of warning though: If you keep clicking on that backup tool and not keep track of the disk space the files use, you may just surprise yourself with a message from your web host saying you’ve just run out of space.
Download and unzip the file into your computer. Using an FTP client (again, I prefer WS_FTP), login to your account and create a folder called backup under the root/wp-content/ directory as shown below:
Right click on the folder and click PROPERTIES.
Under PROPERTIES, assign WRITE permissions to the backup folder by checking the write boxes under ‘owner,’ ‘group,’ and ‘world.’
Upload all the files except backuprestore.php and ReadMe.txt to the root/wp-admin folder.
Upload the backuprestore.php file to the root/wp-contents/plugin folder and ACTIVATE the plugin.
A new BACKUP/RESTORE tab will appear on the top menu alongside Options and Logout.
Upon clicking the BACKUP/RESTORE tab, you will be taken to a screen that looks like this:
BACKUP DATABASE – saves/backs up all data about your blog that is saved in the mysql database. This includes all your posts, comments, blog settings, including usernames and passwords to name a few.
BACKUP WORDPRESS FILES – saves/backs up WordPress install files, themes, images, css files, index.php, and other files except those mentioned in BACKUP DATABASE.
RESTORE YOUR DATABASE – please use sparingly and with the guidance of your web host if you are not sure about what you are doing! This tool restores posts/comments and settings stored in the .sql files that you back up on a regular basis in the unfortunate occasion that you lose your blog data.
To use the BACKUP DATABASE, all you need to do is to click the button. A confirmation will appear on the upper left portion of the screen and a download link right below it.
Right click on the ‘Download the new Backup Sql File’ link, choose ‘Save As’ and save the file to your local drive.
Using the BACKUP WORDPRESS FILES is just as straightforward, click the button and the confirmation will appear on top right, next to the download link. The backup file is in TAR format (.tar.gz) which is the Unix standard for archiving but is compatible with Windows systems. You can use Winzip to decompress the file.
To RESTORE YOUR DATABASE (and this is assuming you are using this only because you absolutely have to!) manually type in the .sql file name of the database and click the Restore Database button. A confirmation appears on the upper part of the screen with a link to view the site. Check to see that all your posts/comments were restored correctly.
To my hostees: This tool need not be installed on your blogs because I do a manual backup of your databases on a regular basis. If you feel you should have it, send me a written request with reasons why this should be installed on your blog.