I've made a python application the relies on a mysql database. Is there anyway I could somehow save the mysql database into a file format along with the code to be distributed to my teacher? He needs to be able to view the code and run it, so I am not able to export it to a .exe file. I'm currently using MYSQL workbench to run my database on mac. Where as my teacher uses a PC and uses Microsoft access
Basically, I want it where I have a folder that container my program saved as a .py file, and the mysql file in the same folder, and my teacher will simply open my code and run it, and the program fully works and runs with the database fully integrated.
I think you have 2 options.
Option A would be to export a so called MySQL dump, send it with the files and use Python to import it into the MySQL database. This option requires that your teacher has MySQL installed.
Option B would be to not use a database application and work with a CSV file instead. With this option you can just send the CSV file with your code. This option obviously requires to change your Python code so it uses the CSV file instead of the database.
From my point of view (I may miss something) you should not have a database installer in your files which installs a DB on your teachers‘ computer
Saving mysql database in file, to be distributed to teacher along with python application