Bug? on insert into previously deleted recid

[Tim James]

I started to loaddump and it appears it will take 24 hours to complete

Would it be possible to

1.export all tables to files

2.delete all records from all tables

3.dump db via dumpxml

4.reload  dump.xml to create a clean new empty DB

5. import all tables back into the new DB


(I presume (hope) that import doesn't look at OBjptrs or changes recids)

Is this a safe way to proceed ??




On 24/04/2004, at 4:18 PM, Ruslan Zasukhin wrote:

> On 4/24/04 3:40 AM, "Tim James" <tjames1 at bigpond.net.au> wrote:
>
>>> Try XML dump then load into new fresh db
>>>
>>
>>
>> Fresh db means ?
>>
>> recreate the db in Valentina - I do not use constructors for db
>> definition ?
>> 30 tables - 250 fields !!
>>
>> or can I just reload into current db
>
> Do not reload into curent db.
>
> 1) you dump to XML
>
> 2) you move your old db to trash (but do not delete yet) or into other 
> place
>
> 3) you do LoadDump() for xml file and as result of LoadDump you get 
> new db.
>
>
> You can use VAPP or Valentina Studio for this.
>
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>