I want to know two things:-
[A] What are the tables in database that are associated with attributes and attribute sets ?
I have searched the database and found these table names: -
[B] My question is,
Let I export these tables using PhpMyAdmin from my site;
Then I import this file in my magento database at another site;
Should I expect that, in this way, my custom created attributes and attribute sets are transferred to my other site ?
Magento Version: 2.1.9 and 2.1.11
Not sure this is good idea. Tables are very often interrelated and linked with other info. In case you already have some products on another store, ids of attributes might change and then cause problems with products.
Maybe free extension will be a solution for one-time operation? Here is the article describing the one with necessary functionality working for Magento 2 -