MariaDB:Bakup and Restore

Revision as of 06:01, 5 November 2021 by Kangtain (talk | contribs)

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.

Source