MySQL Forums
Forum List  »  Newbie

Re: mysqlimport
Posted by: Felix Geerinckx
Date: April 19, 2005 02:38PM

Doug Hairfield wrote:

> Thanx, I am now getting an error that the table is
> already there.

You need a "DROP TABLE IF EXISTS foo;" in your dump. Add the option
--add-drop-table to your mysqldump command

> I basicly want to run one script from my machine,
> have it dump the db in staging and then put it on
> the production db on the remote machine. Is using
> mysqldump and the command from you previous post
> the right way to go?

It's my prefered way (and it works :-)

--
felix

Options: ReplyQuote


Subject
Written By
Posted
April 19, 2005 01:25PM
April 19, 2005 01:47PM
April 19, 2005 02:26PM
Re: mysqlimport
April 19, 2005 02:38PM
April 19, 2005 03:44PM
April 20, 2005 12:48AM
April 20, 2005 07:18AM
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.