Backup wordpress blog and backup wordpress database are very important routine tasks for webmasters who maintain wordpress blog or website. You need to backup your blog data and files regularly.
The WordPress database contains all your posts, every comment and every link you have on your blog. Unfortunate database corruption or erasure will wipe out your all these information. Backups always helps you to recover when disaster strikes.
Taking backup of your blog or website is not a complex process. In just few minutes you can take backup of your blog.
Related:
- Must Do Tips To Secure WordPress Blog and Site
- How to Create WordPress Thumbnail Based Post Archives
- Moving WordPress Blog To New Host : Move WordPress Blog in 7 Steps
Manual and Automated WordPress Backup process
The wordpress back up process can be either an automated process or manual process. There are many wordpress plugins available that will help you to automate the backup process. These plugins takes backups regularly. Most of the plugins once configured backup your site to some predefined locations like FTP sites , Amazon S3 or even email them to a specified address.
Few of the well know wordpress backup plugins are mentioned below,
- EZPZ One Click Backup
- BackupWordPress
- Automatic WordPress Backup
- WordPress DBManager
- WP-DB-Backup Plugin
There are many free tools that can be used to backup the wordpress blog. These manual process gives you total control on what you backup and where you keep your backup files.
Backup WordPress Manualy using FTP , SFTP tools, Schell scripts and PHPMyAdmin
If you are well versed in Shell scripts then you can backup your wordpress files including MySQL database using shell commands.
Using SSH Tools
SSH (Secure Shell) is a complete set of tools for remote administration of your website. It includes SFTP (Secure File Transfer Protocol). SSH offers increased security for clien server communication. On linux and othe Unix based OS you can use Graphical FTP clients such as KBear and gFTP.
Windows SSH Tools
- PuTTY – Download PuTTY
- Cygwin – Download Cygwin
Mac SSH Tools
- Fugu – Download Fugu
Using FTP and SFTP Tools
The File Transfer Protocol or FTP is the most widely used transfer protocol. The secure version of the protocol or SFTP (Secure File Transfer Protocol) is more reliable and secure and transfers your files and your password over a secured connection.
Windows FTP and SFTP tools
There are many good FTP (SFTP) tools available for windows.
- FileZilla
FileZilla is free, open source, cross-platform FTP software. Binaries are available for Windows, Linux, and Mac OS X. Filezilla supports FTP, SFTP, and FTPS (FTP over SSL/TLS)
Download FileZilla
- WinSCP
WinSCP (Windows Secure CoPy) is a free and open source SFTP and FTP client for Microsoft Windows. WinSCP allow you to sync with your website files to keep a mirror copy of the content on your server and local hard drive.
Download WinSCP
- Swish
Swish is a shell extension that allows Windows Explorer to manage files using SFTP.
Download Swish
- Cyberduck
Cyberduck is an open source FTP and SFTP, WebDAV, Cloud Files, Google Docs, and Amazon S3 client for Mac OS X and Windows
Download Cyberduck
Mac FTP and SFTP tools
- FileZilla is available for Mac.
- Cyberduck
Cyberduck is an open source FTP and SFTP, WebDAV, Cloud Files, Google Docs, and Amazon S3 client for Mac OS X and Windows
Backup WordPress DB using phpMyAdmin
phpMyAdmin is a tool (PHP script) meant for giving users the ability to interact with their MySQL databases.Almost all host control panels, such as cPanel and Plesk, have phpMyAdmin pre-installed, and you can start using them directly.
If it is not available in host control panel, yo can instal the phpMyAdmin plugin for wordpress. After installation you can manage it from the WordPress admin console.
Download WP-phpMyAdmin WordPress plugin
Alternatively you can download phpMyAdmin from here.
Once logged in into MySql using phpMyAdmin select the database you want to take backup. Then select the export tab as shown below. 
Select the file format you want. Ideally it should be “.SQL” format, since importing db backup in the form of .sql will be easier.
Then type the file name you want give to the backup. Click the Go button. see below.
Once imported you can save the db backup to any secure location
Before you go, subscribe to get latest technology articles right in your mailbox!.