Change table prefix of WordPress

3 steps to change table prefix:

1. Change table name

2. Update wp-config.php
#$table_prefix = ‘wp_’;
$table_prefix = ‘newprefix_’;

3. Run the following SQL:
Update newprefix_options set option_name = ‘newprefix_user_role’ where option_name = ‘wp_user_role’
update newprefix_usermeta set meta_key = ‘newprefix_capabilities’ where meta_key = ‘wp_capabilities’
update newprefix_usermeta set meta_key = ‘newprefix_autosave_draft_ids’ where meta_key = ‘wp_autosave_draft_ids’
update newprefix_usermeta set meta_key = ‘newprefix_user_level’ where meta_key = ‘wp_user_level’
update newprefix_usermeta set meta_key = ‘newprefix_usersettings’ where meta_key = ‘wp_usersettings’

Remove the default post footer

“This entry was posted on Wednesday, December 2nd, 2009 at 10:00 pm and is filed under ‘category’. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.”

Steps to remove the above paragraph:

1. Login as administrator

2. Select ‘Appearance’ > ‘Editor’

3. Select the current theme

4. On the right hand side, select Single Post(single.php)

5. Search “This entry was posted” and delete the relevant code

6. Click ‘Update File’