wpmu (blogs.gnome.org) database moved from button to drawable



I've moved the wpmu database (used by the site blogs.gnome.org) from
button to drawable.

jdub: Please change wp-config.php locally as well! (noticed push-live)

Quick guide for sysadmins:
@button
* sudo to root
* mysql
* show grants for `wpmu` `window-back`;
@drawable
* sudo to root
* mysql
* paste the commands given by show grants statement
@window
* grep DB_PASSWORD /usr/local/www/blogs.gnome.org/wp-config.php (for the database password)
* mysql -h drawable-back -u wpmu -p
  purely for testing purposes
* vim /etc/httpd/sites.d/blogs.gnome.org.conf
    Add to the config: Redirect 503 /
* /etc/init.d/httpd reload
@button
* mysqldump --databases wpmu > /tmp/wpmu.dump
--> Transfer /tmp/wpmu.dump from @button to @drawable (I used my
    homedir for this; 104MB uncompressed)
@drawable
* mysql < /tmp/wpmu.dump
@window
* vim /usr/local/www/blogs.gnome.org/wp-config.php
    Change window-back to drawable-back
* vim /etc/httpd/sites.d/blogs.gnome.org.conf
    Undo all the changes
* /etc/init.d/httpd reload

Also removed privileges on button for the wpmu user. This to really
ensure the website now uses drawable. I didn't drop the database though.
Further, to edit the privileges I tend to use mysql-administrator (with
port forwarding).

-- 
Regards,
Olav


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]