If you create your Joomla site locally and need to upload it to the server, then follow the steps mentioned below
1) Upload files from your computer to a server
- Make sure that configuration.php has the right settings for the server (especially: localhost, database, database user, database password, log_path, tmp_path)
- Use FTP software (e.g. FileZilla) to connect to the server
- Select the directory you want to upload, and to where (mostly to /public_html/ )
- Right click + select files/folder to upload, or drag + drop the folder from the "Local site" view to the "Remote site" view
- The uploading of the local files to the remote server will start
- After you've uploaded the files, check the "Failed transfers" to see if there weren't any errors
2) Copying the database with phpMyAdmin
The phpMyAdmin tool can be used to export and import a database, providing a simple way to duplicate a copy of a database using a different name on our servers.
Exporting your database to your computer
- Login to the database that you want to duplicate using phpMyAdmin
- Click the database name on the left-hand side of the page.
- Select the Export tab
- Select the Save as file option
- Click Go
You'll then be prompted to save the database file on your personal computer.
Importing the copy into a new database
A) You'll first need to create the new, empty database on your server using the account control panel (cPanel >> MySQL Database . Please Read http://secure.webhost.lk/knowledgebase/38/How-do-I-add-a-mysql-database-in-Cpanel-.html)
B) After the new database has been created:
- Login to cPanel >> PhpMyAdmin
- Click the database name on the left-hand side of the page
- Select the Import tab
- Click the Browse button under "File to import", then select the database file from your computer
- Click Go to import the database
Hint: If you see a "No database selected" error, it's probably because you forgot to first click on the database name in the left-hand column.
3) Changing configuration.php
In order to get Joomla to work on the new server, you should make the necessary changes in configuration.php to reflect the new server settings. You should check/edit the following to
-----------------
var $host = 'localhost'; // usually "localhost". If it's different for your server then your hosting provider should be able to tell you that.
var $user = 'the_db_username';
var $db = 'the_databasename';
var $password = 'the_db_password';
var $live_site = ''; // is usually empty.
-----------------
Please read : http://secure.webhost.lk/knowledgebase/39/What-is-the-mysql-host-name-and-connection-.html
