How can I setup a cron job to execute a SQL query, export the results to a CSV formatted file and email to an address?
Hello @LukeDouglas,
You can add cron jobs through cPanel:
Cron Jobs - Version 70 Documentation - cPanel Documentation
You'll just need to setup a custom script using a programming language such as PHP or Perl that performs all of the actions you need it to (e.g. running SQL queries, exporting results to CSV). The programming portion isn't something we can provide direct assistance with, but websites such as Stackoverflow are useful if you want to seek out help with programming.
Thank you.
You can add cron jobs through cPanel:
Cron Jobs - Version 70 Documentation - cPanel Documentation
You'll just need to setup a custom script using a programming language such as PHP or Perl that performs all of the actions you need it to (e.g. running SQL queries, exporting results to CSV). The programming portion isn't something we can provide direct assistance with, but websites such as Stackoverflow are useful if you want to seek out help with programming.
Thank you.
| Thread starter | Similar threads | Forum | Replies | Date |
|---|---|---|---|---|
|
Backups have an error from a MYSQL database export issue | Databases | 3 | |
|
SOLVED When did the format for exports change | Databases | 6 | |
|
phpMyAdmin export failing | Databases | 10 | |
| C | SOLVED [CPANEL-25765] SQL is missing from table export options in phpMyAdmin 4.8.4 | Databases | 4 | |
| M | phpmyadmin slow export and error | Databases | 7 |