Re: error codes ??
perror will tell you Error code 69: Srmount error This looks pretty much like a system error to me. Ask your ISP. [EMAIL PROTECTED] schrieb am Donnerstag, 9. August 2001, 01:25:48: Hello, I seem to have corrupted mySQL deep down inside. I can not create any tables in any new databases. I will get the exact same errcode each time ... that is : SQL-query: CREATE TABLE test (user_id INT (6) not null AUTO_INCREMENT, notes VARCHAR (100) not null , PRIMARY KEY (user_id)) MySQL said: Error writing file './relata/test.frm' (Errcode: 69) I don't have root access to my server, and also can't find a list of what any of the errcodes mean. Looking for help Peter -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.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
php call to mysql
I know this isn't a PHP mailing list, but maybe someone out there can help. This is my first mysql/php project, and I can't seem to get this call to mysql to work. I have other queries working, but it seems as though any time I try to make a call to one of my auto_increment IDs, either PHP or MySQL doesn't like the way I am querying it. Below is he part of the PHP script that is supposed to call the fields from my Cat table in my database. I am sure there are no problems with authentication to get the table or problems with which table it is selecting. ?php $result = mysql_query(select * from $table2); if ($result){ while ($row = mysql_fetch_array($result)) { print Cat ID: $row[\Cat_ID\]; print Cat Name: $row[\CatName\]; print Cat Description: $row[\CatDescribe\]; print BDelete?/b; print input type=checkbox name=\Cat_ID[]\ value=\\.$row[Cat_ID].\\ Yes, delete entry #.$row[\Cat_ID\].\; print BRBR\n\n; } mysql_free_result($result); } ? I also tried the above code, but I escaped out the underscores. Thanks a lot for your help. Sorry for the indirect mysql question. (PHP question) -Christian Evans - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie -- Error codes
Hi, I'm new to mysql. I've installed an RPM undr Linux PPC and after running mysql server as root and trying to use a sample database from Paul Dubois book MySql, I ' ve got the error 13, can't create directory/file ./samp_db/president.xxx. The thing is I'm using an example DB, any help ? Where I can find out what the codes mean ? Regards, Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Pooling
Hi, I'm using JDBC/MySQL and the MM.MySQL driver to build JSP pages.I want to use connection pooling in my application.Kindly advice connection pooling package which is suitable for the above application. Thanking You, Gaurav Tuli
Re: php call to mysql
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 13:09 Subject: php call to mysql Modify your code as given below and see. It should work. DT I know this isn't a PHP mailing list, but maybe someone out there can help. This is my first mysql/php project, and I can't seem to get this call to mysql to work. I have other queries working, but it seems as though any time I try to make a call to one of my auto_increment IDs, either PHP or MySQL doesn't like the way I am querying it. Below is he part of the PHP script that is supposed to call the fields from my Cat table in my database. I am sure there are no problems with authentication to get the table or problems with which table it is selecting. ?php $result = mysql_query(select * from $table2); if ($result){ while ($row = mysql_fetch_array($result)) { $CatID=$row[Cat_ID]; $CatName=$row[CatName]; and so on. assuming your fields are CatName. print Cat ID: $row[\Cat_ID\]; print Cat Name: $row[\CatName\]; print Cat Description: $row[\CatDescribe\]; print BDelete?/b; print input type=checkbox name=\Cat_ID[]\ value=\\.$row[Cat_ID].\\ Yes, delete entry #.$row[\Cat_ID\].\; print BRBR\n\n; } mysql_free_result($result); } ? I also tried the above code, but I escaped out the underscores. Thanks a lot for your help. Sorry for the indirect mysql question. (PHP question) -Christian Evans - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Connection Pooling
Try going to www.freshmeat.net and searching for PoolMan. It's a Java library for pooling connections to MySQL. I haven't messed around with it but I saw it when trying to learn Java. Hope this helps, Jamie -Original Message- From: gaurav [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 12:33 AM To: [EMAIL PROTECTED] Subject: Connection Pooling Hi, I'm using JDBC/MySQL and the MM.MySQL driver to build JSP pages.I want to use connection pooling in my application.Kindly advice connection pooling package which is suitable for the above application. Thanking You, Gaurav Tuli - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
2008 : MySQL client run out of memory
Hello, I have this error (2008 : MySQL client run out of memory) performing a request in a PHP script. However that request works perfectly under phpMyAdmin ! I tried to do a lot of mysql_free_result() in my script (because there are a lot of requests) but I doesn't work and I think It is useless. I looked on the PHP site to see if there's not a bug but I didn't configured my PHP with the --enable-memory-limit option. I have the version 4.0.6 with the mysql built-in support. Note that I first compiled PHP with the external mysql support and I had the same error. What's the problem ? How to find the cause ? I tried a debugger called Body but It is so slow that I could die before. Thank you Patrice - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Populating mysql db from sql server 7
Is there ne way of populating the mysql db with the data from the sql server db with out doing exports like a copy or something?
Re: Build problems (+solution) on HPUX 10.20/gcc 2.95
Hi Michael, Michael Widenius wrote: Between the different configure attemtns, did you do 'rm config.cache'? If not, then there is a big change that the old content of config.cache from the first build could have affected the later builds. I got an email from Timothy Smith yesterday suggesting the same. I build a lot of packages using configure and am aware of the config.cache (guess how I found *that* out.. :))... no.. I almost automatically rm config.cache before any configure command... Any change you could quickly check on your machine if the recommended configure line from the MySQL manual would work one a clean MySQL distribution ? On our HPUX 10.20 machine, we use the following configure line to build our binaries: CFLAGS=-DHPUX -I/opt/dce/include -O3 -fpic CXX=gcc CXXFLAGS=-DHPUX -I/opt/dce/include -felide-constructors -fno-exceptions -fno-rtti -O3 ./configure --prefix=/usr/local/mysql --with-comment=Official MySQL binary --with-extra-charsets=complex --with-server-suffix= --with-pthread --with-named-thread-libs=-ldce --disable-shared Ok. So I gave it another try. I untarred the source distro into a new directory and ran the configure command above (only different prefix). Made absolutely no difference whatsoever: still a gazillion+-1 errors :). Below I have a snapshot of the kind of errors that fly by my tty I think our gcc is broken/only half installed; it can only build 32bit apps. g++ -v: Reading specs from /local/gcc-2.95/lib/gcc-lib/hppa2.0-hp-hpux10.20/2.95.2/specs gcc version 2.95.2 19991024 (release) snip In file included from /usr/include/fcntl.h:9, from ../include/global.h:176, from mysql.cc:28: /usr/include/sys/fcntl.h:212: initializer list being treated as compound express ion /usr/include/sys/fcntl.h:212: syntax error before `char' /usr/include/sys/fcntl.h:212: `mode_t c' used prior to declaration /usr/include/sys/fcntl.h:212: parse error before `{' /usr/include/sys/fcntl.h:213: initializer list being treated as compound express ion /usr/include/sys/fcntl.h:213: syntax error before `char' /usr/include/sys/fcntl.h:213: `mode_t b' used prior to declaration /usr/include/sys/fcntl.h:213: parse error before `{' In file included from /usr/include/unistd.h:11, from ../include/global.h:192, from mysql.cc:28: /usr/include/sys/unistd.h:92: syntax error before `(' /usr/include/sys/unistd.h:275: type specifier omitted for parameter /usr/include/sys/unistd.h:276: type specifier omitted for parameter /usr/include/sys/unistd.h:362: type specifier omitted for parameter /usr/include/sys/unistd.h:426: type specifier omitted for parameter /usr/include/sys/unistd.h:526: syntax error before `(' /usr/include/sys/unistd.h:528: `int truncate' redeclared as different kind of s In file included from mysql.cc:28: ./include/global.h:633: syntax error before `;' In file included from /usr/include/sys/stat.h:25, from ../include/my_dir.h:27, from mysql.cc:34: /usr/include/sys/_stat_body.h:14: syntax error before `;' /usr/include/sys/_stat_body.h:22: syntax error before `;' In file included from ../include/my_dir.h:27, from mysql.cc:34: /usr/include/sys/stat.h:167: `int stat' redeclared as different kind of symbol /usr/include/sys/stat.h:108: previous declaration of `int stat(const char *, sta t *)' /usr/include/sys/stat.h:167: initializer list being treated as compound expressi on /usr/include/sys/stat.h:167: syntax error before `char' /usr/include/sys/stat.h:167: conflicting types for `struct stat * b' /usr/include/sys/fcntl.h:213: previous declaration as `mode_t b' /usr/include/sys/stat.h:167: parse error before `{' /usr/include/sys/stat.h:168: `int fstat' redeclared as different kind of symbol /usr/include/sys/stat.h:107: previous declaration of `int fstat(int, stat *)' /snip Cheers, -- Groeten, Harro Verkouter Joint Institute for VLBI in Europe [EMAIL PROTECTED] Radiosterrenwacht Dwingeloo Postbus 2 tel.: (+31)(0)521-5965167990 AA DWINGELOO, the Netherlands fax.: (+31)(0)521-597332 -- Accident, n.: A condition in which presence of mind is good, but absence of body is better. -- Foolish Dictionary -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Instalation MySQL
Halo, I'm trying to install MySQL on a RedHat 7.0 (RPM). When I run mysql_install_db, I get the message that the grant tables has been created. I can fint it in /var/lib/mysql. Then when I run safe_mysqld --user=mysql I get a error Can't find file 'host.frm' but the are in this path. If I can only start with safe_mysqld --skip-grant-tables . Can you give me a typ? Thank's Jean-Luc
Re: 2008 : MySQL client run out of memory
If it is a memory problem, try for example ini_set(memory_limit, 16M); in your script. Otherwise, it may be a loop that keeps allocating memory until it crahes. It this is the case, you won't get it through allocating more memory. Patrice Garbe schrieb am Donnerstag, 9. August 2001, 12:43:42: Hello, I have this error (2008 : MySQL client run out of memory) performing a request in a PHP script. However that request works perfectly under phpMyAdmin ! I tried to do a lot of mysql_free_result() in my script (because there are a lot of requests) but I doesn't work and I think It is useless. I looked on the PHP site to see if there's not a bug but I didn't configured my PHP with the --enable-memory-limit option. I have the version 4.0.6 with the mysql built-in support. Note that I first compiled PHP with the external mysql support and I had the same error. What's the problem ? How to find the cause ? I tried a debugger called Body but It is so slow that I could die before. Thank you Patrice - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.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
SELECT
Hi, I'm a bit stuck at the moment with a select query. I have 2 tables a contact table and an events table. They are joined together by contact id. The data is stored in the events table like this: eventid link id contact id 1 1 1 * 2 2 1 * 3 1 2 What I want to-do is create a select statement that lets me select all the contacts from the contacts table that have followed link 1 and link 2. I'm finding this hard without subselects. Thanks Carl Chambers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Localization..
- Original Message - From: shiuwaitai [EMAIL PROTECTED] To: SDiZ Cheng [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 1:08 PM Subject: RE:Re: Localization.. Hi, try to use varchar or varchar binary instead. they work fine in my application for searching '%multibyte%multibyte%' condition even. I have tried that. MySQL match all rows i needed. But i match some row i don't want too.. let me show you an example... The charactor ¤¤ in Big5 chinese is 0xA4 0xA4. The charactor ¤ô is 0xA4 0xF4, ôô is 0xF4 0xF4. To match ôô, we should use %0xF4 0xF4%, which, in result, it match ¤ô¤¤ .. 0xA4 0xF4 0xA4 0xA4 too.. i just don't want this kind of cross-charactor match happend. Hi, I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as OS to run MySQL application. In my experience, I have not changed charset parameter in server startup, database or column. They can store latin1 and big5 properly in-a-mix. Have u tested to insert and select your records with different charsets in MySQL before changing the value of charset? the table i want to create is of mixed charsets, ie: Title VARCHAR(10), --- Latin desc_b5 VARCHAR(10), --- Big5 desc_gb VARCHAR(10), --- GB2312 desc_en VARCHAR(10), --- ASCII desc_(some other charsets...) I am now using a simple BINARY option to make this (seems) possible. INSERT work fine with this. However, _SELECT col_name from tbl_name LIKE '%(somthing)%';_ doesn't work as expected with multi-byted charsets... MySQL try to match across two characters. I don't want to use Unicode in this, as Unicode is not a complete superset of all charset i have to use, there will be some losses when i convect to other charsets.. That's why i am asking here. Beside setting charset value what problems do u face actually? Date |Tue, 7 Aug 2001 17:25:48 +0800 From |SDiZ Cheng [EMAIL PROTECTED] Hello! SC I have read these docs. I can't find any charset option in CREATE TABLE SC syntax. Oh no. You need to set up charset in mysql configuration. like this: http://www.mysql.com/doc/C/h/Character_sets.html Yes, i have read that too. that tell me how to compile mysql with multi charset, but not create such kind of table. i expect there is somthing like CREATE TABLE tbl_name ( col_name type CHARSET=char_set, col_name2 type CHARSET=char_set2 ) ... CREATE DATABASE db_name DEFAULT_CHARSET=char_set where can i find these? == ·s®ö§K¶O¹q¤l«H½c http://sinamail.sina.com.hk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 2008 : MySQL client run out of memory
Then It is not a memory problem for ini_set() didn't work. It always crashes at the same point. Mysql doc says : ERROR 2008: MySQL client ran out of memory note that the error refers to the MySQL client mysql. The reason for this error is simply that the client does not have enough memory to store the whole result. But as I said the query works with phpMyAdmin and is performed several times in the script with free_results() after each performing. Patrice Le jeu, 09 aoû 2001, vous avez écrit : If it is a memory problem, try for example ini_set(memory_limit, 16M); in your script. Otherwise, it may be a loop that keeps allocating memory until it crahes. It this is the case, you won't get it through allocating more memory. Patrice Garbe schrieb am Donnerstag, 9. August 2001, 12:43:42: Hello, I have this error (2008 : MySQL client run out of memory) performing a request in a PHP script. However that request works perfectly under phpMyAdmin ! I tried to do a lot of mysql_free_result() in my script (because there are a lot of requests) but I doesn't work and I think It is useless. I looked on the PHP site to see if there's not a bug but I didn't configured my PHP with the --enable-memory-limit option. I have the version 4.0.6 with the mysql built-in support. Note that I first compiled PHP with the external mysql support and I had the same error. What's the problem ? How to find the cause ? I tried a debugger called Body but It is so slow that I could die before. Thank you Patrice - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 2008 : MySQL client run out of memory
Patrice Garbe schrieb am Donnerstag, 9. August 2001, 14:20:04: Then It is not a memory problem for ini_set() didn't work. It always crashes at the same point. Mysql doc says : ERROR 2008: MySQL client ran out of memory note that the error refers to the MySQL client mysql. The reason for this error is simply that the client does not have enough memory to store the whole result. But as I said the query works with phpMyAdmin and is performed several times in the script with free_results() after each performing. So look at the difference between phpMyAdmin and your script. I assume that you put your query into phpMyAdmin and that's it. In your script, you will obtain the same result when you do the same, as phpMyAdmin does nothing else than call the usual php functions. Therefore, I assume that you will do some other sort of things in your script, like a huge while loop which eats up memory. It isn't hard to construct such a thing. You didn't provide your code, did you? Patrice Le jeu, 09 aoû 2001, vous avez écrit : If it is a memory problem, try for example ini_set(memory_limit, 16M); in your script. Otherwise, it may be a loop that keeps allocating memory until it crahes. It this is the case, you won't get it through allocating more memory. Patrice Garbe schrieb am Donnerstag, 9. August 2001, 12:43:42: Hello, I have this error (2008 : MySQL client run out of memory) performing a request in a PHP script. However that request works perfectly under phpMyAdmin ! I tried to do a lot of mysql_free_result() in my script (because there are a lot of requests) but I doesn't work and I think It is useless. I looked on the PHP site to see if there's not a bug but I didn't configured my PHP with the --enable-memory-limit option. I have the version 4.0.6 with the mysql built-in support. Note that I first compiled PHP with the external mysql support and I had the same error. What's the problem ? How to find the cause ? I tried a debugger called Body but It is so slow that I could die before. Thank you Patrice - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.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: 2008 : MySQL client run out of memory
Hello, I tried with unbuffered queries and It doesn't solve the problem at all I have an weird error performing select id from categories where name = 'Hifi'. The error is now : '0 : ' (nothing). There's an error but it is not defined ?!? Note that only the crashing query is unbuffered so there's no problem with mysql_num_rows(). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Populating mysql db from sql server 7
No. The data has to be moved from MSSQL to MySQL some way, and that will be either an export or a copy. AFAIK, there is no way for the two RDBMS's to communicate directly with each other ... you need some sort of intermediary. And before any data can be moved, the table schema must be created on both servers. For our application, we have a written a translation program that updates/alters our old MSSQL7 table schema to match our current MySQL schema. It then uses an ODBC connection to port the row information from MSSQL to MySQL. Theer are a number of ways to do this ... a search of the list archive will turn up many threads on this topic. Gerald Jensen - Original Message - From: stephen smithstone [EMAIL PROTECTED] To: mysql list [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 4:10 AM Subject: Populating mysql db from sql server 7 Is there ne way of populating the mysql db with the data from the sql server db with out doing exports like a copy or something? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Build problems (+solution) on HPUX 10.20/gcc 2.95
Harro Verkouter writes: Hi Michael, Ok. So I gave it another try. I untarred the source distro into a new directory and ran the configure command above (only different prefix). Made absolutely no difference whatsoever: still a gazillion+-1 errors :). Below I have a snapshot of the kind of errors that fly by my tty I think our gcc is broken/only half installed; it can only build 32bit apps. g++ -v: Reading specs from /local/gcc-2.95/lib/gcc-lib/hppa2.0-hp-hpux10.20/2.95.2/specs gcc version 2.95.2 19991024 (release) snip In file included from /usr/include/fcntl.h:9, from ../include/global.h:176, from mysql.cc:28: /usr/include/sys/fcntl.h:212: initializer list being treated as compound express ion /usr/include/sys/fcntl.h:212: syntax error before `char' cut /snip Cheers, -- Groeten, Harro Verkouter Joint Institute for VLBI in Europe [EMAIL PROTECTED] Radiosterrenwacht Dwingeloo Postbus 2 tel.: (+31)(0)521-596516 7990 AA DWINGELOO, the Netherlands fax.: (+31)(0)521-597332 OK, reinstall 2.95.2 and if the above error repeat, re-send me those errors, plus include /usr/include/sys/fcntl.h and stat.h in a direct mail to me. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Error?
As far as I know, there'll be no other solution than recovering from backup. For the old data, that is quite alright -- what I'm trying to figure out now is how to selectively restore information out of my (very large) binary database transaction log file. (Anyone have tools to this effect???) UPDATE ProjectTime set Start_Time=FROM_UNIXTIME(UNIX_TIMESTAMP(Start_Time)+2592000); I discovered this as well -- but see my other message w.r.t. this not working properly. PS, I've twice now had to explicitly add database to a message to make it pass those filters ... -- Michael T. Babcock 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: MySQL server for Sun Solaris i386?
Jeff Tanner writes: I am looking within http://www.mysql.com/downloads/mysql-3.23.html for MySQL server for Sun Solaris i386? Is MySQL server for Sun Solaris Sparc build-able on Sun Solaris i386? Thanks Jeff Tanner Viathan Seattle, WA Hi! Either build it from source or download some older contributed binary. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Not so good transaction support
What you are trying to perform is doable with InnoDB table handler. Unlike BDB, InnoDB has multi-versioning and consistent reads. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error codes ??
Looks to me like a permissions problem. If you were manipulating the MYSQL files as root or if you copied or moved them, this could happen. Look at the permissions on a working machine and match those on this machine. The permissions need to allow changes, but too permissive permissions will cause MySQL not to work as well. Michael Ridinger On Wed, 8 Aug 2001 [EMAIL PROTECTED] wrote: Hello, I seem to have corrupted mySQL deep down inside. I can not create any tables in any new databases. I will get the exact same errcode each time ... that is : SQL-query: CREATE TABLE test (user_id INT (6) not null AUTO_INCREMENT, notes VARCHAR (100) not null , PRIMARY KEY (user_id)) MySQL said: Error writing file './relata/test.frm' (Errcode: 69) I don't have root access to my server, and also can't find a list of what any of the errcodes mean. Looking for help Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Not so good transaction support
1. Please explain the above in detail. It depends on the type of table you're using. If you're using a table type that only supports table-level locking, then each transaction is isolated by being suspended until the previous transaction is done. This is slower if you do a lot of longer transactions but quite safe. I think the only difference is functions(COMMIT, ROLLBACK) support. This is true, for some table types -- for others, you'll find things work as you expected -- see InnoDB or that other table type (Gemini :-). -- Michael T. Babcock 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
mysqlbinlog
I would like to dump all sql transactions from a binary transaction log for a specific table after a specific timestamp. I can run mysqlbinlog and delete all the queries up to the point of the correct timestamp, then try to filter out the lines for other databases and tables, but a more automatic version of this would be nice. Any pointers? -- Michael T. Babcock CTO, FibreSpeed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 calculations with php and mysql
From: Joel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 3:01 AM Subject: Date calculations with php and mysql How do I find the elapsed time on a timestamp field? SELECT NOW() - field AS elapsed FROM table? Alex -- Alex Page, IT Department, Solid State Logic E-Mail: [EMAIL PROTECTED] Phone: +44 (0) 1865 842 300 Web: http://www.solid-state-logic.com ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.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: Timezone problem.
The small problem in mysql is it does not check if parameter is correct in configure script - this produced the problem... Peter mailto:[EMAIL PROTECTED] Yes, I don't know of any clear way of handling this with autoconf. Basically, if your option starts with --with-, then the script just sets a variable and moves on. If anyone knows a good way to validate --with- and --enable- options in an autoconf-generated configure script, let me know. Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-time Developer /_/ /_/\_, /___/\___\_\___/ Boone, NC 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
Embedding MySQL in an application
I have been told it is possible to embed MySQL in an application such that the user never knows a database is running underneath the app. Where can I find more information about doing this? -- Shawn P. Garbett [EMAIL PROTECTED] See http://www.garbett.org/public-key for my PGP key - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
myisamchk reports tables not closed properly
Description: I'm new to MySQL, and am porting an application from msql. Apologies in advance for blatant ignorance on my part. Apparantly the code that increments the counter on whether a table has been modified is broken. myisamchk reports that: myisamchk: warning: 1 clients is using or hasn't closed the table properly when I don't think it should. Also, note that the configuration is somewhat non-standard. How-To-Repeat: mysqladmin create foo echo CREATE TABLE try ( user CHAR(9), message TEXT) \g | mysql foo echo INSERT INTO try VALUES ('hi', 'sailor') \g | mysql foo myisamchk /usr/local/storm/MySQL/var/foo/*.MYI Fix: Fix 1: $ mysql foo mysql flush tables; mysql quit Fix 2: $ mysqladmin shutdown $ safe_mysqld All of these are only temporary. After inserting/updating to the table, the warning from myisamchk reappears. Submitter-Id: submitter ID Huh? Originator: David Harrison Organization: Dept. of Physics, Univ. of Toronto. MySQL support: [none | licence | email support | extended email support ] none Synopsis: myisamchk reports tables not closed properly Severity: Don't know. Priority: Don't know. Category: mysql Class: sw-bug Release: mysql-3.23.40 (Source distribution) Server: /usr/local/storm/MySQL/bin/mysqladmin Ver 8.21 Distrib 3.23.40, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.40-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/tmp/mysql.sock Uptime: 17 hours 21 min 20 sec Threads: 1 Questions: 214 Slow queries: 0 Opens: 45 Flush tables: 2 Open tables: 11 Queries per second avg: 0.003 Environment: System: Linux storm.physics.utoronto.ca 2.2.16-4.lfssmp #1 SMP Wed Jul 12 14:00:26 EDT 2000 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/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Nov 19 2000 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x1 root root 4101324 Feb 29 2000 /lib/libc-2.1.3.so -rw-r--r--1 root root 20272704 Feb 29 2000 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 29 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/storm/MySQL --with-mysqld-user=storm --with-unix-socket-path=/var/tmp/mysql.sock --with-tcp-port=3307 Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Encrypt Database data
Hello Is there a way to encrypt database data and to let only one user decrypt when server and client runs on the same machine? I am aware of the fact that this is not fool proof scecurity as the decryption happens in the memory and not hard to steal..but i guess its for a short time and would be complex .. Sachin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Embedding MySQL in an application
You could be more specific: Try specifying your programming language and operating system at least. - Original Message - From: Shawn P. Garbett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 2:43 PM Subject: Embedding MySQL in an application I have been told it is possible to embed MySQL in an application such that the user never knows a database is running underneath the app. Where can I find more information about doing this? -- Shawn P. Garbett [EMAIL PROTECTED] See http://www.garbett.org/public-key for my PGP key - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Optimising my select.
Hi, Thanks for the feedback on my earlier problem. I have come up with a query: SELECT *, count(contact_id) AS theCount FROM eventlog LEFT JOIN contacts ON contacts._id = eventlog.contact_id WHERE TYPE = 'CLICK' AND link_id IN (1,2) GROUP BY contact_id HAVING theCount = 2 Thing is it takes forever to run, I haven't seen it complete yet i just have to keep killing the process. I have read up on optimisation and have added some index's to the eventlog table: contact_id and link_id (contact_id on the contacts table is the PK anyways so thats fine). Any ideas on how to speed this up. (In the process list it says the state is Copying to tmp table for ages). Thanks Carl Chambers
Re: Embedding MySQL in an application
Documentation for any programming language that supports / has an interface to / uses MySQL. Try PHP (www.php.net), Perl (http://www-cgi.cs.cmu.edu/cgi-bin/perl-man), or one of the many others. Regards, Sebastiaan J.A. Kamp - Original Message - From: Shawn P. Garbett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 3:43 PM Subject: Embedding MySQL in an application I have been told it is possible to embed MySQL in an application such that the user never knows a database is running underneath the app. Where can I find more information about doing this? -- Shawn P. Garbett [EMAIL PROTECTED] See http://www.garbett.org/public-key for my PGP key - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Fwd: Re: Embedding MySQL in an application
I have been told it is possible to embed MySQL in an application such that the user never knows a database is running underneath the app. Where can I find more information about doing this? That's simple - as you write the application, keep the user interface and database totally seperate. It's as easy as writing any application that uses a database, you just have to worry a little more about which information you present to the user. I'm currently writing a database-backed web application (using perl and Template Toolkit) where the user will never have to know about the existence of keys or anything like that. As it happens, the code doesn't *have* to run off a database at all (it's nicely modular) but it's the best way of organising my information. I didn't make myself clear. Of course a user should NEVER see a database key. The design of the software will have a distinctly separate database module. The real point is, that a user can take the product out of shrink rap, install it, run the program and never fiddle one iota with installation of MySQL or even know that MySQL is running on the system. MySQL is entirely embedded within the application. Sure I could write drivers in the database module that did all this with flat-files, but ugh what a horrible thought. The plan is in the future as the product line grows is to eventually tie several products together through a seperate database engine, or have then as stand-alone packages. Microsoft advertises their MSDE (MS Data Engine), which does just this. Sits inside a program and the user never has to do any database adminstration functions--it's completly integrated into the program. Then their is the option for a seemless upgrade to MS SQL Server when more power is needed. At least that's the ad. My experience with MS products suggests that MSDE won't work and then for a mere $(excessive figure here) I can upgrade to SQL Server. I feel like it could be the classic bait and switch ploy on the part of MS. The MySQL folks have told me that this has been done and will be fully supported as part of the next release. Problem is I have to demonstrate it NOW, or I may end up stuck with MSDE since it exists NOW. MySQL is my preferred option and I'd love to stick with it across all platforms the product will be ported to. -- Shawn P. Garbett [EMAIL PROTECTED] See http://www.garbett.org/public-key for my PGP key - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbinlog
perl script At 08:50 AM 8/9/01 -0400, Michael T. Babcock wrote: I would like to dump all sql transactions from a binary transaction log for a specific table after a specific timestamp. I can run mysqlbinlog and delete all the queries up to the point of the correct timestamp, then try to filter out the lines for other databases and tables, but a more automatic version of this would be nice. Any pointers? -- Michael T. Babcock CTO, FibreSpeed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Table too large?
Hello, I have a mysql db that contains a table to track visitors, Visitor information is stored at the beginning of each page. The problem that I am having is that a few days ago the pages just stopped loading and I had to dump, drop and recreate the table with nothing in it to get the site going again. The table is about 26 meg in size (dumped file) and I am running on Red Hat 7.1 server with 90 Gig HDD with 512 Meg RAM. BTW - I have other servers running other sites with this dB and some of them are much bigger with no problems. Anyone have any thoughts ? -- Stephen Johnson [EMAIL PROTECTED] http://www.pets4u.com Owner / Founder -- your next best friend is waiting for you -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Encrypt Database data
From: sachin shetty [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 2:56 PM Subject: Encrypt Database data Is there a way to encrypt database data and to let only one user decrypt when server and client runs on the same machine? I am aware of the fact that this is not fool proof scecurity as the decryption happens in the memory and not hard to steal..but i guess its for a short time and would be complex .. The easiest way to do this would be to only allow one user access to the database with: GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'password' WITH GRANT OPTION; This should only allow user 'username' to access the database from the local machine. Alex -- Alex Page, IT Department, Solid State Logic E-Mail: [EMAIL PROTECTED] Phone: +44 (0) 1865 842 300 Web: http://www.solid-state-logic.com ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.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: Instalation MySQL
Dear Jean-Luc, check this part of the manual: http://www.mysql.com/doc/m/y/mysql_install_db.html Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Devenoge J.-L. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 11:18 AM Subject: Instalation MySQL Halo, I'm trying to install MySQL on a RedHat 7.0 (RPM). When I run mysql_install_db, I get the message that the grant tables has been created. I can fint it in /var/lib/mysql. Then when I run safe_mysqld --user=mysql I get a error Can't find file 'host.frm' but the are in this path. If I can only start with safe_mysqld --skip-grant-tables . Can you give me a typ? Thank's Jean-Luc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Embedding MySQL in an application
Dear Shawn, try PHP (www.php.net). Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Shawn P. Garbett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 3:43 PM Subject: Embedding MySQL in an application I have been told it is possible to embed MySQL in an application such that the user never knows a database is running underneath the app. Where can I find more information about doing this? -- Shawn P. Garbett [EMAIL PROTECTED] See http://www.garbett.org/public-key for my PGP key - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SELECT
Dear Carl, What I want to-do is create a select statement that lets me select all the contacts from the contacts table that have followed link 1 and link 2. I'm finding this hard without subselects. Maybe I miss out on something, but I would do it like this: SELECT * FROM contact INNER JOIN events USING (eventid) WHERE events.link_id = 1 AND events.link_id = 2 Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Carl Chambers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 11:40 AM Subject: SELECT Hi, I'm a bit stuck at the moment with a select query. I have 2 tables a contact table and an events table. They are joined together by contact id. The data is stored in the events table like this: eventid link id contact id 1 1 1 * 2 2 1 * 3 1 2 What I want to-do is create a select statement that lets me select all the contacts from the contacts table that have followed link 1 and link 2. I'm finding this hard without subselects. Thanks Carl Chambers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Embedding MySQL in an application
From: Shawn P. Garbett [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 3:07 PM Subject: Fwd: Re: Embedding MySQL in an application The real point is, that a user can take the product out of shrink rap, install it, run the program and never fiddle one iota with installation of MySQL or even know that MySQL is running on the system. So what you're essentially talking about is embedding the MySQL *binary* in an application? There are a lot of reasons why this is a bad idea - it'll replicate unnecessarily if more than one application does this, you won't be able to upgrade MySQL (to, say, fix security holes) without upgrading the application... ...but I suppose that massively monolithic, repetitive code is the way of the Windows world... MySQL is entirely embedded within the application. Sure I could write drivers in the database module that did all this with flat-files, but ugh what a horrible thought. In perl: use DBI; if ( -x /usr/local/mysql/bin/mysql ) { require DBD::mysql; } else { require DBD::CSV; } But hey, perl's good like that. The plan is in the future as the product line grows is to eventually tie several products together through a seperate database engine, or have then as stand-alone packages. This depends on your target platform. With your talk of Microsoft, I presume that you're developing for a Windows platform. The best way to do this, IMHO, would be to have the installation program for *your* application check to see if MySQL is installed (by poking in the registry?), and download and install it (perhaps invisibly) if it isn't (or you could include MySQL with the CD of your application, licensing issues permitting). If you then want to port to (say) Linux, you could have the program package have a dependency on MySQL (this seems to work very well in Debian, not sure about RPM-based distribution) which would do exactly the same - check for MySQL on install, and install it invisibly if it's not there. Hope this is of some use, Alex -- Alex Page, IT Department, Solid State Logic E-Mail: [EMAIL PROTECTED] Phone: +44 (0) 1865 842 300 Web: http://www.solid-state-logic.com ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.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
Select results to new table?
Is there a way to put the results of a SELECT into a table without going through an export file? For example, something like SELECT * FROM table_1 WHERE condition INTO table_2 Eldon Ziegler ProAtion Systems [EMAIL PROTECTED] http://www.proation.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
Fwd: Re: Fwd: Re: Embedding MySQL in an application
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Freakin' Spam filter!!! - -- Forwarded Message -- Subject: Re: Fwd: Re: Embedding MySQL in an application Date: 9 Aug 2001 14:07:44 - From: [EMAIL PROTECTED] To: Shawn P. Garbett [EMAIL PROTECTED] Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. You have written the following: You could be more specific: Try specifying your programming language and operating system at least. I'm using Linux, Debian 2.2.2 and GNU C++ with Qt for the GUI under development. Then I'm compiling under Windows 98, with Borland using C++ as well. So the true target for now is Windows 98. Although a demo under linux would probably be satisfactory for now. - -- Shawn P. Garbett [EMAIL PROTECTED] See http://www.garbett.org/public-key for my PGP key - --- - -- Shawn P. Garbett [EMAIL PROTECTED] See http://www.garbett.org/public-key for my PGP key -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE7cqaNDtpPjAQxZ6ARAmimAJwPp5EcFJaBRX0slMAyPe3klIRy7QCfYtrw pvn+6ckgSqzF5i6P1jBWXXo= =qQqz -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: Table too large?
Normally the size can be 2G, 4G or more... You can check the maximum table size for a table with the myisamchk -dv table_name or table_file if It doesn't work. You should have run myisamchk or mysqlcheck (whick worked better for me) to check your table. Le jeu, 09 aoû 2001, vous avez écrit : Hello, I have a mysql db that contains a table to track visitors, Visitor information is stored at the beginning of each page. The problem that I am having is that a few days ago the pages just stopped loading and I had to dump, drop and recreate the table with nothing in it to get the site going again. The table is about 26 meg in size (dumped file) and I am running on Red Hat 7.1 server with 90 Gig HDD with 512 Meg RAM. BTW - I have other servers running other sites with this dB and some of them are much bigger with no problems. Anyone have any thoughts ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Large tables
I have 3 tables that have all fieds the same (name, length, indexes...) The only difference is that data is stored by year(1999 in table1999, 2000 in table2000, 2001 in table2001) I don't want to merge them because each contains about 15,000,000 records and the index would'nt fit into memmory... What I would like to do is compare for example august 1999, august 2000 and august 2001. I do it like this: create temporary table tmp select * from table1999 where month(dDate)=8; insert into tmp select * from table2000 where month(dDate)=8; insert into tmp select * from table2001 where month(dDate)=8; select year(dDate), month(dDate), avg(zPrice), sum(zPrice) ... from tmp group by year(dDate), month(dDate); Is there a way to do this without using a temporary table? Any ideas? Tadej
Binary transaction log
I've been reapplying transactions to my aforementioned screwed up database. It seems however, that the binary transaction log doesn't quite work properly with user variables (with MySQL 3.23.38). I have this entry from the log: insert into Projects (ParentID, Name, LongDesc) values (@customer, VPN, VPN Work); I remember doing that transaction, and I'd done a SELECT @customer:=ID WHERE ... beforehand. Since that SELECT isn't stored in the binary log (that I can find), the value for @customer is NULL. This just seems like a bug to me (I know what my SELECT was, so I've redone it, but this would be a problem for large-scale restoring). PS. Now I feel like I'm flooding the list, but that's ok ... -- Michael T. Babcock CTO, FibreSpeed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 server for Sun Solaris i386?
I have downloaded http://www.mysql.com/downloads/mysql-3.23.html Sun Solaris (Sparc) [sun-solaris2.7-sparc] to a Sun Solaris x86 machine. Mr. Milivojevic, would not the binaries Sun Solaris (Sparc) be not compatible for Sun Solaris (x86)? Mr. Smith, after building on a Sun Solaris x86 machine, the mysql build fails when it trys to make files with suffixes of *.cc. What am I missing? Jeff Tanner Viathan Seattle, WA 98177 -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 09, 2001 4:53 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: MySQL server for Sun Solaris i386? Jeff Tanner writes: I am looking within http://www.mysql.com/downloads/mysql-3.23.html for MySQL server for Sun Solaris i386? Is MySQL server for Sun Solaris Sparc build-able on Sun Solaris i386? Thanks Jeff Tanner Viathan Seattle, WA Hi! Either build it from source or download some older contributed binary. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Embedding MySQL in an application
You need to download the MySQL-4.0 source and compile for embedded-server. This is a library that you link your programs to. It is used for small devices, like what we are doing here. I haven't found any docs on it yet, but the header files give plenty or explaination. Hope that helped Brian Austin On Thu, 9 Aug 2001, Alex Page wrote: From: Shawn P. Garbett [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 3:07 PM Subject: Fwd: Re: Embedding MySQL in an application The real point is, that a user can take the product out of shrink rap, install it, run the program and never fiddle one iota with installation of MySQL or even know that MySQL is running on the system. So what you're essentially talking about is embedding the MySQL *binary* in an application? There are a lot of reasons why this is a bad idea - it'll replicate unnecessarily if more than one application does this, you won't be able to upgrade MySQL (to, say, fix security holes) without upgrading the application... ...but I suppose that massively monolithic, repetitive code is the way of the Windows world... MySQL is entirely embedded within the application. Sure I could write drivers in the database module that did all this with flat-files, but ugh what a horrible thought. In perl: use DBI; if ( -x /usr/local/mysql/bin/mysql ) { require DBD::mysql; } else { require DBD::CSV; } But hey, perl's good like that. The plan is in the future as the product line grows is to eventually tie several products together through a seperate database engine, or have then as stand-alone packages. This depends on your target platform. With your talk of Microsoft, I presume that you're developing for a Windows platform. The best way to do this, IMHO, would be to have the installation program for *your* application check to see if MySQL is installed (by poking in the registry?), and download and install it (perhaps invisibly) if it isn't (or you could include MySQL with the CD of your application, licensing issues permitting). If you then want to port to (say) Linux, you could have the program package have a dependency on MySQL (this seems to work very well in Debian, not sure about RPM-based distribution) which would do exactly the same - check for MySQL on install, and install it invisibly if it's not there. Hope this is of some use, Alex -- Alex Page, IT Department, Solid State Logic E-Mail: [EMAIL PROTECTED] Phone: +44 (0) 1865 842 300 Web: http://www.solid-state-logic.com ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SV: [PHP-DB] Empty error ? (HELP ME)
PhpMyAdmin writes : 3.23.40-log Why -log, don't know ?... Le jeu, 09 aoû 2001, vous avez écrit : What version of Mysql is it? -Opprinnelig melding- Fra: Patrice Garbe [mailto:[EMAIL PROTECTED]] Sendt: 9. august 2001 19:45 Til: [EMAIL PROTECTED]; [EMAIL PROTECTED] Emne: [PHP-DB] Empty error ? (HELP ME) Hello, Sorry to ask so much questions but I'm in real troubles. I have an error 0 performing a query that works with phpMyAdmin. This appear in a script that performs a lot of queries before. I have PHP 4.0.6 with the mysql built-in support. I use unbuffered queries because I had a mysql client run out of memory error. I had the same problem with the external support. What can be the cause of the problem ? A lack of memory I suppose but why and where ? Thank you. Patrice -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [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
Add Character to Output
Hi, I have a select statement and want to add a Percent sign to the output of one expression. Do I have to use Concat-function or is there another way (for only one character)? Best Regards Bernhard p.S. Since this is no spam I include the words database, MySQL, query and table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bad path to ibpthread.so.14.20?
Alright, but what if I do not have a ld.so.conf file? Do I just create one in /etc/? -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 8:26 AM To: Adam Douglas Cc: Mysql@Lists. Mysql. Com (E-mail) Subject: Re: Bad path to ibpthread.so.14.20? 1. Add the path to /etc/ld.so.conf 2. Run ldconfig Adam Douglas wrote: I'm installed MySQL 3.23.37 and I can't get it started. I know there has be number of posts regarding such a problem but I haven't seen a resolution to fix mine specificly. I get this error when I try and load mysqld /usr/libexec/ld.so: my_print_defaults: libpthread.so.14.20: No such file or directory Starting mysqld daemon with databases from /var/mysql 010807 15:42:38 mysqld ended Now I know the file is located at /usr/local/lib/pth/libpthread.so.14.20 but where is the location for me to fix this bad path? Funny thing is I had MySQL Daemon running just fine but when I did a reboot I haven't been able to start it since. I can go ldconfig -m /usr/local/lib/pth/ and that seems to fix the problem for that session. Once a reboot of the system is done the path is no longer known. Frustration is settling in very quickly G. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-php mailing list
Thank you all for your help!!! The problem was set_time_limit(0); Thank YOU ALL! -Original Message- From: Werner Stuerenburg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 4:20 PM To: Jason Radley Cc: [EMAIL PROTECTED] Subject: Re: mysql-php mailing list Jason Radley schrieb am Mittwoch, 8. August 2001, 21:11:57: I have written a php script to get all the clients for a mysql table and send them emails. The problem is when the script is doing its job the browser times out and it stops the script. so I am sending about 300 email out of 3000. And the browser said page not found. Any ideas? Yes. It timed out. You adjust it with set_time_limit(0);//indefinitely -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Upgrading to 3.23.37 from 3.22.32
Ok but I've have chmod 777 on a couple of tables and I still receive table in read only message. Plus I was under the understanding that you only need say 700 because the mysql daemon it self would be modifying the files directly and not the client using MySQL. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 08, 2001 7:38 AM To: Adam Douglas Cc: [EMAIL PROTECTED] Subject: Re: Upgrading to 3.23.37 from 3.22.32 Except, mysql needs write permission. Adam Douglas wrote: MySQL reports read only table. As for file permissions, everything is fine. Everyone has read and execute privileges. They are probably not owned by mysql anymore. Adam Douglas wrote: I just upgraded MySQL from 3.22.32 to MySQL 3.23.37. All I did was pkg_delete the old MySQL and install the new one. Before I delete the old MySQL I copied all the database files to a temporary location. Once the new installation was successful I copied over all the database files into the proper location. My problem is I seem to have 3 extra tables now, A-1, A-9 and A-ce. The funny thing is they all seem to be linked to my tables. These tables to my knowledge were not present in the MySQL 3.22.32. Also I can't seem to remove the test user from mysql-db, MySQL says it's read only. I never made the table read only and doesn't seem to be. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fatal warning in MySQL build Sun Solaris x86
mysql.cc, line 1187: [__1cVbuild_completion_hash6Fbb_v_]: OPT: Unknown linkage type in dependency graph 1 fatal error Ideas? Thanks Jeff Tanner Seattle, WA - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Select results to new table?
Is there a way to put the results of a SELECT into a table without going through an export file? For example, something like SELECT * FROM table_1 WHERE condition INTO table_2 You can CREATE a table with the new data: CREATE table_2 SELECT * from table_1 You can also INSERT or REPLACE into a table: INSERT into table_2 SELECT * from table_1 / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 server for Sun Solaris i386?
On 2001 Aug 09, Jeff Tanner [EMAIL PROTECTED] wrote: I have downloaded http://www.mysql.com/downloads/mysql-3.23.html Sun Solaris (Sparc) [sun-solaris2.7-sparc] to a Sun Solaris x86 machine. Mr. Milivojevic, would not the binaries Sun Solaris (Sparc) be not compatible for Sun Solaris (x86)? No, they are not compatible. Different architectures = different instruction set = different binaries! Mr. Smith, after building on a Sun Solaris x86 machine, the mysql build fails when it trys to make files with suffixes of *.cc. What am I missing? Good question. From that info, all I can guess is that your C++ compiler isn't working right. Did you check our Solaris notes in the manual? Tim -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Tim Smith [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-time Developer /_/ /_/\_, /___/\___\_\___/ Boone, NC 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
group by and make_set
Is there a way to have SELECT return sets for rows that were grouped together? So if I had a table like: Table: ID DATA 1a 1b 2X 2Y 310 320 I want to do something like this: SELECT MAKE_SET(-1,DATA) as LIST FROM Table GROUP BY ID ID DATA 1a,b 2X,Y 310,20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BSD/OS 4.1 binary for MySql
Is the freebsd-elf mysql binary available at mysql.com compatible with BSD/OS (bsdi) 4.1? If not, is there a place to download this binary...or am I stuck with building it myself? Thanks, David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlbinlog
So how can I log all the queries. Can I define a log (not binary log) file in my.cnf using for instance log=filename in the mysqld section ? Do I have to disable log-binary to use normal log ? This is my startup: /usr/bin/safe_mysqld \ --log=/var/log/mysql/query_log --log-bin=/var/log/mysql/transaction_log.bin \ --log-slow-queries=/var/log/mysql/slow_query_log \ --bdb-tmpdir=/var/mysql/bdb/tmp \ --bdb-logdir=/var/mysql/bdb/logs' query_log is the log of all queries done by the server. transaction_log is the binary replay log for running after restoring from backup. slow_query_log is all the queries that took over 10 seconds to execute. -- Michael T. Babcock CTO, FibreSpeed - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Protection of /tmp/mysql.sock
Hi i think this isnt a purely mysql specific question but surely related. I have a stick bit set on the /tmp directory(Solaris) where the socket file resides.But there is no protection on the file because ppl apart from the owner of the file can delete the file.. Sachin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Optimising for 4096MB RAM
Hi there, I am trying to optimise MySQL for use on a machine with: Linux 2.4.7-ac9 (only kernel to work with the disk controller) Dual Pentium III 1000 MHz 4096 MB memory RAID-1 Mirror over two 76GB 7200 RPM UDMA disks Reiserfs partition for MySQL As a reference point, I am running the benchmarking tests to measure the performance. I plan on measuring the performance with our particular queries after this. After reading the section of the manual dealing with performance tuning, I used the following in my.cnf: [mysqld] set-variable = join_buffer=2048M set-variable = key_buffer=2048M set-variable = table_cache=1024 set-variable = max_allowed_packet=16M set-variable = max_connections=200 set-variable = record_buffer=2048M set-variable = sort_buffer=2048M set-variable = tmp_table_size=2048M The problem is that these settings don't seem to have practically any effect on the amount of memory that MySQL uses when running the benchmarking suite - I expected it to chew up large amounts of memory with these settings. MySQL is currently only taking up 25MB of RAM - not the 512MB plus I was expecting. This machine is going to be a dedicated database server for a number of web servers - I expected MySQL to take up about half the memory, and disk caching the other half. I want it to run like a beast posessed :) Does anyone have any real world examples and/or suggestions for how to increase the performance? Any other variables I should be looking at? When the machine is operational, the biggest table I expect to be using has 55 million rows and takes up about 2G disk space (compressed, packed, everything). Please could you CC: any replies to me, since I am no longer on the list. Regards, Corin /+-\ | Corin Hartland-Swann |Tel: +44 (0) 20 7491 2000| | Commerce Internet Ltd |Fax: +44 (0) 20 7491 2010| | 22 Cavendish Buildings | Mobile: +44 (0) 79 5854 0027| | Gilbert Street | | | Mayfair|Web: http://www.commerce.uk.net/ | | London W1K 5HJ | E-Mail: [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: mysqlimport error!
That means the server does not have permission to read the file. James E. Hicks III wrote: What exactly does this error mean? mysqlimport: Error: Can't get stat of '/home/jameshicks/NONSTOCK' (Errcode: 13), when using table: NONSTOCK James 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 -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication problems
We are looking for a solution to backing up a remote database, without using mysqldump, and replication seemed to offer the solution required. I set up the master/slave configurations on both the master and the slave exactly the way it was shown in the MySQL documentation (4.10.3 How To Set Up Replication), With some additional options as shown: MASTER my.cnf [mysqld] log-bin binlog-do-db=masterslave server-id=1 SLAVE my.cnf [mysqld] master-host=172.16.0.100 master-user=rep1 master-password='yesmaster' master-port=3306 server-id=2 replicate-do-db=masterslave I checked the slave status thinking it was telling me everything was fine mysql show slave status; | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | | 172.16.0.100 | rep1| 3306| 60 | | 4| Yes | masterslave | | I made some updates on the master, a couple of inserts and deletes. Not a thing happened to the slave after a few minutes. I checked the error log to see if anything was wrong and this was written a few times (assuming each new attempt at a connection) 010809 13:16:51 Slave thread: error connecting to master:Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)(0), retry in 60 sec I re-input my GRANT several times (checking/retyping the password each time), then connected remotely with the mysql -h option (not a problem) Has anyone else encountered this problem, and/or does anyone have a solution.. Thank you Luc Foisy Technical Magic 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 Phone: (613) 829-7117 Fax: (613) 596-5096 E-Mail: [EMAIL PROTECTED] Fulfilling the Promise of Technology - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
convert a Unify Database to a mySQL database
Hi, Has anybody tried to concert a UNIFY database into a mySQL database? Has anybody even heard of UNIFY? GRIN Tim
Re: myisamchk reports tables not closed properly
[EMAIL PROTECTED] wrote: Description: I'm new to MySQL, and am porting an application from msql. Apologies in advance for blatant ignorance on my part. Apparantly the code that increments the counter on whether a table has been modified is broken. myisamchk reports that: myisamchk: warning: 1 clients is using or hasn't closed the table properly when I don't think it should. Also, note that the configuration is somewhat non-standard. How-To-Repeat: mysqladmin create foo echo CREATE TABLE try ( user CHAR(9), message TEXT) \g | mysql foo echo INSERT INTO try VALUES ('hi', 'sailor') \g | mysql foo myisamchk /usr/local/storm/MySQL/var/foo/*.MYI Don't run myisamchk while the server is running. -- Gerald L. Clark [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:InnoDB and table optimization?
Philip, InnoDB does not give an exact number of rows to the query analyzer. A problem is that in a multiversioned database different transactions will see a different number of rows in the table, and a single count of rows cannot be kept. It is an eternal problem in query optimization. Errors in estimates will toggle query plans to another, and some queries will run faster, others slower. The estimation algorithm in InnoDB tends to underestimate the number of rows in big index trees or subtrees. I changed the code now so that it multiplies the estimate by 2 if the tree height is 1. The change is already in the upcoming 3.23.41. I do not know if this change will toggle your query plan. A better solution is to make more dives into the tree to estimate the number of rows. Currently only two dives are made, at the sides of the index tree. This is on my TODO list, but improvement in join optimization will not be that big because errors in other factors are bigger: for example, if the table fits in the buffer pool, a search down the index tree runs in about 10 microseconds, while a search which requires a disk seek takes 10 milliseconds. Another solution is to implement ANALYZE TABLE. A 1000-fold error in query time estimates is very common in SQL databases. The classic trick to guide the query optimizer of SQL is to put a column inside a function. For example, WHERE col1 = 'asadsd' AND col2 = 5; can be changed to WHERE SUBSTRING(col1, 0, 128) = 'asadsd' AND col2 + 0 = 5; Then MySQL cannot use the WHERE condition, and the query plan may toggle. In your case there was an index 'running'. Maybe you can prevent its use this way? Regards, Heikki http://www.innodb.com Copied message: I've got a table with roughly 1 rows that's being joined with several other tables Ten-thousand rows isn't a whole lot, but it makes a difference. With MyISAM, the query is optimized perfectly, exactly how I would expect it to be optimized given our indexing scheme, but when I switch the table type to InnoDB, it shifts the query to a much more inefficient one. Sometimes, given enough database usage, internal numbers must shift around, because it reverts to the old optimization and we gain about 10% free CPU. It appears that it has to do with the table information. While 'SHOW TABLE STATUS' is supposed to give inaccurate data for InnoDB tables concerning things like row count, I would expect the optimizer to still get the correct information. However, the inefficient query searches through all the rows in this 1 row table because it thinks it only has to look through half of them (which, if that were true, *would* yield a more efficient query). Is this a known issue, or is EXPLAIN returning the wrong information? On the rare occasion the query explanation reverts to its old plan, we get a significant reduction in resources, but I can't *make* it shiftback. Here is the query explanation with the 1 row table as a MyISAM table (table p is the 1 row table): +---++--+-+-+--- -- \ +--+-+ | table | type | possible_keys| key | \ key_len | ref | rows | Extra | \ +---++--+-+-+--- -- \ +--+-+ | h | ref| PRIMARY,active | active |\ 4 | const | 20 | Using temporary | | p | ref| \ deleted,hid,running,ptid | hid | 4 | h.hid | 378 | where \ used | | pt| eq_ref | PRIMARY | PRIMARY | 4 | p.ptid \ |1 | where used | | pth | eq_ref | PRIMARY | PRIMARY |\ 4 | p.pid |1 | | | sl| eq_ref | PRIMARY \ | PRIMARY | 4 | p.pid |1 | | | pdc | ref\ | PRIMARY | PRIMARY | 4 | p.pid | 13 | Using \ index | | sd| eq_ref | PRIMARY | PRIMARY | 4 | \ pdc.dep_pid |1 | | | plf | eq_ref | PRIMARY \ | PRIMARY | 4 | p.pid |1 | | | ptt | eq_ref \ | PRIMARY | PRIMARY | 4 | p.ptid |1 | \ | | wft | eq_ref | PRIMARY | PRIMARY | 36 | \ pt.logtype,plf.type |1 | | \ +---++--+-+-+--- -- \ +--+-+ Here it is with the 1 row table as an InnoDB table (the only thing that has changed is the table type of p; all other tables are InnoDBtables): +---++--+-+-+--- -- \ +--+-+ | table | type | possible_keys | \ key | key_len | ref | rows | Extra | \
Condensing results, sort of
I was wondering if there's a way to condense results given by a query. What I'm looking at is a situation where the following query will give me a number of rows with all but 1 column the same. I'd like to concatenate that one column (with a user specified string) so that I don't have to break the query up into multiple queries. I also would like to use the limit clause, so, programmatically condensing the results does me no good. SELECT i.incident_id, i.description, r.location, d.name DATE_FORMAT(r.incident_date_time,%m/%d/%Y) AS date FROM incident AS i, report AS r, individual AS d, involved AS v WHERE i.incident_id=r.incident_id AND i.incident_id=v.incident_id AND d.individual_id=v.individual_id ORDER BY r.incident_date_time LIMIT 0,10 Is what I'm looking for possible? (Am I just overlooking something very simple?) Justin -- []--[] || [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] || || AIM:eZZeWeZZa ICQ:21584649 IRC:TeknoFobe IRC:Loc-Dog || []--[] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Instalation MySQL
Hello, I run the install of mysql on RedHat 7.0 via RPM successfully. But when I try /usr/bin/safe_mysqld --user=mysql or with whatever other option, I've the message: Starting mysql daemon with databases from /var/lib/mysql 010809 20;59:28 mysqld ended and when I try mysql -u root or another client I get the message: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' I can you give me some trips? I've already visit the site below without any success. check this part of the manual: http://www.mysql.com/doc/m/y/mysql_install_db.html Regards, Thanks. = ~~~ # Jules NKAMLA TENE # # D.U.T. Informatique # # Elève Ingénieur. # # Cel:(237)611613 # # [EMAIL PROTECTED] # ~ ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.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
problem!!
I installed MySQL 3.23.40 perfectly without ploblems... but I installed MySQL for database to PHP 4.0.6 with Apache 1.3.20... but when I compile Apache, this error ocours: === src/modules gcc -c -I./os/unix -I./include -DLINUX=22 -I/usr/local/php-4.0.6 -I/usr/local/php-4.0.6/main -I/usr/local/php-4.0.6/main -I/usr/local/php-4.0.6/Zend -I/usr/local/php-4.0.6/Zend -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` modules.c gcc -c -I./os/unix -I./include -DLINUX=22 -I/usr/local/php-4.0.6 -I/usr/local/php-4.0.6/main -I/usr/local/php-4.0.6/main -I/usr/local/php-4.0.6/Zend -I/usr/local/php-4.0.6/Zend -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` buildmark.c gcc -DLINUX=22 -I/usr/local/php-4.0.6 -I/usr/local/php-4.0.6/main -I/usr/local/php-4.0.6/main -I/usr/local/php-4.0.6/Zend -I/usr/local/php-4.0.6/Zend -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci`\ -o httpd buildmark.o modules.o modules/standard/libstandard.a modules/php4/libphp4.a main/libmain.a ./os/unix/libos.a ap/libap.a lib/expat-lite/libexpat.a -Wl,-rpath,/usr/local/mysql-3.23.40-pc-linux-gnu-i686/lib -rdynamic -L/usr/local/mysql-3.23.40-pc-linux-gnu-i686/lib -Lmodules/php4 -L../modules/php4 -L../../modules/php4 -lmodphp4 -lpam -ldl -lmysqlclient -lcrypt -lresolv -lm -ldl -lnsl -lresolv -lm -lcrypt /usr/local/mysql-3.23.40-pc-linux-gnu-i686/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress' /usr/local/mysql-3.23.40-pc-linux-gnu-i686/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to `compress' collect2: ld returned 1 exit status make[2]: *** [target_static] Error 1 can you give-me a help plis?? I live in Brazil and I don't speak english very well, then, if you can speak portuguese with me, I thanks!! Bye!! Raoni F. Novellino. ___ Yahoo! GeoCities Tenha seu lugar na Web. Construa hoje mesmo sua home page no Yahoo! GeoCities. É fácil e grátis! http://br.geocities.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
Problem with UPDATE statement
I have a table 'cdrequest' it has columns 'albumfill' and 'releasedatefill' among others when i do the following query with myphpadmin update cdrequest set albumfill = hot shots II, releasedatefill = 20010708 where requstID = 2; i get: You have an error in your SQL syntax near '\hot shots II\, releasedatefill = 20010708 where requstID = 2' at line 1 I can't see any reason for the error. part 2: when I flip to properties for the cdrequest just to make sure i'm spelling the columns corectly and cut and paste the exact same query on that page IT WORKS Why would it work on that page but not the other. both are supposed to be places where you can enter a normal sql query.. It also doesn't work in my PHP script which is where I really want it to work. What am I missing?? thanx Julian btw. I've tried all different combinations of double quotes and single quotes so it's not that - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Migrating from MS SQLserver to MySQL
Thanks Schajee, Did you let Access make an SQL-script to build your tables ? You could then use such scripts in mySQL to produce a copy of the database. And what would you be using for the import of the data ? cheers, bart -Oorspronkelijk bericht- Van: Schajee Achmad [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 9 augustus 2001 7:45 Aan: Bart Goormans Onderwerp: Re: Migrating from MS SQLserver to MySQL I had an almost similar problem with conversion from Access to MySQL and that was easily solved by generating an SQL query. What access did was it generated an SQL query that was run on MySQL and that sort of imported/converted all data to MySQL. Try that same thing MS SQL. I'm sure there'll be someting that might do that. --- Bart Goormans [EMAIL PROTECTED] wrote: Hi all, There's a fairly large MS SQLserver Database that my client wants me to convert to MySQL. Can someone advice me on how to tackle this, or direct me to some help. There aren't any BLOBs-fields or other exotic field types, mainly straightforward text/integers, so I don't expect too much problems on that. The main issue will be its size, so an intermediate tab-delimited textfile might not be useable. (?) Thanks, Bart -- --- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.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
how to erase all data in database (table)
How can I erase all data except for the fields in mysql table? I just want to fill all data again in the same table. Dmitry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 my my.cnf file -- not there by default?
I'm still testing out MySQL and I'm trying to find the my.cnf file referred to at http://www.mysql.com/doc/O/p/Option_files.html The page says to look in: /etc/my.cnf DATADIR/my.cnf defaults-extra-file (The file specified with --defaults-extra-file=# ) ~/.my.cnf but none of these files seem to exist on my machine. (I assume my DATADIR is /var/lib/mysql/, since it contains subdirectories and subfiles like ./var/lib/mysql/menagerie ./var/lib/mysql/menagerie/pet.frm ./var/lib/mysql/menagerie/pet.MYI ./var/lib/mysql/menagerie/pet.MYD which I assume represent the data stored in the menagerie database that I created while going through the MySQL tutorial.) I searched the machine for files with mysql in the path and .cnf in the name (I had to look up how to do that, to give you an idea of my level of experience with UNIX) but found only: ./usr/doc/MySQL-3.23.36/my-huge.cnf ./usr/doc/MySQL-3.23.36/my-large.cnf ./usr/doc/MySQL-3.23.36/my-medium.cnf ./usr/doc/MySQL-3.23.36/my-small.cnf ./usr/share/mysql/my-huge.cnf ./usr/share/mysql/my-large.cnf ./usr/share/mysql/my-medium.cnf ./usr/share/mysql/my-small.cnf which are sample files. MySQL came pre-installed on that machine. Is it possible (or, indeed, normal) that the MySQL installation process didn't create a my.cnf file? (In that case I'd recommending adding that info to http://www.mysql.com/doc/O/p/Option_files.html , if the author of those pages is on the list. I'll submit a comment there anyway based on what the list replies.) -Bennett [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: local MySQL server authenticating users by machine username
At 06:04 PM 8/8/2001 -0500, Paul DuBois wrote: At 2:50 PM -0700 8/8/01, Bennett Haselton wrote: The first page of the MySQL tutorial at: http://www.mysql.com/doc/C/o/Connecting-disconnecting.html says that when you connect to the MySQL server, it authenticates you based on a username and password that you enter, unless the server is also configured to allow anonymous access, in which case you can log in with no username. Isn't it also true that if you connect to the MySQL server on your local machine, the server authenticates you based on the username that you're already logged in under? Not quite. The server has no idea who you're logged in as. The mysql client program uses your login name as the default MySQL user name if you don't specify any user name explicitly. Oh OK. The behavior makes sense now. However, the page at http://www.mysql.com/doc/C/o/Connecting-disconnecting.html says: Some MySQL installations allow users to connect as the anonymous (unnamed) user to the server running on the local host. If this is the case on your machine, you should be able to connect to that server by invoking mysql without any options: shell mysql which sounds like it's incorrect -- if you invoke mysql without specifying a username, it actually uses your login name as the username. I added a comment on that page. -Bennett [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Missing Symbol mysql_real_escape_string in 3.23.40-win
Hi, I use the windows binary distribution from www.mysql.com (version 3.23.40). When I try to use the function mysql_real_escape_string, the linker complains about not finding it... Solution is easy :-) Add the symbol to libmysql.def and recompile... Cheers Oliver -- \\\/// ++ \\// +-+ | Oliver Billmann|( .. )|[EMAIL PROTECTED] | ++-ooO-(__)-Ooo-+-+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to erase all data in database (table)
DELETE FROM tablename; where tablename is the name of the table. -Bennett At 05:23 PM 8/9/2001 -0400, Dmitry Kashlev wrote: How can I erase all data except for the fields in mysql table? I just want to fill all data again in the same table. Dmitry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to erase all data in database (table)
In the last episode (Aug 09), Dmitry Kashlev said: How can I erase all data except for the fields in mysql table? I just want to fill all data again in the same table. TRUNCATE TABLE tablename or DELETE * FROM tablename -- Dan Nelson [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: Optimising for 4096MB RAM
You might want to look into what your ulimit settings are for the process starting mysql... usually this can be done with 'ulimit -a' but check your shells man page for more info. You could have a memory limit set for the process and mysql is not able to use the amount of memory you specify. Keep in mind that mysql doesnt actually allocate all the memory you let it until it needs it, so utilities like 'top' wont show the full amount of memory mysql will use until its been up for a while and sufficiently 'used'. Also, your computer has 4096MB or ram, you shouldnt let mysql use absolutly all of it you should keep some of the OS + the other stuff that runs on the computer (if any). ryan - Original Message - From: Corin Hartland-Swann [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 1:41 PM Subject: Optimising for 4096MB RAM Hi there, I am trying to optimise MySQL for use on a machine with: Linux 2.4.7-ac9 (only kernel to work with the disk controller) Dual Pentium III 1000 MHz 4096 MB memory RAID-1 Mirror over two 76GB 7200 RPM UDMA disks Reiserfs partition for MySQL As a reference point, I am running the benchmarking tests to measure the performance. I plan on measuring the performance with our particular queries after this. After reading the section of the manual dealing with performance tuning, I used the following in my.cnf: [mysqld] set-variable = join_buffer=2048M set-variable = key_buffer=2048M set-variable = table_cache=1024 set-variable = max_allowed_packet=16M set-variable = max_connections=200 set-variable = record_buffer=2048M set-variable = sort_buffer=2048M set-variable = tmp_table_size=2048M The problem is that these settings don't seem to have practically any effect on the amount of memory that MySQL uses when running the benchmarking suite - I expected it to chew up large amounts of memory with these settings. MySQL is currently only taking up 25MB of RAM - not the 512MB plus I was expecting. This machine is going to be a dedicated database server for a number of web servers - I expected MySQL to take up about half the memory, and disk caching the other half. I want it to run like a beast posessed :) Does anyone have any real world examples and/or suggestions for how to increase the performance? Any other variables I should be looking at? When the machine is operational, the biggest table I expect to be using has 55 million rows and takes up about 2G disk space (compressed, packed, everything). Please could you CC: any replies to me, since I am no longer on the list. Regards, Corin /+-\ | Corin Hartland-Swann |Tel: +44 (0) 20 7491 2000| | Commerce Internet Ltd |Fax: +44 (0) 20 7491 2010| | 22 Cavendish Buildings | Mobile: +44 (0) 79 5854 0027| | Gilbert Street | | | Mayfair|Web: http://www.commerce.uk.net/ | | London W1K 5HJ | E-Mail: [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
connecting by knowing someone's scrambled password?
http://www.mysql.com/doc/U/s/User_names.html says: MySQL encrypts passwords using a different algorithm than the one used during the Unix login process. See the descriptions of the PASSWORD() and ENCRYPT() functions in section 6.4.12 Miscellaneous Functions. Note that even if the password is stored 'scrambled', and knowing your 'scrambled' password is enough to be able to connect to the MySQL server! How is that possible? Even if you do know someone's scrambled password, when you connect to the MySQL server pretending to be that user, it will ask you for their non-scrambled password. After you type it in, the server will scramble it and check that the scrambled value matches the scrambled value stored in the database -- but you can't intercept that part of the process and insert the known scrambled password to be checked. -Bennett [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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!!
I installed MySQL 3.23.40 perfectly without ploblems... but I installed MySQL for database to PHP 4.0.6 with Apache 1.3.20... but when I compile Apache, this error ocours: === src/modules gcc -c -I./os/unix -I./include -DLINUX=22 -I/usr/local/php-4.0.6 -I/usr/local/php-4.0.6/main -I/usr/local/php-4.0.6/main -I/usr/local/php-4.0.6/Zend -I/usr/local/php-4.0.6/Zend -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` modules.c gcc -c -I./os/unix -I./include -DLINUX=22 -I/usr/local/php-4.0.6 -I/usr/local/php-4.0.6/main -I/usr/local/php-4.0.6/main -I/usr/local/php-4.0.6/Zend -I/usr/local/php-4.0.6/Zend -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci` buildmark.c gcc -DLINUX=22 -I/usr/local/php-4.0.6 -I/usr/local/php-4.0.6/main -I/usr/local/php-4.0.6/main -I/usr/local/php-4.0.6/Zend -I/usr/local/php-4.0.6/Zend -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6/TSRM -I/usr/local/php-4.0.6 -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED `./apaci`\ -o httpd buildmark.o modules.o modules/standard/libstandard.a modules/php4/libphp4.a main/libmain.a ./os/unix/libos.a ap/libap.a lib/expat-lite/libexpat.a -Wl,-rpath,/usr/local/mysql-3.23.40-pc-linux-gnu-i686/lib -rdynamic -L/usr/local/mysql-3.23.40-pc-linux-gnu-i686/lib -Lmodules/php4 -L../modules/php4 -L../../modules/php4 -lmodphp4 -lpam -ldl -lmysqlclient -lcrypt -lresolv -lm -ldl -lnsl -lresolv -lm -lcrypt /usr/local/mysql-3.23.40-pc-linux-gnu-i686/lib/libmysqlclient.a(my_compress.o): In function `my_uncompress': my_compress.o(.text+0x9a): undefined reference to `uncompress' /usr/local/mysql-3.23.40-pc-linux-gnu-i686/lib/libmysqlclient.a(my_compress.o): In function `my_compress_alloc': my_compress.o(.text+0x12a): undefined reference to `compress' collect2: ld returned 1 exit status make[2]: *** [target_static] Error 1 can you give-me a help plis?? I live in Brazil and I don't speak english very well, then, if you can speak portuguese with me, I thanks!! Bye!! Raoni F. Novellino. ___ Yahoo! GeoCities Tenha seu lugar na Web. Construa hoje mesmo sua home page no Yahoo! GeoCities. É fácil e grátis! http://br.geocities.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: how to erase all data in database (table)
Run a query like this ... USE database; DELETE FROM tblname; Gerald Jensen - Original Message - From: Dmitry Kashlev [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 4:23 PM Subject: how to erase all data in database (table) How can I erase all data except for the fields in mysql table? I just want to fill all data again in the same table. Dmitry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
About installing MySQL on Linux 7.1
Excuse Me, I'm a starter to Linux. I've downloaded the MySQL-3.23.40-1 for my Linux OS. They are in .rpm form. How can I install the software properly on Linux? I try to follow the instructions mentioned in manual.txt but it didn't work. Can you help me and tell my how to install it via RPM? Thanks! Please send me the solution. E-mail : [EMAIL PROTECTED]
root/bhaselto same pwd, but mysql thinks one is blank
I gave the same password to user root and user bhaselto, using the statements: UPDATE user SET Password=PASSWORD('') WHERE user='root'; UPDATE user SET Password=PASSWORD('') WHERE user='bhaselto'; (using the real password instead of '', of course). The 'user' table shows them as having the same scrambled password: mysql select Host, User, Password from user; +---+--+--+ | Host | User | Password | +---+--+--+ | localhost | root | | | localhost.localdomain | root | | | localhost | | | | localhost.localdomain | | | | localhost | bhaselto | | +---+--+--+ 5 rows in set (0.00 sec) (where '' represents the scrambled password, and is *the same* in all three places -- I've obfuscated it here even though I still can't see how you could break into someone's account knowing only the scrambled password, since it's non-reversible). However, only user root appears to have a non-blank password. If I try mysql -u root from the command line, I can't log in, and instead I have to enter mysql -u root -p and then type the '' password when prompted. This is expected. But when I try to log in as bhaselto, I can type mysql -u bhaselto and log right in with no password. If I type mysql -u bhaselto -p and then get prompted for a password, I have to hit Enter (submitting a blank password) to log in. I tried stopping and starting the mysql service but it didn't help. Why does mysql not ask for a password for user bhaselto? Related question: if I try accessing the database using the DBI perl module, then: my $dbh = DBI-connect(DBI:mysql:database=menagerie;host=localhost, 'root', # username '', # password {'RaiseError' = 1 } ); connects *succesfully*. However, this code: my $dbh = DBI-connect(DBI:mysql:database=menagerie;host=localhost, 'bhaselto', # username '', # password {'RaiseError' = 1 } ); fails with the error: DBI-connect(database=menagerie;host=localhost) failed: Access denied for user: 'bhaselto@localhost' (Using password: YES) at dbdtest.pl line 5 And this code: my $dbh = DBI-connect(DBI:mysql:database=menagerie;host=localhost, 'bhaselto', # username '', # password {'RaiseError' = 1 } ); (i.e. using a blank password for user bhaselto) fails with the error: DBI-connect(database=menagerie;host=localhost) failed: Access denied for user: '@localhost' to database 'menagerie' at dbdtest.pl line 5 So, if the password for user bhaselto really is blank, why didn't the second example work? And, for that matter, in the second example, it was the *password* that was blank, not the *username* -- so why did the error message refer to user: '@localhost'? It seems like it should have referred to user: 'bhaselto@localhost' since I did give the username as bhaselto. Thanks very much to anyone who can help me sort this out! :) -Bennett [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ACT Conversion
We are moving away from windows all together in the office I work for, one of our major programs that we use here is ACT2 DB. Can someone point me in the right direction of converting a ACT2 DB to MySQL. ANy help is greatly appreciated. Kat - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ACT Conversion
Kat: This can be a little tricky ... the version of ACT! you have is pretty old. ACT! is ... TTBOMK ... based on FoxPro. Unfortunately, it doesn't support ODBC, so it doesn't connect to other DB servers. The only way I have been able to port the data from ACT! is to use the built-in export data function, and squirt the data out to a delimited text file. You can import that file into MySQL, but you'll have to create the database schema first. Good luck! Gerald Jensen - Original Message - From: James McLaughlin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 09, 2001 8:32 PM Subject: ACT Conversion We are moving away from windows all together in the office I work for, one of our major programs that we use here is ACT2 DB. Can someone point me in the right direction of converting a ACT2 DB to MySQL. ANy help is greatly appreciated. Kat - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
innobase .39b problems
After succesfully upgrading to .39b things seemed to be running great... However the past few days I have been having some problems with queries not completing. This only seems to occur during higher loads and I am not sure where to begin debuging. I was hoping someone has some ideas... Here is the output of mysqladmin processlist... From the time field you can see those queries have been going for a very long time, and under normal circumstances they finish in under a second. | 27 | forums | localhost | forums | Query | 20014 | statistics | SELECT m. messageid,groupid,m.userid,subject,postdate,replies,realname,replace(publice mail ,'\'','\\\' | | 44 | forums | localhost | forums | Query | 19941 | statistics | SELECT m. messageid,groupid,m.userid,subject,postdate,replies,realname,replace(publice mail ,'\'','\\\' | | 55 | forums | localhost | forums | Query | 20090 | statistics | SELECT m. messageid,groupid,m.userid,subject,postdate,replies,realname,replace(publice mail ,'\'','\\\' | | 77 | forums | localhost | forums | Query | 6736 | statistics | SELECT * FROM users WHERE username = LOWER('xxx') AND password = PASSWORD('xxx') | | 82 | forums | localhost | forums | Query | 19981 | statistics | SELECT m.messageid,groupid,m.userid,subject,postdate,replies,realname,replace(publi cemail,'\'','\\\' | | 84 | forums | localhost | forums | Query | 20434 | Sending data | SELECT m.messageid,m.parentmsgid,groupid,m.userid,subject,postdate,replies,realname ,publicemail FROM | | 85 | forums | localhost | forums | Query | 20186 | statistics | SELECT m.messageid,groupid,m.userid,subject,postdate,replies,realname,replace(publi cemail,'\'','\\\' | | 89 | forums | localhost | forums | Query | 19826 | statistics | SELECT m.messageid,groupid,m.userid,subject,postdate,replies,realname,replace(publi cemail,'\'','\\\' | | 90 | forums | localhost | forums | Query | 19773 | statistics | SELECT m.messageid,groupid,m.userid,subject,postdate,replies,realname,replace(publi cemail,'\'','\\\' | | 91 | forums | localhost | forums | Query | 19622 | Sending data | SELECT m.messageid,m.parentmsgid,groupid,m.userid,subject,postdate,replies,realname ,publicemail FROM | | 92 | forums | localhost | forums | Sleep | 11129 | | | | 95 | forums | localhost | forums | Sleep | 17126 | | | | 99 | forums | localhost | forums | Query | 6498 | statistics | SELECT * FROM users WHERE username = LOWER('xxx') AND password = PASSWORD('xxx')| | 116 | forums | localhost | forums | Query | 108 | statistics | SELECT * FROM users WHERE username = LOWER('xxx') AND password = PASSWORD('xxx')| | 118 | forums | localhost | forums | Sleep | 3350 | | | | 122 | forums | localhost | forums | Query | 1625 | statistics | SELECT m.messageid,groupid,m.userid,subject,postdate,replies,realname,replace(publi cemail,'\'','\\\' | | 126 | root | localhost || Query | 0 | | show processlist Here is the query that is being 'locked': SELECT m.messageid,groupid,m.userid,subject,postdate,replies,realname,replace(publi cemail,'\\'','\\'') AS publicemail FROM messages AS m LEFT JOIN users AS u ON (m.userid = u.userid) WHERE m.groupid = $groupid AND m.parentmsgid = 0 AND m.clean = 1 ORDER BY postdate DESC limit 50; and also: SELECT * FROM users WHERE username = LOWER('xxx') AND password = PASSWORD('xxx') In both cases the connection is using auto commit = 1... so I dont think it can be a deadlock problem. I am fairly certain that inserts have not been done to either table in a while (a while being a day or so). Below are the create table definitions just in case you need to take a look at them. Do you have any idea what could be causing this? Under the non-large blob support innobase code this worked without any problems. The only thing that has changed since then is the upgrade to .39b code and a little bit more data inserted into the table. Thanks, ryan create table messages` ( `messageid` bigint(20) NOT NULL auto_increment, `msgid` varchar(255) NOT NULL default '', `groupid` int(10) unsigned NOT NULL default '0', `userid` int(10) unsigned NOT NULL default '0', `parentmsgid` int(10) unsigned NOT NULL default '0', `subject` text NOT NULL, `body` text NOT NULL, `closedflag` char(1) NOT NULL default '', `postdate` int(10) unsigned NOT NULL default '0', `adddate` int(10) unsigned NOT NULL default '0', `replies` int(10) unsigned NOT NULL default '0', `ipaddr` int(10) unsigned NOT NULL default '0', `clean` char(1) NOT NULL default '0', `msent` char(1) NOT NULL default '', PRIMARY KEY (`messageid`), UNIQUE KEY `usenetmsgid` (`msgid`), KEY `parentmsgid` (`parentmsgid`,`clean`), KEY `MSGSELECT` (`groupid`,`clean`,`parentmsgid`,`postdate`), KEY `adddatestats` (`adddate`) ) TYPE=InnoDB MAX_ROWS=1; CREATE TABLE `users` ( `userid` bigint(20) unsigned NOT NULL
Gemini Problems
I've compiled MySQL 3.23.39 with Gemini support. The compile was error free although the 'make test' skipped the Gemini tests for some reason. In the mysqld.err log from the test directory I see this message: 00:18:15 MSGS_DIR tag failed -1 --- I went ahead and installed it. 'Show Variables' confirms that gemini is DISABLED. The docs indicate that this means support is compiled in, but has been disabled by '--skip-gemini'. This isn't the case. My configure options were: -- ./configure \ --prefix=/usr \ --localstatedir=/home/mysql.db \ --with-innodb \ --with-gemini \ --enable-thread-safe-client \ --enable-assembler \ --with-unix-socket-path=/var/lib/mysql/mysql.sock \ --with-mysqld-user=mysql \ --without-debug \ --with-client-ldflags=-all-static \ --with-mysqld-ldflags=-all-static \ --with-extra-charsets=none My startup options were: --skip-networking --skip-name-resolve \ --default-table-type=gemini --gemini-unbuffered-io \ --transaction-isolation=READ-UNCOMMITTED And finally, my.cnf contains: - gemini-recovery=FULL set-variable= gemini_buffer_cache=128M set-variable= gemini_io_threads=4 set-variable= gemini_connection_limit=200 Any help or pointers greatly appreciated :) Paul http://dbforums.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
mysqlgui 1.7.5 source
The source package for mysqlgui Makefile references an object 'edfile' which is not included in the source package (at Aug 9, 2001). When I try to compile without that object, I get a missing function error. Can anyone suggest where I can find this mysterious edfile? Thanks. Bo Green - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ACT Conversion
We are moving away from windows all together in the office I work for, one of our major programs that we use here is ACT2 DB. Can someone point me in the right direction of converting a ACT2 DB to MySQL. If it's any help, I recently used the following method to successfully convert an ACT2 database into MySQL: (i) open the ACT data file [your_database].dbf using MS Excel (ii) manually clean up the data in the spreadsheet, eliminating unnecessary columns, values, etc. (iii) save the spreadsheet as a tab delimited text file (iv) create tables in MySQL with appropriate column types for the data to be stored in them (v) load the text file into the tables using the mysqlimport utility Best of luck! Chris -- Waverley Internet Design http://www.waverley-internet.co.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_install_db - file size is zero
I have just downloaded mysql-3.23.39-pc-solaris2.8-i386 and I am going through my first installation however I don't get far as one of the first steps is to run the script mysql_install_db however the size of this file is zero bytes! I have seen the messages about Sun's tar not working properly but I don't believe that is my problem. Has anyone got any ideas what's going on? Why is this file empty? Thank you Paul Hefford - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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++ API under Mac OS X
On Wednesday, August 8, 2001, at 07:32 AM, Sinisa Milivojevic wrote: You are using the right compiler. What you should check are symlinks to dynamic and static versions of libstdc++. They should point out to the stdc++ that came with gcc 2.95.2. If that does not help, add a full path to the correct libstdc++ in your linker command. There is only a static version of libstdc++ with the default Mac OS X distribution. It is located in /usr/lib/gcc/darwin/default/libstdc++.a, and there is a symlink to that at /usr/lib/libstdc++.a. Adding /usr/lib/gcc/darwin/default/libstdc++.a directly into the link does not help. I've tried compiling with a bunch of different flag combinations, with no luck either. -Wno-uninitialized -fno-implicit-templates produces a TON of errors. Are there any alternative C++ API's out there for MySQL database access that are any less complex internally? I tried compiling the mysqlcppapi but ran into some rather large compatibility problems with that too. -Halim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Gemini Problems
On Thu, Aug 09, 2001 at 11:07:13PM -0400, Paul wrote: I've compiled MySQL 3.23.39 with Gemini support. The compile was error free although the 'make test' skipped the Gemini tests for some reason. In the mysqld.err log from the test directory I see this message: 00:18:15 MSGS_DIR tag failed -1 --- I went ahead and installed it. 'Show Variables' confirms that gemini is DISABLED. The docs indicate that this means support is compiled in, but has been disabled by '--skip-gemini'. This isn't the case. Hi, I cannot offer a solution but I am having the same problem. I compiled mysql with debugging and traced it with gdb, here's the offending code in ha_gemini.cc in the gemini_init function. fn_format(pmsgsfile, GEM_MSGS_FILE, language, .db, 2 | 4); rc = dsmContextSetString(pfirstContext, DSM_TAGDB_MSGS_FILE, strlen(pmsgsfile), (TEXT *)pmsgsfile); if( rc != 0 ) { gemini_msg(pfirstContext, MSGS_DIR tag failed %l, rc); goto badret; } If gemini_init fails, mysqld sets gemini to disabled. It seems to do this if any table type fails on initialization. Now what this piece of code is trying to do I have no idea. Shane -- Shane Wegner: [EMAIL PROTECTED] http://www.cm.nu/~shane/ PGP: 1024D/FFE3035D A0ED DAC4 77EC D674 5487 5B5C 4F89 9A4E FFE3 035D - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
programmatically getting field list from a table
Is there any way -- using either MySQL directly, or (ideally) using the DBI perl module -- to get a list of fields from a (possibly empty) table? (If the table is nonempty, you can just use a perl function to get the first record, and then apply keys() to the returned reference to get the field names.) I'm sure it's a trivial question, but I can't find the answer anywhere in the tutorial at http://www.mysql.com/doc/ -Bennett [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Problem with UPDATE statement
update cdrequest set albumfill = hot shots II, releasedatefill = 20010708 where requstID = 2; i get: You have an error in your SQL syntax near '\hot shots II\, releasedatefill = 20010708 where requstID = 2' at line 1 I can't see any reason for the error. Your web based interface is mangling your query. part 2: when I flip to properties for the cdrequest just to make sure i'm spelling the columns corectly and cut and paste the exact same query on that page IT WORKS Why would it work on that page but not the other. both are supposed to be places where you can enter a normal sql query.. Because your web based interface is mangling your query. Try using the mysql command line client. It also doesn't work in my PHP script which is where I really want it to work. Paste source. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: can't find my my.cnf file -- not there by default?
I'm still testing out MySQL and I'm trying to find the my.cnf file referred to at http://www.mysql.com/doc/O/p/Option_files.html ... but none of these files seem to exist on my machine. ... MySQL came pre-installed on that machine. Is it possible (or, indeed, normal) that the MySQL installation process didn't create a my.cnf file? It is normal. (In that case I'd recommending adding that info to http://www.mysql.com/doc/O/p/Option_files.html , if the author of those pages is on the list. I'll submit a comment there anyway based on what the list replies.) That's what the commenting feature is there for :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: connecting by knowing someone's scrambled password?
How is that possible? Even if you do know someone's scrambled password, when you connect to the MySQL server pretending to be that user, it will ask you for their non-scrambled password. After you type it in, the server will scramble it and check that the scrambled value matches the scrambled value stored in the database -- but you can't intercept that part of the process and insert the known scrambled password to be checked. It's called bruteforcing... knowing the scrambled password, you can encrypt every possible password and compare it to the scrambled password to find the original password. Either that or the scrambled password is encrypted by the client then sent for comparison, but I doubt it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: programmatically getting field list from a table
Is there any way -- using either MySQL directly, or (ideally) using the DBI perl module -- to get a list of fields from a (possibly empty) table? (If the table is nonempty, you can just use a perl function to get the first record, and then apply keys() to the returned reference to get the field names.) http://www.mysql.com/doc/D/E/DESCRIBE.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: connecting by knowing someone's scrambled password?
http://www.mysql.com/doc/U/s/User_names.html says: MySQL encrypts passwords using a different algorithm than the one used during the Unix login process. See the descriptions of the PASSWORD() and ENCRYPT() functions in section 6.4.12 Miscellaneous Functions. Note that even if the password is stored 'scrambled', and knowing your 'scrambled' password is enough to be able to connect to the MySQL server! How is that possible? Even if you do know someone's scrambled password, when you connect to the MySQL server pretending to be that user, it will ask you for their non-scrambled password. After you type it in, the server will scramble it and check that the scrambled value matches the scrambled value stored in the database -- but you can't intercept that part of the process and insert the known scrambled password to be checked. -Bennett The manual certainly *does* need a clean-up on this. --- 4.3.6 Setting Up Passwords: ...When the user jeffrey attempts to connect to the server using this password, the mysql client encrypts it with PASSWORD() and sends the result to the server. The server compares the value in the user table... --- Which would explain why knowing the encrypted password is enough to gain access to the server (you would, of course, need to write your own version of the mysql where you skip the PASSWORD call). However, --- 4.2.8 Access Control, Stage 1: Connection Verification ...The encrypted password is then used when the client/server is checking if the password is correct (This is done without the encrypted password ever traveling over the connection.) ... --- These two statements surely contradict each other. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php