Wordpress table prefix change ~ NO PLUGIN

Publicado el: 13 abril 2024
en el canal de: 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.

En esta página del sitio puede ver el video en línea Wordpress table prefix change ~ NO PLUGIN de Duración online en buena calidad , que subió el usuario microcodes 13 abril 2024, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 161 veces y le gustó 2 a los espectadores. Disfruta viendo!