Yes that does work. The only thing I would caution is that a global search and replace of wp_ will find entries within the tables which is not what we want.
I used phpmyadmin to export the database and that used a single backtick around the table names. The backtick will not show here as it is used to flag code so I’ve used the normal quote for the example.
'wp_tablename'
Selecting the first backtick and the existing prefix ‘wp_ and replacing it with ‘newprefix_ will ignore the wp_ field entries and only select the table names.
Depending on the tools you use this may require some variations but the basic export, change, import process will work.
Of course on an active blog site you may want to block the site for the 10 minutes that this will take so that you do not lose any entries or comments.
Tony
I used this plugin last week to rename my tables from wp_ to xx_.
I then found that I was locked out of the wp-admin system entirely.
Renaming the tables back to wp_ made no difference.
The rename had also renamed all FIELDS within the tables starting with wp_ to XX_ !!
So the wp-user-roles became xx-user-roles etc. Tables affected included wp-user and wp-user-meta..
I’ve now MANUALLY corrected the mess. About two hours wasted.
(Yes, I COULD have restored my current database backup, but then I’d have had to repopulate the posts from that backup onward. It’s a dynamic site.)
REALLY, NOT IMPRESSED.
Advice to potential users of this plugin: DON’T BOTHER.
Rename the tables manually.
Update wp-config.php manually.
Rename the admin user to something else.
Make sure you have a backup admin user just in case.
Make sure you have up-to-date backups..
REALLY, NOT IMPRESSED.