NYCPHP Meetup

[David A. Roth]

The intention here is not to share the Joomla database with another
instance, but to keep them separate. If the MySQL database created has its
own name to match the instance, then this would prevent each instance from
interfering with another which is the objective. The purpose is to have
these instances behave as if they were on totally different machines with no
relationship to each other. Here is a detailed example:
www.example.com/website1 with a Joomla directory name of website1 using a
MySQL database name of website1_db, website1_usr for the MySQL account to
access it, with a table name of ws1_ (instead of jos_).

www.example.com/website2 with a Joomla directory name of website2 using a
MySQL database name of website2_db, website1_usr for the MySQL account to
access it, with a table name of ws2_ (instead of jos_).

Creating a different table name for each instance so there is no mistake in
what is being referred to.

The above is how I have been doing this where I have several instances of
Joomla on the development server so I can keep a demo instance, development
instance and a staging instance. I then use the Joomla backup component,
JoomlaPack, to easily move an instance to another server.

You have given me an idea. If someone has several related Joomla instances
where there was a need to share the user registrations amongst them, then
what you are suggesting would be useful, although I've not done that myself
yet.

David

On Thu, Dec 11, 2008 at 10:21 PM, <masimko at verizon.net> wrote:

> T
> MIME-Version: 1.0
> Content-Type: text/html; charset=UTF-8
> Content-Transfer-Encoding: 7bit
> X-Originating-IP: [208.54.90.35]
>
> <html><head>
>
> <link media="all" type="text/css"
> href="/webmail/static/deg/css/wysiwyg-4096788580.css" rel="stylesheet">
> </head><body>
> <br>Joomla is self-contained within the directory it is installed. The
> only<br>external requirement is the MySQL database which simply needs to
> have a<br>different name for each Joomla installation to keep them totally
> separate.<br><br>Not entirely accurate. Joomla sites can share a database if
> the table prefixes are different.<br><br>The default prefix is jos_. If you
> are sharing the mysql database with another instance of Joomla!,<br>set the
> prefix to something other than the default in the installation
> dialog.<br><br>I've put Joomla below the top level in one website during
> testing and transition, and set the home<br>menu link to point up one level
> in the directory structure out of the Joomla! system.<br><br>I've also put
> SugarCRM and phpGroupware below Joomla! in the directory structure, but
> without trying<br>to link to them from the Joomla! menu.<br></body></html>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/joomla/attachments/20081212/6203aa6c/attachment.html>