I want to automate the process of dumping one table from MySQL and uploading it to GitHub - what are the steps?

Question

MySQL

subject)
I need in the Ubuntu Server 18.04 environment:
1. Once a day, by cron, or upon updating the MySQL table, make a backup copy of it (preferably in JSON format).
2. Post it as a new commit to a GitHub repository.
How to do it step by step?
What are the best tools to use?
I'm familiar with PHP - is that enough for me, or is shell scripting a must?

Answer 1

1. table to json
2. git add ... git commit ...
?

Answer 2

Wouldn't a replica solve your question? https://ruhighload.com/%D0%9A%D0%B0%D0%BA+%D0%BD%D...