Creating pretty and functional API documentation isn’t easy. Thanks to open source community and power of search engine I have found few tools to make it fast by generating look and feel so you can focus more on your app.



Easy split .sql dump file

Some tables may fail to load during dump import, especially when you do some migration when customers are waiting to resume service and your hands are shaking :)

Easy way to locate this problem is dividing your big .sql file using this tool

sh --source big_file.sql  --compression none --extract ALLTABLES

MySQL Tuning

Increase performance and check for popular vulnerabilities easy way, compatible with MySQL and MariaDB

Sometimes you need to access guest disk without booting it.

From time to time i just need to access few files from VM backups, so I restore VM to other ID on host and mount disk to prevent network IP conflicts etc.


It can’t be easier


losetup /dev/loop0 /var/lib/vz/images/100/vm-100-disk-1.raw
mount /dev/loop0p1 /mnt/tmpdiskrescue


umount /mnt/tmpdiskrescue


Little more tricky

Kernel module

First, you will need kernel module loaded

modprobe nbd max_part=63


qemu-nbd -c /dev/nbd0 /var/lib/vz/images/100/vm-100-disk-1.qcow2
mount /dev/nbd0p1 /mnt/tmpdiskrescue


umount /mnt/tmpdiskrescue
qemu-nbd -d /dev/nbd0


Say no more to big video files stored on disk only for few seconds of content.

You can also make short clips for sharing on YT/Vimeo etc.

Just install ffmpeg on Ubuntu/Debian

sudo apt-get install ffmpeg

then set start and end of a clip

ffmpeg -i longvideo.avi -vcodec copy -acodec copy -ss 00:34:00 -t 00:40:00 shortvideo.avi


It’s not transcoded so it’s fast and new file have original quality.