From owner-freebsd-questions@FreeBSD.ORG Fri May 2 16:28:27 2008 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 159BB1065679 for ; Fri, 2 May 2008 16:28:27 +0000 (UTC) (envelope-from z.szalbot@lc-words.com) Received: from relay.lc-words.com (relay.lc-words.com [62.121.130.110]) by mx1.freebsd.org (Postfix) with ESMTP id A082E8FC23 for ; Fri, 2 May 2008 16:28:26 +0000 (UTC) (envelope-from z.szalbot@lc-words.com) Received: from localhost (localhost [127.0.0.1]) by relay.lc-words.com (Postfix) with ESMTP id EA9EBC942F for ; Fri, 2 May 2008 18:28:24 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=lc-words.com; s=mainlcwords.key.pem; t=1209745705; bh=4UnvU8UL9I5EnwSbQBnNuunr4hb UAxN66i6LUwque0o=; h=Message-ID:Date:From:Reply-To:MIME-Version:To: Subject:References:In-Reply-To:Content-Type; b=o3MZ50+YD1Z9xyTdQ1+ d7oXSH0ATZndrFREqXmTn8aaI9Bk0IhyU4BwyGMx4169wNL4ucgCaqzTj2rJdCnJguD z87srZ3DMYVjdSHzYj2A7weBIXsviRaDJpEKFMI7EA18acifAOd8NCEd4uPKwGZQX4Y d1/eJNgb8Zt7GUH6SE= Received: from relay.lc-words.com ([127.0.0.1]) by localhost (relay.lc-words.com [127.0.0.1]) (amavisd-maia, port 10024) with ESMTP id 37480-08 for ; Fri, 2 May 2008 18:28:24 +0200 (CEST) Received: from [127.0.0.1] (87-205-237-6.adsl.inetia.pl [87.205.237.6]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: info@lc-words.com) by relay.lc-words.com (Postfix) with ESMTPSA id 606ECC9421 for ; Fri, 2 May 2008 18:28:24 +0200 (CEST) Message-ID: <481B4126.8030802@lc-words.com> Date: Fri, 02 May 2008 18:28:22 +0200 From: Zbigniew Szalbot User-Agent: Thunderbird 2.0.0.12 (Windows/20080213) MIME-Version: 1.0 To: freebsd-questions@freebsd.org 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> In-Reply-To: <9C2A6842-CBB4-4DD6-B759-4054BCAE2C70@hughes.net> Content-Type: multipart/signed; protocol="application/x-pkcs7-signature"; micalg=sha1; boundary="------------ms090804050402000302050601" X-Virus-Scanned: Maia Mailguard Subject: Re: handling mysql binlog data X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list Reply-To: z.szalbot@lc-words.com List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 02 May 2008 16:28:27 -0000 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--