MariaDB:Bakup and Restore: Difference between revisions
No edit summary |
|||
| Line 1: | Line 1: | ||
Berikut adalah cara backup dan restore [[database]] di [[MySQL]] dan [[MariaDB]] | |||
==Menggunakan MySQLDump== | ==Menggunakan MySQLDump== | ||
===Cara 1=== | ===Cara 1=== | ||
| Line 26: | Line 28: | ||
[[Category:MySQL]] | [[Category:MySQL]] | ||
[[Category:Database]] | [[Category:Database]] | ||
[[Category:Tutorial]] | |||
Latest revision as of 12:04, 2 August 2022
Berikut adalah cara backup dan restore database di MySQL dan MariaDB
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