Title: Install multiple databases
Last modified: August 19, 2016

---

# Install multiple databases

 *  [illufoxdesign](https://wordpress.org/support/users/illufoxdesign/)
 * (@illufoxdesign)
 * [16 years, 12 months ago](https://wordpress.org/support/topic/install-multiple-databases/)
 * I want to start using WordPress for my clients.
 * I have done a lot of research on how to move a WordPress site to another server,
   and I believe I have that figured out. But I’m concerned about the database part.
 * My plan is to create a subdirectory for each client and then install WordPress
   into the subdirectory (via Fantastico). However, I’m concerned that this will
   overwrite the database of my own WordPress site.
 * I know I can have multiple installation in the same database by changing the 
   wp-config file. But that won’t work if I want to move the database and website
   to the clients hosting server later on.
 * I wonder if it would be better to install the client test site on a subdirectory
   of the clients hosting server, and then move it to the main directory after testing?
   I know this won’t be good if the client doesn’t pay, but it seems so much easier.
 * There just isn’t enough detailed information on how to use WordPress for clients
   in a step by step setup and installation process description.
 * Can anybody share how they do it for their clients?

Viewing 4 replies - 1 through 4 (of 4 total)

 *  [Samuel B](https://wordpress.org/support/users/samboll/)
 * (@samboll)
 * [16 years, 12 months ago](https://wordpress.org/support/topic/install-multiple-databases/#post-1113777)
 * usually I install it on a folder on my server
    get it the way client wants download
   database dump install wordpress on client server import database edit database
   to reflect 2 new url’s done
 * more info here
    [http://codex.wordpress.org/Moving_WordPress#Moving_WordPress_to_a_New_Server](http://codex.wordpress.org/Moving_WordPress#Moving_WordPress_to_a_New_Server)
 *  Thread Starter [illufoxdesign](https://wordpress.org/support/users/illufoxdesign/)
 * (@illufoxdesign)
 * [16 years, 12 months ago](https://wordpress.org/support/topic/install-multiple-databases/#post-1113810)
 * This doesn’t answer my question. I know the steps, but I need to know specifically
   about the database installation.
 * I did some more research and I’m pretty sure that I will have to **manually**
   install WordPress into a subdirectory to avoid overwriting my existing database.
   This way I can create a new database from scratch naming it by the client for
   example. Am I right?
 * I also wonder if I move the site via the export/import feature in WordPress (
   see below) , if I have to worry about the database dump at all?
 * 1. Create an export file.
    2. Install WordPress on your new host. 3. Import the
   WordPress export files.
 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [16 years, 12 months ago](https://wordpress.org/support/topic/install-multiple-databases/#post-1113823)
 * “to avoid overwriting my existing database” is very simple.
 * Don’t use the same database as your other installs. Each WordPress installation
   has a wp-config.php. Just make sure you create a new database in cPanel, then
   use that in your wp-config.php file. Then in [phpMyAdmin](http://codex.wordpress.org/phpMyAdmin)
   when ‘restoring’ your backup from the other server just make sure you are IN 
   the correct database.
 * And yes you could do the export, install, import process, you just suggested.
 *  Thread Starter [illufoxdesign](https://wordpress.org/support/users/illufoxdesign/)
 * (@illufoxdesign)
 * [16 years, 11 months ago](https://wordpress.org/support/topic/install-multiple-databases/#post-1113953)
 * Ok, I know now that I can’t install via Fantastico as this will overwrite the
   current database.
 * I’ve never installed WordPress manually, but I just tried and everything worked
   as expected.
 * Here are the steps for anyone else in the same situation:
    - Create Database & User in Cpanel
    - Download WordPress files onto harddrive
    - Change wp-config file (add database name, username, password)
    - Upload files to client subdirectory on server
    - Go to [http://yourdomain.com/Clients/xxxxx/wp-admin/](http://yourdomain.com/Clients/xxxxx/wp-admin/)
    - Enter Blog Title (i.e. Client Company Name)
    - Email address: your email address
    - Click “Install WordPress”
    - Copy automatic username and password to clipboard
    - Login with automatic username and password
    - You will get to WordPress dashboard
    - Change password (recommended)
 * Voila, you’re set to start designing the theme for the client.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Install multiple databases’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [moving](https://wordpress.org/support/topic-tag/moving/)
 * [multiple](https://wordpress.org/support/topic-tag/multiple/)
 * [overwrite](https://wordpress.org/support/topic-tag/overwrite/)
 * [subdirectory](https://wordpress.org/support/topic-tag/subdirectory/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 4 replies
 * 3 participants
 * Last reply from: [illufoxdesign](https://wordpress.org/support/users/illufoxdesign/)
 * Last activity: [16 years, 11 months ago](https://wordpress.org/support/topic/install-multiple-databases/#post-1113953)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics