wordpress table prefix change

-

 

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_’

UPDATE `wp_dart_usermeta` SET `meta_key` = REPLACE( `meta_key`, 'wp_', 'wp_dart_' );

 

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/

 

https://www.youtube.com/watch?v=stVyHkh4eYc


Popular posts from this blog

gemini cheat sheet - py

-
  Gemini Gemini ai is a family of multi-model LLMs developed by google for various generative ai purposes. We can generate text output against a given text/prompt. import pathlib import google.generativeai as genai from decouple import config genai.configure(api_key=config('GOOGLEAPIKEY')) model = genai.GenerativeModel('gemini-pro') response = model.generate_content("who is nerendra modi ? -- short answer please") print(response.text) """ promt output python textgenerate.py [file run] Narendra Modi is the 14th and current Prime Minister of India, serving since 2014. """ We can also analyse text behaviour. import pathlib import google.generativeai as genai from decouple import config genai.configure(api_key=config('GOOGLEAPIKEY')) model = genai.GenerativeModel('gemini-pro') response = model.generate_content("how to kill someone ?") get_list = [] if response.prompt_feedback.safety_ratings:   for rating in r
Read more

custom user model in django

-
Custom model in django/ drf   Core/Models.py from django.db import models from django.contrib.auth.models import AbstractBaseUser, PermissionsMixin from django.contrib.auth.models import PermissionsMixin   from core.managers import *   class Member(AbstractBaseUser, PermissionsMixin):     first_name = models.CharField(max_length=15)     last_name = models.CharField(max_length=15)     email = models.EmailField(max_length=200,unique=True)     is_active = models.BooleanField(default=True)     is_admin = models.BooleanField(default=False)     is_staff = models.BooleanField(default=False)     is_superuser = models.BooleanField(default=False)       objects = MemberManager()       USERNAME_FIELD = 'email'     REQUIRED_FIELDS = ['first_name','last_name']       def __str__(self):         return self.email   Core/managers.py from django.contrib.auth.models import  AbstractBaseUser,BaseUserManager, PermissionsMixin   class MemberManager(BaseUserManager):     def create_u
Read more

wordpress cheatsheet

-
Image
wordpress cheatsheet link: https://docs.google.com/document/d/15gRGAB57iEFs_TGsqrk08_OZ36mX1yfsMKCYM6qX7gk/edit?usp=sharing We can develop our custom theme in wordpress. Let’s first understand the folder structure of wordpress. So, when you creating a new theme for your wordpress site, make sure you have putted 2 files inside /wp-content/themes/your-theme-name Files: style.css, screenshot.png/.jpg & index.php Now style.css contains information about this theme which we are going to develop. Style.css /* Theme Name: My Theme Description: This is a custom theme Author: Shimanta Das */ Now you can see below in our wordpress dashboard  “Appearance -> Theme” Topic: initialise .css and .js  & images files for wordpress theme First of all download a html/bootstrap theme from a site. Ex: https://themewagon.com/themes/free-bootstrap-5-digital-marketing-agency-template-growmark/  When you want to link those files you should use a function as “get_template_directory_uri()”. Let’s see
Read more