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 need id to auto-increment and serverid to be set by something
that I specify depending on what file im importing. 

 

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 ?

 

Thanks for any help!

Ian

Reply via email to