Re: full import question

From: Jeremy Smith <jeremy.d.smith_at_bigfoot.com>
Date: Sat, 16 Sep 2000 02:54:46 +0100
Message-ID: <ZpAw5.5140$h21.81554@news6-win.server.ntlworld.com>

It depends on what you've lost. If you know it's scott's schema you can drop scott which will delete all his tables, recreate scott and then use the import fromuser=scott touser=scott to bring his tables back

Jez

<susana73_at_hotmail.com> wrote in message news:8puguc$8gg$1_at_nnrp1.deja.com...
> Hi,
>
> I have a daily full export(full=y) dump file. My database isn't crash
> but we have screw up some of the logical data and we want to recover to
> the yesterday version. Should I do a full import or drop all the tables
> then import each tables?
>
> Thanks,
>
> Susan
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Sep 15 2000 - 20:54:46 CDT