Upgrading WordPress

November 19th, 2008

1. Deactivate Plugins
2. Back up DB
mysqldump -u[username] -p[password] –opt datanamename > databasename.sql

3. copy wordpress folder
cp wordpress wordpress.save

4. download latest wordpress and extract
http://Wordpress.org

5. delete wordpress folder
rm -rf wordpress

4. upload new word press folder

6. Run upgrade program
http://example.com/wordpress/wp-admin/upgrade.php

You will have to create a new wp-config.php file during upgrade,
Look at your old config file for the correct settings.

cat wordpress.save/wp-config.php

7. Go to admin screen and set the theme to the default theme

http://example.com/wordpress/wp-admin

8. View site.

9 Copy over Themes

cp wordpress.save/wp-content/themes/* wordpress/wp-content/themes

10. Copy over Plugins

cp wordpress.save/wp-content/plugins/* wordpress/wp-content/plugins

11. Set theme to normal theme

12. Activate Plugins.

13. Edit wordpress config file
and change the following variables to something complicated.
here are some examples
define(’AUTH_KEY’, ‘:dr+ytru%/5V4sAUG-gg%aS*v;&xGhd%{YKC^Z7KKGh j>k[.Nf$y7iGKytutrdJ3c*[Kr5Bg');
define('SECURE_AUTH_KEY', 'TufWOuA _.t>#+hA?^|3RfGTm>@*+S=8ytruytu\"\'+\"}] define('LOGGED_IN_KEY', 'Styut~AACm4h1;T^\"qW3_8Zv!Ji=y|)~5i63JI |Al[(

If this does not work to put things back..

1. Remove wordpress folder
rm -rf wordpress
2 Copy saved wordpress folder back
cp wordpress.save wordpress
3. drop database using PhpMyadmin
4. Reload database
mysql -u[user] -p[password] datanamename < databasename.sql

Migrating Websites with databases

November 18th, 2008

1. Create ‘table’ folder on old website.

2. Sql dump all databases

cd …/’table’
mysqldump -u[username] -p[password] –opt datanamename > databasename.sql

3. FTP all files/folders to local PC

4. Create new folder “sitename” on new site

4.5 add domain name

6. FTP all the files to new site in sitename folder

7. create new database in phpmyadmin

8. on new site in tables folder sql load all databases
mysql -u[username] -p[password] datanamename < databasename.sql

9. check database in phpmyadmin

10. change password in on config files

11. Test Website.

12. change the DNS settings for site

Closing a Project

June 16th, 2008

Input

    Project Management Plan
    Contract Document
    Enterprise Environment Factors
    Organization Process Assets
    Work performance information
    deliverables

Tools and Techniques

    Project Management Methodology
    Project Management Information System
    Expert Judgment

Outputs

    Administrative Closure Procedure
    Contract Closure Procedure
    Final Product, Service, or Result
    Organizational Process assets updates

Developing a Project Scope Statement

June 12th, 2008

Benefits for developing a project scope statement.

  1. A common under standing among team and stakeholders
  2. A reference for judging success
  3. A baseline

Input

  1. Organizational process assets
  2. Project charter
  3. Preliminary project scope statement
  4. Project scope management plan
  5. Approved change requests

Tools and Techniques

  1. Product Analysis
  2. Alternative Identification
  3. Expert Judgment
  4. Stakeholder Analysis

Output

  1. Detailed Project Scope statement
  2. Requested changes
  3. Project Scope Management Plan updates

Developing a Scope Management Plan

June 12th, 2008

Scope Planning:

Why:

  1. Establish a common understanding
  2. Describe Project Deliverables
  3. Measure Project Performance

Inputs

  1. Enterprise environmental factors – anything internal or external that affects the project
  2. Process assets
  3. Project Charter
  4. Preliminary Score Statement

Tools and Techniques

  1. Expert Judgment
  2. Templates, Forms, and Standards

Output

  1. Project Scope Management Plan

Managing Integrated Change Control

June 12th, 2008

Input

  1. Project Management Plan
  2. Work Performance Information
  3. Recommended Preventative Actions
  4. Recommended Corrective Actions
  5. Recommended Defect Repair
  6. Deliverables
  7. Requested Changes

Tool and Techniques

  1. Project Management Methodology
  2. Project Management Information System
  3. Expert Judgment

Output

  1. Approved Change Request
  2. Rejected Change Request
  3. Project Management Plan Updates
  4. Approved Corrective Actions
  5. Approved Preventative Actions
  6. Approved Defect Repair
  7. Validated Defect Repair
  8. Deliverables

Project Management Monitoring

June 12th, 2008

Inputs

  1. Project Management Plan
  2. Work Performance Information
  3. Requested Change Requests

Tools and Techniques

  1. Expert Judgment
  2. Earn Value Technique (measure)
  3. Project Management Methodology

Output

  1. Recommended Corrective Actions
  2. Recommended Preventative Actions
  3. Recommended Defect Repair
  4. Requested Changes

Directing Project Management Execution

June 12th, 2008

Inputs

  1. Project Management Plan
  2. Approved corrective actions
  3. Approved preventive actions
  4. Approved defect repairs
  5. Approved change requests
  6. Validated defect repair
  7. Administrative closure procedures

Tools and Techniques

  1. Project Management Methodologies
  2. Project Management Information Systems

Output

  1. Deliverables
  2. Work Performance Information
  3. Requested Changes
  4. Implemented Change Requests
  5. Implemented Corrective Actions
  6. Implemented Preventative Actions
  7. Implemented Defect Repair

Developing a Project Management Plan

June 12th, 2008

The areas that a project management plan helps guide are communication, Decision, and Leadership.

Communication

  1. Risks
  2. Assumptions
  3. Decisions

Decision

  1. Schedule
  2. Cost
  3. Quality
  4. Scope

Leadership

  1. Executing
  2. Directing
  3. Controlling

To create a project management plan

Inputs:

  1. Preliminary Scope Statement
  2. Project Management Process
  3. Organizational Process Assets
  4. Enterprise Environmental Factors

Tools and Techniques

  1. Project Management Methodologies
  2. Project Management Information System
  3. Expert Judgment

Output

  1. Work Execution
  2. Project Process
  3. Implementation Level of Process
  4. Tools and Techniques
  5. Life Cycle
  6. Project Management Tools and Techniques
  7. Change Monitoring and Control Plan
  8. Configuration Management plan
  9. Communication Plan
  10. Management Reviews
  11. Baseline
  12. Management Plan
    • Scope
    • Schedule
    • Cost
    • Communication
    • Process Improvement metric
    • Staffing
    • Quality
    • Risk
    • Procurement

WebFocus Custom Query Example

May 16th, 2008

-* File db2stest.fex
ENGINE DB2 SET DEFAULT_CONNECTION DB2
SQL DB2 PREPARE SQLOUT FOR
select * FROM DB2SCHEMA.MYTABLE
;
END

TABLE FILE SQLOUT
PRINT
*
END

« Previous Entries