#Decalaration de variable (MYSQL)
REMDBHOST='HOTE BD ANCIEN SITE'
REMDBNAME='BD ANCIEN SITE'
REMDBUSER='UTILISATEUR BD ANCIEN SITE'
REMDBPSW='MOT DE PASSE BD ANCIEN SITE'
REMTBL2XFER=( "TABLE 1" "TABLE 2" "TABLE 3" "TABLE..." )
REMFILENAME=REMOTE_$(date +"%Y_%m_%d_%I_%M_%p").sql

DBHOST='HOTE NOUVEAU SITE'
DBNAME='BD NOUVEAU SITE'
DBUSER='UTILISATEUR BD NOUVEAU SITE'
DBPSW='MOT DE PASSE BD NOUVEAU SITE'

#Decalaration de variable (FTP)
FTPHOST='HOTE FTP ANCIEN SITE'
FTPUSER='UTILISATEUR FTP ANCIEN SITE'
FTPPSW='MOT DE PASSE FTP ANCIEN SITE'

#Chemin vers repertoire IMG
FTPIMGFOLDER='/public_html/img'
SITEIMGFOLDER='/home/site/public_html/img'

#Chemin vers repertoire Download
FTPDLFOLDER='/public_html/download'
SITEDLFOLDER='/home/site/public_html/download'

#Chemin vers repertoire UPLOAD
FTPUPFOLDER='/public_html/upload'
SITEUPFOLDER='/home/site/public_html/upload'


echo ----------------------
echo REMOTE DB BACKUP
echo ----------------------

mysqldump -h $REMDBHOST -u $REMDBUSER -p"$REMDBPSW" $REMDBNAME > REMOTE_BCK_$(date +"%Y_%m_%d_%I_%M_%p").sql

echo ----------------------
echo REMOTE DB BACKUP DONE
echo ----------------------

echo ----------------------
echo LOCAL DB BACKUP
echo ----------------------

mysqldump -h $DBHOST -u $DBUSER -p"$DBPSW" $DBNAME > LOCAL_BCK_$(date +"%Y_%m_%d_%I_%M_%p").sql

echo ----------------------
echo LOCAL DB BACKUP DONE
echo ----------------------

echo ----------------------
echo SIMPLE MYSQL LOOP
echo ----------------------
for ((i=0; i<${#REMTBL2XFER[*]}; i++));
do
	echo -- TABLE: ${REMTBL2XFER[i]}
	mysqldump --complete-insert --skip-triggers -h $REMDBHOST -u $REMDBUSER -p"$REMDBPSW" $REMDBNAME  ${REMTBL2XFER[i]} > $REMFILENAME
	sed -i 's/CREATE TABLE/CREATE TABLE IF NOT EXISTS/g' $REMFILENAME
	sed -i 's/DROP TABLE IF EXISTS/TRUNCATE TABLE/g' $REMFILENAME
	mysql -h $DBHOST -u $DBUSER -p"$DBPSW" $DBNAME < $REMFILENAME
done

echo ----------------------
echo SIMPLE MYSQL LOOP DONE
echo ----------------------

echo ----------------------
echo PHP SCRIPT IMPORT
echo ----------------------
/usr/bin/php5 /home/fomdi/web/fomdi.com/public_html/mep/data_xfer.php cronkey
echo ----------------------
echo PHP SCRIPT IMPORT DONE
echo ----------------------

echo ----------------------
echo IMG SYNC
echo ----------------------
lftp -u "$FTPUSER","$FTPPSW" -e "set ftp:ssl-allow no;set ftp:list-options -a; mirror -n -x error_log $FTPIMGFOLDER $SITEIMGFOLDER; quit;" $FTPHOST
echo ----------------------
echo IMG SYNC DONE
echo ----------------------

echo ----------------------
echo DOWNLOAD SYNC
echo ----------------------
lftp -u "$FTPUSER","$FTPPSW" -e "set ftp:ssl-allow no;set ftp:list-options -a; mirror -n -x error_log $FTPDLFOLDER $SITEDLFOLDER; quit;" $FTPHOST
echo ----------------------
echo DOWNLOAD SYNC DONE
echo ----------------------

echo ----------------------
echo UPLOAD SYNC
echo ----------------------
lftp -u "$FTPUSER","$FTPPSW" -e "set ftp:ssl-allow no;set ftp:list-options -a; mirror -n -x error_log $FTPUPFOLDER $SITEUPFOLDER; quit;" $FTPHOST
echo ----------------------
echo UPLOAD SYNC DONE
echo ----------------------