#!/bin/bash

cd /myata/Photos_tools
echo "Dumping sqlite data"
sqlite3 ../digikam4.db .dump > digikam-dump.txt
echo "Converting sqlite data to mysql format"
cat digikam-dump.txt | ./sqlite3-to-mysql.py > into_mysql
echo "Dropping tables"
grep "CREATE TABLE" into_mysql | sed 's/^CREATE TABLE \(.*\)$/DROP TABLE IF EXISTS \1;/' | mysql --batch -u<userid> -p<password> digikam4
echo "Importing Data"
( grep -v hash_index into_mysql | grep -v image_name_index | grep -v uuid_index | sed -e '{N; s/,\n.*UNIQUE.*);/);/;P;D }' | sed '0,/TRIGGER/s/CREATE TRIGGER/\/*/1' ; echo "*/" )| mysql --batch -u<userid> -p<password> digikam4