Difference between revisions of "Network/Procedures/move to vps"

Revision as of 23:59, 4 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 donations > donations.sql
• web:~/migration# mysqldump --single-transaction ml256_wordpress > ml256_wordpress.sql
• web:~/migration# mysqldump --single-transaction presence > presence.sql
• web:~/migration# mysqldump --single-transaction website > website.sql
• web:~/migration# mysqldump --single-transaction wikidb > wikidb.sql
• scp -3r root@web:/root/migration/ remote.makerslocal.org:~/dbs

• jimshoe@remote:~$ mysql -u root -p < grants.sql