Archive for 2012

How to change mysql database or table collation

 

You can use the ALTER TABLE/DATABASE SQL statements to convert your data.
 
To set the default character set for a database, use the following statement.
 
ALTER DATABASE <database_name> CHARACTER SET utf8;
 
This does not affect any existing tables, but any future tables created in this database will use utf8 by default.
 
How to change mysql database- table collation
 
For each table you want to convert to utf8, use the following statement.
 
ALTER TABLE <table_name> CONVERT TO CHARACTER SET utf8;
 
This will automatically convert all text columns to utf8.
 

Read more »

How to Change a Broken WordPress Theme Using PHPMyAdmin

 
Sometimes when editing .php files you will make a mistake and end up breaking your theme or sometimes you might upload a theme that is old and out of date or is just too problematic and it needs to be switched back to the twenty ten default theme.

Some times the following error may occur.

Change a Broken WordPress Theme 1
 
Here is an easy way to switch to the twenty ten default theme using PHPMyAdmin.
 
Step 1
 
Go into your cPanel and look for the Databases section and click on the phpmyadmin link.


 
Step 2
 
Select the database where your WordPress is stored.


 
Step 3
 
Select the ‘wp_options’ table from the menu on the left.

 

Read more »

How to Add Leverage Browser Caching in WordPress Website via .htaccess

 
Step 1
 
First you need to access your .htaccess file through cPanel by clicking on the File Manager. When the popup box appears, click on the Web Root option and make sure that the “Show hidden files” option is checked.
 

Add Leverage Browser Caching 1


 
Step 2
 
Open up your .htaccess file and paste the following directives at the top of the file:
 

Read more »