Talking Drupal #141 - Working with MySQL

March 29, 2017
In episode #141, we talk about getting comfortable with MySQL.

Listen:

direct Link

Topics

In episode #141, we talk about getting comfortable with MySQL.

  • Get familiar with the Drupal database
  • Why a SQL view is helpful
  • The command line 
  • Modules that will help
  • Tools
  • Drush import/export
drush sql-dump > \~/db.sql
drush sql-drop
drush sql-cli < \~/db.sql

Resources

Mysql Workbench

Sequel Pro

phpmyadmin

Module of the Week

Force Password Change

This module allows administrators to force users, by role, individual user, or newly created user, to change their password on their next page load or login, and/or expire their passwords after a period of time.