Related

Product Now Available: Managed MySQL Databases Product
Need help to troubleshoot mysqlnd_ms setup on PHP72 with php-fpm Question Question
Hi, I am not familiar with droplets and linux whats the easiest way to access my files Question Question

Question

What's the easiest way to setup automatic nightly SQL script executions?

Posted September 25, 2020 333 views
MySQLSQL

Hi there,

I was wondering how I could most easily setup nightly SQL script executions using the RDBMS here. I’m hoping to build a MySQL or Microsoft SQL Server database (as I learned how to use these in college) here for a personal learning project.

Every night, I’d like to run some CRUD queries to update my tables. Can anyone please point me in the right direction?

Thank you!

Add a comment
niroxu
By:
niroxu

Related

Product Now Available: Managed MySQL Databases Product
Need help to troubleshoot mysqlnd_ms setup on PHP72 with php-fpm Question Question
Hi, I am not familiar with droplets and linux whats the easiest way to access my files Question Question
Add a comment
1 comment
  • niroxu September 25, 2020
    Reply Report

    Sorry, one more question. As I’m hoping to use the free tier for now, is it correct to say that I would be using Kubernetes to host my MySQL database?

    I have about 5 relational tables with a few dozen records in each.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer
KFSys September 25, 2020

Hi @nirox,

My suggestion would be for you to use cron jobs. The cron jobs should be executed at night whenever you want and they should be scripts. In these scripts, you can specify what database queries to be done. I think that’s the best option and one that is largely used in most setups!

Regards,
KFSys

Reply Report

Related

Looking for something else?

Ask a new question Search for more help