Re: export multiple tables and import in a single one

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 Received on Thu Dec 13 2007 - 04:34:23 CST