AW: DROP CONNECTIONS OF DATABASE

Robert Brenstein rjb at robelko.com
Wed Mar 21 12:11:57 CDT 2012


On 3/21/12 8:36 AM, "Fabian Kneubuehl" <support at ysd.ch> wrote:

>  If you combine:
>
>  CLONE DATABASE [SKIPERRORS]
>  If VServer DROP ALL CONNECTIONS
>  Close files
>  Delete files
>  Rename clone of DB
>  ReOpen files
>  ev. if VServer reestablish connections
>
>  You will have a perfect REPAIR command!

If those steps are combined and provided as a command on the server, 
I would suggest to call it RESCUE or RECREATE or something like that. 
REPAIR should be reserved for a utility which fixes only problem 
areas, should such utility ever become available.

Robert


More information about the Valentina mailing list