1
Drgn2480
Sharing one mySQL database between multiple xoops sites
  • 2004/5/29 14:59

  • Drgn2480

  • Just popping in

  • Posts: 1

  • Since: 2003/8/6 1


Hi;

I've looked at the threads concerning multi-sites (multiple sites, multi sites, etc.), and none of them really address what I'm trying to do, so here it is;

I have an account with a host, and I have two mySQL databases included in my plan. I want to run three or four XOOPS sites, and they are to be completely independent sites, no sharing of any tables or data. I'm just trying to avoid buying additional mySQL databases if it isn't necessary.

It seems to me that multiple XOOPS installations could use the same mySQL database so long as the prefix is different, as in "site01-" and "site02-". That is the approach I am taking by the way, multiple XOOPS installs in different directories, but sharing the same database.

I've tried to do this already. I set up my first XOOPS site, and it works fine. Then I set up the next XOOPS site in a different directory, using a different prefix (I left the first site using the prefix "xoops"), and it installs fine. Checking the database with phpMyAdmin, and the tables from both sites are there. The installation of the second site completes, I can login to the second site, and this is where the problem starts; the site will load, and then I get the "This is your first time administering...", and I can't get past that point. The first site continues to work properly, and the second site works so long as I don't attempt to administer it.

Any thoughts? I haven't edited any mainfile.php or database.php files.

-Drgn2480




TopTop



Login

Who's Online

217 user(s) are online (155 user(s) are browsing Support Forums)


Members: 0


Guests: 217


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits