MySQL database backup script for each table

To make a date backup of each table in the MySQL database, the idea is to take out the table name of each table first, and then use the For loop to back up each table by date

[email protected]0-171  backup]# vim dataname.txt Bamboocactuscamelliacoupondaisyfacilitygladioluslilaclilyorchildp2p_adminpansyrosetulipvioletwisteriaxxl_job 

[[email protected]0-171#!/bin/bashtime= ' Date +%f ' for I in ' Cat dataname.txt ' do Mysqldump-u root-prxw2018! $i > $i-$TIME. Sqldone

MySQL database backup script for each table