Posted 2 years ago #
My ISP does not allow you to create two DB in an instance of MySQL so when I originally set up SMF it had to go in another separate instance. The stupid thing is that instance was also on a different server. Anytime you tried to add a user or re-sync users in WP there would be an SQL error.
Resolved the error by moving all the tables into the existing WP DB.
Nice thing about WordPress is the ability to use a different $table_prefix in the wp-config.php file so you could literally have hundreds if not thousands of WordPress blogs in one MySQL database. That also means, if your host limits you to one database, you can likely install other software packages as long as there is some unique naming mechanism (such as $table_prefix).
Resources:
Installing_Multiple_Blogs
Editing wp-config.php
This topic has been closed to new replies.
