Hi Frederic,
mysql -p -u root < readable_SQL_file
Compared to
unreadable_binary_I_should_ask_for_the_source_and_spend_time_going_through_it_and_perhaps_recompile_it
I'm sure Simone intention was good, I didn't mean to criticize. It's just
that there are plain standard solutions... Why not using them?
cheers
alessandra
On Mon, 29 Jan 2007, Frederic Brochu wrote:
> Hi Alessandra,
>
>
> Any solution leading to the same result will do.
> I could feedback alternative solutions to atlas if I had detailed
> procedures (I think that Simone's intentions was to provide sysadmins with
> something straightforward to run).
>
> Discussing the pro and cons of favourite methods (direct sql update vs
> DPM APIs vs dedicated script) can be left to the ops meeting.
> Needless to say I will only feedback the most straightforward method.
>
> Cheers,
>
> Frederic
>
>
> On Mon, 29 Jan 2007, Alessandra Forti
> wrote:
>
> > Hi Frederic,
> >
> > mmhhh I'm not sure what other people think but I would prefer a plain file
> > with SQL commands if there are any changes to apply to any mysql/postgrees
> > DB without having to go through someone else code and recompile it or
> > rewrite my own file. Do you think you could spread the word to atlas? or
> > do you think maybe it is something we should raise as a general point at
> > the ops meeting?
> >
> > thanks
> >
> > cheers
> > alessandra
> >
> >
> > On Mon, 29 Jan 2007, Frederic Brochu wrote:
> >
> > > And the final word from Simone, about Greig and Alessandra's comments:
> > >
> > > Cheers,
> > >
> > > Frederic
> > >
> > >
> > > Date: Mon, 29 Jan 2007 12:30:20 +0100
> > > From: Simone Campana <[log in to unmask]>
> > > To: Frederic Brochu <[log in to unmask]>
> > > Subject: RE: storage in UK cloud (fwd)
> > >
> > > Hi Frederic. Sites can do this as they wish. If they are more
> > > comfortable writing their SQL, recompiling the code or using DPM native
> > > APIs, it is really up to them.
> > >
> > > Simone
> > >
> > >
> > >
> > >
> >
> > Alessandra Forti
> > NorthGrid Technical Coordinator
> > University of Manchester
> >
>
Alessandra Forti
NorthGrid Technical Coordinator
University of Manchester
|