Re: Backup

2010-10-10 Thread kranthi
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

MySQL sock file is missing: server doesn't start

2010-10-10 Thread spacemarc
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.

Re: Backup

2010-10-10 Thread Suresh Kuna
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 wrote: > 2010/10/10 kranthi : > > > > > > Hi , > > > > My database size is 900GB.i don'

Re: Design advice

2010-10-10 Thread Shawn Green (MySQL)
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 experie