Network/Procedures/move to vps

From Makers Local 256
< Network
Revision as of 23:59, 4 April 2015 by Jimshoe (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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 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
Retrieved from "https://256.makerslocal.org/wiki/index.php?title=Network/Procedures/move_to_vps&oldid=18776"