Re: help urgent please

2004-09-09 Thread Jim Grill
-- help please please tell me how to extract a script file of a database from mysql commandprompt. s.deepak This life is a hard fact; work your way through it boldly, though it may be adamantine; no matter, the soul is stronger Swami Vivekananda Are you looking for mysqldump?? If

Re: help urgent please

2004-09-09 Thread SGreen
One thing Jim didn't mention is that mysqldump is not a mysql client command but a standalone executable. Run it from a shell prompt (DOS prompt if you are using windows) Shawn Green Database Administrator Unimin Corporation - Spruce Pine Jim Grill [EMAIL PROTECTED] wrote on 09/09/2004

Re: Help! Urgent!

2002-08-13 Thread Thomas Spahni
On Tue, 13 Aug 2002, John Wards wrote: Hi folks i am in a bit of a panic. My server began playing up today and after ruling out apache and php it has come down to mysql. I need to find out what queries the database is running that is making it so slow. I can't figure out the command to

Re: Help Urgent!!!

2001-08-30 Thread Rafal Jank
Eugene wrote: Hello... I got a big problem in MYODBC. I am using myodbc-2.50.31-win95. When I use any MySQL Administrator to query the database that I had created for example:- SELECT * FROM dbname, they come out error like:= Your command could not be completed. MySQL returned the

Re: help (urgent!!!) with a query(SOLVED!!)

2001-08-13 Thread hassan el forkani
hi people this is the correct syntax: delete from TABLE_NAME where DATE_ADD(TIMESTAMP_COLUMN, interval 3 day) now() the function to be used is outside the parenthesis, the column name inside; this way mysql applies the function to the column (using the specified parameters interval...

RE: help (urgent!!!) with a query

2001-08-12 Thread Don Read
On 13-Aug-2001 hassan el forkani wrote: hello; can someone please help me with this query: delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) now() what i'm tryng to do is to delete all records that are 3 (or more) days old i've looked around in the manual but

Re: help (urgent!!!) with a query

2001-08-12 Thread mickalo
On Mon, 13 Aug 2001 02:47:32 +0200, hassan el forkani [EMAIL PROTECTED] wrote: hello; can someone please help me with this query: delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) now() what i'm tryng to do is to delete all records that are 3 (or more) days old i've looked

Re: help-urgent

2001-03-14 Thread Gerald L. Clark
You have provided absolutely no useful information for anyone who may wish to help you. ramamurthy rajeshkumar wrote: hi, We are using mysql as back end in our server.We are getting an problem with Mysql .the problem is mysqld is going down wiht out any error messages.in the log file it

Re: help-urgent

2001-03-14 Thread Roberto Meyer
Hello ramamurthy, rr hi, rr We are using mysql as back end in our server.We are getting an problem with Mysql .the problem is mysqld is going down wiht out any error messages.in the log file it has writted as mysql deamon rr ended no other messages is thr.but we are getting problmem recently