mySQL dump remote database select tables

PHOTO EMBED

Fri Jan 21 2022 08:26:17 GMT+0000 (Coordinated Universal Time)

Saved by @swina #mysql #mysqldump #remote

mysqldump -u root -p -h host_name_or_ip -P port_number --databases db_name --tables tbl_1 tbl_2 > db_name.sql

//to import table
mysql -u -p host_name_or_ip -P port_number database_name < table_name.sql
content_copyCOPY