MySQL Forums :: Newbie :: Export Recordset query to a file nightly? Ubuntu and MySQL


Advanced Search

Export Recordset query to a file nightly? Ubuntu and MySQL
Posted by: Shawn Bordeaux ()
Date: February 27, 2010 11:00AM

I am running MySQL on an Ubuntu desktop. I have a very detailed query that I would like ran nightly and then exported into a .csv file so I can ftp drop it to another server.

Can someone explain to me the steps involved in doing this? I already have a scheduler installed on my machine and have created a few bash scripts that load data files into the MySQL database but I have never tried exporting this way.

Thank you and best regards,

Shawn

Options: ReplyQuote


Subject Written By Posted
Export Recordset query to a file nightly? Ubuntu and MySQL Shawn Bordeaux 02/27/2010 11:00AM
Re: Export Recordset query to a file nightly? Ubuntu and MySQL Peter Brawley 02/27/2010 12:39PM
Re: Export Recordset query to a file nightly? Ubuntu and MySQL Shawn Bordeaux 03/01/2010 12:13PM
Re: Export Recordset query to a file nightly? Ubuntu and MySQL Peter Brawley 03/01/2010 01:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.