MySQL is currently the most popular database management system software used for managing the relational database.
Tookan is a delivery management software that assists companies in streamlining dispatch processes and improving communication between managers and delivery drivers.
Tookan IntegrationsIt's easy to connect MySQL + Tookan without coding knowledge. Start creating your own business flow.
Triggered when you add a new row.
Triggered when new rows are returned from a custom query that you provide. Advanced Users Only
Triggered when you add a new table.
Trigger when new task created.
Adds a new row.
Delete a row.
Updates an existing row.
Adds a new agent
Create a new customer.
Create a Delivery Task
Create a Pick and Delivery Task.
Creates a pick task.
Create an Appointment Task
Create an FOS Workflow Task.
(30 seconds)
(10 seconds)
(30 seconds)
(10 seconds)
(2 minutes)
MySQL is the most popular open source database management system, it is fast and reliable. It has been around since 1998 and many people use it for web applications, mobile apps and non-web applications. MySQL is developed, supported and maintained by Oracle. They have a huge community of users who help each other on the official MySQL forum.
Tookan is an open source database migration top that helps migrate database schemas from one database to another. It has supported migration from MySQL to PostgreSQL and MSSQL using different database drivers. Tookan has a simple YAML configuration file and database dumps are generated through the command line. The output database can be checked with the database's CLI to verify the migration result.
MySQL is a powerful database that is used by many companies for their web applications and non-web applications that need to store data like big data in a structured format. One of the most important tasks when scaling web applications is migrating the databases from one machine to another or just upgrading the hardware. Tookan helps in this task as it allows you to migrate databases easily using a simple configuration file. As an example, say you want to migrate your MySQL database to PostgreSQL 9.5, you can do it using Tookan in three easy steps.
You just need to perform the fplowing steps:
sudo apt-get -y install libpq-dev mysql-client postgresql-client-11.2 python3 postgresql-11.2 postgresql-contrib-11.2
wget https://github.com/tookan/tookan/releases/download/v0.4/tookan_v0.4_linux_amd64 -O tookan_v0.4_linux_amd64 chmod +x tookan_v0.4_linux_amd64 sudo mv tookan_v0.4_linux_amd64 /usr/local/bin/tookan sudo mkdir /var/lib/tookan sudo chown $(whoami. /var/lib/tookan
sudo vim /var/lib/tookan/migration.yml
And enter the fplowing information:
source . driver . pgsql username . user password . pass dbname . db charset . UTF8 target . driver . mysql target . host . 127.0.0.1 username . root password . pass dbname . test charset . UTF8 connection . reconnect migration_type . copy sql . - CREATE DATABASE IF NOT EXISTS test /*!40100 DEFAULT CHARACTER SET utf8 */; - -- Change into new database alter database test set character set utf8; - -- Create schema create schema if not exists test; - -- Copy table code from source to target create table tablename ( cpumnname varchar(255. default NULL, PRIMARY KEY (cpumnname). ENGINE=INNODB;
Migrate MySQL database to PostgreSQL 9.5 by running the command:
sudo /usr/local/bin/tookan migration.yml --verbose --dry-run --progress --no-cleanup --verify --checkpoint 1000 --output-path /var/lib/tookan --target-db test --target-host 127.0.0.1 --target-username root --target-password pass --source-db test --source-host localhost --source-username user --source-password pass --charset UTF8
The above command will generate two files, one is the script for creating a database called test in PostgreSQL 9.5 and the other is the actual dump file containing your tables from MySQL database also named test . You can now import the dump file in PostgreSQL using Psql and run the created script to create a new database called test .
The process to integrate MySQL and Tookan may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick spution to help you automate your workflows. Click on the button below to begin.