- machiel.richards machiel.richa...@gmail.com wrote
How can we do this when running in a cron script?
Hi!
You can use following command in a shell script running from cron:
echo select * from table into outfile '/path/to/output/file' fields
terminated by '|'; | mysql
.
Regards
-Original Message-
From: Nicola Salvemini [mailto:nicolasalvem...@yahoo.it]
Sent: 07 January 2010 3:45 PM
To: sureshkumar...@gmail.com; Mikhail Berman; machiel.richards
Cc: mysql@lists.mysql.com
Subject: Re: table export in cron
- machiel.richards machiel.richa...@gmail.com
Hi Machiel, all!
machiel.richards wrote:
Hi All
[[...]]
What the Oracle guys found was that some of the fields were blank even
though the fields were configured as not nullable.
I found that where this is the case, the users entered a blank space
which is then
On Thu, 7 Jan 2010 15:48:24 +0200, machiel.richards
machiel.richa...@gmail.com wrote:
Hi All
What the Oracle guys found was that some of the fields were blank even
though the fields were configured as not nullable.
I found that where this is the case, the users entered a
machiel.richards wrote:
How can we do this when running in a cron script?
mysql -e select * from table into outfile '/path/to/output/file'
fields terminated by '|' ?
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi Machiel,
As an alternative, you might consider use of mysqdump command,
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html, in a KSH/BASH
script running from cron
The script might look like this:
=
!#/bin/ksh
mysqldump --password=yourpassword [more switches needed here]
To: machiel.richardsmachiel.richa...@gmail.com
Cc: mysql@lists.mysql.com
Subject: Re: table export in cron
Hi Machiel,
As an alternative, you might consider use of mysqdump command,
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html, in a KSH/BASH
script running from cron
The script might look like this:
=
!#/bin
:14
To: machiel.richardsmachiel.richa...@gmail.com
Cc: mysql@lists.mysql.com
Subject: Re: table export in cron
Hi Machiel,
As an alternative, you might consider use of mysqdump command,
http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html, in a KSH/BASH
script running from cron