Backup automation..

2002-07-31 Thread Nixarlidis Aris

Hi,
I am looking for a way to automate the way i take backups.
I run mysql on w2k server and I seek for a way to take backups of the 
database at certain times automaticaly.
Is out there any suggestion?
thanks.. 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Query problem..

2002-07-26 Thread Nixarlidis Aris

Hi,
I face the following situation.I have a number of clients-each with a 
unique clientid.I have a table with some records -one after 
the other in time order(datedone field) with actions checked as 'done' or 
not 'done', 
in the 'done' field which is either true or false.What I want to to, is to 
specify in my query the last record-date that has an action marked as 
done at the same time when the value x='' for every clientid.I have 
tried what you see but didin't help.

SELECT clientid FROM table_name WHERE datedone = 'max(datedone)' and done 
= 'true' and x = '' group by clientid;  

I am new to all this, so any help would be usefull
Thanks


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Re: Great tool

2002-07-11 Thread Nixarlidis Aris

MySql Front works fine on XP Home as well.I agree-very helpful tool for a 
someone new like me.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Visio-mysql driver question

2002-07-10 Thread Nixarlidis Aris

hi,
I'm trying to get Visio work with mysql to get a visual representation of 
my data base.Visio asks for a 'Visio Database Driver' for mysql.Does 
anyone know if such a driver exists or if what I;m trying to do can be 
done or not?
Thanks,Aris


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




logging question..

2002-07-05 Thread Nixarlidis Aris

Hi.
I run mysql 3.23.51-max-nt on a PIII 800-8 users.I just turned LOG and 
LOG-UPDATE on because I have problems with the user-application that 
interacts with the database.I don't know what is happening but the 
application CRASHES frequently and i just want to see what is happening through the 
logs.
This kind of info doesn't show up.What does this mean?Is any other log i 
can turn on?
Thanks,
Aris 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




selected records retrieve

2002-07-04 Thread Nixarlidis Aris

Hi to all.
I'm new in the list and in mysql as well, so excuse me for anything that 
sounds novice or in wrong place.I'm facing the following situation:

For some reason, i had to use a backup of the database.Because of the 
difference in time between my backup and the instance i had to use it,i 
want to retrieve from the database, I no longer use, some records BUT NOT 
ALL the database.Is there a way to do it?




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




selected records retrieve (fwd)

2002-07-03 Thread Nixarlidis Aris



-- Forwarded message --
Date: Tue, 2 Jul 2002 17:40:24 +0300 (EEST)
From: Nixarlidis Aris [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: selected records retrieve

Hi to all.
I'm new in the list and in mysql as well, so excuse me for anything that 
sounds novice or in wrong place.I'm facing the following situation:
For some reason, i had to use a backup of the database.Because of the 
difference in time between my backup and the instance i had to use it,i 
want to retrieve from the database, i no longer use, some records BUT NOT 
ALL the database.Is there a way to do it?Thank you all in advance.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




selected records retrieve

2002-07-02 Thread Nixarlidis Aris

Hi to all.
I'm new in the list and in mysql as well, so excuse me for anything that 
sounds novice or in wrong place.I'm facing the following situation:
For some reason, i had to use a backup of the database.Because of the 
difference in time between my backup and the instance i had to use it,i 
want to retrieve from the database, i no longer use, some records BUT NOT 
ALL the database.Is there a way to do it?Thank you all in advance.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php