MariaDB:Bakup and Restore: Difference between revisions
| Line 20: | Line 20: | ||
==Source== | ==Source== | ||
*[https:// | *[https://mariadb.com/kb/en/backup-and-restore-overview/ mariadb.com] | ||
[[Category:Server]] | [[Category:Server]] | ||
Revision as of 15:08, 5 March 2022
Menggunakan MySQLDump
Cara 1
- 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.
Cara 2
- BackUp
mysqldump -u DB_USER_OR_ROOT -p MEDIAWIKI_DATABASE_NAME > /opt/mediawiki-migration-backup/db/database.sql
- Resotore
mysql -u bluespice -p bluespice < /opt/mediawiki-migration-backup/db/database.sql