Re: MYSQL DB BACKUP

2008-09-16 Thread Krishna Chandra Prajapati
Thanks a lot. I am writing script which will take backup and copy it to another box. On Wed, Sep 17, 2008 at 11:14 AM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Can u mount that file system on the slave db and take the backup so that u > can avoid Network latency. > > regards > anandkl > > > On

Re: MYSQL DB BACKUP

2008-09-16 Thread Ananda Kumar
Can u mount that file system on the slave db and take the backup so that u can avoid Network latency. regards anandkl On 9/16/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > Yes > > On Tue, Sep 16, 2008 at 6:39 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > >> Hi Krishna, >> When u s

recommended SQL for 'category' and 'help' table

2008-09-16 Thread Fayland Lam
hi list. I want to build a category system and a help system. I think that's a very common task, and I'm curious about what's your SQLs to build these. I'm really appreciated your sharing the table structure with me, Thanks. Regards, -- Fayland Lam // http://www.fayland.org/ Foorum based on

Re: Query cache contents

2008-09-16 Thread Parvesh Garg
http://rpbouman.blogspot.com/2008/07/inspect-query-cahce-using-mysql.html - parvesh On Wed, Sep 17, 2008 at 1:15 AM, Edson Noboru Yamada <[EMAIL PROTECTED]> wrote: > Hey, Guys > > Is there a way to know what queries are in the query cache? > > > thanks > -- MySQL General Mailing List For list a

Re: Replication error 1236

2008-09-16 Thread samk
See Thread at: http://www.techienuggets.com/Detail?tx=46643 Posted on behalf of a User HI, first check the error log and find the position where the replication was terminated.Now run the mysqlbinlog utility on the binarylogs file. Now when you run the query will get the text format as a result

RE: optimize table

2008-09-16 Thread Theodore Petkantchin
Hi Ananda, 1. Long term solution: When you upgrade to MySQL 5.1 partition the table e.g. by time. This approach was used for 10s of years in the other DBs. http://dev.mysql.com/tech-resources/articles/performance-partitioning.ht ml http://dev.mysql.com/tech-resources/articles/mysql_5.1_partition

Query cache contents

2008-09-16 Thread Edson Noboru Yamada
Hey, Guys Is there a way to know what queries are in the query cache? thanks

Re: MySQL not running on fresh LAMP install

2008-09-16 Thread David Ashley
On Tue, Sep 16, 2008 at 11:02 AM, Dave M G <[EMAIL PROTECTED]> wrote: > MySQL List, > > I'm going through a post-hard-drive-crash process of reinstalling my whole > operating system, and MySQL is acting very strange. > > I installed it as I always have done, by using Ubuntu's Synaptic Package > Ma

Re: MySQL not running on fresh LAMP install

2008-09-16 Thread Josh Miller
Dave M G wrote: [EMAIL PROTECTED]:~$ ps aux | grep mysql And it said back to me: root 11171 0.0 0.0 1772 532 ?S20:36 0:00 /bin/sh /usr/bin/mysqld_safe mysql11290 0.1 0.7 126708 15424 ?Sl 20:36 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/m

MySQL not running on fresh LAMP install

2008-09-16 Thread Dave M G
MySQL List, I'm going through a post-hard-drive-crash process of reinstalling my whole operating system, and MySQL is acting very strange. I installed it as I always have done, by using Ubuntu's Synaptic Package Manager to install all the default packages for a LAMP server. Every time before

Re: MYSQL DB BACKUP

2008-09-16 Thread Krishna Chandra Prajapati
Yes On Tue, Sep 16, 2008 at 6:39 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Hi Krishna, > When u say remote server, do u mean the file system storing the backup is > on a different machine. > > regards > anandkl > > > On 9/16/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: >> >> Hi, >

Re: MYSQL DB BACKUP

2008-09-16 Thread Ananda Kumar
Hi Krishna, When u say remote server, do u mean the file system storing the backup is on a different machine. regards anandkl On 9/16/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > Hi, > > Currently, i am taking production server backup on hourly basis on the > slave > server. Is i