Does anyone know how rename sql tables throughout an existing WP page? I want to install another version of WP on my site with different table prefixes and I wanted to change the prefix of the older tables to match the current sequence.
I tried out right changing the prefix of the old tables and changing the prefix setting in config.php, but when trying to access the old page it says:
It doesn't look like you've installed WP yet. Try running install.php.
I backed everything up and tried running
install.php, but then it gave me this error:
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '01-v3_categories ( cat_ID bigint(20) NOT NULL auto_increment, cat_name varch' at line 1]
CREATE TABLE 01-v3_categories ( cat_ID bigint(20) NOT NULL auto_increment, cat_name varchar(55) NOT NULL default '', category_nicename varchar(200) NOT NULL default '', category_description longtext NOT NULL, category_parent int(4) NOT NULL default '0', PRIMARY KEY (cat_ID), KEY category_nicename (category_nicename) )
Any help would be appreciated!