March 29, 2017
In episode #141, we talk about getting comfortable with MySQL.
Listen:
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
Modules:
Resources:
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.
Sponsors
nLightened Design
nLightened Design specializes in designing, developing and fulfilling your web marketing needs.
Oomph, Inc.
Crafting digital experiences with passion & purpose. We connect you and your audience in a more meaningful way by leveraging the open source power of Drupal and WordPress.
Parallax Information Technology
Parallax Information Technology is a web development agency providing services since 1996 to small and and Fortune 100 companies.
Comments
Frederick Henderson replied on Permalink
Hi guys!
You missed my favorite tool for working with SQL databases, Adminer (https://www.adminer.org/), Database management in a single PHP file. I find that the user interface is much more intuitive than Mysql Workbench or phpmyadmin. I don't have a Mac so I can't comment on Sequel Pro.
I have a git repository with the configuration that I like for Adminer. I find it easy to git clone this in the webroot of a site, do my SQL work, then delete the adminer folder.
God bless!
Frederick
Stephen Cross replied on Permalink
Fredrick - thanks for the input. I'm not aware of this tool. It seems like a good tool to take with each project that does not require any additional software.
-S
Add new comment