transfering only tables not databases
Posted by: Matias Niemela
Date: November 29, 2005 07:29PM

I have two MySQL servers and I want to transfer a BIG table of information from one server to the next, however I have two seprately named databases (schema's). When I transfer a table from one database to another it attempts to create an identically named schema on the destination mysql server... And I do not have the permissions to create the schema (the same name as the schema where the information is being copied from) with the username etc... (I am using Cpanel)

So how could I make it so that it would only transfer the file, and not attempt to create a new schema into the destination mysql server. Just transfer the selected tables into the selected schema.

Thanks

Options: ReplyQuote


Subject
Written By
Posted
transfering only tables not databases
November 29, 2005 07:29PM


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.