Re: [CentOS] mysql data
Barry L. Kline wrote: 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 Thanks to all who replied. My reason for wanting to know the location of the actual databases and tables is that I had a crash and rebuilt a new system. I hadn't done mysqldump(s) of the databases recently enough to the crash to be useful, so I am going to temporarily mount the drive that contained /var from the old system (thankfully, that partition is sound) and just pull that data out. /var/lib/mysql is the answer I needed. I've since implemented a backup strategy which I found online [1]. The only difference between what I am running and the posted script is the location of the mysqldump file. In the example it's in /usr/local/bin, in Cent it's in /usr/bin Kind regards, -Ray [1] http://www.tech-recipes.com/mysql_tips221.html ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
[CentOS] mysql data
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 ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] mysql data
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/ : [EMAIL PROTECTED] ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] mysql data
On Mon, Mar 31, 2008 at 5:17 PM, Ray Leventhal [EMAIL PROTECTED] 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 -Ray If you're using the stock settings from an RPM, probably in /var/lib/mysql -- -matt ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] mysql data
-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- ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
