This post should serve as a guide on how to transfer Joomla files and documents from a local host such as the WAMP, LAMP or XAMPP Server to a Web Server via FTP. The popularity of Joomla as a content management system, for building simple to complex Websites, is growing on a daily basis. While some Web administrators prefer to build a Website directly on their Web Server, there are others who like to do otherwise. While both methods have their advantages and disadvantages, this article will focus on the latter category. There are three main components that are required in order to make a clean file transfer from a local to a Web Server: an FTP Client such as FileZilla, a cross-platform Web Server package for example, WAMP or XAMPP and a Web Server. Once these are in place, you can proceed with the following steps:
Select all the files in your Local Server and upload unto the public_html (or a sub-directory in public_html) folder on your Web Server. This usually takes a long time, so be prepared to wait.
Create a full dump of the SQL database by using a database management tool such as phpMyAdmin on your cpanel. If using phpMyAdmin, log in and choose your database from the left menu and click on the Export tab. Select all the tables, check the Add DROP TABLE box and Save as file then click on Go, as shown below. Do not change any other options.
Now to import the database dump to your Web Server, create a new database (with any name of your choice) with a new username and password from your cPanel and log into your Web Server’s phpMyAdmin interface. Select the new database on the left and click on the Import tab. Browse the location of the SQL file then click on Go to import.
Now adjust the core settings identified in the Joomla configuration.php file in the File Manager. It is very important that you get the database settings right otherwise there will be no connectivity between the Joomla files and the database. Below is an example of the variables that need to be changed –
/* Database Settings */
var $host = ‘getCorrectHostnamefromProvider’;
var $user = ‘mySQLdatabaseUsername;
var $password = ‘mySQLdatabasePassword’;
var $db = ‘mySQLdatabaseName’;
var $dbprefix = ‘databasePrefix_’;
var $log_path = ‘enterCorrectLogPath’;
var $tmp_path = ‘enterCorrectTmpPath’;
The Website should now work correctly if all the information above is entered correctly and your domain name points to the right DNS server of your Web hosting account.