Tutorials Export and import / backup and upload the joomla database with phpmyadmin

Technology News tutorial today : Tutorials Export and import / backup and upload the sql with phpmyadmin
How do I backup and upload the joomla database?
When we install a localhost joomla to be able to carry it everywhere (displayed on the computer / another server) we need him mencopy sql (database).
MySQL has a facility called a MySQL Dump. Usually used to perform backups on the database, or to transfer data to the server
The easiest way to make dumping the MySQL database is through phpmyadmin.


Enough preamble, the direct practice of how to backup and upload the joomla database


1. Backup Database
- PhpMyAdmin normally be in http://localhost/phpmyadmin, open your phpmyadmin

- Select the database you want to copy

- PhpMyAdmin will display the tables contained in the database.
- Click on the Export


- Then just watch the save as file (the others let the defaults). Mark save as a file, then click ok.


Usually, like downloading files, we will ask for the save file. Save the file as you download the files and sql joomla already biased in the show on the host else.


2. UPLOAD DATABASE
To move Joomla to another host, we have to upload the sql it, the following tutorial:
Import / upload the database in byethost / other webhost

- Log into your hosting control panel
- Then look for phpmyadmin, click on the phpmyadmin
- Create a database "create database" and enter your database name (if you already have a database on your webhost, this step is not necessary)
- To byethost, click on admin, then you will be brought to your phpmyadmin
(To another webhost, find the location of phpmyadmin in accordance with directions given by each webhost)
- Then click on Import
- Browse for your sql file that you export / copy earlier
- Then click on Go

If no error then the meaning of success,
Usually sql error occurred because the name is not in accordance with the provisions of the webhost.
Please change the name of your sql via phpmyadmin. You also need to replace the configuration database to be used in joomla



3. Modifying CONFIGURE.PHP FILE
You should change you in joomla configuration.php yanga, the editing process can dilalkukan in tect editor or modification of files in cpanel and select the name configuration.php and then click "code editor / edit". This is a sample configuration whatever need to be changed:

(JConfig class
var $ offline = '0 '; // let the default
var $ editor = 'fckeditor'; // let the default
var $ list_limit = '20 '; // let the default
var $ helpurl = 'http://help.joomla.org'; // let the default
var $ debug = '0 '; // let the default
var $ debug_lang = '0 '; // let the default
var $ SEF = '1 '; // let the default
var $ sef_rewrite = '1 '; // let the default
var $ sef_suffix = '1 '; // let the default
var $ feed_limit = '10 '; // let the default
var $ feed_email = 'author'; // let the default
var $ secret = 'hLE6ceIWUADAyE4C'; // let the default
var $ gzip = '1 '; / / let the default
var $ error_reporting = '-1'; / / let the default
var $ xmlrpc_server = '0 '; / / let the default
var $ log_path = '/ home/vol14/byethost5.com/b5_5281829/hernawan.co.tv/htdocs/logs'; / / the contents of which you are logs jomla
var $ tmp_path = '/ home/vol14/byethost5.com/b5_5281829/hernawan.co.tv/htdocs/tmp'; / / tmp content where you are
var $ live_site =''; / / let the default
var $ force_ssl = '0 '; / / let the default
var $ offset = '0 '; / / let the default
var $ caching = '0 '; / / let the default
var $ cachetime = '15 '; / / let the default
var $ cache_handler = 'file'; / / let the default
var $ memcache_settings = array (); / / let the default
var $ ftp_enable = '0 '; / / let the default because in safe mode usually does not need to ftp off
var $ ftp_host = 'ftp.byethost5.com'; / / fill it with your ftp host
var $ ftp_port = '21 '; / / let the default
var $ ftp_user = 'b5_5'; / / fill it with your ftp user
var $ ftp_pass = 'paswordku'; / / the contents with your password
var $ ftp_root = '/ home/vol14/byethost5.com/b5_5281829/hernawan.co.tv/htdocs'; / / content where you are in the root joomla
var $ dbtype = 'mysql'; / / let the default
var $ host = 'sql108.byethost5.com'; / / fill it with your host's sql
var $ user = 'b5_5'; / / the contents of your sql user
var $ db = 'b5_5_dbmu'; / / the contents of a databasemu
var $ dbprefix = 'jos_'; / / let the default
var $ mailer = 'mail'; / / let the default
var $ mailfrom = 'hernawanbopa@yahoo.co.id'; / / the contents emailmu
var $ fromname = 'hernawan | jr3074 blog';
var $ sendmail = '/ usr / sbin / sendmail';
var $ smtpauth = '0 ';
var $ smtpsecure = 'none';
var $ smtpport = '25 ';
var $ smtpuser ='';
var $ smtppass ='';
var $ smtphost = 'localhost';
var $ MetaAuthor = '1 ';
var $ MetaTitle = '1 ';
var $ lifetime = '15 ';
var $ session_handler = 'database';
var $ password = 'passwordku'; / / fill it with your password
var $ sitename = 'hernawan | jr3074 blog';
var $ MetaDesc = 'Hernawan jr3074 blogs, e-book nideo tutorials about computers, assemble a computer, video tutorial e-book computer repair, refil printer, network, hacking';
var $ MetaKeys = 'jr3074, muhammad hernawan, hernawan, ebook, video tutorials, assemble a computer, assemble a laptop, computer repair, monitor repair, printer refil, CIS printers, technology, windows, linux, lan, wlan, wireless, hacking, tutorials, downloads, e-book, facebook, e-mail ';
var $ offline_message = 'This site is under maintenance. Please visit again later. ';)

When finished making changes, please save the settings changes
how to backup and upload the joomla database