This tutorial explains how to upload a Joomla installation on your local computer to a general hosting server.
- Select all the files/directories of your Joomla installation, then compress them (*.zip)
- Using phpmyadmin on your local computer, export (dump) your Joomla database to a *.sql file. Here are the steps:
- login to phpmyadmin, e.g. http://localhost/phpmyadmin
- select the database name, then click Export
- select all tables in the database [Select All], choose formal SQL
- check 'Save as file' then click the Go button to download the dumped *.SQL file
- Next upload your joomla installation zip file to the server using FTP or from Manage Files from your hosting control panel.
- After the upload is complete, extract using the tools available in the control panel, if your hosting provider provides SSH access, you can also extract via shell.
- Next, create a new database name via the hosting control panel [SPANEL > MySQL Database menu].
- The next step, with the help of phpmyadmin found on the hosting server, ex. http://domainanda.com/webapps/phpmyadminsilahkan import your *.SQL file to the database server. Here are the steps:
- login to phpmyadmin, use the db_user and db_password you specified when creating the database in the control panel.
- select the database name, then click the Import menu
- click Browse then locate your *.sql file
- click the Go button to start the database import, if there are no errors, all tables will be automatically populated into the database.
- Next, change the PATH settings and DB settings in your Joomla configuration.php file. example:
var $host = 'localhost'; var $user = 't12345_joomla'; var $password = 'dfgy69238'; var $db = 't12345_joomla';var $log_path = '/u/t12345/sites/domainanda.com/www'; var $live_site = 'http://domainanda.com'; var $tmp_path = '/u/t12345/sites/domainanda.com/www';
Done, please try accessing your website URL now, good luck.
Note
- if your database is large; >16MB, import via phpmyadmin may timeout or fail, the solution is to upload your *.sql file using FTP, then by accessing the shell you can run the mysqldump command.
- maybe you need to adjust the permissions of some of your joomla files/directories so that they can be written, for example for the Gallery application