Restore Sage50 MySQL Data

I have a Sage 50 (Canadian edition) company that stores its data in MySQL-style *.frm files. After repairing corruption outside of Sage, all tables now exist only as clean exports—both *.sql dumps and matching *.csv files. My challenge is getting that data back into the working Sage50 MySQL repository so the program will recognise the company and let me complete the fiscal year-end rollover. I would like this project completed as soon as possible.

Here’s the current state:
• Schema files: original Sage-generated *.frm files still sitting in the data folder.
• Data files: full content available in *.sql and *.csv formats.
• Problem: attempts to re-import keep failing because Sage50 expects its exact table structure, indexes, triggers and constraints. Errors range from structure mismatch to Sage refusing to open the company after a manual load.

What I need from you
1. Re-establish a functional Sage50 database by aligning my exports with the existing *.frm schema (or rebuilding the correct schema if that is faster).
2. Import all current-year data so that balances, transactions and settings appear correctly inside Sage.
3. Prove success by opening the file in Sage50 and completing the year-end rollover without errors.
4. Provide a concise outline of the steps or scripts you used so I have a recovery path in future.

You should already be comfortable with Sage50 Canadian data architecture, MySQL tools (or MariaDB equivalents), and the quirks of the *.frm container format. If this sounds straightforward to you, let’s get the books closed and the new year moving.