Auto Export Table's Data from MySQL DB to CSV File Periodically

Question

So I am working on developing an app, that requires auto export every week at Saturday 23.59 P.M. Is there any ways to make an auto export table's data from MySQL DB to CSV File every week (ex: Saturday 23.59 P.M.)?

I've found this question but it didn't answer my case.

Can somebody show me how to do this case? Thanks in advance

Write a simple mysql dump/export query to export data in CSV format, then just put that query in scheduler or a crontab for automated backup — Mangesh Sathe, Apr 23 '19 at 08:48

score 0 · Answer 1 · answered Apr 23 '19 at 08:29

0

To generate a CSV from your database table, you can use PhpSpreadsheet by PhpOffice. To regularly do jobs, you can use cron on your server.

answered Apr 23 '19 at 08:29

Sixtus

155
8

well, cron must be a simple solution for this. I'll try cron – arnold_p Apr 24 '19 at 01:41

Auto Export Table's Data from MySQL DB to CSV File Periodically

1 Answers1