R
R
Roman2019-10-22 17:23:50
MySQL
Roman, 2019-10-22 17:23:50

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

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 the question

In order to leave comments, you need to log in

2 answer(s)
M
Max, 2019-10-22
@procode

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

I
Igor, 2019-10-22
@trooper

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

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question