Wordpress table prefix change ~ NO PLUGIN

Published: 13 April 2024
on channel: microcodes
44
1

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_’
4.a. UPDATE `wp_dart_usermeta` SET `meta_key` = REPLACE( `meta_key`, 'wp_', 'wp_dart_' );
4.b. 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 old ones for wp-admin, for that go to ‘_users’ table and pass the new md5 hash key. For generating md5 hash use this website:


---------------------------------------------------------------------------------------------------------------------------------------------------------
Our website :

learn Java:
️learn MySQL:
learn PHP:
learn Dart:

My Social Media links
‍️Linkedin:
facebook :
Instagram :
Twitter :
Telegram link :
Youtube :

️Tools used :
OBS studio, windows, ms office, vs code etc.
️Disclaimer- Some contents are used for educational purposes under fair use.
music credit:
Song: BEAUZ & JVNA - Crazy [NCS Release]
Music provided by NoCopyrightSounds
Free Download/Stream:
Watch:


Copyright Disclaimer Under Section 107 of the Copyright Act 1976,
allowance is made for "fair use" for purposes such as criticism,
comment, news reporting, teaching, scholarship, and research.
Fair use is a use permitted by copyright statute that might otherwise be infringing.
Non-profit, educational, or personal use tips the balance in favor of fair use.


Watch video Wordpress table prefix change ~ NO PLUGIN online without registration, duration 14 minute 10 second in high hd quality. This video was added by user microcodes 13 April 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4 once and liked it people.