MySQL zabbix data table backup and upload

Open my.cnf and whitelist data export and import directory:

[mysqld]
secure-file-priv=/backup01

Allow eveyone to write:

chmod 777 /backup01

Download data from old DB:

USE z50;
SELECT * FROM trends INTO OUTFILE '/backup01/trends.tsv' FIELDS TERMINATED BY '\t' ENCLOSED BY '"' LINES TERMINATED BY '\n';

Upload to new:

USE z70;
LOAD DATA INFILE '/backup01/trends.tsv' INTO TABLE trends FIELDS TERMINATED BY '\t' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;

Watch:

watch -n1 "ls -lt /var/lib/mysql/z70 | grep '#'"