Change table prefix in wordpress db

gistfile1.txt

RENAME TABLE wp_8_options TO wp_5_options,
             wp_8_posts TO wp_5_posts,
             wp_8_commentmeta TO  wp_5_commentmeta,
             wp_8_comments to wp_5_comments,
             wp_8_links to wp_5_links,
             wp_8_postmeta to wp_5_postmeta,
             wp_8_users to wp_5_users,
             wp_8_usermeta to wp_5_usermeta,
             wp_8_terms to wp_5_terms,
             wp_8_term_taxonomy to wp_5_term_taxonomy,
             wp_8_term_relationships to wp_5_term_relationships;
update wp_5_options set option_name = 'wp_5_user_roles' where option_name='wp_8_user_roles';
update  wp_5_usermeta set meta_key='wp_5_user_level' where meta_key='wp_8_user_level';
update  wp_5_usermeta set meta_key='wp_5_usersettings' where meta_key='wp_8_usersettings';
update  wp_5_usermeta set meta_key='wp_5_usersettings_time' where meta_key='wp_8_usersettings_time';
update  wp_5_usermeta set meta_key='wp_5_capabilities' where meta_key='wp_8_capabilities';
// don't forget to change prefix in wp_config