I am creating an online store. Every hour, the database with goods in .trs format, which is needed for almost everything in this very online store, is uploaded to the root of the site. I see two options:
1) Load the database in phpmyadmin, but how to do it automatically, for example, I did not find every hour.
2) Read the .trs file directly through php, which seems like a pretty bad and insecure idea to me.
Actually, the question is: how to automatically load a database dump in phpmyadmin?
Here is example of .trs file