know Dbeaver has such option but i don't know how it's done
DBeaver does a SELECT from the table using a connection and INSERT the rows it receives in another connection. If you want to directly connect a MySQL to another database, search for "MySQL federated engine"
Ok i see I have a mysql that every 1 month i need to copy a table from there to another 7 mysqls i want to do it automatically, best option will be dump & restore? will check MySQL federated engine
Open query tab and then select your query do a right click select Execute -> Export from Query
Обсуждают сегодня