MariaDB:Bakup and Restore - Revision history

Kangtain at 05:04, 2 August 2022

2022-08-02T05:04:07Z

← Older revision		Revision as of 12:04, 2 August 2022
Line 1:		Line 1:
			Berikut adalah cara backup dan restore [[database]] di [[MySQL]] dan [[MariaDB]]

	==Menggunakan MySQLDump==		==Menggunakan MySQLDump==
	===Cara 1===		===Cara 1===
Line 26:		Line 28:
	[[Category:MySQL]]		[[Category:MySQL]]
	[[Category:Database]]		[[Category:Database]]
			[[Category:Tutorial]]

Kangtain: /* Source */

2022-03-05T08:08:15Z

Source

← Older revision		Revision as of 15:08, 5 March 2022
Line 20:		Line 20:

	==Source==		==Source==
	*[https://~~bit~~.ly/~~30eYG4Y~~ mariadb.com]		*[https://mariadb.com/kb/en/backup-and-restore-overview/ mariadb.com]

	[[Category:Server]]		[[Category:Server]]

Kangtain: /* Source */

2021-12-11T08:08:36Z

Source

← Older revision		Revision as of 15:08, 11 December 2021
Line 25:		Line 25:
	[[Category:Website]]		[[Category:Website]]
	[[Category:MySQL]]		[[Category:MySQL]]
			[[Category:Database]]

Kangtain: /* Source */

2021-11-13T22:41:06Z

Source

← Older revision		Revision as of 05:41, 14 November 2021
Line 20:		Line 20:

	==Source==		==Source==
	*[https://~~mariadb~~.~~com/kb/en/backup-and-restore-overview~~/ mariadb.com]		*[https://bit.ly/30eYG4Y mariadb.com]

	[[Category:Server]]		[[Category:Server]]
	[[Category:Website]]		[[Category:Website]]
	[[Category:MySQL]]		[[Category:MySQL]]

Kangtain: /* Menggunakan MySQLDump */

2021-11-10T23:35:24Z

Menggunakan MySQLDump

← Older revision		Revision as of 06:35, 11 November 2021
Line 10:		Line 10:
	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===

Kangtain: /* Menggunakan MySQLDump */

2021-11-10T23:33:59Z

Menggunakan MySQLDump

← Older revision		Revision as of 06:33, 11 November 2021
Line 2:		Line 2:
	===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://mariadb.com/kb/en/mysqldump/ mysqldump] page for detailed syntax and examples.
Line 14:		Line 14:
	===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==

Kangtain: /* Cara 1 */

2021-11-08T09:21:00Z

Cara 1

← Older revision		Revision as of 16:21, 8 November 2021
Line 2:		Line 2:
	===Cara 1===		===Cara 1===
	*Backing up a single database		*Backing up a single database
	{{Terminal\|shell> mysqldump ~~<span style="color:#ff0000">~~DB_Name~~</span> > <span style="color:#ff0000"~~>Backup-Name.sql~~</span>~~}}		{{Terminal\|shell> mysqldump DB_Name > Backup-Name.sql}}

	*atau		*atau
	{{Terminal\|mysqldump -u ~~<span style="color:#ff0000">~~DB_Name~~</span>~~ -p -A ~~> <span style="color:#ff0000"~~>Backup-Name.sql~~</span>~~}}		{{Terminal\|mysqldump -u DB_Name -p -A > Backup-Name.sql}}

	*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>~~}}		{{Terminal\|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://mariadb.com/kb/en/mysqldump/ mysqldump] page for detailed syntax and examples.

Kangtain: /* Menggunakan MySQLDump */

2021-11-08T09:18:13Z

Menggunakan MySQLDump

← Older revision		Revision as of 16:18, 8 November 2021
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==

Kangtain at 16:37, 5 November 2021

2021-11-05T16:37:03Z

← Older revision		Revision as of 23:37, 5 November 2021
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==

Kangtain at 23:01, 4 November 2021

2021-11-04T23:01:28Z

← Older revision		Revision as of 06:01, 5 November 2021
Line 16:		Line 16:
	[[Category:Server]]		[[Category:Server]]
	[[Category:Website]]		[[Category:Website]]
			[[Category:MySQL]]