Importing files as elements

Hi all,

I would like to populate one column of my table with XML files -
meaning each element in that column will be an XML file. Is this
possible and how can it be done? Would it be more efficient to
store the files in the filesystem and instead keep a set of pointers
as elements in that column that point to those files?

Thanks very much

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

mysqld_safe

Hello All. when I issued this command: ps -e | grep, I noticed that mys=
qld_safe was up running in my system.
My question is: what is mysqld_safe and why was it running. Please help.=



[spbcb@naxbmisq03 ~]$ ps -e | grep -i mysql
11989 ? 00:00:00 mysqld_safe
12025 ? 13:28:39 mysqld

********************************************
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.

If you are not the intended recipient, you are hereby notified
that any dissemination of this communication is strictly prohibited.

If you have received this communication in error, please erase
all copies of the message and its attachments and notify us
immediately.

Thank you.
********************************************

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: mysqld_safe

--- On Mon, 29/3/10, Brown, Charles wrote: > Hello Al=
l.=A0 when I issued this=0A> command: ps -e | grep,=A0 I noticed that mysql=
d_safe was=0A> up running in my system.=0A> My question is:=A0 what is mysq=
ld_safe and why was it=0A> running. Please help.=0A> =0A> =0A> [spbcb@naxbm=
isq03 ~]$ ps -e | grep -i mysql=0A> 11989 ?=A0 =A0 =A0 =A0 00:00:00 mysqld_=
safe=0A> 12025 ?=A0 =A0 =A0 =A0 13:28:39 mysqld=0A> My understanding =
is that mysqld_safe is the process used to start mysqld and handle any runt=
ime errors, crashes etc.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: mysqld_safe

Yeah, its just a shell script that acts as a wrapper around the mysql processes on debian systems(
maybe others, I'm not sure)
You can read it at 'less /usr/bin/mysqld_safe'

Colin

On March 29, 2010 11:51:36 am Glyn Astill wrote:
> --- On Mon, 29/3/10, Brown, Charles wrote:
> > Hello All. when I issued this
> > command: ps -e | grep, I noticed that mysqld_safe was
> > up running in my system.
> > My question is: what is mysqld_safe and why was it
> > running. Please help.
> >
> >
> > [spbcb@naxbmisq03 ~]$ ps -e | grep -i mysql
> > 11989 ? 00:00:00 mysqld_safe
> > 12025 ? 13:28:39 mysqld
>
> My understanding is that mysqld_safe is the process used to start mysqld
> and handle any runtime errors, crashes etc.
>

--
Anyone who has had a bull by the tail knows five or six more things
than someone who hasn't.
-- Mark Twain

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

timezone questions

data from one server in timezone A ported to another server in timezone B,
what will happen for the records with datetime columns?

What is the recommended way of handling this kind of issues? Thanks


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

RE: timezone questions

> -----Original Message-----
> From: Elim PDT [mailto:elim@pdtnetworks.net]=20
> Sent: Monday, March 29, 2010 5:57 PM
> To: mysql@lists.mysql.com
> Subject: timezone questions
>=20
> data from one server in timezone A ported to another server=20
> in timezone B, what will happen for the records with datetime columns?

If you have a timezone stored on your server, then all dates/times are
stored relative to that. If you now change it, say you were in CA and =
moved
to NY, your times retrieved are now actually 3 hours off technically
depending. Even if you set your new timezone to NY. mySQL doesn't store =
the
timezone you started with. It just stores that you created the record at
noon let's say. That noon is the noon where the server timezone is. This
may or may not be an issue for you depending on your application. If =
you're
moving an entire company and this is a local database with respect to =
the
company (say, a time-off tracker, or payroll or something) you may not
care. All you care is that at 3pm some user asked for time off. And =
since
you all now live in NY, it's your 3pm local time.=20

Now, having said that, this in most cases is a huge deal since the web =
is
global and rarely do web pages live in such a local setting. More often,
there are people from different time zones accessing them.

> What is the recommended way of handling this kind of issues? Thanks=20

Real sites set their timezone to UTC and store everything in the =
database
as UTC as well.

Then you adjust the time on the client based upon their local timezone.

Both PHP and mySQL (and other languages) have functions to convert based
upon the TZ variable.

ÐÆ5ÏÐ=20


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: mysqld_safe

It's distributed as part of mysql. The script is responsible for
restarting mysqld if it exits with a non zero return code such as when
it crashes.

On Mon, Mar 29, 2010 at 2:40 PM, Colin Streicher
wrote:
> Yeah, its just a shell script that acts as a wrapper around the mysql pro=
cesses on debian systems(
> maybe others, I'm not sure)
> You can read it at 'less /usr/bin/mysqld_safe'
>
> Colin
>
> On March 29, 2010 11:51:36 am Glyn Astill wrote:
>> --- On Mon, 29/3/10, Brown, Charles wrote:
>> > Hello All. =A0when I issued this
>> > command: ps -e | grep, =A0I noticed that mysqld_safe was
>> > up running in my system.
>> > My question is: =A0what is mysqld_safe and why was it
>> > running. Please help.
>> >
>> >
>> > [spbcb@naxbmisq03 ~]$ ps -e | grep -i mysql
>> > 11989 ? =A0 =A0 =A0 =A000:00:00 mysqld_safe
>> > 12025 ? =A0 =A0 =A0 =A013:28:39 mysqld
>>
>> My understanding is that mysqld_safe is the process used to start mysqld
>> =A0and handle any runtime errors, crashes etc.
>>
>
> --
> Anyone who has had a bull by the tail knows five or six more things
> than someone who hasn't.
> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0-- Mark Twain
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Deric.bergen@g=
mail.com
>
>



--=20
Eric Bergen
eric.bergen@gmail.com
http://www.ebergen.net

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg