HI folks, Apologies if this is OT. If it is, please msg me offllist and I'll carry on my searching elsewhere. Where does mysql actually store databases and tables in the filesystem? Thanks in advance -Ray
Ray Leventhal wrote:> HI folks, > > Apologies if this is OT. If it is, please msg me offllist and I'll > carry on my searching elsewhere. > > Where does mysql actually store databases and tables in the filesystem? >depends on where you set it up to store those things. a cursory google for mysql config will give you the details. and you can start by looking at /etc/my.cnf -- Karanbir Singh : http://www.karan.org/ : 2522219 at icq
On Mon, Mar 31, 2008 at 5:17 PM, Ray Leventhal <centos at swhi.net> wrote:> HI folks, > > Apologies if this is OT. If it is, please msg me offllist and I'll > carry on my searching elsewhere. > > Where does mysql actually store databases and tables in the filesystem? > > Thanks in advance > -RayIf you're using the stock settings from an RPM, probably in /var/lib/mysql -- -matt
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Ray Leventhal wrote: | Where does mysql actually store databases and tables in the filesystem? If you're asking because you're concerned about backup/restore then you'll want to forget about the location of the data files and instead use the mysqldump command to make your backups. If you're interested from the capacity planning standpoint then the answer is that CentOS configures MySQL to live in the /var/lib/mysql directory. Barry -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFH8VnsCFu3bIiwtTARAqr6AJ4+4ebIBElzscaAv4V2lzvWlawSqQCfW3pz mpjjqFcZM08jrOS6GK6r4Ho=7vI8 -----END PGP SIGNATURE-----