Skip to main content

Where are my files saved

Comments

1 comment

  • Jason Rodgers

    Change the MC.id and set to the course id

    Select F.filename, F.contenthash, F.itemid, F.userid, C.id as contextid, CM.id as Coursemoduleid, CM.course as courseid, MC.fullname from mdl_files F 
    LEFT JOIN mdl_context C ON F.contextid = C.id
    LEFT JOIN mdl_course_modules CM ON CM.id=C.instanceid
    LEFT JOIN mdl_course MC on MC.id=CM.course
    where MC.id=5208

    this will display the filename and where the file is stored in the /moodledata/filedir/ structure.

    So example.  contenthash comes out to 5f8e911d0da441e36f47c5c46f4393269211ca56

    then go over to directory /moodledata/filedir/5f/8e and you will find your file as the entire above string.

    Just rename it to filename after downloading.

    1

Please sign in to leave a comment.