backup database

Ada cara lain dalam membackup database MySQL melalui console yaitu dengan command :

root@server:/mysql</code>

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1683
Server version: 5.1.41-3ubuntu12.10 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.<span id="more-45"></span>

mysql&gt; show databases;

mysql&gt; show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| bantuan_perpusnas  |
| hukumv1            |
| jurnal             |
| mysql              |
| ojs                |
| senayan            |
| wordpress          |
+--------------------+
8 rows in set (0.00 sec)

root@library://# mysqldump -u root -p ojs &gt; /home/ojs.sql

enter dan isi password dari MySQL nya

root@library://# mysqldump -u root -p ojs &gt; /home/ojs.sql
Enter password:

Hasil dari proses back up data tersebut adalah file dengan jenis *.sql di direktori penyimpanan di atas, misal di /home/

root@library:/home# ls
administrator  lost+found  master  ojs.sql

 

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>