Frequent Questions

Can non-database files be stored in a MySQL database folder without causing MySQL errors? For example, can users store the spreadsheet(s) containing county-level input data in the same folder as the county input database?

In MYSQL, each table in a database is stored as a set of three files with the table suffixes .frm, .myi and .myd. Generally, MySQL will ignore non-database files contained in the MySQL database folder.

You will notice that we keep a folder containing information about the database in a sub folder (/ReadMe) of the MySQL database folder. Supporting spreadsheets could be stored in the same way.

Have more questions? Contact Us