WP takes care of all of the database table creation for multisite installs. Forget about the second database you created.
As far as making sure that all user accounts are shared with every sub-site, look into a plugin like Multisite User Management.
Thats the problem, that multisite does nothing for me.
The users are not shared.
I do see the sites in my dashboard, but if I register now for example a new user, I’m not able to log in on other site.
The plugin I linked to will take care of your issue.
Well, I did what you’ve suggested.
Now if I go and check all my users in the network, I see they appeard under both sites.
If I go to my second site, I cannot login.
I will show you my website:
http://ugot-it.com
(it’s in Hebrew). This is the main site, now I’m releasing English version, which is located in a sub-folder:
http://ugot-it.com/eng/
First of all, how do I know that the first link is registered in network as my main website and the ENG sub folder as sub-site.
How do I force the ENG sub-site to read the users from my main Data Base?
I remind you that I’m using separate DB’s for each site (not 1 DB with prefixes).
I really hope you or someone else will help.
how do I know that the first link is registered in network as my main website and the ENG sub folder as sub-site.
Because all your subsites will be domain.com/SUBSITENAME
That’s how we know 🙂
How do I force the ENG sub-site to read the users from my main Data Base?
I remind you that I’m using separate DB’s for each site (not 1 DB with prefixes).
Then you’re not using Multisite. Multisite uses one database for a million sites 🙂 No prefixes needed, it will make new tables like wp_2_options and so on.
But since you’re not using Multisite, none of the advice here will help.
So you suggesting me to re-create my data base, re-install the sites using the main DB but with different prefixes and then re-enable the multisite?
No. I’m suggesting you remove your eng site, and on your main site, just activate multisite.
No extra install needed. WP takes care of it.
OK, maybe I missed something but if I remove the ENG site (completely deleting it), activing the multisite, how will it create the ENG site automatically? The main site is in Hebrew, while the ENG site supposed to be in English.
I noticed that multisite created new table in my main DB (wp_2 prefix, so I guess it was made for the second site).
The second option is to edit my ENG wp-config.php file and connect it to my main DB using the new prefix that the multisite created for it. :/
Read http://codex.wordpress.org/Create_A_Network
I’m telling you this: Create a multisite network.
Otherwise you aren’t using multisite at all, and are in the wrong forum section 🙂
Delete the eng folder.
Then turn on multisite in your main install.
Add the subsite within multisite for ENG
Have a beer 🙂
I promise, it’s just that easy!
Easy for you 🙂
If I delete the ENG folder, how will the ENG subsite will be as English version?
Let’s say I delete now the ENG folder in my ROOT folder, no more English version, just the main Hebrew version.
I enable the multisite.
Then I log in to the main dashboard again, going to sites, and adding a new site.
I just did it, and now if I browser http://ugot-it.com/eng , it shows nothing, because the files doesn’t exist there anymore (I deleted them).
Also when I added another site, I see in my DB new tables for the new site with a new prefix. I don’t need new prefix.
Currently I restored my ENG folder and the database.
For some reason, my multisite doesn’t work as it should.
If I delete the ENG folder, how will the ENG subsite will be as English version?
Because you will re-create it.
However I think what you’re trying to ask is this ‘How can I import my existing ENG instance to Multisite?’ (You hadn’t actually told us you’d already made the ENG site, just that you were going to.)
Answer: Create a Multisite Network. Make a site called EN2 (the length of the folder matters, we’ll get to why in a second, it just has to be the same as your current folder). Export from eng, import into en2.
Then. Delete ENG.
Go back into EN2 and rename it to ENG. Search your DB for EN2 replace with ENG and you’re done.
Just nothing!
I did what you asked me to do and nothing!
And it is logical that it does nothing, because the ENG wp-config.php file contains different DB server information, so it keeps on reading that usrers from that DB and not from the main DB.
Multisite does not configure the wp-config files!
The alternative solution which solves my problem is using the same database server and the sable table, but with additional prefix.
And then adding these lines to my wp-cnfig.php:
define(‘CUSTOM_USER_TABLE’,’wp_users’);
define(‘CUSTOM_USER_META_TABLE’, ‘wp_usermeta’);
But again, this is the last option I would like to use if I will not set up multisite.
No…
You’re … okay look, we’re talking about replacing the ENG you already made with a new site, right?
So step one is to make the new site. Step two is to export ENG and import it to the new one.
Have you already made the main install a multisite, and have you created a subsite with a temporary name?