How do you rename a database linked to an existing, published php app like WordPress or OSCommerce?

1. Back up your database.
2. Create a new database with the new name you want in mySQL and assign a user.
3. In phpMyAdmin go to Operations and use the "Copy database to:" option to move the structure and data to the new table by:  typing the new name in the text field, de-selecting any check boxes that are on and choosing “Go”. 
4. Your new database should now be present in the drop down list of databases in phpMyAdmin.
5. Back up your current app’s (WordPress or OSCommerce for example) config file.
6. Change the information in the current config file to reflect the new database name and any username and password changes you may have made. Save with the same name.
7.  Upload/overwrite the config file on your server in the appropriate area for your app.
8. Check to verify that your app works with the new setup by accessing your site.
9. Once you feel clear that everything’s hooked up and happy with the new database information you can delete your old database (and users if you created new ones.)

1st Quarter Project for Mediaworks at Evergreen State College

Get the latest Flash Player to see this player.

There’s alot I like about Access 2007 but one big exception is Microsoft’s failing to provide a trail map from Access 2003 features to the radically new locations of those same features in Access 2007. 

So I spent a few hours trying to figure out how to separate a label from a field in a report layout.  In the past you could just simply select the label and then cut . . . no more.  Now what you have to do is select the Arrange Tab and work with the buttons for Tabular, Stacked and Remove layouts. The layout needs to be removed by pressing the Remove button in order for the label to be deleted. (Now how hard would it have been to state this in MS’s own Help file??? Methinks it did belong there.)

On the plus side the tabular and stacked layouts allow for a much improved ability to resize and relocate fields on a report and working with the field/label links in most layouts will be a time saving improvement.  If you don’t for some reason want your field labels, don’t despair - you can still delete them - just the way to get there has changed.

Plug-in wp-dtree creates nested, drop-down menus. See examples here.

Simple Tags makes managing your tags infinitely easier and more straightforward. It provides a fast way to add tags to all your posts.

SpotMilk Theme by Sunghwa Park. comes in two choices – blue or green and has an extra zip file "adminmilkmenus" that creates drop-down menus. The interface is attractive and clean and the drop down menus save a lot of time. Unfortunately it looks like the plug-in website http://www.ceprix.net has disappeared, at least for now.

#sidebar ul li {
  list-style: disc;
  list-style-position: inside;
}

#sidebar ul li ul li{
 list-style: circle;
 list-style-position: inside;
}

Dean’s FCKEditor For Wordpress is very stable and has it all. Add tables, images, format all of the above and more.