Hi all,
I got MySQL 3.23.55-nt running on XP and MySQL Client 3.23.36 running on
Linux Red Hat 7. I'm trying to have the client connect to the server but I
get the same error all the time:
[EMAIL PROTECTED] /root]# mysql -h 10.0.0.41 -u guest
ERROR 1130: Host '10.0.0.220' is not allowed to connect
Hi!
Sorry for the repost, but I am really eager to hear the verdict so I
give it another go, thanks ;-)
When using the Union statement in MySQL, is it possible to retrieve the
corresponding table name for a given row? The reason I need to know
this is that I present info from different tables
How do I write a SQL call to take the results of a select statement and
plug them into a new table in the DB?
Thanks
Phillip
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.
Hi,
query question:
I have 2 tables created using Mysql:
1) Players
Name(varchar),Team(varchar),Goals(tinyint),Assists(tinyint),Shutouts(tinyint),points(int).
2)draftees
ID(smallint),Name(varchar),Phone(varchar),Player(varchar)
The problem I run into is when I run this statement only the
At 16:15 +1100 3/11/03, Philip McCarthy wrote:
Hi Loren
I started over; uninstalled mysql and reinstalled.
The file I used was mysql-3.23.55-win
This unzipped ok and installed into a folder called mysql on my c drive.
Following http://www.mysql.com/doc/en/Windows_server_first_start.html
At 6:08 +0100 3/11/03, Harish B M (RBIN/ECM2) * wrote:
Dear All,
I reinstalled the Linux (SuSE Linux ver 8.0) on my machine and selected
MySQL from the Linux CD itself. While starting mysqld daemon through
safe_mysqld script, it is giving the following Error and daemon has ended
immediatly. I had
Please help me with the following c code:
sprintf(update, "update chrc set center='");
len = 24;
memcpy(update+len, center, 128);
len += 128;
sprintf(update+len, "', var='");
len += 8;
m
Well, believe it or not SUCCESS!! That's right, you were running the mysql
Server.
Now for something you should try. Find the winmysqladmin.exe (Should be in
the same folder. Run that one. It will allow you to run the mysqld as a
service, give you stat's on whats going on, and start and stop t
Hi Loren
I started over; uninstalled mysql and reinstalled.
The file I used was mysql-3.23.55-win
This unzipped ok and installed into a folder called mysql on my c drive.
Following http://www.mysql.com/doc/en/Windows_server_first_start.html
the first thing I tried was:
C:\mysql\
Dear All,
I reinstalled the Linux (SuSE Linux ver 8.0) on my machine and selected
MySQL from the Linux CD itself. While starting mysqld daemon through
safe_mysqld script, it is giving the following Error and daemon has ended
immediatly. I had pasted the messages on my screen below. Kindly let me k
I hope I've subscribed to the right list.
I am using version 3.23.41 of MySQL, and I'm having a problem getting
correct (expected?) behavior with column aliases.
I have a database A which has, among other things, an id field,
something like this:
CREATE TABLE a {
somedata VARCHAR(10),
id INT UNS
At 10:13 2003-03-08, Zak Greant wrote:
Why not use the binaries from mysql.com? We recommend them over making
your own binaries.
I guess this is what I have to do then... I just *imagined* that mysql
would run better on my linuxbox if I compiled it on it...
Well, cheers!
/ H, off to setup up
I have run into a problem where data is truncated when sending to MySql via
a SSL connection, I can not determine whether this is my server or just the
protocol, I hope the later, as I know web* 4, which is what I am using will
never get it fixed. Anyone with php and apache running SSL, would you
I have just upgraded from MySQL 3.23.32 to 3.23.55 on my RedHat 8 server.
Everything is working fine except that I get FAILED for MySQL when shutting down.
I have not changed any settings at all. And the FAILED message does
not seem to affect anything with MySQL operations. How do I go abt c
Hi!
When using the Union statement in MySQL, is it possible to retrieve the
corresponding table name for a given row? I know I can create a column
in each table that describes which table the row actually is being
retrieved from, but I am looking for a more intelligent solution.
Thanks! :-)
B
Well, I'm on the verge of giving up on connecting to the MySQL server
externally. I've updated the Host fields in the User and Db tables to
be %, but I still get error 1130 when I connect, and the user name
isn't transmitted.
The manager of the database (it isn't mine) claims PHPmyAdmin (which
>Description:
Performing a VPATH build with innobase support included fails since the
innobase headers in $(top_srcdir)/innobase/include are not found:
gcc -DHAVE_CONFIG_H -I. -I/vol/mysql/src/mysql/dist/mysql-3.23.55/innobase/os -I..
-I../../include -I../include-DDBUG_OFF -O3 -DDBUG_OFF -D
Hi!
On Mon 2003-03-10 at 16:44:40 -0500, [EMAIL PROTECTED] wrote:
[...]
> - Given a system user 'junk' I would like to create a "master" user
> 'junk' that can have all permissions (including grant?) on all 'junk_*'
> databases so that he can create and manage his own databases
>
> - Given a
>Description:
Performing a VPATH build on Solaris 8/SPARC with innobase support and
the previously reported VPATH build problem (no -I options for $srcdir) fixed
by editing the generated innobase Makefiles adding -I$(srcdir)/../../include
-I$(srcdir)/../include to INCLUDES proceeds, but fails to li
At 14:37 -0800 3/10/03, DuSTiN KRySaK wrote:
Hi there - I'm truing to connect to a mysql server (redhat linux 8) with the
mysqlcc GUI (through a SSH session), and for some reason when I try to
connect I get the error:
[localhost] ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/
At 22:28 + 3/10/03, Paul Taylor wrote:
I have MySQL 3.23, running on Windows XP. I don't seem to be able to make my
tables Innodb type. Is there something I should install, or some script I
should configure. Looking on the MySQL site, I noticed there was a script I
should run. I'm so inexperien
MySQL must be compiled with support for InnoDB, if yours wasn't, you
wouldn't be able to use InnoDB tables. You can download a MySQL binary here:
http://www.mysql.com/downloads/mysql-3.23.html
According to the InnoDB quick start page
(http://www.innodb.com/howtouse.html), you'll want MySQL-max:
-
why don't you try...
mysql > SHOW GRANTS for 'junk'@'localhost'
just to see what has been granted at present?
David
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
Hi there - I'm truing to connect to a mysql server (redhat linux 8) with the
mysqlcc GUI (through a SSH session), and for some reason when I try to
connect I get the error:
[localhost] ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
Now I was reading that this
I have MySQL 3.23, running on Windows XP. I don't seem to be able to make my
tables Innodb type. Is there something I should install, or some script I
should configure. Looking on the MySQL site, I noticed there was a script I
should run. I'm so inexperience with MySQL, I don't know what it meant b
Hello
I would asume that these two queries would give the same output? Am I wrong?
Seems like the where part don't have any effect on the LEFT JOIN when it
comes to MIN() and MAX().
SELECT count( plads_ordre.id )
as antal, MIN( forestilling.arrangement_id )
as min, MAX( forestilling.arrangement_i
>Description:
If configuring with --with-innobase and non-standard configure flags (like
--enable-maintainer-mode), those flags are not passed to the configure
run in the innobase subdirectory. Since the sub-configure is run with many
variables in the environment (see innobase/config.status sub -r
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi, all --
I am having a bit of trouble with GRANT and users and database access. I
would like to do two things:
- - Given a system user 'junk' I would like to create a "master" user
'junk' that can have all permissions (including grant?) on all '
On 10 Mar 2003, at 16:31, Tab Alleman wrote:
> I was thinking if you do a select on a char[50] and the whole field
> is indexed, wouldn't the search algorithm know exactly where to go
> to look for a match, as opposed to - if only the first 20 characters
> are indexed - finding all of the possible
>Description:
Performing a VPATH build inside an empty build directory fails to compile
sql/mysqld.c since the generated db.h (which is created in
$top_builddir/bdb/build_unix) isn't found:
g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr/local\""
-DDATADIR="\"/usr/local/var\"" -DSHAREDIR="\"/usr/
Benjamin Pflugmann wrote:
> If you have 256MB, the one may fit into memory,
> the other may not and therefore requires additional disk reads.
Ah, see.. I hadn't thought of disk reads. I was thinking if you do a
select on a char[50] and the whole field is indexed, wouldn't the search
algorith
On Mon 2003-03-10 at 15:06:05 -0500, [EMAIL PROTECTED] wrote:
> >
> > If you're indexing all 50 characters, index fewer of them.
>
> Not that I think you're wrong, but help me understand, please:
>
> It seems to me that this would cause the index creation to go faster,
> but the execution of the
According to the microsoft web site, SQLFetch should
update the variable SQL_ATTR_ROWS_FETCHED_PTR with the
number of rows fetched.
A fairly simple change to results.c, line 657
if (stmt->stmt_options.rowsFetchedPtr)
*stmt->stmt_options.rowsFetchedPtr= 1;
fixes this.
Thanks,
Laramie
---
on 3/10/03 9:24 AM, Pete Harlan at [EMAIL PROTECTED] wrote:
> If you want to connect to localhost via TCP/IP, you have to specify
> the host by IP address (127.0.0.1), not as "localhost".
Tried that, it doesn't work. In my case, I call ssh like this:
ssh -n -N -L 3307:foo.bar.com:3306 foo.bar.co
If your create table statement has both char's and varchar's in it, then MySQL
converts the char's all to
varchar's.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sheryl --
...and then Sheryl Canter said...
%
% I have a big problem to solve on my site, and I'm not sure how to approach
% it. I'm selling software that's distributed as trialware (will be--haven't
Best of luck! :-)
% launched yet). Users will b
>
> If you're indexing all 50 characters, index fewer of them.
>
Not that I think you're wrong, but help me understand, please:
It seems to me that this would cause the index creation to go faster,
but the execution of the SELECT query to, if anything, go slower...?
I'm probably wrong, though,
I have a question regarding fixed width char fields. How do you create
them in MySQL? When I create a table and define a field MyField
char[50], when I run the describe table, the field shows up as a
varchar.
Thanks,
--
Jason H. West
Software Engineer
Softek Software International, Inc.
813 Pavi
On Mon, Mar 10, 2003 at 11:32:06AM -0600, Paul DuBois wrote:
> Whether it's a feature or not, it's not always so easy to figure out
> what to do. If you specify -h localhost, it can be argued that you
> really want the socket even if you specify the port. It can be
> argued conversely that if you
>Description:
Running configure in an empty build directory to perform a VPATH build of mysql,
I noticed that configure created on temporary and one permanent file in $srcdir.
This shouldn't happen: $srcdir should be treated as read-only (e.g. to support
building from a read-only source partition,
On Mon, 10 Mar 2003 10:41:15 -0600
Paul DuBois <[EMAIL PROTECTED]> wrote:
> At 14:35 +0100 3/10/03, Chand wrote:
> >hey dudes, i'd really need some insight on this. Does anyone have
> >any idea about this ?
> >
> >TIA
> >
> >heya,
> >
> >I have a quick and painless (i hope :) )question..
> >
> >D
sql, mysql...
oops, forgot the quotes>>
You might also try indexing only a portion of the char[50] index.
>> index (UserName(20)), for example...
David
-
Before posting, please check:
http://www.mysql.com/manual.php
sql, mysql...
You might also try indexing only a portion of the char[50] index.
index UserName(20), for example...
David
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mys
At 13:39 -0500 3/10/03, Jason West wrote:
Does anyone know of a way to speed up seek time when selecting based on
an indexed char field? I have a query that I'm executing ('select * from
Table where UserName = myname') and it takes approximately 7 seconds to
execute this 1000 times (UserName is cha
Hi
> If you
> tunnel the port, you have to be sure to block access to that
> port from the outside, because outside connections to that
> port (on the tunneling
> client) will be tunneled too (under Linux anyway; I didn't
> try it elsewhere).
>
> That's potentially dangerous and not complete
This may not be the solution you are looking for, but if you are executing
ths query 1000 times, it must be in a program somewhere, so why not execute
it once, pullout the UserID the run the rest on UserID?
Hope this helps.
Roger
-Original Message-
From: Jason West [mailto:[EMAIL PROTECTE
At 11:36 -0700 3/10/03, Mark Berkwitt wrote:
I can't figure the solution:
#mysql -p -u Me sampdb < create_president.sql
#Enter password:
ERROR 1 at line 5; Can't create/write to file './sampdb/president.frm'
(Errcode:13)
Please help.
% perror 1 13
Error code 1: Operation not permitted
Error cod
Does anyone know of a way to speed up seek time when selecting based on
an indexed char field? I have a query that I'm executing ('select * from
Table where UserName = myname') and it takes approximately 7 seconds to
execute this 1000 times (UserName is char[50], and it is indexed). If I
change the
I can't figure the solution:
#mysql -p -u Me sampdb < create_president.sql
#Enter password:
ERROR 1 at line 5; Can't create/write to file './sampdb/president.frm'
(Errcode:13)
Please help.
-
Before posting, please check:
ht
Hi all,
I found a problem (bug?) when updating a blob column via MyODBC. The
statement i run is like that:
UPDATE blob_table SET blob_col = ? where id = ?
when i do NOT bind the restriction as input parameter, but write it directly
in the string, it works perfectly.
but when i want to bind the
At 11:24 -0600 3/10/03, Pete Harlan wrote:
On Fri, Mar 07, 2003 at 05:43:29PM -0800, Jeremy Zawodny wrote:
On Fri, Mar 07, 2003 at 05:37:38PM -0800, LZ Orders wrote:
> Hi. I wanted to connect from a client machine to a MySQL server using
> ssh. I execute the following on the local machine (the s
On Fri, Mar 07, 2003 at 05:43:29PM -0800, Jeremy Zawodny wrote:
> On Fri, Mar 07, 2003 at 05:37:38PM -0800, LZ Orders wrote:
> > Hi. I wanted to connect from a client machine to a MySQL server using
> > ssh. I execute the following on the local machine (the server is
> > foo.bar.com):
> >
> > %
I inadvertantly deleted the colonel's question, which I believe concerned
winmysqladmin.
Please give us more info. You should be able to see your databse(s) under the
database tab.
David
-
Before posting, please check:
h
Thanks..that helped.
anil :)
-Original Message-
From: Roger Baklund [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2003 10:52 AM
To: [EMAIL PROTECTED]
Cc: Anil Garg
Subject: Re: date query.
* Anil Garg
> The date field in my database table looks as below:
> 07th of March 2003 10:14:29
At 14:35 +0100 3/10/03, Chand wrote:
hey dudes, i'd really need some insight on this. Does anyone have
any idea about this ?
TIA
heya,
I have a quick and painless (i hope :) )question..
Do you know how the username length is limited under MySQL. There is
no mention of this in the manual or bo
At 09:36 AM 3/10/2003, Anil Garg wrote:
The date field in my database table looks as below:
"07th of March 2003 10:14:29 PM"
Weird. All of my datetime variables look like '2003-03-07 22:14:29'. Are
these fields datetime field types or are they text that looks like a date?
If they are datetime,
At 11:09 -0500 3/10/03, Douglas B. Jones wrote:
Hi,
Great! This works, I did not use the 'null' and that is
where I had a problem. One other questions: is this atomic?
If I have several processes trying to do this at one time,
will each one correctly update the table (assuming they have
the same '
Hi,
Great! This works, I did not use the 'null' and that is
where I had a problem. One other questions: is this atomic?
If I have several processes trying to do this at one time,
will each one correctly update the table (assuming they have
the same 'name' value. Also, in the part: unique (name(10
Indexing in MySQL.
If while indexing a table I retrieve data from same table the indexing
process seems to get stuck. Mytop keeps saying something about
"repairing keycache" for days when the indexing shouldn't take more than
a couple of hours.
Can someone please explain!
--
* Anil Garg
> The date field in my database table looks as below:
> 07th of March 2003 10:14:29 PM
Then it is probably not a 'date field' in the sense that it is of type
"date", "datetime" or "timestamp".
> I need to write a query which gets me all the rows which are
> entered in last to weeks.
>
Hi,
The date field in my database table looks as below:
07th of March 2003 10:14:29 PM
I need to write a query which gets me all the rows which are entered in last
to weeks.
Any ideas!!
Thanks and Regards
Anil.
-
Before posti
As I read the manual, the REPLACE command will do what you want.
Make the name field UNIQUE, and the number field AUTO_INCREMENT NOT NULL.
Replace dos a delete-if-present, insert. The insert generates a new ID.
See test below, and note two rows affected by second replace.
mysql> create table te
On Sunday 09 March 2003 05:04, SUGIOKA Toshinobu wrote:
> I found obvious bug that causes segmentation fault while building
> on sh-linux. Please apply.
>
> Regards,
> SUGIOKA Toshinobu.
>
> --- mysql-3.23.54a.orig/sql/gen_lex_hash.cc Thu Dec 5 18:37:06 2002
> +++ mysql-3.23.54a/sql/gen_lex_h
On Friday 07 March 2003 17:52, gluk at php4 dot ru wrote:
> >Description:
>
> UPDATE command fail with multiple myisam tables with error:
> ERROR 1142: update command denied to user: '[EMAIL PROTECTED]' for table '***'
> This situation occures only when non-root user make UPDATE
Hi,
I have a pretty significant problem when inserting records in to 2
tables (Parent/child). In the Parent table the records are 25 bytes, and
the child records are 80 bytes. The Parent table has an auto inc field
which I retrieve using 'mysql_insert_id()' to populate the ownerID in
the child tab
Found it myself... checking the documentation isn't such a bad idea...
adding -lz did the trick.
/Lars
> Getting the following errors when trying to link client application
> written in C:
>
> /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
> `my_uncompress':
> my_compress.o(.text+
Hi,
First, the version: 3.23.49
If I have a table with two elements: name char(128), n int
how do I have it so that n will increment each time?
I take it that name needs to be a primary key. How do I get
n to increment in vaue each time. This is not auto_increment.
I want name to be in the tab
* Andrew
> Actually thinking about this in a bit more depth! I also have
> the infamous
> items table where individual company records are being stored.
> So is the best way to do this:
>
> i) add another field that will coreespond to the items.ItemsID or
I don't know what you mean.
> ii) create
If you want to use DNS, that's the way to go.
You can also use LVS to setup clusters of databases.
http://www.linuxvirtualserver.org
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 6:05 PM
To: John Masterson
Cc: [EMAIL PROTECTED]
Subject:
Hi,...
We work with MySQL 3.23.55 in a LINUX REDHAT Machine.
It used to work fine with our BDB Tables,.. but now we got the following
errors when we try to start the Database Server:
##
030310 15:09:08 mysqld started
030310 15:09:08 bdb: Log sequence error: page LSN 1:5242731; pre
Getting the following errors when trying to link client application
written in C:
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_uncompress':
my_compress.o(.text+0xaa): undefined reference to `uncompress'
/usr/lib/mysql/libmysqlclient.a(my_compress.o): In function
`my_compress_al
THE SITUATION:
We're running MySQL 3.23.51. We have a table which has a primary-keyed
field 'sid'. We have four tables what have foreign key references
on that field. We deleted all rows from those four tables that
had values in that foreign key index and then tried to delete the
row in the main
hey dudes, i'd really need some insight on this. Does anyone have any idea about this
?
TIA
heya,
I have a quick and painless (i hope :) )question..
Do you know how the username length is limited under MySQL. There is no mention of
this in the manual or books. I figured the username length
On Saturday 08 March 2003 23:38, John David Duncan wrote:
> In MySQL 4.0, query cache hits are counted in Qcache_hits, but not in
> Com_select. The documentation for Com_select implies that they should be
> there. Is this the intended behavior, or is it a bug?
No, it's not a bug, but a known b
On Sunday 09 March 2003 11:17, Kian Kok Lim wrote:
> Do you have a version of mysql that supports
> transaction, with auto-commit (rollback and commit)
> feature?
>
> From your manuals, it appears that there is a BDB
> version. How/Where can I access it?
Transactions work on InnoDB and BDB tables
On Monday 10 March 2003 10:40, Hu Qinan wrote:
> Which records in tbl1 are to be updated are determined by an INNER JOIN
> with tbl2. I have tried the following:
>
> UPDATE tbl1 INNER JOIN tbl2 ON tbl1.id = tbl2.id
> SET tbl1.col1 = 0;
>
> UPDATE tbl1, tbl2
> SET tbl1.col1 = 0
> WHERE tbl1.id = tb
On Saturday 08 March 2003 09:09, Heo Jungsu wrote:
> I have a question about altering table which has foreign key constraints.
>
> MySQL manual says that :
>
> "In InnoDB versions < 3.23.50 ALTER TABLE or CREATE INDEX should not be
> used in connection with tables which have foreign key constraint
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Loïc QUERAN wrote:
Hi,
What I want to do is to update a table in a database and at the same time post
a message in a message queue. "At the same time" means in the same
transaction : I must be able to commit both operations or rollback both
operatio
Hi,
What I want to do is to update a table in a database and at the same time post
a message in a message queue. "At the same time" means in the same
transaction : I must be able to commit both operations or rollback both
operations.
As far as I know, what I need is a transaction manager that
I tried to use MySql 4.0.11-gamma-max gebug on W2K.
Mysql Service hang on "delete from tbl_listdat;"
Do you want to get further information about this problem?
I' m an experienced MySql user since years. I think this is a problem caused by a
combination of the table structure and the content.
W
Hi,
I'm very new to MySQL database design, and have been going
through a lot of tutorials and such but haven't seen a good example of
this yet.
I am currently working on a database for an ebusiness which will
need to have a database of products, customer information and so on.
What
Hi,
> Now my problem is, a user with no privilege is able to
> run SQL command TRUNCATE to empty any table!
Thanks for the bug report.
The bug has been entered into our bug database as bug #138:
http://bugs.mysql.com/bug.php?id=138
This will be fixed in the next release, 4.0.12.
Rgds,
Indrek
I use MySQL 3.23.
Dear all,
Which records in tbl1 are to be updated are determined by an INNER JOIN with tbl2. I
have tried the following:
UPDATE tbl1 INNER JOIN tbl2 ON tbl1.id = tbl2.id
SET tbl1.col1 = 0;
UPDATE tbl1, tbl2
SET tbl1.col1 = 0
WHERE tbl1.id = tbl2.id;
UPDATE tbl1
SET tbl1.col1 = 0
INNER JOIN tb
On 10-Mar-2003 Micha Brans wrote:
>
>
> Hi All,
>
> After migrating to a new server, I have problems importing *.csv files to
> the MySQL db.
>
> When I try to do LOAD DATA INFILE
> '/home/www/htdocs/helpdesk/systems/forms/users.csv' REPLACE INTO TABLE
> `empl_navtech` FIELDS TERMINATED BY
Hi All,
After migrating to a new server, I have problems importing *.csv files to
the MySQL db.
When I try to do LOAD DATA INFILE
'/home/www/htdocs/helpdesk/systems/forms/users.csv' REPLACE INTO TABLE
`empl_navtech` FIELDS TERMINATED BY ',' ENCLOSED BY '"'
I get the error: 13: Can't get sta
86 matches
Mail list logo
