wordpress table prefix change
Change table prefix 1. Download all the wordpress site files and database(.sql) file 2. Open wp-config.php file and change the current database credentials and change the $table_prefix name. 3. Upload all the tables from .sql file to new database. Now select all the tables and right click and change table prefix name(rename). 4. Change 2 tables value, assume your old prefix was ‘wp_’ UPDATE `wp_dart_usermeta` SET `meta_key` = REPLACE( `meta_key`, 'wp_', 'wp_dart_' ); UPDATE `wp_dart_options` SET `option_name` = 'wp_dart_user_roles' WHERE `option_name` = 'wp_user_roles'; 5. Now change 2 values more, go to ‘_options’ table of your new database and change the ‘siteurl’ and ‘home’ url by new value. 6. You can also set new password if you forgot o...