Hi Travis,
Thanks a lot for your help,
Can i have a same scrip for windows OS.
On Sat, Jul 31, 2010 at 3:29 AM, Travis Ard travis_...@hotmail.com wrote:
Something like this mysql-summary script might be useful:
http://code.google.com/p/aspersa/wiki/mysql_summary
-Travis
: script of mysql
From: pratikshadjayswa...@gmail.com
To: travis_...@hotmail.com
CC: mysql@lists.mysql.com
Hi Travis,
Thanks a lot for your help,
Can i have a same scrip for windows OS.
On Sat, Jul 31, 2010 at 3:29 AM, Travis Ard wrote:
Something like this mysql-summary script might
Hi List,
Can somebody please help me if they have a script using which we can get an
idea for installed mysql server, backup, created databases, indexes, tables,
engines, replication etc...
I will appreciate your help in advance
Thanks
Pratiksha
of scripts on the internet but you need to adjust to *your*
needs.
Running a mysql script is easy.
mysql DATABASE script
replace DATABASE with your database name and script with your script.
Read the available documentation on mysql.com to understand how to write such
script
for your self.
re
Something like this mysql-summary script might be useful:
http://code.google.com/p/aspersa/wiki/mysql_summary
-Travis
Date: Fri, 30 Jul 2010 12:19:07 +0100
Subject: script of mysql
From: pratikshadjayswa...@gmail.com
To: mysql@lists.mysql.com
Hi
script in mysql-5.0.67
Severity: serious
Priority: medium
Category: mysql
Class: sw-bug
Release: mysql-5.0.67 (Source distribution)
Server: ./mysqladmin Ver 8.41 Distrib 5.0.67, for pc-solaris2.10 on i386
Copyright (C) 2000-2006 MySQL AB
This software comes
On 20.12.2008 00:51 CE(S)T, Steve Holmes wrote:
2008/12/19 Menachem Bazian gro...@bcconsultingservices.com
Does anyone have an inno setup script so I can automatically install MySQL
with an application?
http://lists.mysql.com/mysql?unsub=sholme...@gmail.com
I don't know about anyone else,
Does anyone have an inno setup script so I can automatically install
MySQL with an application?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
2008/12/19 Menachem Bazian gro...@bcconsultingservices.com
Does anyone have an inno setup script so I can automatically install MySQL
with an application?
http://lists.mysql.com/mysql?unsub=sholme...@gmail.com
I don't know about anyone else, but I don't know what you mean by inno
setup
Hi all,
I'm releasing an installation script for installing/managing a MySQL
Cluster (NDB).
http://forge.mysql.com/projects/view.php?id=228
or
http://www.jimdowling.info/ndbinstaller-trac/
The script enables a quick install of cluster (you should be able to
install and start a localhost
Scott Haneda wrote:
on 02/04/2004 02:23 AM, Bernd Tannenbaum at [EMAIL PROTECTED]
wrote:
2 possible ways to go:
Feed a Textfile with your statement in the db:
PATH/mysql db /sql_scripts/sql_statements_as_textfile --password=pass
Give command directly In the shell-script:
PATH/mysql --skip
on 02/05/2004 07:29 AM, Michael Stassen at [EMAIL PROTECTED]
wrote:
Also, you need the FILE privilege to SELECT INTO OUTFILE.
Alternatively, you could simply redirect output to a file.
mysql dbname -e SELECT serial FROM serials /path/to/outfile
In this case, the file is written by the
Scott Haneda wrote:
on 02/05/2004 07:29 AM, Michael Stassen at [EMAIL PROTECTED]
wrote:
Also, you need the FILE privilege to SELECT INTO OUTFILE.
Alternatively, you could simply redirect output to a file.
mysql dbname -e SELECT serial FROM serials /path/to/outfile
In this case, the file is
I need to to the following
Select serial from serials;
Problem is I need to run this from a script which cron will call once a day,
how do you pass a select statement to mysql with user and pass so it can all
happen in one go?
--
-
Scott Haneda wrote:
I need to to the following
Select serial from serials;
Problem is I need to run this from a script which cron will call once a day,
how do you pass a select statement to mysql with user and pass so it can all
happen in one go?
Something like this should work:
#!/bin/bash
On Wednesday 04 February 2004 05:44, Scott Haneda wrote:
I need to to the following
Select serial from serials;
Problem is I need to run this from a script which cron will call once a
day, how do you pass a select statement to mysql with user and pass so it
can all happen in one go?
mysql
all happen in one go?
2 possible ways to go:
Feed a Textfile with your statement in the db:
PATH/mysql db /sql_scripts/sql_statements_as_textfile --password=pass
Give command directly In the shell-script:
PATH/mysql --skip-column-names -e SELECT table SET blabla db
--password=pass
Have fun
Why not use another language that has mysql hooks built in?
For example, from version 4.3.0 PHP comes with SAPI to allow scripting from
the command line, ideal for cron style tasks and it's mysql support is very
mature.
--
Russell.
--
MySQL General Mailing List
For list archives:
Why not use another language that has mysql hooks built in?
Good suggestion.
For example, from version 4.3.0 PHP comes with SAPI to allow
scripting from the command line, ideal for cron style tasks
and it's mysql support is very mature.
Or better yet, Perl. Not only is its mysql support
Sorry for the OT,
I deleted the messages from the perosn who sent me a response offlist.
In response to his personal emails in reply to:
http://lists.mysql.com/mysql/158945
he said, Perl was a write only language
(meaning it is hard to read since careless
people may do sloppy code - not me
on 02/04/2004 02:23 AM, Bernd Tannenbaum at [EMAIL PROTECTED]
wrote:
2 possible ways to go:
Feed a Textfile with your statement in the db:
PATH/mysql db /sql_scripts/sql_statements_as_textfile --password=pass
Give command directly In the shell-script:
PATH/mysql --skip-column-names -e
command directly In the shell-script:
PATH/mysql --skip-column-names -e SELECT table SET blabla db
--password=pass
I need to select into outfile on this one, which poses a problem to me, I
can not write the file to any directory as I get a permissions error since
mysql is the owner of this file
All,
I tried to run a script using MySQL++, but the procedure threw an exception
stating that there's something wrong with the syntax. I did the following:
Connection conn;
Query query(conn);
Result result;
conn.connect(dbase,host,user,passwd);
query source batch.sql; //most likely
* Thi Cao
dropt database if exists sample;
^
Don't know if this is the reason for your problem, but it should be 'drop'.
--
Roger
query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
sorry, careless typing, but that's just a typo
-Original Message-
From: Thi Cao [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 10:48 AM
To: MySQL
Subject: Running a script using MySQL++
All,
I tried to run a script using MySQL++, but the procedure threw an exception
stating
that's just a typo in the email message, however the script itself is
correct
-Original Message-
From: Thi Cao
Sent: Tuesday, March 12, 2002 11:00 AM
To: Thi Cao; MySQL
Subject: RE: Running a script using MySQL++
sorry, careless typing, but that's just a typo
-Original Message
Thi Cao writes:
All,
I tried to run a script using MySQL++, but the procedure threw an exception
stating that there's something wrong with the syntax. I did the following:
Connection conn;
Query query(conn);
Result result;
conn.connect(dbase,host,user,passwd);
query source
of data from mysql
* The expect script uses that data and interfaces with a device hanging off
a serial port.
* The script ends with the result based on whether the interaction with the
serial device succeeds or not.
Thats why Im wanting to use expect... and thats why I am trying to find
Hi,
Just a quick query. I haven't been able to locate any documentation on it,
but has anyone ever used an expect script to connect to a MySQL database
and pull out a bunch of data for use further in the expect script ?
Any directions would be appreciated.
Cheers
Chris
--
Chris
It is possible and not very hard at all.
But why would you need expect? Why not
just use a shell script?
Neil
On Mon, 24 Sep 2001, Chris Aitken wrote:
Hi,
Just a quick query. I haven't been able to locate any documentation on it,
but has anyone ever used an expect script to connect to a
of a
database).
A psuedo flow of what it does is -
* Fire off the expect script
* The expect script grabs fields of data from mysql
* The expect script uses that data and interfaces with a device hanging off
a serial port.
* The script ends with the result based on whether the interaction
I have a SQL file that I generated on MS SQL 7. The file looks like this (a portion):
CREATE TABLE [dbo].[Articles] (
[ArticleID] [int] IDENTITY (1, 1) NOT NULL ,
[Title] [char] (100) NOT NULL ,
[AuthorID] [int] NOT NULL ,
[Date] [datetime] NOT NULL ,
[SubjectID] [int] NOT NULL ,
[Pages]
Hi.
On Sun, Apr 01, 2001 at 03:30:48AM -0400, [EMAIL PROTECTED] wrote:
I have a SQL file that I generated on MS SQL 7. The file looks like this (a
portion):
CREATE TABLE [dbo].[Articles] (
[ArticleID] [int] IDENTITY (1, 1) NOT NULL ,
[Title] [char] (100) NOT NULL ,
[...]
I am using
33 matches
Mail list logo