Yes, multiple installations can share a single database.
When you edit the wp-config.php
file for each installation, you must give each install a unique table prefix.
The process is also explained in Installing Multiple Blogs: Single Database in Codex.
Related Posts:
- How to resolve ORA-011033: ORACLE initialization or shutdown in progress
- Oracle SQL query for Date format
- Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
- Can I have multiple primary keys in a single table?
- How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
- get_results using wpdb
- How to migrate a HTTPS WordPress installation to localhost?
- Database connection close
- How to monitor server for error establishing a database connection
- How to create bulk page and content? [closed]
- Importing posts from old website to new conflicting post ID’s?
- Connect to remote database using Localhost install
- remove missing image attachments
- Transient RSS feeds in wp_options not removed automatically?
- Best way to move live site local
- The revisions table in my database is at 70% capacity and growing. What should I do?
- WordPress for a very large website
- How to use multiple database in wordpress?
- How to ensure data consistency in WordPress
- Database location in WordPress
- WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
- WP_list_table bulk_action get edit and delete
- How to display data from custom table in wordpress database?
- Cloning and syncing a WordPress website
- How to execute mulitple statement SQL queries using $wpdb->query?
- Store and Encrypt Contact Form 7 Submissions in Database? [closed]
- Database with mixed collation (utf8mb4 & utf8_general_ci)
- WordPress database growing dramatically in size despite adding no new content
- Clean database from unused tables
- How wordpress accesses its own database
- Using table lock with wp_insert_post?
- Migrating database / content of non-CMS site to WordPress
- Should I remove transients from the wp_options table?
- Delete all post meta except featured image Using SQL
- Show last modified date of database
- What generates these very slow postmeta queries? [closed]
- How to migrate a website based on a custom database to wordpress?
- How to scan barcode and store data into a database [closed]
- Fetching values from database for select box
- WP CLI Core install – blank database
- fastest replacement DB
- Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
- Connection refused on locahost after importing database?
- When to use custom DB tables or add_option?
- Have working sql query… trying to adjust it to use $wpdb
- Best host for running large mem and processor intensive WordPress sites?
- Will there be any concern if I upgrade my current WordPress Database server from Centos 7 Mariadb 5.5 to Centos 8 Mariadb 10.3?
- In which format the data is stored in WordPress Databases?
- creating new field on mysql
- Does WordPress store the username as a primary key in the database?
- Strange characters added to the database
- Database Update Required – Update from command-line
- After database migration, theme mods don’t show [closed]
- SQL query to set posts in bulk based on the post content
- Automate WordPress website setup with prefilled data
- Remote database connection and local development
- Custom search query by category id
- Website displays old version of page
- Image link issues after importing a database backup to my local web server
- multiple wordpress installs w/shared user database but separate content databases
- Fetch a single row from a custom table for to a given ID
- Database create or redirect
- Updating seperate database when post attachment is changed
- add featured image dialog box disappear
- Displaying table data on a page
- muliple wordpress installs (network) on different databases
- Database structure cheatsheet
- WordPress Database – wp_usermeta and the correct number of session_tokens rows
- How to get a list of articles related to a particular category from my other WordPress website?
- Whats the best practise on how to store json data from a custom settings page?
- /wp-admin not accessible after migrating to local host (no plugin issue)
- Job and Employee Performance Tracking with Product Safety
- set_transient fails if the value has more than 60.000 characters
- A WP dev site that displays content from a live site’s database but cannot write to wp_posts?
- error establishing database connection (WAMP + filezilla)
- Is there a way for two deferent themes to consume two different DB on a same WP instance?
- Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
- How to optimize wp_option table?
- How do I update a WordPress wp_postmeta meta_value that contains many options
- How can I get $wpdb to show MySQL warnings?
- About wp database hooks (error establishing connection)
- Database for JQuery Autocomplete field
- Auto populate form fields based on serial input or pull listings from other websites?
- How to extract some part of WordPress full source code
- Create Tables in WordPress
- Catchable fatal error in formatting.php
- Error establishing a database connection for some files
- Hash user emails in database?
- WordPress Failed to Login (DB Error)
- Share WordPress Database
- DB access blocked when initializing WP externally
- Saving data to database and exporting to excel
- Site does not work right, pages not showing up, even for root admin
- ERROR: “Table Prefix” must not be empty
- How do you build a database-centric site in WP?
- One information repeated on multiple locations on one site [closed]
- WordPress: Interact with Database Query Data and Login
- Attach posts based on category and position
- Showing Error(TAble already exist)
- Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]