open-steps.org WordPress farm

From https://lab.allmende.io/ecobytes/infrastructure/issues/141#note_11534 (three months ago) we copy and paste the following. With @acorbi we anticipated an intended migration of the four WordPress blogs on the open-steps.org KVM, which is being abandoned in course of the deprecation of Koala, into a single WordPress farm instance.

Criterium

• All four sites seek to be up to date, up and running after the migration.

Course of action

site	folder	database
archives.open-steps.org	opensteps_archive/	opensteps_archive
www.lifeformapps.com	lifeformapps/	lifeformapps_wp
www.ungravityvision.com	ungravity/	ungravity
www.alexcorbi.com	alexcorbi/	alexcorbi_wp

• get database credentials grep 'DB_' /var/www/*/wp-config.php
• write scripts
  • database dump
  • tar.gz wp-content folders
• run ^^
• move ^^ via scp to panda
• restore WordPressies
  • convert into a single farm
    • merge user databases
      • retain site mappings
    • mangle table prefixes
  • refer to previous examples
    • https://hack.allmende.io/s/ecobytes-2017-wordpress
    • find further ones ...
• validate 💣