mysql backup
cd /my/backup/directory
mv moodle-database.sql.gz moodle-database-old.sql.gz
mysqldump -h example.com -u myusername --password=mypassword -C -Q -e --create-options mydatabasename > moodle-database.sql
gzip moodle-database.sql
backup database
mysqldump -h localhost -u root -p -C -Q -e --create-options moodle > moodle-database.sql
restore database
mysql -u root -p moodle < moodle.sql
mv moodle moodle.bak
unzip file
cp moodle.backup/config.php moodle
cp -pr moodle.backup/theme/mytheme moodle/theme/mytheme
cp -pr moodle.backup/mod/mymod moodle/mod/mymod
沒有留言:
張貼留言