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.

REST API

Other

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 https://github.com/kedarvj/mysqldumpsplitter

sh mysqldumpsplitter.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.

.raw

It can’t be easier

Mount

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

Unmount

umount /mnt/tmpdiskrescue

.qcow2

Little more tricky

Kernel module

First, you will need kernel module loaded

modprobe nbd max_part=63

Mount

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

Unmount

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

Source http://alexeytorkhov.blogspot.com/2009/09/mounting-raw-and-qcow2-vm-disk-images.html

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

Voilà!

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

Source http://askubuntu.com/a/56044/453981