MySQL Forums
Forum List  »  Newbie

Re: mysqlimport
Posted by: Felix Geerinckx
Date: April 20, 2005 07:45AM

Doug Hairfield wrote:
> Ok, I tried that command but it seems that none of
> my data changes. Is there something else I need
> to do? Is the --add-drop-table doing this?

Usually I put the 'use database' in manually.

You could also try the following to transfer database 'localdb' from a local machine to database 'remotedb' on remote machine 'remote_machine' (on one line):

mysqldump -ulocal_user -plocal_password localdb | mysql -hremote_machine
-uremote_user -premote_password remotedb

--
felix

Options: ReplyQuote


Subject
Written By
Posted
April 19, 2005 01:25PM
April 19, 2005 01:47PM
April 19, 2005 02:26PM
April 19, 2005 02:38PM
April 19, 2005 03:44PM
April 20, 2005 12:48AM
April 20, 2005 07:18AM
Re: mysqlimport
April 20, 2005 07:45AM
April 20, 2005 08:22AM
April 20, 2005 08:49AM
April 20, 2005 08:58AM


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.