Moodle: Copy Database - Revision history

Onnowpurbo at 09:04, 19 March 2012

2012-03-19T09:04:01Z

← Older revision		Revision as of 09:04, 19 March 2012
Line 81:		Line 81:
	* di mesin asal		* di mesin asal

	/usr/bin/mysqldump -u root -p123456 moodle -c \| /bin/gzip -9 > moodle.sql.gz		/usr/bin/mysqldump -u root -p123456 -C -Q -e --create-options moodle \| /bin/gzip -9 > moodle-database.sql.gz
	scp moodle.sql.gz stkip@10.150.5.249:		scp moodle-database.sql.gz stkip@10.150.5.249:


Line 88:		Line 88:

	cd ~		cd ~
	gunzip moodle.sql.gz		gunzip moodle-database.sql.gz
	sudo mysqladmin --user=root --password=123456 --force drop moodle		sudo mysqladmin --user=root --password=123456 --force drop moodle
	sudo mysqladmin --user=root --password=123456 create moodle		sudo mysqladmin --user=root --password=123456 create moodle
	sudo mysql -u moodle -pmoodle moodle < ~/moodle.sql		sudo mysql -u moodle -pmoodle moodle < ~/moodle-database.sql
	scp -r root@10.150.5.250:/var/moodledata /var		scp -r root@10.150.5.250:/var/moodledata /var
	chmod -Rf 777 /var/moodledata/lang/		sudo chmod -Rf 777 /var/moodledata/lang/
	chown -Rf www-data.www-data /var/moodledata/lang/		sudo chown -Rf www-data.www-data /var/moodledata/lang/
	chown -Rf www-data.www-data /var/moodledata/		sudo chown -Rf www-data.www-data /var/moodledata/

	==scp database==		==scp database==

2012-03-19T08:58:35Z

← Older revision		Revision as of 08:58, 19 March 2012
Line 83:		Line 83:
	/usr/bin/mysqldump -u root -p123456 moodle -c \| /bin/gzip -9 > moodle.sql.gz		/usr/bin/mysqldump -u root -p123456 moodle -c \| /bin/gzip -9 > moodle.sql.gz
	scp moodle.sql.gz stkip@10.150.5.249:		scp moodle.sql.gz stkip@10.150.5.249:


	* di mesin mirror		* di mesin mirror
Line 91:		Line 92:
	sudo mysqladmin --user=root --password=123456 create moodle		sudo mysqladmin --user=root --password=123456 create moodle
	sudo mysql -u moodle -pmoodle moodle < ~/moodle.sql		sudo mysql -u moodle -pmoodle moodle < ~/moodle.sql
			scp -r root@10.150.5.250:/var/moodledata /var
			chmod -Rf 777 /var/moodledata/lang/
			chown -Rf www-data.www-data /var/moodledata/lang/
			chown -Rf www-data.www-data /var/moodledata/

	==scp database==		==scp database==

2012-03-19T08:50:05Z

menggunakan moodle_backup.php

← Older revision		Revision as of 08:50, 19 March 2012
Line 24:		Line 24:
	http://cvs.moodle.org/contrib/tools/moodle_backup/moodle_backup.php		http://cvs.moodle.org/contrib/tools/moodle_backup/moodle_backup.php
	http://cvs.moodle.org/contrib/tools/moodle_backup/moodle_backup.php?view=co		http://cvs.moodle.org/contrib/tools/moodle_backup/moodle_backup.php?view=co
			http://cvs.moodle.org/contrib/tools/moodle_backup/moodle_backup.php?view=log

	* siapkan		* siapkan

2012-03-19T08:41:30Z

menggunakan moodle_backup.php

2012-03-19T08:38:49Z

← Older revision		Revision as of 08:38, 19 March 2012
Line 35:		Line 35:

	cd /usr/local/bin		cd /usr/local/bin
			touch moodle_backup.php
			chmod -Rf 777 moodle_backup.php
			chown -Rf nobody.nogroup moodle_backup.php
	vi moodle_backup.php		vi moodle_backup.php

2012-03-19T08:37:46Z

@@ Line 24: / Line 24: @@
   http://cvs.moodle.org/contrib/tools/moodle_backup/moodle_backup.php
   http://cvs.moodle.org/contrib/tools/moodle_backup/moodle_backup.php?view=co
 * buat script
@@ Line 29: / Line 36: @@
   cd /usr/local/bin
   vi moodle_backup.php

2012-03-19T08:31:49Z

@@ Line 18: / Line 18: @@
 The Moodle code (wwwroot) is less important as a frequent backup, since it will only change when the the actual code is changed through upgrades, addins and code tweaks. You can always get a copy of the standard Moodle code from http://download.moodle.org so you only have to backup the parts you added or changed yourself.
-==pakai mysqldump==
+* Download dari
 '''WARNING: Entah kenapa password user jadi beda / berubah, kayanya karena hash'''

2012-03-19T08:28:19Z

pakai mysqldump

← Older revision		Revision as of 08:28, 19 March 2012
Line 20:		Line 20:

	==pakai mysqldump==		==pakai mysqldump==
	'''WARNING: ~~Ada Masalah di mesin mirror~~'''		'''WARNING: Entah kenapa password user jadi beda / berubah, kayanya karena hash'''

	* Install Moodle Kosong di mesin mirror		* Install Moodle Kosong di mesin mirror

2012-03-19T08:27:38Z

pakai mysqldump

← Older revision		Revision as of 08:27, 19 March 2012
Line 20:		Line 20:

	==pakai mysqldump==		==pakai mysqldump==
			'''WARNING: Ada Masalah di mesin mirror'''

	* Install Moodle Kosong di mesin mirror		* Install Moodle Kosong di mesin mirror
Line 34:		Line 35:
	sudo mysqladmin --user=root --password=123456 create moodle		sudo mysqladmin --user=root --password=123456 create moodle
	sudo mysql -u moodle -pmoodle moodle < ~/moodle.sql		sudo mysql -u moodle -pmoodle moodle < ~/moodle.sql



	==scp database==		==scp database==

2012-03-19T08:26:57Z

Referensi

← Older revision		Revision as of 08:26, 19 March 2012
Line 67:		Line 67:
	* http://docs.moodle.org/22/en/Site_restore		* http://docs.moodle.org/22/en/Site_restore
	* http://docs.moodle.org/22/en/Site_backup		* http://docs.moodle.org/22/en/Site_backup
			* http://cvs.moodle.org/contrib/tools/moodle_backup/moodle_backup.php?view=log&pathrev=MOODLE_22_STABLE


	==Pranala Menarik==		==Pranala Menarik==