There were actually over 700 blog entries to add to this web site. I did it with three SQL statements:
INSERT INTO wp_posts (post_date, post_content, post_title, post_status, comment_status, ping_status, post_name) SELECT FROM_UNIXTIME(news_datestamp), news_body, news_title, ‘publish’, ‘closed’, ‘open’, REPLACE(news_title, ‘ ‘, ‘-’) FROM e107_news;
UPDATE wp_posts SET post_author = 2, guid = CONCAT(‘http://www.blogicalthoughts.com/?p=’, FORMAT(ID, 0)) WHERE ID > 41;
INSERT INTO wp_post2cat (post_id, category_id) SELECT ID, 1 FROM wp_posts WHERE ID > 41;
Each of these took less than a quarter of a second to execute, and I now have over 700 posts. Of course, there will be manual tweaking, since the two CMS programs are fundamentally different.
Silly sign of the day:
Free/Open Source Software
- Linux grabs 75% of all open source investment
- Novell, ODF and Castles in the Sand
- Miguel de Icaza plays fast and loose with the facts and history
- 13 Reasons to Celebrate the New Microsoft-Novell Pact – Pure speculation, no concrete items.
RIAA/MPAA/BSA/FCC
- One-Name Celebrities and Four-Letter Words
- Stealing Fair Use, Selling It Back to You
- Senators Warn FCC on Media-Ownership Rewrite
- BSA takes two London-based companies to court for alleged software licensing infringements
- AllofMP3 Denies Wrongdoing, Contact with US/Russian Governments
Stupid Patent Tricks, DRM and Other IP Nonsense
- US to charge new patent fees
- TiVoToGo DRM cracked
- BT store’s Windows DRM
- State to lead way in intellectual property law certification
- Walking the design plank
Other News
- Panel changes course, approves e-voting checks
- Nasa unveils plans for moon station
- Another Day, Another Knockout Punch Aimed at SCO
- Boy Arrested For Opening Xmas Gift Early – So, what kind of lesson is that for the kid?
- ‘Smokey’ Joe Barton Calls Global Warming Science ‘Absolute Nonsense,’ Vows To Fight CO2 Caps
Security/Our Rights
- Radical Transparency and National Security
- Microsoft Issues Word Zero-Day Attack Alert
- Cost of border-security gear: $8 billion
- Heathrow starts biometric security trial
Big Brother
- Hey, Have You Seen My Civil Liberties Recently?
- Say Hello to the Goodbye Weapon
- Privacy Board Knows Number of Americans Targetted by NSA but Won’t Share the 411