By A Web Design
Once these files are available locally all that has to be done is to:
Step 1: Unzip administrator.zip within E:/public_html/osv which is the path to the folder that must hold the website locally.
Step 2: Next, load a local version of phpMyAdmin, and import the contents of the database export file opensour_opensour.sql into the local database.
NOTE: After taking the Manual Backup of the website via cPanel, please do not forget to download the .htaccess file using FTP. The backup zip file which was created does not contain the .htaccess file, because the .htaccess file is a hidden file on Linux Server.
In our case we had named the local MySQL database as osv, which was accessible only to a user named osv and protected by a password.
The import process does not take too long normally, but would really depend upon the size of the database export file being imported. The larger this file the longer time the import process would take.
Once Step 1 and Step 2 complete the entire restore process of the Joomla website locally is complete.
One final step to complete the local restore process is remaining. Navigate to E:/public_html/osv and locate a file named configuration.php in this folder and open this file in your favorite ASCII editor. Notepad or EditPlus would work just file.
Three entries need to be made:
var $user = ‘osv’;
var $db = ‘osv’;
var $password = ‘{your_password}’;
These are the user name, database name and password for the local installation.
They will actually hold values that were correct for the website.
Once these changes have been completed the local restore process of the Joomla website is complete.
Open a new tab in the Browser and enter the URL for the local website.
In our case it was http://www.localosv.com and the website ran perfectly.