Skip to content

Instantly share code, notes, and snippets.

View TimaGribanov's full-sized avatar
🇺🇦

Tima Gribanov TimaGribanov

🇺🇦
4 followers · 8 following
View GitHub Profile
@davenewham
davenewham / gist:220850ca51667d559bbe9ded6856fd60
Created February 1, 2022 19:32
Convert video file to telegram webm for animated sticker
ffmpeg -i input_file.mp4 -framerate 30 -c:v libvpx-vp9 -an -vf scale=512:512 -pix_fmt yuva420p output_sticker.webm
@xacnio
xacnio / telegram_video_sticker_ffmpeg.md
Last active July 20, 2025 23:05
Telegram - Create Video Sticker (.WEBM) with FFMPEG

Command

ffmpeg -y -i animated_sticker.mov -r 30 -t 2.99 -an -c:v libvpx-vp9 -pix_fmt yuva420p -s 512x512 -b:v 400K output.webm
  • If .webm file size greater than 256 KB, you should reduce "-b:v 400K"
  • .mov video file may has alpha channel but not required.
  • My video sticker pack for example: https://t.me/addstickers/msn_animations

Telegram Sticker Command

@devdrops
devdrops / example.md
Last active December 12, 2025 14:08
Mysqldump from Docker container

Mysqldump from Docker container

docker exec -i mysql_container mysqldump -uroot -proot --databases database_name --skip-comments > /path/to/my/dump.sql

OBS

  • This will generate a dump.sql file in your host machine. Awesome, eh?
  • Avoid using --compact on your dump. This will make MySQL check your constraints which will cause troubles when reading your file (damm you MySQL). And don't use --force to fix this scenario: recreate your dump without --compact ¯_(ツ)_/¯