Even though MySQL is now an Oracle product, it still retains an open source component. In some ways, this is a good thing - we can develop a system using the open source version, and if a client wishes to upgrade to a paid, fully supported commercial product, the option is there.
Note that MySQL development has forked. Oracle continues to develope and maintain MySQL. The original developers of MySQL have forked off MariaDB. At present the two are compatible and almost interchangable.
Moving the Location of the Data Files
MySQL puts its database files in /var/lib/mysql. The easiest way to move those files to a larger partition is to simply create a link from /var/lib/mysql to the new location.
ln -s /home/mysql /var/lib/mysql
The big thing to remember here is that if you recreate the server, you have to put the symbolic link back in.
Back to Main Page