An official website of the United States government.

This is not the current EPA website. To navigate to the current EPA website, please go to www.epa.gov. This website is historical material reflecting the EPA website as it existed on January 19, 2021. This website is no longer updated and links to external websites and some internal pages may not work. More information »

MOVES and Related Models

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?

See More Frequent Questions about MOVES and Related Models.

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; however, any script commands to drop that database will fail.

While the MOVES default database folder includes a "read me" subfolder, we highly recommend that you store supporting spreadsheets in a separate folder with your MOVES runspecs rather than in the MySQL data folder.