On 13 déc, 11:34, gazzag <gar..._at_jamms.org> wrote:
> On 13 Dec, 09:19, Vincent <mortime..._at_hotmail.com> wrote:
>
>
>
> > well, right, but I was thinking about merging data in another table
> > after import.
> > imp 1st table -> add data to a table merged_data
> > imp 2nd table -> add data to merged_data
> > ...
>
> > it's what I did actually, but I added a "drop table" between each
> > import. It works, although I'm not sure it's the best solution...
>
> > Thanks :-)
>
> The steps you need to take are as follows:
>
> 1. Import first table as normal:
>
> imp <user>/<password> file=<filename> fromuser=user1 tables=login
>
> 2. Now that the "login" table exists, a subsequent import will fail
> unless you use the IGNORE parameter:
>
> imp <user>/<password> file=<filename> fromuser=user2 tables=login
> ignore=y
>
> 3. As in step 2, to import the final table, you need the IGNORE
> parameter again:
>
> imp <user>/<password> file=<filename> fromuser=user3 tables=login
> ignore=y
>
> If the above fails, there's something else you're not telling us.
>
> HTH
>
> -g
I agree with your algorithm, i'll try again, i should have missed
something... :-/
thx.
Received on Fri Dec 14 2007 - 05:02:09 CST
