Discover Top Posts Tagged with #datadir

How to Change default MySQL Data Directory in Linux

As a System Administrator I don’t prefer to use / directory to store MySQL data files. Each time when I install MySQL for a production server, I tried to use secondary disk for storing application and database file. In that way I always change the default data directory of MySQL to secondary disk mounted on system.

Mostly MySQL uses /var/lib/mysqldirectory as default data directory for Linux…