By skor on

I know I've seen it here in the forums somewhere, but can't seem to find it again. Can someone help me get a list of installed modules out of a 5.7 database?

Thanks.

⋅ Categories: Drupal 5.x

Comments

vm’s picture

vm commented

I don't know which query you are talking about or where that may be, but you can export the system table ?

roopletheme’s picture

roopletheme commented

http://drupal.org/node/199755

styro’s picture

styro commented

http://api.drupal.org/api/function/module_list/5

BTW - there is a SQL query in there if you really really need to have your own query.

--
Anton
New to Drupal? | Troubleshooting FAQ
Example knowledge base built with Drupal

skor’s picture

skor commented

No specific reason for sql in particular, that's just what I remembered coming across, and I'm comfortable with the command line.

Basically, I'm just trying to resurrect an old site off an old database, and I don't remember what modules I had enabled back then.

So if I just fire up phpmyadmin, and browse to the system table, and then to the filename row, I can see all the modules that I need to restore to start getting the site back up & running.

Thanks.

skor’s picture

skor commented

here's what I was thinking of

so from an ssh command line, you can connect to the database with:

> mysql --user=user_name --password=your_password db_name

and then get a list of enabled modules with

mysql> SELECT name,status FROM system WHERE type='module' AND status=1;