forget root password
Hi, I have installed mysql-3.22.22 on Linux RedHat, but now I have problem because I forget the root password. How do I solve this problem ? TIA, dick# __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Clear table contents
Hello Odhiambo, Please allow me to request for help with the table below. mysql select * from relay_ip; +-+++-+-+ | rei_aid | rei_uname | rei_domain | rei_ip | rei_ts | +-+++-+-+ | 1 | wash | alligator.wananchi.com | 62.8.64.4 | 2002-02-08 18:17:36 | | 2 | wash | alligator.wananchi.com | 62.8.64.108 | 2002-02-08 20:36:51 | | 3 | wash | alligator.wananchi.com | 62.8.64.108 | 2002-02-08 20:42:27 | | 4 | wash | alligator.wananchi.com | 62.8.64.108 | 2002-02-09 13:03:27 | | 5 | wash | alligator.wananchi.com | 62.8.64.108 | 2002-02-09 13:03:28 | | 6 | [EMAIL PROTECTED] | freebsd.co.ke | 62.8.64.108 | 2002-02-11 09:46:43 | | 7 | [EMAIL PROTECTED] | freebsd.co.ke | 62.8.64.108 | 2002-02-11 09:47:27 | +-+++-+-+ I am looking for a way to clear each record that is older than 10 minutes by referring to the timestamp. Something that I can run from cron. There is an extensive collection of useful routines described in the manual (6.3.4 Date and Time Functions). You will probably be interested in CURRENT_TIMESTAMP and DATE_SUB(). Currently you have rei_ts formatted as a string. If it is mostly used for calculation, then you might like to consider using (manual: TIME data types) using an integer format or even a UNIX timestamp - for efficiency. Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: forget root password
Please log on to www.mysql.com and do what I did (look under password) http://www.mysql.com/doc/R/e/Resetting_permissions.html You to will come to this page :-) Simon -Original Message- From: dick idod [mailto:[EMAIL PROTECTED]] Sent: 11 February 2002 08:23 To: [EMAIL PROTECTED] Subject: forget root password Hi, I have installed mysql-3.22.22 on Linux RedHat, but now I have problem because I forget the root password. How do I solve this problem ? TIA, dick# __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 of Lock contention
I've a strange problem. Please help me. I've installed Mysql ver. 3.23-46 and I've 3 tables of type InnoDB Until 5 days agò it was ok, but now I received a message: GOT ERROR 146 WHEN READING TABLE. and I've found in documentation that is a lock timeout problem. How can I resolve this problem? and one of the tables has more than 500.000 rows if this is important! The request on mysql arrive from Apache server and the max client of Apache (in http.conf) is 150 (default). thanks Roberto - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 make light DB size?
Hi, I have a problem with my size of MySQL database (.isd file). Every month my data replace with the new one, n every my data replaced, the size of .isd file always more bigger than before. How to make my data light like the first one I fill tables ? Thank you, -M. Amrin- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 FULLTEXT
Hello, I make an fulltext index on a column 'detailannonce' of a table 'apptcv'. When I made this select : SELECT apptcv.*, match (detailannonce) against (' jardin ') as relevance FROM apptcv WHERE match (detailannonce) against ('jardin')0 HAVING relevance0 ORDER BY relevance DESC I didn't have any row in result. If I made this another select : SELECT apptcv.* FROM apptcv WHERE detailannonce like '%jardin%' I had about 6000 rows resulted. And, if in the first select, I'm replace 'jardin' by 'piscine' or another word, It's work fine and I have correct result. What's about the word 'jardin' ? It is a word reserved by Mysql, or perhaps it is in my stop list, but I did'nt find the file containing the stop list in my system (max OS X) Thanks for yours responses. Greetings Philippe BARRIELLE --- * S.A. Editions et Publicites - ABRITEL * 109, La Canebière - B.P 2033 - 13201 Marseille cedex 01 - France Tél : 33 (0)4 91 11 00 72 Wap : http://wap.abritel.fr Email: [EMAIL PROTECTED] Web : http://www.abritel.fr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Fwd: Compile options]
-Forwarded Message- From: Diana Soares [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Compile options Date: 08 Feb 2002 15:35:57 + Hi, Is there a way of knowing with wich options mysql was compiled ? Thanx, -- Diana Soares (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 -- Diana Soares (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
Heap problem
Hi! I made a head table like this: ## create table SECURITIES ( SID varchar(16) not NULL, NAMEvarchar(255)not NULL, MARKET varchar(8) not NULL, TICKER varchar(8) not NULL, LAST_PRICE float not NULL, BID float, ASK float, BIDSIZE int unsigned, ASKSIZE int unsigned, PRICE_CHANGEfloat, PRICE_CHANGE_PSTfloat, HIGHfloat, LOW float, VOLUME int unsigned, CHANGED datetime not NULL, LAST_PRICE_DELAYED float not NULL, CHANGED_DELAYED datetime, CREATED datetimenot NULL, PRIMARY KEY (SID), INDEX (MARKET), INDEX (TICKER), INDEX (LAST_PRICE), INDEX (LAST_PRICE_DELAYED), INDEX (CHANGED), INDEX (LAST_PRICE) ) type=HEAP; ## Then I insert 216 rows of securities where MARKET = 'OSE'. When I try to select from SECURITIES like this: select * from SECURITIES where MARKET='OSE'; the query only responds with 1 row. ( the last in the next listing ) but if I do this: select * from SECURITIES where MARKET like '%OSE'; it resonds with all the 216 rows. -- Tom Vatland mob: +47 93683350 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
when can we expect 4.1?
I saw on the webpage that the alpha release of the mysql database was scheduled to december/january - you mean this year or previous year? /Jon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems with the daemon
Javier, Monday, February 11, 2002, 5:48:16 AM, you wrote: JG hi i´m starting with linux and i want to install the daemon of mysql... JG please help. JG i all ready read the documentation and the man pages but i dont JG understand ... help If you want to install MySQL, you should download MySQL from : http://www.mysql.com/downloads/index.html The recommended way to install MySQL on Linux is to use an RPM file. You can find full instruction for installation in the manual: http://www.mysql.com/doc/L/i/Linux-RPM.html Get some more info about post-installation setup at: http://www.mysql.com/doc/P/o/Post-installation.html -- For technical support contracts, goto https://order.mysql.com/ 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
can't find file--WHY?
Benny, Sunday, February 10, 2002, 7:31:03 PM, you wrote: BC I have backed up my data in server A and copied to /var/lib/mysql/my_db in BC server B where my_db is the name of database. I can see my_db in left column BC of phpMyAdmin 2.2.3 in my browser, but when I try to browse my data, I get BC the error message can't find file: ./my_db/my_table.frm (errno :13). BC What should I do to solve this problem? Your user doesn't have required permission on mysql data dir. Reset permission on server B for your user. BC thanks! BC Benny Chen -- For technical support contracts, goto https://order.mysql.com/ 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
Access denied to apache@localhost
Nick, Sunday, February 10, 2002, 12:58:12 PM, you wrote: NW Hi all NW I've just set up and the latest problem I have getting started is that NW 'Access denied for user: apache@localhost' msg. NW How can I put that right? Please, check the following links: http://www.mysql.com/doc/A/c/Access_denied.html and http://www.mysql.com/doc/P/r/Privileges.html -- For technical support contracts, goto https://order.mysql.com/ 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
Problem with FULLTEXT
Philippe, Monday, February 11, 2002, 12:28:47 PM, you wrote: P Hello, P I make an fulltext index on a column 'detailannonce' of a table 'apptcv'. P When I made this select : P SELECT apptcv.*, match (detailannonce) against (' jardin ') as relevance P FROM apptcv WHERE match (detailannonce) against ('jardin')0 HAVING relevance0 ORDER BY relevance DESC P I didn't have any row in result. P If I made this another select : P SELECT apptcv.* FROM apptcv WHERE detailannonce like '%jardin%' P I had about 6000 rows resulted. P And, if in the first select, I'm replace 'jardin' by 'piscine' or P another word, It's work fine and I have correct result. P What's about the word 'jardin' ? It is a word reserved by Mysql, or P perhaps it is in my stop list, but I did'nt find the file containing the P stop list in my system (max OS X) It's a peculiar property of Full-text search. If the word is present in more than half of rows in the table, it has zero relevance. For more help look at: http://www.mysql.com/doc/F/u/Fulltext_Search.html P Thanks for yours responses. P Greetings P Philippe BARRIELLE -- For technical support contracts, goto https://order.mysql.com/ 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
logrotate error after changing mysql root password
After I've changed the root (mysql) password the logorotate programe (called from cron) gives me the following error: === errors occured while rotating /var/log/mysql.log ./usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' error running postrotate script = errors occured while rotating /var/log/mysql.err ./usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' error running postrotate script = What happens? Thanks Josep - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
release_lock
Hello there! I'm using Apache-Session module and it seems that everything work properly, but in bin log is this query: DO RELEASE_LOCK(Apache-Session-0c47492fccde576b180ea37fa07de395); What could be wrong in it? Please help! Kosyo __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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
Where Did Mysql Go?
I was working on updating some databases yesterday and when I booted up my computer this morning I couldn't connect to MySQL, the error message is can't connect to local MySQL server through socket /path/mysql.socket. It was there yesterday and now it's gone! Where did it go (a search of the HD doesn't show it) and, more important, how do I get it back? Rich -- [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: Where Did Mysql Go?
I was working on updating some databases yesterday and when I booted up my computer this morning I couldn't connect to MySQL, the error message is can't connect to local MySQL server through socket /path/mysql.socket. It was there yesterday and now it's gone! Where did it go (a search of the HD doesn't show it) and, more important, how do I get it back? The socket file is created by mysqld at startup. Are you sure mysqld is running? Have you tried restarting mysqld? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Where Did Mysql Go?
Carsten H. Pedersen wrote: I was working on updating some databases yesterday and when I booted up my computer this morning I couldn't connect to MySQL, the error message is can't connect to local MySQL server through socket /path/mysql.socket. It was there yesterday and now it's gone! Where did it go (a search of the HD doesn't show it) and, more important, how do I get it back? The socket file is created by mysqld at startup. Are you sure mysqld is running? Have you tried restarting mysqld? I finally fixed it by re-booting the computer. Nothing was working; file not found was the error message when I tried to run mysqld and safe_mysqld. Apparently, something hung on the first boot. Rich -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql disk management
Hi, Can you help on this? I'm trying to index a table with bigint(20), 8 byte field (under linux), there are now 650.000.000 rows and takes 8,5Gb space. Free space is 17Gb, twice and stil cant index it couse runs out of space??? aaa@cab1:~/mysql_tests sudo ls -l /var/lib/mysql/test2docfp/ total 8260031 -rw-rw1 mysqldaemon 845000 Feb 11 18:34 docfp.MYD -rw-rw1 mysqldaemon 1024 Feb 11 18:34 docfp.MYI -rw-rw1 mysqldaemon 8594 Feb 10 01:43 docfp.frm aaa@cab1:~/mysql_tests df Filesystem 1k-blocks Used Available Use% Mounted on /dev/vol1/data26213596 9254160 16959436 36% /cdb1 when i give 'create index fp_idx on docfp (fingerprint)' mysql makes temp files like this with #-s -rw-rw1 mysqldaemon 845000 Feb 11 18:58 #sql-18c5_4b.MYD -rw-rw1 mysqldaemon 1024 Feb 11 18:40 #sql-18c5_4b.MYI -rw-rw1 mysqldaemon 8594 Feb 11 18:40 #sql-18c5_4b.frm -rw-rw1 mysqldaemon 845000 Feb 11 18:34 docfp.MYD -rw-rw1 mysqldaemon 1024 Feb 11 18:34 docfp.MYI -rw-rw1 mysqldaemon 8594 Feb 10 01:43 docfp.frm after this consumes all 8,5Gb freespace left after this operation and stops with error message cant create temporary files mysql tmp directory is set to this mounpoint, i dont have space elsewhere Why needs so much space for index? There is twice more space then the database and i know that the index file takes about the same space as this database. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ORDER BY an ABSolute value
Paste your sql exactly as it is and your version of mysql. Dave On Tue, Feb 12, 2002 at 10:08:10AM +1000, David Mackay wrote: Thanks for your quick response Dave, Have tried this, but no bannana... I get: You have an error in your SQL syntax near 'abs(id)' at line 1 Seems a not-valid thing to do these days... Is there a work around? Dave from Oz select id from table_name order by abs(id); Dave Dundee! On Tue, Feb 12, 2002 at 09:46:25AM +1000, David Mackay wrote: G'Day folks, New to PHP/MySQL. Want to order the results of a SELECT by their 'absolute' value, not their sign. So regardless of whether it's +37 or -37, they are both 37 and thus both come between 38 36, regardless of whether they're + or -. eg. 100 -99 -92 91 72 -38 37 -37 etc... I have the order DESC but it puts 100 first, and -100 last, (that's what you'd usually want, but I need the extremes grouped at one end, down to the middle point zero..). In my fantasy world I could do a ORDER BY ABS(number) DESC If there was any other way to achieve the same result that would be just dandy... I bet this is obvious. Thanks for your time, David Mackay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ORDER BY an ABSolute value
At 10:08 +1000 2/12/02, David Mackay wrote: Thanks for your quick response Dave, Have tried this, but no bannana... I get: You have an error in your SQL syntax near 'abs(id)' at line 1 If you can't put an expression in your ORDER BY, that means your version of MySQL is older than 3.23. The workaround is to add another column to the selection list and refer to it in the ORDER BY using an alias or a column position: SELECT id, ABS(id) AS absid FROM tbl_name ORDER BY absid; or SELECT id, ABS(id) FROM tbl_name ORDER BY 2; Then ignore the second column of output when processing the result. Seems a not-valid thing to do these days... Is there a work around? Dave from Oz select id from table_name order by abs(id); Dave Dundee! On Tue, Feb 12, 2002 at 09:46:25AM +1000, David Mackay wrote: G'Day folks, New to PHP/MySQL. Want to order the results of a SELECT by their 'absolute' value, not their sign. So regardless of whether it's +37 or -37, they are both 37 and thus both come between 38 36, regardless of whether they're + or -. eg. 100 -99 -92 91 72 -38 37 -37 etc... I have the order DESC but it puts 100 first, and -100 last, (that's what you'd usually want, but I need the extremes grouped at one end, down to the middle point zero..). In my fantasy world I could do a ORDER BY ABS(number) DESC If there was any other way to achieve the same result that would be just dandy... I bet this is obvious. Thanks for your time, David Mackay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Request for help in testing new replication code in 4.0.2
On Sunday 10 February 2002 01:17 am, you wrote: I can't get it to start replicating. Note, the master (db1.tias.com) is a 3.23 server. The slave is 4.0.2 (noritake.tias.com). On the master I get: mysql show master status; +---++--+--+ | File ? ? ? ? ?| Position ? | Binlog_do_db | Binlog_ignore_db | +---++--+--+ | spode-bin.020 | 1058168617 | ? ? ? ? ? ? ?| ? ? ? ? ? ? ? ? ?| +---++--+--+ 1 row in set (0.00 sec) mysql show slave status; +-+-+-+---+-+-++---+---+--+---+-+-+++--+-+ | Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File ? ? ? ? | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | Exec_master_log_pos | +-+-+-+---+-+-++---+---+--+---+-+-+++--+-+ | ? ? ? ? ? ? | ? ? ? ? ? ? | 0 ? ? ? ? ? | 0 ? ? ? ? ? ? | ? ? ? ? ? ? ? ? | 0 ? ? ? ? ? ? ? ? ? ?| noritake-relay-bin.001 | 4 ? ? ? ? ? ? | ? ? ?| No ? ? ? ? ? ? ? | No ? ? ? ? ? ? ? ?| ? ? ? ? ? ? ? ? | ? ? ?| 0 ? ? ? ? ?| ? ? ? ? ? ?| 0 ? ? ? ? ? ?| 0 ? ? ? ? ? ? ? ? ? | +-+-+-+---+-+-++---+---+--+---+-+-+++--+-+ 1 row in set (0.01 sec) and in noritake.tias.com.err: 020210 00:07:21 ?mysqld started 020210 ?0:07:21 ?Could not find first log during relay log initialization 020210 ?0:07:21 ?Warning: Can't create threads to handle slave /usr/local/libexec/mysqld: ready for connections and in /etc/my.cnf on the slave: [mysqld] replicate-ignore-table=curioscape.avstemp replicate-ignore-table=tias.avtemp replicate-ignore-table=inventory.availableQuantity replicate-ignore-table=inventory.thisItem replicate-ignore-table=inventory.auctionStatus replicate-ignore-table=inventory.itemTable master-host=db1.tias.com master-user=slave master-password=password log=db.log # master-port= server-id=2 and on the server: [mysqld] set-variable = tmp_table_size=8M set-variable = key_buffer=384M set-variable = max_allowed_packet=2M set-variable = max_connections=1024 set-variable = table_cache=8192 set-variable = thread_cache_size=32 set-variable = sort_buffer=4M set-variable = record_buffer=2M log-slow-queries log-bin server-id=1 It appears the problem is that the new replication code is using a different file name convention? This set up did work before. Until the 4.0.1 MySQL starting crashing because of a fulltext index bug that I reported earlier. Mike: Thanks for reporting the bug. To troubleshoot it, lets do the following: in slave.cc around line 186, you find the following code: if (rli-relay_log.find_first_log(rli-linfo,log)) { *errmsg=Could not find first log during relay log initialization; goto err; } make it: if (rli-relay_log.find_first_log(rli-linfo,log)) { sql_print_error(Could not find first log during relay initialization); abort(); *errmsg=Could not find first log during relay log initialization; goto err; } and then run BUILD/compile-pentium-debug and install the new binary. It will coredump when it hits the error. You will find a core file ( core.pid_of_mysql) in your datadir. FTP the core file to support.mysql.com/pub/mysql/secret along with your binary and a readme file all in a tar archive. Thanks again for your efforts to help us make MySQL 4.0 more stable. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try:
RE: ORDER BY an ABSolute value
Well, See the egg on face you get when using old technology. I'll never use asbestos cutlery again, and I'll upgrade myMySQL while I'm at it!!! Thanks Paul, Dave This brings ORDER to CHAOS!!! Dave (SoulScientist) -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 12 February 2002 10:29 To: David Mackay; 'David Turner' Cc: '[EMAIL PROTECTED]' Subject: RE: ORDER BY an ABSolute value At 10:08 +1000 2/12/02, David Mackay wrote: Thanks for your quick response Dave, Have tried this, but no bannana... I get: You have an error in your SQL syntax near 'abs(id)' at line 1 If you can't put an expression in your ORDER BY, that means your version of MySQL is older than 3.23. The workaround is to add another column to the selection list and refer to it in the ORDER BY using an alias or a column position: SELECT id, ABS(id) AS absid FROM tbl_name ORDER BY absid; or SELECT id, ABS(id) FROM tbl_name ORDER BY 2; Then ignore the second column of output when processing the result. Seems a not-valid thing to do these days... Is there a work around? Dave from Oz select id from table_name order by abs(id); Dave Dundee! On Tue, Feb 12, 2002 at 09:46:25AM +1000, David Mackay wrote: G'Day folks, New to PHP/MySQL. Want to order the results of a SELECT by their 'absolute' value, not their sign. So regardless of whether it's +37 or -37, they are both 37 and thus both come between 38 36, regardless of whether they're + or -. eg. 100 -99 -92 91 72 -38 37 -37 etc... I have the order DESC but it puts 100 first, and -100 last, (that's what you'd usually want, but I need the extremes grouped at one end, down to the middle point zero..). In my fantasy world I could do a ORDER BY ABS(number) DESC If there was any other way to achieve the same result that would be just dandy... I bet this is obvious. Thanks for your time, David Mackay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ORDER BY an ABSolute value
Did you try SQRT(id)? Should rank things the way you want if it's legal (*_*) -Original Message- From: David Mackay [mailto:[EMAIL PROTECTED]] Sent: Monday, February 11, 2002 7:08 PM To: 'David Turner'; David Mackay Cc: '[EMAIL PROTECTED]' Subject: RE: ORDER BY an ABSolute value Thanks for your quick response Dave, Have tried this, but no bannana... I get: You have an error in your SQL syntax near 'abs(id)' at line 1 Seems a not-valid thing to do these days... Is there a work around? Dave from Oz select id from table_name order by abs(id); Dave Dundee! On Tue, Feb 12, 2002 at 09:46:25AM +1000, David Mackay wrote: G'Day folks, New to PHP/MySQL. Want to order the results of a SELECT by their 'absolute' value, not their sign. So regardless of whether it's +37 or -37, they are both 37 and thus both come between 38 36, regardless of whether they're + or -. eg. 100 -99 -92 91 72 -38 37 -37 etc... I have the order DESC but it puts 100 first, and -100 last, (that's what you'd usually want, but I need the extremes grouped at one end, down to the middle point zero..). In my fantasy world I could do a ORDER BY ABS(number) DESC If there was any other way to achieve the same result that would be just dandy... I bet this is obvious. Thanks for your time, David Mackay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to connect in non-interactive mode
If you set the interactive_timeout to infinite then no clients will get disconnected until the server is restarted. I know the perl DBI allows for a client to implement ping ($dbh-ping) ... this will reset the timeout for that particular client, allow the client to check for connectivity, without having to make ever client connect forever!!. I'm sure the JDBC driver will allow for this. Regards, Dan -Original Message- From: beckymcelroy [mailto:beckymcelroy]On Behalf Of Becky McElroy Sent: Tuesday, 12 February 2002 9:31 a.m. To: [EMAIL PROTECTED] Subject: How to connect in non-interactive mode Hello- How does one run a client in non-interactive mode? Or, is there a way to set interactive_timeout at the MySQL server to infinite? We have a software component connecting to MySQL (using Mark Matthews JDBC driver) and there may be a long time ( 8 hours) of inactivity. Any suggestions much appreciated - Becky McElroy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ORDER BY an ABSolute value
dear friends.. i'm doing a simple script that use mysql_fetch_array() and it give me the following error. Warning: Supplied argument is not a valid MySQL result resource in /apache/htdocs/html/intranet.domus.cl/base.php on line 10 Warning: Supplied argument is not a valid MySQL result resource in /apache/htdocs/html/intranet.domus.cl/base.php on line 16 here is the code, there is no problem with the connection to BD, i probe it and it works.. but this problem don't let print nothing in a web page.. i'll appreciate your help... html body ? include(config.inc); $db = mysql_connect($servidor, $usuariodb, $password); mysql_select_db($base,$db); ? ? $result = mysql_query(select nombres,email from usuarios); while ($row = mysql_fetch_array($result)) { echo user_id: .$row[nombres].br\n; echo user_id: .$row[0].br\n; echo email: .$row[email].br\n; echo fullname: .$row[1].br\n; } mysql_free_result($result); ? /body /html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql_fetch_array
dear friends.. i'm doing a simple script that use mysql_fetch_array() and it give me the following error. Warning: Supplied argument is not a valid MySQL result resource in /apache/htdocs/html/intranet.domus.cl/base.php on line 10 Warning: Supplied argument is not a valid MySQL result resource in /apache/htdocs/html/intranet.domus.cl/base.php on line 16 here is the code, there is no problem with the connection to BD, i probe it and it works.. but this problem don't let print nothing in a web page.. i'll appreciate your help... html body ? include(config.inc); $db = mysql_connect($servidor, $usuariodb, $password); mysql_select_db($base,$db); ? ? $result = mysql_query(select nombres,email from usuarios); while ($row = mysql_fetch_array($result)) { echo user_id: .$row[nombres].br\n; echo user_id: .$row[0].br\n; echo email: .$row[email].br\n; echo fullname: .$row[1].br\n; } mysql_free_result($result); ? /body /html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Errors that i can't see find in the help system on mysql
020206 15:11:47 mysqld started /usr/pkg/libexec/mysqld: ready for connections 020207 1:02:00 Error in accept: Too many open files 020207 1:06:19 Error in accept: Too many open files 020207 1:10:37 Error in accept: Too many open files 020207 1:14:56 Error in accept: Too many open files 020207 1:19:14 Error in accept: Too many open files 020207 1:23:33 Error in accept: Too many open files 020207 1:27:52 Error in accept: Too many open files 020207 1:32:10 Error in accept: Too many open files 020207 1:36:29 Error in accept: Too many open files 020207 1:40:47 Error in accept: Too many open files 020207 1:45:06 Error in accept: Too many open files 020207 1:49:24 Error in accept: Too many open files 020207 1:53:43 Error in accept: Too many open files 020207 1:58:01 Error in accept: Too many open files 020207 2:02:20 Error in accept: Too many open files 020207 2:06:39 Error in accept: Too many open files 020207 2:10:57 Error in accept: Too many open files 020207 2:15:16 Error in accept: Too many open files 020207 2:19:34 Error in accept: Too many open files 020207 2:23:53 Error in accept: Too many open files 020207 2:28:11 Error in accept: Too many open files 020207 2:32:30 Error in accept: Too many open files 020207 2:36:48 Error in accept: Too many open files 020207 2:41:07 Error in accept: Too many open files 020207 2:45:26 Error in accept: Too many open files 020207 2:49:44 Error in accept: Too many open files 020207 2:54:03 Error in accept: Too many open files 020207 2:58:21 Error in accept: Too many open files 020207 3:02:40 Error in accept: Too many open files 020207 3:06:58 Error in accept: Too many open files 020207 3:11:17 Error in accept: Too many open files 020207 3:15:36 Error in accept: Too many open files 020207 3:19:54 Error in accept: Too many open files 020207 3:24:13 Error in accept: Too many open files 020207 3:28:31 Error in accept: Too many open files 020207 3:32:50 Error in accept: Too many open files 020207 3:37:08 Error in accept: Too many open files 020207 3:41:27 Error in accept: Too many open files 020207 3:45:45 Error in accept: Too many open files 020207 3:50:04 Error in accept: Too many open files 020207 3:54:23 Error in accept: Too many open files 020207 3:58:41 Error in accept: Too many open files 020207 4:03:00 Error in accept: Too many open files 020207 4:07:18 Error in accept: Too many open files 020207 4:11:37 Error in accept: Too many open files 020207 4:15:55 Error in accept: Too many open files 020207 4:20:14 Error in accept: Too many open files 020207 4:24:32 Error in accept: Too many open files 020207 4:28:51 Error in accept: Too many open files 020207 4:33:10 Error in accept: Too many open files 020207 4:37:28 Error in accept: Too many open files 020207 4:41:47 Error in accept: Too many open files 020207 4:46:05 Error in accept: Too many open files 020207 4:50:24 Error in accept: Too many open files 020207 4:54:42 Error in accept: Too many open files I can't find this in any of the helpfiles on your website, nor can i find it on NetBSD helpfile mysql Ver 11.15 Distrib 3.23.47, for -netbsdelf (i386) And 1.5ZA NetBSD 1.5ZA I Same error on 3.23.43 i tried upgrading both the kernel and the mysql, but still no avail. Have you had any others with similar problems, if so i'd love to hear about it Terkel -- Terkel D. Olsen Systemadministrator Bonnierforlagene A/S Frederiksborggade 1. 2.sal 1360 Kbh K Tlf: 33 69 50 85 Mob: 40 18 70 85 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
regarding mysql DATE support
Hai , is there any support of sys_date in mysql which is strong feature in oracle 8.x . i am using MYSQL 3.23 server version . With Warm Regards [EMAIL PROTECTED] JIN INformation Systems(P) Ltd Voice : 5275300/5097603/5097604/5281822 ext 218 www.jinis.com With Warm Regards [EMAIL PROTECTED] JIN INformation Systems(P) Ltd Voice : 5275300/5097603/5097604/5281822 ext 218 www.jinis.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with database
I have a site using PHP Mysql. About a month ago to now one of the tables gets corrupted with the message Got Error 127... I fix it and everything works OK, except every time I loose 1 record. Today I could obtain mysql.err from the machine and I could see whenever an error is produced by date, previously I have the following line: 020205 9:57:46 Aborted connection 137 to db: 'Biblioteca' user: 'ODBC' host: `localhost' (Server shutdown in progress) 020205 9:57:46 Aborted connection 124 to db: 'Biblioteca' user: 'ODBC' host: `localhost' (Server shutdown in progress) or 020205 12:55:51 Aborted connection 377 to db: 'Biblioteca' user: 'ODBC' host: `localhost' (Unknown error) 020205 13:05:37 Aborted connection 504 to db: 'Biblioteca' user: 'ODBC' host: `localhost' (Unknown error) It doesn´t seems too clear for me because no ODBC client should be accessing to the database. Should I suppose that an unautorized ODBC client is breaking the table or could be another problem? Thanks a lot. Emiliano. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Memory limit issue with 64 bit mysql.3.23.46
On Wed, Feb 06, 2002 at 08:04:23PM +0200, Sinisa Milivojevic wrote: Albert Chin writes: On Wed, Feb 06, 2002 at 07:17:13PM +0200, Sinisa Milivojevic wrote: Yes, SIZEOF_INT is 4: $ grep SIZEOF_INT config.h #define SIZEOF_INT 4 $ grep SIZEOF_INT include/my_config.h #define SIZEOF_INT 4 However, according to http://docs.sun.com/ab2/coll.45.13/SOL64TRANS/%40Ab2PageView/1865;td=5?Ab2Lang=CAb2Enc=iso-8859-1, in the LP64 (64-bit) environment, int is 32-bits and long is 64-bits so it would appear SIZEOF_INT == 4 is correct above. -- albert chin ([EMAIL PROTECTED]) It is correct. It is a smnall problem in our code. Ok. Guess we'll wait for a fix. Any idea when a fix for MySQL will be available? -- albert chin ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: bug in count(distinct(putafieldnamehere)) ?
Ok, its not in count(distinct()). It always happends if temptables are used, but only if the server runs some minutes/hours/days :( -Ursprüngliche Nachricht- Von: Maverick [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 7. Februar 2002 16:48 An: [EMAIL PROTECTED] Betreff: bug in count(distinct(putafieldnamehere)) ? Hi, can it be that there is a bug in count(distinct(putafieldnamehere)) ? After restarting the server it runs, but after some time it doesnt return any result-rows. A count(putafieldnamehere) runs without problems in this situation. Thanx for any sugesstions to solve this problem ... mysql,database,query,bug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PostgreSQL
Whether or not the default table type is changed to InnoDB, in the spirit of the original poster's question, and what I think Sinisa is trying to get you to admit, transaction support is no longer one of the issues to consider when comparing MySQL to PostgreSQL. MySQL supports transactions *now*. Transactions everywhere is really a meanlingless comparison point. If anything, MySQL wins on this point. What if I don't want it everywhere? Point being, in MySQL you have a choice. That said, depending on your requirements, there are still compelling reasons to choose PostgreSQL - subselects, triggers, user defined types, etc. -Original Message- From: [EMAIL PROTECTED]=20 [mailto:[EMAIL PROTECTED]] On Behalf Of Trond=20 Eivind Glomsr=F8d Sent: Wednesday, February 06, 2002 3:15 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: PostgreSQL =20 =20 Sinisa Milivojevic [EMAIL PROTECTED] writes: =20 Trond Eivind Glomsr=F8d writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: =20 There is a slight difference between advanced, non-standardized=20 tuning/backup/load-balancing like that and core SQL functionality=20 not being present. =20 This depends on the definition. Where do you draw your definitions=20 from ?? =20 And core SQL functionlity that we speak about IS present. =20 Transactions are present, but not in the default table type=20 (MyISAM). My understanding is that this will change in MySQL 4. =20 --=20 Trond Eivind Glomsr=F8d Red Hat, Inc. =20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) =20 To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail=20 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php =20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: having trouble killing mysqld to restart and change root
Amendment to that last post I don't think the daemon is starting properly, because I can't run a mysqladmin version - I just get a hung cursor. Does anyone know if there's something that would be stopping mysqld from loading with the --skip-grant-tables option? When I do a ps I can see that it's definitely been started, but the fact that I can't do anything with mysqladmin makes me think that it hasn't loaded the way it needs to. JP Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables option, however now I can't connect to the monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try using /usr/bin/mysql -h hostname mysql Anyone know why I can't get the monitor started? JP At 03:20 PM 2/6/2002 -0600, you wrote: If you need to, use the kill -9 pid -9 is a definite kill and it will work -Original Message- From: JP Audette [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: having trouble killing mysqld to restart and change root password Howdy, I'm trying to reset a forgotten password for a MySQL server, and I can't kill mysqld via the method mentioned in the documentation (or by any method for that matter). When I try using the command... kill 'cat /var/lib/mysql/mysqld.pid' ...I get a message saying that there is no such pid (although that's definitely the path specified for the pid when mysqld loads). I've also tried to kill it by running a ps -wax and killing these processes... 643 ?S 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysqld.pid 675 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 709 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 710 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - I'm not sure if all of these are processes that are actively running, but killing them apparently does nothing because I am unable to load mysqld again so that I can restart it using the --skip-grant-tables option. Can someone help me understand which of the pid's is the actual one, and how I can kill it? Thanks, JP - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FULL-TEXT Index / Searching Question
Hello, I have two tables in my database as such: CREATE TABLE `skill_names` ( `id` bigint(20) NOT NULL auto_increment, `name` varchar(30) NOT NULL default '', PRIMARY KEY (`id`) ); CREATE TABLE `skills` ( `skills_id` int(11) NOT NULL auto_increment, `member_id` int(11) NOT NULL default '0', `schooling` varchar(100) default NULL, `certifications` varchar(20) NOT NULL default '', `description` blob NOT NULL, `skill_name_id` bigint(20) NOT NULL default '0', PRIMARY KEY (`skills_id`) ); I would like to make full text indexes of the skills table as well as the other tables in the database. My question is that I would like to be able to search for the Member_ID's that have a certain skill name. How would I accomplish this? Also, right now the database has about 300 records, the database runs on a Pentium 200 with 96Mb. Can it handle this not much traffic? Thanks. Matt Rudderham I am running MySQL 3.23.38 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 access MySql using Perl. Help
Hi. You have to install DBI::DBD module. Then in perl use Mysql; $dbh = Mysql-connect(undef,database,username,'password'); $sql = select blah from blah; $sth = $dbh-query($sql); @arr = $sth-fetchrow; for example if the result is more than one line you have to loop it Ofcoz there is other ways to do it i guess:) /PM\ Andy Cheng wrote: Hello, I am new to MySql. I have MySql installed in my Linux PC. How do I connect to MySql using Perl script and assign the result of a query to an array? Where could I find a sample code? Thank you. Andy _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Memory limit issue with 64 bit mysql.3.23.46
Albert Chin writes: $ grep SIZEOF_LONG config.h #define SIZEOF_LONG 8 #define SIZEOF_LONG_LONG 8 $ grep SIZEOF_LONG incldue/my_config.h #define SIZEOF_LONG 8 #define SIZEOF_LONG_LONG 8 -- albert chin ([EMAIL PROTECTED]) If SIZEOF_INT is 4, then it could be our bug. Please let us know. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Tweaking MySQL on a RaQ (or any server) Help please.
At 20:54 -0500 02/04/2002, I whispered: Hi all, A couple of weeks back you may remember that I was asking about setting up a new client on our server that ran around 35GB in bandwidth per month mostly from MySQL queries. Well, we have put them on our server and have good and bad news. The good news is that they are now pulling around 45GB in bandwidth per month. Overall the performance is acceptable and the machine is happy. Hmm. I guess no one has any suggestions on tweaking our mysqld server to run better. This is an important MySQL issue for us. If no one can suggest a tip or two, perhaps someone can suggest a place to look on the internet or a good book. I have read most of the pertinent documentation from MySQL and have done my share of searching through google for pertinent information. I have New Riders book on MySQL which has been read cover to cover. I am stil stuck. I will include my last email below in case anyone can offer some advice. Oh, and i forgot last time - we are using MySQL 3.23.37. here is the old email -- A couple of weeks back you may remember that I was asking about setting up a new client on our server that ran around 35GB in bandwidth per month mostly from MySQL queries. Well, we have put them on our server and have good and bad news. The good news is that they are now pulling around 45GB in bandwidth per month. Overall the performance is acceptable and the machine is happy. Now, the bad news, which is why I am emailing the list for I am out of ideas. During peak assaults on our server, which is noon eastern time and noon pacific time, or there-abouts, our server does not do so well. Apart from getting CPU warning from the server about high load averages going up to 15 for a 15 minute period, we also had the sendmail server shutdown for a couple of minutes from lack of resources. A few specs: MySQL extended-status shows some of the following | Aborted_clients | 1315 | | Aborted_connects | 20 | | Bytes_received | 568116057 | | Bytes_sent | 113998812 | ---this should be several Gig by now, is there a rollover? | Connections | 166586 | | Created_tmp_disk_tables | 25944 | | Created_tmp_tables | 96834 | | Created_tmp_files| 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 37034 | | Handler_read_first | 360285 | | Handler_read_key | 17394405 | | Handler_read_next| 28441290 | | Handler_read_prev| 4808 | | Handler_read_rnd | 21530499 | | Handler_read_rnd_next| 1185471281 | | Handler_update | 690269 | | Handler_write| 1808922| | Key_blocks_used | 46376 | | Key_read_requests| 81926178 | | Key_reads| 17962 | | Key_write_requests | 712426 | | Key_writes | 234236 | | Max_used_connections | 49 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 256| | Open_files | 420| | Open_streams | 0 | | Opened_tables| 5745 | | Questions| 5080399| | Select_full_join | 102| | Select_full_range_join | 1 | | Select_range | 370613 | | Select_range_check | 0 | | Select_scan | 952200 | | Slave_running| OFF| | Slave_open_temp_tables | 0 | | Slow_launch_threads | 84 | ---This is not good is it? | Slow_queries | 0 | | Sort_merge_passes| 0 | | Sort_range | 381972 | | Sort_rows| 36789069 | | Sort_scan| 659404 | | Table_locks_immediate| 4181394| | Table_locks_waited | 2958 | | Threads_cached | 7 | | Threads_created | 1678 | | Threads_connected| 1 | | Threads_running | 1 | | Uptime | 1141490| +--++ I have basically used the large-my.cnf configuration with modifications to allow up to 150 simultanous connections. Though I am wondering what else I can modify, or perhaps I should not have use that configuration. System specs: Cobalt RaQ4i 450MHz 512MB of RAM --Which is why I am thinking that large-my.cnf is too big Apache, PHP and MySQL Application is GeekLog 1.2.5 which albeit is not very efficient in its queries. Hmm, I think I have included most of my information. Now, can anyone give some suggestions on how to enhance MySQL? The other processes are definitely not causing
What is MySQL-MAX.
Hi , I am already using MySQL 3.23.26, which is available by Redhat LINUX 7.1 If I would like to update to newer version I found the following What is MySQL-MAX. RedHat packages (rpm) MySQL 3.23.47 Server (i386) (1.4M) where as ordinary MySQL RedHat packages (rpm) MySQL 3.23.47 Server (i386) (6M) Is the sizes will be this much different. Which can better to download and use if I want transaction security to tables. regards, sreedhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LIKE work around??
Work-around? LIKE should work just fine... mysql select * from fruits where fruit_name like '%banana%'; On Thu, 7 Feb 2002, Rutledge, Aaron wrote: I am trying to query the database for records that have the same sequence of starting characters--such as banana1 and banana2 and have a result set returned that contains everything that starts with banana. Any way to do this? I think I would use LIKE in other types of databases, but I was wondering if there was a work around for MySQL. Thanks, Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PostgreSQL
Sinisa Milivojevic [EMAIL PROTECTED] writes: Trond Eivind Glomsrød writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: There is a slight difference between advanced, non-standardized tuning/backup/load-balancing like that and core SQL functionality not being present. This depends on the definition. Where do you draw your definitions from ?? And core SQL functionlity that we speak about IS present. Transactions are present, but not in the default table type (MyISAM). My understanding is that this will change in MySQL 4. -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Starting Server
Greetings: I recently upgraded my MySQL server on a Linux box. When I try to start the server, it says started, then immediately it stops. The log file gumby.err reports: -- 020206 14:38:35 mysqld started /usr/local/libexec/mysqld: File './gumby-bin.1' not found (Errcode: 13) 020206 14:38:36 Could not use gumby-bin for logging (error 13) 020206 14:38:36 /usr/local/libexec/mysqld: Can't create/write to file '/usr/loc al/var/gumby.pid' (Errcode: 13) 020206 14:38:36 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 020206 14:38:36 /usr/local/libexec/mysqld: Error on delete of '/usr/local/var/g umby.pid' (Errcode: 13) 020206 14:38:36 mysqld ended --- Anyone have any ideas on how I should troubleshoot? Thanks Chris Mulcahy __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 field
[redirecting to mysql list because of general interest] Yoram Naim wrote: Can some one send me a code sample (C , CPP ) How can I copy file data to MYSQL BLOB field but not in one piece . Is this even possible? If so, I'm sure that the JDBC driver could use such a feature to stream large blobs to the database (currently, in 3.23, we're stuck with the 16MB single-packet limitation). -- Shankar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
more problems: session ends immediately ...
hello again, still learning ... i'm experiencing some unusual behaviors from the daemon. it stops immediately. [localhost:/usr/local/mysql] root# sudo ./bin/safe_mysqld --user=mysql [localhost:/usr/local/mysql] root# Starting mysqld daemon with databases from /usr/local/mysql/data 020205 15:13:40 mysqld ended any ideas ... always appreciated jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Cannot connect to MySQL server with a java application
hello, i tried to connect my MySQL-Server with a short java application. The application can't connect to the server, obviously the server is running on localhost:3306. I append the SourceCode (roughly the same: http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:80228:200107:popciohjmlbbolpak ) and the error-message. SourceCode: import java.sql.*; class SQLtest2 { public static void main(String[] args) { try { Class.forName(org.gjt.mm.mysql.Driver).newInstance(); System.out.println(register the Driver: OK); } catch (Exception e){} try { Connection conn = DriverManager.getConnection(jdbc:mysql://127.0.0.1:3306/test?user=testpass word=teschd); System.out.println(... ccnnected); Statement s = conn.createStatement(); s.close(); conn.close(); } catch(SQLException e) { System.out.println(SQLException: + e.getMessage()); System.out.println(SQLState: + e.getSQLState()); System.out.println(VendorError: + e.getErrorCode()); } } } Error-Msg: register the Driver: OK java.io.IOException: Connection timed out at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:56) (some EXCeptions more) SQLException: Cannot connect to MySQL server on 127.0.0.1:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.io.IOException) SQLState: 08S01 VendorError: 0 is there somebody who can help me? thnx bobby - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: long query on php
Since PHP ignores whitespace, I think this is also acceptable: $query = CREATE TABLE query tabledef for col a, tabledef for col b, lots more table defs, . welcome to line 400; I have been using this technique and have not had any problems with it. If you echo $query, it's all on the same line. # Nathan - Original Message - From: Johnny Withers [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 10:36 AM Subject: RE: long query on php Or you could do it like this: $query=some query .some more of this query .still some more query .and so on and so forth...; ; The tabs are no needed, I just put them there to make it easy to understand that all those lines are actually just one line. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Brett Burgess [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 11:25 AM To: [EMAIL PROTECTED] Subject: Re: long query on php Here is how I do it: $query = some query ; $query.=some more of the same query ; $query.=still more query ; $query.=and so on... ; $rst = mysql_query($query); NOTE: you need to add a space at the end of each line (after the last word and before the closing quotations) if you plan on continuing the query on the next line, or else your SQL will be invalid. Good luck, Brett Original Message Follows From: savaidis [EMAIL PROTECTED] To: MySQL list \(E-mail\) [EMAIL PROTECTED] Subject: long query on php Date: Wed, 6 Feb 2002 21:13:44 +0200 How is possible to pass a long query to MySQL server with php? I mean i.e a create table statement with more than 400 chars. Have I to use shorter create and then alter? Thanks Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Join the world's 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Print file
Hi all How can I take info from one table and print it into a txt file. the table is (NAME) and all the names in it I want to print out to a file name virtusertable. Thanx Christo 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.sock
When I try to connect to the mysql server (mysql -u root -p table), I get an error about /tmp/mysql.sock. Anyway, what is the problem here? Do I have to take it down and start it up again? I'm pretty sure the problem is that the file has been deleted, probably a cron job, but I can't remember the fix. Tried touching it to make it exist again, but of course no go. (And a pointer to the documentation would be welcomed, too...) What does the mysqld.log file say? If the mysql.sock is gone, stopping (killing) mysqld and then starting it again will fix it. Joe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GRANT command (ERROR 1047)
I am using the following versions of mysql on suse linux 7.2: frontend: mysql Ver 11.15 Distrib 3.23.47, for pc-linux-gnu (i686) server: version 3.23.47 If I try to use the GRANT command I get #mysql -u root mysql mysql GRANT ALL ON *.* TO root@localhost - IDENTIFIED BY 'password' WITH GRANT OPTION; ERROR 1047: Unknown command Any idea? 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: having trouble killing mysqld to restart and change root
Ye, that did the trick. I was able to get the daemon restarted using the --skip-grant-tables option, however now I can't connect to the monitor. Typing in /usr/bin/mysql I just get a hung cursor. Same if I try using /usr/bin/mysql -h hostname mysql Anyone know why I can't get the monitor started? JP At 03:20 PM 2/6/2002 -0600, you wrote: If you need to, use the kill -9 pid -9 is a definite kill and it will work -Original Message- From: JP Audette [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:52 PM To: [EMAIL PROTECTED] Subject: having trouble killing mysqld to restart and change root password Howdy, I'm trying to reset a forgotten password for a MySQL server, and I can't kill mysqld via the method mentioned in the documentation (or by any method for that matter). When I try using the command... kill 'cat /var/lib/mysql/mysqld.pid' ...I get a message saying that there is no such pid (although that's definitely the path specified for the pid when mysqld loads). I've also tried to kill it by running a ps -wax and killing these processes... 643 ?S 0:00 sh /usr/bin/safe_mysqld --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/mysqld.pid 675 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 709 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - 710 ?S 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/mysqld.pid - I'm not sure if all of these are processes that are actively running, but killing them apparently does nothing because I am unable to load mysqld again so that I can restart it using the --skip-grant-tables option. Can someone help me understand which of the pid's is the actual one, and how I can kill it? Thanks, JP - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
admin privilege problems
jeremy, Tuesday, February 05, 2002, 6:40:29 PM, you wrote: jr hello, jr i made the mistake of changing my root password manually in the mysql jr database. after doing so, i 'flushed privileges'. jr now i'm unable to log on using the root. i've tried to log on using the new jr password a number of times, but i'm always denied access. strangely enough, jr other users (that have passwords) can log on successfully without providing jr a password. does anybody have any recommendations for logging on as the root jr user ... and fixing this privileges problem? Look at: http://www.mysql.com/doc/R/e/Resetting_permissions.html It will help you. jr thx jr jeremy -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.sock
Cindy, Tuesday, February 05, 2002, 11:58:45 PM, you wrote: C Sorry, I know this is documented somewhere, because I've seen it, C but I can't find it now, nor remember exactly what it said. C When I try to connect to the mysql server (mysql -u root -p table), C I get an error about /tmp/mysql.sock. C I've searched both http://lists.mysql.com/ and C http://www.mysql.com/manual.php using the available search functions, C and leafed through Paul's mysql book and can't find it, which drives C me bats because I KNOW I've seen it somewhere C Anyway, what is the problem here? Do I have to take it down and start C it up again? I'm pretty sure the problem is that the file has been C deleted, probably a cron job, but I can't remember the fix. Tried C touching it to make it exist again, but of course no go. C (And a pointer to the documentation would be welcomed, too...) Is your MySQL server really running? Check your /etc/my.cnf file for line 'socket=...'. Did you use configure option '--with-unix-socket-path=...' or you have installed a binary version? That will be useful to refer to: http://www.mysql.com/doc/P/r/Problems_with_mysql.sock.html and http://www.mysql.com/doc/C/a/Can_not_connect_to_server.html C Thanks, C --Cindy -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
fatal: libncurses.so.5
michael.s, Wednesday, February 06, 2002, 12:22:15 PM, you wrote: msÉ Hi, msÉ I just installed mysql in my Solaris (Sparc) box, but msÉ when I run mysql ( mysqld running ), I get the following msÉ err, ld.so.1: bin/mysql: fatal: libncurses.so.5: open msÉ failed: No such file or directory Killed Please, tell us more about the problem appeared. How did you install MySQL? Did you install a downloaded from the mysql site binary distributive or you have compiled the server on your own? msÉ Any help will be appreciated! -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 4.0.2 Replication Bug...
On Monday 11 February 2002 12:55 pm, Jeremy Zawodny wrote: The slave hit a duplicate key error and died. ?The IO thread appears to still be running, but the SQL thread is not. ?When I try to do a SLAVE START on the slave, the command never returns to the mysql prompt. Jeremy: First, do SHOW PROCESSLIST. Then I have a dilema - on one hand I want to see if SLAVE STOP/SLAVE START will get it going, but on the other hand, I want to see the core from the time when slave start got stuck, and we cannot do both at the same time :-) So let's try SLAVE STOP/SLAVE START, and if that does not help, kill mysqld with signal 6 ( SIGABRT), find the core file in datadir, and FTP the core and the binary to ftp://support.mysql.com/pub/mysql/secret In the mean time, I will check the code to see if I can find a bug. Your help is very much appreciated. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Request for help in testing new replication code in 4.0.2
On Sunday 10 February 2002 06:06 pm, Jeremy Zawodny wrote: One question: ? Can you explain the relay log a bit. ?Does it shrink eventually? ?I ? see it growing and growing, so I don't know if the space is ? recycled, or if I need to do something to periodically flush the ? executed queries from the log. Relay log rotates once a written event pushes it over max_binlog_size in the I/O thread, and the SQL thread deletes a processed relay log when switching to the next one. So if it works without bugs, you can just leave it unattended and it should take care of itself. Okay, a second question: ? How can I control where the relay log goes? ?I always have my binlog ? go to a special directory on a different disk from my active tables. ? I'd like to do something similar for the relay log. relay-log=/path/to/relay-log similar to log-bin= Relay log in essence is just another binary log, and most of the code is reused from the log-bin. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: LIKE work around??
MySQL doesn't support LIKE does it? I got an error when I tried. =20 -Original Message- From: Nathan [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 1:04 PM To: Rutledge, Aaron Subject: Re: LIKE work around?? Um... keep using LIKE? Just a thought... :-) - Original Message -=20 From: Rutledge, Aaron [EMAIL PROTECTED] To: Mysql List (E-mail) [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 12:56 PM Subject: LIKE work around?? I am trying to query the database for records that have the same sequence of starting characters--such as banana1 and banana2 and have a result set returned that contains everything that starts with banana. Any way to do this? I think I would use LIKE in other types of databases, but I was wondering if there was a work around for MySQL. Thanks, Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PostgreSQL
Trond Eivind Glomsr=F8d writes: Sinisa Milivojevic [EMAIL PROTECTED] writes: =20 There is a slight difference between advanced, non-standardized tuning/backup/load-balancing like that and core SQL functionality not= being present. =20 --=20 Trond Eivind Glomsr=F8d Red Hat, Inc. =20 This depends on the definition. Where do you draw your definitions from ?? And core SQL functionlity that we speak about IS present. --=20 Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]= / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: OT: *nix text editor?
Heh. I keep getting answers, after all this time. See below for how I solved it. Background: I had a 1.5 gig flatfile, consisting of all the data from two databases. I had neglected to put 'use database' lines in it, so I couldn't simply load it back into MySQL. I had to add one line at the beginning, and one line somewhere in the middle. Or so I thought. Here's what I did. Step 1: Use 'more' to find what line number the info for the second DB started on. Step 2: Use 'head' to grab the first n lines of the file, up to where the second DB started, and pipe the output to a second file. I now have the first DB in it's own file. Step 3: Use 'tail' to grab the last n lines of the file, to get the second DB. Also pipe this to a file. Now I have each DB in it's own file. Step 4: Upload each file on it's own into the server, telling the mysql client what DB to send the data too. Done. And all without adding any lines. Maybe this will help someone else in the future who is in the same situation. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Thomas Spahni [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 5:25 AM To: Matthew Walker Cc: [EMAIL PROTECTED] Subject: Re: OT: *nix text editor? On Mon, 4 Feb 2002, Matthew Walker wrote: I need to find a text editor for Linux that doesnt load the whole file into memory. I need to edit a 1.5 gig text flatfile to add two lines. But I dont have enough ram to open it in most programs. Can anyone recommend something? man sed Rather obscure at the beginning but does the job. (Filter: MySQL database table query) Thomas Spahni - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.323 / Virus Database: 180 - Release Date: 2/8/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
Re: LIKE work around??
Rutledge, Aaron writes: MySQL doesn't support LIKE does it? I got an error when I tried. I use it all the time. Maybe post the error message you got. RLIKE on the other hand...sigh. --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Load_File issue
At 4:22 +0800 2/7/02, yue cheng wrote: Hi, Now I am puzzled by the filepath,Load_file, I install MySQL in Windows98, the file which i want to insert to table is c:\P1.bmp when I run load_file in mysql command line,it succeeds mysql insert into blobtable (load_file(/P1.bmp)) but i don't know why i should use slash instead of backslash on windows. if i use the absolute path load_file(c:\P1.bmp), the blob field in table is NULL Try doubling the backslash. MySQL interprets as an escape character in strings, so it's necessary to double it to specify a literal backslash. I also run insert into blobtable (load_file(/P1.bmp))in mysqlgui,it also insert null to table. i run this query in my Visual basic, same problem. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: long query on php
There is no limit on the size of strings in PHP. Follow this link for more info: http://www.php.net/manual/en/language.types.string.php Brett Original Message Follows From: savaidis [EMAIL PROTECTED] To: 'Johnny Withers' [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: long query on php Date: Thu, 7 Feb 2002 22:29:47 +0200 The obious question is: (before I test it) This is concatenation to $query that is a string type, no? So the limit isn't also set to 255 chars too? Or is a trick especially for this case? Makis -Original Message- From: Johnny Withers [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 7:36 PM To: [EMAIL PROTECTED] Subject: RE: long query on php Or you could do it like this: $query=some query .some more of this query .still some more query .and so on and so forth...; ; The tabs are no needed, I just put them there to make it easy to understand that all those lines are actually just one line. - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Brett Burgess [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 11:25 AM To: [EMAIL PROTECTED] Subject: Re: long query on php Here is how I do it: $query = some query ; $query.=some more of the same query ; $query.=still more query ; $query.=and so on... ; $rst = mysql_query($query); NOTE: you need to add a space at the end of each line (after the last word and before the closing quotations) if you plan on continuing the query on the next line, or else your SQL will be invalid. Good luck, Brett Original Message Follows From: savaidis [EMAIL PROTECTED] To: MySQL list \(E-mail\) [EMAIL PROTECTED] Subject: long query on php Date: Wed, 6 Feb 2002 21:13:44 +0200 How is possible to pass a long query to MySQL server with php? I mean i.e a create table statement with more than 400 chars. Have I to use shorter create and then alter? Thanks Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Join the world's 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 _ 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 planning, concepts
Think of the binary log as just a long binary data stream, which simply happens to be in a series of files. Each slave has a position in that binary stream, which is expressed as a filename and file position. Each slave has (potentially) a different position in the stream, and therefore a different file and different position in that file. The current log is only relevant to the master, as in which log file its writing to. Each slave will have its own idea of what the current log file is, based on where it is in the stream. The CHANGE MASTER TO command simply instructs the slave to start at position X in the binary stream, which has to correspond to the point that the snapshot was made for that particular slave. Each slave can have a different snapshot, and a different starting point in the stream. You can take a new snapshot at any time and simply start a slave at the current point in the stream (show master status displays this), which makes it relatively easy to add a new slave to a set. The best way to do this is: master_mysql flush tables with read lock; master_mysql show master status; copy files to slave slave_mysql change master to values from show master status master_mysql unlock tables; This is also a good way to re-sync a slave if it crashes and corrupts its tables. james montebello On Thu, 7 Feb 2002, Mark M. Ito wrote: MySQL folks, I am planning on using MySQL replication to mirror a database at various far-flung locations. I'm anticipating that there might be a handful of slaves, but they will only come on every few months. In that scenario, the last slave will have a lot of catching up to do if all slaves are started from the same snapshot. It's conceivable that this process extends over years. In planning this, the following related questions occur to me while reading the manual: Can slave start from a binary log that is not the current log? Does a slave always start from the beginning of the current binary log? In the CHANGE MASTER TO command, what is the interpretation of the value of MASTER_LOG_POS? I. e., how does one know what number to provide here? Any help would be appreciated. -- Mark -- Mark M. Ito, Thomas Jefferson National Accelerator Facility 12000 Jefferson Ave., Mail Stop 12H, Newport News, VA 23606 Email: [EMAIL PROTECTED], Phone: (757)269-5295 WWW: http://claspc2.jlab.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to access MySql using Perl. Help
Hello, I am new to MySql. I have MySql installed in my Linux PC. How do I connect to MySql using Perl script and assign the result of a query to an array? Where could I find a sample code? Thank you. Andy _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Load_File issue
First off, you trying to insert the image into the database or just its path? -Original Message- From: yue cheng [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 06, 2002 2:23 PM To: [EMAIL PROTECTED] Subject: Load_File issue Hi, Now I am puzzled by the filepath,Load_file, I install MySQL in Windows98, the file which i want to insert to table is c:\P1.bmp when I run load_file in mysql command line,it succeeds mysql insert into blobtable (load_file(/P1.bmp)) but i don't know why i should use slash instead of backslash on windows. if i use the absolute path load_file(c:\P1.bmp), the blob field in table is NULL I also run insert into blobtable (load_file(/P1.bmp))in mysqlgui,it also insert null to table. i run this query in my Visual basic, same problem. _ Do You Yahoo!? µ½ÊÀ½ç±Ö÷Ì⹫԰ÍæÒ»Í棬ӮȡÊÀ½ç±ÃÅƱÀÖÒ»ÀÖ¡£ http://cn.worldcup.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Distributed Fulltext?
I second the question. It could also reduce the size of the fulltext index and the time taken to update it. -steve On Thursday 07 February 2002 20:53, Brian wrote: Has anyone made a suggestion or thought about ways to distribute databases which focus on fulltext indexes? fulltext indexes do a good job of indexing a moderate amount of data, but when you get a lot of data to be indexed, the queries slow down significantly. I have an example table, with about 90 million rows.. and has a fulltext index on a varchar(100) field. A single-word query which would return approx 300k results takes an average of 15 seconds. A query with smaller results (~ 10k) can be as quick as 1 sec.. which I would consider acceptable. Has any thought about splitting the data into distributed files or even machines? ie: something as simple as 'words' starting with 'X' are split into a-h, i-p, q-z... or something more advanced? (maybe mysqld could automatically split results based on (#results per unique 'word' / desired # of 'split files/machines') Would such a system give any advantages to searching speed and concurrenct query scalability? I haven't looked at the fulltext internals.. so I don't know if such query routing could take place or not. If nothing else, does anyone else have experience with a table of this size or even larger? What kind of tuning have you done? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PHP - MySQL - SQL7 Server - Visual Basic.
Hi Bob, Hi, I currently have a very large MS SQL7 database that I need to put on the web. My plan is to use PHP and MySQL to accomplish this. Currently I have a Visual Basic front end on the MS SQL7 Server. I would like to have my VB program write The MS SQL7 server data to a MYSql database and then have PHP read and display the MySql database on a web page. I am new to PHP and MySql so some idea's, samples, pro's or con's would be appreciated. =if you are converting, why not use SQL to 'export' the data from SQL-Server, and import it into MySQL? =Or do you mean that the web front-end is only for users to view the data, but that all updating transactions will be carried out through some VB-based system, and that you are contemplating having two databases/RDBMS-es? =Please clarify, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 File Size
Hi! From http://www.innodb.com/ibman.html : MySQL/InnoDB-3.23.44, November 2, 2001 You can define foreign key constraints on InnoDB tables. An example: FOREIGN KEY (col1) REFERENCES table2(col2). You can create 4 GB data files in those file systems that allow it. Thus 4 G files should be available also on 4.0.1. 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 Gurupartap Davis wrote in message ... I'm using MySQL 4.0, trying to set up some innodb tables with several 20GB data files, but mysql is telling me that the files must be = 4096MB This is on a RedHat 7.2 box with redhat's 2.4.9-13 enterprise kernel on a reiserfs filesystem... I don't think there should be such a low limit...I accidentally made a 9GB log file the other day. Is this a limit of innodb? Is there somewhere I can adjust this limit? Thanks -Partap Davis Syncrasy, LLC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and views
MYSQL sql,query is anybody know when suppost to be support to views ? |\_.._/| | o o | (=T=) ^'-^-'^. '. ; .' | | | | | ((_((|))_)) Best Regards from the Cat Noam Cassif([EMAIL PROTECTED]) Raz Systems LTD http://www.raz.co.il - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to sum() with php query?
I have a column of amounts that was getting adding in a loop but I see there's a sum() function to do this. Should have known. But I can't make it work. Can someone give me a simple query syntax using php? TIA Floyd -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 sum() with php query?
On Thu, 7 Feb 2002 19:54:51 -0600, you wrote: At 19:53 -0500 2/7/02, Floyd Baker wrote: I have a column of amounts that was getting adding in a loop but I see there's a sum() function to do this. Should have known. But I can't make it work. Can someone give me a simple query syntax using php? The SQL SUM() function has nothing to do with PHP. SELECT SUM(some_numeric_column) FROM tbl_name is one example of how it works. That I know. I have your book in my hand... But I'm not able to make it work from a php script. By php syntax I mean something like your example on page 360 using count(). I'm replacing it with sum(). $result = mysql_query( select SUM('cost') from $table); if($row = mysql_fetch_array($result)) print RESULT = $row(0); I get result = array(0)... Can you tell me what's wrong? Thanks much. Floyd -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 to MSActiveDirectory
I would like to authenticate my IntrAnet users against our Microsoft Active Directory database. Has someone done this before? How would I connect MySQL to the AD? Thanks -Allen --- [This E-mail has been scanned for viruses and is clean] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQL RE: insertion problem !!
hi, I have two tables as : please concentrate on domain_id and INDEX Create table ls_domain ( domain_id INT(4) UNSIGNED AUTO_INCREMENT , domain_addr VARCHAR(80), domain_name CHAR(50) UNIQUE KEY, domain_port INT(6) UNSIGNED, domain_ip VARCHAR(15), created_by VARCHAR(40), created_date DATE, PRIMARY KEY (domain_id) ) TYPE=3DInnoDB; I have created and inserted values in it then.. Create table ls_user ( user_id INT(4) UNSIGNED AUTO_INCREMENT , domain_id INT(4), INDEX do_id (domain_id), user_name VARCHAR(30) UNIQUE KEY, user_flag CHAR(1) , user_passwd VARCHAR(8) , user_addr VARCHAR(100), user_email VARCHAR(50), created_by VARCHAR(30), created_date DATE, FOREIGN KEY (domain_id) REFERENCES ls_domain(domain_id), PRIMARY KEY (user_id) ) TYPE=3DInnoDB; It has also been created. Now when I am inserting values in ls_user it is giving error as mentioned below..( I have made sure that the value I am inserting for the 'domain_id' exists in the ls_domain table.) please tell me what could be the problem... INSERT INTO ls_user(ls_user,domain_id,user_name,user_flag,user_passwd,user_addr,user _email,created_by, created_date) VALUES(1,1,'Chetan Lavti','y','chetan','116-C,Mayur Vihar','[EMAIL PROTECTED]','Chetan Lavti','2002-02-07'); ERROR 1216: Cannot add a child row: a foreign key constraint fails Please, help me for the same... Thanks and regards, Chetan Lavti - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql and views
Noam, Wednesday, February 06, 2002, 11:37:13 AM, you wrote: NC MYSQL NC sql,query NC is anybody know when suppost to be support to views ? It will be sopported in MySQL around Version 4.1 See at: http://www.mysql.com/doc/A/N/ANSI_diff_Views.html NC Noam Cassif([EMAIL PROTECTED]) NC Raz Systems LTD -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
fatal: libncurses.so.5
Hi, I just installed mysql in my Solaris (Sparc) box, but when I run mysql ( mysqld running ), I get the following err, ld.so.1: bin/mysql: fatal: libncurses.so.5: open failed: No such file or directory Killed Any help will be appreciated! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 sum() with php query?
On Thu, 7 Feb 2002 21:07:44 -0600, you wrote: At 21:28 -0500 2/7/02, Floyd Baker wrote: On Thu, 7 Feb 2002 19:54:51 -0600, you wrote: At 19:53 -0500 2/7/02, Floyd Baker wrote: I have a column of amounts that was getting adding in a loop but I see there's a sum() function to do this. Should have known. But I can't make it work. Can someone give me a simple query syntax using php? The SQL SUM() function has nothing to do with PHP. SELECT SUM(some_numeric_column) FROM tbl_name is one example of how it works. That I know. I have your book in my hand... But I'm not able to make it work from a php script. By php syntax I mean something like your example on page 360 using count(). I'm replacing it with sum(). $result = mysql_query( select SUM('cost') from $table); if($row = mysql_fetch_array($result)) print RESULT = $row(0); I get result = array(0)... Can you tell me what's wrong? Ah. You're asking SUM() to sum the value of the string 'cost' for each row of the result set. Assuming that cost is the name of the column you want to sum, replace SUM('cost') with SUM(cost). Thanks much. Floyd Well that made sense but unfortunately it didn't work. I see that adding strings isn't too good but it's still coming up with array(0). I have another query ahead and everything works. The connection, table, etc. are ok. $query = select * from $table; $mysql_result = mysql_query($query, $mysql_link); while($row = mysql_fetch_array($mysql_result)) { $cost = $row['cost']; print brCOST = $costbr; //Prints each record's cost. } $result = mysql_query( select SUM(cost) from $table); or exit(); if($row = mysql_fetch_array($result)) print RESULT = $row(0); I've been trying lots of arrangements but nothings happening. Floyd -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 1 billion row
Hi, An int datatype takes 4 bytes and a bigint 8 bytes. . Since there is an index created with bigint it will take an additional 8 bytes for the data and some more bytes for the pointer to the table rows. Thus a bare minimum of 20+ bytes is consumed corresponding to a row of data. A billion records will then need 20+GB of FREE disk space. The database may have many other overheads, for building indexes etc. You may also check the size of the operating system files for the table and index for the space consumed for 600M row. By dividing the total space by 600,000,000 will give you the space needed for a single row of data. What is the free disk space available before inserting the data? How do you commit the data? What is the table type? Anvar. At 10:05 AM 07/02/2002 +0200, you wrote: Hi, I have been trying to build a 1 billion row database, in mysql version 3.23.47, under Suse 7.3, but failed a several times, i reached around .600.000.000 rows... The table has an int(10) unsigned and a bigint(20) field, indexed by the bigint(20) field. The hardisk is 26GB SCSI, the computer is a dual Pentium III with 1GHz, with 2GB memory I'd like to have your opinion about what should I be carefull at the table creation or mysqld settings, and how fast will be the queries in this 1 billion row and if its worth to make all in 1 table. Thank you, Magyari Istvan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Tweaking MySQL my.cnf
Hi Again, I have honed this question pretty well I think (MySQL 3.23.37): I am using large-my.cnf as my my.cnf file. It is for servers with 512 MB of RAM from what I read. On our server that has 512MB of RAM I notice in top the following: 10244 mysql 16 0 147M 147M 1684 S 0 16.7 29.2 0:08 mysqld 10260 mysql 14 0 148M 148M 1684 R 0 8.0 29.4 0:10 mysqld All instances of mysqld are using between 146-154MB of RAM each. This seems awefully large to me. Is this correct or should I be reducing the amount of RAM each child gets. James - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
SELECT query with TRIM and LIKE
Dear list, I have a telephone database which has Name as one of the fields/columns. This field contains single name e.g Robert, double names e.g Robert Downing and more than double names. I want to make a SELECT query using a form whose input name is Name i.e '$Name' against the Name field in the database. One can type a part/full of one part of the name, or part/full of two parts of a name and goes on likewise for more than double names in the input form. I believe this SELECT query is accomplished using TRIM and LIKE, something like: $query = (SELECT * from table_name where Name like '% Trim($Name) %' ); This $query is not working. Could sombody please provide me a query statement that I could use for my above requirement. Thank you so much. NOBBY - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
storage usage
Hi, I have some text file (10MB per day) might be keep for a year. I have been keep it in compress format (using WinZip). When I need to see detail I have been open it and find something I want to see. If I decide to store these text file in to BLOB field of MySQL. How do you thing about this idea? Sommai - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LIKE work around??
Umm, I take it you haven't read the documentation? MySQL fully supports LIKE. Can you tell us the error you are getting? Along with the full query? j- k- On Thursday 07 February 2002 11:11, Rutledge, Aaron wrote: MySQL doesn't support LIKE does it? I got an error when I tried. -- Joshua Kugler, Information Services Director Associated Students of the University of Alaska Fairbanks [EMAIL PROTECTED], 907-474-7601 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 sum() with php query?
On Thu, 7 Feb 2002 22:09:18 -0600, you wrote: At 22:58 -0500 2/7/02, Floyd Baker wrote: On Thu, 7 Feb 2002 21:07:44 -0600, you wrote: At 21:28 -0500 2/7/02, Floyd Baker wrote: On Thu, 7 Feb 2002 19:54:51 -0600, you wrote: At 19:53 -0500 2/7/02, Floyd Baker wrote: I have a column of amounts that was getting adding in a loop but I see there's a sum() function to do this. Should have known. But I can't make it work. Can someone give me a simple query syntax using php? The SQL SUM() function has nothing to do with PHP. SELECT SUM(some_numeric_column) FROM tbl_name is one example of how it works. That I know. I have your book in my hand... But I'm not able to make it work from a php script. By php syntax I mean something like your example on page 360 using count(). I'm replacing it with sum(). $result = mysql_query( select SUM('cost') from $table); if($row = mysql_fetch_array($result)) print RESULT = $row(0); I get result = array(0)... Can you tell me what's wrong? Ah. You're asking SUM() to sum the value of the string 'cost' for each row of the result set. Assuming that cost is the name of the column you want to sum, replace SUM('cost') with SUM(cost). Thanks much. Floyd Well that made sense but unfortunately it didn't work. I see that adding strings isn't too good but it's still coming up with array(0). The other problem is you're access the row element as $row(0). Should be $row[0]. That did it Paul... Blast I hate it when that happens... g I go blind once in awhile. I try hard to watch for that stuff too. It's amazing how some things can be so hard to see. Thanks very much for the help. It'll be flying in no time now. Floyd -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: opposite of PASSWORD('mypasswd').
in Mysql, under sql, we have the function PASSWORD('mypasswd') where we can encrpt 'mypasswd' into a 16 character scrambled word. which function in sql is used to decrypt the same and get back the original mypasswd. There is no such feature. PASSWORD like other hash passwords are one way only. This means the only way to find the actual password would be to use the PASSWORD command on the entered password and then compare that hash to the hash in the database. The system is setup like this so if someone manages to obtain a copy of your usernames and encrypted passwords on MySQL, they can't simply run a DEPASSWORD or something similar to instantly find out what the passwords are (which would then make encrypting the passwords in the first place meaningless). Sincerely, Craig Vincent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 planning, concepts
MySQL folks, I am planning on using MySQL replication to mirror a database at various far-flung locations. I'm anticipating that there might be a handful of slaves, but they will only come on every few months. In that scenario, the last slave will have a lot of catching up to do if all slaves are started from the same snapshot. It's conceivable that this process extends over years. In planning this, the following related questions occur to me while reading the manual: Can slave start from a binary log that is not the current log? Does a slave always start from the beginning of the current binary log? In the CHANGE MASTER TO command, what is the interpretation of the value of MASTER_LOG_POS? I. e., how does one know what number to provide here? Any help would be appreciated. -- Mark -- Mark M. Ito, Thomas Jefferson National Accelerator Facility 12000 Jefferson Ave., Mail Stop 12H, Newport News, VA 23606 Email: [EMAIL PROTECTED], Phone: (757)269-5295 WWW: http://claspc2.jlab.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
outer join + count() + group by
i have what is basically a personal ad database. in one table, i have a list of advertisers. in another table i have a list of reviews. (there's a third table with stuff like their name, address, etc). i want to get a list of advertisers and the number of reviews all in one query. i can do it with an inner join just fine. select ad.id,adtype,name,count(1) from person,review,ad where ad.id=review.id and ad.id=person.id group by review.id; this only selects users who have reviews though (which i understand). i want to do it with an outer join. if a user has no reviews it should put a 0 in the count column. this query gets all the usernames whether or not they have reviews, but the count column is always 1. select ad.id,adtype,name,count(1) from person review left join ad on ad.id=review.id group by ad.id; what am i missing? -jsd- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Request for help in testing new replication code in 4.0.2
On Sunday 10 February 2002 01:17 am, you wrote: I can't get it to start replicating. Note, the master (db1.tias.com) is a 3.23 server. The slave is 4.0.2 (noritake.tias.com). On the master I get: mysql show master status; +---++--+--+ | File ? ? ? ? ?| Position ? | Binlog_do_db | Binlog_ignore_db | +---++--+--+ | spode-bin.020 | 1058168617 | ? ? ? ? ? ? ?| ? ? ? ? ? ? ? ? ?| +---++--+--+ 1 row in set (0.00 sec) mysql show slave status; +-+-+-+---+-+-++---+---+--+---+-+-+++--+-+ | Master_Host | Master_User | Master_Port | Connect_retry | Master_Log_File | Read_Master_Log_Pos | Relay_Log_File ? ? ? ? | Relay_Log_Pos | Relay_Master_Log_File | Slave_IO_Running | Slave_SQL_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | Exec_master_log_pos | +-+-+-+---+-+-++---+---+--+---+-+-+++--+-+ | ? ? ? ? ? ? | ? ? ? ? ? ? | 0 ? ? ? ? ? | 0 ? ? ? ? ? ? | ? ? ? ? ? ? ? ? | 0 ? ? ? ? ? ? ? ? ? ?| noritake-relay-bin.001 | 4 ? ? ? ? ? ? | ? ? ?| No ? ? ? ? ? ? ? | No ? ? ? ? ? ? ? ?| ? ? ? ? ? ? ? ? | ? ? ?| 0 ? ? ? ? ?| ? ? ? ? ? ?| 0 ? ? ? ? ? ?| 0 ? ? ? ? ? ? ? ? ? | +-+-+-+---+-+-++---+---+--+---+-+-+++--+-+ 1 row in set (0.01 sec) and in noritake.tias.com.err: 020210 00:07:21 ?mysqld started 020210 ?0:07:21 ?Could not find first log during relay log initialization 020210 ?0:07:21 ?Warning: Can't create threads to handle slave /usr/local/libexec/mysqld: ready for connections and in /etc/my.cnf on the slave: [mysqld] replicate-ignore-table=curioscape.avstemp replicate-ignore-table=tias.avtemp replicate-ignore-table=inventory.availableQuantity replicate-ignore-table=inventory.thisItem replicate-ignore-table=inventory.auctionStatus replicate-ignore-table=inventory.itemTable master-host=db1.tias.com master-user=slave master-password=password log=db.log # master-port= server-id=2 and on the server: [mysqld] set-variable = tmp_table_size=8M set-variable = key_buffer=384M set-variable = max_allowed_packet=2M set-variable = max_connections=1024 set-variable = table_cache=8192 set-variable = thread_cache_size=32 set-variable = sort_buffer=4M set-variable = record_buffer=2M log-slow-queries log-bin server-id=1 It appears the problem is that the new replication code is using a different file name convention? This set up did work before. Until the 4.0.1 MySQL starting crashing because of a fulltext index bug that I reported earlier. Mike: Thanks for reporting the bug. To troubleshoot it, lets do the following: in slave.cc around line 186, you find the following code: if (rli-relay_log.find_first_log(rli-linfo,log)) { *errmsg=Could not find first log during relay log initialization; goto err; } make it: if (rli-relay_log.find_first_log(rli-linfo,log)) { sql_print_error(Could not find first log during relay initialization); abort(); *errmsg=Could not find first log during relay log initialization; goto err; } and then run BUILD/compile-pentium-debug and install the new binary. It will coredump when it hits the error. You will find a core file ( core.pid_of_mysql) in your datadir. FTP the core file to support.mysql.com/pub/mysql/secret along with your binary and a readme file all in a tar archive. Thanks again for your efforts to help us make MySQL 4.0 more stable. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try:
Re: Distributed Fulltext?
On Thu, 2002-02-07 at 15:40, Tod Harter wrote: [snip] Wouldn't be too tough to write a little query routing system if you are using perl. Use DBD::Proxy on the web server side, and just hack the perl proxy server so it routes the query to several places and returns a single result set. Ordering could be achieved as well. I'm sure there are commercial packages out there as well. I don't see why the individual database servers would need to do anything special. [snip] If I'm understanding you correctly, I think you're refering to routing based on the first character of the word. That would work for cases where the query is searching for a word that begins with a certain character.. however fulltext searches also return results with the term in the middle. ie: a search for 'foo' could return: foo.txt foobar but also could return: thisisfoo that_is_foolish I could be wrong, but it's my understanding that MySQL stores it's fulltext index based on all the 'unique words' found. For such a system as you mentioned above, you'd probably have to create your own fulltext indexing system to determine: a) where to store the data 'segments' and b) how to route queries. It seems like this could probably be done much more efficiently inside of the server. - Brian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Selecting Floating point numbers: Summary
Hello again, In reply to all the suggestions made, here it goes one more mail. I hope it will be helpful. (André, isto vai em ingles que é para o pessoal perceber ;) Suggestion 1: Float aren't really searchable in Mysql. You may need to do some casting, not sure how to do it on top but i remember reading from the Mysql help. Couldn't find out how :((( Suggestion 2: You forgot around temp example: mysqlselect datetime,temperatura from temperatura where datetime=2002-02-08 09:30:00 and temperatura=15.8; This does not work (I had tried this before of course). The output is an empty set :( Suggestion 3: Replace the dot for a comma. Wrongo... it does not work: mysql select datetime,temperatura from temperatura where datetime=2002-02-08 09:30:00 and temperatura=15,8; ERROR 1064: You have an error in your SQL syntax near '8' at line 1 or (to clear everything up) mysql select datetime,temperatura from temperatura where datetime=2002-02-08 09:30:00 and temperatura=15,8; Empty set (0.00 sec) Suggestion 4: 15.8 has no exact binary representation, so a test for equality will fail. Do not use floating point if you want to test for equality. Try DECIMAL Miguel, RTFM ;) DECIMAL and NUMERIC values are stored as string rather than a binary floating-point numbers, in order to preserve the decimal precision of those values. - MySQL Reference Manual 3.23.39 page 177. mysql create table temp_test (datetime datetime, temperatura DECIMAL(2,1)); mysql insert into temp_test(datetime,temperatura) values (2002-02-08 09:30:00,15.8); mysql select datetime,temperatura from temp_test where datetime=2002-02-08 09:30:00 and temperatura=15.8; +-+-+ | datetime| temperatura | +-+-+ | 2002-02-08 09:30:00 |15.8 | +-+-+ 1 row in set (0.00 sec) weee :) Suggestion 5: This is not a MySQL problem, nor a database one, but a general computer science one. It is almost never save to compare two floating point numbers for equality. The decimal representation you see in ASCII is not an exact representation but an approximation. Because of the way computers store floating point numbers in bunry and humans read them in decimal, the decimal value is alway rounded and there are invisible bits which can be different in apparently identical values. For floating point comparisons you should *always* use unequalities e.g. WHERE temp BETWEEN 15.75 AND 15.85. mysql select datetime,temperatura from temperatura where datetime=2002-02-08 09:30:00 and temperatura between 15.75 and 15.85; +-+-+ | datetime| temperatura | +-+-+ | 2002-02-08 09:30:00 |15.8 | +-+-+ 1 row in set (0.00 sec) Works : Conclusion: I think I will follow suggestion 4, and alter my table. Thank for all the help guys :) Best wishes, Miguel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 4.X
Hi. I have been awayv for a while. I see that 3.23 is still listed as the current distribution version. When might one expect that 4.X will be released as a production version? MySQL, versions - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Static or Dynamic rows -- which is faster?
On Mon, Feb 11, 2002 at 04:48:10PM -0600, David Felio wrote: Whoops, originally sent this to just Heikki. On Monday, February 11, 2002, at 12:12 PM, Heikki Tuuri wrote: for InnoDB 'dynamic rows', that is, rows where you define char columns as VARCHAR, are faster because tables and indexes fit in smaller space. Is there reasoning specific to InnoDB? Sort of. It's because InnoDB stores the data and indexes together. (BDB does something similar.) Dynamic tables would be smaller regardless of the table type, I would think. True. In Kaj Arno's talk on optimizing MySQL at the O'Reilly Open Source Convention last year, he said that fixed tables are preferable and that if you must have dynamic columns, you should try to put them in a table separate from your static columns (slides 67 and 68 for those who have them). Has this changed? Nope, not for MyISAM it hasn't changed. With fixed rows, tables can be checked, repaired, and accessed more quickly. If you know the row size, you know how to get to row 500,123 quickly. It's just multiplication. But if the row sizes are all different, you have to scan the rows before it. (This is an over-simplification, but hopefully gets the point across.) Plus, if you have fixed rows and no holes in the table, you can INSERT and SELECT at the same time. :-) So, Kaj's talk is right on. Going to the conference again this year? There's gonna be some cool MySQL stuff again this year. 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.47-max: up 4 days, processed 162,876,748 queries (418/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
MySQL Question
Hi there, I have installed MySQL 3.23.37-sun-solaris2.7-sparc. Some times the server starts and when i try to connect it using my password it hangs. It doesn't allow me in. Neither does it say anything about the password or about the connection. How do i solve this. This is the second time it is happening to me. The first time it happenend it automatically got rectified after a few days. It is strange... Regards, Hari ---\ Hariprasad N Davanagere 1007 Bolling Ave, Apt 49 Norfolk, Va -23508 (h) (757) 489 8839 (c) (757) 348 3647 ---\ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Distributed Fulltext?
Also, I have to ask the question: Why is it that Altavista can index terabytes overnight and return a fulltext boolean for the WHOLE WEB within a second, and Mysql takes so long? On Friday 08 February 2002 11:50, Steve Rapaport wrote: I second the question. It could also reduce the size of the fulltext index and the time taken to update it. -steve On Thursday 07 February 2002 20:53, Brian wrote: Has anyone made a suggestion or thought about ways to distribute databases which focus on fulltext indexes? fulltext indexes do a good job of indexing a moderate amount of data, but when you get a lot of data to be indexed, the queries slow down significantly. I have an example table, with about 90 million rows.. and has a fulltext index on a varchar(100) field. A single-word query which would return approx 300k results takes an average of 15 seconds. A query with smaller results (~ 10k) can be as quick as 1 sec.. which I would consider acceptable. Has any thought about splitting the data into distributed files or even machines? ie: something as simple as 'words' starting with 'X' are split into a-h, i-p, q-z... or something more advanced? (maybe mysqld could automatically split results based on (#results per unique 'word' / desired # of 'split files/machines') Would such a system give any advantages to searching speed and concurrenct query scalability? I haven't looked at the fulltext internals.. so I don't know if such query routing could take place or not. If nothing else, does anyone else have experience with a table of this size or even larger? What kind of tuning have you done? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PostgreSQL
On Wed, Feb 06, 2002 at 06:49:02PM +0200, Sinisa Milivojevic wrote: Trond Eivind Glomsrød writes: Vernon A Webb [EMAIL PROTECTED] writes: Anyone know the difference between MySQL and PostgreSQL? PostgreSQL has a lot of features MySQL don't have yet (transactions everywhere, foreign keys, subselects, stored procedures, triggers, etc), while MySQL is heavily optimized for handling big loads of simple SQL. Sorry Trond, But MySQL has transactions and foreign keys. For the rest you are correct, unless you do not count myperl as stored procs. To his credit, he said transactions everywhere. MySQL has transactions for specific table handlers, not everywhere. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 2 days, processed 100,359,170 queries (475/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: How to sum() with php query?
At 22:58 -0500 2/7/02, Floyd Baker wrote: On Thu, 7 Feb 2002 21:07:44 -0600, you wrote: At 21:28 -0500 2/7/02, Floyd Baker wrote: On Thu, 7 Feb 2002 19:54:51 -0600, you wrote: At 19:53 -0500 2/7/02, Floyd Baker wrote: I have a column of amounts that was getting adding in a loop but I see there's a sum() function to do this. Should have known. But I can't make it work. Can someone give me a simple query syntax using php? The SQL SUM() function has nothing to do with PHP. SELECT SUM(some_numeric_column) FROM tbl_name is one example of how it works. That I know. I have your book in my hand... But I'm not able to make it work from a php script. By php syntax I mean something like your example on page 360 using count(). I'm replacing it with sum(). $result = mysql_query( select SUM('cost') from $table); if($row = mysql_fetch_array($result)) print RESULT = $row(0); I get result = array(0)... Can you tell me what's wrong? Ah. You're asking SUM() to sum the value of the string 'cost' for each row of the result set. Assuming that cost is the name of the column you want to sum, replace SUM('cost') with SUM(cost). Thanks much. Floyd Well that made sense but unfortunately it didn't work. I see that adding strings isn't too good but it's still coming up with array(0). The other problem is you're access the row element as $row(0). Should be $row[0]. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: LIKE work around??
input is SELECT dog_name FROM hold_tbl WHERE dog_name RLIKE ^sam[0123456789]* ORDER BY dog_name (and then printing out each of the matches made) Sam Sam4 Sam5 Sammie6 Sammy7 Sampson2 Samson Samuel As I understand it, only the first three should have matched. Actually, as I really understand it none of them should have matched because REGEXP/RLIKE are case sensitive searches. It makes no difference if I use REGEXP instead of RLIKE. Also, I couldn't find any indication that mysql's regexp understood [0-9] as opposed to [0123456789], am I correct? Again, it makes no difference if I try that notation. Thanks, The query you want is dog_name RLIKE ^sam[0123456789]*$ Each of the above matches sam at the beginning folowed by ZERO or more numbers. If you put a $ at the end. It anchors to the end of the string like ^ anchors to the beginning. --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: long query on php
Just a comment: Doing so it's possible to insert a line between $query.. statements. (comments ecc) Its very simple to write it with copy+paste and I prefer this. Thanks. PS. I'll check the string limit and I let you know. I think it has to be the 64KB. I think only Visual Basic has this high limit, no? Makis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 3:03 AM To: Nathan Cc: MySQL Subject: Re: long query on php Hi. I prefer doing like this $query = CREATE TABLE query ; $query .= tabledef for col a,; $query .= tabledef for col b,; $query .= lots more table defs,; $query .= welcome to line 400; You get the point i guess you can do same things many different ways in php:) /PM\ Alex Aulbach wrote: Yesterday, from Nathan: Since PHP ignores whitespace, I think this is also acceptable: PHP doesn't ignore whitespace in a quote. But your code is of course correct. $query = CREATE TABLE query tabledef for col a, tabledef for col b, lots more table defs, . welcome to line 400; Another way: (without test) $bladefault=24; $query = eoq; CREATE TABLE query ( idchar(2) default 24 # doublequotes work hugo char(2) default '24' # singlequotes work either bla char(2) default '$bladefault' # inline vars work ... ) eoq -- How is possible to pass a long query to MySQL server with php? I mean i.e a create table statement with more than 400 chars. Have I to use shorter create and then alter? Strings in PHP can be really, really long and are binary safe. Perhaps the problem is the editor? -- SSilk - Alexander Aulbach - Herbipolis/Frankonia Minoris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB foreign keys crash MySQL
(MySQL 4.0.1-alpha-Max-log, your Linux binary) The following works fine (just a slight variation of what is in the manual): CREATE TABLE t1 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ) TYPE=InnoDB; CREATE TABLE t2 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, t1id INT UNSIGNED NOT NULL, PRIMARY KEY (id), KEY (t1id), FOREIGN KEY (t1id) REFERENCES t1(id) ) TYPE=InnoDB; The following, however, crashes MySQL: CREATE TABLE t1 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ) TYPE=InnoDB; CREATE TABLE t2 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, t1id INT UNSIGNED NOT NULL, PRIMARY KEY (id), KEY (t1id), FOREIGN KEY (t1id) REFERENCES t1(id) ) TYPE=InnoDB; CREATE TABLE t3 ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, t2id INT UNSIGNED NOT NULL, PRIMARY KEY (id), KEY (t2id), FOREIGN KEY (t2id) REFERENCES t2(id) ) TYPE=InnoDB; The log file says: InnoDB: foreign constraint creation failed; InnoDB: internal error number 17 InnoDB: Assertion failure in thread 45067 in file dict0crea.c line 1241 InnoDB: We intentionally generate a memory trap. InnoDB: Send a detailed bug report to [EMAIL PROTECTED] mysqld got signal 11; I can send you the stack trace if necessary. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: triming white space from a TEXT column
At 16:17 -0800 2/6/02, Richard Reina wrote: I am trying to trim both leading and trailing whitespace from a TEXT column in my SELECT query. I found the TRIM() command in the manual, however, I can't get it to act upon a column name instead of an actual string. Can anyone help? If you just say TRIM(col_name) it will return the trimmed column value, but it won't change the column itself. Try updating the column to its trimmed value: UPDATE tbl_name SET col_name = TRIM(col_name); Thanks, Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
my.cnf
Demirchyan, Thursday, February 07, 2002, 8:39:05 PM, you wrote: DOA There used to be a section in mysql documentation, which explained about all the DOA entries in my.ini file. Do you know what happened to it? DOA There is a part about my.cnf but that's not what I want. There was more. Look at: http://www.mysql.com/doc/O/p/Option_files.html You can refer to: http://www.mysql.com/doc/C/o/Command-line_options.html and http://www.mysql.com/doc/S/e/Server_parameters.html -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: regarding mysql DATE support
Hi Prabhu, Select cols from tbl where datecolumn date_add(datevar, interval 1 day); A look at Date and time functions of the manual would do good. But you originally asked about sys_date (is it not sysdate pseudocolumn). Regards, Anvar At 04:49 PM 07/02/2002 +0530, you wrote: i am asking regarding a query . select DATE from table name where DATE NEXT DAY(DATE). like this . could u write the query for me . - Original Message - From: Anvar Hussain K.M. [EMAIL PROTECTED] To: SNPrabhu [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, February 07, 2002 PM 04:29 Subject: Re: regarding mysql DATE support Hi, Now(), sysdate(). Anvar. At 03:02 PM 07/02/2002 +0530, you wrote: Hai , is there any support of sys_date in mysql which is strong feature in oracle 8.x . i am using MYSQL 3.23 server version . With Warm Regards [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: long query on php
Yesterday, from Nathan: Since PHP ignores whitespace, I think this is also acceptable: PHP doesn't ignore whitespace in a quote. But your code is of course correct. $query = CREATE TABLE query tabledef for col a, tabledef for col b, lots more table defs, . welcome to line 400; Another way: (without test) $bladefault=24; $query = eoq; CREATE TABLE query ( idchar(2) default 24 # doublequotes work hugo char(2) default '24' # singlequotes work either bla char(2) default '$bladefault' # inline vars work ... ) eoq -- How is possible to pass a long query to MySQL server with php? I mean i.e a create table statement with more than 400 chars. Have I to use shorter create and then alter? Strings in PHP can be really, really long and are binary safe. Perhaps the problem is the editor? -- SSilk - Alexander Aulbach - Herbipolis/Frankonia Minoris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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