Hello, I'm programming with HTML, PHP, JS, but I'm not really familar with databases. (mySQL in this case) E.g. I have written an editor for textemplates. Now, I have created some dummy templates, however I want to work with my real templates from work, (JSON export files). Can I just overwrite the database (import the files, make a backup before), or do I create a new database? How do you usually hande this? Thanks!
It all depends on what you're doing and I'm not quite understanding what you want to do with those json files. You can delete all the records from your tables and reimport if you want to get a clean copy of the data - and that's something that happens a lot in development projects.
I can Download JSON files at work, I don't have access to the database. Does this also happen a lot in dev projects, that JSON or xml is used in order to backup data?
I don't know if that's normal but if you're trying to upskill then you'd get some good practice writing scripts to json_decode the files and save each row in the database. You could then write pages to display the information, and forms to edit it and save the result.