MariaDB:Bakup and Restore: Difference between revisions
No edit summary |
|||
| Line 16: | Line 16: | ||
[[Category:Server]] | [[Category:Server]] | ||
[[Category:Website]] | [[Category:Website]] | ||
[[Category:MySQL]] | |||
Revision as of 06:01, 5 November 2021
Menggunakan MySQLDump
- Backing up a single database
shell> mysqldump DB_Name > Backup-Name.sql
- atau
mysqldump -u DB_Name -p -A > Backup-Name.sql
- Restoring or loading the database
shell> mysql DB_Name < Backup-Name.sql
See the mysqldump page for detailed syntax and examples.