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 11:
>
> --
> 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 mysql
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 comma
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 t
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..."
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 o
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 b
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 recentl
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
