Hi,
I've tried it and I still encountered this.
btw, my compiler version is 2.95.2
Here is the result.
checking build system type... sparc-sun-solaris2.8
checking host system type... sparc-sun-solaris2.8
checking target system type... sparc-sun-solaris2.8
checking for a BSD compatible
Victoria,
i did not get it. What do you mean by Nicolaos and Daniel, can you send
new character sets as you see them
with the explanations?. Please could you be more specific?
(SQL,QUERY)
With thanks
Georgiafentis Nikolaos
Project Manager
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
iTEL LTD
409
I am a MySQL newbie and can not seem to find the documentation that
explains how to allow network or remote access to a running MySQL
server. It does not seem to be in the my.cnf file or in the manual???
I am sure this is a simple thing but it is really holding me up right
now. Thanks for
Hello all,
How to use mysql command in perl script?
I want to lock the db thru a perl(or shell)script.
Thanx in advance.
--
Charitha
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Greetings All:
I found the following referer field entry in my MySQL-based web-server logs:
http://www.google.com/search?q=apache+mysql+modulehl=enlr=ie=UTF-8oe=UTF-8
After checking it out, I realized Micro$oft put this page together on July 11,
2002:
download mysql module of perl from cpan.org.
Barnali
-Original Message-
From: Charitha [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 12:08 PM
To: [EMAIL PROTECTED]
Subject: usage of mysql command
Hello all,
How to use mysql command in perl script?
I want to lock the db
look at the grant syntax in the manual.
Steve Dickey wrote:
I am a MySQL newbie and can not seem to find the documentation that
explains how to allow network or remote access to a running MySQL
server. It does not seem to be in the my.cnf file or in the
manual??? I am sure this is a
Hi ppl
I had a auto increment column
let say the auto increment would look like this
100,1001,1003,1101,1103,10005,10006
yes I had delete several column in tha past
now I would like to sort it again so it would be an order from 100 to 1006
is it possible for mysql to do that with out drop
Actually i want to lock a db in mysql with the flush command
should i go thru CPAN for that purpose or i can do it with a single
command like
mysql -u -p DBNAME --execute flush tables with read only
i have tried this but it is not working for me
that is why i put that mail
Is there
You should use the `FLUSH' command if you want to clear some of the
internal caches *MySQL* uses. To execute `FLUSH', you must have the
*reload* privilege.
FLUSH TABLES closes all open tables.
If you want table level locks, use LOCK command.
LOCK TABLES tbl_name [AS alias] {READ | [READ
Nikolaos and Victoria,
Victoria! Just like Nikolaos, I also don't know what you mean send new
character sets as seen with the explanations.
The first thing I have to mention that I'm not sure how MySQL string
comparison works, but I think it just compares the characters at the same
position
I want to select from three tables where there may or may not be a record in
the third table. Table 1 and 2 have a one to one relationship and table 1
and 2 both have a one to many relationship with table three. All three
tables have a column called 'code' and I want to select where code is in
Leonard Miller [EMAIL PROTECTED] writes:
Lets try this again.
Try thinkgeek.com
They don't have any, but copyleft does. URL:
http://www.copyleft.net/item.phtml?page=product_889_front.phtml
obNoSpamPadding: sql.query, MySQL, InnoDB, select * from user;
--
- håkon
Tor R. Skoglund (NextG) [EMAIL PROTECTED] writes:
Dan, thanks for your reply. I will first try to do a 'clean' install from
the source.
That link below is seems to be the 3.23.51 source... not the 4.0.2-Max that
I want.
I have searched the web for a full tarball source distribution of
Hello! :)
Is there a way to undo query.
For example if execute from mysql prompt
update table set address='something';
and update all row is there a way to undo this action.
Thank you.
Kosyo
__
Do You Yahoo!?
Yahoo! Health - Feel better, live
Dasmeet Singh [EMAIL PROTECTED] writes:
Is there any free mailing software that uses PHP/MySQL? I am looking
for a simple yet powerful software that could manage addressess in
thousands and several mailing lists together.
Thanx in advance.
Yes, there are several. I can't tell you which one
Leonard Miller [EMAIL PROTECTED] writes:
mysql version 3.23.41 On Redhat 7.2
I was trying to get this setup so I could limit access to future
databases,
and I think I locked my root account out.
I tried restarting with /etc/rc.d/init.d/mysqld start
--skip-grant-tables, but I don't think
Leonard Miller [EMAIL PROTECTED] writes:
Lets try this again.
Try thinkgeek.com
They don't have any, but copyleft does. URL:
http://www.copyleft.net/item.phtml?page=product_889_front.phtml
obNoSpamPadding: sql.query, MySQL, InnoDB, select * from user;
--
- h
åkon
Tor R. Skoglund (NextG) [EMAIL PROTECTED] writes:
Dan, thanks for your reply. I will first try to do a 'clean' install from
the source.
That link below is seems to be the 3.23.51 source... not the 4.0.2-Max that
I want.
I have searched the web for a full tarball source distribution of
Hello! :)
Is there a way to undo query.
For example if execute from mysql prompt
update table set address='something';
and update all row is there a way to undo this action.
Thank you.
Kosyo
__
Do You Yahoo!?
Yahoo! Health - Feel better, live
Dasmeet Singh [EMAIL PROTECTED] writes:
Is there any free mailing software that uses PHP/MySQL? I am looking
for a simple yet powerful software that could manage addressess in
thousands and several mailing lists together.
Thanx in advance.
Yes, there are several. I can't tell you which
We have a support contract with you. One of my clients has lost his root
password. How can we access his mysql?
Michael Johnson
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
Leonard Miller [EMAIL PROTECTED] writes:
Lets try this again.
Try thinkgeek.com
They don't have any, but copyleft does. URL:
http://www.copyleft.net/item.phtml?page=product_889_front.phtml
obNoSpamPadding: sql.query, MySQL, InnoDB, select * from user;
--
- h
åkon
Tor R. Skoglund (NextG) [EMAIL PROTECTED] writes:
Dan, thanks for your reply. I will first try to do a 'clean' install from
the source.
That link below is seems to be the 3.23.51 source... not the 4.0.2-Max that
I want.
I have searched the web for a full tarball source distribution
Description:
While trying to compile MySQL version 3.23.51 on a HP-UX 11.00 9000/803
PA-RISC 1.1 I get the following linking error:
gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti
-fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW -DHAVE_BROKEN_PREAD
Description:
After issuing an incorrect GRANT command Mysqld crashed, but
restarted itself. On the next boot-up of the machine, Mysqld
crashes on startup with an added message about unable to find
user.MYD Copying user.MYD from a backup directory changed the
Hello!
This one should work:
SELECT
...
FROM
table1 t1
LEFT JOIN table2 t2 USING (code)
LEFT OUTER JOIN table3 t3 USING(code)
WHERE
t1.code = t3.code
OR t3.code IS NULL
;
Mark Colvin wrote:
I want to select from three tables where there may or may not be a record in
Hi,
I am pretty new to perl and am currently involved in setting up MySQL
database using Perl. My setup includes MySQL running on Win95.
I have a simple program which writes a few values to a database. The
file works fine when using the Command Line interface and the database
gets the
Konstantin Yotov wrote:
Hello! :)
Is there a way to undo query.
For example if execute from mysql prompt
update table set address='something';
and update all row is there a way to undo this action.
Thank you.
Unless you are using a table type that is supporting transactions and
have
1. Take down the mysqld server by sending a kill (not kill -9) to
the mysqld server. The pid is stored in a `.pid' file, which is normally
in the MySQL database directory:
shell kill `cat /mysql-data-directory/hostname.pid`
You must be either the Unix root user or the same user
Hello!
[EMAIL PROTECTED] wrote:
Description:
After issuing an incorrect GRANT command Mysqld crashed, but
restarted itself. On the next boot-up of the machine, Mysqld
crashes on startup with an added message about unable to find
user.MYD Copying user.MYD from a
Hello!
Troy Hickey wrote:
Hi,
I am pretty new to perl and am currently involved in setting up MySQL
database using Perl. My setup includes MySQL running on Win95.
I have a simple program which writes a few values to a database. The
file works fine when using the Command Line interface and
My problems seem to be occuring with the table receiving the processed
firewall logs. However I don't understand this - there may be an insert of
200-500 records every five minutes, but reporting and cleanup only touches
this table once a day. My syslog table has inserts and deletes run on it
Is there a different method of logging onto a DB when using it in a
cgi-bin script rather than running the script from the DOS prompt? This
would indeed explain a not connecting problem.
My code snippet is:
#
$db=employees;
Hello!
[EMAIL PROTECTED] wrote:
Description:
After issuing an incorrect GRANT command Mysqld crashed, but
restarted itself. On the next boot-up of the machine, Mysqld
crashes on startup with an added message about unable to find
user.MYD Copying user.MYD from a backup
Konstantin Yotov wrote:
Hello! :)
Is there a way to undo query.
For example if execute from mysql prompt
update table set address='something';
and update all row is there a way to undo this action.
Thank you.
Unless you are using a table type that is supporting transactions and
have
Hello!
This one should work:
SELECT
...
FROM
table1 t1
LEFT JOIN table2 t2 USING (code)
LEFT OUTER JOIN table3 t3 USING(code)
WHERE
t1.code = t3.code
OR t3.code IS NULL
;
Mark Colvin wrote:
I want to select from three tables where there may or may not be a record
Description:
After issuing an incorrect GRANT command Mysqld crashed, but
restarted itself. On the next boot-up of the machine, Mysqld
crashes on startup with an added message about unable to find
user.MYD Copying user.MYD from a backup directory changed the
message
Hello all. I have been trying to add a second slave to my server but have
come up to a hopefully easy problem. The first slave is up and running
fine, but after copying down the master info to the second slave when I go
to start it it is trying to read the original logs which were/are being
used
We have a support contract with you. One of my clients has lost his root
password. How can we access his mysql?
Michael Johnson
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
1. Take down the mysqld server by sending a kill (not kill -9) to
the mysqld server. The pid is stored in a `.pid' file, which is normally
in the MySQL database directory:
shell kill `cat /mysql-data-directory/hostname.pid`
You must be either the Unix root user or the same user
Leonard Miller [EMAIL PROTECTED] writes:
Lets try this again.
Try thinkgeek.com
They don't have any, but copyleft does. URL:
http://www.copyleft.net/item.phtml?page=product_889_front.phtml
obNoSpamPadding: sql.query, MySQL, InnoDB, select * from user;
--
- h
åkon
Dasmeet Singh [EMAIL PROTECTED] writes:
Is there any free mailing software that uses PHP/MySQL? I am looking
for a simple yet powerful software that could manage addressess in
thousands and several mailing lists together.
Thanx in advance.
Yes, there are several. I can't tell you
Tor R. Skoglund (NextG) [EMAIL PROTECTED] writes:
Dan, thanks for your reply. I will first try to do a 'clean' install from
the source.
That link below is seems to be the 3.23.51 source... not the 4.0.2-Max that
I want.
I have searched the web for a full tarball source
Troy Hickey wrote:
Is there a different method of logging onto a DB when using it in a
cgi-bin script rather than running the script from the DOS prompt? This
would indeed explain a not connecting problem.
My code snippet is:
#
Hello!
Troy Hickey wrote:
Hi,
I am pretty new to perl and am currently involved in setting up MySQL
database using Perl. My setup includes MySQL running on Win95.
I have a simple program which writes a few values to a database. The
file works fine when using the Command Line interface and
Are partial word searches available with a FULLTEXT index.
I.E. could the following select statement return any results given that the
word Pippins or Pippin's is indexed ?
SELECT * from list WHERE MATCH (cols) AGAINST ('pipp')
TIA,
Pat...
[EMAIL PROTECTED]
MySql
Hi list,
A nut to crack:
I have a medium-sized database(about 1000 rows). The keys contain
zip-address-information. Now I want to get the surrounding persons, e.g.
someone has zip 12345 I would get(now for 4 entries):
+---+--+
| 12340 | personA |
| 12345 | personB | -- I searched
Hello:
I have SSH installed on our MYSQL server box, and no matter what I do I
can't connect into the box to access remotely.
Does anyone know how to DISABLE the protection on the MYSQL ports ?
Help !
Brett Whittaker
Ottawa, Ontario Canada
http://www.mysql.com/doc/C/o/Command-line_options.html
See --skip-grant-tables
-Original Message-
From: michael johnson [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 4:33 AM
To: Support at Mysql; mysql@lists. mysql. com
Subject: Lost root password
We have a support
c if this helps:
1.. Cold Reboot the machine and hit the SPACE bar to stop loading when
this message appears:
Hit[ENTER] to boot immediately or any other key for cmd prompt. Booting
kernel in 9,8,7?
2.. Type: boot -s (machine now in single user mode.)
You will see the following
Does mysql own master.info ?
If you copied it as root, mysqld probably can't read it.
Nicholas Stuart wrote:
Hello all. I have been trying to add a second slave to my server but have
come up to a hopefully easy problem. The first slave is up and running
fine, but after copying down the master
Konstantin,
Monday, July 22, 2002, 12:49:06 PM, you wrote:
KY Is there a way to undo query.
KY For example if execute from mysql prompt
KY update table set address='something';
KY and update all row is there a way to undo this action.
KY Thank you.
If you used transactions, yes. Take a look
Leonard,
Saturday, July 20, 2002, 4:50:32 PM, you wrote:
LM mysql version 3.23.41 On Redhat 7.2
LM I was trying to get this setup so I could limit access to future
LM databases,
LM and I think I locked my root account out.
LM I tried restarting with /etc/rc.d/init.d/mysqld start
LM
DBs(ML),
Saturday, July 20, 2002, 3:50:48 PM, you wrote:
DM 2) Nope, I have nothing on the end of the line.
DM eg.
DM set-variable = back_log = 200
DM this works under 4.0.1 but not under 4.0.2
DM back_log = 200
DM this works under 4.0.2
DM Error: (from 4.0.2 when using set-variable =
michael,
Monday, July 22, 2002, 1:32:47 PM, you wrote:
mj We have a support contract with you. One of my clients has lost his root
mj password. How can we access his mysql?
You should take down mysqld, start the one with --skip-grant-tables option
and change password for user 'root'.
It also
Hiya,
We're running a 1gz server which crashed around an hour ago and I'm trying
to find out why,
it's averaging 60 queries per second according to mysql status and I figure
that's why the server crashed although it had happily handled 15 million
questions up to that point.
Is there a logfile
Norton AntiVirus found a virus in an attachment you (mysql
[EMAIL PROTECTED]) sent to [EMAIL PROTECTED]
To ensure the recipient(s) are able to use the files you sent, perform a
virus scan on your computer, clean any infected files, then resend this
attachment.
Attachment: width.scr
Virus
Yes you can do it utilizing fulltext search in boolean mode...
SELECT * from list WHERE MATCH (cols) AGAINST ('pipp*' IN BOOLEAN MODE);
See: http://www.mysql.com/doc/F/u/Fulltext_Search.html
Gurhan
- Original Message -
From: Patrick Sherrill [EMAIL PROTECTED]
To: mySQL List [EMAIL
Hi,
Can you please explain what is the algorithm here? Say you have zip code
12345, do you need all rows thats have zipcodes between 12340 and 12350, and
vice versa?
We can't help without knowing what do you mean by surrounding .
Gurhan
- Original Message -
From: Jan Peuker [EMAIL
Hi,
sorry for my bad earlier explanation.
What I want to do is, select the 10(say, a value) nearest values to a given
number. The easiest way would be near 5 shows 1..10. The problem is, the
number should affect rows, not values, because values are not unique nor in
order. What I want to do is a
Hi,
Use LEFT JOIN instead =
Bye and Good Luck!
--- Mark Colvin [EMAIL PROTECTED] wrote:
I want to select from three tables where there may
or may not be a record in
the third table. Table 1 and 2 have a one to one
relationship and table 1
and 2 both have a one to many relationship with
Hi,
If you mean how to connect to a MySQL server from a
remote machine in a local network, you only need to
include the computer (or ip address) of the server in
the HOSTNAME. You also have to make sure that the user
in the connection string, has permission to access the
database, you should go
Hi,
Mailing list: http://lists.mysql.com/
Joining three tables could be something like this.
Select * from t1 INNER JOIN t2 ON t1.id = t2.id INNER
JOIN t3 ON t2.id = t3.id
I highly recomend you to read some basic SQL books
before you carry on with your project. Trial and error
is not always
Hi friends,
Can anybody tell me some good projects in C/C++/ with
MYSQL with brief explanation. Focus is on MYSQL.
Thanks in advance.
regards...
-krishna
Email: [EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Health - Feel better, live better
At 10:35 -0400 7/22/02, Patrick Sherrill wrote:
Are partial word searches available with a FULLTEXT index.
I.E. could the following select statement return any results given that the
word Pippins or Pippin's is indexed ?
SELECT * from list WHERE MATCH (cols) AGAINST ('pipp')
Not as written.
SELECT code FROM zip WHERE (zip 12345-5) AND (zip 12345+5);
Does this work out fine for you??
Note that it will work only if the zip field is integer...
Gurhan
- Original Message -
From: Jan Peuker [EMAIL PROTECTED]
To: Gurhan Ozen [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent:
I seem to be destined to become an expert on restarting mysql and
dealing with passwords despite myself :-). This time I'm working on a
slight variation: restarting mysql on a machine that we haven't been
using for some 18 months and that I myself have never used.
Mysql appears to be installed
Run myisamchk BEFORE you start the server!
William_dw -- Sqlcoders wrote:
Hiya,
We're running a 1gz server which crashed around an hour ago and I'm trying
to find out why,
it's averaging 60 queries per second according to mysql status and I figure
that's why the server crashed although it had
Sorry,
I might not have been clear, the mySQL server magically restarted itself
once it crashed apparently, I got woken up with a call saying the homepage
had a 'funny message', and when I hopped into the mysql console it said it
had been up 1 hour 30 minutes (considering it said it was up for 40
Thanks for the input, unfortunately are production server is still v 3.26.xx
Pat...
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Patrick Sherrill [EMAIL PROTECTED]; mySQL List
[EMAIL PROTECTED]
Sent: Monday, July 22, 2002 2:40 PM
Subject: Re: mysql FULLTEXT Searches
At
It isn't in one statement, but what about, after you get your zip code
select * from table where zip yourzip order by zip desc limit 5
select * from table where zip yourzip order by zip limit 5
On Monday, July 22, 2002, at 12:53 PM, Jan Peuker wrote:
Hi,
sorry for my bad earlier
Description:
Deadlock occurs when slave is locked trying to write to table that was
write locked by separate process who then tries to do a slave stop. This should
only happen on a mutual master set up (i.e. 2 servers that are each other's
master); otherwise, the only write locks would
If you know the value of the ZIP you want to surround lets call it
KZIP then try
SELECT code, abs(code - kzip) as Diff from zip order by Diff Limit n;
The '-' will make MySQL convert the zip codes into numeric values, ABS
is absolute value therefore making all of the results positive, order by
In the last episode (Jul 22), Jan Peuker said:
What I want to do is, select the 10(say, a value) nearest values to a
given number. The easiest way would be near 5 shows 1..10. The
problem is, the number should affect rows, not values, because values
are not unique nor in order. What I want to
Hi all,
I have difficulties obtaining the MySQL4.0.2a. It seems that numerous
downloads
links point to the files stated as 4.0.2 zip file but during the setup , it
was 4.0.1a
instead. Where can I obtain the 4.0.2a ? Many thanks.
Best regards,
Michael
Hi!,
I'm hoping someone can give me a pointer as to what's going wrong that's
crashing our MySQL server, I've included a snippet of the log (for the last
time it restarted and then the errors after that).
I've been trying to read through the 'Debugging MySQL server' section, but
there doesn't
Hi
I'm looking for an sql query Select Statement which can find a lot of Keywords
(AND OR) in one or more table.
Are there any suggestions... ?
Thanks,
Franz-josef
--
Dr. Franz-Josef Huecker
W3: http://www.huecker.com
Email: [EMAIL PROTECTED]
--
Dr. Franz-Josef Huecker
W3:
Hi,
I have a mysql database with innodb tables, and I keep running into a
deadlock that is not detected (causes a timeout) and that I don't think
should be happening. Can anyone explain why this is causing a deadlock,
and secondly, how can I fix it or how can I change this so that the
deadlock
Dan,
Hi, good news.. =) I've already successfully installed mysql...
Thank you very much to you and georg :)
Thanks for helping me out. I'm quite new here...
My last problem was solved by fixing my path...
ok...
Dexter...
- Original Message -
From: Dan Nelson [EMAIL
Hi,
Assuming that there are 2 users for MYSQL.
First user issues 'lock tables customer_table write';
Second user wish to view the customer info using the command 'select * from
customer_table';
This select query will be pending untill the first user issues the 'unlock
tables' command.
I am
Had a wierd problem with my first slave.
Slave 1 has MySQL 4.02 on win 2000
Slave 2 has MySQL 3.23.49(?) or some where arond there on win nt 4
Master has MySQL 3.23.51 on Linux RH 7.2
Slave 2 and master appear to be running with out problems. How ever after
making several table drops to the
Dear list,
I've been trying to install mysql 4.0.2. alpha.
The configuration is going well.
That also count's for the make command.
But when I run the make test command I'm getting the following error:
ERROR: /down/mysql-4.0.2-alpha/mysql-test/var/run/master.pid was not
created in 30 seconds;
Hi,
i'm newbie in c/c++ language. i'm going to build c/c++ GUI application
on Windows and using C api (libmysql.dll) to connect my application to
database.
i'm still confused regarding static and dynamic library,
i don't know how to include it to my source and how to compile
my source using
Joe,
are you also using MySQL table level locks? I mean
LOCK TABLES ... READ, ... WRITE
The deadlock detection algorithm does not know of them and we must resort to
a timeout.
Below we see that the second trx has shared row level locks though it is
executing an UPDATE. An UPDATE sets
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Please let me know the entries of host and user table of 'mysql' database.
You need to provide the access to remote machine through these tables.
-Original Message-
From: Brett Whittaker [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 22, 2002 9:05 PM
To: MySQL
Cc: Brett Whittaker
Subject:
Can anyone tell me how do achieve the following in MySQL:
Update oitems
SET Pstatus = SELECT product.Pstatus from products
WHERE oitems.Pstatus not like %Printed%
AND oitems.ProdCode=products.Code
i.e. I need to update all order item status flields that have not been
can you tell me where to find some useful example or documentation about
using python with mysql? Especially with MySQLdb module.
thanks!
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I am acessing MySQL 3.23.51 running
on FreeBSD 4.6-i386.
Variable interactive_timeout=28800.
But without activity server disconnects
in 10 minutes. In both cases of just
mysql client and myODBC from Windoz box.
Any ideas what may be the reason and
how to fix? Maybe some other timeout
accounts
OOps somehow my last request got re: on the Subject
Can anyone tell me how do achieve the following in MySQL:
Update oitems
SET Pstatus = SELECT product.Pstatus from products
WHERE oitems.Pstatus not like %Printed%
AND oitems.ProdCode=products.Code
i.e. I need to update all
91 matches
Mail list logo