- On LINUX, the typical defaults are /user/local/mysql/data for binary/source installation and /var/lib/mysql for RPM packages.
- On Windows, the default directory are C:\ProgramData\MySQL\ (for Windows 2008 server) and C:\Documents and Settings\All users\Application Data\MySQL depending on the Windows Versions.
You can find the binary log directory with the following SQL command:
If you didn't specify the directory location for the bin log in the configuration file, such as using "log-bin=bin.log". MySQL will use the default data directory location to store the binary log files.
Created 8/21/2013, Last Updated: 1/5/2016
GoldenGate for MySQL
Oracle GoldenGate for MySQL replicates DML operations for MySQL databases. Here, I discuss Oracle GoldenGate for MySQL, MySQL database and MySQL replication.
Heterogeneity Security High Performance Real-Time DML Globalization