Network/Procedures/move to vps

From Makers Local 256
Jump to: navigation, search
  • web:~/migration# ./mygrants.sh > grants.sql
  • remove debian-sys-maint user info in grants.sql
  • remove root user info from grants.sql
  • web:~/migration# mysqldump --single-transaction --add-drop-database --databases donations ml256_wordpress presence website wikidb > backup.sql
  • scp -3r root@web:/root/migration/ remote.makerslocal.org:~/dbs
  • jimshoe@remote:~$ mysql -u root -p < backup.sql
  • jimshoe@remote:~$ mysql -u root -p < grants.sql
  • On local machine:
    • rsync -Pa root@10.56.0.3:/var/svn .
    • rsync -Pa root@10.56.0.3:/var/www .
    • rsync -Pa root@10.56.0.3:/etc/ssl/private .
    • rsync -Pa www remote.makerslocal.org:~/
    • rsync -Pa svn remote.makerslocal.org:~/