Mysql: how can I import a table from a platform attached to LAN?

Hi everyone,
My LAN is consisted of 2 separate MySQL platforms.
In on of those 2 stations I have a database: “MyDB” that hosts a table: “MyTABLE”.
At the second station I created a database with the name: “MyDB” and I’d like to import the table “MyTABLE” into that database.
In order to do so I thought I might write the following query:

CREATE TABLE MyTABLE SELECT * FROM ip.db. MyTABLE;

I typed:

CREATE TABLE MyTABLE SELECT * FROM 10.0.0.30.MyDB.MyTABLE;

and recieved an error that says: “error 1049 unknown database 10.0.0.30”.
Can anyone help my put the right code to read (and whereby import) a table fro a remote station?
Thanks

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.