> >
> >interestingly, if I type sh I get 'show ' but if I type show
ta I
> >don't get 'show tables' which is what I would expect.
>
> Does "show tables" actually produce a list of tables, or no tables?
> On some systems, there is a bug in glibc that prevents it from working
> properly, in which
At 1:32 PM +1000 7/16/01, Noel Clarkson wrote:
>
>> >
>> >interestingly, if I type sh I get 'show ' but if I type show
>ta I
>> >don't get 'show tables' which is what I would expect.
>>
>> Does "show tables" actually produce a list of tables, or no tables?
>> On some systems, there is a bug i
> I hope I'm not being really stupid, but this does not seem to work:
>
> mysql -h localhost -u xxx -p
>
> I get the command line usage error. It appears I can't use any other option
> if I use the -h. This works fine
>
> mysql -u xxx -p
>
> I'm
I need to run a file called sms.sql from the command line. Is this
possible and what is the syntax?
Thanks in advance.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
On Friday 04 April 2003 04:02, you wrote:
> The logon now works after "DELETE FROM user WHERE user=""
>
> It's still crashing when a remote logon is attempted. The copy of the
> modified my.cnf file is attached.
What exactly OS do you use? What version of MySQL server do you use? Did oyu
install
Is there any command to list all the datatypes available on mysql? I can get
the information about datatypes from mysql manual as well but I need to get
them from mysql command line. Is there any such command available?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Hi Scott,
mysqladmin can issue a kill from the command line. You will have to
issue a mysqladmin -u etc. etc. processlist to get the process id from
mysql and then you can issue a mysqladmin -u etc. etc. kill
Regards
to go in and kill them by hand.
CTRL+Z simply puts a process in sleep mode so it can be woken up later on.
CTRL+C will kill the MySQL process (thus killing the query). While I don't
like that method, it's the only one I've found so far.
> Is there any easy way to abort fro
nt
---
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 20 June 2006 8:37 AM
To: mysql@lists.mysql.com
Subject: Re: Aborting a greedy querry from the command line
On Monday 19 June 2006 04:02 pm, Scott Haneda wrote:
> Sometimes I will issue something, slip of the
On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote:
> Hi Chris,
>
> I've noticed that a Ctrl-C will also leave the query running (5.0.22 -
> Linux) and I've had to use the kill from mysqladmin or mysql client to
> get rid of it.
Huh, that's odd, it should abort everything entirel
In the last episode (Jun 19), Chris White said:
> On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote:
> > I've noticed that a Ctrl-C will also leave the query running
> > (5.0.22 - Linux) and I've had to use the kill from mysqladmin or
> > mysql client to get rid of it.
>
> Huh,
> On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote:
> > Hi Chris,
> >
> > I've noticed that a Ctrl-C will also leave the query
> running (5.0.22 -
> > Linux) and I've had to use the kill from mysqladmin or
> mysql client to
> > get rid of it.
>
> Huh, that's odd, it should a
On Tuesday 20 June 2006 08:23, Ciprian Vizitiu wrote:
> > On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote:
> > > Hi Chris,
> > >
> > > I've noticed that a Ctrl-C will also leave the query
> >
> > running (5.0.22 -
> >
> > > Linux) and I've had to use the kill from mysqladmin or
Quoting Ciprian Vizitiu <[EMAIL PROTECTED]>:
> > On Monday 19 June 2006 04:08 pm, Logan, David (SST - Adelaide) wrote:
> > > Hi Chris,
> > >
> > > I've noticed that a Ctrl-C will also leave the query
> > running (5.0.22 -
> > > Linux) and I've had to use the kill from mysqladmin or
> > mysql cli
Hi!
Some days ago, there was a debate on this list about the visibility of
passwords using "ps" if they were given on the command line.
I have just come across this text. While it talks about the process
name, the info still applies to command line arguments as well:
| 1.1
On Fri, 2005-10-21 at 14:34 -0700, Dustin Krysak wrote:
> Hi there, I was wondering if it was possible to issue multiple
> commands to mysql from a regular command line? For example i know you
> can issue a single by the following:
>
> mysql -u${DB_USER} -p${DB_PASSWORD} -e
Dustin Krysak wrote:
> Hi there, I was wondering if it was possible to issue multiple commands
> to mysql from a regular command line? For example i know you can issue
> a single by the following:
>
> mysql -u${DB_USER} -p${DB_PASSWORD} -e 'show databases'
e.g.,
a one-liner, though, the above will work.
>
> -Sheeri
>
> On 10/21/05, Dustin Krysak <[EMAIL PROTECTED]> wrote:
> > Hi there, I was wondering if it was possible to issue multiple
> > commands to mysql from a regular command line? For example i know you
> >
Innotop can satisfy you demand.
On Thu, Apr 16, 2009 at 4:36 PM, Hitesh Shah wrote:
> Hello,
> I'd like to know if there is a command line tool I can run to collect
> vital health information for a remote mysql server (just like
> mysqltop) for 5.0 - I often see mysql swapping
Hi.
For example, entering mysql command line client,
mysql> pager more ( or pager md5sum and so on.)
I want to know how many command the 'pager' follows? Any reply will be
big appreciated.
[snip]
I'm new to mysql. I would like to issue a query from the command line
and pass the result to an update done on the command line within the
same script. See below.
My question is how can I run a select from the command line and pass the
values to an update
SELECT SYS_ID, SYS_LOC
[snip]
SELECT SYS_ID, SYS_LOCATION, SYS_IP FROM PROD_SERVER;
UPDATE TEST_SERVER
SET SYS_ID = &value passed from above
SYS_LOCATION = &value passed from above
SYS_IPADDRESS = &value passed from above;
[/snip]
And here http://dev.mysql.com/doc/refman/5.1/en/user-variables.html
--
M
t: RE: executing query from the command line -- need help
[snip]
SELECT SYS_ID, SYS_LOCATION, SYS_IP FROM PROD_SERVER;
UPDATE TEST_SERVER
SET SYS_ID = &value passed from above
SYS_LOCATION = &value passed from above
SYS_IPADDRESS = &value passed from above;
[/sni
to:[EMAIL PROTECTED]
> Sent: Wednesday, January 23, 2008 11:29 AM
> To: Brown, Charles; mysql@lists.mysql.com
> Subject: RE: executing query from the command line -- need help
>
> [snip]
> SELECT SYS_ID, SYS_LOCATION, SYS_IP FROM PROD_SERVER;
>
> UPDATE TEST_SERVER
> SET SYS_ID
thanks
-Original Message-
From: obed [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 23, 2008 10:49 PM
To: Jay Blanchard
Cc: Brown, Charles; mysql@lists.mysql.com
Subject: Re: executing query from the command line -- need help
On Jan 23, 2008 2:36 PM, Jay Blanchard <[EMAIL PROTEC
2013/3/31 Norah Jones
> Hi,
>
> To source sqldump i can use the source command, but if I need to do the
> same stuff using command line without going to the sqlpromt, can I achieve
> that.
>
>
Hello,
You mean cat sqldump.sql | mysql -uwhatever -pwhatever whatever_database ?
Manuel.
Hi, everyone,
I've recently run into a strange phenomenon.
I try to tun the statement "update accounts set loggedin=10 where username='user'" --
works fine from the command line. But I used it in a PERL DBI situation and it does
NOTHING -- no error, nothing. I k
Hi Chetan,
Suppose I have a table :
mysql> select * from flag_test;
++--+
| name | flag |
++--+
| Chetan | Y|
++--+
1 row in set (0.00 sec)
I am setting/unsetting the flag field from the api's ;
Now if the flag is already set and I executes the Query f
Hi
I think you need to read a book on C since C has no notion of a boolean value
At 11:40 01/03/2002 +, DL Neil wrote:
>Hi Chetan,
>
>Suppose I have a table :
>
>mysql> select * from flag_test;
>++--+
>| name | flag |
>++--+
>| Chetan | Y|
>++--+
>1 r
5:25 PM
To: DL Neil; Chetan Lavti; [EMAIL PROTECTED]
Subject: Re: Row affected from Mysql Command line and api's
Hi
I think you need to read a book on C since C has no notion of a boolean
value
At 11:40 01/03/2002 +, DL Neil wrote:
>Hi Chetan,
>
>Suppose I have a table :
stion.
>
>Thanks and regards,
>Chetan Lavti
>
>
>
>
>
>-Original Message-
>From: John Dean [mailto:[EMAIL PROTECTED]]
>Sent: Friday, March 01, 2002 5:25 PM
>To: DL Neil; Chetan Lavti; [EMAIL PROTECTED]
>Subject: Re: Row affected from Mysql Command line a
Using the source on the command line, I am getting "access denied" (to
the file, I am guessing).
The user has all privledges granted. I have tried
"mysql -h hostname -u user database < source_file"
and I received the same "access denied" message.
What
Using the source command on the command line, I am getting "access
denied" (to
the file, I am guessing).
I have tried these statements:
(1) "source filename"
(2) "mysql -h hostname -u user database < source_file"
and I received the same "access denied&quo
Scott Pippin wrote:
> I need to run a file called sms.sql from the command line. Is this
> possible and what is the syntax?
> Thanks in advance.
>
> -
> Before posting, please check:
>http://www.mysql.
mysqlsource sms.sql
Bye and Good Luck!
--- Scott Pippin <[EMAIL PROTECTED]> wrote:
> I need to run a file called sms.sql from the command
> line. Is this
> possible and what is the syntax?
> Thanks in advance.
>
>
--
Okay, I just found out what I was doing wrong. Having looked in the docs,
but I'm sure this is documented behavior.
> MySQL 4.0.12, MSW2k. Here's what's puzzling me --
>
> I set up a new user yesterday. I'm pretty sure I was able to connect as
> the user from the
Hi everybody,
I am working on a small GUI tool for managing MySQL server.
I would like to include one functionality to change the port number of
the server and restart the server just after the change took place. Is
there any command line tool which I can use to change the port number?
e.g
I know, all the shell command can do this. Thanks.
2010/8/25 Moon's Father
> Hi.
>For example, entering mysql command line client,
>mysql> pager more ( or pager md5sum and so on.)
>
>I want to know how many command the 'pager' follows? Any reply will be
> big appreciated.
>
In the last episode (Aug 25), Moon's Father said:
> Hi.
>For example, entering mysql command line client,
>mysql> pager more ( or pager md5sum and so on.)
>
>I want to know how many command the 'pager' follows? Any reply will
> be big appreciated.
My Synology station is on 192.168.178.27,
the database listens to port 3306,
on my FritzBox I forwarded port 3306 to 192.168.178.27,
I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/
But when I try:
mysql --host=192.168.178.27 --password=* --user=wybo
I get:
ERROR 1045 (2
t "update accounts set loggedin=10 where username='user'"
>-- works fine from the command line. But I used it in a PERL DBI situation and it
>does NOTHING -- no error, nothing. I know the PERL code is fine, because I've tried
>substituting the $sql variable (contain
ggedin=10 where username='user'"
-- the users field updates but the loggedin field does not. Both fields
have exactly the same definition int(11). Plus the exact same query updates
BOTH from the command line -- though only the one field in PERL
What about repairing the table and what does DESC tablename say?
- Original Message -
From: "Laszlo G. Szijarto" <[EMAIL PROTECTED]>
To: "Ryan Wahle" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, February 16, 2001 3:20
Subject: Re: SQL ex
.
Have I missed something?
I tried the "default-character-set" tag and I got an error that #10 was not
a compiled language? #10 being swe7 in the index file... and I figure
meaning Swedish. Whats happening and how do I resolve this.
In summary, I need to data load Swedish character fi
use have the privileges to do so?
Bye,
Benjamin.
On Tue, Jun 12, 2001 at 10:16:10AM -0500, [EMAIL PROTECTED] wrote:
> Using the source command on the command line, I am getting "access
> denied" (to
> the file, I am guessing).
>
> I have tried these statements:
The "access denied" message is most likely occurring because you are not
supplying the password option (-p) to the mysql command.
- TIM
> Using the source command on the command line, I am getting "access
> denied" (to
> the file, I am guessing).
>
> I
.)
-Original Message-
From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 12, 2001 8:33 AM
To: Edward Sepulveda
Cc: [EMAIL PROTECTED]
Subject: Re: Problem with source command for command line (win version)
Hi.
May sound like a stupid question, but do you have read access to
Hi,
We're trying enter polish language into mysql. My understanding is that
polish language uses iso-8859-2 character set. I am cutting and pasting
polish text from a web browser (Konqueror) into the mysql command line client
running in a terminal window (konsole). MySQL server is ve
lists-mysql wrote:
in a *nix environment, restarting the mysql server is done with a
system-level command and requires *system* root privileges, not
something that the average db-admin is likely to have. also,
changing the port a service is listening on has potentially serious
implications as you
pp which can administrate MySQL and would later add a GUI over it.
>
If you want to control the server process, you'll need to start the
server process with those options, this mysqld, and the command line
options are here:
http://dev.mysql.com/doc/refman/5.1/en/server-options.html
For your p
Micah Stevens wrote:
If you want to control the server process, you'll need to start the
server process with those options, this mysqld, and the command line
options are here:
http://dev.mysql.com/doc/refman/5.1/en/server-options.html
Thanks for the link, I am going through it.
For
Hi Wybo,
On 8/20/2014 3:47 PM, Wybo wrote:
My Synology station is on 192.168.178.27,
the database listens to port 3306,
on my FritzBox I forwarded port 3306 to 192.168.178.27,
I /can/ connect to the database on http://192.168.178.27/phpMyAdmin/
But when I try:
mysql --host=192.168.178.27 --pass
Hello Wybo,
I cleansed your reply and cc:'ed the list again to share the answer.
On 8/20/2014 4:24 PM, Wybo wrote:
Hi Shawn,
Thanks for your prompt reply - I suppose I'll have to do that query via
phpMysqlAdmin. When I do that, the only host that appears is localhost.
However, when I browse th
Yes, that worked - thank you very much!
On 2014-08-20 22:51, shawn l.green wrote:
Hello Wybo,
I cleansed your reply and cc:'ed the list again to share the answer.
On 8/20/2014 4:24 PM, Wybo wrote:
Hi Shawn,
Thanks for your prompt reply - I suppose I'll have to do that query via
phpMysqlAdmin
I dumped a database from a 4.0 mysql and am attempting to move it to a
server running 4.1 - using the command line:
$ mysql -u root -pmypassword empty4.1db < 4.0dump.sql
The result:
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check
the manual that corresponds to y
7;$bulletin_date','$bulletin_from2')";
mysql_query($sql);
print("The Data has been entered!\n");
print("You can add another Dealer Bulletin below\n");
endif;
?>
I have purposely changed the name todaysnews to be incorrect and the page, on submit,
will
e a look and try it on my machine.
Hope this helps,
Ben
-Original Message-
From: Ian Corner [mailto:[EMAIL PROTECTED]]
Sent: 08 April 2001 22:32
To: [EMAIL PROTECTED]
Subject: character set works via web but not at command line?
Hi (if needed you can find my environment setup below)
I wi
words.
Carlos
On 9/26/06, Curious George <[EMAIL PROTECTED]> wrote:
I dumped a database from a 4.0 mysql and am attempting to move it to a
server running 4.1 - using the command line:
$ mysql -u root -pmypassword empty4.1db < 4.0dump.sql
The result:
ERROR 1064 (42000) at line 2: Yo
Hello all,
I use the bash shell and the vi editing mode (set -o vi) in my .inputrc.
On one of my boxes, I managed to get the command line tool (mysql) to honour
that setting. However, I have forgotten how I did that. Does anyone know how
to do that
n, all tables are created with these parameters:
ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
In all respects except one, the treatment of Unicode works just fine. I can
write Unicode to database tables, read it, display it, etc., with no
problems. The exception is mysq
Five months ago I posted the query shown below on StackOverflow. I got
one reply which was not of much help. So I am trying again, hoping a
more MySQL-centric forum might be able to solve my problem.
Roger House
How to get the MySQL Command-Line Tool to display Unicode properly?
I use a
mOpt AB
Michael Löfmans gata 6
254 38 Helsingborg, Sweden
Direct: +46 42 389918
Phone: +46 42 389900
e-mail: [EMAIL PROTECTED]
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]]
Sent: 16 September 2002 15:59
To: [EMAIL PROTECTED]
Subject: re: Start mysqld-nt from command line wit
., and this has enabled use of
'load data local infile' from the command line, but still not in php scripts.
Removing the word LOCAL from the php scripts results in a different error - I get a
message saying that access is denied for the
user instead.
I would be very grateful to hear f
Hi!
This SQL works perfect when running the command line tool mysql.exe
SELECT exe, sum(duration) FROM data GROUP BY exe ORDER BY 2
BUT when running from the C API, the "ORDER BY" part doesn't seem
active, why?
Please h
Hello,
I have a command-line PHP script--called Listener--that is designed
to run indefinitely with a predictable CPU usage and memory
footprint. In a nutshell, it's a multi-client socket server that
waits for incoming connections, processes incoming data, stores
results in a
2017/10/18 18:32 ... Roger House:
I get the same behavior with the MySQL Command Line Tool when I run it on
Windows, Mac OS X, and Ubuntu, so I'm pretty sure the problem has to do
with mysql itself.
What do you know about the displays to which the client is writing?
In the case of "
Am 13.03.2018 um 22:59 schrieb Roger House:
In all respects except one, the treatment of Unicode works just fine. I
can write Unicode to database tables, read it, display it, etc., with no
problems. The exception is mysql, the MySQL Command-Line Tool. When I
execute a SELECT statement to see
treatment of Unicode works just fine.
I can write Unicode to database tables, read it, display it, etc.,
with no problems. The exception is mysql, the MySQL Command-Line
Tool. When I execute a SELECT statement to see rows in a table
containing the Venus and Mars Unicode characters, here is what I
ust fine.
>>> I can write Unicode to database tables, read it, display it, etc.,
>>> with no problems. The exception is mysql, the MySQL Command-Line
>>> Tool. When I execute a SELECT statement to see rows in a table
>>> containing the Venus and Mars Unicode ch
ects except one, the treatment of Unicode works just fine.
>>> I can write Unicode to database tables, read it, display it, etc.,
>>> with no problems. The exception is mysql, the MySQL Command-Line
>>> Tool. When I execute a SELECT statement to see rows in a table
>>
2:59 schrieb Roger House:
>>> In all respects except one, the treatment of Unicode works just
fine.
>>> I can write Unicode to database tables, read it, display it, etc.,
>>> with no problems. The exception is mysql, the MySQL Command-Line
>>> Tool. When I execute
03.2018 um 22:59 schrieb Roger House:
>>> >>> In all respects except one, the treatment of Unicode works just
>>> fine.
>>> >>> I can write Unicode to database tables, read it, display it,
>etc.,
>>> >>> with no problems.
-
From: Joseph Bueno [mailto:joseph.bueno@;trader.com]
Sent: den 4 november 2002 11:57
To: Christer Holmström (at Home)
Cc: [EMAIL PROTECTED]
Subject: Re: Problems with "ORDER BY" from C API (works from
command-line tool mysql.exe)
Christer Holmström (at Home) wrote:
> Hi!
>
;; [EMAIL PROTECTED]
Subject: Re: Problems with "ORDER BY" from C API (works from
command-line tool mysql.exe)
Then I would suggest you check your C code.
The program 'mysql' uses the C API.
Christer Holmström (at Home) wrote:
>Hi, and thanks for the response, but unfortun
k'
Cc: 'Joseph Bueno'; [EMAIL PROTECTED]
Subject: RE: Problems with "ORDER BY" from C API (works from
command-line tool mysql.exe)
The code works in that sence that I get resultsets, the only thing that
does not work is the "ORDER BY" option for the SELECT statement. Th
Hi.
On Mon 2002-11-04 at 11:56:40 +0100, [EMAIL PROTECTED] wrote:
> Christer Holmström (at Home) wrote:
[...]
> > This SQL works perfect when running the command line tool mysql.exe
> >
> > SELECT exe, sum(duration) FROM data GROUP BY exe ORDER BY 2
> >
> > BUT
At 11:56 +0100 11/4/02, Joseph Bueno wrote:
Christer Holmström (at Home) wrote:
Hi!
This SQL works perfect when running the command line tool mysql.exe
SELECT exe, sum(duration) FROM data GROUP BY exe ORDER BY 2
BUT when running from the C API, the "ORDER BY" part doesn'
API (works from
command-line tool mysql.exe)
At 11:56 +0100 11/4/02, Joseph Bueno wrote:
>Christer Holmström (at Home) wrote:
>
>> Hi!
>>
>> This SQL works perfect when running the command line tool mysql.exe
>>
>> SELECT exe, sum(duration) FROM data GROUP BY e
September 29, 2002 8:24 PM
> To: Dawn Friedland
> Cc: [EMAIL PROTECTED]
> Subject: Re: Japanese Charset
...
> Say, do you want a little utility program in Java or C that will print
> the hexadecimal values of the characters in a string? Basically, it
> would be a command-line utili
Devart
Email: i...@devart.com
Web: http://www.devart.com
FOR IMMEDIATE RELEASE
CONTACT INFORMATION:
Julia Samarska
jul...@devart.com
26-Feb-10
Schema and Data Comparison and Synchronization Tools for MySQL Offer Command
Line Mode and Comparison Reports
MySQL database
I'm really not sure what to try next. ps -aux shows MySQL as hogging
the CPU, not PHP or Terminal:
When this happens, do a 'SHOW PROCESSLIST' in mysql to see what it's
doing.
I have, and I can't see anything unusual. There are a few scripts
that loop with very slow overhead (with sufficien
201 - 281 of 281 matches
Mail list logo
