*** DISCLAIMER: I have not
tested this so do it at your own risk *** :-)
I was thinking that if you
can just dump the contents out, then you can uninstall mysql-server, re-install
it (root user will have no password), re-import the database and re-create the
oscar user giving it access to the "oscar" database (and put the password in
/etc/odapw). Then if you re-run the wizard, it should just Do The Right
Thing (tm).
However, perhaps it's best
you let our database expert take a look at your problem to see if he can offer
you any better solution.
Cheers,
Bernard
From: Bruce Becker [mailto:[EMAIL PROTECTED]
Sent: Thu 04/05/2006 02:27
To: Bernard Li
Cc: gareth; [email protected]; [EMAIL PROTECTED]
Subject: Re: [Oscar-users] How to recover from a lost DB ?
Hi All.
> BTW, you have access to the database
right? Perhaps it's easier just to
> dump the contents and re-import
it?
This is kinda what we want to do, but the problem is, I'm not sure
how
to run _just_ the right script to re-import it. If you guys
could
point us to where in the OSCAR code this is done, we could drop
the
oscar database and re-import
it....
Thanks
bruce
