Hi Friends, Multiple WordPress Installation into a single database. is it possible and how difficult is it?

This question is arrive when we think about installing multiple WordPress but our server(Host) has a limit of the MYSQL Database. The simple answer to this question is “Multiple WordPress Installation into a single database is possible and it’s not so difficult.”

For installing multiple WordPress on single MYSQL Database we need to install WordPress manually not using one-click programs they would not let you choose the prefix.

Please read here for manually installing WordPress if you don’t know if you already know its good. When we follow WordPress installation steps WordPress will for database pieces of information like in the below image.

WordPress Table Prefix

We need to enter all the details related to the database here only thing we need to change is Table Prefix. By default, the WordPress table prefix is (wp_). We can change it according to our requirement like below.

  1. For the Main website (www.example.com)
    We can use table prefix (main_)

  2. For Subdirectory blog (www.example.com/blog)
    We can use table prefix (blog_)

  3. For Subdomain blog (www.blog.example.com)
    We can use table prefix (blog2_) or anything that differentiates our table columns.

By using Table Prefix we can install as many WordPress we want on a single MYSQL Database.

Transferring WordPress is a very easy with WordPress plugin, but what happens when we get any error while transferring WordPress using these plugin. Because we are Web Developers so we must have the knowledge of how to manually transfer WordPress .

Transfer WordPress for any of reason like:

To new Domain.
To new Hosting.
Sub Domain to Root.
Root to Sub Domain.

Here are some notes for how to transfer your WordPress manually:

Step – 1

First, We download all files of WordPress From your old server. These files contains WordPress php files, your theme, plugins, media images and many more. We must download all files so that our site correctly transfer successfully.

Step – 2

After Downloading files we need to export database from phpMyAdmin Server. It contains all your WordPress website pages, posts and many more.

Step – 3

After exporting database we need to create database, database user and password on your new server where you want transfer your WordPress, and please copy these details in notepad.

Step – 4

After creating database we need to import our old database to this new server. after import database we need to below steps:
4.1) We need to go wp-options table
4.2) Here we need to change in “siteurl” and “home”  row and replace old URL with your new site URL.

Step – 5

After this, we need to upload all files you downloaded from old server to new server and edit “wp-config.php” file and change the values of below data:

— “We need to add new database name you copied when create new database”

define('DB_NAME', 'database name')

— “ We need to add new database user name you copied when create new database”

define('DB_USER', 'database user name');

— “ We need to add new database user password you copied when create new database”

define('DB_PASSWORD', 'database user password');

— “We need to add your server user if not get any server url just add (localhost)”

-- define('DB_HOST', 'server url');

Step – 6

After these changes we need to login to your new site in browser with URL like, (http://yourdomain.com/wp-login.php)

Step – 7

After login we need to go to Settings > Permalinks and choose your permalink option and click save.

Step – 8

After saving Permalinks Settings we need to install a plugin named:

  1. Use the Velvet Blues Update URLs plugin if you can access your WP Admin Dashboard.
  2. Use the Better Search Replace plugin if you can access your WP Admin Dashboard.
  3. Use WP-CLI’s search-replace if your hosting provider (or you) have installed WP-CLI.

I used “Velvet Blues Update URLs” plugin. you can use any of these above plugin they all work same.

Step – 9

After installing plugin.

Go to Tools > Update URLs

9.1)  Enter Old URL and new URL.
9.2)  Check all the option below and Save settings.

Step 1

Download WordPress from https://wordpress.org/download.

Step 2

Extract files where you want to install WordPress like:

Here wordpress is a folder inside the htdocs folder.

  • On Server – https://yourdomain.com/

Here your WordPress is installing in root folder on server.

  • On Server sub domain  – https://yourdomain.com/blog

Here blog is a folder inside your root folder on server.

Step 3

Create database on your localhost (phpmyadmin) or on server where you extract your folder.

On localhost there is default user is root and password is blank.

On Server you need to create a User. View all instruction for creating database on cpanel.

After creating database and user, copy all details on notepad like database name, user name, user password and server URL.

Step 5

Open your domain on browser

  • On localhost – http://localhost/wordpress
  • On Server – https://yourdomain.com/
  • On Server sub domain  – https://yourdomain.com/blog/

and follow the instructions:

Step 5.1

Select language:

Step 5.2

Prepare all details we need to install WordPress as mention in screenshot:

Step 5.3

Enter all details which ask, on local your Host is localhost and on server your host may be different or may be localhost:

Step 5.4

Enter all details which ask, please enter valid Email so that if you forgot your password you can reset using email:

That’s all now your WordPress is install and running you can login and start customization.