MariaDB:Bakup and Restore: Difference between revisions
| Line 2: | Line 2: | ||
===Cara 1=== | ===Cara 1=== | ||
*Backing up a single database | *Backing up a single database | ||
{{Terminal|shell> mysqldump | {{Terminal|shell> mysqldump DB_Name > Backup-Name.sql}} | ||
*atau | *atau | ||
{{Terminal|mysqldump -u | {{Terminal|mysqldump -u DB_Name -p -A > Backup-Name.sql}} | ||
*Restoring or loading the database | *Restoring or loading the database | ||
{{Terminal|shell> mysql | {{Terminal|shell> mysql DB_Name < Backup-Name.sql}} | ||
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. | ||