error while 'make'
Hi, First at all, I want to appologize if somebody else ever send this question here. Would you please help me to solve my problem regarding installing MySQL. The error ocured when I 'make'. Last lines from 'make' are: = Making all in tests make[2]: Entering directory `/home/hariss/mysql-3.23.34a/tests' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/home/hariss/mysql-3.23.34a/tests' Making all in man make[2]: Entering directory `/home/hariss/mysql-3.23.34a/man' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/home/hariss/mysql-3.23.34a/man' Making all in sql-bench make[2]: Entering directory `/home/hariss/mysql-3.23.34a/sql-bench' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/home/hariss/mysql-3.23.34a/sql-bench' Making all in mysql-test make[2]: Entering directory `/home/hariss/mysql-3.23.34a/mysql-test' make[2]: *** No rule to make target `all'. Stop. make[2]: Leaving directory `/home/hariss/mysql-3.23.34a/mysql-test' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/home/hariss/mysql-3.23.34a' make: *** [all-recursive-am] Error 2 Here are some lines from config.log: = configure:9249: checking can netinet files be included configure:9263: gcc -c -O6 -DDBUG_OFF -DHAVE_RWLOCK_T conftest.c 15 configure:9378: checking character sets configure:9616: checking for BerkeleyDB configure:10244: checking for Innobase Thanks a lot. -haris- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 denied
*** NOTICE: This transmission contains information relating to Schlumberger's business activities in Libya. If you are a United States (U.S.) Person (i.e., U.S. Citizen; Permanent Resident Alien green card holder; employee of a U.S. Company; or physically in the U.S.) you are prohibited by law from disclosing, responding, or otherwise acting upon any of the information contained in this transmission. If you are a Schlumberger employee, please consult the OFS Export Administration web site: http://www.sugar-land.spc.slb.com (under Services) to ensure that any actions which may be taken in connection with this transmission are in full compliance with Schlumberger's Trade Control Policy and procedures. *** Hello mysql, Please can you tell me why i got the following message when i was trying to connect to mysql database from the server. the connection statement was like : - c = DriverManager.getConnection(jdbc:mysql://IT-SNS:3306/slb?user=root=root); i have got the following message :- java.security.AccessControlException: access denied (java.net.SocketPermission IT-SNS resolve) so please help me to solve this problem. -- Best regards, Sami mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.36 crash on MDK 8
hello, sorry for my english, I have a compaq bi PII 400 Mhz with 512 Mo of ram. Linux mandrake 8 kernel 2.4.6 MySQL 3.23.36, apache 1.3.19 with php 4.0.4pl1 disk free space /usr/ : 2Go /var/ : 2,4 Go I want to create a benchmark with linux + apache + php + mysql vs linux + apache + php + postgresql vs W2000 + IIS5 + asp + SQL Server I use Microsoft Web Application Stress Tool (http://webtool.rte.microsoft.com/) test with linux + apache + php + postgresql and W2000 + IIS5 + asp + SQL Server passed but the test (=7 clients http (first test is ok)) with linux + apache + php + mysql crash mysql (/etc/rc.d/init.d/mysql start|stop, mysql, mysqladmin and any query don't work) /etc/my.cnf: # Example mysql config file for large systems. # # This is for large system with memory = 512M where the system runs mainly # MySQL. # # You can copy this file to # /etc/mf.cnf to set global options, # mysql-data-dir/my.cnf to set server-specific options (in this # installation this directory is /var/lib/mysql) or # ~/.my.cnf to set user-specific options. # # One can in this file use all long options that the program supports. # If you want to know which options a program support, run the program # with --help option. # The following options will be passed to all MySQL clients [client] #password = your_password port = 3306 socket = /var/lib/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port = 3306 socket = /var/lib/mysql/mysql.sock #datadir =/home/database/mysql skip-locking set-variable = key_buffer=256M set-variable = max_allowed_packet=1M set-variable = max_connections=1000 set-variable = table_cache=256 set-variable = sort_buffer=1M set-variable = record_buffer=1M set-variable = myisam_sort_buffer_size=64M set-variable = thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable = thread_concurrency=8 log-bin server-id = 1 # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=64M #set-variable = bdb_max_lock=10 # Uncomment the following if you are using Innobase tables #innobase_data_home_dir = /usr/share #innobase_log_group_home_dir = /usr/share #innobase_log_arch_dir = /usr/share #innobase_data_file_path = ibdata1:25M;ibdata2:37M;ibdata3:100M;ibdata4:300M #set-variable = innobase_mirrored_log_groups=1 #set-variable = innobase_log_files_in_group=3 #set-variable = innobase_log_file_size=5M #set-variable = innobase_log_buffer_size=8M #innobase_flush_log_at_trx_commit=1 #innobase_log_archive=0 #set-variable = innobase_buffer_pool_size=16M #set-variable = innobase_additional_mem_pool_size=2M #set-variable = innobase_file_io_threads=4 #set-variable = innobase_lock_wait_timeout=50 # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=128M set-variable = sort_buffer=128M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=128M set-variable = sort_buffer=128M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout my table with 5000 rows : CREATE TABLE test ( idtest int(11) NOT NULL auto_increment, testchar varchar(255), testdate datetime, testnum int(11), testbool tinyint(1), testvarchar varchar(255), PRIMARY KEY (idtest) ); testmysql.php : HTML BODY ?PHP $dbconn = mysql_connect (localhost, root, ); $template=idtest : !--IDTEST-- - testchar : !--TESTCHAR-- - testdate : !--TESTDATE-- - ; $template=$template . testnum : !--TESTNUM-- - testbool : !--TESTBOOL-- - testvarchar : !--TESTVARCHAR--br; $Affiche=; $cpt=0; $sql=SELECT * FROM test LIMIT 3000, 20; $sqlok=mysql_db_query (testapache, $sql, $dbconn) ; if ($sqlok) { while ($result=mysql_fetch_array ($sqlok, MYSQL_ASSOC)) { $cpt++; $templatetmp =$template; foreach ($result as $key = $value) { $templatetmp = eregi_replace(!--.$key.--,$value,$templatetmp); } $Affiche = $Affiche . liEnregistrement . $cpt . : br . $templatetmp; } } echo $Affiche; mysql_close ($dbconn); ? /BODY /HTML do you have an idea ? Bien à vous Philippe http://www.devparadise.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
repost: Too many open files
Hi, Any help would be greatly appreciated as I have a production server that is struggling. (I only get the digest list, so could you copy me on any replies - thankyou). My error log show this... 011002 9:16:11 Error in accept: Too many open files 011002 9:36:43 /usr/local/mysql/libexec/mysqld: Shutdown Complete 011002 09:36:43 mysqld ended 011002 09:36:52 mysqld started 011002 9:36:52 Warning: setrlimit couldn't increase number of open files to more than 1024 011002 9:36:52 Warning: Changed limits: max_connections: 500 table_cache: 257 /usr/local/mysql/libexec/mysqld: ready for connections I am getting the too many open files error. What does the setrlimit log line mean? How many connections can I have before reaching 'too many connections'? What can I do about it? I have looked in docs. open_files_limit If this is not 0, then mysqld will use this value to reserve file descriptors to use with setrlimit(). If this value is 0 then mysqld will reserve max_connections*5 or max_connections + table_cache*2 (whichever is larger) number of files. You should try increasing this if mysqld gives you the error 'Too many open files'. mine is 0 so it should use quite a big number ( 500 * 5) - is this too big? Should I set open_file_limits directly to something smaller? I have ... /proc/sys/fs/file-max = 8192 /proc/sys/fs/file-nr = 2097 14118192 my.cnf # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=2M set-variable= max_connections=500 set-variable= table_cache=512 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 set-variable= wait_timeout=1800 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=4 set-variable= myisam_sort_buffer_size=64M log-bin low-priority-updates binlog-ignore-db=e3 server-id = 1 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.282 / Virus Database: 150 - Release Date: 25/09/01 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Yes or No
Jordan Elver writes: Hi, If I wanted to define a table to have a cloumn which is either yes or no for example. Would it be better to use a single char (0 or 1), or can I use an enum (I find them more friendly ;)). If you use an enum you might end up with the value '' if you enter something invalid, whereas if you use a tinyint(1) the worst thing you can get is a number outside {0,1}. If you use a char you'll have all sorts of conversion problems when using the column in boolena expressions, not to mention that there are lots of funny values permitted. I use tinyint(1) in all places where I need a boolean, and it works fine for me. I've seen rumors about bool being an alias for tinyint(1), but it's not in the manual and I haven't tested it. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Yes or No
Hi, so far I know is MySQL able to handle Enums in a very efficient way. So I'd advise you to use Enums. Best regrads Bernhard - Original Message - From: Jordan Elver [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED]; PHP DB Mailing List [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 11:23 AM Subject: Yes or No If I wanted to define a table to have a cloumn which is either yes or no for example. Would it be better to use a single char (0 or 1), or can I use an enum (I find them more friendly ;)). Could you offer some advice? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 MAx
Just installed MySQL Max 3.23.43 on a LInux box from the rpm. When starting get the following message: /usr/sbin/mysqld-max: Fatal error: Error message file '/usr/share/mysql/english/errmsg.sys' had only 205 error messages, but it should have at least 213 error messages. Check that the above file is the right version for this program! The system previously had a normal version of 3.23. Any ideas as to what might have gone wrong? Thanks Robert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Help me with SELECT - GROUP BY - IF
Hi there. I have problems with mySQL What I would like to do is: I have a statement SELECT a.id AS ID, IDmark, IDrecipe, ocenjevalec, ocena, ROUND(AVG(ocena),1) as povprecje, COUNT(*) as all, IF (ID=ocenjevalec, 'yes', 'no') as zeocenil FROM ocenerecepti, obiskovalci WHERE IDrecept = 1365 group by IDrecipe But 'zeocenil' allways returns no, because it groups all the data together and only the first data that has IDrecept = 1365 is checked with if sentance. I have to use group by because of AVG and count. Is there any if-like function that checks ALL records for the ID=ocenjevalec, not just the first (or the grouped by, seems to take 'ocenjevalec' as from the first data). If this is not possible, how can I achieve that? Should I make another recordset? Thank you for your time and patience Yours Jerry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re:MySQL MAx
Robert, the installation program obviously failed to put the new errmsg files to the right place. Look for the new errmsg files somewhere, usually the directory is something like .../share/english, and copy them to /usr/share/mysql/english Regards, Heikki http://www.innodb.com/ibman.html Just installed MySQL Max 3.23.43 on a LInux box from the rpm. When starting get the following message: /usr/sbin/mysqld-max: Fatal error: Error message file '/usr/share/mysql/english/errmsg.sys' had only 205 error messages, but it should have at least 213 error messages. Check that the above file is the right version for this program! The system previously had a normal version of 3.23. Any ideas as to what might have gone wrong? Thanks Robert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Counting Sequences Clarified
Hello, Thank's for your interest Paul. I did a poor job of explaining my problem. Here is another go: For an athlete's first entry in the database I need a column value of 1. The second performance entry of the same athlete would have a value of 2. And so on. I need to apply this retrospectively to ten years of performance records. Ongoing updates are not an issue at present. Thanks Bruce - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:MySQL MAx
Heikki, The only ones I found were in /usr/share/mysql. Did a find starting in root. Robert Heikki Tuuri [EMAIL PROTECTED] wrote: Robert, the installation program obviously failed to put the new errmsg files to the right place. Look for the new errmsg files somewhere, usually the directory is something like .../share/english, and copy them to /usr/share/mysql/english Regards, Heikki http://www.innodb.com/ibman.html Just installed MySQL Max 3.23.43 on a LInux box from the rpm. When starting get the following message: /usr/sbin/mysqld-max: Fatal error: Error message file '/usr/share/mysql/english/errmsg.sys' had only 205 error messages, but it should have at least 213 error messages. Check that the above file is the right version for this program! The system previously had a normal version of 3.23. Any ideas as to what might have gone wrong? Thanks Robert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail To unsubscribe, e-mail 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: Counting Sequences Clarified
Bruce, Why not just determine this number when you do a query? Why do you need to have it be stored in the database? It's easy to create a Perl (or probably PHP, but I really don't know PHP) script to fill in such a column, too, but you would need to manually maintain that. And right now I don't understand the problem well enough to convince me that such maintenance would be worthwhile ... Tom Haapanen [EMAIL PROTECTED] -Original Message- From: Bruce Collins [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 02 October, 2001 07:04 To: [EMAIL PROTECTED] Subject: Counting Sequences Clarified Hello, Thank's for your interest Paul. I did a poor job of explaining my problem. Here is another go: For an athlete's first entry in the database I need a column value of 1. The second performance entry of the same athlete would have a value of 2. And so on. I need to apply this retrospectively to ten years of performance records. Ongoing updates are not an issue at present. Thanks Bruce - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multi-Row Insert
Is there any way to insert more than one row at a time??? The data that I have will change with each row, but is there a way to insert 900 rows (with different values for each) all at once? database,sql,query,table PS The listserv is starting to piss me off... Must have one of the keywords, no attachments, etc... .grr - Glendon Solsberry Internet Programmer Tricon Global Restaurants tel. (502) 874-6736 fax (502) 874-8818 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
0000-00-00 vs NULL in Date Field
If I read a file into a database with a \N in an empty date field the field is populated with -00-00. If I insert a row into the same database with NULL in the date field it is populated with NULL. Programmatically is there a difference between the two? Thanks Frank - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is right DB for our purpose
Hi, We are planning to create an web database(6 - 7 tables with the average of 6 columns), where members search for the right person by entering the proper search criteria. We expect that this database will grow in the rate of 1000 to 2000 records in a month. Could you please let us know whether the MySQL database is the right choice for our purpose as soon as possible. Because we are nearly ready to sign an agreement with a webhosting company. Please reply to the following email address [EMAIL PROTECTED] Thank you Ruthira S Steinhart Net esolutions - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 OLEDB
Did you find the solution ? -Message d'origine- De : Bruce Stewart [mailto:[EMAIL PROTECTED]] Envoyé : 20 août, 2001 11:41 À : 'Roy, Steeve'; [EMAIL PROTECTED] Objet : RE: MySQL OLEDB Steeve, I have had the same problem for months, with no solutions. If you find a solution, please let be know. Thanks, Bruce -Original Message- From: Roy, Steeve [mailto:[EMAIL PROTECTED]] Sent: Mon, 20 August 2001 16:21 To: '[EMAIL PROTECTED]' Subject: MySQL OLEDB Hello, I us emysql oledb driver to connect on my database. When I use that localy on the computer where mysql run, I can connect correctly on any of my database. When I try from another computer (where I have installed the MySQL oledb driver) I get this message. Why ? Test connection failed because of an error in initializing provider. Catastrophic Failure... P.S.: I have try from more than one diferrent computer running Windows 2000 professionnal... Tanks for your help... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Multi-Row Insert
Is there any way to insert more than one row at a time??? The data that I have will change with each row, but is there a way to insert 900 rows (with different values for each) all at once? INSERT INTI table VALUES (row1), (row 2), (row3) . where rowN is a list of values for the row in column order. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Cannot get mysql to core dump
Hi, I would suggest you upgrade to FreeBSD 4.3 or better 4.4 (Which just came out a coupel of weeks ago). 4.2 has threads and compiler bugs. You can do an in place upgrade, but after upgrading don't forget to recompile MySQL (unless you are using the binary provided by mysql group). See www.freebsd.org for upgrade instructions or download an upgrade image and checkout the README. Best of Luck, Ken - Original Message - From: Spinlock [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 01, 2001 8:47 PM Subject: Cannot get mysql to core dump Sometimes mysqld gets signal 11 (segmentation fault), it crashes, and safe_mysqld restarts it, anyways I cannot get it to generate a core dump file. I am using FreeBSD 4.2. Any ideas? --- Spinlock Creator of EmpireQuest http://www.empirequest.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: Cannot get server to honor configuration settings
That is a permissions error. Mysql does not own the database directory. chown -R mysql /var/lib/mysql Mailing List Receiver wrote: With basedir and datadir=/var/lib/mysql the error is: 011001 16:16:42 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) With basedir=/var/lib/mysql and datadir not set: /usr/libexec/mysqld: Can't change dir to '/var/lib/mysql/var/' (Errcode: 2) 011001 16:18:23 Aborting 011001 16:18:23 /usr/libexec/mysqld: Shutdown Complete With datadir=/var/lib/mysql and basedir not set: More information on setting the parameters you find in the manual. 011001 16:19:19 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) The server version: /usr/libexec/mysqld Ver 3.23.42-max for pc-linux-gnu on i686 This is the latest version available from www.mysql.com. I also tried the latest version available from Red Hat (a little older version) with the same results. What gives? Todd Merriman [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 -- 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: \n is SLASH, N instead of newline
try echo select \test \n test\ | mysql -N -B stud out.txt Uriel Wittenberg wrote: I have a batch file called mysql.txt containing the single line, select test \n test; My command for running this file is: mysql -N -B stud mysql.txt out.txt After running the command, out.txt contains test \n test -- with the \n appearing literally, instead of a newline character. In other words, it's the output I'd expect from select test \\n test; Originator: Uriel Wittenberg Organization: Tsinghua U. MySQL support: none Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.42 Exectutable: mysql.exe Environment: Pentium processor, 64 MB RAM System:Windows Me - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
MySQL vs. NFS locking
How dependent is MySQL on proper NFS locking between threads of the same server? Some background: I have a small application with lots of data that stores recent RADIUS records for lookup by techs to help diagnose dialup problems. The application runs with MySQL 3.23.10 (yes, I know, I ought to upgrade, but it's currently working fine) on a small Alpha system running OSF 4.0D. The application is write-mostly read-occasionally (at least 95% of the activity is REPLACE). The problem: managers want to keep records for a much longer time, and this machine doesn't have the disk space. Further, it probably can't be expanded within reasonable cost. Proposed solution: use this big NFS server we've got and put the database on that. We can do striped and mirrored filesystems, and set up more storage. There is *NO* intent to run multiple instances of the server using the same database (we might switch to a more powerful CPU) and I think it is possible to effectively threaten the admins (I get to handle problems with this app most of the time) with dire consequences if they run myisamchk while the server is still running. Problems: NFS locking doesn't seem to work. First try: copy databases over, run myisamchk. Fails with no locks available. Start up rpc.lockd and rpc.statd. Run myisamchk. Hangs indefinitely. The server is *NOT* running on this copy yet, and if myisamchk won't work, it won't ever be. Assuming that NFS locking can be gotten to work at all, it will probably be flakey. Does MySQL depend on NFS locking (when database is on NFS filesystem) to do table locking between different queries sent to the same server? Does anyone see any problems with *ONE* instance (but multiple threads at times) of the server running with the database on a NFS filesystem, with manual locking between the server and myisamchk? Gordon L. Burditt - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP-DB] Re: Yes or No
I've decided on enum. Should work fine. I've used it before and it works fine with PHP. Thanks for everyone help, Jord On Tuesday 02 October 2001 12:13, you wrote: If I wanted to define a table to have a cloumn which is either yes or no for example. Would it be better to use a single char (0 or 1), or can I use an enum (I find them more friendly ;)). Since enums are internaly stored as numbers, and are therefore fast, it's better to use them than characters. Unless ther's a specific need. It, for instance, depends on how you're gonna use them in case you select them. For example, if you have enum('yes','no'), and you select it in perl, using them in if statements like this: if ($sqlref-[0][0]) { do something; } wont work, since, when selected in string context, you're gonna get 'yes', which is true (it will work if one selects it in integer context). But using characters '0' and '1' will always work, string '0' is false in perl. -- Jordan Elver Web Developer The InternetOne UK 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: Is right DB for our purpose
A piece of cake for MySQL. Our news/photo database is growing by nearly 10,000 records per month, with no noticeable performance impact. As long as you design your database structure and queries right ... Tom Haapanen [EMAIL PROTECTED] -Original Message- From: Paul Murphy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 02 October, 2001 09:21 To: [EMAIL PROTECTED] Subject: Is right DB for our purpose Hi, We are planning to create an web database(6 - 7 tables with the average of 6 columns), where members search for the right person by entering the proper search criteria. We expect that this database will grow in the rate of 1000 to 2000 records in a month. Could you please let us know whether the MySQL database is the right choice for our purpose as soon as possible. Because we are nearly ready to sign an agreement with a webhosting company. Please reply to the following email address [EMAIL PROTECTED] Thank you Ruthira S Steinhart Net esolutions - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
what is the security issue with dynamic format?
hi I am presently going over the mysql documentation to get familiar with it, It runs great on my development server (linux RH7.1 kernel=2.4.2-2 resin application server), I am in the process of optimizing and testing , I am using blob datatype in my main table, I understand why a fixed-size format is faster, but why is it more secure? I must use the dynamic format because of blobs, what are the security issues in using this format? clip from http://www.mysql.com/information/presentations/presentation-oscon2000-2719/index.html MySQL row types (only relevant for ISAM/MyISAM tables) MySQL will create the table in fixed size table format if all columns are of fixed length format (no VARCHAR, BLOB or TEXT columns). If not, the table is created in dynamic-size format. -?? Fixed-size format is much faster and more secure than the dynamic format. --?? The dynamic-size row format normally takes up less space but may be fragmented over time if the table is updated a lot. In some cases it's worth it to move all VARCHAR, BLOB and TEXT columns to another table just to get more speed on the main table. With myisampack (pack_isam for ISAM) one can create a read-only, packed table. This minimizes disk usage which is very nice when using slow disks. The packed tables are perfect to use on log tables which one will not update anymore. - Any comments would be appreciated thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Order By Limit; Count
Hi, I have been using the ORDER By clause in one of my sql queries and it works fine; however when I combine it with a LIMIT it still order's the results by it doesn't do it the way its supposed to, for example:- Order By clause without Limit returns:- A B C C C C C C M N T W Order By clause with Limit returns:- C C C C C C M N T W Is there any way to fix this, so that the results with the limit comes out starting with the A and then moves on to the next pages? Also, can I add a count(*) in my sql statement to get the total number of records even though I would be using Limit? I tried something along the lines of:- SELECT *, COUNT(*) from table where column like keyword order by title desc limit 0,10; and that dint work, so any ideas? Thanks.. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Hazardous problem making arithmetic operation on date fields.
Description: When multiplying a date field with a number( any type ) field for some values in any of these 2 fields mysql did nt answer to queries. How-To-Repeat: # # Table structure for table 'testdate' # CREATE TABLE testdate ( ID int(11) NOT NULL auto_increment, DATE time DEFAULT '00:00:00' NOT NULL, coef decimal(4,2) DEFAULT '0.00' NOT NULL, PRIMARY KEY (ID) ); # # Dumping data for table 'testdate' # INSERT INTO testdate VALUES( '1', '15:54:52', '0.75'); INSERT INTO testdate VALUES( '2', '00:17:21', '0.75'); INSERT INTO testdate VALUES( '3', '00:10:00', '0.75'); when executing this query : mysql select date,coef,sec_to_time(time_to_sec(date*coef)) from testdate; +--+--+-+ | date | coef | sec_to_time(time_to_sec(date*coef)) | +--+--+-+ | 15:54:52 | 0.75 | NULL| | 00:17:21 | 0.75 | NULL| | 00:10:00 | 0.75 | 00:07:50| +--+--+-+ 3 rows in set (0.00 sec) Fix: how to correct or work around the problem, if known (multiple lines) Submitter-Id: submitter ID Originator:Malko ([EMAIL PROTECTED]) Organization: organization of PR author (multiple lines) MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.31 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.13 Distrib 3.23.31, 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.31 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 20 days 4 hours 17 min 53 sec Threads: 1 Questions: 96455 Slow queries: 0 Opens: 30 Flush tables: 1 Open tables: 10 Queries per second avg: 0.055 Environment: machine, os, target, libraries (multiple lines) System: Linux Trex 2.2.18 #2 SMP Thu Feb 8 14:10:31 CET 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS='-O6 -fomit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fomit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jan 18 2001 /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 --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.005_03 built for i386-linux _ Téléchargez MSN Explorer gratuitement à l'adresse http://explorer.msn.fr/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
databases
Hi, i have a simple question: how many databases is mysql able to handle. i have a mysql server on a dual xenon with 2GB ram with 300 Databases (for each customer one) but in the meantime a simple query takes ages to complete 10s select * from table tablename (11K rows) (no other links are active 100% cpu for this query) the same db on a fresh mysql installation (same binary config) on a second box (dual xenon 2GB Ram) is as fast as it i expect it to be les than 1s. therfore the exact dirrence between the boxes is only that one has 300 DB's the other not. both boxes had no load while testing. has someone the same a idea if this realy the reason or not ? Box OS FBSD 4.3 (yes a OS not scrap) regards. I personlay prefere postgresql but there i have no such problems but others ;) -- Andre Schwaller - Interdata AG Andre Schwaller Gewerbepark CH-5506 Mägenwil E-Mail [EMAIL PROTECTED] Voice: +41 62 887 3732 Fax:+41 62 896 1133 Internet: http://www.interdata.ch - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Hazardous problem making arithmetic operation on date fields.
Malko Malko writes: mysql select date,coef,sec_to_time(time_to_sec(date*coef)) from testdate; Why do you multiply the date with a number and then convert it to a number? Shouldn't it be the other way around? :-O //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Subselects
(Apologies in advance if this is the wrong place to ask, but this is my first foray into this list.) I would like to use Subselects with mySQL but they are not supported until 3.24. Can anyone tell me if there is an estimated date for the release of 3.24? Secondly is it likely that the 3.23beta release has the subselects feature? Or is there a web page describing features and releases? (I have looked! But could not find anything.). Regards. John Seers Lion Bioscience 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: Counting Sequences Clarified
At 9:04 PM +1000 10/2/01, Bruce Collins wrote: Hello, Thank's for your interest Paul. I did a poor job of explaining my problem. Here is another go: For an athlete's first entry in the database I need a column value of 1. The second performance entry of the same athlete would have a value of 2. And so on. I need to apply this retrospectively to ten years of performance records. Ongoing updates are not an issue at present. Thanks Bruce If you have a column identifies each athlete, say, by name, you can add an AUTO_INCREMENT column and create a primary key that combines the two columns. Then records will be auto-numbered, individually for each athlete name. This assumes a version of MySQL = 3.22.25. ALTER TABLE tbl_name ADD seqnum INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD PRIMARY KEY (name, seqnum) name should have been declared NOT NULL as well. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Order By Limit; Count
At 11:48 AM -0300 10/2/01, Ashwin Kutty wrote: Hi, I have been using the ORDER By clause in one of my sql queries and it works fine; however when I combine it with a LIMIT it still order's the results by it doesn't do it the way its supposed to, for example:- Your examples don't show the actual queries you're using, so it's difficult to say whether or not they're working correctly. Order By clause without Limit returns:- A B C C C C C C M N T W Order By clause with Limit returns:- C C C C C C M N T W Is there any way to fix this, so that the results with the limit comes out starting with the A and then moves on to the next pages? Also, can I add a count(*) in my sql statement to get the total number of records even though I would be using Limit? I tried something along the lines of:- SELECT *, COUNT(*) from table where column like keyword order by title desc limit 0,10; and that dint work, so any ideas? You'll be able to do this in MySQL 4.0. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Hazardous problem making arithmetic operation on date fields.
At 5:22 PM +0200 10/2/01, Malko Malko wrote: Description: When multiplying a date field with a number( any type ) field for some values in any of these 2 fields mysql did nt answer to queries. How-To-Repeat: # # Table structure for table 'testdate' # CREATE TABLE testdate ( ID int(11) NOT NULL auto_increment, DATE time DEFAULT '00:00:00' NOT NULL, coef decimal(4,2) DEFAULT '0.00' NOT NULL, PRIMARY KEY (ID) ); # # Dumping data for table 'testdate' # INSERT INTO testdate VALUES( '1', '15:54:52', '0.75'); INSERT INTO testdate VALUES( '2', '00:17:21', '0.75'); INSERT INTO testdate VALUES( '3', '00:10:00', '0.75'); when executing this query : mysql select date,coef,sec_to_time(time_to_sec(date*coef)) from testdate; Don't you mean sec_to_time(time_to_sec(date)*coef) instead? +--+--+-+ | date | coef | sec_to_time(time_to_sec(date*coef)) | +--+--+-+ | 15:54:52 | 0.75 | NULL| | 00:17:21 | 0.75 | NULL| | 00:10:00 | 0.75 | 00:07:50| +--+--+-+ 3 rows in set (0.00 sec) -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL vs. NFS locking
At 9:11 AM -0500 10/2/01, [EMAIL PROTECTED] wrote: How dependent is MySQL on proper NFS locking between threads of the same server? Running MySQL over NFS is a bad idea. -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
strange replication problems
Description: Hi, I have 28 linux boxes configured identically, 27 as slaves, one as master. On all 27 slaves, everything works fine, but only on one I have strange errors in the logs: 011002 17:49:49 Slave: received 0 length packet from server, apparent master shutdown: (0) 011002 17:50:49 Slave: Failed reading log event, reconnecting to retry, log 'cp4230-bin.005' position 664857 011002 17:50:49 Slave: reconnected to master 'repl@xxx:3306',replication resumed in log 'xxx-bin.005' at position 664857 011002 17:51:49 Slave: received 0 length packet from server, apparent master shutdown: (0) This repeats every minute. I repeat, replication is running fine, just these errors that are bugging me, and only on one of 27 machines. Could this be a networking problem of some sort? my my.cnf: [client] #password = your_password port= 3306 socket = /tmp/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=256M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=64M set-variable= thread_cache=8 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=4 set-variable= max_connections=2000 #log-bin server-id = 101 master-host=xxx master-user=repl master-password=micro master-port=3306 replicate-do-table=micro.screen_text replicate-do-table=micro.websp_prices replicate-do-table=micro.websp_flights replicate-do-table=micro.partner_config replicate-do-table=micro.banner_ads replicate-do-table=micro.country replicate-do-table=micro.partner_country replicate-do-table=micro.es_airports [mysqldump] quick set-variable= max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=128M set-variable= sort_buffer=128M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout How-To-Repeat: no idea Fix: no idea Submitter-Id: submitter ID Originator:root Organization: 2e Systems MySQL support: [none ] Synopsis: strange failures during replication Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.39 (Source distribution) Environment: Dual PIII/866, 1Gb RAM, SuSe 7.1 System: Linux cp4120 2.2.18-SMP #1 SMP Sat Jan 20 07:41:17 GMT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1382179 Jan 19 2001 /lib/libc.so.6 -rw-r--r--1 root root 2585872 Jan 19 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Jan 19 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/web/soft/mysql-3.23.39 --without-docs --without-bench --without-readline --without-debug --with-pthread --with-charset=german1 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 0000-00-00 vs NULL in Date Field
If I read a file into a database with a \N in an empty date field the field is populated with -00-00. If I insert a row into the same database with NULL in the date field it is populated with NULL. Programmatically is there a difference between the two? The field is proably defined with a default of -00-00, which MySQL then uses when you input no data. That doesn't stop you from entering NULL specifically, unless the field is declared NOT NULL. / 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: Subselects
As far as I know. There is no 3.24.xx coming out, but instead 4.0 in a few days or weeks according to various posting on this list. But I know be wrong! Hope this help Daniel -Original Message- From: John Seers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 11:44 To: [EMAIL PROTECTED] Subject: Subselects (Apologies in advance if this is the wrong place to ask, but this is my first foray into this list.) I would like to use Subselects with mySQL but they are not supported until 3.24. Can anyone tell me if there is an estimated date for the release of 3.24? Secondly is it likely that the 3.23beta release has the subselects feature? Or is there a web page describing features and releases? (I have looked! But could not find anything.). Regards. John Seers Lion Bioscience 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Dump only Data
Hi How to Dump only the data from a Table. I took a look at the mysqldump options, but I didn't find something that works fine ! Regards Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Dump only Data
Hi Claudemir, Perhaps you are really looking for SELECT INTO OUTFILE syntax? http://www.mysql.com/doc/S/E/SELECT.html Ken - Original Message - From: fi-claudemir [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 12:55 PM Subject: How to Dump only Data Hi How to Dump only the data from a Table. I took a look at the mysqldump options, but I didn't find something that works fine ! Regards Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How to Dump only Data
Didn't work... still there are informations and the INSERT INTO clause into the dumped file Thanks anyway! Claudemir F. Martins Robert Cope wrote: On Tue, Oct 02, 2001 at 01:55:13PM -0300, fi-claudemir wrote: How to Dump only the data from a Table. I took a look at the mysqldump options, but I didn't find something that works fine ! Do --no-create-info and --no-create-db not do the trick? robert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Dump only Data
Here directly from Paul Dubois's book page 619-620 mysqldump --opt db_name backup_file So, it would be here: mysqldump --no-create-info db_name backup_file Or if you want the create statement as well, just do mysqldump db_name backup_file His book is a very good one and have all you can dream and more. I hope we will be lucky to get a revise copy for the 4.0, but I am sure this is hell to do. Hope this answer your question. Daniel -Original Message- From: fi-claudemir [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 12:55 To: mysql Subject: How to Dump only Data Hi How to Dump only the data from a Table. I took a look at the mysqldump options, but I didn't find something that works fine ! Regards Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How to Dump only Data
From page 620 in MySQL... * -t or --no-create-info Does not write CREATE TABLE statements Since DROPs are off by default, this should give you just the insert statements. The other option (as already suggested) is SELECT INTO OUTFILE. Jay Fesco -Original Message- From: fi-claudemir [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 12:55 PM To: mysql Subject: How to Dump only Data Hi How to Dump only the data from a Table. I took a look at the mysqldump options, but I didn't find something that works fine ! Regards Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 0000-00-00 vs NULL in Date Field
Here's what I did: mysql create database testnull; Query OK, 1 row affected (0.05 sec) mysql use testnull; Database changed mysql create table info (birth date); Query OK, 0 rows affected (0.03 sec) mysql show tables; ++ | Tables_in_testnull | ++ | info | ++ 1 row in set (0.00 sec) mysql describe info; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | birth | date | YES | | NULL| | +---+--+--+-+-+---+ 1 row in set (0.01 sec) mysql describe info; +---+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | birth | date | YES | | NULL || | death| date | YES | | NULL| | +---+--+--+-+-+---+ 2 rows in set (0.00 sec) mysql load data local infile date.txt into table info; Query OK, 4 rows affected (0.01 sec) Records: 4 Deleted: 0 Skipped: 0 Warnings: 1 mysql select * from info; +++ | birth | death | +++ | 1999-01-01 | -00-00 | | 1990-05-21 | -00-00 | | 1989-12-20 | -00-00 | | -00-00 | NULL | +++ 4 rows in set (0.00 sec) date.txt is as follows: 1999-01-01 /N (date followed by tab followed by /N) 1990-05-21 NULL(date followed by tab followed by NULL) 1989-12-20 (date followed by tab with nothing beyond) (single tab - no data) Any idea of why this works as it does? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bug, mySQL keeps crashing.
On Mon, Oct 01, 2001 at 04:41:58PM -0600, Spinlock wrote: I was using gcc not g++ The guts of MySQL are written in C++, and hence the Gnu C++ compiler will be used: From the manpage gcc(1): DESCRIPTION The C and C++ compilers are integrated. Both process input files through one or more of four stages: prepro- cessing, compilation, assembly, and linking. Source file- name suffixes identify the source language, but which name you use for the compiler governs default assumptions: gccassumes preprocessed (.i) files are C and assumes C style linking. g++assumes preprocessed (.i) files are C++ and assumes C++ style linking. -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [PHP-DB] Re: Yes or No
An enum should work fine as you've described, but remember that the ENUM type is a MySQL proprietary type and if you ever want to convert to another database (Oracle, PostgreSQL, MSSQL, Etc.), you may have to find an appropiate solution (i.e. convert to integer and use 0 and 1)... On Tue, 2 Oct 2001, Jordan Elver wrote: I've decided on enum. Should work fine. I've used it before and it works fine with 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: repost: Too many open files
it sounds like you've run out of file descriptors, I suggest rebuilding your kernel to handle more. In a bsd kernel you can do this simply by upping the maximum number of users allowed to access the machine at any given time. Robin Keech wrote: Hi, Any help would be greatly appreciated as I have a production server that is struggling. (I only get the digest list, so could you copy me on any replies - thankyou). My error log show this... 011002 9:16:11 Error in accept: Too many open files 011002 9:36:43 /usr/local/mysql/libexec/mysqld: Shutdown Complete 011002 09:36:43 mysqld ended 011002 09:36:52 mysqld started 011002 9:36:52 Warning: setrlimit couldn't increase number of open files to more than 1024 011002 9:36:52 Warning: Changed limits: max_connections: 500 table_cache: 257 /usr/local/mysql/libexec/mysqld: ready for connections I am getting the too many open files error. What does the setrlimit log line mean? How many connections can I have before reaching 'too many connections'? What can I do about it? I have looked in docs. open_files_limit If this is not 0, then mysqld will use this value to reserve file descriptors to use with setrlimit(). If this value is 0 then mysqld will reserve max_connections*5 or max_connections + table_cache*2 (whichever is larger) number of files. You should try increasing this if mysqld gives you the error 'Too many open files'. mine is 0 so it should use quite a big number ( 500 * 5) - is this too big? Should I set open_file_limits directly to something smaller? I have ... /proc/sys/fs/file-max = 8192 /proc/sys/fs/file-nr = 2097 14118192 my.cnf # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=2M set-variable= max_connections=500 set-variable= table_cache=512 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 set-variable= wait_timeout=1800 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=4 set-variable= myisam_sort_buffer_size=64M log-bin low-priority-updates binlog-ignore-db=e3 server-id = 1 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.282 / Virus Database: 150 - Release Date: 25/09/01 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 0000-00-00 vs NULL in Date Field
Here's what I did: mysql create database testnull; Query OK, 1 row affected (0.05 sec) mysql use testnull; Database changed mysql create table info (birth date); Query OK, 0 rows affected (0.03 sec) mysql show tables; ++ | Tables_in_testnull | ++ | info | ++ 1 row in set (0.00 sec) mysql describe info; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | birth | date | YES | | NULL| | +---+--+--+-+-+---+ 1 row in set (0.01 sec) mysql describe info; +---+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ | birth | date | YES | | NULL || | death| date | YES | | NULL| | +---+--+--+-+-+---+ 2 rows in set (0.00 sec) How come two identical commands show different results here? mysql load data local infile date.txt into table info; Query OK, 4 rows affected (0.01 sec) Records: 4 Deleted: 0 Skipped: 0 Warnings: 1 mysql select * from info; +++ | birth | death | +++ | 1999-01-01 | -00-00 | | 1990-05-21 | -00-00 | | 1989-12-20 | -00-00 | | -00-00 | NULL | +++ 4 rows in set (0.00 sec) date.txt is as follows: 1999-01-01 /N (date followed by tab followed by /N) 1990-05-21 NULL(date followed by tab followed by NULL) 1989-12-20 (date followed by tab with nothing beyond) (single tab - no data) Any idea of why this works as it does? Because you used /N rather than \N ... -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: repost: Too many open files
Colin Faber wrote: it sounds like you've run out of file descriptors, I suggest rebuilding your kernel to handle more. In a bsd kernel you can do this simply by upping the maximum number of users allowed to access the machine at any given time. Or in Linux (in my rc.local): echo Set max files to 32768 echo 32768 /proc/sys/fs/file-max --Bill 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
Re:Possible bug?
Heikki, Update on this. Managed to get this to happen with the file updates you sent, on an internal box(same config as original problem rpt), log info follows: //Log file starts 011002 13:28:19 mysqld started InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 293003 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=314568704 record_buffer=16773120 sort_buffer=67108856 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 110187 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, fp=0xbfffd830, stack_bottom=0x49d856f0, thread_stack=131072, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x49040760 is invalid pointer thd-thread_id=137794600 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 137794600 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash 011002 13:28:19 mysqld ended 011002 13:28:53 mysqld started InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 293003 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=314568704 record_buffer=16773120 sort_buffer=67108856 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 110187 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, fp=0xbfffd830, stack_bottom=0x49d856f0, thread_stack=131072, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x49040760 is invalid pointer thd-thread_id=137794600 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 137794600 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash 011002 13:28:54 mysqld ended //Log file ends Thanks, Chris On Thu, 27 Sep 2001, Heikki Tuuri wrote: Ok, I have added some debug code to the upcoming 3.23.43 so that if the bug reappears, mysqld will print a lot of diagnostic info. That is the best solution. I could also put some fault tolerance in, but I am afraid people would not send bug reports then. Regards, Heikki At 03:36 PM 9/27/01 -0400, you wrote: On Thu, 27 Sep 2001, Heikki Tuuri wrote: Heikki, I'll give it a shot. I probably won't be able to recreate very quickly, I had to take some more drastic steps to get everything back up. It happened on a field-trial system, so we wiped the db clean and recreated it. I'll probably load it into a in-house machine too. Wish I could give you access to the offending system, but it's behind someone else's security perimeter. Thanks, Chris Chris, I have attached mysql/innobase/btr/btr0pcur.c and mysql/innobase/ibuf/ibuf0ibuf.c (maybe it comes as 'ibuf0i~1.c' since Eudora does not understand 8-char file names). Recompile with these. They will print a lot of info to the standard output of mysqld. That may help me to find the
RE: How to Dump only Data
I just tried this, but I get the result: mysql SELECT * FROM ga_perf INTO OUTFILE /home/georgee/ga_perf.out; ERROR 1: Can't create/write to file '/home/georgee/ga_perf.out' (Errcode: 13) my username (georgee) is fully priveledged, and /home/georgee is my home directory, so I certainly have permission there. There is no existing file with the name I provided. I double checked the user table of the mysql database: mysql select host, file_priv from user where user='georgee'; hostfile_priv % Y localhost Y I am running the mysql client on the same system that the server is on, so the restriction on running SELECT INTO OUTFILE from a remote host shouldn't be an issue. Any ideas? I'm pretty green on this whole SQL business, so it's probably something obvious! Thanks Eric -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 11:08 AM To: fi-claudemir; mysql Subject: Re: How to Dump only Data Hi Claudemir, Perhaps you are really looking for SELECT INTO OUTFILE syntax? http://www.mysql.com/doc/S/E/SELECT.html Ken - Original Message - From: fi-claudemir [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 12:55 PM Subject: How to Dump only Data Hi How to Dump only the data from a Table. I took a look at the mysqldump options, but I didn't find something that works fine ! Regards Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error message
Dear list members, This is the first time i am trying to connect to my database on mysql using php. The code is : HTML ?php $hostname = localhost; $password = password; $user = testing; mysql_connect($hosthame,$user,$password); $result = mysql(assetbase,SELECT param FROM parameter_tbl); $total_rows = mysql_numrows($result); echo $total_rows; ? /BODY /HTML Error message: Warning: MySQL Connection Failed: Access denied for user: 'testing@localhost' (Using password: YES) in /var/www/html/contact.php on line 8 Please help. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 message
The error message you get is not related to PHP, but to the access right preset into MySQL. Basically, MySQL tell you that you can't connect to it with the user name testing. Check your right access in MySQL. Daniel -Original Message- From: Harpreet [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 15:07 To: Mysql (E-mail) Subject: Error message Dear list members, This is the first time i am trying to connect to my database on mysql using php. The code is : HTML ?php $hostname = localhost; $password = password; $user = testing; mysql_connect($hosthame,$user,$password); $result = mysql(assetbase,SELECT param FROM parameter_tbl); $total_rows = mysql_numrows($result); echo $total_rows; ? /BODY /HTML Error message: Warning: MySQL Connection Failed: Access denied for user: 'testing@localhost' (Using password: YES) in /var/www/html/contact.php on line 8 Please help. Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: How to Dump only Data
Yes, the mysql process is writing the file so mysql must have permissions to write there. Try writing /tmp/myfile.txt or create a directory with write permissions for the group or user that mysql is running as. Best of Luck Ken - Original Message - From: George Eric R Contr AFSPC/CVYZ [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 2:55 PM Subject: RE: How to Dump only Data I just tried this, but I get the result: mysql SELECT * FROM ga_perf INTO OUTFILE /home/georgee/ga_perf.out; ERROR 1: Can't create/write to file '/home/georgee/ga_perf.out' (Errcode: 13) my username (georgee) is fully priveledged, and /home/georgee is my home directory, so I certainly have permission there. There is no existing file with the name I provided. I double checked the user table of the mysql database: mysql select host, file_priv from user where user='georgee'; hostfile_priv % Y localhost Y I am running the mysql client on the same system that the server is on, so the restriction on running SELECT INTO OUTFILE from a remote host shouldn't be an issue. Any ideas? I'm pretty green on this whole SQL business, so it's probably something obvious! Thanks Eric -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 11:08 AM To: fi-claudemir; mysql Subject: Re: How to Dump only Data Hi Claudemir, Perhaps you are really looking for SELECT INTO OUTFILE syntax? http://www.mysql.com/doc/S/E/SELECT.html Ken - Original Message - From: fi-claudemir [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 12:55 PM Subject: How to Dump only Data Hi How to Dump only the data from a Table. I took a look at the mysqldump options, but I didn't find something that works fine ! Regards Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 one SELECT records depending on multiple entries in a many to many table?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Benjamin Hi. On Mon, Oct 01, 2001 at 07:54:37PM -0700, [EMAIL PROTECTED] wrote: Hi there, I have a many-to-many relationship: ind table - id = 4, name = Joe id = 5, name = Jane bus_ctr table - id = 1, name = downtown mall id = 2, name = sunshine mall id = 3, name = express shop mm_ind_bus_ctr table (many to many association table) - id = 6, ind_id = 4, bus_ctr_id = 1 id = 7, ind_id = 4, bus_ctr_id = 2 id = 8, ind_id = 4, bus_ctr_id = 3 id = 9, ind_id = 5, bus_ctr_id = 1 Is there a way to create a SELECT that returns only the people in the ind table that are associated with bus_ctr.id=1, bus_ctr.id=2 and bus_ctr.id=3? In other words a SELECT that only returns the ind.id = 4 (Joe) record? Do you want an exact match or an at least match, i.e. what if id = 10, ind_id = 4, bus_ctr_id = 5 would be given. Does Joe still match? I'm looking for an exact match, so if that record also existed in mm_ind_bus_ctr, Joe should not match. I've only been able to create a SELECT that would return both Jane and Joe so far. If you have something, please post it, even if it isn't correct. It will give other a better idea of what's all about (if you also post the result and what you don't like about it). I was going at it from the wrong direction as this provides the at least match. SELECT DISTINCT i.id, i.name FROM ind i, mm_ind_bus_ctr mm WHERE mm.bus_ctr_id IN (1,2,3) AND i.id=mm.ind_id; The select will get a bit large, because you need several joins. In fact, you want to check for three relations and therefore needs as much tables to join with: SELECTi.id, i.name FROM ind i, mm_ind_bus_ctr bi1, mm_ind_bus_ctr bi2, mm_ind_bus_ctr bi3 WHERE bi1.bus_ctr_id = 1 AND bi2.bus_ctr_id = 2 AND bi3.bus_ctr_id = 3 AND bi1.ind_id = i.id AND bi2.ind_id = i.id AND bi3.ind_id = i.id Untested, but should work. It does work and is exactly what I was hoping for. I was missing the multiple alias for a single table technique. Bye, Benjamin. Thank you, Benjamin. I really appreciate your time and help! -Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to Dump only Data
Oops, Yea, that's pretty obvious now that you pointed it out! Thanks Eric -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 1:11 PM To: George Eric R Contr AFSPC/CVYZ; mysql Subject: Re: How to Dump only Data Yes, the mysql process is writing the file so mysql must have permissions to write there. Try writing /tmp/myfile.txt or create a directory with write permissions for the group or user that mysql is running as. Best of Luck Ken - Original Message - From: George Eric R Contr AFSPC/CVYZ [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 2:55 PM Subject: RE: How to Dump only Data I just tried this, but I get the result: mysql SELECT * FROM ga_perf INTO OUTFILE /home/georgee/ga_perf.out; ERROR 1: Can't create/write to file '/home/georgee/ga_perf.out' (Errcode: 13) my username (georgee) is fully priveledged, and /home/georgee is my home directory, so I certainly have permission there. There is no existing file with the name I provided. I double checked the user table of the mysql database: mysql select host, file_priv from user where user='georgee'; hostfile_priv % Y localhost Y I am running the mysql client on the same system that the server is on, so the restriction on running SELECT INTO OUTFILE from a remote host shouldn't be an issue. Any ideas? I'm pretty green on this whole SQL business, so it's probably something obvious! Thanks Eric -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 11:08 AM To: fi-claudemir; mysql Subject: Re: How to Dump only Data Hi Claudemir, Perhaps you are really looking for SELECT INTO OUTFILE syntax? http://www.mysql.com/doc/S/E/SELECT.html Ken - Original Message - From: fi-claudemir [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Tuesday, October 02, 2001 12:55 PM Subject: How to Dump only Data Hi How to Dump only the data from a Table. I took a look at the mysqldump options, but I didn't find something that works fine ! Regards Claudemir F. Martins - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compile MySQL with GCC 2.95.3 optimise for I686
Hi, I am looking into using optimization of the GCC 2.95.3 for I686 as -O3 -mpentiumpro to compile an optimize version of MySQL. But as I look around, I see that some user warned about using this as they said there is bug in GCC for I686 optimization. Any information you can pass to me on that? Is it still true for the 2.95.3. I know that the 2.95.2 had issues, but I want to check for the this. Also, as I am on the subject, what about using the GCC 3.01. Any better with good result so far. Any one? Thanks Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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:Possible bug?
Hi! The log sequence number is only 300 000 bytes :). You have data and log files which are almost completely full of zeros, and consequently if you compress them with gzip, you are able to send them to me as attachments. Some notes on possible Linux bugs: I notice that you are running the Linux kernel 2.2.14. MySQL AB people recently sent the following advisory which is now also in the manual: http://www.mysql.com/doc/B/i/Binary_notes-Linux.html WARNING: We have have reports from some MySQL users that they have got serious stability problems with MySQL with Linux kernel 2.2.14. If you are using this kernel you should upgrade to 2.2.19 (or newer) or to a 2.4 kernel. If you have a multi-cpu box, then you should seriously consider using 2.4 as this will give you a significant speed boost. My development platform is a 2-way Xeon with Linux 2.4.4-64GB-SMP i686. I have not seen any strange thread crashes or database page corruption in it. In a 2-way Red Hat 6.2 box with software RAID I got both file corruption and thread crashes in my tests. InnoDB calls often fsync and has more threads than MyISAM. That may make it more susceptible to kernel bugs. You could also try downloading a binary from the MySQL site www.mysql.com. Monty tries to compile them in the best way to keep Linux bugs at bay. Regards, Heikki At 02:21 PM 10/2/01 -0400, you wrote: Heikki, Update on this. Managed to get this to happen with the file updates you sent, on an internal box(same config as original problem rpt), log info follows: //Log file starts 011002 13:28:19 mysqld started InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 293003 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=314568704 record_buffer=16773120 sort_buffer=67108856 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 110187 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, fp=0xbfffd830, stack_bottom=0x49d856f0, thread_stack=131072, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x49040760 is invalid pointer thd-thread_id=137794600 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 137794600 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid The manual page at http://www.mysql.com/doc/C/r/Crashing.html contains information that should help you find out what is causing the crash 011002 13:28:19 mysqld ended 011002 13:28:53 mysqld started InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 293003 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=314568704 record_buffer=16773120 sort_buffer=67108856 max_used_connections=0 max_connections=100 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 110187 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Bogus stack limit or frame pointer, fp=0xbfffd830, stack_bottom=0x49d856f0, thread_stack=131072, aborting backtrace. Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x49040760 is invalid pointer thd-thread_id=137794600 Successfully dumped variables, if you ran with --log, take a look at the details of what thread 137794600 did to cause the crash. In some cases of really bad corruption, the values shown above may be invalid The
Re: MySQL MAx
Hi! I am forwarding the following message from the newsgroup mailing.database.mysql richarde explained that from the rpm you have to install both MySQL-... and MySQL-Max-... (As a sidenote people recently asked if there is a newsgroup on MySQL. It is the above mentioned newsgroup, but it is not a good idea to post there, because newsgroup messages are not sent to the mailing list, though mails appear in the newsgroup.) Regards, Heikki http://www.innodb.com/ibman.html [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: In article 9pcalq$244g$[EMAIL PROTECTED], robertc [EMAIL PROTECTED] wrote: I have had a similar problem - you must make sure you install all the RPM's including the normal mysql. Doing an rpm -qa|grep My must yeild something like this: MySQL-devel-3.23.41-1 MySQL-Max-3.23.41-1 MySQL-shared-3.23.41-1 MySQL-client-3.23.41-1 MySQL-3.23.41-1 Note this one too! MySQL max is only a binary and nothing else. I do not think MySQL max RPM check for which version of MySQL is actually installed and also does not do a dependancy check for the standard mysql rpm. Heikki, The only ones I found were in /usr/share/mysql. Did a find starting in root. Robert Heikki Tuuri [EMAIL PROTECTED] wrote: Robert, the installation program obviously failed to put the new errmsg files to the right place. Look for the new errmsg files somewhere, usually the directory is something like .../share/english, and copy them to /usr/share/mysql/english Regards, Heikki http://www.innodb.com/ibman.html Just installed MySQL Max 3.23.43 on a LInux box from the rpm. When starting get the following message: /usr/sbin/mysqld-max: Fatal error: Error message file '/usr/share/mysql/english/errmsg.sys' had only 205 error messages, but it should have at least 213 error messages. Check that the above file is the right version for thisprogram! The system previously had a normal version of 3.23. Any ideas as to what might have gone wrong?ThanksRobert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 queries
Hello All, I have several queries that generate various financial reports, by date ranges. I've been trying to figure out a way to combine all these queries into one query , if it's at all possible or if it's practical to combine them into one large query. The single query I tried doesn't produce the proper results. The multiple queries below do produce the desired results, but I'd like to combine them into one single query, if it's possible. TOTAL SUMMARY PAYIN's/PAYOUT's(single query) select format(sum(po.refund_charge*.95),2) as RefundCharge, format(sum(po.refund_check),2) as RefundCheck, format(sum(po.chargeback*.95)+ (count(po.chargeback)*-15),2) as ChargeBack, format(sum(po.badcheck)+ (count(po.badcheck)*-15),2) as Badcheck, format(sum(pi.amt_charge*.95),2) as TotalCharge, format(sum(pi.amt_check),2) as TotalCheck from payhistory ph left join payin pi on pi.payid = ph.payid left join payout po on po.payid = ph.payid where ph.paydate between '2001-09-01' and '2001-09-14' --- MULTIPLE SMALL QUERIES: (these queries do produce the desired results) === PAYOUTS: Total Refunds(Charge): select format(sum(p.refund_charge*.95),2) as RefundCharge from payout p,payhistory ph where ph.paydate between '2001-09-01' and '2001-09-14' and p.payid = ph.payid; Total Refunds(Check): select format(sum(p.refund_check),2) as RefundCheck from payout p,payhistory ph where ph.paydate between '2001-09-01' and '2001-09-14' and p.payid = ph.payid; Total ChargeBack query: select format(sum(p.chargeback*.95)+ (count(p.chargeback)*-15),2) as ChargeBack from payout p,payhistory ph where ph.paydate between '2001-09-20' and '2001-09-30' and p.payid = ph.payid; Total BadCheck query: select format(sum(p.badcheck)+ (count(p.badcheck)*-15),2) as Badcheck from payout p,payhistory ph where ph.paydate between '2001-09-20' and '2001-09-30' and p.payid = ph.payid; == PAYINS: Total New/Renewals(Charge): select format(sum(p.amt_charge*.95),2) as TotalCharge from payin p,payhistory ph where ph.paydate between '2001-09-01' and '2001-09-14' and p.payid = ph.payid; Total New/Renewals(Check): select format(sum(p.amt_check),2) as TotalCheck from payin p,payhistory ph where ph.paydate between '2001-09-01' and '2001-09-14' and p.payid = ph.payid; == Appreciate any suggestion or help. mysql database. 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
AW: sort mysql data
Not realy because ORDER BY is an MySQL command... Greetings, Hakan Wolf -Ursprüngliche Nachricht- Von: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 2. Oktober 2001 22:14 An: Hakan Wolf Cc: 'MySQL Mailinglist' Betreff: Re: sort mysql data On Tue, Oct 02, 2001 at 09:46:20PM +0200, Hakan Wolf wrote: Hi, is there any way to sort mysql data wich is read out by php according to the aplhabet Probably, yes. But that's more of a PHP question, isn't it? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 26 days, processed 539,677,276 queries (234/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HOW: Getting a list of connected users?
Is it possible to get a list of all users currently connected to a mysql server? Preferably the login name they use? Any ideas? I would like any commands which work on both windows and linux MySQL Thanks lots David Ayliffe ICQ# 125646758 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and tmp dir problem
When execcuting some queries in MySQL (3.23.42) on Redhat 7.1 i'v got error: ERROR 1: Can't create/write to file '/tmp/root-tmp.03a811f23b28d045/files/#sql61ba_d_0.MYI' (Errcode: 2) /tmp dir permission is 777 so there shouldn't be problem. When i create dir which mysql wants to write to everything is ok. MySQL server, works as mysql user. What's wrong? By the way, should mysql create tmpdir as root-tmp, not mysql-tmp ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HOW: Getting a list of connected users?
David Ayliffe writes: Is it possible to get a list of all users currently connected to a mysql server? Preferably the login name they use? Any ideas? http://www.mysql.com/doc/S/H/SHOW_PROCESSLIST.html -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HOW: Getting a list of connected users?
On Tue, Oct 02, 2001 at 09:21:03PM +0100, David Ayliffe wrote: Is it possible to get a list of all users currently connected to a mysql server? Preferably the login name they use? Any ideas? I would like any commands which work on both windows and linux MySQL SHOW PROCESSLIST Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 26 days, processed 539,966,608 queries (234/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: HOW: Getting a list of connected users?
Thank you -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: 02 October 2001 21:38 To: David Ayliffe Cc: [EMAIL PROTECTED] Subject: Re: HOW: Getting a list of connected users? On Tue, Oct 02, 2001 at 09:21:03PM +0100, David Ayliffe wrote: Is it possible to get a list of all users currently connected to a mysql server? Preferably the login name they use? Any ideas? I would like any commands which work on both windows and linux MySQL SHOW PROCESSLIST Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 26 days, processed 539,966,608 queries (234/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Multiple queries
[EMAIL PROTECTED] writes: I've been trying to figure out a way to combine all these queries into one query , if it's at all possible or if it's practical to combine them into one large query. The single query I tried doesn't produce the proper results. [SNIP] I'm not surprised, seeing how you did something funny with a couple of LEFT JOINs. If you look at what rows you get back and ponder, you'll see what goes wrong. To get the desired result you'll probably have to do as many selects as you have combinations of tables in your original queries, which (if I didn't glance too briefly at) them was 2. //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql and tmp dir problem
Have you checked that /tmp isn't full? If /tmp is its own filesystem, and its full, then no matter what the permissions you won't be able to write to it. At 10:24 PM 10/2/01 +0200, you wrote: When execcuting some queries in MySQL (3.23.42) on Redhat 7.1 i'v got error: ERROR 1: Can't create/write to file '/tmp/root-tmp.03a811f23b28d045/files/#sql61ba_d_0.MYI' (Errcode: 2) /tmp dir permission is 777 so there shouldn't be problem. When i create dir which mysql wants to write to everything is ok. MySQL server, works as mysql user. What's wrong? By the way, should mysql create tmpdir as root-tmp, not mysql-tmp ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OpenBSD mysql_install_db
OpenBSD 2.9 on macppc (G4 Cube). Built mysql-3.23.42 fine straight out of the box. Then, when I try to install the database it stops being such a perfect easy install. This is what I see, so if anyone can explain why I'd be very interested to know. Searching on deja and the mailing list archives doesn't seem to reveal much on this... bash-2.05# scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) 011002 20:21:26 /usr/local/mysql/libexec/mysqld: Shutdown Complete 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: OpenBSD mysql_install_db
Are you sure you have space on /var/mysql/mysql and that mysql user have access to it. That's where it is by default on OpenBSD. Daniel -Original Message- From: David Reid [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 17:15 To: [EMAIL PROTECTED] Subject: OpenBSD mysql_install_db OpenBSD 2.9 on macppc (G4 Cube). Built mysql-3.23.42 fine straight out of the box. Then, when I try to install the database it stops being such a perfect easy install. This is what I see, so if anyone can explain why I'd be very interested to know. Searching on deja and the mailing list archives doesn't seem to reveal much on this... bash-2.05# scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) ERROR: 3 Error writing file './mysql/db.frm' (Errcode: 2) 011002 20:21:26 /usr/local/mysql/libexec/mysqld: Shutdown Complete 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 4.0
by what i have seen there is a 4.0 version of MySQL. Where can I find more information about and even download a version of it ?!?!? Thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql 4.0
It will be available just in a few days for what I have been told. Not yet there. Daniel by what i have seen there is a 4.0 version of MySQL. Where can I find more information about and even download a version of it ?!?!? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FullText Searches
Hi! On Oct 02, Thomas Deliduka wrote: For MySQL Full-text Searches and indexes. Do these indexes take up a lot of disk space? Any information on this out there as to how much on average? In default configuration (that is without changing myisam/ftdefs.h) index can be as big as original text - on real world texts (that is with commas, quotes, spaces, etc.) about 50-70% of the original text. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: \n is SLASH, N instead of newline
It may not intuitive at first, but it is really what one wants for default. For example, how would you else know, whether test asdf was originally one row (test\nasdf) or two rows (test+asdf)? I would know because I'm the one who thought up and wrote -- for good reasons -- the select test\nasdf query. The principle is: commands should work consistently. Computers should give you what you ask for. mySQL should not make exceptions of special cases on the assumption that the user will be confused. -- http://urielw.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql-3.22.33
Please solve the problems # # groupadd mysql # useradd -g mysql mysql # cd /export/home0 # gunzip mysql-3.23.33.tar.gz | tar xvf - # cd mysql-3.23.33 # ./configure --prefix=/usr/local/mysql # make make all-recursive Making all in include Making all in Docs Making all in readline Making all in libmysql Making all in client Making all in strings Making all in dbug Making all in mysys Making all in extra Making all in regex Making all in isam . . . /usr/bin/rm -f copy-db copy-db-t /usr/bin/sed \ -e 's!@''benchdir''@!/usr/local/mysql/sql-bench!g' \ -e 's!@''bindir''@!/usr/local/mysql/bin!g' \ -e 's!@''scriptdir''@!/usr/local/mysql/bin!g' \ -e 's!@''prefix''@!/usr/local/mysql!g' \ -e 's!@''datadir''@!/usr/local/mysql/share!g' \ -e 's!@''localstatedir''@!/usr/local/mysql/var!g' \ -e 's!@''libexecdir''@!/usr/local/mysql/libexec!g' \ -e 's!@''PERL''@!/usr/local/bin/perl!' \ -e 's!@''VERSION''@!3.23.33!' \ -e 's!@''MYSQL_SERVER_SUFFIX''@!!' \ copy-db.sh copy-db-t /usr/bin/chmod +x copy-db-t /usr/bin/mv copy-db-t copy-db Making all in mysql-test make: Fatal error: Don't know how to make target `all' Current working directory /export/home0/mysql-3.23.33/mysql-test *** Error code 1 make: Fatal error: Command failed for target `all-recursive' Current working directory /export/home0/mysql-3.23.33 *** Error code 1 make: Fatal error: Command failed for target `all-recursive-am' Thank 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
Copy a column into a string
Hi, I would like to copy a database column ( row[index] ) into a string variable to get it onto a form. the example mysql provides are directing the column to cout, but how do I copy the column to a string variable ??? please help. many thanks Johann - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help with sql query
mysql - version 3.23.40-log (build from src) i have created a database that records ahrs worked and have 2 fields (amongst others) ahrs_start ahrs_end both are set as type time (hh:mm:ss) as we get paid for a minmum of 1hr for being called out i would like to be able to craft a query that subtracts ahrs_end from ahrs_start and then does a ceiling() on the difference. so that it displays effectivly everything rounded up to the highest hour has anyone done something similar??? Barry Haycock Sys Admin (UNIX Networking) ** B-Digital Pty Ltd Level 3, 207 Adelaide Tce Perth, Western Australia 6000 (ph) +61 8 9463 5800 (fax) +61 89463 5955 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
INSERT INTO SELECT ??
Hi DBAs: I want to copy TableA in DatabaseA to TableB in DatabaseB with changes in the attributes of the tables, what options do I have? I tried these: a) insert into TableB (id) select (id) from DatabaseA.TableA; this works b) insert into TableB (id,data) select (id,data) from DatabaseA.TableA; but this does not work, why? and how do I do this? The mysqlhotcopy copy the whole database or it can copy a single table? Thanks a lot. Wee - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 dump only table structure with MySQLDump?
I would like to extract the DDL for the database so I can re-run it elsewhere. MySQLDump can do that, but it also exports the data. Is there a way for it to just export the Create Table statements? TIA Barry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: sort mysql data
Try something like that in your SQL query: SELECT * FROM table_name ORDER BY FIELD_NAME -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 22:14 To: Hakan Wolf Cc: 'MySQL Mailinglist' Subject: Re: sort mysql data On Tue, Oct 02, 2001 at 09:46:20PM +0200, Hakan Wolf wrote: Hi, is there any way to sort mysql data wich is read out by php according to the aplhabet Probably, yes. But that's more of a PHP question, isn't it? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 26 days, processed 539,677,276 queries (234/sec. avg) - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 dump only table structure with MySQLDump?
check the command line option -d (or --no-data) -Original Message- From: Barry McClure [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 03, 2001 1:45 AM To: [EMAIL PROTECTED] Subject: --How to dump only table structure with MySQLDump? I would like to extract the DDL for the database so I can re-run it elsewhere. MySQLDump can do that, but it also exports the data. Is there a way for it to just export the Create Table statements? TIA Barry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Update Logging ???
On Fri, Sep 21, 2001 at 01:43:32AM -0400, Will French wrote: Actually yes (if I read the documentation correctly - I have not tried this). But if his ISP won't allow it, he can't do it. Maybe I misunderstood. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 27 days, processed 543,190,508 queries (232/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php