To create a database using the 'mysql' command line client, first log into MySQL. $ mysql -u root -p Enter password: (Enter the password you previously set - or been given - for the MySQL 'root' user). After some pre-amble this should take you to the mysql> prompt. Create a new database (called 'moodle' - substitute your own name if required).
Mar 23, 2012 · SELECT COUNT(*), c.fullname AS Course FROM mdl_course_modules cm JOIN mdl_course c ON c.id = cm.course JOIN mdl_modules m ON m.id = cm.module WHERE m.id = 13 GROUP BY c.id HAVING COUNT(m.`id`) = 0; But I would probably write the query above differently as the COUNT(*) is ambiguous or can be anyway with the addition of a DISTINCT clause.
Jul 13, 2015 · The times in Moodle are stored as integers and are a UTC unix timestamp. So the date functions in MySql won't work - unless they are converted using FROM_UNIXTIME(). If you want all users enrolled, not just students, then this is simpler.
Apr 06, 2020 · The Moodle database has around 200 tables, and can be quite daunting at first sight. ... Other parts of the role definition are stored in the role_capabilities and role_context_levels tables. capabilites the various permissions that can be granted. context a context is a scope in Moodle, for example the whole system, a course, a particular ...
In the relevant Moodle course, in the Settings block, select Course administration > Users > Groups. On the Groups page, click Import groups.Jul 11, 2019
A student would go to the course participants page, click their name, then scroll to the bottom of their course profile page (alternately, they can go to their site-level profile, then select a course from the list, and that will also bring them to their course-level profile).Oct 10, 2020
moodledata"moodledata" is a folder that contains user files, course files, site language, cached and other information. It is created in the Moodle install process. It should be located outside of the "moodle" folder and is called by default "moodledata".Mar 26, 2019
The database tables are used by Moodle and its plugins for data storage. They are able to be queried for information about users, and their involvement, as well as course and site information. I would estimate that more than half of the data needed for analytics are stored in these database tables.Feb 11, 2014
Groupings are a collection of groups, and you can assign activities to specific groupings as needed. To assign a specific activity to a grouping, you must first set up the grouping. For instructions on making a grouping, refer to Create Groupings in Moodle.
Go to Participants on your course page, click the gear button, and click Import Enrolls.Input the correct settings for your import. Select whether you inputted usernames or email addresses on your CSV. Select role as Student. Select yes to assign to groups. ... Choose your CSV file and click import file.Oct 9, 2020
The moodledata directory is the location of files that are uploaded or created by the Moodle interface. Since it is a directory, it can have a different name and location than the default name of "moodledata". ... Site administrators can see the actual moodledata directory name and location in the config. php file.Aug 26, 2011
Backup Your Moodle CourseLog in to Moodle and click on the course you want to back up.Under Administration, click Backup.On the Course backup screen, leave all checkboxes checked to backup both your course materials and student work. ... On the confirmation screen, click Continue.More items...
So how can you make a backup of your Moodle course?Click the gear menu and then select “backup.”Use the checkboxes to decide what you would like to bring over with your copy of the course. ... Experienced Moodlers can click the “jump to the final step” button, or if you prefer click “next”.More items...•Nov 10, 2017
If you do not have command line access, but do have access to the database, you can modify a password there. Passwords for all users, including admin, are stored as cryptographic hashes in the table mdl_user.Sep 22, 2021
The Moodle database has around 200 tables, and can be quite daunting at first sight.Apr 6, 2020
The database activity module allows the teacher and/or students to build, display and search a bank of record entries about any conceivable topic. The format and structure of these entries can be almost unlimited, including images, files, URLs, numbers and text amongst other things.Feb 16, 2019
you're only missing a HAVING clause. A HAVING clause is like a WHERE on aggregates like COUNT, SUM, AVG, MIN, MAX, etc.#N#It appears after the GROUP BY. So with your query it would be...
You can use "mdl_course.fullname" instead of "mdl_course.id" in the WHERE clause - but using "mdl_course.id" will guarantee you a unique value (whereas you could have multiple courses with the same mdl_course.fullname). Your second question isn't as clear. Please provide more details.
The Moodle database has around 200 tables, and can be quite daunting at first sight. The good news is that you don't have to understand it all at once. For example, there are eight tables called forum_ something. If you are interested in the forum module, then obviously you need to understand these tables, and the places they link into core tables.
a context is a scope in Moodle, for example the whole system, a course, a particular activity. The type is given by contextlevel, and depending on context level, instanceid points to one of a number of different tables. which roles can assign which other roles. which roles can override which other roles.