I had a problem with this website last Wednesday, and as part of troubleshooting the problem, I need to look at one of the Drupal database tables, specifically the
watchdog table. This table had thousands of records in it, and I couldn't find what I needed with SQL
SELECT queries, so I finally dug through the MySQL documentation, and found that I could save the output from a
SELECT query to a text file.
In this tutorial I'll show you both (a) how to save the results of a MySQL query to a text file, and also (b) how to log your entire MySQL session to a text file.