If you use the export and import options in phpMyAdmin to do the backup and restore then you end up with a text file as the backup with just a whole series of SQL commands in it for recreating and loading the tables. You could just edit that file to remove the wp_ from the table names.
Alternatively you could edit the config file for your installation to change the prefix to 'wp_' so that it looks for tables with the prefix.


Reply With Quote

