Any function to convert string to integer?
Hi all. Anybody knows a function or some way to convert a string to a integer? I've looked in the manual and I haven't seen anything. I need it to order a query by a column which contains numbers but the type of the column is varchar. I want to convert the values to integer before ordering the query. Iago. __ mensaje enviado desde http://www.iespana.es emails (pop)-paginas web (espacio illimitado)-agenda-favoris (bookmarks)-foros - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: myisampack dumps core on some tables
On Wed, 29 Aug 2001, Sasha Pachev wrote: On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote: Description: I have on Linux running 3.23.41 the following problem: $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp /data/mysql/Aactinomycetemcomitans/blimps.MYI Compressing /data/mysql/Aactinomycetemcomitans/blimps.MYD: (1443 records) - Calculating statistics normal: 7 empty-space: 0 empty-zero: 0 empty-fill: 7 pre-space: 0 end-space: 3 intervall-fields: 0 zero: 1 Original trees: 16 After join: 9 - Compressing file Segmentation fault (core dumped) $ gdb /usr/local/mysql/bin/myisampack ./core [...] Core was generated by `/usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp /data/mysql/Aactinomycet'. Program terminated with signal 11, Segmentation fault. #0 0x400f00d5 in ?? () (gdb) where #0 0x400f00d5 in ?? () #1 0x8050557 in compress_isam_file () #2 0x804e18c in compress () #3 0x804d4b4 in main () #4 0x400b3a42 in ?? () (gdb) quit $ The calling perl script reports as an error value in $! Illegal seek. It happens to me with 3 table-types: Packing blast Aactinomycetemcomitans failed: Illegal seek Packing blimps Aactinomycetemcomitans failed: Illegal seek Packing rep Aactinomycetemcomitans failed: Illegal seek Packing rep Aeropyrum_pernix_K1 failed: Illegal seek Packing rep Anabaena failed: Illegal seek Packing rep Aquifex_aeolicus_VF5 failed: Illegal seek Packing rep Archaeoglobus_fulgidus failed: Illegal seek Packing rep Athaliana_I failed: Illegal seek May I upload you some tables? ;-) Go ahead. For future refrence, if you can type How-to-repeat with good instructions after that, write directly to [EMAIL PROTECTED] Look in pub/mysql/secret for myisampack_failing.tgz . It contains I hope representative sample of our failing tables, i.e. not all of them, but all table-types are included. -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics http://mips.gsf.de GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Hot Backups
Matthew Walker ([EMAIL PROTECTED]) writes: What's the best way of doing a hot backup on a database? Our server is set up in such a way that it's not a simple matter to shut down apache/mysql and do the backup then. So, is it safe to just copy the mysql directories, or is there some recommended procedure for this? RTFM, RTFM, RTFM! That being said, most everyone I know uses mysqldump for hot backups. Now, STOP what you're doing and go bookmark http://www.bitbybit.dk/mysqlfaq/faq.html, if you have time to do nothing else - this is Carsten Pederson's *excellent* MySQL FAQ. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help Urgent!!!
Hello... I got a big problem in MYODBC. I am using myodbc-2.50.31-win95. When I use any MySQL Administrator to query the database that I had created for example:- SELECT * FROM dbname, they come out error like:= Your command could not be completed. MySQL returned the following error: Got error 127 from table handler. There is an error too if I format my PC and reinstall all over again. So, can I know what is going on? Can you me and give me instruction to overcome this problem. Thanks. From Eugene
Re: Help Urgent!!!
Eugene wrote: Hello... I got a big problem in MYODBC. I am using myodbc-2.50.31-win95. When I use any MySQL Administrator to query the database that I had created for example:- SELECT * FROM dbname, they come out error like:= Your command could not be completed. MySQL returned the following error: Got error 127 from table handler. There is an error too if I format my PC and reinstall all over again. So, can I know what is going on? Can you me and give me instruction to overcome this problem. Thanks. That means that the table has crashed. Repair it with command: repair table dbname; -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58) 5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Reply-to and this list
A quick question: How come the mailing list software doesn't add a reply-to header? Is this intentional to keep replies off the mysql list, and if so why? I'll try to remember to reply to the list rather than directly to the people who ask the questions, as replying in private does little to stop the same questions from reappearing, and if there's something this list has too much of it's the same questions over and over... :-o //Círdan -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Index Create Speed
Dear List, I have a (standard table handler ) table defined as follows : CREATE TABLE fact0 ( d0keyINTEGER, d1keyINTEGER, d2keyINTEGER, val INTEGER, filler VARCHAR(200) ); I then LOAD 300 rows into it ( about 350Mb) This takes about 2m30s on my ( fairly old ) hardware ( I think this is quite fast ). Distribution wise the d0key values are loaded in order. there are 300 distinct d0keys, 300 distinct d0keys and 100 distinct d2keys. The next step is creating an index as follows : CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ; Whichunfortunatly takes about 20m ( which I think is a bit slow ) Here is my relevant .cnf configuration : ( I am using 3.23.39 compiled from source with gcc 2.96 on Mandrake 8.0 ) [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=100 set-variable= sort_buffer=10M set-variable= join_buffer=16M set-variable= record_buffer=5M set-variable= myisam_sort_buffer_size=32M set-variable= thread_cache=8 any suggestions ? ( as I would love to create indexes faster ! ) regards Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Primary Key pairs and auto-incrementing
On 29-Aug-01, Paul DuBois wrote: Create a single PRIMARY KEY that consists of the two columns chapter and section, and make section an AUTO_INCREMENT column. When you insert rows, set chapter to the proper chapter number and section to NULL. This will cause MySQL to generate independent sequences for each chapter. (In essence, you have multiple sequences within the same table.) This requires that you have MySQL 3.22.25 or later. That's when this feature was introduced. That's odd. There's nothing about it in the changelog for 3.22.25 in the documentation, and the only reference to this behavior I've been able to find in the manual is this (from the chapter on MyIsam): Note that when an AUTO_INCREMENT is defined on the end of a multi-part-key the old behavior is still present. I hate having to ask for this, but could you please point me to the chapter in the manual where this is discussed? I just can't seem to find it. :-P //C -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thanks!
Hi all, On the subject of licensing: I've seen the discussions around this topic and would like to approach it from another angle. Until recently I were a student and if it weren't for the free distribution of mySQL I would have had problems. On the other hand I will be the first to - as soon as my budget allow - pay to get the added resources, I think it's only fair to the developers and us. It will also allow them to keep developing / maintain mySQL to its current standard. Thank you all at mySQL for the great product. I am new to mySQL but like it alot. Regards Joyce - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
database location
hy, i want to set up a apache web server with mysql database connection for different users which should have their databases in their homedirectories. for ex: user x use .jsp to write data from forms in a mysql database - for ex: homedir: /home/x/htdocs but the mysqldatabases are by default in /usr/local/mysql/var is it possible do configure mysql to create the databases in each users homedirectory ?? are there any solutions ? thomas m. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
discussion: mysql licensing issue and funding issues
Hi! Neil == Neil Zanella [EMAIL PROTECTED] writes: Neil I would like to comment on the following mysql.com question Neil We have made our product available at zero price under the GNU Neil General Public Licence (GPL), and we also sell it under a commercial Neil licence to those who do not wish to be bound by the terms of the GPL. Neil Out of curiosity, how does the second statement Neil not violate the GNU GPL? It seems like the GPL Neil can be bypassed by keeping two identical copies Neil of the source code, one under the GNU GPL bundled Neil with the GNU licence file called COPYING, and Neil another bundled with a proprietary license file. Neil Since the two source files can be considered as Neil being updated separately the two licenses can Neil be kept alive concurrently. This approach which Neil as I see it is perfactly legal (as long as it Neil is made clear which is the GPL'd release and Neil which is the proprietary release on the download Neil section of the mysqld.com web site) can lead Neil to forking. In particular, contributions made Neil to the GPL'd source code cannot be applied to Neil the proprietary source code unless the contributor Neil explicitly states that the contribution goes Neil to both the GPL'd software release and the Neil proprietary source code simultaneously. cut How we do it here at MySQL (And according to what I know, this is identically to how FSF does it): All files in the MySQL distribution that is part of the core MySQL server clearly states that MySQL AB has the copyright to this file. Patches that are emailed to us for these files that just cover a few lines are not considered 'copyrightable work' and can thus be applied both to the GPL and proprietary version of MySQL. (See http://www.gnu.org/software/gcc/contribute.html for details about this) In other words, we don't have to change the copyright text of the file just because someone asks us to do a small change to the file. For larger patches we ask the author for a copyright assignment/shared copyright before applying the patch (just like FSF does). Another issue is that most patches, from outside sources, that goes into the core server are rewritten by me to be more in line with the rest of the MySQL code. For source that doesn't affect the core MySQL server (like the InnoDB or Gemini table handler or patches to the MySQL clients) we don't require a copyright assignment. cut Neil I do not believe that the mysql.org folks have the Neil experience to improve on mysql otherwise they would Neil have started theirsql from scratch. For this very Neil reason I would urge mysql.com and mysql.org to come Neil to some compromise that would avoid the uglyness of Neil what I deem as unnecessary code forking. Let us not Neil have two separate code versions of mysql. Neil Let us all cooperate. The main problem with mysql.org is that it clearly violates our trademark and other rights. If we would accept mysql.org we would put our trademark on risk and this could seriously affect our future possibilities to do business. Another problem with mysql.org is that this is driven by NuSphere, who don't have any rights to copy, modify or distribute MySQL (because they have violated the MySQL GPL license). This also makes it hard for us to work together with them. We have also tried to talk with NuSphere to solve our issues but so far in vain. During the two talks we have had with NuSphere after mysql.org was launched they have just said they are note authorized to talk about anything that is mentioned in the lawsuits (like the usage of mysql.org). It's a little hard to sort out things when one of the parties refuses to talk about the main issues at hand. Neil Also, how is mysql.org's funding strategy any better Neil than mysql.com? The two parties should perhaps merge. Neil Having two mysql's will simply weaken mysql's Neil popularity if there is no cooperation among Neil the two parties. I personally don't see any need for a mysql.org; This site doesn't provide anything important that mysql.com doesn't or couldn't provide. I you want us to help avoid confusion, I would urge you to help us to change those few links that are still pointing at mysql.org to point to mysql.com. Regards, Monty CTO of MySQL AB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Index Create Speed
Mark kirkwood ([EMAIL PROTECTED]) writes: CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ; Whichunfortunatly takes about 20m ( which I think is a bit slow ) Have you tried building the table structure with the index already in place, then importing the data? -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqldump issues
daniel james ([EMAIL PROTECTED]) writes: I need to generate a tab-delimited text dump of table data ONLY and have it output to a text file. I don't want any table info, delimiters, etc. I need this to copy/paste into a excel spreadsheet. What's the syntax? I'm stuck here: % mysqldump dbname tablename ??? Easier: echo select * into outfile 'tablename.tsv' from tablename|mysql dbname -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Index Create Speed
Mark kirkwood wrote: Dear List, I have a (standard table handler ) table defined as follows : CREATE TABLE fact0 ( d0keyINTEGER, d1keyINTEGER, d2keyINTEGER, val INTEGER, filler VARCHAR(200) ); I then LOAD 300 rows into it ( about 350Mb) This takes about 2m30s on my ( fairly old ) hardware ( I think this is quite fast ). Distribution wise the d0key values are loaded in order. there are 300 distinct d0keys, 300 distinct d0keys and 100 distinct d2keys. The next step is creating an index as follows : CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ; Whichunfortunatly takes about 20m ( which I think is a bit slow ) Here is my relevant .cnf configuration : ( I am using 3.23.39 compiled from source with gcc 2.96 on Mandrake 8.0 ) [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=16M set-variable= max_allowed_packet=1M set-variable= table_cache=100 set-variable= sort_buffer=10M set-variable= join_buffer=16M set-variable= record_buffer=5M set-variable= myisam_sort_buffer_size=32M set-variable= thread_cache=8 any suggestions ? ( as I would love to create indexes faster ! ) regards Mark Hi, Try with a bigger key_buffer. You will get better performance if key_buffer is greater than your index. Regards -- Joseph Bueno NetClub/Trader.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: Use of the MySQL logo - licensing agreement
Van writes: I'm also advertising for MySQL all over my site with the original logo. Do I need to remove it? I'd rather not, since it's just a link to point people to a valuable resource. Is my site violating the terms of the trademark? Van -- = Linux rocks!!! http://www.dedserius.com/ = Hi Van! You do not have to do anything right now. Our people responsible for this issue are trying to come out with something that would both please MySQL community and protect us from some sharks out there. I guess that you know what I am talking about. After a new policy comes out, usage of logo should be much clearer. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Index Create Speed
Hi! On Aug 30, Mark kirkwood wrote: Dear List, I then LOAD 300 rows into it ( about 350Mb) This takes about 2m30s on my ( fairly old ) hardware ( I think this is quite fast ). CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ; Which unfortunatly takes about 20m ( which I think is a bit slow ) any suggestions ? ( as I would love to create indexes faster ! ) I doubt you can do it much faster, but here're some hints: Be sure that SHOW PROCESSLIST during index creation shows repair by sort not repair with keycache. Increase myisam_max_sort_file_size otherwise. The most important parameter for repair by sort is myisam_sort_buffer_size. The more, the better. Most of other variables don't matter here. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problems getting into MySQL.com
Philip Daggett writes: Is anybody else not able to get onto mysql.com??? There were some temporary problems with firewall. It should be OK by now. -- 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
Replication: Push by Master or Pop by Slaves ?
There is an issue that confuse me a bit, altough it is not important for an operational point of view: From the manual: The master server keeps a binary log of updates and an index file to binary logs to keep track of log rotation. The slave, upon connecting, informs the master where it left off since the last successfully propagated update, catches up on the updates, and then blocks and waits for the master to notify it of the new updates. So, it seems that is the master that pushes information to the slave(s) But I can also read: MySQL replication is based on the server keeping track of all changes to your database (updates, deletes, etc) in the binary log and the slave server(s) reading the saved queries from the master server's binary log so that the slave can execute the same queries on its copy of the data. Here, seems that are the slaves that pop data from master. So where is the truth ? Is the master that pushes or the slaves the pops ? Or it is a combination of the two ? Thanks. -- Claudio Cicali aka FleXer [EMAIL PROTECTED] http://www.flexer.it GPG Key Fingerprint = 2E12 64D5 E5F5 2883 0472 4CFF 3682 E786 555D 25CE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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@lists.mysql.com: Re: Re: Replication: Push by Master or Pop by Slaves ?]
On Thu, Aug 30, 2001 at 12:44:46PM +0200, Claudio Cicali wrote: [snip] Here, seems that are the slaves that pop data from master. So where is the truth ? Is the master that pushes or the slaves the pops ? Or it is a combination of the two ? In normal operation, the master pushes to the slave. When a slave is turned off temporarily and is turned back on, it pops all changes that happened while it was down. After that, the master starts pushing again. Magic 5 letter word: MySQL. Tsk. Greetz, Peter -- Monopolyhttp://www.dataloss.nl/monopoly.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Replication: Push by Master or Pop by Slaves ?
On Thu, Aug 30, 2001 at 12:44:46PM +0200, Claudio Cicali wrote: Here, seems that are the slaves that pop data from master. So where is the truth ? Is the master that pushes or the slaves the pops ? Or it is a combination of the two ? It's a pull mechanism... The slave simply contacts the master and waits for updates to come down the channel. But the slave is in control of which updates it handles, etc. And the master actually has no idea who its slaves are. 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 0 days, processed 602,992 queries (192/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqld as root
Ken Menzel writes: Wasn't there something awhile back that was supposed to prevent running the daemon as root? When the daemon was started through safe_mysqld it would tell you to select a user as root you had to use --user=root, this seems to be gone! from the manual: F.2.26 Changes in release 3.23.15 To start mysqld as root, you must now use the --user=root option. This does not seem to be true (tested on freebsd 3.23.41 etc), the reason I have a problem with this is I am getting some files owned by root, which is a problem if someone restarts mysql as safe_mysqld. I am adding the user to my.cnf to avoid this, but it does seem to confict with the manual unless I missed a change note to remove that feature! Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] Seems that you are right !! We would either have to change a code or docs -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Use of the MySQL logo - licensing agreement
Sinisa Milivojevic wrote: Van writes: I'm also advertising for MySQL all over my site with the original logo. Do I need to remove it? I'd rather not, since it's just a link to point people to a valuable resource. Is my site violating the terms of the trademark? Van -- = Linux rocks!!! http://www.dedserius.com/ = Hi Van! You do not have to do anything right now. Our people responsible for this issue are trying to come out with something that would both please MySQL community and protect us from some sharks out there. I guess that you know what I am talking about. After a new policy comes out, usage of logo should be much clearer. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Sinisa: I've never had a doubt about the integrity of the MySQL AB approach to such issues, nor this one. Thank you for confirming my assumption that MySQL AB is maintaining a responsible approach in addressing this issue amid shark-infested waters. As always, I offer my full support and endorsement of MySQL AB, Monty's efforts and the MySQL Team for continued support and development of the superior Database for UNIX/Linux/Windows Internet developers. Best Regards, Van -- = Linux rocks!!! http://www.dedserius.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: myisampack dumps core on some tables
Hi! Sasha == Sasha Pachev [EMAIL PROTECTED] writes: Sasha On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote: Description: I have on Linux running 3.23.41 the following problem: $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp Sasha /data/mysql/Aactinomycetemcomitans/blimps.MYI Compressing /data/mysql/Aactinomycetemcomitans/blimps.MYD: (1443 records) - Calculating statistics normal: 7 empty-space: 0 empty-zero: 0 empty-fill: 7 pre-space: 0 end-space: 3 intervall-fields: 0 zero: 1 Original trees: 16 After join: 9 - Compressing file Segmentation fault (core dumped) cut Thanks Martin for the test case; It enabled me to quickly find the bug. Here is a patch for this (This will be in 3.23.42) = myisam/myisampack.c 1.9 vs edited = *** /tmp/myisampack.c-1.9-8558 Wed Aug 22 01:45:03 2001 --- edited/myisam/myisampack.c Thu Aug 30 14:09:40 2001 *** *** 251,257 static void print_version(void) { ! printf(%s Ver 1.9 for %s on %s\n,my_progname,SYSTEM_TYPE,MACHINE_TYPE); } static void usage(void) --- 251,257 static void print_version(void) { ! printf(%s Ver 1.10 for %s on %s\n,my_progname,SYSTEM_TYPE,MACHINE_TYPE); } static void usage(void) *** *** 1670,1676 max_calc_length+=huff_counts[i].tree-height; else if (huff_counts[i].field_type == FIELD_BLOB || huff_counts[i].field_type == FIELD_VARCHAR) ! max_calc_length=huff_counts[i].tree-height*huff_counts[i].max_length + huff_counts[i].length_bits +1; else max_calc_length+= (huff_counts[i].field_length - huff_counts[i].max_zero_fill)* --- 1670,1676 max_calc_length+=huff_counts[i].tree-height; else if (huff_counts[i].field_type == FIELD_BLOB || huff_counts[i].field_type == FIELD_VARCHAR) ! max_calc_length+=huff_counts[i].tree-height*huff_counts[i].max_length + huff_counts[i].length_bits +1; else max_calc_length+= (huff_counts[i].field_length - huff_counts[i].max_zero_fill)* Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: fulltext indexes for innodb?
Hi! On Aug 30, Alexander wrote: Hello, mysql team! Any chance (in the near future) to get FullText indexing working with innodb table handler? Alexander I doubt it will be done it the near future (unless a customer would like to pay for the feature, of course). Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Thanks!
Joyce Vermeulen writes: Hi all, On the subject of licensing: I've seen the discussions around this topic and would like to approach it from another angle. Until recently I were a student and if it weren't for the free distribution of mySQL I would have had problems. On the other hand I will be the first to - as soon as my budget allow - pay to get the added resources, I think it's only fair to the developers and us. It will also allow them to keep developing / maintain mySQL to its current standard. Thank you all at mySQL for the great product. I am new to mySQL but like it alot. Regards Joyce On the behalf of MySQL AB, thank you for your kind words. -- 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
Syntax Question: deleting previous duplicate entries
hi, i've got a table collecting info from html forms. problem is, certain wiseguys always make multiple entries. could someone clue me in to how i can select the Last entry where there is a duplicate for the User (type text, these are email addresses), and automatically delete any previous entries? i'm using a column 'id' int auto_increment as my index: the last entry from a User will automatically have a higher id #. example: i've only gotten this far: this selects all users with multiple entries SELECT * from table_name GROUP BY User HAVING Count(User) 1 thanks muchly, tom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Syntax Question: deleting previous duplicate entries
Tom Churm ([EMAIL PROTECTED]) writes: hi, i've got a table collecting info from html forms. problem is, certain wiseguys always make multiple entries. could someone clue me in to how i can select the Last entry where there is a duplicate for the User (type text, these are email addresses), and automatically delete any previous entries? i'm using a column 'id' int auto_increment as my index: the last entry from a User will automatically have a higher id #. Try looking at the excellent MySQL FAQ! Here's a link that may help: http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_8_0 :) -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
stopwords
Is there any way to remove the treatment of words three letters and under being treated as a stopword when performing a query of a full text index on a table. If it is a recompile of MySQL is there a good resource on how to do this... I'm a newbie to the world of compiling MySQL thanks Chris Dr Christopher Thorpe Information Architect GenomeBiology - biology for the post-genomic era w http://www.genomebiology.com t +44 (0) 20 7631 9184 (direct) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: need help with select statements
On Thursday 30 August 2001 15:28, Andre Konopka wrote: Hi, I have, three tables (one,two, three) with the rows id/value. id is the key for all the tables. with select value from one where id=xx; select value from two where id=xx; select value from three where id=xx; I can select all values from the tables with the id=xx. How can I do this with one select statement. Notice, it's possible that there is an entry for id=xx in table one, but not in table two, or three. Of course ist's possible that there is only a value in table three. The output could be id one.value two.value three.value x1 233 2342 NULL x2 NULL 998NULL x3 33 232 23 Clear enough? A couple of LEFT JOINs should probably do the trick HTH Ian Barwick -- Ian Barwick - Developer - [EMAIL PROTECTED] akademie.de asp GmbH - http://www.akademie.de To query tables in a MySQL database is more fun than eating spam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQLGUI file save function
I am using MySQLGUI 1.7.5-1 on Windows 2000. When I save a query result to a file it seems to save it as a Hex output. Is this what is supposed to happen? Can this be used to backup a database? Thanks in advance. Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Use of the MySQL logo - licensing agreement
Van writes: Sinisa: I've never had a doubt about the integrity of the MySQL AB approach to such issues, nor this one. Thank you for confirming my assumption that MySQL AB is maintaining a responsible approach in addressing this issue amid shark-infested waters. As always, I offer my full support and endorsement of MySQL AB, Monty's efforts and the MySQL Team for continued support and development of the superior Database for UNIX/Linux/Windows Internet developers. Best Regards, Van -- = Linux rocks!!! http://www.dedserius.com/ = Thank you Van ! -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Use of the MySQL logo - licensing agreement
And then there's the sad situation I'm in. I'm using MySQL to do a site for the U.S. Army, but I am not allowed to put the logo up as it would be considered an endorsement of a commercial product, which is a major no-no. And I'd like so much to do it. I'm thinking of a way, but I'll have to consult Legal to see if I'm okay (contact/about this site page with logo, and with required disclaimer that we don't endorse, etc.). Frank. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
order by number
When doing a select with an order by clause, how do you make mysql list the items in correct numberical order. Normally, when I run the command mysql will list 1000 before 200 because of the initial digit. How do I correct this? Thanks, Phil Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQLGUI file save function
Jeff Isom writes: I am using MySQLGUI 1.7.5-1 on Windows 2000. When I save a query result to a file it seems to save it as a Hex output. Is this what is supposed to happen? Can this be used to backup a database? Thanks in advance. Jeff It will save query results in a file in escaped form. For backup use mysqldump or mysqlhotcopy or BACKUP TABLE command. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Disappeared
Hi Van, If you don't give drop privileges how can the user drop tables? Is there a way to give just drop table privileges, because 'drop' will let you drop tables and the database? If so I missed it and would be very happy to know how to do this, as I would feel a little better about that as well, Ideally I would only want to be allow the user to drop temp tables (in my case). Ken - Original Message - From: Van [EMAIL PROTECTED] cut If yes, and yes, then your user dropped the db. Bummer. You should NEVER give drop db privileges to anyone. Not even yourself. :) Van - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 number
If the column is an int then it will order it numerically. Other wise you have to cast it. And dont for get the difference between ORDER BY x ASC and ORDER BY x DESC. --Bill DROP TABLE IF EXISTS test; CREATE TABLE test ( i int, c char(20)); INSERT INTO test VALUES ( 1, '5' ), ( 2, '4' ), ( 3, '3' ), ( 4, '2' ), ( 5, '1' ), ( 1, '5' ); SELECT '-- Natural Order'; SELECT * FROM test; SELECT '- ORDER by INT'; SELECT * FROM test ORDER BY i; SELECT '- ORDER BY cast char-- '; SELECT *, ( c + 0) AS o_col FROM test ORDER BY o_col; Philip Montgomery wrote: When doing a select with an order by clause, how do you make mysql list the items in correct numberical order. Normally, when I run the command mysql will list 1000 before 200 because of the initial digit. How do I correct this? Thanks, Phil Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Bill Adams TriQuint Semiconductor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Licensing terms for an Intranet site
-- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 Is anyone else getting a strange flag associated with Jeremy's email, or is it just me? Every one of his posts comes in flagged in Outlook, and the headers have a line which reads: X-message-flag: Mailbox corrupt. Please upgrade your mail software. This is definitely OT for this forum, but this forum is the only place where I see the problem. Jay database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Remote Users
Mike writes: I'll probably get brow beat for this but hey the coffee has not kicked in yetg How to I allow connections from remote clients? I lost my note but I thought it was GRANT ALL PRIVILEGES ON *.* TO [EMAIL PROTECTED]; The rights are high but this is the example I seen somewhere. Mine keeps saying host@dsl-boi-111-111-111-1 not allowed to connect I am using MySQLFront client. Thanks M;) Quote of the day; Instead of having answers on a math test, they should just call them impressions, and if you got a different impression, so what, can't we all be brothers? - Jack Handey Either grant privileges to user@% or insert that host into host table and reload privileges. -- 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
Db maintenance
Is there anything I need to be doing maintenance wise on a mysql database? I have inherited one that was installed as follows As far as database stuff that we do, we basically installed the server, set up databases and tables, and use them. Indices have been created on many of the tables to speed up access times. It is being replicated to another server continuously. In particular mysqldump, mysqladmin, optimize, mysqlcheck, etc. Thanks. April Sims MCSE, CNE Abilene Christian University OCP 8i DBA ACU Box 29005 Information Technology Abilene, TX 79699 [EMAIL PROTECTED] Vx:(915)674-2681 Fx:674-6724 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQLGUI file save function
I am fairly new to MySQL and I am unfamiliar with the term escaped form. Can anyone point me to documentation that explains what that is and how it can be used. Also, I am trying to perform a backup remotely. My understanding is that the mysqldump and mysqlhotcopy commands can only be used on the local machine. Is this correct? What is the best way to perform a backup remotely. Thanks, Jeff - Original Message - From: Sinisa Milivojevic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 9:29 AM Subject: Re: MySQLGUI file save function Jeff Isom writes: I am using MySQLGUI 1.7.5-1 on Windows 2000. When I save a query result to a file it seems to save it as a Hex output. Is this what is supposed to happen? Can this be used to backup a database? Thanks in advance. Jeff It will save query results in a file in escaped form. For backup use mysqldump or mysqlhotcopy or BACKUP TABLE command. -- 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
Precision of Scientific Notation
For a float column, is there any way to change the decimal precision for scientific notation returned from a select statement? For instance, a select statement currently returns 1.19573e+06 although the actual value is 1.195731e+06. Also, is there any way to prevent MySQL from using scientific notation for float columns in a select statement? Thanks, George Essig - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Licensing terms for an Intranet site
Hi Jay, I'd definitely suspect Outlook (or LOOKOUT! as a few of my network support buddies call it) as the source of the problem, rather than anything to do with Jeremy's emails. I'm having no problems here -- but then again, I don't use any Microsoft products. : Good luck, /Rob As Rob Glaser, a former Microsoft exec, told Time magazine last year, Gates is relentless. He's Darwinian. He doesn't look for win-win situations with others, but for ways to make others lose. Success is defined as flattening the competition, not creating excellence. Ob. MySQL: database, sql, query, table Is anyone else getting a strange flag associated with Jeremy's email, or is it just me? Every one of his posts comes in flagged in Outlook, and the headers have a line which reads: X-message-flag: Mailbox corrupt. Please upgrade your mail software. This is definitely OT for this forum, but this forum is the only place where I see the problem. Jay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Replication
Has anyone tested dropping a master database? I have dropped the master database that was replicating just to see how it would affect the slave. The slave kept its data. What would the proper proceedure be in this case? I wouldnt be able to snapshot the slave and then port the snapshot back into the master, the bin logs would be messed up then. If I was replicating multiple databases on the master (bin logging multiple databases) and I had a slave only replicating one of those databases, I wouldnt be able to just remove all the bin logs and start the process over again without losing the rest of the replicated databases. A note: Nothing occurs in the error log or in SHOW MASTER STATUS on the master when a database is dropped that it is supposed to be replicating. Does it not realize that the database is not there? If I was only replicating one database (bin logging one database), could I just port in a copy from the slave, remove the bin logs and index(or modify it in some way) from the master, do something with the master.info on the slave and then let it go from there? Has anyone ever been through this scenario? (Luckily I am only testing these things and I am not on a live database!) Luc Foisy Technical Magic Corporation 1 Stafford Road, Suite 325, Nepean, Ontario, K2H 1B9 Phone: (613) 829-7117 Fax: (613) 596-5096 E-Mail: [EMAIL PROTECTED] Fulfilling the Promise of Technology - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Db maintenance
April Sims ([EMAIL PROTECTED]) writes: Is there anything I need to be doing maintenance wise on a mysql database? I have inherited one that was installed as follows As far as database stuff that we do, we basically installed the server, set up databases and tables, and use them. Indices have been created on many of the tables to speed up access times. It is being replicated to another server continuously. In particular mysqldump, mysqladmin, optimize, mysqlcheck, etc. We don't do anything here. Every now and then the server gets rebooted for one reason or another (every 45-60 days), and either isamchk -r -e -s -o -f or myisamchk -r gets run, followed by optimize table commands on some of the most updated tables. -- Ed Carp, N7EKG - [EMAIL PROTECTED] - 214/341-4420 - http://www.pobox.com/~erc Squished Mosquito, Inc. Internet Applications Development Escapade Server-Side Scripting Language Development Team http://www.squishedmosquito.com Pensacola - Dallas - Dresden - London - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error adding tables, databases, or records
Benjamin Krajmalnik wrote: I have a deployment of mySQL 3.23.26-beta running on FreeBSD 4.2-RELEASE. I am running 3 databases off of a single mySQL server. In one particular database I am unable to insert records - the process just hangs. My intuition would tell me that maybe something is corrupted in the index. Since I have no problem whatsoever selecting records from the database, I thought I would create a new table with the same schema and copy the records over. HOWEVER, although I am logged in as root and root has full priviledges in the user table, I am unable to either create new databases or add new tables. This is getting extremely frustrating. Below is a sample of the results: mysql use aplcore Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql create table test (ID int); ERROR 3: Error writing file './aplcore/test.frm' (Errcode: 28) mysql I have set the access rights for the aplcore directory under mySQL to 776 to make sure it was not an access issue. Any help will be deeply appreciated - this needs to be resolved ASAP. Also, I am logged in as the superuser account. Hi, $ perror 28 Error code 28: No space left on device Have you checked disc space ? Regards -- Joseph Bueno NetClub/Trader.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Error adding tables, databases, or records
OK. I tracked the problem to being out of disk space in the var partition. The default source installation plaved the data in the /var/db directory. The var partition is not that large by default, and therefore I am now out of space. I would like to move the data to a /usr/local/mysql/data directory. What is the proper process to do this by? Is moving the data to that directory and changing the datadir location in safe_mysqld sufficient? Any help will be deeply appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error adding tables, databases, or records
perror 28 Error code 28: No space left on device Benjamin Krajmalnik wrote: I have a deployment of mySQL 3.23.26-beta running on FreeBSD 4.2-RELEASE. I am running 3 databases off of a single mySQL server. In one particular database I am unable to insert records - the process just hangs. My intuition would tell me that maybe something is corrupted in the index. Since I have no problem whatsoever selecting records from the database, I thought I would create a new table with the same schema and copy the records over. HOWEVER, although I am logged in as root and root has full priviledges in the user table, I am unable to either create new databases or add new tables. This is getting extremely frustrating. Below is a sample of the results: mysql use aplcore Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql create table test (ID int); ERROR 3: Error writing file './aplcore/test.frm' (Errcode: 28) mysql I have set the access rights for the aplcore directory under mySQL to 776 to make sure it was not an access issue. Any help will be deeply appreciated - this needs to be resolved ASAP. Also, I am logged in as the superuser account. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[OT] Old sources
Hi all, I hate to bring this up in the group, but I haven't found an answer on the site. I've got mysql-3.23.30-gamma-unknown-freebsdelf4.2-i386.tar.gz installed, but I need to recompile a little differently. My problem is that I can't find this version in source. Can anybody tell me where I can find this version in source? --- Rodney Broom Programmer: Desert.Net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Licensing terms for an Intranet site (way beyond OT)
i think this is jeremy's not-so-subtle way of bashing your choice of email client. check this link: http://www.rodos.net/outlook/#messageflag -ravi. Yeah, yeah - I got it. Only problem is that I DON'T have a choice (company policy et al)... \:^{ Jay Fesco Magical Mystery Words: database,sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
newbie password issue
now i changed the root password just fine but now i have to enter it every time i run mysqladmin even mysqladmin version reqires a -p tell me there's a simpler way - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: newbie password issue
now i changed the root password just fine but now i have to enter it every time i run mysqladmin even mysqladmin version reqires a -p tell me there's a simpler way http://www.mysql.com/doc/C/o/Connecting.html * You can specify connection parameters in the [client] section of the `.my.cnf' configuration file in your home directory. The relevant section of the file might look like this: [client] host=host_name user=user_name password=your_pass - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_connect () and mysql_pconnect are not recognized ! Pls help.
Hi, I'm running mysql MAX 3.23.41 on LinuxPPC, everything was installed from an RPM. My problem is whenever I try to call mysql_connect (), from a php3 script, I got the error function not found or misconfigured The script is a simple form, that passes the data to be added to an empty database, with an empty table, both the MySQL server and Apache reside on the same machine, and because it's just a test, I'm entering as root. I am developing a more complex script , but I need to solve the connection problem first BTW ifyou define a var $link = mysql_connect ( localhost ) or ; , which is the correct syntax ? localhost or 'localhost' ? Why is the command failing ??? From the console it works BTW The server is on a static IP without a DNS, is it correct to set mysql_connect (xxx.xxx.xxx.xxx) or ('xxx.xxx.xxx.xxx' when you are running as localhost Thank you Regards, Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: order by number
What about a number field w/zero fill? On Thu, 30 Aug 2001, Adams, Bill TQO wrote: Date: Thu, 30 Aug 2001 08:48:11 -0700 From: Adams, Bill TQO [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: order by number If the column is an int then it will order it numerically. Other wise you have to cast it. And dont for get the difference between ORDER BY x ASC and ORDER BY x DESC. --Bill DROP TABLE IF EXISTS test; CREATE TABLE test ( i int, c char(20)); INSERT INTO test VALUES ( 1, '5' ), ( 2, '4' ), ( 3, '3' ), ( 4, '2' ), ( 5, '1' ), ( 1, '5' ); SELECT '-- Natural Order'; SELECT * FROM test; SELECT '- ORDER by INT'; SELECT * FROM test ORDER BY i; SELECT '- ORDER BY cast char-- '; SELECT *, ( c + 0) AS o_col FROM test ORDER BY o_col; Philip Montgomery wrote: When doing a select with an order by clause, how do you make mysql list the items in correct numberical order. Normally, when I run the command mysql will list 1000 before 200 because of the initial digit. How do I correct this? Thanks, Phil Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Bill Adams TriQuint Semiconductor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 (command line program) enhancement request
I use MySQL a number of different ways: the C API, from PHP, from the command line, and often from shell scripts run by other users or from crontab entries. The latter two uses present a couple of problems that could be fixed easily through some minor changes to the code for the mysql program (mysql.cc). I'd like to see the following 2 changes: (1) Blank out the password in the environment variables while running for security. Otherwise, on any system where one can run a ps command (most Unix derivatives), any user can easily see the password when it is given on the command line to the '-p' argument. As there is no other reasonable way to provide the password, this is a common problem. The C/C++ code to do this is simple, small and efficient. (2) When running in a batch mode, one usually wants to know if the command worked or not. The default is to tell the user absolutely nothing (example 1 below). Adding the '-v' (verbose) flag gets the user some feedback -- the SQL that was submitted -- but says nothing about success (example 2 below). Adding a second 'v' (-vv) adds the results of the command to the feedback (example 3 below). This seems completely backwards. I know what SQL I submitted; I want to know if it worked. I'd like to see the meaning of the '-v' and '-vv' flags reversed, giving the results with the first 'v', and then echoing the SQL along with the results with the second 'v'. Example 1: 49 hostname:~ mysql -pmypass -e 'Update foo Set val = 1 Where id = 1;' temp 50 hostname:~ Example 2: 50 hostname:~ mysql -v -pmypass -e 'Update foo Set val = 1 Where id = 1;' temp -- Update foo Set val = 1 Where id = 1 -- 51 hostname:~ Example 3: 51 hostname:~ mysql -vv -pmypass -e 'Update foo Set val = 1 Where id = 1;' temp -- Update foo Set val = 1 Where id = 1 -- Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 Bye 52 hostname:~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MERGE TABLES
I have been playing around with merge tables. You MUST have the columns and indexes in the same order. Eg. Do SHOW INDEX FROM real_table; SHOW INDEX FROM merge_table; If the Column_name order is different you will get either no records or a bunch of null records when you select on a column that is indexed. b. Sergei Golubchik wrote: Hi! On Aug 29, Johnny Withers wrote: I'm not sure if this is a bug or if this is the way MERGE TABLES works in MySQL. It seems that if I have an INDEX in a field (id for instance), and I try to SELECT using a WHERE id=NUMBER, it will fail, even though that NUMBER is a valid id. ID is an int unsigned field with a key on it. However, when I drop the key, everything works as expected.. Is this a bug? (also if I tried to ORDER BY id, while indexed, that didn't work either) Both look like a bug. Could you create a repeatable test case ? Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Bill Adams TriQuint Semiconductor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Virtualizing MySQL
Hi all, I am in the process of creating a Virtual Server - and pretty much all aspects have been completed to my liking. This includes web / mail / ftp and ssh. The next hurdle is virtualizing MySQL, and I would like to do this by sharing the same MySQL server across multiple chrooted clients. This way, they can have unlimied databases / tables under their userID without looking at, or disrupting, any of the other clients in their chroot. I am also rather new to this, so please feel free to point me to a URL which may help. I've tried though - couldn't find anything relevant to my cause. I appreciate your time. Cheers, Mustafa. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Storing the mysql data in a different location
Hello everyone!! I am installing the latest rpm for mysql 3-23.41 on a RedHat 7.1 box and want the datadir to be /data/mysql/data. In my /etc/my.cnf file I have the directive: [mysqld] datadir=/data/mysql/data The installation completes but the daemon won't start. I do the mysql_install_db command and the requisite tables are installed in my new data directory, the message states that it is starting with the data in the new directory, then the server stops and the error message from the error log is : /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) This file in fact exists in the new data directory as well as the /var/lib/mysql directory. Does anyone know how to do this correctly?? Thanks, Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select without taking all items
Webmaster Odell wrote: Hi I am trying to write a query that pulls all the items from a database except two here is what I am using: $query = 'SELECT DISTINCT Type FROM Products WHERE Type != System, Upgrade'; This populates the drop down box with all including the System and Upgrade. What do I have to do to make this work? Thanks Kevin Try with the query SELECT DISTINCT Type FROM Products WHERE Type 'System' AND Type 'Upgrade' Bye Fabio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MERGE TABLES
Well, I don't know if you can specify what order to put these in, but mine just happen to not be in the same order: mysql show index from all_records; ++-+--+-+---+--- --+--++ | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | ++-+--+-+---+--- --+--++ | 1 | catalog_key |1 | catalog | A | NULL | NULL | NULL | | 1 | id_key |1 | id | A | NULL | NULL | NULL | ++-+--+-+---+--- --+--++ 2 rows in set (0.00 sec) mysql show index from data1[,2,3,4,5]; ++-+--+-+---+--- --+--++ | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | ++-+--+-+---+--- --+--++ | 0 | PRIMARY |1 | id | A | 93 | NULL | NULL | | 1 | catalog_key |1 | catalog | A | NULL | NULL | NULL | ++-+--+-+---+--- --+--++ As you can see, the data1,2,3,4,5 tables that make up the 'all_records' table have a primary key defined on ID. I was unable to define the ID field in my merged table as primary because it has to be non_unique. This may have caused the problem. Maybe making the id columns in data1,2,3,4,5 a normal key instead of PIMARY will solve the problem. (Filter : MySQL,database,SQL,etc) - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adams, Bill TQO Sent: Thursday, August 30, 2001 1:11 PM To: Sergei Golubchik Cc: Johnny Withers; Mysql-List Subject: Re: MERGE TABLES I have been playing around with merge tables. You MUST have the columns and indexes in the same order. Eg. Do SHOW INDEX FROM real_table; SHOW INDEX FROM merge_table; If the Column_name order is different you will get either no records or a bunch of null records when you select on a column that is indexed. b. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MERGE TABLES
Monty helped me with this, and this is my understanding. Regardless of what order you generate the keys, MySQL puts the primary key first, then the UNIQUE keys, then the others. When you add a new UNIQUE key, it puts it after the primary key but before the other existing UNIQUE keys. In your case you have only non-UNIQUE keys in the merge table so you just need to add them in the same order as is in the dataN tables and MySQL will maintain the order: ALTER TABLE all_records DROP INDEX id_kex, DROP INDEX catalog_key; ALTER TABLE all_records ADD INDEX id_key (id_key), ADD INDEX catalog_key (catalog_key); --Bill Johnny Withers wrote: Well, I don't know if you can specify what order to put these in, but mine just happen to not be in the same order: mysql show index from all_records; ++-+--- --+-+---+--- --+--++ | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | ++-+- +-+---+--- --+--++ | 1 | catalog_key |1 | catalog | A | NULL | NULL | NULL | | 1 | id_key |1 | id | A | NULL | NULL | NULL | ++ +--+-+---+--- --+--++ 2 rows in set (0.00 sec) mysql show index from data1[,2,3,4,5]; ++-+--- --+-+---+--- --+--++ | Non_unique | Key_name| Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | ++-+- +-+---+--- --+--++ | 0 | PRIMARY |1 | id | A | 93 | NULL | NULL | | 1 | catalog_key |1 | catalog | A | NULL | NULL | NULL | ++ +--+-+---+--- --+--++ As you can see, the data1,2,3,4,5 tables that make up the 'all_records' table have a primary key defined on ID. I was unable to define the ID field in my merged table as primary because it has to be non_unique. This may have caused the problem. Maybe making the id columns in data1,2,3,4,5 a normal key instead of PIMARY will solve the problem. (Filter : MySQL,database,SQL,etc) - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adams, Bill TQO Sent: Thursday, August 30, 2001 1:11 PM To: Sergei Golubchik Cc: Johnny Withers; Mysql-List Subject: Re: MERGE TABLES I have been playing around with merge tables. You MUST have the columns and indexes in the same order. Eg. Do SHOW INDEX FROM real_table; SHOW INDEX FROM merge_table; If the Column_name order is different you will get either no records or a bunch of null records when you select on a column that is indexed. b. -- Bill Adams TriQuint Semiconductor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Enabling Logging of Slow Queries
I have tried to enable slow query logging for a couple days now, with no success. I have tried adding the line to the my.cnf file as well as stoppign the service then starting it with the command line version. Both ways, the server refuses to restart. I have checked the syntax over and over and I think I have it correct! [mysqld] log-slow-queries=/root/slow-queries.log and /etc/usr/bin/safe_mysqld --log-slow-queries=/root/slow-queries.log Either way, the server will not start. I take the line out and it works again. What am I doing wrong? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [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
COUNTNULL function
Evening Gurus, I have a small problem that I've beaten to death the past 2 days. I am trying to get the value of a row, and update another table accordingly. The data within the row is either a 1 or 0. My issue is in trying to increment a count for both 1's and 0's. In other words, I want to SUM up all the 1's and update a table with this sum. I also want to sum up all the 0's and add this total count to the table as well. This can be accomplished in a long query, or in through a language..what I am trying to accomplish is to get the total sum of each value without using a WHERE clause. Something akin to: SELECT ... SUM(bool_was_connected), COUNTNULL(bool_was_connected), etc... the SUM will sum up all non-null values. The COUNTNULL would sum up all rows which have a value of 0. Does anyone have a UDF for this function? I currently don't have room on my laptop to download the mysql source code in order to write this up. ( Also have not written a udf for mysql up to this point either) Thankyou kindly for any reply, Calvin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Storing the mysql data in a different location
Unfortunately, when you moved the directories, you forgot to make mysql the owner of the new directory. chown -R mysql /data/mysql Philip Daggett wrote: Hello everyone!! I am installing the latest rpm for mysql 3-23.41 on a RedHat 7.1 box and want the datadir to be /data/mysql/data. In my /etc/my.cnf file I have the directive: [mysqld] datadir=/data/mysql/data The installation completes but the daemon won't start. I do the mysql_install_db command and the requisite tables are installed in my new data directory, the message states that it is starting with the data in the new directory, then the server stops and the error message from the error log is : /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) This file in fact exists in the new data directory as well as the /var/lib/mysql directory. Does anyone know how to do this correctly?? Thanks, Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: COUNTNULL function
SELECT SUM( bool_was_connected=1 ) AS was_connected, SUM( bool_was_connected=0 ) AS was_not_connected, etc... b. [EMAIL PROTECTED] wrote: Evening Gurus, I have a small problem that I've beaten to death the past 2 days. I am trying to get the value of a row, and update another table accordingly. The data within the row is either a 1 or 0. My issue is in trying to increment a count for both 1's and 0's. In other words, I want to SUM up all the 1's and update a table with this sum. I also want to sum up all the 0's and add this total count to the table as well. This can be accomplished in a long query, or in through a language..what I am trying to accomplish is to get the total sum of each value without using a WHERE clause. Something akin to: SELECT ... SUM(bool_was_connected), COUNTNULL(bool_was_connected), etc... the SUM will sum up all non-null values. The COUNTNULL would sum up all rows which have a value of 0. Does anyone have a UDF for this function? I currently don't have room on my laptop to download the mysql source code in order to write this up. ( Also have not written a udf for mysql up to this point either) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Virtualizing MySQL
Two problems. The clients don't have access to the databases, the server does. Chrooted clients will not be able to read and write the named pipe unless it is in their new root structure. Mustafa Hashmi wrote: Hi all, I am in the process of creating a Virtual Server - and pretty much all aspects have been completed to my liking. This includes web / mail / ftp and ssh. The next hurdle is virtualizing MySQL, and I would like to do this by sharing the same MySQL server across multiple chrooted clients. This way, they can have unlimied databases / tables under their userID without looking at, or disrupting, any of the other clients in their chroot. I am also rather new to this, so please feel free to point me to a URL which may help. I've tried though - couldn't find anything relevant to my cause. I appreciate your time. Cheers, Mustafa. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: COUNTNULL function
Thankyou kindly Bill. Just to verify, SUM adds up values. My data is only 1 or 0. I used SUM as an example, the below query you recommend will count all 'rows' which are 0, thus returning a number which represents how many 0's were found? Thankyou for the fast reply, Calvin On Thu, 30 Aug 2001, Adams, Bill TQO wrote: SELECT SUM( bool_was_connected=1 ) AS was_connected, SUM( bool_was_connected=0 ) AS was_not_connected, etc... b. [EMAIL PROTECTED] wrote: Evening Gurus, I have a small problem that I've beaten to death the past 2 days. I am trying to get the value of a row, and update another table accordingly. The data within the row is either a 1 or 0. My issue is in trying to increment a count for both 1's and 0's. In other words, I want to SUM up all the 1's and update a table with this sum. I also want to sum up all the 0's and add this total count to the table as well. This can be accomplished in a long query, or in through a language..what I am trying to accomplish is to get the total sum of each value without using a WHERE clause. Something akin to: SELECT ... SUM(bool_was_connected), COUNTNULL(bool_was_connected), etc... the SUM will sum up all non-null values. The COUNTNULL would sum up all rows which have a value of 0. Does anyone have a UDF for this function? I currently don't have room on my laptop to download the mysql source code in order to write this up. ( Also have not written a udf for mysql up to this point either) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: COUNTNULL function
Calvin, Maybe I'm just confused (fairly likely), but it appears that you are confusing 'null' with zero. If you actually want to count all values including nulls, COUNT(*) will do it. If you want to count NON nulls, COUNT(a_field_name) does it. SUM(a_field_name) returns the sum of all non-null values for a_field_name. Appropriate WHERE, IN, or NOT IN clauses combined with a version of the COUNT and/or SUM functions should give you the results you need. Jay Evening Gurus, I have a small problem that I've beaten to death the past 2 days. I am trying to get the value of a row, and update another table accordingly. The data within the row is either a 1 or 0. My issue is in trying to increment a count for both 1's and 0's. In other words, I want to SUM up all the 1's and update a table with this sum. I also want to sum up all the 0's and add this total count to the table as well. This can be accomplished in a long query, or in through a language..what I am trying to accomplish is to get the total sum of each value without using a WHERE clause. Something akin to: SELECT ... SUM(bool_was_connected), COUNTNULL(bool_was_connected), etc... the SUM will sum up all non-null values. The COUNTNULL would sum up all rows which have a value of 0. Does anyone have a UDF for this function? I currently don't have room on my laptop to download the mysql source code in order to write this up. ( Also have not written a udf for mysql up to this point either) Thankyou kindly for any reply, Calvin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Is this a bug?
Hi People, I'm trying to execute this Simple query: SET SQL_SAFE_MODE=0; The server doesn't like it; However, SET any other option will work fine except this one. I'm still using mysqld v3.23.36 . If someone can try it on the latest version. Thanks. Randy, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: COUNTNULL function
Yes. A feature of MySQL is that it returns 1 for true and 0 for false. When you select ... you can put logic tests and sum up the number of true values. In the case of bool_was_connected=0 will have a value of 1 when it is true and then you sum up the results. You could also do something like: SUM( bool_was_connected IS NULL ) SUM( boul_was_connected IS NULL OR boul_was_connected=0 ) and do on. Just put the condition you want to be true and count in the SUM(). b. [EMAIL PROTECTED] wrote: Thankyou kindly Bill. Just to verify, SUM adds up values. My data is only 1 or 0. I used SUM as an example, the below query you recommend will count all 'rows' which are 0, thus returning a number which represents how many 0's were found? Thankyou for the fast reply, Calvin On Thu, 30 Aug 2001, Adams, Bill TQO wrote: SELECT SUM( bool_was_connected=1 ) AS was_connected, SUM( bool_was_connected=0 ) AS was_not_connected, etc... b. [EMAIL PROTECTED] wrote: Evening Gurus, I have a small problem that I've beaten to death the past 2 days. I am trying to get the value of a row, and update another table accordingly. The data within the row is either a 1 or 0. My issue is in trying to increment a count for both 1's and 0's. In other words, I want to SUM up all the 1's and update a table with this sum. I also want to sum up all the 0's and add this total count to the table as well. This can be accomplished in a long query, or in through a language..what I am trying to accomplish is to get the total sum of each value without using a WHERE clause. Something akin to: SELECT ... SUM(bool_was_connected), COUNTNULL(bool_was_connected), etc... the SUM will sum up all non-null values. The COUNTNULL would sum up all rows which have a value of 0. Does anyone have a UDF for this function? I currently don't have room on my laptop to download the mysql source code in order to write this up. ( Also have not written a udf for mysql up to this point either) -- Bill Adams TriQuint Semiconductor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: COUNTNULL function
Evening Jay, I'm still abit new to MySQL. Spending the last 6 months I have worked with it more on my CGI development, than good SQL query practicing. My technical jargon is lacking. In laymens terms ( I know no other at this point in time ) I have a row that has '1' or '0' in it. I'm trying to do: What is the total number of '1's? What is the total number of 0's? Thanks for the patience list, Calvin Update: Just read Bill's reply to my request. Looks like he's got my answer. Thankyou much gents. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Virtualizing MySQL
Gerhard, Thank you for your response. Emphasizing that I am new to this, could you describe in a bit more detail how I could put this in the new root structure? (client's chrooted structure) If this is too extensive to properly explain, is there some documentation available which might help? I appreciate your help. Regards, Mustafa. - Original Message - From: Gerald Clark [EMAIL PROTECTED] To: Mustafa Hashmi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 1:03 PM Subject: Re: Virtualizing MySQL Two problems. The clients don't have access to the databases, the server does. Chrooted clients will not be able to read and write the named pipe unless it is in their new root structure. Mustafa Hashmi wrote: Hi all, I am in the process of creating a Virtual Server - and pretty much all aspects have been completed to my liking. This includes web / mail / ftp and ssh. The next hurdle is virtualizing MySQL, and I would like to do this by sharing the same MySQL server across multiple chrooted clients. This way, they can have unlimied databases / tables under their userID without looking at, or disrupting, any of the other clients in their chroot. I am also rather new to this, so please feel free to point me to a URL which may help. I've tried though - couldn't find anything relevant to my cause. I appreciate your time. Cheers, Mustafa. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQLGUI file save function
Jeff Isom writes: I am fairly new to MySQL and I am unfamiliar with the term escaped form. Can anyone point me to documentation that explains what that is and how it can be used. Also, I am trying to perform a backup remotely. My understanding is that the mysqldump and mysqlhotcopy commands can only be used on the local machine. Is this correct? What is the best way to perform a backup remotely. Thanks, Jeff Escaped form means that binary data are escaped, i.e. some characters are converted to a combo of backslash and readable character. Read a manual on the subject. You can use mysqldump from remote hosts, without any problems. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Storing the mysql data in a different location
Thanks Gerald!! That did the trick and everything seems to be running perfectly! At 01:59 PM 8/30/2001 -0500, Gerald Clark wrote: Unfortunately, when you moved the directories, you forgot to make mysql the owner of the new directory. chown -R mysql /data/mysql Philip Daggett wrote: Hello everyone!! I am installing the latest rpm for mysql 3-23.41 on a RedHat 7.1 box and want the datadir to be /data/mysql/data. In my /etc/my.cnf file I have the directive: [mysqld] datadir=/data/mysql/data The installation completes but the daemon won't start. I do the mysql_install_db command and the requisite tables are installed in my new data directory, the message states that it is starting with the data in the new directory, then the server stops and the error message from the error log is : /usr/sbin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) This file in fact exists in the new data directory as well as the /var/lib/mysql directory. Does anyone know how to do this correctly?? Thanks, Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installation on Solaris questions
I'm a newbie to Unix and MySQL. I have a few questions. With 'uname -a' I got the following message SunOS [EMAIL PROTECTED] 5.7 Generic_106541-06 sun4u sparc SUNW,Ultra-1 Can i install mysql-3.23.41-sun-solaris2.8-sparc in it. Theres no installation instructions for Unix/Solaris machines in the Documentation page. I'd appreciate it if someone can give me pointers on installing MySql on a Sun Solaris machine Thank you ( tables ) __ Do You Yahoo!? Get email alerts NEW webcam video instant messaging with Yahoo! Messenger http://im.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
Support Contracts
Anyone, I apologize for broadcasting to the group, but I've been trying to set-up a maintenance contract and licenses for about a month and no-one seems to be listening to the sales and licensing e-mail drops for MySQL AB Company. I assume those that are 'in the know' can direct me to some 'reliable' way of contacting any? business folks. Again my apologies for spamming the group. Thanks, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help renumbering unique
Hi, I have a mysql table: +---+--+--+-+ | Field | Type | Null | Key | +---+--+--+-+ | sessionid | int(10) unsigned | | PRI | | username | char(20) | | MUL | | start | int(10) unsigned | | MUL | | stop | int(10) unsigned | | MUL | | ipaddress | char(15) | YES | | +---+--+--+-+ sessionid is a unique key. Is there a way to change the values of sessionid such that the values will be numbered from 1 and increments by 1? ie, if the numbers were 1,20,22,25,40,45,47. the new data will be 1,2,3,4,5,6,7,8,9. ? Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQLGUI file save function
On Thu, Aug 30, 2001 at 10:22:02AM -0600, Jeff Isom wrote: I am fairly new to MySQL and I am unfamiliar with the term escaped form. This a Unix-ism. For instance: this line 'this line' this\ line The last two are functionally equivalent. The last one has an 'escaped' space embedded within it. Ie., the shell is forced to interpret the third line just like it would the second line. All of these have to do with how the shell interprets them. Here's some more: $var $var '$var' In this, the first two are equivalent. Single quotes protect variables from shell interpretation. Double quotes do not. All of this is explained in most introductory Unix books. -- Any technology distinguishable from magic is insufficiently advanced. [EMAIL PROTECTED] TopQuark Software Serv. Contract programmer, server bum. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 number
You mean leading zeros? MySQL will translate as much of a string as it can into a number when it is cast: mysql select ('a'+0); +-+ | ('a'+0) | +-+ | 0 | +-+ 1 row in set (0.00 sec) mysql select ('00010'+0); +-+ | ('00010'+0) | +-+ | 10 | +-+ 1 row in set (0.00 sec) mysql select ('0010a'+0); +-+ | ('0010a'+0) | +-+ | 10 | +-+ 1 row in set (0.00 sec) mysql --bill William R. Mussatto wrote: What about a number field w/zero fill? On Thu, 30 Aug 2001, Adams, Bill TQO wrote: Date: Thu, 30 Aug 2001 08:48:11 -0700 From: Adams, Bill TQO [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: order by number If the column is an int then it will order it numerically. Other wise you have to cast it. And dont for get the difference between ORDER BY x ASC and ORDER BY x DESC. --Bill DROP TABLE IF EXISTS test; CREATE TABLE test ( i int, c char(20)); INSERT INTO test VALUES ( 1, '5' ), ( 2, '4' ), ( 3, '3' ), ( 4, '2' ), ( 5, '1' ), ( 1, '5' ); SELECT '-- Natural Order'; SELECT * FROM test; SELECT '- ORDER by INT'; SELECT * FROM test ORDER BY i; SELECT '- ORDER BY cast char-- '; SELECT *, ( c + 0) AS o_col FROM test ORDER BY o_col; Philip Montgomery wrote: When doing a select with an order by clause, how do you make mysql list the items in correct numberical order. Normally, when I run the command mysql will list 1000 before 200 because of the initial digit. How do I correct this? Thanks, Phil Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Bill Adams TriQuint Semiconductor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 -- Bill Adams TriQuint Semiconductor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Enabling Logging of Slow Queries
i think the server does not run with privileges to write to /root regards Sven Huster Senior IT Systems Engineer Sven Huster Senior IT Systems Engineer -Original Message- From: Ryan Shrout [mailto:[EMAIL PROTECTED]] Sent: 30 August, 2001 20:51 To: [EMAIL PROTECTED] Subject: Enabling Logging of Slow Queries I have tried to enable slow query logging for a couple days now, with no success. I have tried adding the line to the my.cnf file as well as stoppign the service then starting it with the command line version. Both ways, the server refuses to restart. I have checked the syntax over and over and I think I have it correct! [mysqld] log-slow-queries=/root/slow-queries.log and /etc/usr/bin/safe_mysqld --log-slow-queries=/root/slow-queries.log Either way, the server will not start. I take the line out and it works again. What am I doing wrong? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [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: Virtualizing MySQL
The short answer is that you can't, if you're using a named pipe (/tmp/mysql.sock, or some such). That would require every user having their own installation of MySQL, which may be what you want. Why not have the users connect via TCP/IP, and just set permissions correctly? They would be able to list the other databases on the server, but if permissions are set correctly, they will only be able to have access to their own databases. Hope that helps. j- k- On Thursday 30 August 2001 12:21, Mustafa Hashmi wrote: Gerhard, Thank you for your response. Emphasizing that I am new to this, could you describe in a bit more detail how I could put this in the new root structure? (client's chrooted structure) If this is too extensive to properly explain, is there some documentation available which might help? I appreciate your help. Regards, Mustafa. - Original Message - From: Gerald Clark [EMAIL PROTECTED] To: Mustafa Hashmi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 1:03 PM Subject: Re: Virtualizing MySQL Two problems. The clients don't have access to the databases, the server does. Chrooted clients will not be able to read and write the named pipe unless it is in their new root structure. Mustafa Hashmi wrote: Hi all, I am in the process of creating a Virtual Server - and pretty much all aspects have been completed to my liking. This includes web / mail / ftp and ssh. The next hurdle is virtualizing MySQL, and I would like to do this by sharing the same MySQL server across multiple chrooted clients. This way, they can have unlimied databases / tables under their userID without looking at, or disrupting, any of the other clients in their chroot. I am also rather new to this, so please feel free to point me to a URL which may help. I've tried though - couldn't find anything relevant to my cause. I appreciate your time. Cheers, Mustafa. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- 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
any sequence generator function?
Hi, Is there a number sequence generator/function in MySQL such that if I were to execute: UPDATE mytable SET id = thisfunction; it will update the table mytable and set the column id to a numbered sequence 1,2,3,4,5,6,7,8,9.? currently, i have a table with 2.5 million records and i want to change one of the field and sequence it and am doing it the hard way of updating one at a time. regards Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: myisampack dumps core on some tables
On Thu, 30 Aug 2001, Michael Widenius wrote: Hi, yes this patch *fixes* all of my problems, except one table which is/was probably too big? I haven't found any options that would make myisamchk to ask for less memory. /usr/local/mysql/bin/myisamchk: Out of memory (Needed 4294922813 bytes) /usr/local/mysql/bin/myisamchk: error: 12 when opening MyISAM-table '/data/mysql/Celegans/rep.MYI' /usr/local/mysql/bin/myisamchk: Out of memory (Needed 4294922813 bytes) /usr/local/mysql/bin/myisamchk: error: 12 when opening MyISAM-table '/data/mysql/Celegans/rep.MYI' -rwxrwx---1 mysqlmysql21108759 Aug 28 20:31 /data/mysql/Celegans/rep.MYD -rwxrwx---1 mysqlmysql1024 Aug 29 21:55 /data/mysql/Celegans/rep.MYI -rwxrwx---1 mysqlmysql9247 Aug 28 20:30 /data/mysql/Celegans/rep.frm Well, the other rep tables are fine. I'm a bit angry about myself, because I dropped the Celegans.rep tables:!!! mysql drop table rep; Query OK, 0 rows affected (0.05 sec) and dumped them again via network from master site, so I got: -rw-rw1 mysqlmysql44130688 Aug 30 21:39 /data/mysql/Celegans/rep.MYD -rw-rw1 mysqlmysql 2411520 Aug 30 21:39 /data/mysql/Celegans/rep.MYI -rw-rw1 mysqlmysql9247 Aug 30 21:38 /data/mysql/Celegans/rep.frm I managed successfully to run myisamchk -rq on it, myisampack and again myisamchk -rq. So now I can only tell you that broken datafile can cause myisamchk to ask for too much memory. :( This is on master site: -rw-rw1 pedant users44130688 Jul 11 13:41 /home/mysql/Celegans/rep.MYD -rw-rw1 pedant users 1645568 Jul 11 13:41 /home/mysql/Celegans/rep.MYI -rw-rw1 pedant users9247 Jul 11 13:40 /home/mysql/Celegans/rep.frm mysql select count(id) from rep; +---+ | count(id) | +---+ | 19223 | +---+ 1 row in set (0.02 sec) mysql and this is on backup site after compression and rebuilding index: -rw-rw1 mysqlmysql21108573 Aug 30 21:41 /data/mysql/Celegans/rep.MYD -rw-rw1 mysqlmysql 1644544 Aug 30 21:41 /data/mysql/Celegans/rep.MYI -rw-rw1 mysqlmysql9247 Aug 30 21:38 /data/mysql/Celegans/rep.frm and also 19223 lines. So unfortunately, I don't have the broken table anymore, only the screen dumps (size od .MYD and .MYI differed). It seems the broken datafile had 6 bytes more, broken index was much smaller. That's all I can tell you. ;) Maybe it helps. Hi! Sasha == Sasha Pachev [EMAIL PROTECTED] writes: Sasha On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote: Description: I have on Linux running 3.23.41 the following problem: $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp Sasha /data/mysql/Aactinomycetemcomitans/blimps.MYI Compressing /data/mysql/Aactinomycetemcomitans/blimps.MYD: (1443 records) - Calculating statistics normal: 7 empty-space: 0 empty-zero: 0 empty-fill: 7 pre-space: 0 end-space: 3 intervall-fields: 0 zero: 1 Original trees: 16 After join: 9 - Compressing file Segmentation fault (core dumped) cut Thanks Martin for the test case; It enabled me to quickly find the bug. Here is a patch for this (This will be in 3.23.42) = myisam/myisampack.c 1.9 vs edited = *** /tmp/myisampack.c-1.9-8558Wed Aug 22 01:45:03 2001 --- edited/myisam/myisampack.cThu Aug 30 14:09:40 2001 *** *** 251,257 static void print_version(void) { ! printf(%s Ver 1.9 for %s on %s\n,my_progname,SYSTEM_TYPE,MACHINE_TYPE); } static void usage(void) --- 251,257 static void print_version(void) { ! printf(%s Ver 1.10 for %s on %s\n,my_progname,SYSTEM_TYPE,MACHINE_TYPE); } static void usage(void) *** *** 1670,1676 max_calc_length+=huff_counts[i].tree-height; else if (huff_counts[i].field_type == FIELD_BLOB || huff_counts[i].field_type == FIELD_VARCHAR) ! max_calc_length=huff_counts[i].tree-height*huff_counts[i].max_length + huff_counts[i].length_bits +1; else max_calc_length+= (huff_counts[i].field_length - huff_counts[i].max_zero_fill)* --- 1670,1676 max_calc_length+=huff_counts[i].tree-height; else if (huff_counts[i].field_type == FIELD_BLOB || huff_counts[i].field_type == FIELD_VARCHAR) ! max_calc_length+=huff_counts[i].tree-height*huff_counts[i].max_length + huff_counts[i].length_bits +1; else max_calc_length+= (huff_counts[i].field_length - huff_counts[i].max_zero_fill)* Regards, Monty -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics http://mips.gsf.de GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
Re: Enabling Logging of Slow Queries
Hi Ryan, Did you look in you hostname.err file for the error at the end of the file? Are you running the mysql daemon as root? Could it be the user you are running mysqld as does not have permission to write to /root? The .err file by default is in the directory with your other logs (on my system /usr/local/var/picard.icarz.com.err ). Either tail or cat the file and look at the error on the end. Best of luck Ken - Original Message - From: Ryan Shrout [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 2:50 PM Subject: Enabling Logging of Slow Queries I have tried to enable slow query logging for a couple days now, with no success. I have tried adding the line to the my.cnf file as well as stoppign the service then starting it with the command line version. Both ways, the server refuses to restart. I have checked the syntax over and over and I think I have it correct! [mysqld] log-slow-queries=/root/slow-queries.log and /etc/usr/bin/safe_mysqld --log-slow-queries=/root/slow-queries.log Either way, the server will not start. I take the line out and it works again. What am I doing wrong? Ryan Shrout Owner - Amdmb.com http://www.amdmb.com/ [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: Virtualizing MySQL
Thanks for the response Joshua, That is an option - however not one I would be very comfortable with. I have a similar setup for virtual hosts generally - wanted something more flexible and powerful for a virtual server implementation without taxing the actual server too much. For example, the mail server (qmail) is not chrooted as such - however pop is chrooted via tcpserver, delivering messages to users in a virtual env. SMTP works the same way, chrooting to say /home/user/etc/tcp.cdb to check relay. Unfortunately, I know little about the actual how-does-it-work part of MySQL and need some direction :) I am going to try something in the next 3-4 days and hopefully I'll post a positive outcome. If this works, I'll write a HowTo :) Thanks again for your response. Mustafa. OS: debian-2.2.19 - Original Message - From: Joshua J. Kugler [EMAIL PROTECTED] To: Mustafa Hashmi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 1:51 PM Subject: Re: Virtualizing MySQL The short answer is that you can't, if you're using a named pipe (/tmp/mysql.sock, or some such). That would require every user having their own installation of MySQL, which may be what you want. Why not have the users connect via TCP/IP, and just set permissions correctly? They would be able to list the other databases on the server, but if permissions are set correctly, they will only be able to have access to their own databases. Hope that helps. j- k- On Thursday 30 August 2001 12:21, Mustafa Hashmi wrote: Gerhard, Thank you for your response. Emphasizing that I am new to this, could you describe in a bit more detail how I could put this in the new root structure? (client's chrooted structure) If this is too extensive to properly explain, is there some documentation available which might help? I appreciate your help. Regards, Mustafa. - Original Message - From: Gerald Clark [EMAIL PROTECTED] To: Mustafa Hashmi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 1:03 PM Subject: Re: Virtualizing MySQL Two problems. The clients don't have access to the databases, the server does. Chrooted clients will not be able to read and write the named pipe unless it is in their new root structure. Mustafa Hashmi wrote: Hi all, I am in the process of creating a Virtual Server - and pretty much all aspects have been completed to my liking. This includes web / mail / ftp and ssh. The next hurdle is virtualizing MySQL, and I would like to do this by sharing the same MySQL server across multiple chrooted clients. This way, they can have unlimied databases / tables under their userID without looking at, or disrupting, any of the other clients in their chroot. I am also rather new to this, so please feel free to point me to a URL which may help. I've tried though - couldn't find anything relevant to my cause. I appreciate your time. Cheers, Mustafa. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- 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
Re: Enabling Logging of Slow Queries
On Thu, Aug 30, 2001 at 02:50:47PM -0400, Ryan Shrout wrote: I have tried to enable slow query logging for a couple days now, with no success. I have tried adding the line to the my.cnf file as well as stoppign the service then starting it with the command line version. Both ways, the server refuses to restart. I have checked the syntax over and over and I think I have it correct! [mysqld] log-slow-queries=/root/slow-queries.log Is mysqld running owned by root? No? Then mysql will have no right to write to /root. Mine runs as mysql. -- Any technology distinguishable from magic is insufficiently advanced. [EMAIL PROTECTED] TopQuark Software Serv. Contract programmer, server bum. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error adding tables, databases, or records
On Thu, Aug 30, 2001 at 11:00:14AM -0600, Benjamin Krajmalnik wrote: OK. I tracked the problem to being out of disk space in the var partition. The default source installation plaved the data in the /var/db directory. The var partition is not that large by default, and therefore I am now out of space. I would like to move the data to a /usr/local/mysql/data directory. What is the proper process to do this by? Is moving the data to that directory and changing the datadir location in safe_mysqld sufficient? That might work; dunno. Or you could: shell_ cd /var shell_ rmdir db shell_ ln -s /usr/local/mysql/data ./db ... I think. Then you wouldn't have to fiddle with mysql defaults at all. Of course, get your data out of /var/db before you rmdir /var/db. -- Any technology distinguishable from magic is insufficiently advanced. [EMAIL PROTECTED] TopQuark Software Serv. Contract programmer, server bum. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: help renumbering unique
That seems like rather a bad idea to me. Would that not leave anything else that references the sessions looking at the wrong session? Jaime Teng wrote: Hi, I have a mysql table: +---+--+--+-+ | Field | Type | Null | Key | +---+--+--+-+ | sessionid | int(10) unsigned | | PRI | | username | char(20) | | MUL | | start | int(10) unsigned | | MUL | | stop | int(10) unsigned | | MUL | | ipaddress | char(15) | YES | | +---+--+--+-+ sessionid is a unique key. Is there a way to change the values of sessionid such that the values will be numbered from 1 and increments by 1? ie, if the numbers were 1,20,22,25,40,45,47. the new data will be 1,2,3,4,5,6,7,8,9. ? Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bug in return value of jdbc call
When using the Java call to executeUpdate() for an update statement, the return value should be the number of rows affected. mysql is returning a value of 0 on a successful update when it should return 1. The database is being updated properly, only the response is wrong. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: any sequence generator function?
Add an auto_increment column of an appropriate int size. Jaime Teng wrote: Hi, Is there a number sequence generator/function in MySQL such that if I were to execute: UPDATE mytable SET id = thisfunction; it will update the table mytable and set the column id to a numbered sequence 1,2,3,4,5,6,7,8,9.? currently, i have a table with 2.5 million records and i want to change one of the field and sequence it and am doing it the hard way of updating one at a time. regards Jaime - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
straneg replication problem
the master has the correct permission. however the slave reports this error. Slave: Failed reading log event, reconnecting to retry, log 'mysql-bin.log' position 30 Slave: reconnected to master 'mysql@mydb203:3306',replication resumed in log 'mysql-bin.log' at position 30 Slave: received 0 length packet from server, apparent master shutdown: (0) Searching the list it looks like others have run up against this. There does not seem to be an answer anywhere tho. Thanks David Berk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: straneg replication problem
Hi, Every time we have run into this one, is because somthing updating, was out of sync. Best Regards On Thu, 30 Aug 2001, Dave Berk wrote: the master has the correct permission. however the slave reports this error. Slave: Failed reading log event, reconnecting to retry, log 'mysql-bin.log' position 30 Slave: reconnected to master 'mysql@mydb203:3306',replication resumed in log 'mysql-bin.log' at position 30 Slave: received 0 length packet from server, apparent master shutdown: (0) Searching the list it looks like others have run up against this. There does not seem to be an answer anywhere tho. Thanks David Berk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Backing up a MySQL database on a remote server
I'm new to MySQL and I'm sure this has been covered, but I can't find it so I'll ask here. What is the best way to backup a MySQL database that is hosted on a remote server. Our web site is hosted by a hosting company and they configured MySQL. I want to backup the database periodically. I've tried using PhPMyAdmin to get data dumps, but the databases are quite large and the browser times out before the file download begins. How can I connect to the MySQL server from my Win2000 machine and perform a dump to my hard drive? Also, what is the best way to reverse the process and restore the dump from my hard drive to the remote server. I apologize if this question is obvious. I've looked in the documentation, but haven't been able to figure it out. Thanks in advance for the help. Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[fwd] Re: Re: any sequence generator function? (from: mysql@lists.mysql.com)
database,sql,query,table So sprach =BBJaime Teng=AB am 2001-08-31 um 03:53:47 +0800 : Is there a number sequence generator/function in you can set the INT types to auto_increment, which will do just that when you insert rows. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.digitalprojects.com | http://www.iso-top.de iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 1 day 8 hours 30 minutes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question concerning the mysqld process
Question, Could some one tell me why our mysqld daemon appears to be incrementing on time. For instance I get the following output when I use ps -elf. the 470 you see below was 460 30 secs ago. Is there a memory leak or ?we are using MySql 3.23.30 What can I do to resolve this??? besides restart mysqld Thanks, Joe Balderrama F S UID PID PPID C PRI NI ADDR SZWCHANSTIME TTY TIME CMD 19 T root 0 0 0 0 SY 10414c50 0Aug 16 ?0:00 sched 8 S root 1 0 0 41 20 70111848 94 70111a70 Aug 16 ?0:14 /etc/init - 8 S root 287 1 0 84 20 70a3a728373 7019e83a Aug 16 ?0:00 /usr/lib/dmi/dmispd 8 Omysql 22907 22897 1 81 20 70892e20 3190Aug 26 ? 470:02 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/local_home/my 8 S http 23257 305 0 41 20 7160e798 1168 706ae3ac Aug 26 ? 15:38 /local_home/apache/v1.3.20/bin/http 8 S root 28988 1408 0 41 20 70c20a58178 70d5baa6 Aug 28 pts/10:00 /bin/csh 8 O root 3058 2673 0 51 20 7160eea0119 14:18:37 pts/70:00 ps -elf 8 S http 24038 305 1 81 20 716103b8 1161 70d5bbae Aug 27 ? 15:26 /local_home/apache/v1.3.20/bin/http 8 S http 23925 305 0 41 20 70c21160 1170 7055662c Aug 27 ? 15:11 /local_home/apache/v1.3.20/bin/http - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 stalls
Greetings, We're having some problems with our one way replication stalling. There are no errors in the errors logs, and the status reports seem to indicate things are still running, however, changes to the master are not being received by our slaves. We're running a farm of 4 slave mysql machines (MySQL version 3.23.41) that talk to a single master (also version 3.23.41) machine. We're running two databases on the machines (I'll call them db1 and db2), but I only wish to replicate one of them (db2). I've sync'd the databases, and turned on replication, and everything works great until we load data into _db1_ via the 'load data infile' command. At that point, any further changes to db2 are not replicated to the slave machines. Running 'show processlist' at that point, on any of the slaves, gives the following: | 1294 | system user | none | NULL | Connect | 5233 | Reading master update | NULL Running 'show slave status' gives: | master | user | 3306 | 60 | p23-bin.004 | 380 | Yes | db2 | db1 | 0 | | 0 | Running 'show processlist' on the master reveals: | 4 | repl | 10.1.1.108 | NULL | Binlog Dump | 2666 | Reading from net | NULL Running 'show master status' on the master gives: | p23-bin.004 | 11283 | db2 | db1 | If I run 'mysqlbinlog -j 380 p23-bin.004 |head' on master I get: # at 380 #010830 15:39:21 server id 1 Query thread_id=32exec_time=0 error_code=0 use db1; SET TIMESTAMP=999203961;replace into time_last_updated (time,table_name) values ('2001-08-30 15:24:16','person_function'); If I issue 'slave stop' and 'slave start' on a slave, it syncs up to the master, and will continue replicating until db1 is updated. Restarting the master will also allow all of the slaves to sync up. Here's the mysqld section of my.cnf from the master: [mysqld] #port= 3306 #socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=16M set-variable= table_cache=512 set-variable= sort_buffer=6M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=128M set-variable= thread_cache_size=4 set-variable= thread_concurrency=4 # Try number of CPU's*2 set-variable= tmp_table_size=4M set-variable= net_read_timeout=300 set-variable= net_write_timeout=300 # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=64M # Point the following paths to different dedicated disks #tmpdir = /tmp/ #log-update = /path-to-dedicated-directory/hostname # Replication log-bin server-id=1 binlog-do-db=db2 binlog-ignore-db=db1 And from the slaves: [mysqld] #port= 3306 #socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=16M set-variable= table_cache=512 set-variable= sort_buffer=5M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=128M set-variable= thread_cache_size=4 set-variable= thread_concurrency=4 # Try number of CPU's*2 set-variable= tmp_table_size=3M set-variable= net_read_timeout=300 set-variable= net_write_timeout=300 set-variable= max_connections=500 log-update # Replication master-host=master master-user=user master-password=password master-port=3306 server-id=3 replicate-do-db=db2 replicate-ignore-db=db1 log-slave-updates #log-bin If anyone could shed some light on this is happening, and more importantly, how we can keep the replication going, or if you need any other information, please let me know. Thanks, Jeff Adams Webmaster Hoover's Online - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
remove? revoke?
Can I remove the rigth for one user to see one specific table in database? for exemple: user: bob table: tab_secret database: Customer_service Bob can see any table in DB Customer_service except the table tab_secret. --=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-- François Boucher [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: M$ SQL Export to Mysql Help
Curtis ... Do you have the database/table created on the MySQL server? If so, you can use MSAccess (need ODBC connections to both servers) to Link Tables and move the data acros that way. We did it that way until our programmers wrote a C++ app that replicates server-to-server. Gerald Jensen - Original Message - From: Curtis Spencer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 30, 2001 2:54 PM Subject: M$ SQL Export to Mysql Help I have a nicely sized database of about 40 records, which I have in MS SQL but I need to move it to my production server, which is Mysql. I was going to do it this way: Export MS SQL database into a file and then use LOAD DATA INFILE But I was wondering if there were a way to export into SQL and then just use \. Database.sql to import it very quickly. I am worried that the exporter will mess up the file because it is so large. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Installation on Solaris questions
At 12:30 PM -0700 8/30/01, Sujay Daniel wrote: I'm a newbie to Unix and MySQL. I have a few questions. With 'uname -a' I got the following message SunOS [EMAIL PROTECTED] 5.7 Generic_106541-06 sun4u sparc SUNW,Ultra-1 Can i install mysql-3.23.41-sun-solaris2.8-sparc in it. Theres no installation instructions for Unix/Solaris machines in the Documentation page. Evidently you didn't see http://www.mysql.com/doc/S/o/Solaris.html I'd suspect using a 2.8 binary on a 2.7 system might cause problems, but it shouldn't hurt to test it... There are also older binaries (including some for Solaris 2.7) at ftp://ftp.mysql.com/MySQL-3.23/ Lastly, you could always compile it yourself from source...t'aint that hard! -steve I'd appreciate it if someone can give me pointers on installing MySql on a Sun Solaris machine Thank you ( tables ) -- + Open source questions? + | Steve Edberg University of California, Davis | | [EMAIL PROTECTED] Computer Consultant | | http://aesric.ucdavis.edu/ http://pgfsun.ucdavis.edu/ | +--- http://pgfsun.ucdavis.edu/open-source-tools.html ---+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Reply-to and this list
On Thursday 30 August 2001 04:13 am, Carl Troein wrote: A quick question: How come the mailing list software doesn't add a reply-to header? Is this intentional to keep replies off the mysql list, and if so why? Generally, I hit reply-All, and then just edit the To Line:-) I'll try to remember to reply to the list rather than directly to the people who ask the questions, as replying in private does little to stop the same questions from reappearing, and if there's something this list has too much of it's the same questions over and over... :-o //Círdan -- cya l8r Leon D. McClatchey mailto:[EMAIL PROTECTED] ICQ:#112341159 In 1880 the French captured Detroit but gave it back ... they couldn't get parts. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
duplicate delete query
excuse me if this is too newbie...but I need to perform a duplicate delete on my database using the e-mail address as the key. I understnad how to use COUNT and DISTINCT together... select count(DISTINCT email) FROM table; but I can't seem to find any info on how to perform the actual deletion of the duplicate records. Any info is appreciated! Thanks! providing the finest in midget technology - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php