Stephen, Ryan, Thanks a ton to both of you. Due to some personal reasons, I was away from my PC for more than 2 weeks.
Yesterday, I started the upgrade process of my wordpress files. As a first step, I first tried creating a backup of my wordpress database. I am new to this as I have never created a backup before.
I backed up my wordpress database with the help of
phpMyAdmin by following the instructions shown in the site, mentioned in Ryan's reply.
Now I have saved the backup on my computer. It has got
saved as an sql file with a notepad extension. I want to
make sure that the backup which I created is actually
usable. How do I verify this?
The beginning of my file looks like this.
-- phpMyAdmin SQL Dump
-- version 184.108.40.206
-- Host: localhost
Time: Apr 05, 2011 at 12:14 PM
-- Server version: 5.1.52
PHP Version: 5.2.4
40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION
/*!40101 SET NAMES utf8 */;
-- Table structure for table
comment_ID bigint(20) unsigned NOT NULL AUTO_INCREMENT,
comment_post_ID bigint(20) unsigned NOT NULL DEFAULT
comment_author tinytext NOT NULL
...the rest of the file follows after this. Has the backup been created the way it should be?