On Thu, 7 Jan 2010 15:48:24 +0200, "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
>
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
.
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 wrote
- machiel.richards 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 into outfile '/path/to/output/file' fields
terminated by '|';" | mysql --user= --password=
;
Bye!
> Date: Wed, 06 Jan 2010 10:42:14
> To: machiel.richards
> Cc:
> 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
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/ksh
mysqldump --password=yourpassword [more switches needed here
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]
your_da
machiel.richards wrote:
How can we do this when running in a cron script?
mysql -e "select * from into outfile '/path/to/output/file'
fields terminated by '|'" ?
Gary
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://li
Hi all
I have a question regarding exporting of tables to a file
from mysql.
We need to export tables from mysql to a delimeted file
which will then be imported into another database (oracle).
We can do this manually from within mysql usin
