Wordpress table prefix change ~ NO PLUGIN

Published: 13 April 2024
on channel: microcodes

114

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...

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, duration hours minute second in high quality that is uploaded to the channel microcodes 13 April 2024. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 114 times and liked it 1 visitors.

42,904

1.3K