guru@guru-predator:~$ docker run --rm --net="host" --name pgloader dimitri/pgloader:latest pgloader --debug mysql://root:1@172.17.0.2/comm postgresql://postgres:1@127.0.0.1:5432/comm
mkdir -p #P"/tmp/pgloader/"
pgloader version 3.6.2~devel
compiled with SBCL 1.4.16.debian
sb-impl::*default-external-format* :ANSI_X3.4-1968
tmpdir: #P"/tmp/pgloader/"
2020-02-27T14:36:42.006000Z NOTICE Starting pgloader, log system is ready.
2020-02-27T14:36:42.011000Z INFO Starting monitor
2020-02-27T14:36:42.013000Z LOG pgloader version "3.6.2~devel"
2020-02-27T14:36:42.013000Z INFO     SOURCE: "mysql://root:1@172.17.0.2/comm"
2020-02-27T14:36:42.013000Z INFO SOURCE URI: #<PGLOADER.SOURCE.MYSQL:MYSQL-CONNECTION mysql://root@172.17.0.2:3306/comm {1005E9E3C3}>
2020-02-27T14:36:42.013000Z INFO     TARGET: "postgresql://postgres:1@127.0.0.1:5432/comm"
2020-02-27T14:36:42.013000Z INFO TARGET URI: #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@127.0.0.1:5432/comm {1005FE7B13}>
2020-02-27T14:36:42.013000Z DEBUG LOAD DATA FROM #<PGLOADER.SOURCE.MYSQL:MYSQL-CONNECTION mysql://root@172.17.0.2:3306/comm {1005E9E3C3}>
2020-02-27T14:36:42.021000Z DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@127.0.0.1:5432/comm {1005FE7B13}>
2020-02-27T14:36:42.022000Z DEBUG SET client_encoding TO 'utf8'
2020-02-27T14:36:42.022000Z DEBUG SET application_name TO 'pgloader'
2020-02-27T14:36:42.030000Z LOG Migrating from #<MYSQL-CONNECTION mysql://root@172.17.0.2:3306/comm {1005E9E3C3}>
2020-02-27T14:36:42.030000Z LOG Migrating into #<PGSQL-CONNECTION pgsql://postgres@127.0.0.1:5432/comm {1005FE7B13}>
2020-02-27T14:36:42.055000Z DEBUG CONNECTED TO #<MYSQL-CONNECTION mysql://root@172.17.0.2:3306/comm {1005E9E3C3}>
2020-02-27T14:36:42.059000Z SQL MySQL: sending query: -- params: db-name
--         table-type-name
--         only-tables
--         only-tables
--         including
--         filter-list-to-where-clause incuding
--         excluding
--         filter-list-to-where-clause excluding
  select c.table_name, t.table_comment,
         c.column_name, c.column_comment,
         c.data_type, c.column_type, c.column_default,
         c.is_nullable, c.extra
    from information_schema.columns c
         join information_schema.tables t using(table_schema, table_name)
   where c.table_schema = 'comm' and t.table_type = 'BASE TABLE'
         
         
order by table_name, ordinal_position;
2020-02-27T14:36:42.062000Z SQL MySQL: sending query: -- params: db-name
--         table-type-name
--         only-tables
--         only-tables
--         including
--         filter-list-to-where-clause incuding
--         excluding
--         filter-list-to-where-clause excluding
SELECT s.table_name, s.constraint_name, s.ft, s.cols, s.fcols,
       rc.update_rule, rc.delete_rule

FROM
 (
  SELECT tc.table_schema, tc.table_name,
         tc.constraint_name, k.referenced_table_name ft,

             group_concat(         k.column_name
                          order by k.ordinal_position) as cols,

             group_concat(         k.referenced_column_name
                          order by k.position_in_unique_constraint) as fcols

        FROM information_schema.table_constraints tc

        LEFT JOIN information_schema.key_column_usage k
               ON k.table_schema = tc.table_schema
              AND k.table_name = tc.table_name
              AND k.constraint_name = tc.constraint_name

      WHERE     tc.table_schema = 'comm'
            AND k.referenced_table_schema = 'comm'
            AND tc.constraint_type = 'FOREIGN KEY'
           
           

   GROUP BY tc.table_schema, tc.table_name, tc.constraint_name, ft
 ) s
             JOIN information_schema.referential_constraints rc
               ON rc.constraint_schema = s.table_schema
              AND rc.constraint_name = s.constraint_name
              AND rc.table_name = s.table_name;
