how to insert the remote table data into another table in my local computer in mysql?

Question

can any body tell me. I have a remote table from which I need to import part of the data and I need to place into my table which is in my computer(local). I know select-into command and its use but dont know use it for such kind of situations.

Thanks in advance

Answer 1

Try this from your local machine:

mysqldump -u username -p password -h remote_host --databases remote_database --tables remote_table --where="id=757575" | mysql local_database -u username -p password

Answer 2

To export the data from a remote table use below command you can also use where clause in it if u need specific data.

select * from tablename into outfile '/etc/tablename.csv';

use mysql>show create table tablename;

copy the create table statement and create a table in your local PC then Copy that 'tablename.csv' file from remote to your local computer. and use below to import data.

load data local infile '/etc/tablename.csv' into table tablename;

Any Issues let me know.