Archive for the 'Network Storage' Category
If you upgraded from 2.1 to 2.3.2, please don’t forget this database update:
You will need to add a new table called POST2CAT into your database.
Depending on your setup, it maybe defaulted to WP_ prefix
so make sure you add this to your SQL
-- phpMyAdmin SQL Dump
-- version 2.8.0.1
-- http://www.phpmyadmin.net
--
-- Host: custsql-pow07
-- Generation Time: Jan 10, 2008 at 03:57 PM
-- Server version: 5.0.45
-- PHP Version: 4.4.4
--
-- Database: `azrin_net1`
--
-- --------------------------------------------------------
--
-- Table structure for table `wp_IMM-Glossary`
--
CREATE TABLE IF NOT EXISTS `wp_IMM-Glossary` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Title` varchar(255) NOT NULL default '',
`Definition` text NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
-- --------------------------------------------------------
--
-- Table structure for table `wp_categories`
--
CREATE TABLE IF NOT EXISTS `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=28 DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ;
-- --------------------------------------------------------
--
-- Table structure for table `wp_comments`
--
CREATE TABLE IF NOT EXISTS `wp_comments` (
`comment_ID` bigint(20) unsigned NOT NULL auto_increment,
`comment_post_ID` int(11) NOT NULL default '0',
`comment_author` tinytext NOT NULL,
`comment_author_email` varchar(100) NOT NULL default '',
`comment_author_url` varchar(200) NOT NULL default '',
`comment_author_IP` varchar(100) NOT NULL default '',
`comment_date` datetime NOT NULL default '0000-00-00 00:00:00',
`comment_date_gmt` datetime NOT NULL default '0000-00-00 00:00:00',
`comment_content` text NOT NULL,
`comment_karma` int(11) NOT NULL default '0',
`comment_approved` enum('0','1','spam') NOT NULL default '1',
`comment_agent` varchar(255) NOT NULL default '',
`comment_type` varchar(20) NOT NULL default '',
`comment_parent` bigint(20) NOT NULL default '0',
`user_id` bigint(20) NOT NULL default '0',
PRIMARY KEY (`comment_ID`),
KEY `comment_approved` (`comment_approved`),
KEY `comment_post_ID` (`comment_post_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4187 DEFAULT CHARSET=latin1 AUTO_INCREMENT=4187 ;
-- --------------------------------------------------------
--
-- Table structure for table `wp_link2cat`
--
CREATE TABLE IF NOT EXISTS `wp_link2cat` (
`rel_id` bigint(20) NOT NULL auto_increment,
`link_id` bigint(20) NOT NULL default '0',
`category_id` bigint(20) NOT NULL default '0',
PRIMARY KEY (`rel_id`),
KEY `link_id` (`link_id`,`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
-- --------------------------------------------------------
--
-- Table structure for table `wp_links`
--
CREATE TABLE IF NOT EXISTS `wp_links` (
`link_id` bigint(20) NOT NULL auto_increment,
`link_url` varchar(255) NOT NULL default '',
`link_name` varchar(255) NOT NULL default '',
`link_image` varchar(255) NOT NULL default '',
`link_target` varchar(25) NOT NULL default '',
`link_category` bigint(20) NOT NULL default '0',
`link_description` varchar(255) NOT NULL default '',
`link_visible` enum('Y','N') NOT NULL default 'Y',
`link_owner` int(11) NOT NULL default '1',
`link_rating` int(11) NOT NULL default '0',
`link_updated` datetime NOT NULL default '0000-00-00 00:00:00',
`link_rel` varchar(255) NOT NULL default '',
`link_notes` mediumtext NOT NULL,
`link_rss` varchar(255) NOT NULL default '',
PRIMARY KEY (`link_id`),
KEY `link_category` (`link_category`),
KEY `link_visible` (`link_visible`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
-- --------------------------------------------------------
--
-- Table structure for table `wp_options`
--
CREATE TABLE IF NOT EXISTS `wp_options` (
`option_id` bigint(20) NOT NULL auto_increment,
`blog_id` int(11) NOT NULL default '0',
`option_name` varchar(64) NOT NULL default '',
`option_value` longtext NOT NULL,
`autoload` enum('yes','no') NOT NULL default 'yes',
PRIMARY KEY (`option_id`,`blog_id`,`option_name`),
KEY `option_name` (`option_name`)
) ENGINE=MyISAM AUTO_INCREMENT=936 DEFAULT CHARSET=latin1 AUTO_INCREMENT=936 ;
-- --------------------------------------------------------
--
-- Table structure for table `wp_post2cat`
--
CREATE TABLE IF NOT EXISTS `wp_post2cat` (
`rel_id` bigint(20) NOT NULL auto_increment,
`post_id` bigint(20) NOT NULL default '0',
`category_id` bigint(20) NOT NULL default '0',
PRIMARY KEY (`rel_id`),
KEY `post_id` (`post_id`,`category_id`)
) ENGINE=MyISAM AUTO_INCREMENT=829 DEFAULT CHARSET=latin1 AUTO_INCREMENT=829 ;
-- --------------------------------------------------------
--
-- Table structure for table `wp_postmeta`
--
CREATE TABLE IF NOT EXISTS `wp_postmeta` (
`meta_id` bigint(20) NOT NULL auto_increment,
`post_id` bigint(20) NOT NULL default '0',
`meta_key` varchar(255) default NULL,
`meta_value` longtext,
PRIMARY KEY (`meta_id`),
KEY `post_id` (`post_id`),
KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM AUTO_INCREMENT=5556 DEFAULT CHARSET=latin1 AUTO_INCREMENT=5556 ;
-- --------------------------------------------------------
--
-- Table structure for table `wp_posts`
--
CREATE TABLE IF NOT EXISTS `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','pending') 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 `post_status` (`post_status`),
KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
FULLTEXT KEY `autometa` (`post_content`,`post_title`)
) ENGINE=MyISAM AUTO_INCREMENT=670 DEFAULT CHARSET=latin1 AUTO_INCREMENT=670 ;
-- --------------------------------------------------------
--
-- Table structure for table `wp_term_relationships`
--
CREATE TABLE IF NOT EXISTS `wp_term_relationships` (
`object_id` bigint(20) NOT NULL default '0',
`term_taxonomy_id` bigint(20) NOT NULL default '0',
PRIMARY KEY (`object_id`,`term_taxonomy_id`),
KEY `term_taxonomy_id` (`term_taxonomy_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `wp_term_taxonomy`
--
CREATE TABLE IF NOT EXISTS `wp_term_taxonomy` (
`term_taxonomy_id` bigint(20) NOT NULL auto_increment,
`term_id` bigint(20) NOT NULL default '0',
`taxonomy` varchar(32) NOT NULL default '',
`description` longtext NOT NULL,
`parent` bigint(20) NOT NULL default '0',
`count` bigint(20) NOT NULL default '0',
PRIMARY KEY (`term_taxonomy_id`),
UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 AUTO_INCREMENT=63 ;
-- --------------------------------------------------------
--
-- Table structure for table `wp_terms`
--
CREATE TABLE IF NOT EXISTS `wp_terms` (
`term_id` bigint(20) NOT NULL auto_increment,
`name` varchar(55) NOT NULL default '',
`slug` varchar(200) NOT NULL default '',
`term_group` bigint(10) NOT NULL default '0',
PRIMARY KEY (`term_id`),
UNIQUE KEY `slug` (`slug`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 AUTO_INCREMENT=63 ;
-- --------------------------------------------------------
--
-- Table structure for table `wp_tla_data`
--
CREATE TABLE IF NOT EXISTS `wp_tla_data` (
`id` int(10) unsigned NOT NULL auto_increment,
`post_id` bigint(20) unsigned NOT NULL default '0',
`url` text NOT NULL,
`text` text NOT NULL,
`before_text` text NOT NULL,
`after_text` text NOT NULL,
`rss_text` text NOT NULL,
`rss_before_text` text NOT NULL,
`rss_after_text` text NOT NULL,
`rss_prefix` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `post_id` (`post_id`),
KEY `post_id_2` (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `wp_tla_rss_map`
--
CREATE TABLE IF NOT EXISTS `wp_tla_rss_map` (
`post_id` int(10) unsigned NOT NULL default '0',
`advertisement` text NOT NULL,
PRIMARY KEY (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `wp_usermeta`
--
CREATE TABLE IF NOT EXISTS `wp_usermeta` (
`umeta_id` bigint(20) NOT NULL auto_increment,
`user_id` bigint(20) NOT NULL default '0',
`meta_key` varchar(255) default NULL,
`meta_value` longtext,
PRIMARY KEY (`umeta_id`),
KEY `user_id` (`user_id`),
KEY `meta_key` (`meta_key`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
-- --------------------------------------------------------
--
-- Table structure for table `wp_users`
--
CREATE TABLE IF NOT EXISTS `wp_users` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`user_login` varchar(60) NOT NULL default '',
`user_pass` varchar(64) NOT NULL default '',
`user_nicename` varchar(50) NOT NULL default '',
`user_email` varchar(100) NOT NULL default '',
`user_url` varchar(100) NOT NULL default '',
`user_registered` datetime NOT NULL default '0000-00-00 00:00:00',
`user_activation_key` varchar(60) NOT NULL default '',
`user_status` int(11) NOT NULL default '0',
`display_name` varchar(250) NOT NULL default '',
PRIMARY KEY (`ID`),
KEY `user_login_key` (`user_login`),
KEY `user_nicename` (`user_nicename`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `wpau_active_plugins_info`
--
CREATE TABLE IF NOT EXISTS `wpau_active_plugins_info` (
`id` int(4) NOT NULL auto_increment,
`plugin_name` varchar(255) NOT NULL default '',
`plugin_status` varchar(255) NOT NULL default '',
`plugin_deactive_response` smallint(2) default '0',
`plugin_reactive_response` smallint(2) default '0',
`fatal_plugin` smallint(2) default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `wpau_upgrade_log`
--
CREATE TABLE IF NOT EXISTS `wpau_upgrade_log` (
`id` int(4) NOT NULL auto_increment,
`task_name` varchar(150) NOT NULL default '',
`task_status` varchar(150) NOT NULL default '',
`task_description` varchar(150) NOT NULL default '',
`task_log` text,
`start_date` datetime NOT NULL default '0000-00-00 00:00:00',
`end_date` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
You may need to access your MYSQL DB controls thru your control panel (CPANEL / WHM / PLESK / HELM ) and go thru phpmyadmin to access them.
Check your CONFIG.PHP for your database settings.
Then …easily update yr blog using the WP-AUTO-UPGRADE script. Yeah..the post ID is satanic abit.
Don’t say I DID NOT WARN YOU!
I am about to embark on my biggest project ever.
What to expect? Alot of downtime, for sure,cos mainly, I’m the only person doing all these stuff.Basicly, alot of factors made me do this.
1) Powweb Servers rental are due. They are not giving us the great deal as before. $7.77 was the deal, with buy one year, get 6mths free… and I took the 2yr get 2yr free. That is still active on the Perkahwinan.Org server. I’m going to remove all that, and port it to another single entity. I have 3 servers there, and there are are two which is under utilised and nearly to it’s end of the prepaid term. So , in order to renew, it’s $200 each, and it’s not worth it. I better put it to good use and renew the domains instead.
Their servers are getting VERY SLUGGISH nowadays, so I think it’s time to port out!Too much problems.
2)Hostgator Server 51 *(NS101) is on the Pre-Upgraded set. So, I am stuck with 5GB Space…and 75GB Bandwidth, whereas the newbies get 100GB space and 1,000GB *(that’s One Terrabyte!) Bandwidth. I have noticed that this server is getting sluggish and since the time we got banned due to a script error. So I did not want that to happen, and killed ALL of my sites, thus I took on more, with one I got for 1c on the first month. It’s silly, and I can say, it’s a real hassle!
But it works like a wonder! At least I can get things done properly, with PPP giving me a hit on the head for some work!
3)My Photo Galleries software are out of date, and so I took a new licensing for TWO new sites and a Photo based Advertising Gallery. That will be on my Free Property Listings - UK Edition. It’s a EBAY Style listing, and Foruming all in one. I will be working on it abit more, cos the previous marketplace I installed, well…sucked! Open Realty also has ALOT of limitations. I don’t want a vB based Job Marketplace…like Powweb did…..nor I want something on Ruby-on-Rails which I don’t even know head from tail! I will work on this once I learn new tricks and when my Linux machines come back to me. At least I can crash and trash it for all I care.
4)For the time being, it’s a one man show, less Mommy Tia & Co, in the world of Technology.My old operations have cease due to alot of problems I don’t even want to get into details.It sucks, and I hate to part with my friends who are my co-workers. So, if you want to work on this project with me, fine, as it’s quite promising, especially on the advertising aspect of things.
There will be more…but do understand if any of the network sites have an issue, it’s probably me doing something in the back…again!
Best Wishes.
Azrin
I give up! Should have stuck to my NSLU..
Poor Linksys Network Storage Unit ….
I just upgraded the firmware and the Flipping upgrade don’t work on me….
dunno why though..the OpenSlug manual says install that to the NSLU when without a usb disk/drive…
dead..can’t revive it at all….
Let me take a nap and see what I can do next.
Buddy Link:
SEO Engineering 101 Hacks and Cracks
In the Kitchen With Kak Mar
Walk with me in Europe
Singaporean in Europe
Ramble with the V@mp
With Her Royalness A Tun King Tia
- July 2008 (2)
- June 2008 (1)
- May 2008 (5)
- April 2008 (6)
- March 2008 (20)
- February 2008 (17)
- January 2008 (33)
- December 2007 (27)
- November 2007 (24)
- October 2007 (11)
- September 2007 (7)
- August 2007 (10)
- July 2007 (2)
- June 2007 (35)
- May 2007 (54)
- April 2007 (47)
- March 2007 (69)
- February 2007 (97)
- January 2007 (98)
- December 2006 (62)
- November 2006 (7)
- October 2006 (8)
- September 2006 (4)
- August 2006 (7)
- July 2006 (1)
- June 2006 (1)
- May 2006 (7)
- April 2006 (16)
- March 2006 (22)
- February 2006 (1)
- July 2005 (1)
- June 2005 (1)
- May 2005 (3)
- April 2005 (3)