PDA

View Full Version : Where are the MySQL databases located?



fred2028
August 19th, 2010, 02:40 PM
Hi, I want to move all of my MySQL databases to a different partition on my HDD. Where are they located? Also, am I right in thinking that if I move it I can just create a symlink where the DB used to be and point it to the new location, and it should work fine?

Ubuntu 10.04 LTS x64

Thanks!

lykeion
August 19th, 2010, 03:31 PM
Maybe this will help:
http://www.ubuntu-howto.info/howto/how-to-move-mysql-databases-to-another-location-partition-or-hard-drive

Be sure to read the comments about user permissions/apparmor as well

brettg
August 20th, 2010, 07:00 AM
You can find the location of the databases in the config file for mysql (/etc/my.cnf)