Wordpress table prefix change ~ NO PLUGIN

Published: 13 April 2024
on channel: microcodes

161

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: https://www.md5hashgenerator.com/

---------------------------------------------------------------------------------------------------------------------------------------------------------
🌐Our website : https://www.microcodes.in/

📗learn Java: https://java.microcodes.in/index.php/...
🗄️learn MySQL: https://dbms.microcodes.in/index.php/...
🐘learn PHP: https://php.microcodes.in/index.php/b...
📕learn Dart: https://dart.microcodes.in/index.php/...

👉 My Social Media links
🤹‍♂️Linkedin:   / shimanta-das-497167223
👹facebook : https://www.facebook.com/profile.php?...
📸Instagram : https://www.instagram.com/meshimanta/...
🐦Twitter :   / shimantadas247
📬Telegram link : https://t.me/microcodesofficial
🎦Youtube :    / @microcodes6887

⚙️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: http://ncs.io/_Crazy
Watch:    • BEAUZ & JVNA - Crazy | Electronic Pop | NC...

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.

On this page of the site you can watch the video online Wordpress table prefix change ~ NO PLUGIN with a duration of online in good quality, which was uploaded by the user microcodes 13 April 2024, share the link with friends and acquaintances, this video has already been watched 161 times on youtube and it was liked by 2 viewers. Enjoy your viewing!