Skip navigation links

MySQL Forums :: Data Warehouse :: Bulk copy/transform MySQL -> MySQL


Advanced Search

Bulk copy/transform MySQL -> MySQL
Posted by: Martin Herchl ()
Date: April 11, 2005 03:47AM

I'm looking for a procedure(tool) to copy data from one MySQL database (on server1) to another MySQL database (on server2 - another server). I'm looking for something like bulk copy.
For example: I need to copy only particular columns from source DB (not the whole table) to dest table (which has different structure than the source table) and I don't want to use LOAD DATA INFILE (text copy).

source table:
firstname varchar(10)
lastname varchar(20)
sex char(1)

dest table:
name varchar(30)
sex char(1)

definition: copy(source_table, source query, dest_table, dest_columns):
example: copy('sourcetable', 'select "firstname + lastname", sex from source', 'desttable', 'name, sex')

Any idea?

Thanx

Martin

Options: ReplyQuote


Subject Views Written By Posted
Bulk copy/transform MySQL -> MySQL 12764 Martin Herchl 04/11/2005 03:47AM
Re: Bulk copy/transform MySQL -> MySQL 5120 Ulf Wendel 04/20/2005 06:40AM
Re: Bulk copy/transform MySQL -> MySQL 4500 Peter Nolan 05/20/2005 11:06AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.