Migrate data from Database to different server database in MySQL?

0

good I have the following panorama

I have a database called Mybase in which there is a table called mytabla on a server

and I have another server where I have a database called Mybase2 in which there is a table called MyTabla2 equal (same columns as the table called mytabla )

Previously because I did not have access to the Mybase database, I migrated the data from table to table with a CSV file

but now that I have accesses I want to know if there is a way to directly migrate data from table to table

The two databases were created in MySQL but they are not on the same server

    
asked by Wilfredo Aleman 13.12.2017 в 18:49
source

1 answer

2

If you are using Windows you can download a free software called Heidi .

This tool has an option to export your database as an .sql file or it connects you with the 2nd server so that you can export your data to another database that you have on another server.

    
answered by 13.12.2017 / 20:21
source