How to Use WordPress Database Multiple Places
WordPress uses MySQL databases for storing post, page and blog data for each WordPress blog. While it is a common practice to set up a separate database for each WordPress installation, you can use table prefixes to link to the same database for multiple installations. When you set up the WordPress installation in this manner, you can run multiple blogs and all of the data is stored in the same place.
Other People Are Reading
Instructions
-
-
1
Download the WordPress installation package from the WordPress.org website. Right-click on the downloaded file when the transfer is complete and click "Extract" on the context menu. Alternately, you can use your preferred file extraction tool to unzip the file.
-
2
Locate the "wp-config-sample.php" file from the unzipped contents of the installation package and open it in a text editor. Type your database information in the "database name," "database username" and "database password" sections. Save and close the file. Right-click on the file and choose "Rename." Rename the file to "wp-config.php."
-
-
3
Open your FTP software and upload the WordPress installation files to each blog site that will share a single database. Open the "wp-config.php" file through your FTP software once the upload is complete on each site, one at a time.
-
4
Create a unique table prefix for the section labeled "$table_prefix = 'wp_';". Replace "wp_" with a different prefix for each blog site. Save the file. Each blog will now use a single database with different prefixes for its data.
-
1
