If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Wordpress mySQL backup file ?
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` # -------------------------------------------------------- |
#2
|
|||
|
|||
Wordpress mySQL backup file ?
"ps56k" wrote in message ... 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" /p\r\np align="center"font size="4"strongWelcome to Naperville North Boys Track & Fieldbr /\r\n/strongemHome of the Huskies!br /\r\n/em/fontfont size="4"br /\r\n/font/p\r\np 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 fun! /font/p\r\np 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\np align="left"Thanks for visiting our site. .......................................... |
Thread Tools | |
Display Modes | |
|
|