clement-analogue

#!/bin/bash
# find all video files without thumbnail and create thumbnails
db=""
host="mysql.example.com"
user=""
pw=""

mysql -h $host -P 3306 -D$db -u$user -p$pw -se 'SELECT id,path FROM `piwigo_images` where representative_ext is null and right(file,3) = "mp4"' | while read -r id value;
do
    s=${value##*/}