// Dummy data for tests (you can just create one table and rest with CREATE TABLE.. SELECT.. if you prefer instead of creating each tables and populating)

create database if not exists test;
use test;
drop table if exists t1;
CREATE TABLE `t1` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50),
  PRIMARY KEY (`id`)
) ENGINE=innodb;

set @id:=0;
insert into `t1` values (@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000));
insert into `t1`(`id`,`name`)
select @id:=@id+1,md5(rand()*1000000) from `t1` k1, `t1` k2, `t1` k3, `t1` k4,`t1` k5,`t1` k6, `t1` k7, `t1` k8, `t1` k9,`t1` k0,`t1` ka, `t1` kb, `t1` kc, `t1` kd limit 50000;

drop table if exists t2;
CREATE TABLE `t2` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50),
  PRIMARY KEY (`id`)
) ENGINE=innodb;

set @id:=0;
insert into `t2` values (@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000));
insert into `t2`(`id`,`name`)
select @id:=@id+1,md5(rand()*1000000) from `t2` k1, `t2` k2, `t2` k3, `t2` k4,`t2` k5,`t2` k6, `t2` k7, `t2` k8, `t2` k9,`t2` k0,`t2` ka, `t2` kb, `t2` kc, `t2` kd limit 50000;

drop table if exists t3;
CREATE TABLE `t3` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50),
  PRIMARY KEY (`id`)
) ENGINE=innodb;

set @id:=0;
insert into `t3` values (@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000));
insert into `t3`(`id`,`name`)
select @id:=@id+1,md5(rand()*1000000) from `t3` k1, `t3` k2, `t3` k3, `t3` k4,`t3` k5,`t3` k6, `t3` k7, `t3` k8, `t3` k9,`t3` k0,`t3` ka, `t3` kb, `t3` kc, `t3` kd limit 50000;

drop table if exists t4;
CREATE TABLE `t4` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50),
  PRIMARY KEY (`id`)
) ENGINE=innodb;

set @id:=0;
insert into `t4` values (@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000));
insert into `t4`(`id`,`name`)
select @id:=@id+1,md5(rand()*1000000) from `t4` k1, `t4` k2, `t4` k3, `t4` k4,`t4` k5,`t4` k6, `t4` k7, `t4` k8, `t4` k9,`t4` k0,`t4` ka, `t4` kb, `t4` kc, `t4` kd limit 50000;

drop table if exists t5;
CREATE TABLE `t5` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50),
  PRIMARY KEY (`id`)
) ENGINE=innodb;

set @id:=0;
insert into `t5` values (@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000)),(@id:=@id+1,md5(rand()*1000000));
insert into `t5`(`id`,`name`)
select @id:=@id+1,md5(rand()*1000000) from `t5` k1, `t5` k2, `t5` k3, `t5` k4,`t5` k5,`t5` k6, `t5` k7, `t5` k8, `t5` k9,`t5` k0,`t5` ka, `t5` kb, `t5` kc, `t5` kd limit 50000;

// take a dump

[umshastr@hod03]/export/umesh/mysql-5.1.73: bin/mysqldump -uroot -p -S /tmp/mysql_ushastry.sock --databases test --tab /tmp/

-- Should create 5 load files

 ls -l /tmp/t*.txt
-rw-rw-rw- 1 umshastr common 1939050 Mar 25 18:02 /tmp/t1.txt
-rw-rw-rw- 1 umshastr common 1939050 Mar 25 18:02 /tmp/t2.txt
-rw-rw-rw- 1 umshastr common 1939050 Mar 25 18:02 /tmp/t3.txt
-rw-rw-rw- 1 umshastr common 1939050 Mar 25 18:02 /tmp/t4.txt
-rw-rw-rw- 1 umshastr common 1939050 Mar 25 18:02 /tmp/t5.txt


// truncate tables before importing using mysqlimport
// 5.1.73

[umshastr@hod03]/export/umesh/mysql-5.1.73: bin/mysqlimport -uroot -S/tmp/mysql_ushastry.sock --use-threads=5 --verbose test /tmp/t*.txt
Connecting to localhost
Connecting to localhost
Connecting to localhost
Connecting to localhost
Connecting to localhost
Selecting database test
Selecting database test
Selecting database test
Selecting database test
Loading data from SERVER file: /tmp/t1.txt into t1
Selecting database test
Loading data from SERVER file: /tmp/t5.txt into t5
Loading data from SERVER file: /tmp/t4.txt into t4
Loading data from SERVER file: /tmp/t3.txt into t3
Loading data from SERVER file: /tmp/t2.txt into t2
test.t3: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Disconnecting from localhost
test.t5: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Disconnecting from localhost
test.t2: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Disconnecting from localhost
test.t4: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Disconnecting from localhost
test.t1: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Disconnecting from localhost
[umshastr@hod03]/export/umesh/mysql-5.1.73:

// 5.5.45

[umshastr@hod03]/export/umesh/mysql-5.5.44:  bin/mysqlimport -uroot -S/tmp/mysql_ushastry.sock --use-threads=5 --verbose test /tmp/t*.txt
Connecting to localhost
Selecting database test
Loading data from SERVER file: /tmp/t1.txt into t1
test.t1: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Loading data from SERVER file: /tmp/t2.txt into t2
test.t2: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Loading data from SERVER file: /tmp/t3.txt into t3
test.t3: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Loading data from SERVER file: /tmp/t4.txt into t4
test.t4: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Loading data from SERVER file: /tmp/t5.txt into t5
test.t5: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Disconnecting from localhost

// 5.6.25 

[umshastr@hod03]/export/umesh/mysql-5.6.25: bin/mysqlimport -uroot -S/tmp/mysql_ushastry.sock --use-threads=5 --verbose test /tmp/t*.txt
Connecting to localhost
Selecting database test
Loading data from SERVER file: /tmp/t1.txt into t1
test.t1: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Loading data from SERVER file: /tmp/t2.txt into t2
test.t2: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Loading data from SERVER file: /tmp/t3.txt into t3
test.t3: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Loading data from SERVER file: /tmp/t4.txt into t4
test.t4: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Loading data from SERVER file: /tmp/t5.txt into t5
test.t5: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Disconnecting from localhost

// 5.7.8

[umshastr@hod03]/export/umesh/mysql-5.7.8: bin/mysqlimport -uroot -S/tmp/mysql_ushastry.sock --use-threads=5 --verbose test /tmp/t*.txt
Connecting to localhost
Selecting database test
Loading data from SERVER file: /tmp/t1.txt into t1
test.t1: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Loading data from SERVER file: /tmp/t2.txt into t2
test.t2: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Loading data from SERVER file: /tmp/t3.txt into t3
test.t3: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Loading data from SERVER file: /tmp/t4.txt into t4
test.t4: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Loading data from SERVER file: /tmp/t5.txt into t5
test.t5: Records: 50004  Deleted: 0  Skipped: 0  Warnings: 0
Disconnecting from localhost