Олег Давидович: 1 версия импортирована

2024-10-18T07:00:00Z

1 версия импортирована

← Предыдущая версия	Версия от 07:00, 18 октября 2024
(нет различий)

Олег Давидович: 1 версия импортирована

2024-10-18T06:45:41Z

1 версия импортирована

← Предыдущая версия	Версия от 06:45, 18 октября 2024
(нет различий)

1>Tim@horizoneducationnetwork.org: /* Database */clean up, typos fixed: eg. → e.g.

2024-04-25T15:28:14Z

Database: clean up, typos fixed: eg. → e.g.

← Предыдущая версия		Версия от 15:28, 25 апреля 2024
Строка 1:		Строка 1:
	#~~REDIRECT~~ [[Site backup]]		{{Backup}}
			A '''site backup''' allows a site administrator to save everything associated with a moodle site. These backups can be restored to bring a site back to the point in time when the backup was made.

			Performing regular backups are highly recommended to reduce the amount of lost information in the event of a problem on the site and to speed the overall recovery process.
			== What needs to be backed up? ==
			A Moodle system comprises three parts:
			# The data stored in the database (For example, a MySQL database)
			# The uploaded files (For example, site and course files uploaded via Moodle located in moodledata)
			# The '''Moodle code''' (For example, everything in server/htdocs/moodle)
			You can confirm where all these things are located in a Moodle installation by checking the '''[[Configuration file\|config.php]]''' file.
			:# '''$CFG->dbname''' shows the database name
			:# '''$CFG->prefix''' shows the the database table name prefix
			:# '''$CFG->dataroot''' controls where the ''uploaded files'' are stored; and
			:# '''$CFG->wwwroot''' points to where the ''code'' is stored.

			;Tip
			Generally speaking, the database ("dbname and prefix") and the uploaded files (dataroot) are the two most important to copy on a regular basis. These contain information that will change most often.

			The Moodle code (wwwroot) is less important as a frequent backup, since it will only change when 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.
			== Creating a backup of your Moodle site ==
			=== Database ===
			The right way to back up your database depends on which database system you are using. The instructions below are one way to back up a MySQL database. Another option would be to use a tool like phpMyAdmin to manually make a backup. The documentation for your database will give more options.

			There are many ways to do such backups. Here is an outline of a little script you can run on Unix to backup the database (it works well to have such a script run daily via a cron task):
			cd /my/backup/directory
			mv moodle-database.sql.gz moodle-database-old.sql.gz
			mysqldump --default-character-set=utf8mb4 -h example.com -u myusername --password=mypassword -C -Q -e --create-options mydatabasename > moodle-database.sql
			gzip moodle-database.sql
			Also consider using an option to help ensure that the backup is consistent (e.g. avoid the data changing half-way through the backup), e.g. for MySQL/MariaDB and mysqldump try [https://dev.mysql.com/doc/refman/5.7/en/mysqldump.html#option_mysqldump_single-transaction --single-transaction].

			If you wanted to write your own script for backing up a database automatically at regular intervals (e.g. Daily), for small databases this site may be a good starting point: [https://www.spacerex.co/how-to-automatically-backup-a-mysql-or-mariadb-server-with-mysqldump/ How to Automatically Backup a MySQL or MariaDB Server with MySQLDump]. You could also modify this to make a copy of the moodleData folder, and include it in the .zip file created.
			==== Character encoding ====
			Make sure that a database backup uses the correct character encoding. In most databases, use [[UTF-8]].

			When dumping the entire Moodle database, check for possible character encoding issues. In some instances, backups created with [http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html mysqldump] or [http://www.phpmyadmin.net phpMyAdmin] may not properly encode all of the data. This will result in non-readable characters when the database is restored.
			:''Tip'': One solution is to use MySQL Administrator 1.1 or another tool that will force a UTF-8 dump of the data.
			==== Tools for database backups ====
			; phpMyAdmin
			: [http://www.phpmyadmin.net phpMyAdmin] is the tool of choice with most web hosting providers.

			; MySQLDumper
			: [https://sourceforge.net/projects/mysqldumper/ MySQLDumper] is a backup script for MySQL databases, written in PHP and Perl. MySQLDumper uses a proprietary technique to avoid execution interruption when running PHP scripts (the max. execution time is usually set to 30 seconds). MySQLDumper also cares for the encoding problems mentioned above. It also works with compressed files and allows setting up regular cron jobs for updating and updating to a remote FTP site.

			; AutoMySQLBackup
			: [https://github.com/sixhop/AutoMySQLBackup AutoMySQLBackup] is a backup script for MySQL databases, written in PHP. AutoMySQLBackup will create Daily, Weekly and Monthly backups of one or more of your MySQL databases from one or more of your MySQL servers. Features include email notification, compression and encryption, configurable backup rotation, incremental database backups, and more.
			=== Uploaded files (moodledata) ===
			Through the Moodle interface, users can upload or create files and folders. These are located in a directory, often called "moodledata". Since they are just files and folders, there are many different ways to backup or copy moodledata.
			* For example, using a file transfer program, copy the entire moodledata directory to a different area, drive or computer. Example of file transfer programs include: FTP, WinSP, wget, rsync.

			* You might use a compression program to create compact files (tar, zip. 7z, XZ, BZIP2, GZIP, and WIM are a few file formats) of the entire directory. This can be done before or after file transfers.
			; Tips
			* Typically not all moodledata files change between regular/periodic backups. A new Administrator might want to look into [http://en.wikipedia.org/wiki/Incremental_backup incremental or other efficient backups] procedures.
			* Depending upon the operating environment there are many tools for backing up server files and ways of backing up moodledata. See [[Tools for backing up server files]] for tips on using rsync, FTP or Wget.
			=== Moodle code ===
			Backing up the Moodle code, will be similar to backing up moodledata. See [[Tools for backing up server files]].
			;Tip
			It is always a good idea to have several backup copies of your Moodle code files. While you can always download a fresh base copy of the Moodle code from http://download.moodle.org, you might have customized that code. It is a good idea to create a separate backup of your Moodle code before you customize the code. This includes installing [[Contributed code]], [[Themes]] and upgrading.
			== See also ==
			* [https://www.youtube.com/watch?v=k5rwTy3sNh0 Screencast: How to back up a Moodle site] (thanks to Bruce Chambr)
			*[[Site restore]] Now that you have a backup, how to restore it
			* [[Moodle migration]] - move a Moodle site to a different server
			* Using Moodle [http://moodle.org/mod/forum/discuss.php?d=140949 Site DatabaseBackup Using phpMyAdmin] forum discussion
			* [[Site Backup for Low-tech Users]]
			[[de:Sicherung der Moodle-Installation]]
			[[ja:サイトバックアップ]]
			[[es:Copia de seguridad del sitio]]
			[[fr:Sauvegarde de site]]

1>Tim@horizoneducationnetwork.org: Case sensitive redirect

2024-04-25T14:58:17Z

Case sensitive redirect

Новая страница

#REDIRECT [[Site backup]]

Site backup - История изменений

Олег Давидович: 1 версия импортирована

Олег Давидович: 1 версия импортирована

1>Tim@horizoneducationnetwork.org: /* Database */clean up, typos fixed: eg. → e.g.

1>Tim@horizoneducationnetwork.org: Case sensitive redirect