MySQL
MySQL is an open source relational database management system, known for its speed and reliability.
ingestr supports MySQL as a source and a destination.
URI format
The URI format for MySQL is as follows:
plaintext
mysql://user:password@host:port/dbname
URI parameters:
user
: the user name to connect to the databasepassword
: the password for the userhost
: the host address of the database serverport
: the port number the database server is listening on, the default is 3306dbname
: the name of the database to connect to
The same URI structure and table can be used both for sources and destinations. You can read more about SQLAlchemy's MySQL dialect here.