I want to download the log files for my Amazon Relational Database Service (Amazon RDS) DB instance, but I can't locate the log files to download.

Logs for an RDS DB instance are accessible for viewing or downloading in the Amazon RDS console. These logs are also accessible for viewing, watching, downloading, or querying using commands or API actions as described in Amazon RDS Database Log Files. However, the log output defaults for MySQL and MariaDB are to a table instead of to a file. You can't directly download the log data, as that data is stored in the mysql.general_log table or the mysql.slow_log table. 

To be sure that you can access and download MySQL or MariaDB log files, first, set the log_output parameter to file. Then, enable logging, as described at How do I enable and monitor logs for my Amazon RDS MySQL instance? For more information about logging using database engines, refer to the following:

OracleOracle Database Log Files

PostgreSQLPostgreSQL Database Log Files

SQL ServerMicrosoft SQL Server Database Log Files

MySQLMySQL Database Log Files

MariaDBMariaDB Database Log Files

Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center.

Published: 2015-11-03

Updated: 2018-07-11