copy_images.sh
613 Bytes
#!/bin/bash
timestamp=$(date "+%F +%T" )
#timestamp=$(date +%s)
for D in `ls /var/www/Magento/SPV3_Bilder/Alben/Bilder`; do
for F in `ls /var/www/Magento/SPV3_Bilder/Alben/Bilder/${D}`;do
mv /var/www/Magento/SPV3_Bilder/Alben/Bilder/${D}/${F} /var/www/Magento/magento/media/anc/image//admin/1/original/${F}
echo "INSERT INTO magento19_spv3.mag_anc_image_ncimage ( customer_id, admin_user_id, path, file,ncalbum_id,created_at) VALUES ('0', '1', 'media/anc/image//admin/1/original/${F}', '${F}', '${D}','${timestamp}');"
done | mysql -uspv3 -pxGr5ZuopTr45gZpl1R5t4EsrwftzuIo magento19_spv3;
#done
done