XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / XOOPS and SQL Connection
Register
1
ManXP
XOOPS and SQL Connection

  • 2005/7/9 8:58

  • ManXP

  • Quite a regular

  • Posts: 231

  • Since: 2003/8/14


I have one question about XOOPS and SQL connection.

If I have 2 websites (and I need to have 2nd website as main website mirror), I simply enter SQL host, user and password from 1st website to 2nd website and it takes all the data from 1st website, right?

Now the main question: If I make any changes on 2nd website, these changes will be applied to 1st website too, right? Because both websites use the same database...
2
Mithrandir
Re: XOOPS and SQL Connection

yep
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software
3
ManXP
Re: XOOPS and SQL Connection

  • 2005/7/9 13:22

  • ManXP

  • Quite a regular

  • Posts: 231

  • Since: 2003/8/14


Thanks Mithrandir,

Your answers are clean and useful as always.

And I think there is no way to make this:

2nd website uses its local database, but uses data for one table (yes, not for all tables!) from external SQL database?
4
Mithrandir
Re: XOOPS and SQL Connection

Quote:
And I think there is no way to make this:

2nd website uses its local database, but uses data for one table (yes, not for all tables!) from external SQL database?

You are - to my knowledge - correct.

This, however, is possible:
both websites use the same database, with different table prefixes. 2nd website uses the prefix of 1st website for one or more tables.
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software
5
ManXP
Re: XOOPS and SQL Connection

  • 2005/7/10 17:18

  • ManXP

  • Quite a regular

  • Posts: 231

  • Since: 2003/8/14


Great!

How can I make it work in real life? website2 must use table "xoops_wfdownloads_downloads" from website1 and all other tables should be used from local database.

What do I need to change?

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

399 user(s) are online (346 user(s) are browsing Support Forums)

Members: 0

Guests: 399

more...

Donat-O-Meter

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

Latest GitHub Commits