For all you people looking for mysql shirts ;-)
Hi guys, Just an FYI, We've finally decided to license out our logo to CafePress.com with the MySQL Developer logo. You can buy shirts, mugs, tote bags and more If you have a chance please check it out. Here is the link http://www.cafeshops.com/cp/store.aspx?s=mysqldeveloper.0 P.S. Sorry in advance if anyone is offended by this post. FILTER FODDER{ SQL, SELECT, DATABASE } -- Colin Faber (303) 736-5160 fpsn.net, Inc. * Black holes are where God divided by zero. * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: a newserver would be better than this mailing list
Bart Burkhardt wrote: hello list, i think it would be better to have a mysql news server instead of this email list. i will name some reasons that i think of, correct me if i am wrong. Not everyone has access to usenet - with a newsgroup you only select the messages that you want to read or where you can give an answer on. No, you still have to download the message headers which on a slow news server can take just as long as the email's them selves. - with this email list my mailbox fills with too many single messages, replys are not threaded (no plus sign to expand thread) This is a problem with your client then, I'm using netscape's messenger service for reading news and mail and it can thread both. This also totally depends on whether the client issuing the message bothers to update the References: tracking header. - when i go on vacation, and return, i would have a mailbox that is flooded causing that my other messages could not be delivered. Heh, Get a bigger mail box I guess ;-) Or unsubscribe your self while you're out. - using a newsgroup server is less waste of cyberspace because it is centrally located News group servers aren't centrally located in any way. And I'd hate to bust your bubble but usenet is a PIG when it comes to resources used. On top of all of that the overall speed in which it takes to get a message from news server (a) to news server (y) on the internet can very from a few minutes to a day or possibly longer where as with an email list is traditionally MUCH faster. - a mysql newsserver could seperate different subjects like; installation / advanced query / communication / bugreport / announcements / ideas / platform sections.. So can a good mail client. There is absolutely no difference between subscribing to different news groups and subscribing to different mailing lists. It still totally depends on the client. On the other hand subscribing to different news groups allows you the option to only download the headers for that group rather than downloading everything you're subscribed to. However given the VERY low amount of overall traffic on the other mailing lists there shouldn't be any problems with this. - there are probably more reasons to setup a newsserver Yes and there are probably more arguments against it ;-) So my question, why this mailing list, why not a newsserver? See http://groups.google.com/groups?hl=enlr=ie=UTF-8safe=offgroup=mailing.database This list is already fed to a usenet group. -- Colin Faber (303) 736-5160 fpsn.net, Inc. * Black holes are where God divided by zero. * - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Bash to remote MySql Server
Yes, use the ``mysql'' client. Terence wrote: Hi List, Wondering if anyone knows whether it's possible from bash, to connect to a remote mysql database? And if so, where I can find some help. All I require is to connect to another mysql database and get a list of users. (I am trying to avoid running another mysql db for just one table) If not, what do I need to look into? perl? Thanks Terence - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: copy question
Yes, CREATE TABLE tbl SELECT * FROM tbl; Vivian Wang wrote: Can mysql copy from table1 to table2? Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Opposite of --skip-networking?
Hi, Andy Smith wrote: On Wed, Jul 17, 2002 at 01:24:41PM -0700, Jeremy Zawodny wrote: On Wed, Jul 17, 2002 at 08:04:47PM +0100, Andy Smith wrote: Hi, I've compiled mysql-4.0.2-alpha from source, and I cannot seem to get it to bind to an interface and allow TCP connections. When I do a SHOW VARIABLES I see skip_networking=ON yet I am not starting mysql with --skip-networking. To reverse this situation I tried putting: set-variable = skip_networking=OFF in my.cnf, but it told me it was an unknown variable. Anyone got any ideas? Is there a rogue .my.cnf file or my.cnf lurking about elsewhere maybe? Ah, you're absolutely right. In /etc/my.conf there appears skip-networking The problem is, I need to run multiple mysql servers on this machine. Is there a way I can reverse the effect of skip-networking, Yes, Comment out or remove the line or else skip reading /etc/my.cnf (the one in the basedir and $HOME/.my.cnf is enough)? Yes, Place the ``my.cnf'' file into the --datadir= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on a Cobalt RAQ4
Hi, Those builds are horribly out of date, I recommend you get the binary package (if available) from the MySQL.com site, Other wise grab the source distribution and compile it your self. Peter Lovatt wrote: Hi Dont use the rpm, go for the package at http://pkgmaster.com/packages/raq/4/ and install it from there, just point and click! Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- -Original Message- From: K Frey [mailto:[EMAIL PROTECTED]] Sent: 16 July 2002 20:39 To: [EMAIL PROTECTED] Subject: MySQL on a Cobalt RAQ4 I plan to attempt installing MySQL on a Cobalt Raq4 this week - anyone have experience/advice to share? My plan is to download the RPM from mysql.com and follow the directions on the site, but I have read some things on the internet that say to stay away from the rpm... Kristy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Read-Only MySQL
Like Kristian says, I don't see why you couldn't do something like that, Though you may want to setup mysql to have a very large amount of cache to pool from this way you can speed performance of it. Gerald R. Jensen wrote: Kristian: Possible? I suppose, but not very practical. It would be ssllooww, you'd need to supply an application to permit access to the data, and how would you handle licensing? Gerald Jensen - Original Message - From: Kristian Koehntopp [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Tuesday, July 09, 2002 6:48 AM Subject: Read-Only MySQL I want to create a CD-ROM which contains a copy of MySQL (for Windows) and a set of MySQL databases. Is it possible to set up a read-only MySQL, that is, a MySQL running from a r/o media? Kristian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and DBI remote access
Hi, Right from the connect section in the DBD::mysql manual: $dsn = DBI:mysql:database=$database;host=$hostname;port=$port; $dbh = DBI-connect($dsn, $user, $password); Shawn wrote: Hello all, Does anyone know if there is a way to remotely call the data_source [DBI-data_source('mysql')] property to pull all available databases/drivers? I can't seem to do it since you are not allowed to specify a host name, user name, or password with it. The docs mention nothing about it using the call remotely, but I can't believe that I am the first to have an issue with it... Any pointers would be greatly appreciated? TIA, Shawn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Get message
http://www.mysqldeveloper.com/lists/index.pcgi?readlist=mysql [EMAIL PROTECTED] wrote: Unfortunately, I don't have. I subscribed today. -- Mensagem Original -- you can't. Check the archives, this was discussed about 2 weeks ago. * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 03, 2002 7:13 AM To: [EMAIL PROTECTED] Subject: Get message How can I get the message when I make a query like e.g: 8 rows in set (0.01 sec) How can I get with Delphi. I use the component Zeos dbo to access Mysql Regards Alexander Curitiba/BRA A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php A busca mais veloz e precisa da internet. Acesse agora: http://www.zoom.com.br. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Tab delimited dump?
SELECT cols FROM tbl INTO OUTFILE '/someflie'; ollie wrote: Does anyone have a way to export data from a table into a tab delimited text file? Can't seem to see the option in mysqldump. For bonus points - how could I achieve this via PHP?(!) TIA, ollie or-media.com | design | online | interactive | 3d | animation | video +44 (0) 207 394 1072 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Demande d'inscription à mysql-france
You all should block anything with 'yahoogroups' anywhere in any of the headers. Notification de Yahoo! Groupes wrote: Bonjour, Vous avez récemment demandé à vous inscrire au groupe mysql-france. Comme vous êtes déjà membre de ce groupe, votre demande ne sera pas prise en compte. Pour toute question sur l'envoi de messages à ce groupe, veuillez envoyer un e-mail à [EMAIL PROTECTED] Cordialement, L'équipe support Yahoo! Groupes L'utilisation du service Yahoo! Groupes est soumise à l'acceptation des Conditions d'utilisation et de la Charte sur la vie privée, disponibles respectivement sur http://fr.docs.yahoo.com/info/utos.html et http://fr.docs.yahoo.com/info/privacy.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 -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: apparent bug
Hi Buff, Try under the optimization section. Though keep in mind the impact on speed shouldn't be that great.. By the way.. in an ideal design your primary key will be an integer ;-) Buff Smith wrote: Colin, Where can I read about the impact of having Primary Keys as VARCHAR? This entails an 8 times overhead in Sybase, Oracle, and Microsoft for changing PK values. It must rebuild the index versus and update-in-place. Buff Smith, Maestro THE BLUES BUFFET BAND 310 280-3593 http://BluesBuffetBand.com (AKA) [EMAIL PROTECTED] -Original Message- From: Colin Faber [SMTP:[EMAIL PROTECTED]] Sent: Saturday, May 18, 2002 3:46 PM To: [EMAIL PROTECTED] Cc: '[EMAIL PROTECTED]' Subject:Re: apparent bug Hi, this is a feature. see http://www.mysqldeveloper.com/manual/index.pcgi?section=Silent_column_ch anges ;-) Buff Smith wrote: To Whom It May Concern: I have reported the following symptoms in UNIX using 'mysqlbug' character mode utility. I am including the text of that problem statement with this email. Additionally, I am attaching several sample DDL input files, and the results of SHOW COLUMNS FROM table name output. Voila, the mysqlbug problem text: *** SEND-PR: -*- send-pr -*- SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as SEND-PR: will all comments (text enclosed in `' and `'). SEND-PR: From: buff To: [EMAIL PROTECTED] Subject: DDL CREATE TABLE data format CHAR(x) compiles as VARCHAR(x) Description: My DDL files for CREATE TABLE statements contain no VARCHAR(x) data formats. However, when compiling all DDL for a given database. For some reason invisible to me, some of the columns whose data format is CHAR(x) end up being created as VARCHAR(x). The set of columns that mutate in this fashion is consistent, i.e., the same set of columns always get this error. However, the rime or reason for this set seems to be happenstance. That is: For a given dB name with a parallel set of DDL the same columns mutate to VARCHAR. In other words: I use DDL set A with dB name 1, DDL set B with dB name 2, etc., etc. NOTE: pair A1, B2, etc get consistent within pair, but consistently different between pair sets of VARCHAR columns. The string /VARCHAR/cannot be found via grep in any of my DDL scripts. I can email or FTP a DDL script. How-To-Repeat: I will email or FTP a set of DDL scripts Fix: NONE Submitter-Id: [EMAIL PROTECTED] Originator: Buff Organization: cynchrony.com hosted by interland.com MySQL A.B's customer is Interland MySQL support: interland.com says -- none Synopsis: CHAR(X) mutates in DDL compile varchar(x) Severity: critical Priority: medium Category: mysql Class: sw-bug Release:mysql-3.22.32 (Source distribution) Environment: FreeBSD cynchrony.com 4.1.1-STABLE FreeBSD 4.1.1-STABLE #0: Tue Aug 21 22:35:59i GMT 2001 root@osbuilder:/usr/obj/usr/src/sys/SERVER i386 MySql Version: +---+ | version() | +---+ | 3.22.32 | +---+ * end of mysqlbug problem statement text In preparing data for this email I noticed that it seems to happen for columns added after a certain period of time. Originally, the Question_Asked_Quantitative table did not have the Question_Subscale_Name column. Generation number 2 DDL version 09 of the trimergence_main database did not have the column, whereas generation number 3 DDL version 13 of the trimergence_main database added that and other columns. The current version of mysql is listed in the mysqlbug problem statement text, above I do not know which version mysql was when generation 2 of the database was created. attachments follow -- generation 09 show cols === Field TypeNullKey Default Extra Questionnaire_IDint(11) PRI 0 Question_Number int(11) PRI 0 Question_Subscale_Name varchar(32) PRI Question_Text textNULL Generation 09 DDL = use trimergence_main2; CREATE TABLE Customer_Authentication ( Customer_ID CHAR(30) NOT NULL, Customer_NameCHAR(128) NOT NULL, Company_SignUp_date DATE NOT NULL, Company_Expire_Date DATE NOT NULL, Customer_Validation_flag CHAR(1) NOT NULL, Contact_Person CHAR(128) NOT NULL, Contact_emailCHAR(128) NOT NULL, Customer_address_street CHAR(128), Customer_address_city CHAR(64
Re: apparent bug
] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database's Disappear from phpMyAdmin
Hi, try contacting the author, phpmyadmin != mysql Kelly Hamlin wrote: Im running MySQL 3.23.49/PHP 4.2.1/Apache 2.0.35 I load of phpMyAdmin and i see one of my databases with a - after its name like its empty, but the wierd thing is, its not. I have quote a large amount of data in it and my sites all still function properly. Any idea on what might be causing this? thanks. // ( o o ) +--.oooO--(_)--Oooo.-+ | [Kelly Hamlin] | [EMAIL PROTECTED] | http://www.bomb.net | .oooO | ( )Oooo. +--- \ (( )+ \_)) / (_/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is there MySQL version 4.0.2 ?
Hi, as far as I know the only way that can be correct is to have one of the committers rename the files them selves that have duplicate names. Since windows isn't smart enough to realize that ABC doesn't mean abc. Good luck getting it working under windows ;-) Viliam Batka wrote: Hi , CFc I've decided to provide a snapshot release system of the data on the CFc work.mysql.com server for 4.0.x you can access the nightly builds here: CFc CFc http://www.mysqldeveloper.com/snapshots/ thank you very much for the option to download the snapshot. Just my Intention is to by involved more seriously and therefore I would like to use the BitKeeper. LBc You can get the latest source code LBc take a look at LBc http://www.mysql.com/doc/I/n/Installing_source_tree.html LBc to see how to proceed At the moment I am using Windows 2000 and BitKeeper 2.1 for Windows. After applying the : bk clonebk://work.mysql.com:7001 mysql-4.0 I have got following message: == Sfio has detected a name conflict between BitKeeper/deleted/SCCS/s..del-Makefil e.w32 and BitKeeper/deleted/SCCS/s..del-makefile.w32; This usually happens when you transfer file from a case-sensitive file system (e.g. Unix) to a case insensitive file system (e.g FAT, NTFS) Please rename one of the files and retry (see also bk helptool mv) Note: You must do the rename in the sending repository. == In hope to fix it via bk pull and I have used the: cd mysql-4.0 bk pull bk://work.mysql.com:7001 Nothing to pull from bk://work.mysql.com:7001 when I have checked my local copy via: bk -r check -a I have got plenty of files that was not resolved. Am I doing something wrong or I shall forget about BitKeeper as I am using the Windown 2000? Any suggestion? Thanks, Viliam Batka -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql error
Hi Tristan, Both the client and the server must have that option enabled. You must also have the right setup in your grant tables to load files. Try loading it locally (with out the LOCAL flag) and see if that helps. Tristan Trio wrote: Hello, Am new to mySQL. I had installed mySQL version 3.23.49 on my pc running on windows 98. My problem is when I tried to populate a database using the command: load data local infile uprhs.txt into table uprhs; i get an error message ERROR 1148: The used command is not allowed with this MySQL version Is that command not availbale in version 3.23.49 if yes what is the alternate command for it. Would appreciate any help you can give me. Tristan -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: empty?
Hi amy, No the database(s) them selves are empty until populated with tables, and data. Amy Zediak wrote: I have my MySQL database up and running, but its empty...did i miss a step? Thanks Amy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Temp Table size?
Hi Mike, Possibly out of available memory. (Or disk space assuming that's what it's hitting) Mike Grover wrote: When I create a temp table, If I put to much in it, I get a Temp Table [Table name] is Full error. I changed my tmp_table_size to a ver large number. Still same error, Any Ideas? This is windows 2000 MySQL 4.01 Config Loaded Form my.ini in winnt dir. Show Variables for server shows new tmp_table_size set In ini file. mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Load data command?
Hi Joshua, what exactly did you try? LOAD DATA INFILE seems to be working on my box ;-) Joshua Richards wrote: Hi, Could anyone please tell me how I could load a text file into a specific column in mysql. I tried LOAD DATA INFILE but didn't work Thanks, J.Richards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: source code
yes, http://www.mysql.com/downloads Amy Zediak wrote: Can i download the source code for MySQL? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mixed up variables || solution found
/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 -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql uses 99% cpu under freebsd 4.3
Symmetric Multi Processing ;-) url: http://webopedia.lycos.com/TERM/S/SMP.html David BORDAS wrote: SMP is System Multi Processor Like a server with 2 or more CPUs ... David - Original Message - From: webmaster [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 13, 2002 1:07 PM Subject: Re: Re: mysql uses 99% cpu under freebsd 4.3 So far I've experienced it on one SMP box and one single CPU box. I Silly question: what is SMP...? Best regards,=20 Eivind :-) sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Is there MySQL version 4.0.2 ?
Hi, Given the number of questions i've seen regarding later versions of mysql I've decided to provide a snapshot release system of the data on the work.mysql.com server for 4.0.x you can access the nightly builds here: http://www.mysqldeveloper.com/snapshots/ Good luck and have fun. Luciano Barcaro wrote: Viliam Batka clear wrote: Hi, When I have been browsing the mysql documentation on http://www.mysql.com/documentation/mysql/bychapter/ I have recognised that the documentation is referring the 4.0.2 version of MySQL. I would like to compile MySQL from source files. At the moment I am able to download the 4.0.1 version. Will be the 4.0.2 version available soon or shall I go ahead with the 4.0.1 version? Thanks Viliam Batka Hi, You can get the latest source code take a look at http://www.mysql.com/doc/I/n/Installing_source_tree.html to see how to proceed -- \|/ __\|/ `@ / o . \ @' Microsoft? Por acaso é alguma nova /___| \/ |___\ marca de papel higiênico? \___U__/ .^. Luciano Barcaro - Linux User # 99517 /v\ Registre-se gratuitamente em // \\http://counter.li.org //(.)\\ ICQ # 17266954 ^`~'^ -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Perl-Mysql manual (.chm version)
Hi see perldoc DBI and perldoc DBD::mysql (search.cpan.org) Onder Hazaroglu wrote: I use Perl, Php, mysql for my applications. I have a great manual for php for mysql processes. But i do not know any manual for perl yet. Does anyone know any manual about for perl-mysql? Better if would be .chm version. Thanks. -Onder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: My Query is TOOOOOOOOOOOO Slow :(
Hi Edilson, Increase your key and join buffers. also select your absolute values first. i.e.: SELECT idemailsent, email, idclient FROM wmkt_email_sent a, wmkt_client b, wmkt_email c WHERE fkuser = 1 AND fkpbl = 23 AND nMachine = 0 AND c.idemail=a.fkemail AND b.fkemail=a.fkemail ORDER BY email LIMIT 1000 Also make sure you index any columns which will be used to key off of. This includes any columns you plan to join on. Edilson Vasconcelos de Melo Junior wrote: Hi, My query is running very very VERY slowly and this is creating a lot of troubles. Please, see it below and if u find something useful and faster i'll be very grateful. MYSQL SELECT idemailsent, email, idclient FROM wmkt_email_sent a, wmkt_client b, wmkt_email c WHERE nMachine = 0 AND c.idemail=a.fkemail AND b.fkemail=a.fkemail AND fkuser=1 AND fkpbl=23 ORDER BY email LIMIT 1000 the tables structures are: mysql show fields FROM wmkt_email_sent; +-+---+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+---+--+-+-++ | idemailsent | int(11) | | PRI | NULL| auto_increment | | fkpbl | int(11) | | | 0 || | fkemail | int(11) | | | 0 || | dtSend | timestamp(14) | YES | | NULL|| | nResult | int(11) | | | 0 || | dtLastUp| timestamp(14) | YES | | NULL|| | nMachine| int(11) | | | 0 || +-+---+--+-+-++ mysql show fields FROM wmkt_client; +--+---+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+---+--+-+-++ | idclient | int(11) | | PRI | NULL| auto_increment | | realname | varchar(80) | | | || | fkemail | int(11) | | | 0 || | dtInsert | timestamp(14) | YES | | NULL|| | dtLastUp | timestamp(14) | YES | | NULL|| | fkuser | int(11) | | | 1 || +--+---+--+-+-++ mysql show fields FROM wmkt_email; ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-++ | idemail| int(11) | | PRI | NULL| auto_increment | | email | varchar(255) | | UNI | || | fklastresp | int(11) | | | 0 || ++--+--+-+-++ Thank u very much, Edilson. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Poor Manual [Was: Why using filesort here?]
Hi benjamin/Sven, it's my understanding that the latest revision of the manual is (minus 4.x commits) always included in the distribution set. New features are always documented in the manual and are nearly always appended with a This was added in version insert version here string some place. Benjamin Pflugmann wrote: Hello. On Sun, Apr 21, 2002 at 02:15:33PM +0200, [EMAIL PROTECTED] wrote: [...] I assume you are referring to the online manual? It's documenting the most recent version. According to the change history (Appendix D), this optimization was introduced in version 4.0.2. I see, thanks for that one. This manual is f@#$% up, since it seems like there is no manual for stable versions online A copy of the manual for your version of MySQL accompanied your copy of MySQL. At last should have. And if not, it's online in a downloadable format. Only - but it's not as if there was no copy available. I agree that a searchable version for the stable branch would be nice, anyhow. or at least some annotations that say in which version a feature was introduced (it's not nice to lookup every change in the ChangeLog). If you have read some more of the manual, you will notice that most features have such annotations, except if they are long established. I suspected that the online version reflects the most recent stable not some development version. You are right, that could be stated more obviously. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL counter for HIGH traffic site
Having objectively looked at both I would say a simple DBI perl app running under mod_perl with Apache::DBI installed would be your best bet for performance. Connection pooling is something you'll need to keep the overall load down. PHP's pconnect is good but seems to be a bit broken in it's pooling practices. Anyone else have any suggestions? Craig Westerman wrote: I'm needing counter for site that receives 80 to 120 hits a minute at peak load. Many I have tried cause excessive server load and need to be deactivated or they lose data and return to zero without warning. All tried so far have been written in Perl writing to a file. Anyone here know of a counter that would handle HIGH traffic with little added server load? Would using MySQL to store count be of any benifit? Would Perl or PHP be faster for writing count to MySQL? Thanks Craig [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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: regarding libmysqlclient and libmysqlclient_r
Try building libmysqlclient_r with your local pthreads, the same ones you're using in the application it self. ie --with-pthraed=-pthread or --with-pthread=-lpthread Shivam K Shah wrote: Hi, I have written the following test case in which I'm trying to access the database using differant threads each thread calls this function test2(), access to which is protected by a pthread_mutex_lock() at the beginning of the test and pthread_mutex_unlock() at the end of the test. The same code when it is compiled using libmysqlclient works and doesn't work while using libmysqlclient_r Can anyone help me out on this . I'm including mysql.h as the header file The platform I'm using is Linux 2.4.4-4 Suse Linux . I'm also using InnoDB tables for the same. regards, void test2(int l = 0 ){ pthread_mutex_lock(lockmutex); FASDBConnection conn1; conn1.Connect(lithium.ini.cmu.edu,shivam_test,shivam,shivam_pass); if(conn1.isConnected()) cout Success Connection endl; else cout Failed Connection endl; for(int i = 0; i 1000; i++){ string query = SELECT * from STUDENTS ; FASDBStatement *r = conn1.createStatement(); FASDBResult rr; rr = r-ExecuteQuery(query); int num = rr.getNumRows(); if(num == 0){ cout Query failed number: (i+1); if(l != 0){ //FAILURE_QUERY[l-1]++; cout Failure Thread Num: l; } cout endl; delete r; continue; } // SUCCESS_QUERY[l-1]++; cout QUERY NO. i endl; while(rr.nextRow()){ FASDBRow row = rr.getCurrentRow(); cout setw(10) row.getString(0); cout setw(10) row.getString(1); cout setw(10) row.getInteger(2) endl; } cout Index :(i+1) ThreadID:l endl; delete r; } conn1.Close(); pthread_mutex_unlock(lockmutex); } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql/Perl installation problem
Hi, It doesn't sound to me that you've installed these packages (if they are packages) for the correct version of perl; Possibly they've been dumped in the OS default? (/usr/lib/perl5/5.00503) etc.? I suggest fetching the latest source from CPAN and building it manually. Chris Evans wrote: I am having a problem with testing MySql (max) version 3.23.49a. I downloaded the 3 required Perl packages (Data-Dumper, DBI, and Msql-Mysql-modules), the latest versions, and installed them. The OS is RH Linux 7.2. The installation of both the binary MySql distribution and the Perl packages seemed to go ok, and the MySql installation passed the little initial tests. I am getting the following error doing run-all-tests: [root@scully sql-bench]# run-all-tests install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: /usr/lib/perl5/5.6.0/i386-linux /usr/lib/perl5/5.6.0 /usr/lib/perl5/site_perl/5.6.0/i386-linux /usr/lib/perl5/site_perl/5.6.0 /usr/lib/perl5/site_perl .) at (eval 44) line 3. Perhaps the DBD::mysql perl module hasn't been fully installed, or perhaps the capitalisation of 'mysql' isn't right. Available drivers: ADO, ExampleP, Multiplex, Proxy. at /usr/local/mysql-max-3.23.49a-pc-linux-gnu-i686/sql-bench/server-cfg line 238 Any thoughts about what is wrong? Thanks. Chris Evans [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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Not null not working??
Well also, 0x00 != 0 and to test for NULL in mysql you need to use special functions IS NULL, IS NOT NULL etc. Rodney Broom wrote: From: Andrew Hazen [EMAIL PROTECTED] If it was blank, the sql statement would fail... Nope, you're passing an empty string with '$login'. NULL is not empty, it's less that that. It's nothing. What you want is: emplogin=$login Rather than: emplogin='$login' ...is SOMETIMES blank where is should be Robyn. Yep, but I'll be that a query from the MySQL client never says the word NULL. --- Rodney Broom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PERL/SQL, again? - Re: Procedures
my thoughts I would assume a plpgsql solution wouldn't be a bad one, All you would really need is IF ELSEIF ELSE and FOR/WHILE, a way for procedures, triggers, views, etc. to be able to access each other with in the syntax of the language (providing routine/function support) along side the ability to access existing functions defined by the db; You may even want to think about providing a very simple push - pull system to allow forks out to external applications (not ideal in most cases but could be very useful in some). /my thoughts Russell E Glaue wrote: Actually, I like this proposal of being able to plug in any language into MySQL. I also want to make a note that Greg Cope has a very good point. I believe it to be good to be able to plug in any language, but the mySQL community may want to make a standard recomendation of a certain language. And going from what Greg mentioned in an earlier e-mail in this thread, the embedded language of choice really needs to be a small and compact language. Perhaps it is feature rich, but still small. A big language like java or perl will most likely slow down the database. What language could MySQL try to standardize on that would not cause the server to slow down or become bulky in memory? I don't know if Python or PHP are necessarilly better choices than PERL or Java under these considerations. I cringe at offering up TCL as an option (don't hit me!). I might go along with using LISP. Does anyone on this list have a suggestion as what might be the best language to embed into MySQL? Be sure to consider memory efficiency, threadding, speed of the language, and compactness (compared to code and library bulkiness). I'd like to hear what other people think? As far as creating a language just to embed in MySQL... this may be tempting, but I think it to be far better to not do this. The problems with inventing a language just for MySQL is stalness of advancing the language, and also innovation and optimization. There are already lots of people in existing communities to improve current program languages. -RG On Tue, 2 Apr 2002, Jeremy Zawodny wrote: On Tue, Apr 02, 2002 at 06:20:41PM -0600, Russell E Glaue wrote: On the mysql-internals mail list we had a thread going about this. I was suggesting something like embedding PERL into MySQL to produce something like PERL/SQL (similar to PL/SQL in oracle). Unfortunately, although promising and liked among people of the list, there are no plan right now to develop anything like this. Atleast no one has taken the initiative to look into this. Actually, there are plans. I've been in at least 2 discussions (1 was in person) about just how it will be done. The plan, last I heard, is to provide a general API for plugging in a language on the back-end. So if you to use Python, you can. If you want to use PHP, you can. Java? Probably. And so on. The only problematic languages are those with threading problems--like Perl. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 54 days, processed 1,508,672,191 queries (319/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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: funny thing with versions
The manual is build (from what I can tell) about a week or so behind the source tree on the work server. If you want to mess with the latest snapshots check out http://www.mysql.com/doc/I/n/Installing_source_tree.html Przemyslaw Popielarski wrote: 3.23.50 not yet published, but 3.23.51 is already being developed, according to the manual at http://www.mysql.com/doc/N/e/News-3.23.51.html. -- ./ premax ./ [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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Load Data Problem
Hi kim, Try using load data local infile '~/Documents/web export.txt' into table stories fields terminated by ',' enclosed by '' escaped by '\\' lines terminated by '\r' (StoryName,Writer,Heading,Caption,Body,ListDate,Section,Publication); Also, if this is a windows text file you should be using \r\n not \r, if this is a unix text file you should simply use \n. Good luck. Kim Kohen wrote: Hello All, I'm having a problem when using Load Data where the single and double quotes in the text file are getting nuked. It appears that the escape character is not being respected but I'm not sure why. It is also knocking out characters near the quotes. The command I'm running is: load data local infile ~/Documents/web export.txt into table stories fields terminated by , enclosed by \ lines terminated by \r (StoryName,Writer,Heading,Caption,Body,ListDate,Section,Publication); A sample of the original text file is: kimtest,Kim,,,this is kim¹s test stories¹ to see how we c¹n accommodate single quotes¹There are a ³couple² of ³double² quotes here to. And ³here are some single¹ quotes that¹re enclosed in doubles²,2002-4-4,, The result from a command line query is: | 253 | this is kim? test stories? to see how we c? accommodate single ?uotes? There are a ?ouple?of ?ouble?quotes here to. And ?ere are some ?ingle?quotes that?e enclosed in doubles? The original file (an csv export from Filemaker Pro) has curly quotes but I have also tried after converting the file to plain text with the same results. Any assistance would be greatly appreciated. Cheers and thanks kim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access sql statement
No, MySQL is not a web server. Rw wrote: Is it possible to access a sql statement to mysql database through Internet explorer ? such as : http://www.abc.com?select * from test Thanks. -- Best regards, Ridwan Goldbase Technology http://www.pembukuan.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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access sql statement
I agree but this one one of those things which _SHOULD_ have been researched. denonymous wrote: From: Colin Faber [EMAIL PROTECTED] Rw wrote: Is it possible to access a sql statement to mysql database through Internet explorer ? such as : No, MySQL is not a web server. Well, it's not an entirely invalid question... One example that comes to mind is accessing ftp://, gopher://, news://, etc from a web browser. Seems like a fairly valid newbie question to me, especially if one is not versed in protocols. -- denonymous www.coldcircuit.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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
PigeonRank
Is it true that mysql is planing to implement google's famous PigeonRank system in it's FTS word weighting schema??? *drool* :-) -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PigeonRank
Who knows with google... ;-) Though I do like Michael's 'peck' 'not-yet-pecked' system. I question though how much more performance we could get out of Rats rather than Winged Rats. Dan Zarrella wrote: i've read the bit on google about thier pigeon rank thing, sounds like a cross between reality and alittle aprils' fools to me, either way id apreciate a better explanation of this technology and how it may be implemented into mysql -dan _ Chat with friends online, try MSN Messenger: http://messenger.msn.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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Very large BLOBS in MySQL 4.0.1
It sounds to me that you're exceeding the maximum packet size mysql can handle. Adriano Manocchia wrote: I've been using a perl script to insert a very large blob (up to about 8 MB) into a DB successfully, but now I need to do it with a 34 MB BLOB, so I upgraded to MySQL 4.0.1. First off, I can't get max_allowable_packet to go higher than 64M, regardless of what I set it to, but that shouldn't be the problem, right? But I still keep getting DBD::mysql::st execute failed: MySQL server has gone away when it tries to do the insert or update. It continues to work fine for smaller files. The field is a longblob, BTW. Any help would be greatly appreciated. And please don't tell me not to store large blobs in the database. I wouldn't be doing it if I didn't have to. Age --- Adriano Age Manocchia [EMAIL PROTECTED] Cornell University AIM/Yahoo/MSN: SalsaSharkNet http://salsashark.net/ageICQ: 5962736 --- The capacity to blunder slightly is the real marvel of DNA. Without this special attribute, we would still be anaerobic bacteria, and there would be no music. -Lewis Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: hits
UPDATE tbl SET Number = Number + 1 WHERE blah; Alex Behrens wrote: Hey Guys, I'm working on a script that displays reviews by a category for my site and I want the pull-down menu to be ordered by the amount of hits each category or review has, is it possible to sort by the amount of hits for a row value? My table is structured as follows: Name, Url, Author, E-mail, Number, Category, Description I want to be able to track the amount of hits per category and I the same categories for displaying all reviews in the table. Does mysql integrate a function like this? Thanks! -Alex Big Al Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access denied on use mysql;
alan, Given the large amount of postings you've made to this list, I suggest that you may be bettered helped via live chat. You can do so by using the mysqldeveloper.com Live Chat system: http://www.mysqldeveloper.com/chat/ which connects you to the #mysql support channel on the EFnet IRC network. alan4100 wrote: mysql kathy, What would happen if you type in mysql -u root -p then type in use mysql -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Adding Columns to table
I suggest using one of the windows GUI clients to modify tables, rather than a command prompt (i.e. winmysql etc). alan4100 wrote: I am creating a database called Meet_a_Geek at MS DOS prompt. The customer table has about 30 fields..no time counting..but I noticed that I cannot go beyond 9 fields without ending with a semicolon. Also another problem crops up when I tried to recreate the customer table with the remaining fields yet to be created. The error message says Customer Table existed. Is there a windows program that I can input all at once with ease? I know more questions are keeping coming in...Please just refer me to good tutorial sites so I can continue and finish this assignment. You may take a glance at my assignment below from cut and paste with dos editor. == == mysql use Meet_a_Geek; Database changed mysql create table customers (Customer_ID INT NOT NULL PRIMARY KEY AUTO_INCREME NT, First_Name VARCHAR(20) NOT NULL, LAst_Name VARCHAR(30) NOT NULL); Query OK, 0 rows affected (0.00 sec) mysql show tables from Meet_a_Geek; +---+ | Tables_in_Meet_a_Geek | +---+ | customers | +---+ 1 row in set (0.01 sec) mysql create table customers (Customer_ID INT NOT NULL PRIMARY KEY AUTO_INCREME NT, First_Name VARCHAR(20) NOT NULL, LAst_Name VARCHAR(30) NOT NULL, address VAR CHAR(50), City VARCHAR(20), State VARCHAR(2), Zip VARCHAR(20), E_Mail VARCHAR(20 ), Age INT); ERROR 1050: Table 'customers' already exists mysql create table customers (Customer_ID INT NOT NULL PRIMARY KEY AUTO_INCREME NT, First_Name VARCHAR(20) NOT NULL, LAst_Name VARCHAR(30) NOT NULL, address VAR CHAR(50), City VARCHAR(20), State VARCHAR(2), Zip VARCHAR(20), E_Mail VARCHAR(20 ), Age INT); -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error message
Normally seen when a client disconnects due to timeout, Or the server doesn't realize the client has disconnected. mysql mailing list user wrote: Hi, In my mysql .err file I get a lot of the following error... Aborted connection 121031 to db: ..connection details... (Got an error reading communication packets) What does this mean, and is it bad, and what do I do about it? Any help appreciated. Howard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: all databases deneid
Try mysql -uODBC -p (-p assuming you have a password on the account) the formula is -optVAL alan4100 wrote: I typed SELECT SYSTEM_USER() ..The output is ++ | system_user() | ++ | ODBC@localhost | ++ 1 row in set (0.00 sec) I then tried mysql -h localhost -u ODBC Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 19 to server version: 3.23.44-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql use mysql ERROR 1044: Access denied for user: '@localhost' to database 'mysql' mysql mysql show databases; +-+ | Database| +-+ | Meet_a_Geek | | database05 | | db001 | | db002 | | mrbs| | mysql | | sample_db | | shopcart| | test| +-+ 9 rows in set (0.00 sec) == I try to use USE command for different datbases indicated by SHOW DATABASES; All are denied access. mysql use Meet_aGeek; ERROR 1044: Access denied for user: '@localhost' to database 'Meet_aGeek' mysql use database05; ERROR 1044: Access denied for user: '@localhost' to database 'database05' mysql use db001; ERROR 1044: Access denied for user: '@localhost' to database 'db001' mysql use db002; ERROR 1044: Access denied for user: '@localhost' to database 'db002' mysql Introduction to MYSQL at your recommendation is confusing because it includes UNIX and Windows. I am using Windows XP. == shell mysql -h host -u user -p Enter password: -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL, FreeBSD problem
With out knowing your system configuration it sounds to me like you've got some problems with locking. I suggest looking into that. Brad Phinney wrote: Hello all. I have an application that does a lot of table creation and writing for a FreeBSD 4.4 SMP machine. Over time, I begin to see the following errors. DBD::mysql::db tables failed: Can't read dir of './p0_samt_trans/' (Errcode: 2) at /var/SAMT/code/SAMTlib/SAMTdb.pm line 2552, FILE chunk 138. DBD::mysql::db do failed: Table 'p3_samt_trans.p3_int_sender_2_12_0' doesn't exist at /var/SAMT/code/SAMTlib/SAMTdb.pm line 2301, FILE chunk 138. These errors seem to happen for no reason. If I issue a select, do or anything else 2 seconds later, I get no errors. The table in question above does in fact exist, although MySQL claims that it does not. The machine (or mysql for that matter) is not under particularly heavy load. It simply occassionally just cant read a database directory for some reason or another. A fraction of a second later, the same command will work fine. Now, I am using the 3.23.47 Free BSD binary from the MySQL site on this machine. I notice that the problem continues to get worse as time goes on. If I restart mysqld however, the problem seems to go away for a bit. But after 2-3 days, the problem comes back. Any ideas? thoughts? Any assistance with this problem would be welcomed. Thanks. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: INSERT ... SELECT not supported?
use an auto_increment column. Or if this is during an UPDATE UPDATE tbl SET col = col + 1 WHERE ..; Allon Bendavid wrote: Hello All- I just read that an Insert ... Select naming the same table is not supported in MySQL. What is the alternative? What we need to do is simply insert the max of a column + 1 to create essentially a counter in a situation where an auto_increment counter would not work. Anyone? -Allon Allon Bendavid Imacination Software [EMAIL PROTECTED]http://www.imacination.com/ 805-650-8153 Visit Imacination and start selling on the Web today with Ch-Ching! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Faxing from MySQL
RDBMS Is not a Fax machine use middleware to do this. Rich Fortnum wrote: Hi there. Anybody know how I can fax using MySQL? I might have an application for this. I would suspect third party software to reach in, generate reports, then fax out. Cheers. @@@ Rich Fortnum / Viaduct Productions / Toronto (EST) @@@ Web Design / Databases / Internet Video / Wireless Data @@@ [EMAIL PROTECTED] / http://www.viaduct-productions.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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Perl core API
With the up and coming libmysqld library this should be possible; assuming you want to sit down and take the time to write a module to interface it. Though I don't really see any advantages to this given the front end interface we have now (DBD::mysql) works like a charm. Regarding procedures, This is something that should be handled by the rdbms it self and not your middleware. Rodney Broom wrote: Has anybody ever talked seriously about a Perl API for MySQL? I'd like to be able to access all phases of the MySQL deamon with Perl in much the same way we access Apache via mod_perl. Things like: - Query rewrite - Data manipulation, pre-storage - Data manipulation, post-query - Prodedures --- Rodney Broom Programmer: Desert.Net Spam filter: sql database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Perl core API
the libmysqld api is part of the 4.x development branch at the moment, I suggest checking that out. If you're interested in the development branch I suggest hopping on to the internals list. Rodney Broom wrote: From: Colin Faber [EMAIL PROTECTED] With the up and coming libmysqld library this should be possible; libmysqld? Sounds interesting, do you have an URL? Though I don't really see any advantages to this given the front end interface we have now (DBD::mysql) works like a charm. As a quick example, I want to be able to define my own datatypes inside the DB. I might do something like storing an image and a bunch of metadata about that image in a single blob() vi Storable::freeze(). Then provide some Perl code plugged into the DB that lets me look at the data inside of blob()s in order to query over images at the SQL level. At this point, I can access the DB from any interface I like: JDBC, DBD::mysql, the mysql client, etc. Regarding procedures, This is something that should be handled by the rdbms it self and not your middleware. Yep, you're right, but I'm not after middle-ware. I'm after a hook into the RDBMS itself. The problem with this, Is if you're not going through the primary engine managing the data it self you run into all sorts of ugly issues with dead locks. --- 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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 1 billion row
Interesting subject ;-) Can you provide some more information; Like exactly what failed, any errors you received, if it crashed, how big the database files got before the failure happened etc. Magyari Istvan wrote: Hi, I have been trying to build a 1 billion row database, in mysql version 3.23.47, under Suse 7.3, but failed a several times, i reached around 600.000.000 rows... The table has an int(10) unsigned and a bigint(20) field, indexed by the bigint(20) field. The hardisk is 26GB SCSI, the computer is a dual Pentium III with 1GHz, with 2GB memory I'd like to have your opinion about what should I be carefull at the table creation or mysqld settings, and how fast will be the queries in this 1 billion row and if its worth to make all in 1 table. Thank you, Magyari Istvan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 1 billion row
Interesting subject ;-) Can you provide some more information; Like exactly what failed, any errors you received, if it crashed, how big the database files got before the failure happened etc. Magyari Istvan wrote: Hi, I have been trying to build a 1 billion row database, in mysql version 3.23.47, under Suse 7.3, but failed a several times, i reached around 600.000.000 rows... The table has an int(10) unsigned and a bigint(20) field, indexed by the bigint(20) field. The hardisk is 26GB SCSI, the computer is a dual Pentium III with 1GHz, with 2GB memory I'd like to have your opinion about what should I be carefull at the table creation or mysqld settings, and how fast will be the queries in this 1 billion row and if its worth to make all in 1 table. Thank you, Magyari Istvan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(WWOT) Re: PHP with TTF fonts
What does this have to do with mysql? Please try a PHP mailing list ps: database, sql, mysql savaidis wrote: Hello again! I see many people works here with php and that's natural, as php is connected with MySQL. In php graphics, I found that printing with a TTF font has no possibility to set the font high. Is this true? Also is not possible to open only once one font file and not as many times as text stings are displayed on the image? This is to slow and consumes to much of server's memory. Thanks Makis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: setup/DBI issues...
A little more information would be helpful, Such as pasting the exact error here. Chris Petersen wrote: ok, after several months away from working with mysql, I figured I should get back into things.. anyway, the server is up and running, and I can access it with the mysql client, but I get an unknown error whenever I try to connect to it via perl DBI... I'm using: DBI-connect(DBI:mysql:$UserID, $UserID, $DBPass); This works on other servers, and is not limited to one single script, so I know it's a config issue on my part.. any help would be greatly appreciated. -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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 'Automating Mailing Facility'
Um.. RDBMS != Bulk Mailer sreedhar wrote: Hi All, Is there any possiblity 'Automating Mailing Facility' like in MS-SQL in MySQL. If not, which mid range database is suitable for me for my project. regards, sreedhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to get connected with mysql using perl scripts
Hi, see the DBI perldoc here is a quick example: my $dbh = DBI-connect(DBI:mysql:mydb, $user, $password) or die Can't connect to $data_source: $DBI::errstr; Charitha wrote: Hi all, Please guide me to get the connection with mysql through perl scripts and through the scripts i have to insert some lot of data in the existing tables. Thank you. Regards, Charitha. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL on the Playstation2?
I think a better question would be why ;-) It's not that I don't love my PS2 I just don't see it as a very good database machine you know ;-) Mark Maunder wrote: Linux for PS2 is being released in Europe in May this year: http://www.scee.com/corporate/pressreleases.jhtml Who's going to be the first to get MySQL to compile on PS2. ;-) ~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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL gurus - easy one.
Correct, If you MUST use date as the column name escape it with forward ticks, `date` Mike(mickalo)Blezien wrote: On Tue, 29 Jan 2002 08:08:44 +0300, Odhiambo Washington [EMAIL PROTECTED] wrote: Please forgive my bad step of joining the list and begining with questions. I'm a NEWBIE at MySQL with very minimal knowledge. I'm beginning to learn (self-teaching). I am trying to create a table and made a file as below: I believe the column name your using date is a reserved word in MySQL Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL undo?
Only in the case of transaction based tables in which you haven't committed; Time to restore a backup. David S. Jackson wrote: Hi, I did a really dumb thing. I went update Tablename set Name = 'Joe Bloe' instead of update Tablename set Name = 'Joe Bloe' where ID = 5. Now all the Name records in Tablename = 'Joe Blow' Damn. I can't believe I did that, but it was a slip of the hand. Is there any easy way to recover that information? Is there an undo command? -- David S. Jackson[EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= You can't have everything. Where would you put it? -- Steven Wright - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how do I search for a substring of a field? sql
Dan, you can use LIKE RLIKE and MATCH() AGAINST() If that's what you're asking. Dan wrote: Anyone know how to seach for a subsctring instead of the whole field? sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 4416 Great Growth Potential 185528
Billy, Block yahoo.com mail they don't do anything about spammers abusing their services ;-) I did that and found that the spam I see dropped by 99% Billy Harvey wrote: On Wed, 2002-01-09 at 23:08, [EMAIL PROTECTED] wrote: OTC News Alerts' Last 3 Picks have gained 358%! Here is our next Hot Pick! Dear MySQL list, I'm afraid I've had it. I don't post often here - but I probably help on average one person a day by working directly with them in the background. I considered it payback for the value I got from others over the years. But, I can't stand the quantity of spam here. The list needs to be made subscriber only, or I suspect the only people that will be left here soon will be the company and the spammers. Good luck to all. Someone let me know if the policy changes. Thanks for a great product. Billy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.47 compile problems with sun's forte compiler
Hi guys, You can also pick up an evaluation version (I think its good for 30 days) of the forte suite from sun's site. Quentin Bennett wrote: From the cc(1) man page for Forte Developer 6.2 These predefinitions are valid in all modes: __sun __unix __SUNPRO_C=0x530 __`uname -s`_`uname -r` __sparc (SPARC) __sparcv9 (SPARC with -xarch=v9|v9a) __i386 (x86) __BUILTIN_VA_ARG_INCR __SVR4 __SUNPRO_C looks like it might be a good one to try for. Version 5.2 had __SUNPRO_C=0x500 HTH Quentin -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Friday, 4 January 2002 3:31 p.m. To: Shakeel Sorathia Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: 3.23.47 compile problems with sun's forte compiler Hi! Shakeel == Shakeel Sorathia [EMAIL PROTECTED] writes: Shakeel Thanks for the help on this, it seems to be working now. One question Shakeel though, wouldn't configure be able to take of this? The problem is that as I don't have access to a Forte compiler, so I haven't been able patch configure to detect this case.. Do you know if Forte defines some unique define we can trigger on ? Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(WOT) Re: Perl problem
From the DBI manual: $dbh = DBI-connect($data_source, $username, $auth, \%attr); You're not telling DBI what the DSN is (Data source name) John Mayson wrote: I've decided to graduate to the next step and access my mySQL databases with Perl. I am attempting this on a Win2000 machine. Here's my code... #!C:/perl/bin/perl.exe -w use strict; use CGI qw(:standard); use DBI; my $dbh = DBI-connect('Radio', 'root', ''); I get this error message... Can't locate object method connect via package DBI (perhaps you forgot to load DBI?) at C:\Program Files\Apache Group\Apache2\cgi-bin\rdb.pl line 7. DBI.pm lives under c:\perl\lib which is in my @INC. Ideas? John -- John Mayson KC4VJO Linux/Perl/HP-UX/ICT Austin, Texas 78729 30.4560N 97.7851W [EMAIL PROTECTED] http://www.nyx.net/~jmayson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: UNIX_TIMESTAMP() INT unsigned problems
Michael Widenius wrote: Hi! Colin == Colin Faber [EMAIL PROTECTED] writes: Description: Colin When attempting to select a result set by subtracting the value Colin of an unsigned INT column against UNIX_TIMESTAMP() the result set Colin is invalid. How-To-Repeat: Colin Test case: mysql create table t (ts int unsigned not null); insert into t values (1008884715), (1008886691), (1008887691); Colin Query OK, 0 rows affected (0.05 sec) Colin Query OK, 3 rows affected (0.00 sec) Colin Records: 3 Duplicates: 0 Warnings: 0 mysql select (ts - unix_timestamp()) from t; Colin +-+ Colin | (ts - unix_timestamp()) | Colin +-+ Colin |18446744073709551463 | Colin |1823 | Colin |2823 | Colin +-+ Colin 3 rows in set (0.01 sec) The above is correct; You are subtracting two unsigned values, and the result is unsigned. Compare how C works! cut Colin As shown above this can be correct by using a variable which I believe recasts the Colin result set as a signed int. Colin This problem first appeared in 4.0.0-alpha and has been verified by multiple people. Yes; The difference is that MySQL 4.0 can now correctly handle unsigned values; Something that was wrong in 3.23. If we would try to fix this, then we would not anymore have full support of 64 bit values in MySQL. The proper way to fix this is to add a cast operator for unsigned to signed and vice versa. We shall look into doing this. Agreed; But isn't this a case where an expected result of zero is more important that the unexpected `true' result of `18446744073709551463'? I don't know how other people feel about this but I personally think a NULL value, zero value or error returned would be a better solution. 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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
UNIX_TIMESTAMP() INT unsigned problems
Description: When attempting to select a result set by subtracting the value of an unsigned INT column against UNIX_TIMESTAMP() the result set is invalid. How-To-Repeat: Test case: mysql create table t (ts int unsigned not null); insert into t values (1008884715), (1008886691), (1008887691); Query OK, 0 rows affected (0.05 sec) Query OK, 3 rows affected (0.00 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql select (ts - unix_timestamp()) from t; +-+ | (ts - unix_timestamp()) | +-+ |18446744073709551463 | |1823 | |2823 | +-+ 3 rows in set (0.01 sec) mysql alter table t modify ts int; Query OK, 3 rows affected (0.19 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql select (ts - unix_timestamp()) from t; +-+ | (ts - unix_timestamp()) | +-+ |-174 | |1802 | |2802 | +-+ 3 rows in set (0.01 sec) mysql alter table t modify ts int unsigned; Query OK, 3 rows affected (0.24 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql select (ts - unix_timestamp()) from t; +-+ | (ts - unix_timestamp()) | +-+ |18446744073709551421 | |1781 | |2781 | +-+ 3 rows in set (0.00 sec) mysql set @ts=0; select @ts:=ts, (@ts - unix_timestamp()+0) from t; Query OK, 0 rows affected (0.00 sec) +++ | @ts:=ts| (@ts - unix_timestamp()+0) | +++ | 1008884715 | -290 | | 1008886691 | 1686 | | 1008887691 | 2686 | +++ 3 rows in set (0.01 sec) Fix: As shown above this can be correct by using a variable which I believe recasts the result set as a signed int. This problem first appeared in 4.0.0-alpha and has been verified by multiple people. Submitter-Id: Originator:Colin Faber Organization: fpsn.net, Inc. MySQL support: none Synopsis: subtraction on an unsigned INT column against UNIX_TIMESTAMP() returns an invalid result set when the resulting value is below zero. Severity: serious Priority: high Category: mysql Class: sw-bug Release: mysql-4.0.0-alpha (Source distribution) Environment: System: FreeBSD 4.3-STABLE - SMP GCC: Using builtin specs. gcc version 2.95.3 [FreeBSD] 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 1202644 Jul 15 23:17 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 9 Jul 15 23:17 /usr/lib/libc.so - libc.so.4 lrwxr-xr-x 1 root wheel 9 May 18 2001 /usr/lib/libc.so.3 - libc.so.4 -r--r--r-- 1 root wheel 570968 Jul 15 23:17 /usr/lib/libc.so.4 Configure command: ./configure --prefix=/usr/local/mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(WOT) Re: SOFTWARE TESTERS DEVELOPERS CONTRACT TO HIRE
A better question is why hasn't this host `From:' been banned yet? This is the second time in a month that this guy has spammed the lists with his garbage. Shankar Unni wrote: rc wrote: anyone know why i'm getting these spam emails over this list Because it had the magic word sql, which the filter checks.. -- Shankar. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Searchable Mailing List Archive now up.
Hi guys, I think i've already pointed this out but im also archiving ALL of the mailing lists from mysql at http://www.mysqldeveloper.com/lists/ Tony Buckley wrote: - Original Message - From: Robert Alexander [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, December 14, 2001 9:19 PM Subject: MySQL Searchable Mailing List Archive now up. So, being ahem 'between contracts' right now, I decided finally to write one. I've actually been keeping an archive of the MySQL list for quite a while in anticipation of doing this some day. Just doin' my bit... The archive is at http://archive.workmate.ca/myarchive Simply fabulous! Thanks! Tony - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlclient.lib compiling problem
I've run into the same problem with mysql++'s msvc++ port mysql++.lib. Devore, Jacob wrote: I am trying to link with the static lib mysqlclient.lib and keep getting errors like this mysqlclient.lib(libmysql.obj) : error LNK2001: unresolved external symbol _WSAGetLastError@0 I have the mysql version 3.23.45, running win2k, compiling on vc6. Thanks, jake - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlclient.lib compiling problem
no, I haven't fixed it yet ;-) Devore, Jacob wrote: How did you fix it, just use the dll? Thanks, jake -Original Message- From: Colin Faber [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 5:07 PM To: Devore, Jacob Cc: '[EMAIL PROTECTED]' Subject: Re: mysqlclient.lib compiling problem I've run into the same problem with mysql++'s msvc++ port mysql++.lib. Devore, Jacob wrote: I am trying to link with the static lib mysqlclient.lib and keep getting errors like this mysqlclient.lib(libmysql.obj) : error LNK2001: unresolved external symbol _WSAGetLastError@0 I have the mysql version 3.23.45, running win2k, compiling on vc6. Thanks, jake - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Feature request
Hi, I've got a feature request which I don't think should be all that hard to implement (if not already) With in the mysql fulltext search system if your search words exist in more than 50% of the records; it is ignored. How about having mysql return either an error or set something that can be retrieved which will notify if this event happens. A feature like this would allow people that use the FTS as the bases of a search engine to return nifty little `google like' results. The following words were not included in the search because of their commonality with in our database .. 'words' etc. -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
libmysqlclient documentation project
Is anyone else interested in documenting libmysqlclient? Just a basic set of function guidelines would be nice. -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please redo this horrible web page
Hi guys, Locally I've already redone that for mysqldeveloper.com, Give it a look-see http://www.mysqldeveloper.com/lists/ Alexander Skwar wrote: So sprach »Keith C. Ivey« am 2001-11-28 um 16:27:46 -0500 : Does that work for you? The MySQL button on the side links to a Yep, it does. Mozilla 0.9.6, Opera 5.05tp1 and Konqueror 2.2.1 checked; all on Linux. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.iso-top.de | Jabber: [EMAIL PROTECTED] iso-top.de - Die günstige Art an Linux Distributionen zu kommen Uptime: 5 days 14 hours 49 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Annoying DBD-mySQL error wont go away
You've failed to close your prepare() statements with finish() See the perldoc on DBI again. Jaime Teng wrote: Hi, I have been pulling my hair due to this annoying error. x( DBI::db=HASH(0x1d2998c)-disconnect invalidates 1 active statement handle (either destroy statement handles or call finish on them before disconnecting) at C:\WEBSITE\script\default.pl line 721. It is a Perl CGI script and at line 721 is a simple disconnect command: 721 $DBH-disconnect; 722 723 binmode STDOUT; 724 print Content-type: text/html\cM\cJ; 725 print Content-length: ,length($HTTP),\cM\cJ; 726 print \cM\cJ; 727 print $HTTP; The error message is straight forward and means that I have an open mySQL handle that is not closed; example: $sth=$DBH-prepare(SELECT ..); $sth-execute; $DBH-disconnect; --- should have been a fetch before disconnect. But I am dead sure I have a result collector: $sth=$DBH-prepare(SELECT ..); $sth-execute; $result = $sth-fetchrow; I only use three functions: prepare, execute and fetchrow. For all intents and purposes, I have reviewed the script line per line and even made sure that each select will give only one result by adding LIMIT 1 $sth=$DBH-prepare(SELECT .. LIMIT 1); arg! I am Perl built 626 on win2000. Mysql 3.23.37 I have encountered this kind of errors on Linux+Apache before and I solved it via: $sth=$DBH-prepare(SELECT ..LIMIT 1); $sth-execute; while ( $result = $sth-fetchrow ) {1}; It appeared to me that even if only one result is to be expected, mysql would throw more than one. or is this a problem with DBD-Mysql module? 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: No curses/termcap library found
Sorry; you'll have to check your local man page for the syntax to match your machine. ncurses - CRT screen handling and optimization package http://www.gnu.org/software/ncurses/ncurses.html If this is a solaris machine you can probably find a pre-built package at sunfreeware.com Gabriel Richards wrote: Thanks for the quick reply! Running ldconfig -r | grep curses gives me an error saying option requires an argument -- r What is ncurses library and an ld path? If I find / -type f -name termcap the file is found at /etc/termcap. Thank you for your help! Gabe -Original Message- From: Colin Faber [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 12:45 PM To: Gabriel Richards; [EMAIL PROTECTED] Subject: Re: No curses/termcap library found Make sure you have an ncurses library installed and is in your ld path ldconfig -r | grep curses Gabriel Richards wrote: I'm trying to compile MySQL from source, the above subject is the error I get after ./configure --prefix=/usr/local/mysql Help is sincerely appreciated! Gabe - Ender Technology Websites, Database Applications, Hosting (310) 516-7411 [EMAIL PROTECTED] http://www.endertechnology.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Dictionary
Hi, load your dict file with LOAD DATA INFILE very easy; pretty quick ;-) If you don't want to mess with that, I just dumped my dictionary database. Here is the link to where you can download that dump file: http://brimstone.fpsn.net/~cfaber/mysql/dict.sql.gz Michael wrote: Does anyone know where to get a dictionary that would be for sql. I was attempting to write up a few scripts for password stuff and thought it would be easy if someone knew where to obtain a dictionary in sql format. Any ideas would be helpful. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
(WOT) Re: taiwan.com
Um. I block every domain I catch spamming and my users don't seem to have problems. kronos wrote: Guys... this is the internet just delete the spam... and dont complain like a school girl with a skinned knee... I am a system admin and if i blocked every domain that sent spam mail people would only be able to email to other on our domain.. Spam Happens.. delete it and go on with your day... If you really want to stop spammers... preach about turning off MAIL RELAYING. most spammers telnet into a servers incomming mail port and send the spam.. so other than lazyness and stupidity it usally isnt the Domains fault... now... can we use this list for MySQL relayted stuff... thats why its here... Adam Graham Datastream Cowboys Inc mysql,database,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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to turn beeping off
Hey now, why would you want to turn it off, After all its a `feature' [EMAIL PROTECTED] wrote: Back a few years there was a nasty little virus that played Chops on your WinDoDie box's and we had to unplug the PC Speakers on a couple dozen becuase there was not fix for it at the time. Or was it cause they where to cheap..hmm. Does anyone know how to turn that annoying beeping off in the text mode utilities such as mysql.exe? Cut the speaker cable. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Newsgroups
In the next version of my mysqldeveloper site (which I hope to release here pretty quick) it will support a feature to show you which messages are new and which you've already read. Hope this helps ;-) BD wrote: PMFJI, Do any of the public web archives of the list suit your needs? Have you seen them? It's fine for archived messages but too hard to find new messages, say within the last 7 days. Staying current with MySQL is a lot harder with the mailing list because you have to keep up with the mail each day. A newsgroup is much better because you know the messages can be browsed whenever you want. It puts the messages in a tree and makes viewing pertinent threads a breeze, especially with an offline newsgroup reader like Agent. You see the complete thread without getting inundated with 60-90 messages every day. The newgroup can still be archived to the public web archive. Would you want a uni-directional news gateway or bi-directional? Bi-directional. Where do I sign up? g Brent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Yes or No
I fail to see why ENUM() isn't used in this case, This is exacly what its for. Carl Troein wrote: Benjamin Pflugmann writes: Hi. On Tue, Oct 02, 2001 at 09:33:53AM +, [EMAIL PROTECTED] wrote: [...] I've seen rumors about bool being an alias for tinyint(1), but it's not in the manual and I haven't tested it. Actually, it's in the manual (but just recently ;), but it tells otherwise: http://www.mysql.com/doc/C/o/Column_types.html Ah. One question about using CHAR(1) as BOOL, though: Will the value be stored as 0/1 or as '0'/'1'? The former would give all sorts of troubles, and the latter would require a huge number of string-int conversions when the column is used in a WHERE. Is the performance difference between BOOL and TINYINT(1) know? Oh, and Benjamin, could you _please_ not send me two copies of the mails when you reply. I _am_ on the mysql list, you know, so there's absolutely no need to send both to the list and to my email address. //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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: repost: Too many open files
it sounds like you've run out of file descriptors, I suggest rebuilding your kernel to handle more. In a bsd kernel you can do this simply by upping the maximum number of users allowed to access the machine at any given time. Robin Keech wrote: Hi, Any help would be greatly appreciated as I have a production server that is struggling. (I only get the digest list, so could you copy me on any replies - thankyou). My error log show this... 011002 9:16:11 Error in accept: Too many open files 011002 9:36:43 /usr/local/mysql/libexec/mysqld: Shutdown Complete 011002 09:36:43 mysqld ended 011002 09:36:52 mysqld started 011002 9:36:52 Warning: setrlimit couldn't increase number of open files to more than 1024 011002 9:36:52 Warning: Changed limits: max_connections: 500 table_cache: 257 /usr/local/mysql/libexec/mysqld: ready for connections I am getting the too many open files error. What does the setrlimit log line mean? How many connections can I have before reaching 'too many connections'? What can I do about it? I have looked in docs. open_files_limit If this is not 0, then mysqld will use this value to reserve file descriptors to use with setrlimit(). If this value is 0 then mysqld will reserve max_connections*5 or max_connections + table_cache*2 (whichever is larger) number of files. You should try increasing this if mysqld gives you the error 'Too many open files'. mine is 0 so it should use quite a big number ( 500 * 5) - is this too big? Should I set open_file_limits directly to something smaller? I have ... /proc/sys/fs/file-max = 8192 /proc/sys/fs/file-nr = 2097 14118192 my.cnf # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking set-variable= key_buffer=384M set-variable= max_allowed_packet=2M set-variable= max_connections=500 set-variable= table_cache=512 set-variable= sort_buffer=2M set-variable= record_buffer=2M set-variable= thread_cache=8 set-variable= wait_timeout=1800 # Try number of CPU's*2 for thread_concurrency set-variable= thread_concurrency=4 set-variable= myisam_sort_buffer_size=64M log-bin low-priority-updates binlog-ignore-db=e3 server-id = 1 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.282 / Virus Database: 150 - Release Date: 25/09/01 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: strange error message
run the perror app provided with your distrobution perror 13 Casey Tourangeau wrote: Hi, I'm using MySQL v3.23.42 with Mac OS 10.1, and whenever I try to create a database (logged in as root), i get the error create database 'name'. (errno: 13). Does anyone have any idea what that might mean? I tried manually instering data into the mysql.* tables, but with no luck... Thanks for any help! Casey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql List Bounce Message?
As near as I can figure there are a few people out there that have yet to setup their MTA's correctly, so they think they're receiving messages for any addresses in the headers of the email. Jason Frisvold wrote: Can anyone explain why I'm getting a Mail account is disabled message from [EMAIL PROTECTED] regarding anything I post to the mysql list? The body of the message says : The mail account ([EMAIL PROTECTED]) is currently disabled, and is not receiving mail at this time. Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- So Long and Thanks for all the Fish -- Douglas Adams [1952-2001] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Mysql List Bounce Message?
Also, a simple fix for you sendmail guru's HFrom: tab $check_from Scheck_from [EMAIL PROTECTED] tab $#error $@ 5.5.5 $: Broken MTA, Message ignored Cheers. Colin Faber wrote: As near as I can figure there are a few people out there that have yet to setup their MTA's correctly, so they think they're receiving messages for any addresses in the headers of the email. Jason Frisvold wrote: Can anyone explain why I'm getting a Mail account is disabled message from [EMAIL PROTECTED] regarding anything I post to the mysql list? The body of the message says : The mail account ([EMAIL PROTECTED]) is currently disabled, and is not receiving mail at this time. Thanks, --- Jason H. Frisvold Senior ATM Engineer Engineering Dept. Penteledata CCNA Certified - CSCO10151622 [EMAIL PROTECTED] --- So Long and Thanks for all the Fish -- Douglas Adams [1952-2001] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Illegal table names
you can try DROP TABLE `table name`; Håkan Elmqvist wrote: By accident, I don't know how (perhaps microsoft played me a trick), I managed to create a table with a name containing spaces i. e. a useless table with an illegal name. Now would like to drop that table. Is there anyone who knows how? H Professor Håkan Elmqvist Avdelningen för medicinsk teknik Institutionen för medicinsk laboratorievetenskap teknik KAROLINSKA INSTITUTET Novum 141 57 Huddinge Tel 46-8-585 837 55, Fax 46-8-779 55 50 epost [EMAIL PROTECTED] Organisationsno. 01 202100-2973 01 Vat No. SE 202100297301 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Illegal table names
forward ticks Håkan Elmqvist wrote: Thanks for your very rapid response but: mysql show tables; +--+ | Tables_in_test | +--+ | personer | | resultat impl VT2001 | | tentamen_impl_vt2001 | +--+ 3 rows in set (0.00 sec) mysql drop 'resultat impl VT2001'; ERROR 1064: You have an error in your SQL syntax near ''resultat impl VT2001'' at line 1 mysql drop resultat impl VT2001; ERROR 1064: You have an error in your SQL syntax near 'resultat impl VT2001' at line 1 H Professor Håkan Elmqvist Avdelningen för medicinsk teknik Institutionen för medicinsk laboratorievetenskap teknik KAROLINSKA INSTITUTET Novum 141 57 Huddinge Tel 46-8-585 837 55, Fax 46-8-779 55 50 epost [EMAIL PROTECTED] Organisationsno. 01 202100-2973 01 Vat No. SE 202100297301 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Illegal table names
if all else fails shut the db down and go in your db directory and just delete the data files ;-) Håkan Elmqvist wrote: mysql drop `resultat impl VT2001`; ERROR 1064: You have an error in your SQL syntax near 'resultat impl VT2001`' at line 1 I don't seem to have the proper character `. What's the ASCII? H Professor Håkan Elmqvist Avdelningen för medicinsk teknik Institutionen för medicinsk laboratorievetenskap teknik KAROLINSKA INSTITUTET Novum 141 57 Huddinge Tel 46-8-585 837 55, Fax 46-8-779 55 50 epost [EMAIL PROTECTED] Organisationsno. 01 202100-2973 01 Vat No. SE 202100297301 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: PHP variable conversion problem.
This really isn't a MySQL question and should be handled by another list, But to answer your question (logically). You need to have the whole string `productcategory.ID=\$cat\' optional, so that if your variable `$cat' isn't populated the string `productcategory.ID=\$cat\' isn't included, Also you should use what ever methods PHP provides to escape the $cat string so users can't break it with in it. Neil Silvester wrote: Another PHP problem has kept me up all night, scouring through my database books and trying everything I could think of. I am still new to the MySQL and PHP field, but never the lass I will not give up. $cat is a variable that is passed to the query from the previous page. The SELECT statement works faultlessly, except for the point at which no choice is made from the drop down on the page prior to this one. I have set a value of x to the drop down for a non selection, but am having problems converting that x value to a % value withing my SELECT statement. I am assuming that I will need an IF THEN before the SELECT, but I have tried several variation to no avail. $result = mysql_query(SELECT CompetitorName FROM competitor, competitorproducts, productcategory WHERE competitorproducts.CompID=competitor.ID AND productcategory.ID=\$cat\ AND competitorproducts.CatID=productcategory.ID ); Any help would be mostly appreciated. Thanks. Neil Silvester Webmaster / Systems Administrator Heat and Control Inc. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error From Web Site
Try the PHP list, This is not a MySQL error. System Administrator a.k.a. The Root of the Problem wrote: I am getting a Warning: Supplied argument is not a valid MySQL result resource in /usr/home/tsguide/html/ssi/phpfunctions.php on line 48 No results were found ... Pointers please. -- contact: Dave Yadallee NetLine 2000 The Edmonton Internet Service Company [EMAIL PROTECTED] http://www.nl2k.ab.ca 990-3244 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: EMS MySQL Manager 0.92 released
No problems here, Possibly mailing list issues? Peter Harvey wrote: Ok... this is getting out of hand. Is it just me or are we getting a posting every week on this? Please keep these postings to majour releases (1.0, 2.0, etc)... at most. Post your minor releases to your own mailing list. This is a relevant product but we do not want to pollute the list. Thanks! Peter Table,MySQL - Original Message - From: Igor Brynskich [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 17, 2001 9:32 AM Subject: ANN: EMS MySQL Manager 0.92 released Dear Sirs and Madams, EMS HiTech company is announcing the next version (0.92) of MySQL Manager -- A Powerful MySQL Administration and Development Tool for Windows95/98/ME/NT/2000/XP. You can download the latest version from http://www.mysqlmanager.com/download.phtml What's new in version 0.92? 1. New services were added. Check out the Service menu to find this new features. Now you can Analyze, Check, Repair and Optimize tables step by step with corresponding wizard: a) Analyze Tables wizard allows you to analyze and store the key distribution for specified tables. b) Check Tables wizard allows you to check specified tables for errors. c) Repair Tables wizard allows you to repair a possible corrupted tables. d) Optimize Tables wizard allows you to optimize tables with variable-length rows. 2. The Server Properties menu item was added. Now you can get a detailed information about MySQL server, such as server version, server variables and currently running processes. See menu Service to find it. 3. A few little improvements and minor bugfixes were added. What is the EMS MySQL Manager? EMS MySQL Manager provides you powerful and effective tools for MySQL Server administration and objects management. Its Graphical User Interface (GUI) allows you to create/edit of all MySQL database objects most easy and simple way, run SQL scripts, manage users and administrate users' privileges, visually build SQL queries, extract or print metadata, export/import data, view/edit BLOBs and many more services that will make you work with MySQL server as easy as you want... Best regards, EMS HiTech development team. http://www.ems-hitech.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: DBI-1.18.tar.gz Can't gzip -cd
I would even suggest not using zcat given the solaris version only examins .Z files. try: cat DBI-1.18.tar.gz | gunzip - | tar xvf - this should work on all versions of solaris any just about any other unix (assuming gzip is installed with a working tar) Adams, Bill TQO wrote: rjtalbo wrote: I have been trying to uncompress DBI-1.18.tar.gz which I downloaded together with Msql-Mysql-modules-1.2216.tar.gz Data-ShowTable-3.3.tar.gz from the MySQL down load page... I followed the direction in the DBE-1.18 README but if I use the pipe as instructed... gzip -cd DBI-1.18.tar.gz | tar xf -cd DBI-1.18 I get tar: Cannot open -cd: No such file or directory Depending on your OS, One of: zcat DBI-1.18.tar.gz |tar xf - tar xfvvz DBI-1.18.tar.gz gzip -cd DBI-1.18.tar.gz |tar xf - --Bill - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL and Perl (STOP)
STOP PLEASE. Not again. See mailing list archives. [EMAIL PROTECTED] wrote: PHP's mysql_fetch_array() fetches an associative as well as indexed array...or you can specify which. (I'm a huge fan of perl, btw, and have used it to talk to mysql when PHP was just a baby language so no flames...just setting the record straight...) Cheers jenn Rich Duzenbury wrote: PHP has built in functions that will dump an entire row into an array (this works with CSV and SQL databases).well there is my 2 cents worth on PHP+MySQL Um, not to start a language war, perl also can dump a row into an array, as well as into a hash so that one can refer to fields by name, not just ordinal number. Regards, Rich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with using mysqladmin
if(redhat){ Fear RPM install's } else { ./mysqladmin -uroot -hlocalhost password } Farzad Faramarzi wrote: Hi I tried to set the password to mysql by using mysqladmin and I received the following error message - ./mysqladmin -u root password ./mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! --- I checked if mysql is running and it does, as you can see here --- [root@c-dffd70d5 bin]# ps -d PID TTY TIME CMD 677 ?00:00:00 safe_mysqld 704 ?00:00:00 mysqld 708 ?00:00:00 mysqld 709 ?00:00:00 mysqld 1030 pts/100:00:00 bash 1054 pts/100:00:00 ssh 1055 ?00:00:00 sshd2 1086 pts/200:00:00 ps God, please help me! What am I doing wrong??? Thanx Farzad - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: output to csv
Yes, the same way you would with the INFILE syntax Steve Doig wrote: Hi Folks, I'm running a batch command in win2K: cmd mysql batch-file output.txt In the batch file, can I specify that values are separated by commas instead of tabs? Cheers, Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MAILER-DAEMON@123box.co.uk: 123box.co.uk mail delivery system
Yes. s . keeling wrote: Is anyone else getting these goofy bounces from 123box.co.uk besides me? Should I report them to Spamcop? :-) database, sql, ... -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FW: sql
With out knowing the exact error im guess its because you're trying to start the server as root. Sheena Sidhu wrote: Hi All, I have installed mysql-max. Previously I had the mysql verion 3.23.40 without max libraries on the same machine. When I start the server , I get the following messages: Please help ! Urgent! *** [root@arulacc mysql-max-3.23.41-pc-linux-gnu-i686]# vi INSTALL-BINARY [root@arulacc mysql-max-3.23.41-pc-linux-gnu-i686]# ./bin/safe_mysqld --user=mysql [1] 30123 [root@arulacc mysql-max-3.23.41-pc-linux-gnu-i686]# Starting mysqld daemon with databases from /usr/local/mysql-max-3.23.41-pc-linux-gnu-i686/data 010827 12:20:13 mysqld ended [1]+ Done./bin/safe_mysqld --user=mysql [root@arulacc mysql-max-3.23.41-pc-linux-gnu-i686]# ps -ef | grep mysql [root@arulacc mysql-max-3.23.41-pc-linux-gnu-i686]# - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë
Sasha, Are you sure its working? Zusky wrote: Part 1.1Type: Plain Text (text/plain) Encoding: quoted-printable Name: ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.com ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.comType: MS-DOS Application (application/x-unknown-content-type-comfile) Encoding: base64 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë
sendmail++ Van wrote: Colin Faber wrote: Sasha, Are you sure its working? Zusky wrote: Part 1.1Type: Plain Text (text/plain) Encoding: quoted-printable Name: ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.com ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.comType: MS-DOS Application (application/x-unknown-content-type-comfile) Encoding: base64 Doesn't appear to be, Colin. Procmail recipe that's been effective on SirCam: # ~/.procmailrc which should be chmod-ded 0600 on a *n*x system # Ignored otherwise SUBJECT=`formail -xSubject: \ | sed -e 's/[;\`\\]/ /g' \ | expand | sed -e 's/^[ ]*//g' -e 's/[ ]*$//g'` :0 { :0 Bh *I send you this file in order to have your advice *daeLRCQEM9KJEIN8JAwAdBmLRCQEi1QkCIkQi0QkDCtEJAiLVCQEiUIEg8QUXV9eW8NTVldV |(formail -rtb -I Precedence: junk \ -I Subject: VIRUS! $SUBJECT \ -I bcc: [EMAIL PROTECTED]; \ echo This message is infected with the SirCam worm. Please see; \ echo http://www.wired.com/news/technology/0,1282,45427,00.html for more information.)\ |$SENDMAIL -oi -t } I realize the MySQL list runs qmail (or, did before the recent outbreak{s}). Modify as useful. 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: ????????????????
Sasha, Hey that works for me. I'm personally not to fond of HTML email any ways ;-) Sasha Pachev wrote: On Wednesday 22 August 2001 01:53, Colin Faber wrote: Sasha, Are you sure its working? That is a bug in the filter, or rather a lack of feature. It is currently treats everything after the header as the boby, and it accepted quoted-printable in the header of one attachment part because it contained table as substring. I will fix up the filter to bounce everything with attachments - this will encourage MS Outlook users to turn off HTML when posting to the list. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: password()
Are you sure its not the full page ads and embedded ad-spam in cnet articles? s. keeling wrote: On Wed, Aug 22, 2001 at 03:19:43PM -0600, Sasha Pachev wrote: Just to make it difficult for people to migrate to Oracle, the only documentation that we provide for the PASSWORD() function algorithm is the source :-) On a serious note, what is it that makes MySQL not good enough for your application that you have to migrate to Oracle? If it already works, you have found your way around the lack of sub-queries and enforced referential integrity. Performance wise, MySQL is much faster on the same hardware in most cases. Perhaps you could consider convincing your management that you will get better value of your money if you just purchase MySQL support. I just had a discussion with a friend who decided he couldn't care less how fast, cheap, and efficient MySQL was; Oracle was his gravy train, and he was not about to suggest anything as radical to others as giving up their common gravy train. I asked him if the Oracle experience he'd picked up was _Oracle specific_ skills, or just basic rdbms skills, to which he never replied. But then, Oracle is all the recruiters are looking for on their resumes; why would they put MySQL or rdbms there if recruiters were looking for Oracle? I just don't get it. Oracle promises features that never seem to work 'til years afterwards, costs a mountain of money, and (for instance) SQL*Plus is garbage compared to mysql-client. It must be the glossy brochures. MySQL needs glossy brochures. -- Any technology distinguishable from magic is insufficiently advanced. TopQuark Software Serv. Contract programmer, server bum. [EMAIL PROTECTED]Give up Spammers; I use procmail. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Got an error reading communication packets
Before posting, please check: http://www.mysql.com/manual.php (the manual) -- http://lists.mysql.com/ (the list archive) DS wrote: Anyone seen this in your log file before? It's perlscripts on the same host, so before the DBI routine all the data needed for an insert is on the machine, not like it's loggin in from another machine. Could this be a problem with the loop back device? Any other ideas as to what causes mysql to spit this out? Thanks David 010804 20:00:40 mysqld started /usr/local/mysql/bin/mysqld: ready for connections 010805 4:08:29 Aborted connection 140 to db: 'rose' user: 'rainman2' host: `localhost' (Got an error reading communication packets) 010805 4:09:48 Aborted connection 166 to db: 'rose' user: 'rainman2' host: `localhost' (Got an error reading communication packets) = http/email [EMAIL PROTECTED] +380676920324 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: WANTED: Utility to reverse engineer existing database
For mysql you can use mysqldump Kevin wrote: I need a utility that will probe my existing mysql database, analyze the 90+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Fwd: This Ad Really Works!!!
Is the filter no longer working? snip bullshit spam PS database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php