Differences

This shows you the differences between two versions of the page.

--- mysqlfilesdirectories [2019/02/18 11:29] – created z0hpvk
+++ mysqlfilesdirectories [2025/03/08 22:24] (current) – external edit 127.0.0.1
@@ Line 5: / Line 5: @@
 === Data Directory ===
 On Ubuntu this defaults to **/var/lib/mysql** \\
+A separate directory will be created for each database, apart from INFORMATION_SCHEMA. \\
+Also stored here by default are ...
+  * Log Files
+  * InnoDB tablespace and log files
+  * SSL and RSA certificate and key files
+  * The server process ID file
+You can display the Data Directory using following command ...
+<code>
+mysql> show variable like 'datadir';
+</code>
+=== Log Files ===
+  * [[https://dev.mysql.com/doc/refman/5.7/en/error-log.html | Error Log]]
+  * [[https://dev.mysql.com/doc/refman/5.7/en/query-log.html | General Query Log]]
+  * [[https://dev.mysql.com/doc/refman/5.7/en/binary-log.html | Binary Log]]
+  * [[https://dev.mysql.com/doc/refman/5.7/en/slave-logs-relaylog.html | Slave Relay Log]]
+  * [[https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html | Slow Query Log]]
+  * [[https://dev.mysql.com/doc/refman/5.7/en/ddl-log.html | DDL Log]]
+=== Option Files ===
+To check location of my.cnf file use ...
+<code>
+mysql --help | grep 'my.cnf'
+</code>
+On Ubuntu 18.04 this returns ...
+<code>
+/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
+</code>
+Default options are read from the above files in the order given.