MySQL server has gone away – how to get it back

Has MySQL/MariaDB server ever run away from you? If it hasn’t, you’re lucky or you’re likely to use PostgreSQL instead. Today I’m trying to restore a database from backup (database dump) onto a new MariaDB server. This is what happened: The database size is 1.7G, and this should not surprised a database administrator. But it did surprise me because: firstly I’m not a db admin, and secondly I had this issue before just a few weeks ago....

February 8, 2018 · 1 min · 147 words · kenno

FreeBSD Recover GTP Table

Recently one of my servers that runs FreeBSD 11.1 keeps hanging on boot. Usually, the 2nd hard reboot will fix it. The root file system on this server is using ZFS and the ZFS pool report it as healthy. So I’ve been reluctant to do anything about it. Until tonight, when I accidentally list the partition of that drive (ada4): Ahh.. [CORRUPT] partition table it seems. I think the reason the server can still boot because GPT keeps the partition tables in two places (yes, one of the more reason to use GPT over MBR)....

February 3, 2018 · 1 min · 127 words · kenno

How to find the motherboard model on Windows 10

To find the motherboard model number on Windows (10), run cmd, and type: C:\Users\kenno>wmic baseboard get product,Manufacturer,version,serialnumber Manufacturer Product SerialNumber Version Gigabyte Technology Co., Ltd. Z170N-Gaming 5 To be filled by O.E.M. x.x Ref & credit: How to Find Computer and Motherboard Model Serial Number on Windows 10

January 14, 2018 · 1 min · 48 words · kenno

Change the urxvt font size on the fly

urxvt or unicode-rxvt is a terminal simulator like Gnome-terminal or Konsole. Recently I’m trying to switch to use i3 (i3-gaps), a tiling windows manager, and urxvt is good compliment to i3. Unlike Gnome-terminal or Konsole, the font name and size for urxvt are configured in ~/.Xresources. To make change to font size, for example, I’d edit ~/.Xresources, reload it with xrdb ~/.Xresources, and finally close and re-open urxvt itself. Though there is no built-in function to allow changing font size on the fly, urxvt allows us to do this via extensions....

December 24, 2017 · 2 min · 294 words · kenno

How to remove a copr repository in Fedora

This is just a quick note to remind myself how to remove a Copr repository. What’s a Copr? “Copr (Cool Other Package Repo) is a Fedora project to help make building and managing third party package repositories easy.” – https://fedoraproject.org/wiki/Category:Copr. Why do I want to remove it? One of the Copr repo I added a while back seemed to be no longer working, so I wanted to remove it. To list all repos on Fedora (27):...

December 11, 2017 · 1 min · 91 words · kenno