Difference between revisions of "Network/Procedures/move to vps"
From Makers Local 256
< Network
(starting steps) |
m |
||
| (3 intermediate revisions by one user not shown) | |||
| Line 2: | Line 2: | ||
* remove debian-sys-maint user info in grants.sql | * remove debian-sys-maint user info in grants.sql | ||
* remove root user info from grants.sql | * remove root user info from grants.sql | ||
| − | * web:~/migration# mysqldump --single-transaction | + | * 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 | * 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 | * 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:~/ | ||
Latest revision as of 20:22, 28 April 2015
- 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:~/
