With this little tool you can connect to a MySQL database server and select tables from a specific schema to be exported as CSV files.
Create virtual environment and install dependencies (requirements)
$ virtualenv --python=python3.9 venv
$ source venv/bin/activate
(venv) $ pip3 install -r requirements.txtTo specify the location of the database server the application reads environment variables which
you can provide either via shell variables or initializing in a .env (in the working directory).
THe supported variables are:
- TCEX_HOSTNAME: the host address of the server
- TCEX_USERNAME: the user to connect to the server
- TCEX_PASSWORD: the user's password
- TCEX_DATABASE: the database (schema) from which you wish to export the tables from
(venv) $ python3 app/main.py