MariaDB:Bakup and Restore: Difference between revisions
No edit summary |
|||
| Line 1: | Line 1: | ||
==Menggunakan MySQLDump== | ==Menggunakan MySQLDump== | ||
*Backing up a single database | *Backing up a single database | ||
shell> mysqldump | shell> mysqldump <span style="color:#ff0000">DB_Name</span> > <span style="color:#ff0000">Backup-Name.sql</span> | ||
*atau | *atau | ||
mysqldump -u <span style="color:#ff0000">DB_Name</span> -p -A > <span style="color:#ff0000"> | mysqldump -u <span style="color:#ff0000">DB_Name</span> -p -A > <span style="color:#ff0000">Backup-Name.sql</span> | ||
*Restoring or loading the database | *Restoring or loading the database | ||
shell> mysql | shell> mysql <span style="color:#ff0000">DB_Name</span> < <span style="color:#ff0000">Backup-Name.sql</span> | ||
See the [https://mariadb.com/kb/en/mysqldump/ mysqldump] page for detailed syntax and examples. | See the [https://mariadb.com/kb/en/mysqldump/ mysqldump] page for detailed syntax and examples. | ||