Difference between revisions of "Tutorial: PhpRunner 9.8 and Photo Display"

From dftwiki3
Jump to: navigation, search
 
(4 intermediate revisions by the same user not shown)
Line 2: Line 2:
 
----
 
----
 
<onlydft>
 
<onlydft>
−
=PhpRunner 9.8=
+
=PhpRunner 9.8 on MacBook Pro=
 
* Get IP of MacBook (192.168.1.151)
 
* Get IP of MacBook (192.168.1.151)
 
* Start Parallels
 
* Start Parallels
Line 44: Line 44:
 
echo "rsyncing php dir to hadoop01"
 
echo "rsyncing php dir to hadoop01"
 
rsync -azv ~/Documents/PHPRunnerOutput/* dominique@hadoop01.dyndns.org:/var/www/html/photos/
 
rsync -azv ~/Documents/PHPRunnerOutput/* dominique@hadoop01.dyndns.org:/var/www/html/photos/
 +
ssh -tt dominique@hadoop01.dyndns.org <<EOF
 +
chmod g+w /var/www/html/photos/files
 +
exit
 +
EOF
  
 
# dump photo database to sql file
 
# dump photo database to sql file
Line 304: Line 308:
 
       sudo chown -R www-data:www-data $fullDir 2> /dev/null
 
       sudo chown -R www-data:www-data $fullDir 2> /dev/null
 
   
 
   
 +
* Create MYSQL User and DB.  On EC2
 +
 +
mysql -u root -p
 +
create database NohoSkies;
 +
CREATE USER 'nohoSkies'@'localhost' IDENTIFIED BY 'xxxxxxxx';
 +
grant all privileges on NohoSkies . * to 'nohoSkies'@'localhost' ;
 +
FLUSH PRIVILEGES;
 +
quit
 +
 +
* Migrate MySQL database from MacBook to EC2
 +
 +
cd ~/Downloads/
 +
echo "USE NohoSkies;" > NohoSkies.sql
 +
mysqldump -u root -pvoidm%20  NohoSkies >> NohoSkies.sql
 +
 +
echo "rsyncing MySqlDump to EC2"
 +
rsync -az -e "ssh -i ~/.ssh/mykeyDFT.pem" \
 +
      NohoSkies.sql ubuntu@dominiquefthiebaut.com:Downloads/
 +
 +
echo "loading up MySQL dump in EC2 MySQL DB"
 +
ssh -i "~/.ssh/mykeyDFT.pem" -tt ubuntu@dominiquefthiebaut.com <<EOF
 +
mysql -u root -pvoidm%20 < ~/Downloads/NohoSkies.sql
 +
exit
 +
EOF
 +
 +
*
 +
 +
==Cron Script to Backup S2 Photos directory+MySql to S3==
 
<br />
 
<br />
 +
::<source lang="bash">
 +
#! /bin/bash
 +
# ~/bin/backupNohoSkies.sh
 +
# D. Thiebaut
 +
# --------------------------------------------------------------------------------
 +
 +
# --------------------------------------------------------------------------------
 +
# BACKUP MYSQL
 +
# --------------------------------------------------------------------------------
 +
#
 +
echo mysqldump
 +
mysqldump --user=nohoSkies --password=voidm%20 NohoSkies > /home/ubuntu/backups/NohoSkies/NohoSkies.sql
 +
# 2> /dev/null
 +
# copy to S3
 +
cd /home/ubuntu/backups/NohoSkies
 +
gzip -f NohoSkies.sql
 +
echo uploading sql file to S3
 +
s3cmd  put  NohoSkies.sql.gz  s3://backup-dft-hadoop02/NohoSkies/
 +
 +
# --------------------------------------------------------------------------------
 +
# BACKUP PHP FILES (ON SUNDAYS ONLY)
 +
# --------------------------------------------------------------------------------
 +
cd /data/html/photos/
 +
_DATE="$(LC_ALL=C date +%A)"
 +
if test "$_DATE" = "Sunday"
 +
then
 +
  echo tar-zipping php files
 +
  tar --exclude='./files' -czf /home/ubuntu/backups/NohoSkies/NohoSkiesPhp.tgz *
 +
  echo uploading php files to s3
 +
  s3cmd put /home/ubuntu/backups/NohoSkies/NohoSkiesPhp.tgz s3://backup-dft-hadoop02/NohoSkies/
 +
fi
 +
 +
# --------------------------------------------------------------------------------
 +
# SYNC PHOTOS ONLY
 +
# --------------------------------------------------------------------------------
 +
cd /data/html/photos/files/
 +
s3cmd sync ./ s3://backup-dft-hadoop02/NohoSkies/files/
 +
 +
 +
</source>
 
<br />
 
<br />
 
</onlydft>
 
</onlydft>

Latest revision as of 14:59, 8 June 2018

D. Thiebaut (talk) 10:38, 25 May 2018 (EDT)


...








Retrieved from "http://dominiquethiebaut.com/dftwiki3/index.php?title=Tutorial:_PhpRunner_9.8_and_Photo_Display&oldid=33557"