First you should know that your Joomla application (portal) consists of two components: Joomla files and Joomla database.

• The files and folders of your Joomla application contain the scripts and core application code.
• The Joomla database contains all records for your website such as your site sections, categories, articles, etc.

Let's assume that you are running your own *LAMP or *WAMP webserver or you have a hosting account with another company. You should know the root directory where your Joomla installation resides. It is often called httpdocs, public_html or www. Those are the so-called web server root directories. So let's suppose that your Joomla application in installed under your web server root directory.

The first thing you have to do when you want to transfer your Joomla applications to your SiteGround server, is to copy the entire content of your web server root directory straight into the public_html folder of your SiteGround hosting account.

If you are running your own server probbably you have already had your Joomla site files on your hard drive. In case you are hosting your account on a remote machine, simply download your Joomla site files and directories (please mind that you should keep the directory structure in tact) on your desktop PC by using your favourite FTP client. (Please, find here how to backup your Joomla site.)

Once the download is finished, please connect to your SiteGround FTP account, change your current working directory to the public_html one (this is the root/main folder for your website) and drag and drop your Joomla files and folders from your desktop PC to your public_html folder.

Well done! We are now ready with the upload of the Joomla files and they are already on your SiteGround FTP account.

The next step you should follow is to create a full dump of your Joomla MySQL database. If you are running your own *WAMP or *LAMP server probbably you already have the phpMyadmin installed. If you are using different web hosting provider they should provide you with access to a database manipulation tool. Please ask them for further assistance. Here we suppose that you are manipulating your databases by using the phpMyadmin tool as it is the most popular tool for administrating MySQL databases.

Once you are logged in into your phpMyadmin tool, backing up (exporting) your database is simple. First choose your database from the left menu. Then click the Export tab. Select all the tables, check Add DROP TABLE and Save as file. Leave all other options untouched. Finally click on Go and the database dump will be downloaded to your PC. (Please, find here how to export your database.)

We are done with your Joomla database backup and you should already have it downloaded on your hard drive. The next step we should take is to import your database dump to your SiteGround FTP account.

To do that, please, go to your cPanel area and create a brand new database with a name of your choice. Please mind that you can create databases only from your cPanel area. You cannot execute CREATE database; MySQL statement from the phpMyadmin tool. Once you've created your new database, please create a new database username and add it to the database you have created during the previous step. For detiled instructons on MySQL database creation please refer to the video tutorial for creating MySQL database and user in cPanel.

We assume that you have created your MySQL database and the next step is to go into your SiteGround phpMyadmin interface.

To restore (import) a database in phpMyAdmin, first choose the database you'll be restoring from the left menu. Then please click the SQL tab. You have the option of importing a .sql file. Use the “Browse” button to find it on your pc and then click “Go” at the bottom.

If you receive an error message which says access denied, please open the database dump file you have downloaded on your desktop PC with your favourite text editor and look for lines that may contain CREATE database db_name; and/or USE db_name; mysql statements. If you find any simply delete them and try to re-import the dump. If you ran into troubles our friendly technical support team is available 24/7/366 and ready to help you.

Here we go. The final step is to adjust the core settings which are defined in your main Joomla configuration.php file. Go to your SiteGround File Manager, change the curent working directory to public_html and if you have followed the steps  mentioned above correctly you should be able to easily locate configuration.php file in there. Open it for editing.

Below are the main variables you need to adjust so they can fit to your new SiteGround hosting enviroment:

$mosConfig_host = 'some.host.com';
$mosConfig_user = 'some_db_user';
$mosConfig_password = 'some_db_password';
$mosConfig_db = 'some_db_user';
$mosConfig_absolute_path = '/path/to/your/joomla/root/folder';
$mosConfig_live_site = 'http://url.to.your.joomla.site.com';
$mosConfig_cachepath = '/path/to/your/joomla/root/folder/cache';

Examples provided above are the core Joomla configuration variables you have used with your desktop/home LAMP/WAMP server or with your previous host.

In order to make your Joomla site runs on your SiteGround account you should adjust them as follows:

$mosConfig_host = 'localhost';
$mosConfig_user = 'yourSGusername_mysqluser';
$mosConfig_password = 'the_password_you_have_defined_during_the_mysql_username_creation';
$mosConfig_db = 'yourSGusername_mysqldb';
$mosConfig_absolute_path = '/home/yourSGusername/public_html';
$mosConfig_live_site = 'http://your-siteground-domain.com';
$mosConfig_cachepath = '/home/yourSGusername/public_html/cache';

Please mind to replace yourSGusername_mysqluser with the MySQL username you have created during the database setup process mentioned above. This also aplies for the password for this username and for the database name. You should also replace yourSGusername with the username you are using for your SiteGround cPanel area.

$mosConfig_live_site is also essential and you should put the domain name you are using with your siteground hosting account there.

If you have correctly followed the instructions mentioned above and your domain name propperly points to the DNS servers of your SiteGround hosting account you should be able to see your Joomla portal .

*WAMP HTTP Server with Windows, Apache, MySQL and PHP
*LAMP HTTP Server with Linux, Apache, MySQL and PHP

For more information, please visit our Joomla tutorial.

Note: This above instructions are for Joomla 1.0.*. In order to migrate a local Joomla 1.5 please follow these instructions.

I finally learned how to change my default Stumbleupon password. I think the Stumpbleupon user account page sux!

Anyway, I googled for how to change stumbleupon password and followed a link to Yahoo answer which points you to StumbleUpon Help page!

Here’s my version of a Simple 3-Step Guide on How To Change Stumbleupon Password:

1. Go download the StumbleUpon Toolbar

2. Install toolbar and look for the Tools drop-down menu

3. Select Change Passwords…