2020-02-27T14:36:42.067000Z SQL MySQL: sending query: -- params: db-name
--         table-type-name
--         only-tables
--         only-tables
--         including
--         filter-list-to-where-clause incuding
--         excluding
--         filter-list-to-where-clause excluding
  SELECT table_name, index_name, index_type,
         sum(non_unique),
         cast(GROUP_CONCAT(column_name order by seq_in_index) as char)
    FROM information_schema.statistics
   WHERE table_schema = 'comm'
         
         
GROUP BY table_name, index_name, index_type;
2020-02-27T14:36:42.081000Z INFO Processing source catalogs
2020-02-27T14:36:42.086000Z NOTICE Prepare PostgreSQL database.
2020-02-27T14:36:42.088000Z DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@127.0.0.1:5432/comm {1005FE7B13}>
2020-02-27T14:36:42.088000Z DEBUG SET client_encoding TO 'utf8'
2020-02-27T14:36:42.088000Z DEBUG SET application_name TO 'pgloader'
2020-02-27T14:36:42.090000Z DEBUG BEGIN
2020-02-27T14:36:42.097000Z SQL CREATE SCHEMA comm;
2020-02-27T14:36:42.108000Z INFO Done with COPYing data, waiting for indexes
2020-02-27T14:36:42.108000Z INFO Done waiting for indexes
2020-02-27T14:36:42.116000Z NOTICE Completing PostgreSQL database.
2020-02-27T14:36:42.125000Z NOTICE Reset sequences
2020-02-27T14:36:42.127000Z DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@127.0.0.1:5432/comm {1005B40113}>
2020-02-27T14:36:42.127000Z DEBUG SET client_encoding TO 'utf8'
2020-02-27T14:36:42.127000Z DEBUG SET application_name TO 'pgloader'
2020-02-27T14:36:42.127000Z DEBUG SET client_encoding TO 'utf8'
2020-02-27T14:36:42.128000Z DEBUG SET application_name TO 'pgloader'
2020-02-27T14:36:42.133000Z DEBUG CONNECTED TO #<PGLOADER.PGSQL:PGSQL-CONNECTION pgsql://postgres@127.0.0.1:5432/comm {1005B61103}>
2020-02-27T14:36:42.133000Z DEBUG SET client_encoding TO 'utf8'
2020-02-27T14:36:42.133000Z DEBUG SET application_name TO 'pgloader'
2020-02-27T14:36:42.134000Z DEBUG BEGIN
2020-02-27T14:36:42.135000Z NOTICE ALTER DATABASE "comm" SET search_path TO public, comm;
2020-02-27T14:36:42.138000Z LOG report summary reset
             table name     errors       read   imported      bytes      total time       read      write
-----------------------  ---------  ---------  ---------  ---------  --------------  ---------  ---------
        fetch meta data          0          0          0                     0.043s    
         Create Schemas          0          0          0                     0.001s    
       Create SQL Types          0          0          0                     0.004s    
          Create tables          0          0          0                     0.002s    
         Set Table OIDs          0          0          0                     0.000s    
-----------------------  ---------  ---------  ---------  ---------  --------------  ---------  ---------
-----------------------  ---------  ---------  ---------  ---------  --------------  ---------  ---------
COPY Threads Completion          0          4          4                     0.000s    
 Index Build Completion          0          0          0                     0.000s    
        Reset Sequences          0          0          0                     0.007s    
           Primary Keys          0          0          0                     0.000s    
    Create Foreign Keys          0          0          0                     0.000s    
        Create Triggers          0          0          0                     0.000s    
        Set Search Path          0          1          1                     0.000s    
       Install Comments          0          0          0                     0.000s    
-----------------------  ---------  ---------  ---------  ---------  --------------  ---------  ---------
      Total import time          ?          0          0                     0.007s    
2020-02-27T14:36:42.155000Z INFO Stopping monitor