Difference between revisions of "Moodle: Copy Database"

From OnnoWiki
Jump to navigation Jump to search
Line 1: Line 1:
 +
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/lib/mysql/moodle /var/lib/mysql
 
  scp -r root@10.150.5.250:/var/moodledata /var
 
  scp -r root@10.150.5.250:/var/moodledata /var

Revision as of 14:35, 19 March 2012

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

Retrieved from "https://onnocenter.or.id/wiki/index.php?title=Moodle:_Copy_Database&oldid=30844"