Re: MySQL Server uptime.

2002-03-07 Thread Jonas Björklund
Hi, > Up 212 days, > Processed 199,654 queries (average = 0.01/sec) > Processed 2 slow queries (woops ;-) don't you hate leaving out the where > statement on joins) I have also noticed that uptime is not calculated the same way as the Linux kernel. I have more uptime on the MySQL server then hos

Re: Några frågor

2002-01-24 Thread Jonas Björklund
This is an english mailinglist. Please write in english. 1. Nej. 2. Ja, du hittar det på http://www.mysql.com/downloads/contrib.html#SEC641 On Wed, 23 Jan 2002, Jimmy Geschwind wrote: > Date: Wed, 23 Jan 2002 23:22:40 +0100 > From: Jimmy Geschwind <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > S

SQL query

2002-01-22 Thread Jonas Björklund
Hi, I wonder if its possbile to make a toplist from the folowing table: +--+--+ | name | status | +--+--+ | Bob | working | | Jane | sleeping | | Joe | sleeping | | Bob | sleeping | | Bob | working | | Bob | sleeping | | Bob

Re: BACKUP command & external script.

2001-02-09 Thread Jonas Björklund
My script backuping up alla databases which is in my datadir. It's works for me. #!/bin/sh USER=root PASSWORD=somepassword BACKUPTYPE=daily if [ -x $BACKUPTYPE ] then echo "$0 " exit 0 fi for i in `ls /var/mysql|grep -E -v ".pid|.err"` ; do DB=$i ; DATE=$BACKUPTYPE ; r