Re: Problems with text fields
what's you table definition, what;s your query - Original Message - From: "Thomas Kaester(global)" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 11:10 AM Subject: Problems with text fields Hello everybody, ich have a few problems with text fields. I want to get the text data of a mysql text field. The saved texts are longer than 256 characters. But if I use a select statement mysql returns only 256 characters! Do anybody know why and what I have to do? Greetings Tom - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: World's Money Monitoring on the Net!
Dear Mr. Stephen K. Horn, (WHITE HOUSE - USA) As being as Global Products Information Consultant, I have Invented a totally new Concept, using which the World's Money systems can be Monitored by using a single software on the Internet. Please help me to implement my Invention! I have Lost all my Money in last more then 20 years for studying the World Markets! And the most thing is that I have no qualification background, but belongs to a Multimillion's Family from New Delhi. My openion is "One Man can Change the World's Economy" but if truly aand honestly implemented by the Governments of local countries individually. For which I am always afraid of Indian Economy, Indian Politicians and Businessmen have Zero down this Economy! Warmest Regards Sunil Kumar Jain Director Rubber Consultants (INDIA) ( A Unit of Yeshu Eurotech Technologies Pvt.LTD.,) 5/4, Film Colony, 1st. Floor, R.N.T Marg, Indore 452 001 MP State, INDIA Tel: 91-731-556718 Cellular: 91-0-98260-17226 Fax: 91-731-515883 www.RubberSources.com Coming Up Soon! www.MyRubberShop.com www.Polymersources.com www.RubberSearch.com www.Archits.com And So On!
SV: CREATE TABLE / Telnet (Linux / Unix server)
This command should be invoked from the shell as the command: mysql --user mysqlusername -pmysqlpasswd database test.sql is actually running the mysql frontend with a username, password choosing database named "database" and executing all commands from test.sql before exiting. If you want to invoke the same command from within mysql frontend you write (after choosing \u "database") mysql \. test.sql or you could actually just copy and past the items if you have an ssh og telnet which support copying and pasting from your favorite workstation to your favorite server :o) (I do that sometimes, but it's a lazy thing to) mvh: Pl Wester, programmerer never.no as, stortingsgt 30, 0161 Oslo tlf: 22 01 66 20, fax: 22 01 66 21 direkte: 22 01 66 34, 906 900 62 http://never.no - icq:103476059 ~ f u cn rd ts u prb a gk ~ -Opprinnelig melding- Fra: C.o.m.b.u.s.t. [mailto:[EMAIL PROTECTED]] Sendt: 12. februar 2001 08:31 Til: Nielsen; [EMAIL PROTECTED] Emne: Re: CREATE TABLE / Telnet (Linux / Unix server) Ok, I am trying to execute the CREATE TABLE command through telnet and the "test.sql" file is residing in the directory /home2/fullboreidiot/test.sql and I put in the command how I'm assuming it would be executed: mysql mysql fullboreidiot /home2/fullboreidiot/test.sql; and I get the following error: ERROR 1064: You have an error in your SQL syntax near 'mysql fullboreidiot /home2/fullboreidiot/test.sql' at line 1 Anyone know what I'm doing wrong? Derek Booth [EMAIL PROTECTED] - Original Message - From: Nielsen To: C.o.m.b.u.s.t. ; [EMAIL PROTECTED] Sent: Sunday, February 11, 2001 9:24 PM Subject: RE: CREATE TABLE / Telnet (Linux / Unix server) ...and this will load the table into your database. Now, in the book it doesn't specify whether or not you have to be on the computer with the server, or if you can send the .sql file command from your computer to the remote server, sort of like a file transfer protocol as well. Basically, my question is, do I have to either FTP my files to the server, and then execute the command, or can I do it remotely without FTP? Or is it possible AT ALL to execute the command from a remote computer? In case it helps, I am on a Windows 98 system connected through SSH to an Linux system running Apache. Please help, I'm stuck and I won't give up until I'm un-stuck! Thanks in advance to all that reply. The file must be on the remote machine (as has been answered), but yes, if you are connected to the shell (via telnet/ssh/ssh2/etc), you can execute the command. And, no, the extension may be anything (all you're doing is redirecting the contents of the file (via '') into the 'mysql database' command. HTH, Jon A. Nielsen. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: CREATE TABLE / Telnet (Linux / Unix server)
Check that your sql script has the syntax use your_db_name create table tablename ... then try to exec it mysqlmysql your_script_name But first of all read the manual. It's help in most cases. - Original Message - From: C.o.m.b.u.s.t. [EMAIL PROTECTED] To: Nielsen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, February 12, 2001 10:31 AM Subject: Re: CREATE TABLE / Telnet (Linux / Unix server) Ok, I am trying to execute the CREATE TABLE command through telnet and the "test.sql" file is residing in the directory /home2/fullboreidiot/test.sql and I put in the command how I'm assuming it would be executed: mysql mysql fullboreidiot /home2/fullboreidiot/test.sql; and I get the following error: ERROR 1064: You have an error in your SQL syntax near 'mysql fullboreidiot /home2/fullboreidiot/test.sql' at line 1 Anyone know what I'm doing wrong? Derek Booth [EMAIL PROTECTED] - Original Message - From: Nielsen To: C.o.m.b.u.s.t. ; [EMAIL PROTECTED] Sent: Sunday, February 11, 2001 9:24 PM Subject: RE: CREATE TABLE / Telnet (Linux / Unix server) ...and this will load the table into your database. Now, in the book it doesn't specify whether or not you have to be on the computer with the server, or if you can send the .sql file command from your computer to the remote server, sort of like a file transfer protocol as well. Basically, my question is, do I have to either FTP my files to the server, and then execute the command, or can I do it remotely without FTP? Or is it possible AT ALL to execute the command from a remote computer? In case it helps, I am on a Windows 98 system connected through SSH to an Linux system running Apache. Please help, I'm stuck and I won't give up until I'm un-stuck! Thanks in advance to all that reply. The file must be on the remote machine (as has been answered), but yes, if you are connected to the shell (via telnet/ssh/ssh2/etc), you can execute the command. And, no, the extension may be anything (all you're doing is redirecting the contents of the file (via '') into the 'mysql database' command. HTH, Jon A. Nielsen. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Building php4.0.4pl1 with mysql 3.23.32
Scott Brown schrieb: Does anyone have any suggestions??? As near as I can tell mysql_fetch_array is failing - but there is a return result otherwise I'd be getting an error message out of this routine... I'm really confused here. sounds strange! I've no problems using php4.04pl1 with mysql Ver 11.12 Distrib 3.23.32, for redhat-linux-gnu (i386) maybe you should reinstall it (:-? ) -- IrmundThum +49 179 6998564 +49 6374 992541 Kryptographische Unterschrift mit S/MIME
connection
how to i change the default connection from unix socket to tcpip 3306 ? currently is connection = localhost via unix socket thanks Wong - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: indexing unique fields
I think that KEY is the same as INDEX, but why UNIQUE? - Original Message - From: TJ Hunter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 3:49 AM Subject: indexing unique fields I'm using the following table to store information about a merchant user. He uses his email address as his username to login. Since I'm going to be doing WHERE clauses on that field, I'd like it to be indexed for speed. If I have a UNIQUE property on the email field when I create the table, do I need the "INDEX (email)" line in there or since the email field is UNIQUE, it's automatically indexed? CREATE TABLE merchants ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, nameCHAR(64) NOT NULL, contact CHAR(64), address CHAR(64), cityCHAR(64), stateId INT UNSIGNED, zipcode CHAR(11), phone CHAR(15), fax CHAR(15), email CHAR(64) NOT NULL UNIQUE, passwordCHAR(64) NOT NULL, PRIMARY KEY (id), INDEX (email) ); This question came up when I did a dump on the table and got the output below. There is a 'KEY email_2 (email)' line that is throwing me off. CREATE TABLE merchants ( id int(10) unsigned NOT NULL auto_increment, name char(64) NOT NULL, contact char(64), address char(64), city char(64), stateId int(10) unsigned, zipcode char(11), phone char(15), fax char(15), email char(64) NOT NULL, password char(64) NOT NULL, PRIMARY KEY (id), UNIQUE email (email), KEY email_2 (email) ); -TJ Hunter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: CREATE TABLE / Telnet (Linux / Unix server)
Check the structure of txt file. Does it created with SELECT ... INTO OUTFILE? Check command syntax. - Original Message - From: Joel Holtzman [EMAIL PROTECTED] To: Nielsen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 8:51 AM Subject: Re: CREATE TABLE / Telnet (Linux / Unix server) I've had questions about this too. What happens if I have a primary key, and the text file has the columns that are in the existing table, with records. And I want to insert them. How do I get rid of that duplicate error? I read the manual, about 'ignore' but I can't get it to work. Any ideas? In other words, if I have a db with one table "Test" and columns: A B And my file.txt has the columns and records, so it's structured like this: A B 1 2 3 4 So when I 'load data infile file.txt' the db with 'test' table and 0 records, becomes table with records added. How do I avoid errors. The manual is no help, I tried it. Any ideas? SHould I ignore the Primary key field in the text file, and use the rest of it to avoid that duplicate error? The text file is separated by tabs. Thanks Joel - Original Message - From: Nielsen [EMAIL PROTECTED] To: C.o.m.b.u.s.t. [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, February 11, 2001 9:24 PM Subject: RE: CREATE TABLE / Telnet (Linux / Unix server) ...and this will load the table into your database. Now, in the book it doesn't specify whether or not you have to be on the computer with the server, or if you can send the .sql file command from your computer to the remote server, sort of like a file transfer protocol as well. Basically, my question is, do I have to either FTP my files to the server, and then execute the command, or can I do it remotely without FTP? Or is it possible AT ALL to execute the command from a remote computer? In case it helps, I am on a Windows 98 system connected through SSH to an Linux system running Apache. Please help, I'm stuck and I won't give up until I'm un-stuck! Thanks in advance to all that reply. The file must be on the remote machine (as has been answered), but yes, if you are connected to the shell (via telnet/ssh/ssh2/etc), you can execute the command. And, no, the extension may be anything (all you're doing is redirecting the contents of the file (via '') into the 'mysql database' command. HTH, Jon A. Nielsen. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL version
paul herigs wrote: I want to know something about MySQL versions we have a database working with version 4.0. can you tell me were I can download this version. On the internet I only can find version 5.0 and my database don't response on this version. Something is totally wrong. MySQL-4.0 is the newest in family and available to developers only. Last stable on is 3.23.32 (33?). There is no MySQL-5.0. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Technical Clarification
Hi, We have uploaded our site that uses Chilisoft ASP with MySQL backend database.We are now in testing stage.It works fine with just 10 records in each table. We have our original data in Excel. Now how do we convert that excel data to mysql data (which is in bulk.) and upload . The main issue is where in the server should the mysql (converted) data be uploaded. The Connection string we use is set cc=server.createobject("adodb.connection") cc.open "DRIVER={MySQL};SERVER=www.www.net;DATABASE=mydatabase; UID=myUser;PWD=myPwd" Please do give us a solution in this regard. Regards Gopinath
Total = the total of the SUM function
Hi, I was wondering if there is a way I can do this in MySQL as a one line command: SELECT COUNT(*) as Qty, Name, 100 * Qty/(SELECT COUNT(*) from Table1) as Percent from Table1 GROUP BY Name; Currently I have to do this in two lines: SELECT COUNT(*) from Table1; SELECT COUNT(*) as Qty, Name, 100 * Qty/(RESULT_OF_ABOVE_STATEMENT) as Percent from Table1 GROUP BY Name; Any help is appreciated. jerome _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Performance Q
Rus wrote: Hi! Does MySQL open all tables in database when I select data from one table? No. But he will keep last x ones for faster access. My my.cnf file: [tonu@no tonu]$ cat /etc/my.cnf [mysqld] log-slow-queries=/var/log/mysql-slow-query.log set-variable = long_query_time=1 set-variable = key_buffer=16M set-variable = sort_buffer=1M set-variable = table_cache=128 --- Keep last 128 tables open set-variable = record_buffer=1M set-variable = net_buffer=16M [tonu@no tonu]$ Will it be faster to split db to number of smaller db associated with concrete PHP scripts? Depends. Usually you do not have so huge tables. If someone does, then one can read manual about MERGE type of tables. They are hiding that solution with many tables from you. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Tallinn, Estonia ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 code list
vaibhavi writes: hello, I am working on project where my database is mysql. I need whole list of error codes eg code when there is primary key violation, or other such database related problems.I have tried perror but that all are system related problems.I want code for database related problems. vaibhavi Hi! You should try our manual. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Sub-Selects
Gunnar Ingvi writes: Hi there ! I?m wondering if there is planned support for Sub-Selects (e.g. HAVING and so on) in upcoming versions? I think this is very important to implement. Best regards, Gunnar Ingvi [EMAIL PROTECTED] Hi! It will come in version 4.1. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Data modeling tool
On Sat, 10 Feb 2001, Cal Evans [EMAIL PROTECTED] wrote: As much as I love creating models by hand, my databases are growing to the point where I need a tool to help me "see" them. Does anyone know of a tool like ERWin or ER/Studio that supports MySQL? I do my diagrams in UML with dia. And then I use mysqltool from Dajoba to build and maintain the tables: http://www.dajoba.com/projects/mysqltool/index.html?_of=20, Moving back and forth is a manual process, which is a bit frustrating. Since dia stores everything in XML, I'm considering what it would take to make some sort of syncronization. I've been planning on looking into Alzabo too, which was already mentioned, but I haven't had the time for that either. :-( -- /chris Those who cannot remember the past are doomed to buy Microsoft products. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
hi there
im trying to find out the corrent download urs's to get the shopping chart going.. i know i got to get the MySQL database, Msql-Mysql, and DBI , i found them but not shure which one to click im on windows 98 pc can you give me any direct links. i read the files but not shure still... __ Kind Regards George Kordas Statik Recordings http://www.statik.com.au The Engine That Drives Australia's Hip-Hop Underground
Re: Help - Corruption
Rodolfo Sikora writes: This table is getting corrupted all the time (twice a week). We have only SELECTS and INSERTS with little updates. (we have 140.000 registers growing faster to 100 :)) CREATE TABLE conta ( idConta int(8) unsigned NOT NULL auto_increment, idDominio int(6) unsigned DEFAULT '0' NOT NULL, conta varchar(30) DEFAULT '' NOT NULL, senha varchar(32) DEFAULT '' NOT NULL, usermount varchar(100) DEFAULT '' NOT NULL, userlock int(1) DEFAULT '0' NOT NULL, senha2 varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (idConta), UNIQUE idDominio (idDominio,conta) ); The worst is tha we have another table with 1.000.000 inserts/updates/deletes/selects and this table never get corrupted. What should I do to prevent corruptions. (every day I run an optimize, check table... etc..) I'm running mysql under a NetServer LC2000 (HP) with RAID 5 and 1GB RAM, PIII 667/600. Shoudl I use -O key_buffer and/or table_cache. What really does FLUSH TABLES? it's ok do it once a day? By the way I got this interesting message in my slave log: 010207 12:47:42 Error reading packet from server: Contratulations! You have hit the magic number and can win sweepstakes if you report the bug (0) Best regards. HI! The above error message looks like you have hit a very hard error in network protocol. It could be a cause for table corruption, although we would prefer to see a full repeatable test case . But for the start, you could check that you have no errors in your LAN network functioning. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Update: Status of MySQL 4.0/Innobase/transactions row level locks
Hi! The timeout in Innobase deadlock resolution is configurable in my.cnf file: you will be able to set it in units of one second (or would someone need an even greater precision?). In the future we might modify the MySQL code so that Innobase gets the information of MySQL LOCK TABLES commands before MySQL tries to set the locks. Then Innobase will be able to detect these deadlocks immediately and roll back the transaction. In this case we could also allow a user to issue several consecutive LOCK TABLES commands without the need to call UNLOCK TABLES between these. Currently, in MySQL you must call UNLOCK TABLES before issuing another LOCK TABLES, because there is no deadlock detection in MySQL itself. The MySQL mailing list is currently the only place to discuss the Innobase table handler. You can also send me email directly, I will be happy to reply! Regards, Heikki Tuuri Innobase Oy At 04:45 AM 2/11/01 +0100, you wrote: Hi. On Fri, Feb 09, 2001 at 05:34:38PM +0200, you wrote [...] 5. Add a timeout to lock waiting: Innobase can detect and resolve deadlocks within its own lock table, but if a user uses also MySQL LOCK TABLES... or BDB locks, a deadlock can occur where Innobase does not know of all the locks: this is resolved by adding a timeout for a lock wait, say 100 s., after which the transaction is rolled back. Maybe I misunderstand this point: But a 100 secs timeout (in worst case of a deadlock) would be absolutely inacceptable within my applications. :-/ I mean, okay, if I am going to block a table for 100 secs, that's my problem. But it sounds as if the handler waits 100 secs before it "solves" a dead-lock condition by failing. Is there a better mechanism planned for later? At least one should be able to change the timeout (I would set it below 5 seconds...). Bye, Benjamin. PS: If there is a better place to discuss the Innobase table handler for MySQL, let me know. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Queries editor better than standard mysql
Hi, I wonder: is there some queries editor better than standard mysql? Maybe something like dbaccess in Informix. I use mysqlgui in X, but I'd preffer something in terminal-mode... -- Mariusz Brzezinski WBK SA tel. +48 61 856 53 57 mobile +48 501 623 123 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: UDF Problem
Thomas Kaester(global) writes: Hello everybody, I have a big UDF problem and I hope that anybody can help me! In details: I have developed an UDF which returns a string which is longer than 256 characters! But the function only returns the first 256 characters and not the whole string. I checked the UDF_INIT struct but the necessary parameter initid-max_length has the value 65535. This should be enough. Does anyone know if I have to set special buffer parameters? What goes wrong? And what can I do? Greetings Tom Hi! You will have to allocate that string in _init function and deallocate it in _deinit function. Regards, Sinisa __ _ _ ___ == MySQL AB /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus /*/ /*/ /*/\*\_/*/ \*\_/*/ |*| /*/^^^\*\^^^ /*/ \*\Developers Team - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: BDB
Hi! "Mehalick," == Mehalick, Richard RE SSI-GRAX [EMAIL PROTECTED] writes: Mehalick, When using the BDB tables and RedHat 6.2 or 7.0, should --skip-locking be Mehalick, used or not? I know it was recommended for earlier versions of RedHat, like Mehalick, version 5.x. Now when CHECK TABLE and REPAIR TABLE is integrated with mysqld, You can always use --skip-locking; (In any case, this option has no effect on BDB tables) Regrads, 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
got error 127 - again and again
hi. i have been using mysql w/o problems for almost 1.5 years now; however, since some days ago, one of my tables keep crashing. i keep receveing 'get error 127 from table handler' errors. after doing a 'repair table' on tha particular table, everything seems to work ok - however, the same error will come back within days, if not hours. the mysql doc doesn't say much about this besides the fact that one should repair the table... which was fine if the error wouldn't come back as fast as it does. is there anyone out there with a more detailed explanation what could cause that particular error - and what i can do to get rid of it again? WM_THX thomas woelfer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication problem
I try to use the replication feature of the latest stable version 3.23.32. Everyting works find when I follow the instructions until when I tried to stop the slave and then start it. It generated the following messages in the error log: 010212 18:28:08 mysqld started /vol2/mysql/libexec/mysqld: ready for connections 010212 18:28:08 Slave: connected to master 'repl@iappl04:3306', replication st arted in log 'iappl04-bin.006 ' at position 25798 010212 18:28:08 Error reading packet from server: Could not find first log (rea d_errno 0,server_errno=65535) 010212 18:28:08 Slave: Failed reading log event, reconnecting to retry, log 'ia ppl04-bin.006 ' position 25798 010212 18:28:08 Slave: reconnected to master 'repl@iappl04:3306',replication re sumed in log 'iappl04-bin.006 ' at position 25798 But I found sometimes it worked but sometimes not. I also tried to stop the slave by the command 'slave stop' before shutdown the server. Please advise what the problem is. Stephen
Re: cronjobs crash with libmysqlclient in PAM-modules
On Mon, 6 Nov 2000, Michael Widenius wrote: Hi! "Jan" == Jan Lukoschus [EMAIL PROTECTED] writes: Description: Jan Operating system: SUN Solaris 7 or 8 Jan MySQL: 3.22.32 or 3.23.27-beta Jan When cron starts a job and tries to authenticate the associated user Jan with a PAM-module which uses libmysqlclient, then the process crashes Jan when calling the function mysql_init. All other uses of the PAM-module Jan work just fine (login, ssh, dtlogin, xdm, telnet, etc.), Only cron keeps Jan constantly crashing (not the demon itself, just the jobs teminate). How-To-Repeat: Jan Just install a PAM-module for authenticating users against a MySQL-DB on Jan Solaris 7 or 8 and set up a trivial cron job. We tested MySQL versions Jan 3.22.32 and 3.23.27-beta. Both shows the error. We use our own PAM-module, Jan but pam-mysql should have the same problem. Fix: Jan The following statements apply to MySQL 3.23.27-beta: Jan The offending statement is in mysql-3.23.27-beta/libmysql/errmsg.c line 81: Janerrmsg[CLIENT_ERRMAP] = client_errors[0]; cut Thanks; We will rename errmsg to my_errmsg in 3.23.28 Is there a specific reason, why that change did not found its way into the stable release 3.23-32 (I have not checked the beta versions)? Jan. -- Jan Lukoschus [EMAIL PROTECTED] I. f. Informatik u. Praktische Mathematik Olshausenstr. 40, 24118 Kiel, Germany - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Changing DB type
Hi all, I have a couple of MyISAM tables, but I want them changed to BDB tables. Can I let mysql do so automatically? Or should I do a dump, recreate the table as BDB and insert all the data again? TIA, Marc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 error 127 - again and again
So, you're a lucky guy! I got the same "problem" but more strange and comic. I've been using perl / DBI to access mysql on my scripts, an week ago I got the same error as you. I runned out repair my tables (everyone says that this error is about corrupted tables), after repair and local/console tests everything seemed ok. I tried to run my scrip again (simple selects) and I got the same error, then I tried the same select, but now at mysql client, and worked fine how crazy... = hi. i have been using mysql w/o problems for almost 1.5 years now; however, since some days ago, one of my tables keep crashing. i keep receveing 'get error 127 from table handler' errors. after doing a 'repair table' on tha particular table, everything seems to work ok - however, the same error will come back within days, if not hours. the mysql doc doesn't say much about this besides the fact that one should repair the table... which was fine if the error wouldn't come back as fast as it does. is there anyone out there with a more detailed explanation what could cause that particular error - and what i can do to get rid of it again? WM_THX thomas woelfer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: replication problem
Stephen Wong wrote: I try to use the replication feature of the latest stable version 3.23.32. Everyting works find when I follow the instructions until when I tried to stop the slave and then start it. It generated the following messages in the error log: 010212 18:28:08 mysqld started /vol2/mysql/libexec/mysqld: ready for connections 010212 18:28:08 Slave: connected to master 'repl@iappl04:3306', replication st arted in log 'iappl04-bin.006 ' at position 25798 010212 18:28:08 Error reading packet from server: Could not find first log (rea d_errno 0,server_errno=65535) 010212 18:28:08 Slave: Failed reading log event, reconnecting to retry, log 'ia ppl04-bin.006 ' position 25798 010212 18:28:08 Slave: reconnected to master 'repl@iappl04:3306',replication re sumed in log 'iappl04-bin.006 ' at position 25798 But I found sometimes it worked but sometimes not. I also tried to stop the slave by the command 'slave stop' before shutdown the server. Please advise what the problem is. Stephen If you built from sources, make sure you apply the patches posted earlier. Otherwise wait for .33. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
connection faild
hi i using linux 6.2,mysql and coldfusion 4.5 the odbc connection in cold fusion is failed for setup can anyone help ? i don know how to start on checking. wong - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Upgrading
Hi; I'm trying to upgrade to the latest distro. I thought I could simply d'l the distro, go in as root (Apache, RedHat) and enter the following command: # rpm -U MySQL-3.23.32-1.src.rpm When I do I get no error messages, but no upgrade seems to occur (i.e., I get the old version number at the mysql prompt). How am I supposed to do the upgrade? TIA, BenO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Win2000 cluster and MySQL
Hi, A collegue of me is asking if it is possible to use MySQL on a Windows 2000 cluser. It is in an Active/Standby configuration with shared disks. If the active server fails, the standby takes over the services, so it fires up the MySQL service. I have no idea if this is a good solution, in what state the tables will be etc etc. Does anyone have an idea on how to set this up, or do we need a tablecheck before the standby machine takes over??? Thanks -- Thierry Coopman - [EMAIL PROTECTED] My opinions are personal, and have really nothing or nothing to do with Keytrade! "You want what? You can't have it." - Tech Support - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
tab in mysqlshell
Hey I just upgraded to mysql 3.23.32 but now i can't use the tab in the mysqlshell (like in you do in various unix shells to get a list of valid names, etc.). How do I enable it in again ? // Jesper
Re: MySQL GUI for Windows
For web-based GUI admin, I'd highly recommend phpMyAdmin (http://phpwizard.net/phpMyAdmin/) "indrek siitan" [EMAIL PROTECTED] on 02/12/2001 10:00:27 AM To: [EMAIL PROTECTED] cc:(bcc: Adam Brake/Raleigh/TEKELEC) Subject: MySQL GUI for Windows Hi, can anyone suggest a good GUI client to suggest to MySQL hosting customers? it should: * be able to display table structures, add and alter tables (field, indexes) * show and edit table data * be freeware (or it can be half-commercial, as long as the above functionality is available without paying) * ask for database name in the connection parameters or only display the list of databases user has access to Rgds, Indrek --- Indrek Siitan, CEO eMotion Ltd. [http://www.eMotion.ee] e-mail: [EMAIL PROTECTED] Narva mnt 31, 10120 Tallinn Estonia GSM: +372 50 17621+372 6605 890 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Corruption
This table is getting corrupted all the time (twice a week). We have only SELECTS and INSERTS with little updates. (we have 140.000 registers growing faster to 100 :)) CREATE TABLE conta ( idConta int(8) unsigned NOT NULL auto_increment, idDominio int(6) unsigned DEFAULT '0' NOT NULL, conta varchar(30) DEFAULT '' NOT NULL, senha varchar(32) DEFAULT '' NOT NULL, usermount varchar(100) DEFAULT '' NOT NULL, userlock int(1) DEFAULT '0' NOT NULL, senha2 varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (idConta), UNIQUE idDominio (idDominio,conta) ); The worst is tha we have another table with 1.000.000 inserts/updates/deletes/selects and this table never get corrupted. What should I do to prevent corruptions. (every day I run an optimize, check table... etc..) Help us find and fix the bug You should work on creating a repeatable case of corruption. Start by upgrading to 3.23.33 once it is released. 3.23.33 will print the trouble query to the error log in the crash handler along with the backtrace on x86 Linux, so this should make debugging a lot easier. I'm running mysql under a NetServer LC2000 (HP) with RAID 5 and 1GB RAM, PIII 667/600. Shoudl I use -O key_buffer and/or table_cache. This will not help, although different setting that what you have may randomly obscure the bug. You should not rely on this, though. What really does FLUSH TABLES? it's ok do it once a day? It closes all the currently open tables and flushed all the buffers related to tables to to the disk. This is needed only when you want to be sure that what you have on the disk is current, and is normally not necessary. By the way I got this interesting message in my slave log: 010207 12:47:42 Error reading packet from server: Contratulations! You have hit the magic number and can win sweepstakes if you report the bug (0) If your version is pre-3.23.29, you are hitting the bug that has already been fixed. This should not happen in newer versions, if it does, it is a bug, just like the message says. Actually, looking at the message, you **are** running an old version. The evidence is the misspeled "Congratulations" in the error message. The fix is to upgrade - to 3.23.33 once it gets out, or if you cannot wait, 3.23.31. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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: MySQL GUI for Windows
urSQL - http://www.urbanresearch.com/ursql On Mon, 12 Feb 2001, indrek siitan wrote: Hi, can anyone suggest a good GUI client to suggest to MySQL hosting customers? it should: * be able to display table structures, add and alter tables (field, indexes) * show and edit table data * be freeware (or it can be half-commercial, as long as the above functionality is available without paying) * ask for database name in the connection parameters or only display the list of databases user has access to Rgds, Indrek --- Indrek Siitan, CEO eMotion Ltd. [http://www.eMotion.ee] e-mail: [EMAIL PROTECTED] Narva mnt 31, 10120 Tallinn Estonia GSM: +372 50 17621+372 6605 890 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 GUI for Windows
Use PhpMyadmin - Original Message - From: "indrek siitan" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 11:00 PM Subject: MySQL GUI for Windows Hi, can anyone suggest a good GUI client to suggest to MySQL hosting customers? it should: * be able to display table structures, add and alter tables (field, indexes) * show and edit table data * be freeware (or it can be half-commercial, as long as the above functionality is available without paying) * ask for database name in the connection parameters or only display the list of databases user has access to Rgds, Indrek -- - Indrek Siitan, CEO eMotion Ltd. [http://www.eMotion.ee] e-mail: [EMAIL PROTECTED] Narva mnt 31, 10120 Tallinn Estonia GSM: +372 50 17621+372 6605 890 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Can anyone suggest a more efficient method
I have two tables, one contains units one contains activity I run this query .. select unit.dialup_user, unit.address1, activity.dialup_user from unit LEFT JOIN activity ON (unit.dialup_user = activity.dialup_user) where !(activity.event_time_unix (981990589 - (2* ( 24 * (60 * 60) ) ) ) ) unit.status ="Active" GROUP BY unit.id What I am trying to do is select every unit that does not have an entry in the activity table after a certain unix time. Any help would be much appreciated Here is the output from the explain command table typepossible_keys key key_len ref rows Extra - ---- --- --- - unit ALLNULL NULL NULL NULL840 where used; Using temporary activity ALLNULL NULL NULL NULL29109 where used (2 row(s) affected) Bryan Hunt Developer Netnote 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: Upgrading
On Mon, 12 Feb 2001, Ben Ocean wrote: I'm trying to upgrade to the latest distro. I thought I could simply d'l the distro, go in as root (Apache, RedHat) and enter the following command: # rpm -U MySQL-3.23.32-1.src.rpm Being no rpm expert, the above suggests that you fetched the source distribution, ie. you'd have to recompile to get the new version. Try searching for a file that's named similarly, but without the 'src'. Regards, Jan-Aage -- Mr. Jan-Aage Bruvoll Managing Director Bruvoll Brains in Bits, 7a Neal's Yard, London WC2H 9DP, UK Office: +442072408283 Cell: +4792492482 Fax: +4792571158 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrading
you need to grab the .i386.rpm files...you have the source code RPM. - Original Message - From: "Ben Ocean" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 10:14 AM Subject: Upgrading Hi; I'm trying to upgrade to the latest distro. I thought I could simply d'l the distro, go in as root (Apache, RedHat) and enter the following command: # rpm -U MySQL-3.23.32-1.src.rpm When I do I get no error messages, but no upgrade seems to occur (i.e., I get the old version number at the mysql prompt). How am I supposed to do the upgrade? TIA, BenO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
!!! Mysql hangs after some days on FreeBSD 4.0I
Hi, I've mysql 3.23.32 running on FreeBSD 4.0. It runs a site with heavy traffic and heavy database interaction. After starting mysql it hangs after some days. Mysql server is still in the processlist, but it is not possible to connect to the sql server anymore. Therefor it is impossible to stop the server and rerun it without killing. Problem with threads?? I've found the following in the config.log generated by ./configure: - SNIP configure:5648: gcc -o conftest conftest.c -lz -lcrypt -lm 15 /tmp/ccF77967.o: In function `main': /tmp/ccF77967.o(.text+0xf): undefined reference to `pthread_create' configure: failed program was: #line 5641 "configure" #include "confdefs.h" #include pthread.h int main() { (void) pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0); ; return 0; } configure:5662: checking for pthread_create in -lpthread configure:5673: gcc -o conftest conftest.c -lz -lcrypt -lm -lpthread 15 /usr/libexec/elf/ld: cannot open -lpthread: No such file or directory configure: failed program was: #line 5666 "configure" #include "confdefs.h" #include pthread.h int main() { (void) pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0); ; return 0; } configure:5688: checking for pthread_create in -lpthreads configure:5697: gcc -o conftest conftest.c-lz -lcrypt -lm -lpthreads 15 /usr/libexec/elf/ld: cannot open -lpthreads: No such file or directory configure: failed program was: #line 5690 "configure" #include "confdefs.h" #include pthread.h int main() { pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0); ; return 0; } - SNIP I've no idea if this is important or not? I've made a script which reboots the server if connection to sql server fails. But this is not a solution :). Thanks in advance. Regards, Patric de Waha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: indexing unique fields
You don't need the INDEX (email) at the end of this statement, it's creating a second index on the same data. UNIQUE specifies that an index should be created. TJ Hunter [EMAIL PROTECTED] wrote: I'm using the following table to store information about a merchant user. He uses his email address as his username to login. Since I'm going to be doing WHERE clauses on that field, I'd like it to be indexed for speed. If I have a UNIQUE property on the email field when I create the table, do I need the "INDEX (email)" line in there or since the email field is UNIQUE, it's automatically indexed? CREATE TABLE merchants ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, nameCHAR(64) NOT NULL, contact CHAR(64), address CHAR(64), cityCHAR(64), stateId INT UNSIGNED, zipcode CHAR(11), phone CHAR(15), fax CHAR(15), email CHAR(64) NOT NULL UNIQUE, passwordCHAR(64) NOT NULL, PRIMARY KEY (id), INDEX (email) ); This question came up when I did a dump on the table and got the output below. There is a 'KEY email_2 (email)' line that is throwing me off. CREATE TABLE merchants ( id int(10) unsigned NOT NULL auto_increment, name char(64) NOT NULL, contact char(64), address char(64), city char(64), stateId int(10) unsigned, zipcode char(11), phone char(15), fax char(15), email char(64) NOT NULL, password char(64) NOT NULL, PRIMARY KEY (id), UNIQUE email (email), KEY email_2 (email) ); -TJ Hunter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Use of mysql_use_result in ODBC driver ?
Hi all, I would like to change the do_query function in execute.c module in the ODBC driver to use mysql_use_result function instead of mysql_store_result function. There is currently some comments with an eventual problem in case of SQLRowCount function. To my mind, the only thing would be that SQLRowCount could only return a result on UPDATE, INSERT and DELETE statements but not anymore on SELECT statement if you didn't retrieve all the rows. But the return value of SQLRowCount function is driver-defined for SELECT statements... So is it really a problem? Thanks for your help Patrick __ Patrick Fiche - Prologue Software (France) Software Engineer Email: [EMAIL PROTECTED] Internet : http://www.prologue-software.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
DECIMAL column type links to Access as TEXT
I found a problem with MyODBC when linking tables to Access97. It considers DECIMAL type as TEXT (and you know you can't change that without going into code). I changed the column type into FLOAT and it fixed the problem, but at the same time it would be nice if MyODBC either gave you a choice on what data type you want to give linked table column or determine it properly. Anyway. MySQL rocks, and we all know it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Here you have, ;o)
Hi: Check This! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Here you have, ;o)
Hi: Check This! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Access - This Recordset is not updateable
I've scanned past e-mails and haven't found this in the archives. This is probably something simple that I'm overlooking. If I'm connecting to a table in MySQL from MS Access 97 and getting the message "This Recordset is not updateable" whenever I try and change anything, where can I change the setting so I can read/write and not just read? I also have another table that lets me make changes, but won't let me save them. Thanks, John Halladay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyVbQL.dll version 2.0.0 released
MyVbQL.dll version 2.0.0 released. The new version can be download at http://www.icarz.com/mysql/index.html Version 2.0.0 contains the following changes: MYSQL_CONNECTION object changes: - fixed OpenConnection method returning incorrect state upon successful connection - added AutoUpdate property - added LastInsertID method - added QueryString property - added Ping method MYSQL_RS object changes: - changed object Instancing property to PublicNotCreatable - fixed EOF property returning incorrect value when record count = 0 - added RsToHtmlTable method - added AddNew method - added Update method - added CancelUpdate method - added Delete method - added Requery method - added MYSQL_EDIT_MODE enum - added EditMode property - added Table property - added TableCount property MYSQL_FIELD changes: - added "Let" to Value property - added Table property - added MYSQL_FIELD_FLAGS enum - added Flags property - added Length property - added MaxLength property - added Decimals property I also added a webpage containing a change log http://www.icarz.com/mysql/changes.html and will be adding a FAQ page soon. Enjoy !!! Eric Grau icarz, 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 hangs after some days on FreeBSD 4.0I
Hi Patric, I believe you will have many problems of this kind with older versions of FreeBSD. You should update, if you can, to FreeBSD-stable. See this URL for easy instructions on how to update if you don't know how. http://www.mostgraveconcern.com/freebsd/ and look at the CVSUP info. The recompile MySQL and re-install it! Bonne chance Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: "pdewaha" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 11:21 AM Subject: !!! Mysql hangs after some days on FreeBSD 4.0I Hi, I've mysql 3.23.32 running on FreeBSD 4.0. It runs a site with heavy traffic and heavy database interaction. After starting mysql it hangs after some days. Mysql server is still in the processlist, but it is not possible to connect to the sql server anymore. Therefor it is impossible to stop the server and rerun it without killing. Problem with threads?? I've found the following in the config.log generated by ./configure: - SNIP configure:5648: gcc -o conftest conftest.c -lz -lcrypt -lm 15 /tmp/ccF77967.o: In function `main': /tmp/ccF77967.o(.text+0xf): undefined reference to `pthread_create' configure: failed program was: #line 5641 "configure" #include "confdefs.h" #include pthread.h int main() { (void) pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0); ; return 0; } configure:5662: checking for pthread_create in -lpthread configure:5673: gcc -o conftest conftest.c -lz -lcrypt -lm -lpthread 15 /usr/libexec/elf/ld: cannot open -lpthread: No such file or directory configure: failed program was: #line 5666 "configure" #include "confdefs.h" #include pthread.h int main() { (void) pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0); ; return 0; } configure:5688: checking for pthread_create in -lpthreads configure:5697: gcc -o conftest conftest.c-lz -lcrypt -lm -lpthreads 15 /usr/libexec/elf/ld: cannot open -lpthreads: No such file or directory configure: failed program was: #line 5690 "configure" #include "confdefs.h" #include pthread.h int main() { pthread_create((pthread_t*) 0,(pthread_attr_t*) 0, 0, 0); ; return 0; } - SNIP I've no idea if this is important or not? I've made a script which reboots the server if connection to sql server fails. But this is not a solution :). Thanks in advance. Regards, Patric de Waha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Here you have, ;o)
If you hadn't read up on this yet, the attachment AnnaKournikova.jpg.vbs which is accompanying Mr. Arora's e-mail is a virus. McAfee doesn't know what the damage is, because it was created by a worm that changes the damage slightly for every lucky recipient. Just a heads up. Cheers, # Nathan - Original Message - From: "ajay arora" [EMAIL PROTECTED] To: "mysql lists" [EMAIL PROTECTED] Sent: Monday, February 12, 2001 10:20 AM Subject: Here you have, ;o) Hi: Check This! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Access 2000 and MySQL
I've just been exposed to Access 2000 :-( I'd be interested in any comments about using Access 2000 as a front-end for MySQL (this isn't _my_ choice). How is it done? What are the pitfalls? Please c.c. me directly as I'm in the process of resubscribing to this list. -- Bill McEachran - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication errors
I have a one-way replication setup where the master is out of state, and the slave is local. The connection between the machines is high-speed, but not 100% reliable. Every once in a while, my slave thread stops because of a duplicate key entry. I'm puzzled by this for several reasons: 1. Insertions and updates are made on the master, and nowhere else. 2. I know that if a slave loses connection, it will attempt to restart - so network disruptions shouldn't be a big factor. I am running: mysql Ver 11.6 Distrib 3.23.28-gamma, for sun-solaris2.7 (sparc) on both machines. Does anyone know where I might be able to start finding clues to solving this mystery? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SELECT DISTINCT question
Say I have a bunch of records in a table with a bunch of fields. One of those fields is cluster_id. It is not unique. However, I want to make a unique set. I want one record for each cluster_id value. I don't care which record that is. Right now, I do: SELECT DISTINCT cluster_id FROM my_table Then, for each of those I do: SELECT * FROM my_table WHERE cluster_id=$cluster_id I take the first record of the response and continue. This is very slow because I'm accesing the database thousands of times instead of once. SELECT DISTINCTROW * from my_table doesn't work either, because it sees if ALL of the fields are DISTINCT, not just cluster_id, thus this is more than I want. Also, I would like to SELECT into another table. The MySQL docs only say how to select into a file. This is not really what I want. What I do now is SELECT and then INSERT each row. Any suggestions? -rishi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Here you have, ;o)
Hi: Check This! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I can not alter the new index num.....
$ myisamchk --set-autoincrement-value=1 YourTable.MYI would reset the number to 1 for you. If you do not remove existing records from your table, your MySQL could generate errors as the new value collides with an existing record. Cheers, Kent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Duplicate entry error??
Hi, You have a unique key defined which includes Ekey and another field (the key 2 mentioned in the error message), and the entry "other_field = '88' and Ekey='252'" has already been used. Regards Quentin -Original Message- From: Paul Wilkinson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 13 February 2001 10:39 To: Help MySQL List Subject: Duplicate entry error?? Thanks in advance for your help! How does one replace a single field value when the value repeats? I tryed the following and get an error message "Duplicate entry '88-252' for key 2" UPDATE DKWords SET EKey='252' WHERE EKey='13' What is wrong? Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php 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
Exporting DB's
Ok this is a total newbie question, but if I develope a DB on my developement server and want to export it to the live server what is process I use to do this? TIA, Jeremy J. Arntz Digital Architect Simplified Development [EMAIL PROTECTED] http://www.simplifiednow.com/
Re: CREATE TABLE / Telnet (Linux / Unix server)
I turned my access db into excel, and into .csv So that's the structure of my text file. When I use "Load data infile..." I get the 10 warnings. 10 for the 2 columns, and 8 records. Does it have to be a special format? I have the file.txt on the server. I can point to it. I just can't get it to insert this file's records. Are you saying when columns exist in a db, you must use Select into? And does the file need to have columns/records sepearated a certain way? Mine uses commas. (.csv file) Thanks Joel - Original Message - From: Rus [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 1:21 AM Subject: Re: CREATE TABLE / Telnet (Linux / Unix server) Check the structure of txt file. Does it created with SELECT ... INTO OUTFILE? Check command syntax. - Original Message - From: Joel Holtzman [EMAIL PROTECTED] To: Nielsen [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 8:51 AM Subject: Re: CREATE TABLE / Telnet (Linux / Unix server) I've had questions about this too. What happens if I have a primary key, and the text file has the columns that are in the existing table, with records. And I want to insert them. How do I get rid of that duplicate error? I read the manual, about 'ignore' but I can't get it to work. Any ideas? In other words, if I have a db with one table "Test" and columns: A B And my file.txt has the columns and records, so it's structured like this: A B 1 2 3 4 So when I 'load data infile file.txt' the db with 'test' table and 0 records, becomes table with records added. How do I avoid errors. The manual is no help, I tried it. Any ideas? SHould I ignore the Primary key field in the text file, and use the rest of it to avoid that duplicate error? The text file is separated by tabs. Thanks Joel - Original Message - From: Nielsen [EMAIL PROTECTED] To: C.o.m.b.u.s.t. [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, February 11, 2001 9:24 PM Subject: RE: CREATE TABLE / Telnet (Linux / Unix server) ...and this will load the table into your database. Now, in the book it doesn't specify whether or not you have to be on the computer with the server, or if you can send the .sql file command from your computer to the remote server, sort of like a file transfer protocol as well. Basically, my question is, do I have to either FTP my files to the server, and then execute the command, or can I do it remotely without FTP? Or is it possible AT ALL to execute the command from a remote computer? In case it helps, I am on a Windows 98 system connected through SSH to an Linux system running Apache. Please help, I'm stuck and I won't give up until I'm un-stuck! Thanks in advance to all that reply. The file must be on the remote machine (as has been answered), but yes, if you are connected to the shell (via telnet/ssh/ssh2/etc), you can execute the command. And, no, the extension may be anything (all you're doing is redirecting the contents of the file (via '') into the 'mysql database' command. HTH, Jon A. Nielsen. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Re: Corruption
mysql select VERSION(); +-+ | VERSION() | +-+ | 3.23.31-log | +-+ 1 row in set (0.00 sec) I swer I'm running 3.23.31 (with pgcc) but let's forget about "Contratulation message", I think the error is something related to master.info position. Thanks for your answers to another questions. Well, give me some advices to get some stability. I'll prepare a LVS cluster to avoid problems with unexpected corruption, I gave up to use mysql with pgcc (I'm afraid about it). I'm planning use a Bi-Directional replication, 2 servers with --log-slave-update and other required replication stuff, so I'll put them replicating each other and if some table get corrupted I'll change the LVS switch and my system will work fine until I fix the problem. Next time I see some bug I'll send a report with mysqlbug. Thanks, Best Regards ... Rodolfo Sikora = This table is getting corrupted all the time (twice a week). We have only SELECTS and INSERTS with little updates. (we have 140.000 registers growing faster to 100 :)) CREATE TABLE conta ( idConta int(8) unsigned NOT NULL auto_increment, idDominio int(6) unsigned DEFAULT '0' NOT NULL, conta varchar(30) DEFAULT '' NOT NULL, senha varchar(32) DEFAULT '' NOT NULL, usermount varchar(100) DEFAULT '' NOT NULL, userlock int(1) DEFAULT '0' NOT NULL, senha2 varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (idConta), UNIQUE idDominio (idDominio,conta) ); The worst is tha we have another table with 1.000.000 inserts/updates/deletes/selects and this table never get corrupted. What should I do to prevent corruptions. (every day I run an optimize, check table... etc..) Help us find and fix the bug You should work on creating a repeatable case of corruption. Start by upgrading to 3.23.33 once it is released. 3.23.33 will print the trouble query to the error log in the crash handler along with the backtrace on x86 Linux, so this should make debugging a lot easier. I'm running mysql under a NetServer LC2000 (HP) with RAID 5 and 1GB RAM, PIII 667/600. Shoudl I use -O key_buffer and/or table_cache. This will not help, although different setting that what you have may randomly obscure the bug. You should not rely on this, though. What really does FLUSH TABLES? it's ok do it once a day? It closes all the currently open tables and flushed all the buffers related to tables to to the disk. This is needed only when you want to be sure that what you have on the disk is current, and is normally not necessary. By the way I got this interesting message in my slave log: 010207 12:47:42 Error reading packet from server: Contratulations! You have hit the magic number and can win sweepstakes if you report the bug (0) If your version is pre-3.23.29, you are hitting the bug that has already been fixed. This should not happen in newer versions, if it does, it is a bug, just like the message says. Actually, looking at the message, you **are** running an old version. The evidence is the misspeled "Congratulations" in the error message. The fix is to upgrade - to 3.23.33 once it gets out, or if you cannot wait, 3.23.31. -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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
Mysql 3.23-14 keeps dieing on me...
Dear Everyone, I am presently running Mysql 3.23-14 server on a dual processor Linux box. It is the only service on the server while interactions are done via a web interface (Perl CGI) on a separate web server. About once an hour, I get the error: Aborted connection 52 to db: 'ihost' user: 'web' (Got an error reading communication packets) Immediately there after, the server fails to respond any more and I must kill all the mysqld processes and re-run safe_mysqld. I have restarted the process numerous times, I have rebooted the server, I have run myisamchk -r on the MYI files and I have check every log looking for more information. This database holds email account information. This information is modified via a web frontend with Perl CGI doing all the updates. At any given time, there are roughly 10-20 people using the web interface. I have restarted apache on the remote web server and still the problem exits. Please email possible solutions to [EMAIL PROTECTED] If you need more information, I can provide more information. Sincerely, Scott McDaniel Scott McDaniel Network EngineerWorkPhone [800] 239-3000 ITC^DeltacomWorkPhone (334) 321-3511 306 Alabama Street Fax (334) 321-3599 Auburn, AL 36832Pager [800] 294-4183 EMAIL [EMAIL PROTECTED] ICQ# 6855702 Instant MessangerPenguin0600 WEBhttp://scott.deltacom.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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Exporting DB's
mysqldump --help or, read up on it on www.mysql.com :) .. Atle On Mon, 12 Feb 2001, Jeremy Arntz wrote: Ok this is a total newbie question, but if I develope a DB on my developement server and want to export it to the live server what is process I use to do this? TIA, Jeremy J. Arntz Digital Architect Simplified Development [EMAIL PROTECTED] http://www.simplifiednow.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
Error code 13
Hello, I copy a database "demo" from one server to another. The file types are the same as other databases that exist in the destination server. I stopped and restarted mysql server. When I try to use that database using the command "use demo" it gives me the following error "Error code 13 can't read ./demo" What could be be problem? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
BDB not working well
Hello I've just compiled mysql-3.23.32 (tar.gz) with with the bdb tgz (from mysql.com) on my linuxppc machine (powermac 9600/300mhz, kernel 2.2.17 , glibc 2.1.3, gcc-2.95.3). configure --with-charset=german1 --with-extra-charsets=latin1 --with-berkeley-db I find the following problems: (1. I didn't find out how to correctly set up mysql.server to run mysql as 'mysql' user instead of root, where has the mysql_user setting gone?) 2. long delay on startup of mysql server (there must be some dns lookup or the like) 3. BDB tables are extremely slow in the first simple tests (0.2 to 2.5 seconds per query). MyIsam tables are fast as usual (0.01 secs) 4. BDB table contents show up corrupted when selected with a 'where' clause. At least, BEGIN/COMMIT/ROLLBACK work. Here's what happens in my test: mysql create table bdbtest (a int not null primary key, b text) type=bdb; Query OK, 0 rows affected (4.04 sec) mysql insert into bdbtest values(0,"Miau"); Query OK, 1 row affected (1.58 sec) mysql insert into bdbtest values(1,"Cat"); Query OK, 1 row affected (0.37 sec) mysql select * from bdbtest; +---+--+ | a | b| +---+--+ | 0 | Miau | | 1 | Cat | +---+--+ 2 rows in set (0.32 sec) mysql select * from bdbtest where a=1; +---+--+ | a | b| +---+--+ | 1 | | +---+--+ 1 row in set (0.18 sec) mysql select * from bdbtest where a=0; +---+--+ | a | b| +---+--+ | 0 | | +---+--+ 1 row in set (0.18 sec) mysql Thanks for any insights Christian Jaeger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Reading from merge table while updating underlying table
Hi, Is it okay to write to a table that is part of a merge table? The documentation is not explicit on this as far as I understand it. Anyway, when I try this in a typical logging scenario that merge tables are supposed to be useful for, I sometimes get incorrect results. My tables have these fields (and more): id: integer auth_time: integer There are some indexes. One on the id field, one on the auth_time field and some more indexes. One process is INSERTing rows as fast as it can in one of the underlying tables. The id field is incremented for each next row (I set it explicitly even though it's an auto_increment field). The auth_time field is a UNIX timestamp which is a non-decreasing value. In the mysql command-line client I do this: select count(*), max(id), from_unixtime(max(auth_time)) from authentication; Most of the time the results are plausible, but sometimes one or more of the result fields are 0 [for count(*)] or NULL. When I do this: explain select count(*), max(id), from_unixtime(max(auth_time)) from authentication; Most of the time I get a comment 'Select tables optimized away' but sometimes I get 'No matching min/max row' which seems to indicate an empty table (or some error condition). This makes me wonder if it's 'allowed' to update the tables that make up a merge table. MySQL is running on Solaris 7 for SPARC. Any help on this will be greatly appreciated. Fred. -- Fred van Engen XO Communications B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Localization
I am localizing (in French) a Delphi MySQL application which uses the Zeos components which in turn use libmysql.dll. Can anyone suggest how to translate the login dialog screen and other messages in libmysql.dll? Is there already a French version around? Thanks. Lisle Robins
how to 'live' withou transactions?
How can I do 'transaction' withou begin/commit/rollback? I don't understando how lock tables can replace it... if I have update thing set this=this; insert into stuff values(this, this and that); insert into thing_stuff values(from both thing and stuff); or whatever... and I want to be sure the ALL of them are carried out or NONE... if I had transactions I could do checks for each query and if something went wrong just rollback... but without it, I can even start to imagine... please, enlighten me... :) . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Want to Deny Access into MySql Database
I don't think that's possible. Mind you, they won't be able to do much anyway as they didn't supply any passwords. - Original Message - From: "lkeeton" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 23:30 Subject: Want to Deny Access into MySql Database I have set up my passwords into the mysql database but I am having a problem when somebody just logs in as just (mysql) without mysql -u user -ppassword. By just putting in mysql they can get into mysql, but they can't get into any of the databases unless they log on and supply a user and a password for that database. But still I would like to eliminate anybody coming into the database that isn't supposed to be there. 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: Installing on Solaris machine
The manual is a very good place to start. There is even a section specifically dealing with Solaris. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 22:43 Subject: Installing on Solaris machine Hello, Do you have a set of simple instructions to install mysql on Solaris machine? Your help is appreciated. 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 'live' withou transactions?
You could upgrade to the latest version which now supports transactions. - Original Message - From: "Christian Dechery" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 10:17 Subject: how to 'live' withou transactions? How can I do 'transaction' withou begin/commit/rollback? I don't understando how lock tables can replace it... if I have update thing set this=this; insert into stuff values(this, this and that); insert into thing_stuff values(from both thing and stuff); or whatever... and I want to be sure the ALL of them are carried out or NONE... if I had transactions I could do checks for each query and if something went wrong just rollback... but without it, I can even start to imagine... please, enlighten me... :) . Christian Dechery (lemming) . http://www.tanamesa.com.br . Gaita-L Owner / Web Developer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Who is using BDB tables in critical environment?
I feel like the BDB tables have been around long enough to be reasonably stable and mature enough to have some confidence in them. But it always helps to hear people say things like: I've been using BDB tables in a high-volume environment with no problems since date. And the BDB page-level locking has improved the performance of my application, which was previous bound by MyISAM table locks. Is anyone ready to say such a thing? Or something close to it? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to add to a set
OK, is there an easy way to ADD a value to a set type without having to enumerate all that's there already? I've looked through http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SET but it doesn't say anything about adding values to the current set. It rather looks like all or nothing, but I was hoping to avoid having to retrieve the record via a select before doing the update. What I want to do is something like this...a set variable in a table has a current value of "a,b,c" and I want to add the value "d" to it so the new value is now "a,b,c,d". The type is already defined as setval SET ('a', 'b', 'c', 'd', 'e', 'f') Thanks, --Cindy -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Data modeling tool [Long Rant and then some information]
Greetings list: I'm going to reply to my own message here. I've received 2 comments on my use of the word cartoonish when describing the interface to DeZign. While their approach was different, both basically wanted to know what I found cartoonish about the interface. First let me say that I will apologize for the use of the word cartoonish. It wasn't the best word to use, it was just the closest one that comes to mind. But it was not very accurate. Second, let me say that I won't apologize for my opinion, it's mine, if you don't like it, then get your own. Ok, I re-downloaded and re-installed DeZign.(http://www.heraut.demon.nl) For those who are not totally pissed at me now for my first faux-pas, I'll offer my opinion on the product. DeZign is a good product. I've worked with several ER diagramming programs in my 16 years of building databases and it's no where near the worst I've worked with. As a matter of fact, for the price (139.00US$) when compared to it's more "mature" brethren (ERWin, ER/Studio) it's a very good deal. However, there are several things that I personally did not like about. First, Most ER programs support a common paradigm for designing entities and attributes. Mainly that when you add an entity to the workspace, the entity is placed where you clicked. DeZign chooses to do it otherwise. It currently places all entities in the upper left corner. Also, it does not allow you to drag relationships between entities. It's a small thing but it's important when you are designing large models. (Also, I found it difficult to figure out how to do a 0:N relationship, which I consider the most common. It seems the default relationship is N:N A bit odd but nothing that a little poking around won't cure.) Finally, the interface breaks with the commonly used symbols for data modeling. Other tools use common symbols for entities and relationships. DeZign chose to use similar but non-standard symbols. All that said and done, what DeZign does have is a developer that actually cares how his product is perceived. (He reads this list!) There is nothing really wrong with DeZign. If you don't have a lot of experience with other E/R diagramming programs then you won't ever notice the things I'm talking about. But the thing you will notice about DeZign is that when you have a question, you actually get an email response from a person. That's refreshing these days. I hope I've not bored too many of you to tears. I'll go back to lurking now until another newbie questions comes along where I can help. Cal http://www.calevans.com p.s. my gripe about size limited demos still stands. -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 11, 2001 9:36 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Data modeling tool Mark, I like CASE but I wish they would add MySQL Reverse Engineering capabilities to it. The interface is clean and similar to what one expects from it's more mature brothers. (ERWin, ER/Studio) A couple of people emailed me and told me to look at http://www.heraut.demon.nl but I'm not thrilled with the interface. It looks too cartoonish and as I remember it (it's been a month or more since I looked at it) it was not the friendliest program to work with. One gripe I have about both tools. I've done ER Diagramming "Bake Off's" before. I did one for tools that supported FoxPro a few years ago. With those tools, all the demo's were timed instead of size restrictive. I wish these two vendors would provide a 30-60 day demo that is unlimited. I can't get a feel for the tool with 6 tables. (Gees, my CHECKBOOK has more tables than that!) :) I'd love to publish a full comparison of the tools but these size limited demo's bite. Cal http://www.calevans.com -Original Message- From: Mark Chalkley [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 10, 2001 6:12 PM To: [EMAIL PROTECTED] Subject: Re: Data modeling tool I haven't tried ERWin, but CASE Studio (www.casestudio.com) is extremely good, offers a trial download, and does support MySQL. Mark Chalkleyi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Re: Error code 13
Hi, This sounds like a permissions problem. Make sure your database directory is set to 770 and that the files inside (tables) are set to 660. example: # chmod 770 demo # chmod 660 demo/* Regards Jorge MySQL Development Team __ ___ __ __ / |/ /_ __/ __/ __ \/ / Jorge del Conde [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\/ Mexico City, Mexico ___/ - Original Message - From: "Rashid Zolqarnain" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 5:17 PM Subject: Error code 13 Hello, I copy a database "demo" from one server to another. The file types are the same as other databases that exist in the destination server. I stopped and restarted mysql server. When I try to use that database using the command "use demo" it gives me the following error "Error code 13 can't read ./demo" What could be be problem? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 3.23-14 keeps dieing on me...
Hi. Note that 3.23.14 (10. Apr 2000) was still considered alpha quality, so the general suggestion is to upgrade to current 3.23.33 (12. Feb 2001) release (declared stable). The chances are high that the problem you encounter has been fixed up meanwhile. Bye, Benjamin. PS: For more info see the changes history section in the fine manual, where the changes and bug fixes are listed in more detail. On Mon, Feb 12, 2001 at 05:16:19PM -0600, [EMAIL PROTECTED] wrote: Dear Everyone, I am presently running Mysql 3.23-14 server on a dual processor Linux box. [...] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SET question
This is a reply to the SET column UPDATE question (I deleted to e-mail, oups!). The question was that you have a column of type SET and value ("a,b,c") and you want to make this ("a,b,c,d") In the __MySQL MANUAL__ it says that the SET type is actually stored numerically and in particular "with the low-order bit of the stored value corresponding to the first set member" and a couple of lines further down "If a number is stored into a SET column, the bits that are set in the binary representation of the number determine the set members in the column value" i.e. if your set has values "a,b,c,d" then: a = 0001 b = 0010 c = 0100 d = 1000 So if you do an update of the form: UPDATE table SET set_var=3 WHERE my_cond; it would actually make set_var=("a,b") for the tuple that my_cond holds since the ten_Base 3 is the binary 11. So in your case that you want to add "d" to a tuple that is "a,b,c" you do UPDATE table SET set_val=15 WHERE my_cond; since 15 is in binary (the leftmost '1' is the flag that tells mysql to add the "d" in your set) does it make any sense? regards, thalis ---+ You're definitely on their list. The correct question to ask is what list it is. ---+ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SET question
"Thalis A. Kalfigopoulos" writes: So in your case that you want to add "d" to a tuple that is "a,b,c" you do UPDATE table SET set_val=15 WHERE my_cond; since 15 is in binary (the leftmost '1' is the flag that tells mysql to add the "d" in your set) does it make any sense? Yes, but it doesn't solve my problem because in actuality I don't know what the current value of the set is, I just want to add something to it. I was trying to illustrate my problem so that people didn't think I wanted to alter the table. --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Password routine
Hi all I am interesting on password routine in mysql Could some body help about this routine ? I download the source code of MySql, but i am not yet found about this routine Maybe some body have this routine in Delphi / pascal code Help me please Regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Issues compiling under Solaris
Previously someone had mentioned that the issues covered by my FAQ (located at http://users.talstar.com/forager/MySQL-HOWTO.html ) had been taken care of with releases past 3.23.28. However, just tonight I found that the problem with the broken Solaris term.h file still exists, and after running ./configure you will have to edit the config.h file and either comment out or undef the line: #define HAVE_TERM_H 1 BEFORE running make. After that things will flow smoothly. This holds true for Solaris 7/Sparc, and Solaris 8/i86 and Sparc. Hope this is helpful to people. -- Alan W. Rateliff, II: YourVillage.com Assistant Systems Administrator : 2700 Apalachee Pkwy [EMAIL PROTECTED] : Tallahassee, FL 32301 (850) 942-7021--- [EMAIL PROTECTED] http://support.yourvillage.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
external access to mysql
I and 2 others are working on a web site an occasionally. Each of us are in different locations and exchange info email. Some of them need to query the database to compare results with what is on the site with the MySQL database. My question is, is there a way to allow access to my database by creating an account for each user and allowing them to connect to the database externally? Thanks, Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqlimport - LOAD DATA LOCAL INFILE
Rus schrieb: Maybe it's problem with end_of_line symbol. You could use PHP to insert records directly into db. - Original Message - From: Irmund Thum [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, February 12, 2001 2:30 PM Subject: mysqlimport - LOAD DATA LOCAL INFILE thanks - but it was another problem (or better 2); reorganzing primary key, unique and NOT NULL for some fields I've got 106 of the 137 lines into the database and this is good enough for the tutorial site i.t -- http://it97.dyn.dhs.org/ IrmundThum +49 179 6998564 +49 6374 992541 Kryptographische Unterschrift mit S/MIME
Re: external access to mysql
Hi, again phpmyadmin can do this :) Teddy - Original Message - From: "Mike Yuen" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 13, 2001 1:45 PM Subject: external access to mysql I and 2 others are working on a web site an occasionally. Each of us are in different locations and exchange info email. Some of them need to query the database to compare results with what is on the site with the MySQL database. My question is, is there a way to allow access to my database by creating an account for each user and allowing them to connect to the database externally? Thanks, 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Insert BLOB
Hello there, I'm currently developing an app in VB with MySQL as the database and I'm having a hard time inserting a BLOB into MySQL. Can somebody share with me a code snippet on how to do this? Thanks, Eric
special characters messing me up
I can't figure out why my windows machine leaves "^M" character at the end of each line of code. This causes the file to be messed up when I put it on the Linux server. It makes my perl interpreter look for a file named ^M after the very first line. #!/usr/sbin/perl also... what else I can't figure out is why this special character is sometimes hidden and sometimes visible in my Emacs program in Linux... this is the program I used in which I found the problem. anybody know? John Ford
Shell Shocking
Hello The hosting company has given me a user name and passwd . When i log into my own site thro' a telnet session i 'm able to view all the databases created in the server that includes DBs not created by me . I also did a "USE DB" command to connect to a DB that wasn't mine . Also "Show tables" faithfully listed all the tables in the DB . I even was able to run a "SELECT " on a login table table to list all the user names and passeords listed with the company . What do i make of it An admin lapse or a inherent limitation of MySQL as the support guy makes it out . But the latter is hard to believe. Any suggestions on how to make my DB invisible on other Logins ? Any help will be deeply appreciated . Regards Donald
Re: Shell Shocking
Donald, Poor administration of the server or incorrect privileges assigned to your user account. Donald Korth wrote: Hello The hosting company has given me a user name and passwd . When i log into my own site thro' a telnet session i 'm able to view all the databases created in the server that includes DBs not created by me . I also did a "USE DB" command to connect to a DB that wasn't mine . Also "Show tables" faithfully listed all the tables in the DB . I even was able to run a "SELECT " on a login table table to list all the user names and passeords listed with the company . What do i make of it An admin lapse or a inherent limitation of MySQL as the support guy makes it out . But the latter is hard to believe. Any suggestions on how to make my DB invisible on other Logins ? Any help will be deeply appreciated . Regards Donald - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Urgent-UDF problem
Hello Sinisa and everybody else, sorry that I contact you directly! But I tried all suggestions and it still doesn't work! The UDF return string has always 256 characters! I've used my_malloc and my_free! Also I allocated the necessary memory in xxx_init()! But it doesn't work! What can I do? Who is the mysql developer who is specialized in UDF programming! It's very important! To change the initid-max_length has no effect. If I set this value on 12 or so, I will furthermore get 256 characters, why? Is it a bug? Thank you for your help and support! Greetings Tom Some code: // init function my_bool IHistogram_init(UDF_INIT *initid, UDF_ARGS *args, char *message){ // Parameter: ID, filepointer, data if (args-arg_count != 3) { strcpy(message,"Usage: ID, filepointer and data field."); return 1; } initid-ptr = (char*) my_malloc (65535 * sizeof(char), MY_ZEROFILL); // Set types args-arg_type[0] = STRING_RESULT; args-arg_type[1] = STRING_RESULT; args-arg_type[2] = STRING_RESULT; return 0; } void IHistogram_deinit(UDF_INIT *initid) { my_free(initid-ptr, MY_ZEROFILL); } char* IHistogram(UDF_INIT *initid, UDF_ARGS *args, char *result, unsigned long length, char *is_null, char *error){ char* res; // Calc histogram, result: histogram-string res = checkIHist(args-args[0], args-args[1], args-args[2], args-lengths[1], args-lengths[2]); // Error occured if (strcmp(res, "ERROR") == 0){ *error = 1; return 0; } else{ initid-ptr = res; return initid-ptr; } } - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php