User:MichaelWestwind/wordpress testbed

site press set up by vagrant

packages installed

ii  wordpress      2.5.1-11       weblog manager
ii  apache2        2.2.9-10+lenny Apache HTTP Server metapackage
ii  apache2-mpm-pr 2.2.9-10+lenny Apache HTTP Server - traditional non-threade
ii  apache2-utils  2.2.9-10+lenny utility programs for webservers
ii  apache2.2-comm 2.2.9-10+lenny Apache HTTP Server common files
ii  php5           5.2.6.dfsg.1-1 server-side, HTML-embedded scripting languag
ii  php5-common    5.2.6.dfsg.1-1 Common files for packages built from the php
ii  php5-gd        5.2.6.dfsg.1-1 GD module for php5
ii  php5-mysql     5.2.6.dfsg.1-1 MySQL module for php5
ii  mysql-client-5 5.0.51a-24+len MySQL database client binaries
ii  mysql-common   5.0.51a-24+len MySQL database common files

• 6-13 added mysql-server

• on oahu:
  • mysqldump -uroot -p wordpress >dump.sql
  • tar cvf wp-backup.tar /usr/share/wordpress/wp-content/ dump.sql
  • gzip wp-backup.tar

• copy to press (took two steps because oahu is in dmz)
  • untar (found I made mistake when I tarred it and had to be in / to untar properly)

• replace all instances of oahu.freegeek.org with press.fglan (using vim)
• now I need to create a wordpress database with a user wordpress and a password
• sudo mysql -p
• create database wordpress;
• create user wordpress identified by xxxxxx;
• grant all on wordpress.* to wordpress;