Integrate MySQL with Tookan

Appy Pie Connect allows you to automate multiple workflows between MySQL and Tookan

  • No code
  • No Credit Card
  • Lightning Fast Setup
20 Million man hours saved

Award Winning App Integration Platform

About MySQL

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 Integrations

Best MySQL and Tookan Integrations

  • MySQL Integration Tookan Integration

    MySQL + Tookan

    Add Customer in Tookan when New Row is created in MySQL Read More...
    Close
    When this happens...
    MySQL Integration New Row
     
    Then do this...
    Tookan Integration Add Customer
  • MySQL Integration Tookan Integration

    MySQL + Tookan

    Add Agent in Tookan when New Row is created in MySQL Read More...
    Close
    When this happens...
    MySQL Integration New Row
     
    Then do this...
    Tookan Integration Add Agent
  • MySQL Integration Tookan Integration

    MySQL + Tookan

    Create a Pickup Task to Tookan from New Row in MySQL Read More...
    Close
    When this happens...
    MySQL Integration New Row
     
    Then do this...
    Tookan Integration Create a Pickup Task
  • MySQL Integration Tookan Integration

    MySQL + Tookan

    Create a Delivery Task to Tookan from New Row in MySQL Read More...
    Close
    When this happens...
    MySQL Integration New Row
     
    Then do this...
    Tookan Integration Create a Delivery Task
  • MySQL Integration Tookan Integration

    MySQL + Tookan

    Create an Appointment Task to Tookan from New Row in MySQL Read More...
    Close
    When this happens...
    MySQL Integration New Row
     
    Then do this...
    Tookan Integration Create an Appointment Task
  • MySQL Integration {{item.actionAppName}} Integration

    MySQL + {{item.actionAppName}}

    {{item.message}} Read More...
    Close
    When this happens...
    {{item.triggerAppName}} Integration {{item.triggerTitle}}
     
    Then do this...
    {{item.actionAppName}} Integration {{item.actionTitle}}
Connect MySQL + Tookan in easier way

It's easy to connect MySQL + Tookan without coding knowledge. Start creating your own business flow.

    Triggers
  • 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.

    Actions
  • 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.

Compliance Certifications and Memberships

Highly rated by thousands of customers all over the world

We’ve been featured on

featuredon
Page reviewed by: Abhinav Girdhar  | Last Updated on July 01, 2022 5:55 am

How MySQL & Tookan Integrations Work

  1. Step 1: Choose MySQL as a trigger app and authenticate it on Appy Pie Connect.

    (30 seconds)

  2. Step 2: Select "Trigger" from the Triggers List.

    (10 seconds)

  3. Step 3: Pick Tookan as an action app and authenticate.

    (30 seconds)

  4. Step 4: Select a resulting action from the Action List.

    (10 seconds)

  5. Step 5: Select the data you want to send from MySQL to Tookan.

    (2 minutes)

  6. 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.