~/talk

A look at the database behind the curtain

Talkat WordCamp Asheville 2018 · 2018-08-18..08-19· [databases, wordpress]
slides:none on file

Shows exactly which WordPress tables matter (11 core tables like wp_users, wp_posts, wp_postmeta, wp_options), the tools to edit them (phpMyAdmin, serialized editor), and concrete fixes: set an MD5 in wp_users.user_pass to change your password without logging into your site, edit wp_usermeta.WP_capabilities to make a user an administrator, change wp_options.siteurl/home to stop unwanted redirects, or clear wp_options.active_plugins (serialized) to deactivate plugins. Demonstrates plugins creating prefixed tables (Wordfence → WF_*) and how to back up and restore tables safely.

AI-written summary · about

  1. 0:00Intro
  2. 3:37MySQL
  3. 5:34Database structure
  4. 6:36Users table
  5. 10:12Change user name
  6. 12:27Display user name
  7. 14:25Display serialized data
  8. 17:59Change user to administrator
  9. 21:06Deactivate plugins
  10. 23:14Plugins folder
  11. 26:39Post table
  12. 28:53Post content
  13. 31:15Post meta table
  14. 36:36Terms table
  15. 49:01Last Ul
~/search
type to search 6,518 conferences, 143,918 speakers and 192,133 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
← →
on a talk: 5 seconds back / forward
0–9
on a talk: jump to 0%–90% of the recording
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.