Admins eHow SysAdmin Tips & Tricks

May 5, 2016

Convert whole directory video/audio files using ffmpeg in Windows

Filed under: Windows — Tags: , , , — admin @ 9:05 pm

The following command converts all AVI files in a directory to H264 480p using ffmpeg :

FOR /F "tokens=*" %G IN ('dir /b *.avi') DO ffmpeg -i "%G" -codec:v libx264 -preset slow -b:v 500k -maxrate 500k -bufsize 1000k -vf scale=-1:480 -threads 0 -codec:a aac -b:a 128k "%~nG.mp4"

May 18, 2009

Convert and Change MySQL Collation/Encoding to utf8

Filed under: General,MySQL — Tags: , , , , , , — admin @ 12:33 pm

This is simple , use the following command on mysql :

alter table TABLE_NAME convert to character set utf8 collate utf8_unicode_ci;

Powered by WordPress