synopsis of the problem (one line)
I would like to know how to create mysql.sock I destructed... Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:MySQL Server Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.36 (Source distribution) Environment: System: Linux superfc.dyndns.org 2.4.2-2 #1 Sun Apr 8 19:37:14 EDT 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-81) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 jun 25 03:36 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x2 root root 5578134 avr 6 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26350254 avr 6 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 avr 6 2001 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --with-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --with-berkeley-db - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: From Oracle to the MySQL Database Server
Hi Arjen, - Original Message - From: Arjen G. Lentz [EMAIL PROTECTED] To: Tony Buckley [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, December 09, 2001 1:40 AM Subject: Re: From Oracle to the MySQL Database Server But eh, what are those gripes about transactions and locking? Are you aware that the MySQL server with the InnoDB table handler (since over a year now!) features full transactional capabilities including row level locking? You just need to grab a 3.23-Max version, or compile 3.23 from source, or any 4.0 version. For more info on the InnoDB table handler, see http://www.mysql.com/doc/I/n/InnoDB.html in the online manual. Yep, I do know about that and I was wrong not to mention it. It's just something that I haven't set up to use yet because I don't 'need' it as another level of complexity (at the moment). I love the idea of being able to choose whether I want it or not. For what I am doing at the moment I really don't need it - a few hanging FK's or missing children won't bother me as I am dealing with statistical analysis and as long as the failures are within tolerence than that's fine! It's just so fast compared to what I have been using! When I said 'gripes', I didn't mean mine - there are the usual knockers who probably haven't looked at page 1 of the manual let alone tried the system. I have come across experienced database people who get very snotty when they find out about transactional processing not being inherent in mySQL even though there are some very commercial systems out there that have the same approach to get the speed they need. People's attitudes (especially those with an Oracle background IMHO) are very hard to change. Thanks for adding to my misleading note. Are there any highend figures to estimate the performance hit by using InnoDB across the platforms? Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: synopsis of the problem (one line)
I would like to know how to create mysql.sock I destructed... Restart mysqld / 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
VB6 ADO and UPDATE method
Hello to everybody. I have a problem with the Update method in the following simple VB6 code: Dim MyConn as New ADODB.Connection Dim MyRs As New ADODB.Recordset MyConn.ConnectionString = DSN=test;uid=sa;pwd=;database=test MyConn.Open MyRs.CursorLocation = adUseClient MyRs.Open lines, MyConn, adOpenKeyset, adLockOptimistic, adCmdTableDirect Do While Not MyRs.EOF MyRs!StartAngle = AngleValues(MyRs!LineId).StartAngle MyRs!EndAngle = AngleValues(MyRs!LineId).EndAngle MyRs.Update MyRs.MoveNext Loop The invocation of the methot MyRs.Update raise an error ( -2147217864 It's impossible to find the row to update). Everything works fine if I make the update using the method MyConn.Execute (UPDATE lines SET ) I've installed the latest releases of MySql and MyOdbc drivers (3.23.46 and 2.50.39 under win2000) I just would like to know if the simple moving through records and updating is supported, or if there is something wrong in my code. Thank you Stefano - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
IN keyword supported?
I'm trying to use the IN operator as described in my databases textbook from college. This query: select count(*) from user where user.ID in (select ID from user); is supposed to evaluate to count the number of rows in the 'user' table where the ID field is in the set of all ID field values in the 'user' table (in other words, just a roundabout way of counting the rows in the 'user' table, written solely to demonstrate the IN keyword). There doesn't seem to be a syntax error in that example, but MySQL gives the error: ERROR 1064: You have an error in your SQL syntax near 'select ID from user)' at line 1 Is the IN keyword not supported in MySQL, or am I using it wrong? -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: IN keyword supported?
I'm trying to use the IN operator as described in my databases textbook from college. This query: select count(*) from user where user.ID in (select ID from user); is supposed to evaluate to count the number of rows in the 'user' table where the ID field is in the set of all ID field values in the 'user' table (in other words, just a roundabout way of counting the rows in the 'user' table, written solely to demonstrate the IN keyword). There doesn't seem to be a syntax error in that example, but MySQL gives the error: ERROR 1064: You have an error in your SQL syntax near 'select ID from user)' at line 1 Is the IN keyword not supported in MySQL, or am I using it wrong? It is and you are -- IN is supported, but subselects aren't. So you can use IN with a value list, i.e. select count(*) from user where user.ID in (4, 101, 1000); but not in the context you describe. / 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: IN keyword supported?
Hi Bennett, - Original Message - From: Bennett Haselton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, December 09, 2001 12:31 PM Subject: IN keyword supported? I'm trying to use the IN operator as described in my databases textbook from college. This query: select count(*) from user where user.ID in (select ID from user); is supposed to evaluate to count the number of rows in the 'user' table where the ID field is in the set of all ID field values in the 'user' table (in other words, just a roundabout way of counting the rows in the 'user' table, written solely to demonstrate the IN keyword). There doesn't seem to be a syntax error in that example, but MySQL gives the error: ERROR 1064: You have an error in your SQL syntax near 'select ID from user)' at line 1 Is the IN keyword not supported in MySQL, or am I using it wrong? Subqueries are not supported in mySQL. Have to rewrite it with a combination of outer joins to do the same thing. Have a look at section 1.7.4.1 in the manual. Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqladmin does not install
On RedHat 7.1 I have installed MySQL-3.23.46-1.i386.rpm and the client, but mysqladmin does not install. Is there a fix for this? Raymond - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 running under WIN98
Under Win98 (and NT for that matter), I've found it convenient to just run WinMySQLAdmin. It starts the server (or service) automatically. After installing mysql specifying nothing but defaults, I started mysql without any parameters and then ran MYSQL TEST and received the following error message: Can't connect to mysql server or localhost (10061). Any suggestions? Richard Czerwonka, Partner, FYI Systems, Perth, Western Australia, Delphi development - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Associative Array from MySQL
I have a MySQL query that I want to draw an associative array from - but I want the 'key' to the array to be the identifying element of the row, and I'm stuck on how to get what I want. For instance: Each row in the result set contains an id number, a keyword and a count related to that keyword. so in a 'while' loop I can get an associative array like $row[id], $row[word], etc. with no problem. However - later (outside of the 'while' loop) I want to be able, given the id number, to get the keyword and the count. Like this pseudo code: $id_list(1150, 1160, 1170); for each $item in $id_list { print ($item[word] : $item[count]); } The idea is that I want a series of associative arrays that might be otherwise set like... $1150[word] = Blue; $1150[count] = 12; $1160[word] = Red; ...etc ...except drawn from a MySQL query. Any ideas how to achieve this? Thanks for any assistance, Nelson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB: Checking occupied space
Hi, how can I check how much of the InnoDB data files are already taken? Jens (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
Can't start MySQL,please help......
Hi,Sir: I found the message shows that: --- 04 01:13:40 mysqld started ^G/usr/local/mysql/libexec/mysqld: File './host-bin.1' not found (Errcode: 13) 04 1:13:40 Could not use host-bin for logging (error 13) InnoDB: Warning: operating system error number 13 in a file operation. InnoDB: Cannot continue operation. 04 01:13:41 mysqld ended Could anyone help ? thanks Fongming from Taiwan.. - This mail sent through IMP: http://web.horde.org/imp/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multiple unix sockets
Hi there, Is it possible to have MySQLd create multiple unix sockets? Over and above /var/run/mysql.sock. I'd like to have a socket in each of my chrooted file systems. Thanks, Aragon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multiple unix sockets
Hi there, Is it possible to have MySQLd create multiple unix sockets? Over and above /var/run/mysql.sock. I'd like to have a socket in each of my chrooted file systems. Thanks, Aragon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 start MySQL,please help......
Hi,Sir: I found the message shows that: --- 04 01:13:40 mysqld started ^G/usr/local/mysql/libexec/mysqld: File './host-bin.1' not found (Errcode: 13) 04 1:13:40 Could not use host-bin for logging (error 13) InnoDB: Warning: operating system error number 13 in a file operation. InnoDB: Cannot continue operation. 04 01:13:41 mysqld ended Could anyone help ? thanks Sounds like a file permission problem. Does the user running mysqld have the correct permissions on the directory containing host-bin.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: Associative Array from MySQL
On Monday 10 December 2001 00:36, you wrote: I have a MySQL query that I want to draw an associative array from - but I want the 'key' to the array to be the identifying element of the row, and I'm stuck on how to get what I want. For instance: Each row in the result set contains an id number, a keyword and a count related to that keyword. so in a 'while' loop I can get an associative array like $row[id], $row[word], etc. with no problem. However - later (outside of the 'while' loop) I want to be able, given the id number, to get the keyword and the count. Like this pseudo code: $id_list(1150, 1160, 1170); for each $item in $id_list { print ($item[word] : $item[count]); } The idea is that I want a series of associative arrays that might be otherwise set like... $1150[word] = Blue; $1150[count] = 12; $1160[word] = Red; ...etc ...except drawn from a MySQL query. Any ideas how to achieve this? Here's what I use (I'm assuming you're PHP). Note on parameters: $dbh is the database handle. If you use the built-in mysql functions then subsitute with a valid mysql connection id. $query is the query $key_field is the name of the field of your id number $fields is an array of the names of the fields to include in the result, if empty then include all fields. $stripslash is a boolean to specify whether or not to stripslashes from the results. If you need more explanation let me know. function get_db_array($dbh, $query, $key_field=, $fields=, $stripslash=1) { $result = ; $sth = $dbh-prepare($query); if ($sth) { $sth-execute(); while ($row = $sth-fetchrow_hash()) { $key_field_val = $row[$key_field]; if ($fields) { reset($fields); while (list($key, $field) = each($fields)) { if (!is_array($field) AND isset($row[$field])) { switch ($stripslash) { case 1 : $result[$key_field_val][$field] = stripslashes($row[$field]); break; case 0 : $result[$key_field_val][$field] = $row[$field]; break; }} else { switch ($stripslash) { case 1 : $result[$key_field_val][$key] = stripslashes($row[$key]); break; case 0 : $result[$key_field_val][$key] = $row[$key]; break; } } }} else { #show_msg(Displaying row); #get_array_elems($row); $i = 0; while (list($key, $field) = each($row)) { $i++; #echo Key:$key field:$fieldbr; if (!($i % 2)) { if ($stripslash) { #$result[$key_field_val][$key] = stripslashes($field); echo Assigned result[$key_field_val][$key]::$result[$key_field_val][$key]br; } $tmp[$key] = stripslashes($field); }#echo Assigned result[$key_field_val][$key]::$result[$key_field_val][$key]br; } else { #$result[$key_field_val][$key] = $field; echo Assigned result[$key_field_val][$key]::$result[$key_field_val][$key]br; $tmp[$key] = $field; #echo Assigned result[$key_field_val][$key]::$result[$key_field_val][$key]br; } } } #get_array_elems($result); $result[] = $tmp; } } return($result); } } -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Peers's Law: The solution to a problem changes the nature of the problem. */ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Random
On Sunday 09 December 2001 12:26, Paul DuBois wrote: At 3:19 PM -0800 12/8/01, Rob@TH wrote: Hmm still nothing :/ Any other possibilities? The suggestion offered below is a workaround that seems logical given the lack of ORDER BY RAND() prior to MySQL 3.23. Unfortunately, it doesn't work due to the behavior of the optimizer in pre-3.23 versions. Specifically, MySQL notices that rand() as rnd is a function, deduces (incorrectly) that the contents of the column will be constant, and thus optimizes away the order by rnd clause entirely. Result: no sorting. To deal with this, use an expression that includes RAND(), but written in such a way that the optimizer won't think is constant. For example, if you have an id column, do something like this: SELECT id*0+RAND() AS rnd, ... FROM tbl_name ORDER BY rnd LIMIT 1; Seems to work for me using 3.23.42 -- is it a bug ;-) mysql select * from category; +-+--+ | category_id | category_description | +-+--+ | 01 | Feng Shui| | 02 | Figure | | 03 | Magnet | | 04 | Candle | +-+--+ mysql select category_description, rand() as rnd from category order by rnd; +--+---+ | category_description | rnd | +--+---+ | Candle | 0.467619647707436 | | Figure | 0.581306149793143 | | Magnet | 0.916031742390275 | | Feng Shui| 0.996833012436361 | +--+---+ 4 rows in set (0.00 sec) mysql select category_description, rand() as rnd from category order by rnd; +--+---+ | category_description | rnd | +--+---+ | Feng Shui| 0.433106270090776 | | Figure | 0.656810501270751 | | Candle | 0.836240293305591 | | Magnet | 0.984733726815073 | +--+---+ 4 rows in set (0.00 sec) mysql select category_description, rand() as rnd from category order by rnd; +--+---+ | category_description | rnd | +--+---+ | Figure | 0.200211824104387 | | Magnet | 0.565105185438977 | | Feng Shui| 0.811984655272201 | | Candle | 0.953237160996755 | +--+---+ -- Jason Wong - Gremlins Associates - www.gremlins.com.hk /* Boling's postulate: If you're feeling good, don't worry. You'll get over 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: Associative Array from MySQL
How about a 2 dimensional array? If I understand you correctly wouldn't this work: $result = mysql_query(SELECT id, word, count FROM table, $db); while ($return = mysql_fetch_array($result)) { $id = $return['id']; $row[$id]['word'] = $return['word']; $row[$id]['count'] = $return['count']; } Very rough. Just threw it together now. *shrug* Regards, Aragon On Monday 10 December 2001 00:36, you wrote: I have a MySQL query that I want to draw an associative array from - but I want the 'key' to the array to be the identifying element of the row, and I'm stuck on how to get what I want. For instance: Each row in the result set contains an id number, a keyword and a count related to that keyword. so in a 'while' loop I can get an associative array like $row[id], $row[word], etc. with no problem. However - later (outside of the 'while' loop) I want to be able, given the id number, to get the keyword and the count. Like this pseudo code: $id_list(1150, 1160, 1170); for each $item in $id_list { print ($item[word] : $item[count]); } The idea is that I want a series of associative arrays that might be otherwise set like... $1150[word] = Blue; $1150[count] = 12; $1160[word] = Red; ...etc ...except drawn from a MySQL query. Any ideas how to achieve this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
running MySQL on WinXP
Hi. I am new to PHP/MySQL and this list. Can I run MySQL on WinXP? I haven't been able to get it to work so far. Any help would be appreciated. -- Best regards, Curt Kliewer ** ** Sol Interactive Development Applications Programmer/Analyst Internet Solutions/Server-Side Programmer ** ** Contact Information: ICQ:1835597 MSN Messenger: [EMAIL PROTECTED] Email:[EMAIL PROTECTED] Website: http://www.sol-interactive.com ** **
startup command line
Hello, We currently have two separate MySQL version running, one w/innodb and bdb tables and the other w/o transaction table handlers. We normally shutdown/restart the servers using the --defaults-file=/path/to/my.cnf Now if I want to restart the server w/innodb and bdb tables, and do not want to use the the bdb, if I use the command line: safe_mysqld --defaults-file=/path/to/my.cnf --skip-bdb even tho it was compiled w/bdb tables and has the setting in the my.cnf for them, will the command line over ride the settings in the my.cnf, hence disabling bdb tables untill the server is restarted and the bdb table handler is enabled again. Thx's database mysql sql Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql configure problem 3.26.46 version
Hi, I've downloaded mysql 3.23.46 version and currenlty runnig solaris 2.8 relase 10/00 on intel platform. I'm getting the following error during the ./configure stage in creating my makefile. checking size of char... 0 configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have libm.a in /lib, /usr/lib or some other standard place. If this is the problem, install the static libraries and try again. If this isn't the problem, examine config.log for possible errors. If you want to report this, use 'scripts/mysqlbug' and include at least the last 20 rows from config.log! # libm.a is in /usr/lib and my LD_LIBRARY_PATH is set as followed: # echo $LD_LIBRARY_PATH /opt/orca/lib:/usr/lib:/usr/local/lib:/opt/sfw/lib:/opt/sfw/gnome/lib:/opt/orca/lib/perl:/usr/local/rrdtool-1.0.33/lib:/usr/local/lib/glib:/usr/local/lib/mysql config.log has the following: # tail -20 config.log configure:6468: checking for off_t configure:6501: checking for st_rdev in struct stat configure:6514: gcc -c -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/software/local/mysql-3.23.46/include -DHAVE_RWLOCK_T conftest.c 15 configure:6535: checking whether time.h and sys/time.h may both be included configure:6549: gcc -c -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/software/local/mysql-3.23.46/include -DHAVE_RWLOCK_T conftest.c 15 configure:6570: checking whether struct tm is in sys/time.h or time.h configure:6583: gcc -c -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/software/local/mysql-3.23.46/include -DHAVE_RWLOCK_T conftest.c 15 configure:6606: checking size of char configure:6625: gcc -o conftest -O3 -DDBUG_OFF -DHAVE_CURSES_H -I/software/local/mysql-3.23.46/include -DHAVE_RWLOCK_T conftest.c -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread 15 configure: failed program was: #line 6614 configure #include confdefs.h #include stdio.h main() { FILE *f=fopen(conftestval, w); if (!f) exit(1); fprintf(f, %d\n, sizeof(char)); exit(0); } I would appreciate any ideas on this. I have compiled mysql 3.20 version in the past with no problem but wondered if this is a bug? -- *** Phillip B. Bruce *** *** http://pbbruce.home.mindspring.com *** *** [EMAIL PROTECTED] *** *** *** *** Have you ever noticed? Anybody going slower than*** *** you is an idiot, and anyone going faster than you*** *** is a maniac. - George Carlin*** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: VB6 ADO and UPDATE method
Hi, -Original Message- From: Stefano Vaccari [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 09, 2001 3:10 AM To: [EMAIL PROTECTED] Subject: VB6 ADO and UPDATE method Hello to everybody. I have a problem with the Update method in the following simple VB6 code: Dim MyConn as New ADODB.Connection Dim MyRs As New ADODB.Recordset MyConn.ConnectionString = DSN=test;uid=sa;pwd=;database=test MyConn.Open MyRs.CursorLocation = adUseClient MyRs.Open lines, MyConn, adOpenKeyset, adLockOptimistic, adCmdTableDirect Do While Not MyRs.EOF MyRs!StartAngle = AngleValues(MyRs!LineId).StartAngle MyRs!EndAngle = AngleValues(MyRs!LineId).EndAngle MyRs.Update MyRs.MoveNext Loop The invocation of the methot MyRs.Update raise an error ( -2147217864 It's impossible to find the row to update). Everything works fine if I make the update using the method MyConn.Execute (UPDATE lines SET ) I've installed the latest releases of MySql and MyOdbc drivers (3.23.46 and 2.50.39 under win2000) I just would like to know if the simple moving through records and updating is supported, or if there is something wrong in my code. Thank you Stefano Change connection string from DSN=test;uid=sa;pwd=;database=test to DSN=test;uid=sa;pwd=;database=test;option=2, then everything will be fine. Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: startup command line
Hello, cut a'lot them, will the command line over ride the settings in the my.cnf, cut s'more Manual sec. 4.1.2: Options specified on the command line take precedence over options specified in any option file. / 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: running MySQL on WinXP
Haven't tried it myself, but can't see why it shouldn't. How about you try telling us the process you have been through so far and any messages / errors that you may be getting. -Original Message- From: Curt Kliewer [mailto:[EMAIL PROTECTED]] Sent: Monday, 10 December 2001 5:16 To: MySQL List Subject: running MySQL on WinXP Hi. I am new to PHP/MySQL and this list. Can I run MySQL on WinXP? I haven't been able to get it to work so far. Any help would be appreciated. -- Best regards, Curt Kliewer ** ** Sol Interactive Development Applications Programmer/Analyst Internet Solutions/Server-Side Programmer ** ** Contact Information: ICQ:1835597 MSN Messenger: [EMAIL PROTECTED] Email:[EMAIL PROTECTED] Website: http://www.sol-interactive.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
speed up MySQL Selections
Hello, i have a question. I will have to set up a MySQL Database which will have a hughe amount of entries in a table. I did some tests and my select statements would need lot of time. I just wanna ask if there are some generally ways to speed up performance of mysql statements? thanx in advance bye Rüdi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: speed up MySQL Selections
Hello, Depending on what types of values are in your table, and the types of selects that you are going to perform, you will most likely notice a speed change if you were to INDEX some of your attributes...Just look up INDEX in the mysql manual... I notice the largest improvement when I INDEX on an attribute that I am constantly using in a WHERE clause in my SELECT statement...It really helps MySQL when it goes to test the comparisons... Hope this helps... Chris -Original Message- From: Cael Mahold [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 09, 2001 4:20 PM To: [EMAIL PROTECTED] Subject: speed up MySQL Selections Hello, i have a question. I will have to set up a MySQL Database which will have a hughe amount of entries in a table. I did some tests and my select statements would need lot of time. I just wanna ask if there are some generally ways to speed up performance of mysql statements? thanx in advance bye Rüdi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Question
Hello, Does anyone know where I should look on the http://www.mysql.com web site or anywhere else I can find documentation for being able to SSH to the box and setup additional databases as necessary using the MySQL command line tools? Scott Scott = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: speed up MySQL Selections
Hello, i have a question. Don't we all :-) I will have to set up a MySQL Database which will have a hughe amount of entries in a table. I did some tests and my select statements would need lot of time. I just wanna ask if there are some generally ways to speed up performance of mysql statements? Indexing, indexing, indexing. It can't be said too many times. Learn to use EXPLAIN SELECT ... to see how MySQL makes use of the indexes you define. Then learn to use SHOW STATUS and understand what it tells you. The manual is quite thorough in explaining what each line means. This is an excellent tool to track down problematic queries. - Lastly, set key_buffer in my.cnf as high as you can without stealing too many resources from other processes. This is the last step, though. No amount of RAM or other hardware will help you, unless you take a good look at the other issues above. / 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: Question
Try MySQLFront from www.mysqlfront.de, it has its limitations, but I find it does 90% of what I need to do on a day-to-day basis. Regards, DOD. Scott Johnson wrote: Hello, Does anyone know where I should look on the http://www.mysql.com web site or anywhere else I can find documentation for being able to SSH to the box and setup additional databases as necessary using the MySQL command line tools? Scott Scott = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- www.dodtechnology.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Question
Try MySQLFront from www.mysqlfront.de, it has its limitations, but I find it does 90% of what I need to do on a day-to-day basis. Regards, DOD. Scott Johnson wrote: Hello, Does anyone know where I should look on the http://www.mysql.com web site or anywhere else I can find documentation for being able to SSH to the box and setup additional databases as necessary using the MySQL command line tools? Scott Scott = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- www.dodtechnology.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Question
Hello, Does anyone know where I should look on the http://www.mysql.com web site or anywhere else I can find documentation for being able to SSH to the box and setup additional databases as necessary using the MySQL command line tools? http://www.mysql.com/doc/S/e/Secure_connections.html / 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: Question
Hi, http://www.mysql.com/doc/m/y/mysqladmin.html and http://www.mysql.com/doc/C/o/Connecting.html are a good start. If SSHing into a Unix box, you can also use man mysqladmin and man mysql, and man mysqldump for more info. -Joe -Original Message- From: Scott Johnson [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 09, 2001 4:06 PM To: [EMAIL PROTECTED] Subject: Question Hello, Does anyone know where I should look on the http://www.mysql.com web site or anywhere else I can find documentation for being able to SSH to the box and setup additional databases as necessary using the MySQL command line tools? Scott Scott = - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
connection problem
hi, I am new to PHP/mySQL. When i connect to phpMyAdmin to work with my database I do not have any problem of connection, but when I try to connect to my mySQL DB using this script (http://www.utpala.net/query1.php), then I get the following error message, Does anyone see something wrong in my code? Thanks in advance Philippe ? $myserver = '**' ; // $mylogin = '**' ; $mypassword = '*' ; $mydatabase = '*' ; $db = mysql_connect($myserver, $mylogin, $mypassword); mysql_select_db($mydatabase,$db); $req = mysql_query('SELECT * FROM users'); $res = mysql_numrows($req); echo 'number of lines: '.$res.' .'; mysql_close($db); ? Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in /home/sites/site14/web/query1.php on line 8 Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in /home/sites/site14/web/query1.php on line 8 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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!
Thanks for reading this. I'm new to the whole world of linux, and MySql, but I decided to get my hands dirty, and learn the whole thing. I have just installed corel linux, and I'm quite happy that the whole thing is working, and is visable on my network. Next I'm trying to get apache up and running! (Well, it's running, but I have no idea how to update the default web page!!! lol !) I've had limited experiance with MySQL, I've only ever been a user, and even then it was a remote host. My questions are as follows: Do I need to create users for the database, or does every user on the system have the right to create a table? Also, is it possible to connect to a MySQL database using Access as a front end? Thanks in advance! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: running MySQL on WinXP
I have installed the necessary MySQL files onto the hard drive (under the folders inetpub -- wwwroot -- mysql. Next, I set up a cnf file and called it my.cnf with the path C:\Inetpub\wwwroot\mysql in it. Then, using the command prompt, I keyed in the path to the mysql directory and keyed in mysql.exe. The error I get is: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I've tried this with my firewall (giving permission to MySQL and without it. Both have resulted in the same error message. Any ideas? -- Best regards, Curt Kliewer ** ** Sol Interactive Development Applications Programmer/Analyst Internet Solutions/Server-Side Programmer ** ** Contact Information: ICQ:1835597 MSN Messenger: [EMAIL PROTECTED] Email:[EMAIL PROTECTED] Website: http://www.sol-interactive.com ** ** - Original Message - From: G r e g L a w r i e To: Curt Kliewer ; MySQL List Sent: Sunday, December 09, 2001 1:04 PM Subject: RE: running MySQL on WinXP Haven't tried it myself, but can't see why it shouldn't. How about you try telling us the process you have been through so far and any messages / errors that you may be getting. -Original Message- From: Curt Kliewer [mailto:[EMAIL PROTECTED]] Sent: Monday, 10 December 2001 5:16 To: MySQL List Subject: running MySQL on WinXP Hi. I am new to PHP/MySQL and this list. Can I run MySQL on WinXP? I haven't been able to get it to work so far. Any help would be appreciated. -- Best regards, Curt Kliewer ** ** Sol Interactive Development Applications Programmer/Analyst Internet Solutions/Server-Side Programmer ** ** Contact Information: ICQ:1835597 MSN Messenger: [EMAIL PROTECTED] Email:[EMAIL PROTECTED] Website: http://www.sol-interactive.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: running MySQL on WinXP
Sounds like you need to add permission to connect from localhost. You might want to check out: http://www.mysql.com/doc/S/e/Secure_GRANT.html or you might need to use the -u root option to mysql -Original Message- From: Curt Kliewer [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 09, 2001 3:49 PM To: G r e g L a w r i e Cc: MySQL List Subject: Re: running MySQL on WinXP I have installed the necessary MySQL files onto the hard drive (under the folders inetpub -- wwwroot -- mysql. Next, I set up a cnf file and called it my.cnf with the path C:\Inetpub\wwwroot\mysql in it. Then, using the command prompt, I keyed in the path to the mysql directory and keyed in mysql.exe. The error I get is: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I've tried this with my firewall (giving permission to MySQL and without it. Both have resulted in the same error message. Any ideas? -- Best regards, Curt Kliewer ** ** Sol Interactive Development Applications Programmer/Analyst Internet Solutions/Server-Side Programmer ** ** Contact Information: ICQ:1835597 MSN Messenger: [EMAIL PROTECTED] Email:[EMAIL PROTECTED] Website: http://www.sol-interactive.com ** ** - Original Message - From: G r e g L a w r i e To: Curt Kliewer ; MySQL List Sent: Sunday, December 09, 2001 1:04 PM Subject: RE: running MySQL on WinXP Haven't tried it myself, but can't see why it shouldn't. How about you try telling us the process you have been through so far and any messages / errors that you may be getting. -Original Message- From: Curt Kliewer [mailto:[EMAIL PROTECTED]] Sent: Monday, 10 December 2001 5:16 To: MySQL List Subject: running MySQL on WinXP Hi. I am new to PHP/MySQL and this list. Can I run MySQL on WinXP? I haven't been able to get it to work so far. Any help would be appreciated. -- Best regards, Curt Kliewer ** ** Sol Interactive Development Applications Programmer/Analyst Internet Solutions/Server-Side Programmer ** ** Contact Information: ICQ:1835597 MSN Messenger: [EMAIL PROTECTED] Email:[EMAIL PROTECTED] Website: http://www.sol-interactive.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: running MySQL on WinXP
Hi, You need to be running the server (mysqld.exe) before you can connect to it from the command line. 10061 means that the TCP/IP service cannot be contacted, either because the IP address isn't correct or that there is no service on the requested port. HTH Quentin -Original Message- From: Curt Kliewer [mailto:[EMAIL PROTECTED]] Sent: Monday, 10 December 2001 11:49 a.m. To: G r e g L a w r i e Cc: MySQL List Subject: Re: running MySQL on WinXP I have installed the necessary MySQL files onto the hard drive (under the folders inetpub -- wwwroot -- mysql. Next, I set up a cnf file and called it my.cnf with the path C:\Inetpub\wwwroot\mysql in it. Then, using the command prompt, I keyed in the path to the mysql directory and keyed in mysql.exe. The error I get is: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I've tried this with my firewall (giving permission to MySQL and without it. Both have resulted in the same error message. Any ideas? -- Best regards, Curt Kliewer ** ** Sol Interactive Development Applications Programmer/Analyst Internet Solutions/Server-Side Programmer ** ** Contact Information: ICQ:1835597 MSN Messenger: [EMAIL PROTECTED] Email:[EMAIL PROTECTED] Website: http://www.sol-interactive.com ** ** - Original Message - From: G r e g L a w r i e To: Curt Kliewer ; MySQL List Sent: Sunday, December 09, 2001 1:04 PM Subject: RE: running MySQL on WinXP Haven't tried it myself, but can't see why it shouldn't. How about you try telling us the process you have been through so far and any messages / errors that you may be getting. -Original Message- From: Curt Kliewer [mailto:[EMAIL PROTECTED]] Sent: Monday, 10 December 2001 5:16 To: MySQL List Subject: running MySQL on WinXP Hi. I am new to PHP/MySQL and this list. Can I run MySQL on WinXP? I haven't been able to get it to work so far. Any help would be appreciated. -- Best regards, Curt Kliewer ** ** Sol Interactive Development Applications Programmer/Analyst Internet Solutions/Server-Side Programmer ** ** Contact Information: ICQ:1835597 MSN Messenger: [EMAIL PROTECTED] Email:[EMAIL PROTECTED] Website: http://www.sol-interactive.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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie!
Hi, Do I need to create users for the database, or does every user on the system have the right to create a table? You need to create users within MySQL's authentication database. The manual explains this beautifully. Also, is it possible to connect to a MySQL database using Access as a front end? Yes. Download MyODBC. However, you're probably better off setting up something like phpMyAdmin. Regards, Aragon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 can I configure mysql server to write on 2 separate disk
Hi; I have logging server (redundant) and I will store these logs on database (2 disks: one local and another remote using NFS). When I receice the logs from my server I sent these logs to MySQL server running on Linux. Normaly the database is on /var/lib/mysql/logging. can I have another database on /var/lib/mysql/backup mounted on another machine using NFS. whith these solution I will have 2 database redundant : one on local machine logging and another on remote machine backup. How I can configure this solution ? Thanks for help _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: running MySQL on WinXP
Ok, thanks for the help, people. I finally got it to work. Was really quite simple. (wish it were like this all the time heh). I just had to run the *clears throat* winmysqladmin.exe and then everything went smooth as glass. Again, thank you all for your help. :) -- Best regards, Curt Kliewer ** ** Sol Interactive Development Applications Programmer/Analyst Internet Solutions/Server-Side Programmer ** ** Contact Information: ICQ:1835597 MSN Messenger: [EMAIL PROTECTED] Email:[EMAIL PROTECTED] Website: http://www.sol-interactive.com ** ** - Original Message - From: Joe Kaiping To: 'Curt Kliewer' ; 'G r e g L a w r i e' Cc: 'MySQL List' Sent: Sunday, December 09, 2001 3:17 PM Subject: RE: running MySQL on WinXP Sounds like you need to add permission to connect from localhost. You might want to check out: http://www.mysql.com/doc/S/e/Secure_GRANT.html or you might need to use the -u root option to mysql -Original Message- From: Curt Kliewer [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 09, 2001 3:49 PM To: G r e g L a w r i e Cc: MySQL List Subject: Re: running MySQL on WinXP I have installed the necessary MySQL files onto the hard drive (under the folders inetpub -- wwwroot -- mysql. Next, I set up a cnf file and called it my.cnf with the path C:\Inetpub\wwwroot\mysql in it. Then, using the command prompt, I keyed in the path to the mysql directory and keyed in mysql.exe. The error I get is: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I've tried this with my firewall (giving permission to MySQL and without it. Both have resulted in the same error message. Any ideas? -- Best regards, Curt Kliewer ** ** Sol Interactive Development Applications Programmer/Analyst Internet Solutions/Server-Side Programmer ** ** Contact Information: ICQ:1835597 MSN Messenger: [EMAIL PROTECTED] Email:[EMAIL PROTECTED] Website: http://www.sol-interactive.com ** ** - Original Message - From: G r e g L a w r i e To: Curt Kliewer ; MySQL List Sent: Sunday, December 09, 2001 1:04 PM Subject: RE: running MySQL on WinXP Haven't tried it myself, but can't see why it shouldn't. How about you try telling us the process you have been through so far and any messages / errors that you may be getting. -Original Message- From: Curt Kliewer [mailto:[EMAIL PROTECTED]] Sent: Monday, 10 December 2001 5:16 To: MySQL List Subject: running MySQL on WinXP Hi. I am new to PHP/MySQL and this list. Can I run MySQL on WinXP? I haven't been able to get it to work so far. Any help would be appreciated. -- Best regards, Curt Kliewer ** ** Sol Interactive Development Applications Programmer/Analyst Internet Solutions/Server-Side Programmer ** ** Contact Information: ICQ:1835597 MSN Messenger: [EMAIL PROTECTED] Email:[EMAIL PROTECTED] Website: http://www.sol-interactive.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: Very large table load/index questions
Hi! Sergei == Sergei Golubchik [EMAIL PROTECTED] writes: cut Sergei Ok, mysqlimport uses LOAD DATA INFILE. Yes, but they are simply convenient shortcuts to myisamchk --keys-used=0 -rq You can enable/disable keys from command line in 3.23. Ok, what is the suggested usage? create w/ index disable load enable Or something else? Sergei Just create without index, and then ALTER TABLE. Sergei When ALTER TABLE is running check with SHOW PROCESSLIST Sergei that it does 'repair by sorting', not 'repair with keycache' Sergei DISABLE/ENABLE sequence is useful when one want to add data to non-empty Sergei table. Note that if you are using LOAD DATA into an empty table, you will not get any additional speed by using ALTER TABLE to disable/enable the keys; In this case MySQL will automaticly use the same method as REPAIR TABLE or ALTER TABLE to generate the keys.. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 solve requently mysqld restarted in SCO ?
Hi, I compiled mysql 3.23.42 in SCO 5.05, sometimes in log file there'are frequently mesaages: mysqld restarted, I don't know why. Thank you for your any useful response ! Dick _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: newbie. can't run safe_mysqld
If I understand your core problem: it seems as if you can't start your mysql daemon (mysqld) using the safe_mysqld wrapper. Is it possible that you ran your mysql_install_db script as root? If so then mysqld will have problems accessing the admin db files that the script creates. (You can verify this by checking ownership and permissions on the newly created db files. My datadir for RedHat 7.2 is /var/lib/mysql/mysql; all the db files should be owned by user=mysql.) One solution is: - backup/rename your datadir while logged-in as root - su mysql (a valid mysql user must exist; check docs if does not) - execute mysql_install_db as user=mysql - run safe_mysqld as user=mysql - check connection with mysqladmin version There is probably an easier way to do all this with the --user directive. Hope this helps. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Access Error
Hi, I am a newbie at this. I am running mysql 3.23.41 on my RedHat 7.2 linux box. I installed it using rpm. I can start mysql but everytime I try to create a database, I keep getting this error: mysql create database guessbook; ERROR 1044: Access denied for user: '@localhost' to database 'guessbook' mysql Does anyone know what is going on here? Thanks, Hai Nguyen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Access Error
Hi, I am a newbie at this. I am running mysql 3.23.41 on my RedHat 7.2 linux box. I installed it using rpm. I can start mysql but everytime I try to create a database, I keep getting this error: mysql create database guessbook; ERROR 1044: Access denied for user: '@localhost' to database 'guessbook' mysql Does anyone know what is going on here? Thanks, Hai Nguyen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Huge of your mySQL database or table in your former Instance
All, Now I want to design a database which contains more than 10G data to use. I think the largest table in my db will contains more than 30 million records and the amount of this kind of table will be up to 7 or 10. In my instance there won't be so many clients connecting. normally, there are less than 20 clients concurrent querying. My hardware is dual PIII 933, 512M I plan to upgrade to 1G RAM, three SCSI 18G HD, one of them is dedicated to mySQL DB. platform RH 7.2 with XFS. So, could you give me some advice that if it is feasible ? Or show me your successful cases of using mySQL which is supporting very large DB or tables with details ? Thanks a lot! Ares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
efficient DELETE query - 2 tables
I want to write an efficient query that will delete all records from one table when they show up in another table (pending shipments -- shipped shipments). I can't do it with this: mysql DELETE from pending_2 WHERE pending_2.ordno = ordersearch_2.ordno; because you can only refer to columns of one table in a delete query. Does anybody have an effiecnt way for me to do this with Perl DBI? Thanks! Rory - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: efficient DELETE query - 2 tables
I spent some time to do it w/ one query, but I couldn't figure out. So I am throwing an example in Perl (the best way I could think of) my $pending = $dbh-selectrow_arrayref(qq/ SELECT pending_2.ordno FROM pending_2, ordersearch_2 WHERE pending_2.ordno=ordersearch_2.ordno/); for ( @{$pending} ) { $dbh-do(DELETE FROM pending_2 WHERE ordno=?, undef, $_); } take care rory o'connor wrote: ro: Date: Sun, 9 Dec 2001 23:40:03 -0600 ro: From: rory o'connor [EMAIL PROTECTED] ro: To: [EMAIL PROTECTED] ro: Subject: efficient DELETE query - 2 tables ro: ro: I want to write an efficient query that will delete all records from one ro: table when they show up in another table (pending shipments -- shipped ro: shipments). I can't do it with this: ro: ro: mysql DELETE from pending_2 WHERE pending_2.ordno = ordersearch_2.ordno; ro: ro: because you can only refer to columns of one table in a delete query. Does ro: anybody have an effiecnt way for me to do this with Perl DBI? ro: ro: Thanks! ro: ro: Rory ro: ro: - ro: Before posting, please check: ro:http://www.mysql.com/manual.php (the manual) ro:http://lists.mysql.com/ (the list archive) ro: ro: To request this thread, e-mail [EMAIL PROTECTED] ro: To unsubscribe, e-mail [EMAIL PROTECTED] ro: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ro: -- Sherzod Ruzmetov [EMAIL PROTECTED] http://www.UltraCgis.com, Consultant 989.774.6265 ++ | There is nothing wrong with your tools.| | But we can make a better one. | ++ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Huge of your mySQL database or table in your former Instance
Thanks very much Paul, Could you like to tell me what time spent in your querying ten thousands of records from tables one time? In my test, when I query 10,000 records from a table which contains 17 millions records total, it will cost less than 1 second of querying INDEX, or cost more than 30 seconds of querying normal COLUMNs. I want to know query speed in larger table. Regards Ares - Original Message - From: [EMAIL PROTECTED] To: Ares Liu [EMAIL PROTECTED] Sent: Monday, December 10, 2001 1:28 PM Subject: Re: How Huge of your mySQL database or table in your former Instance Now I want to design a database which contains more than 10G data to use. I think the largest table in my db will contains more than 30 million records and the amount of this kind of table will be up to 7 or 10. In my instance there won't be so many clients connecting. normally, there are less than 20 clients concurrent querying. My hardware is dual PIII 933, 512M I plan to upgrade to 1G RAM, three SCSI 18G HD, one of them is dedicated to mySQL DB. platform RH 7.2 with XFS. So, could you give me some advice that if it is feasible ? Or show me your successful cases of using mySQL which is supporting very large DB or tables with details ? I've just restructured a database which has 8 identical tables whose size varies by the hour. They often have 30-35 million rows each. In addition, there are two new tables per day, and the system has been running for over a year now. The database server is a dual PIII-1000 with 1 Gb of RAM, 18 Gb Ultra-wide SCSI disk for the system, and a RAID array with 14 * 73 Gb IBM 10,000 rpm Ultra-wide SCSI discs. The system sings. It's easy to hit disk limits with a large database, hence the RAID array above. It has 8-10 other machines on a 100 MHz ethernet lan which fire selects at the database server, and two which issue inserts into the 8 tables mentioned above. Hope this helps a little. Regards, Paul Wilson iiNet Ltd - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: efficient DELETE query - 2 tables
Rory I want to write an efficient query that will delete all records Rory from one table when they show up in another table (pending Rory shipments -- shipped shipments). I can't do it with this: mysql DELETE from pending_2 WHERE pending_2.ordno = ordersearch_2.ordno; Rory because you can only refer to columns of one table in a delete Rory query. Does anybody have an effiecnt way for me to do this with Rory Perl DBI? This isn't really a Perl question, is it? Isn't the most efficient way to have the DB handle all of it? Something like: DELETE FROM pending_2 WHERE ordno IN (SELECT ordno FROM ordersearch_2) --Harlan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Latin-2
On Saturday, December 08, 2001 at 21:46:52, Bojan IVANCIC wrote: BI Hi: BI Just a short Q: BI - if I install MySQL through rpm is it possible with any sort of BI postintallation to change the code page e.g. from Latin-1 to Latin-2. BI Thanx and bye. BI Bojan Hi, Try to add to my.cnf file into section [mysqld] line like this: [mysqld] default-character-set=latin2 This enables latin-2 character set as default. Best Regards, -- Jarek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Access Error
Hi, I am a newbie at this. I am running mysql 3.23.41 on my RedHat 7.2 linux box. I installed it using rpm. I can start mysql but everytime I try to create a database, I keep getting this error: mysql create database guessbook; ERROR 1044: Access denied for user: '@localhost' to database 'guessbook' mysql Does anyone know what is going on here? You're logged on to mysql as the anonymous user, and you only have access to the database test. Log on as root, and set the correct permissions. More info: http://www.bitbybit.dk/mysqlfaq/faq.html#ch11_0_0 http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_2_0 sec. 4.2.4 - 4.2.10 of the manual / 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