Search code examples
mysqldrupaldrupal-6

Drupal - Which MySql table contains $footer message

Inherited a mess. Drupal 6 site with custom theme that has removed all admin access. That's a different problem though.

Immediately we need to change the footer message text. Since I don't have admin access, I need to edit via MySql database.

Which Drupal database table contains the $footer message text?

Chris

Solution

  • The Site Footer variable (as configured on the /admin/settings/site-information page) is stored in the variables table. The variables table has two columns: name and value. The value is obviously stored in the value column and it is identified as site_footer in the name column. So:

    SELECT value FROM variable WHERE name = 'site_footer'

    ...will give you the current value. Note that the value is serialized, so make sure you're familiar with how that works if you plan on trying to change it directly in the database.