Re: table export in cron

- 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

RE: table export in cron

. 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

Re: table export in cron

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

RE: table export in cron

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

table export in cron

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

Re: table export in cron

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:

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/ksh mysqldump --password=yourpassword [more switches needed here]

Re: table export in cron

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

Re: table export in cron

: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