MySQL

From aoxoaWiki
Jump to: navigation, search

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.

Topics

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.


Online Resources

www.mysql.com

mariadb.org



Back to Main Page