Tinkering with MySQL Databases #moodle
In two days, I’ll be sharing a lot of what I’ve learned over the years while tinkering with MySQL databases. I wish it could be more, but my focus has been more practical on what I needed to know to get Moodle, Wordpress and other Web 2.0 tools up and going.
Here’s the outline for my upcoming Tinkering with MySQL presentation where I hope to share some of what I’ve learned:
TCEA2011-Tinkering with MySQL Moodle Databases
Image Source: http://exs.exploratorium.edu/wp-content/uploads/2009/08/tinkering\_teaser.png
Overview of MySQL and Queries Possible
- Example #1: Updating how Moodle User authentication
- Example #2: Disabling Student Emails en masse
- Creating MySQL Databases
-
General Settings for a new database:
-
UTF8
-
General_ci
-
How To Create Your Database with…
-
phpMyAdmin - Tutorial (external link)
- Backing Up Your Moodle database using Free, Open Source Tools
- Backing up with phpMyAdmin (web-based)
- Backing up with SQL Yog (Windows only)
- Restoring Your Moodle database
- Resetting Your Moodle Admin Password via the MySQL Database Interface
- Ever find yourself unable to login with your admin password to Moodle? This may mean you need to repair a corrupt Moodle database (see below). It could also mean you forgot your password. To change the admin password, go to a Moodle database for which you know the admin password. Copy the password (usually encrypted). Then, go to the mdl_user table, and find the admin user and replace the contents of the password field with your previously copied password.
- Other questions?
Miscellaneous Tips
- Optimizing Your MySQL Tables
- Turning Moodle Messaging ON/OFF
- Repairing a Corrupt Moodle Database
- Repairing MySQL Database Part 2
- Goofing Around with PHPMyAdmin
Moodle Custom SQL Queries
Other Fun Stuff
Get Blog Updates via Email!
Enter your email address:
Delivered by FeedBurner
pingthis();
Bookmark this on Delicious
Subscribe to Around the Corner-MGuhlin.org
Everything posted on Miguel Guhlin’s blogs/wikis are his personal opinion and do not necessarily represent the views of his employer(s) or its clients. Read Full Disclosure