Re: MySQL Backup solution for non-technical user

2011-05-13 Thread Joerg Bruehe
Hi everybody! Dotan Cohen wrote: Is there a simple browser-based MySQL backup solution for non-technical users. [[...]] The main features needed are: 1) Automatic scheduled off-site backups (via SSH or FTP) Off-site = good (for reliability purposes). 2) Backup multiple databases and all

Re: operation with dates

2011-05-13 Thread Hal�sz S�ndor
2011/05/12 13:06 -0500, Dan Nelson In the last episode (May 12), Rocio Gomez Escribano said: I found it, mysql select userID from user where datediff(now(), userPaymentDate) 365; This can be made more readable by using mysql's INTERVAL syntax. And less portable -- MySQL General

Re: problem

2011-05-13 Thread Johan De Meersman
- Original Message - From: Gavin Towey gto...@ffn.com The server will disconnect idle connections after a while. The wait_timeout variable controls how many seconds it will wait. You can set it for your connection when you connect by issuing a query like: SET SESSION

Re: MySQL Backup solution for non-technical user

2011-05-13 Thread Dotan Cohen
On Fri, May 13, 2011 at 10:21, Joerg Bruehe joerg.bru...@oracle.com wrote: Hi everybody! Dotan Cohen wrote: Is there a simple browser-based MySQL backup solution for non-technical users. [[...]] The main features needed are: 1) Automatic scheduled off-site backups (via SSH or FTP)

Re: operation with dates

2011-05-13 Thread Dan Nelson
In the last episode (May 12), Halßsz Sßndor said: 2011/05/12 13:06 -0500, Dan Nelson In the last episode (May 12), Rocio Gomez Escribano said: I found it, mysql select userID from user where datediff(now(), userPaymentDate) 365; This can be made more readable by using mysql's

URGENT: Change Default Location of where Database Files get written?

2011-05-13 Thread Tina Matter
I have a MySQL question that I'm hoping someone can help answer. We have a linux machine which has MySQL 5.5.8 installed. It is currently installed in this location:/opt/mysql When creating a new database, a folder (with the name of the databas) gets created in this location:

RE: URGENT: Change Default Location of where Database Files get written?

2011-05-13 Thread David Brian Chait
Add: datadir=/path/to/datadir/mysql to your my.cnf file and restart mysql. -Original Message- From: Tina Matter [mailto:ti...@umich.edu] Sent: Friday, May 13, 2011 8:22 AM To: mysql@lists.mysql.com Subject: URGENT: Change Default Location of where Database Files get written? I have a

Re: URGENT: Change Default Location of where Database Files get written?

2011-05-13 Thread Wm Mussatto
On Fri, May 13, 2011 08:21, Tina Matter wrote: I have a MySQL question that I'm hoping someone can help answer. We have a linux machine which has MySQL 5.5.8 installed. It is currently installed in this location:/opt/mysql When creating a new database, a folder (with the name of the

Re: URGENT: Change Default Location of where Database Files get written?

2011-05-13 Thread Larry Martell
On Fri, May 13, 2011 at 9:21 AM, Tina Matter ti...@umich.edu wrote: I have a MySQL question that I'm hoping someone can help answer. We have a linux machine which has MySQL 5.5.8 installed. It is currently installed in this location:    /opt/mysql When creating a new database, a folder (with

Re: URGENT: Change Default Location of where Database Files get written?

2011-05-13 Thread Andrew Moore
There absolutely is; there is a configuration file belonging to MySQL named `my.cnf`. It can exist in many places and there's a hierarchal order of precedense. The most common of which is /etc/my.cnf. Within this file you may specify the `datadir` option to identify location you wish your data

Re: operation with dates

2011-05-13 Thread Hal�sz S�ndor
2011/05/13 09:46 -0500, Dan Nelson Datediff isn't portable, either :) What of the date arithmetic is? I looked at it, and saw beside much that it was MySQL extension. But at least a function of fixed arguments looks like any other function; there is hope of writing one. The INTERVAL form is

Re: Efficiency of NULLIFie expression

2011-05-13 Thread Hal�sz S�ndor
2011/05/12 15:15 +0200, misiaq h...@tbbs.net wrote: (...) Is the optimizer so clever as to set that test outside the expression, and only then evaluate it when houmuch and SharePrice are not equal? Try it yourself: mysql explain extended select * from table1; and then mysql show