Latest Mysql News

MySQL Date Gotchas Welcome to the second installment in a series on MySQL Gotchas. Part one addressed the MySQL Numeric Overflow Gotcha. Today’s article will explore the perils of working with dates in MySQL. Read more on Database Journal Call For Speakers For Fourth Annual Percona Live MySQL Conference & Expo … DURHAM, NC–(Marketwired) – […]
Continue reading…

 

Where Are MySQL Files Stored in UNIX / Linux

Were are my MySQL database and table files are stored in UNIX or Linux operating systems? Usually /var/lib/mysql or /var/db/mysql directory used to store database and tales under UNIX like operating systems. You can use the following command to locate MySQL datadir: grep datadir /etc/my.cnf Sample outputs: datadir=/var/lib/mysql Another command that will display datadir: ps […]
Continue reading…