I’m going to build a testing install of WordPress to play with our CollegePublisher5 database export.
Some background: I have an account with Linode for hosting. The main site is running in the root, so PHP/MySQL/Apache are already set up. If you’re looking for help with that, check out Linode’s LAMP guide.
I’m going to install a new WordPress under /_stage. It’ll be completely seperate — seperate files, database, etc, so I can’t muck up the production site. (Hopefully.)
Create the database
I’m using SSH, so connecting directly to the database is the easiest way to do this. WordPress provides a very handy guide to making the MySQL database
I’ll call it “test1,” so my command looks like:
ivar@dailyemerald:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 50430
Server version: 5.1.41-3ubuntu12.10 (Ubuntu)
Type ‘help;’ or ‘h’ for help. Type ‘c’ to clear the current input statement.
mysql> create database test1;
Query OK, 1 row affected (0.00 sec)
mysql> grant all privileges on test1.* to “test1″@”localhost” identified by “(YOUR PASSWORD)”;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> exit
Bye
ivar@dailyemerald:~$
Jot that password down — you’ll need it in a second, then you won’t need it again.
Download, unzip WordPress
Let jump into our “_stage” directory, grab the lastest .tar.gz, unzip it, then move the install up a level (it defaults to a subdirectoy called “wordpress”)
ivar@dailyemerald:~/ode/_stage$ ls
ivar@dailyemerald:~/ode/_stage$ wget http://wordpress.org/latest.tar.gz
(download info comes out)
ivar@dailyemerald:~/ode/_stage$ tar xvzf latest.tar.gz
(lots of files scroll by)
ivar@dailyemerald:~/ode/_stage$ cd wordpress/
ivar@dailyemerald:~/ode/_stage/wordpress$ mv * ..
ivar@dailyemerald:~/ode/_stage/wordpress$ ls
ivar@dailyemerald:~/ode/_stage/wordpress$ ls -lah
total 8.0K
drwxr-xr-x 2 ivar ivar 4.0K May 7 21:16 .
drwxr-xr-x 6 ivar ivar 4.0K May 7 21:16 ..
ivar@dailyemerald:~/ode/_stage/wordpress$ cd ..
ivar@dailyemerald:~/ode/_stage$ rm -r wordpress/
ivar@dailyemerald:~/ode/_stage$ ls
index.php wp-app.php wp-content wp-login.php wp-rss2.php
latest.tar.gz wp-atom.php wp-cron.php wp-mail.php wp-settings.php
license.txt wp-blog-header.php wp-feed.php wp-pass.php wp-signup.php
readme.html wp-comments-post.php wp-includes wp-rdf.php wp-trackback.php
wp-activate.php wp-commentsrss2.php wp-links-opml.php wp-register.php xmlrpc.php
wp-admin wp-config-sample.php wp-load.php wp-rss.php
ivar@dailyemerald:~/ode/_stage$
Cool. We have a new installation living under /_stage. Lets go visit the site URL and go through the setup. For me, that’s http://dailyemerald.com/_stage. You’ll need your MySQL database, user and password.
Rock and roll!