A MySQL DB within a MySQL DB

When you run the wordpress installation script, on step 5 of the famous 5 minute install https://codex.wordpress.org/Installing_WordPress#Step_5:_Run_the_Install_Script … use the same Database Credentials as the existing site, but use a different prefix for the tables.

The default prefix is “wp_” make it something like “my_” and that’s it.

(You’ll see it says, “If you want to run multiple WordPress installations in a single database, change this.)

enter image description here

Related Posts:

  1. Rename a table in MySQL
  2. How should I tackle –secure-file-priv in MySQL?
  3. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  4. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  5. Using wpdb to connect to a separate database
  6. Checking if Database Table exists
  7. The MySQL alternatives: Do Percona Server and MariaDB work well with WordPress, and do they make WordPress go better?
  8. How to fetch Data in WordPress using MySQLi or $wpdb
  9. Connect to database using wordpress wp-config file
  10. wpdb->insert multiple record at once
  11. How To Export/Import WordPress (MySQL) Database Properly Via Command-Line?
  12. How to define composite keys with dbDelta()
  13. Is it possible to define two databases for one installation?
  14. Does WordPress use the InnoDB engine for MySQL by default?
  15. WordPress for a very large website
  16. WooCommerce with thousands of products – site is very slow – optimize db queries? [closed]
  17. Huge wp_options table
  18. “MySQL server has gone away” since update to 3.8
  19. Error establishing a database connection – with Debug Data
  20. How to execute mulitple statement SQL queries using $wpdb->query?
  21. Can I transfer a mysql database to another site?
  22. Database with mixed collation (utf8mb4 & utf8_general_ci)
  23. MySQL Syntax Error upon restoring database from backup [closed]
  24. Help running a MySQL query to update all wp_#_options tables in a Multisite install
  25. Set Display Name to first and last name (phpmyadmin SQL Query)
  26. Is it safe to convert tables from MyISAM to InnoDB?
  27. Emojis getting converted to “?”
  28. Migrating database / content of non-CMS site to WordPress
  29. Does WordPress ever need multiple databases?
  30. Why are no posts showing despite my apparently correct DB restoration?
  31. Delete all post meta except featured image Using SQL
  32. How do I properly update the WordPress database password?
  33. wpdb_prepare with multiple or condition
  34. Adding new row to wp_post table
  35. WordPress Install and Database on separate hosting?
  36. SQL Error wp_commentmeta – incorrect table definition
  37. WordPress database error – Error in SQL syntax – I can’t identify any error?
  38. WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
  39. How do I get the posts within a certain year/date(with sql query)?
  40. Using GROUP CONCAT in my-sql query with wp_usermeta table
  41. Create table from array with prepare
  42. Unable to set a default serialized array using dbdelta()
  43. How to prevent/delay MySQL connections when an object cache is used?
  44. Migrating from PDO using SQLite to clean new install using MySQL
  45. Call to undefined function get_user_meta() – trying to access data in MySQL from custom fields
  46. Duplicated site isn’t recognized as a site
  47. Have working sql query… trying to adjust it to use $wpdb
  48. Error establishing a database connection,
  49. Changing root password in PHPMyAdmin for WordPress Database when going live
  50. How to properly check if a table exists in WordPress Database using Show Tables Query
  51. Can’t update WordFence Options, clear data manually
  52. Changing between Local Host DB to Production DB and in reverse
  53. creating new field on mysql
  54. How and where is wordpress adding mySQL content to database?
  55. Why does changing Database Table Prefixes result in loss of content?
  56. SQL query to set posts in bulk based on the post content
  57. Query Column of Specific ID from Database Table
  58. How can I detect right db type?
  59. How to create more than one new wpdb object?
  60. Files on Localhost, Database on Server
  61. Remote database -> massive response time increase?
  62. Second ezSQL initialization for MSSQL
  63. Fetch a single row from a custom table for to a given ID
  64. Database create or redirect
  65. Getting “Error Establishing a Database Connection” on localhost in new Mac OSX Lion environment
  66. Cloning blog to localhost via WAMP
  67. Counting post and changing roles in mysql database. Query not code
  68. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  69. DB prefix not updating
  70. Recovery – Restore Database after moving folder location locally
  71. Replacing javascript link in WordPress database without getting mysql syntax errors
  72. I imported an restore an database and It shows #1067 – Invalid default value for ‘user_registered’
  73. How to edit custom table data in frontend
  74. local wordpress broke after changing URL
  75. how to access 2nd Mysqli Database from different server for wordpress
  76. Error establishing a database connection – WordPress setup, everything else is working
  77. Exporting Post ID, Post Title, Primary Category and Primary Category ID
  78. How to map data on CSV to web pages?
  79. How to create index (sql) to a meta_key?
  80. Search and Replace in Windows XAMPP site
  81. WPCLI search and replace in a particlar site dir effect another site-dir
  82. How can i syn wordpress user table with a stand-alone php script?
  83. insert data from a form:: Warning Empty query mysqli::query()
  84. How can I get $wpdb to show MySQL warnings?
  85. After renaming MySQL database, I can no longer access my Blog page
  86. WordPress Database Posts Table query
  87. Hang Up Followed By Can’t select database
  88. How to extract some part of WordPress full source code
  89. Mysql Queries per Visit – Crazy High
  90. Create a new table on the database and save parameters from a contact form
  91. Why is converting my database to UTF-8 truncating entries?
  92. using same mysql user with many databases
  93. Why are my WordPress post queries so slow?
  94. How to back-up a database on IIS
  95. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  96. export individual posts to text files or a single csv file
  97. Custom wordpress SQL statement for a website
  98. WordPress database connection failed, while mysql client is working [closed]
  99. Uploading to WordPress Database
  100. Have WordPress Use a Different Database for users