Copy a MySQL table

Not using this all too often, so here it is for me and everyone:

create table my_new_table like my_old_table;
insert into my_new_table select * from my_old_table;

An easy way to make a quick backup.

Increase VM storage on-line

Increase from 300 G to 400 G using the same storage, but leverage LVM on GPT inside the VM.

Host:

lvextend -L +100G /dev/mapper/guests--lolguest
virsh qemu-monitor-command lolguest info block --hmp
virsh qemu-monitor-command lolguest block_resize drive-virtio-disk0 400G --hmp

VM:

sgdisk -e /dev/vda
gdisk /dev/vda # <-- create partition 5
partprobe /dev/vda
pvcreate /dev/vda5
vgextend ubuntu-vg /dev/vda5
lvextend -l +100%FREE /dev/ubuntu-vg/ubuntu-lv
resize2fs /dev/mapper/ubuntu--vg-ubuntu--lv

Always watch out for paths, partition numbers and names!

Acer Aspire 1200

I was cleaning up my apartment and I found my very first own notebook back from 2002ish. It has undergone a couple of upgrades and replacements since then and I installed a weird Linux distribution on it.

Screenshot

It’s Q4OS with a Windows 2000 theme.