wpmu (blogs.gnome.org) database moved from button to drawable
- From: Olav Vitters <olav vitters nl>
- To: gnome-infrastructure gnome org
- Cc: jdub gnome org
- Subject: wpmu (blogs.gnome.org) database moved from button to drawable
- Date: Mon, 19 Apr 2010 23:09:18 +0200
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]