I want to extract only the lines that will restore a specific table from a mysql backup file. The following works. zcat /mnt/backup/full-replication.gz | sed -n -e '/DROP TABLE.*`account_codes`/,/UNLOCK TABLES/p' > account_codes.sql However, the backup file it 9GB in size, so I’d like to stop searching once the ending match […]
Daily Archives: July 16, 2023
5 posts
How I should setup my NAS network settings to isolate WAN and LAN traffic on each physical interfaces (1 and 2) to maximize LAN traffic speed? Or it exists another option to achieve this result without make changes on LAN clients? I have next home network setup – router with […]
PC starts ignoring mouse and keyboard once per day – it is not a total freeze, because the video keeps playing – the PC is used only to play YouTube, nothing else. PC is a few years old, it has Intel Pentium 8505 and 8 GB of RAM and a […]
a couple of hours ago I changed the IP-Address of my Windows-PC and my Raspberry Pi. Up until then I was able to connect to the Pi via SSH without any problems. Now, when I try to connect, I get the error message, that someone is trying “something nasty” and […]
Does anybody know how to add a second name for custom keyboard layout, that appears under the main name on the control panel, like US under ENG for “English (United States)”? I made a few layouts for one language via MSKLC and I don’t see which I use looking on […]