Joomla and Directories

[DavidJames]

I installed Joomla in directory called Joomla. I want to create a subdomain for the new site but I don't want to redirect to the Joomla directory. I would like to copy the Joomla directory to one called homestead. Then create a subdomain pointing to homestead.

1. Any suggestions on the easiest way to do that?
2. Would that screw up the Joomla site

Does anyonen have a better solution. I intend to create other subdomains with other "instances" of Joomla so I'll be doing this more. I would like to use this "base" Joomla website for other sites.

[nerdykit]

I installed Joomla in directory called Joomla. I want to create a subdomain for the new site but I don't want to redirect to the Joomla directory. I would like to copy the Joomla directory to one called homestead. Then create a subdomain pointing to homestead.

1. Any suggestions on the easiest way to do that?
2. Would that screw up the Joomla site

Does anyonen have a better solution. I intend to create other subdomains with other "instances" of Joomla so I'll be doing this more. I would like to use this "base" Joomla website for other sites.

I can't speak for other ftp clients but I did a lot of folder copying using Fetch by opening up two connections and then creating the new folder that I wanted and just dragging stuff from one folder to the other. ie: one ftp window to the other ftp window Can't speak about the change in the Joomla folder name. Why not test? Rename the existing Joomla folder, and test... does it still work? You can always rename it back to joomla again.

[shadmego]

As far as I know, you cannot have one base installation of Joomla power multiple subdomains. Because of the way the program is set up, each installation of Joomla needs to be powered by its own configuration file and database. If you want to use Joomla in multiple directories, you will have to install it in each one, or play with the wrapper funtion in the main installation. This second choise will produce some unwanted results though, as it is simply a "frame" to load external sites into.

You might want to ask the experts (http://forum.joomla.org) though, as they will be able to answer you more fully.

~regards,
Shadmego

[DavidJames]

Thanks for the tips.

For future reference, here is where I found the answer. It's pretty simple:

http://forum.joomla.org/index.php/topic,5556.0.html

[DavidJames]

Thanks for the tips.

For future reference, here is where I found the answer. It's pretty simple:

http://forum.joomla.org/index.php/topic,5556.0.html

The results weren't what I expected. Any idea how to install a second instance of Joomla including a new database? I saw a suggestion on the Joomla forum to use "a different prefix per installation", anyone know if that's possible with Fanstastico?

[shadmego]

The best way to do this is to create a brand new database for the new installation of Joomla.

Sign into CPanel and navigate to the MySQL database section near the bottom of the page.

Create your new database, username/password and attach your user to the new database. For the names, I would name them something similar to the second installation. For instance, if you are installing your second Joomla database for a subdomain named foo.yourdomain.com, then name your new database account_foo (Hostmonster appends the "account_" part automatically).

Doing this will help separate your installations and make managing them easier.

When you go to install the new instance of Joomla, you will simply point the script to use the new database (account_foo) instead of the old one.

I haven't installed Joomla using Fantastico in awhile so I'm not familiar with the steps involved, but you should be able to name your database for the installation.

PM me if you need more specific help.

~regards,
Shadmego

[DavidJames]

The best way to do this is to create a brand new database for the new installation of Joomla.

Sign into CPanel and navigate to the MySQL database section near the bottom of the page.

Create your new database, username/password and attach your user to the new database. For the names, I would name them something similar to the second installation. For instance, if you are installing your second Joomla database for a subdomain named foo.yourdomain.com, then name your new database account_foo (Hostmonster appends the "account_" part automatically).

Doing this will help separate your installations and make managing them easier.

When you go to install the new instance of Joomla, you will simply point the script to use the new database (account_foo) instead of the old one.

I haven't installed Joomla using Fantastico in awhile so I'm not familiar with the steps involved, but you should be able to name your database for the installation.

PM me if you need more specific help.

~regards,
ShadmegoFantastico automatically creates a new database for the new installation, so I think I'm good. Now if only there were an easy why to "copy" my old database into the new one :)

[nerdykit]

Fantastico automatically creates a new database for the new installation, so I think I'm good. Now if only there were an easy why to "copy" my old database into the new one :)

You can use phpMySQL to export the data from the old database as an SQL file, then create the new database and import it. phpMySQL has the option of including the 'create tables' lines so that all you have to do is create the database and when you import the SQL file, it creates tables in the new database and populates them with the data.

phpMySQL is a totally cool tool for working with mySQL databases. It is your friend.

Kit

[DavidJames]

You can use phpMySQL to export the data from the old database as an SQL file, then create the new database and import it. phpMySQL has the option of including the 'create tables' lines so that all you have to do is create the database and when you import the SQL file, it creates tables in the new database and populates them with the data.

phpMySQL is a totally cool tool for working with mySQL databases. It is your friend.

Kit
Thanks, one question. I assume when Fantastico installs Joomla, it creates the database, along with the creating the tables and other objects. Would there be any issues with importing the export under that scenario?

[shadmego]

No. Once the tables are created, no matter how they are created, you can export/import them at will. The only problem you will run into is saving the username/password that goes with the database. These are not exported my phpmyadmin, or CPanel.

[DavidJames]

No. Once the tables are created, no matter how they are created, you can export/import them at will. The only problem you will run into is saving the username/password that goes with the database. These are not exported my phpmyadmin, or CPanel.
Ok, those are created when I install Joomla so looks like I should have a go and test it out.

Thanks everyone for you help.