Re: MySql keeps crashing
Yes, host server means ISP. I am able to view the logs because he lets me. I agree with you, I think someone else is shutting down the database, but he insists that my perl scripts are causing it to crash. The only proof I have right now is the MySql error log, which lists the normal shutdown messages. These messages occur everytime the database goes down. I need to be able to show him the logs and prove that *I'm* not crashing the database, someone/something is shutting it down. I was just hoping that the MySql developers would see my post and tell me that normal shutdown messages will NOT occur if the database crashes...so I can go back to him and prove he's lying to me. Thanx, Chuck - Original Message - From: Rolf Hopkins [EMAIL PROTECTED] To: Chuck Lucas [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, June 11, 2001 01:55 Subject: Re: MySql keeps crashing This doesn't make much sense to me. By host server you mean your ISP? If so how are you able to view the logs? Are you DB admin or something? By the looks, someone is able to get in and shut it down. This can only happen with admin rights or mysql server wasn't set up correctly in the first place. I can't possibly see how SQL scripts could shutdown the server especially if the server has been properly setup and secured. - Original Message - From: Chuck Lucas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 11, 2001 12:03 Subject: help: MySql keeps crashing Need a little assistance. I've looked through the current MySql manual, but I can't find any information concerning my questions. My MySql server keeps crashing, or that's what my host server tells me. He claims that my scripts are crashing MySql. However, when I look at the MySql error log, I see messages like this: mysqld started on Fri Jun 8 07:36:34 PDT 2001 /usr/sbin/mysqld: ready for connections 010608 14:39:44 /usr/sbin/mysqld: Normal shutdown 010608 14:39:44 /usr/sbin/mysqld: Shutdown Complete mysqld ended on Fri Jun 8 14:39:45 PDT 2001 My questions are thus: If the server crashes, would it write a normal shutdown message, or is that message indicative of someone/something sending MySql a shutdown signal? Am I even looking in the correct log...should I be looking in the update log, or somewhere else? Here is some other information that may affect your answer: MySql Server version 3.22.21 Running on Cobalt RaQ with the following OS info: Linux 2.0.34 #1 mips glibc-2.0.7-10 Any help you could offer would be greatly appreciated! Chuck [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: Pornographer will trade for Help with web based MySql
I'm sure most people on this list aren't interested in your services. You can start by reading the relevant manuals or you could hire a professional to create the db for you. This is a great list for getting help on specific problems provided you've tried to help yourself first. Also, if you do need to ask the list for help and you need to post some code, please ensure that the content is ummm... let's say suitable for children. I mean, this list is for people to get assistance with mysql problems, it is not an adult's only chat room. - Original Message - From: John 'TPG' Smith [EMAIL PROTECTED] To: mysql list [EMAIL PROTECTED] Sent: Monday, June 11, 2001 9:13 Subject: Pornographer will trade for Help with web based MySql I am interested in learning MySql and cgi. I want to trade my services for this help. I want to be able to make custom web based applications. I am a pornographer. TPG [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
Help with tuning connections!
Ciao guys, I am using MySQL 3.23 on a Linux with Apache/PHP. Last week I first run it, and had a 'too many connections' warning. So, I just set the max_connections variable to 200. And since then, no problem. Here is the /etc/my.cnf file under the [mysqld] group: set-variable=key_buffer=16777216 set-variable=max_connections=200 set-variable=table_cache=2048 I want to ask you if there's a way to keep this under control. I mean. What should I do to do this? I use to give a look at the status and extended-status with mysqladmin, but are there any attributes I should keep an eye on? And, why does max_used_connections always says: 100? Kinda weird, isn't it? Ciao and thanks! -Gabriele - Gabriele Bartolini Computer Programmer (are U sure?) U.O. Rete Civica - Comune di Prato Prato - Italia - Europa e-mail: [EMAIL PROTECTED] http://www.po-net.prato.it - Zinedine Zizou Zidane. Just for soccer lovers. - - - 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
Case insensitive records search
Hi! I have such SQL : select CompanyName from Company where CompanyName like '%car%' Really I need in query result all of companys, which contains symbols CAR in any case (car, Car,CAr, CAR, e.t.c). I think that I need Case insensitive records search. Is it's possible and how? Thanks a lot! Andis
Row to delete
Hi Can some one help me for this issue. When I have multiple rows with the same duplicated data in the table, how can I delete a perticular row only ? For example I have the table TABLE1 with C1 INT and C2 VARCHAR(20) with the following rows of data C1 C2 = 10 MySQL 20 MySQLAB 10 MySQL 10 MySQL If I want to delete only the 3rd row, with out deleting other rows. Is it possible in MySQL ? Thank you Lalal __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.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: MySql keeps crashing
On Mon, Jun 11, 2001 at 02:13:25AM -0400, Chuck Lucas wrote: Yes, host server means ISP. I am able to view the logs because he lets me. I agree with you, I think someone else is shutting down the database, but he insists that my perl scripts are causing it to crash. The only proof I have right now is the MySql error log, which lists the normal shutdown messages. These messages occur everytime the database goes down. I need to be able to show him the logs and prove that *I'm* not crashing the database, someone/something is shutting it down. I was just hoping that the MySql developers would see my post and tell me that normal shutdown messages will NOT occur if the database crashes...so I can go back to him and prove he's lying to me. The normal basically means that it didn't crash. But there are a few normal ways in which MySQL can be shut down. Someone could do so by sending the right signal to the right mysqld process, or via `mysqladmin shutdown', and so on. It sounds like the admin you're dealing with is being lazy and really doesn't want to investiage what is happening. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 16 days, processed 105,690,521 queries (73/sec. avg) - 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: Replication
On Sun, Jun 10, 2001 at 09:29:15AM -0400, Granville A. Gayle Jnr. wrote: I have just started to use MySQL and like the ease in which it does it's one way replication. However I have a situation that has multi-sites that would need to do local entry to a database and then update the centreal database which could then update those databases that don't have the changed/additional info. i.e. locations HEAD,A,B C. Entry done in A,B C. HEAD needs to be updated after entry in A,B C. Likewise A B needs data from C, B C needs data from A, C A needs data from B. Is there any known way to accomplish this with MySQL?? If I understand you correctly, this is a multi-master replication setup. One in which there are several peers which all should see each other's updates to the data. You can do this in MySQL as long as: (1) You are running one of the latest MySQL versions. (2) You have a unique server-id for each server. (3) You configure the servers in a replication ring where A is a slave of B, B is a slave of C, and C is a slave of A (for a 3-master setup). (4) You understand that some queries won't work well in this seutp. For example you can't reliably use AUTO_INCREMENT columns the way you normally might with only one master. Some of this is mentioned in the manual, I think. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 16 days, processed 105,706,229 queries (73/sec. avg) - 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: StarOffice
1, Install unixODBC (look at www.unixodbc.org) 2, Then compile MyODBC with --with-unixODBC switch (I'm not sure about the syntax, look in ./configure -- help). 3, Setup odbc.ini propperly (here U can use ODBCConfig) 4, In StarOffice U should be able to create ODBC Database (select mysql driver in setup for db). This worked on my RH7.0 box. Maybe it'll help. Malmo Malmo If I only got 20$ for evryone who's too lazy to configure his own comp. Bill Gates Why not? On Sat, 9 Jun 2001, Jan Birk wrote: Hi I am new to this list, so foregive me if this have been asked before. Can anybody inform me and maybe point me in a direction (faq, etc.) for connecting mysql and StarOffice (Sparc, Solaris). Thanks and best regards Jan Birk - 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 keeps crashing
You could simulate a crash by deleting the mysql.sock file. If your ISP allows you to access the logs, he may have inadvertently allowed others access to them as well. Are you able to check if the system, especially mysql, is all locked down properly. Correct permission, ownerships, etc.? Only someone with the correct mysql root password could shut it down like that. Are you able to check what cron jobs are running? - Original Message - From: Chuck Lucas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 11, 2001 14:13 Subject: Re: MySql keeps crashing Yes, host server means ISP. I am able to view the logs because he lets me. I agree with you, I think someone else is shutting down the database, but he insists that my perl scripts are causing it to crash. The only proof I have right now is the MySql error log, which lists the normal shutdown messages. These messages occur everytime the database goes down. I need to be able to show him the logs and prove that *I'm* not crashing the database, someone/something is shutting it down. I was just hoping that the MySql developers would see my post and tell me that normal shutdown messages will NOT occur if the database crashes...so I can go back to him and prove he's lying to me. Thanx, Chuck - Original Message - From: Rolf Hopkins [EMAIL PROTECTED] To: Chuck Lucas [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, June 11, 2001 01:55 Subject: Re: MySql keeps crashing This doesn't make much sense to me. By host server you mean your ISP? If so how are you able to view the logs? Are you DB admin or something? By the looks, someone is able to get in and shut it down. This can only happen with admin rights or mysql server wasn't set up correctly in the first place. I can't possibly see how SQL scripts could shutdown the server especially if the server has been properly setup and secured. - Original Message - From: Chuck Lucas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 11, 2001 12:03 Subject: help: MySql keeps crashing Need a little assistance. I've looked through the current MySql manual, but I can't find any information concerning my questions. My MySql server keeps crashing, or that's what my host server tells me. He claims that my scripts are crashing MySql. However, when I look at the MySql error log, I see messages like this: mysqld started on Fri Jun 8 07:36:34 PDT 2001 /usr/sbin/mysqld: ready for connections 010608 14:39:44 /usr/sbin/mysqld: Normal shutdown 010608 14:39:44 /usr/sbin/mysqld: Shutdown Complete mysqld ended on Fri Jun 8 14:39:45 PDT 2001 My questions are thus: If the server crashes, would it write a normal shutdown message, or is that message indicative of someone/something sending MySql a shutdown signal? Am I even looking in the correct log...should I be looking in the update log, or somewhere else? Here is some other information that may affect your answer: MySql Server version 3.22.21 Running on Cobalt RaQ with the following OS info: Linux 2.0.34 #1 mips glibc-2.0.7-10 Any help you could offer would be greatly appreciated! Chuck [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 - 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
[beginner] How to update mysql with Linux ?
Hi all, I'd like to update my version of Mysql on linux. How can I do it so that I don't have two copies of mysql on my machine ? Do I have to clean up the folder mysql and then install the new version under it? And what should I download -the source code or the binaries- in order to update the starting scripts under /etc/rc.d/init.d ? Thanks a lot Francesco [EMAIL PROTECTED]
another query, please help
Hello All: I am trying to access second mysql server which is running on port 3308 through java. Even when I specify port number in my connection, it still connecting to the database running on port 3307. When i try to access 2nd mysql server through command prompt it works! This is the way i access my 2nd mysql server through command prompt: 'mysql -u root -S/var/lib/mysql2/mysql.sock2 -P3308 -p' Whereas if I say: 'mysql -u root -p' It connects to my default mysql server running on port 3307. How do achieve this using JDBC? How do I connect to two different mysql servers? Using port numbers does not seem to help. Do I have to specify any socket file here too??? Have no idea here! Any Ponters? ...Rohit TransLogic Systems 5th Floor, Amogh Plaza, Greenlands, Hyderabad, AP - 500 016, INDIA Ph: 91.40.3401795, Fax: 91.40.3407943 www.translogicsys.com
RE: Once again, this doesn't do anything.
The insert statement is valid (see http://www.mysql.com/doc/I/N/INSERT.html, third example), just uncommon. I can't help with the php...but I do know that insert statement is invalid. ... $sql = insert into sitesats set areview='$areview', apositive='$apositive', anegative='$anegative', arate='$arate' where id='$id'; - 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: Case insensitive records search
Andis Grasis wrote: Hi! I have such SQL : select CompanyName from Company where CompanyName like '%car%' Really I need in query result all of companys, which contains symbols CAR in any case (car, Car,CAr, CAR, e.t.c). I think that I need Case insensitive records search. Is it's possible and how? Thanks a lot! Andis There is no case insensitive type in MySQL as far as I know but you should be able to do it with regular expression lokk for them in the manual. Lars - 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: Internals Of MySQL
Im running some benchmarking tests on mysql, postgres and interbase database servers. does anyone know the reasons why or know where i can find out some technical reasons why the mysql database server is particularly good in relation to the others or just by itself e.g. use of query optimisation or indexing etc. I'm only looking at creates, selects, inserts, update and delete statements. I've tried to look around for this on the net, but all i seem to get is a big arguement consisting of the features lacking in mysql that are in other databases e.g. ACID!! Without detailed knowledge, may I suggest that you have answered your own question. MySQL has dumped some of the more complex features offered by other databases in favour of oprimising for prformance. Some of the features arequired for ACID would probably slow it down considerably. Isn't it nice toi have the choice - if you really need ACID, there are other databeses which will offer it. If you don't, you can used MySQL and not be burdened with the cost of it. Alec Cawley - 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: Access Database into mysql
Hi, I have a database table, which was made with Microsoft Access and am to move the data into a mysql database table. As there are some long entries, which exceed the data size allowed in a table cell by Microsoft Excel I can't export it via Excel and convert it from Excel into a Text Tabs document (As I did with other tables). Did you try to export it via ODBC. I the past I have some databases to move from Access 97 to MySQL. I have created the same DB in mysql , and (of course I have installed MySQL on Win) and than put all data from Access to MySQL via ODBC . I only lost keys, but, I have manualy fix it with alter table. Poz -- * Ilic Aleksandar * * System Administrator * Dream Company* * Beogradska 1, 18000 Nis * * E-mail: [EMAIL PROTECTED] * * Phone/Fax: 381 18 24 540 * * Phone: 381 18 547 450 * * Mob: 381 63 691 803 * - 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: install problems
On Fri, Jun 08, 2001 at 07:26:55PM +, Ji-Qin Yang wrote: Hi, Mysql guys: I have problem to install mysql into my DEC-AlphaServer 800 which run DEC-osf4.0d. I downloaded mysql source file: mysql-3.22.30-dec-osf4.0f- alphaev6.tar.gz, after run #./configure, then #make, it show the problems, although I try command #make install, the error message is showed below: [snip] root 01:52:13 mysql-3.23.38 make install No suffix list. Making install in include No suffix list. Make: % rule can only use a single ':'. Stop. *** Exit 1 Stop. What sort of make do you have installed? I'd suggest grabbing a copy of GNU Make. You'll have much better luck than with the version that Digital (probably) provided. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 16 days, processed 106,618,579 queries (74/sec. avg) - 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: [beginner] How to update mysql with Linux ?
At 09.42 11/06/01 +0200, Francesco Marchioni wrote: Hi all, I'd like to update my version of Mysql on linux. How can I do it so that I don't have two copies of mysql on my machine ? Do I have to clean up the folder mysql and then install the new version under it? I suggest you to dump all of the database you are interested in, first of all. That's pretty easy, just run mysqldump for every db. And what should I download -the source code or the binaries- in order to update the starting scripts under /etc/rc.d/init.d ? It depends on which version you have already installed. Do you use RPMs or source code? And, which version of MySQL do you have? However, you could also write me in italian ... but I guess personally, otherwise nobody will understand! :-) Ciao -Gabriele - Gabriele Bartolini - Computer Programmer U.O. Rete Civica - Comune di Prato Prato - Italia - Europa e-mail: [EMAIL PROTECTED] http://www.po-net.prato.it - A Supernova is the celestial equivalent of rm -rf /* with root permissions. - - 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 working on a cluster
On Thu, Jun 07, 2001 at 05:42:40PM +0100, Nelson Gomes wrote: I have a question: On a cluster, is it possible to have several MySQL instances (one per node) each having several mysqld processes, working concurrently on NAS (network storage) device, that is mounted on every node, and accessed through a shared filesystem ?? Yes. Folks have reported doing this with a Network Appliance Filer (specialized NFS server) and several Linux/Unix boxes. How does mysql controlles the access to database files? Through file system calls ? File locking. Does anyone used mysql on a cluster ? Suggestions ? Anyone ? (I'm thinking on use Mosix and Global File System (GFS) ) There was some Mosix/GFS related discussion a month or two ago on the mysql-internals list. You might want to poke around the archives for it and see what turns up. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 16 days, processed 106,641,595 queries (74/sec. avg) - 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
query to display per page
Dear, I am preparing my web page to display search result. How could I use SQL command to handle display specific row per page and next button at the bottom page (like most search engine display result). Sommai Fongnamthip Remark: Could I use this SQL command with PHP or perl? - 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
Again: ORDER BY key_part1,key_part2 does not use index
Hi, I know this subject has been treated several times in this list (see e.g. http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:65398:200102:ipomopcphmhamkmigoob#b ), but I think it deserves further discussion. My problem is the following: I have a rather large table (~430M records in 21G with a 4.4G packed index) created by: CREATE TABLE T ( `Id` int(11) NOT NULL default '0', `Id2` int(11) NOT NULL default '0', `F1` smallint(6) default NULL, `F2` smallint(6) default NULL, `F3` smallint(6) default NULL, `F4` smallint(6) default NULL, `F5` float default NULL, `F6` mediumtext, `F7` float default NULL, `F8` float default NULL, KEY `TIds`(`Id`,`Id2`), KEY `TId2`(`Id2`) ) TYPE=MyISAM MAX_ROWS=25 PACK_KEYS=1; The query I want to run is: SELECT * FROM T ORDER BY Id, Id2; I would expect MySQL to use the index to retrieve the rows in sorted order, but this is not what happens (MySQL 3.23.38): EXPLAIN SELECT * FROM T ORDER BY Id, Id2; +---+--+---+--+-+--+---++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--+---++ | T | ALL | NULL | NULL |NULL | NULL | 431476682 | Using filesort | +---+--+---+--+-+--+---++ Using filesort means that MySQL does the sorting itself without using the index. I can think of two possible implementations: (1) Create a temporary 21G file with 430M complete records, sort these by (Id, Id2) and then read the data sequentially from this file. The sorting can be done on the fly using a good mergesort implementation and will use almost no random accesses with large enough buffers. I expect the time required for this to be the time to read, write and reread 21G: with 50MB/s I/O bandwidth, 3*21G/50MB ~ 21 min. With the CPU time required for the sorting, I would expect less than an hour. The time to process the query would be dominated by reading the sorted data into the application, even with a Gigabit network. (2) Create a temporary 16*430M file with 430M records (Id, Id2, record pointer), sort this by (Id, Id2), and then retrieve the complete records doing 430M random accesses. From earlier experience, I assume this is what MySQL does, despite the fact that it is entirely equivalent to using the index... I expect the time rqeuired for this to be dominated by the 430M random reads. On a fast RAID with 2 ms avg access time, this may require up to 430M * 2ms ~ 10 days, but may be substantially less if the data file is already partially sorted by Id, Id2 (which it is in our case). For me, this discussion boils down to three questions: A) Does MySQL sort the entire file (1), or just the ORDER BY criteria with subsequent random reads (2)? B) If what I believe is correct (MySQL does (2)), why does it create a temporary file containing the keys and sort it instead of using the index? C) The MySQL manual in http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#MySQL_indexes says: ...The following queries will use the index to resolve the ORDER BY part: SELECT * FROM foo ORDER BY key_part1,key_part2,key_part3; Isn't this information wrong or at least incomplete? Can anyone shed some light on this? Thanks. Lukas Knecht infox Neptunstr. 35 CH-8032 Zürich - 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: query to display per page
Try Limit 10,10 then Limit 20,10 or is it the other was around limit 10.20! Well some thing like that.. Hope this helps Simon -Original Message- From: Sommai Fongnamthip [mailto:[EMAIL PROTECTED]] Sent: 11 June 2001 10:52 To: [EMAIL PROTECTED] Subject: query to display per page Dear, I am preparing my web page to display search result. How could I use SQL command to handle display specific row per page and next button at the bottom page (like most search engine display result). Sommai Fongnamthip Remark: Could I use this SQL command with PHP or perl? - 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: Internals Of MySQL
[EMAIL PROTECTED] writes: Im running some benchmarking tests on mysql, postgres and interbase database servers. does anyone know the reasons why or know where i can find out some technical reasons why the mysql database server is particularly good in relation to the others or just by itself e.g. use of query optimisation or indexing etc. I'm only looking at creates, selects, inserts, update and delete statements. I've tried to look around for this on the net, but all i seem to get is a big arguement consisting of the features lacking in mysql that are in other databases e.g. ACID!! Without detailed knowledge, may I suggest that you have answered your own question. MySQL has dumped some of the more complex features offered by other databases in favour of oprimising for prformance. Some of the features arequired for ACID would probably slow it down considerably. Isn't it nice toi have the choice - if you really need ACID, there are other databeses which will offer it. If you don't, you can used MySQL and not be burdened with the cost of it. Alec Cawley Hi! Just to clear up the issue a bit. If you wish to have ACID level of security use MySQL with BDB or InnoDB tables. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.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: query to display per page
In PHP, I used something like this: ? $result = $db-query(select * from table limit $x,25); while ($row=$db-fetch_array($result)) { echo $row[column]; } $next = ($x+25); echo a href=\script.php?x=$next\Next/a\n; ? So that's the idea... Leon Mergen [EMAIL PROTECTED] President of Operations BlazeBox, Inc. T: +31 31 735 03 03 F: +31 31 735 03 08 ICQ: 55677353 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 any computer. - Original Message - From: Sommai Fongnamthip [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 11, 2001 11:52 AM Subject: query to display per page Dear, I am preparing my web page to display search result. How could I use SQL command to handle display specific row per page and next button at the bottom page (like most search engine display result). Sommai Fongnamthip Remark: Could I use this SQL command with PHP or perl? - 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: Again: ORDER BY key_part1,key_part2 does not use index
Just out of interest If you are selecting * then you are using all the records What if you use are 'where'..? Simon -Original Message- From: Lukas Knecht [mailto:[EMAIL PROTECTED]] Sent: 11 June 2001 10:49 To: [EMAIL PROTECTED] Subject: Again: ORDER BY key_part1,key_part2 does not use index Hi, I know this subject has been treated several times in this list (see e.g. http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:65398:200102:ipomopcphmhamkmig oob#b ), but I think it deserves further discussion. My problem is the following: I have a rather large table (~430M records in 21G with a 4.4G packed index) created by: CREATE TABLE T ( `Id` int(11) NOT NULL default '0', `Id2` int(11) NOT NULL default '0', `F1` smallint(6) default NULL, `F2` smallint(6) default NULL, `F3` smallint(6) default NULL, `F4` smallint(6) default NULL, `F5` float default NULL, `F6` mediumtext, `F7` float default NULL, `F8` float default NULL, KEY `TIds`(`Id`,`Id2`), KEY `TId2`(`Id2`) ) TYPE=MyISAM MAX_ROWS=25 PACK_KEYS=1; The query I want to run is: SELECT * FROM T ORDER BY Id, Id2; I would expect MySQL to use the index to retrieve the rows in sorted order, but this is not what happens (MySQL 3.23.38): EXPLAIN SELECT * FROM T ORDER BY Id, Id2; +---+--+---+--+-+--+---+ + | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--+---+ + | T | ALL | NULL | NULL |NULL | NULL | 431476682 | Using filesort | +---+--+---+--+-+--+---+ + Using filesort means that MySQL does the sorting itself without using the index. I can think of two possible implementations: (1) Create a temporary 21G file with 430M complete records, sort these by (Id, Id2) and then read the data sequentially from this file. The sorting can be done on the fly using a good mergesort implementation and will use almost no random accesses with large enough buffers. I expect the time required for this to be the time to read, write and reread 21G: with 50MB/s I/O bandwidth, 3*21G/50MB ~ 21 min. With the CPU time required for the sorting, I would expect less than an hour. The time to process the query would be dominated by reading the sorted data into the application, even with a Gigabit network. (2) Create a temporary 16*430M file with 430M records (Id, Id2, record pointer), sort this by (Id, Id2), and then retrieve the complete records doing 430M random accesses. From earlier experience, I assume this is what MySQL does, despite the fact that it is entirely equivalent to using the index... I expect the time rqeuired for this to be dominated by the 430M random reads. On a fast RAID with 2 ms avg access time, this may require up to 430M * 2ms ~ 10 days, but may be substantially less if the data file is already partially sorted by Id, Id2 (which it is in our case). For me, this discussion boils down to three questions: A) Does MySQL sort the entire file (1), or just the ORDER BY criteria with subsequent random reads (2)? B) If what I believe is correct (MySQL does (2)), why does it create a temporary file containing the keys and sort it instead of using the index? C) The MySQL manual in http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#M ySQL_indexes says: ...The following queries will use the index to resolve the ORDER BY part: SELECT * FROM foo ORDER BY key_part1,key_part2,key_part3; Isn't this information wrong or at least incomplete? Can anyone shed some light on this? Thanks. Lukas Knecht infox Neptunstr. 35 CH-8032 Zürich - 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
FW: Q: max value?
Hi! Does anybody knows how can I check whether the max value in some database's field has been reached? For example, I have MEDIUMINT column and I want to reset its value once it reaches its maximum, that is 8388607. How can I check which is the maximum (min) value I can insert into field? Bye!
Re: Again: ORDER BY key_part1,key_part2 does not use index
I have some sort of problem too... Look at this: mysql explain select * from game3 order by memberid; +---+--+---+--+-+--+--+- ---+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--+--+- ---+ | game3 | ALL | NULL | NULL |NULL | NULL | 1245 | Using filesort | +---+--+---+--+-+--+--+- ---+ 1 row in set (0.02 sec) mysql explain select * from game3 where memberid = '1'; +---+---+---+--+-+---+--+--- + | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+---+---+--+-+---+--+--- + | game3 | const | memberid | memberid | 2 | const |1 | | +---+---+---+--+-+---+--+--- + 1 row in set (0.00 sec) As you can clearly see in the 2nd query, memberid is a key, and is used there. But why isn't it used in the ORDER BY clause? Thanks in advance, Leon Mergen [EMAIL PROTECTED] BlazeBox, Inc. ICQ: 55677353 - Original Message - From: Lukas Knecht [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 11, 2001 11:48 AM Subject: Again: ORDER BY key_part1,key_part2 does not use index Hi, I know this subject has been treated several times in this list (see e.g. http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:sss:65398:200102:ipomopcphmhamkmig oob#b ), but I think it deserves further discussion. My problem is the following: I have a rather large table (~430M records in 21G with a 4.4G packed index) created by: CREATE TABLE T ( `Id` int(11) NOT NULL default '0', `Id2` int(11) NOT NULL default '0', `F1` smallint(6) default NULL, `F2` smallint(6) default NULL, `F3` smallint(6) default NULL, `F4` smallint(6) default NULL, `F5` float default NULL, `F6` mediumtext, `F7` float default NULL, `F8` float default NULL, KEY `TIds`(`Id`,`Id2`), KEY `TId2`(`Id2`) ) TYPE=MyISAM MAX_ROWS=25 PACK_KEYS=1; The query I want to run is: SELECT * FROM T ORDER BY Id, Id2; I would expect MySQL to use the index to retrieve the rows in sorted order, but this is not what happens (MySQL 3.23.38): EXPLAIN SELECT * FROM T ORDER BY Id, Id2; +---+--+---+--+-+--+---+ + | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+--+-+--+---+ + | T | ALL | NULL | NULL |NULL | NULL | 431476682 | Using filesort | +---+--+---+--+-+--+---+ + Using filesort means that MySQL does the sorting itself without using the index. I can think of two possible implementations: (1) Create a temporary 21G file with 430M complete records, sort these by (Id, Id2) and then read the data sequentially from this file. The sorting can be done on the fly using a good mergesort implementation and will use almost no random accesses with large enough buffers. I expect the time required for this to be the time to read, write and reread 21G: with 50MB/s I/O bandwidth, 3*21G/50MB ~ 21 min. With the CPU time required for the sorting, I would expect less than an hour. The time to process the query would be dominated by reading the sorted data into the application, even with a Gigabit network. (2) Create a temporary 16*430M file with 430M records (Id, Id2, record pointer), sort this by (Id, Id2), and then retrieve the complete records doing 430M random accesses. From earlier experience, I assume this is what MySQL does, despite the fact that it is entirely equivalent to using the index... I expect the time rqeuired for this to be dominated by the 430M random reads. On a fast RAID with 2 ms avg access time, this may require up to 430M * 2ms ~ 10 days, but may be substantially less if the data file is already partially sorted by Id, Id2 (which it is in our case). For me, this discussion boils down to three questions: A) Does MySQL sort the entire file (1), or just the ORDER BY criteria with subsequent random reads (2)? B) If what I believe is correct (MySQL does (2)), why does it create a temporary file containing the keys and sort it instead of using the index? C) The MySQL manual in http://www.mysql.com/documentation/mysql/bychapter/manual_Performance.html#M ySQL_indexes says: ...The following queries will use the index to resolve the ORDER BY part: SELECT * FROM foo ORDER BY key_part1,key_part2,key_part3; Isn't this information wrong or at least incomplete? Can anyone shed some light on this? Thanks. Lukas Knecht infox Neptunstr. 35 CH-8032 Zürich
Re: load_defaults Strangeness
Van writes: Greetings: With the following code, I have 3 problems: 1../client -psecret works, but, ./client --password=secret does not; 2.After calling load_defaults, the argument vector is getting parsed, but, it's not making it into the switch processing. The values from my global char *password = NULL values are being used; 3.Compiler warnings related to the struct variables. I've also tried: {password,optional_argument, 0, p}, with the same result. I didn't see anything in getopt.h that would explain this. Using the one from sampdb/capi used in Paul's book. main.c:38: warning: initialization makes integer from pointer without a cast Can anyone see where the error(s) is/are? Full source is at http://az.dedserius.com/main.c/ Regards, Van Hi! What you have described works just fine with mysql client program. Just copy the relevant parts from it and your program will work in the same fashion. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.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: query to display per page
Hi Sommai. On Mon, Jun 11, 2001 at 04:52:01PM +0700, Sommai Fongnamthip wrote: Dear, I am preparing my web page to display search result. How could I use SQL command to handle display specific row per page and next button at the bottom page (like most search engine display result). See the LIMIT clause of the SELECT statement: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT That allows you to specify the row offset and the maximum number of rows to return. For example: SELECT * FROM search_results WHERE sid = ? LIMIT 50,25 That would fetch 25 rows starting at offset 50 (offset is zero-based). In order to know if you should display the next button, you'll want to fetch one more row than you need (e.g. if you'll be displaying 25 rows per page, fetch 26 instead). If you get that extra row, you'll know you have more to display. Maurice - 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
Troubleshooting connectivity
I seem to have a connectivity problem that I'm having trouble diagnosing. I have an internal network (192.168.0.*) with mysql running fine on machine A. The outside world can get to A fine, and ordinarily so can machine Bhowever randomly and more often, I cannot log into A from B using mysql -h kettlebrook -p I get the password promt but nothing more. This appears to be the only service on A inaccessible from B (for example I can ssh to A from B). I've stopped and started networking, my firewall, and mysql, but that doesn't help.unfortunately, only a reboot on B clears it (linux). Does anyone have any tips for troubleshooting this? Regards, Gary SuperID Huntress === FreeSQL.org offering free database hosting to developers Visit http://www.freesql.org - 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 I'm receiving
Saleel, mysqld.exe was accidentally compiled with __NT__ defined. You should use mysqld-max.exe. The next version .39 will ask from the OS if it is Win 95, ..., and this problem will not appear any more. I am sorry for the inconvenience. Regards, Heikki Tuuri Innobase Oy Hello, I was wondering if you could help me on a problem I am having with mySQL. I've installed MySQL (Win32) on F:\mysql. I've placed my.cnf on C:\. This is the contents of my.cnf:---# Example mysql config file. # Copy this file to c:\my.cnf to set global options# # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients[client]#password=my_passwordport=3306 #socket=MySQL# Here is entries for some specific programs # The following values assume you have at least 32M ram# The MySQL server [mysqld]port=3306#socket=MySQLskip-lockingdefault-character-set=latin1 set-variable = key_buffer=16Mset-variable = max_allowed_packet=1M set-variable = thread_stack=128Kset-variable = flush_time=1800 innodb_data_file_path = ibdata1:20M;ibdata2:20M # Uncomment the following row if you move the MySQL distribution to another # location#basedir = d:/mysql/[mysqldump]quick set-variable = max_allowed_packet=16M[mysql]no-auto-rehash[isamchk] set-variable= key=16M[client_fltk]help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.optionshistory_length=20database = test queries_root= c:\mysql\querieslast_database_file= c:\mysql\lastdb My system is a PII 400MHz with 128mb RAM and plenty of hard disk space. (F:\ alone has 17GB free, C:\ has 5.7GB free). It is running Win ME. I fire up a MS-DOS window, navigate to f:\mysql\bin and type mysqld. This is what happens: InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file .\ibdata1 size to 20971520 InnoDB: Database physically writes the file full: wait... InnoDB: Data file .\ibdata2 did not exist: new to be created InnoDB: Setting file .\ibdata2 size to 20971520 InnoDB: Database physically writes the file full: wait... InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 5242880 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 5242880 Innobase: Assertion failure in thread 4294430293 in fileM:\mysql-3.23\innobase\ os\os0file.c line 187Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010610 22:46:17 F:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010610 22:46:17 Aborting InnoDB: Warning: shutting down not properly started database 010610 22:46:17 F:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete--- And I have no clue what to do next. Doing a Ctrl+Alt+Del to see the tasks shows me that myslq is *not* running (not in programs list). I don't think it matters, but I am running Apache/1.3.19 (Win32), PHP/4.0.5 and ActiveState Perl (F:\php and F:\perl). Before attempting to start mysql, I did close done Apache.Any help would be much appreciated.Thanks.--- Saleel [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 install problem
I have a slackware box with Apache Perl 5.6, DBI and mod_perl. I can't get the MYSQL DBI module to install. It's dieing on this line. I'm very perplexed. Ruben umask -a Linux vidor 2.2.13 #127 Thu Oct 21 13:13:20 CDT 1999 i686 unknown make[1]: Entering directory `/root/.cpan/build/Msql-Mysql-modules-1.1835/Mysql' cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI -I/usr/local/include/mysql -I../dbd -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI -I/usr/local/lib/perl5/5.6.1/i686-linux -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\1.1835\ -DXS_VERSION=\1.1835\ -fpic -I/usr/local/lib/perl5/5.6.1/i686-linux/CORE -DDBD_MYSQL Mysql.xs: In function `XS_Mysql_listdbs': Mysql.xs:945: `sv_undef' undeclared (first use in this function) Mysql.xs:949: `dowarn' undeclared (first use in this function) Mysql.xs: In function `XS_Mysql_listtables': Mysql.xs:970: `sv_undef' undeclared (first use in this function) Mysql.xs:974: `dowarn' undeclared (first use in this function) Mysql.xs: In function `XS_Mysql_listfields': Mysql.xs:1005: `dowarn' undeclared (first use in this function) make[1]: *** [Mysql.o] Error 1 make[1]: Leaving directory `/root/.cpan/build/Msql-Mysql-modules-1.1835/Mysql' make: *** [subdirs] Error 2 -- Brooklyn Linux Solutions http://www.mrbrklyn.com http://www.brooklynonline.com 1-718-382-5752 -- Brooklyn Linux Solutions http://www.mrbrklyn.com http://www.brooklynonline.com 1-718-382-5752 - 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
Setting up users!
Ok. I have read the manual =) But one thing I am not clear on. Is if I can create a user who can create their own database's..modify them..and drop them if need be. But they wouldn't have access to any database on the server. I am asking because I host 4 different sites and 3 of them want mysql access. And I would not want to have to go and create a new database for these guys anytime they wanted. Or are there other ways around this? Thanks, h3rb - 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 I'm receiving
At 15:04 11/06/2001 +0300, Heikki Tuuri wrote: Hi, Only to complete the Heikki's instructions, also you need to edit on /my.cnf the variables: [mysqld] basedir=F:/mysql datadir=F:/mysql/data The above is necessary when MySQL was installed on different location than the default c:\mysql. Regards, Miguel Saleel, mysqld.exe was accidentally compiled with __NT__ defined. You should use mysqld-max.exe. The next version .39 will ask from the OS if it is Win 95, ..., and this problem will not appear any more. I am sorry for the inconvenience. Regards, Heikki Tuuri Innobase Oy Hello, I was wondering if you could help me on a problem I am having with mySQL. I've installed MySQL (Win32) on F:\mysql. I've placed my.cnf on C:\. This is the contents of my.cnf:---# Example mysql config file. # Copy this file to c:\my.cnf to set global options# # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients[client]#password=my_passwordport=3306 #socket=MySQL# Here is entries for some specific programs # The following values assume you have at least 32M ram# The MySQL server [mysqld]port=3306#socket=MySQLskip-lockingdefault-character-set=latin1 set-variable = key_buffer=16Mset-variable = max_allowed_packet=1M set-variable = thread_stack=128Kset-variable = flush_time=1800 innodb_data_file_path = ibdata1:20M;ibdata2:20M # Uncomment the following row if you move the MySQL distribution to another # location#basedir = d:/mysql/[mysqldump]quick set-variable = max_allowed_packet=16M[mysql]no-auto-rehash[isamchk] set-variable= key=16M[client_fltk]help_file= c:\mysql\sql_client\MySQL.help client_file= c:\mysql\MySQL.optionshistory_length=20database = test queries_root= c:\mysql\querieslast_database_file= c:\mysql\lastdb My system is a PII 400MHz with 128mb RAM and plenty of hard disk space. (F:\ alone has 17GB free, C:\ has 5.7GB free). It is running Win ME. I fire up a MS-DOS window, navigate to f:\mysql\bin and type mysqld. This is what happens: InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file .\ibdata1 size to 20971520 InnoDB: Database physically writes the file full: wait... InnoDB: Data file .\ibdata2 did not exist: new to be created InnoDB: Setting file .\ibdata2 size to 20971520 InnoDB: Database physically writes the file full: wait... InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 5242880 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 5242880 Innobase: Assertion failure in thread 4294430293 in fileM:\mysql-3.23\innobase\ os\os0file.c line 187Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010610 22:46:17 F:\MYSQL\BIN\MYSQLD.EXE: Got signal 11. Aborting! 010610 22:46:17 Aborting InnoDB: Warning: shutting down not properly started database 010610 22:46:17 F:\MYSQL\BIN\MYSQLD.EXE: Shutdown Complete--- And I have no clue what to do next. Doing a Ctrl+Alt+Del to see the tasks shows me that myslq is *not* running (not in programs list). I don't think it matters, but I am running Apache/1.3.19 (Win32), PHP/4.0.5 and ActiveState Perl (F:\php and F:\perl). Before attempting to start mysql, I did close done Apache.Any help would be much appreciated.Thanks.--- Saleel [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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.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: Row to delete
hi. check out a book or online tutorial on database normalization. even a mildly normalized database will provide a way to uniquely reference a row. otherwise, you can use: delete from table1 where c1 = 10 and c2 = 'MySQL' limit 1; that will delete one row only, and if the rows are truly identical, it won't matter which of them (third one, first one, second one) you delete. -ravi. -Original Message- From: LAMULA LALLAL [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 2:47 AM To: [EMAIL PROTECTED] Subject: Row to delete Hi Can some one help me for this issue. When I have multiple rows with the same duplicated data in the table, how can I delete a perticular row only ? For example I have the table TABLE1 with C1 INT and C2 VARCHAR(20) with the following rows of data C1 C2 = 10 MySQL 20 MySQLAB 10 MySQL 10 MySQL If I want to delete only the 3rd row, with out deleting other rows. Is it possible in MySQL ? Thank you Lalal __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.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
Can any body supply libmysqlclient.so for Solaris 7?
Could anybody e-mail me a copy of libmysqlclient.so for Solaris 7 -or- let me know where I can get one? Many Thanks, =Adrian= Information in this message is confidential and may also be legally privileged. It is intended solely for the person to whom it is addressed. If you are not the intended recipient, please notify the sender, and then please delete the message from your system immediately. - 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
mysqld keeps falling over on NetBSD
Our normally reliable back-end server for our web site has now gone completely crazy ... it's falling over every few seconds. Automatic restarts are nice, but it really makes the web site unusable. 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. 010611 10:06:28 mysqld restarted /usr/local/libexec/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. 010611 10:06:30 mysqld restarted /usr/local/libexec/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. 010611 10:06:32 mysqld restarted /usr/local/libexec/mysqld: ready for connections There is very little information available here. I have tried check table, and myisamchk with -r, -o and -e options ... and no help. This is running MySQL 3.23.36 on NetBSD/i386 1.4.1. Are there any significant bug fixes in 3.23.38 to make it worthwhile downloading, building and installing it? Tom Haapanen [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
odbc on WinME
I recently downloaded the ODBC client software for windows, ran setup, then went into the 'ODBC Data Source Administrator' from the control panel per the readme. I tried to add a new datasource, but MySQL was not in the list so apparently the setup program didn't work as expected. Any suggestions on what to check? (Just saying that this worked for you is not what I am looking for.) Perhaps there's a registry entry I should check? Thanks. - 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 starting mysql server
Hello, I donwloaded the mysql 3.23.38 binary for AIX 4.3.3 and installed an IBM rs6000 workstation. When I started mysql server with safe_mysqld, I got following error message: Start MySQL server deamon exec(): 0509-036 Cannot load program /usr/local/mysql/bin/my_print_defaults because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be loaded. 0509-152 Member shr.o is not found in archive 010608 10:54:45 mysqld ended The zlib installed on the workstation is version 1.1.3. Can anyone tell me what wrong here? what is this shr.o? Did I miss something? Thanks. Weining - 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
LEFT JOIN in MySQL Version 3.22.32
Hi, unfortunately my provider still runs My SQL version 3.22.32 on his server. Apparently the LEFT JOIN statement does not work on this version. Anybody knows a workaround? Holger - 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
stunnel problem - libwrap
Doing that, I'm now seeing: ERROR 2013: Lost connection to MySQL server during query after entering the password. The problem above shouldn't be master.info related. Sheesh, yeah, it's: stunnel[7765]: Connection from xxx.xx.xxx.xx:1635 REFUSED by libwrap which is the problem for the mysql client on the client, trying to connect with its own port 3307 (to which the remote mysqld is tunnelled). So I need to get that out of the way first. I have no man page for libwrap, and can't find where stunnel's documents discuss this. Might there be a problem with the tcpwrappers library on what was originally a Red Hat 6.0 system? Is there some flag I'm missing to tell stunnel I really don't want the libwrap check to be applied? I'm vague on the concept of tcpwrap - thought it only applied to inet.d-invoked stuff, haven't run into problems with it before, kind of wish it wasn't there if it's going to be problematic like this - I've got good firewalls on both ends to worry about what connects to what. Whit - 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 multiple mysqld's
On Friday 08 June 2001 22:16, Rohit Peyyeti wrote: Hello All: I have two mysqld runnning in ports: 3307 3308 respectively. I started the second one by using 'mysqld_multi start 2'. whereas mysqld running on port 3307 is the default mysqld started at the boot time. when i issue command such as: mysql -u root -p (it connects to my new mysqld running on 3307). Why is that it won't connect to mysqld running on port 3308. I also tried giving in port / socket options to mysql but to no luck! I cannot connect to mysqld running on port 3307 (default mysqld which is started at boot time) (anti-s_p_a_m_b_o_t fodder: database, query) MySQL runs with two methods of connection. The first is via Unix sockets (assuming that you are using Linux here). The second is via Internet sockets. The port numbers you have above apply only to Internet sockets. You should see two instances of MySQL running if you connect from a different machine. If you connect on the machine which is running the two instances, you'll need to specify host and port, or you'll need to make sure that the Unix sockets are in different places. For each instance, make sure that the default Unix socket location (usually something like /var/lib/mysql/mysql.sock or /tmp/mysql.sock) is different! MySQL will happily run with two instances using the same Unix socket. Unfortunately, your results may not be what you want. We run multiple instances all the time. The hard part is not configuring MySQL, it is getting the clients to talk to the right one :-) We set up a main directory where all the instances have subdirectories. You could use something like /databases. Put each instance into a subdirectory. We put the logs, Unix socket, pid file, configuration file and databases into directories of the main subdirectory: /database/instance1/etc/my.cnf config file /database/instance1/log/... log files /database/instance1/run/mysql.pid pid file /database/instance1/run/mysql.sock Unix socket /database/instance1/db_files/...database table files /database/instance2/etc/my.cnf config file ... etc... Then, if we are on the same machine and need to connect with the MySQL command-line client, we can just type this: $ mysql --defaults-file=/database/instance1/etc/my.cnf -u root -p... You could easily make wrapper scripts to make this easier: $ mysql_wrapper --instance=1 -uroot -p ... We run multiple instances for several reasons. The primary reason is that we need to take some down on a nightly basis for various purposes and others need to stay up. We cannot do this with a single instance. We can also control resource usage on a per-type-of-use basis. Some instances just perform dumb data logging, others are used for heavy queries. Best, Kyle - 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: Replication
I had converted an Access Database into MySQL format and it used autoincrement fields. I will try without the autoincrement and see what happens. Thanks -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 1:54 AM To: Granville A. Gayle Jnr. Cc: [EMAIL PROTECTED] Subject: Re: Replication On Sun, Jun 10, 2001 at 09:29:15AM -0400, Granville A. Gayle Jnr. wrote: I have just started to use MySQL and like the ease in which it does it's one way replication. However I have a situation that has multi-sites that would need to do local entry to a database and then update the centreal database which could then update those databases that don't have the changed/additional info. i.e. locations HEAD,A,B C. Entry done in A,B C. HEAD needs to be updated after entry in A,B C. Likewise A B needs data from C, B C needs data from A, C A needs data from B. Is there any known way to accomplish this with MySQL?? If I understand you correctly, this is a multi-master replication setup. One in which there are several peers which all should see each other's updates to the data. You can do this in MySQL as long as: (1) You are running one of the latest MySQL versions. (2) You have a unique server-id for each server. (3) You configure the servers in a replication ring where A is a slave of B, B is a slave of C, and C is a slave of A (for a 3-master setup). (4) You understand that some queries won't work well in this seutp. For example you can't reliably use AUTO_INCREMENT columns the way you normally might with only one master. Some of this is mentioned in the manual, I think. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 16 days, processed 105,706,229 queries (73/sec. avg) - 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 -- Scanned for VIRUSES Social Development Commission IT Support -- - 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: Setting up users!
On Mon, 11 Jun 2001, h3rb wrote: Ok. I have read the manual =) But one thing I am not clear on. Is if I can create a user who can create their own database's..modify them..and drop them if need be. But they wouldn't have access to any database on the server. I am asking because I host 4 different sites and 3 of them want mysql access. And I would not want to have to go and create a new database for these guys anytime they wanted. Or are there other ways around this? Thanks, h3rb I suggest you take an approach similar to sourceforge: - set up one or more mysql servers - on these servers set up a MySQL user for each Unix user - give user USER access to a database USER only All of this is done by executing the GRANT SQL command as a privileged user. Neil - 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
BDB
where can i found description of BDB messages writed in log and also what must be done in the case or maybe somebody can help and tell me what went wrong: bdb: Log sequence error: page LSN 1:2043982; previous LSN 1 2074929010608 21:12:22 bdb: Log sequence error: page LSN 1:2043982; previous LSN 1 2077028010608 21:12:22 bdb: ./fly_db/airports.db: close: 2 blocks left pinned i use mysql.3.23.36 / redhat linux 7.0 thanks - 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
breaking the 31 tables in a join limitation, round 2
Hello, I always have my problem with the 31 tables in a join limitation. In crash-me database comparaison page, I saw that mysqld 3.23.39 could manage up to 63 tables in a join. I didn't see in history log that the limite has been updated from 31 (in 3.23.36 version we use) to 63 tables. So, is it a new feature not yet listed in MySqld3.23.39 history log ? Is there a parameter in 3.23.36 version to change to be able to use up to 63 tables in a join ? Why only 63 tables, it not look like a C limitation??? infinite would have been better ;)) -- Best regards, SixK // \\ //Amiga spirit will never die \\/ mailto:[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: MYSQL error
Ok! thanks. I tried and with the prompt it seems to work. Effectively i have this error often, but sometime it works correctly. Maybe the packet it's too big? A. Scrive Rolf Hopkins [EMAIL PROTECTED]: You don't have to join the mailing list to send mail to the list. Send it to the list anyway and you may get a better response and there may even be someone who has come across this exact same problem. If you don't think it's IMP, are you able to log into the mysql prompt and run that exact same query from there? - Original Message - From: Aldo Spano [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED] Sent: Monday, June 11, 2001 21:27 Subject: Re: MYSQL error Thank you very much for answer. I removed from the list cause I received too much e-mail and basicly i'm not even on-line, so my mailbox becomes full in a white. IMP is a package wrote in PHP, for the management of mailbox with IMAP protocoll. I don't think the problem was IMP, cause, like I wrote you in the first email, with the old version of MYSQL works correctly. The DB's tables has the right fields, this is the making: CREATE TABLE active_sessions ( sid varchar(32) NOT NULL, name varchar(32) NOT NULL, val text, changed varchar(14) NOT NULL, PRIMARY KEY (name, sid), KEY changed (changed) ); Seems to be a problem for the socket, or maybe for the thread definitions. I tried to change the config file my.cnf and it works in a bad way. I really apreciate your interesting Thank you A. Scrive Rolf Hopkins [EMAIL PROTECTED]: Firstly, you should reply to the list as I may not know the answer. For starters I don't know IMP so if it is more of an IMP problem, I can't help you. The only thing I can think of is that your columns aren't defined properly to hold your data. For example, without looking at the manual, the only 2 column types I can think of, that would be suitable for the val column, are text and blob. - Original Message - From: Aldo Spano [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED] Sent: Friday, June 08, 2001 16:53 Subject: Re: MYSQL error I saw in the log that there is an error with the communication. This is a line from the log: 010608 4:30:07 Aborted connection 274940 to db: 'horde' user: 'hordemgr' host: `localhost' (Got an error reading communication packets) IMP is wrote with php and for this error in the page appear an error like: Database error (HordeDB): Invalid SQL: insert into active_sessions ( sid, name, val, changed ) values ('62f84000b07f13f8f8da50855c978199', 'HordeSession', 'base64:JHRoaXMtPmluID0gJyc7ICR0aGlzLT5wdCA9IGFycmF5KCk7ICR0aGlzLT5wdFsnaW1w J10gPSAnMSc7ICRHTE9CQUxTWydpbXAnXSA9IG5ldyBJbXBTZXNzaW9uOyAkR0xPQkFMU1snaW1w J10tPmRhdGEgPSBhcnJheSgpOyAkR0xPQkFMU1snaW1wJ10tPmRhdGFbJ3NlcnZlciddID0gJ2xv Y2FsaG9zdCc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsncG9ydCddID0gJzE0Myc7ICRHTE9CQUxT WydpbXAnXS0+ZGF0YVsnc2VydnR5cGUnXSA9ICdpbWFwJzsgJEdMT0JBTFNbJ2ltcCddLT5kYXRh Wyd1c2VyJ10gPSAnYWxkbyc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsncGFzcyddID0gJzRtbTFu MXN0cjR0MHIzJzsgJEdMT0JBTFNbJ2ltcCddLT5kYXRhWydtYWlsYm94J10gPSAnSU5CT1gnOyAk R0xPQkFMU1snaW1wJ10tPmRhdGFbJ2tleSddID0gJyc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsn bXNnbCddID0gJzExMTk6MTMyMToxMzM4OjEzNDU6MTM0NjoxMzc2OjEzODA6MTM4OToxMzkyOjEz OTM6MTM5NToxNDU3OjE0NjM6MTQ4MjoxNDg1OjE1MTE6MTUzNDoxNTU2OjE1NjE6MTU2NDoxNTY1 OjE1Njc6MTYxOToxNjIwOjE2NDU6MTY1MToxNjkwOjE2OTI6MTY5MzoxNzQxOjE3NDk6MTc3Njox NzkyOjE3OTM6MTgwMzoxODE0OjE4MTc6MTgyMToxODIyOjE4NDE6MTg2NjoxODY4OjE4NzM6MTkz MzoyMDA1OjIwMzI6MjA2MToyMDc4OjIxNDA6MjE2OToyMTk3OjIyMzc6MjI1ODoyMjY0OjIyNzM6 MjI3NDoyMzI1OjIzNTM6MjM1NjoyMzU3OjIzNTk6MjM2MDoyMzYyOjIzNzM6MjM3NToyMzc3OjIz Nzg6MjM4NzoyNDIxOjI0MjY6MjQ2NjoyNjE1OjI2NDg6MjY4ODoyNzk5OjI4MDA6MjgwMToyODAy OjI4MDM6MjgwNCc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsnZm9sZGVycyddID0gJyc7ICRHTE9C QUxTWydpbXAnXS0+ZGF0YVsnc29ydGJ5J10gPSAnMSc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0 YVsn c29ydGRpciddID0gJzAnOyAkR0xPQkFMU1snaW1wJ10tPmRhdGFbJ2RlbGhpZGUnXSA9ICcnOyAk R0xPQkFMU1snaW1wJ10tPmRhdGFbJ29mZnNldCddID0gJzAnOyAkR0xPQkFMU1snaW1wJ10tPmRh dGFbJ2Zyb21fc2VydmVyJ10gPSAnaXRhbGlhbi5pdCc7IA==', '20010608105204') Database error (HordeDB): Session: freeze() failed. Thanks Aldo Scrive Rolf Hopkins [EMAIL PROTECTED]: What is the error? - Original Message - From: Aldo Spano [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 07, 2001 21:34 Subject: MYSQL error I use mysql with IMP, a webmail application very nice and fast. Till I used the old version of Mysql 3.22.xx i had no problem. Now i upgrade to the new one and often i have problem with mysql cause it doesn't read the packet
Linking problem
Hi all, My ISP provides me with MySql version 3.23.36 on Red Hat Linux 5.2 box, gcc version is 2.7.2.1, libc version 5. When I try to compile my C application I get lots of errors. What is wrong ? Since this is not my own server, what should I ask my ISP to do in order to correct this? I mean, if the reason is old version of libc or gcc for example, and my ISP won't install a newer version, is there some workaround ? gcc -o test.cgi test.c cgihtml.a -I/usr/local/mysql/include -L/usr/local/mysql/lib -lmysqlclient -lz /usr/local/mysql/lib/libmysqlclient.a(libmysql.o): In function `net_safe_read': libmysql.o(.text+0x2bc): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(libmysql.o): In function `simple_command': libmysql.o(.text+0x46b): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(libmysql.o): In function `read_rows': libmysql.o(.text+0xa64): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(libmysql.o): In function `mysql_real_connect': libmysql.o(.text+0xe85): undefined reference to `__stpcpy' libmysql.o(.text+0x146c): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(libmysql.o)(.text+0x148a): more undefined references to `__stpcpy' follow /usr/local/mysql/lib/libmysqlclient.a(libmysql.o): In function `mysql_list_dbs': libmysql.o(.text+0x25cd): undefined reference to `__mempcpy' /usr/local/mysql/lib/libmysqlclient.a(libmysql.o): In function `mysql_list_tables': libmysql.o(.text+0x2675): undefined reference to `__mempcpy' /usr/local/mysql/lib/libmysqlclient.a(libmysql.o): In function `mysql_stat': libmysql.o(.text+0x29aa): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(violite.o): In function `vio_peer_addr': violite.o(.text+0x1d): undefined reference to `__mempcpy' /usr/local/mysql/lib/libmysqlclient.a(violite.o): In function `vio_poll_read': violite.o(.text+0x306): undefined reference to `poll' /usr/local/mysql/lib/libmysqlclient.a(my_open.o): In function `my_open': my_open.o(.text+0x17): undefined reference to `open64' /usr/local/mysql/lib/libmysqlclient.a(my_error.o): In function `my_error': my_error.o(.text+0x1ba): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(mf_pack.o): In function `pack_dirname': mf_pack.o(.text+0x1e5): undefined reference to `__stpcpy' mf_pack.o(.text+0x240): undefined reference to `__stpcpy' mf_pack.o(.text+0x29f): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(mf_pack.o): In function `cleanup_dirname': mf_pack.o(.text+0x401): undefined reference to `__stpcpy' mf_pack.o(.text+0x6cc): undefined reference to `__mempcpy' mf_pack.o(.text+0x725): undefined reference to `__stpcpy' mf_pack.o(.text+0x7ee): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(mf_pack.o): In function `unpack_filename': mf_pack.o(.text+0xa15): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(mf_pack.o): In function `intern_filename': mf_pack.o(.text+0xa5e): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(typelib.o): In function `find_type': typelib.o(.text+0x13d): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(typelib.o)(.text+0x174): more undefined references to `__stpcpy' follow /usr/local/mysql/lib/libmysqlclient.a(mf_format.o): In function `fn_format': mf_format.o(.text+0x20f): undefined reference to `__lxstat64' /usr/local/mysql/lib/libmysqlclient.a(default.o): In function `search_default_file': default.o(.text+0x4d9): undefined reference to `__stpcpy' default.o(.text+0x53f): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(default.o): In function `print_defaults': default.o(.text+0x95b): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(my_net.o): In function `my_inet_ntoa': my_net.o(.text+0x16): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(my_lib.o): In function `my_dir': my_lib.o(.text+0x1f7): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(my_lib.o)(.text+0x210): more undefined references to `__stpcpy' follow /usr/local/mysql/lib/libmysqlclient.a(my_lib.o): In function `my_dir': my_lib.o(.text+0x269): undefined reference to `readdir64' /usr/local/mysql/lib/libmysqlclient.a(my_lib.o): In function `directory_file_name': my_lib.o(.text+0x343): undefined reference to `__stpcpy' /usr/local/mysql/lib/libmysqlclient.a(my_lib.o): In function `my_stat': my_lib.o(.text+0x3a8): undefined reference to `__xstat64' /usr/local/mysql/lib/libmysqlclient.a(my_lib.o): In function `my_fstat': my_lib.o(.text+0x406): undefined reference to `__fxstat64' /usr/local/mysql/lib/libmysqlclient.a(my_fopen.o): In function `my_fopen': my_fopen.o(.text+0x1f): undefined reference to `fopen64' make: *** [test] Error 1 Thanks in advance, Mitko - Before posting, please check: http://www.mysql.com/manual.php
JDBC Issue After changing root password.
Hello, I have been using JDBC with MySQL for the past couple of days without any user id or password. After reading the directions in the privileges section I decided to change the password for root. I used the following example from the online manual: shell mysql -u root mysql mysql UPDATE user SET Password=PASSWORD('new_password') WHERE user='root'; mysql FLUSH PRIVILEGES; After doing this I was able to sign on to mysql as follows: mysql -u root -ptwosouth mysql This works fine and I am able to review the tables in the mysql database with the interactive client. Here is a snippet of java code that I am using to read a table from the database. try { System.out.println(Createing Connection); Connection Conn = DriverManager.getConnection( jdbc:mysql://165.121.243.45/test?user=rootpassword=twosouth); // jdbc:mysql://165.121.243.45/test); try { ... I get the following errors SQLException: Server configuration denies access to data source SQLState: 08001 VendorError: 0 Prior to changing the root password I was able to access the database with JDBC with no user or password. Now, I am unable to get a connection even with the correct user and password. What am I missing? Thanks in advance, Scott Salisbury - 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
Installation help
Hi, I downloaded the mysql-3.23.38 source rpm. When I try to build it I get the error message: checking for gcc... egcs checking whether the C compiler (egcs -O3 ) works... no configure: error: installation or configuration problem: C compiler cannot create executables. error: Bad exit status from /var/tmp/rpm-tmp.8977 (%build) RPM build errors: Bad exit status from /var/tmp/rpm-tmp.8977 (%build) I don't have an egcs. I do have the gcc-2.96-69 package working. What can I do to convince config to use gcc? Thanks, -- Bernd - 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
Procedures
From the docs, it doesn't look like too much has been done in the area of stored procedures. Are there any resources which would teach me or point me in the right direction to writing procedures for mysql? The manual mentions that it has facility for c++ procedures, but if you want to learn how to write them, you have to look at the code. Also, I have seen reference to Mylua which is a scripting language which allows the writing of procedures. Is there anything perlish? If not, how do I go about writing a perl interface for procedures? jvt - 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: another query, please help
At 12:23 PM +0530 6/11/01, Rohit Peyyeti wrote: Hello All: I am trying to access second mysql server which is running on port 3308 through java. Even when I specify port number in my connection, it still connecting to the database running on port 3307. When i try to access 2nd mysql server through command prompt it works! This is the way i access my 2nd mysql server through command prompt: 'mysql -u root -S/var/lib/mysql2/mysql.sock2 -P3308 -p' Whereas if I say: 'mysql -u root -p' It connects to my default mysql server running on port 3307. How do achieve this using JDBC? How do I connect to two different mysql servers? Using port numbers does not seem to help. Do I have to specify any socket file here too??? Have no idea here! Any Ponters? ...Rohit This question would be better posed to the MySQL Java mailing list. Your connnection URL should look something like this: jdbc:mysql://host_name:port_number/db_name -- Paul DuBois, [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
many tables in one database, impact on performance?
Hi folks, just another question. I have a lot of tables in one mysql-database (around 3200 for now) because I am running Phorum with a lot of boards. (yes I am working on it to split it in different databases but it can take a while). So my question is ... does that mass of tables in one database have some impact on the performance of mysql? Could it be, that it creates higher load on the server it is running? Thanks in advance, Thomas -- Thomas Seifert mailto:[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
Solved stunnel - replication still fails
Doing that, I'm now seeing: ERROR 2013: Lost connection to MySQL server during query after entering the password. Right. That was a client error. The server is the only thing which cares about the master.info file. Okay, this is solved - stunnel works better when compiled without libwrap, which can be done by changing #define HAVE_LIBWRAP 1 to #define HAVE_LIBWRAP 0 in its configure file before running it and assembling. You know that the tunnel is alive. Now I do ; ) You know that it works using the `mysql' command-line tool from the slave. Now it does. Given the same parameters (hostname, user, pass, etc), the MySQL server on the slave isn't happy. It's still reporting: | 1 | system user | none | NULL | Connect | 354| waiting to reconnect after a |failed read | NULL | Have also tried having the slave look for the 3307 tunnelled connection by machine name rather than localhost (which is required for the mysql client, but didn't need to do it before for replication - localhost worked). This did require removing the master.info file so it would be recreated with the change. Same result though. I suppose I should upgrade MySQL on the slave, but upgrading MySQL usually brings its own problems, and these versions aren't that far apart. Whit - 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: LEFT JOIN in MySQL Version 3.22.32
this: select tbl1.field1, tbl2.field2 from tbl1, tbl2 where tbl1.id = tbl2.id is the same thing as: select tbl1.field1, tbl2.field2 from tbl1 left join tbl2 on tbl1.id = tbl2.id - TIM Hi, unfortunately my provider still runs My SQL version 3.22.32 on his server. Apparently the LEFT JOIN statement does not work on this version. Anybody knows a workaround? Holger - 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 -- -TIM - 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
New JDBC3.0 driver for MySQL
Hi I and my friends we are going to write new JDBC driver for MySQL. Where can we get description of communication protocol between client and MySQL server? Tomek
Re: odbc on WinME
At 07:39 11/06/2001 -0700, Bob Andrews wrote: Hi, Assuming that: 1- You have the ODBC Data Source Administrator, means that your machine has already the ODBC core installed. 2- You ran the MyODBC setup for Win9x and something wrong happened. If the item 2 is true, verify if the myodbc.dll exists at /windows/system directory and apply the below batch file, editing the correct path for your machine environment: C:\\WINDOWS\\SYSTEM\\. Regards, Miguel rem -Author: Jim Michaels if errorlevel 1 goto bye rem create a .REG file to make registry entries echo REGEDIT4myodbc.reg echo.myodbc.reg echo [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\MySQL]myodbc.reg echo APILevel=2myodbc.reg echo ConnectFunctions=YYNmyodbc.reg echo Driver=C:\\WINDOWS\\SYSTEM\\myodbc.dllmyodbc.reg echo DriverODBCVer=02.50myodbc.reg echo FileExtns=*.txtmyodbc.reg echo FileUsage=0myodbc.reg echo Setup=C:\\WINDOWS\\SYSTEM\\myodbc.dllmyodbc.reg echo SQLLevel=1myodbc.reg echo.myodbc.reg echo [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]myodbc.reg echo MySQL=Installedmyodbc.reg echo.myodbc.reg rem -install the registry entries by executing the .REG file start /wait myodbc.reg rem clean up after we are done installing del myodbc.reg :bye I recently downloaded the ODBC client software for windows, ran setup, then went into the 'ODBC Data Source Administrator' from the control panel per the readme. I tried to add a new datasource, but MySQL was not in the list so apparently the setup program didn't work as expected. Any suggestions on what to check? (Just saying that this worked for you is not what I am looking for.) Perhaps there's a registry entry I should check? Thanks. - 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 -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Miguel A. Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Mogi das Cruzes - São Paulo, Brazil ___/ www.mysql.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: Field length problem!
hi, what did you assign the col type and what is the length... - Original Message - From: "Simon Abolnar" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 11, 2001 8:15 PM Subject: Field length problem! Hello! When I add record in database everything works OK. When I modify data in database using RS.Update function everything works OK again when I use the same or less length field that it was before. (lets say "123" to "456" or "45" o "4") The problem is when I use greater field length (my sql respond as error) (lets say "123" to "4567") What should I do to avoid this problem? Thanks all! Simon - 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: Field length problem!
On Mon, 11 Jun 2001 17:15:09 +0200, Simon Abolnar [EMAIL PROTECTED] wrote: What kind of data type is the column in questions?? VAR, CHAR,...etc.?? Hello! When I add record in database everything works OK. When I modify data in database using RS.Update function everything works OK again when I use the same or less length field that it was before. (lets say 123 to 456 or 45 o 4) The problem is when I use greater field length (my sql respond as error) (lets say 123 to 4567) What should I do to avoid this problem? Thanks all! Simon 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
mysqld --skip-networking and mysqlgui 1.7.5
Is mysqlgui capable of connecting to the mysqld daemon via a unix socket, or must it use the network. Mysqlgui appears to ignore the 'socket' option in the my.cnf file. Am I out of luck, or did I possibly make a mistake in the compile? thanks, bl -- //== Brett G. Lemoine -=- [EMAIL PROTECTED] ===\\ || Info. Systems Architect | _ __ __ Core|| ||Core Unix System Services|/ ___// / / / / __/ / __/Unix|| || Incyte Genomics | / /___/ /_/ / _\ \_ _\ \_ System || || Palo Alto, California | \___(_)(_)___(_)___(_)Services|| |+-+-+| \\== PGP Key Fingerprint: 68 A1 2A 2D 82 CE E9 70 5B 80 D1 11 EC F3 FB 85 ==// - 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 DBI install problem
Yes That was the trouble. Thanks I just upgraded the entire thing while I was at it, perl 5.6, DBI, mod_perl, embperl Thank you very much. I thought I did get the latest version. Maybe I go a pre-release version. Ruben On 2001.06.11 11:06:01 -0400 Dave FitzPatrick wrote: Ruben, I ran into the same thing on a Compaq Tru64 box last week. Version 1.1835 of the Msql-Mysql-modules is WAY out of date. For some reason it is still listed in the CPAN database if you try to install Bundle::Mysql or Bundle::Msql. Try again by: cpan install J/JW/JWIED/Msql-Mysql-modules-1.2216.tar.gz This way you will be sure to get the correct version. Hope this helps, D= On 11 Jun 2001, at 8:09, Brooklyn Linux Solutions [EMAIL PROTECTED] wrote: I have a slackware box with Apache Perl 5.6, DBI and mod_perl. I can't get the MYSQL DBI module to install. It's dieing on this line. I'm very perplexed. Ruben umask -a Linux vidor 2.2.13 #127 Thu Oct 21 13:13:20 CDT 1999 i686 unknown make[1]: Entering directory `/root/.cpan/build/Msql-Mysql-modules-1.1835/Mysql' cc -c -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI -I/usr/local/include/mysql -I../dbd -I/usr/local/lib/perl5/site_perl/5.6.1/i686-linux/auto/DBI -I/usr/local/lib/perl5/5.6.1/i686-linux -fno-strict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -DVERSION=\1.1835\ -DXS_VERSION=\1.1835\ -fpic -I/usr/local/lib/perl5/5.6.1/i686-linux/CORE -DDBD_MYSQL Mysql.xs: In function `XS_Mysql_listdbs': Mysql.xs:945: `sv_undef' undeclared (first use in this function) Mysql.xs:949: `dowarn' undeclared (first use in this function) Mysql.xs: In function `XS_Mysql_listtables': Mysql.xs:970: `sv_undef' undeclared (first use in this function) Mysql.xs:974: `dowarn' undeclared (first use in this function) Mysql.xs: In function `XS_Mysql_listfields': Mysql.xs:1005: `dowarn' undeclared (first use in this function) make[1]: *** [Mysql.o] Error 1 make[1]: Leaving directory `/root/.cpan/build/Msql-Mysql-modules-1.1835/Mysql' make: *** [subdirs] Error 2 -- Brooklyn Linux Solutions http://www.mrbrklyn.com http://www.brooklynonline.com 1-718-382-5752 -- Brooklyn Linux Solutions http://www.mrbrklyn.com http://www.brooklynonline.com 1-718-382-5752 - 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 -- Dave FitzPatrick [EMAIL PROTECTED] Webmaster 978-681-1599 Quantic Communications An MHI Company http://www.quantic.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 -- Brooklyn Linux Solutions http://www.mrbrklyn.com http://www.brooklynonline.com 1-718-382-5752 - 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: LEFT JOIN in MySQL Version 3.22.32
Hello, I use 3.22.32 on WinNT. Left Join works perfectly (I have one stmt that has 10 left joins). JohnC -Original Message- From: Holger Böhnke [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 7:44 AM To: mysql Subject: LEFT JOIN in MySQL Version 3.22.32 Hi, unfortunately my provider still runs My SQL version 3.22.32 on his server. Apparently the LEFT JOIN statement does not work on this version. Anybody knows a workaround? Holger - 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
Was wondering...
Hello: I was wondering if there is a simple way to put a ceiling on the maximun amount of memory that can be allocated to the mysqld process? Please advise. Thanks, jcd
multi platforms
We have linux/solaris mounted on the same data storage unit and I would like to install the mysql server once with the ability to evoke it from linux or solaris. Is this possible? --- --==- Sonia Van TasselSoftware EngineerInterWorking Labs ==--= 4113 Scotts Valley Drive, Suite 200 Scotts Valley, CA 95066 --==- [EMAIL PROTECTED] +1 831 430 3610 x23 +1 831 430 9144 Fax --- - 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
New JDBC3.0 driver fr MySQL
Hi I and my friends we are going to write new JDBC driver for MySQL. Where can we get description of communication protocol between client and server? Tomek
Re: Linking problem
Hello Dimitar I'm not a great linux programmer but I had few days ago similar problem. My advice is to try this: gcc -o test.cgi test.c cgihtml.a -I/usr/local/mysql/include -L/usr/local/mysql/lib -lz -lmysqlclient -lz The only change here is twice use of -lz. In my case that was _very_ important. I hope I helped. Good luck! Karol Majewski -- Ile zarabiasz? Wypelnij ankiete, dowiesz sie jak zarabiac wiecej [ http://listaplac.onet.pl ] - 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 would password not be recognized?
Well, getting stunnel clean now presents additional info in the *.err file on the slave: 010611 13:35:41 Error reading packet from server: Access denied for user: 'ftp@localhost' (Using password: YES) (0) This being repeated every minute implies it's from the replication connection, which is set for 60 second retries. What's perverse is that the password is _right_ in my.cnf on the slave, and I can connect as that /hostname/user/port/password to the master server using the mysql client with no problem. I can also of course connect from the mysql client on the master, using the user and password, and thus being 'ftp@localhost' as far as it is concerned. What would replication be basing denial of access on that wouldn't apply to the mysql client? Meanwhile in the master's *.err: 010611 13:46:15 Aborted connection 612 to db: 'ftp' user: 'ftp' host: `localhost' (Got an error reading communication packets) - not sure this is the same though, it's less than once-a-minute, although there's far too much of it - about 2-3 times in 5 minutes - whatever the problem is. There's no apparent functional problem with the database use on the server though. Restarting both servers makes no difference. What am I missing? Whit - 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
Problems with MyODBC and dateformat
hallo i use VB6 - ADO 2.6 with the newest MyODBC with options 16834 even when make a select on a date or time type columne i get the windows-format 24.12.2001 , but the format is realy -MM-DD. So i get a lot of trouble.. what i have to do, that i get the right date/time-format(-MM-DD) ??? --database,sql,query
Re: (sleeping) processes of 90% CPU
On Sun, Jun 10, 2001 at 01:15:38PM +0300, Sinisa Milivojevic wrote: Hello, I'm a database administrator for a hosting provider, and we have currently 2 SMP MySQL-database servers. The one that is causing me problems, has at least 900 databases running on it. That's an dual PIII-550, with 1024MB memory, running RedHat 6.2, with Linux 2.4.5-ac4. During working hours, a load of 5 6 is pretty default, with about 600 mysqld processes. This is already reduced from 900 to 600, by setting the wait-timeout to 600 seconds, to 120, to 30 at the moment. The problem is that the server is in an unstable situation lately. I see a lot of MySQL-processes with top (sorted by MEM-usage), that are taking over 90% CPU. If I strace -p PID the process, it returns me nothing. I assume this is a sleeping process. RSS sometimes is 120M, most of the time between 20 and 40M. No change in running 3.22.32, 3.23.31 - 3.23.38 (.38 currently). Anyone has a hint on what happens ? SHOW PROCESSLIST gives me for 90% Sleeping as output. Here is (partially) my /etc/my.cnf : skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=1M set-variable= table_cache=512 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 set-variable= thread_concurrency=4 set-variable= myisam_sort_buffer_size=64M set-variable= max_connections=1250 set-variable= max_connect_errors=9 set-variable= wait_timeout=30 Hi! This is most probably mutex contention problem. Please use our binary, or patch your LinuxThreads with a patch on our site. Hmm, I patched glibc 2.1.3 with the patch on your site, then recompiled MySQL. No change, still huge processes. : I then tried the binary version, that didn't help too. I really don't know what to look for anymore : I can replace the hardware, but I don't think that will change anything... *hoping for hints :* -- Regards, For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com -- Met vriendelijke groet/With kind regards, Cable Wirelesshttp://www.widexs.nl Wouter de Jong System-Administrator Tel +31 23 5698070 Fax +31 23 5698099 Bijlmermeerstraat 62, 2131 HG HOOFDDORP, NL - 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
Delete FROM Table does not function correctly
I am running MySql 3.23.38, Slackware Linux 7.1 (custom Kernel 2.4.4), PhP 4.0.5, and Apache 1.3.19. I have found what I believe is a bug with this release of MySql. When I try to delete an entry from a table (DELETE FROM articles WHERE article_id = '3') the database only deletes the article_id which is a primary key. It leaves the rest of the entry data in the table. This creates a problem when I no longer want certain records in my database. I have tried in multiple versions of MySql, and 3.23.38 seems to be the only version that has this particular bug. Has anyone else experienced this issue? Please let me know how to fix this problem. Thanks in advance, David - 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: LEFT JOIN in MySQL Version 3.22.32
Careful here, a left join is not necessarily the same as a join. In particular a left join will return rows for the left table even if there are no matching rows in the right table. Under many conditions the two are identical but definitely not always. That being said, maybe one could use temp tables? I see several issues in the change logs regarding left joins but I do believe they were available for 3.22.32. Good luck, Jeff -Original Message- From: Tim [mailto:[EMAIL PROTECTED]] Sent: Monday, June 11, 2001 12:03 PM To: Holger Bohnke Cc: mysql Subject: Re: LEFT JOIN in MySQL Version 3.22.32 this: select tbl1.field1, tbl2.field2 from tbl1, tbl2 where tbl1.id = tbl2.id is the same thing as: select tbl1.field1, tbl2.field2 from tbl1 left join tbl2 on tbl1.id = tbl2.id - TIM Hi, unfortunately my provider still runs My SQL version 3.22.32 on his server. Apparently the LEFT JOIN statement does not work on this version. Anybody knows a workaround? Holger - 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 -- -TIM - 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: Kinda unrelated
That would be an apache question. If you look in the Apache Docs for instructions on how to do use directories (www.host.com/~user) I think that might point you in the right direction. In short, getting Apache to read the user's homedir out of a MySQL database would require modifying Apache itself, I believe j- k- On Saturday 09 June 2001 15:52, James Greene wrote: Hi All, I know this is not completely a mysql question, but it is related. I am trying to do all my authentication based out of a mysql database. Works great for radius, and ftp. Problem is, I can't figure out how to get apache to read where a users homeridr is out of mysql. It still looks in the passwd file. I can't see how I could use mod_auth_mysql for this. Anyone have any thoughts, or know where else I should ask ? Jim G -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - 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 get started
I downloaded the file mysql-3.23.38-sun-solaris2.7-sparc.tar.gz last Friday. I followed the installation instructions, except that mysql is installed in /export/mysql since I don't control /usr/local. The file mysqlbug doesn't exist anywhere in my distribution. The scripts subdirectory only has mysql_install_db. The command mysql_install_db gave me messages that it couldn't find my hostname (organa), so I needed to use ip address instead of hostname to set permissions. It also said it couldn't create the grant tables. Later, the command safe_mysqld --user=mysql gives an syntax error message for bin/my_print_defaults, and mysql promptly quits. Detailed messages follow. Thanks in advance. Barbara Baughman 972-883-2157 The error messages from mysql_install_db are: --- organa:/export/mysql/mysql# scripts/mysql_install_db ./bin/my_print_defaults: syntax error at line 1: `(' unexpected WARNING: The host 'organa' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ./bin/mysqld: syntax error at line 1: `(' unexpected Installation of grant tables failed! organa:/export/mysql/mysql# scripts/mysql_install_db ./bin/my_print_defaults: syntax error at line 1: `(' unexpected WARNING: The host 'organa' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ./bin/mysqld: syntax error at line 1: `(' unexpected Installation of grant tables failed! --- The error message from safe_mysql --user=mysql are: - organa:/export/mysql/mysql# bin/safe_mysqld --user=mysql [1] 18023 ./bin/my_print_defaults: syntax error at line 1: `(' unexpected organa:/export/mysql/mysql# Starting mysqld daemon with databases from /export/mysql/mysql-3.23.38/data 010611 14:30:39 mysqld ended - 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
hello?
I didn't get a confirmation mail or anything so here goes ... I'm trying to compile a simple C program to access a db and dump out the info (for testing purposes). Here is what I get when I try to compile it: ebulon:/var/www/www.miester.org/cgi-bin# gcc -g -o miesterc miesterc.c -I/usr/local/mysql/include/mysql -L/usr/local/mysql/lib -lmysqlclient -lsocket -lnsl /usr/bin/ld: cannot find -lsocket collect2: ld returned 1 exit status I have installed the deb package socket ... not sure what I need to do from here (I'm somewhat new to C as well ...) Thanks for any help and please cc me since I'm not sure if I'm on the list yet. Thanks! --Joe Joe Stump [EMAIL PROTECTED] To each his own - My own is GNU/Linux --Joe Stump - 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: Procedures
Hi: There is a perl module for MySQL you can download from cpan. It provides the interface to MySQL database you can use to connect, execute SQL statements from perl programs. Seung-woo Nam John Tsangaris wrote: From the docs, it doesn't look like too much has been done in the area of stored procedures. Are there any resources which would teach me or point me in the right direction to writing procedures for mysql? The manual mentions that it has facility for c++ procedures, but if you want to learn how to write them, you have to look at the code. Also, I have seen reference to Mylua which is a scripting language which allows the writing of procedures. Is there anything perlish? If not, how do I go about writing a perl interface for procedures? jvt - 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
compile error
Hi, I'm developing an application with mysqlclient library, my code is right but i get an error: /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function 'my_uncompress': my_compress.o(.text+0x9a): undefined reference to 'uncompress' /usr/lib/mysql/libmysqlclient.a(my_compress.o): In function 'my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to 'compress' i'm using Linux Red Hat 6.2, mysql 3.23.35, mysql-devel-3.23.38-1, gcc version egcs-2.91.66 i'm very new in Linux programming and i really need help! thanks in advance. José -- Obtén gratis tu cuenta de correo en StarMedia Email. ¡Regístrate hoy mismo!. http://www.starmedia.com/email -- - 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
3.23.39 somewhere?
Hi all, a bugfixed MySQL version 3.23.39 was announced on Freshmeat on June, 7th, but there is no announcement on the list and nothing on the site. Was it a premature announcement? Michael - 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: Delete FROM Table does not function correctly
on 6/11/01 15:13, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: I am running MySql 3.23.38, Slackware Linux 7.1 (custom Kernel 2.4.4), PhP 4.0.5, and Apache 1.3.19. I have found what I believe is a bug with this release of MySql. When I try to delete an entry from a table (DELETE FROM articles WHERE article_id = '3') the database only deletes the article_id which is a primary key. It leaves the rest of the entry data in the table. This creates a problem when I no longer want certain records in my database. I have tried in multiple versions of MySql, and 3.23.38 seems to be the only version that has this particular bug. Has anyone else experienced this issue? Please let me know how to fix this problem. Thanks in advance, David - 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 Have you tried ( DELETE * FROM articles WHERE article_id = '3' ) ? -- Barry C. Hawkins Systems Consultant, MCSE 4.0 [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
Replication getting a Signal 16
I am running 3.23.33 master/ 1 slave config on Caldera eDesktop 2.4 system. I had not examined the error logs on the slave for sometime but was looking them over because the slave thread crashed on a bad query (not related to my question). I found the error message 'Received a Signal 16 on replication thread x' where x was the current slave thread about once every 30 seconds for a month... Does anyone know what a Signal 16 is ? I will be upgrading the install to 2.23.38 but would still like to know what I had danh - 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
How to get my shell readline settings in mysql command line tool?
Hello all, I use the bash shell and the vi editing mode (set -o vi) in my .inputrc. On one of my boxes, I managed to get the command line tool (mysql) to honour that setting. However, I have forgotten how I did that. Does anyone know how to do that? - 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
Table won't update
The table sitesats won't update and shows no errors! (even though there are two instances of echo(mysql_error())) html body ?php require('../common.php'); if (!isset($areview)) { echo(You must review the site); } else { if (!isset($apositive)) { echo(You must review the site); } else { if (!isset($anegative)) { echo(You must review the site); } else { connectdb(); mysql_select_db(xtopsites); $sql = update sitesats set arate='$arate', areview='$areview', apositive='$apositive', anegative='$anegative', validated='2' where id='$id'; $query = mysql_query($sql); echo(mysql_error()); if (!$query) { echo(mysql_error()); } else { echo(Review stored successfully.); } } } } ? /body /html Any ideas?
Re: Pornographer will trade for Help with web based MySql
So I had some expensive fun, eh? John 'TPG' Smith wrote: Very nice of you to take your very expensive time to write me an idiotic message. TPG - Original Message - From: jay downs [EMAIL PROTECTED] To: John 'TPG' Smith [EMAIL PROTECTED] Sent: Monday, June 11, 2001 6:08 AM Subject: Re: Pornographer will trade for Help with web based MySql I've got some sweeping up around the office you might be able to do. That'd be alot of sweeping to meet my hourly rate. Jay D John 'TPG' Smith wrote: I am interested in learning MySql and cgi. I want to trade my services for this help. I want to be able to make custom web based applications. I am a pornographer. TPG [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 get started
You might have issues with the 'environment' you're setup with... What 'shell' are you using (especially when you performed the installation) ?? Isn't /export an 'NFS mounted' area ? (will this cause issues with the installation ?) Can you 'resolve' (lookup) your system name yourself ? (i.e. nslookup organa) If not, you might want to fix this in case it's causing additional problems (or the result of). What system and 'O/S' are you actually using (type uname -a and send me the result). did you download the correct 'binary' package ? - Original Message - From: Barbara Baughman [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 11, 2001 12:47 PM Subject: Can't get started I downloaded the file mysql-3.23.38-sun-solaris2.7-sparc.tar.gz last Friday. I followed the installation instructions, except that mysql is installed in /export/mysql since I don't control /usr/local. The file mysqlbug doesn't exist anywhere in my distribution. The scripts subdirectory only has mysql_install_db. The command mysql_install_db gave me messages that it couldn't find my hostname (organa), so I needed to use ip address instead of hostname to set permissions. It also said it couldn't create the grant tables. Later, the command safe_mysqld --user=mysql gives an syntax error message for bin/my_print_defaults, and mysql promptly quits. Detailed messages follow. Thanks in advance. Barbara Baughman 972-883-2157 The error messages from mysql_install_db are: --- organa:/export/mysql/mysql# scripts/mysql_install_db ./bin/my_print_defaults: syntax error at line 1: `(' unexpected WARNING: The host 'organa' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ./bin/mysqld: syntax error at line 1: `(' unexpected Installation of grant tables failed! organa:/export/mysql/mysql# scripts/mysql_install_db ./bin/my_print_defaults: syntax error at line 1: `(' unexpected WARNING: The host 'organa' could not be looked up with resolveip. This probably means that your libc libraries are not 100 % compatible with this binary MySQL version. The MySQL deamon, mysqld, should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ./bin/mysqld: syntax error at line 1: `(' unexpected Installation of grant tables failed! --- The error message from safe_mysql --user=mysql are: - organa:/export/mysql/mysql# bin/safe_mysqld --user=mysql [1] 18023 ./bin/my_print_defaults: syntax error at line 1: `(' unexpected organa:/export/mysql/mysql# Starting mysqld daemon with databases from /export/mysql/mysql-3.23.38/data 010611 14:30:39 mysqld ended - 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
install problem
Hi all, Installing mysql on solaris 6 sun4u sparc SUNW,Ultra-5_10 release: -- mysql-3.23.38.tar.gz via ./configure --prefix=/dir --with-low-memory make make install I get to: yacc -d sql_yacc.yy mv y.tab.c sql_yacc.cc sql_yacc.yy, line 71: fatal: invalid escape, or illegal reserved word: pure_parser make[2]: *** [sql_yacc.cc] Error 1 make[2]: Leaving directory `/home/smith/solaris.6/mysql/sql' make[1]: *** [install-recursive] Error 1 make[1]: Leaving directory `/home/smith/solaris.6/mysql/sql' make: *** [install-recursive] Error 1 Any ideas? thanks - 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: Was wondering...
On Mon, Jun 11, 2001 at 01:49:48PM -0400, Jude C. Divierte wrote: Hello: I was wondering if there is a simple way to put a ceiling on the maximun amount of memory that can be allocated to the mysqld process? The various memory related options in the my.cnf file give you a fair amount of control over it, yes. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 17 days, processed 112,778,094 queries (75/sec. avg) - 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: load_defaults Strangeness
Sinisa Milivojevic wrote: Van writes: Greetings: With the following code, I have 3 problems: 1../client -psecret works, but, ./client --password=secret does not; 2.After calling load_defaults, the argument vector is getting parsed, but, it's not making it into the switch processing. The values from my global char *password = NULL values are being used; 3.Compiler warnings related to the struct variables. I've also tried: {password,optional_argument, 0, p}, with the same result. I didn't see anything in getopt.h that would explain this. Using the one from sampdb/capi used in Paul's book. main.c:38: warning: initialization makes integer from pointer without a cast Can anyone see where the error(s) is/are? Full source is at http://az.dedserius.com/main.c/ Regards, Van Hi! What you have described works just fine with mysql client program. Just copy the relevant parts from it and your program will work in the same fashion. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com Sinisa: Thanks for the response. The flawed version was: struct option long_options[] = { {CALL_TYPE, optional_argument, NULL, T}, {HOSTNAME,optional_argument, NULL, H}, {user,optional_argument, NULL, u}, {CLIENT_BUSINESS, optional_argument, NULL, C}, {BTIME_HOST, optional_argument, NULL, B}, {password,optional_argument, NULL, p}, {showvars,no_argument, NULL, s}, {testing, no_argument, NULL, t}, {repair,no_argument, NULL, r}, {help,no_argument, NULL, h}, {version, no_argument, NULL, v}, {0,0,0,0} }; Correct version: struct option long_options[] = { {CALL_TYPE, optional_argument, NULL, 'T'}, {HOSTNAME,optional_argument, NULL, 'H'}, {user,optional_argument, NULL, 'u'}, {CLIENT_BUSINESS, optional_argument, NULL, C'}, {BTIME_HOST, optional_argument, NULL, 'B'}, {password,optional_argument, NULL, 'p'}, {showvars,no_argument, NULL, 's'}, {testing, no_argument, NULL, 't'}, {repair,no_argument, NULL, 'r'}, {help,no_argument, NULL, 'h'}, {version, no_argument, NULL, 'v'}, {0,0,0,0} }; Single quotes need to be around the 4th argument, not double quotes. Regards, Van -- = Linux rocks!!! http://www.dedserius.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: Table won't update
Here are some ideas for an improved debugging methodology. First, take the query that you think should be working, substitute in hard-coded values, and test it through the mysql command-line client interface. So, for example, run the update sitesats set... query and use hard-coded values for $arate, $areview, $apositive, and so on. Check whether the rows you expected to be updated were updated. If that works, then you know it's not the query as such. Next, take the exact same query and place it in your PHP document. Still refrain from doing any variable substitutions. Verify again that the update worked. Finally, one by one, add the variables back in. Maurice Aubrey On Mon, Jun 11, 2001 at 05:39:43PM -0700, Vladimir Kravtsov wrote: The table sitesats won't update and shows no errors! (even though there are two instances of echo(mysql_error())) html body ?php require('../common.php'); if (!isset($areview)) { echo(You must review the site); } else { if (!isset($apositive)) { echo(You must review the site); } else { if (!isset($anegative)) { echo(You must review the site); } else { connectdb(); mysql_select_db(xtopsites); $sql = update sitesats set arate='$arate', areview='$areview', apositive='$apositive', anegative='$anegative', validated='2' where id='$id'; $query = mysql_query($sql); echo(mysql_error()); if (!$query) { echo(mysql_error()); } else { echo(Review stored successfully.); } } } } ? /body /html 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: mysqld keeps falling over on NetBSD
On Monday 11 June 2001 08:30, Haapanen, Tom wrote: Our normally reliable back-end server for our web site has now gone completely crazy ... it's falling over every few seconds. Automatic restarts are nice, but it really makes the web site unusable. 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. 010611 10:06:28 mysqld restarted /usr/local/libexec/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. 010611 10:06:30 mysqld restarted /usr/local/libexec/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. 010611 10:06:32 mysqld restarted /usr/local/libexec/mysqld: ready for connections There is very little information available here. I have tried check table, and myisamchk with -r, -o and -e options ... and no help. This is running MySQL 3.23.36 on NetBSD/i386 1.4.1. Are there any significant bug fixes in 3.23.38 to make it worthwhile downloading, building and installing it? There are, of course, bugfixes in 3.23.38 that make it worth downloading. If there were not, we would not have released it :-) However, I would not think that you are hitting one of the bugs we fixed. Unfortunately, our internal backtracer works only on Linux, so on NetBSD you are just getting the info that SIGSEGV was received, but no more details. The frequency of coredumps, though, indicates that very likely, the problem is something like a bad/wrong shared library, bad kernel, bad RAM, etc. We also are aware of the following phenomenon that we have still been unable to explain rationally: If you compile with gcc and do CXX=gcc ( this forces exclusion of libstdc++ from linking) and CXXFLAGS=-fno-exceptions -fno-rtti ( one turns off exceptions, the other turns off dynamic casts) strange problems tend to disappear. At this point not sure which extra baggage feature causes the problems - it is very possible that all three do. However, this really does not matter - MySQL does not need any of the three at all, and you get a cleaner binary anyway if you turn them off. I have tried to investigate the issue and looked for the culprit code that gets executed behind the scenes ( MySQL itself never calls libstdc++ routines, never uses exceptions, and never does dynamic casts) that could cause a problem with threads, but have not spent enough time to find it. -- MySQL Development Team For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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
Re: compile error
Hi José Could you give us some more information ? Something like gcc -I/usr. Generally you didn't point the compiler which library to use or where is it or simply did it in wrong order. I think so but I'm not 100% sure of it because I'm a novice too ;-) Regards Karol Majewski query / sql / database -- Ile zarabiasz? Wypelnij ankiete, dowiesz sie jak zarabiac wiecej [ http://listaplac.onet.pl ] - 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: Installation help
Is that a Red Hat gcc? There was a famous version they put out with 7.0 that's broken for a lot of things - but I don't recall the gcc version number. I've compiled MySQL just fine with gcc version 2.95.2 on Debian (aside from MySQL needing some help finding zlib). If you go to gnu.org and download their latest stable gcc, that will also quite automatically compile and install on most systems in just a few steps (and a lot of waiting on your CPU during the compile). Can solve problems from using distro gcc's sometimes, and you can keep two gccs on a system just by setting up a gcc symlink, in case you have reason to switch back. Whit On Mon, Jun 11, 2001 at 12:23:03PM -0400, Bernd Prager wrote: Hi, I downloaded the mysql-3.23.38 source rpm. When I try to build it I get the error message: checking for gcc... egcs checking whether the C compiler (egcs -O3 ) works... no configure: error: installation or configuration problem: C compiler cannot create executables. error: Bad exit status from /var/tmp/rpm-tmp.8977 (%build) RPM build errors: Bad exit status from /var/tmp/rpm-tmp.8977 (%build) I don't have an egcs. I do have the gcc-2.96-69 package working. What can I do to convince config to use gcc? Thanks, -- Bernd - 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
Elapsed time
Ver 8.0, Distrib 3.22.32. I have two fields in a table that are TIMESTAMP fields. I'd like to show the amount of elapsed time between the two timestamps in a human readable format. For example, I'd like to print 'Elapsed time: 1 year 4 months 27 days 9 hours 13 minutes 42 seconds. ' Or perhaps 1-4-27 9:13:42. I've tried SELECT SEC_TO_TIME(date2 - date1) from myfile Differences of more than 24 hours appear to accumulate in the hours field - it show things like 225:18:07. I've also tried select FORMAT_DATE((date2 - date1), '%Y-%c-%e %T') from myfile. most records return NULL.. Can an SQL query calculate and display the elapsed time? If so, could you provide a simple example? If this isn't feasible, I can certainly calculate the difference in the code if need be. Thank you. Regards, Rich - 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
Auto Increment
Ver 8.0, Distrib 3.22.32 I have a customer file, keyed by an auto-increment customer number. Customers can have orders. The order file is keyed by an auto-increment order sequence number, which works fine, but is not convenient. Rather, I would like the order sequence number to start at 1 for each customer, and have two keys on the order file, customer id, followed by order sequence. I would like the database to enforce uniqueness on this key pair. I don't think the built in auto-increment field can support this kind of mechanism, so - What is a safe, efficient way to find the customers highest order number, increment it by one, and write the new order record? I need to be absolutely sure that if ten people enter a new order all for the same customer at (nearly) the same time, they all get a unique order number. Thank you for your advice. Regards, Rich - 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: Please Help
Can someone please help with this database problem. - Original Message - From: [EMAIL PROTECTED] To: Iceberg Media [EMAIL PROTECTED] Sent: Monday, June 11, 2001 8:56 PM Subject: Re: Please Help Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: This is a multi-part message in MIME format. --=_NextPart_000_000B_01C0F2B9.3F76DD80 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Can some please tell me how to fix the below problem and how to avoid in = in other fields? Duplicate entry 'tim' for key 1 Thanks Tim --=_NextPart_000_000B_01C0F2B9.3F76DD80 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; = charset=3Diso-8859-1 META content=3DMSHTML 5.50.4134.600 name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVFONT size=3D2Can some please tell me how to fix the below problem = and how=20 to avoid in in other fields?/FONT/DIV DIVFONT size=3D2/FONTnbsp;/DIV DIVDuplicate entry 'tim' for key 1/DIV DIVnbsp;/DIV DIVFONT size=3D2Thanks/FONT/DIV DIVFONT size=3D2/FONTnbsp;/DIV DIVFONT size=3D2Tim/FONT/DIV/BODY/HTML --=_NextPart_000_000B_01C0F2B9.3F76DD80-- - 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
Okay, now the binary log is open and not open at same time
Okay, password was not recognized because I had the tunnel working with the f.q. server name rather than localhost (whereas the mysql client on the slave will _only_ work with the tunnel if it is by the fq server name, since localhost just goes to the local machine regardless of socket). But reverting to 'localhost' for the slave gets me to: 010611 20:40:52 Error reading packet from server: Binary log is not open (0) Which doesn't seem right because my.cnf is specifying the binary log the same as it ever did (when I was running an earlier MySQL version on the machine in the master position). In fact I just went to the binary log file and checked it and it's capturing fresh transactions just fine. Admittedly, I'm getting a lot of things wrong along the trail trying to tweak stuff to get whatever's really wrong right. But what the heck am I missing?? Is there really some way the binary log can be open for writing but not for reading, or is the error message in error? Whit - 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 error
There are settings that could probably fix the problem then but I would need to RTFM. - Original Message - From: Aldo Spano [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, June 12, 2001 0:03 Subject: Re: MYSQL error Ok! thanks. I tried and with the prompt it seems to work. Effectively i have this error often, but sometime it works correctly. Maybe the packet it's too big? A. Scrive Rolf Hopkins [EMAIL PROTECTED]: You don't have to join the mailing list to send mail to the list. Send it to the list anyway and you may get a better response and there may even be someone who has come across this exact same problem. If you don't think it's IMP, are you able to log into the mysql prompt and run that exact same query from there? - Original Message - From: Aldo Spano [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED] Sent: Monday, June 11, 2001 21:27 Subject: Re: MYSQL error Thank you very much for answer. I removed from the list cause I received too much e-mail and basicly i'm not even on-line, so my mailbox becomes full in a white. IMP is a package wrote in PHP, for the management of mailbox with IMAP protocoll. I don't think the problem was IMP, cause, like I wrote you in the first email, with the old version of MYSQL works correctly. The DB's tables has the right fields, this is the making: CREATE TABLE active_sessions ( sid varchar(32) NOT NULL, name varchar(32) NOT NULL, val text, changed varchar(14) NOT NULL, PRIMARY KEY (name, sid), KEY changed (changed) ); Seems to be a problem for the socket, or maybe for the thread definitions. I tried to change the config file my.cnf and it works in a bad way. I really apreciate your interesting Thank you A. Scrive Rolf Hopkins [EMAIL PROTECTED]: Firstly, you should reply to the list as I may not know the answer. For starters I don't know IMP so if it is more of an IMP problem, I can't help you. The only thing I can think of is that your columns aren't defined properly to hold your data. For example, without looking at the manual, the only 2 column types I can think of, that would be suitable for the val column, are text and blob. - Original Message - From: Aldo Spano [EMAIL PROTECTED] To: Rolf Hopkins [EMAIL PROTECTED] Sent: Friday, June 08, 2001 16:53 Subject: Re: MYSQL error I saw in the log that there is an error with the communication. This is a line from the log: 010608 4:30:07 Aborted connection 274940 to db: 'horde' user: 'hordemgr' host: `localhost' (Got an error reading communication packets) IMP is wrote with php and for this error in the page appear an error like: Database error (HordeDB): Invalid SQL: insert into active_sessions ( sid, name, val, changed ) values ('62f84000b07f13f8f8da50855c978199', 'HordeSession', 'base64:JHRoaXMtPmluID0gJyc7ICR0aGlzLT5wdCA9IGFycmF5KCk7ICR0aGlzLT5wdFsnaW1w J10gPSAnMSc7ICRHTE9CQUxTWydpbXAnXSA9IG5ldyBJbXBTZXNzaW9uOyAkR0xPQkFMU1snaW1w J10tPmRhdGEgPSBhcnJheSgpOyAkR0xPQkFMU1snaW1wJ10tPmRhdGFbJ3NlcnZlciddID0gJ2xv Y2FsaG9zdCc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsncG9ydCddID0gJzE0Myc7ICRHTE9CQUxT WydpbXAnXS0+ZGF0YVsnc2VydnR5cGUnXSA9ICdpbWFwJzsgJEdMT0JBTFNbJ2ltcCddLT5kYXRh Wyd1c2VyJ10gPSAnYWxkbyc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsncGFzcyddID0gJzRtbTFu MXN0cjR0MHIzJzsgJEdMT0JBTFNbJ2ltcCddLT5kYXRhWydtYWlsYm94J10gPSAnSU5CT1gnOyAk R0xPQkFMU1snaW1wJ10tPmRhdGFbJ2tleSddID0gJyc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsn bXNnbCddID0gJzExMTk6MTMyMToxMzM4OjEzNDU6MTM0NjoxMzc2OjEzODA6MTM4OToxMzkyOjEz OTM6MTM5NToxNDU3OjE0NjM6MTQ4MjoxNDg1OjE1MTE6MTUzNDoxNTU2OjE1NjE6MTU2NDoxNTY1 OjE1Njc6MTYxOToxNjIwOjE2NDU6MTY1MToxNjkwOjE2OTI6MTY5MzoxNzQxOjE3NDk6MTc3Njox NzkyOjE3OTM6MTgwMzoxODE0OjE4MTc6MTgyMToxODIyOjE4NDE6MTg2NjoxODY4OjE4NzM6MTkz MzoyMDA1OjIwMzI6MjA2MToyMDc4OjIxNDA6MjE2OToyMTk3OjIyMzc6MjI1ODoyMjY0OjIyNzM6 MjI3NDoyMzI1OjIzNTM6MjM1NjoyMzU3OjIzNTk6MjM2MDoyMzYyOjIzNzM6MjM3NToyMzc3OjIz Nzg6MjM4NzoyNDIxOjI0MjY6MjQ2NjoyNjE1OjI2NDg6MjY4ODoyNzk5OjI4MDA6MjgwMToyODAy OjI4MDM6MjgwNCc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0YVsnZm9sZGVycyddID0gJyc7ICRHTE9C QUxTWydpbXAnXS0+ZGF0YVsnc29ydGJ5J10gPSAnMSc7ICRHTE9CQUxTWydpbXAnXS0+ZGF0 YVsn c29ydGRpciddID0gJzAnOyAkR0xPQkFMU1snaW1wJ10tPmRhdGFbJ2RlbGhpZGUnXSA9ICcnOyAk R0xPQkFMU1snaW1wJ10tPmRhdGFbJ29mZnNldCddID0gJzAnOyAkR0xPQkFMU1snaW1wJ10tPmRh dGFbJ2Zyb21fc2VydmVyJ10gPSAnaXRhbGlhbi5pdCc7IA==', '20010608105204') Database error (HordeDB): Session: freeze() failed. Thanks Aldo Scrive Rolf Hopkins [EMAIL PROTECTED]: What is the error? - Original Message
RE: Q: max value?
SELECT max(fieldname) FROM table; Hi! Does anybody knows how can I check whether the max value in some database's field has been reached? For example, I have MEDIUMINT column and I want to reset its value once it reaches its maximum, that is 8388607. How can I check which is the maximum (min) value I can insert into field? - 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: Table won't update
Will the update statement work under the mysql prompt? - Original Message - From: Vladimir Kravtsov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 12, 2001 8:39 Subject: Table won't update The table sitesats won't update and shows no errors! (even though there are two instances of echo(mysql_error())) html body ?php require('../common.php'); if (!isset($areview)) { echo(You must review the site); } else { if (!isset($apositive)) { echo(You must review the site); } else { if (!isset($anegative)) { echo(You must review the site); } else { connectdb(); mysql_select_db(xtopsites); $sql = update sitesats set arate='$arate', areview='$areview', apositive='$apositive', anegative='$anegative', validated='2' where id='$id'; $query = mysql_query($sql); echo(mysql_error()); if (!$query) { echo(mysql_error()); } else { echo(Review stored successfully.); } } } } ? /body /html 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: Auto Increment
I have a customer file, keyed by an auto-increment customer number. Customers can have orders. The order file is keyed by an auto-increment order sequence number, which works fine, but is not convenient. Rather, I would like the order sequence number to start at 1 for each customer, and have two keys on the order file, customer id, followed by order sequence. I would like the database to enforce uniqueness on this key pair. I don't think the built in auto-increment field can support this kind of mechanism, so - What is a safe, efficient way to find the customers highest order number, increment it by one, and write the new order record? I need to be absolutely sure that if ten people enter a new order all for the same customer at (nearly) the same time, they all get a unique order number. Create a single unique index on both columns (CREATE UNIQUE INDEX ordernumber ON table (customerid, orderid);) and use LOCK TABLES when creating the order id. - 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: Elapsed time
Rich, You can try TO_DAYS() first before finding the diff. of the two dates. Perhaps this would give you a better solution. Hasan - Original Message - From: Rich Duzenbury [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 12, 2001 5:22 AM Subject: Elapsed time Ver 8.0, Distrib 3.22.32. I have two fields in a table that are TIMESTAMP fields. I'd like to show the amount of elapsed time between the two timestamps in a human readable format. For example, I'd like to print 'Elapsed time: 1 year 4 months 27 days 9 hours 13 minutes 42 seconds. ' Or perhaps 1-4-27 9:13:42. I've tried SELECT SEC_TO_TIME(date2 - date1) from myfile Differences of more than 24 hours appear to accumulate in the hours field - it show things like 225:18:07. I've also tried select FORMAT_DATE((date2 - date1), '%Y-%c-%e %T') from myfile. most records return NULL.. Can an SQL query calculate and display the elapsed time? If so, could you provide a simple example? If this isn't feasible, I can certainly calculate the difference in the code if need be. Thank you. Regards, Rich - 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
How to upgrade MySQL without breaking PHP/Apache?
Trying to upgrade from 3.23.27 to 3.23.38 via rpm. The problem is then Apache/PHP cannot connect to the database (using the mysql routines internal to PHP), so I'm left having to --force --nodeps a downgrade to keep the system up. Now, PHP can be compiled to use the current MySQL libraries, but the last time I had to do that (with an install of MySQL 3.23.37 from binary tar to a Debian box) a needed MySQL library or two wasn't on the system, and to get it I had to compile MySQL from the source tar. Okay: 1. Is there a way to just get PHP/Apache to talk to the current MySQL without recompiling to reference the current MySQL libraries? 2. Does the development rpm actually contain what I'll need to point to if I _do_ have to recompile everything? 3. Considering that PHP/Apache is one of the most common MySQL front ends, why isn't this set of problems prominently dealt with in the documentation, if not avoided through clever programming and/or making sure the PHP team has early access to any interface changes coming along? Whit - 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: odbc on WinME
try download full windows odbc setup (not download only .dll). Then, follow with Setup.exe. Sommai Fongnamthip At 07:39 11/6/2001 -0700, Bob Andrews wrote: I recently downloaded the ODBC client software for windows, ran setup, then went into the 'ODBC Data Source Administrator' from the control panel per the readme. I tried to add a new datasource, but MySQL was not in the list so apparently the setup program didn't work as expected. Any suggestions on what to check? (Just saying that this worked for you is not what I am looking for.) Perhaps there's a registry entry I should check? Thanks. - 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