Make a full WordPress Transfer

WordPress site migration from one host to another host consists of three parts - moving the files, moving the database and reconfiguration (if needed).

Step :-

open cpanel

compress the all file in zip format

download the zip file

upload zip file in anoter host

create database

import database file

To do this, open the wp-config.php file in your WordPress root folder and locate the following lines:
define('DB_NAME', 'user_wrdp1');
/** MySQL database username */
define('DB_USER', 'user_wrdp1');
/** MySQL database password */
define('DB_PASSWORD', 'password');

You need to replace those values with your actual database, database username and password for it.

How to do Search and Replace in WordPress with a Plugin.

you create a complete WordPress backup before making any changes to your WordPress database. Make this best practice a habit, things can go wrong anytime when you are making direct changes to the WordPress database. If you have a backup, then you can easily restore your WordPress site without losing anything.

Installing and Using Better Search and Replace for WordPress

First thing you need to do is install and activate the Better Search Replace plugin. Upon activation, you need to visit Tools » Better Search Replace page to use the plugin.

Simply add the text string you want to search for and then add the replace text. After that you need to select the tables you want to look into. For example, if you want to search and replace some text in your posts then you may want to select the posts table. You can also select multiple tables if you want.

The plugin can run a case sensitive search and replace. It can also perform a dry run which allows you to see how many cells are affected by your search without actually replacing the text. When you are satisfied, click on run search/replace button. If you did not check the dry run option, then the plugin will now run search and replace on your WordPress database.

if you want of replace hardcoded code from your database they you can use plugin search and replace plugin.

Backup your wordpress site.

we recommend that you check out BackupBuddy plugin which is hands down the most complete backup solution for WordPress.

How To Move Or Backup Your Website With The WordPress Duplicator Plugin

How To Move Or Backup Your Website With The WordPress Duplicator Plugin

1. Download and Install the Plugin

Duplicator can be installed directly from the WordPress dashboard. Under the Plugins option of your dashboard, click the “Add New” button and then search for “duplicator”. The plugin you’re looking for should be the first result but double check that it’s authored by LifeInTheGrid. Go ahead and click “Install Now”:

2. Activate the Plugin and Create a Site Package

After activating the plugin, you’ll get a new navigation option in your main WordPress dashboard menu: “Duplicator”. Select this and you’ll enter the main setup screen with a warning message that you haven’t created any packages yet:

Click the “Create New” tab. This will take you to the package creation wizard. Before the package can be created, there are several requirements that need to be fulfilled. Hopefully you’ll have a “pass” in this, but if not, you can expand the box to find out where the problem is:

Optimizing your WordPress Database in phpMyAdmin

After using WordPress for a while your database becomes fragmented. There are memory overheads which increases your overall database size and query execution time. For those of us who remember in the old PC days, you would notice that your computer would get faster once you use Disk Defragmenter. The MySQL database works in a similar way. It comes with a simple command that allows you to optimize your database. Go to phpMyAdmin and click on your WordPress Database. This will show you a list of your WordPress tables. Click on Check All link below the tables. Next to it there is a “With Selected” drop down, click on it and choose Optimize table.

This will optimize your WordPress tables by defragmenting tables. It will make your WordPress queries run a little faster and slightly reduce the size of your database.

How to Deactivate all WordPress Plugin from phpMyAdmin

Output :-

Previous Next