RE: Re-importing a mysqldump file

2006-06-25 Thread Ian Barnes
Hi, No unfortunately not... Cheers Ian > -Original Message- > From: John Meyer [mailto:[EMAIL PROTECTED] > Sent: 25 June 2006 05:41 PM > To: mysql@lists.mysql.com > Subject: Re: Re-importing a mysqldump file > > Ian Barnes wrote: > > Is this possible? Or woul

Re: Re-importing a mysqldump file

2006-06-25 Thread John Meyer
Ian Barnes wrote: Is this possible? Or would the best way be to import the dumped file into a temp table and then select out of the temp table into my correct table ? Anyway to use a trigger? -- Online library -- http://pueblonative.110mb.com 126 books and counting. -- MySQL General Mailing

Re-importing a mysqldump file

2006-06-25 Thread Ian Barnes
Hi, I need to auto re-import a mysqldump file, but when importing it I need to make a certain field a value for all information imported. For example my db looks like this: Id Name Value Serverid Now, on the remote server, name and value get exported, and when I re-import it here, I