MariaDB:Bakup and Restore: Difference between revisions

No edit summary
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
Berikut adalah cara backup dan restore [[database]] di [[MySQL]] dan [[MariaDB]]
==Menggunakan MySQLDump==
==Menggunakan MySQLDump==
===Cara 1===
===Cara 1===
*Backing up a single database
*Backing up a single database
  {{Terminal|shell> mysqldump DB_Name > Backup-Name.sql}}
  shell> mysqldump DB_Name > Backup-Name.sql


*atau
*atau
  {{Terminal|mysqldump -u DB_Name -p -A > Backup-Name.sql}}
  mysqldump -u DB_Name -p -A > Backup-Name.sql


*Restoring or loading the database
*Restoring or loading the database
  {{Terminal|shell> mysql DB_Name < Backup-Name.sql}}
  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://bit.ly/30eYG4Y mysqldump] page for detailed syntax and examples.


===Cara 2===
===Cara 2===
*BackUp
*BackUp
  {{Terminal|mysqldump -u DB_USER_OR_ROOT -p MEDIAWIKI_DATABASE_NAME > /opt/mediawiki-migration-backup/db/database.sql}}
  mysqldump -u DB_USER_OR_ROOT -p MEDIAWIKI_DATABASE_NAME > /opt/mediawiki-migration-backup/db/database.sql


*Resotore
*Resotore
  {{Terminal|mysql -u bluespice -p bluespice < /opt/mediawiki-migration-backup/db/database.sql}}
  mysql -u bluespice -p bluespice < /opt/mediawiki-migration-backup/db/database.sql


==Source==
==Source==
Line 25: Line 27:
[[Category:Website]]
[[Category:Website]]
[[Category:MySQL]]
[[Category:MySQL]]
[[Category:Database]]
[[Category:Tutorial]]