Backup dan Restore Database SQL

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

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