re: ERROR 2013: Lost connection to MySQL server during query
Thanks for your help, we have installed MySQL 2.23.53a on Red Hat 8.0. The problem seems to be the version of RedHat. We have now installed the same version of MySql on RedHat 7.3 and it seems to work fine. Can you give me a confirmation of this problem? Thanks Davide On Fri, 2002-10-25 at 15:36, Egor Egorov wrote: Davide, Friday, October 25, 2002, 11:57:23 AM, you wrote: DP I'm new to MySQL. I am trying to set replication in MySQL but i get the DP error in the subject. DP Can you help me please? Can you be more detailed? What OS? What versions of MySQL servers? What did you done before you got this error? You gave incomplete info .. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
can't find messagefile errmsg.sys
10/27/02 Your [EMAIL PROTECTED] spit me out in a very nasty manner, eventhough I DID follow your guidelines to the best of my ability and this error is about the mysql daemon not starting. I'm not exactly encouraged by this and I'm wondering how much good it is going to do me that I spent a lot of time documenting all of this for you. It is true that what I'm hoping to get is my situation fixed, but I've gone to a lot of trouble here, and judging by what's on the internet, I'm not the only one with these types of problems unresolved. I can't figure out what an unemployed student with a home network is supposed to do about this - do you have an unemployed student tech support sliding scale fee for a one time installation problem? The ironic thing about this is that I never had ANY trouble with mysql on Windows 2000! Original email below: I'm on Red Hat Linux 7.3 with Kernel 2.4.18.3 (BTW, I couldn't get the mysql bug reporting mechanism to work so this is my recourse). Background here, specific repeatable steps lower down: After several headaches trying to install MySQL 3.23 from rpm, from binaries, using root as installer, using mysql as installer, I gave up and deleted and am now trying MySQL 4.0.4 where the errors are more understandable but equally frustrating. I've lost 5 days of my life and installed and deleted (yes keeping track, and deleting my.cnf too associated files then experimenting with not deleting all the files - I've done it every way I can imagine - most recently first creating a user mysql WITH a linux login password -as well as the group - before installing mysql) and reinstalled etc. With mysql 3.23 I kept getting errors about mysql.sock. Plus lots of other errors, I wound up creating a lot of files manually, changing ownership on files making them more permissive, making links, all to no avail. Specifics: On 4.0.4 After installing, reinstalling, and reinstalling. When I attempt to start mysqld, I keep (a, consistency) getting the error message (from hostname.err) Can't find messagefile mysql-long-name-4.0.4/share/mysql/english/errmsg.sys When I checked, yes the file did indeed exist in that directory: rw_r__r__ mysql users errmsg.sys so I moved it because it wasn't reading it anyway mv errmsg.sys errmsg_old.sys Got a new error message /usr/local/mysql/libexec/mysqld doesn't exist or isn't executable. Well, at least that is understandable. And the mysqld file really didn't exist at that location. Oh, I tried to start mysql in safe mode so it would look for the most reasonable path probably switched paths because of it. I know more about this than I ever wanted to. I've spent hours on mysql.com and even more hours on Google looking up error messages. I created a symbolic link from one of the places that mysqld resides ln -s /usr/libexec/mysqld /usr/local/mysql/libexec/mysqld Trying to start the daemon after doing this gave me: Can't find messagefile /usr/local/mysql-long-name-4.0.4/share/mysql/english/errmsg.sys Aborting mysqld ended I like this better because at least it is an absolute path so I know the process is pointing to the same place I'm looking. Now I moved errmsg_old.sys back to errmsg.sys which I hoped would fix the problem. It didn't. Same error message. So I re gunzipped and untarred the original .tar.gz file and ran mysql_install_db for the 110th time. The bug repeats itself exactly. I also tried this with making the symbolic link from /mysql-long-name-4.0.4/bin/mysqld to /mysql-long-name-4.0.4/libexec/mysqld (instead of from /usr/libexec/mysqld) with the same results. Attempting to run mysql-test-run gave me errors: Can't find messagefile /usr/local/mysql-long-name-4.0.4/share/mysql/english/errmsg.sys Aborting Error executing mysqld --bootstrap Error: could not install master test DBs I really NEED to install MySQL and have it running properly from my Linux Red Hat box. Oh yeah, other error messages I got (from 3.2.3 which had a wide variety of error messages including missing my.hosts file and unable to use mysql.sock) included stuff about ELF and gcc (which of course RedHat7.3 does not have, the C++ compiler is egcs) I would appreciate any help you can give me with this. I am fairly new at Administering Linux so maybe there is something that everyone knows that is so basic that I'm missing and not finding in any documentation. If that is the case, since similar errors seem to be sprinkled all over the internet in lots of usegroups, maybe they SHOULD be documented - I haven't found any answers out there. BTW, I am unable to execute mysqladmin so mysqladmin version is out of the question. I am running the most recent beta, downloaded Friday. mysql-4.0.4-beta-pc-gnu-i686 I ftped from Virginia last, I think. If you have more specific questions for me or want me to run perl or shell scripts on my environment to give you more information I'm willing to do so. --
root password
Hi, I am learning MySql and was going through the manual.html in the /usr/share/doc/mysql.../Docs/ I know SQL already and made some changes to the user table of mysql database. The server is running but I cant get a privileged access. I changed password=y for root user. Now the hostname.err (in my case munshi.err) says that 021026 13:03:43 mysqld started 021026 13:03:44 Found invalid password for user: 'root@localhost'; Ignoring user 021026 13:03:44 Found invalid password for user: I guess that I need to change the password somewhere, but I cant access the mysql databsae, Thanks in advance. INFO : From \s in mysql. mysql Ver 11.18 Distrib 3.23.52, for slackware-linux-gnu (i386) Connection id: 26 Current database: Current user: amish@localhost Current pager: stdout Using outfile: '' Server version: 3.23.52 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/var/run/mysql/mysql.sock Uptime: 14 min 42 sec Threads: 1 Questions: 21 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.024 - 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: root password
On Sat, 26 Oct 2002 [EMAIL PROTECTED] wrote: Hi, I am learning MySql and was going through the manual.html in the /usr/share/doc/mysql.../Docs/ I know SQL already and made some changes to the user table of mysql database. The server is running but I cant get a privileged access. I changed password=y for root user. Now the hostname.err (in my case munshi.err) says that Hi, On SQL level, one should change his/her password by using the PASSWORD() function. Like this: UPDATE USER SET password=PASSWORD('blah') WHERE user='root'; Not sure how you changed it, but this is the better way. Then FLUSH PRIVILEGES; See below for a solution for your problem. :-) 021026 13:03:43 mysqld started 021026 13:03:44 Found invalid password for user: 'root@localhost'; Ignoring user 021026 13:03:44 Found invalid password for user: I guess that I need to change the password somewhere, but I cant access the mysql databsae, Thanks in advance. Start mysqld with --skip-grant-tables and reset your passwords. Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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
What if binary log's suffix number exceeds 999?
Dear, By default, binary log file uses 3-digit number suffix as its counter. Then, without reseting master logs suffix number may reach 999. If so, what happens? next suffix number is 1000 or 001? Otherwise error occurres? sql. query. :( Regards, -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.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
date_sub, must use a datetime column type?
Hello List, Is it true that the date_sub function(s) will only work on datetime column types? SELECT count(id) as id FROM messages WHERE client_id = '2' AND datetime_col date_sub(NOW(),interval 1 day) To get the above query to work, I had to change my datetime_col column from timestamp to datetime, and that breaks A LOT of formatting work I had done previously when I thought I was only going to be able to keep with a timestamp column type. Could someone suggest a replacement query for the one above, where I would not have to change my datetime column from timestamp to datetime? Alternatively, could someone suggest a Java alternative to the following that would allow me to get the HH:mm from a datetime column type? SimpleDateFormat(HH:mm).format(rs.getTime(datetime_col)) I tried playing around with rs.getDate to get HH:mm, but couldn't see the light. Specifically, (rs.getDate(datetime_col).getTime()) did not work. Anyone? It's 4:35 AM. I'm dying. Many 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
database corrupted after power switched off
hello. is it a normal behaviour that a sql databases gets corrupted if the power of the whole system will be switched off while an application is writing to the database ? what can i do that this problem does no more appear ? thanx tom --- bbv Software Services Tom Thurnherr QA Specialist Postfach 2210 CH-6002 Luzern +41 41 429 01 37 - 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: plz help...tables getting corrupted...
Akash, Sunday, October 27, 2002, 10:49:55 AM, you wrote: A I came across a strange problem in MySQL. Some of the tables are getting A corrupted. The most common error messages which I encountered are : Can't A open file: 'tablename.MYD'. (errno: 145) and Got error 127 from table A handler. A I rectified it by shutting down the MySQL Server and using myisamchk A with the options -r and sometimes -o. A Is there anything I can do to avoid such errors to occur in future ? A Don't these errors make MySQL unreliable ? If your tables becomes corrupted so often, you should fine the source of the problem. I think the following section of the manual may help you: http://www.mysql.com/doc/en/Corrupted_MyISAM_tables.html http://www.mysql.com/doc/en/Reproduceable_test_case.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: date_sub, must use a datetime column type?
Qmail, Monday, October 28, 2002, 11:48:14 AM, you wrote: QL Is it true that the date_sub function(s) will only work on datetime column QL types? QL SELECT count(id) as id FROM messages WHERE client_id = '2' AND datetime_col date_sub(NOW(),interval 1 day) QL To get the above query to work, I had to change my datetime_col column from QL timestamp to datetime, and that breaks A LOT of formatting work I had done QL previously when I thought I was only going to be able to keep with a QL timestamp column type. QL Could someone suggest a replacement query for the one above, where I would QL not have to change my datetime column from timestamp to datetime? DATE_SUB works perfect on my TIMESTAMP column. So, what exactly doesn't work for you? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: LEFT JOIN selects with ORDER BY and WHERE and LIMIT missing results
toasty, Sunday, October 27, 2002, 11:17:53 PM, you wrote: taddc Under some pretty specific conditions, adding a LIMIT clause to a query taddc will cause incorrect results. taddc How-To-Repeat: taddc This bug is NOT present in 4.0.3. taddc CREATE TABLE `history` ( taddc `id_pic` int(11) unsigned NOT NULL auto_increment, taddc `id_cam` smallint(11) unsigned NOT NULL default '0', taddc `time` int(14) unsigned NOT NULL default '0', taddc `votes` smallint(3) NOT NULL default '0', taddc `score` mediumint(3) NOT NULL default '0', taddc `avgscore` double NOT NULL default '-65534', taddc `id_show` smallint(11) NOT NULL default '0', taddc `views` mediumint(8) unsigned NOT NULL default '0', taddc PRIMARY KEY (`id_pic`), taddc KEY `avgscore` (`avgscore`), taddc KEY `id_cam` (`id_cam`), taddc KEY `id_show` (`id_show`), taddc KEY `votes` (`votes`), taddc KEY `camshow` (`id_cam`,`id_show`) taddc ) TYPE=MyISAM taddc CREATE TABLE `cam_update` ( taddc `id_cam` int(11) NOT NULL auto_increment, taddc `status` tinyint(4) NOT NULL default '0', taddc PRIMARY KEY (`id_cam`), taddc KEY `status` (`status`) taddc ) TYPE=MyISAM PACK_KEYS=1 taddc mysql SELECT history.* FROM history LEFT JOIN cam_update ON history.id_cam=cam_update.id_cam WHERE history.votes 10 AND (cam_update.status=2) ORDER BY avgscore desc limit 0,13; taddc Empty set (0.14 sec) taddc mysql SELECT history.* FROM history LEFT JOIN cam_update ON history.id_cam=cam_update.id_cam WHERE history.votes 10 AND (cam_update.status=2) ORDER BY avgscore limit 0,13; taddc ++++---+---++-+---+ taddc | id_pic | id_cam | time | votes | score | avgscore | id_show | views | taddc ++++---+---++-+---+ taddc | 388402 |520 | 1017892232 |31 | -65 | -0.185185185185185 | 0 | 0 | taddc ++++---+---++-+---+ taddc 1 row in set (0.15 sec) Could you please give me some data for testing? I couldn't repeat it with my test data :( -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: database corrupted after power switched off
is it a normal behaviour that a sql databases gets corrupted if the power of the whole system will be switched off while an application is writing to the database ? Yes. what can i do that this problem does no more appear ? Buy a UPS or shutdown the system normally. NEVER just turn off power to a computer. sql, query - 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: date_sub, must use a datetime column type?
Hello List, Is it true that the date_sub function(s) will only work on datetime column types? SELECT count(id) as id FROM messages WHERE client_id = '2' AND datetime_col date_sub(NOW(),interval 1 day) To get the above query to work, I had to change my datetime_col column from timestamp to datetime, and that breaks A LOT of formatting work I had done previously when I thought I was only going to be able to keep with a timestamp column type. Could someone suggest a replacement query for the one above, where I would not have to change my datetime column from timestamp to datetime? Strange indeed.. here's a workaround SELECT count(id) as id FROM messages WHERE client_id = '2' AND date_sub(datetime_col,interval 0 day) date_sub(NOW(),interval 1 day) Ugly, but in testing (with a timestamp field) it seemed to work. Regards, Martin -- mailto:mac.com;nemo http://www.mechintosh.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
Date as field default
What do I put in a date field's default value if I want the MySQL database to insert the current date in the field when a new record is inserted? TIA, Jerry - 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: date_sub, must use a datetime column type?
Is it true that the date_sub function(s) will only work on datetime column types? SELECT count(id) as id FROM messages WHERE client_id = '2' AND datetime_col date_sub(NOW(),interval 1 day) To get the above query to work, I had to change my datetime_col column from timestamp to datetime, and that breaks A LOT of formatting work I had done previously when I thought I was only going to be able to keep with a timestamp column type. Could someone suggest a replacement query for the one above, where I would not have to change my datetime column from timestamp to datetime? Strange indeed.. here's a workaround SELECT count(id) as id FROM messages WHERE client_id = '2' AND date_sub(datetime_col,interval 0 day) date_sub(NOW(),interval 1 day) Ugly, but in testing (with a timestamp field) it seemed to work. Guess I shouldn't stay up nights either.. the first method works for me as well, now. %-/ -- mailto:mac.com;nemo http://www.mechintosh.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: database corrupted after power switched off
Tom, Monday, October 28, 2002, 11:59:16 AM, you wrote: TT is it a normal behaviour that a sql databases gets corrupted if the power of TT the whole system will be switched off while an application is writing to the TT database ? Yes. Other situations when tables may become corrupted are listed here: http://www.mysql.com/doc/en/Corrupted_MyISAM_tables.html TT what can i do that this problem does no more appear ? You have to shutdown MySQL server correctly, buy UPS :-) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
MYSQL newbie :-)
This has probably been asked a thousand times before but only once from me. I am able to programme in MS Access to quite a high level to which I have now realised its limitations, where is the best place to start learning and reading up on MYSQL, I am not really a book reader as I prefer to do things by trial and error but have not got a clue as to how mysql works Regards Liam - 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 newbie :-)
On Mon, 28 Oct 2002 [EMAIL PROTECTED] wrote: This has probably been asked a thousand times before but only once from me. I am able to programme in MS Access to quite a high level to which I have now realised its limitations, where is the best place to start learning and reading up on MYSQL, I am not really a book reader as I prefer to do things by trial and error but have not got a clue as to how mysql works Hi! See www.mysql.com/doc There is a tutorial section in the manual, it's not a big one, but you should be able to get started with it. The reference manual is excellent for further learning, too. Paul DuBois's book 'MySQL' is also very good. Also, searching Google with these 'mysql tutorial' will help... :-) Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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 newbie :-)
This has probably been asked a thousand times before but only once from me. I am able to programme in MS Access to quite a high level to which I have now realised its limitations, where is the best place to start learning and reading up on MYSQL, I am not really a book reader as I prefer to do things by trial and error but have not got a clue as to how mysql works After much confused reading, browsing and trial/error that didn't really get me anywhere I arrived here http://sqlcourse.com/ and http://sqlcourse2.com/ and was up to speed (relatively speaking ofcourse.. :-) in no time (an afternoon maybe?) They have an online SQL parser and sample tables that work from a webform where you can try the exercises they have after each short chapter. Regards, Martin -- mailto:mac.com;nemo http://www.mechintosh.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
Using a query as a source for another query?
G'day all, Is it possible to use a query as a source for another query? For example... Query 1: SELECT COUNT(*) AS TotalSurveys, SurveyDate FROM Surveys GROUP BY SurveyDate; Query 2: SELECT MIN(TotalSurveys) AS MinSurveys, MAX(TotalSurveys) AS MaxSurveys FROM Query 1; I am using 3.23.53 on a Windows 2000 (SP3) platform. Adrian [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: RE: large amount of aborted_connects
Hello Jennifer, Thursday, October 24, 2002, 12:29:25 AM, you wrote: I'm having trouble with a an obscene amount of aborted_connects on my MySQL database servers. I have 3 dedicated database servers, one of them is a master database with 2 slaves, and the other 2 are stand-alone database servers. All connections are being made by PHP pages on Apache web servers. [rest skipped] Hmm, I can guess that this could be caused by PHP itself. Like, say, PHP aborts connection, not closing 'em properly. Try to use pconnect instead of connect, maybe that will help. Another warning to consider: is your server running an official binaries of MySQL? If not, this may be the source of the problem, as compiling MySQL on Linux is very tricky to get it working right. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: re: Re: problem upgrading
Hello Lance, Wednesday, October 23, 2002, 4:16:16 PM, you wrote: LU I have /tmp symlinked to /var/tmp, and /var is a writable partition, while / LU is readonly. When / is readonly mysqld is not able to run. LU I've tracked down the problem to the safe_mysqld script. The problem is it LU does: LU USER_OPTION= LU if test -w / LU then LU if test $user != root -o $SET_USER = 1 LU then LU USER_OPTION=--user=$user LU fi LU So if / is not writable then my --user argument gets blown away. Yikes. LU I believe this is a bug. If anyone knows why it's like this please let me LU know. Until then I'll be patching my system so I can continue running... If I got you right, then /usr is readonly, too. In this case hardly you can run your FreeBSD box LU Yes. /usr is readonly too. This box is being run as a webserver, so once I LU setup the world there's no need for it to be writable. All data I need LU written goes in /var. Well, mea culpa - I've just found the test -w / line above. I will check it out. LU -Lance -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Security question
Daniel, Monday, October 28, 2002, 1:06:10 AM, you wrote: DLS In my mysql.db file, I have some lines like: DLS %.private | somedb | someuser | Y | Y | Y | Y | Y | Y | N | Y | Y | Y DLS So, I have an internal domain called private, those hosts are in an DLS internal DNS, and can be reverse resolved. The only way I can manage to DLS connect to somedb as someuser is to put the fully qualified hostnames DLS in the /etc/hosts file, eg.: DLS 1.2.3.4 somehost.private DLS For some reason mysql is not seeing the DNS resolution. Yes, DNS is DLS really working as verified with nslookup for both forward and reverse DLS records. DLS The version of mysqld I am running is: DLS /usr/libexec/mysqld Ver 3.23.36 for redhat-linux-gnu on i386 DLS Can someone provide some insight or suggestions? Sure, there are some known problems with resolver on Linux. First, you should not compile MySQL by yourself. Broken resolver is one of the most common situations happening when MySQL is wrong-compiled. Second, there were a log of fixes to resolver part of MySQL since .36. So you have to upgrade your server to MySQL 3.23.53 with MySQL official binary release found at http://www.mysql.com/ That will help. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Table-sizes, number of tables etc
Michelle, Saturday, October 26, 2002, 6:59:28 PM, you wrote: MdB I am trying a worst-case-scenario of my databse. MdB I have, so far, come up with some numbers to do the MdB calculations with and perhaps a way of splitting one MdB big table into smaller, yet structured, tables. MdB (These questions are not limited by hardware, because MdB if the need for speed is there, the revenues are too.) MdB The numbers are: MdB Thought-up number entries in one table: MdB 100 000 000 000 (100 billion) MdB Number of tables: MdB 10 000 MdB (I could perhaps limit the number of entries to a MdB maximum of 9 000 000, but I need to have a hell of a MdB lot of tables.) MdB So here are the questions regarding MySQL: MdB 1) How many tables can one database have? MdB (The absolute maximum) Depends on file system: how many files can be stored in the directory. MdB 2) How many entries can one single table have? MdB (The absolute maximum) There are no limits on number of rows. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Inserting value from other table in query
Michael, Saturday, October 26, 2002, 6:42:41 PM, you wrote: MTB I want to do: MTB SELECT @Rate:=Rate FROM Project WHERE ProjectID = 'x'; MTB INSERT INTO BillingTime (Start, End, ProjectID, Rate) values (a, b, x, MTB @Rate); MTB ... but I'm sure its doable in a single query, even if I have multiple MTB values to query, is it? MTB INSERT INTO BillingTime (Start, End, ProjectID, Rate) SELECT a, b, x, MTB Rate FROM Project where ProjectID = x; MTB ... but this doesn't work if I want to query values from multiple tables. It should work. So, what exactly doesn't work? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: re: ERROR 2013: Lost connection to MySQL server during query
Davide, Monday, October 28, 2002, 9:56:46 AM, you wrote: DP Thanks for your help, we have installed MySQL 2.23.53a on Red Hat 8.0. DP The problem seems to be the version of RedHat. We have now installed the DP same version of MySql on RedHat 7.3 and it seems to work fine. Can you DP give me a confirmation of this problem? Lost connection on RedHat 7.x/8.0 was caused by RedHat glibc. But 3.23.53a was compiled with statically linked glibc, so this problem shouldn't occur ... DP On Fri, 2002-10-25 at 15:36, Egor Egorov wrote: Davide, Friday, October 25, 2002, 11:57:23 AM, you wrote: DP I'm new to MySQL. I am trying to set replication in MySQL but i get the DP error in the subject. DP Can you help me please? Can you be more detailed? What OS? What versions of MySQL servers? What did you done before you got this error? You gave incomplete info .. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Date as field default
Jerry, Monday, October 28, 2002, 12:24:05 PM, you wrote: J What do I put in a date field's default value if I want J the MySQL database to insert the current date in the J field when J a new record is inserted? What about TIMESTAMP column type? http://www.mysql.com/doc/en/DATETIME.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: MYSQL newbie :-)
the manual is a very good place to start , its very organized , and its complete reference , better than any book . trial and error is good , but try to get a graphical user interface beter than the shell . there are many . --- [EMAIL PROTECTED] wrote: This has probably been asked a thousand times before but only once from me. I am able to programme in MS Access to quite a high level to which I have now realised its limitations, where is the best place to start learning and reading up on MYSQL, I am not really a book reader as I prefer to do things by trial and error but have not got a clue as to how mysql works Regards Liam - 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 _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Select your own custom email address for FREE! Get [EMAIL PROTECTED] w/No Ads, 6MB, POP more! http://www.everyone.net/selectmail?campaign=tag - 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-sizes, number of tables etc
At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote: MdB 2) How many entries can one single table have? MdB (The absolute maximum) There are no limits on number of rows. What if the values for Primary Key run out? Can you use a unsigned bigint as Primary Key? I mean, we /have/ to store the properties of sandgrains in the Sahara *somewhere*, right :-) Regards, Martin SQL MySQL bla vla yadda query 0 rows found -- mailto:mac.com;nemo http://www.mechintosh.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
Need a little query help
I am trying to select some data from a hotel database I am putting on the web. Currently I am using two temporary tables and three queries to get the data, but I suspect it can be done in one query by a better knowledge of SQL. The tables are Hotels: ID, PostCode, ShowHotel AmenityLink: ID, HotelID, AmenityID, Value I have the postcode as $postcode and one or more amenities = 'y'; I want to find all active hotel IDs with PostCode = $postcode and having the amenityid, ignoring the amenity value as I will test for that later. SELECT Hotels.ID FROM Hotels, AmenityLink WHERE Hotels.ID = AmenityLink.HotelID AND ShowHotel = 1 AND PostCode = '$postcode' AND (AmenityLink.AmenityID = $amenityid[1] OR AmenityLink.AmenityID = $amenityid[2] ) The problem is, it is easy to test for one amenity, but I need to test that the hotel has all of the amenities. The query above returns all the hotels that have ANY of the amenities, I need the hotels having ALL of the amenties only. Thanks for any assistance. Chris Mason [EMAIL PROTECTED] Box 340, The Valley, Anguilla, British West Indies Tel: 264 497 5670 Fax: 264 497 8463 Cell: 264 235 5670 http://www.anguillaguide.com/ The Anguilla Guide Talk to me in real time: Yahoo:netconcepts_anguilla US Fax and Voicemail: (815)301-9759 - 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
Performance degradation over time
I have a script written in python running on Suse linux using mySQL 3.23.32. There are two tables each with an auto-increment key and one index. Table 1 has a maximinum of 1,000,000 records and table 2 has a maxminum of 20,000,000 records. The script performs a mixture of inserts, updates, deletes and selects. it has an output line every 10 seconds saying how many records have been written since the last sample. I set it running @ 6.00 last friday and performance started @ 1200 transaction per second and degraded gradually to about 12 a second. I then connected to mysql and asked for the count of both tables, 'select count(*) from table_name'. After the query, performance went up to 700/sec degrading after an hour or so the aroung 500/sec. Can anyone offer an explanation to this interesting result. Dave French. NOTICE DISCLAIMER This email including attachments (this Document) is confidential and may contain legally privileged information. If you have received this Document in error please notify the sender immediately and delete this Document from your system without using, copying, disclosing or disseminating it or placing any reliance upon its contents. We cannot accept liability for any breaches of confidence arising through use of this Document. The information contained in this Document is provided solely for information purposes on an as is basis without warranty of any kind, either express or implied, including without limitation any implied warranty of satisfactory or merchantable quality, fitness for a particular purpose or freedom from error or infringement. The user relies on the information contained herein, and its accuracy or otherwise, entirely at their own risk. Any opinions expressed in this Document are those of the author and do not necessarily reflect the opinions of Telsis. We will not accept responsibility for any commitments made by our employees outside the scope of our business. - 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: re: Table-sizes, number of tables etc
M, Monday, October 28, 2002, 2:00:28 PM, you wrote: MS At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote: MdB 2) How many entries can one single table have? MdB (The absolute maximum) There are no limits on number of rows. MS What if the values for Primary Key run out? You get Duplicate key error. MS Can you use a unsigned bigint as Primary Key? MS I mean, we /have/ to store the properties of sandgrains in the Sahara *somewhere*, right :-) The maximum unsigned bigint value is not the same as limits on number of rows, is it? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
gcc3
Hi to all, i can't compile sqlplus.hh with gcc3. do someone has tried this ? Thanks Yann Taillade-Carrière Services Techniques de la Navigation Aérienne, SubDivision 7VI tél 05 62 14 50 47 - 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: Is it possible to replicate just a couple of tables insteadof the whole database
Hi, Is it possible to replicate just some tables instead of a whole mysql database? A replication of the whole database would be not necessary in my case. It would be a one-way replication (means slave won't update master). Furthermore: Is there a cheep tool taking care of that (without changing the design of the master database)? Thank you in advance, Ralf Koellner - 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 odbc bug? with centura application using bind variable
Hi, I'm using: -- - W98 - MySql ODBC (MyODBC-3.51.04.exe) / Tried also (myodbc-2.50.39-win95.zip) - Application with Centura Team Developer CTD 1.5.1 PTF6 (Gupta Sqlwindows) - MySql Server on Linux 3.23.48-19, (from Suse Linux 8.0) Problem: Using bind variable in select statement in where clause get's no result. Examples (Centura Application Code) - NOT WORKING: Set sKKey = '4711' Set sSel = 'SELECT PARAM, TEXT FROM KONFIG INTO :sParam1, :sParm2 WHERE KKEY = :sKKey' Call SqlPrepareAndExecute( hSqlA, sSel ) Call SqlFetchNext( hSqlA, nErr ) Gets no Result. Don't using bind variable in where clause - WORKING: Set sSel = 'SELECT PARAM, TEXT FROM KONFIG INTO :sParam1, :sParm2 WHERE KKEY = \'4711\' I've searched many hours in newsgroups and mailing list but I can't find a solution! Thank you for help! -- Best regards Peter mailto:Peter.Franz.muc;web.de - 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-sizes, number of tables etc
Monday, October 28, 2002, 2:00:28 PM, you wrote: MS At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote: MdB 2) How many entries can one single table have? MdB (The absolute maximum) There are no limits on number of rows. MS What if the values for Primary Key run out? You get Duplicate key error. MS Can you use a unsigned bigint as Primary Key? MS I mean, we /have/ to store the properties of sandgrains in the Sahara *somewhere*, right :-) The maximum unsigned bigint value is not the same as limits on number of rows, is it? Hey, you tell me, I'm just a MySQL newbie :-) Just wondering if there exists a theoretical maximum, even if no one will ever reach it, it'd be good ammo in the preferred-dbserver-wars My database can hold a larger infinite number of rows than your database! ;-) Regards, Martin -- mailto:mac.com;nemo http://www.mechintosh.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: Re: Is it possible to replicate just a couple of tables instead of the whole database
Ralf, Monday, October 28, 2002, 11:48:22 PM, you wrote: RK Is it possible to replicate just some tables instead of a whole mysql RK database? A replication of the whole database would be not necessary in RK my case. It would be a one-way replication (means slave won't update RK master). RK Furthermore: RK Is there a cheep tool taking care of that (without changing the design RK of the master database)? Yes. Take a look at the following options related to replication: replicate-do-table replicate-ignore-table replicate-wild-do-table replicate-wild-ignore-table You can read about them here: http://www.mysql.com/doc/en/Replication_Options.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: SEGFAULT unless reverse...
jonfray, Friday, October 25, 2002, 5:19:24 PM, you wrote: jamtdc Description: jamtdc I have the same problem as a previous mail : jamtdc # http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:107859 jamtdc But I couldn't find the final issue (except adding every host in jamtdc my /etc/hosts file) jamtdc How-To-Repeat: jamtdc Run this command from a host that has no reverse DNS available jamtdc # /usr/local/mysql/bin/mysql -u mediation -h 194.242.186.11 -p jamtdc An error occur : jamtdc # ERROR 2013: Lost connection to MySQL server during query jamtdc On the server, the logs contains these lines : jamtdc # /usr/local/mysql/bin/safe_mysqld: line 1: 4698 Erreur de segmentation nice --5 nohup /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var jamtdc --user=mysql --pid-file=/usr/local/mysql/var/sodium.mediation-telecom.net.pid --skip-locking --log --log-bin /usr/local/mysql/var/sodium.mediation-telecom.net.err 21 jamtdc # jamtdc # Number of processes running now: 1 jamtdc # mysqld process hanging, pid 4701 - killed jamtdc # 021025 15:56:26 mysqld restarted jamtdc Fix: jamtdc The only solution I found was to add each host that need to connect in the /etc/hosts.conf file. You can also install MySQL from binaries (3.23.53a), or downgrade glibc ... Please, check mailing list archives, there were a lot of similar posts. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: What if binary log's suffix number exceeds 999?
Chung, Monday, October 28, 2002, 11:14:59 AM, you wrote: CHn By default, binary log file uses 3-digit number suffix as its counter. CHn Then, without reseting master logs suffix number may reach 999. If so, CHn what happens? CHn next suffix number is 1000 or 001? Otherwise error occurres? Next suffix will be 1000 and you won't get any error message. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Is it possible to replicate just a couple of tables insteadof the whole database
Ralf Koellner wrote: Hi, Is it possible to replicate just some tables instead of a whole mysql database? A replication of the whole database would be not necessary in my case. It would be a one-way replication (means slave won't update master). You can use 'replicate-do-table' on slave side to restrict replication to some tables. BTW, replication is ALWAYS one way: slaves receive their updates from the master. Furthermore: Is there a cheep tool taking care of that (without changing the design of the master database)? Thank you in advance, Ralf Koellner Hope this helps -- Joseph Bueno - 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: What if binary log's suffix number exceeds 999?
Then, what's the limit of suffix numbering? -- Chung Ha-nyung alita@[neowiz.com|kldp.org] SayClub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net] Sent: Monday, October 28, 2002 10:01 PM To: [EMAIL PROTECTED] Subject: re: What if binary log's suffix number exceeds 999? Chung, Monday, October 28, 2002, 11:14:59 AM, you wrote: CHn By default, binary log file uses 3-digit number suffix as its counter. CHn Then, without reseting master logs suffix number may reach 999. If so, CHn what happens? CHn next suffix number is 1000 or 001? Otherwise error occurres? Next suffix will be 1000 and you won't get any error message. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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 - 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
Altering Table errors
MySQL I asume that when I add a field or rename a field etc and get the errcode 13, that I must wait til a connection timeout has occurred to be able to make this structural change. While I'm developing, is there a quicker way to do this? Stopping/starting the service is not that quick.. Is there another way? thanks Alan - 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: BLOB inserts vs. storing filepath
John Meyer wrote: Hi, I've got a client that I'm trying to convince to store the file path in the database rather than the file itself into the database. Is there any statistical data to show how much of a hit you take doing it as a BLOB vs. a filepath? Assuming MySQL is equally efficient to your filesystem at storing the file, and your filesystem is as efficient as MySQL at finding the file (use ReiserFS), then the issue comes down to maintainability and usability. In most cases, the files I want to store are easily accessible (NFS / SFTP / local), so machine name and/or filepath is sufficient for me and I don't have to maintain that data in the MySQL table space. On top of that, you don't have to worry about hitting maximum table sizes (in MyISAM tables) as quickly either and your files are still easily accessible from non-MySQL aware programs. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: self relation query help
Yes, at first it may seem that groups are just another form of artist, and that your searches would be simpler, but if you put them both in a single table, how do you model someone like say Paul McCartney, who was in the Beatles and Wings? Or Yo Yo Ma, who has guested with every important symphony orchestra in the world? Particularly in the jazz world, your model poses enormous problems. How could you model Charlie Haden, Miles Davis, the Brecker brothers, and so so? Peter's right. If you want a robust model, you have to break out groups and artists. If you want a historically accurate model, you may need a junction table GroupArtists, with FKs into Groups and Artists, and a pair of date columns indicating from and to -- which could overlap, again especially in jazz. Arthur -Original Message- From: Peter Brawley [mailto:peter.brawley;artfulsoftware.com] Sent: Saturday, October 26, 2002 6:43 AM To: Franklin Williams Jr.; [EMAIL PROTECTED] Subject: Re: self relation query help Franklin, the basic relational rules (http://hometown.aol.com/mbaddenda/art120.html, http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter7/node1.html) say, decompose relationships like your artists groups to separate tables, and your example fits right in. PB - - Original Message - From: Franklin Williams Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 25, 2002 9:44 PM Subject: self relation query help I have a table with names in it where the names can function as 1 of 2 things - either an artist or a group. In order to make searching easy I wished to keep these names in one table. EG: searching for artist name, whether a group or soloist you would have to search only one table. The problem arises if the person wishes to get the names of the artists in the group or an artist also performs in multiple groups. I thought a self relationship of sorts solved this but then I could not figure out how to write the query. For instance the simplest query is: show me all the groups and artists in each group, or Show me the artists names in group U2. Easy if groups and artist names were in 2 tables, however... A table B table -- idNameid grp_id art_id -- 1 Joe 1 2 1 2 U2 2 2 3 3 Mike 3 2 4 4 John -- 5 Jane --- In the above sample data, table B is a join of sorts where the A.id functions as both the B.grp_id and B.art_id. EG: B.grp_id = A.id AND B.art_id = A.id I thought I had come up with a nifty little trick (using the same id in different fields to designate a distinction ) but alas. I can only select one column to get the names of the group and artists. I thought nested selects would solve this - maybe not - but no nested selects in mysql anyway. So..can this be done with this design or must I split the artists and groups into separate tables, forcing a multiple table search? I hoped column alias would solve this but I could not make it work using them. Confused? Good...so am I! Thanks in advance for any help Franklin Williams [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
backups without revealing password
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all! I would like to dump my mysql databases to cold files for separate backups; we're too cheap to buy the database agent that will do it live. I started with mysqldump --user=root --password=showtheworld --all-databases ... as I've seen in numerous scripts posted to this list, but of course that shows the world my DB root password if you happen to run top at the right time (or are the adventurous type who might run a script to, say, look for and log any mysql commands). My next step was to create dumpster user with no password grant select on *.* to dumpster@localhost so that I can run mysqldump --user=dumpster --all-databases ... and at least protect all of my writing privs -- but now the DB id of a user that can obviously read every bit of data in there is also exposed. What I need is a way to connect to the database from a cron job without exposing the password in the environment. What amazes me is that even confidential databases at large companies are accessed through scripts with the passwords embedded -- and the scripts are often world-readable! Is there anything analagous to an ssh key pair so that only an OS user connecting with the DB id private key can get in to do the select and run the mysqldump? Or am I barking up the wrong tree and should I instead do something else to cleanly and securely back up the databases? TIA HAND :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE9vUEvGb7uCXufRwARAhD4AKDj+BMcS2bUtfTnMNd7mF4tPKBX5wCgv+wF ijDeFAYEEH//YbW5qsExAmY= =Y+bQ -END PGP SIGNATURE- - 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: Shutting off power
Ed Carp wrote: Buy a UPS or shutdown the system normally. NEVER just turn off power to a computer. Or even, use a UPS _and_ shut down the system properly _and_ use sync'd writes to the partition your database is on (or at least the partition your recovery logs are on). PS, I hate this stupid SQL filter ... I can't tell you how many times I haven't even bothered to contribute an answer to this list because it was bounced by the stupid filter. I can't tell you how much I hate reading 4 line answers from people preceded by the 10+ lines of forward this message, blah blah. I _can_ tell you that I'd rather see the spam, and filter it myself, than lose the intelligent contributions of other list members who forget to put 'sql' or 'query' in their message. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: backups without revealing password
On Mon, 28 Oct 2002, David T-G wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all! I would like to dump my mysql databases to cold files for separate backups; we're too cheap to buy the database agent that will do it live. I started with mysqldump --user=root --password=showtheworld --all-databases ... as I've seen in numerous scripts posted to this list, but of course that shows the world my DB root password if you happen to run top at the right time (or are the adventurous type who might run a script to, say, look for and log any mysql commands). My next step was to create dumpster user with no password grant select on *.* to dumpster@localhost so that I can run mysqldump --user=dumpster --all-databases ... and at least protect all of my writing privs -- but now the DB id of a user that can obviously read every bit of data in there is also exposed. What I need is a way to connect to the database from a cron job without exposing the password in the environment. What amazes me is that even confidential databases at large companies are accessed through scripts with the passwords embedded -- and the scripts are often world-readable! Is there anything analagous to an ssh key pair so that only an OS user connecting with the DB id private key can get in to do the select and run the mysqldump? Or am I barking up the wrong tree and should I instead do something else to cleanly and securely back up the databases? Hi! See http://www.mysql.com/doc/en/Secure_connections.html and its subsections. I think GRANT ... REQUIRE X509 and x509 certificates could help you. Even then you have expose your password but it won't help a cracker as he doesn't have your certificate. I haven't used this personally, and the documentation is pretty thin on this subject, unfortunately. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - 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
Problem with indexed joins
Hi, I'm relatively new to MySQL, and am having trouble with the optimization of some of the queries. I have two tables (T_PERSONNE and T_DEVIS) which are supposed to be linked by a foreign key (T_PERSONNE.PERS_ID = T_DEVIS.DEV_PERS). I've put an index on the foreign key (DEV_PERS), and even on the combination of PERS_ID and DEV_PERS (this worked fine for another table with a similar structure), but when I analyse the query using EXPLAIN, the base still wants to use an ALL join on the second table. I'm using MySQL 3.23.53 Thanks in advance, John. CREATE table T_PERSONNE( PERS_GUID varchar(32) not null unique, PERS_NAME varchar(50) not null, ... primary key (PERS_GUID)); CREATE index EST_RENSEIGNE_PAR_FK on T_PERSONNES(PERS_CIV); CREATE index PERS_NAME_IDX on T_PERSONNES(PERS_NAME); CREATE table T_DEVIS( DEV_NUM int not null unique, DEV_PERS varchar(32) not null, ... primary key (DEV_NUM)); CREATE index EST_LIE_FK on T_DEVIS(DEV_TYPE); CREATE index POSSEDE_FK on T_DEVIS(DEV_PERS); CREATE index EST_ASSOCIE_FK on T_DEVIS(DEV_STATE); CREATE index DEVIS_PERSONNE_IDX on T_DEVIS(DEV_PERS,DEV_NUM); CREATE index DEVIS_PERSONNE_IDX on T_DEVIS(DEV_PERS,DEV_NUM); mysql explain select * from t_personnes, t_devis where dev_pers=pers_guid and pers_name = 'DUPONT'; +-+--+-+---+-+---+--++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+--+-+---+-+---+--++ | t_personnes | ref | PRIMARY,PERS_GUID,PERS_NAME_IDX | PERS_NAME_IDX | 50 | const |1 | where used | | t_devis | ALL | FULL_DEVIS_IDX,POSSEDE_FK | NULL |NULL | NULL |3 | where used | +-+--+-+---+-+---+--++ 2 rows in set (0.00 sec) -- John Ferguson Smart Directeur Technique Département Informatique Communicante AACOM email : [EMAIL PROTECTED] - AACOM - L'Informatique communicante 120 rue du Marin Blanc - Z.I. des Paluds 13685 Aubagne Cedex tel : 04.42.72.65.69 - fax : 04.42.72.65.68 Web : http://www.aacom.fr - - 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: Lost my socks...
[EMAIL PROTECTED] wrote: Try a touch /var/lib/mysql/mysql.sock NO. Do not do this. It will cause problems later when you try to start the server. Although it is a special file it may just work this way. Also make the permissions to chmod 777 mysql.sock and chown mysql.mysql mysql.sock Leave the mysq.sock alone. If you did any of the above, make sure that the server is not running, and delete the mysql.sock. The server will create it properly when it starts, and remove it when it stops. Bye. On Mon, 28 Oct 2002, Dennis Herndon wrote: I just upgraded to Linux-Mandrake 9.0 and installed mysql via the RPM files. Everything installed just fine and dandy except when I try to run mysql it can't find /var/lib/mysql/mysql.sock file. I'm read how to protect that file, but where does it come from? - 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: Altering Table errors
Error 13 is an operating system privilege violation error. the user 'mysql' does not own or have access to something in the database. Alan McDonald wrote: MySQL I asume that when I add a field or rename a field etc and get the errcode 13, that I must wait til a connection timeout has occurred to be able to make this structural change. While I'm developing, is there a quicker way to do this? Stopping/starting the service is not that quick.. Is there another way? thanks Alan - 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: backups without revealing password
create a .my.cnf file in your home directory, and enter the useid and password here. David T-G wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, all! I would like to dump my mysql databases to cold files for separate backups; we're too cheap to buy the database agent that will do it live. I started with mysqldump --user=root --password=showtheworld --all-databases ... as I've seen in numerous scripts posted to this list, but of course that shows the world my DB root password if you happen to run top at the right time (or are the adventurous type who might run a script to, say, look for and log any mysql commands). My next step was to create dumpster user with no password grant select on *.* to dumpster@localhost so that I can run mysqldump --user=dumpster --all-databases ... and at least protect all of my writing privs -- but now the DB id of a user that can obviously read every bit of data in there is also exposed. What I need is a way to connect to the database from a cron job without exposing the password in the environment. What amazes me is that even confidential databases at large companies are accessed through scripts with the passwords embedded -- and the scripts are often world-readable! Is there anything analagous to an ssh key pair so that only an OS user connecting with the DB id private key can get in to do the select and run the mysqldump? Or am I barking up the wrong tree and should I instead do something else to cleanly and securely back up the databases? TIA HAND :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE9vUEvGb7uCXufRwARAhD4AKDj+BMcS2bUtfTnMNd7mF4tPKBX5wCgv+wF ijDeFAYEEH//YbW5qsExAmY= =Y+bQ -END PGP SIGNATURE- - 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
Free space in Database
How do I know how much free space I have in my database innodb? MySql - 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.h: no such file or directory
dear everybody, I tired to use mysqlhotcopy, but then I got the following error message: can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.6.1/i386-linux /usr/lib/perl5/5.6.1/ /usr/lib/perl5/site_perl/5.6.1/i386-linux /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl/ /usr/lib/perl5/vendor_perl/5.6.1/i386-linux /usr/lib/perl5/vendor_perl/5.6.1 /usr/lib/perl5/vendor_perl/ .) at /usr/bin/mysqlhotcopy line 8 I fixed this error by installing the CPAN package DBI-1.30 and typed mysqlhotcopy again - again an error: install_driver(mysql) failed: can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.6.1/i386-linux /usr/lib/perl5/5.6.1/ /usr/lib/perl5/site_perl/5.6.1/i386-linux /usr/lib/perl5/site_perl/5.6.1 /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl/ /usr/lib/perl5/vendor_perl/5.6.1/i386-linux /usr/lib/perl5/vendor_perl/5.6.1 /usr/lib/perl5/vendor_perl/ .) at (eval 1) line 3. Perhaps the DBD::mysql perl modul hasn't been fully installed, or perhaps the capitalisation of 'mysql' isn't right. Available dirvers: ExampleP, Proxy. at /usr/bin/mysqlhotcopy line 162 thus I tried to install DBD-mysql-2.1020 - but once again it doesn't work because of: In file included from dbdimp.c:29: dbdimp.h:31:49: mysql.h: No such file or directory dbdimp.h:32:49: errmsg.h: No such file or directory So what can I do thanks for your help martina FLEXTRONICS World Trade Center A-1300 Vienna Austria [EMAIL PROTECTED] www.flextronics.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: database corrupted after power switched off
VRDate: Mon, 28 Oct 2002 12:35:01 +0200 VRFrom: Victoria Reznichenko [EMAIL PROTECTED] VRSubject: re: database corrupted after power switched off VRTom, VRMonday, October 28, 2002, 11:59:16 AM, you wrote: VRTT is it a normal behaviour that a sql databases gets corrupted if the power of VRTT the whole system will be switched off while an application is writing to the VRTT database ? VRYes. Other situations when tables may become corrupted are listed VRhere: VR http://www.mysql.com/doc/en/Corrupted_MyISAM_tables.html ... which says MyISAM table format is very reliable (all changes to a table is written before the SQL statements returns) Evidently, this is NOT true. (Perhaps, it used to be true for ISAM tables. The documentation should be changed.) VRTT what can i do that this problem does no more appear ? VRYou have to shutdown MySQL server correctly, buy UPS :-) There are a couple of other choices (perhaps to be used in addition to UPS). (1) Use InnoDB tables. Evidently, they are designed to survive such things, especially with innodb_flush_log_at_trx_commit=1. We have survived having the server disconnected from the UPS. I hope to not find out if it works twice :-) (2) If you have updates in infrequent bursts, such as with a server used primarily for queries or a single-user system, do FLUSH TABLES after each burst. This writes the tables to disk. We have a number of users with single-user local database a which are synchronized with the server from time to time, and we have no control over whether or not they have UPS. We did have the problem that the databases would be corrupted if power were lost an hour after updating. Adding the FLUSH TABLES after each user interaction that updates the database solved this. (In reality, we only flush the tables that have been modified.) - 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: database corrupted after power switched off
Bill Easton wrote: ... which says MyISAM table format is very reliable (all changes to a table is written before the SQL statements returns) Evidently, this is NOT true. (Perhaps, it used to be true for ISAM tables. The documentation should be changed.) You are misinterpreting the statement; it says that the database will be safe after the SQL command returns (all SQL commands active on the table, for that matter). That is to say, if the power were turned off while any (update / etc.) SQL command was running, you could expect corruption. Again, make sure you check how your OS deals with write caching and consider turning it off on the partition / disk you're using for DB storage. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: database corrupted after power switched off
Original Message - From: Michael T. Babcock [EMAIL PROTECTED] To: Bill Easton [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Tom Thurnherr [EMAIL PROTECTED] Sent: Monday, October 28, 2002 4:18 PM Subject: Re: database corrupted after power switched off Again, make sure you check how your OS deals with write caching and consider turning it off on the partition / disk you're using for DB storage. I would certainly not do that. In fact, disk caches (for non 4.04 users) are an excellent, be it a poor man's, way of having a SELECT cache. On my own MySQL news server, with many recurring logins from the same people, disk caches make an enormous difference. Since MySQL, through the disk cache, effectively reads most of these SELECTS from memory, the speed of logins has increased by an order of magnitude. The proper way is NOT to disable disk cache, but to shut down mysqld properly. In fact, I could make a cogent case stating that disabling disk cache actually INCREASES the risk of corruption (because you can never hope to expect a delayed write). - Mark System Administrator Asarian-host.org --- If you were supposed to understand it, we wouldn't call it code. - FedEx - 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: database corrupted after power switched off
Thanks. You're right, of course. Nevertheless, I think the suggestions I made should help. (Context: There was a post asking how to avoid table corruption. There were several replies suggesting UPS. I suggested that, in addition to UPS, there were two other things that could be done.) (1) Use InnoDB. Of course, you need to worry that InnoDB does a physical write when it thinks it does. My understanding is that it tries to do so, if it can, when innodb_flush_log_at_trx_commit=1. (2) If MyISAM updates are infrequent, flush tables after updates. This closes the files, which generally causes physical writes on most OS's. Of course, this doesn't help with loss of power while an update is running, but it does avoid corruption when there are no updates going on, and MyISAM is susceptible to the latter. - Original Message - From: Michael T. Babcock [EMAIL PROTECTED] To: Bill Easton [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; Tom Thurnherr [EMAIL PROTECTED] Sent: Monday, October 28, 2002 10:18 AM Subject: Re: database corrupted after power switched off Bill Easton wrote: ... which says MyISAM table format is very reliable (all changes to a table is written before the SQL statements returns) Evidently, this is NOT true. (Perhaps, it used to be true for ISAM tables. The documentation should be changed.) You are misinterpreting the statement; it says that the database will be safe after the SQL command returns (all SQL commands active on the table, for that matter). That is to say, if the power were turned off while any (update / etc.) SQL command was running, you could expect corruption. Again, make sure you check how your OS deals with write caching and consider turning it off on the partition / disk you're using for DB storage. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: database corrupted after power switched off
Mark wrote: Again, make sure you check how your OS deals with write caching and consider turning it off on the partition / disk you're using for DB storage. I would certainly not do that. In fact, disk caches (for non 4.04 users) are an excellent, be it a poor man's, way of having a SELECT cache. I specifically said _write_ caching; not read caching. Read caches won't damage your data (if properly coded), but write caches can hold data in memory instead of on disk that never gets written in a power failure. (This has something to do with SQL ... ) :) -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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: self relation query help
This is probably going more into db design than pure mysql issues...on the other hand if performance is at stake with these different designs. After several inputs - which I am EXTREMELY thankful for - here are some of my thoughts. The solution using Joseph's table aliases works beautifully. With that said, I also see the value in using separate tables. And from a design perspective, which I really enjoy working on, that seems the better solution given the ease of maintenance on one subject entities. However, in this case I believe the table groupmembers which is a table of all the groups and its members, with the dates they were in those groups - a point Arthur makes which is already in place - works as effectively as creating separate tables, and makes the search algorithm easier to code - at least for me! ;-) . If an artist recorded with multiple groups, their id appears in the groupmembers table associated with all groups they performed with and the dates. This seems similar to me as an example I saw regarding bowling league teams and captains. The captains were also bowlers so a self-relation was used keeping all the bowlers in one table. In large DB's, such as an Amazon, or CD now, you can only search by artist, song, album title, etc. There are no group searches. So if they are parsing out groups into another table then I would love to see the code for that 'cause they are quick! Classical searches differ given the conductor, orchestra, etc. Which makes me wonder why Jazz searches are not set up that way as well. h I have a linking table of sorts to combine artists with groups, but eliminate an additional group table. Am I missing something here that should be obvious as to a serious problem with the one table design? Yes, I'm trying to defend the one table design. hehe. Honestly I had given it up for Arthur and Pete's design until Joseph showed me the table alias method. So we can blame him! ;-) Thanks for the input and feel free to fire away with any other thoughts and suggestions. I'm new to this mysql stuff. It rocks! Franklin __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.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: RE: What if binary log's suffix number exceeds 999?
alita, Monday, October 28, 2002, 3:13:54 PM, you wrote: a Then, what's the limit of suffix numbering? Seems, there is no limit of numbering. -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net] Sent: Monday, October 28, 2002 10:01 PM To: [EMAIL PROTECTED] Subject: re: What if binary log's suffix number exceeds 999? Chung, Monday, October 28, 2002, 11:14:59 AM, you wrote: CHn By default, binary log file uses 3-digit number suffix as its counter. CHn Then, without reseting master logs suffix number may reach 999. If so, CHn what happens? CHn next suffix number is 1000 or 001? Otherwise error occurres? Next suffix will be 1000 and you won't get any error message. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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
Replication and ALTER
Say I have a database that is being properly replicated to another server and I want to alter it on both machines (say, add a new column). Will this also be sent with the SQL update log to the second server, or must I do the altering on both machines myself? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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
safe_mysqld bind-address
Hi all , I am trying to do the following : [root@xxx bin]# ./safe_mysqld --bind-address=192.168.1.222 Starting mysqld daemon with databases from /usr/local/mysql/var but when I telnet xxx 3306, the mysqld have the following response: ./safe_mysqld: line 1: 12325 Segmentation fault nice --5 nohup /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/hkpfaServer.pid --skip-locking --bind-address\=192.168.1.222 /usr/local/mysql/var/hkpfaServer.err 21 Number of processes running now: 2 mysqld process hanging, pid 12328 - killed ./safe_mysqld: kill: (12328) - No such pid 021029 00:37:34 mysqld restarted So how can I bind the address successfully ? Thanks. Perseus _ Get a speedy connection with MSN Broadband. Join now! http://resourcecenter.msn.com/access/plans/freeactivation.asp - 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
Is BACKUP / RESTORE making my table corrupted
Greetings... I used BACKUP command to backup all the tables in a database which has only MyISAM tables ( since backup only works with MyISAM table ). Everything was OK. Then after some time I did the RESTORE COMMAND, but before that I deleted all the tables in the database...in two tables,,,i got this error... Delete link points outside datafile at 0 and in another two tables i get this error... Couldn't fix table with quick recovery: Found wrong number of deleted records. I am using MySQL 3.23.44 in WinXP. Is there any problem in Backup / Restore or I am doing something wrong ? Whats wrong. Thanks in advance. Rgds Ritesh - 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
using libmysqld - can't connect to remote DB as client.
Nobody answered my question, so I felt like I should ask again ... I'm using libmysqld to embed a mysql server in my C app. However, I'd also like to connect to other remote mysql databases as well, but the mysql_real_connect command doesn't seem to be working when trying to connect to a remote database in the same app as the libmysqld stuff. The connect works, but I think that it's connecting to my local database and not the remote one. Here's a little code: mysql_server_init(sizeof(server_args) / sizeof(char *), server_args, server_groups); // Here's the embedded database. This works. one = db_connect(NULL); db_do_query(one, CREATE DATABASE my_blah_database); mysql_close(one); one = db_connect(my_blah_database); db_do_query(one, create table blank (num int)); mysql_close(one); /* This must be called after all other mysql functions */ mysql_server_end(); // Here's the remote connection - it connects to the same local machine, not the remote machine. two = db_remote_connect (remote_machine,remote,remote,dbname); db_do_query(two, SHOW DATABASES); Has anyone tried this. I'm using the 4.0.4 beta source tree. __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.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
mysqld bringing down server
I now maintain a popular internet sports portal which runs mySQL. Last weekend, the server (x86 linux) started grinding to a halt. When I list the processes, there are many, many (much more than the number of webserver threads!) mysqld threads running at once, sitting on the CPU for long periods of time. This is new behavior, and when I restart the mysqld, this situation reliably occurs again in a minute or so. How can I debug/repair this sort of thing? I have no idea what's going on, and I've never run into this sort of problem before. Is there any way to get connections to the backend to time out? Also, the documentations makes some comment about the default settings for mysqld not being configured for high-load situations, but then fails to explain how to do this. Any suggestions? -dj - 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: re: Table-sizes, number of tables etc
M, Monday, October 28, 2002, 2:55:44 PM, you wrote: Monday, October 28, 2002, 2:00:28 PM, you wrote: MS At 13:36 +0200 28-10-2002, Victoria Reznichenko wrote: MdB 2) How many entries can one single table have? MdB (The absolute maximum) There are no limits on number of rows. MS What if the values for Primary Key run out? You get Duplicate key error. MS Can you use a unsigned bigint as Primary Key? MS I mean, we /have/ to store the properties of sandgrains in the Sahara *somewhere*, right :-) The maximum unsigned bigint value is not the same as limits on number of rows, is it? MS Hey, you tell me, I'm just a MySQL newbie :-) MS Just wondering if there exists a theoretical maximum, even if no one will ever reach it, it'd be good ammo in the preferred-dbserver-wars Oops, I was wrong .. There is limit on number of rows .. 4 billions of rows per table, but you can extend it by re-compiling MySQL .. MS My database can hold a larger infinite number of rows than your database! :-) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: small bug in mysqlcheck
Guy, Saturday, October 26, 2002, 10:42:43 PM, you wrote: GC When trying to check/repair/analaiz a table with a name like 'table-name' GC mysqlcheck (from source package 3.23.53) fails with: GC mysqlcheck: Got error: 1064: You have an error in your SQL syntax near '-name' GC at line 1 when executing 'CHECK TABLE ... GC Here's the patch for it: GC --- mysqlcheck.old Sat Oct 26 11:37:49 2002 GC +++ mysqlcheck.cSat Oct 26 11:35:12 2002 GC @@ -521,7 +521,7 @@ GCif (!(query =(char *) my_malloc((sizeof(char)*(length+110)), MYF(MY_WME GC return 1; GC - sprintf(query, %s TABLE %s %s, op, tables, options); GC + sprintf(query, %s TABLE `%s` %s, op, tables, options); GCif (mysql_query(sock, query)) GC{ GC sprintf(message, when executing '%s TABLE ... %s, op, options); Thanks for the report! It will be fixed. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Free space in Database
Silmara, Monday, October 28, 2002, 3:58:18 PM, you wrote: S How do I know how much free space I have in my database innodb? STABLE STATUS LIKE table_name shows you free InnoDB space. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ 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: Hashref array loading
-Original Message- From: [EMAIL PROTECTED] [mailto:mysql;lists.mysql.com] Sent: Monday, October 28, 2002 11:42 AM To: Ramon Hildreth Subject: Re: Hashref array loading 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: 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. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi, Does anyone know how to load a hashref into an array, and then display a html table using the contents of that array. Any help would be greatly appreciated. Ramon Hildreth - 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: database corrupted after power switched off
From: Ed Carp [EMAIL PROTECTED] is it a normal behaviour that a sql databases gets corrupted if the power of the whole system will be switched off while an application is writing to the database ? Yes. what can i do that this problem does no more appear ? Buy a UPS or shutdown the system normally. NEVER just turn off power to a computer. And note that this is NOT a MySQL problem! If the power goes off while ANY program is writing to disk, you are likely to have (at best) a corrupted file, and possibly a corrupted file system as well! If you turn off the power while writing a Microsoft Word file (for example), you will also have a corrupted file. What sets MySQL apart is that there is generally more at stake than there is with a single Word file. Small UPS systems are quite inexpensive these days. Even office-sized systems that will protect numerous computers cost no more than a single new computer. (And they last longer!) Anyone doing anything that is mission-critical for any business of any size should have a UPS capable of keeping the system up long enough to shut it down gracefully. -- SQL SQL SQL SQL SQL SQL SQL SQL : Jan Steinman -- nature Transography(TM): http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Buy My Step Van! http://www.Bytesmiths.com/van - 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 bringing down server
Hi David, I've seen a similar behavior on our machine. We had someone re-write the code for a particular PHP site that was producing tons of slow queries (while the CPU was 100% idle the script would still take 15 seconds to run its queries) and the problem was (sort of) fixed. Have a constant look at mysqladmin processlist, maybe there are tons of mysql processes sitting sleeping. You can adjust the max. wait time for (interactive) connections with: In your my.cnf, under [mysqld]: set-variable= interactive_timeout=90 set-variable= wait_timeout=90 This will close sleeping connections after 90 seconds. Default is 8 days. However, this is not a real fix for your problems but might help temporary so that mysqld is not taking your server down. This only makes sense if you have sleeping processes (according to mysqladmin processlist). Active the sleep log, it will show you which queries take up too much time ( 10 secs): In your my.cnf, under [safe_mysqld]: log-slow-queries = /var/log/mysql-slow.log mysqladmin status will show you how many slow queries you got. Investigate /var/log/mysql-slow.log to find out what the query looked like. Maybe that helps... Regards Markus On Mon, 28 Oct 2002 13:46:52 -0500 David J. Trombley [EMAIL PROTECTED] wrote: I now maintain a popular internet sports portal which runs mySQL. Last weekend, the server (x86 linux) started grinding to a halt. When I list the processes, there are many, many (much more than the number of webserver threads!) mysqld threads running at once, sitting on the CPU for long periods of time. This is new behavior, and when I restart the mysqld, this situation reliably occurs again in a minute or so. How can I debug/repair this sort of thing? I have no idea what's going on, and I've never run into this sort of problem before. Is there any way to get connections to the backend to time out? Also, the documentations makes some comment about the default settings for mysqld not being configured for high-load situations, but then fails to explain how to do this. Any suggestions? -dj - 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: hashref array loading
Ramon Hildreth wrote something about SQL: Does anyone know how to load a hashref into an array, and then display a html table using the contents of that array. Any help would be greatly appreciated. Sounds like there's more to your question than you're bothering to type. Please see http://www.tuxedo.org/~esr/faqs/smart-questions.html and while you're at it, search Google for 'load hashref array html table' and see if it helps. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - 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 and ALTER
On Mon, Oct 28, 2002 at 12:17:20PM -0500, Michael T. Babcock wrote: Say I have a database that is being properly replicated to another server and I want to alter it on both machines (say, add a new column). Will this also be sent with the SQL update log to the second server, or must I do the altering on both machines myself? It is automatic. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 83 days, processed 1,742,206,890 queries (241/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: mysql odbc bug? with centura application using bind variable
Hi !! Hi, I'm using: -- - W98 - MySql ODBC (MyODBC-3.51.04.exe) / Tried also (myodbc-2.50.39-win95.zip) - Application with Centura Team Developer CTD 1.5.1 PTF6 (Gupta Sqlwindows) - MySql Server on Linux 3.23.48-19, (from Suse Linux 8.0) Problem: Using bind variable in select statement in where clause get's no result. Examples (Centura Application Code) - NOT WORKING: Set sKKey = '4711' Set sSel = 'SELECT PARAM, TEXT FROM KONFIG INTO :sParam1, :sParm2 WHERE KKEY = :sKKey' Call SqlPrepareAndExecute( hSqlA, sSel ) Call SqlFetchNext( hSqlA, nErr ) Gets no Result. How this SqlPrepareAndExecute is binding the data for sKKey value ? Can you cross the call from SQLBindParameter from the ODBC log whether it is passing the valid pointer with the value that you are expecting ? The reason could be the sKKey is bound to different value than the expected or sent a wrong pointer. And it's a basic functionality from the driver, and that is used by many users. Don't using bind variable in where clause - WORKING: Set sSel = 'SELECT PARAM, TEXT FROM KONFIG INTO :sParam1, :sParm2 WHERE KKEY = \'4711\' I've searched many hours in newsgroups and mailing list but I can't find a solution! I guess, the value sent in the where clause didn't match. But more information can be found from the odbc log. Send me the log file. Thanks Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ Palo Alto, CA-94306 ___/ www.mysql.com 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
C-API and multiple resultsets
Hi! If I use mysql_use_reult() of the C-API, I must use two connections to traverse two different result sets at the same time. Is that right? Thanx, Stefan sql, query - 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: InnoDB and auto_increment fields
stored? Why isn't this done automatically as it is for [ISAM] tables? As for the why, I'm not a MySQL developer, but I believe the reason goes something like this: When ISAM tables were implemented, they did it the wrong way. When other table types came along, they fixed this bug and do it the right way. You seem to disagree about which is better, but I believe the above is the explanation for the switch in behavior. As for why the MyISAM/InnoDB way is right, I believe it has to do with the idea that autoincrement values are very commonly used in situations where you want not just a key that's unique in the table, but one that will never be used again. Specifically, in ISAM tables, when you delete the highest-keyed record, that key will be given out again with the next insert. Depending on how your application is written, that could lead to unpleasant race conditions that would be easily avoided by simply not reusing key values at all. --Pete sql, db - 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: InnoDB and auto_increment fields
stored? Why isn't this done automatically as it is for [ISAM] tables? As for the why, I'm not a MySQL developer, but I believe the reason goes something like this: When ISAM tables were implemented, they did it the wrong way. When other table types came along, they fixed this bug and do it the right way. Ahh, ok. Thanks for the info. You seem to disagree about which is better, but I believe the above is the explanation for the switch in behavior. I really have no opinion as to which is better. Certainly, restarting on an empty table automatically is easier. But for reasons that you point out, depending on your application, it could lead to unforseen problems. Chris - 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
fs/table size ...
Hi ! This is my first posting to this group so: hello to everybody. I`m using snort (IDS) with logging to MySQL DB. Snort is little bit noisy and it inserts a lot of datas in DB - about 130MB/4h. I`m confused about: is it better to use fs with support more then 2GB files (ext3, ReiserFS (which is not so good for large files), or tables build with raid option (i have read in mysql faq that indexes are not divided ...so that is a problem also0 This db has to have good effitency ... ps. sorry for my poor english. greetz boka --- Tytus na Dzikim Zachodzie http://tytus.wp.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: Altering Table errors
But after a while it does, cause I only have to wait a while with no activity on the database, and the command executes. So it's not permissions Alan -Original Message- From: gerald_clark [mailto:gerald_clark;suppliersystems.com] Sent: Tuesday, 29 October 2002 1:38 To: Alan McDonald Cc: [EMAIL PROTECTED] Subject: Re: Altering Table errors Error 13 is an operating system privilege violation error. the user 'mysql' does not own or have access to something in the database. Alan McDonald wrote: MySQL I asume that when I add a field or rename a field etc and get the errcode 13, that I must wait til a connection timeout has occurred to be able to make this structural change. While I'm developing, is there a quicker way to do this? Stopping/starting the service is not that quick.. Is there another way? thanks Alan - 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: mysqld bringing down server
universe wrote: Hi David, I've seen a similar behavior on our machine. We had someone re-write the code for a particular PHP site that was producing tons of slow queries (while the CPU was 100% idle the script would still take 15 seconds to run its queries) and the problem was (sort of) fixed. Ok, this makes some sense! We are in fact using PHP and there are in fact queries known to be slow. Is it possible that the PHP end is timing out the connection and the backend is continuing to process the query? Have a constant look at mysqladmin processlist, maybe there are tons of mysql processes sitting sleeping. You can adjust the max. wait time for (interactive) connections with: In your my.cnf, under [mysqld]: set-variable= interactive_timeout=90 set-variable= wait_timeout=90 This will close sleeping connections after 90 seconds. Default is 8 days. However, this is not a real fix for your problems but might help temporary so that mysqld is not taking your server down. This only makes sense if you have sleeping processes (according to mysqladmin processlist). Ah! Thanks, this is very useful information. Active the sleep log, it will show you which queries take up too much time ( 10 secs): In your my.cnf, under [safe_mysqld]: log-slow-queries = /var/log/mysql-slow.log This was actually the first thing I did. The query that shows up there consistently is a known problem, and I briefly griped about it on this list before, but no one seemed to have a solution. I'll reiterate, in case you might: SELECT DISTINCT en_name as name, en_body as body, news.id, en_headline as headline, mnemonic, date_format(disp_stamp, '%Y') as year, date_format(disp_stamp,'%m') as month, date_format(disp_stamp,'%d') as day,disp_stamp FROM news, news_competitions, competitions WHERE (news.primary_section=competitions.id OR (news.id=news_competitions.newsid AND news_competitions.competitionid=competitions.id)) AND competitions.mnemonic='a_comp' AND en_headline!='' ORDER by disp_stamp desc; is an example of one of the slow queries. mysql describe news; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(11) | | PRI | NULL| auto_increment | | en_headline | text | YES | | NULL|| | sp_headline | text | YES | | NULL|| | en_body | text | YES | | NULL|| | sp_body | text | YES | | NULL|| | disp_stamp | datetime | YES | | NULL|| | primary_section | int(11) | YES | MUL | NULL|| | disp_order | int(11) | YES | MUL | NULL|| +-+--+--+-+-++ mysql describe news_competitions - ; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | newsid| int(11) | YES | | NULL|| | competitionid | int(11) | YES | | NULL|| | disp_order| int(11) | YES | | NULL|| +---+-+--+-+-++ mysql describe competitions; +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | id| int(11) | | PRI | NULL| auto_increment | | mnemonic | text| YES | MUL | NULL|| | en_name | text| YES | | NULL|| | en_url| text| YES | | NULL|| | competition | tinyint(1) | YES | | NULL|| | has_section | tinyint(1) | YES | MUL | NULL|| | disp_order| int(11) | YES | MUL | NULL||
mysql doesn't start with ./support-files/mysql.server script
Description: 1. I am running RedHat 7.2 with mysql-3.23.53a 2. If I go to mysql directory as a root and try to start mysql over there using ./support-files/mysql.server script it produces the error: cd /usr/local/mysql [root@jnikom mysql]# ./support-files/mysql.server ./support-files/mysql.server: @HOSTNAME@: command not found /usr/local/mysql/data/.pid usage: ./support-files/mysql.server start|stop 3. To fix it I replaced the line pid_file=$datadir/`@HOSTNAME@`.pid with pid_file=$datadir/$HOSTNAME.pid and it starts to work. I still don't know how it could work for other Oses. Regards, Jacob Nikom - 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
Building MySQL 4.0.4 with Borland 5.0.2
Has anyone had any luck building MySQL 4.0.4 from the win32 source using the Borland 5.0.2 Compiler? Please let me know if it is possible and where can I find some guidance as to what I have to do. Thank you, JFernando *** sql *** - 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
fs/table size ... cd
Hi ! i forgot to tell You (sorry !) that DB has to be run on linux. ps. sql,query - included for filter. greetz boka --- Tytus na Dzikim Zachodzie http://tytus.wp.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: Replication and ALTER
The only thing that is not published to the replication logs are 'flush' statements. -Original Message- From: Jeremy Zawodny [mailto:Jeremy;Zawodny.com] Sent: Monday, October 28, 2002 1:00 PM To: Michael T. Babcock Cc: '[EMAIL PROTECTED]' Subject: Re: Replication and ALTER On Mon, Oct 28, 2002 at 12:17:20PM -0500, Michael T. Babcock wrote: Say I have a database that is being properly replicated to another server and I want to alter it on both machines (say, add a new column). Will this also be sent with the SQL update log to the second server, or must I do the altering on both machines myself? It is automatic. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 83 days, processed 1,742,206,890 queries (241/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 - 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: secure replication
On Thu, 2002-10-24 at 20:26, Lists @ Apted Technologies Inc. wrote: i am going to be setting up four mysql servers, three of which will replicate data off of the primary. i know that in more recent versions of mysql client/server communciations can be encrypted internally. but is there any way to encrypt replication communcations between these mysql servers internally so i don't need to set up a vpn or ssl tunnel? thanks all. Setting this up with SSH is quite easy. I have a How-To on it at: http://www.guydavis.ca/projects/oss/docs/ssh_mysql.jsp -- Guy Davis http://www.guydavis.caCalgary, Alberta, Canada Digitally signed by GnuPG (DSA ID 30D52F0B at www.keyserver.net) PGP Fingerprint: 8DC8 4A6F C1AD 393B 39DB CDBF 196D 31D0 30D5 2F0 - 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
Connection problems
I recently installed Red Hat 7.3 on a box, and have been having difficulty connecting to my MySQL server. I can connect locally. That is, on the same machine as the server. However, if I try and connect from a remote machine with the following command: mysql -h IP_ADDRESS -p DATABASE I get the following error message: ERROR 2013: Lost connection to MySQL server during query I've poked around on the net and in the documentation, but I can't find anything that explains this. Aside from creating a database and using the GRANT ALL command on it to setup privileges, I haven't mucked with the configuration at all. I've tried reinstalling the RPMs for MySQL and still no luck. Any idea what could be causing this? How can I fix it? Thanks!!! Steve Nakhla [EMAIL PROTECTED] __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.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: Connection problems
Steven Nakhla wrote: I recently installed Red Hat 7.3 on a box, and have been having difficulty connecting to my MySQL server. I can connect locally. That is, on the same machine as the server. However, if I try and connect from a remote machine with the following command: mysql -h -p I get the following error message: ERROR 2013: Lost connection to MySQL server during query I've poked around on the net and in the documentation, but I can't find anything that explains this. Aside from creating a database and using the GRANT ALL command on it to setup privileges, I haven't mucked with the configuration at all. I've tried reinstalling the RPMs for MySQL and still no luck. Any idea what could be causing this? How can I fix it? Thanks!!! Steve Nakhla [EMAIL PROTECTED] This is a known problem with RedHat and the latest GLIBC that they pushed out via up2date. It breaks remote access to MySQL (amongst other bad things). If you're running on Linux, your best bet (always) is to use MySQL's binaries, as they're compiled statically, so it doesn't matter what breaks on your system with respect to GLIBC, MySQL should still work. The latest binaries (in RPM) are 3.23.53a, which can be downloaded from http://www.mysql.com/ (btw, This problem has been discussed on the mailing list for quite some time, so to save time in the future, you might try the archive at lists.mysql.com or marc.theaimsgroup.com). -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ 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: backups without revealing password
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gerald -- ...and then gerald_clark said... % % create a .my.cnf file in your home directory, and enter the useid and % password here. Ahhh... That's also not a bad idea. Between that and perhaps certificates I might be getting somewhere. Will that file be used all the time, or only when I don't override it with a -u parameter, or only when I specifically call it? I haven't yet seen it in the docs... A pointer to a section would be most wonderful :-) Thanks HAND mysql query :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://www.justpickone.org/davidtg/Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE9vdIVGb7uCXufRwARAgMyAKDesN5FxUnrVgGNNbqB0xxP3SP/NQCfX0CD yaxGQTPFZZl0b+jmHgWJrpw= =fpta -END PGP SIGNATURE- - 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
4.0.5 estimate?
Hi folks, as I am building a new db-server right now and would like to know if I should wait ... when is 4.0.5 due to arrive? ;-) Thanks, Thomas filter-fodder: sql, query -- +++ GMX - Mail, Messaging more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! - 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 segfault
Description: After upgrading mysql to 3.23.53, mysqld would segfault every time accessing a certain database. After running checks on the database and making sure everything was okay, I started mysqld up in gdb. Program received signal SIGSEGV, Segmentation fault. [Switching to Thread 2051 (LWP 12699)] 0x0012a12c in _nss_dns_gethostbyaddr_r (addr=0x81b9f68, len=4, af=2, result=0x337ca4, buffer=0x81bbfc8 \b33, buflen=1024, errnop=0x431c68, h_errnop=0x431864) at nss_dns/dns-host.c:223 223 nss_dns/dns-host.c: No such file or directory. in nss_dns/dns-host.c (gdb) bt #0 0x0012a12c in _nss_dns_gethostbyaddr_r (addr=0x81b9f68, len=4, af=2, result=0x337ca4, buffer=0x81bbfc8 \b33, buflen=1024, errnop=0x431c68, h_errnop=0x431864) at nss_dns/dns-host.c:223 #1 0x002fc919 in __gethostbyaddr_r (addr=0x81b9f68, len=4, type=2, resbuf=0x337ca4, buffer=0x81bbfc8 \b33, buflen=1024, result=0x431860, h_errnop=0x431864) at ../nss/getXXbyYY_r.c:200 #2 0x002fc6fb in gethostbyaddr (addr=0x81b9f68, len=4, type=2) at ../nss/getXXbyYY.c:131 #3 0x080ac720 in ip_to_hostname () #4 0x080acecb in check_connections () #5 0x080ad341 in handle_one_connection () #6 0x00137c6f in pthread_start_thread (arg=0x431be0) at manager.c:284 #7 0x00137d5f in pthread_start_thread_event (arg=0x431be0) at manager.c:308 How-To-Repeat: Not sure if it'll be repeatable on other machines Fix: Turning of name resolution fixes the problem, so does using the binary for 3.23.53 Submitter-Id: Alien88 Originator:root Organization: MySQL support: none Synopsis: mysqld segfaults doing name resolutions Severity: serious Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.53 (Source distribution) Environment: System: Linux webserv2.divide0.net 2.4.18-grsec-1.9.4 #2 SMP Sat Mar 23 21:27:39 PST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.2 2.96-108.7.2) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 6 00:36 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1285884 Sep 9 09:10 /lib/libc-2.2.4.so -rw-r--r--1 root root 27336078 Sep 9 08:48 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 9 08:48 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --sysconfdir=/etc --localstatedir=/home/mysql/var --without-bench - 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
su problems under linux.
I am having some difficulty with users using su and trying to access mysql, either through the command line (mysql) or via perl programs using DBD. Under normal circumstances users are able to use the command line tool mysql or run perl programs using DBD. They usually use $HOME/.my.cnf for password information. However if user1 #34;su#34; to user2 mysql tries to authenticate the original user (user1), not the one #34;su#34; to (user2). Both the original user (user1) and the #34;su#34; user (user2) have $HOME/.my.cnf so passwords are not needed, but the program abends saying the user tried to access mysql but didn't provide a password. The system is running: Linux 2.2.19 mysql Ver 11.15 Distrib 3.23.39, for slackware-linux-gnu (i386) Any suggestions to remedy this problem would be appreciated. Thanks, Chris. __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.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
i almost hate queires, please help!!!
here's my table syntax: create table Projects ( PjID int unsigned auto_increment not null primary key, PjNumber varchar(40) not null, PjName tinytext not null, PjDesc tinytext, PJEcd varchar(30), PJCost varchar(30), LastUpdate char(30) ); create table Managers ( MgrID int unsigned auto_increment primary key, MgrName varchar(40) not null, PrimaryID int unsigned not null, AlternateID int unsigned not null ); create table PjStatus ( StatID int unsigned auto_increment not null primary key, PjID int unsigned not null, Actions longtext, Status varchar(10) ); create table POCs ( PjID int unsigned not null, pmyid int unsigned not null, altid varchar(5) not null, I only have two records stored in my database currently. You'll notice the managers table has 3 id's for each manager. MGRid is the PK only reason for that. PrimaryID and Alternate ID are both for tracking purposes. A manager might be the primary manager (meaning the one ultimately responsible for the project) or he may be an alternate (backing somone else up who is the primary). Therefore, these two columns will have a one to many relationship with the POCs table. Here's what I want to do: define a query that will select * from the POCs table and display that info via a php script in a table. Simple enough right? WRONG! I know plently about php but jack about SQL. My query is as follows: select mgrname, pjname from managers, projects, pocs where pjid = 'x' and pmyid = 'x' and altid = 'x' NOW! This should give me an output like this: +--+ |__pjname|___mgrname(primary)___|___mgrname(alternate)_| | testproject testprimary1 testprimary2 Instead, what I get is the name of the project with EVERY single manager that I have loaded. Now I only have two records (or 2 projects) loaded into this database, but I have over 90 different project managers loaded (don't ask why, lost a bet on that one). So what happens is, I get the testproject name for the pjname and I get it replicated 94 different times for each and every manager that I have loaded. So it seems like every single manager is associated with this project. WTF am I doing wrong? This is going on 11 days trying to figure this out. Am I doing the joins wrong or something? Does my table design not allow me to do what I'm trying to do? Should I instead be trying to nest 3 queries in one and display the output side by side (sort of like the html talbe theory???)?? - 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: i almost hate queires, please help!!!
you have to include relations to all the tables you've selected from. select mgrname, pjname from managers, projects, pocs where pjid = 'x' and pmyid = 'x' and altid = 'x' AND POCs.PjID = PjStatus.PjID AND POCS.pmyid = Managers.PrimaryID AND POCS.altid = Managers.AlternateID i think that is how your tables should relate. play with it a little. it should work if you make sure all the tables you are selecting from have relational statements inside the query. have fun. Randy Hammons wrote: here's my table syntax: create table Projects ( PjID int unsigned auto_increment not null primary key, PjNumber varchar(40) not null, PjName tinytext not null, PjDesc tinytext, PJEcd varchar(30), PJCost varchar(30), LastUpdate char(30) ); create table Managers ( MgrID int unsigned auto_increment primary key, MgrName varchar(40) not null, PrimaryID int unsigned not null, AlternateID int unsigned not null ); create table PjStatus ( StatID int unsigned auto_increment not null primary key, PjID int unsigned not null, Actions longtext, Status varchar(10) ); create table POCs ( PjID int unsigned not null, pmyid int unsigned not null, altid varchar(5) not null, I only have two records stored in my database currently. You'll notice the managers table has 3 id's for each manager. MGRid is the PK only reason for that. PrimaryID and Alternate ID are both for tracking purposes. A manager might be the primary manager (meaning the one ultimately responsible for the project) or he may be an alternate (backing somone else up who is the primary). Therefore, these two columns will have a one to many relationship with the POCs table. Here's what I want to do: define a query that will select * from the POCs table and display that info via a php script in a table. Simple enough right? WRONG! I know plently about php but jack about SQL. My query is as follows: select mgrname, pjname from managers, projects, pocs where pjid = 'x' and pmyid = 'x' and altid = 'x' NOW! This should give me an output like this: +--+ |__pjname|___mgrname(primary)___|___mgrname(alternate)_| | testproject testprimary1 testprimary2 Instead, what I get is the name of the project with EVERY single manager that I have loaded. Now I only have two records (or 2 projects) loaded into this database, but I have over 90 different project managers loaded (don't ask why, lost a bet on that one). So what happens is, I get the testproject name for the pjname and I get it replicated 94 different times for each and every manager that I have loaded. So it seems like every single manager is associated with this project. WTF am I doing wrong? This is going on 11 days trying to figure this out. Am I doing the joins wrong or something? Does my table design not allow me to do what I'm trying to do? Should I instead be trying to nest 3 queries in one and display the output side by side (sort of like the html talbe theory???)?? - 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 -- //mikezero/ [EMAIL PROTECTED] //radiotakeover www.radiotakeover.com -- Every pirate lives for something different. For some, it's the open sea. For others (the masochists), it's the food. For you, it's definitely the fighting. You tend to blend into the background occaisionally, but that's okay, because it's much easier to sneak up on people and disembowel them that way. Arr! - 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 update user
Hello there, I need your expert and slow guided assistance. I would like someone to explain to me the correct mysql commands monitor to achive the following correctly. It would greatly help if you work for a hosting company. The question is: User asks to be given access to mysql database for his hosting account. username: marco pssword: mysecret database name: lotsofusers. Of first I set the administrative and root password using the document here: ftp://216.94.9.36/Setting%20the%20Root%20and%20Administrative%20Passwords.doc Then What I would like to do is: allow another user access to create and complete control over his database, inside tables and data information inside the database (we are talking about total control, creation, editing and deletion, (the ins and outs of that database assigned to the user called: marco: Enter the following command at your shell prompt: mysql -u root -p lotsofusers I am in. Then here is where I get bit stuck. I would some one to teach me how to do for that user and allow him/website to have access to that database and that database alone, having complete control over it. Using the example I have given you please teach me how to do so in detail?. I look forward to be taken a novice, As I have gone through the docs online. and it was not a great teacher!. Please help?!. regards, m a r c o - 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
Bug using truncation in 4.0.4-beta
Description: Special case: using SELECT with truncation doesn't return some records when the searched query appears at the end of the line. Note that the last record will be matched and returned because there is a space character at the end. I am using ft_min_word_len = 1; How-To-Repeat: Try this: drop database if exists Test_Bug ; create database Test_Bug; use Test_Bug; create table article (id int(10) primary key not null auto_increment, title text); insert into article values (0, 'Probability and Statistics with Reliability, Queueing and Computer Science Applications'), (0, 'Rasiowa-Sikorski deduction systems in computer science application'), (0, 'Computer science today in the European Union'), (0, 'Phase transition in a random fragmentation problem with applications to computer science'), (0, 'A Collection of Papers and Memoirs Celebrating the Contribution of Rod Burstall to Advances in Computer Science'), (0, 'KITE microprocessor and CAE for computer science'), (0, 'What Makes Them Succeed? Entry, progression and graduation in Computer Science '); create fulltext index ti_idx on article (title); select id,title from article where match (title) against ('computer science' in boolean mode); select . Now using the truncation operator .. as ''; select id,title from article where match (title) against ('computer science*' in boolean mode); Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-4.0.4-beta (Source distribution) Environment: System: Linux nile.lub.lu.se 2.4.7-10smp #1 SMP Thu Sep 6 16:16:16 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Sep 16 15:52 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1282588 Sep 4 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 Sep 4 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 4 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --with-raid --with-named-curses-libs=/usr/lib/libncurses.so.5.2 --with-innodb Regards Salam - 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