Currently, DevCentral uses the default phabricator prefix. We should instead use devcentral.
Offered procedure:
$ shell devcentral $ sv stop ircbot $ sv stop phd $ sv stop php-fpm $ cd /opt/phabricator $ bin/storage dump > /tmp/dump.sql $ cp /tmp/dump.sql /tmp/dump-backup-with-phabricator-prefix.sql $ bin/storage renamespace --in dump.sql --from phabricator --to devcentral > /tmp/dump-backup-with-devcentral-prefix.sql $ mysql -hmysql -p$MYSQL_ENV_MYSQL_ROOT_PASSWORD < /tmp/dump-backup-with-devcentral-prefix.sql $ bin/config set storage.default-namespace devcentral $ sv start php-fpm $ sv start phd $ sv start ircbot
Then, if all is fine, remove former databases:
$ bin/storage shell DROP DATABASE phabricator_almanac; DROP DATABASE phabricator_audit; DROP DATABASE phabricator_auth; DROP DATABASE phabricator_badges; DROP DATABASE phabricator_cache; DROP DATABASE phabricator_calendar; DROP DATABASE phabricator_chatlog; DROP DATABASE phabricator_conduit; DROP DATABASE phabricator_config; DROP DATABASE phabricator_conpherence; DROP DATABASE phabricator_countdown; DROP DATABASE phabricator_daemon; DROP DATABASE phabricator_dashboard; DROP DATABASE phabricator_differential; DROP DATABASE phabricator_diviner; DROP DATABASE phabricator_doorkeeper; DROP DATABASE phabricator_draft; DROP DATABASE phabricator_drydock; DROP DATABASE phabricator_fact; DROP DATABASE phabricator_feed; DROP DATABASE phabricator_file; DROP DATABASE phabricator_flag; DROP DATABASE phabricator_fund; DROP DATABASE phabricator_harbormaster; DROP DATABASE phabricator_herald; DROP DATABASE phabricator_legalpad; DROP DATABASE phabricator_maniphest; DROP DATABASE phabricator_metamta; DROP DATABASE phabricator_meta_data; DROP DATABASE phabricator_multimeter; DROP DATABASE phabricator_nuance; DROP DATABASE phabricator_oauth_server; DROP DATABASE phabricator_owners; DROP DATABASE phabricator_passphrase; DROP DATABASE phabricator_pastebin; DROP DATABASE phabricator_phame; DROP DATABASE phabricator_phlux; DROP DATABASE phabricator_pholio; DROP DATABASE phabricator_phortune; DROP DATABASE phabricator_phragment; DROP DATABASE phabricator_phrequent; DROP DATABASE phabricator_phriction; DROP DATABASE phabricator_phurl; DROP DATABASE phabricator_policy; DROP DATABASE phabricator_ponder; DROP DATABASE phabricator_project; DROP DATABASE phabricator_releeph; DROP DATABASE phabricator_repository; DROP DATABASE phabricator_search; DROP DATABASE phabricator_slowvote; DROP DATABASE phabricator_spaces; DROP DATABASE phabricator_system; DROP DATABASE phabricator_token; DROP DATABASE phabricator_user; DROP DATABASE phabricator_worker; DROP DATABASE phabricator_xhpastview; DROP DATABASE phabricator_xhprof;