I would like to extract user data such as email address and name from the mt database. As their is no real way to do this via the back-end admin, I went to phpMyAdmin and went to the "mt authors" table and only found myself as the main admin.
I have enabled all users and they have been given the "commenter" role.
Any ideas? What SQL table holds the user data?
-JK
Reported on Movable Type 4.2
mtauthor holds the information for user accounts on your installation AND information from those who have been authenticated by other means. If you don't see what you're looking for in there, then do in phpMyAdmin, select the unique information from mtcomment that you're looking for, and export the results in the format of your choosing. The export option for a result set is near the bottom of the page that displays it, if memory serves.