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

How to recover when windows XP won’t boot after a defrag.

January 11th, 2006

Over the weekend, my laptop was running slow so I decided to run defrag after about 10 hours of it running I decided to cancel the defrag and rebooted my system. The system gave an error similar to “Windows XP can not boot required DLL missing”.
Read the rest of this entry »