Re: Root pass
On Wednesday, 3. July 2002 07:51, Page Works Web Solutions wrote: Hi, Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql UPDATE user SET Password=PASSWORD(testpassword) - WHERE User='root'; ERROR 1046: No Database Selected mysql 1) select the database with use mysql before, or specify mysql.user as table 2) Quote testpassword: ... =password('testpassword') Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
selected records retrieve (fwd)
-- Forwarded message -- Date: Tue, 2 Jul 2002 17:40:24 +0300 (EEST) From: Nixarlidis Aris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: selected records retrieve Hi to all. I'm new in the list and in mysql as well, so excuse me for anything that sounds novice or in wrong place.I'm facing the following situation: For some reason, i had to use a backup of the database.Because of the difference in time between my backup and the instance i had to use it,i want to retrieve from the database, i no longer use, some records BUT NOT ALL the database.Is there a way to do it?Thank you all in advance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: Regarding cast functions
I would like to know regarding the cast and convert functions in MySql4.0.1;. Can nebody explain the usage(casting of strings to number/integer). I was not able to use them properly Regards Harish Varandani - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: blob versus file
Grabbing a half-gig video segment out of any database I'm sure you're absolutely right about not putting half gig videos in a database! I was thinking more of an application like an access control system, where there might be tens of thousands of photographs of people, each a jpeg of a small number of K, or a catalogue, again with thousands of tiny photos. The experiment I did with 500,000 operating system files was to see whether smallish blobs (bits of text, in this case, which I didn't need to search or index) were better stored as disk files or in an SQL Server database. The database won hands down on all counts. Tim Ward Brett Ward Limited - www.brettward.co.uk --- On August 5th ip.access will be moving to: CPC1 Telephone: +44 (0) 1223 219000 Capital Park Fax: +44 (0) 1223 219099 Fulbourn Cambridge CB1 5XE United Kingdom --- This e-mail and the information it contains are confidential and may be privileged. If you have received this e-mail in error please notify us immediately. You should not copy it for any purpose, or disclose its contents to any other person. All emails to and from ip.access may be monitored and stored for audit and other legal reasons. --- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: innodb is disabled, how can i make it yes?
Hytham, - Original Message - From: Hytham Shehab [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 03, 2002 6:21 AM Subject: Re: innodb is disabled, how can i make it yes? hi Heikki, i do what u said: yourpathtomysqlbindir mysqld-max-nt --console cannot initialize innodb as 'innodb_data_file_path' is not set ... i sword in god that i have set this data file path as: innodb_data_file_path=c:/mysql/data/ibdata:300M and this is a valid directory, and some times i get another error message: os error number 123 in a file operation ???!!! have you added the line to the [mysqld] section in my.cnf? my.cnf should look like this: [mysqld] innodb_data_home_dir= innodb_data_file_path=c:/mysql/data/ibdata:300M Also, if you do not specify innodb_data_home_dir, it gets the datadir of MySQL as the default. Then you cannot give the absolute file path to the ibdata file like you have done above. In this case MySQL-Max-3.23.51 and 4.0.2 print: C:\m\client_debugmysqld --console 020703 11:40:04 InnoDB: Operating system error number 123 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help. InnoDB: Look from section 13.2 at http://www.innodb.com/ibman.html InnoDB: what the error number means. InnoDB: File name .\c:\mysql\data\ibdata InnoDB: Cannot continue operation. From http://www.innodb.com/ibman.html#OS_Error_codes we see: 123 The filename, directory name, or volume label syntax is incorrect. ERROR_INVALID_NAME thanks -- Hytham Shehab Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: blob versus file
At 09:42 AM 7/3/02 +0100, Tim Ward wrote: I was thinking more of an application like an access control system, where there might be tens of thousands of photographs of people, each a jpeg of a small number of K, or a catalogue, again with thousands of tiny photos. The experiment I did with 500,000 operating system files was to see whether smallish blobs (bits of text, in this case, which I didn't need to search or index) were better stored as disk files or in an SQL Server database. The database won hands down on all counts. Not meaning to put down MySQL, but have you tried this also with a ReiserFS filesystem? I had a similar number of files, about 70 GByte worth on an ext2 filesystem. Moved them to a ReiserFS filesystem and found I only needed 51 GByte. And got a much faster system... The main gain of MySQL is probably that MySQL packs the data tighter together, which in the end causes fewer hard disk head movents and less data to be transferred. And if you use indexes, your directory searches are binary chops rather than linear searches. ReiserFS does that also, but at a file system level. If you need to port your application to the outside world where you don't have control over your file systems, MySQL would be the way to go for this application. If you _do_ have control over the filesystem being used and you can use ReiserFS and you don't need MySQL specific features, then I wouldn't be so sure. Just my 2 eurocents worth... Liz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MAX vs plain vanilla mysql
Petre, - Original Message - From: Petre Agenbag [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, July 03, 2002 9:01 AM Subject: Re: MAX vs plain vanilla mysql Thanks, So, just to be 100% sure, the BEST to do is to install max, as I can't see any reason why NOT to...? No performance issues when used as a plain vanilla model, no stability and no security issues either, only down side to it is that it is a tad bit larger ? no MyISAM bugs which would have been special to the -Max version have been reported, as far as I know. The security is the same in both versions because the MyISAM source code is the same. PS, Oh, and why do I always get a returned mail when posting to this list, yet my message still seems to reach it? Me too :). Looks like we almost always have some glitch in the mail server of some recipient of the mailing list, or in the mail server itself. I have notified the MySQL web team about this bug. Thanks Petre Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com Paul DuBois wrote: At 19:31 +0200 7/2/02, Petre Agenbag wrote: Thanks, So, if you install MySQL MAX, you can use either myisam OR innodb / bdb tables, ie, if I install ONE mysql max server, then different users on the server can use different types of tables(innodb/myisam) as they choose?, also, if you create one db, can you have different types of tables in one db? Sorry if I'm asking stupid questions, just want to know what is possible and what not, was thinking the other day if it wouldn't be etter if one had different types of tables in one relation db ; myisam types for the normal static data, and innodb or bdb tables for the tables that need to commit/rollback. Yes, yes, yes, and yes. :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: SHOW TABLE STATUS InnoDB Tables
From the manual : Note that the statistics SHOW gives about InnoDB tables are only approximate: they are used in SQL optimization. Table and index reserved sizes in bytes are accurate, though. CB. -Original Message- From: Crercio O. Silva [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 01:51 To: [EMAIL PROTECTED] Subject: BUG: SHOW TABLE STATUS InnoDB Tables Hi, I have just noticed that SHOW TABLE STATUS is returning different number of rows each time you execute the query. This seams to affect only InnoDB Tables (Although I have tested only with ISAM/MyISAM/InnoDB Tables). I'm using MySQL 3.23.49Max on WIN2K. How to repeat the problem: Execute the statement SHOW TABLE STATUS many times. In some times (not all) it will return different number of rows for the same table. Have anyone else experienced this with other versions? PS: SELECT COUNT(*) FROM table is working just fine, but on InnoDB tables with large number of rows (my tables have -+ 30 records each) it take a few seconds to get the results. This is not a big issue for me, but I'd like to confirm that. Thanks, []'s Crercio O. Silva - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: innodb is disabled, how can i make it yes?
Are you sure that you are starting mysqld-max-nt.exe for the server ? If so, try mysqld-max-nt --print-defaults to see what parameters are set, maybe that will give you a clue ... CB. -Original Message- From: Hytham Shehab [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 00:19 To: Paul DuBois Cc: [EMAIL PROTECTED] Subject: Re: innodb is disabled, how can i make it yes? hi Paul: Make sure it's not being started with --skip-innodb. i am sure that the --skip-innodb is not in any of my configuration files. sql -- Hytham Shehab --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.372 / Virus Database: 207 - Release Date: 20/06/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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: blob versus file
Hello. On Wed 2002-07-03 at 09:42:52 +0100, [EMAIL PROTECTED] wrote: [...] I was thinking more of an application like an access control system, where there might be tens of thousands of photographs of people, each a jpeg of a small number of K, or a catalogue, again with thousands of tiny photos. The experiment I did with 500,000 operating system files was to see whether smallish blobs (bits of text, in this case, which I didn't need to search or index) were better stored as disk files or in an SQL Server database. The database won hands down on all counts. Well, you did *not* put all 500.000 files in one directory, did you? I had a similar setting for some years (about 12GB of data in about 1.2 Mio. files at the end) stored in a directory hierachy and had no particular performance problems (at least once I started to avoid having more than 5.000 files in one dir ;-). About 50-100 random accesses/sec sustained at high time (including all the rest: web server, database server, etc...). Btw, this was still under Linux 2.0, Alpha 300MHz? SCSI (which is beaten performance-wise by any desktop PC nowadays). I mean not to say, that a SQL database would not have been able to handle this. But a filesystem is an specialized hierachical database, and I have yet to see an (more general) SQL database wins hands down in the preferred domain of the file system - of course, a reasonable implementation presumed (which ext2 IMHO is). Bye, Benjamin. -- [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
Incorrect replication user time
Hi. I recently update my servers from 3.23.29 to 3.23.51 version. Replication alwais works fine. Now, when I send show processlist command to slave, this is the response: +--+-+---+--+-+--+---+--+ | Id | User| Host | db | Command | Time | State | |Info | +--+-+---+--+-+--+---+--+ |1 | system user | none | NULL | Connect | 664 | Reading master update | |NULL | | 4377 | root| localhost | biz | Query | 0| NULL | |show processlist | +--+-+---+--+-+--+---+--+ 2 rows in set (0.00 sec) The system user time used by replication always starts at 664 seconds (0 must be correct). The intervals are correct. Two seconds more without replication updates and Show processlist says: +--+-+---+--+-+--+---+--+ | Id | User| Host | db | Command | Time | State | |Info | +--+-+---+--+-+--+---+--+ |1 | system user | none | NULL | Connect | 664 | Reading master update | |NULL | | 4377 | root| localhost | biz | Query | 0| NULL | |show processlist | +--+-+---+--+-+--+---+--+ 2 rows in set (0.00 sec) Correct! And in new update, Show processlist says: +--+-+---+--+-+--+---+--+ | Id | User| Host | db | Command | Time | State | |Info | +--+-+---+--+-+--+---+--+ |1 | system user | none | NULL | Connect | 664 | Reading master update | |NULL | | 4377 | root| localhost | biz | Query | 0| NULL | |show processlist | +--+-+---+--+-+--+---+--+ 2 rows in set (0.00 sec) Incorrect again. All the servers are updated to 3.23.51 and replication works fine excepts this. Any sugestion?. Sorry for my limited English. Javier. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: blob versus file
Am Mittwoch, 3. Juli 2002 10:58 schrieb Elizabeth Mattijsen: Not meaning to put down MySQL, but have you tried this also with a ReiserFS filesystem? I had a similar number of files, about 70 GByte worth on an ext2 filesystem. Moved them to a ReiserFS filesystem and found I only needed 51 GByte. And got a much faster system... ext2 searches directories linearly. With 500.000 files in a directory where each file is subsequently accessed in a benchmark, you get quadratic access times. reiserfs uses a tree structure for directories, giving you almost linear (O(n log n)) access. It also packs tails of different files into singular blocks, saving much space as well. Question: Can the MySQL BLOB API access and transfer partial blobs. That is, if you want to do the equivalent of a file * to a BLOB table, the first 10 bytes or so of each BLOB must be read in order to guess the type of the BLOB. Is it possible to implement this efficiently using the MySQL API? More specific: Can I efficiently read the bytes x to y from any BLOB stored in a MySQL database? Kristian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysqld crash
Hi, I have 2 machine dual-processor Pentium III, with 1G of memory. They have the same software, same architecture, with one-way replication beetween. Versions: [root@localhost tmp]# mysql -V mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686) [root@localhost tmp]# cat /etc/redhat-release Red Hat Linux release 7.3 (Valhalla) Since i've installed mysql 3.23.51 (mysql binaries) that i'm having some problems, the worst is the slave's mysqld crashes all days. What happens: Every day, a cron job in the slave starts at 3:30AM to generate some reports. The maximum load is about 2.0. Mysqld daemon crashes and restarts itself. All queries in this cron job are done in the master. The slave only replicates... I don't understand why the slave keeps crashing. The master logs are clean, with no error at all, the reports are ok. * The log error at the slave: 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=335540224 record_buffer=2093056 sort_buffer=2097144 max_used_connections=1 max_connections=150 threads_connected=0 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 941474 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... Stack range sanity check OK, backtrace follows: 0x806edf4 0x811fd28 0x81050f3 0x810410f 0x8103df9 0x80b5f04 0x809524c 0x80943b7 0x80940c3 0x808cf67 0x80760ce 0x8079a8c 0x80cfb31 0x80d1249 Stack trace seems successful - bottom reached ... Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd-query at 0x8287e59 = CREATE TEMPORARY TABLE IF NOT EXISTS tmp_uv SELECT campaign_id , user, count(user) as views FROM Log_Impr_all WHERE campaign_id IN (9) GROUP BY campaign_id , user HAVING views0 thd-thread_id=18 ... * Stack resolved: 0x806edf4 handle_segfault__Fi + 428 0x811fd28 pthread_sighandler + 184 0x81050f3 _hp_movelink + 11 0x810410f _hp_write_key + 595 0x8103df9 heap_write + 73 0x80b5f04 write_row__7ha_heapPc + 72 0x809524c end_update__FP4JOINP13st_join_tableb + 440 0x80943b7 sub_select__FP4JOINP13st_join_tableb + 255 0x80940c3 do_select__FP4JOINPt4List1Z4ItemP8st_tableP9Procedure + 415 0x808cf67 mysql_select__FP3THDP13st_table_listRt4List1Z4ItemP4ItemP8st_orderT4T3T4UiP13select_result + 4055 0x80760ce mysql_execute_command__Fv + 2570 0x8079a8c mysql_parse__FP3THDPcUi + 216 0x80cfb31 exec_event__FP3THDP6st_netP14st_master_infoi + 1133 0x80d1249 handle_slave__FPv + 2309 (i don't understand what this means..) Thank you for reading this, i hope someone can give me a light. -- Diana Soares - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Comment-parsing bug in MySQL
Description: Single quotes (') in comments may cause syntax errors. How-To-Repeat: Run this MySQL code from a file, including the comment (running from the MySQL shell will also expose the bug, but you will not be able to complete the command without supplying a second quote): /* MySQL's handling of comments is kind of flaky. */ SELECT * FROM MYTABLE; Fix: Work around the problem by not using the apostrophe character (') in the comments of MySQL code. Originator:Godless Infidel MySQL support: none Synopsis: Single-quotes in comments cause problems. Severity: non-critical Category: mysql Class: sw-bug Release: mysql-3.23.51 (Official MySQL Binary) Environment: System: Linux devnull 2.4.7-10custom #1 Wed May 1 13:07:29 EST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 May 2 17:07 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x2 root root 1285788 Apr 2 11:58 /lib/libc-2.2.4.so -rw-r--r--1 root root 27332668 Apr 2 11:42 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 2 11:42 /usr/lib/libc.so lrwxrwxrwx1 root root 10 May 24 19:56 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc '--with-comment=Official MySQL Binary' --prefix=/usr/local/mysql --with-extra-charset=complex --enable-thread-safe-client --enable-local-infile 'CFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' 'CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX=gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Submitting Form Data
Mark Colvin wrote: I have a php script that executes a query and depending on the results builds a section of a table for each record returned in the query. Each section has some fields and three buttons. My problem is this. When I want to change the data in one particular section, how can I submit the form passing only the data for that particular section? 1. Use a separate form for each field. 2. Use different names in buttons: INPUT TYPE=SUBMIT NAME=field1 VALUE=Submit INPUT TYPE=SUBMIT NAME=field2 VALUE=Submit INPUT TYPE=SUBMIT NAME=field3 VALUE=Submit 3. Use a single form, but fill all it's fields with their previous values SELECTing them from the database before displaying the form. -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Alexander Barkov [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Izhevsk, Russia ___/ www.mysql.com +7-902-856-80-21 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
testing mysql
Hello and good morning all! I'm running into a problem when trying to test mysql on Red Hat Linux. I have the server up and running just fine with no problems, but when I go to run ./mysql-test-run it spits back the following. TEST USER SYSTEM ELAPSEDRESULT alias [ fail ] /home/nstuart/mysql-3.23.49/bin/mysqltest: Failed in mysql_real_connect(): Can't connect to local MySQL server through socket '/home/nstuart/mysql-3.23.49/mysql-test/var/tmp/mysql-master.sock' (2) Command exited with non-zero status 1 real 0.01 user 0.01 sys 0.01 Aborting. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon /home/nstuart/mysql-3.23.49/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/home/nstuart/mysql-3.23.49/mysql-test/var/tmp/mysql-master.sock' (2)' Check that mysqld is running and that the socket: '/home/nstuart/mysql-3.23.49/mysql-test/var/tmp/mysql-master.sock' exists! Master shutdown finished I would like to simply run the test on the server that is running but apparently it doesn't want to do that. I thought I changed the correct settings in the mysql-test-run but apparently not. Also tried the mysql-test-run --local but that do anything different. Also, I dont want to run the slave test either but again the --skip-rpl seems to do nothing. Thanks for all the help! -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
query error
When I issue the following query from phpMyAdmin, SELECT b.* FROM newblocks b LEFT JOIN groups_blocks_link l ON l.block_id=b.bid WHERE (l.groupid=3) AND b.isactive=1 AND b.side=0 AND b.visible=1 ORDER BY b.weight,b.bid I get the following error Can't create/write to file '/var/tmp/#sql3f2_194_0.MYI' (Errcode: 2) but when I change * to bid in the above query like this SELECT b.bid FROM newblocks b LEFT JOIN groups_blocks_link l ON l.block_id=b.bid WHERE (l.groupid=3) AND b.isactive=1 AND b.side=0 AND b.visible=1 ORDER BY b.weight,b.bid I have no problem retrieving data, and no errors as I received with the first query. Has anybody got this problem? thanks in advance K. Ono - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can this be done without UNION?
Hi all, I have a problem whith a very simple query. My problem is: it doesn't use indexes. It does full table scans instead. The only way I found to make it fast was using UNION. Can somebody please tell me, how I can make it fast (using indexes) without using UNION? My query: SELECT * FROM mytable WHERE fielda=1 OR fieldb=2 -The colums fielda and fieldb are offcourse indexed. -The table has about half a million rows. Faster is: SELECT * FROM mytable WHERE fielda=1 UNION SELECT * FROM mytable WHERE fieldb=2 Is there a way to make this fast on mysql 3.x as well? thanks in advance Gunnar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
login question
I was wondering if anyone knows of a way to make a mysql server running on red hat linux authenticate using nt pass through (something like samba does it) or possibly ldap. I am new to mysql so this may be very easy to do I just don't know how. It also might be impossible. Just wondering if anyone had any ideas. Eddie __ This email transmission and any documents, files or previous email messages attached to it may contain information that is confidential or legally privileged. If you are not the intended recipient or a person responsible for delivering this transmission to the intended recipient, you are hereby notified that you must not read this transmission and that any disclosure, copying, printing, distribution or use of this transmission is strictly prohibited. If you have received this transmission in error, please immediately notify the sender by telephone or return email and delete the original transmission and its attachments without reading or saving in any manner. __ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: problems installing 3.23.51 on BSDI 4.0.1
Any clues? Anyone? I'm stumped here guys. On 2 Jul 2002 at 18:00, [EMAIL PROTECTED] wrote: Hi. I am trying to install MySQL on BSDI BSD/OS 4.0.1 Kernel #3. Processor: Cpu-1 = Pentium III (448 MHz) GenuineIntel mdl 7 step 2 type 0, feat 387fbff Ram: 128M I configured using: CC=gcc CXX=gcc CXXFLAGS=-O ./configure --prefix=/usr/local/mysql --with-extra- charsets=complex and ran make. My compiler is GNU gcc. My error is as follows: gcc -DUNDEF_THREADS_HACK -I./../include -I../include -I./.. - I..-I..-O3 -DDBUG_OFF -O -fno-implicit-templates -fno- exceptions -fno-rtti -c mysql.cc cc1plus: Invalid option `-fno-exceptions' In file included from client_priv.h:19, from mysql.cc:28: ../include/global.h:686: warning: abstract declarator used as declaration *** Error code 1 Stop. *** Error code 1 Stop. *** Error code 1 Stop. Exit 1 Any suggestions? -- Jesse Guardiani, Systems Administrator WingNET Internet Services - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Jesse Guardiani, Systems Administrator WingNET Internet Services, P.O. Box 2605 // Cleveland, TN 37320-2605 423-559-LINK (v) 423-559-5145 (f) http://www.wingnet.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Invisible tables?
On Tue, Jul 02, 2002 at 10:55:25PM -0500, Paul DuBois [EMAIL PROTECTED] wrote: At 21:41 -0400 7/2/02, Bob Bell wrote: Pardon my posting as soon as I subscribed to this list, but I have a problem that's really annoying me. I just installed MySQL on a virtual server account that I have, and for some reason, mysql refuses to list my databases or tables, although they seem to be there. I've included a log below, which may be somewhat lengthy, but hopefully should explain what I'm seeing. Does anyone have any ideas what could be happening here? $ mysql -u root '-pMyPassword' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 11 to server version: 3.23.51-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show databases; +--+ | Database | +--+ | | | | | | | | | | | | | | +--+ 7 rows in set (0.00 sec) Are you running Linux? Yes, although I am not the system administator. I think it's an upgraded Red Hat installation. I installed MySQL myself. $ cat /etc/redhat-release Red Hat Linux release 6.0 (Hedwig) $ uname -a Linux server38 2.4.16 #1 SMP Thu Dec 6 14:36:30 EST 2001 i686 unknown -- Bob Bell [EMAIL PROTECTED] - Time flies like an arrow; Fruit flies like a banana. -- Author unknown - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-byte characters
Hello, I have a bunch of text with Japanese in it that uses shift_jis encoding. My initial tests show that this encoding has the same problems in MySQL as it does in Perl: it gives false matches. I have to convert the data to the EUC enconding (I think I've seen it called ejis in a MySQL context), and was wondering if anyone can point me to information on how to do that with MySQL and PHP. Paul Flint Japanese to English Translation Kawasaki Japan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Privileges needed to execute PURGE MASTER LOGS
Hello! The subject says it all: What rights does a user need to have (minimal rights of course) to be able to execute PURGE MASTER LOGS command? Thanks in advance Ralf For the poor little filter: sql query -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PERROR on Windows
Is there a command like perror for the Windows version of MySQL? I can't seem to find anything to list error code descriptions in either MySQL 3 or 4. TIA - Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: starting MySQL automatically
You can use the winmysqladmin tool located in the bin directory to install it as a service. (I'm not sure wether this also works on a '98SE machine) CB -Original Message- From: Gerhard H. W. May [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 15:00 To: [EMAIL PROTECTED] Subject: starting MySQL automatically Hello, I am running MySQL 3.23.51 under Windows 98SE. Everything I need to do so far seems to work but I would like to arrange it so that the server starts up automatically when I switch on the machine. Maybe I am too stupid but I don't understand the section (2.4.3) in the reference manual on 'Starting and stopping MySQL automatically', but then again this section might not be relevant to Windows users anyway? If anyone has suggestions what I should do, I would welcome them. Thanks in advance. Gerhard ~~ Dr. Gerhard H. W. May Institute of Biomedical and Life Sciences Division of Biochemistry and Molecular Biology Davidson Building, Rm 327 University of Glasgow Glasgow G12 8QQ Tel. +44-141-330 2749 Fax+44-141-330 4620 e-mail [EMAIL PROTECTED] http://www.gla.ac.uk/ibls/BMB/gmay/ - 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: PERROR on Windows
Yes there is: perror.exe located in c:\yourmysqldir\bin\ :) -Original Message- From: Christopher A. Libby [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 15:16 To: [EMAIL PROTECTED] Subject: PERROR on Windows Is there a command like perror for the Windows version of MySQL? I can't seem to find anything to list error code descriptions in either MySQL 3 or 4. TIA - Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PERROR on Windows
* Christopher A. Libby Is there a command like perror for the Windows version of MySQL? I can't seem to find anything to list error code descriptions in either MySQL 3 or 4. It should be in the bin diretory: C:\dir \mysql\bin\perror* Volume in drive C has no label. Volume Serial Number is 28E6-EF3E Directory of C:\mysql\bin 03.01.2001 15:35 139 264 perror.exe 1 File(s)139 264 bytes 0 Dir(s) 444 899 328 bytes free -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL design/query question
Well maybe I sould map this out more clearly... members +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | rowid | int(11) | | PRI | NULL| auto_increment | | first_name| varchar(20) | YES | | NULL|| | last_name | varchar(20) | YES | | NULL|| | address1 | varchar(60) | YES | | NULL|| | address2 | varchar(60) | YES | | NULL|| | city | varchar(20) | YES | | NULL|| | state | varchar(20) | YES | | NULL|| | zip | varchar(12) | YES | | NULL|| | region_id | int(10) | YES | | NULL|| | subregion_id | int(11) | YES | | NULL|| +---+-+--+-+-++ regions +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | rowid | bigint(20) | | PRI | NULL| auto_increment | | name | varchar(20) | YES | | NULL|| +---+-+--+-+-++ subregions +---+-+--+-+-++ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-++ | rowid | bigint(20) | | PRI | NULL| auto_increment | | name | varchar(20) | YES | | NULL|| +---+-+--+-+-++ event +--+-+--+-+-++ | Field| Type| Null | Key | Default | Extra | +--+-+--+-+-++ | rowid| int(11) | | PRI | NULL| auto_increment | | event_type | smallint(6) | YES | | NULL|| | event_date | date| YES | | NULL|| | member_id| int(11) | YES | | NULL|| +--+-+--+-+-++ the results of the query should look like this: +--+-+++ --+ | region | subregion | first_name | last_name | Attended | +--+-+++ --+ I am interested in showing a list for a selected date so the date is not part of the output. I am currently using the following query to just show the list without the attendance information. SELECT regions.name as region, subregion.name as subregion, first_name, last_name FROM members, regions, subregion WHERE members.region_id=regions.rowid and members.subregion_id=subregion.rowid GROUP BY region, subregion; +--+-+++ | region | subregion | first_name | last_name | +--+-+++ The query you gave didn't seem to work right. It only gave me one line for every record in the event table. On Tuesday, July 2, 2002, at 08:45 PM, Cal Evans wrote: Right list. What you want is an outer join. Very simple example: person --- personID === name region === attendance --- attendanceID === date personID FK into person eventid FK into event === Select event.date, person.name, (attendance.personID is null) as present from attendance left outer join person on attendance.personID = person.personID order by person.region SHOULD give you a 0 in present if they were not there. (DISCLAIMER: It's late, I've not tested this code, and this is free advice, take it for what it's worth.) :) HTH, =C+ * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Chris Griffin [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 02, 2002 9:08 PM To: [EMAIL PROTECTED] Subject: SQL design/query question If this is not the right list for this please direct me to the proper list. I have a table of name/address information. I need to keep track of a weekly event and if they participated or not. I thought I could have a table of dates and people record ids with just those that participated. The problem is I want to list all people with a check or not if they participated. I would like the list sorted by region (which is part of the people table) and by participation within that. Is this possible to do with the way I have set up the tables? If so what is the query. I can only
Strange problem - could be a bug?
Okay: FreeBSD 4.5-STABLE with LinuxThreads 2.2.3. and MySQL 3.23.51. Duel PIII 1Ghz with 1G of RAM. All from source. Compiled okay and came through super-smack and crash-me tests okay. But a few hours later, for no reason, MySQL decided to look at /var/tmp instead of /usr/local/mysql/var for the datadir. There is nothing in the logs to suggest why this happened. AFAIK, you have to restart mysqld to change the data dir, but the daemon was not restarted at any point. SHOW VARIABLES revealed that the datadir was still set to /usr/local/mysql/var, but SHOW DATABASES listed the contents of /var/tmp (in my case vi.recover). When I shutdown and restarted the system, it reverted to normal behaviour. Anyone have any idea what is going on? --Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Query on large table times out
I'm trying to import a 1 GB mysql database into oracle using a perl/dbd interface written by a 3rd party software company. This is over a network, but I've pinpointed my bottleneck as being the disks attached to the target oracle db server. This process dies with a timeout on the mysql server while moving a table with 246,000 rows. It seems that some rows were added to this table while the migration was happening. The ubiquitous and uninformative error message is: 020702 19:49:25 Aborted connection 25 to db: 'test' user: 'testuser' host: `snafu' (Got an error reading communication packets) I did some poking around newsgroup archives and mysql docs yesterday and as a result tried upping the interactive_timeout parameter. This didn't seem to help. Any suggestions on what else to try? Dave Lowenstein Programmer/Analyst Instructional Technology Services San Diego State University (619)594-0270 http://www-rohan.sdsu.edu/dept/its - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
TCP TIME_WAIT strange problem ( LINUX mysql 3.23.49 )
Hi list, I've got lots of troubles with one of my mysql dedicated server. The problem occurs time to time ( during peac or idle time ). In fact mysql seem not to answer all connections. Netstat show several connections TIME_WAIT and show process_list only show 1 ou 2 queries running ... But on other way, 80% of the time, mysql works and answers well. At those moments netstat show lots of ETABLISHED; All connections are made through TCP/IP on a private LAN ( ip like 192.168.x.xx ). Server don't have access to internet. ifconfig show me that me eth0 config is clear : UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:17728939 errors:0 dropped:0 overruns:0 frame:0 TX packets:10940614 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 lg file transmission:100 RX bytes:1689574777 (1611.3 Mb) TX bytes:347460048 (331.3 Mb) Here is the config : uname -a Linux 2.4.7-10smp #1 SMP Thu Sep 6 17:09:31 EDT 2001 i686 unknown Red Hat 7.2 2 * 1Ghz Intel 1 Go of ram 2 Go of swap Raid 5 scsi hdds Running mysql 3.23.49 from mysql team tar.gz binary. I've got only one MYISAM table like this : 8922 jun 19 07:43 Forums.frm 980150372 jui 3 17:24 Forums.MYD 85792768 jui 3 17:24 Forums.MYI mysql show table status; | Name | Type| Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | +--+++-++-+- +--+---+ | Forums | MyISAM | Dynamic | 3881810 |252 | 980155640 | 4294967295 | 85792768 | 0 | | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | +--+++-++-+- +--+---+ | Forums | MyISAM | Dynamic | 3881810 | 252 | 980155640 | 4294967295 | 85792768 | 0 | my.cnf : [mysqld] port= 3306 #socket = /tmp/mysql.sock skip-locking skip-name-resolve set-variable= key_buffer=128M set-variable= back_log=150 set-variable= record_buffer=1M set-variable= sort_buffer=2M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K set-variable= thread_cache_size=8 set-variable= max_connections=700 set-variable= max_connect_errors=100 set-variable= table_cache=256 set-variable= net_read_timeout=180 set-variable= net_write_timeout=180 set-variable= wait_timeout=3600 I don't where to search. Is that an hardware problem ? Why not but the server isn't old ( only 3 mounths ). Linux ? Have a second mysq server with same hardware, same linux and same mysql and this one don't have any problem. Best rgds 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: Mysqld crash
Diana, Wednesday, July 03, 2002, 2:24:51 PM, you wrote: DS I have 2 machine dual-processor Pentium III, with 1G of memory. DS They have the same software, same architecture, with one-way replication DS beetween. Versions: DS [root@localhost tmp]# mysql -V DS mysql Ver 11.18 Distrib 3.23.51, for pc-linux-gnu (i686) DS [root@localhost tmp]# cat /etc/redhat-release DS Red Hat Linux release 7.3 (Valhalla) DS Since i've installed mysql 3.23.51 (mysql binaries) that i'm having some DS problems, the worst is the slave's mysqld crashes all days. What DS happens: [skip] Diana, can you upload dump of your tables(gzipped) to ftp://support.mysql.com/pub/mysql/secret/ and also send us commands? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Privileges needed to execute PURGE MASTER LOGS
Ralf, Wednesday, July 03, 2002, 4:48:11 PM, you wrote: RN The subject says it all: What rights does a user need to have (minimal RN rights of course) to be able to execute PURGE MASTER LOGS command? Since version 4.0.2 user must have SUPER privilege. before 4.0.2 you must have PROCESS privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PERROR on Windows
Christopher, Wednesday, July 03, 2002, 5:15:44 PM, you wrote: CAL Is there a command like perror for the Windows version of MySQL? I can't CAL seem to find anything to list error code descriptions in either MySQL 3 or CAL 4. Take a look at perror.exe program in /bin directory. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
verification upon update, help, please
Does MySQL prevent updates from occurring when the values involved are the same as the database's current state. For instance, if I've got a table create table updater( id int not null primary key auto_increment, is_active int not null default 1 }; insert into updater(is_active) values (1); insert into updater(is_active) values (1); update updater set is_active = 1; Would MySQL essentially disregard this update statement b/c the values contained within the table are already 1? Now, I realize that the values wouldn't be altered, but does the dB do pre-checking and see which (if any) rows would be affected by the query, and only run the update against rows that would be changed? There seems to be some reporting that is displayed which indicates that MySQL DOES indeed to pre-checking mysql select * from updater; ++---+ | id | is_active | ++---+ | 1 | 1 | | 2 | 1 | ++---+ 2 rows in set (0.00 sec) mysql update updater set is_active = 1; Query OK, 0 rows affected (0.00 sec) Rows matched: 2 Changed: 0 Warnings: 0 mysql any thoughts? thanks, Paul _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: verification upon update, help, please
At 12:07 -0400 7/3/02, Paul Tomsic wrote: Does MySQL prevent updates from occurring when the values involved are the same as the database's current state. I don't know if prevent is the word exactly. It doesn't bother to update the row unless you actually change a value. The phenonenon you're observing is that the row-count value means rows actually changed from their current values rather than rows select to be updated. For instance, if I've got a table create table updater( id int not null primary key auto_increment, is_active int not null default 1 }; insert into updater(is_active) values (1); insert into updater(is_active) values (1); update updater set is_active = 1; Would MySQL essentially disregard this update statement b/c the values contained within the table are already 1? Now, I realize that the values wouldn't be altered, but does the dB do pre-checking and see which (if any) rows would be affected by the query, and only run the update against rows that would be changed? There seems to be some reporting that is displayed which indicates that MySQL DOES indeed to pre-checking mysql select * from updater; ++---+ | id | is_active | ++---+ | 1 | 1 | | 2 | 1 | ++---+ 2 rows in set (0.00 sec) mysql update updater set is_active = 1; Query OK, 0 rows affected (0.00 sec) Rows matched: 2 Changed: 0 Warnings: 0 mysql any thoughts? thanks, Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ADO or MySQL error ?
Hi, I have installed mySql 3.23 max for NT and i'm getting the following error, but I am not sure if it is ADO or MySQL at fault ! I need to list the tables,columns and indices of the DB and the last index access statement is failing. I'm accessing MySql via a DSN connection from within VB6. I get access the table list and the table properties but not the index info. Code attached - Command3_click fails and although it looks like an ADO error the two other commands work ? * Also I have a question regarding Discussion groups/newsgroups of MySQL users. I have written an end-user reporting tool that accesses mainframe/Unix/Vax based DBs via middle-ware and until NOW (using MySQL) uses either SQL-Server,Oracle, Sybase as the local repository to hold application info etc, as the master data would be held in Adabas/DB2/VSAM on the legacy platform. If I had access to such a group I could get info to see if any one would be interested in such a product ? Even yourselves as a marketing piece on how such an application uses MySQL as the local repository and allows users more freedom than with the Microsoft/Oracle route whilst keeping their legacy DBs as the master source. Interested ? Thanks Martin = Attached Code: Option Explicit Dim myconn As New ADODB.Connection Dim LocalRs As New Recordset Dim mycomm As New ADODB.Command Dim gSQLSyntax As String Dim PtyDDM As String Dim iIx As Integer Dim sTable As String Private Sub Command1_Click() myconn.Open DSN=DataObjects-DSN gSQLSyntax = SHOW TABLES Set LocalRs.ActiveConnection = myconn LocalRs.CursorLocation = adUseClient LocalRs.Open gSQLSyntax, myconn, adOpenForwardOnly, adLockReadOnly If LocalRs.RecordCount 0 Then sTable = tables_in_ dataobjects Do While Not LocalRs.EOF Debug.Print LocalRs.Fields(sTable).Value LocalRs.MoveNext Loop End If LocalRs.Close myconn.Close End Sub Private Sub Command2_Click() myconn.Open DSN=DataObjects-DSN PtyDDM = DDMAudit gSQLSyntax = DESCRIBE PtyDDM Set LocalRs.ActiveConnection = myconn LocalRs.CursorLocation = adUseClient LocalRs.Open gSQLSyntax, myconn, adOpenForwardOnly, adLockReadOnly If LocalRs.RecordCount 0 Then Do While Not LocalRs.EOF Debug.Print LocalRs.Fields(field).Value , _ LocalRs.Fields(type).Value LocalRs.MoveNext Loop End If LocalRs.Close myconn.Close End Sub The following fails on the rs open statement with : [Microsoft][ODBC Driver Manager] Driver does not support this parameter myconn has the value Provider=MSDASQL.1;Extended Properties=DSN=DataObjects-DSN;DATABASE=DataObjects;SERVER=PC03;UID=root;PWD=Haragei;PORT=3306;OPTION=0;STMT=; Private Sub Command3_Click() myconn.Open DSN=DataObjects-DSN PtyDDM = DDMProjDetails gSQLSyntax = SHOW INDEX FROM PtyDDM Set LocalRs.ActiveConnection = myconn LocalRs.CursorLocation = adUseClient LocalRs.Open gSQLSyntax, myconn, adOpenForwardOnly, adLockReadOnly If LocalRs.RecordCount 0 Then Do While Not LocalRs.EOF Debug.Print LocalRs.Fields(column_name).Value LocalRs.MoveNext Loop End If LocalRs.Close myconn.Close End Sub _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.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: verification upon update, help, please
What happens if you put third TIMESTAMP column.?. Will that be updated?. Just curios. Nilesh -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 12:42 PM To: Paul Tomsic; [EMAIL PROTECTED] Subject: Re: verification upon update, help, please At 12:07 -0400 7/3/02, Paul Tomsic wrote: Does MySQL prevent updates from occurring when the values involved are the same as the database's current state. I don't know if prevent is the word exactly. It doesn't bother to update the row unless you actually change a value. The phenonenon you're observing is that the row-count value means rows actually changed from their current values rather than rows select to be updated. For instance, if I've got a table create table updater( id int not null primary key auto_increment, is_active int not null default 1 }; insert into updater(is_active) values (1); insert into updater(is_active) values (1); update updater set is_active = 1; Would MySQL essentially disregard this update statement b/c the values contained within the table are already 1? Now, I realize that the values wouldn't be altered, but does the dB do pre-checking and see which (if any) rows would be affected by the query, and only run the update against rows that would be changed? There seems to be some reporting that is displayed which indicates that MySQL DOES indeed to pre-checking mysql select * from updater; ++---+ | id | is_active | ++---+ | 1 | 1 | | 2 | 1 | ++---+ 2 rows in set (0.00 sec) mysql update updater set is_active = 1; Query OK, 0 rows affected (0.00 sec) Rows matched: 2 Changed: 0 Warnings: 0 mysql any thoughts? thanks, Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Creating a list from group-by values
This is not specific to MySQL (probably) but I thought this wizened community might have a definitive answer. Take this simple grouped select: SELECT Value1,Value2 FROM Table1 GROUP BY Value1,Value2 Value1 Value2 --- Joe Red Joe Blue Joe Green Jim Red Jim Green Jack Blue My end goal is really this: Value1Value2s -- Joe Red,Blue,Green Joe Red,Green Jack Blue The normal way to do this is iterate through the table using the app's code. Is this possible to do in MySQL? Using MS SQL Server or Oracle, where you can create user defined functions, I can create a function to return the list given the group-by value - but it is atrociously slow, far less efficient than doing it on the client code. Is there no native SQL way to return a list of values from within a group-by value? Seems a nice function like LIST(Value, Separator) would complement MAX(), MIN(), and so on nicely... but it seems not to exist. -- Jamie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1030: Got error 22 from table handler
Description: when running a insert data infile command on a 500MB text file, I get the error ERROR 1030: Got error 22 from table handler from mysql. I did a listing of the database files and it looks like this: -rw-rw 1 root root 2147397632 Jul 3 09:46 finddata.MYD -rw-rw 1 root root 266409984 Jul 3 10:01 finddata.MYI -rw-rw 1 root root8866 Jul 3 08:45 finddata.frm I thought that Solaris 2.6 didn't have a problem with files over 2GB. How-To-Repeat: Generate a large database, up to the 2GB limit. It should blow up on you. Fix: unknown Submitter-Id: submitter ID Originator:Grant Miller Organization: Apple Computer -Grant Miller[EMAIL PROTECTED] Unix Systems Admin, Engineering Computer Services MySQL support: none Synopsis: ERROR 1030: Got error 22 from table handler Severity: non-critical Priority: medium Category: mysql Class: support Release: mysql-3.23.39 (Source distribution) Server: /local/solaris_2.6/mysql3.23.39/bin/mysqladmin Ver 8.21 Distrib 3.23.39, for sun-solaris2.6 on sparc 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.39 Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 226 days 17 hours 4 min 48 sec Threads: 1 Questions: 856482843 Slow queries: 69635 Opens: 6790604 Flush tables: 2 Open tables: 61 Queries per second avg: 43.725 Environment: System: SunOS www-ecs 5.6 Generic_105181-21 sun4u sparc SUNW,Ultra-2 Architecture: sun4 Some paths: /usr/bin/perl /local/bin/make /local/bin/gmake /local/bin/gcc /usr/ucb/cc GCC: Reading specs from /local/solaris_2.6/gcc2.95.2-so/lib/gcc-lib/sparc-sun-solaris2.6/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='cc' CFLAGS=' -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64' CXX='CC' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1608144 Jul 13 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Sep 10 2001 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014272 Jul 13 2000 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1608144 Jul 13 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Sep 10 2001 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1014272 Jul 13 2000 /usr/lib/libc.so.1 Configure command: configure --with-gemini --disable-shared --enable-assembler --enable-largefile --prefix=/usr/local/nusphere/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: TCP TIME_WAIT strange problem ( LINUX mysql 3.23.49 )
Hi, What is written in err.log (/var/lib/mysql) ? I think you have some problems with network (switch or hub). Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: David BORDAS [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 03, 2002 7:03 PM Subject: TCP TIME_WAIT strange problem ( LINUX mysql 3.23.49 ) Hi list, I've got lots of troubles with one of my mysql dedicated server. The problem occurs time to time ( during peac or idle time ). In fact mysql seem not to answer all connections. Netstat show several connections TIME_WAIT and show process_list only show 1 ou 2 queries running ... But on other way, 80% of the time, mysql works and answers well. At those moments netstat show lots of ETABLISHED; All connections are made through TCP/IP on a private LAN ( ip like 192.168.x.xx ). Server don't have access to internet. ifconfig show me that me eth0 config is clear : UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:17728939 errors:0 dropped:0 overruns:0 frame:0 TX packets:10940614 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 lg file transmission:100 RX bytes:1689574777 (1611.3 Mb) TX bytes:347460048 (331.3 Mb) Here is the config : uname -a Linux 2.4.7-10smp #1 SMP Thu Sep 6 17:09:31 EDT 2001 i686 unknown Red Hat 7.2 2 * 1Ghz Intel 1 Go of ram 2 Go of swap Raid 5 scsi hdds Running mysql 3.23.49 from mysql team tar.gz binary. I've got only one MYISAM table like this : 8922 jun 19 07:43 Forums.frm 980150372 jui 3 17:24 Forums.MYD 85792768 jui 3 17:24 Forums.MYI mysql show table status; | Name | Type| Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | +--+++-++-+- +--+---+ | Forums | MyISAM | Dynamic | 3881810 |252 | 980155640 | 4294967295 | 85792768 | 0 | | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | +--+++-++-+- +--+---+ | Forums | MyISAM | Dynamic | 3881810 | 252 | 980155640 | 4294967295 | 85792768 | 0 | my.cnf : [mysqld] port= 3306 #socket = /tmp/mysql.sock skip-locking skip-name-resolve set-variable= key_buffer=128M set-variable= back_log=150 set-variable= record_buffer=1M set-variable= sort_buffer=2M set-variable= max_allowed_packet=1M set-variable= thread_stack=128K set-variable= thread_cache_size=8 set-variable= max_connections=700 set-variable= max_connect_errors=100 set-variable= table_cache=256 set-variable= net_read_timeout=180 set-variable= net_write_timeout=180 set-variable= wait_timeout=3600 I don't where to search. Is that an hardware problem ? Why not but the server isn't old ( only 3 mounths ). Linux ? Have a second mysq server with same hardware, same linux and same mysql and this one don't have any problem. Best rgds 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
Error on rename
Hi, Newbie here...please be kind! Sometimes when I try to execute some SQL statment MySQL throws an Error 7...(see below) For example: ALTER TABLE `categorias` RENAME `catAnimais`; And here's the error Error: 7 - Error on rename of '.\orniex\categorias.MYI' to '.\orniex\#sql2-ffc-4.MYI' (Errcode: 13) It also happens when I try to delete a Table (not always) I'm using MySQL Front to do this, but I tried from the console after stopping and starting the server and the error still occurs, so I guess it has nothing to do with MySQL Front. why does this Happen? Computer Info: OS: Win XP pro MySQL: 4.0.1 Alpha-Max Thank you in advance Aníbal Anibal Cascais Santos www.engrenagem.net 22 731 93 74 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 full text bug/problem ?
Hi . One table with three filed full-text indexed : titlu,continut,descriere qry : SELECT autori.nume as autor, ref_data.id as id_ref, ref_data.marime as marime, ref_data.clasa as clasa_ref, ref_data.titlu, ref_data.nota as nota ,materii.*,MATCH (titlu,continut,descriere) AGAINST ('conceptia') as muian FROM materii,ref_data,referat_categ,autori WHERE referat_categ.categ_id=materii.id AND ref_data.id=referat_categ.ref_id AND ref_data.autor_id=autori.id order by muian desc LIMIT 0, 30 The results are very disapointing : Conceptia politica a lui Nae I gives relevance 7.10530698297792 Conceptia si conceptia are loc atunci cand doua celule fuzioneaza 1 gives relevance 1.83638876238596 imho the second result should give higher relevance on keyrowd 'conceptia' . using mysql Ver 11.16 Distrib 3.23.49, for redhat-linux-gnu (i386) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AUTO_INCREMENT with Replication
From the manual 4.10.4 Replication will be done correctly with AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values. I am somewhat fearful and curious about how this works. Say we have a master web database that gets replicated back to the office slave over the Internet. A person on the web puts in an order to the master web db, another person in the office enters a phone order, but that order goes into the slave because orders get shipped based on information in the office slave. How would I not at some point end up with replication errors because of duplicate auto_inc values? Would setting up replication as a circle help? Or would timing issues still cause a problem? (The insert on the Master beats the insert on the slave that was getting sent at the time) I am using 4.0.2 alpha so I am most concerned with how that version is affected. Thanks, Eric sql,querysql,querysql,querysql,querysql,querysql,querysql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Transparent Encryption [was: encrypt myisam?]
Hi users and developers! I deleted the in-reply-to header as everybody misunderstood my first mail. Please give this a thought folks, especially developers, I can help developing it if nessecary. I want to do transparent encryption. Like being able to choose an encryption scheme of a table or database when created so that the data on disk is always encrypted. I need this as my application doesn't communicate directly with the database. I do it via an application called tilde (http://tilde.tildesoftware.net), sure I can patch tilde (me and some others wrote it), but its not a good solution as I'm sure others need or at least want the same thing. There must be numerous of applications people use to store sensitive data that communicates with databases but without internal support for encryption. For examples Content Management Systems, Calendars, Business Systems, Web Shops etc.. is there anyone out there who think this idea is any good, I think its rather neccesarry. In the users interface it could be implemented as CREATE:ing the table with some extra flags, choose encryption algorithm, nums of bits etc. And when you're asking querys we'll need a new API to be able to send passphrases too. Or maybe encryption should only be turned on at the database level, not the table level, so you just have to pass an extra parameter on the mysql_real_connect()-api (the best thing is probably to create a new API, called something like mysql_connect_wparams(), taking an info-struct containing things like port, host, username, password, database, ssl-option etc..) or maybe just use the database-password as passphrase for the choosen encryption-scheme.. how strong is the PASSWORD()-funtion? is it just some crypt(3)-variant or good shit? come with some ideas! kind regards Tobias Bengtsson PS. Please CC replies on the internals list to me, as I'm only on the general discussion list --- Missunderstood conversation follow below: On ons, jun 26, 2002 at 09:43:16 -0500, mos wrote: At 05:40 AM 6/26/2002, Tobias Bengtsson wrote: Hi! I want to store my mysqldatabase encrypted on disk, it contains sensitive data. Is there anybody out there doing this already? Or do I have to rewrite the myisam routines? Or is there another way? Regards, Tobbe - Tobbe, MySQL 4.02 has AES_Encrypt and DES_Encrypt which offers good encryption. See http://www.mysql.com/doc/M/i/Miscellaneous_functions.html. -- `Given enough eyeballs, all bugs are shallow.' 69D6 E76A FC83 E9CA 0747 7A21 3CA3 2ABC 7A33 0551 Registered linux user number 75150 http://tobbe.nu/.sig http://tobbe.nu/pgp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: blob versus file
Kristian, Question: Can the MySQL BLOB API access and transfer partial blobs. That is, if you want to do the equivalent of a file * to a BLOB table, the first 10 bytes or so of each BLOB must be read in order to guess the type of the BLOB. Is it possible to implement this efficiently using the MySQL API? More specific: Can I efficiently read the bytes x to y from any BLOB stored in a MySQL database? Why not just add another column, Char(3), that contains the file extension? Then you wouldn't need to read the blob data. Or you can use ENUM and define the possible blob types. By having a second column you can sort and filter on it. Another column could be the blob size (in bytes) so you know how much blob data is being stored. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Root pass
[admin admin]$ mysql mysql or once you have the mysql prompt type: use mysql then issue the command Curtis Page Works Web Solutions said: Hi, any ideas on this one [admin admin]$ mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 3.23.37 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql UPDATE user SET Password=PASSWORD(testpassword) - WHERE User='root'; ERROR 1046: No Database Selected mysql Shawn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Startup Help!
hi im getting the message : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when i try to connect to mysql Then I tried to run daemon [root /root]# /usr/sbin/mysqld Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020702 13:25:41 Aborting 020702 13:25:41 /usr/sbin/mysqld: Shutdown Complete [root /root]# /usr/sbin/mysqld start /usr/sbin/mysqld: Too many parameters /usr/sbin/mysqld Ver 3.23.51 for pc-linux-gnu on i686 Use '--help' or '--no-defaults --help' for a list of available options can someone please help me out. I have just installed mysql 3.23.51 on my RaQ System. Thanks rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB or BdB
Heey There Folks, Well, I hope that this message gets through finallly. First I got it back from the deamon because I had send it in html format, then because of I was suspected from spamming this list. Only for not having used the words query or sql once ... well, I have now so it should come through ;) hihi I just discovered the power of transactions in databases and was wondering, which table type is better; BdB or InnoDB ? and if one is better than the other, why is it? Does BdB also support referential ingegrity as InnoDB does? Also, I was wondering what SIGNED or UNSIGNED integer are .. really don't have a clue about it :D That were some questions I was wondering about .. Greetz, Wouter -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 startup help!
hi im getting the message : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when i try to connect to mysql Then I tried to run daemon [root /root]# /usr/sbin/mysqld Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020702 13:25:41 Aborting 020702 13:25:41 /usr/sbin/mysqld: Shutdown Complete [root /root]# /usr/sbin/mysqld start /usr/sbin/mysqld: Too many parameters /usr/sbin/mysqld Ver 3.23.51 for pc-linux-gnu on i686 Use '--help' or '--no-defaults --help' for a list of available options can someone please help me out. I have just installed mysql 3.23.51 on my RaQ System. Thanks rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Startup Help!
How did you install MySQL? Package, source, binary? *** REPLY SEPARATOR *** On 7/3/2002 at 3:06 PM Rahadul Kabir wrote: hi im getting the message : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when i try to connect to mysql Then I tried to run daemon [root /root]# /usr/sbin/mysqld Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020702 13:25:41 Aborting 020702 13:25:41 /usr/sbin/mysqld: Shutdown Complete [root /root]# /usr/sbin/mysqld start /usr/sbin/mysqld: Too many parameters /usr/sbin/mysqld Ver 3.23.51 for pc-linux-gnu on i686 Use '--help' or '--no-defaults --help' for a list of available options can someone please help me out. I have just installed mysql 3.23.51 on my RaQ System. Thanks rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
problem with mysqlhotcopy
Hi mysql wizards, I've a problem with mysqlhotcopy, i.e. the 'copy step' fails. I've no idea why (for I don't understand perl), could anyone help? Here is how mysqlhotcopy is invoked (intentionaly using option '-n' here): mysqlhotcopy webimages /swpr_ss02-2/frisbee/dbbackups --allowold --keepold -u frisbeebackup -p DOIT -n rmtree /swpr_ss02-2/frisbee/dbbackups/webimages_old rename /swpr_ss02-2/frisbee/dbbackups/webimages, /swpr_ss02-2/frisbee/dbbackups/webimages_old mkdir /swpr_ss02-2/frisbee/dbbackups/webimages/, 0750 LOCK TABLES webimages.CONFIGURATION READ, webimages.CONTEXTS READ, webimages.HOSTS READ, webimages.HTMLPAGES READ, webimages.HTMLPAGES_OLD READ, webimages.IMAGES READ, webimages.IMAGES_OLD READ, webimages.IMAGE_DATA READ, webimages.JOBENTRY_CONTEXTANALYSIS READ, webimages.JOBENTRY_DLCONTEXT READ, webimages.JOBENTRY_DLIMAGE READ, webimages.JOBENTRY_IMAGE_FEATURES READ, webimages.JOBENTRY_IMAGE_INFO READ, webimages.JOBLIST_CONTEXTANALYSIS READ, webimages.JOBLIST_DLCONTEXT READ, webimages.JOBLIST_DLIMAGE READ, webimages.JOBLIST_IMAGE_FEATURES READ, webimages.JOBLIST_IMAGE_INFO READ, webimages.KEYWORDS READ, webimages.KEYWORDS_OLD READ, webimages.MN_IMAGES_KEYWORDS READ FLUSH TABLES /*!32323 webimages.CONFIGURATION, webimages.CONTEXTS, webimages.HOSTS, webimages.HTMLPAGES, webimages.HTMLPAGES_OLD, webimages.IMAGES, webimages.IMAGES_OLD, webimages.IMAGE_DATA, webimages.JOBENTRY_CONTEXTANALYSIS, webimages.JOBENTRY_DLCONTEXT, webimages.JOBENTRY_DLIMAGE, webimages.JOBENTRY_IMAGE_FEATURES, webimages.JOBENTRY_IMAGE_INFO, webimages.JOBLIST_CONTEXTANALYSIS, webimages.JOBLIST_DLCONTEXT, webimages.JOBLIST_DLIMAGE, webimages.JOBLIST_IMAGE_FEATURES, webimages.JOBLIST_IMAGE_INFO, webimages.KEYWORDS, webimages.KEYWORDS_OLD, webimages.MN_IMAGES_KEYWORDS */ Copying 63 files... cp -p /swpr_ss02-2/frisbee/dbbackups/webimages Copying indices for 0 files... UNLOCK TABLES As you can see, the cp command is missing the source parameter... This is mysqlhotcopy version 1.14 running on a debian linux. Regards, Ralf -- - Ralf Jüngling Institut für Informatik - Lehrstuhl f. Mustererkennung Bildverarbeitung Georges-Köhler-Allee Gebäude 52 Tel: +49-(0)761-203-8215 79110 Freiburg Fax: +49-(0)761-203-8262 - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: TCP TIME_WAIT strange problem ( LINUX mysql 3.23.49 )
Hi, What is written in err.log (/var/lib/mysql) ? nothing :( something like mysql started and ready for connection I think you have some problems with network (switch or hub). Euh network hardware i don't think, perhaps a problem with software but may be strange 'cause ifconfig says that all is ok : ifconfig show me that me eth0 config is clear : UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:17728939 errors:0 dropped:0 overruns:0 frame:0 TX packets:10940614 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 lg file transmission:100 RX bytes:1689574777 (1611.3 Mb) TX bytes:347460048 (331.3 Mb) Here's the show status : +--++ | Variable_name| Value | +--++ | Aborted_clients | 3467 | | Aborted_connects | 24 | | Bytes_received | 128250456 | | Bytes_sent | 2317251152 | | Com_admin_commands | 0 | | Com_alter_table | 0 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin| 0 | | Com_change_db| 1 | | Com_change_master| 0 | | Com_check| 0 | | Com_commit | 0 | | Com_create_db| 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_table | 0 | | Com_delete | 1107 | | Com_drop_db | 0 | | Com_drop_function| 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_flush| 0 | | Com_grant| 0 | | Com_insert | 28257 | | Com_insert_select| 0 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_table| 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_purge| 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace | 0 | | Com_replace_select | 0 | | Com_reset| 0 | | Com_restore_table| 0 | | Com_revoke | 0 | | Com_rollback | 0 | | Com_select | 614872 | | Com_set_option | 1 | | Com_show_binlogs | 0 | | Com_show_create | 1 | | Com_show_databases | 0 | | Com_show_fields | 1 | | Com_show_grants | 0 | | Com_show_keys| 1 | | Com_show_logs| 0 | | Com_show_master_stat | 0 | | Com_show_open_tables | 0 | | Com_show_processlist | 11 | | Com_show_slave_stat | 0 | | Com_show_status | 6 | | Com_show_tables | 2 | | Com_show_variables | 1 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_truncate | 0 | | Com_unlock_tables| 0 | | Com_update | 25456 | | Connections | 425680 | | Created_tmp_disk_tables | 0 | | Created_tmp_tables | 1 | | Created_tmp_files| 32 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 2551 | | Handler_read_first | 1 | | Handler_read_key | 621052 | | Handler_read_next| 2015869637 | | Handler_read_prev| 0 | | Handler_read_rnd | 993404 | | Handler_read_rnd_next| 24207000 | | Handler_update | 25408 | | Handler_write| 28606 | | Key_blocks_used | 48213 | | Key_read_requests| 85661529 | | Key_reads| 47254 | | Key_write_requests | 145118 | | Key_writes | 107980 | | Max_used_connections | 180| | Not_flushed_key_blocks | 37 | | Not_flushed_delayed_rows | 0 | | Open_tables | 186| | Open_files | 190| | Open_streams | 0 | | Opened_tables| 192| | Questions| 1091817| | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 34 | | Select_range_check | 0 | | Select_scan | 20273 | | Slave_running| OFF| | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 1052 | |
mysql error!!!
[root /root]# mysqladmin -u root password '30waverly' mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql .sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' ex ists! [root /root]# I can't connect to mysql. does anyone know whats te problem. 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
MYSQ current value!!!
This are the few variables for mysql. Does anyone know how can I set the current value to some other value. because whats happing now is when I try to startup mysql, it starts and right after a second it ends. and I think Its because of this current value: 0. can someone please tel me in which file should I look into to chnage this value or any other solutions . thanks so much Possible variables for option --set-variable ( connect_timeout current value: 0 shutdown_timeout current value: 3600 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 startup help!
depending on your distro. You should have a dir named /etc/rc.d/init.d or /etc/init.d in it should be a script named mysql for starting and stopping mysql. Use it (as root) to start mysql. /etc/init.d/mysql start or /etc/rc.d/init.d/mysql start HTH, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Rahadul Kabir [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 2:13 PM To: MySql Mailing List Subject: MYSQL startup help! hi im getting the message : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) when i try to connect to mysql Then I tried to run daemon [root /root]# /usr/sbin/mysqld Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 020702 13:25:41 Aborting 020702 13:25:41 /usr/sbin/mysqld: Shutdown Complete [root /root]# /usr/sbin/mysqld start /usr/sbin/mysqld: Too many parameters /usr/sbin/mysqld Ver 3.23.51 for pc-linux-gnu on i686 Use '--help' or '--no-defaults --help' for a list of available options can someone please help me out. I have just installed mysql 3.23.51 on my RaQ System. Thanks rahad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: InnoDB or BdB
Salutations. 1: I personally use InnoDB. I think Bdb tables were the first with transactions but I don't see a lot of people talking about using them these days. Also, InnoDB is being activly developed and between sleeping, eating and coding, Heikki answers questions here! :) 2: Signed integers can have a + or an - in front of them. (The + is implied, you don't actually see it) Because that takes up a bit, it means that signed integers represent smaller numbers than unsigned. Unsigned integers can represent larger numbers. (Ok, I'm over simplifying here but work with me) There is a limit on both types as to how big of a number they can store...check the docs. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Wouter van Vliet [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 2:06 PM To: MySQL Mailinglist Subject: InnoDB or BdB Heey There Folks, Well, I hope that this message gets through finallly. First I got it back from the deamon because I had send it in html format, then because of I was suspected from spamming this list. Only for not having used the words query or sql once ... well, I have now so it should come through ;) hihi I just discovered the power of transactions in databases and was wondering, which table type is better; BdB or InnoDB ? and if one is better than the other, why is it? Does BdB also support referential ingegrity as InnoDB does? Also, I was wondering what SIGNED or UNSIGNED integer are .. really don't have a clue about it :D That were some questions I was wondering about .. Greetz, Wouter -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 error!!!
start the server before connecting to it. *** REPLY SEPARATOR *** On 7/3/2002 at 3:24 PM Rahadul Kabir wrote: [root /root]# mysqladmin -u root password '30waverly' mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql .sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' ex ists! [root /root]# I can't connect to mysql. does anyone know whats te problem. thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql error!!!
looks like mysql is not running. type ps ax and see if you see any mysqld lines. =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: Rahadul Kabir [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 2:24 PM To: MySql Mailing List Subject: mysql error!!! [root /root]# mysqladmin -u root password '30waverly' mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql .sock' (111)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' ex ists! [root /root]# I can't connect to mysql. does anyone know whats te problem. thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication errors
I have replication running successfully between two Linux boxes running 3.23.51. However, I'm getting the following error very frequently (every 30 - 60 seconds) in my slave error log: - 020703 15:41:09 Error reading packet from server: (server_errno=1159) 020703 15:42:09 Slave: Failed reading log event, reconnecting to retry, log 'db1-bin.009' position 25448 020703 15:42:09 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'db1-bin.009' at position 25448 020703 15:42:39 Error reading packet from server: (server_errno=1159) 020703 15:43:39 Slave: Failed reading log event, reconnecting to retry, log 'db1-bin.009' position 25448 020703 15:43:39 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'db1-bin.009' at position 25448 - Is this just a normal timeout error, because there's currently very little activity on these machines? Or is there some other problem? The slave_net_timeout value is at it's default of 3600, so I would expect to see this type of error every hour -- but maybe I misunderstand that variable. If this is just a normal timeout, is there any way to up the value or prevent these errors from being logged? Thanks, --jeff sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
unexpected results using LEFT JOIN with more than one join_condition
From: Harald Kleiner [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: unexpected results using LEFT JOIN with more than one join_condition Description: I use LEFT JOIN to join together two tables. And (for some 'complex' reason) I want to add additional conditions into the join_condition-part (and not in the WHERE part where it would belong to). But these additional conditions seem to be ignored just as if they weren't there. If I cut the 'ON'-part and move conditions to the 'WHERE' all goes the way it should. Changing the join method from LEFT JOIN to INNER JOIN does fix the problem - yes but alas I need a LEFT JOIN in this case. The manual says The ON conditional is any conditional of the form that may be used in a WHERE clause. So it _should_ be allowed to do the things that I do... Maybe this is all my fault - so please be patient. But in any case: Thank you very much for spending time with my problem! How-To-Repeat: I have constructed a simplified example that shows the unexpected behavior. A table called person is linked with room-table. Both have a date-typed field that holds deletion-date of the record. Now I want to get all persons with their room codes which are _not_ deleted (i.e. deleted==0). As you can see the first query uses LEFT JOIN ... ON ... and returns all four persons. (Joe gets returned even though he has a non-zero deletion-date -- that's what I don't understand) And in the second query I just replaced the first 'AND' with a 'WHERE' and voila Joe falls out (because of his non-zero deletion-date) and Fred falls out because of his null room (room.deleted gets null I think) -- that's what I expected to get. DROP DATABASE JOINTest; CREATE DATABASE JOINTest; USE JOINTest; CREATE TABLE person ( personID INT AUTO_INCREMENT NOT NULL, roomID INT, name VARCHAR(20), deleted DATE, PRIMARY KEY(personID) ); CREATE TABLE room ( roomID INT AUTO_INCREMENT NOT NULL, roomcode VARCHAR(20), deleted DATE, PRIMARY KEY(roomID) ); INSERT INTO person VALUES(NULL, 0, 'Fred', 0); INSERT INTO person VALUES(NULL, 1, 'Max', 0); INSERT INTO person VALUES(NULL, 1, 'Joe', '2002-07-01'); INSERT INTO person VALUES(NULL, 1, 'Anne', 0); INSERT INTO room VALUES(NULL, 'R001', 0); SELECT DISTINCTROW person.name, person.deleted, room.roomcode FROM person LEFT JOIN room ON person.roomID=room.roomID AND person.deleted=0 AND room.deleted=0; +--++--+ | name | deleted| roomcode | +--++--+ | Fred | -00-00 | NULL | | Max | -00-00 | R001 | | Joe | 2002-07-01 | NULL | | Anne | -00-00 | R001 | +--++--+ 4 rows in set (0.00 sec) SELECT DISTINCTROW person.name, person.deleted, room.roomcode FROM person LEFT JOIN room ON person.roomID=room.roomID WHERE person.deleted=0 AND room.deleted=0; +--++--+ | name | deleted| roomcode | +--++--+ | Max | -00-00 | R001 | | Anne | -00-00 | R001 | +--++--+ 2 rows in set (0.00 sec) Fix: Yes, I could move additional criteria into the WHERE but that would be not as beautiful and easy for me as putting it into the ON - part. And even in the manual (chapter 9.8.1, The Twin Project) such a join is used. So it _should_ work. Submitter-Id: Originator:Harald Kleiner Organization: MySQL support: none Synopsis: unexpected LEFT JOIN behavior Severity: non-critical Priority: low Category: mysql Class: sw-bug | support Release: mysql-3.23.33 (Source distribution) Server: /usr/bin/mysqladmin Ver 8.15 Distrib 3.23.33, for suse-linux 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.33-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 54 min 52 sec Threads: 3 Questions: 618 Slow queries: 0 Opens: 56 Flush tables: 1 Open tables: 50 Queries per second avg: 0.188 Environment: SuSE Linux 7.1 (but with some updates already) on an AMD Duron, 256MB RAM System: Linux haraldk 2.4.7-4GB #1 Thu Oct 25 19:17:11 GMT 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/i486-suse-linux/2.95.2/specs gcc version 2.95.2 19991024 (release) Compilation info: CC='gcc' CFLAGS='-O2 -m486' CXX='c++' CXXFLAGS='-O2 -m486' 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 -rw-r--r--1 root root 851660
Re: innodb is disabled, how can i make it yes?
at last, i got an error 5 'Access Denied', then after some blah,blah, etc, etc, it got started with InnoDB. not InnoDB is yes. now i can write a good SQL QUERY ;) special thanks to Heikki and Bert -- Hytham Shehab - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AUTO_INCREMENT with Replication
On Wed, Jul 03, 2002 at 10:54:23AM -0700, Eric Frazier wrote: From the manual 4.10.4 Replication will be done correctly with AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values. I am somewhat fearful and curious about how this works. Say we have a master web database that gets replicated back to the office slave over the Internet. A person on the web puts in an order to the master web db, another person in the office enters a phone order, but that order goes into the slave because orders get shipped based on information in the office slave. How would I not at some point end up with replication errors because of duplicate auto_inc values? Would setting up replication as a circle help? Or would timing issues still cause a problem? (The insert on the Master beats the insert on the slave that was getting sent at the time) I am using 4.0.2 alpha so I am most concerned with how that version is affected. You're asking for trouble. :-) AUTO_INCREMENTS are not safe for use in a mutli-master environment. The scenario you painted will result in a primary key violation on the master when it reads the value inserted on the slave. 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.51: up 34 days, processed 779,275,123 queries (258/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 to On DELETE CASCADE
Hello, I'm quite new in MySQL and PHP, so I guess my question is stupide. Sorry for that but I really need the solution... I have 2 tables table Client : --- |ClientID | ClientName| --- |1| Eric | |2| Mark | |3| Simon | --- and table Command : --- | CommandID | ClentID | Price | --- | 2 |1| 32 | | 1 |1| 12 | | 3 |2| 38 | | 4 |2| 65 | | 5 |3| 81 | --- The primary Keys are ClientID on table Client and CommandID on table Command. I'm looking for a way to be sure that when deleting an entry in Client table, all the corresponding entries in Command table are deleted without sending a specific request for that. It seems that in SQL a froreign key is the solution but the MySQL documentation says that foreign keys aren't implemented in MySQL, so how to solve this elementary issue ? Thank you in advance for your replies or suggestions, @+ Carl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Transparent Encryption [was: encrypt myisam?]
On Wed, Jul 03, 2002 at 08:06:52PM +0200, Tobias Bengtsson wrote: I want to do transparent encryption. Like being able to choose an encryption scheme of a table or database when created so that the data on disk is always encrypted. Why don't you just put the tables on an encrypted filesystem? Afraid root will be able to read them? Somewhere the data will be in plaintext, root will always be able to get it if she wants. (think about ptracing mysqld) I need this as my application doesn't communicate directly with the database. I do it via an application called tilde (http://tilde.tildesoftware.net), sure I can patch tilde (me and some others wrote it), but its not a good solution as I'm sure others need or at least want the same thing. So you want it totally transperent? Without any need at all for changes in the client. [...] In the users interface it could be implemented as CREATE:ing the table with some extra flags, choose encryption algorithm, nums of bits etc. And when you're asking querys we'll need a new API to be able to send passphrases too. Whoah! This is really transperant, no needs to make changes in the client :) Or maybe encryption should only be turned on at the database level, not the table level, so you just have to pass an extra parameter on the mysql_real_connect()-api (the best thing is probably to create a new API, called something like mysql_connect_wparams(), taking an info-struct containing things like port, host, username, password, database, ssl-option etc..) or maybe just use the database-password as passphrase for the choosen encryption-scheme.. how strong is the PASSWORD()-funtion? is it just some crypt(3)-variant or good shit? come with some ideas! What about different users (hopefully with different passwords) using the same database? In what way, other than protecting the database ondisk-files from beeing stolen and read, will your proposed change increase the security? If you are able to steal the ondisk-files you are also able to ptrace mysqld and aquire the data that way. To me it seems as a good way of making oneself just feel secure when infact it almost doesn't buy you anything. PS. Please CC replies on the internals list to me, as I'm only on the general discussion list Okidoki.. -- //anders/g - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Strange problem - could be a bug?
In the last episode (Jul 03), Mike Hall said: FreeBSD 4.5-STABLE with LinuxThreads 2.2.3. and MySQL 3.23.51. Duel PIII 1Ghz with 1G of RAM. All from source. Compiled okay and came through super-smack and crash-me tests okay. But a few hours later, for no reason, MySQL decided to look at /var/tmp instead of /usr/local/mysql/var for the datadir. There is nothing in the logs to suggest why this happened. AFAIK, you have to restart mysqld to change the data dir, but the daemon was not restarted at any point. SHOW VARIABLES revealed that the datadir was still set to /usr/local/mysql/var, but SHOW DATABASES listed the contents of /var/tmp (in my case vi.recover). When I shutdown and restarted the system, it reverted to normal behaviour. Anyone have any idea what is going on? Weeird. You don't happen to have written a UDF that changes directories, do you? From a quick scan of the source, mysql chdir()'s to the datadir once on startup and uses relative paths to access tables. This means that any chdir() call made while mysql is running will screw up table access from that point on. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AUTO_INCREMENT with Replication
if you set it up so that the slaves occasionally update the master, you can get around the problem as follows. For the *primary* table(s), when you update the master, get the data for 1 row to update from the slave. When you insert this row into the master, remove the auto_increment field from the list of set values. Then, when the row is inserted, it is assigned a new auto_increment value. This could be a problem if the value you just dropped is meaningful, like an invoice # for instance, and not just a (meaningless) unique id. If you have *child* tables that use that key like a foreign key, you'll need to do some manipulation on the rows from those child tables so that they still relate properly. I have successfully implemented things similar to this for an order /billing system where orders could come from on-line, phone orders, etc. It is a bit of work though, and depending on the app, there may be some things you can't do quite right. I had to work around some issues that i never resolved :( hope this helps sean peters [EMAIL PROTECTED] - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Eric Frazier [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 03, 2002 1:07 PM Subject: Re: AUTO_INCREMENT with Replication On Wed, Jul 03, 2002 at 10:54:23AM -0700, Eric Frazier wrote: From the manual 4.10.4 Replication will be done correctly with AUTO_INCREMENT, LAST_INSERT_ID(), and TIMESTAMP values. I am somewhat fearful and curious about how this works. Say we have a master web database that gets replicated back to the office slave over the Internet. A person on the web puts in an order to the master web db, another person in the office enters a phone order, but that order goes into the slave because orders get shipped based on information in the office slave. How would I not at some point end up with replication errors because of duplicate auto_inc values? Would setting up replication as a circle help? Or would timing issues still cause a problem? (The insert on the Master beats the insert on the slave that was getting sent at the time) I am using 4.0.2 alpha so I am most concerned with how that version is affected. You're asking for trouble. :-) AUTO_INCREMENTS are not safe for use in a mutli-master environment. The scenario you painted will result in a primary key violation on the master when it reads the value inserted on the slave. 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.51: up 34 days, processed 779,275,123 queries (258/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: AUTO_INCREMENT with Replication
Well. Good to know. So I guess the only alternative would be to generate keys by date/time? I was hoping to avoid that. I am still worried about the timestamp type not having good enough resolution. Seconds are pretty broad. Thanks, Eric You're asking for trouble. :-) AUTO_INCREMENTS are not safe for use in a mutli-master environment. The scenario you painted will result in a primary key violation on the master when it reads the value inserted on the slave. 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.51: up 34 days, processed 779,275,123 queries (258/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 Leading Edge Marketing Inc. 250-360-2992 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 : Problems to make a file dump /n and br
Hi, I'm making a CSV from a Mysql table, in which text is stored as is, with all br to keep format etc (I need to keep line breaks because the same text has to be printed out in a page taking care of the original fomatting); The problem comes actually when Excell tries to read the CSV (; separates columns and ;; is a new row) all br inside the text are parsed as a Carriage return causing Excel to display a new Row in the middle of a text field; I've been looking up the mysql manual but I couldn't find a workaround for this, can someone help me, please? thanks in advance to everybody - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB or BdB
Hello, My perception of the InnoDB vs BDB question is that although the BDB is very impressive and long standing, it does not get the same level of attention that InnoDB seems to get from the good folks at MySQL AB. If I am not mistaken, BDB does not yet offer foreign key support. I have chosen InnoDB instead of BDB and have not been disappointed so far. A signed interger is one that can accept both positive and negative values. Because storing the sign of a number uses one bit, and unsigned interger can hold a larger positve value than an unsigned integer. For example, given a 16 bit interger, the maximum value for an unsigned is 2^16, and 2^15 for the signed version. Regards, Michael --- Wouter van Vliet [EMAIL PROTECTED] wrote: Heey There Folks, Well, I hope that this message gets through finallly. First I got it back from the deamon because I had send it in html format, then because of I was suspected from spamming this list. Only for not having used the words query or sql once ... well, I have now so it should come through ;) hihi I just discovered the power of transactions in databases and was wondering, which table type is better; BdB or InnoDB ? and if one is better than the other, why is it? Does BdB also support referential ingegrity as InnoDB does? Also, I was wondering what SIGNED or UNSIGNED integer are .. really don't have a clue about it :D That were some questions I was wondering about .. Greetz, Wouter -- Alle door mij verzonden email is careware. Dit houdt in dat het alleen herlezen en bewaard mag worden als je goed omgaat met al het leven op aarde en daar buiten. Als je het hier niet mee eens bent dien je mijn mailtje binnen 24 uur terug te sturen, met opgaaf van reden van onenigheid. All email sent by me is careware. This means that it can only be reread and kept if you are good for all the life here on earth and beyond. If you don't agree to these terms, you should return this email in no more than 24 hours stating the reason of disagreement. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with mysqlhotcopy
Hi mysql wizards, I've a problem with mysqlhotcopy, i.e. the 'copy step' fails. I've no idea why (for I don't understand perl), could anyone help? Here is how mysqlhotcopy is invoked (intentionaly using option '-n' here): mysqlhotcopy webimages /swpr_ss02-2/frisbee/dbbackups --allowold --keepold -u frisbeebackup -p DOIT -n rmtree /swpr_ss02-2/frisbee/dbbackups/webimages_old rename /swpr_ss02-2/frisbee/dbbackups/webimages, /swpr_ss02-2/frisbee/dbbackups/webimages_old mkdir /swpr_ss02-2/frisbee/dbbackups/webimages/, 0750 LOCK TABLES webimages.CONFIGURATION READ, webimages.CONTEXTS READ, webimages.HOSTS READ, webimages.HTMLPAGES READ, webimages.HTMLPAGES_OLD READ, webimages.IMAGES READ, webimages.IMAGES_OLD READ, webimages.IMAGE_DATA READ, webimages.JOBENTRY_CONTEXTANALYSIS READ, webimages.JOBENTRY_DLCONTEXT READ, webimages.JOBENTRY_DLIMAGE READ, webimages.JOBENTRY_IMAGE_FEATURES READ, webimages.JOBENTRY_IMAGE_INFO READ, webimages.JOBLIST_CONTEXTANALYSIS READ, webimages.JOBLIST_DLCONTEXT READ, webimages.JOBLIST_DLIMAGE READ, webimages.JOBLIST_IMAGE_FEATURES READ, webimages.JOBLIST_IMAGE_INFO READ, webimages.KEYWORDS READ, webimages.KEYWORDS_OLD READ, webimages.MN_IMAGES_KEYWORDS READ FLUSH TABLES /*!32323 webimages.CONFIGURATION, webimages.CONTEXTS, webimages.HOSTS, webimages.HTMLPAGES, webimages.HTMLPAGES_OLD, webimages.IMAGES, webimages.IMAGES_OLD, webimages.IMAGE_DATA, webimages.JOBENTRY_CONTEXTANALYSIS, webimages.JOBENTRY_DLCONTEXT, webimages.JOBENTRY_DLIMAGE, webimages.JOBENTRY_IMAGE_FEATURES, webimages.JOBENTRY_IMAGE_INFO, webimages.JOBLIST_CONTEXTANALYSIS, webimages.JOBLIST_DLCONTEXT, webimages.JOBLIST_DLIMAGE, webimages.JOBLIST_IMAGE_FEATURES, webimages.JOBLIST_IMAGE_INFO, webimages.KEYWORDS, webimages.KEYWORDS_OLD, webimages.MN_IMAGES_KEYWORDS */ Copying 63 files... cp -p /swpr_ss02-2/frisbee/dbbackups/webimages Copying indices for 0 files... UNLOCK TABLES As you can see, the cp command is missing the source parameter... This is mysqlhotcopy version 1.14 running on a debian linux. Regards, Ralf -- - Ralf Jüngling Institut für Informatik - Lehrstuhl f. Mustererkennung Bildverarbeitung Georges-Köhler-Allee Gebäude 52 Tel: +49-(0)761-203-8215 79110 Freiburg Fax: +49-(0)761-203-8262 - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYD files deleted
Hello All, I'm using mysql version 3.23.47 as a database in an embedded device. In the startup scripts for the database I have it run : myisamchk -o -s /usr/local/var/data/*/*.MYI (to fix any possible problems) with safe_mysqld --datadir=/usr/local/var/data (to start the database) On one occasion, during testing I came across an issue where if I poweroff the machine while the database is starting it seems to DELETE many of the MYD files, including host.MYD, user.MYD, along with data MYD files. Of course this makes the database dead. Its not clear to me if its the myisamchk, safe_mysqld, or something else that is actually killing these files. I'm not concerned with retrieving this data, but I do want to find exactly what, and why this is happening and implement a fix. I should note that I am able to re-create the problem if the timing is correct. A possible low tech solution will include copying the MYD files (most of my data is stored in innodb and was not harmed) before starting the database and restoring them from the backup if they are missing. Of course, I would prefer a more proper solution. I'd appreciate knowing if anyone else has had this problem and what version you're using, even if a solution hasn't been found. Thanks, Eric Mayers Software Engineer Captus Networks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Affecting weighting of fulltext indices
I'm working on a search interface in MySQL for a series of items that have titles and descriptions. I'd like to weight the results so that matches in the title count for more than matches in the description. Is there a recommended way of doing this? So far, I've come up with three ways, two of which seem to work. The first and most straightforward is to create a keywords table, and then list the word multiple times depending on where it was listed to give it extra weight. For example, if the title is Children and Dogs and the description is Boys and girls take their pets for walks, I might put in: children children dogs dogs boys girls take their pets walks to give the words that appeared in the title, children and dogs, twice the weight of the other words. The second is to list a column multiple times when creating the index. For example: create fulltext index test on TxKeywords (Title,Title,Description); seems to have roughly the desired effect, but I don't exactly understand what it's doing, and I don't know if this is supported behavior, or if might go away in a future version. The third is to create multiple fulltext indices, and multiply the MATCH...AGAINST number against a multiplier. For example: select *, match(Title) against('children') * 2 + match(Description) against ('children') as score from TxKeywords order by (score) limit 10 This is extremely slow---on a few thousand rows, it takes several minutes at least, which just won't work for an interactive application. Has anybody done anything like this, and would they be willing to share their experiences? Am I missing something obvious? Any way to speed up the third method (which seems to be the most flexible)? Can I count on the second method being supported in future releases? Thanks for any tips, -ScottG. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 : Problems to make a file dump /n and br
If 'text' is stored in the HTML format in the db, the only solution I can think of is writing a perl/shell script to parse out the br and recreate the files without it, that ways, the data in the DB is not disturbed and Excel should be able to read it to (unless someone knows of a setting in Excel which will make it ignore br) Regards, Bhavin. - Original Message - From: Walter D. Funk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 03, 2002 2:34 PM Subject: Mysql : Problems to make a file dump /n and br Hi, I'm making a CSV from a Mysql table, in which text is stored as is, with all br to keep format etc (I need to keep line breaks because the same text has to be printed out in a page taking care of the original fomatting); The problem comes actually when Excell tries to read the CSV (; separates columns and ;; is a new row) all br inside the text are parsed as a Carriage return causing Excel to display a new Row in the middle of a text field; I've been looking up the mysql manual but I couldn't find a workaround for this, can someone help me, please? thanks in advance to everybody - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 On DELETE CASCADE
You can use the InnoDB table type which supports foreign keys. http://www.mysql.com/doc/S/E/SEC446.html If you want to use MyIsam table types, the only solution is to send a specific request to delete records in both the tables. Regards, Bhavin. - Original Message - From: multivac [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Wednesday, July 03, 2002 2:22 PM Subject: How to On DELETE CASCADE Hello, I'm quite new in MySQL and PHP, so I guess my question is stupide. Sorry for that but I really need the solution... I have 2 tables table Client : --- |ClientID | ClientName| --- |1| Eric | |2| Mark | |3| Simon | --- and table Command : --- | CommandID | ClentID | Price | --- | 2 |1| 32 | | 1 |1| 12 | | 3 |2| 38 | | 4 |2| 65 | | 5 |3| 81 | --- The primary Keys are ClientID on table Client and CommandID on table Command. I'm looking for a way to be sure that when deleting an entry in Client table, all the corresponding entries in Command table are deleted without sending a specific request for that. It seems that in SQL a froreign key is the solution but the MySQL documentation says that foreign keys aren't implemented in MySQL, so how to solve this elementary issue ? Thank you in advance for your replies or suggestions, @+ Carl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MYD files deleted
Pada Wed, 3 Jul 2002 16:39:03 -0700 Eric Mayers [EMAIL PROTECTED] menulis : Hello All, I'm using mysql version 3.23.47 as a database in an embedded device. In the startup scripts for the database I have it run : myisamchk -o -s /usr/local/var/data/*/*.MYI (to fix any possible problems) with safe_mysqld --datadir=/usr/local/var/data (to start the database) try to do this first mysqlcheck -A -uuser -ppassword maybe it can help you to restored .MYD files (which maybe was still in repair state -- .TMD) -- printk(Entering UltraSMPenguin Mode...\n); 2.2.16 /usr/src/linux/arch/sparc64/kernel/smp.c query,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: multi-byte characters
Hello, I have a bunch of text with Japanese in it that uses shift_jis encoding. My initial tests show that this encoding has the same problems in MySQL as it does in Perl: it gives false matches. I have to convert the data to the EUC enconding (I think I've seen it called ejis in a MySQL context), and was wondering if anyone can point me to information on how to do that with MySQL and PHP. Have you tried setting the language to Japanese and the encoding to shift-JIS yet? -- Joel Rees [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: Replication errors
Pada Wed, 3 Jul 2002 12:56:30 -0700 Jeff Kilbride [EMAIL PROTECTED] menulis : Is this just a normal timeout error, because there's currently very little activity on these machines? Or is there some other problem? The slave_net_timeout value is at it's default of 3600, so I would expect to see this type of error every hour -- but maybe I misunderstand that variable. If this is just a normal timeout, is there any way to up the value or prevent these errors from being logged? change this value master-connect-retry = 3600 sql,query -- Let's call it an accidental feature. -- Larry Wall - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Load Data Problem
Hie there, I'm having a potential problem with Load Data Infile function where i'm unable to get the right no. of records to appear in the table. I have a table created in MySQL with 2 fields region (char 1)-pkey and regionname (char 30). The table name is called region. I've also created a text file(Test.txt) with the following contents 1,New Record 1 2,New Record 2 3,New Record 3 My SQL load statement is: Load Data Infile 'test.txt' into table region fields enclosed by '' terminated by ,; The result: Query OK, 2 rows affected Records:2 Deleted:0 Skipped:0 Warnings:1 As you can see, only the 1st and 3rd lines of records are input in, the 2nd is ignoredany explanations? By the way, i'm using mysql ver 11.16 Distrib 3.23.49 for Win95/98 (i32) Any help would be much appreciated. Thanks Regards, Eric. ** NOTICE OF CONFIDENTIALITY ** This message and any files transmitted with it may be privileged and/or confidential and are intended only for the use of the addressee. If you, the reader of this message, are not the intended recipient, you should not disseminate, distribute or copy this message. If you have received this message in error, please notify us immediately by return email and delete the original message. 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
login root problem
I can't login using root to mysql server from my pc-client... I have tried to use this command but still have a problem... mysql -u root -p -h 192.168.x.xxx i already created one user which have all privileges so, if i check into mysql database and user tables, i found two user, root and user_1. should i give grant privilege to root with all privileges or not? anybody can help me? Sorry for my bad English and thanks for advance Ivan Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Growing memory usage/processes
Hello all, I have mysql running on a 2.4.18 kernel: /usr/libexec/mysqld Ver 3.23.49 for redhat-linux-gnu on i386 and note that one started about 4 processes (threads?) began to handle the various signal/table tasks and such. After several random queries the process list grows accordingly. After a couple hours all processes which showed consumption of about 8MB of memory initially are now 25MB each and growing as queries are received. My question is...Why if these are threads does it require each thread to utilize so much memory? 4 threads using 10MB each is ok, 10 threads using 10MB each is ok. 20 threads using 25MB each is too much. When I shutdown MySQL available memory increases according to the number of threads * size previously in use. Is this a problem or a feature? Is there a way to limit mysqld to only a certain number of maximum threads and a maximum size of memory always? I don't really like seeing this runaway with all my memory. On the other hand, CPU load is incredibly low. Inserting about 1.5 million records never hit more than about 30% load. The machine is a dual P3 1000Mhz with 1GB of RAM. Any ideas? Thanks! -Dave - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php