bug in bdb-table handler ???
hello mysql-team, i am sorry if i do not correctly report this bug, but i do not know how i should make it sure with a script, that you can verify or repeat this bug. however i have a dump of my mysql-database attached to this mail and hope it will be enough. i am using mysql source distribution 3.23.36 with bdb-tablehandler on a linux server. my problem is that the result sets i receive from my tables are not always correct. if i do the select statement: SELECT MA_Key FROM Counsel_Skill WHERE MA_Key=1 AND CO_Key=1 GROUP BY MA_Key the result set should contain one record (1). sometimes (and i do not know when and why) i receive an empty result set. if this error occurs i do the select statement: SELECT MA_Key FROM Counsel_Skill WHERE MA_Key=1 AND SK_Key=10 GROUP BY MA_Key and afterwards the first select statement again: SELECT MA_Key FROM Counsel_Skill WHERE MA_Key=1 AND CO_Key=1 GROUP BY MA_Key and then it works! i do not understand this - can you help me with this problem - it is really important thanks a lot bye kerstin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Binary
Is there some kind of pattern in fields containing binary data - so you can be sure that is really IS binary!? I.e. if I in my database have a BLOB-field and sometimes write a string, and sometimes a file?! Regards David - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
bug in bdb-table handler ??? [Virus checked with Trend Micro Anti Virus]
upssorry - i forgot to attach the database :-) (See attached file: econDB.dump) --- hello mysql-team, i am sorry if i do not correctly report this bug, but i do not know how i should make it sure with a script, that you can verify or repeat this bug. however i have a dump of my mysql-database attached to this mail and hope it will be enough. i am using mysql source distribution 3.23.36 with bdb-tablehandler on a linux server. my problem is that the result sets i receive from my tables are not always correct. if i do the select statement: SELECT MA_Key FROM Counsel_Skill WHERE MA_Key=1 AND CO_Key=1 GROUP BY MA_Key the result set should contain one record (1). sometimes (and i do not know when and why) i receive an empty result set. if this error occurs i do the select statement: SELECT MA_Key FROM Counsel_Skill WHERE MA_Key=1 AND SK_Key=10 GROUP BY MA_Key and afterwards the first select statement again: SELECT MA_Key FROM Counsel_Skill WHERE MA_Key=1 AND CO_Key=1 GROUP BY MA_Key and then it works! i do not understand this - can you help me with this problem - it is really important thanks a lot bye kerstin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Please tell me how to select the 10 (or 5) newest records or posts from a MySql table. Best Wishes Signe Hasseriis
mysql client
What is mysqlclient and mysql server. Where will I get it. What is the difference between them. Thanks in advance. Poornima Visvesvaran. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: atttempting to connect remotely using mysql gui
Hello John, There is a tute of sorts at: http://terra.tafe.tas.edu.au/~beechd/rdb/rdbd_mysql_intro.html which will help if you have problems with the acces/privilege model. Also: Have you installed an ODBC driver (MyODBC) correctly? and set up a DSN? It is most likely that the problem is an access issue and can be solved by using GRANT eg grant select on stusys.* to '[EMAIL PROTECTED]' identified by 'joe' David On 26 May 2001, at 21:22, John C. Dale wrote: I'm using the mysql gui client on a windows machine and attempting to connect to mysql on a linux machine for the purpose of doing some database design. I can't get a connection, however. I get the following error message: access denied for user username@userip address (using password: YES) I'm rather new to mysql, but have used oracle and sql server. I was unable to find a cookbook or tutorial for establishing a connection with the gui. I'm assuming that there is something I need to do on the server-side to enable/facilitate this remote connection. Furthermore, I would like to use jdbc to make remote connections to the database, but assume that I'll run into similar problems. All/any help would be very much appreciated. Sincerely, John C. Dale Lead Java Architect, Project Manager, Lead Software Engineer Down in the Desert productions [EMAIL PROTECTED] www.downinthedesert.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication Problems
Hi Before enabling replication between two live machines, I've been doing some tests in the office between two similar machines. Everything appears to work well, as expected, except the command LOAD TABLE x FROM MASTER; This records an error on the screen ERROR 1188: Error From master: 'Access denied for user : ' and in mysql.err 010529 092358 fetch_nx_table: failed on create table Does anyone have an idea what might be causing this error ? Thanx Simon -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700744 Fax: +44 (0) 1249 700725 Email: mailto:[EMAIL PROTECTED] This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Thank you for your cooperation and assistance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 1030: got error 28 from table handler
On 29-May-01 Griff Hamlin wrote: Hello, snip I have tried the set SQL_BIG_TABLES flag set to 1, but that did not help and now I'm out of ideas. Any suggestions would be appreciated. localhost.dread$ perror 28 Error code 28: No space left on device put --tmpdir on a bigger disc. Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do 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
Re: how to
On Tue, 29 May 2001, Signe Hasseriis wrote: Please tell me how to select the 10 (or 5) newest records or posts from a MySql table. Best Wishes Signe Hasseriis IMHO, there's no fair way. May be this trick works. add a field with type timestamp to your table, for example 'modified'. then select your table like this query : select * from tbl_foo order by modified desc limit 5; the field 'modified' will be updated every update/insert query. CMIIW - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Binary
Hi, See 'BLOB' column type in the manual. David Lidström wrote: Is there some kind of pattern in fields containing binary data - so you can be sure that is really IS binary!? I.e. if I in my database have a BLOB-field and sometimes write a string, and sometimes a file?! Regards David - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL++ for Visual Basic
Has seen an ocx for the MySQL++ to allow Visual Basic to control MySQL databases? I have seen a tool on the MySQL site called MyTool-DLL, this does the job but the code is licenced, I am looking at source code to do this if possible!
Optimizing a query with a new index
Hi all. I want to optimize a query that is executed often in the application we use at work. NOTE: Excuse me for using spanish names for the tables and the columns. In the database we have three tables for article: ARTICULOINFO (information of an article), LARTICULOINFO_IDIOMA (information of an article that depends of the language, we use it for the locals we have in Portugal) and LARTICULOINFO_PVP (information of the price of an article for a determinated local). When the language of the application is spanish the query is SELECT ART.*, IFNULL(ART_PVP.PVP, ART.PVP) AS PVPREAL FROM ARTICULOINFO ART LEFT JOIN LARTICULOINFO_PVP ART_PVP ON (ART.ID = ART_PVP.IDARTICULOINFO AND ART_PVP.FECHAINICIO = '2001-05-29' AND ART_PVP.FECHAFINAL = '2001-05-29' AND ART_PVP.IDLOCAL = 'LOC:0:0') WHERE ART.descripcion LIKE '%teka%' Otherwise the query is: SELECT ART.*, IFNULL(ART_PVP.PVP, ART_IDI.PVP) AS PVPREAL FROM LARTICULOINFO_IDIOMA ART_IDI, ARTICULOINFO ART LEFT JOIN LARTICULOINFO_PVP ART_PVP ON ( ART.ID = ART_PVP.IDARTICULOINFO AND ART_PVP.FECHAINICIO = '2001-05-29' AND ART_PVP.FECHAFINAL = '2001-05-29' AND ART_PVP.IDLOCAL = 'LOC:0:0' ) WHERE ART.descripcion LIKE '%teka%' NOTE: This is an example of the query looking for the description of the article. When I use the explain command whith the first query it responds: mysql explain SELECT ART.*, IFNULL(ART_PVP.PVP, ART.PVP) AS PVPREAL FROM ARTICULOINFO ART LEFT JOIN LARTICULOINFO_PVP ART_PVP ON (ART.ID = ART_PVP.IDARTICULOINFO AND ART_PVP.FECHAINICIO = '2001-05-29' AND ART_PVP.FECHAFINAL = '2001-05-29' AND ART_PVP.IDLOCAL = 'LOC:0:0') WHERE ART.descripcion LIKE '%teka%'; +-+---+- +-+-+--+---++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-+---+- +-+-+--+---++ | ART | ALL | NULL | NULL|NULL | NULL | 33847 | where used | | ART_PVP | range | idArticuloInfo,idLocal,fechaInicio,fechaFinal,join_articulo | idLocal | 26 | NULL | 1 | where used | +-+---+- +-+-+--+---++ 2 rows in set (0.00 sec) The index for LARTICULOINFO_PVP are: mysql show index from LARTICULOINFO_PVP; +---+++--+-- --+---+-+--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name| Collation | Cardinality | Sub_part | Packed | Comment | +---+++--+-- --+---+-+--++-+ | LARTICULOINFO_PVP | 0 | PRIMARY|1 | id | A | 1 | NULL | NULL | NULL| | LARTICULOINFO_PVP | 1 | idArticuloInfo |1 | idArticuloInfo | A | 1 | NULL | NULL | NULL| | LARTICULOINFO_PVP | 1 | idLocal|1 | idLocal | A | 1 | NULL | NULL | NULL| | LARTICULOINFO_PVP | 1 | fechaInicio|1 | fechaInicio| A | 1 | NULL | NULL | NULL| | LARTICULOINFO_PVP | 1 | fechaFinal |1 | fechaFinal | A | 1 | NULL | NULL | NULL| | LARTICULOINFO_PVP | 1 | join_articulo |1 | idLocal | A | 1 | NULL | NULL | NULL| | LARTICULOINFO_PVP | 1 | join_articulo |2 | idArticuloInfo | A | 1 | NULL | NULL | NULL| | LARTICULOINFO_PVP | 1 | join_articulo |3 | fechaInicio| A | 1 | NULL | NULL | NULL| | LARTICULOINFO_PVP | 1 | join_articulo |4 | fechaFinal | A | 1 | NULL | NULL | NULL| +---+++--+-- --+---+-+--++-+ 9 rows in set (0.00 sec) I've added the index join_articulo for the columns idLocal, idArticuloInfo, fechaInicio and fechaFinal expecting that the query will use this index but it didn't. Instead it uses index idLocal. I think it will use index jon_articulo because it has the four columns in the condition of the left join. It's is in a MyIsam database of mysql 3.23.27 we use for test but in the production database (Isam tables in mysql 3.22.30) it's worse the explain comand responds: +-+---+- +--+-+--+---++ | table | type | possible_keys
RE: MySQL++ for Visual Basic
I use an Open Source mySQL API. [homepage] http://www.icarz.com/mysql/index.html / d -Original Message- From: Cyber Monkey [mailto:[EMAIL PROTECTED]] Sent: den 29 maj 2001 11:20 To: [EMAIL PROTECTED] Subject: MySQL++ for Visual Basic Has seen an ocx for the MySQL++ to allow Visual Basic to control MySQL databases? I have seen a tool on the MySQL site called MyTool-DLL, this does the job but the code is licenced, I am looking at source code to do this if possible! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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++ for Visual Basic
Cyber Monkey wrote: Has seen an ocx for the MySQL++ to allow Visual Basic to control MySQL databases? Actually you dont't need a ocx. You can call the MySQL API functions, which are in a dll file. Robert - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
LOAD table from master failure
Hello mysql, I just tried to build replica on the fly and encountered strange problem. When I do LOAD table stopword from master it hangs forever and in logs I'm getting this 010529 14:04:13 Duplicate key 1 for record at 315 against new record at 0 010529 14:04:13 fetch_nx_table: failed on create table I don't think 315 is a row number because mysql select count(*) from stopword; +--+ | count(*) | +--+ | 99 | +--+ 1 row in set (0.00 sec) On the replica server I have mysql select count(*) from stopword; +--+ | count(*) | +--+ |0 | +--+ 1 row in set (0.00 sec) Neither CHECK nor REPAIR table stopword on master give me an error. I don't know what to now. Maybe someone help me? Table definition: CREATE TABLE stopword ( word char(32) NOT NULL default '', lang char(2) NOT NULL default '', PRIMARY KEY (word,lang) ) TYPE=MyISAM; -- Best regards, Vinche mailto:[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
No subject
Dear Sir, When I run this php script then system show some errors. script and errors is below . Please advice me how can I resolv this problem. /var/www/html/test2.php --- ? $dbuser = 'root'; $dbhost = 'localhost'; $dbpass = 'root'; $dbname = 'mysql'; $dbtable = 'user'; mysql_connect ($dbhost, $dbuser, $dbpass); $mysql_link = mysql_connect($dbhost, $dbuser, $dbpass); $column=mysql_list_fields($dbname,$dbtable,$mysql_link); for ($i=0;$imysql_num_fields($column);$i++) { print mysql_field_name($column,$i).br; } ? Errors after browsing via web page: --- Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/test2.php on line 7 Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in /var/www/html/test2.php on line 8 Warning: Supplied argument is not a valid MySQL-Link resource in /var/www/html/test2.php on line 9 Warning: Supplied argument is not a valid MySQL result resource in /var/www/html/test2.php on line 10 Regards, Iqbal - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Direct communication with internet server
You can use MyODBC to establish database connection to your server using Delphi application. http://www.mysql.com/downloads/api-myodbc.html In addition to that you can use secure shell (OpenSSH/SSH) port forwarding facility for secure connection to your server. good luck, -- [EMAIL PROTECTED] JfActiveSoft jfactivesoft@jfactivTo: [EMAIL PROTECTED] esoft.com cc: Subject: Direct communication with internet 2001.05.29 08:57 server Hello to all, Is it possible to communicate with a database that is in a Internet server without using PHP? How can one make? In Host it is necessary to put the primary server DNS? Can it be carried out the communication with Delphi? What parameters is it necessary to use? Thank you. Best Regards, Jose Antonio Molina - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Odbc on NT
Im having aproblem in connecting via Odbc to the MySql Server. I working on a pentium III with NT 4.0 Server. The error is the following: SQLDriverConnect returned: SQL_ERROR=-1 dbc: szSqlState = S1000, *pfNativeError = 2003, *pcbErrorMsg = 65 MessageText = [TCX][MyODBC]Can't connect to MySQL server on 'localhost' (10061) dbc: szSqlState = S1000, *pfNativeError = 2003, *pcbErrorMsg = 65 MessageText = [TCX][MyODBC]Can't connect to MySQL server on 'localhost' (10061) dbc: szSqlState = 01000, *pfNativeError = 0, *pcbErrorMsg = 140 MessageText = [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). dbc: szSqlState = 01000, *pfNativeError = 0, *pcbErrorMsg = 140 MessageText = [Microsoft][ODBC Driver Manager] The driver doesn't support the version of ODBC behavior that the application requested (see SQLSetEnvAttr). im using the myodbc 2.50.37 with mysql 3.23.38. If somebody can help me i would apreciate. Thanx Bruno Santos - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Problems
Hi Problem solved. After adding select permission (now file+select) to the replication user the command LOAD TABLE x FROM MASTER works perfectly. The only question is, why does this command need SELECT permission, whilst the rest of replication does not ? Simon On Tuesday 29 May 2001 10:06, you wrote: Hi Before enabling replication between two live machines, I've been doing some tests in the office between two similar machines. Everything appears to work well, as expected, except the command LOAD TABLE x FROM MASTER; This records an error on the screen ERROR 1188: Error From master: 'Access denied for user : ' and in mysql.err 010529 092358 fetch_nx_table: failed on create table Does anyone have an idea what might be causing this error ? Thanx Simon -- Simon Windsor CricInfo http://www.cricinfo.com/ Tel: +44 (0) 1249 700744 Fax: +44 (0) 1249 700725 Email: mailto:[EMAIL PROTECTED] This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. Thank you for your cooperation and assistance. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
multiple mysql servers?
Hello All: Did anybody setup multiple mysql servers on single machine? Do I have to use mysqld_multi? I tried using this but gives me this error: ABORT: Bad GNR: mysql2 See mysqld_multi --help This is how I ran mysqld_multi: mysqld_multi --config-file=/etc/my.cnf start mysqld2 Here are the entries in my.cnf file: [mysqld2] socket=/var/lib/mysql/mysql.sock2 port=3308 pid-file=/var/run/mysqld/mysqld.pid2 datadir=/var/lib/mysql2 language=/usr/share/mysql/english Here is my environment: RedHat Linux 7.0 MySQL 3.23.32 Any pointers would be greatly appreciated! Thanks! ...Rohit
My sql and system time
Hi, Can some one let me know how can I insert current time into the MySQL table's time column. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: My sql and system time
Field | Type | Null | Key | Default | Extra ---+--+--+-+-+--- hora | time | YES | | | insert into hora values (curtime()) - Original Message - From: VVM Ravikumar Sarma Chengalvala [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 10:07 AM Subject: My sql and system time Hi, Can some one let me know how can I insert current time into the MySQL table's time column. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: My sql and system time
Hi! Try this: INSERT INTO my_table (myTimeField) VALUES (CURTIME()) [also see] http://www.mysql.com/doc/D/a/Date_and_time_functions.html -Original Message- From: VVM Ravikumar Sarma Chengalvala [mailto:[EMAIL PROTECTED]] Sent: den 29 maj 2001 15:07 To: [EMAIL PROTECTED] Subject: My sql and system time Hi, Can some one let me know how can I insert current time into the MySQL table's time column. Regards, Ravi Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, UniData and ODBC question
MySQL users, Our department is in the midst of reengineering the way data on our email server (MySQL on Linux) is kept in sync with the data on our administrative server (UniData on Tru64). I am not familiar with ODBC connectivity but from what I have heard and read, it might be our only hope of getting UniData and MySQL to communicate, even if on the most basic level. We have ODBC connectivity to UniData as well as our MySQL database but we need to figure out how to get UniData to access MySQL or vice versa. I was hoping to find a Perl DBI module for UniData but that search has turned up nothing. Any suggestions, comments or small nuggets of wisdom would be GREATLY appreciated. Thanks, Allen Belk | Allen Belk, Systems Administrator | Office of Information Technology | Saint Leo University, Saint Leo, FL | [EMAIL PROTECTED] - (352) 588-8592 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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++ for Visual Basic
Hi, Mytool is GPL, use any way you like. For current mytool docs see (www.icarz.com/mysql/index.html ). The tools uses the MySQL windows dll, you can of course use this directly. Mytool is licensed that same as MySQL. That was the intent. Also www.scibit.com sells a nice library for VB. GL, Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: Cyber Monkey [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 5:19 AM Subject: MySQL++ for Visual Basic Has seen an ocx for the MySQL++ to allow Visual Basic to control MySQL databases? I have seen a tool on the MySQL site called MyTool-DLL, this does the job but the code is licenced, I am looking at source code to do this if possible! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FoxPro6 and MySQL, odbc
Hi, I see there are ways to have MySQL obtain data from a FoxPro database--using ODBC--which is very nice, I'm sure. However, is it possible to run a FoxPro program that gets data from a MySQL database?? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Installation Problem
Hello I have just installed MySQL on a Win98 machine and on trying to load mysqld.exe I get the following error: can't initialise InnoDB as innodb_file_data_path is not set can anyone help with this? Many thanks, Sean Browne.
Re: mySQL databases over two drives
This isn't awfully useful to you, but it's dead easy to do this on a Unix system. All you do is copy the data over wherever you like (to a big, fat, drive), and then link the new directory from the /usr/local/mysql/data/ directory (ln -s). OTOH, I guess you can't link a file/directory in Windows/DOS. David Brieck [EMAIL PROTECTED] on 05/29/2001 09:13:17 AM To: Chris Mallett [EMAIL PROTECTED], myODBC List \(E-mail\) [EMAIL PROTECTED] cc:(bcc: Charles Kirby/Usdcsdny) Subject: Re: mySQL databases over two drives I'm not sure where you heard that MySQL only like to run on the C drive. I've got my test bed at home running on my E drive and the production server where I work runs on the D drive. Works great here! - Original Message - From: Chris Mallett To: myODBC List (E-mail) Sent: Tuesday, May 29, 2001 5:51 AM Subject: mySQL databases over two drives hi everyone We have mySQL installed on the c drive of our server. However, we need to move a mySQL database to another drive for more space. Will we need to also re-install mySQL on the new drive? I have heard that mySQL is only truly happy running on the C drive - is this true? Is it possible to keep mySQL on the c drive but move the database files to another drive? This way mySQL would still run on the c drive but retrieve the database info from another drive. Any help would be greatly appreciated. cheers chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question about UDF
conditions: MySQL-3.23.32 FreeBSD 4.2-RELEASE problem: == MySQL documentation: 16.1 Adding a New User-definable Function [...] The MySQL source distribution includes a file `sql/udf_example.cc' that defines 5 new functions. Consult this file to see how UDF calling conventions work. [...] == sql/udf_example.cc: ** A dynamicly loadable file should be compiled sharable ** (something like: gcc -shared -o udf_example.so myfunc.cc). ** You can easily get all switches right by doing: ** cd sql ; make udf_example.o ** Take the compile line that make writes, remove the '-c' near the end of ** the line and add -o udf_example.so to the end of the compile line. ** The resulting library (udf_example.so) should be copied to some dir ** searched by ld. (/usr/lib ?) == bash-2.04$ make udf_example.o c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql-3.23.32\ -DDATADIR=\/db/mysql\ -DSHAREDIR=\/usr/local/mysql-3.23.32/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex-I. -I../include -I.. -I.-O3 -DDBUG_OFF -fno-implicit-templates -DMYSQLD_NET_RETRY_COUNT=100 -c udf_example.cc == bash-2.04$ c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local/mysql-3.23.32\ -DDATADIR=\/db/mysql\ -DSHAREDIR=\/usr/local/mysql-3.23.32/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex -I. -I../ include -I.. -I. -O3 -DDBUG_OFF -fno-implicit-templates -DMYSQLD_NET_RETRY_COUNT=100 udf_example.cc -o udf_example.so /usr/lib/crt1.o: In function `_start': /usr/lib/crt1.o(.text+0x79): undefined reference to `main' /tmp/ccH74112.o: In function `metaphon': /tmp/ccH74112.o(.text+0x4a): undefined reference to `default_charset_info' == Can somebody tell me where source of the problem can be? - Mike Andreev Programer SMIS Lab, Space Research Institute (Moscow, Russia). http://smis.iki.rssi.ru [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: FoxPro6 and MySQL, odbc
within VFP it is. Cal http://www.calevans.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 8:50 AM Subject: FoxPro6 and MySQL, odbc Hi, I see there are ways to have MySQL obtain data from a FoxPro database--using ODBC--which is very nice, I'm sure. However, is it possible to run a FoxPro program that gets data from a MySQL database?? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to
On 29 May 2001 09:28:04 +0200, Signe Hasseriis wrote: Please tell me how to select the 10 (or 5) newest records or posts from a MySql table. SELECT * FROM table ORDER BY posttime DESC LIMIT 5 -- MySQL Security Administrator __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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: mysql client
On 29 May 2001 00:27:42 -0700, Poornima Visvesvaran wrote: What is mysqlclient and mysql server. mysqlclient is name of MySQL client side library. mysql server is a MySQL Server. Where will I get it. http://www.mysql.com What is the difference between them. MySQL server stores data and know how to find something within it. All client side stuff doesn't know much about data but knows, how to ask it. One server can answer queries of many clients. -- MySQL Security Administrator __ ___ ___ __ / |/ /_ __/ __/ __ \/ / 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: Aborted connections
Hi, I have also noticed these aborted connections, unfortunately my time is too divided to give this 100%. I have just created a test situation with 3 server and a large application that inserts about 300,000 large rows. This application aborts after several hours with an aborted connection message of FreeBSD (4.3) but not on Linux, I am today running a test with BSDi, but I think it will succeed. After that I will start debugging more closely the network reads and writes. Can you please tell me what network card/driver you are running, the output from dmesg would help. As I am still gathering information I can not yet make any firm conclusions. If anyone else has comments please e-mail me privately and I will gather a concensus then report after we have facts. Thanks Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: Jaap de Heer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 27, 2001 3:35 PM Subject: Aborted connections Hi, We've recently upgraded our 2 mysql servers from 3.22 to 3.23.36, and since then we occasionally get errors like the following in the servers' error logs: 010527 21:01:26 Aborted connection 461457 to db: 'clantsf' user: 'tsf' host: `pride.gamepoint.net' (Got an error reading communication packets) We've upgraded the client machines from 3.22 to 3.23.32 (the version that comes with PHP 4.0.5) assuming it was a version conflict, but this doesn't seem to make any difference. This only happens once in every 1000 connects or so. It happens to connections from all client machines. The server machines run FreeBSD 3.5-STABLE and 4.2-STABLE on Intels. Both the mysqlds were compiled from source. The client machines are one Sparc running SunOS, and a few Intels running RedHat 6.2, with kernels 2.2.19 and 2.4.3. The connections are made by PHP scripts running on Apache 1.3.19 with PHP 4.0.5, using persistent connections. Does anyone know what the problem might be, or how I can find out? Thanks a lot, Jaap de Heer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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/php problem
I'm running FreeBSD 3.4, Apache 1.3.9 w/ php4 and mysql 3.22.32. The problem I'm having is that my php scripts work fine, mysql works fine. When I run a php script, everthing in the script works up to the point were I try mysql_connect. I get no error, but the script just hangs. It never connects to the database. I've looked through all my logs, and there are no errors listed anywhere. Any ideas? Here is the code I'm testing all this with: html head title My php test script /title /head body ?php $user = root; $pass = Taylor; $db = CollegeBound; $link = mysql_connect( localhost, $user, $pass ); if ( ! $link ) die( Couldn't connect to MySQL ); mysql_select_db ( $db, $link ) or die ( Couldn't open $db: .mysql_error() ); $result = mysql_querry( SELECT * FROM Address ); $num_rows = mysql_num_rows ( $result ); print There are currently $num_rows rows in the tableP; msyq_close( $link ); phpinfo(); ? /body /html JUMP Technology Services Stephanie DeVille Systems Engineer 918.317.1256 (w) 918.625.6106 (c) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Question about UDF
Tuesday, May 29, 2001, 6:11:31 PM, you wrote: MVA conditions: MVA MySQL-3.23.32 MVA FreeBSD 4.2-RELEASE MVA problem: sorry for spam. I'm newbie in this stuff. Now i compiled this example, but it still doesn't work bash-2.04$ mysql -p -u admin mysql CREATE FUNCTION metaphon RETURNS STRING SONAME udf_example.so; ERROR 1126: Can't open shared library 'udf_example.so' (errno: 0 /usr/local/lib/udf_example.so: Undefined symb ol default_charset) - Mike Andreev Programer SMIS Lab, Space Research Institute (Moscow, Russia). http://smis.iki.rssi.ru [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
Can't change password in MySQL Windows version
Hello all! Can anyone help me why I cannot change a user's password in the Windows version of MySQL (except for the root account)? I keep getting the ERROR 1133: Can't find any matching row in the user table error message everytime I try to change a user's password, both from mysqladmin and from SET PASSWORD command. FYI I'm using version 3.23.28-gamma running on Win98. Thanx in advance! Ardianto Rustandi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Can't login to MySQL from PHP
Hello, I am a novice to Apache, MySQL and PHP. I have just installed these on my Win98SE machine, and want to do some off-line ('localhost') exercises before I go on the web. Apache and PHP work; I can run PHP scripts that do not access a database. But as soon as I try mysql_connect(), I get errors. I am sure it is something very basic I am missing. Perhaps it's a matter of username/password; I fooled around a bit with those, but to no effect (how are those verified? I suppose they have to be entered in 2 places?). Does anyone have a hint? Or can someone guide me through a procedure to track the problem? Which additional info do you need? Thanks, Marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice please. | Don't put me on any kind of mailing list. | | I am now receiving the Snowhite virus 4x a day | - some of you must be infected, please check ! | (No, you did not get it from me, I use Eudora) | __@ | _`\,_ |__(*)/ (*)Ah, op DIE fiets ! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help! How to use dBase with mySQL?
On Mon, 28 May 2001, Pat Suwalski wrote: I'm doing a school project for which I'm to write a PHP script with MySQL that searches a dBase database. I've got my code planned out, but the problem right now seems to be that mySQL can't directly read dBase databases. It's a fairly large database (9 megs), and so I ask: do I need to convert it somehow or can I just read it directly? Pat I recently hacked some C code to convert dbase data into sql. I can't even remember for which version of dbase it works, but you may use this as a starting point. It translates character sets as well. Thomas snip /* dbase2sql.c * acts as a filter * takes a dbase file from stdin * and outputs sql code to stdout * a tablename may be given as an argument (optional) * compile with: me@box gcc -o dbase2sql dbase2sql.c * use as: me@box cat dbasefile.dbf | dbase2sql dbasefile.sql * [ this hack is in the public domain ] */ #include stdio.h #include stdlib.h #define VERSION 1.0 #define HEADERLENGTH32 #define BUFSIZE 4096 #define LINEBUFFER 4096 #define NCOLUMNS200 const char *defaulttable=noname; int offset[NCOLUMNS]; int fieldsize[NCOLUMNS]; unsigned char columntype[NCOLUMNS]; /* * this is basically the file * '/usr/lib/kbd/consoletrans/cp850_to_iso01.trans' * as found on most Linux systems. * The first value of each code pair is a character in the iso_8859-1 * character set. The second value is the corresponding code * in the cp850 character set as used on many Windoze boxes. * Initialization inittr(void) will bring this into a more useable form. */ int trtable[192] = { 0xa0, 0xff, 0xa1, 0xad, 0xa2, 0xbd, 0xa3, 0x9c, 0xa4, 0xcf, 0xa5, 0xbe, 0xa6, 0xdd, 0xa7, 0x15, 0xa8, 0xf9, 0xa9, 0xb8, 0xaa, 0xa6, 0xab, 0xae, 0xac, 0xaa, 0xad, 0xf0, 0xae, 0xa9, 0xaf, 0xee, 0xb0, 0xf8, 0xb1, 0xf1, 0xb2, 0xfd, 0xb3, 0xfc, 0xb4, 0xef, 0xb5, 0xe6, 0xb6, 0x14, 0xb7, 0xfa, 0xb8, 0xf7, 0xb9, 0xfb, 0xba, 0xa7, 0xbb, 0xaf, 0xbc, 0xac, 0xbd, 0xab, 0xbe, 0xf3, 0xbf, 0xa8, 0xc0, 0xb7, 0xc1, 0xb5, 0xc2, 0xb6, 0xc3, 0xc7, 0xc4, 0x8e, 0xc5, 0x8f, 0xc6, 0x92, 0xc7, 0x80, 0xc8, 0xd4, 0xc9, 0x90, 0xca, 0xd2, 0xcb, 0xd3, 0xcc, 0xde, 0xcd, 0xd6, 0xce, 0xd7, 0xcf, 0xd8, 0xd0, 0xd1, 0xd1, 0xa5, 0xd2, 0xe3, 0xd3, 0xe0, 0xd4, 0xe2, 0xd5, 0xe5, 0xd6, 0x99, 0xd7, 0x9e, 0xd8, 0x9d, 0xd9, 0xeb, 0xda, 0xe9, 0xdb, 0xea, 0xdc, 0x9a, 0xdd, 0xed, 0xde, 0xe8, 0xdf, 0xe1, 0xe0, 0x85, 0xe1, 0xa0, 0xe2, 0x83, 0xe3, 0xc6, 0xe4, 0x84, 0xe5, 0x86, 0xe6, 0x91, 0xe7, 0x87, 0xe8, 0x8a, 0xe9, 0x82, 0xea, 0x88, 0xeb, 0x89, 0xec, 0x8d, 0xed, 0xa1, 0xee, 0x8c, 0xef, 0x8b, 0xf0, 0xd0, 0xf1, 0xa4, 0xf2, 0x95, 0xf3, 0xa2, 0xf4, 0x93, 0xf5, 0xe4, 0xf6, 0x94, 0xf7, 0xf6, 0xf8, 0x9b, 0xf9, 0x97, 0xfa, 0xa3, 0xfb, 0x96, 0xfc, 0x81, 0xfd, 0xec, 0xfe, 0xe7, 0xff, 0x98}; int trlist[256]; void inittr(void) { int i, k; for(i=0; i256; i++) { trlist[i] = i; for(k=1; k192; k+=2) { if(i == trtable[k]) trlist[i] = trtable[k-1]; } } } int translate(int c) { return(trlist[c]); } void stripdata(unsigned char *lbuf, int columns) { int i, k; unsigned char *begincol, *endcol, *colptr, *prptr; for(i=1; icolumns; i++) { switch(columntype[i]) { case 'C': begincol = lbuf + offset[i]; endcol = begincol + fieldsize[i]; colptr = endcol -1; /* trailing blanks must be removed */ while((colptr begincol) (*colptr == ' ')) { colptr--; } k = colptr - begincol + 1; if(*begincol == ' ') { printf(''); } else { printf('%*.*s', k, k, begincol); } if(i (columns-1)) { printf(,); } break; case 'N': begincol = lbuf + offset[i]; endcol = (begincol + fieldsize[i])-1; colptr = begincol; /* leading blanks must be removed */ while((colptr endcol) (*colptr == ' ')) { colptr++; } k = (endcol - colptr) + 1; if(*endcol == ' ') { printf(NULL); } else { printf(%*.*s, k, k, colptr); } if(i (columns-1)) { printf(,); } break; case 'D':
RE: mySQL databases over two drives
You can do this with NT Server as well. It is called Distributed File System (DFS). You may have to download it from Microsoft but it is free. I think it is built into Win 2000. You will have to muck around in the documentation for the details. HTH Tracy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 6:54 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mySQL databases over two drives This isn't awfully useful to you, but it's dead easy to do this on a Unix system. All you do is copy the data over wherever you like (to a big, fat, drive), and then link the new directory from the /usr/local/mysql/data/ directory (ln -s). OTOH, I guess you can't link a file/directory in Windows/DOS.
Re: Can't login to MySQL from PHP
have you tried using mysql_connect without the preceding @? This may give you some error info on the page... of course, I am a newbie too and I am using it on a Unix box so I could be totally off.. thanks, shawn On Tue, 29 May 2001, Marco Bleeker wrote: Hello, I am a novice to Apache, MySQL and PHP. I have just installed these on my Win98SE machine, and want to do some off-line ('localhost') exercises before I go on the web. Apache and PHP work; I can run PHP scripts that do not access a database. But as soon as I try mysql_connect(), I get errors. I am sure it is something very basic I am missing. Perhaps it's a matter of username/password; I fooled around a bit with those, but to no effect (how are those verified? I suppose they have to be entered in 2 places?). Does anyone have a hint? Or can someone guide me through a procedure to track the problem? Which additional info do you need? Thanks, Marco | | Marco Bleeker, Amsterdam | [EMAIL PROTECTED] | http://www.euronet.nl/users/mbleeker/ | | Attachments only after prior notice please. | Don't put me on any kind of mailing list. | | I am now receiving the Snowhite virus 4x a day | - some of you must be infected, please check ! | (No, you did not get it from me, I use Eudora) | __@ | _`\,_ |__(*)/ (*)Ah, op DIE fiets ! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 databases over two drives
Look up link or something in the manual. There is a way to do virtual symbolic links in NT with mysql without installing anything, it has to do with adding paths to the my.cnf file, see the docs for details. Tracy A. Mitchell wrote: You can do this with NT Server as well. It is called Distributed File System (DFS). You may have to download it from Microsoft but it is free. I think it is built into Win 2000. You will have to muck around in the documentation for the details. HTH Tracy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 6:54 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: mySQL databases over two drives This isn't awfully useful to you, but it's dead easy to do this on a Unix system. All you do is copy the data over wherever you like (to a big, fat, drive), and then link the new directory from the /usr/local/mysql/data/ directory (ln -s). OTOH, I guess you can't link a file/directory in Windows/DOS. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
install_driver(mysql) failed: Can't locate object method bootstrap via package
Hey everyone! I'm hoping someone can help me out with this... I'm trying to write a perl/cgi to connect to mysql. This is my code: #!/usr/bin/perl print Content-type: text/html\n\n; use DBI(); connect(DBD::mysql,usertest); read(STDIN, $buffer, $ENV{'CONTENT_LENGTH'}); @pairs = split(//, $buffer); foreach $pair (@pairs) { ($name, $value) = split(/=/, $pair); $value =~ tr/+/ /; $value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack(C,hex($1))/eg; $HW{$name} = $value; } $dbh = DBI-connect(DBI:mysql:newdb,usertest,password); This is my error message: Content-type: text/html install_driver(mysql) failed: Can't locate object method bootstrap via package IO::Handle at /usr/lib/perl5/site_perl/DBD/mysql.pm line 14. at ./sli.cgi line 21 I would appreciate any help anyone could offer. Thanks! Heather - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Can't login to MySQL from PHP
Hi Marco, The usual method is something along the lines of: --start-- $server = localhost; $username = your username; $password = your password; $database = your database name; $db_handler = mysql_connect($server, $username, $password) or die (mysql_error()); mysql_select_db ($database); ---end--- The die (mysql_error()) will echo the error message to the screen if the connection failed, which at least will let you know what went wrong (hopefully). You shouldn't have to enter the username and password anywhere else but here (it's generally a good idea to have the above code in a separate file, which you then include into any script that needs database connectivity). Armed with this information, you should be in a better position to sort it out, but give us a shout if it's still not happy. HTH Jon -Original Message- From: Marco Bleeker [mailto:[EMAIL PROTECTED]] Sent: 29 May 2001 16:25 To: [EMAIL PROTECTED] Subject: Can't login to MySQL from PHP Hello, I am a novice to Apache, MySQL and PHP. I have just installed these on my Win98SE machine, and want to do some off-line ('localhost') exercises before I go on the web. Apache and PHP work; I can run PHP scripts that do not access a database. But as soon as I try mysql_connect(), I get errors. I am sure it is something very basic I am missing. Perhaps it's a matter of username/password; I fooled around a bit with those, but to no effect (how are those verified? I suppose they have to be entered in 2 places?). Does anyone have a hint? Or can someone guide me through a procedure to track the problem? Which additional info do you need? ** 'The information included in this Email is of a confidential nature and is intended only for the addressee. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. Disclosure to any party other than the addressee, whether inadvertent or otherwise is not intended to waive privilege or confidentiality' ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Novice mySQL and PHP problem
When I do my query: mysql_query(SELECT * FROM users WHERE name='$sentname'); it always returns 0 elements. $sentname is comming from form input on a page that POST's to my current page. I have checked this value and it is what I expect, usually Scott for testing purposes. The first record in the table has name Scott, and I return that element if I replace the $sentname in the query with Scott. I'm fairly certain that this is a simple string management problem and has an easy fix, but I'm at wits end with this. Thanks for your time, Scott Spearman [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: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)
[client] port=3309 socket=/tmp/mysql.sock.shoja Now the problem is when I'm trying to run my cgi from command prompt there is no error and it connect successfully. But when I'm trying to run it through web browser I get this error message: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) and this is wondering because anyway my socket file is '/tmp/mysql.sock.shoja' It is looking for /tmp/mysql.sock and the one that exists is /tmp/mysql.sock.shoja Two different files.. It can't find what it is looking for. Try: safe_mysqld --socket=/tmp/mysql.sock and it should work I just had the same problem. thanks, shawn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)
Thanks for your reply The question is why in command line there is no problem? It is looking for /tmp/mysql.sock and the one that exists is /tmp/mysql.sock.shoja Two different files.. It can't find what it is looking for. Try: safe_mysqld --socket=/tmp/mysql.sock and it should work I just had the same problem. thanks, shawn -- Mohammadreza Shojatalab European Bioinformatics InstituteTel: +44 (0)1223 494 669 EMBL Outstation Fax: +44 (0)1223 494 468 Wellcome Trust Genome Campus E-Mail: [EMAIL PROTECTED] Hinxton, Cambridge URL: http://www.ebi.ac.uk/~shoja CB10 1SD, UK - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect to local MySQL server through socket '/tmp/mysql.sock'(2)
I don't know for sure... perhaps, the apache+php binary just treats it differently than when interacting with it directly from the shell... I am a newbie and I just had the same problem 2 minutes ago... hope it works out... thanks, shawn On Tue, 29 May 2001, Mohammad Shoja wrote: Thanks for your reply The question is why in command line there is no problem? It is looking for /tmp/mysql.sock and the one that exists is /tmp/mysql.sock.shoja Two different files.. It can't find what it is looking for. Try: safe_mysqld --socket=/tmp/mysql.sock and it should work I just had the same problem. thanks, shawn -- Mohammadreza Shojatalab European Bioinformatics InstituteTel: +44 (0)1223 494 669 EMBL Outstation Fax: +44 (0)1223 494 468 Wellcome Trust Genome Campus E-Mail: [EMAIL PROTECTED] Hinxton, Cambridge URL: http://www.ebi.ac.uk/~shoja CB10 1SD, UK - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 mySQL, definitive procedure wanted
Hi, If one installs a newer version of mysql over the top of a current version (in my case this will be done from the FreeBSD ports collection), will the current tables and data remain intact? If not OR if a worry, is there a single command using mysqldump to dump everything in one go, knowing that it will all go back intact? OR Shall I just copy the folders containing the data to a backup folder, install newer version, if the tables get wiped, then do a filecopy back to the correct folder (while mysql server is down)? M. -- Work:- postmasterAThinwick.demon.co.uk WEB:- http://www.hinwick.demon.co.uk Work:- mworsdallATshaftesburysoc.org.uk REPLACE AT with @ Home:- hinwickATworsdall.demon.co.ukWEB:- http://www.wizdom.org.uk Shadow:- webmasterATshadow.org.uk WEB:- http://www.shadow.org.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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
In message [EMAIL PROTECTED], Tonu Samuel [EMAIL PROTECTED] writes On 29 May 2001 09:28:04 +0200, Signe Hasseriis wrote: Please tell me how to select the 10 (or 5) newest records or posts from a MySql table. SELECT * FROM table ORDER BY posttime DESC LIMIT 5 is the column/field posttime put in by one self or is this a special built in function? M. -- Work:- postmasterAThinwick.demon.co.uk WEB:- http://www.hinwick.demon.co.uk Work:- mworsdallATshaftesburysoc.org.uk REPLACE AT with @ Home:- hinwickATworsdall.demon.co.ukWEB:- http://www.wizdom.org.uk Shadow:- webmasterATshadow.org.uk WEB:- http://www.shadow.org.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: install_driver(mysql) failed: Can't locate object method bootstrap via package
I'm still stuck... but Im making progress? This is the new problem: - Original Message - From: Heather Wagamon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 10:57 AM Subject: install_driver(mysql) failed: Can't locate object method bootstrap via package Hey everyone! I'm hoping someone can help me out with this... I'm trying to write a perl/cgi to connect to mysql. This is my code: #!/usr/bin/perl print Content-type: text/html\n\n; use DBI(); read(STDIN, $buffer, $ENV{'CONTENT_LENGTH'}); @pairs = split(//, $buffer); foreach $pair (@pairs) { ($name, $value) = split(/=/, $pair); $value =~ tr/+/ /; $value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack(C,hex($1))/eg; $HW{$name} = $value; } $dbh = DBI-connect(DBI:mysql:newdb,usertest,password); This is my error message: Content-type: text/html perl: error in loading shared libraries /usr/lib/perl5/site_perl/i386-linux/auto/DBD/mysql/mysql.so: undefined symbol: m ysql_init I would appreciate any help anyone could offer. Thanks! Heather - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Novice mySQL and PHP problem
-Original Message- From: Scott Spearman [mailto:[EMAIL PROTECTED]] Sent: 29. maj 2001 18:50 To: [EMAIL PROTECTED] Subject: Novice mySQL and PHP problem When I do my query: mysql_query(SELECT * FROM users WHERE name='$sentname'); it always returns 0 elements. $sentname is comming from form input on a page that POST's to my current page. I have checked this value and it is what I expect, usually Scott for testing purposes. The first record in the table has name Scott, and I return that element if I replace the $sentname in the query with Scott. I'm fairly certain that this is a simple string management problem and has an easy fix, but I'm at wits end with this. Thanks for your time, Scott Spearman [EMAIL PROTECTED] Hi Scott Have you tried to print out and verify the syntax of your SQL query: echo SELECT * FROM users WHERE name='$sentname'; What is being printed out? -- Regards Grosen Friis, Programmer -- The Stibo Group Søren Nymarks Vej 3 DK-8270 Højbjerg Aarhus, Denmark Phone +45 89 39 11 11 Direct +45 89 39 13 21 Fax +45 89 39 11 12 E-mail: [EMAIL PROTECTED] http://www.stibo.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: FoxPro6 and MySQL, odbc
Any specifics? Informative/interesting articles on your Nerd Herd web site, Cal ! Better fix INPUT TYPE=hidden NAME=item_name VALUE=ConsultaingAssistance I have the Que book, Special Edition, Using Visual FoxPro 6, but all it ever discusses is how *other* applications can access _FoxPro's_ database. I don't want to do that. I'm considering this really great program (that someone else designed) in FoxPro, but I don't want to use the FoxPro database (it's too Micro$oft-oriented... I don't trust it). Maybe FoxPro has since obtained some functionality for being able to access foreign databases. Other than SQL Server (or Access), that is. I like my databases to be located on Unix servers (the type that don't crash). Thanks, Charles Kirby [In a world without fences, who needs Gates?] Cal Evans [EMAIL PROTECTED] on 05/29/2001 10:08:36 AM To: Charles Kirby/Usdcsdny@2DC-NYS-Notes, [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject: Re: FoxPro6 and MySQL, odbc within VFP it is. Cal http://www.calevans.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 8:50 AM Subject: FoxPro6 and MySQL, odbc Hi, I see there are ways to have MySQL obtain data from a FoxPro database--using ODBC--which is very nice, I'm sure. However, is it possible to run a FoxPro program that gets data from a MySQL database?? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Restarting problem
I have mysql 3.23.32 installed in my system OpenBSD 2.8, worked fine for almost one year, but recently he is restarting frequently and crash after many restart and I need restart mysql myself. The following messagem is showed in error file: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. What's happening? Please help-me Rogerio Carlos Topan Download NeoPlanet at http://www.neoplanet.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: FoxPro6 and MySQL, odbc
Thank you! :) Go grab the ODBC driver for mysql. Install and create a DSN for your mysql database. Then go into VFP and open your DBC, add it as a connection. Now you can add updateable views of all your mysql tables into it and use them like you could any other remove view. NOTE: I've spent the last 2 months working with FP SQL server, using views like this is not like using FP tables. There are a LOT of problems. We got around most of them by either : 1: using SQL passthrough (sqlexec, etc) 2: Using ADO HTH, Cal http://www.calevans.com - Original Message - From: [EMAIL PROTECTED] To: Cal Evans [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 12:05 PM Subject: Re: FoxPro6 and MySQL, odbc Any specifics? Informative/interesting articles on your Nerd Herd web site, Cal ! Better fix INPUT TYPE=hidden NAME=item_name VALUE=ConsultaingAssistance I have the Que book, Special Edition, Using Visual FoxPro 6, but all it ever discusses is how *other* applications can access _FoxPro's_ database. I don't want to do that. I'm considering this really great program (that someone else designed) in FoxPro, but I don't want to use the FoxPro database (it's too Micro$oft-oriented... I don't trust it). Maybe FoxPro has since obtained some functionality for being able to access foreign databases. Other than SQL Server (or Access), that is. I like my databases to be located on Unix servers (the type that don't crash). Thanks, Charles Kirby [In a world without fences, who needs Gates?] Cal Evans [EMAIL PROTECTED] on 05/29/2001 10:08:36 AM To: Charles Kirby/Usdcsdny@2DC-NYS-Notes, [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject: Re: FoxPro6 and MySQL, odbc within VFP it is. Cal http://www.calevans.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 8:50 AM Subject: FoxPro6 and MySQL, odbc Hi, I see there are ways to have MySQL obtain data from a FoxPro database--using ODBC--which is very nice, I'm sure. However, is it possible to run a FoxPro program that gets data from a MySQL database?? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
VBA/VB DAO/ADO MS Access to MySQL?
Howdy, I currently have an application which uses DAO and ADO coding in VBA/VB as well as databound objects in VB to access a MS Access database. Can DAO and ADO in VBA/VB and databound objects in VB be made to work with a MySQL database? Anybody done this successfully? Cheers, Mike
Does a mysql preprocessor exist for SQL embedded in C/C++ code?
Or is anyone working on this? Also, how about stored procedures? Does mysql support stored procedures? Thanks.
Re: VBA/VB DAO/ADO MS Access to MySQL?
Yes it can, via ODBC. I've never done it though. (I don't work in VB) Cal - Original Message - From: Thompson, Mike [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 12:37 PM Subject: VBA/VB DAO/ADO MS Access to MySQL? Howdy, I currently have an application which uses DAO and ADO coding in VBA/VB as well as databound objects in VB to access a MS Access database. Can DAO and ADO in VBA/VB and databound objects in VB be made to work with a MySQL database? Anybody done this successfully? Cheers, 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: FoxPro6 and MySQL, odbc
Ah, yes, I remember seeing some of this COM or ADO stuff in the Que book, plus the SQL passthrough stuff. I remember putting the book to one side for some reason, and that reason follows: It looked to me as if you certainly *could* manage to *read* data from another machine, but (tell me if I'm right) it looks as if there's no way to UPDATE or INSERT data into the remote database. Of course, it already looks pretty involved, especially if you don't just go Micro$oft's way and use the SQL Server. CK Cal Evans [EMAIL PROTECTED] on 05/29/2001 01:18:08 PM To: Charles Kirby/Usdcsdny@2DC-NYS-Notes, [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject: Re: FoxPro6 and MySQL, odbc Thank you! :) Go grab the ODBC driver for mysql. Install and create a DSN for your mysql database. Then go into VFP and open your DBC, add it as a connection. Now you can add updateable views of all your mysql tables into it and use them like you could any other remove view. NOTE: I've spent the last 2 months working with FP SQL server, using views like this is not like using FP tables. There are a LOT of problems. We got around most of them by either : 1: using SQL passthrough (sqlexec, etc) 2: Using ADO HTH, Cal http://www.calevans.com - Original Message - From: [EMAIL PROTECTED] To: Cal Evans [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 12:05 PM Subject: Re: FoxPro6 and MySQL, odbc Any specifics? Informative/interesting articles on your Nerd Herd web site, Cal ! Better fix INPUT TYPE=hidden NAME=item_name VALUE=ConsultaingAssistance I have the Que book, Special Edition, Using Visual FoxPro 6, but all it ever discusses is how *other* applications can access _FoxPro's_ database. I don't want to do that. I'm considering this really great program (that someone else designed) in FoxPro, but I don't want to use the FoxPro database (it's too Micro$oft-oriented... I don't trust it). Maybe FoxPro has since obtained some functionality for being able to access foreign databases. Other than SQL Server (or Access), that is. I like my databases to be located on Unix servers (the type that don't crash). Thanks, Charles Kirby [In a world without fences, who needs Gates?] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FoxPro6 and MySQL, odbc
No, you can read and write the data. The problems arise when old fox-jockey's like myself try to treat the remote views exactly like dbfs. No can do. When creating your remote views make sure you go to the update panel and tell it you want to actually send the sql updates. (You have to specify a primary key for the checkbox to become available) In short, on the project I'm working on right now we adopted the following conventions: 1) If we have a screen that is editing a single record (like a customer record) we create a customer object that used ADO to read and write to the ODBC connection. (We've actually got a cool little object generator that writes the code for us!) 2) If we need a cursor for a grid, we use SQL Passthrough. it is possible to use ADO and another fll that can be found on the MS website to convert an ADO recordset to a VFP cursor so you can attach a grid to it but I chose not to do that. 3) If it's a small table (less than 200 records) then we left the existing FP code in but removed any code that won't work with views. (indexes, relations, locks, etc.) I didn't mention but we are converting a 2.6 app to VFP w/ SQL. So there is a ton of legacy code. You probably won't have to deal with that. The bottom line is if you are careful, you can do it without a problem. But it's not 'just like' writing FP code. HTH, Cal http://www.calevans.com - Original Message - From: [EMAIL PROTECTED] To: Cal Evans [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:21 PM Subject: Re: FoxPro6 and MySQL, odbc Ah, yes, I remember seeing some of this COM or ADO stuff in the Que book, plus the SQL passthrough stuff. I remember putting the book to one side for some reason, and that reason follows: It looked to me as if you certainly *could* manage to *read* data from another machine, but (tell me if I'm right) it looks as if there's no way to UPDATE or INSERT data into the remote database. Of course, it already looks pretty involved, especially if you don't just go Micro$oft's way and use the SQL Server. CK Cal Evans [EMAIL PROTECTED] on 05/29/2001 01:18:08 PM To: Charles Kirby/Usdcsdny@2DC-NYS-Notes, [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject: Re: FoxPro6 and MySQL, odbc Thank you! :) Go grab the ODBC driver for mysql. Install and create a DSN for your mysql database. Then go into VFP and open your DBC, add it as a connection. Now you can add updateable views of all your mysql tables into it and use them like you could any other remove view. NOTE: I've spent the last 2 months working with FP SQL server, using views like this is not like using FP tables. There are a LOT of problems. We got around most of them by either : 1: using SQL passthrough (sqlexec, etc) 2: Using ADO HTH, Cal http://www.calevans.com - Original Message - From: [EMAIL PROTECTED] To: Cal Evans [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 12:05 PM Subject: Re: FoxPro6 and MySQL, odbc Any specifics? Informative/interesting articles on your Nerd Herd web site, Cal ! Better fix INPUT TYPE=hidden NAME=item_name VALUE=ConsultaingAssistance I have the Que book, Special Edition, Using Visual FoxPro 6, but all it ever discusses is how *other* applications can access _FoxPro's_ database. I don't want to do that. I'm considering this really great program (that someone else designed) in FoxPro, but I don't want to use the FoxPro database (it's too Micro$oft-oriented... I don't trust it). Maybe FoxPro has since obtained some functionality for being able to access foreign databases. Other than SQL Server (or Access), that is. I like my databases to be located on Unix servers (the type that don't crash). Thanks, Charles Kirby [In a world without fences, who needs Gates?] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: VBA/VB DAO/ADO MS Access to MySQL?
I've done it by installing the MyODBC driver on NT4.0 WS running VB6sp2, and connecting to a RHLinux6.2 box running MySQL vs .36 - I've only done it w/ ADO over the ODBC layer, and it seems to work fine, however I am using disconnected recordsets and have not attempted binding a control to the backend... Good Luck. ChrisB MCSE MCDBA -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 11:14 AM To: Thompson, Mike; [EMAIL PROTECTED] Subject: Re: VBA/VB DAO/ADO MS Access to MySQL? Yes it can, via ODBC. I've never done it though. (I don't work in VB) Cal - Original Message - From: Thompson, Mike [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 12:37 PM Subject: VBA/VB DAO/ADO MS Access to MySQL? Howdy, I currently have an application which uses DAO and ADO coding in VBA/VB as well as databound objects in VB to access a MS Access database. Can DAO and ADO in VBA/VB and databound objects in VB be made to work with a MySQL database? Anybody done this successfully? Cheers, 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
Re: mysqldump all dbs
From 'man mysqldump' mysqldump [OPTIONS] --all-databases [OPTIONS] Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Original Message - From: Marco Kammerer [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:18 PM Subject: mysqldump all dbs Hello on http://www.mysql.com/articles/mysql_intro.html#SECTION000100 there is the text ... The function mysqldump can be used to backup !! all !! databases, several databases, one database, or just certain tables within a given database. In this section, the syntax involved with each scenario is provided, followed with a few examples. Using mysqldump to backup just one ... I always used mysqldump to dump db by db, how can i get it to dump all? i was not able to figure it out thanks marco - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Explanations about the start up of MySQL 3.23.38 on Windows
Hi! We have noticed some mails posted by Windows users having problem in the first start of mysqld.exe on Windows platforms. Then, below the explanations how to avoid the problems reported: 1- According with our MySQL-Max download page is noticed that the regular distribution 3.23.38, contains the MySQL-Max stuff. The MySQL-Max stuff has additional features: - Support for transactions with two types of tables: InnoDB and BDB. - Support for symbolic links to have databases on another place than the default one. - The servers which have the MySQL-Max support are: mysqld.exe mysqld-max.exe mysqld-max-nt.exe 2- When the MySQL-Max servers are started, the InnoBD routines tries to found the paths for its data and log files. When aren't specified that data on the \my.cnf or \WindDir\my.ini file, the server launches the following warning message: Can't initialize InnoDB as 'innodb_data_file_path' is not set The above means that the InnoDB tables are disabled, however the server is ready for the others tables. C:\mysql\binmysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.38-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql show variables like have_innodb; +---+--+ | Variable_name | Value| +---+--+ | have_innodb | DISABLED | +---+--+ 1 row in set (0.05 sec) If you don't want the InnoDB tables support and to avoid the above warning message, you could create the \my.cnf or \WindDir\my.ini file and add the below variable: [mysqld] skip-innodb Otherwise if you want the InnoDB tables support, you need to read in our Manual how to prepare the configuration file. Below the preliminaries instructions: - Create the log and data directories, for example: c:\ibdata and c:\iblogs. - Create the configuration file and edit the variables according with the Manual instructions. Notice that the sizes of the files can't exceed 2000M. - Start the server and you will see, the messages that InnoDB are creating the files: C:\mysql\binmysqld-max --standalone InnoDB: The first specified data file c:\ibdata\ibdata1 did not exist: InnoDB: a new database to be created! InnoDB: Setting file c:\ibdata\ibdata1 size to 26214400 InnoDB: Database physically writes the file full: wait... InnoDB: Data file c:\ibdata\ibdata2 did not exist: new to be created InnoDB: Setting file c:\ibdata\ibdata2 size to 38797312 InnoDB: Database physically writes the file full: wait... InnoDB: Data file c:\ibdata\ibdata3 did not exist: new to be created InnoDB: Setting file c:\ibdata\ibdata3 size to 104857600 InnoDB: Database physically writes the file full: wait... InnoDB: Data file c:\ibdata\ibdata4 did not exist: new to be created InnoDB: Setting file c:\ibdata\ibdata4 size to 314572800 InnoDB: Database physically writes the file full: wait... InnoDB: Log file c:\iblogs\ib_logfile0 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile0 size to 5242880 InnoDB: Log file c:\iblogs\ib_logfile1 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile1 size to 5242880 InnoDB: Log file c:\iblogs\ib_logfile2 did not exist: new to be created InnoDB: Setting log file c:\iblogs\ib_logfile2 size to 5242880 InnoDB: Started Notice that you can to start the server as service on WinNT and Win2k OSs. The server should be used is the mysqld-max-nt.exe 3- The mysqld.exe on Win9x How mentioned above, this server has the Max stuff, however on the 3.23.38 distribution was compiled with the InnoDB library with a pre-processor define option for NT platform, which cause a handle exception when tries to create the data and log files. If you want to use InnoDB tables on Win9x, use instead the mysqld-max.exe server. Also this server doesn't has the symbolic link support. Those problem already are fixed and in the next release, the mysqld.exe should be able to run on Win9x with the InnoDB and symbolic link supports. 4- Using Symbolic Links To use this support we explains it with a sample: Do you want a database called mylink on the d:\mydata directory. First create on \mysql\data directory a file called mylink.sym. Edit this file with the text: d:\mydata\mylink\ Notice the trailing backlash in the end of the path. This is important only in the 3.23.38 distribution. In the next MySQL release will added code to handle a path like: d:\mydata\mylink Create the directory d:\mydata\mylink Add to configuration file the variable use-symbolic-links. If you aren't starting the server as service you should use the
URGENT !! Hanging query
PLEASE if anyone can help!! We are past deadline Object: Retrieve rows from table D. GIVEN: 1. MySQL ver 3.23.33 (but must run on 3.22.25!) 2. Table D is connected to tables E,F,K through tables dE,dF,dK. 3. Table D is connected to table L through tables dK then Lk. D - dE - E D - dF - F D - dK - K D - dK - Lk - L 4. All query WHERE clauses use string fields (VAR or VARCHAR) in E, F, K, L 5. Each table E,F,K,L has less than 1000 rows. 6. Each string field is indexed 7. Each joiner field is indexed NEED: 1. WHERE clause which checks exact matches for E,F and L tables and substring match for words in K. 2. Multiple words to limit results to intersection of returns 3. Ordered by number of rows in dE,dF, then dK (both L and K) 4. List only unique rows in D I have tryed several things to create various queries in PHP, some which are as large as 2500 characters! The only thing that I can think of now is Does each AND section of the WHERE clause have to have ALL unique table aliases? (down to the last common one?) 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
Re: VBA/VB DAO/ADO MS Access to MySQL?
This works fine from VB6. Install the MyODBC driver (get it from the MySQL web site), then set up a datasource just as you usually would. Ideally, you won't have to change any of your VB code - just bind the ADO/DAO controls to the MySQL datasource rather than the Access datasource. Note that depending on your application, you may have to select different options in the MyODBC datasource configuration. On my box (Win2k SP2, MySQL 3.23.36) I got some irritating runtime errors with ADO controls until I checked Return Matching Rows and Change BIGINT Columns To INT. Ben On Tuesday, May 29, 2001, at 12:37 PM, Thompson, Mike wrote: Howdy, I currently have an application which uses DAO and ADO coding in VBA/VB as well as databound objects in VB to access a MS Access database. Can DAO and ADO in VBA/VB and databound objects in VB be made to work with a MySQL database? Anybody done this successfully? Cheers, 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
Which version of MYSQL to use?
Hi, Can any one please tell me which version of MYSQL to use if my uname -a command gives the following output: SunOS ny-dmdbld02 5.6 Generic_105181-23 sun4u sparc SUNW,Ultra-2 Thanks Giri __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FoxPro6 and MySQL, odbc
Excellent! This looks like it should work. Another useful reference is http://lists.mysql.com/cgi-ez/ezmlm-cgi?5:mss:2861:200102:nofjdmbdkfaebemidbgl From: Christopher R. Jones Date: Wed, 21 Feb 2001 16:00:33 -0500 I have it working. Here is what I did: I. MyODBC Create a System DSN, check the following: Don't optimize column width Return Matching Rows Safety II. Foxpro Create a Remote View, I used the Wizard. Once the view is created, you need to modify its properties. I am using VFP6. In the view properties screen, go to Update Criteria. Make sure that all fields are checked for update (the column under the little pencil is the update column). Check Send SQL Updates Check Delete then Insert. Thanks. It'll take a while to set up what I have already, but I'm optimistic this advice will do the trick (Cal Evans' stuff, plus Christopher Jones') Charles Kirby Cal Evans [EMAIL PROTECTED] on 05/29/2001 02:36:10 PM To: Charles Kirby/Usdcsdny@2DC-NYS-Notes, [EMAIL PROTECTED], [EMAIL PROTECTED] cc: Subject: Re: FoxPro6 and MySQL, odbc No, you can read and write the data. The problems arise when old fox-jockey's like myself try to treat the remote views exactly like dbfs. No can do. When creating your remote views make sure you go to the update panel and tell it you want to actually send the sql updates. (You have to specify a primary key for the checkbox to become available) In short, on the project I'm working on right now we adopted the following conventions: 1) If we have a screen that is editing a single record (like a customer record) we create a customer object that used ADO to read and write to the ODBC connection. (We've actually got a cool little object generator that writes the code for us!) 2) If we need a cursor for a grid, we use SQL Passthrough. it is possible to use ADO and another fll that can be found on the MS website to convert an ADO recordset to a VFP cursor so you can attach a grid to it but I chose not to do that. 3) If it's a small table (less than 200 records) then we left the existing FP code in but removed any code that won't work with views. (indexes, relations, locks, etc.) I didn't mention but we are converting a 2.6 app to VFP w/ SQL. So there is a ton of legacy code. You probably won't have to deal with that. The bottom line is if you are careful, you can do it without a problem. But it's not 'just like' writing FP code. HTH, Cal http://www.calevans.com - Original Message - From: [EMAIL PROTECTED] To: Cal Evans [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:21 PM Subject: Re: FoxPro6 and MySQL, odbc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqldump all dbs
I prefer dumping things one database at a time so I can more easily recover them. See script below, run from the mysqlback directory which is at the same level as the directory containing the directories of all of the files. Sincerely, William Mussatto, Senior Systems Engineer CyberStrategies, Inc ph. 909-920-9154 ext. 27 #!/bin/sh date cd ../mysql for d in * do mysqldump -u root --password=ROOTPASSWORD --add-drop-table -l $d ../mysqlback/$d.dmp done date - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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] DATE_FORMAT
Hi, I've setup a database to keep track of various events. Now I'm working on displaying these events on the screen through a web browser. I've got all the crucial information displaying - now its time for a little fine tuning. All the dates in my database are ISO format, so -MM-DD, I'd like to display them in a more user friendly format. For example, there is an event taking place this Wednesday, in ISO 2001-05-30 - I'd like it to display as May 30th, 2001. Through the command line, I know I do this by typing: select DATE_FORMAT(EventStartDate, '%M %D %Y'); My question is how would i get this information to display via 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
database basics
Hi, was wondering as am starting a database with just some 5000 different ID entries and each entry having some 60 datafields, which would work best/faster a single table of the data or divided into separate tables? Jari Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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] DATE_FORMAT
Hi Tim! You could do something like this: $sqlstr = select date_format(EventStartDate, '%M %D %Y') as mydate, (rest of your SQL string here) ; $result = mysql(mydb, $sqlstr, $connect) ; $myformatteddate = mysql_result($result, 0, 'mydate') ; This should do it for you :) HTH --Sam On Tue, 29 May 2001 14:39:51 -0500 Tim Thorburn [EMAIL PROTECTED] wrote: Hi, I've setup a database to keep track of various events. Now I'm working on displaying these events on the screen through a web browser. I've got all the crucial information displaying - now its time for a little fine tuning. All the dates in my database are ISO format, so -MM-DD, I'd like to display them in a more user friendly format. For example, there is an event taking place this Wednesday, in ISO 2001-05-30 - I'd like it to display as May 30th, 2001. Through the command line, I know I do this by typing: select DATE_FORMAT(EventStartDate, '%M %D %Y'); My question is how would i get this information to display via 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] DATE_FORMAT
$Result = @mysql_query (SELECT DATE_FORMAT(EventStartDate,'%M %D %Y') AS EventStartDate FROM EventsTable); $Row = mysql_fetch_array($Result); printf(Event Date:%s, %Row['EventStartDate']; Hope this helps :o) --Patrick # -Original Message- # From: Tim Thorburn [mailto:[EMAIL PROTECTED]] # Sent: Tuesday, May 29, 2001 12:40 PM # To: [EMAIL PROTECTED] # Subject: [MySQL] DATE_FORMAT # # # Hi, # # I've setup a database to keep track of various events. Now # I'm working on # displaying these events on the screen through a web browser. # I've got all # the crucial information displaying - now its time for a # little fine tuning. # # All the dates in my database are ISO format, so -MM-DD, # I'd like to # display them in a more user friendly format. For example, # there is an # event taking place this Wednesday, in ISO 2001-05-30 - I'd like it to # display as May 30th, 2001. # # Through the command line, I know I do this by typing: # select DATE_FORMAT(EventStartDate, '%M %D %Y'); # # My question is how would i get this information to display via 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] DATE_FORMAT
At 2:39 PM -0500 5/29/01, Tim Thorburn wrote: Hi, I've setup a database to keep track of various events. Now I'm working on displaying these events on the screen through a web browser. I've got all the crucial information displaying - now its time for a little fine tuning. All the dates in my database are ISO format, so -MM-DD, I'd like to display them in a more user friendly format. For example, there is an event taking place this Wednesday, in ISO 2001-05-30 - I'd like it to display as May 30th, 2001. Through the command line, I know I do this by typing: select DATE_FORMAT(EventStartDate, '%M %D %Y'); My question is how would i get this information to display via PHP? The same way. Issue a query that uses DATE_FORMAT() rather than selecting the date in its native format. -- Paul DuBois, [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: DBD and locking
What if the queries were updates instead of inserts? Would I need or be able to lock the tables then? Can I go without locking the bdb tables and not worry about the data integrity on those tables during updates and inserts? -Seth Hall Student Programmer Ohio State University Main Library On 24 May 2001 16:54:42 -0700, Jeremy Zawodny wrote: On Thu, May 17, 2001 at 12:35:09PM -0400, Seth Hall wrote: Hi, could someone point me to a tutorial on when to do table locking with the BDB tables in MySQL? Why? I'm running version 3.23.37 on RH7.0 (with BDB tables :) and if I attempt to do locking within a transaction, the transaction is automatically committed leaving me with non-working transaction code. So, what I'm wondering is do I even need to lock the tables(I'm doing inserts and updates)? If I do, have there been any bugs with locking inside transactions? BTW, if I don't do the table write locking the code works fine. this works begin work; insert into Table (field1, field2) VALUES (2,'hi'); rollback; this doesn'tit's committed anyway begin work; lock tables Table write; insert into Table (field1, field2) VALUES (2,'hi'); unlock tables; rollback; Why is the lock necessary at all? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 5 days, processed 35,049,645 queries (79/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: URGENT !! Hanging query
Bruce, Thanks for your reply! 1- Yes I've tested using MySQL GUI 1.7.4 with the same results 2 - Don't know, will have to find out 3 - I'll find and check that too Paul, Have you tried the SQL from mysql to see wht it does outside of PHP? IS the MySQL server configured to log all queries? What do the logs say is being sent to the server? These are the places I start from. Bruce Ferrell PLEASE if anyone can help!! We are past deadline Object: Retrieve rows from table D. GIVEN: 1. MySQL ver 3.23.33 (but must run on 3.22.25!) 2. Table D is connected to tables E,F,K through tables dE,dF,dK. 3. Table D is connected to table L through tables dK then Lk. D - dE - E D - dF - F D - dK - K D - dK - Lk - L 4. All query WHERE clauses use string fields (VAR or VARCHAR) in E, F, K, L 5. Each table E,F,K,L has less than 1000 rows. 6. Each string field is indexed 7. Each joiner field is indexed NEED: 1. WHERE clause which checks exact matches for E,F and L tables and substring match for words in K. 2. Multiple words to limit results to intersection of returns 3. Ordered by number of rows in dE,dF, then dK (both L and K) 4. List only unique rows in D I have tryed several things to create various queries in PHP, some which are as large as 2500 characters! The only thing that I can think of now is Does each AND section of the WHERE clause have to have ALL unique table aliases? (down to the last common one?) Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Any suggestions on a front end for MySQL database?
I currently have Access97 as a front end of MySQL database. Would any of you be able to suggest me any other easy front end for the database. Employees in my company are very slow to learn, so something like Access would be good to find. The reason I am asking is, because every damn time I get new work stations I have to add new licenses that are impossible to come by (by the way, if you know where I can get a pack of 5 MS Office 97 Pro licenses for less, let me know). Apollo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
what's the command to list all the tables in the DB
Previously, I used SELECT table_name FROM tabs to get all the table names, but now, I logged into a new box using SQLPlus, but there is no record in the tabs table. So, how can I get the table names in that database (Oracle)? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Novice mySQL and PHP problem
hi. this is a php question, and is offtopic for this list... ...but values in single quotes are sent without parsing to mysql from php. use double quotes instead. -ravi. -Original Message- From: Grosen Friis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 29, 2001 1:07 PM To: 'Scott Spearman'; '[EMAIL PROTECTED]' Subject: RE: Novice mySQL and PHP problem -Original Message- From: Scott Spearman [mailto:[EMAIL PROTECTED]] Sent: 29. maj 2001 18:50 To: [EMAIL PROTECTED] Subject: Novice mySQL and PHP problem When I do my query: mysql_query(SELECT * FROM users WHERE name='$sentname'); it always returns 0 elements. $sentname is comming from form input on a page that POST's to my current page. I have checked this value and it is what I expect, usually Scott for testing purposes. The first record in the table has name Scott, and I return that element if I replace the $sentname in the query with Scott. I'm fairly certain that this is a simple string management problem and has an easy fix, but I'm at wits end with this. Thanks for your time, Scott Spearman [EMAIL PROTECTED] Hi Scott Have you tried to print out and verify the syntax of your SQL query: echo SELECT * FROM users WHERE name='$sentname'; What is being printed out? -- Regards Grosen Friis, Programmer -- The Stibo Group Søren Nymarks Vej 3 DK-8270 Højbjerg Aarhus, Denmark Phone +45 89 39 11 11 Direct +45 89 39 13 21 Fax +45 89 39 11 12 E-mail: [EMAIL PROTECTED] http://www.stibo.com -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Any suggestions on a front end for MySQL database?
Have a look at urSQL from http://www.urbanresearch.com/ursql. On Tue, 29 May 2001, Apolinaras Apollo Sinkevicius wrote: I currently have Access97 as a front end of MySQL database. Would any of you be able to suggest me any other easy front end for the database. Employees in my company are very slow to learn, so something like Access would be good to find. The reason I am asking is, because every damn time I get new work stations I have to add new licenses that are impossible to come by (by the way, if you know where I can get a pack of 5 MS Office 97 Pro licenses for less, let me know). Apollo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: database basics
You should split the data-fields into tables containing 'categories' of fields. * 'textual' (or informational) fields would be the main 'item' table * 'quantity' and other 'numeric' fields that are updated frequently (i.e. quantity sold, quantity on-hand) would be in the table that would be 'locked' most frequently. * fields that may be 'one to many' (i.e. 'alternate' item number(s) ) would be in their own tables All of the tables would be 'keyed' on the item number. Splitting them would reduce 'lock contention' (if someone has 'locked' the quantity table to update the 'on-hand' amounts, you won't be stopped from looking up item information from the 'textual' table), and reduce the amount of space used per item (the 'alternate item number' table would only grow for items that HAD alternate numbers). Jari Mäkelä wrote: Hi, was wondering as am starting a database with just some 5000 different ID entries and each entry having some 60 datafields, which would work best/faster a single table of the data or divided into separate tables? Jari Mäkelä
Problem in compiling Mysql source 3.23.38
Description: When I tried to compile mysql source with make, I have the following errors : make[2]: Entre dans le répertoire `/installation/install/MySql/Tarball/source/mysql-3.23.38/client' /bin/sh ../libtool --mode=link c++ -O3 -DDBUG_OFF -fno-implicit-templates -rdynamic -o mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a -ltermcap ../libmysql/libmysqlclient.la -lz -lcrypt -lnsl -lm c++ -O3 -DDBUG_OFF -fno-implicit-templates -rdynamic -o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../readline/libreadline.a -ltermcap ../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt -lnsl -lm -Wl,--rpath -Wl,/usr/local/lib/mysql /usr/bin/ld: cannot find -ltermcap collect2: ld returned 1 exit status make[2]: *** [mysql] Erreur 1 make[2]: Quitte le répertoire `/installation/install/MySql/Tarball/source/mysql-3.23.38/client' make[1]: *** [all-recursive] Erreur 1 make[1]: Quitte le répertoire `/installation/install/MySql/Tarball/source/mysql-3.23.38' make: *** [all-recursive-am] Erreur 2 Something to deal with -ltermcap that I don't understand. I used to compile the same realease of MySql on Linux Mandrake 7.2. Now I have installed Mandrake 8.0. Thanks in advance for your response. Best regards. Hugues Malherbe (FROM FRANCE) [EMAIL PROTECTED] Originator: root MySQL support: none Synopsis: compiling Mysql Severity: non-critical Priority: low Category: mysql Class: support Release:mysql-3.23.38 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux localhost.localdomain 2.4.3-20mdk #1 Sun Apr 15 23:03:10 CEST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.96/specs gcc version 2.96 2731 (Linux-Mandrake 8.0 2.96-0.48mdk) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 mai 28 09:06 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1216268 fév 21 05:38 /lib/libc-2.2.2.so -rw-r--r--1 root root 26366908 fév 21 05:31 /usr/lib/libc.a -rw-r--r--1 root root 178 fév 21 05:31 /usr/lib/libc.so Configure command: ./configure - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: VBA/VB DAO/ADO MS Access to MySQL?
I'll add my two cents along with what everyone else has said because I have worked with all three. In short, MySQL works best when you are strictly using ADO and not DAO. On top of that, it's fast becoming (if it's not already) an ADO world! So, in the long run you might be better off converting everything to ADO. As for the databound objects, the answer is: it depends. Some of the databound objects will work fine, others will produce some of the weirdest and non-sensical errors you have ever seen :-). I have worked mostly with the datagrid bound object and found that it was best to ditch it in favor of re-writing all of the code in ADO. As someone else already stated, the less complex the application, the better than VB and MySQL will work together. Otherwise, proceed with caution and get yourself a good ADO reference. Good Luck, Dennis ** Beridney Computer Services http://www.beridney.com - Original Message - From: Thompson, Mike [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 10:37 AM Subject: VBA/VB DAO/ADO MS Access to MySQL? Howdy, I currently have an application which uses DAO and ADO coding in VBA/VB as well as databound objects in VB to access a MS Access database. Can DAO and ADO in VBA/VB and databound objects in VB be made to work with a MySQL database? Anybody done this successfully? Cheers, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Updating non-existant records...
Hello all. I'm new to the list, and I just have a quick question. Hopefully somebody can help me out. Anyway, here's the basics of what I want to do: I want to update a record or, if that record does not exist, create a new one. Now I could easily do this on the client side in another language, but it would require a query or two to the MySQL server as a test. This update is something that will be done very frequently, and I would like to limit the number of queries if at all possible -- I'd rather have the SQL server do the test. So... is there any way to do it in MySQL? Thanks to any replies, Randolpho - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Updating non-existant records...
Randolpho St John wrote: Hello all. I'm new to the list, and I just have a quick question. Hopefully somebody can help me out. Anyway, here's the basics of what I want to do: I want to update a record or, if that record does not exist, create a new one. Try the REPLACE... query. Look in the manual. Its quite handy to use replace. =) //Eric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: URGENT !! Hanging query
Please send me the actual physical query that was locking things up. This sounds like a simple join, include table/key structures in your response. More than likely you aren't joining somewhere nicely, and if you don't, you end up with really really large result sets. - Original Message - From: Paul Wilkinson [EMAIL PROTECTED] To: Help MySQL List [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 1:08 PM Subject: URGENT !! Hanging query PLEASE if anyone can help!! We are past deadline Object: Retrieve rows from table D. GIVEN: 1. MySQL ver 3.23.33 (but must run on 3.22.25!) 2. Table D is connected to tables E,F,K through tables dE,dF,dK. 3. Table D is connected to table L through tables dK then Lk. D - dE - E D - dF - F D - dK - K D - dK - Lk - L 4. All query WHERE clauses use string fields (VAR or VARCHAR) in E, F, K, L 5. Each table E,F,K,L has less than 1000 rows. 6. Each string field is indexed 7. Each joiner field is indexed NEED: 1. WHERE clause which checks exact matches for E,F and L tables and substring match for words in K. 2. Multiple words to limit results to intersection of returns 3. Ordered by number of rows in dE,dF, then dK (both L and K) 4. List only unique rows in D I have tryed several things to create various queries in PHP, some which are as large as 2500 characters! The only thing that I can think of now is Does each AND section of the WHERE clause have to have ALL unique table aliases? (down to the last common one?) Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: database basics
Oh, and response time should be 'faster', since you can locate the different tables on separate storage devices, allowing for concurrent drive access to the different parts of the item. Steve Brazill wrote: You should split the data-fields into tables containing 'categories' of fields. * 'textual' (or informational) fields would be the main 'item' table * 'quantity' and other 'numeric' fields that are updated frequently (i.e. quantity sold, quantity on-hand) would be in the table that would be 'locked' most frequently. * fields that may be 'one to many' (i.e. 'alternate' item number(s) ) would be in their own tables All of the tables would be 'keyed' on the item number. Splitting them would reduce 'lock contention' (if someone has 'locked' the quantity table to update the 'on-hand' amounts, you won't be stopped from looking up item information from the 'textual' table), and reduce the amount of space used per item (the 'alternate item number' table would only grow for items that HAD alternate numbers). Jari Mäkelä wrote: Hi, was wondering as am starting a database with just some 5000 different ID entries and each entry having some 60 datafields, which would work best/faster a single table of the data or divided into separate tables? Jari Mäkelä - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlhotcopy question
I am using mysqlhotcopy from within a cron job to make a backup copy of my database each night. Once I have run mysqlhotcopy and made the backup directory in my /usr/local/mysql/data directory, I'm able to do select statements on the data in the backups, but the mysqlshow command does not show any tables like it would on the regular database. I get the following: bash mysqlshow -pXX ontario_bkup_may29 Wildcard: ontario_bkup_may29 ++ | Databases | ++ | ontario_bkup_may29 | ++ Normally, I would get this: # mysqlshow -pXX ontario Database: ontario +-+ | Tables| +-+ | account | | account_deleted | | bank| | basicwebsite| | billing | | circuit | etc. (many more tables.) Any ideas as to why this happens? Is there something wrong? Griff Hamlin, III Quik International. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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++ for Visual Basic
Actually you dont't need a ocx. You can call the MySQL API functions, which are in a dll file. Robert Do you have any examples of that with VB? D'Arcy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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, UniData and ODBC question
I've never heard of UniData or Tru64 but if they are unix based, I have heard of a MyODBC for unix systems. Don't know much about it as most of my ODBC experience has been on Windoze platforms. - Original Message - From: Allen Belk [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 21:24 Subject: MySQL, UniData and ODBC question MySQL users, Our department is in the midst of reengineering the way data on our email server (MySQL on Linux) is kept in sync with the data on our administrative server (UniData on Tru64). I am not familiar with ODBC connectivity but from what I have heard and read, it might be our only hope of getting UniData and MySQL to communicate, even if on the most basic level. We have ODBC connectivity to UniData as well as our MySQL database but we need to figure out how to get UniData to access MySQL or vice versa. I was hoping to find a Perl DBI module for UniData but that search has turned up nothing. Any suggestions, comments or small nuggets of wisdom would be GREATLY appreciated. Thanks, Allen Belk | Allen Belk, Systems Administrator | Office of Information Technology | Saint Leo University, Saint Leo, FL | [EMAIL PROTECTED] - (352) 588-8592 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Can't change password in MySQL Windows version
It's a little difficult solving your problem as you have not provided as with samples of the commands you used, but 1. Check that the user exists in the first place. and 2. Did you use GRANT to set up a user in the first place? Not just insert a user into the tables. - Original Message - From: Ardianto Rustandi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 23:32 Subject: Can't change password in MySQL Windows version Hello all! Can anyone help me why I cannot change a user's password in the Windows version of MySQL (except for the root account)? I keep getting the ERROR 1133: Can't find any matching row in the user table error message everytime I try to change a user's password, both from mysqladmin and from SET PASSWORD command. FYI I'm using version 3.23.28-gamma running on Win98. Thanx in advance! Ardianto Rustandi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: what's the command to list all the tables in the DB
Firstly, you are way off topic. This is a MySQL list, not an Oracle list. Secondly, any good book on SQL in general will tell you how. - Original Message - From: Zhu George-CZZ010 [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 4:48 Subject: what's the command to list all the tables in the DB Previously, I used SELECT table_name FROM tabs to get all the table names, but now, I logged into a new box using SQLPlus, but there is no record in the tabs table. So, how can I get the table names in that database (Oracle)? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Binary
At 9:16 AM +0200 5/29/01, David Lidström wrote: Is there some kind of pattern in fields containing binary data - so you can be sure that is really IS binary!? I.e. if I in my database have a BLOB-field and sometimes write a string, and sometimes a file?! Given that a file can contain ordinary string data, it's difficult to know how to answer your question. What's your definition of binary data? One way to solve this would be to add another column to the table that you set to explicitly indicate what kind of information is in your BLOB column. Then you wouldn't have to guess. Regards David -- Paul DuBois, [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
Can't connect mysql in Turbolinux workstation.Err 1130.
Hi,I meet a problem.I install mysql in Turbolinux workstation 6.1,it works seem ok.But when I connect it in another computer(using mysql client,odbc ect.),Err occured seem the host '' not allow connect mysql How can I do? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Can't connect mysql in Turbolinux workstation.Err 1130.
At 9:50 AM +0800 5/30/01, zhenlei wrote: ?Hi,I meet a problem.I install mysql in Turbolinux workstation 6.1,it works seem ok.But when I connect it in another computer(using mysql client,odbc ect.),Err occured seem the host '' not allow connect mysql How can I do? The server you're connecting to needs to allow access from the client machine. Add the appropriate MySQL user account using a GRANT statement. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Paul DuBois, [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
Nesting DATE_FORMAT
Hello I am trying to display a table depending if the registration date is between a certain period. To do this , I want to pull the 'day' field from another table and construct one of the comparison dates with this value. It is probably best explained with a query. This is what I am trying to do: SELECT whatever FROM tbl1, tbl2 WHERE ( tbl1.registration_date = DATE_FORMAT(now(),'%Y-%m-)DATE_FORMAT(tbl2.registration_date,'%d') AND tbl1.registration_date = DATE_FORMAT(now(),'%Y-%m-%d') ) AND tbl2.id=1000 So both tables have their own registration_date, and I am trying to display rows when the registration_date of tbl1 is between the day of tbl2 joined with todays month and year AND todays date. e.g. if the reg_date in tbl2 is 2000-12-15 and todays date is 2001-05-29, it should display any records of tbl1 that have a registration date between 2001-05-15 and 2001-05-29 This is for a payment system, where accounts are paid on the registration date as defined in tbl2 each month, and they can check what accounts they will be getting paid for during the month. I am doing this in a PHP script and can pull the day out first then pass it in a second query. Was trying to find a way to do it in one query. Any tips or hints would be extremely appreciated. Thanks! Have a good one. Regards, Steven Wren - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
zip code locator
I'm trying to convert a primarily php script which does a zip code lookup into a mostly mysql one. I've got alot of the math done, but don't know how to pull some of the data from my tables. Here's the scenario, I have to get the number of miles between 2 zip codes, which are stored in 2 different tables. I am stuck on the part of getting 2 columns(Longitude Latitude) from one table and making them available to the query (so math can be performed on them). I know this can be done, but I can't seem to figure it out. This is what I'd like to do: select sum( acos(sin(lu_zip.Latitude * 0.0174) * sin(dealer_LATITUDE * 0.0174)) * cos(lu_zip.Latitude * 0.0174) * cos(dealer_LATITUDE * 0.0174) * cos(dealer_LONGITUDE - lu_zip.Longitude) * 6371.2 ) AS ZipDist FROM lu_zip,dealerlocations WHERE(dealerlocations.AddrZip = '90210'); I need the dealer latitude longitude of the dealer zipcode (passed in via php) which is looked up in the lu_zip table (which contains the lat/long). I think I need to use JOIN, but the syntax isn't very clear. Any help would be greatly appreciated. -- Jeremy Friedman [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
Install mysql-nt or mysql-max-nt
Hi, I am installing MySQL in Windows 2000 Advanced Server. However, the installation comes with two files for NT, namely mysql-nt.exe and mysql-max-nt.exe. Which one I should use ? Nyon
Re: Cannot create table with file named INFILE
At 2:23 PM +0200 5/28/01, Alessandro Staltari wrote: Hello. I'm new to MySQL but I have a problem that appears serious, al least for me. I can't create a table with a field named INFILE. I think mysql consider INFILE as a keyword. Is there work around for this? Shouldn't INFILE be used only within a LOAD statement? I think it is a bug in the query parser? Well, by that reasoning, COMMIT reasoning is used only in a COMMIT statement, so it should be allowable as a column name. Doesn't matter where a keyword is used; if it's a keyword, it's a keyword. Anyway, if you really want to use INFILE as a column name, you can do so, but you need to enclose it in backquote (`INFILE`) each time you refer to it. This will allow you to port your table from another database, but since it still requires some rewriting (to add those pesky backquotes), you may find it just as easy to rename the column. Regards Alessandro Staltari -- Paul DuBois, [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: Can't change password in MySQL Windows version
This was what I did: As root: mysqlGRANT ALL ON mydb.* to [EMAIL PROTECTED] identified by 'mypassword'; mysqlFLUSH PRIVILEGES; Trying to change myaccount's password from mysqladmin: C:\mysqladmin -u myaccount -p password newpassword Enter password: ** C:\MYSQL\BIN\MYSQLA~1.EXE: unable to change password; error: 'Can't find any matching row in the user table' Trying to change myaccount's password from mysql console (as myaccount): mysql SET PASSWORD = PASSWORD('newpassword'); ERROR 1133: Can't find any matching row in the user table Regards, Ardianto R. - Original Message - From: Rolf Hopkins [EMAIL PROTECTED] To: Ardianto Rustandi [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 8:01 AM Subject: Re: Can't change password in MySQL Windows version It's a little difficult solving your problem as you have not provided as with samples of the commands you used, but 1. Check that the user exists in the first place. and 2. Did you use GRANT to set up a user in the first place? Not just insert a user into the tables. - Original Message - From: Ardianto Rustandi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 23:32 Subject: Can't change password in MySQL Windows version Hello all! Can anyone help me why I cannot change a user's password in the Windows version of MySQL (except for the root account)? I keep getting the ERROR 1133: Can't find any matching row in the user table error message everytime I try to change a user's password, both from mysqladmin and from SET PASSWORD command. FYI I'm using version 3.23.28-gamma running on Win98. Thanx in advance! Ardianto Rustandi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What option of LOAD DATA should I use?
At 4:44 PM +0900 5/28/01, jamal wrote: Hi all, How to use MySQL LOAD DATA command to load comma separated text data Huh? Your LOAD DATA statement below specifies |-separated data, not comma-separated data. but one of the field can contains comma character as part of of the string context.? In other word, I want LOAD DATA insert string with comma characters inside it but without adding slash character ('\')to distinguish it as a field separator. I may be missing something, but that doesn't appear to make sense. If a comma is a field separator, then somehow you need to specify that within-field commas are not separators, either by escaping them, or by quoting the fields. Without using one of those mechanisms, MySQL has no way to distinquish separator and non-separator commas. I use this command, LOAD DATA LOCAL INFILE DATA.TXT REPLACE INTO TABLE tbl FIELDS TERMINATED BY | IGNORE 1 LINES but when I look at the table tbl, everything is fine except in the field that contain comma character, comma charater is written as '\,' rather than just ','. What option of LOAD DATA should I use? Jamal -- Paul DuBois, [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: mysql/php problem
- Original Message - From: Stephanie Deville [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 22:30 Subject: mysql/php problem I'm running FreeBSD 3.4, Apache 1.3.9 w/ php4 and mysql 3.22.32. The problem I'm having is that my php scripts work fine, mysql works fine. When I run a php script, everthing in the script works up to the point were I try mysql_connect. I get no error, but the script just hangs. It never connects to the database. I've looked through all my logs, and there are no errors listed anywhere. Any ideas? Here is the code I'm testing all this with: html head title My php test script /title /head body ?php $user = root; $pass = Taylor; $db = CollegeBound; Hope this isn't your real password and user name. $link = mysql_connect( localhost, $user, $pass ); if ( ! $link ) die( Couldn't connect to MySQL ); mysql_select_db ( $db, $link ) or die ( Couldn't open $db: .mysql_error() ); $result = mysql_querry( SELECT * FROM Address ); mysql_query has 1 r. $num_rows = mysql_num_rows ( $result ); print There are currently $num_rows rows in the tableP; msyq_close( $link ); Again check your spelling. phpinfo(); ? /body /html However, you're saying you're not getting any error messages. Try putting in a few print statements and see where the code freezes. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php