How to restore your WordPress database

Yesterday I showed you how to backup your WordPress database. Today I’ll show you how to restore your WordPress database.

Here’s what to do to restore your WordPress database using the backups that you have made.

1. Log into your FTP account and delete everything in the /wp-content/cache directory.

2. Log into your PHP MyAdmin and select your WordPress database. It is very important that you choose the correct name of your WordPress database especially if you auto-installed it using Fantastico.

3. You will be presented with a list of all the tables contained in the database. Click on Check All to select all the tables. Then select the Drop option from the drop-down box to delete the tables.

4. Choose Yes and all tables will be deleted.

Now it is time to actually restore your WordPress database.

1. Click on the Import menu and then browse to the location of the backup file. Once you’ve done that, click on go and wait for the upload process to finish.

A successful database restoration will show you a message confirming your success.

Now go to your admin panel and check your site to make sure everything is functioning properly. If it is you have successfully restored your WordPress database!

Popularity: 6% [?]

Post to Twitter Post to Digg Post to Facebook Post to StumbleUpon

How to backup your WordPress database

Having a backup of your WordPress database could one day save the day if something should ever happen to your blog. How often should you backup? I know people who backup everyday and I know people who backup once a week. Personally, I backup daily. The choice is entirely up to you.

How do you backup your WordPress blog database?

DISCLAIMER: As always this tutorial is provided as is. I shall not be held responsible in any way for loss of database, blog, etc. Use this at your own discretion.

How to Backup WordPress Database.

1. Download, install and activate WordPress Database Backup .

2. Go to Tools and in the sidebar of your dashboard click on Backup.

3. Under Backup options select “Download to your computer” and click on “Backup Now”. When the backup is done you’ll be given an option to choose where to save the backup. Save the backup and you’re done.

4. Click on the Schedule ie. Once Hourly, Once Daily.
5. Type in your email address.
6. Click the schedule backup button.
7. Select which tables you would like to include in the backup.

Popularity: 7% [?]

Post to Twitter Post to Digg Post to Facebook Post to StumbleUpon

WordPress 2.8 has arrived

Remember when I wrote WordPress 2.7 has arrived? Well, now WordPress 2.8 has arrived. And, since the advent of 2.7 it is now easier than ever to upgrade your WordPress installation. Now you can automatically update your entire WordPress installation straight from your WordPress admin panel. This new feature is called Core Update. Please check the core update host compatibility list before proceeding.

Another quick down and dirty way to upgrade WordPress is to use the automatic WordPress plugin from Techie Buzz. This fine plugin will have you upgraded and up and running in a matter of moments.

Last, but certainly not least is the way I did it before WordPress 2.7. I manually uploaded my files to my web server using FTP. This gave me full control of the files but is the most time consuming of the methods though it is considered by some the most reliable way of upgrading WordPress.

Though I upgraded manually a few different ways this is the most efficient way of going about it. As long as you are at the latest version come update time. Why not use a file comparison utility? A file comparison utility will help you compare and merge the differences between versions of files. Updating only your changed files will get you to the newest version of WordPress quickly and maybe when it is time for the next update you will be less apt to put if off.

Again, there are many ways to upgrade WordPress manually choose whichever method works best for you.

Wordpresslogo

 

 

Popularity: 22% [?]

Post to Twitter Post to Digg Post to Facebook Post to StumbleUpon

Adding Google Analytics to WordPress

Here I’ll show you how to add Google Analytics to your WordPress blog.

  • Login to your WordPress Admin
  • Under “Appearance” (on the left side) select “Editor”
  • If you have a custom template you will be using index.php otherwise you will be using footer.php.
  • ** IMPORTANT** If you were given a choice when you signed up for a Google Analytics account to choose between the new tracking code (ga.js) or the old tracking code (urchin.js) choose the new tracking code.
  • Immediately before the </body> tag paste your Google Analytics code. 
  • Click “Update File”
  • I suggest you now go to Google Analytics and check next to your blog’s URL. Hopefully you will see “Gathering Data” and you’ll know you were successful. If you see “Tracking Not Installed” try it again.

Good luck. That’s all folks!

 

 

 

Popularity: 15% [?]

Post to Twitter Post to Digg Post to Facebook Post to StumbleUpon

How to remove the meta name generator tag

Yesterday I showed you how to remove two useless tags from your WordPress head section. Today we’ll remove a tag that could expose your site by revealing which WordPress version you are running. This tag used to be simple to remove but WordPress has moved it from the template to the core.

Here’s how to remove it:

  • Login to your WordPress admin panel
  • Navigate to Design > Theme Editor and click Theme Functions (functions.php)
  • Just before the closing ?> tag add this

remove_action(‘wp_head’, ‘wp_generator’);

  • Click Update File

Done!

 

Popularity: 2% [?]

Post to Twitter Post to Digg Post to Facebook Post to StumbleUpon

Remove rel=”EditURI” and rel=”wlwmanifest”

Here I’ll show you how to remove the EditURI and wlwmanifest links from the head section of your WordPress blog. These links are only necessary if you use or plan to use Windows Live Writer. Otherwise these 2 lines added to your blog header since WordPress 2.3.1 and above are useless.  

<link rel=”EditURI” type=”application/rsd+xml” title=”RSD” href=”http://mysite/xmlrpc.php?rsd” />

<link rel=”wlwmanifest” type=”application/wlwmanifest+xml” href=”http://mysite/wp-includes/wlwmanifest.xml” />

After removal your pages will load faster. Here’s how to do it:

  • Login to your WordPress panel
  • Navigate to Appearance > Editor
  • Click Theme Functions (functions.php)
  • Add the following code to the end of the file. Right before the closing <?php } ?> or ?> tags:

add_action(‘init’, ‘remheadlink’);
function remheadlink() {
remove_action(‘wp_head’, ‘rsd_link’);
remove_action(‘wp_head’, ‘wlwmanifest_link’);
}

  • Click Update File

Done!

 

Popularity: 33% [?]

Post to Twitter Post to Digg Post to Facebook Post to StumbleUpon

WordPress 2.7 has arrived

The ever popular open source blogging software WordPress recently released version 2.7. This major upgrade dramatically enhances the interface which should come as a welcome relief to most. Your blogging experience will be easier and more manageable with this new version.

I’ve never had a problem upgrading WordPress releases so I do them manually myself. For the weary you can install the automatic update plugin here. For the rest of you grab the last version on the download page.

To get you all psyched up for the upgrade. Here’s a video tour of WordPress 2.7

Popularity: 2% [?]

Post to Twitter Post to Digg Post to Facebook Post to StumbleUpon