MariaDB:Bakup and Restore: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
==Menggunakan MySQLDump== | ==Menggunakan MySQLDump== | ||
===Cara 1=== | |||
*Backing up a single database | *Backing up a single database | ||
shell> mysqldump <span style="color:#ff0000">DB_Name</span> > <span style="color:#ff0000">Backup-Name.sql</span> | shell> mysqldump <span style="color:#ff0000">DB_Name</span> > <span style="color:#ff0000">Backup-Name.sql</span> | ||
| Line 10: | Line 11: | ||
See the [https://mariadb.com/kb/en/mysqldump/ mysqldump] page for detailed syntax and examples. | See the [https://mariadb.com/kb/en/mysqldump/ 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 | |||
==Source== | ==Source== | ||