A client may request to extract the stored messages of any previous date from the table that contains the message archives for a particular list.
The messages_ table is responsible for containing all the message archives. To extract the archive of messages from the messages_ table for a particular list follow the below procedure:
1) Login to the LM instance.
2) Run this query 'select * from messages_ where list_ = 'list_name' (replace listname with your actual list name)
3) Save the output as a CSV file.
The above procedure should export the messages from the archives from the selected list.