transfer mysql to mysql

legal-medium

I want to transfer STRUCTURE and DATA from one MySQL server to another MySQL server.

Both MySQL databases are on different servers in different locations.

I do not want to create a sql file (size is to large) What I would like is a way for BOTH MySQL databases to talk to each other and do the copy that way.

I have looked at the MySQL documentation and cannot find what I am looking for.

Any help would be appreciated.

Thanks

Christopher

LordShryku

Dont wanna create a SQL file huh? You must have millions of records for that to be the bad solution. Anyway, you can create a php script to list the databases, then create them on the other server. Then for each DB, list of tables. Then for each table, do a SHOW CREATE TABLE table. Then duplicate that. Then do a SELECT *, and INSERT all of it. Real pain in the @ss.

[edit]BTW...what kinda servers are these? Windows or Nix/BSD?[/edit]

legal-medium

Linux RH, 1 gig database

LordShryku

Well, have fun with that. Making the SQL file is the MySQL standard way of doing this, and is more reliable.

legal-medium

well, should I create a sql file and ftp it over to the other server and execute the sql file from SSH?

drawmack

you can do this by insterting a select and where you insert into one database with the select from another database.