Wordpress mySQL backup file ?

[ps56k]

I have what appears to be a plain text backup file
from Wordpress used on a now closed team website.

The website we used for one of our teams
was not renewed last year, and is gone.

I have all the files, including what appears to be a backup file
of the Wordpress blog used to maintain the website.
A snipet is included below.
How can I use this backup file to load an MS Access database ?
It appears to be a list of SQL commands
with the actual text data embedded within the stream.

tnx -

# WordPress MySQL database backup

#

# Generated: Saturday 14. June 2008 22:12 EDT

# Hostname: xyz

# Database: `xyz_wordpress`

# --------------------------------------------------------

# --------------------------------------------------------

# Table: `wp_categories`

# --------------------------------------------------------



#

# Delete any existing table `wp_categories`

#

DROP TABLE IF EXISTS `wp_categories`;



#

# Table structure of table `wp_categories`

#

CREATE TABLE `wp_categories` (

`cat_ID` bigint(20) NOT NULL auto_increment,

`cat_name` varchar(55) NOT NULL default '',

`category_nicename` varchar(200) NOT NULL default '',

`category_description` longtext NOT NULL,

`category_parent` bigint(20) NOT NULL default '0',

`category_count` bigint(20) NOT NULL default '0',

`link_count` bigint(20) NOT NULL default '0',

`posts_private` tinyint(1) NOT NULL default '0',

`links_private` tinyint(1) NOT NULL default '0',

PRIMARY KEY (`cat_ID`),

KEY `category_nicename` (`category_nicename`)

) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 ;

#

# Data contents of table `wp_categories`

#


INSERT INTO `wp_categories` VALUES (1, 'News', 'news', '', 0, 105, 0, 0, 0)
;

INSERT INTO `wp_categories` VALUES (2, 'Links', 'links', '', 0, 0, 17, 0, 0)
;

INSERT INTO `wp_categories` VALUES (3, 'Calendar', 'calendar', '', 0, 1, 0,
0, 0) ;

#

# End of data contents of table `wp_categories`

# --------------------------------------------------------

 

[ps56k]

I have what appears to be a plain text backup file
from Wordpress used on a now closed team website.

The website we used for one of our teams
was not renewed last year, and is gone.

I have all the files, including what appears to be a backup file
of the Wordpress blog used to maintain the website.
A snipet is included below.
How can I use this backup file to load an MS Access database ?
It appears to be a list of SQL commands
with the actual text data embedded within the stream.

I really just want a single table - the one with all the formatted text blog
entries...
-----
DROP TABLE IF EXISTS `wp_posts`;



#

# Table structure of table `wp_posts`

#

CREATE TABLE `wp_posts` (

`ID` bigint(20) unsigned NOT NULL auto_increment,

`post_author` bigint(20) NOT NULL default '0',

`post_date` datetime NOT NULL default '0000-00-00 00:00:00',

`post_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',

`post_content` longtext NOT NULL,

`post_title` text NOT NULL,

`post_category` int(4) NOT NULL default '0',

`post_excerpt` text NOT NULL,

`post_status`
enum('publish','draft','private','static','object','attachment','inherit','future')
NOT NULL default 'publish',

`comment_status` enum('open','closed','registered_only') NOT NULL default
'open',

`ping_status` enum('open','closed') NOT NULL default 'open',

`post_password` varchar(20) NOT NULL default '',

`post_name` varchar(200) NOT NULL default '',

`to_ping` text NOT NULL,

`pinged` text NOT NULL,

`post_modified` datetime NOT NULL default '0000-00-00 00:00:00',

`post_modified_gmt` datetime NOT NULL default '0000-00-00 00:00:00',

`post_content_filtered` text NOT NULL,

`post_parent` bigint(20) NOT NULL default '0',

`guid` varchar(255) NOT NULL default '',

`menu_order` int(11) NOT NULL default '0',

`post_type` varchar(20) NOT NULL default 'post',

`post_mime_type` varchar(100) NOT NULL default '',

`comment_count` bigint(20) NOT NULL default '0',

PRIMARY KEY (`ID`),

KEY `post_name` (`post_name`),

KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`)

) ENGINE=MyISAM AUTO_INCREMENT=233 DEFAULT CHARSET=latin1 ;

#

# Data contents of table `wp_posts`

#


INSERT INTO `wp_posts` VALUES (2, 2, '2006-02-11 11:52:32', '2006-02-11
19:52:32', '<p align="center">&nbsp;</p>\r\n<p align="center"><font
size="4"><strong>Welcome to Naperville North Boys Track &amp; Field<br
/>\r\n</strong><em>Home of the Huskies!<br />\r\n</em></font><font
size="4"><br />\r\n</font></p>\r\n<p align="left"><font size="1">The Boys
Track and Field Team provides student athletes an opportunity to feel good
about themselves and their performances. We focus on PRs or Personal Records
which indicate improvement as result of committment to the team, its
coaches, and to oneself. The Huskies believe in measuring individual
performance by measuring their teammates accomplishments. In doing so,
student athletes invest in their fellow team members and enhance their own
ability to achieve PRs. Most of all, we love to compete and have&nbsp;fun!
</font></p>\r\n<p align="left">The subpages to the right should supply you
with all the information you will need regarding the details of our program.
In addition, their are numerous printable PDF forms for your
convience.</p>\r\n<p align="left">Thanks for visiting our site.
..........................................