Hi All I have a wordpress blog, whose tables prefix i would like to change. I understand there are quite a few ways to do this. I chose the method of exporting the database, and then opening the .sql file and doing a find and replace - this part seems to have worked after i import the files back into phpmyadmin. It has created the correct number of tables with the correct prefix, however i still have the old prefix tables present. I then went into the wp-config.php file and edited the line: [ $table_prefix = 'wp_'; ] to correctly reflect the table prefix i had applied. However the blog then does not display the data, any one know what i am doing wrong ? Any help will be appreciated. Kind Regards
How about renaming the tables directly through phpmyadmin and then change the prefix to the new one in wp-config.php?