What is mdb file extension
Mdb file extension is a format use to save Microsoft Access files. They can be seen as an equivalent of sqlite in the sense where they store all informations for the access database.
How to convert .mdb to .sql
After trying multiple method, I end up using a docker image which include the mdb tools library. It’s a set of tools allowing you to work with Microsoft Access files. You can find the image repository, I used here https://github.com/Rillke/mdbtools-docker.
I use the following bash script named convert-mdb-to-mysql.sh
The command to use this script is :