Date: Fri, 02 May 2008 18:28:22 +0200 From: Zbigniew Szalbot <z.szalbot@lc-words.com> To: freebsd-questions@freebsd.org Subject: Re: handling mysql binlog data Message-ID: <481B4126.8030802@lc-words.com> In-Reply-To: <9C2A6842-CBB4-4DD6-B759-4054BCAE2C70@hughes.net> References: <481B08B2.7070702@lc-words.com> <4C629ECE-9203-4A3B-94FA-8BACEA07EE70@hughes.net> <481B3A0E.6060300@lc-words.com> <9C2A6842-CBB4-4DD6-B759-4054BCAE2C70@hughes.net>
next in thread | previous in thread | raw e-mail | index | archive | help
This is a cryptographically signed message in MIME format. --------------ms090804050402000302050601 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Hi Chris, Chris Pratt pisze: >> Thank you anyway - this was very helpful and I instantly saved a >> lot of space on a shrinking /var partition! >> > > I find it most comfortable to do this manually so I can check > my backups first. There is an example in the reply comments > below the documentation on the 5.0 version of the mysql > doc page that shows a "unix" way to set up a cron script > and automate the process. I've not tried it. > > Shrinking /var partition?: I found the ports setup of mysql to > be overly restrictive by using the /var method. It was simple > to install, shutdown mysqld, copy the contents of the /var > database files (preserving the appropriate ownership and > permissions). I then added (assuming /usr is your large > partition) > > mysql_dbdir="/usr/mysql" > mysql_datadir="/usr/mysql" > > to /etc/rc.conf and restarted. It is an outage but it helped given > I'd never have thought to size /var anywhere near what a > medium size database required. Yeah, I am in the same boat so to say... I guess copying mysql data using cp -p will preserve all the file attributes? Will any future upgrade (by means of portupgrade) not change the custom mysql location back to /var/db/mysql? Thanks again Chris! -- Zbigniew Szalbot www.lc-words.com --------------ms090804050402000302050601 Content-Type: application/x-pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" Content-Description: S/MIME Cryptographic Signature MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIIDzCC AmIwggHLoAMCAQICEHu/rJNLTC9H4eJZYOf+/Z0wDQYJKoZIhvcNAQEFBQAwYjELMAkGA1UE BhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMT I1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBMB4XDTA4MDQyNjE1MjAzOVoX DTA5MDQyNjE1MjAzOVowSDEfMB0GA1UEAxMWVGhhd3RlIEZyZWVtYWlsIE1lbWJlcjElMCMG CSqGSIb3DQEJARYWei5zemFsYm90QGxjLXdvcmRzLmNvbTCBnzANBgkqhkiG9w0BAQEFAAOB jQAwgYkCgYEAwBXt/3Jlh3DcJScjw091dfTrKTsz9LxRe5EC6YtlCOaRtnkZIPVF0BfpVTy1 rRE+8LWJLq9fEgGAJPOqqgy9gHV9wmoD7F9505reTZS5Zk98eVzsPWjMHBaRIYxiVMtLa7DT Dnm9M6oJDccDkS5kyz/BtsJnsmUomxR68noMxAECAwEAAaMzMDEwIQYDVR0RBBowGIEWei5z emFsYm90QGxjLXdvcmRzLmNvbTAMBgNVHRMBAf8EAjAAMA0GCSqGSIb3DQEBBQUAA4GBAByS +Jt3BW2uX6CyiFXfz6ninAcCXkPSEHtjgcAHZGwV/TgEio1qKu60Pyn9ycP72XrRzEzCTG9a 85K+fmg6YjMNrrnjrEOlH+FqUt1tNj/ySrxxTLCipY8vakEL4jAyiybYecCj8JQHRxCUGbQo CVHnx+eFWySCZvEwCDb1G6/uMIICYjCCAcugAwIBAgIQe7+sk0tML0fh4llg5/79nTANBgkq hkiG9w0BAQUFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcg KFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3Vpbmcg Q0EwHhcNMDgwNDI2MTUyMDM5WhcNMDkwNDI2MTUyMDM5WjBIMR8wHQYDVQQDExZUaGF3dGUg RnJlZW1haWwgTWVtYmVyMSUwIwYJKoZIhvcNAQkBFhZ6LnN6YWxib3RAbGMtd29yZHMuY29t MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDAFe3/cmWHcNwlJyPDT3V19OspOzP0vFF7 kQLpi2UI5pG2eRkg9UXQF+lVPLWtET7wtYkur18SAYAk86qqDL2AdX3CagPsX3nTmt5NlLlm T3x5XOw9aMwcFpEhjGJUy0trsNMOeb0zqgkNxwORLmTLP8G2wmeyZSibFHryegzEAQIDAQAB ozMwMTAhBgNVHREEGjAYgRZ6LnN6YWxib3RAbGMtd29yZHMuY29tMAwGA1UdEwEB/wQCMAAw DQYJKoZIhvcNAQEFBQADgYEAHJL4m3cFba5foLKIVd/PqeKcBwJeQ9IQe2OBwAdkbBX9OASK jWoq7rQ/Kf3Jw/vZetHMTMJMb1rzkr5+aDpiMw2uueOsQ6Uf4WpS3W02P/JKvHFMsKKljy9q QQviMDKLJth5wKPwlAdHEJQZtCgJUefH54VbJIJm8TAINvUbr+4wggM/MIICqKADAgECAgEN MA0GCSqGSIb3DQEBBQUAMIHRMQswCQYDVQQGEwJaQTEVMBMGA1UECBMMV2VzdGVybiBDYXBl MRIwEAYDVQQHEwlDYXBlIFRvd24xGjAYBgNVBAoTEVRoYXd0ZSBDb25zdWx0aW5nMSgwJgYD VQQLEx9DZXJ0aWZpY2F0aW9uIFNlcnZpY2VzIERpdmlzaW9uMSQwIgYDVQQDExtUaGF3dGUg UGVyc29uYWwgRnJlZW1haWwgQ0ExKzApBgkqhkiG9w0BCQEWHHBlcnNvbmFsLWZyZWVtYWls QHRoYXd0ZS5jb20wHhcNMDMwNzE3MDAwMDAwWhcNMTMwNzE2MjM1OTU5WjBiMQswCQYDVQQG EwJaQTElMCMGA1UEChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMj VGhhd3RlIFBlcnNvbmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwgZ8wDQYJKoZIhvcNAQEBBQAD gY0AMIGJAoGBAMSmPFVzVftOucqZWh5owHUEcJ3f6f+jHuy9zfVb8hp2vX8MOmHyv1HOAdTl UAow1wJjWiyJFXCO3cnwK4Vaqj9xVsuvPAsH5/EfkTYkKhPPK9Xzgnc9A74r/rsYPge/QIAC ZNenprufZdHFKlSFD0gEf6e20TxhBEAeZBlyYLf7AgMBAAGjgZQwgZEwEgYDVR0TAQH/BAgw BgEB/wIBADBDBgNVHR8EPDA6MDigNqA0hjJodHRwOi8vY3JsLnRoYXd0ZS5jb20vVGhhd3Rl UGVyc29uYWxGcmVlbWFpbENBLmNybDALBgNVHQ8EBAMCAQYwKQYDVR0RBCIwIKQeMBwxGjAY BgNVBAMTEVByaXZhdGVMYWJlbDItMTM4MA0GCSqGSIb3DQEBBQUAA4GBAEiM0VCD6gsuzA2j ZqxnD3+vrL7CF6FDlpSdf0whuPg2H6otnzYvwPQcUCCTcDz9reFhYsPZOhl+hLGZGwDFGguC dJ4lUJRix9sncVcljd2pnDmOjCBPZV+V2vf3h9bGCE6u9uo05RAaWzVNd+NWIXiC3CEZNd4k sdMdRv9dX2VPMYIC4zCCAt8CAQEwdjBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3Rl IENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVt YWlsIElzc3VpbmcgQ0ECEHu/rJNLTC9H4eJZYOf+/Z0wCQYFKw4DAhoFAKCCAcMwGAYJKoZI hvcNAQkDMQsGCSqGSIb3DQEHATAcBgkqhkiG9w0BCQUxDxcNMDgwNTAyMTYyODIyWjAjBgkq hkiG9w0BCQQxFgQUNA4RWQes01m0nRhwU28CjUTylNIwUgYJKoZIhvcNAQkPMUUwQzAKBggq hkiG9w0DBzAOBggqhkiG9w0DAgICAIAwDQYIKoZIhvcNAwICAUAwBwYFKw4DAgcwDQYIKoZI hvcNAwICASgwgYUGCSsGAQQBgjcQBDF4MHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRo YXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBG cmVlbWFpbCBJc3N1aW5nIENBAhB7v6yTS0wvR+HiWWDn/v2dMIGHBgsqhkiG9w0BCRACCzF4 oHYwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0 ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAhB7v6yT S0wvR+HiWWDn/v2dMA0GCSqGSIb3DQEBAQUABIGAk26D8dt8Go+ia4SeVSF/70JCQaLk8ViF YRHF46ojKjeFp/zXDpPyJRC9ukEVF+iBWsN3ssbixH4SCSFkgDDq3AiotH4WZrQNbB4v1GEc cd4PF1Zy6ZEgxG/KNBlBb3gG7JglQrSkSqzZSasoucseeb80IwRnBO+GEYnftzqRq+MAAAAA AAA= --------------ms090804050402000302050601--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?481B4126.8030802>