MariaDB:Bakup and Restore: Difference between revisions

Latest revision as of 12:04, 2 August 2022

Berikut adalah cara backup dan restore database di MySQL dan MariaDB

shell> mysqldump DB_Name > Backup-Name.sql

mysqldump -u DB_Name -p -A > Backup-Name.sql

shell> mysql DB_Name < Backup-Name.sql

See the mysqldump page for detailed syntax and examples.

mysqldump -u DB_USER_OR_ROOT -p MEDIAWIKI_DATABASE_NAME > /opt/mediawiki-migration-backup/db/database.sql

mysql -u bluespice -p bluespice < /opt/mediawiki-migration-backup/db/database.sql

@@ Line 1: / Line 1: @@
+Berikut adalah cara backup dan restore [[database]] di [[MySQL]] dan [[MariaDB]]
 ==Menggunakan MySQLDump==
+===Cara 1===
 *Backing up a single database
-  shell> mysqldump <span style="color:#ff0000">DB_Name</span> > <span style="color:#ff0000">Backup-Name.sql</span>
+  shell> mysqldump DB_Name > Backup-Name.sql
 *atau
-  mysqldump -u <span style="color:#ff0000">DB_Name</span> -p -A > <span style="color:#ff0000">Backup-Name.sql</span>
+  mysqldump -u DB_Name -p -A > Backup-Name.sql
 *Restoring or loading the database
+ shell> mysql DB_Name < Backup-Name.sql
+See the [https://bit.ly/30eYG4Y mysqldump] page for detailed syntax and examples.
-  shell> mysql <span style="color:#ff0000">DB_Name</span> < <span style="color:#ff0000">Backup-Name.sql</span>
+===Cara 2===
+*BackUp
+  mysqldump -u DB_USER_OR_ROOT -p MEDIAWIKI_DATABASE_NAME > /opt/mediawiki-migration-backup/db/database.sql
-See the [https://mariadb.com/kb/en/mysqldump/ mysqldump] page for detailed syntax and examples.
+*Resotore
+ mysql -u bluespice -p bluespice < /opt/mediawiki-migration-backup/db/database.sql
 ==Source==
@@ Line 16: / Line 26: @@
 [[Category:Server]]
 [[Category:Website]]
+[[Category:MySQL]]
+[[Category:Database]]
+[[Category:Tutorial]]