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).
definition: copy(source_table, source query, dest_table, dest_columns):
example: copy('sourcetable', 'select "firstname + lastname", sex from source', 'desttable', 'name, sex')
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.