Quickly Load Very Large Data Sets into Your MariaDB Database
If you're using the cPanel and pasting a bunch of insert queries, then you could save a lot of time using the LOAD DATA  command.  In this example here, I connected via `ssh` to my server and uploaded all of the world's postal codes  from opendatasoft  into a database table.   johnny@server [~/postal-code-data]# mysql -user=db_user -password=DB-pwd  Welcome to the MariaDB monitor.  Commands end with ; or \g. Your MariaDB connection id is 29899 Server version: 10.2.31-MariaDB MariaDB Server  Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.  Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.  MariaDB [(none)]> use xyz_db Database changed MariaDB [xyz_db]> LOAD DATA LOCAL INFILE 'geonames-postal-code.csv'  >INTO table geo_postal_codes fields terminated by ';';  Query OK, 1433484 rows affected, 65535 warnings (1 min 2.79 sec) Records: 1433484  Deleted: 0  Skipped: 0  Warnings: 5733970  ...
