Quick Tutorial on how to install Joomla! on your local computer, then how to move your Joomla! to a live server environment once your finished designing and developing it. In a nutshell, here's what we're doing.

1. We'll download and Install a stand-alone server enviroment (PHP,MySQL,Apache), pre-packaged with a full version of Joomla!
2. We'll show you how to access your Joomla! site, and the admin area of the site.
3. You'll then build your site…
4. You'll then transfer your database and site directory.
5. The configuration file will need modification.
6. That's it, you're up and running.

Tools we'll be using:

• JSAS - Stand alone server environment, pre-packaged with PHP, MySQL, Apache, and of course… Joomla!
• FileZilla - FTP Client
• Moovla - PHP File that helps modify the configuration file after we've transferred the site

        Download - For your convenience, we went ahead and packaged all of these tools together in one handy Download . Step One:

1. Unzip the Tools.zip file
2. Install JSAS
3. Once you've installed JSAS, run the program
• When you install JSAS, you'll see that a new Drive has appeared under "My Computer." This is where your directory and your data are located. Keep this in mind.
4. Access your site by going to http://localhost:85/joomla (site) and http://localhost:85/joomla/administrator (admin)
1. The Joomla! user/pass is defaulted to:  admin/admin

       *Note: JSAS allows you to have several Joomla! installations… for this demonstration, we'll be using the default, pre-installed Joomla! site, at http://localhost:85/joomla, and using folder 'joomla.'         To create new installations:

1. open the JSAS control panel
2. Click 'Admin'
3. Click 'My JSAS'
4. Click 'Create a new site'
5. Name your site,  folder name, and database
6. From there, click 'Advanced Options'
7. Click 'Install Joomla.'
8. From here, you'll be guided through the Joomla! installation

       *Another Note: Get familiar with the JSAS control panel. It has several additional tools that we'll be using later. For more information on using JSAS, go here:     http://jsas.joomlasolutions.com/docs/myjsas.htm Step Two: Build your Joomla! site. Unfortunately this tutorial isn't about building the site… It's simply to teach you how to build locally and then move your site to the live server environment. Step Three: Preparing your files and exporting your database.  When you get here, we assume you're happy with your site and you're ready to make it 'LIVE!' FILES

1. Go to your root installation folder: Start > My Computer > Local Disk (W:) > www > joomla >
2. Drag 'moovla.php' into the /joomla folder (moovla.php is included with the Download )

DATABASE EXPORT

1. Open the JSAS console
2. Click 'admin'
3. Click 'PHP MyAdmin'
4. Locate your database in the dropdown, on the left side of the screen, select your database.
• *If you don't remember the name of your database, go to the admin area of your Joomla! site, click 'Site > 'Global Configuration. Then click on the tab named 'database.' You'll see the database name there.
5. Click Export
6. Be sure to 'Select All' tables in the database. You'll be exporting as a SQL file.
7. Be sure to check the box asking if you'd like to save it as a file.
8. Click 'Go' - save the file to your desktop

Step Four: Accessing your server Included in the Download was an application called 'FileZilla.' This is a great FTP client that will allow you to easily access your file system on the live server.

1. Install FileZilla
2. Create a new account, from within FileZilla
• The host will be the name of your website… Example: www.openjason.com
• username: Check with your host for this information
• pass: Check with your host for this information
3. Once you've gained access, locate a folder named 'public_html,' or 'www.' (These two folders go to the same exact place… 'www' is just a shortcut)
4. Clear out the 'public_html' directory. Often times there'll be some files and folders in this directory… you don't need them, delete them.
5. Now we'll move the site files over to the live server. Go to JSAS > Click 'Browse' > Locate and open the folder we named 'joomla'  - These are all the site files belonging to your Joomla! site.
6. Press CTRL-A, or right click > Select all - this will highlight all files and folders
7. With FileZilla open, and in the 'public_html' directory, drag all of the highlighted files into FileZilla. This may take a few minutes… you'll see the files moving over.

Step Five: Creating and Importing the database (if you're not that familiar with creating a database, talk to your host)

1. Create a new database - Go to your cPanel and create a new 'MySQL database.' If you're not using cPanel, ask your host how to create a new database and how to access phpMyAdmin.
2. Go to phpMyAdmin. There should be a link from within your cPanel, or whatever software you're using.
3. On the select menu, select the database you have just created. (left side of the screen). Now, NOTE that the database will now have a prefix on it. Probably something like (accountname)_databasename. The same applies to the MySQL username… For me, the database name would be: openjason_joomla. This is because I initially named the db 'joomla,' but the system attached on my account name and an underscore before the db name.
4. Go to 'import' on the top menu links
5. Browse for the database file you saved on your desktop
6. Install the database

Your database should import without errors into the newly created database. Step Six: Modifying the configuration file. Almost done! Now we have to change the configuration file in the root directory of your joomla site. This can be done manually, or it can be done using moovla.php.

1. Open firefox and type: www.(yoursite).com/moovla.php (remember, we added the moovla.php file to the root directory a while back)
2. Enter the information… please note that you have to have the correct database name, user, and password. This was all defined in Step Five, creating a new database.
3. Click 'Submit Changes'
4. We're done! I'm open for questions here… please comment and I'll happily reply! Also, the video demo is soon to follow.

Tags: joomla, development, open source, tools, openjason, daynger