Its the same with poker.


blogging HQ by Poppy Lane





A successful blog takes time and effort to create and manage. Bloggers spend a lot of their free time publishing posts, refining their Wordpress themes and promoting the blog content. It does not matter if the blog is personal or a paid blog, the importance and the sentiment of it is the same. That is why backing up work is highly recommended, losing months or years of hard work would be a shame. Backing up a blog is easy and should be done on regular basis.

How do you backup a Wordpress blog?

All Wordpress blogs store the information into what is called MySQL database. MySQL database makes it easy to store Wordpress blog information, as well as export and backup MySQL database.

Here are three available methods to backup Wordpress blogs;

Backing up through FTP

File Transfer Protocol (FTP) is an easy way to backup web hosting files. It is also easy to backup Wordpress files and blogs through FTP as well. Simply login to your FTP account (the address of the web hosting account should be ftp.enteryourdomainname.com) and use the given username and password for FTP/Cpanel access. The login for Cpanel/FTP is provided by the web hosting company. It should be different from the actual Wordpress Admin login.

Once logged into FTP, click on public_html folder. The public_html folder is where all public files are uploaded. It is the core of the web hosting account and Wordpress blog. To backup Wordpress files through FTP, you can transfer the entire public_html folder to a local computer on your Desktop.

For example, create a folder on the Desktop called My Website. Then right click on public_html folder inside of the FTP client. Select transfer to Desktop - My Website folder.

This process will take several minutes, depending on the size of the Wordpress blog and the web hosting account, it may take several hours to fully transfer every single file.

Backing up Wordpress files through FTP will backup the Wordpress template, Wordpress installation and setup, but not the MySQL database. The blog posts are stored inside of the MySQL database, which should be backed up separately. However, the files should be backed up through FTP in order to backup Wordpress templates and all the configuration, plus design changes made.

Backing up Wordpress MySQL database

The easiest way to backup MySQL database is through Cpanel. Login to web hosting account's Cpanel (it should be www.enteryourdomainname.com/cpanel) and use the Cpanel login provided by the web hosting company. Usually Cpanel and FTP logins are the same.

Click on the Backups icon in Cpanel

On the left hand side, it will list Download a MySQL Database Backup

Below that, is a list of all Wordpress MySQL databases and any other databases created for the account

Right click on the database name, most likely cpanelusername_wrdp1

Select Save As

Choose where to save the file, such as Desktop - My Website

The MySQL Database should save as a .gz file. You will not be able to open up this file on a local computer, it is a backup of the file that has to be restored in Cpanel. Do not attempt to open or alter the .gz file, as it may corrupt the backup and ruin the saved Wordpress blog database.

Backing up Wordpress MySQL through phpMyAdmin

Another easy way to backup Wordpress MySQL database is through phpMyAdmin. PhpMyAdmin is a PHP and MySQL database tool provided through Cpanel.

Login to Cpanel as instructed before

Click on phpMyAdmin icon

A new window will open up, showing phpMyAdmin and listing MySQL Wordpress databases. It will also list any additional MySQL databases created for the website.

Click on the Wordpress MySQL database, most likely named _wrdp1

Click on the Export tab on the right hand menu

Under Export Select All / Unselect All tab click on Select All option

Once all MySQL tables are selected, click on SQL below

Scroll down until you see:

Save as file File name template (1): ( remember template )

Compression: None "zipped" "gzipped"

Choose the Save as file option, the option None is by default and can be left as selected

Click on the option GO

This should open up your Desktop. Save the Wordpress MySQL database backup wherever you choose on the Desktop, such as Desktop - My Website

This will backup the MySQL Wordpress database, which can be restored using phpMyAdmin. To restore a Wordpress MySQL database, use the Import option provided.

Backup Wordpress files using Cpanel

Another useful tool provided by Cpanel is the backup option, to backup hosting files and backup blog files. To backup a blog through Cpanel, click on the Backup icon again.

Under Partial Backups

Click on the option to: Download a Home Directory Backup - Home Directory

The Home Directory refers to public_html folder. It will backup all hosting files, website files and Wordpress blog files inside of public_html.

The tar.gz can be saved anywhere on your Desktop, and it will give you a copy of Wordpress blog files. This does not backup the Wordpress MySQL database. To backup Wordpress files, use the methods previously provided.



Source article: Blogger Pro and Journal and Journal News and Online Blogger and Using Blogger
blog

0 ความคิดเห็น:

แสดงความคิดเห็น

 

Copyright © 2009 Air Miles Reward