How do you copy a joomla site from localhost to a remote host?

When you are first trying out Joomla!, it is often recommended that you install it on your local system. (e.g., “localhost”), for example with XAMPP, and get your site running locally. Eventually you may want to copy this site to your remote host.

Fortunately, this is easy to do. This article assumes you have installed Joomla! 1.5 on your local computer, you have created a website and you now wish to copy this website to your remote host. Here are the steps:

1, Create a Place on Your Remote Host to Install Joomla!

If this is a new site, it will just be your home directory. If you have an existing site, for example www.domain.com, that you wish to keep while you work with Joomla!, you may be able to create a subdomain, for example, www.domain.com/subdirectory to hold your Joomla! site.

2, Copy Files and Directories of Your Local Joomla Directory to the Remote Host

You have two methods:

a. Upload all files by FTP or
b. Upload only a compressed file by FTP

a, Upload all Files by FTP

Normally, the easiest way to copy these files is using an FTP client program, such as Filezilla.

Select all files from directory localhost (with XAMPP, the directory will be xampp/www/directory) and upload to the remote host HTML directory for a domain, or to the remote host HTML subdirectory.

b, Upload a Compressed File

Copying a large number of individual files using FTP can sometimes be unreliable. If you have command-line access to the both source and destination systems you can create a compressed archive file containing all the files on the source system, then transfer that single file to the destination system where it can be decompressed.

Creating an archive file

On Unix-style systems (eg. Linux) you can use the gzip program to create .zip files, or the tar program to create .tar.gz or .tar.bz2 files. For detailed instructions type man gzip or man tar at the command line. For example,

tar cvfz joomlabackup.tar.gz /path-to-joomla

will create a gzip-compressed archive file, called joomlabackup.tar.gz, containing all the files in your Joomla! installation. Important note! You need to make sure you are NOT in the folder you are trying to backup when you run the tar command or you will create an endless loop.

Extracting an archive file

Having copied the archive file to the destination system, you now need to unpack it. Use the equivalent command that you used to create the archive file. For example, to unpack the archive file created in the example above, enter

cd /path-to-joomla
tar xvfz joomlabackup.tar.gz

If the user or group IDs are not the same between the source and destination systems, then you will need to amend the ownership of the files you just extracted. For example, on an Apache system, you might need to enter the command

cd /path-to-joomla
chown -R www-group.www-user *

Copy the Contents of Your Local MySQL Database to the Host MySQL Database

In Joomla!, all the contents of the site (articles, menus, users, and so on) are stored in the MySql database. You need to copy this information to the host database. This is done by creating an export file on your local system and then importing this file into your host MySQL database, as follows:

1. Open phpMyAdmin on your local system by navigating to it’s URL with your browser. On your local system, this URL will normally be “//localhost/phpmyadmin”. Note: If you have a password on your database, you will be prompted for it.

2. The phpMyAdmin screen will display as shown below. Select the Export link. Select the database you want to export in the upper right-hand list. In the example below, the database “joomla15” is selected. Keep all of the default options, including “SQL” as the export type.

Check the “Save as file” box at the bottom of the screen, and enter the name of the export file.

Press the “Go” button in the lower right corner. An Open / Save / Cancel dialog will display. Press Save and select a folder to save the file in. The export will complete and the file will be saved in the chosen location.

Open up the phpMyAdmin on the host server > 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 > At this point you have installed the database.

If you want to create a database copy, you can use also the MYSQL command line method. Usually you run mysqldump to create a database copy:

$ mysqldump -u user -p db-name > db-name.out

Copy db-name.out file using sftp/ssh to remote MySQL server:

$ scp db-name.out [email protected]:/backup

Restore database at remote server (login over ssh):

$ mysql -u user -p db-name < db-name.out

Configure the Site. Edit the configuration.php File

Manually edit “configuration.php” to tell Joomla! about your site. The file configuration.php contains settings specific to your system. This file was created for you when you installed Joomla! on your localhost. The settings in the configuration.php file that you typically need to change are shown below. This example is from a Windows XP localhost system.

var $log_path = ‘C:xampphtdocsjoomla15logs’;
var $tmp_path = ‘C:xampphtdocsjoomla15tmp’;
var $live_site = ”;
var $host = ‘localhost’;
var $user = ‘root’;
var $db = ‘your_local_db_name’;
var $password = ‘your_local_db_password’;

Now, at you remote host system, the settings in the configuration.php file that you typically need to change are shown below

var $log_path = ‘/var/www/vhost/domain.com/home/html/logs’;
var $tmp_path = ‘/var/www/vhost/domain.com/home/html/tmp’;
var $live_site = ”;
var $host = ‘name your remote host’;
var $user = ‘your_user_db_name’;
var $db = ‘your_db_name’;
var $password = ‘your_db_password’;

If you uploaded Joomla! files to a subdirectory, remember that you are working on subdirectory, and the settings that you need, will be,

var $log_path = ‘/var/www/vhost/domain.com/subdirectory/html/logs’;
var $tmp_path = ‘/var/www/vhost/domain.com/subdirectory/html/tmp’;
var $live_site = ”;
var $host = ‘name your remote host’;
var $user = ‘your_user_db_name’;
var $db = ‘your_db_name’;
var $password = ‘your_db_password’;

At this point, your Joomla! Website on your host should be operational with the same information as your localhost site. If you installed it on a subdirectory, navigate to that subdirectory to see or administer the site.

(for navigatation to the site)

(login to the Joomla admin area with your user and password that your had at your localhost installed)

-and if you installed it on root directory to see the site

https://www.domain.com/ (for navigatation to the site)

(login to admin area)

Ref: http://docs.joomla.org/How_do_you_copy_a_site_from_localhost_to_a_remote_host%3F

Here is comparison of both Local host and remote host ‘configuration.php’ file. I added spaces to get the exact line comparison.