Difference between revisions of "Moodle: Copy Database"

From OnnoWiki
Jump to navigation Jump to search
Line 1: Line 1:
 +
==pakai mysqldump==
 +
 +
* Install Moodle Kosong di mesin mirror
 +
* di mesin asal
 +
 +
/usr/bin/mysqldump -u root -p123456 moodle -c | /bin/gzip -9 > moodle.sql.gz
 +
scp moodle.sql.gz stkip@10.150.5.249:
 +
 +
* di mesin mirror
 +
 +
 +
 
==scp database==
 
==scp database==
 
'''WARNING: Cara ini akan menimbulkan error karena banyak yang kurang lengkap'''
 
'''WARNING: Cara ini akan menimbulkan error karena banyak yang kurang lengkap'''

Revision as of 15:00, 19 March 2012

pakai mysqldump

  • Install Moodle Kosong di mesin mirror
  • di mesin asal
/usr/bin/mysqldump -u root -p123456 moodle -c | /bin/gzip -9 > moodle.sql.gz
scp moodle.sql.gz stkip@10.150.5.249:
  • di mesin mirror


scp database

WARNING: Cara ini akan menimbulkan error karena banyak yang kurang lengkap

mysql -u root -p123456
create database moodle;
ALTER DATABASE moodle charset=utf8;
grant ALL on root.* to moodle@localhost;
grant ALL on moodle.* to moodle@localhost identified by "moodle";
grant ALL on moodle.* to moodle identified by "moodle";
exit


scp -r root@10.150.5.250:/var/lib/mysql/moodle /var/lib/mysql
scp -r root@10.150.5.250:/var/moodledata /var
scp -r root@10.150.5.250:/var/www/moodle /var/www
chmod -Rf 777 /var/moodledata/lang/
chown -Rf www-data.www-data /var/moodledata/lang/
chown -Rf www-data.www-data /var/moodledata/
chmod -Rf 777 /var/www/moodle	
chown -Rf www-data.www-data /var/www/moodle 
chown -Rf mysql.mysql /var/lib/mysql/moodle
config.php:$CFG->wwwroot   = 'http://10.150.5.250/moodle';
vi /var/www/moodle/config.php


Pranala Menarik