MySQL + Tookan Integrations
Appy Pie Connect allows you to automate multiple workflows between MySQL and Tookan
- No code
- No Credit Card
- Lightning Fast Setup
10 Million man hours saved
MySQL is currently the most popular database management system software used for managing the relational database.
About Tookan
Tookan is a delivery management software that assists companies in streamlining dispatch processes and improving communication between managers and delivery drivers.
Tookan IntegrationsBest ways to Integrate MySQL + Tookan
-
When this happens...
New Row
Then do this...
Add Customer
-
When this happens...
New Row
Then do this...
Add Agent
-
When this happens...
New Row
Then do this...
Create a Pickup Task
-
When this happens...
New Row
Then do this...
Create a Delivery Task
-
When this happens...
New Row
Then do this...
Create an Appointment Task
-
When this happens...
{{item.triggerTitle}}
Then do this...{{item.actionTitle}}
It's easy to connect MySQL + Tookan without coding knowledge. Start creating your own business flow.
-
New Row
Triggered when you add a new row.
-
New Row (Custom Query)
Triggered when new rows are returned from a custom query that you provide. Advanced Users Only
-
New Table
Triggered when you add a new table.
-
New Task
Trigger when new task created.
-
Create Row
Adds a new row.
-
Delete Row
Delete a row.
-
Update Row
Updates an existing row.
-
Add Agent
Adds a new agent
-
Add Customer
Create a new customer.
-
Create a Delivery Task
Create a Delivery Task
-
Create a Pick and Delivery Task
Create a Pick and Delivery Task.
-
Create a Pickup Task
Creates a pick task.
-
Create an Appointment Task
Create an Appointment Task
-
Create an FOS Workflow Task
Create an FOS Workflow Task.
How MySQL & Tookan Integrations Work
-
Step 1: Choose MySQL as a trigger app and authenticate it on Appy Pie Connect.
(30 seconds)
-
Step 2: Select "Trigger" from the Triggers List.
(10 seconds)
-
Step 3: Pick Tookan as an action app and authenticate.
(30 seconds)
-
Step 4: Select a resulting action from the Action List.
(10 seconds)
-
Step 5: Select the data you want to send from MySQL to Tookan.
(2 minutes)
-
Your Connect is ready! It's time to start enjoying the benefits of workflow automation.
Integration of MySQL and Tookan
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:
- Install required prerequisites:
sudo apt-get -y install libpq-dev mysql-client postgresql-client-11.2 python3 postgresql-11.2 postgresql-contrib-11.2
- Download and extract Tookan:
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
- Create a Tookan config file:
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.
