MySQL/MariaDB

Dump only the tables, no data (-d):

mysqldump -h 127.0.0.1 -u root -p -d