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:

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,

  1. EZPZ One Click Backup
  2. BackupWordPress
  3. Automatic WordPress Backup
  4. WordPress DBManager
  5. 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

  1. PuTTY Download PuTTY
  2. Cygwin Download Cygwin

Mac SSH Tools

  1. 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.

  • FileZillaFileZilla_FTP client for windows , linux and mac

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

  • Cyberduckcyberduck ftp client for windows and mac

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. phpmyadmin-wordpress-db-backupSelect 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.phpmyadmin-easy wordpress-db-backup
Once imported you can save the db backup to any secure location

Binu GeorgeWordPress Tipsbackup for wordpress,backup mysql,backup wordpress blog,backup wordpress database,backup wordpress plugin,blog backup,how backup wordpress,how-to guides,productivityBackup 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...Tech-Knowledge that helps