Re: Design advice
On 10/8/2010 3:31 PM, Neil Tompkins wrote: Hi Shawn Thanks for your response. In your experience do you think I should still retain the data used to generate the computed totals ? Or just compute the totals and disregard the data used ? In my experience, the details matter. Also in my experience, as soon as you designate some bit of data as useless it will somehow become critical that you find it again. You should probably keep that lowest-level detail data somewhere safe even if you never plan to need it for direct statistics reporting after you use it to generate the first level or two of time-based summary tables. -- Shawn Green MySQL Principal Technical Support Engineer Oracle USA, Inc. Office: Blountville, TN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Backup
Hey Kranthi, If you have binlogs enabled, do a binary logs backup everyday i.e going to be your everyday backup which consists of the sql modified statements. On Sun, Oct 10, 2010 at 11:13 AM, yung inno...@gmail.com wrote: 2010/10/10 kranthi kranthikiran@gmail.com: Hi , My database size is 900GB.i don't want full database backup. I need only yesterday backup. how can I take, please help me. How about the document there: http://dev.mysql.com/doc/refman/5.1/en/backup-strategy-example.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=sureshkumar...@gmail.com -- Thanks Suresh Kuna MySQL DBA
MySQL sock file is missing: server doesn't start
hi MySQL server doesn't start because #2002 the /var/run/mysqld/mysqld.sock is missing. The server only start with sudo mysqld_safe but without the mysqld.sock file. I've checked my /etc/mysql/my.cnf file and the paths are correct for [client] and [mysqld]: /var/run/mysqld/mysqld.sock I run 5.1.41 on Ubuntu 10.04 How to resolve this issue? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Backup
I get, I use following mysqlbinlog --start-date=2010-10-09 9:55:00 \ --stop-date=2010-10-10 10:05:00 \ /var/log/mysql/bin.123456 \ /tmp/mysql_restore.sql Thanks all From: andrew.2.mo...@nokia.com [mailto:andrew.2.mo...@nokia.com] Sent: Sunday, October 10, 2010 4:46 AM To: kranthikiran@gmail.com Subject: Re: Backup hmm a yesterday backup? MySqldump using where clauses? Why do you only want yesterday? -- Sent from my HTC Desire on 3 -- - Reply message - From: ext kranthi kranthikiran@gmail.com Date: Sun, Oct 10, 2010 04:51 Subject: Backup To: bac...@lists.mysql.com bac...@lists.mysql.com Hi , My database size is 900GB.i don't want full database backup. I need only yesterday backup. how can I take, please help me. Thanks Regards, Kranti