How to fill in a table with the same name in workbench?

Question

MySQL

Good evening! Tell me how you can fill in the base to the one already in the workbanch?
Usually I just transfer the file, and in this way it is uploaded, but here the situation is such that the table is divided into several dumps, those profil1 , profil2 ... etc.
I need to connect them all together, how can I do this?

profile.sql structure below

/*
SQLyog Ultimate
MySQL - 5.7.16-log : Database - superjob
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @[email protected]@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40101 SET @[email protected]@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @[email protected]@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`superjob` /*!40100 DEFAULT CHARACTER SET cp1251 */;

/*Table structure for table `profil` */

CREATE TABLE `profil` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `payment` int(10) unsigned NOT NULL DEFAULT '0',
  `town` smallint(5) unsigned DEFAULT NULL,
  `type_of_work` tinyint(3) unsigned DEFAULT NULL,
  `place_of_work` tinyint(3) unsigned DEFAULT NULL,
  `firstname` varchar(20) NOT NULL DEFAULT '',
  `lastname` varchar(30) NOT NULL DEFAULT '',
  `middlname` varchar(20) NOT NULL DEFAULT '',
  `pol` tinyint(3) unsigned DEFAULT NULL,
  `birthday` tinyint(3) unsigned DEFAULT NULL,
  `birthmonth` tinyint(3) unsigned DEFAULT NULL,
  `birthyear` year(4) DEFAULT NULL,
  `age` tinyint(3) unsigned DEFAULT NULL,
  `maritalstatus` tinyint(3) unsigned DEFAULT NULL,
  `children` tinyint(3) unsigned DEFAULT NULL,
  `phone1` varchar(35) DEFAULT NULL,
  `phone2` varchar(35) DEFAULT NULL,
  `email1` varchar(100) DEFAULT NULL,
  `best` mediumtext,
  `dop` mediumtext,
  `driving_licence` varchar(50) DEFAULT NULL,
  `region` tinyint(3) unsigned DEFAULT NULL,
  `education` tinyint(3) unsigned DEFAULT NULL,
  `desired_profession` mediumtext,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

/*Data for the table `profil` */

insert  into `profil`(`id`,`payment`,`town`,`type_of_work`,`place_of_work`,`firstname`,`lastname`,`middlname`,`pol`,`birthday`,`birthmonth`,`birthyear`,`age`,`maritalstatus`,`children`,`phone1`,`phone2`,`email1`,`best`,`dop`,`driving_licence`,`region`,`education`,`desired_profession`) values (128,36000,33,6,0,'Александр','Новиков','Юрьевич',2,8,10,1977,34,2,2,'','','[email protected]','Компьютерные навыки:\nMS Windows 98/2000/ME, MS Word, MS Excel, MS Outlook, Электронная почта, Навигирование в Интернет','Водительское удостоверение \"В\"\nФутбол, билльярд, теннис.','',6,2,'Региональный менеджер, коммерческий директор');

Answer 1

If you need to REPLACE a table, add DROP TABLE ... IF EXISTS;. And even easier - check this option when you make a dump.