MariaDB:Bakup and Restore: Difference between revisions
No edit summary |
|||
| Line 2: | Line 2: | ||
===Cara 1=== | ===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> | {{Terminal|shell> mysqldump <span style="color:#ff0000">DB_Name</span> > <span style="color:#ff0000">Backup-Name.sql</span>}} | ||
*atau | *atau | ||
mysqldump -u <span style="color:#ff0000">DB_Name</span> -p -A > <span style="color:#ff0000">Backup-Name.sql</span> | {{Terminal|mysqldump -u <span style="color:#ff0000">DB_Name</span> -p -A > <span style="color:#ff0000">Backup-Name.sql</span>}} | ||
*Restoring or loading the database | *Restoring or loading the database | ||
{{Terminal|shell> mysql <span style="color:#ff0000">DB_Name</span> < <span style="color:#ff0000">Backup-Name.sql</span>}} | |||
shell> mysql <span style="color:#ff0000">DB_Name</span> < <span style="color:#ff0000">Backup-Name.sql</span> | |||
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. | ||
| Line 14: | Line 14: | ||
===Cara 2=== | ===Cara 2=== | ||
*BackUp | *BackUp | ||
mysqldump -u DB_USER_OR_ROOT -p MEDIAWIKI_DATABASE_NAME > /opt/mediawiki-migration-backup/db/database.sql | {{Terminal|mysqldump -u DB_USER_OR_ROOT -p MEDIAWIKI_DATABASE_NAME > /opt/mediawiki-migration-backup/db/database.sql}} | ||
*Resotore | *Resotore | ||
mysql -u bluespice -p bluespice < /opt/mediawiki-migration-backup/db/database.sql | {{Terminal|mysql -u bluespice -p bluespice < /opt/mediawiki-migration-backup/db/database.sql}} | ||
==Source== | ==Source== | ||