Antwort: RE: Antwort: RE: how to backup mySQL database?
On 28.02.2001 05:58:33 ?US-ASCII?Q?Fabio_Ottolini?= wrote: mysqldump "spits" not only table structures but data also. When you use mysql to import data it will first attempt to create the table and then load its values. If your table's got AUTO_INCREMENT set it will work fine after recreating the database. Anyway... Give it a try! :) Once more: No, it won't. Again, do this, and you'll see that it will not work correctly - or rather it will work correctly, but the recreated table will have different values. Create a table with one AUTO_INCREMENT column called ID. Insert one row, like so: INSERT INTO Tbl (ID) VALUES (0) Check all the rows: SELECT ID FROM Tbl You'll see that the row's ID column is != 0. Do this to set the column to 0: UPDATE Tbl SET ID=0 WHERE ID = 1 Check all the rows: SELECT ID FROM Tbl Now the row will have the ID set to 0. Dump the table, drop the table, replay the dump. Now you'll have just one row again, but ID will be != 0, because the dump contained the statement "INSERT INTO Tbl (ID) VALUES (0)" - as I just explained, this won't work. Give it a try before you disagree again :-)) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: Re: Antwort: Re: Antwort: RE: how to backup mySQL database?
On 28.02.2001 19:51:13 Gerald L. Clark wrote: In the dump, the autoincrement columns will have their actual values, not 0. Yes, correct - and if the actual value is 0, it will contain just this. And inserting a row with the col set to 0, will change the column value. TRY IT! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: Re: [auto_increment]
On 28.02.2001 22:51:12 Jason Landry wrote: Well, except that the value of an auto-increment field CAN be set to a specific value (perhaps negative) an INSERT or UPDATE statement. As long as the value is != 0 for INSERT statements. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: Re: Antwort: AW: version 3.23.29a-1
On 01.03.2001 02:37:17 Rolf Hopkins wrote: Or use the no dependency flag or upgrade. That's as good as suggesting to not use rpm at all. The dependencies are in there with a reason, you know. Never upgrade/install with --force/--nodeps. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A query?
Hi everybody, I qould like to this query: select userid,count(userid) from points where acq=6 group by userid limit 100 but only get the results where count(userid)1 And I don't know how to do that. Could anyone of You please help me out?. TIA. /Patrik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Security annoucement mailing-list ?
Hi! On Mar 01, Benjamin Pflugmann wrote: Hi. On Mon, Feb 26, 2001 at 08:57:19PM +0100, you wrote [...] Yes, security info is to be sent to announcement list. Well, the last two weren't sent to the announcement list, AFAIK. Well, it's a question of its own, whether to send an announcement out due to an buffer overflow in the client. But the people on bugtraq thought it was worth an email and people who are very security-aware may want to be informed about potentially exploitable bugs. If I wouldn't get aware about these problems by the mysql general list and bugtraq, I think I would feel uninformed by the announcement list (regarding security issues). Bye, Benjamin. That's true. For quite a long time there were no security-related bugs in MySQL :-) and we, really, happen not to have a policy about this. Now, [EMAIL PROTECTED] is created for reporting security-related issues (NOTE EVERYBODY !!!), and information about such bugs from now on would be posted to announcement list, for everybody would have his chance to upgrade ASAP. And there're also announcements about new MySQL version, with their "What's New" section... Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: auto_increments
On 01.03.2001 01:54:14 John Nielsen wrote: Hey everyone, This may have already come up a couple of times in the mailling list, but I I was wondering with mysql-3.22.32 if you can have two auto_increment's in one table, e.g.: What would this be good for? Yes, I've seen that one of your auto_increments was a tinyint, and the other one a mediumint. I still don't get this. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
boolean type
Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is closest to the boolean type
New mechanism in retrieving data from tables
Hi,
The webhosting company where I host my my site had upgraded their mysql to
3.23.32
and now my program has an error, saying :
Supplied argument is not a valid MySQL result resource in
the error is in the line containing :
while ($row = mysql_fetch_row($result1)) {
I check the new documentation, saying that in the 3.23.34 version of mysql,
there is a new mechanism to retrieve data from tables, in short they are :
1. mysql_query
2. mysql_use_result or mysql_save_result
3. mysql_fetch_row
but when I tried this, there is an error :
Fatal error : Call to undefined function: mysql_use_result() in
seems like their mysql doesn't recognize the function.
so .. what should I do? I can't find the documentation for mysql 3.23.32
please anyone help me ..
regards,
Yusef
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC for Windows ME
Hi Greg, Yes. Only installed it a couple of weeks ago, but it seems to work fine (using the Win95 version). cheers, Mark - Original Message - From: "genge1" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 01, 2001 4:57 AM Subject: MyODBC for Windows ME Has anyone installed MyODBC under Windows ME? Did you use the Win95 or NT version? I don't have the OS, still on Win95 and 98, but I have a client who wants to install the driver. Thanks in advance. Greg Engel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Why Heap Tables doesn´t support auto_increment colums
Hi, I wounder why there is no support for Auto_increment fields in Heap tables. I know there is a problem with the uniqueness of this columns but some times the uniqueness of the column is only needes as long as the heap table exists. Im currently working on system for Managing http Session and would like to use a heap table for storing the session information. Session information is only of temporary intrest. But still I need an unique ID for reference with some other Tabels storing dtaa for the session. All these tables are Heap tables. So there is no Probelem if the ID generated by the auto_increment column is not unique when the Database server is restarted. So Long Estartu -- Gerhard Schmidt mailto:[EMAIL PROTECTED] Softwaredevelopment adMaster network Tel.: +49 89 38356-334 Kaiserstrae 16 D-80801 Mnchen http://www.admasternetwork.net PGP signature
RE: What's the syntax for using ENCODE()?
You have an odd number of brackets in each case, you are missing a " ) "
-Original Message-
From: Kinney Baughman [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 11:18 PM
To: [EMAIL PROTECTED]
Subject: What's the syntax for using ENCODE()?
Hi,
I'm trying to encrypt credit_card numbers in MySQL 3.23.33. I want to
decrypt them when I retrieve them.
I've tried:
mysql insert into payment (payname1,ccaccount) values
("Kinney",encode('','Ilwfci');
ERROR 1064: You have an error in your SQL syntax near '' at line 1
mysql insert into payment (payname1,ccaccount) values
("Kinney",encode(,Ilwfci);
ERROR 1064: You have an error in your SQL syntax near 'Ilwfci)' at line 1
mysql insert into payment (payname1,ccaccount) values
("Kinney",ENCODE('',Ilwfci);
ERROR 1064: You have an error in your SQL syntax near 'Ilwfci)' at line 1
mysql insert into payment (payname1,ccaccount) values
("Kinney",encode(,'Ilwfci');
ERROR 1064: You have an error in your SQL syntax near '' at line 1
I have "ccaccount" set up as a blob.
As you can see, all I get is error messages. What am I doing wrong?
After I get them in, my next question is how to get them back out.
According to the manual, one should use: DECODE(crypt_str,pass_str) where
"crypt_str" should be a string returned from ENCODE(). This seems to be a
catch-22, though. Wouldn't I have to know the value of "crypt_str", i.e.
the credit_card number in order to get that encrypted string out of
ENCODE()?
Thanks.
--
+---+
| Kinney Baughman Appalachian State University |
| Appalachian Regional Development InstituteBoone, NC 28608 |
| Email: [EMAIL PROTECTED] Phone: (828) 262-6523 |
+---+
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: Select from dual?
On 01.03.2001 10:46:33 M. A. Ould-Beddi wrote: I know that in Oracle it is possible to select a number from DUAL and put it in a variable. Is it possible ??? What's DUAL? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: boolean type
On 01.03.2001 09:50:36 Blaz Grapar wrote: Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is closest to the boolean type ShortInt: 0 == FALSE, 0 == TRUE That's how I do it anyway. Or maybe combine multiple bool fields to one and use binary logic. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SV: A query?
Thank You for the help, the "having" didi the trick. /Patrik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why Heap Tables doesn´t support auto increment colums
Why not use a timestamp column to guarentee the order in which rows get inserted into the table? You can then order on the timestamp column. Gerhard Schmidt wrote: --d6Gm4EdcadzBjdND Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi,=20 I wounder why there is no support for Auto_increment fields in Heap tables. I know there is a problem with the uniqueness of this columns=20 but some times the uniqueness of the column is only needes as long=20 as the heap table exists.=20 I=B4m currently working on system for Managing http Session and would like= =20 to use a heap table for storing the session information. Session=20 information is only of temporary intrest. But still I need an unique=20 ID for reference with some other Tabels storing dtaa for the session.=20 All these tables are Heap tables. So there is no Probelem if the ID=20 generated by the auto_increment column is not unique when the Database server is restarted.=20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: PHP and MySQL
You have to edit your "php.ini" file, usually located in /usr/local/lib.
There is an option called "mysql.default_socket". The value of this options
is the path to the mysql socket file. Your systems seems to search the
socket file at "/var/lib/mysql/mysql.sock". It might be at a different
place, probably "/tmp/mysql.sock".
Tobias.
-Ursprngliche Nachricht-
Von: root [mailto:root]Im Auftrag von Ben Kennish
Gesendet: Donnerstag, 1. Mrz 2001 11:56
An: [EMAIL PROTECTED]
Betreff: PHP and MySQL
Who would've thought it would take 3 days to install MySQL, PHP and get
them talking???!!
I've installed PHP 4.0.4pl1 using an RPM from www.redhat.com
I've also installed MySQL (latest ver) server and client versions from
www.mysql.com using RPMs.
Now MySQL seems to be up and working (using 'mysql' and 'mysqladmin'
gives me no trouble) and PHP seems to work fine ?php phpinfo(); ?.
I've installed the PHP-MySQL module from redhat.com (a single file -
mysql.so) and uncommented the "extension=mysql.so" line in /etc/php.ini
But when I type ...
mysql_connect('localhost', 'root', 'b');
into a PHP file, (I set b as my root SQL pwd) I get the following
error...
"Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/var/www/html/index.php on line 5"
There seems to be nothing in the MySQL error log.
Please help! Thanks,
--
Ben Kennish
Software Developer
Fubra Limited
web | www.fubra.net
email | [EMAIL PROTECTED]
phone | +44 (0)870 1222 600
fax | +44 (0)870 1222 699
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AW: PHP and MySQL
It is in /var/lib/msql
Ben K
Tobias Wolff wrote:
You have to edit your "php.ini" file, usually located in /usr/local/lib.
There is an option called "mysql.default_socket". The value of this options
is the path to the mysql socket file. Your systems seems to search the
socket file at "/var/lib/mysql/mysql.sock". It might be at a different
place, probably "/tmp/mysql.sock".
Tobias.
-Ursprngliche Nachricht-
Von: root [mailto:root]Im Auftrag von Ben Kennish
Gesendet: Donnerstag, 1. Mrz 2001 11:56
An: [EMAIL PROTECTED]
Betreff: PHP and MySQL
Who would've thought it would take 3 days to install MySQL, PHP and get
them talking???!!
I've installed PHP 4.0.4pl1 using an RPM from www.redhat.com
I've also installed MySQL (latest ver) server and client versions from
www.mysql.com using RPMs.
Now MySQL seems to be up and working (using 'mysql' and 'mysqladmin'
gives me no trouble) and PHP seems to work fine ?php phpinfo(); ?.
I've installed the PHP-MySQL module from redhat.com (a single file -
mysql.so) and uncommented the "extension=mysql.so" line in /etc/php.ini
But when I type ...
mysql_connect('localhost', 'root', 'b');
into a PHP file, (I set b as my root SQL pwd) I get the following
error...
"Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/var/www/html/index.php on line 5"
There seems to be nothing in the MySQL error log.
Please help! Thanks,
--
Ben Kennish
Software Developer
Fubra Limited
web | www.fubra.net
email | [EMAIL PROTECTED]
phone | +44 (0)870 1222 600
fax | +44 (0)870 1222 699
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Ben Kennish
Software Developer
Fubra Limited
web | www.fubra.net
email | [EMAIL PROTECTED]
phone | +44 (0)870 1222 600
fax | +44 (0)870 1222 699
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Transactions...
Hi, So does mySQL support transactions or not? There are transaction safe tables but they are not actually implemented? How people cope without transactions when there is a need for multiple UPDATEs or INSERTs...and they need to be implemented as a whole atomic operation? Thanx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MySQL - still got problem
I think that my file permissions are set OK. Heres a list of my MySQL
folder...
total 1652
drwx--6 mysql27 4096 Mar 1 11:37 .
drwxr-xr-x 20 root root 4096 Feb 15 16:26 ..
-rw---1 mysql27244 Feb 26 16:56 .bash_history
drwx--2 mysqlroot 4096 Feb 26 15:48 .xauth
drwx--2 mysqlmysql4096 Feb 28 16:32 BEN
-rw-r--r--1 mysqlmysql 1 Mar 1 10:28
chiefwigham.fubra.err
-rw-r--r--1 mysqlmysql8628 Feb 26 15:07
chiefwigham.fubra.err.old
-rw-rw1 mysqlmysql 3 Mar 1 10:06
chiefwigham.fubra.pid
-rw-rw1 mysqlmysql 322 Feb 26 14:15 chiefwigham.log
-rw---1 mysqlmysql 0 Feb 26 16:12 columns_priv.MYD
-rw---1 mysqlmysql1024 Feb 26 16:12 columns_priv.MYI
-rw---1 mysqlmysql8778 Feb 26 16:12 columns_priv.frm
-rw---1 mysqlmysql 302 Feb 26 16:12 db.MYD
-rw---1 mysqlmysql3072 Feb 26 16:12 db.MYI
-rw---1 mysqlmysql8982 Feb 26 16:12 db.frm
-rw---1 mysqlmysql 0 Feb 26 16:12 func.MYD
-rw---1 mysqlmysql1024 Feb 26 16:12 func.MYI
-rw---1 mysqlmysql8641 Feb 26 16:12 func.frm
-rw---1 mysqlmysql 0 Feb 26 16:12 host.MYD
-rw---1 mysqlmysql1024 Feb 26 16:12 host.MYI
-rw---1 mysqlmysql8958 Feb 26 16:12 host.frm
-rw-r--r--1 root root0 Mar 1 11:37 list.txt
drwx--2 mysqlmysql4096 Feb 28 14:26 mysql
srwxrwxrwx1 mysqlmysql 0 Mar 1 10:06 mysql.sock
-rwxr-xr-x1 mysqlmysql 1524536 Feb 19 13:56 mysqld
-rw---1 mysqlmysql 0 Feb 26 16:12 tables_priv.MYD
-rw---1 mysqlmysql1024 Feb 26 16:12 tables_priv.MYI
-rw---1 mysqlmysql8877 Feb 26 16:12 tables_priv.frm
drwx--2 mysqlmysql4096 Feb 28 16:13 test
-rw---1 mysqlmysql 428 Feb 26 16:12 user.MYD
-rw---1 mysqlmysql2048 Feb 26 16:12 user.MYI
-rw---1 mysqlmysql9148 Feb 26 16:12 user.frm
Thanks
Ben K
Ireneusz Piasecki wrote:
- Original Message -
From: "Ben Kennish" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 11:55 AM
Subject: PHP and MySQL
Who would've thought it would take 3 days to install MySQL, PHP and get
them talking???!!
I've installed PHP 4.0.4pl1 using an RPM from www.redhat.com
I've also installed MySQL (latest ver) server and client versions from
www.mysql.com using RPMs.
Now MySQL seems to be up and working (using 'mysql' and 'mysqladmin'
gives me no trouble) and PHP seems to work fine ?php phpinfo(); ?.
I've installed the PHP-MySQL module from redhat.com (a single file -
mysql.so) and uncommented the "extension=mysql.so" line in /etc/php.ini
But when I type ...
mysql_connect('localhost', 'root', 'b');
This can be that: mysql_connect('serwer_name','root','b' ); where
serwer_name is serwer, that serve mysql databases
or you can chmod file mysql.sock than other can it write (it could help)
into a PHP file, (I set b as my root SQL pwd) I get the following
error...
"Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/var/www/html/index.php on line 5"
There seems to be nothing in the MySQL error log.
Please help! Thanks,
--
Ben Kennish
Software Developer
Fubra Limited
web | www.fubra.net
email | [EMAIL PROTECTED]
phone | +44 (0)870 1222 600
fax | +44 (0)870 1222 699
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Ben Kennish
Software Developer
Fubra Limited
web | www.fubra.net
email | [EMAIL PROTECTED]
phone | +44 (0)870 1222 600
fax | +44 (0)870 1222 699
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble
Re: Maximum Password length?
Hi,
My apologies if this is an easy question. I've looked at the docs in the
privilege section and haven't found a mention of the max length of password
for MySQL. I want to set a fairly long one for each of my web servers that
will be hitting my database server. Incase it is important, I'm running
3.23.33 on Redhat 7.0.
Anyone know how long they can go?
From the 'user' table in the 'mysql' database:
mysql describe user;
+-+---+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+-+---+--+-+-+---+
| Host| char(60) | | PRI | | |
| User| char(16) | | PRI | | |
| password| char(16) | | | | |
.
Looks like it is 16? :)
That's not quite right, actually. Yes, the field in the 'user' table is 16
characters, but MySQL doesn't actually store the original password there.
What it stores is a crytographic cipher of the password, created using the
PASSWORD() function (which is why you must specify the password using that
function when changing passwords).
So, no matter what password you specify for an user, the string stored in
the 'user' table will always be 16 characters. Let me illustrate with a
quick example:
mysql select password('blah') as crypto;
+--+
| crypto |
+--+
| 652f9c175d1914f9 |
+--+
1 row in set (0.00 sec)
mysql select
password('kjsdhfaheiehafiaefajfjaslkfnvfmnglsdahewijfioejfoiaewjfwea') as
crypto;
+--+
| crypto |
+--+
| 4d88ee387b92a03e |
+--+
1 row in set (0.00 sec)
But anyway, to answer the original question - it's unlikely that any
limitations will be encountered with the lengths of passwords that are
planned to be used.
The only likely limit I can think of would be that of any buffers in the
MySQL query parsing routines or those in the code for the PASSWORD()
function. Any MySQL developers care to comment on this, just out of
interest?
Regards,
Basil Hussain ([EMAIL PROTECTED])
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
running mysql not as a server
How can I run mySQL in a Windows app in a non-server mode. That is how can I get the app to start mySQL when the app starts and shut it down when the app is exited. Are there any issue that might cause a problem? Thanks for your help. Best Regards, Mike Michael Gilman, PhD Data Mining Technologies Inc. (516) 470-9011 ext 100 [EMAIL PROTECTED] The information transmitted in this email is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this email in error, please contact the sender and permanently delete the email from your computer.
Error 1052:Query problem
Table_A: ID APPL B BI A BII * * * * C BII * * D BI Table_B: Cnty ID USC Aus A Aus B USD * signifies no data why does the following produce an error: 1052?? SELECT DISTINCT APPL FROM Table_A, Table_B WHERE Table_A.ID=Table_B.ID AND Cnty="US" AND ID="*"; _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL Feature :)
Peter Zaitsev writes:
Hello mysql,
Mysql 3.23.32 running on Linux.
I've got a table with auto_increment command stuck, well this is no
problem there is a record in this table with MAX_UINT value.
I'm not really shure if this is a bug or correct behavior, but still
it leads to toe problems in this case:
insert into g02layers_stat_hits set counter=1, type=1, page_group=1;
ERROR 1062: Duplicate entry '4294967295' for key 1
This is quite well result, but if we use replace in this case (which
works quite OK then the table has not maximum number of rows:
mysql replace into g02layers_stat_hits set counter=1, type=1, page_group=1;
Query OK, 2 rows affected (0.33 sec)
and in this case the old row with id=4294967295 is destroyed.
There for this works quite nice then the table does not have last_id
used:
mysql replace into g02layers_stat_hits set counter=1, type=1, page_group=1;
Query OK, 1 row affected (0.02 sec)
in this case the new ID is generated and everything is just fine :)
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
Hi!
Yes, the above is well known behaviour.
What do you suggest, how should we change that ??
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Use Ukrainian lenguage.
Dear support group of MySQL, When I use MySQL for Windows with languages like Ukrainian, Rassian I can't use case insensitive select, or operator like Upper. Can you help me? Becouse I understand that I mast recompile server, is'nt it? Please give me ansver!!! Sincerely, Anatolii.
Re: boolean type
Blaz Grapar wrote:
Is there a boolean field type (Yes/No; True/False, 1/0) in MySQL or what is closest
to the boolean type
ENUM("no","yes")
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Calculated Field
How do I set up a field called Minutes which has the (default) value, where round((SessionTime+30)/60) = Minutes Is it possible to set this up? In other databases (Alpha Five) I would have used a Calculated Field attribute to achieve this. Can MySql handle it.. ??? -- Daniel M O Higgins, Totally Connect Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: PHP and MySQL
On 01.03.2001 11:55:40 Ben Kennish wrote: "Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/index.php on line 5" Are you sure that your MySQL installation creates the socket right there? If I'm not mistaken, it may be created in /tmp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
changing some tables
hi, i have a table like that: CREATE TABLE user ( login varchar(50), pass varchar(50), PRIMARY KEY(login)); i have lot of info inserted already in that table. And i would like to add some more attributes. how can i do it, in order to maintain older info? drop the table. CREATE TABLE user ( login varchar(50), pass varchar(50), att1 varchar(10), att2 int(4), PRIMARY KEY(login)); mysqldump -u user -p password table table.txt is this right? regards, marcos lloret [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: Transactions...
On 01.03.2001 12:35:55 Gorjan Todorovski wrote: So does mySQL support transactions or not? There are transaction safe tables but they are not actually implemented? They are implemented, if you chose the right table type. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: changing some tables
Marcos wrote: hi, i have a table like that: CREATE TABLE user ( login varchar(50), pass varchar(50), PRIMARY KEY(login)); i have lot of info inserted already in that table. And i would like to add some more attributes. how can i do it, in order to maintain older info? drop the table. CREATE TABLE user ( login varchar(50), pass varchar(50), att1 varchar(10), att2 int(4), PRIMARY KEY(login)); mysqldump -u user -p password table table.txt is this right? regards, marcos lloret [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Hi, Look at ALTER TABLE, it is in the manual ;) Regards -- Joseph Bueno NetClub/Trader.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problen in mysql 'read only'
Dear Sir I am a regular user of MySql. I will be obliged if you help me. 1. The path of the data directory is /var/lib/mysql 2. The database name is 'directory' 3. The permissions of directory are drwxrwxrwx2 root root 4096 Mar 1 16:24 directory 4. All the files in the directory are having the permissions -rw-rw-rw-2 root root Now when I want to insert the data error message appears that the table is read only. error 1036. I tried all combination of permissions but no result. Mysql version is 3.22.25 Raman _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql Daemon...........
Since you did not
./mysql_install_db --user=mysql
the files are owned by the wrong id.
chown -R mysql /usr/home/treebc.com/mysql/var
if that is the correct location for the database directories.
nirmala wrote:
Hi,
We have installed Mysql on our server(UNIX) . When I am telnet into the
server and try to start Mysql by below procedure, I am getting problem.
Anyone can help me.
[/usr/home/tree/www/treebc.com] matis: {2} % cd mysql/bin
[/usr/home/tree/www/treebc.com/mysql/bin] matis: {3} % ls
comp_errmysqladmin
isamchk mysqlbug
isamlog mysqldump
msql2mysql mysqlhotcopy
mysql mysqlimport
mysql_find_rows mysqlshow
mysql_fix_privilege_tables perror
mysql_install_dbprint_defaults
mysql_setpermission replace
mysql_zap resolveip
mysqlaccess safe_mysqld
[/usr/home/tree/www/treebc.com/mysql/bin] matis: {3} % ./mysql_install_db
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
/usr/home/tree/www/treebc.com/mysql/bin/mysqladmin -u root password 'new-passwor
d'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL = 3.22.10 you should run
the /usr/home/tree/www/treebc.com/mysql/bin/mysql_fix_privilege_tables. Otherwis
e you will not be
able to use the new GRANT command!
Please report any problems with the /usr/home/tree/www/treebc.com/mysql/bin/mysq
lbug script!
The latest information about MySQL is available on the web at http://www.mysql.c
om
Support MySQL by buying support/licenses at http://www.tcx.se/license.htmy.
[/usr/home/tree/www/treebc.com/mysql/bin] matis: {4} % ./safe_mysqld
Starting mysqld daemon with databases from /usr/home/tree/www/treebc.com/mysql/v
ar
mysqld daemon ended
[/usr/home/tree/www/treebc.com/mysql/bin] matis: {5} % ./safe_mysqld
[1] 13065
[/usr/home/tree/www/treebc.com/mysql/bin] matis: {6} % Starting mysqld daemon
with databases from /usr/home/tree/www/treebc.com/mysql/var
mysqld daemon ended
Regards,
Nirmala,
([EMAIL PROTECTED])
Tree Data Resources Pte Ltd.
Tel: (65) 2736588 X 15.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading MySQL causes Error - ASP
They replaced your MySQL with a new version.
Did they re-compile Apache and PHP to use the new MySQL libraries,
or is it trying to use the now missing ones?
Celso Pires wrote:
Hi there,
I've got a site hosted at an ISP and everything was going well when they
decided to upgrade the software. Now my site is running under Win2K, IIS5,
MySQL 3.23.33 and MyODBC 2.50.36.
In order to get easier to explain what is going wrong, I've built the
following test:
CREATE TABLE person (
person_ID INTEGER NULL,
name CHAR(50) NULL,
gender CHAR(1) NULL
);
INSERT INTO person (person_id, name, gender) values
(1,'Bob','m'),(2,'Mary','f'),(3,'Antony','m'),(4,'Rose','f'),(5,'Kuerten','m');
mysql select count(*) as quantity, gender
- from person
- group by gender;
+--++
| quantity | gender |
+--++
|2 | f |
|3 | m |
+--++
2 rows in set (0.01 sec)
*** As you can realize, so far so good. Now things get worse ***
html
head
titleGROUP BY TEST/title
/head
body bgcolor="#FF"
%
Response.Write "Beginbr"
strConn =
"DRIVER=MySQL;SERVER=myserver;DATABASE=mydatabase;UID=myuser;PWD=mypass;"
Set conn = Server.Createobject("ADODB.Connection")
conn.Open(strConn)
strSQL = "select count(*) as quantity, gender "
strSQL = strSQL "from person "
strSQL = strSQL "group by gender;"
Response.Write strSQL "BR"
Set Rs = conn.Execute(strSQL)
While Not Rs.EOF
Response.Write "Quantity: " RS("quantity") " - Gender: "
RS("gender") "BR"
Rs.MoveNext
Wend
Rs.Close
conn.close
response.write "The Endbr"
%
/body
/html
*** The page above should print:
Begin
select count(*) as quantity, gender from person group by gender;
Quantity: 2 - Gender: f
Quantity: 3 - Gender: m
The End
*** Instead, I'm getting this:
Begin
select count(*) as quantity, gender from person group by gender;
The End
*** It means that the record set is empty.
Thank you very much for any help.
Regards,
Celso.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql ./config..... concerning lncurses
These libraries should be on Debian installation CD. You just need to install them. "Mark R. Martinez" wrote: Hello, Our problem concerns an abnormal abort of: ./configure --prefix=/usr/local/mysql error messages show that lncurses, lcurses, ltermcap, could not be found. We are running Debian Linux 2.2x, on SPARC. We are trying to install 3.23.33. Any help would be useful thank you. Mark R. M. # I shall pass through this world only once. Any good I can do or any kindness I can show another human being let me do it now and not defer it, for I shall not pass this way again. DEFECTIO NON OPTIO EST "Failure is not an option" I do not SUFFER from insanity I enjoy every minute of it! Name: config.log config.logType: Plain Text (TEXT/PLAIN) Encoding: BASE64 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Calculated Field
Hi, How do I set up a field called Minutes which has the (default) value, where round((SessionTime+30)/60) = Minutes Is it possible to set this up? In other databases (Alpha Five) I would have used a Calculated Field attribute to achieve this. Can MySql handle it.. ??? In SQL databases in general, there is no such thing as a 'Calculated' field type. What you're probably used to is just a convinience supplied by other database systems. What you need to do to accomplish what you want is to calculate that minutes value on the fly, within the SELECT statement that retrieves your data. You don't need to add any fields to your table to do this. Here's an example: SELECT ROUND((SessionTime + 30) / 60) AS Minutes FROM YourTable Regards, Basil Hussain ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: PHP and MySQL - Default Socket Setting
[EMAIL PROTECTED] wrote: On 01.03.2001 11:55:40 Ben Kennish wrote: "Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/index.php on line 5" Are you sure that your MySQL installation creates the socket right there? If I'm not mistaken, it may be created in /tmp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php No it was creating it in /var/lib/mysql but then PHP doesn't like this Thanks to you, we've managed to get it working using the following commands... mysqladmin shutdown safe_mysqld --user=root --socket=/tmp/mysql.sock This works but would you happen to know how I can get NySQL to create the socket in /tmp/ at startup? (rather than having to shut it down and reboot with a new socket) Cheers, -- Ben Kennish Software Developer Fubra Limited web | www.fubra.net email | [EMAIL PROTECTED] phone | +44 (0)870 1222 600 fax | +44 (0)870 1222 699 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Antwort: PHP and MySQL
I hd this same problem. Ensure that /var, /var/lib, and /var/lib/mysql have permissions set to: drwxr-xr-x This cured the problem for me. rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 6:19 AM To: Ben Kennish Cc: [EMAIL PROTECTED] Subject: Antwort: PHP and MySQL On 01.03.2001 11:55:40 Ben Kennish wrote: "Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/index.php on line 5" Are you sure that your MySQL installation creates the socket right there? If I'm not mistaken, it may be created in /tmp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problen in mysql 'read only'
Did you change the permissions of the files after starting the sever, or before? Did you read the GRANT section of the manual. Does your user have the UPDATE privilege? Raman Aggarwal wrote: Dear Sir I am a regular user of MySql. I will be obliged if you help me. 1. The path of the data directory is /var/lib/mysql 2. The database name is 'directory' 3. The permissions of directory are drwxrwxrwx2 root root 4096 Mar 1 16:24 directory 4. All the files in the directory are having the permissions -rw-rw-rw-2 root root Now when I want to insert the data error message appears that the table is read only. error 1036. I tried all combination of permissions but no result. Mysql version is 3.22.25 Raman _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Antwort: Error 1052:Query problem
On 01.03.2001 13:16:47 soon chee keong wrote: Table_A: ID APPL B BI A BII * * * * C BII * * D BI Table_B: Cnty ID USC Aus A Aus B USD * signifies no data why does the following produce an error: 1052?? SELECT DISTINCT APPL FROM Table_A, Table_B WHERE Table_A.ID=Table_B.ID AND Cnty="US" AND ID="*"; Which ID? ID from Table_A, or ID from Table_B? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
C API problem
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include stdio.h
#include mysql.h
#define def_host_name NULL
#define def_user_name NULL
#define def_password NULL
#define def_db_name NULL
MYSQL *conn;
int main(int argc,char *argv[])
{
conn=mysql_init(NULL);
mysql_real_connect(
conn,
def_host_name,
def_user_name,
def_password,
def_db_name,
0, /*port defaut*/
NULL, /*socket default*/
0);/*flag*/
mysql_close(conn);
exit(0);
}
I compile as follows:
gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \
-L/home/MySQL/MySQL/lib \
-lmysqlclient
then I get :
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x14):undefined reference to 'open64'
/home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
mf_format.o(.text+0x201):undefined reference to '__lxstat64'
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x21):undefined reference to 'fopen64'
nothing left to do with the situation, I beg your help. anyway I'm a
newcomer. thank you very much.
please send message to [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: beta
marsha writes:
Hi guys,
I am part of a team developing an interface from Microsoft Access on a
Windows environment to mySQL on a Cobalt RAQ server (LINUX).
When you say the software mySQLgui is in "beta testing", what level is
that? Is alpha a step higher than beta, as in the best and ready for
distribution. Or is delta a step higher than beta? In other words, which
direction does the chain of progression go and how many levels are there?
Thanks,
Marsha Hardacre
Database Programmer
Anne Holmes and Associates
5117 Jersey Ridge Road
Davenport IA 52807
Hi!
First of all mysqlgui is not beta any more. I will have to fix that.
Second, it goes like this:
CVS - alpha - beta - gamma - stable
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BDB tables crashing mysql 3.23.33
[EMAIL PROTECTED] writes:
Hi folks, I'm having a hard time using bdb tables. Here are the
details...
I've create a few BDB tables, which are causing me great amounts
of grief. The tables worked fine for a while, then suddenly
started crashing mysqld. I decided to drop the offending
database, and re-create it. No problem so far. Right after
I run the offending queries (see below), mysqld dies. Any subsequent
connection attempt to mysqld hangs, and the server is basically
dead (requiring a killall -9 mysqld). There is a file called
log.01 that appeared, as well as an error message (see below).
I can replicate this error quite easily, as it happens each time the
query
is run.
CREATE TABLE tblCharge (
ChargeID int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
ServiceID int(10) unsigned DEFAULT '0' NOT NULL,
ChargeDate date DEFAULT '-00-00' NOT NULL,
ChargeAmount decimal(20,2) DEFAULT '0.00' NOT NULL,
FedTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
ProvTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
ChargeStatus enum('New','Auth','Unauth','Sale','Denied','Refund')
DEFAULT 'New' NOT NULL,
ChargeAuthorizationMessage text,
ChargeComment text,
ChargeTimeStamp varchar(20),
PRIMARY KEY (ChargeID),
KEY ServiceID (ServiceID),
KEY ChargeDate (ChargeDate)
) type=BDB;
Query #1:
BEGIN;
INSERT INTO tblCharge
VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
COMMIT;
Query #2
BEGIN;
UPDATE tblCharge SET ChargeAuthorizationMessage = 'blablabla' WHERE
ChargeID = 1;
COMMIT;
Query #3
BEGIN;
INSERT INTO tblCharge
VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
CRASH HERE
ERROR 2013: Lost connection to MySQL server during query
mysql COMMIT;
Number of processes running now: 0
010228 13:59:40 mysqld restarted
ERROR 2006: MySQL server has gone away
No connection. Trying to reconnect...
Connection id:4
Current database: Funio
./mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var \
--user=root --pid-file=/usr/local/mysql/var/suave.pid --skip-locking
./mysqld: ready for connections
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that
may
help in finding out why mysqld died
Attemping backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong
I've replicated this problem on 3 different machines, and on 3.23.33 and
3.23.32.
I had been using BDB tables for a couple weeks now in testing, without a
hitch
until the above query starting being used. I also tried to recompile
mysql
statically, with the same results.
I really hope there is an easy patch/fix to this problem, as my
development
team has just finished writing 15000 lines of code and use DBD tables
extensively throughout the application. My company has purchased a
basic license for mysql, and quite frankly this error really concerns
me.
If it was this easy to crash BDB tables and there is no quick fix, I
will
have to stop using mysql altogether throughout my company. We rely
heavily
on mysql right now, and this kind of error makes me wonder if this is
not a
mistake. Until a solution can be found, I will instruct my team to
start porting the application to postgres, I simply can't take the
chance of using these versions of mysql in production.
Description:
BDB tables crash very easily
How-To-Repeat:
See above
Fix:
no idea
Originator: Mark Steele
Organization:
Mark Steele
Vice president research and development
Inet Technologies Inc.
[EMAIL PROTECTED]
MySQL support: [email support]
Synopsis: BDB tables crash
Severity: critical
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-3.23.32 (Source distribution)
Server: /usr/local/mysql/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for
pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.32
Protocol version10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 1 min 12 sec
Threads: 1 Questions: 61 Slow queries: 0 Opens: 48 Flush tables: 1
Open tables: 42 Queries per second avg: 0.847
Environment:
System: Linux suave 2.4.1 #11 Sat Feb 17 00:30:04 EST 2001 i686 unknown
Architecture: i686
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake
C API problem
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include stdio.h
#include mysql.h
#define def_host_name NULL
#define def_user_name NULL
#define def_password NULL
#define def_db_name NULL
MYSQL *conn;
int main(int argc,char *argv[])
{
conn=mysql_init(NULL);
mysql_real_connect(
conn,
def_host_name,
def_user_name,
def_password,
def_db_name,
0, /*port defaut*/
NULL, /*socket default*/
0);/*flag*/
mysql_close(conn);
exit(0);
}
I compile as follows:
gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \
-L/home/MySQL/MySQL/lib \
-lmysqlclient
then I get :
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x14):undefined reference to 'open64'
/home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
mf_format.o(.text+0x201):undefined reference to '__lxstat64'
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x21):undefined reference to 'fopen64'
nothing left to do with the situation, I beg your help. anyway I'm a
newcomer. thank you very much.
please send message to [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading MySQL causes Error - ASP
Gerald,
I've written to them asking your question.
I'd like to point out that I just got an empty record set when it is running
under ASP.
The query runs successfully through phpMyAdmin 2.0.5. I realized that the
query
(select count(*) as quantity from person;) works well in ASP so that I think
it should be something
related to GROUP BY clause.
Celso.
- Original Message -
From: Gerald L. Clark [EMAIL PROTECTED]
To: Celso Pires [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 11:11
Subject: Re: Upgrading MySQL causes Error - ASP
They replaced your MySQL with a new version.
Did they re-compile Apache and PHP to use the new MySQL libraries,
or is it trying to use the now missing ones?
Celso Pires wrote:
Hi there,
I've got a site hosted at an ISP and everything was going well when they
decided to upgrade the software. Now my site is running under Win2K,
IIS5,
MySQL 3.23.33 and MyODBC 2.50.36.
In order to get easier to explain what is going wrong, I've built the
following test:
CREATE TABLE person (
person_ID INTEGER NULL,
name CHAR(50) NULL,
gender CHAR(1) NULL
);
INSERT INTO person (person_id, name, gender) values
(1,'Bob','m'),(2,'Mary','f'),(3,'Antony','m'),(4,'Rose','f'),(5,'Kuerten','m
');
mysql select count(*) as quantity, gender
- from person
- group by gender;
+--++
| quantity | gender |
+--++
|2 | f |
|3 | m |
+--++
2 rows in set (0.01 sec)
*** As you can realize, so far so good. Now things get worse ***
html
head
titleGROUP BY TEST/title
/head
body bgcolor="#FF"
%
Response.Write "Beginbr"
strConn =
"DRIVER=MySQL;SERVER=myserver;DATABASE=mydatabase;UID=myuser;PWD=mypass;"
Set conn = Server.Createobject("ADODB.Connection")
conn.Open(strConn)
strSQL = "select count(*) as quantity, gender "
strSQL = strSQL "from person "
strSQL = strSQL "group by gender;"
Response.Write strSQL "BR"
Set Rs = conn.Execute(strSQL)
While Not Rs.EOF
Response.Write "Quantity: " RS("quantity") " - Gender: "
RS("gender") "BR"
Rs.MoveNext
Wend
Rs.Close
conn.close
response.write "The Endbr"
%
/body
/html
*** The page above should print:
Begin
select count(*) as quantity, gender from person group by gender;
Quantity: 2 - Gender: f
Quantity: 3 - Gender: m
The End
*** Instead, I'm getting this:
Begin
select count(*) as quantity, gender from person group by gender;
The End
*** It means that the record set is empty.
Thank you very much for any help.
Regards,
Celso.
_
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: Re: Antwort: AW: version 3.23.29a-1
Yeah, except when the RPMS were created with an error. MySQL should not require Perl to be installed in order for it to work, so in this case, yes, use no dependancy flag. Have a look at the archives around november, december last year. Heaps of info in regards to this. - Original Message - From: [EMAIL PROTECTED] To: "Rolf Hopkins" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, March 01, 2001 16:42 Subject: Antwort: Re: Antwort: AW: version 3.23.29a-1 On 01.03.2001 02:37:17 Rolf Hopkins wrote: Or use the no dependency flag or upgrade. That's as good as suggesting to not use rpm at all. The dependencies are in there with a reason, you know. Never upgrade/install with --force/--nodeps. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: running mysql not as a server
Broadly speaking, I would agree with Cal becasue MySQL is, by its very nature, a server application.. However, you can easily emulate it being an application by adding net start(s) and net stop(s) to the beginning and end of your application - you may have timing issues, however, with the start and stops and your application - you will need to ensure that everything is in place before you start your app main code and that everything closes off properly before your app releases all resources. I think the first will just be a timing or return function problem and the second a flush buffer and ensuring all updates have taken place. O'course I aint heard of anyone trying this yet! Andy The rest of life is left as an exercise for the reader :-) - Original Message - From: "Cal Evans" [EMAIL PROTECTED] To: "Michael Gilman" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, March 01, 2001 7:38 AM Subject: RE: running mysql not as a server Michael, IMHO, if you are looking for a desktop database, something built around a .dbf file would be a more suitable choice. (My personal fav is FoxPro even though it's a M$ product) MySQL, while it probably can be made to do this, is not designed to do this. Cal http://www.calevans.com -Original Message- From: Michael Gilman [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 6:08 AM To: [EMAIL PROTECTED] Subject: running mysql not as a server How can I run mySQL in a Windows app in a non-server mode. That is how can I get the app to start mySQL when the app starts and shut it down when the app is exited. Are there any issue that might cause a problem? Thanks for your help. Best Regards, Mike Michael Gilman, PhD Data Mining Technologies Inc. (516) 470-9011 ext 100 [EMAIL PROTECTED] The information transmitted in this email is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this email in error, please contact the sender and permanently delete the email from your computer. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: Re: Why Heap Tables doesn´t support auto increment ?colums
On Thu, Mar 01, 2001 at 02:37:30PM +0100, Entryon Corp., Chief Technical Officer - P. Hasenfratz wrote: Why not use a timestamp column to guarentee the order in which rows get inserted into the table? You can then order on the timestamp column. Hmm, timestamp, ie. seconds as finest resolution, might be to broad depending on the hits his site will get - imagine that 2+ users access the site in the same second, then you won't be able to distinguish them, will you? What's if you combine a timestamp with the client's IP address? for example: 5/6/2001 IP : 212.33.69.2 = clientstamp will be 05.06.2001-212.033.069.002 Besides the fakt tha this ID not unique. There ist the Problem that the ID you proposed ist an String ID and strings als Index are the Major Preformance killer on Databases. Wie kann calculate an intager from the two information. totaly loosing the Uniqueness. The question still is. Why are auto_increment columns are not supported fuer Heap Tables. SoLong Estartu -- Gerhard Schmidt mailto:[EMAIL PROTECTED] Entwicklung adMaster network Tel.: +49 89 38356-334 Kaiserstrae 16 D-80801 Mnchen http://www.admasternetwork.net PGP signature
Re: [auto_increment]
There is entirely unexpected behavior here.
If you have gone to the trouble of defining a column in your database as
an auto_increment field
it should not simply stop working because you enter a negative number.
What we saw yesterday was the addition of a row with a negative number in
the auto_increment field, caused auto_increment to stop for any
FUTURE insert.
In other words, inserting a negative number makes the column not an
auto_increment field any more.
Somehow, in my mind this breaks the basic concept of a database schema,
that once you define something
it shouldn't change out from under you.
Here, we are in effect having to add that restriction programmatically.
The sequence went like this:
create table megatest3
( foo int not null auto_increment primary key,
blah char)
insert megatest3 (blah) values("A")
[ now we have 1,A in the table ]
insert megatest3 (foo, blah) (-1, "B")
[ now we have 1,A in table, and -1, B in table ]
insert megatest3(blah) values("C")
[ now we have 1,A, -1,B,and MAXINT, "C" ]
insert megatest3(blah) values("D")
[ now we have an sql error for double key, presumably because it is
trying to put in MAXINT]
Now imagine these sql statements spread over the span of say a week.
You might not get so lucky
as to figure out what is going on as we were.
-Tom
Jason Landry wrote:
Well, except that the value of an auto-increment field CAN be set to a
specific value (perhaps negative) an INSERT or UPDATE statement.
If Autoincrement can only work with positive numbers, then any
key that is auto_increment should automatically be made unsigned.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error 1052:Query problem
Well, for starters, I would say you need Table_B.Cnty="US" AND Table_A.ID="*"; not Cnty="US" AND ID="*"; - Original Message - From: "soon chee keong" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 01, 2001 20:16 Subject: Error 1052:Query problem Table_A: ID APPL B BI A BII * * * * C BII * * D BI Table_B: Cnty ID USC Aus A Aus B USD * signifies no data why does the following produce an error: 1052?? SELECT DISTINCT APPL FROM Table_A, Table_B WHERE Table_A.ID=Table_B.ID AND Cnty="US" AND ID="*"; _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Q] DBI connect with MySQL
Hi,gurus,
I am a novice at MySQL. When I try to run a sample program in the book of
"MySQL mSQL" I get a error message from my apache server as follows,
*
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to
complete your request.
Please contact the server administrator, [EMAIL PROTECTED] and inform them of the
time the error occurred, and anything you might have done that may have caused the
error.
More information about this error may be available in the server error log.
*
The sample program is
#!/usr/bin/perl -w
use strict;
use CGI qw(:standard);
use CGI::Carp;
use DBI;
CGI::use_named_parameters(1);
my ($db);
my $output = new CGI;
$db = param('test') or die("Could not find database!");
my $dbh = DBI-connect("DBI:mysql:$db:$server",root,passward );
if (not $dbh) {
print header, start_html('title'="Information on $host = $db",
'BGCOLOR'='white');
print END_OF_HTML;
H1$host/h1
H2$db/h2
For the following reasons the connection failed.BR
$DBI::errstr
/body/html
END_OF_HTML
exit(0);
}
print header, start_html('title'="Information on $host = $db",
'BGCOLOR'='white');
print END_OF_HTML;
H1$host/h1
H2$db/h2
p
Tablesbr
UL
END_OF_HTML
my @tables = $dbh-func( '_ListTables' );
foreach (@tables) {
print "LI$_\n";
}
print END_OF_HTML;
/ul
/body/html
END_OF_HTML
exit(0);
Could someone tell me what is wrong? Thanks a lot.
Regards,
--Wen
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql dbi modules
HI, I sent this note a couple days ago and no one has commented. I am trying to implement DBI-1.14.tar.gz Data-ShowTable-3.3.tar.gz Msql-Mysql-modules-1.2215.tar.gz . The first two packages completed successfully byt the Mysql-modules failed druing the 'make test' step.I am using mysql version 3.23.32-log. Any help would be appreciated, TIA Subject: Mysql dbi modules I have almost installed all of the dbi/dbm modules but can't get thru the 'make test'. I get the error msg: 't/10dsnlist.DBI-connect(database=test) failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at t/10dsnlist.t line 45' MySql is ruuning but the database is located at 'local/mysql' and the mysql.sock socket is present. This is setup in /etc/my.cnf How can I change the test to reference the current setup? Thanks, Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Use Ukrainian lenguage.
I have never tried changing the default language myself but a suggestion only is that are your columns of the right type? - Original Message - From: "Vitaly Dugaev" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, March 01, 2001 19:32 Subject: Use Ukrainian lenguage. Dear support group of MySQL, When I use MySQL for Windows with languages like Ukrainian, Rassian I can't use case insensitive select, or operator like Upper. Can you help me? Becouse I understand that I mast recompile server, is'nt it? Please give me ansver!!! Sincerely, Anatolii. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AIX 4.2.1
Is there reasonably current version of mysql that I can install or compile under aix4.2.1. I have been unable to compile 3.23.33 because of size limitations. -- Mike Klein Manager, System Services Information Technology Loyola University New Orleans 6363 St. Charles Ave. New Orleans, LA 70118 504.865.3470 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: PHP and MySQL - Specifying location for mysql.sock
HOORAY! It's finally working. However, I'd prefer to have my mysql.sock socket file in /tmp/ Anyone know how to change the settings for MySQL (and also PHP4 and phpMyAdmin) so that it looks in /tmp/ instead? Cheers. Ben Rick Emery wrote: I hd this same problem. Ensure that /var, /var/lib, and /var/lib/mysql have permissions set to: drwxr-xr-x This cured the problem for me. rick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 6:19 AM To: Ben Kennish Cc: [EMAIL PROTECTED] Subject: Antwort: PHP and MySQL On 01.03.2001 11:55:40 Ben Kennish wrote: "Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/index.php on line 5" Are you sure that your MySQL installation creates the socket right there? If I'm not mistaken, it may be created in /tmp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Ben Kennish Software Developer Fubra Limited web | www.fubra.net email | [EMAIL PROTECTED] phone | +44 (0)870 1222 600 fax | +44 (0)870 1222 699 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Segmentation fault launching mysqld after compiling 3.23.33
Hi all. I've compiled mysql 3.23.33 with support for DB-Berkeley. After it when I try to launch mysqld it gave me a segmentation fault. Anybody has a similar problem? Note: I use Slackware 7.1 in a PC. Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BDB tables crashing mysql 3.23.33
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
Hi folks, I'm having a hard time using bdb tables. Here are the
details...
I've create a few BDB tables, which are causing me great amounts
of grief. The tables worked fine for a while, then suddenly
started crashing mysqld. I decided to drop the offending
database, and re-create it. No problem so far. Right after
I run the offending queries (see below), mysqld dies. Any subsequent
connection attempt to mysqld hangs, and the server is basically
dead (requiring a killall -9 mysqld). There is a file called
log.01 that appeared, as well as an error message (see below).
I can replicate this error quite easily, as it happens each time the
query
is run.
CREATE TABLE tblCharge (
ChargeID int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
ServiceID int(10) unsigned DEFAULT '0' NOT NULL,
ChargeDate date DEFAULT '-00-00' NOT NULL,
ChargeAmount decimal(20,2) DEFAULT '0.00' NOT NULL,
FedTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
ProvTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
ChargeStatus enum('New','Auth','Unauth','Sale','Denied','Refund')
DEFAULT 'New' NOT NULL,
ChargeAuthorizationMessage text,
ChargeComment text,
ChargeTimeStamp varchar(20),
PRIMARY KEY (ChargeID),
KEY ServiceID (ServiceID),
KEY ChargeDate (ChargeDate)
) type=BDB;
Query #1:
BEGIN;
INSERT INTO tblCharge
VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
COMMIT;
Query #2
BEGIN;
UPDATE tblCharge SET ChargeAuthorizationMessage = 'blablabla' WHERE
ChargeID = 1;
COMMIT;
Query #3
BEGIN;
INSERT INTO tblCharge
VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
CRASH HERE
ERROR 2013: Lost connection to MySQL server during query
mysql COMMIT;
Number of processes running now: 0
010228 13:59:40 mysqld restarted
Thanks for reporting the bug - I have been able to repeat it, and am now
trying to figure out what is happening. Unfortunately, Tim and Monty, who are
the ones working on BDB code are not going to be available for a couple of
days, and since I do not know that code as well, it would take me some time
to understand how things work ( which I need to do anyway, and now is a good
chance) before I can provide a fix.
Please note that our BDB tables have not yet received nearly as much of the
"baptism of fire" as MyISAM. We will however, fix all the reported bugs
promptly.
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
___/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyODBC
Ok, I am new in the IT world, and I just want to set up a mySql server. I installed mySql on the WinNt server (on the lan in my office) with mysqladmin running, and i installed myODBC on my win98 computer, with settings that would match the server. How can i test if this is working without making an application? do i need myODBC installed on teh server as well?? HELP!!! kate - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Why Heap Tables doesn´t support auto increment colums
Im currently working on system for Managing http Session and would like to use a heap table for storing the session information. Session information is only of temporary intrest. But still I need an unique ID for reference with some other Tabels storing dtaa for the session. All these tables are Heap tables. So there is no Probelem if the ID generated by the auto_increment column is not unique when the Database server is restarted. There's a couple problems with that to begin with. First, you're storing state in a HEAP table. If the mysql server gets reset, all the sessions are lost. It would be tough to think you want to write your system so your database server cannot ever be restarted, especially when writing the data to a MyISAM table would probably be at a trivial loss of speed. Also, if you used an auto_incrementing column, you would be handing out sessionIDs sequentially. It would be trivial for somebody to usurp somebody else's sessionID by simply subtracting or adding 1 to their own. -Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems with MySQLGUI 1.7 and ssh
Todd A. Jacobs writes:
I downloaded and compiled the latest version of MySQLGUI and am connecting
to MySQL 3.22.32 on OpenBSD. When I try to tunnel MySQLGUI through the
following ssh tunnel:
ssh -x -g -L 3306:localhost:3306 mysql
I get this error message from the MySQLGUI client:
Can't connect to local MySQL server through \
socket '/tmp/mysql.sock' (111)
What does this mean? At first glance, it looks like an X Windows error.
I don't have X running on the MySQL server; only on the remote. Could
this be the problem? That wouldn't really make sense; why would the client
require X services from the database host?
If it's something else, how can I fix it? Why can't I connect? I'm really
frustrated.
--
Todd A. Jacobs
CodeGnome Consulting, LTD
Hi!
This command enabled me to test mysqlgui over SSH tunnel without a
single problem :
#!/bin/sh
ssh1 -C [EMAIL PROTECTED] -L 110:work:110 -L 26:localhost:25 -L 6667:xxx.yyy.zzz:6667
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't find mysqladmin
Hello I have installed the latest rpm on an exiting RH6.2 Linux box. I actually upgraded mysql to the newest version and everything went fine and it verified after the installation was done. The problem that I have is that I cannot log into mysql now. I have tried to located mysqladmin anywhere on the server and it seems to be missing and I cannot log into MYSQL. However when I do a ps -ef I can see that safe_mysqld is running along with the three other processes. Any clues on how to log in would be appreciated (It has just been one of those days) _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BDB tables crashing mysql 3.23.33
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
Hi folks, I'm having a hard time using bdb tables. Here are the
details...
I've create a few BDB tables, which are causing me great amounts
of grief. The tables worked fine for a while, then suddenly
started crashing mysqld. I decided to drop the offending
database, and re-create it. No problem so far. Right after
I run the offending queries (see below), mysqld dies. Any subsequent
connection attempt to mysqld hangs, and the server is basically
dead (requiring a killall -9 mysqld). There is a file called
log.01 that appeared, as well as an error message (see below).
I can replicate this error quite easily, as it happens each time the
query
is run.
CREATE TABLE tblCharge (
ChargeID int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
ServiceID int(10) unsigned DEFAULT '0' NOT NULL,
ChargeDate date DEFAULT '-00-00' NOT NULL,
ChargeAmount decimal(20,2) DEFAULT '0.00' NOT NULL,
FedTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
ProvTaxes decimal(20,2) DEFAULT '0.00' NOT NULL,
ChargeStatus enum('New','Auth','Unauth','Sale','Denied','Refund')
DEFAULT 'New' NOT NULL,
ChargeAuthorizationMessage text,
ChargeComment text,
ChargeTimeStamp varchar(20),
PRIMARY KEY (ChargeID),
KEY ServiceID (ServiceID),
KEY ChargeDate (ChargeDate)
) type=BDB;
Query #1:
BEGIN;
INSERT INTO tblCharge
VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
COMMIT;
Query #2
BEGIN;
UPDATE tblCharge SET ChargeAuthorizationMessage = 'blablabla' WHERE
ChargeID = 1;
COMMIT;
Query #3
BEGIN;
INSERT INTO tblCharge
VALUES(NULL,1,CURRENT_DATE(),1,1,1,'New',NULL,NULL,UNIX_TIMESTAMP(NOW()));
CRASH HERE
ERROR 2013: Lost connection to MySQL server during query
mysql COMMIT;
Number of processes running now: 0
010228 13:59:40 mysqld restarted
Quick update on this bug - if you change ChargeAuthorizationMessage and
ChargeComment to varchar(255) the bug does not happen. In other words, the
offender is the text field.
--
MySQL Development Team
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA
___/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Win 2000 Not starting
Hi 1. I'm working in Windows 2000, intending to run MySQL to localhost on same laptop. 2. I've edited "my.cnf" to change to d: wherever it said c:, placed it 3 places, c:\, d:\ and d:\mysql\data\ as per Manual's Option Files. As I unzipped binary directly to d: 3. None of these have worked: d:\mysql\bin\mysqld --debug d:\mysql\bin\mysqld --standalone --debug d:\mysql\bin\mysqld --standalone d:\mysql\bin\mysqld --basedir d:\mysql d:\mysql\bin\mysqld --skip-grant-tables --debug d:\mysql\bin\mysqld --skip-grant-tables d:\mysql\bin\mysqld-nt --standalone --debug d:\mysql\bin\mysqld-nt --standalone I was shutting down via Task Manager but have repeated by shutting down the laptop aswell. All cases, everything just hangs, nothing happens. 4. As per Manual, this command: d:\mysql\bin\mysqld produced a mysql.err file which states "REady for connections" and it came back to the prompt d: I thought this might have started the server up, so I then tried d:mysql but it didn't recognise this. I tried d:\mysql\bin\mysqlshow but it came back with error message, "Can't connect to MySQL server on 'localhost'. Check that it's running. 5. I particularly didn't want to use the mysqld-nt install option because I don't want the bother of installing as a service with users/passwords, this is just development work, Windows defaults of being available for all users is fine. Also the Manual states the option file my.cnf is supported by program "mysqld", implicitly it therefore does not support programs "mysql-nt", "mysql-opt". As I've changed default location, I need the option file I believe. Anyone any ideas? Cheers, Lucy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The links in the manual -'MySQL_Full.htm' don't work
They didn't work 'onsite'/live, or when downloaded. They *used* to work for both. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [Q] DBI connect with MySQL
You will get errors like these if your script does not print out a header
before spitting out other information. It is usually best to print the
header in the very beginning of the script so you do not have to worry about
it. You dont have to wait until you are about to print out some html.
$output-header();
Also, if your script has parse errors or something similar you will get that
error.
Hope this helps.
ryan
Hi,gurus,
I am a novice at MySQL. When I try to run a sample program in the book of
"MySQL mSQL" I get a error message from my apache server as follows,
*
Internal Server Error
The server encountered an internal error or misconfiguration and was
unable to complete your request.
Please contact the server administrator, [EMAIL PROTECTED] and inform
them of the time the error occurred, and anything you might have done that
may have caused the error.
More information about this error may be available in the server error
log.
*
The sample program is
#!/usr/bin/perl -w
use strict;
use CGI qw(:standard);
use CGI::Carp;
use DBI;
CGI::use_named_parameters(1);
my ($db);
my $output = new CGI;
$db = param('test') or die("Could not find database!");
my $dbh = DBI-connect("DBI:mysql:$db:$server",root,passward );
if (not $dbh) {
print header, start_html('title'="Information on $host = $db",
'BGCOLOR'='white');
print END_OF_HTML;
H1$host/h1
H2$db/h2
For the following reasons the connection failed.BR
$DBI::errstr
/body/html
END_OF_HTML
exit(0);
}
print header, start_html('title'="Information on $host = $db",
'BGCOLOR'='white');
print END_OF_HTML;
H1$host/h1
H2$db/h2
p
Tablesbr
UL
END_OF_HTML
my @tables = $dbh-func( '_ListTables' );
foreach (@tables) {
print "LI$_\n";
}
print END_OF_HTML;
/ul
/body/html
END_OF_HTML
exit(0);
Could someone tell me what is wrong? Thanks a lot.
Regards,
--Wen
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERT DELAYED still keeps CRUSHING (trying everything)
Artem Koutchine writes:
Hello again!
In the prev episode i said that when i do INSERT DELAYED
mysql just catches sig 11, crashes and restarts. No record
inserted whatsoever. Nothing is written into the update log.
Here is a sample (even though it says 1 row affected, it is
actually not affected. nothing is inserted):
mysql insert delayed into aaa (aid, aname) values (111,'hello');
Query OK, 1 row affected (0.00 sec)
mysql 010301 20:17:22 mysqld restarted
In the error log:
010301 20:16:27 mysqld started
/usr/local/mysql/bin/mysqld: ready for connections
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to use a
stack trace and/or the core file to produce a readable backtrace that
may
help in finding out why mysqld died
010301 20:17:22 mysqld restarted
/usr/local/mysql/bin/mysqld: ready for connections
I use FreeBSD 4.2-STABLE (cvsupped and rebuild last sunday),
MySQL 3.23.33. Compiled using the options which are used in the
FreeBSD port of mysql to make it stable on high loads. But it is build
from the original tar ball taken from www.mysql.com. That does not
matter, since patches for mysql on FreeBSD
are minimal and not really needed.
Sinisa recommended to try precompiled binary for FreeBSD. I did.
Same story - keeps crashing on INSERT DELAYED. (not to mention
that i hate to use precompiled stuff, because it is never configured
as i want it to be).
What's going on? I really need INSERT DELAYED since i need
to insert millions of records in a short time for development and
testing purposes.
Regards,
Artem
Hi!
Can you make a test case that would always crash MySQL ??
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)
On 28.02.2001 13:13:05 Bob Hall wrote: Og nu da jeg s nrmere p din email adresse, er du selvflgelig velkommen til at sprge p dansk... ;-) Det er alltid hyggelig se p andre sprg p internettet, men hvis du skriver p dansk, s skal de aller fleste taper sjansen lre om ADO og MySQL. Bitte was? Ich wrde ja gerne helfen, nur leider verstehe ich nicht, was ihr gerade gesagt habt. Es wre nett, wenn ihr entweder in Deutsch, oder vlt. doch in Englisch posten wrdet! Danke sehr! Carsten wrote to a compatriot that they could write in that form of Norwegian spoken south of Skagerrok. I responded in a Danish dialect sung near the Oslo fjord that if they switched from English, few people would be able to learn from their discussion. And Alexander used the linguistic relative of Anglo-Saxon spoken in Berlin to ask us to write in English. This resulted in an extended thread, with several people asking us to post in that derivative of Low German spoken in London and Washington DC by the suburbanite tribes who never roll their 'r's. I hope this clarifies matters. People who are looking for help will be most likely to find it on the list or in the archives if the information is in English. Therefore English postings create the greatest good for the greatest number of people. People who have trouble with English are welcome to post in any language they wish, and hope for an answer. In general, it's best to post in English if you can. Rural dialects spoken in the mountainous regions of Albania should be avoided, unless you are posting many times to ask for help in recovering a hopelessly crashed database without backups, in which case they are preferred. Next up: how the prehistoric wanderings of the SQL people resulted in the dialects in use today. Bob Hall Know thyself? Absurd direction! Bubbles bear no introspection. -Khushhal Khan Khatak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERT DELAYED still keeps CRUSHING (trying everything)
Sinisa, i thought i pointed out that mysql ALWAYS
crashes on any single INSERT DELAY anytime,
any database, under any conditions and during any
weather. NO single INSERT DELAY can be executed
successfully.
Regards,
Artem
- Original Message -
From: "Sinisa Milivojevic" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, March 01, 2001 8:58 PM
Subject: Re: INSERT DELAYED still keeps CRUSHING (trying everything)
Artem Koutchine writes:
Hello again!
In the prev episode i said that when i do INSERT DELAYED
mysql just catches sig 11, crashes and restarts. No record
inserted whatsoever. Nothing is written into the update log.
Here is a sample (even though it says 1 row affected, it is
actually not affected. nothing is inserted):
mysql insert delayed into aaa (aid, aname) values (111,'hello');
Query OK, 1 row affected (0.00 sec)
mysql 010301 20:17:22 mysqld restarted
In the error log:
010301 20:16:27 mysqld started
/usr/local/mysql/bin/mysqld: ready for connections
mysqld got signal 11;
The manual section 'Debugging a MySQL server' tells you how to
use a
stack trace and/or the core file to produce a readable backtrace
that
may
help in finding out why mysqld died
010301 20:17:22 mysqld restarted
/usr/local/mysql/bin/mysqld: ready for connections
I use FreeBSD 4.2-STABLE (cvsupped and rebuild last sunday),
MySQL 3.23.33. Compiled using the options which are used in the
FreeBSD port of mysql to make it stable on high loads. But it is
build
from the original tar ball taken from www.mysql.com. That does
not
matter, since patches for mysql on FreeBSD
are minimal and not really needed.
Sinisa recommended to try precompiled binary for FreeBSD. I did.
Same story - keeps crashing on INSERT DELAYED. (not to mention
that i hate to use precompiled stuff, because it is never
configured
as i want it to be).
What's going on? I really need INSERT DELAYED since i need
to insert millions of records in a short time for development and
testing purposes.
Regards,
Artem
Hi!
Can you make a test case that would always crash MySQL ??
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: C API problem
Laurent Oget writes:
I am not sure this will solve your probleme but you need to add -lnsl and -lsocket
to the compile command line.
On Thu, Mar 01, 2001 at 11:03:11PM +0800, john1 wrote:
dear Sir :
MySQL 3.22 on my linux 486 PC seems work so good. when I compile
a simple C API programe which catched from the MySQL tutorial, it
chokes at the end of compile process . the programe is as follows:
#include stdio.h
#include mysql.h
#define def_host_name NULL
#define def_user_name NULL
#define def_password NULL
#define def_db_name NULL
MYSQL *conn;
int main(int argc,char *argv[])
{
conn=mysql_init(NULL);
mysql_real_connect(
conn,
def_host_name,
def_user_name,
def_password,
def_db_name,
0,/*port defaut*/
NULL, /*socket default*/
0); /*flag*/
mysql_close(conn);
exit(0);
}
I compile as follows:
gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \
-L/home/MySQL/MySQL/lib \
-lmysqlclient
then I get :
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x14):undefined reference to 'open64'
/home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
mf_format.o(.text+0x201):undefined reference to '__lxstat64'
/home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
my_open.o(.text+0x21):undefined reference to 'fopen64'
nothing left to do with the situation, I beg your help. anyway I'm a
newcomer. thank you very much.
please send message to [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Laurent Oget, Ph.D. [EMAIL PROTECTED]
Senior Engineer Zvolve Systems Inc http://zvolve.com
Chercheur AssociLiafa http://liafa.jussieu.fr
No, the above means he has to update his glibc.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how do you format this query?
If all you need is a count of the items why not issue Select count(distinct threads) as ctr from messages Jack ;-)= - Original Message - From: "Ed Lazor" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 11:53 PM Subject: how do you format this query? Hi =) Could you help me with creating a proper query? I have a table that stores messages with a field for the message id, thread, and parent. The goal is to create a query that gives me the total threads. I read in a book and found the DISTINCT key allows me to run a query like this: select DISTINCT threads from messages; Then all I have to do is count the total number of rows returned. I'm concerned this query will create unnecessary overhead as the number of messages in the archive exceeds tens of thousands. Is there a query that will give me the information I'm looking for without creating the overhead? -Ed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [Q] DBI connect with MySQL
iii You will get errors like these if your script does not print out a header iii before spitting out other information. It is usually best to print the iii header in the very beginning of the script so you do not have to worry about iii it. You dont have to wait until you are about to print out some html. iii iii $output-header(); I add "$output-header();" just behind "my $output = new CGI;", but the result does not change. Maybe still there are other factors as you said. Thanks so much for your information. Regards, --Wen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [Q] DBI connect with MySQL(SOLVED)
Okay, I get it. The problem comes from the statement below,
wen $db = param('test') or die("Could not find database!");
After I revised it to "my $db = "test" or die("Could not find database!");"
I get expected result.
Thanks for your consideration.
Regards,
--Wen
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Index Question
My question is about indexes...basically, I'm wondering how many indexes is too much, and what the drawbacks are of having more indexes on a table? I'm guessing INSERT and UPDATE queries probably take longer? My table has the following fields: member_id, first_name, last_name, username, password, email, street1, street2, city, state, zip, country_id, signup_date, signup_ip, ref_id, sex, age, income I know for sure I will want to index the username and email fields. However, should I index the entire field, or would 5 or 6 characters be enough to index? I will also be selecting BY country_id, signup_date, and ref_id as well, is it okay to index all of them? I will also be using the signup_ip field to delete duplicate accounts, should I therefore index that field so the "distinct" operator works better? Is it okay to have 6 indexes on a table like this? The table may have upwards of a million entries. TIA! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [Q] DBI connect with MySQL
Your Apache must be configured to support perl cgi scripts.
Is it?
What is in the Apache error log?
[EMAIL PROTECTED] wrote:
Hi,gurus,
I am a novice at MySQL. When I try to run a sample program in the book of
"MySQL mSQL" I get a error message from my apache server as follows,
*
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to
complete your request.
Please contact the server administrator, [EMAIL PROTECTED] and inform them of
the time the error occurred, and anything you might have done that may have caused
the error.
More information about this error may be available in the server error log.
*
The sample program is
#!/usr/bin/perl -w
use strict;
use CGI qw(:standard);
use CGI::Carp;
use DBI;
CGI::use_named_parameters(1);
my ($db);
my $output = new CGI;
$db = param('test') or die("Could not find database!");
my $dbh = DBI-connect("DBI:mysql:$db:$server",root,passward );
if (not $dbh) {
print header, start_html('title'="Information on $host = $db",
'BGCOLOR'='white');
print END_OF_HTML;
H1$host/h1
H2$db/h2
For the following reasons the connection failed.BR
$DBI::errstr
/body/html
END_OF_HTML
exit(0);
}
print header, start_html('title'="Information on $host = $db",
'BGCOLOR'='white');
print END_OF_HTML;
H1$host/h1
H2$db/h2
p
Tablesbr
UL
END_OF_HTML
my @tables = $dbh-func( '_ListTables' );
foreach (@tables) {
print "LI$_\n";
}
print END_OF_HTML;
/ul
/body/html
END_OF_HTML
exit(0);
Could someone tell me what is wrong? Thanks a lot.
Regards,
--Wen
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't find mysqladmin
Did you also install the mysql client rpm? "K.K" wrote: Hello I have installed the latest rpm on an exiting RH6.2 Linux box. I actually upgraded mysql to the newest version and everything went fine and it verified after the installation was done. The problem that I have is that I cannot log into mysql now. I have tried to located mysqladmin anywhere on the server and it seems to be missing and I cannot log into MYSQL. However when I do a ps -ef I can see that safe_mysqld is running along with the three other processes. Any clues on how to log in would be appreciated (It has just been one of those days) _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Win 2000 Not starting
I'd love to here an answer to this one too. Exact same scenario.. exact same problem. --- "Lucy" [EMAIL PROTECTED] wrote: Hi 1. I'm working in Windows 2000, intending to run MySQL to localhost on same laptop. 2. I've edited "my.cnf" to change to d: wherever it said c:, placed it 3 places, c:\, d:\ and d:\mysql\data\ as per Manual's Option Files. As I unzipped binary directly to d: 3. None of these have worked: d:\mysql\bin\mysqld --debug d:\mysql\bin\mysqld --standalone --debug d:\mysql\bin\mysqld --standalone d:\mysql\bin\mysqld --basedir d:\mysql d:\mysql\bin\mysqld --skip-grant-tables --debug d:\mysql\bin\mysqld --skip-grant-tables d:\mysql\bin\mysqld-nt --standalone --debug d:\mysql\bin\mysqld-nt --standalone I was shutting down via Task Manager but have repeated by shutting down the laptop aswell. All cases, everything just hangs, nothing happens. 4. As per Manual, this command: d:\mysql\bin\mysqld produced a mysql.err file which states "REady for connections" and it came back to the prompt d: I thought this might have started the server up, so I then tried d:mysql but it didn't recognise this. I tried d:\mysql\bin\mysqlshow but it came back with error message, "Can't connect to MySQL server on 'localhost'. Check that it's running. 5. I particularly didn't want to use the mysqld-nt install option because I don't want the bother of installing as a service with users/passwords, this is just development work, Windows defaults of being available for all users is fine. Also the Manual states the option file my.cnf is supported by program "mysqld", implicitly it therefore does not support programs "mysql-nt", "mysql-opt". As I've changed default location, I need the option file I believe. Anyone any ideas? Cheers, Lucy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php == %-- 8-P ---% % "Yeah, I have a life.. sure umm.. % %somewhere.. where did I leave that% %thing??" % % % % Robert Wahl [EMAIL PROTECTED] % % n00b for life % %--% _ Visit Stomped.com for your daily dose of news for gamers - And get free e-mail too! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problen in mysql 'read only'
Did you change the permissions of the files after starting the sever, or before? Did you read the GRANT section of the manual. Does your user have the UPDATE privilege? Raman Aggarwal wrote: Dear Sir I am a regular user of MySql. I will be obliged if you help me. 1. The path of the data directory is /var/lib/mysql 2. The database name is 'directory' 3. The permissions of directory are drwxrwxrwx2 root root 4096 Mar 1 16:24 directory 4. All the files in the directory are having the permissions -rw-rw-rw-2 root root Now when I want to insert the data error message appears that the table is read only. error 1036. I tried all combination of permissions but no result. Mysql version is 3.22.25 Raman IMHO I don't think Mysql should be restarted after changing the permissions of the files at the OS level. Does MySQL cache the permissions too[?] Anyway, perror gave me: $ perror 1036 Error code 1036: Unknown error 1036 Are you sure you are giving the error code correct here? regards, thalis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
weird date behavior
I have a field in my table that stores the date a member has signed up...i run a query using distinct to show me how many members signup each day. Yesterday, our server crashed, and today i am seeing weird behavior with mysql: SELECT count(*) FROM members WHERE signup_date = now(); 122 SELECT count(*) FROM members; 108984 INSERT INTO members (blah blah) VALUES (blah blah); SELECT count(*) FROM members WHERE signup_date = now(); 122 SELECT count(*) FROM members; 108985 The total count is incremented, but not for today's date. Anyone have any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Alter Table Process
Hi, Would ALTER TABLE mytable ADD INDEX (somecol, othercol), ADD INDEX (othercol); do this in one sweep of the table, creating one temporary copy, or go through the table twice, one for each index? Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC for Windows ME
I have used it on a Win98 systems to access a MySQL DB on a Linux server. I found it highly unreliable. I would get a whole record entered before, as often as not, it would get kicked back with an error message, saying it could not save the (new) record, because someone else was accessing that record it at the time (no-one else was even so-much-as accessing webpages). Did I want to save the record to the clipboard? That was no help, as once we had an error on a record, It could not be re-entered until I accessed the DB by telnet and deleted the problem record. When we upgraded from Redhat 6.1 to 7, we were able to get PHP working, allowing us to use PhpMyAdmin. So far, that solution has been problem-free. On 28 Feb 2001, at 22:57, genge1 wrote: Has anyone installed MyODBC under Windows ME? Did you use the Win95 or NT version? I don't have the OS, still on Win95 and 98, but I have a client who wants to install the driver. Thanks in advance. Greg Engel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php John Jensen 520 Goshawk Court Bakersfield, CA 93309 661-833-2858 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: weird date behavior
When you specify now it is giving a date and a time. So if you do your query it may be checking the date and time in the signup_date field and if it doesn't find a time it just matches the date. What I would do if you want results for the day and not the exact time is to change the query so that it only tries to match the day/month/year w/out the timestamp. I noticed some similar things in Microsoft SQL but haven't worked w/ MySQL enough to know that this is the case. So this is all theory. Aaron Weiker -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:39 PM To: [EMAIL PROTECTED] Subject: weird date behavior I have a field in my table that stores the date a member has signed up...i run a query using distinct to show me how many members signup each day. Yesterday, our server crashed, and today i am seeing weird behavior with mysql: SELECT count(*) FROM members WHERE signup_date = now(); 122 SELECT count(*) FROM members; 108984 INSERT INTO members (blah blah) VALUES (blah blah); SELECT count(*) FROM members WHERE signup_date = now(); 122 SELECT count(*) FROM members; 108985 The total count is incremented, but not for today's date. Anyone have any ideas? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: PHP and MySQL
I had the same problem. Ensure the permissions for /var, /var/lib, and
/var/lib/mysql are set to: drwxr-xr-x
-Original Message-
From: Ben Kennish [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 01, 2001 4:56 AM
To: [EMAIL PROTECTED]
Subject: PHP and MySQL
Who would've thought it would take 3 days to install MySQL, PHP and get
them talking???!!
I've installed PHP 4.0.4pl1 using an RPM from www.redhat.com
I've also installed MySQL (latest ver) server and client versions from
www.mysql.com using RPMs.
Now MySQL seems to be up and working (using 'mysql' and 'mysqladmin'
gives me no trouble) and PHP seems to work fine ?php phpinfo(); ?.
I've installed the PHP-MySQL module from redhat.com (a single file -
mysql.so) and uncommented the "extension=mysql.so" line in /etc/php.ini
But when I type ...
mysql_connect('localhost', 'root', 'b');
into a PHP file, (I set b as my root SQL pwd) I get the following
error...
"Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/var/www/html/index.php on line 5"
There seems to be nothing in the MySQL error log.
Please help! Thanks,
--
Ben Kennish
Software Developer
Fubra Limited
web | www.fubra.net
email | [EMAIL PROTECTED]
phone | +44 (0)870 1222 600
fax | +44 (0)870 1222 699
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 1030: Got error -1 from table handler
Getting the above error message on one of our servers using mySQL. Went to go and set up WebCalender on it and tracked an issue down to mySQL. If I execute the query of: mysql SELECT * FROM webcal_entry, webcal_entry_user WHERE webcal_entry.cal_id = webcal_entry_user.cal_id AND webcal_entry.cal_date = 20010201 AND webcal_entry.cal_date = 20010231; It works fine and I get results back. However, if I add a simple ORDER BY, as in: mysql SELECT * FROM webcal_entry, webcal_entry_user WHERE webcal_entry.cal_id = webcal_entry_user.cal_id AND webcal_entry.cal_date = 20010201 AND webcal_entry.cal_date = 20010231 ORDER BY webcal_entry.cal_time; Then I get "ERROR 1030: Got error -1 from table handler" returned back to me. I've shut down mysql (made sure no active processes left) and run isamchk -r on the ISM files. This was the output: # isamchk -r *.ISM - recovering ISAM-table 'webcal_entry.ISM' Data records: 4 - Fixing index 1 - - recovering ISAM-table 'webcal_entry_repeats.ISM' Data records: 0 - Fixing index 1 - - recovering ISAM-table 'webcal_entry_user.ISM' Data records: 4 - Fixing index 1 - - recovering ISAM-table 'webcal_user.ISM' Data records: 2 - Fixing index 1 - - recovering ISAM-table 'webcal_user_layers.ISM' Data records: 0 - Fixing index 1 - - recovering ISAM-table 'webcal_user_pref.ISM' Data records: 12 - Fixing index 1 # This did nothing to affect the problem. Some helpful info about the system: # mysql -V mysql Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686) # rpm -qa | grep -i mysql MySQL-3.22.32-1 mysqlgui-static-1.7.1-1 MySQL-client-3.22.32-1 MySQL-devel-3.22.32-1 MySQL-shared-3.22.32-1 # uname -a Linux host 2.2.14-5.0.14smp #2 Fri Jun 30 16:25:11 EDT 2000 i686 unknown # Any help appreciated. -- Nathan Clemons [EMAIL PROTECTED] 978-635-5300 ext 123 Linux Systems Administrator IRC: etrnl ICQ: 2810688 AIM: StormeRidr O | S | D | N,50 Nagog Park,Acton,MA01720 http://www.osdn.com/ Open Source Development Network Nextel: 978-423-0165 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
more date problems
okay, this is a follow-up to my past email... since I KNOW more than 122 people have signed up today, I did the following query: SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit 200; there are at LEAST 200 people that have signed up today. however, when i do: SELECT count(*) FROM members WHERE signup_date = now(); I only get 122 results! And YES, I have tried "2001-03-01" instead of "now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever. Does anyone have any idea what could be going on? I run this query quite often, is it possible the result is somehow being saved in a buffer? Should I shutdown the mysql server and restart it? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem compiling mysql on FreeBSD
Hi All, Does anyone have any ideas on this one? Could I maybe try to install a newer version of whatever package installs libstdc++? Anyone know what package installs this file? Thanks for the help, Shawn - Original Message - From: Shawn Heeley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 11:56 PM Subject: Re: Problem compiling mysql on FreeBSD Hi Bill and All, Thanks for the suggestions. Here's what I've tried: Installed gmake and gcc. My pkg_info looks like the following (I've cut out the irrelevant ones): bash-2.03 The GNU Borne Again Shell gcc-2.95.3.test3GNU compiler suite gettext-0.10.35 GNU gettext package glib-1.2.7 Some useful routines of C programming gmake-3.79.1GNU version of 'make' utility gtk-1.2.7 General Toolkit for X11 GUI gtk-engines-0.10Theme engine for gtk+ toolkits libtool-1.3.3 Generic shared library support script mysql-client-3.23.33 Multithreaded SQL database (client) mysql-server-3.23.33 Multithreaded SQL database (server) qt-1.45 A C++ X GUI toolkit After installing the only version of gcc I could fine 2.95.3(?), both methods below produced exactly the same error. BTW, in order to install gcc, I had to install gmake. The error message I'm getting is usually, in my limited experience, due to the version of libstdc++.so on my system not being the same version of libstdc++ that mysql was compiled/linked with. Does anyone know the version that mysql was compiled with and if so, how do I check what version I currently have? Thanks all for the help, Shawn - Original Message - From: Bill Swanson [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Shawn Heeley [EMAIL PROTECTED] Sent: Wednesday, February 28, 2001 8:05 AM Subject: Re: Problem compiling mysql on FreeBSD Try upgrading to gcc 2.95.2. That should fix the problem. This cured my 'Installation of grant tables failed' error condition. Rgds, Bill Swanson DNA Enterprises, Inc. MIS Manager 972-671-1972 email: [EMAIL PROTECTED] -- Original Message -- From: "Shawn Heeley" [EMAIL PROTECTED] Date: Tue, 27 Feb 2001 23:07:01 -0500 Hi folks, This appears to be a common problem that I can't seem to find a solution. No matter which approach I take to trying to install mysql- server, the end result is the same. It doesn't work. I apologize for the long message. Thanks for the help. System Specs FreeBSD www.machine.com 4.0-RELEASE FreeBSD 4.0-RELEASE #0: Mon Mar 20 22:50:22 GMT 2000 libtool - libtool-1.3.3 mysql-client- mysql-client-3.23.33 I've tried two different approaches for installation. Source Installation pkg_add ./mysql-server-3.23.33.tgz Result: machine# pkg_add ./mysql-server-3.23.33.tgz Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables /usr/libexec/ld-elf.so.1: /usr/lib/libstdc++.so.3: Undefined symbol "__ti9exception" Installation of grant tables failed! SNIP... pkg_add: command '/usr/local/bin/mysql_install_db' failed mysql:*:88: You already have a group "mysql", so I will use it. mysql:*:88:88::0:0:MySQL Daemon:/var/db/mysql:/sbin/nologin You already have a user "mysql", so I will use it. Changed home directory of "mysql" to "/var/db/mysql" Running the mysqld command above produces the following message: machine# /usr/libexec/ld-elf.so.1: /usr/lib/libstdc++.so.3: Undefined symbol "__ti9exception" Using the Ports method: cd /usr/ports/databases/mysql322-server;make install Result: === Patching for mysql-server-3.22.32 === Applying FreeBSD patches for mysql-server-3.22.32 Ignoring previously applied (or reversed) patch. 3 out of 3 hunks ignored--saving rejects to scripts/mysql_install_db.sh.rej *** Error code 3 Stop in /usr/ports/databases/mysql322-server. *** Error code 1 Stop in /usr/ports/databases/mysql322-server. *** Error code 1 Stop in /usr/ports/databases/mysql322-server. *** Error code 1 Stop in /usr/ports/databases/mysql322-server. *** Error code 1 Stop in /usr/ports/databases/mysql322-server. *** Error code 1 Stop in /usr/ports/databases/mysql322-server. -- --- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php
Re: PHP and MySQL
Hi, I've installed MYSQL on Red hat. I'm trying to run the command mysqlaccess It asks for the Password for MySQL superuser root: Can anyone tell me the password for this? Thanks Sandeep - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: more date problems
Hi, Can you try "where signup_date '2001-02-28 23:59:59'", and see what that gives. Also, what version are you on - I have had some date problems where the end of one month and the begining of another get confused (usually when doing a UNIX_TIMESTAMP). Maybe then use mysqlbug to report the issue, and include the results of your tests. Not much help, I know, but the more information you post, the more help we can be. Regards -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 1:03 p.m. To: [EMAIL PROTECTED] Subject: more date problems okay, this is a follow-up to my past email... since I KNOW more than 122 people have signed up today, I did the following query: SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit 200; there are at LEAST 200 people that have signed up today. however, when i do: SELECT count(*) FROM members WHERE signup_date = now(); I only get 122 results! And YES, I have tried "2001-03-01" instead of "now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever. Does anyone have any idea what could be going on? I run this query quite often, is it possible the result is somehow being saved in a buffer? Should I shutdown the mysql server and restart it? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: more date problems
Quentin, that does not work either, I still get the 125 number, when there are actually 500 records =( I am using version 3.22.32 -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:18 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Hi, Can you try "where signup_date '2001-02-28 23:59:59'", and see what that gives. Also, what version are you on - I have had some date problems where the end of one month and the begining of another get confused (usually when doing a UNIX_TIMESTAMP). Maybe then use mysqlbug to report the issue, and include the results of your tests. Not much help, I know, but the more information you post, the more help we can be. Regards -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 1:03 p.m. To: [EMAIL PROTECTED] Subject: more date problems okay, this is a follow-up to my past email... since I KNOW more than 122 people have signed up today, I did the following query: SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit 200; there are at LEAST 200 people that have signed up today. however, when i do: SELECT count(*) FROM members WHERE signup_date = now(); I only get 122 results! And YES, I have tried "2001-03-01" instead of "now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever. Does anyone have any idea what could be going on? I run this query quite often, is it possible the result is somehow being saved in a buffer? Should I shutdown the mysql server and restart it? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP and MySQL
Hi, I've installed MYSQL on Red hat. I'm trying to run the command mysqlaccess It asks for the Password for MySQL superuser root: Can anyone tell me the password for this? Thanks Sandeep mysqlaccess is a perl script to check the access priviliges of a user:db:host scenario. What you need is to run safe_mysql to get the daemon running and then mysql (which will not ask for a pass the 1st time) and set a password for root by yourself. best of luck, thalis p.s. alternatively to the above: read the first ~500 lines from the mysql manual - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: more date problems
Can you post some of the data - e.g the first 500 rows of the 'order by' select, and the results of the select with signup_date='2001-03-01'. Also, how about Select now(), signup_date from , to see what things are being compared. Regards Quentin -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 3:34 p.m. To: Quentin Bennett; 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Quentin, that does not work either, I still get the 125 number, when there are actually 500 records =( I am using version 3.22.32 -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:18 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Hi, Can you try "where signup_date '2001-02-28 23:59:59'", and see what that gives. Also, what version are you on - I have had some date problems where the end of one month and the begining of another get confused (usually when doing a UNIX_TIMESTAMP). Maybe then use mysqlbug to report the issue, and include the results of your tests. Not much help, I know, but the more information you post, the more help we can be. Regards -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 1:03 p.m. To: [EMAIL PROTECTED] Subject: more date problems okay, this is a follow-up to my past email... since I KNOW more than 122 people have signed up today, I did the following query: SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit 200; there are at LEAST 200 people that have signed up today. however, when i do: SELECT count(*) FROM members WHERE signup_date = now(); I only get 122 results! And YES, I have tried "2001-03-01" instead of "now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever. Does anyone have any idea what could be going on? I run this query quite often, is it possible the result is somehow being saved in a buffer? Should I shutdown the mysql server and restart it? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyODBC
I'm just setting this up myself and there is a program called admndemo (or something like that) that comes with myodbc that will allow you to check if things are working or not without having to create a program. - Original Message - From: "Katelyn Sweet" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 02, 2001 0:53 Subject: MyODBC Ok, I am new in the IT world, and I just want to set up a mySql server. I installed mySql on the WinNt server (on the lan in my office) with mysqladmin running, and i installed myODBC on my win98 computer, with settings that would match the server. How can i test if this is working without making an application? do i need myODBC installed on teh server as well?? HELP!!! kate - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: more date problems
Ok, here goes... mysql select member_id, signup_date from members order by member_id desc limit 410; +---+-+ | member_id | signup_date | +---+-+ (here's the last 20 or so rows) | 0120472 | 2001-03-01 | | 0120471 | 2001-03-01 | | 0120470 | 2001-03-01 | | 0120469 | 2001-03-01 | | 0120468 | 2001-03-01 | | 0120467 | 2001-03-01 | | 0120466 | 2001-03-01 | | 0120465 | 2001-02-28 | | 0120464 | 2001-02-28 | | 0120463 | 2001-02-28 | | 0120462 | 2001-02-28 | | 0120461 | 2001-02-28 | | 0120460 | 2001-02-28 | | 0120459 | 2001-02-28 | | 0120458 | 2001-02-28 | +---+-+ This tells me that there are about 400 people that have signed up TODAY. The date is correct on the server: mysql select now(); +-+ | now() | +-+ | 2001-03-01 19:33:05 | +-+ So, the question is, why does this not return 400, like it should??? OK, weird! Now I am getting this error... mysql select count(*) from members where signup_date = '2001-03-01'; ERROR 1032: Can't find record in 'members' I have checked the tables using the checking utility, they show up fine. What's going on? =) -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:45 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Can you post some of the data - e.g the first 500 rows of the 'order by' select, and the results of the select with signup_date='2001-03-01'. Also, how about Select now(), signup_date from , to see what things are being compared. Regards Quentin -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 3:34 p.m. To: Quentin Bennett; 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Quentin, that does not work either, I still get the 125 number, when there are actually 500 records =( I am using version 3.22.32 -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:18 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Hi, Can you try "where signup_date '2001-02-28 23:59:59'", and see what that gives. Also, what version are you on - I have had some date problems where the end of one month and the begining of another get confused (usually when doing a UNIX_TIMESTAMP). Maybe then use mysqlbug to report the issue, and include the results of your tests. Not much help, I know, but the more information you post, the more help we can be. Regards -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 1:03 p.m. To: [EMAIL PROTECTED] Subject: more date problems okay, this is a follow-up to my past email... since I KNOW more than 122 people have signed up today, I did the following query: SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit 200; there are at LEAST 200 people that have signed up today. however, when i do: SELECT count(*) FROM members WHERE signup_date = now(); I only get 122 results! And YES, I have tried "2001-03-01" instead of "now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever. Does anyone have any idea what could be going on? I run this query quite often, is it possible the result is somehow being saved in a buffer? Should I shutdown the mysql server and restart it? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: BDB tables crashing mysql 3.23.33
On Thursday 01 March 2001 13:32, Quentin Bennett wrote: cut After the patch, MySQL still passes our test suite, which is a good sign. /cut But how come it passed the test suite with the bug in place ?? ;-) It does not any more, with the bug not fixed, that is. We update the test suite every time we find a new bug. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
date troubles
I should note, however, that this query works FINE: mysql select count(*) from members where signup_date = '2001-02-28'; +--+ | count(*) | +--+ | 732 | +--+ This APPEARS to work, but the "127" should be more like 420 mysql select count(*) from members where signup_date '2001-02-28'; +--+ | count(*) | +--+ | 127 | +--+ As opposed to before, when I got an error doing the following query, it now works, but does not return the correct value. I shut-down and restart the server, which is why I'm guessing I no longer get the error: mysql select count(*) from members where signup_date = now(); +--+ | count(*) | +--+ | 127 | +--+ Could this have anything to do with mysql caching this query somehow? I don't see how it works for one date, and not the others? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MyODBC
Ok, I am new in the IT world, and I just want to set up a mySql server. I installed mySql on the WinNt server (on the lan in my office) with mysqladmin running, and i installed myODBC on my win98 computer, with settings that would match the server. How can i test if this is working without making an application? do i need myODBC installed on teh server as well?? If you have defined the data source withing the ODBC administrator then you should be able to use MQuery (part of MS OFFICE) if you have it. Regards Grant Walters Brainbench 'Most Valuable Professional' for Unix Admin Walters Associates, P O Box 13-043 Johnsonville, Wellington, NEW ZEALAND Telephone: +64 4 4765175, CellPhone 025488265, ICQ# 23511989 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: more date problems
On Thu, 1 Mar 2001, Daren Cotter wrote: Ok, here goes... mysql select member_id, signup_date from members order by member_id desc limit 410; +---+-+ | member_id | signup_date | +---+-+ (here's the last 20 or so rows) | 0120472 | 2001-03-01 | | 0120471 | 2001-03-01 | | 0120470 | 2001-03-01 | | 0120469 | 2001-03-01 | | 0120468 | 2001-03-01 | | 0120467 | 2001-03-01 | | 0120466 | 2001-03-01 | | 0120465 | 2001-02-28 | | 0120464 | 2001-02-28 | | 0120463 | 2001-02-28 | | 0120462 | 2001-02-28 | | 0120461 | 2001-02-28 | | 0120460 | 2001-02-28 | | 0120459 | 2001-02-28 | | 0120458 | 2001-02-28 | +---+-+ Sorry if I've missed earlier threads about this, but what type is the signup_date field? AFAIK, datetime fields should show show the full date (and time) even though you don't insert it. So it should be '2001-03-01 00:00:00' or whatever NOW() inserts, if thats what you use :) Atle - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unable to make install mysql with DB-3.2.9a
Hello, I have mysql-3.23.33 installed, when trying to add BDB support using db-3.23.33 I get the message below after doing "make install" from /usr/src/mysql-3.23.33. Note: I had no problem with "make" or "configure" and I did follow all installation steps explained on www.mysql.com website. . . . . . . Making install in client make[1]: Entering directory `/usr/src/mysql-3.23.33/client' make[2]: Entering directory `/usr/src/mysql-3.23.33/client' /bin/sh ../mkinstalldirs /usr/local/mysql/bin /bin/sh ../libtool --mode=install /usr/bin/ginstall -c mysql /usr/local/mysql/bin/mysql /usr/bin/ginstall -c mysql /usr/local/mysql/bin/mysql /bin/sh ../libtool --mode=install /usr/bin/ginstall -c mysqladmin /usr/local/mysql/bin/mysqladmin /usr/bin/ginstall -c mysqladmin /usr/local/mysql/bin/mysqladmin /bin/sh ../libtool --mode=install /usr/bin/ginstall -c mysqlshow /usr/local/mysql/bin/mysqlshow /usr/bin/ginstall -c mysqlshow /usr/local/mysql/bin/mysqlshow /bin/sh ../libtool --mode=install /usr/bin/ginstall -c mysqldump /usr/local/mysql/bin/mysqldump /usr/bin/ginstall -c mysqldump /usr/local/mysql/bin/mysqldump /bin/sh ../libtool --mode=install /usr/bin/ginstall -c mysqlimport /usr/local/mysql/bin/mysqlimport /usr/bin/ginstall -c mysqlimport /usr/local/mysql/bin/mysqlimport /bin/sh ../libtool --mode=install /usr/bin/ginstall -c mysqltest /usr/local/mysql/bin/mysqltest /usr/bin/ginstall -c mysqltest /usr/local/mysql/bin/mysqltest make[2]: Nothing to be done for `install-data-am'. make[2]: Leaving directory `/usr/src/mysql-3.23.33/client' make[1]: Leaving directory `/usr/src/mysql-3.23.33/client' Making install in ./db-3.2.9a/build_unix make[1]: Entering directory `/usr/src/mysql-3.23.33/db-3.2.9a/build_unix' install_include install_lib install_utilities install_docs make[1]: install_include: Command not found make[1]: *** [install] Error 127 make[1]: Leaving directory `/usr/src/mysql-3.23.33/db-3.2.9a/build_unix' make: *** [install-recursive] Error 1 Anyone knows how to solve this problem? Regards, Boulat Khakimov. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: more date problems
On Thu, 1 Mar 2001 19:32:54 -0800, "Daren Cotter" [EMAIL PROTECTED] wrote: So, the question is, why does this not return 400, like it should??? OK, weird! Now I am getting this error... mysql select count(*) from members where signup_date = '2001-03-01'; ERROR 1032: Can't find record in 'members' have you tried mysql select count(*) from members where signup_date = CURDATE(); assuming the signup_date is in the -MM-DD format. Mike(mickalo)Blezien Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225) 686-2002 = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: more date problems
mysql select count(*) from members where signup_date = '2001-03-01'; ERROR 1032: Can't find record in 'members' Indicates a problem with the table structure; the result would be +--+ | count(*) | +--+ |0 | +--+ If there was a problem with the data. I suggest reviewing the isamchk results, and I'll leave it to the MySQL guys to interpret the error further. Good Luck Quentin -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 4:33 p.m. To: Quentin Bennett; 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Ok, here goes... mysql select member_id, signup_date from members order by member_id desc limit 410; +---+-+ | member_id | signup_date | +---+-+ (here's the last 20 or so rows) | 0120472 | 2001-03-01 | | 0120471 | 2001-03-01 | | 0120470 | 2001-03-01 | | 0120469 | 2001-03-01 | | 0120468 | 2001-03-01 | | 0120467 | 2001-03-01 | | 0120466 | 2001-03-01 | | 0120465 | 2001-02-28 | | 0120464 | 2001-02-28 | | 0120463 | 2001-02-28 | | 0120462 | 2001-02-28 | | 0120461 | 2001-02-28 | | 0120460 | 2001-02-28 | | 0120459 | 2001-02-28 | | 0120458 | 2001-02-28 | +---+-+ This tells me that there are about 400 people that have signed up TODAY. The date is correct on the server: mysql select now(); +-+ | now() | +-+ | 2001-03-01 19:33:05 | +-+ So, the question is, why does this not return 400, like it should??? OK, weird! Now I am getting this error... mysql select count(*) from members where signup_date = '2001-03-01'; ERROR 1032: Can't find record in 'members' I have checked the tables using the checking utility, they show up fine. What's going on? =) -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:45 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Can you post some of the data - e.g the first 500 rows of the 'order by' select, and the results of the select with signup_date='2001-03-01'. Also, how about Select now(), signup_date from , to see what things are being compared. Regards Quentin -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 3:34 p.m. To: Quentin Bennett; 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Quentin, that does not work either, I still get the 125 number, when there are actually 500 records =( I am using version 3.22.32 -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 01, 2001 4:18 PM To: 'Daren Cotter'; [EMAIL PROTECTED] Subject: RE: more date problems Hi, Can you try "where signup_date '2001-02-28 23:59:59'", and see what that gives. Also, what version are you on - I have had some date problems where the end of one month and the begining of another get confused (usually when doing a UNIX_TIMESTAMP). Maybe then use mysqlbug to report the issue, and include the results of your tests. Not much help, I know, but the more information you post, the more help we can be. Regards -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 March 2001 1:03 p.m. To: [EMAIL PROTECTED] Subject: more date problems okay, this is a follow-up to my past email... since I KNOW more than 122 people have signed up today, I did the following query: SELECT signup_date, member_id FROM members ORDER BY member_id DESC limit 200; there are at LEAST 200 people that have signed up today. however, when i do: SELECT count(*) FROM members WHERE signup_date = now(); I only get 122 results! And YES, I have tried "2001-03-01" instead of "now()". I ran ISAMCHK with the extended flag, and got no errors whatsoever. Does anyone have any idea what could be going on? I run this query quite often, is it possible the result is somehow being saved in a buffer? Should I shutdown the mysql server and restart it? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you
Select problem
Hi, I having trouble working out how to get a result set similar to the following where I select from a table with Date Sales column. My specific question is can I have a column that accumulates values, if so could I have some guidance on how to express this in a select statement please. +--+---+---+ | Month| Sales | Cum Sales | +--+---+---+ | Jan | 1000 | 1000 | | Feb | 1500 | 2500 | | Mar | 1200 | 3700 | | April| 1400 | 5100 | +--+---+---+ Many thanks in advance. Richard === Richard Vibert [EMAIL PROTECTED] Tatura Mitre10 === - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
