title: Export mysql data from query to csv automatically every week. Possible?
body: <p>I have a problem, that i want to export data automatically every week to a csv is it possible? </p>
  
  <p>I have my code in a stored procedure and i have an event that's fires every week. </p>
  
  <p>My stored procedure </p>
  
  <pre><code>DELIMITER $$
  
  CREATE DEFINER=`lower`@`%` PROCEDURE `backup1`()
  BEGIN
  
  My query
  
  
  
  INTO OUTFILE '/tmp/nytest2.csv'
  FIELDS TERMINATED BY ','
  ENCLOSED BY '"'
  ESCAPED BY '\\'
  LINES TERMINATED BY '\n';
  
  END
  </code></pre>
  
  <p>My event </p>
  
  <pre><code>CREATE EVENT backup_fil3
  ON SCHEDULE
  AT CURRENT_TIMESTAMP + INTERVAL 7 Day
  DO CALL backup1;
  </code></pre>
  
  <p>And my second question is how can i access the csv file or can i save it directly to, for example dropbox?</p>