Wordpress table prefix change ~ NO PLUGIN

Veröffentlicht am: 13 April 2024
auf dem Kanal: 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.

Auf dieser Seite können Sie das Online-Video Wordpress table prefix change ~ NO PLUGIN mit der Dauer online in guter Qualität ansehen, das der Benutzer microcodes 13 April 2024 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 161 Mal angesehen und es wurde von 2 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!

7,186