By lbenito on

Hello,

I was asked to export information about the user accounts registered in our Drupal website. I was able to get most of the important information (Username, e-mail, addresses, phone numbers, etc.) by locating the appropriate tables in the database and exporting their content to CSV.

However, I was not able to find where the "Country" of each user is stored, no matter where I looked. Can anybody point me in the right direction?

Thanks.

⋅ Categories: Drupal 6.x

Comments

VM’s picture

VM commented

Note: Drupal 6 is unsupported. You should be working a plan to upgrade to D7 at minimum.

D6 didn't provide the feature out of the box. What modules are being used to capture the data? that will provide a hint as to where in the DB the data is. Could also utilize a search on the DB to locate a specific country name to try and determine where the data is.