InnoDB transactions

Yesterday I updated the date column of an entire table meant for its subset only. The solution to this mistake was to recover from daily mysqldump, and filling in the gaps that were, thankfully, able to be filled in. Writing in 2010, the author of the answer said: When something goes wrong, the only restoration option available is to reconstruct the data from a backup (providing one exists). Here are two answers that I found useful; i.

Windows 10 and Google Drive

So I was asking my colleague to switch from Dropbox to Google Drive, mainly because is the company is subscribed to Google Apps for Work. But the pushback was that (Windows 10) search didn’t return hits as expected, and search is all-important. I asked (the search engine) Google for help, and buried in a 2015 forum post is the solution for Windows 10, today. I’m not even sure why it’s been months and not resolved by the principals, but anyways:-

Slow Hyper-V Guest Network Performance

A couple weeks ago, I discovered that guest network performance was abysmally slow, copy-pasting files from host to guest (RDP) felt like it took days instead of the (expected) minutes! This delayed the commissioning of a new application, and it bugged me for a bit. Later on, a different guest exhibited the same issue; i.e., I could actually see the images it sent over being (very slowly) downloaded in the browser…

Deleting pages in OS X Preview.app

Today I received a PDF document, but there were two pages I’d to delete. Clicking the page and then hitting Delete didn’t work, so I did a Google search: I figured it out! In case this is useful to anyone else: I just needed to go to the Edit menu and choose “Thumbnail.” Once the list of pages is turned into Thumbnails, you can delete them. References https://discussions.apple.com/thread/5893303

Magento Admin URI 404

Today I was informed that navigating to a (previously working) Magento installation’s admin page was no longer working. Obviously, paid orders cannot be processed. So it’s pretty serious, to say the least. Stack Overflow gave me the solution, but it’s buried pretty deep down, so I’m copy-pasting for posterity, from http://stackoverflow.com/questions/18724995/magento-404-on-admin-page: One common cause for this behavior is an invalid value (or no value at all) being set for a custom admin path.

Windows laptop can't find Wi-Fi; others can

From the Start menu, right click “Computer”, then “Manage”. “Computer Management” window comes up, navigate to System Tools -> Device Manager > Network adapters. Right click the correct one (e.g. Atheros AR5B97 Wireless Network Adapter), then Uninstall. Keep the driver software for the device, now you should have one less adapter. Again from “Computer Management”, click Action > Scan for hardware changes. The wireless adapter should be detected, and then previously missing wireless network should re-appear.