TechSparx Technology News

Subscribe by email (Delivered by FeedBurner):

How to restore a MySQL database and tables from .frm .ibd or .myd raw database files

powered-by-mysql-167x86.pngConsider a situation - you've got a well tuned MySQL database server running some popular websites. The sites are implemented with Drupal and Wordpress, but using MySQL to store the content and settings. You think everything is fine, until one day you look at Google Analytics and are aghast to see zero traffic for the previous two days. You go to the websites and are greeted by a 404 error, with the server saying there's nothing there.

If Wordpress is switching from PHP to Node.js, how should they do it?

wordpress-logo-stacked-rgb.pngnodejs-dark.pngSupposedly the Wordpress team is migrating Wordpress from PHP to Node.js. That astonishing bit of news comes from news.sys-con.com, but the evidence presented isn't exactly compelling.

Headless Wordpress/Drupal is galloping into view with Sleepy Hollow references tagging along for the ride

wordpress-logo-stacked-rgb.pngHeadless Wordpress is becoming a thing, now that Wordpress 4.4 has been released and has some core support for a REST API. The Drupal world has seen Headless Drupal work for a couple years now, and the Wordpress community has seen the light as well. The advantages of decoupling the website rendering from content management are many, the biggest perhaps being the rapidly changing best practices landscape for delivering content to the display device.

Hell Bent from Gallifrey straight to Big Finish - Maisie/Jenna as Me/Clara from now til the end of time

p039ph43.jpgWhatever else we make of the Doctor Who Season 9 finale, one thing is clear: Maisie Williams and Jenna Coleman have a long career ahead of them playing immortals "Me" and Clara, traveling the universe in their own TARDIS. That's how the episode ended, eh? Clara insisting on a return to Gallifrey to finish things, but to take the long way around.

Revisiting software development on Chromebooks - rapidly improving state of Chrome apps for developers

Chromebooks make surprisingly great laptops for software developers. If you don't know much about the Chromebook model, you might dismiss it as just a web-browser with delusions of grandeur. I'm a long-time software developer, writing code for a living since the mid-80's primarily on Unix/Linux/MacOSX systems, and I've pretty much abandoned my MacBookPro in favor of a Chromebook. The Chromebook is much faster than the MacBook (primarily due to the SSD drive), and lots lots lots cheaper to buy/own than any MacBook or MacBookPro.

Drupal Book node hierarchy went missing, necessitating database patching and a couple scripts to help

Twice now I've had the Book hierarchy on a Drupal 6 site go bonkers. The first time was on this very site, back in 2009, while this site was being converted from Drupal 5 to Drupal 6 (it's now on Drupal 7). The /book page simply became empty, and I managed to fix the book hierarchy with some database twiddling. That was over six years ago and I'd since converted this site to Drupal 7. I have another site still running Drupal 6, and the same problem (empty /book page) just happened on that site.

Let's Kill Davros! Or, a review of Doctor Who S09E01, the Magicians Apprentice

p032kxgr.jpgIf someone pointed out to you a little boy, as innocent as could be, and you knew that boy would grow up to create the most evil the universe ever saw, would you kill that little boy and prevent that evil? Yes or No. And what would either answer make you to be? If you're The Doctor, and you're suddenly in the middle of a horridly crazy war that looked like World War I trench warfare but had biplanes shooting laser canons, and you met a scared little boy who was about to die, what would you do?

How to stop your facebook page from posting tweets to twitter

Automated postings to social media accounts - Facebook, Twitter, etc - are a great way to build your presence, and let your audience know what you're doing. Over the years preferred services have come and gone which automate cross posting to social media accounts. Where a few years we would have instructed Facebook to autopost to twitter, we might want to do that in a different way now. For example, I'm finding the dlvr.it service to be much better and offer better control over the format of postings.

Avoid false spam decisions by Gmail's spam filters, stop losing critical emails in the spam folder

Gmail has done us all a great service by developing an excellent spam filter. I used to get hundreds of spam emails a day, and switching to Gmail reduced the spam rate to a few per week. No longer am I buried by spam. Of course the cost for this is to regularly visit the spam folder and see if Gmail accidentally marked any as spam (a.k.a. false positive for spam). Usually there's only a few and it's easy to click the "Not Spam" button to retrieve those emails back into the regular inbox.

Pages