2013 Tokyo Moodle Moot Presentations Database

 

Presentation ID Number 発表ID:
269
Presenters & Author(s)発表者と著者:
Thomas Robb (Kyoto Sangyo University)
Presentation title 発表標題:
Using PhpMyAdmin to Manage the Moodle Database
Presentation type 提出原稿のタイプ: ワークショップ 90分 Workshop 90 mins
Day & Time 日時: 土 Saturday 15:00 - 16:30
Location 場所: 104B
Presentation abstract 発表内容
There are times when direct manipulation of the Moodle database by competent users can be a great time saver. For example, you might want to modify everyone's school email address due to a change in their format, or create a list showing all courses and groups in your database. This workshop will demonstrate some of the ways to safely extract or modify data using phpmyadmin, the most common freeware mysql management tool. Participants will get hands-on practice at using complex "where" statements so that only the desired entries in the database are affected by the desired change. We will also learn how to "bookmark" search specs for repeated use at a later date, and how to download the results as an .xls file. Other techniques will be demonstrated based on the needs of the participants.
Presentation topic(s) トピック:
インストールと管理 - Installation and Administration
Keyword(s) キーワード:
Mysql, phpmyadmin