[root@kvm3 ~]# ll dyw.sql -rw-r--r--. 1 root root 7314 Jan 30 14:45 dyw.sql
mariadb root@localhost:dyw> drop table animals; You're about to run a destructive command. Do you want to proceed? (y/n): y Your call! Query OK, 0 rows affected Time: 0.012s
mariadb root@localhost:dyw> show tables; +----------------+ | Tables_in_dyw | +----------------+ | clone1_animals | | clone_animals | | dcount | | employees | | indextab | | person | | tbl | +----------------+ 7 rows in set Time: 0.024s
[root@kvm3 ~]# mysql -uroot -p123qwe dyw < dyw.sql
mariadb root@localhost:dyw> show tables; +----------------+ | Tables_in_dyw | +----------------+ | animals | | clone1_animals | | clone_animals | | dcount | | employees | | indextab | | person | | tbl | +----------------+ 8 rows in set Time: 0.029s
mariadb root@localhost:dyw> select * from animals; +----+---------+------+ | id | name | foot | +----+---------+------+ | 1 | dog | 4 | | 2 | cat | 4 | | 3 | chicken | 2 | | 15 | bird | 2 | +----+---------+------+ 4 rows in set Time: 0.030s