Multiple Referral Levels
I have a question regarding tracking multiple referral levels in a database. The number of referral levels tracked needs to be at least 4, but should be able to be expanded later (without modifying the database). The first design I considered was: table: id int(8) unsigned not null auto_increment, referer int(8) unsigned null, primary key (id), key tbl_referer(referer)); What I need to be able to do is give a breakdown of the # of members referred (on each level) for a specific member...say, member 10. Getting the # of referrals on level 1 is no problem: SELECT COUNT(*) FROM table WHERE id = 10 The second level isn't too tough either, using a simple join. But what about when I get down to level 4? Is it even possible to get this info in one query? How about level 10? The only other thing I can think of doing is storing not just the referer in the table, but something like: id ref1 ref2 ref3 ref4 ref5 etc... All of the logic would need to be taken care of during member registration, and querying to find the number of referrals on any given level for a member would be simple. However, this method does not allow for easy expansion of referral levels, which is what I want, and is probably not the best way of doing things. Can anyone offer any insight? __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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: Set Path Environment
Try to modify the autoexec.bat if you are using Win9x or the Path User env in Winnt. Another choice in some systems is to modify DOSTART.bat or something like that in \windows. A way to keep the previous setting of the PATH env is to issue a stat like SET PATH=%PATH%;c:\mysql; ... I hope this helps. Leonardo Javier Belen. AFIP-AR Spam: sql, query, mysql - Original Message - From: William Martell [EMAIL PROTECTED] To: MySQL Main List [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 11:38 PM Subject: Fw: Set Path Environment This is more information regarding the Path for my machine. It shows the default PATH information and the PATH information after I perform the SET PATH command. It also shows how MySQL responds after I type MySQL at the command prompt. Thanks in Advance, William C:\path PATH=C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem C:\SET PATH=C:\mysql\bin;C:\perl\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\W bem C:\path PATH=C:\mysql\bin;C:\perl\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\W bem C:\mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 3.23.52-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql - Original Message - From: William Martell [EMAIL PROTECTED] To: MySQL Main List [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 9:33 PM Subject: Set Path Environment Hello All, I am having trouble with MySQL in dos. When I type in mysql from the c:\ prompt, I get the following error: C:\mysql 'mysql' is not recognized as an internal or external command, operable program or batch file. I tried the SET PATH command and this works fine when I have dos open. But when I start another session of dos later the settings are gone. Does anyone know how to set this as the default path?? Thank you very much for your assistance and have a nice day. William - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...
Hi Jeremy, Same problem for me, I submitted a bug report with a repeatable testcase yesterday to the bugs list. Reading the source code and changeset 1.1287, it appears this part of the source code should be desactivated ? (ChangeSet 1.1287 02/09/15 02:23:53 [EMAIL PROTECTED] +2 -0 ha_innodb.h, ha_innodb.cc: Reverted the change which allowed use of HA_READ_PREFIX_LAST in InnoDB) Regards, Jocelyn - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 5:19 PM Subject: InnoDB: Assertion failure in file ha_innodb.cc line 2180... Heikki and others, One of my slaves is dying frequently. It runs MySQL 4.0.4 (pulled yesterday) on FreeBSD. I'm getting an assertion failure on line 2180, which appears to be: case HA_READ_PREFIX_LAST: ut_a(0); return(PAGE_CUR_LE); What can I do to help debug this? Thanks, Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 50 days, processed 1,063,578,875 queries (244/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...
Jeremy, Jocelyn, can you try the following this patch? The flag which bans MySQL using a descending cursor to calculate column LIKE 'jhghj%' ORDER BY column DESC queries was apparently put to the wrong place in ha_innodb.h. The assertion I had added to 4.0.4 revealed this hidden bug. The patch fixes also the crash submitted by Jocelyn Fournier earlier today: ... CREATE TABLE `threadhardwarefr13` ( `numeropost` mediumint(8) unsigned NOT NULL default '0', `numreponse` int(10) unsigned NOT NULL auto_increment, `pseudo` varchar(35) NOT NULL default '', `date` datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (`numeropost`,`numreponse`), UNIQUE KEY `numreponse` (`numreponse`), KEY `pseudo` (`pseudo`,`numeropost`) ) TYPE=InnoDB; SELECT LOWER(pseudo),date FROM threadhardwarefr13 WHERE numeropost='166498' ORDER BY numreponse DESC LIMIT 0,3; - assertion failure at line 2180 of ha_innodb.cc ... I have to check why MySQL uses that flag in Jocelyn's query. It does not have a LIKE '%' clause. Thank you for the bug reports, Heikki ChangeSet 1.1317 02/09/25 19:02:46 [EMAIL PROTECTED] +2 -0 ha_innodb.cc, ha_innodb.h: Move to the right place the flag which bans use of HA_READ_PREFIX_LAST; add diagnostics and remove the assertion on line 2180 of ha_innodb.cc sql/ha_innodb.cc 1.110 02/09/25 19:02:06 [EMAIL PROTECTED] +6 -1 Move to the right place the flag which bans use of HA_READ_PREFIX_LAST; add diagnostics and remove the assertion on line 2180 of ha_innodb.cc sql/ha_innodb.h 1.44 02/09/25 19:02:03 [EMAIL PROTECTED] +2 -1 Move to the right place the flag which bans use of HA_READ_PREFIX_LAST; add diagnostics and remove the assertion on line 2180 of ha_innodb.cc # This is a BitKeeper patch. What follows are the unified diffs for the # set of deltas contained in the patch. The rest of the patch, the part # that BitKeeper cares about, is below these diffs. # User: heikki # Host: hundin.mysql.fi # Root: /home/heikki/mysql-4.0 --- 1.109/sql/ha_innodb.cc Tue Sep 24 17:11:56 2002 +++ 1.110/sql/ha_innodb.cc Wed Sep 25 19:02:06 2002 @@ -2179,7 +2179,12 @@ case HA_READ_AFTER_KEY: return(PAGE_CUR_G); case HA_READ_BEFORE_KEY: return(PAGE_CUR_L); case HA_READ_PREFIX: return(PAGE_CUR_GE); - case HA_READ_PREFIX_LAST: ut_a(0); return(PAGE_CUR_LE); + case HA_READ_PREFIX_LAST: + ut_print_timestamp(stderr); +fprintf(stderr, + InnoDB: Warning: Using HA_READ_PREFIX_LAST\n); + return(PAGE_CUR_LE); + /* InnoDB does not yet support ..PREFIX_LAST! We have to add a new search flag PAGE_CUR_LE_OR_PREFIX to InnoDB. */ --- 1.43/sql/ha_innodb.h Fri Sep 20 23:26:10 2002 +++ 1.44/sql/ha_innodb.h Wed Sep 25 19:02:03 2002 @@ -82,6 +82,7 @@ HA_PRIMARY_KEY_IN_READ_INDEX | HA_DROP_BEFORE_CREATE | HA_NO_PREFIX_CHAR_KEYS | + HA_NOT_READ_PREFIX_LAST | HA_TABLE_SCAN_ON_INDEX), last_dup_key((uint) -1), start_of_scan(0) @@ -96,7 +97,7 @@ ulong index_flags(uint idx) const { return (HA_READ_NEXT | HA_READ_PREV | HA_READ_ORDER | -HA_KEY_READ_ONLY | HA_NOT_READ_PREFIX_LAST); +HA_KEY_READ_ONLY); } uint max_record_length() const { return HA_MAX_REC_LENGTH; } uint max_keys() const { return MAX_KEY; } - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 6:19 PM Subject: InnoDB: Assertion failure in file ha_innodb.cc line 2180... Heikki and others, One of my slaves is dying frequently. It runs MySQL 4.0.4 (pulled yesterday) on FreeBSD. I'm getting an assertion failure on line 2180, which appears to be: case HA_READ_PREFIX_LAST: ut_a(0); return(PAGE_CUR_LE); What can I do to help debug this? Thanks, Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 50 days, processed 1,063,578,875 queries (244/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: MySQL as a desktop DB
I use MySQL as a desktop db. It is alot faster than access, and much more efficient. A great front end I use is phpMyAdmin. www.phpMyAdmin.org -Steve. -Original Message- From: Insanely Great [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:58 AM To: MySQL List Subject: Re: MySQL as a desktop DB I think MySQL will be more faster in Desktop environment and if you are adverse to using the text based interface to MySQL then you can try out some GUI avaiable in the market. The best I know are MySQL-Front and SQLyog but since MySQL-Front has been discontinued you can try SQLyog at http://www.webyog.com/sqlyog Insane - Original Message - From: Adam Parker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 3:11 AM Subject: MySQL as a desktop DB I currently use MS Access as a single-user desktop database. The database is getting quite large. The largest table has 300,000 rows. I am considering upgrading the database. How suitable is MySQL as a single-user desktop database? How does it compare to Access when it is used like this? Obviously MySQL would have advantages if I intended to use it as a server database with concurrent users. But is it faster than Access in the single-user environment, when dealing with large databases? Thanks for any help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Max NB of MyISAM tables / DB ( Ext3 linux )
In the last episode (Sep 25), David Bordas said: I've just a little question for the end. I planned to have around 10K tables under a DB and this number surelly grow up to 20K. I know that a database is a directory and a table is 3 files. I just want to know is mysql have a limit in the number of table per database. If not, i know that ext3 can have ten of thousands files in a directory. But commande like 'ls' will become slower and slower ... Is this also slowing mysql ? show tables will be slow, for the same reason ls is slow: it has to fetch the names of all 20k files. Direct access via mysql should be fine. -- Dan Nelson [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: InnoDB: Assertion failure in file ha_innodb.cc line 2180...
On Wed, Sep 25, 2002 at 08:09:08PM +0300, Heikki Tuuri wrote: Jeremy, Jocelyn, can you try the following this patch? I'm building a new binary row. The flag which bans MySQL using a descending cursor to calculate column LIKE 'jhghj%' ORDER BY column DESC queries was apparently put to the wrong place in ha_innodb.h. The assertion I had added to 4.0.4 revealed this hidden bug. If it helps, my 4.0.2 and 4.0.3 don't have this problem. They all get the same queries. Perhaps a recent change elsewhere triggered this? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.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
Meidumtext vs. varchar
Hi All, I've built a survey application in MySQL that allows people to enter free-form comments. In processing the input, if the comments string is less than 256 characters long, I save it to a varchar column; if longer, I use a mediumtext. This works fine, but I'm wondering if I'm getting any real value from it. Is it inherently faster to retrieve varchars than mediumtext, even if the mediumtext is holding small (256 characters) values? What about for searching on these field types? -Derek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Max NB of MyISAM tables / DB ( Ext3 linux )
Hello, If the number of files is your concern, have you considered using InnoDB? It spans tables across any number of data files you want. The performance is great, too. Best regards, Iikka On Wed, 25 Sep 2002, David Bordas wrote: Hi list, I've just a little question for the end. I planned to have around 10K tables under a DB and this number surelly grow up to 20K. I know that a database is a directory and a table is 3 files. I just want to know is mysql have a limit in the number of table per database. If not, i know that ext3 can have ten of thousands files in a directory. But commande like 'ls' will become slower and slower ... Is this also slowing mysql ? 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
phpMyAdmin/MySQL Question
Maybe someone else can come up with an answer for me on this question. I am getting the following error when I try to run my index.php file. I think I have configured it correctly, but obviously I haven't. And my host basically told to go shove it. Welcome to phpMyAdmin 2.3.1-rc1 Error MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Does anyone have any suggestions on this one? My config file looks like this in the areas I think I may have screwed up: $cfg['PmaAbsoluteUri'] = 'http://www.iaacc.org/phpMyAdmin/'; $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE; $cfg['PmaNoRelation_DisableWarning'] = FALSE; /** * Server(s) configuration */ $i = 0; $i++; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = ''; $cfg['Servers'][$i]['socket']= ''; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['controluser'] = ''; $cfg['Servers'][$i]['controlpass'] = ''; $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = '***'; $cfg['Servers'][$i]['password'] = '***'; $cfg['Servers'][$i]['only_db'] = ''; $cfg['Servers'][$i]['verbose'] = ''; $cfg['Servers'][$i]['pmadb'] = ''; $cfg['Servers'][$i]['bookmarktable'] = ''; $cfg['Servers'][$i]['relation'] = ''; $cfg['Servers'][$i]['table_info']= ''; $cfg['Servers'][$i]['table_coords'] = ''; $cfg['Servers'][$i]['pdf_pages'] = ''; $cfg['Servers'][$i]['column_comments'] = ''; $cfg['Servers'][$i]['AllowDeny']['order'] = ''; $cfg['Servers'][$i]['AllowDeny']['rules'] = array(); I have my login and password entered into the user/password area. Also, the actually database is online at mysql.iaacc.org and that might be different. If anyone can help, I would REALLY appreciate it. Thanks -Bill William Easton Creative Media Group The University of Iowa Room 1185 Westlawn Iowa City, IA 52242 319/353-3022 voice 319/335-9127 fax [EMAIL PROTECTED] http://www.medicine.uiowa.edu/creative http://telemed.medicine.uiowa.edu Notice: This e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...
Hi Heikki, The query doesn't crash anymore, but the ORDER BY doesn't work at all (I tested it on a table with data). How-to-repeat : INSERT INTO threadhardwarefr13 (pseudo,date,numreponse) VALUES ('kytine','2002-09-18 20:37:31','1360'),('joce','2002-09-18 20:42:20','1361'),('kytine','2002-09-18 20:46:32','1362'); mysql SELECT LOWER(pseudo),date,numreponse FROM threadhardwarefr13 WHERE numeropost='0' ORDER BY numreponse DESC LIMIT 0,3; +---+-++ | LOWER(pseudo) | date| numreponse | +---+-++ | kytine| 2002-09-18 20:37:31 | 1360 | | joce | 2002-09-18 20:42:20 | 1361 | | kytine| 2002-09-18 20:46:32 | 1362 | +---+-++ 3 rows in set (0.00 sec) mysql SELECT LOWER(pseudo),date,numreponse FROM threadhardwarefr13 WHERE numeropost='0' ORDER BY numreponse ASC LIMIT 0,3; +---+-++ | LOWER(pseudo) | date| numreponse | +---+-++ | kytine| 2002-09-18 20:37:31 | 1360 | | joce | 2002-09-18 20:42:20 | 1361 | | kytine| 2002-09-18 20:46:32 | 1362 | +---+-++ 3 rows in set (0.00 sec) Regards, Jocelyn - Original Message - From: Heikki Tuuri [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 7:09 PM Subject: Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180... Jeremy, Jocelyn, can you try the following this patch? The flag which bans MySQL using a descending cursor to calculate column LIKE 'jhghj%' ORDER BY column DESC queries was apparently put to the wrong place in ha_innodb.h. The assertion I had added to 4.0.4 revealed this hidden bug. The patch fixes also the crash submitted by Jocelyn Fournier earlier today: ... CREATE TABLE `threadhardwarefr13` ( `numeropost` mediumint(8) unsigned NOT NULL default '0', `numreponse` int(10) unsigned NOT NULL auto_increment, `pseudo` varchar(35) NOT NULL default '', `date` datetime NOT NULL default '-00-00 00:00:00', PRIMARY KEY (`numeropost`,`numreponse`), UNIQUE KEY `numreponse` (`numreponse`), KEY `pseudo` (`pseudo`,`numeropost`) ) TYPE=InnoDB; SELECT LOWER(pseudo),date FROM threadhardwarefr13 WHERE numeropost='166498' ORDER BY numreponse DESC LIMIT 0,3; - assertion failure at line 2180 of ha_innodb.cc ... I have to check why MySQL uses that flag in Jocelyn's query. It does not have a LIKE '%' clause. Thank you for the bug reports, Heikki ChangeSet 1.1317 02/09/25 19:02:46 [EMAIL PROTECTED] +2 -0 ha_innodb.cc, ha_innodb.h: Move to the right place the flag which bans use of HA_READ_PREFIX_LAST; add diagnostics and remove the assertion on line 2180 of ha_innodb.cc sql/ha_innodb.cc 1.110 02/09/25 19:02:06 [EMAIL PROTECTED] +6 -1 Move to the right place the flag which bans use of HA_READ_PREFIX_LAST; add diagnostics and remove the assertion on line 2180 of ha_innodb.cc sql/ha_innodb.h 1.44 02/09/25 19:02:03 [EMAIL PROTECTED] +2 -1 Move to the right place the flag which bans use of HA_READ_PREFIX_LAST; add diagnostics and remove the assertion on line 2180 of ha_innodb.cc # This is a BitKeeper patch. What follows are the unified diffs for the # set of deltas contained in the patch. The rest of the patch, the part # that BitKeeper cares about, is below these diffs. # User: heikki # Host: hundin.mysql.fi # Root: /home/heikki/mysql-4.0 --- 1.109/sql/ha_innodb.cc Tue Sep 24 17:11:56 2002 +++ 1.110/sql/ha_innodb.cc Wed Sep 25 19:02:06 2002 @@ -2179,7 +2179,12 @@ case HA_READ_AFTER_KEY: return(PAGE_CUR_G); case HA_READ_BEFORE_KEY: return(PAGE_CUR_L); case HA_READ_PREFIX: return(PAGE_CUR_GE); - case HA_READ_PREFIX_LAST: ut_a(0); return(PAGE_CUR_LE); + case HA_READ_PREFIX_LAST: + ut_print_timestamp(stderr); +fprintf(stderr, + InnoDB: Warning: Using HA_READ_PREFIX_LAST\n); + return(PAGE_CUR_LE); + /* InnoDB does not yet support ..PREFIX_LAST! We have to add a new search flag PAGE_CUR_LE_OR_PREFIX to InnoDB. */ --- 1.43/sql/ha_innodb.h Fri Sep 20 23:26:10 2002 +++ 1.44/sql/ha_innodb.h Wed Sep 25 19:02:03 2002 @@ -82,6 +82,7 @@ HA_PRIMARY_KEY_IN_READ_INDEX | HA_DROP_BEFORE_CREATE | HA_NO_PREFIX_CHAR_KEYS | + HA_NOT_READ_PREFIX_LAST | HA_TABLE_SCAN_ON_INDEX), last_dup_key((uint) -1), start_of_scan(0) @@ -96,7 +97,7 @@ ulong index_flags(uint idx) const { return (HA_READ_NEXT | HA_READ_PREV | HA_READ_ORDER | -HA_KEY_READ_ONLY | HA_NOT_READ_PREFIX_LAST); +HA_KEY_READ_ONLY); } uint max_record_length() const { return HA_MAX_REC_LENGTH; } uint
I want to unsubscribe but the freaking commands don't work
Help! The following works are required so that this mail goes through sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
load data
I load a table whit the query: LOAD DATA INFILE 'a.txt' INTO TABLE table FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n'; the file: 211ppp222 222ooo333uuuo and more the problem is, the last field in the table is '|' , 'uuuo|' the enter final of the line is in the field - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Set Path Environment
Under NT and XP you set the environment variables by clicking on the My Computer icon and selecting Properties, then clicking the Environment variables on the Advanced tab. Make sure you set the PATH under the System Variables instead of User Variables if you want MySQL to be available to all users. William Martell wrote: Hello All, I am having trouble with MySQL in dos. When I type in mysql from the c:\ prompt, I get the following error: C:\mysql 'mysql' is not recognized as an internal or external command, operable program or batch file. I tried the SET PATH command and this works fine when I have dos open. But when I start another session of dos later the settings are gone. Does anyone know how to set this as the default path?? Thank you very much for your assistance and have a nice day. William - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- == John R. Diehl, Jr. FSU Department of Computer Science == - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access denied ????
At 15:08 25/9/2002 +0300, Iikka Meriläinen wrote: Hi, Only for to clarify: There is a rename table bug for some NT family (Win2k I tested) when is used at the command rename tables names with uppercase and the default lower_case_tables_names =1. This is already fixed in the next releases. On Wed, 25 Sep 2002, toby - wrote: thnx iikkaa im bsorry ... i ve win2k pro, apache 1.3.24 n php 4.2.2 all workin fine . my mysql4.0.1 alfa is givin me these night-mares cud this be the problem 4.0.1 ALFA ? it was a win zip file i guess not the source but a binary . plz do lemme know what can i do n thnx a lot again toby .. Error on rename of '.\zabandb\ctnt_inf.MYI' to '.\zabandb\#sql2-5b0-7e.MYI' (Errcode: 13) perror 13 -- Permission denied So it's probably due to your NTFS file/directory permission on Windows. Please try this if _nothing_ else seems to help: grant Everyone RWXD (full) rights to the whole data directory. This has, of course, a major problem with security but that way you could check if it's really a permissions problem. Also, a more secure way to accomplish this is to run the MySQL service as a ordinary user (rather than the SYSTEM account) and grant that user full rights to the whole data directory structure (make sure the subdirectories and files get their correct permissions, too). Regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I want to unsubscribe but the freaking commands don't work
Help! The following works are required so that this mail goes through sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Win32::ODBC Question (Oracle)
This email leads to a question I have about SQL. I have been accustomed to Mysql with all of its nifty little extensions - like describe. Now I have a project with MSSQL (not because I wanted it - politics). Does any one now how to describe a table structure with standard SQL. Even more important - in Mysql there is the show tables; command which allows you to see the structure of the whole DB. Is there a way to do this in standard SQL? Thanks. -Original Message- From: Peter van der Goes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 8:39 AM To: Thomas R Wyant_III; [EMAIL PROTECTED] Subject: Re: Win32::ODBC Question (Oracle) DESCRIBE is not a SQL command, it's a SQL+ command IIRC. The Oracle ODBC drivers don't know anything about DESCRIBE, because it's not a SQL command. (Warning - based on recollections of two years ago when I actually *worked* for a living) - Original Message - From: Thomas R Wyant_III [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 8:45 AM Subject: Re: Win32::ODBC Question (Oracle) [EMAIL PROTECTED] wrote: I'm trying to get Information about a spezific table in an Oracle with the command 'describe table_name; ' This command works within SQL-PLus and other Tools but I get the error message: Ora-00900: invalid SQL statement when I use it within a perl-script using a Win32::ODBC connection. Does someone know a solution , maybe to use a DBD, DBI module or a different statement to get information about the table definition? You don't say what information you want about the table. If you want to know what columns are in the table, and what data types are in the columns, you perform a select against the table, and then pull the data out of the selection results. If you don't want any data at this point, the usual dodge is to specify a where clause that is never satisfied. In fact, the usual dodge is select * from your_table where 1 = 0 I don't know of any better way under DBI, but you need to know less about your data types if you use DBI, because it supports placeholders. So instead of generating the entire text of a query, and worrying about whether values need to be quoted, and if so how to escape any embedded quotes, you just put a question mark in the query, and provide the value when the query is executed. Tom Wyant This communication is for use by the intended recipient and contains information that may be privileged, confidential or copyrighted under applicable law. If you are not the intended recipient, you are hereby formally notified that any use, copying or distribution of this e-mail, in whole or in part, is strictly prohibited. Please notify the sender by return e-mail and delete this e-mail from your system. Unless explicitly and conspicuously designated as E-Contract Intended, this e-mail does not constitute a contract offer, a contract amendment, or an acceptance of a contract offer. This e-mail does not constitute a consent to the use of sender's contact information for direct marketing purposes or for transfers of data to third parties. Francais Deutsch Italiano Espanol Portuges Japanese Chinese Korean http://www.DuPont.com/corp/email_disclaimer.html ___ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs ___ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Win32::ODBC Question (Oracle)
Hi, Use the following: SELECT * FROM sysobjects WHERE type='U' This will show you all of the user tables And then select * from syscolumns where ID = (select ID from sysobjects where name = 'your_tablename' and type = 'U' This should get you started! HTH Ian. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Norris, Joseph Sent: 25 September 2002 16:47 To: 'Peter van der Goes'; Thomas R Wyant_III; [EMAIL PROTECTED]; Mysql_List (E-mail) Subject: RE: Win32::ODBC Question (Oracle) This email leads to a question I have about SQL. I have been accustomed to Mysql with all of its nifty little extensions - like describe. Now I have a project with MSSQL (not because I wanted it - politics). Does any one now how to describe a table structure with standard SQL. Even more important - in Mysql there is the show tables; command which allows you to see the structure of the whole DB. Is there a way to do this in standard SQL? Thanks. -Original Message- From: Peter van der Goes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 8:39 AM To: Thomas R Wyant_III; [EMAIL PROTECTED] Subject: Re: Win32::ODBC Question (Oracle) DESCRIBE is not a SQL command, it's a SQL+ command IIRC. The Oracle ODBC drivers don't know anything about DESCRIBE, because it's not a SQL command. (Warning - based on recollections of two years ago when I actually *worked* for a living) - Original Message - From: Thomas R Wyant_III [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 8:45 AM Subject: Re: Win32::ODBC Question (Oracle) [EMAIL PROTECTED] wrote: I'm trying to get Information about a spezific table in an Oracle with the command 'describe table_name; ' This command works within SQL-PLus and other Tools but I get the error message: Ora-00900: invalid SQL statement when I use it within a perl-script using a Win32::ODBC connection. Does someone know a solution , maybe to use a DBD, DBI module or a different statement to get information about the table definition? You don't say what information you want about the table. If you want to know what columns are in the table, and what data types are in the columns, you perform a select against the table, and then pull the data out of the selection results. If you don't want any data at this point, the usual dodge is to specify a where clause that is never satisfied. In fact, the usual dodge is select * from your_table where 1 = 0 I don't know of any better way under DBI, but you need to know less about your data types if you use DBI, because it supports placeholders. So instead of generating the entire text of a query, and worrying about whether values need to be quoted, and if so how to escape any embedded quotes, you just put a question mark in the query, and provide the value when the query is executed. Tom Wyant This communication is for use by the intended recipient and contains information that may be privileged, confidential or copyrighted under applicable law. If you are not the intended recipient, you are hereby formally notified that any use, copying or distribution of this e-mail, in whole or in part, is strictly prohibited. Please notify the sender by return e-mail and delete this e-mail from your system. Unless explicitly and conspicuously designated as E-Contract Intended, this e-mail does not constitute a contract offer, a contract amendment, or an acceptance of a contract offer. This e-mail does not constitute a consent to the use of sender's contact information for direct marketing purposes or for transfers of data to third parties. Francais Deutsch Italiano Espanol Portuges Japanese Chinese Korean http://www.DuPont.com/corp/email_disclaimer.html ___ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs ___ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs ___ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Win32::ODBC Question (Oracle)
Ian's help worked great. I have one question. How do I specify the DB? I mean in the query analyzer I can select a db from the pulldown box - is there a way to specify the db in the statements below? Thanks. -Original Message- From: Ian Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 8:50 AM To: 'Norris, Joseph'; 'Peter van der Goes'; 'Thomas R Wyant_III'; [EMAIL PROTECTED]; 'Mysql_List (E-mail)' Subject: RE: Win32::ODBC Question (Oracle) Hi, Use the following: SELECT * FROM sysobjects WHERE type='U' This will show you all of the user tables And then select * from syscolumns where ID = (select ID from sysobjects where name = 'your_tablename' and type = 'U' This should get you started! HTH Ian. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Norris, Joseph Sent: 25 September 2002 16:47 To: 'Peter van der Goes'; Thomas R Wyant_III; [EMAIL PROTECTED]; Mysql_List (E-mail) Subject: RE: Win32::ODBC Question (Oracle) This email leads to a question I have about SQL. I have been accustomed to Mysql with all of its nifty little extensions - like describe. Now I have a project with MSSQL (not because I wanted it - politics). Does any one now how to describe a table structure with standard SQL. Even more important - in Mysql there is the show tables; command which allows you to see the structure of the whole DB. Is there a way to do this in standard SQL? Thanks. -Original Message- From: Peter van der Goes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 8:39 AM To: Thomas R Wyant_III; [EMAIL PROTECTED] Subject: Re: Win32::ODBC Question (Oracle) DESCRIBE is not a SQL command, it's a SQL+ command IIRC. The Oracle ODBC drivers don't know anything about DESCRIBE, because it's not a SQL command. (Warning - based on recollections of two years ago when I actually *worked* for a living) - Original Message - From: Thomas R Wyant_III [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 8:45 AM Subject: Re: Win32::ODBC Question (Oracle) [EMAIL PROTECTED] wrote: I'm trying to get Information about a spezific table in an Oracle with the command 'describe table_name; ' This command works within SQL-PLus and other Tools but I get the error message: Ora-00900: invalid SQL statement when I use it within a perl-script using a Win32::ODBC connection. Does someone know a solution , maybe to use a DBD, DBI module or a different statement to get information about the table definition? You don't say what information you want about the table. If you want to know what columns are in the table, and what data types are in the columns, you perform a select against the table, and then pull the data out of the selection results. If you don't want any data at this point, the usual dodge is to specify a where clause that is never satisfied. In fact, the usual dodge is select * from your_table where 1 = 0 I don't know of any better way under DBI, but you need to know less about your data types if you use DBI, because it supports placeholders. So instead of generating the entire text of a query, and worrying about whether values need to be quoted, and if so how to escape any embedded quotes, you just put a question mark in the query, and provide the value when the query is executed. Tom Wyant This communication is for use by the intended recipient and contains information that may be privileged, confidential or copyrighted under applicable law. If you are not the intended recipient, you are hereby formally notified that any use, copying or distribution of this e-mail, in whole or in part, is strictly prohibited. Please notify the sender by return e-mail and delete this e-mail from your system. Unless explicitly and conspicuously designated as E-Contract Intended, this e-mail does not constitute a contract offer, a contract amendment, or an acceptance of a contract offer. This e-mail does not constitute a consent to the use of sender's contact information for direct marketing purposes or for transfers of data to third parties. Francais Deutsch Italiano Espanol Portuges Japanese Chinese Korean http://www.DuPont.com/corp/email_disclaimer.html ___ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs ___ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs ___ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list
RE: Win32::ODBC Question (Oracle)
Figured it out. just use the use name_of_db and you can switch to another DB. thanks. -Original Message- From: Norris, Joseph Sent: Wednesday, September 25, 2002 9:02 AM To: 'Ian Robertson'; Norris, Joseph; 'Peter van der Goes'; 'Thomas R Wyant_III'; [EMAIL PROTECTED]; 'Mysql_List (E-mail)' Subject: RE: Win32::ODBC Question (Oracle) Ian's help worked great. I have one question. How do I specify the DB? I mean in the query analyzer I can select a db from the pulldown box - is there a way to specify the db in the statements below? Thanks. -Original Message- From: Ian Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 8:50 AM To: 'Norris, Joseph'; 'Peter van der Goes'; 'Thomas R Wyant_III'; [EMAIL PROTECTED]; 'Mysql_List (E-mail)' Subject: RE: Win32::ODBC Question (Oracle) Hi, Use the following: SELECT * FROM sysobjects WHERE type='U' This will show you all of the user tables And then select * from syscolumns where ID = (select ID from sysobjects where name = 'your_tablename' and type = 'U' This should get you started! HTH Ian. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Norris, Joseph Sent: 25 September 2002 16:47 To: 'Peter van der Goes'; Thomas R Wyant_III; [EMAIL PROTECTED]; Mysql_List (E-mail) Subject: RE: Win32::ODBC Question (Oracle) This email leads to a question I have about SQL. I have been accustomed to Mysql with all of its nifty little extensions - like describe. Now I have a project with MSSQL (not because I wanted it - politics). Does any one now how to describe a table structure with standard SQL. Even more important - in Mysql there is the show tables; command which allows you to see the structure of the whole DB. Is there a way to do this in standard SQL? Thanks. -Original Message- From: Peter van der Goes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 8:39 AM To: Thomas R Wyant_III; [EMAIL PROTECTED] Subject: Re: Win32::ODBC Question (Oracle) DESCRIBE is not a SQL command, it's a SQL+ command IIRC. The Oracle ODBC drivers don't know anything about DESCRIBE, because it's not a SQL command. (Warning - based on recollections of two years ago when I actually *worked* for a living) - Original Message - From: Thomas R Wyant_III [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 8:45 AM Subject: Re: Win32::ODBC Question (Oracle) [EMAIL PROTECTED] wrote: I'm trying to get Information about a spezific table in an Oracle with the command 'describe table_name; ' This command works within SQL-PLus and other Tools but I get the error message: Ora-00900: invalid SQL statement when I use it within a perl-script using a Win32::ODBC connection. Does someone know a solution , maybe to use a DBD, DBI module or a different statement to get information about the table definition? You don't say what information you want about the table. If you want to know what columns are in the table, and what data types are in the columns, you perform a select against the table, and then pull the data out of the selection results. If you don't want any data at this point, the usual dodge is to specify a where clause that is never satisfied. In fact, the usual dodge is select * from your_table where 1 = 0 I don't know of any better way under DBI, but you need to know less about your data types if you use DBI, because it supports placeholders. So instead of generating the entire text of a query, and worrying about whether values need to be quoted, and if so how to escape any embedded quotes, you just put a question mark in the query, and provide the value when the query is executed. Tom Wyant This communication is for use by the intended recipient and contains information that may be privileged, confidential or copyrighted under applicable law. If you are not the intended recipient, you are hereby formally notified that any use, copying or distribution of this e-mail, in whole or in part, is strictly prohibited. Please notify the sender by return e-mail and delete this e-mail from your system. Unless explicitly and conspicuously designated as E-Contract Intended, this e-mail does not constitute a contract offer, a contract amendment, or an acceptance of a contract offer. This e-mail does not constitute a consent to the use of sender's contact information for direct marketing purposes or for transfers of data to third parties. Francais Deutsch Italiano Espanol Portuges Japanese Chinese Korean http://www.DuPont.com/corp/email_disclaimer.html ___ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs ___ Perl-Win32-Users mailing list [EMAIL PROTECTED] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
I want to unsubscribe but the freaking commands don't work
Help! sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...
Jocelyn, below the latest patch which puts the code as it was in 4.0.3. Some LIKE 'abc%' ... DESC queries may return wrong results, but this is the best we can get to 4.0.4. I have to ask Monty about the use of HA_READ_PREFIX_LAST. Other bugs may be lurking in the use/non-use of that search flag. - Original Message - From: Jocelyn Fournier [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 9:04 PM Subject: Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180... Hi Heikki, The query doesn't crash anymore, but the ORDER BY doesn't work at all (I tested it on a table with data). How-to-repeat : INSERT INTO threadhardwarefr13 (pseudo,date,numreponse) VALUES ('kytine','2002-09-18 20:37:31','1360'),('joce','2002-09-18 20:42:20','1361'),('kytine','2002-09-18 20:46:32','1362'); mysql SELECT LOWER(pseudo),date,numreponse FROM threadhardwarefr13 WHERE numeropost='0' ORDER BY numreponse DESC LIMIT 0,3; +---+-++ | LOWER(pseudo) | date| numreponse | +---+-++ | kytine| 2002-09-18 20:37:31 | 1360 | | joce | 2002-09-18 20:42:20 | 1361 | | kytine| 2002-09-18 20:46:32 | 1362 | +---+-++ 3 rows in set (0.00 sec) mysql SELECT LOWER(pseudo),date,numreponse FROM threadhardwarefr13 WHERE numeropost='0' ORDER BY numreponse ASC LIMIT 0,3; +---+-++ | LOWER(pseudo) | date| numreponse | +---+-++ | kytine| 2002-09-18 20:37:31 | 1360 | | joce | 2002-09-18 20:42:20 | 1361 | | kytine| 2002-09-18 20:46:32 | 1362 | +---+-++ 3 rows in set (0.00 sec) Now this works: mysql INSERT INTO threadhardwarefr13 (pseudo,date,numreponse) VALUES - ('kytine','2002-09-18 20:37:31','1360'),('joce','2002-09-18 ' 20:42:20','1361'),('kytine','2002-09-18 20:46:32','1362'); Query OK, 3 rows affected (0.04 sec) Records: 3 Duplicates: 0 Warnings: 0 mysql SELECT LOWER(pseudo),date,numreponse FROM threadhardwarefr13 WHERE - numeropost='0' ORDER BY numreponse DESC LIMIT 0,3; +---+-++ | LOWER(pseudo) | date| numreponse | +---+-++ | kytine| 2002-09-18 20:46:32 | 1362 | | joce | 2002-09-18 20:42:20 | 1361 | | kytine| 2002-09-18 20:37:31 | 1360 | +---+-++ 3 rows in set (0.01 sec) mysql ChangeSet 1.1318 02/09/25 20:35:12 [EMAIL PROTECTED] +2 -0 ha_innodb.h, ha_innodb.cc: Remove the flag HA_NOT_READ_PREFIX_LAST because ORDER BY orders wrong then; also remove the diagnostic print to avoid cluttering the error log sql/ha_innodb.h 1.45 02/09/25 20:35:01 [EMAIL PROTECTED] +4 -1 Remove the flag HA_NOT_READ_PREFIX_LAST because ORDER BY orders wrong then; also remove the diagnostic print to avoid cluttering the error log sql/ha_innodb.cc 1.111 02/09/25 20:35:01 [EMAIL PROTECTED] +2 -2 Remove the flag HA_NOT_READ_PREFIX_LAST because ORDER BY orders wrong then; also remove the diagnostic print to avoid cluttering the error log # This is a BitKeeper patch. What follows are the unified diffs for the # set of deltas contained in the patch. The rest of the patch, the part # that BitKeeper cares about, is below these diffs. # User: heikki # Host: hundin.mysql.fi # Root: /home/heikki/mysql-4.0 --- 1.110/sql/ha_innodb.cc Wed Sep 25 19:02:06 2002 +++ 1.111/sql/ha_innodb.cc Wed Sep 25 20:35:01 2002 @@ -2180,9 +2180,9 @@ case HA_READ_BEFORE_KEY: return(PAGE_CUR_L); case HA_READ_PREFIX: return(PAGE_CUR_GE); case HA_READ_PREFIX_LAST: - ut_print_timestamp(stderr); +/* ut_print_timestamp(stderr); fprintf(stderr, - InnoDB: Warning: Using HA_READ_PREFIX_LAST\n); +InnoDB: Warning: Using HA_READ_PREFIX_LAST\n); */ return(PAGE_CUR_LE); /* InnoDB does not yet support ..PREFIX_LAST! --- 1.44/sql/ha_innodb.h Wed Sep 25 19:02:03 2002 +++ 1.45/sql/ha_innodb.h Wed Sep 25 20:35:01 2002 @@ -81,8 +81,11 @@ HA_NO_WRITE_DELAYED | HA_PRIMARY_KEY_IN_READ_INDEX | HA_DROP_BEFORE_CREATE | + /* We should also list HA_NOT_READ_PREFIX_LAST +here but it currently seems to break ORDER BY; +until release 4.0.5 some LIKE 'abc%' ... DESC +queries will not work correctly */ HA_NO_PREFIX_CHAR_KEYS | - HA_NOT_READ_PREFIX_LAST | HA_TABLE_SCAN_ON_INDEX), last_dup_key((uint) -1), start_of_scan(0) - Before posting, please check:
Re: Multiple Referral Levels
- Original Message - From: Daren Cotter [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 7:34 PM Subject: Multiple Referral Levels I have a question regarding tracking multiple referral levels in a database. The number of referral levels tracked needs to be at least 4, but should be able to be expanded later (without modifying the database). The first design I considered was: table: id int(8) unsigned not null auto_increment, referer int(8) unsigned null, primary key (id), key tbl_referer(referer)); What I need to be able to do is give a breakdown of the # of members referred (on each level) for a specific member...say, member 10. Getting the # of referrals on level 1 is no problem: SELECT COUNT(*) FROM table WHERE id = 10 The second level isn't too tough either, using a simple join. But what about when I get down to level 4? Is it even possible to get this info in one query? How about level 10? Yup, you can but you have to generate your query at runtime. I've done this with PHP. To be honest I worked for a company that supported site with referral system up-to 8 levels. So the trick is to generate query at runtime. Just LEFT JOIN the table to itself. Some kind of for loop however you must name your table every time differently. So: Select * from user_table as tb1 left join user_table as tb2 on (tb2.referer = tb1.id) left join user_table as tb3 on (tb3.referer = tb2.user_id) and so on. AFAIK the you can join up to 32 tables in a join. Andrey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Set Path Environment
Hi, Just to clarify a bit, the file in \windows is called winstart.bat, but it seems to be discontinued in Windows XP (may not be available in W2K either). In Windows NT it works, though. In NT/W2K/XP the most efficient way to modify these variables _and_ persist them is through My Computer-Properties... as I noted in an earlier message. After thinking this a bit, it'd be very nice if the MySQL setup program offered an option to automatically add mysql\bin to the PATH environment variable (whoever is responsible of the setup, please consider this!) on Windows. Best regards, Iikka On Wed, 25 Sep 2002, Leonardo Javier Belén wrote: Try to modify the autoexec.bat if you are using Win9x or the Path User env in Winnt. Another choice in some systems is to modify DOSTART.bat or something like that in \windows. A way to keep the previous setting of the PATH env is to issue a stat like SET PATH=%PATH%;c:\mysql; ... I hope this helps. Leonardo Javier Belen. AFIP-AR Spam: sql, query, mysql - Original Message - From: William Martell [EMAIL PROTECTED] To: MySQL Main List [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 11:38 PM Subject: Fw: Set Path Environment This is more information regarding the Path for my machine. It shows the default PATH information and the PATH information after I perform the SET PATH command. It also shows how MySQL responds after I type MySQL at the command prompt. Thanks in Advance, William C:\path PATH=C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem C:\SET PATH=C:\mysql\bin;C:\perl\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\W bem C:\path PATH=C:\mysql\bin;C:\perl\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\W bem C:\mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 3.23.52-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql - Original Message - From: William Martell [EMAIL PROTECTED] To: MySQL Main List [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 9:33 PM Subject: Set Path Environment Hello All, I am having trouble with MySQL in dos. When I type in mysql from the c:\ prompt, I get the following error: C:\mysql 'mysql' is not recognized as an internal or external command, operable program or batch file. I tried the SET PATH command and this works fine when I have dos open. But when I start another session of dos later the settings are gone. Does anyone know how to set this as the default path?? Thank you very much for your assistance and have a nice day. William - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 3.23.52 hangs sometimes
Some people have had problems with the binary of 3.23.5x. We had that problem, and when we went back to a self-compiled 3.23.46 things worked normally again. The bad behavior looked like normal operation for anywhere from two hours to five days, followed by a CPU meltdown with loads over 200, which would typically settle back down by itself after ten or fifteen minutes of (seemingly) nothing progressing. The MySQL guys have said they think it was a version of glibc that they linked with; compiling your own from source may fix the problem. I'd be interested to know if it does. OTOH, in the five or six years I've used MySQL, this is the first time behavior like that was the fault of the server---it's almost always something in our code instead. InnoDB is supposed to reduce pathalogical behavior in a running system, so you might try that. The above-described problem with the MySQL binaries happened with either table type. Good luck, --Pete On Wed, Sep 25, 2002 at 09:24:02AM -0700, Andrew Maltsev wrote: On Wed, Sep 25, 2002 at 10:02:52AM -0500, Philip Molter wrote: On Tue, Sep 24, 2002 at 08:21:36PM -0700, Andrew Maltsev wrote: : Any suggestions how to approach the problem? How and what to test? It : happens randomly, can work for a day or two with no problems and then : hang three times in one hour. And obviously I can't reproduce it in my : test environment however hard I stress test it. When it happens, what does the system look like? Is CPU pegged? Is MySQL using a lot of CPU. What does iostat tell you in terms of drive activity. Are the drives actively seeking or does the system seem relatively quiet? You'll have to do *some* troubleshooting. Sad thing is the system usually gets rebooted by support personel before I can get my hands on it because long downtime is not acceptable. I've seen it first hand only once and had just about a minute to look at it. It is not swapping, the system has adequate amount of memory and generally there is no significant disk activity, no disk bound processes at all. Show processlist responds with one process being in writing to network state and others sleeping. But killing it does not work and even killing the MySQL itself with SIGTERM does not work either, it has to be killed with -9 and then some indexes are corrupted and need myisamchk. Well, I got my answer I guess -- it was a long shot, I kind of hoped that somebody would respond with something like I get the same damn thing with 3.23.52 all the time, try x.xx.xx. As it is not the case I'll have to try to investigate it myself :) Andrew. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: client library no longer LGPL licensing
On Tue, 2002-09-24 at 23:05, Ken Menzel wrote: Hi Everyone, I don't know if it makes a difference to anyone, but mysql client libraries are no longer LGPL. see http://www.mysql.com/doc/en/Copyright.html. (original licenses can be found in old source tar files documentation). I think this means, if you have an application that uses mysql as one of your databases don't include the library it unless your app is GPL also (or MySQL gives permission or changes back to LGPL). I guess you could put a link to the web site so users could download the package. Is that inconvienient? Well the GPL client is the 4.0 client. The 3.23 client is still LGPL. As for you app is GPL also we do not demand GPL. We will make a addition to the GPL in the client saying that we allow a list of other OSI (see opensource.org) approved OpenSource licenses also. Like the PHP license for example. So the limited GPL vs other OpenSource licenses compatibility should not be a problem. As for a link to the old client it will not work with future releases when we add things like prepared statements, warning system and other things that require protocol updates. But it still available as a part of MySQL 3.23 as said above. I don't know if this would affect anyone, anyway, but I found it interesting that the licensing quietly changed and I wondered if anyone else cared or if this change cleared up some previous confusion and is a good thing? Most people are not affected by the change since it affects application when they are distributed. But people who has not followed our licensing guidelines before could have to pay us for commercial licenses this time. And that is the meaning of this. We did this change in 4.0 while it was a alpha/early-development release since we did not want to make the change to fast. We did change the website to reflect the new GPL client when we made 4.0 beta a few weeks ago. The change is made to avoid lots of discussions about when the GPL is effective. Basically we follow the same rules as we always have about when we want people to pay us for a commercial license but now we have a better legal ground to base it on. I hope it will save us (especially me since I have become the MySQL licensing guru :-) lots of discussion about who has to pay and who can use the GPL version. And of course this is totally in the line with what the Free Software Foundation and RMS wants since it spreads free software. We can still make exceptions and allow free use if there is a good reason for it (But not for I like to make money without freeing my code or paying you like reasons). So the goal is to get money out of the people who distribute non OpenSource application using MySQL. We need the income for the much larger development team we now have. And the cost of running a real company instead of the administrative mess that Monty and I had earlier (And that mess was very very bad for my ease of mind). Basically in the early years of MySQL we spend all out time on the technical stuff and did the absolute minimum to run the commercial/administrative side. And you can not do that forever. Monty and I also have this desire to work less than 15h/day 350+ days a year as we did the first years. So all in all I hope everybody understands this change and supports it! /David MySQL CoFounder PS: I might not be able to answer any followups to this for a long time. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Max NB of MyISAM tables / DB ( Ext3 linux )
If not, i know that ext3 can have ten of thousands files in a directory. But commande like 'ls' will become slower and slower ... Is this also slowing mysql ? I believe it would have to. There is a patch somewhere (I don't know if it's maintained) for adding indexed directories to ext2/ext3 to help this problem, or you could use a different filesystem, such as ReiserFS that indexes directories out of the box. In an environment where directory accesses far outnumber directory modifications, you should see a good improvement if you have 20K files in the directory. ('ls' slows down for reasons besides reading the directory; it usually sorts its output, and it's often set up to guess file type for each of the files. Turn those off and it usually goes quite quickly.) --Pete - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New to MySql
Hello all, I am brand new to MySql and I wanted to know if you could recommend any books that are a good start on learning the mechanics of MySql. 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: MySQL as a desktop DB
also: - mysqlstudio - http://www.mysqlstudio.com mascon - http://www.scibit.com -j -Original Message- From: Steve Bradwell [mailto:[EMAIL PROTECTED]] Sent: September 25, 2002 1:09 PM To: Insanely Great; MySQL List Subject: RE: MySQL as a desktop DB I use MySQL as a desktop db. It is alot faster than access, and much more efficient. A great front end I use is phpMyAdmin. www.phpMyAdmin.org -Steve. -Original Message- From: Insanely Great [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:58 AM To: MySQL List Subject: Re: MySQL as a desktop DB I think MySQL will be more faster in Desktop environment and if you are adverse to using the text based interface to MySQL then you can try out some GUI avaiable in the market. The best I know are MySQL-Front and SQLyog but since MySQL-Front has been discontinued you can try SQLyog at http://www.webyog.com/sqlyog Insane - Original Message - From: Adam Parker [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 3:11 AM Subject: MySQL as a desktop DB I currently use MS Access as a single-user desktop database. The database is getting quite large. The largest table has 300,000 rows. I am considering upgrading the database. How suitable is MySQL as a single-user desktop database? How does it compare to Access when it is used like this? Obviously MySQL would have advantages if I intended to use it as a server database with concurrent users. But is it faster than Access in the single-user environment, when dealing with large databases? Thanks for any help. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: No my.cnf file on Linux?
Lindberg, Wednesday, September 25, 2002, 5:17:53 PM, you wrote: LP I use mysql 3.23.4 max on linux and it have worked just fine. LP Now I want to use Transactions so I thougt that I should use the my.cnf to configure for that. If you want to use transaction, you should use InnoDB or BDB table. In my.cnf file you can set up options for InnoDB or BDB. LP Trouble is there is no my.cnf file on my computer. LP Do I have to create the file myself ? Yup. LP or is the InnoDB settings configured right by default? If you use 3.23. you must specify at least innodb_data_file_path in my.cnf. For more info look at: http://www.mysql.com/doc/en/InnoDB_start.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Case sensitivety behaviour [followup re: bugfix]
At 20:25 -0500 9/23/02, Paul DuBois wrote: At 16:43 -0700 9/23/02, Jan Steinman wrote: From: Moestl, Wolfgang [EMAIL PROTECTED] Is there a defined behaviour for handling the case-sensitivety for user- and hostnames? According to the specification for the Domain Name System (DNS), Internet hostnames are always supposed to be case-insensitive. Since other entities in MySQL are case-sensitive, this may seem inconsistent, but it is imposed by international standards. It is NOT under the control of MySQL. To get it even more confusing, the values for user and host at the SHOW GRANTS FOR [user]@[host] are BOTH FULLY case-sensitive. If verified, this is a bug. DNS-based hostnames should NEVER be case-sensitive. MySQL behaves like this: Usernames, passwords, and database and table names are case sensitive in grant table entries. Hostnames and column names are not. The fact that you observed this using the magic hostname localhost may indicate that MySQL is cheating by doing its own management of this unique name. Any other fully qualified domain name should go through your operating system's address resolver, and had better be case-insensitive! localhost is indeed interpreted specially in MySQL. On UNIX, it means connect using the UNIX domain socket rather than TCP/IP. So in this case, DNS is not involved. In any case, I do not observe a difference between setting up user accounts using host 'localhost' versus 'LOCALHOST'. I *do* observe case sensitive hostname behavior for SHOW GRANTS. This should not be. I'll ask about it. Okay, there was indeed a case comparison problem with SHOW GRANTS. This has now been fixed for the upcoming 4.0.4 release. On UNIX and clones: nslookup localhost nslookup Localhost and nslookup LoCaLhOsT all answer the same IP. If case-insensitivity with localhost is important, you might just map some other name to your machine and use that instead. This is also a good policy in case you later want to move your database to its own machine. For example, I have data defined as a CNAME in DNS for the machine I'd normally refer to as localhost. It seems to work -- as it should -- if I call it data, Data, dATA, etc. -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Multiple Referral Levels
You are on the right track that you don't want to modify the database just to add a level. You also want to have your levels in one column/field so that you can use an index to search it quickly and easily. You didn't mention whether someone can be referred on multiple levels, this will really dictate the structure. If one can only be referred on one level, then it's fairly simple: Members - MemberID MemberName RefererID (links to another member record in same database) RefererLevel SELECT COUNT(*) FROM Members WHERE RefererID=10 AND RefererLevel4 That will give you all referrals for member 10 referred on level 1,2, or 3, but not 4. If one member can be referred multiple times on multiple levels, then you need to split things apart and query a little different. Members - MemberID MemberName Referrals - MemberID RefererID Level SELECT COUNT(DISTINCT(MemberID)) FROM Member WHERE RefererID=10 AND Level4 That will give you all referrals for member 10 referred on level 1,2, or 3, but not 4. There is actually no need for a join unless you want to get the names of all the members that someone referred. Does that help or am I completely missing what you are trying to do? On Wednesday, September 25, 2002, at 12:34 PM, Daren Cotter wrote: I have a question regarding tracking multiple referral levels in a database. The number of referral levels tracked needs to be at least 4, but should be able to be expanded later (without modifying the database). -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Data from multiple sources
Hello All, Can someone tell me if I can load only one column of data from a tab delimited text file into MySQL 4.0? If so, then can I assume that I can load data from multiple data stores, picking columns as I need to. Thank you for your assistance. William - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: I want to unsubscribe but the freaking commands don't work
Then, go here: http://lists.mysql.com/php/unsubscribe.php Or, try using a real MUA. Regards, Van -- = Linux rocks!!! http://www.dedserius.com/ = David Busby wrote: Help! sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Meidumtext vs. varchar
It's probably faster to retrieve from a varchar field than a mediumtext field, but any benefit is completely erased by the need to perform an OR query to search in both fields. Your biggest speed benefit can actually be attained by avoiding varchar and text fields altogether, use char(). This will cause each record to be exactly the same length, which will allow MySQL to jump to spot in the file quicker. It's less efficient on space usage, but storage is cheap. On Wednesday, September 25, 2002, at 01:48 PM, Derek Scruggs wrote: Hi All, I've built a survey application in MySQL that allows people to enter free-form comments. In processing the input, if the comments string is less than 256 characters long, I save it to a varchar column; if longer, I use a mediumtext. This works fine, but I'm wondering if I'm getting any real value from it. Is it inherently faster to retrieve varchars than mediumtext, even if the mediumtext is holding small (256 characters) values? What about for searching on these field types? -Derek - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyAdmin/MySQL Question
I believe you need to change the socket to the location in your /etc/my.cnf file. I usually add both sections in it just to kep things straight. [client] socket=path-for-socket-file [mysqld] socket=path-for-socket-file I used /ldata/mysql/tmp/mysql.sock my.cnf isn't automatically there so you may have to create it. then change $cfg['Servers'][$i]['socket']= ''; to $cfg['Servers'][$i]['socket']= 'path-used-in-my.cnf'; I am probably wrong, but its something that you can try without any danger of screwing up everything. If it doesn't work, simply remove the socket information and lines from the my.cnf file. Jason -Original Message- From: Easton, William [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 12:55 PM To: '[EMAIL PROTECTED]' Subject: phpMyAdmin/MySQL Question Maybe someone else can come up with an answer for me on this question. I am getting the following error when I try to run my index.php file. I think I have configured it correctly, but obviously I haven't. And my host basically told to go shove it. Welcome to phpMyAdmin 2.3.1-rc1 Error MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Does anyone have any suggestions on this one? My config file looks like this in the areas I think I may have screwed up: $cfg['PmaAbsoluteUri'] = 'http://www.iaacc.org/phpMyAdmin/'; $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE; $cfg['PmaNoRelation_DisableWarning'] = FALSE; /** * Server(s) configuration */ $i = 0; $i++; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = ''; $cfg['Servers'][$i]['socket']= ''; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['controluser'] = ''; $cfg['Servers'][$i]['controlpass'] = ''; $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = '***'; $cfg['Servers'][$i]['password'] = '***'; $cfg['Servers'][$i]['only_db'] = ''; $cfg['Servers'][$i]['verbose'] = ''; $cfg['Servers'][$i]['pmadb'] = ''; $cfg['Servers'][$i]['bookmarktable'] = ''; $cfg['Servers'][$i]['relation'] = ''; $cfg['Servers'][$i]['table_info']= ''; $cfg['Servers'][$i]['table_coords'] = ''; $cfg['Servers'][$i]['pdf_pages'] = ''; $cfg['Servers'][$i]['column_comments'] = ''; $cfg['Servers'][$i]['AllowDeny']['order'] = ''; $cfg['Servers'][$i]['AllowDeny']['rules'] = array(); I have my login and password entered into the user/password area. Also, the actually database is online at mysql.iaacc.org and that might be different. If anyone can help, I would REALLY appreciate it. Thanks -Bill William Easton Creative Media Group The University of Iowa Room 1185 Westlawn Iowa City, IA 52242 319/353-3022 voice 319/335-9127 fax [EMAIL PROTECTED] http://www.medicine.uiowa.edu/creative http://telemed.medicine.uiowa.edu Notice: This e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
speed problems (?!)
hi all i've mysql 2.32.52 installed, and there is a table with nearly 2.000.000 records in it (4 field/record). i have 256megs of RAM, and the linux version is RedHat 7.3. i do a simple delete, like: delete from foo_db where foo10; (this is around 15.000 record) and after 30 minutes, still nothing. the load is over 2, minimal disk activity. the filesize is around 300MByte. what could be wrong with this? why is it so slow? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: phpMyAdmin/MySQL Question
Yes, please, someone please tell how that mysql.sock file is working. I get the same general thing as well when I try to connect using just mysqladmin. Don B. -Original Message- From: Easton, William [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 10:55 AM To: '' Subject: phpMyAdmin/MySQL Question Maybe someone else can come up with an answer for me on this question. I am getting the following error when I try to run my index.php file. I think I have configured it correctly, but obviously I haven't. And my host basically told to go shove it. Welcome to phpMyAdmin 2.3.1-rc1 Error MySQL said: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Does anyone have any suggestions on this one? My config file looks like this in the areas I think I may have screwed up: $cfg['PmaAbsoluteUri'] = 'http://www.iaacc.org/phpMyAdmin/'; $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE; $cfg['PmaNoRelation_DisableWarning'] = FALSE; /** * Server(s) configuration */ $i = 0; $i++; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = ''; $cfg['Servers'][$i]['socket']= ''; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['controluser'] = ''; $cfg['Servers'][$i]['controlpass'] = ''; $cfg['Servers'][$i]['auth_type'] = 'config'; $cfg['Servers'][$i]['user'] = '***'; $cfg['Servers'][$i]['password'] = '***'; $cfg['Servers'][$i]['only_db'] = ''; $cfg['Servers'][$i]['verbose'] = ''; $cfg['Servers'][$i]['pmadb'] = ''; $cfg['Servers'][$i]['bookmarktable'] = ''; $cfg['Servers'][$i]['relation'] = ''; $cfg['Servers'][$i]['table_info']= ''; $cfg['Servers'][$i]['table_coords'] = ''; $cfg['Servers'][$i]['pdf_pages'] = ''; $cfg['Servers'][$i]['column_comments'] = ''; $cfg['Servers'][$i]['AllowDeny']['order'] = ''; $cfg['Servers'][$i]['AllowDeny']['rules'] = array(); I have my login and password entered into the user/password area. Also, the actually database is online at mysql.iaacc.org and that might be different. If anyone can help, I would REALLY appreciate it. Thanks -Bill William Easton Creative Media Group The University of Iowa Room 1185 Westlawn Iowa City, IA 52242 319/353-3022 voice 319/335-9127 fax [EMAIL PROTECTED] http://www.medicine.uiowa.edu/creative http://telemed.medicine.uiowa.edu Notice: This e-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. 2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: OT: Multiple Referral Levels
Not really a MySQL question, but... The way you have it now definitely won't work. Your select statement for getting the number of referrals for level one will always return a count of one -- because id is the primary key of your table. One way to do this, without listing all the referrals in a single table like you have below, is to use two tables. create table customers ( cust_id int unsigned not null auto_increment primary key, [other relevant fields] ); create table referrals ( cust_id int unsigned not null, ref_id int unsigned not null, ref_level tinyint unsigned not null, primary key (cust_id, ref_level), index (ref_id, ref_level) ); This assumes that all your referrals are coming from existing customers, so the ref_id field in the referrals table is really just another cust_id from your customers table. If this is not correct, you may have to have a 3rd table to generate the correct ref_id's. With this setup, you can have up to 256 referral levels. If you need more, just change the datatype of the ref_level field. You can easily find the ref_id for a particular cust_id and ref_level using the primary key: SELECT ref_id FROM referrals WHERE cust_id=10 and ref_level=3; You can also easily find the number of referrals a given customer has generated for any particular level: SELECT COUNT(*) FROM referrals WHERE ref_id=10 and ref_level=5; Or you can get a complete breakdown of referrals for a given customer by grouping on the ref_level: SELECT COUNT(*), ref_level FROM referrals WHERE ref_id=10 GROUP BY ref_level; Or for everybody at once: SELECT COUNT(*), ref_id, ref_level FROM referrals GROUP BY ref_id, ref_level; Etc... Does this make sense? --jeff - Original Message - From: Daren Cotter [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 9:34 AM Subject: Multiple Referral Levels I have a question regarding tracking multiple referral levels in a database. The number of referral levels tracked needs to be at least 4, but should be able to be expanded later (without modifying the database). The first design I considered was: table: id int(8) unsigned not null auto_increment, referer int(8) unsigned null, primary key (id), key tbl_referer(referer)); What I need to be able to do is give a breakdown of the # of members referred (on each level) for a specific member...say, member 10. Getting the # of referrals on level 1 is no problem: SELECT COUNT(*) FROM table WHERE id = 10 The second level isn't too tough either, using a simple join. But what about when I get down to level 4? Is it even possible to get this info in one query? How about level 10? The only other thing I can think of doing is storing not just the referer in the table, but something like: id ref1 ref2 ref3 ref4 ref5 etc... All of the logic would need to be taken care of during member registration, and querying to find the number of referrals on any given level for a member would be simple. However, this method does not allow for easy expansion of referral levels, which is what I want, and is probably not the best way of doing things. Can anyone offer any insight? __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Meidumtext vs. varchar
On 25 Sep 2002, at 16:28, Brent Baisley wrote: Your biggest speed benefit can actually be attained by avoiding varchar and text fields altogether, use char(). This will cause each record to be exactly the same length, which will allow MySQL to jump to spot in the file quicker. It's less efficient on space usage, but storage is cheap. If Derek is using a MEDIUMTEXT column, presumably he sometimes has more than 65,535 bytes of data in that column, so CHAR is not an option. Besides, with indexes MySQL has the right spot to jump to available even if you don't have fixed-length records. [Filter fodder: SQL] -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: speed problems (?!)
Any reason you can't upgrade to a newer version? mysql,query DSL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: client library no longer LGPL licensing
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The change is made to avoid lots of discussions about when the GPL is effective. Basically we follow the same rules as we always have about when we want people to pay us for a commercial license but now we have a better legal ground to base it on. I hope it will save us (especially me since I have become the MySQL licensing guru :-) lots of discussion about who has to pay and who can use the GPL version. And of course this is totally in the line with what the Free Software Foundation and RMS wants since it spreads free software. We can still make exceptions and allow free use if there is a good reason for it (But not for I like to make money without freeing my code or paying you like reasons). So the goal is to get money out of the people who distribute non OpenSource application using MySQL. We need the income for the much larger development team we now have. And the cost of running a real company instead of the administrative mess that Monty and I had earlier (And that mess was very very bad for my ease of mind). Does this also apply to non-open-source but free applications? For example, we give away Escapade for free - always have, always will, at least for the minimal version of the product. If we develop a non-free version of Escapade that uses mysqlclient, what happens then? We also distribute statically-linked and dynamically-linked versions of the product, and I would be interested in knowing MySQL's position on this issue in regards to licensing. - -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Licensed Texas Peace Officer Computer Crime Investigation Consultant Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden http://www.squishedmosquito.com The whole aim of practical politics is to keep the populace alarmed-- and thus clamorous to be let to safety-- by menacing it with an endless series of hobgoblins, all of them imaginary. - -- H. L. Mencken -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBPZI6FkbhwAGg7YRjEQI/6gCfcnE/vxjAdVXrUs3LTuNUafxRb9sAn3kT A86wjGjw2TYgqhPfPi9V6bna =P6pl -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyISAM or InnoDB
On Wed, Sep 25, 2002 at 08:26:25AM -0600, Scott Pippin wrote: We are moving a databse over from Oracle to MySQL 4.0.3 and I was wondering if I should use MyISAM or InnoDb. The databse currently has 800-900 updates and inserts done to it in a day along with about 1000 selects. Would I run in to any table locking problems with MyISAM? Well, if the individual queries run quickly, any table type can handle it. On modest hardware you can perform 2,000 queries per *second* so you're not going to be stressing either MyISAM or InnoDB. If, on the other hand, need features specific to MyISAM or InnoDB, that'll certainly influence the decision. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 50 days, processed 1,069,298,020 queries (244/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: The record_buffer ,join_buffer, sort_buffer
On Wed, Sep 25, 2002 at 08:42:05AM -0300, Dyego Souza do Carmo wrote: The variables record_buffer,join_buffer and sort_buffer are alocated every user connect ? No, their are allocated on an as-needed basis for each thread. If a thread doesn't need to join anything, there will be no join buffer allocated. You can test that easily by setting them to really large values and noticing that your server doesn't run out of memory if your run INSERTs (for example). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 50 days, processed 1,069,315,891 queries (244/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL InnoDb restore
I am new to InnoDb and was wondering what steps I would have to do to restore a table. Lets assume I am backing up the data by backing up the tablespaces. Thanks in advance (MySQL, query) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: speed problems (?!)
On Wed, Sep 25, 2002 at 11:33:37PM +0300, Gergely Imre wrote: hi all i've mysql 2.32.52 installed, and there is a table with nearly 2.000.000 records in it (4 field/record). i have 256megs of RAM, and the linux version is RedHat 7.3. i do a simple delete, like: delete from foo_db where foo10; (this is around 15.000 record) and after 30 minutes, still nothing. the load is over 2, minimal disk activity. the filesize is around 300MByte. what could be wrong with this? why is it so slow? Is foo indexed? Do you have a large key_buffer? What does EXPLAIN SELECT * FROM foo_db WHERE foo 10 say? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 50 days, processed 1,069,481,946 queries (244/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: client library no longer LGPL licensing
Does this also apply to non-open-source but free applications? For example, we give away Escapade for free - always have, always will, at least for the minimal version of the product. If we develop a non-free version of Escapade that uses mysqlclient, what happens then? We also distribute statically-linked and dynamically-linked versions of the product, and I would be interested in knowing MySQL's position on this issue in regards to licensing. Excellent question and our point also, we give away our non-open source application as well and do not charge a per user/copy/customer charge for the client or restrict copies. We DO have licensed servers and and we DO charge for using our servers. I have been contacted be e-mail by MySQL licensing and am looking forward to having my questions answered. We are still using MySQL 3 so I think we are OK. But was planning on going to MySQL 4 soon. I wonder how this affect the Mascon people (Neat little app also). Anyway I can understand MySQL's need to grow and would hope they continue to listen to us MySQL developers as they always have. (And I think they will). But I do feel this is an important change for anyone working with a windows client for MySQL and want to be able to earn dinner! And I would hope for open discussions. We all want MySQL to succeed as a DB and as a company. Ken - -- Ed Carp, N7EKG http://www.pobox.com/~erc 214/986-5870 Licensed Texas Peace Officer Computer Crime Investigation Consultant Director, Software Development Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - London - Dresden http://www.squishedmosquito.com The whole aim of practical politics is to keep the populace alarmed-- and thus clamorous to be let to safety-- by menacing it with an endless series of hobgoblins, all of them imaginary. - -- H. L. Mencken -BEGIN PGP SIGNATURE- Version: PGPfreeware 6.5.8 for non-commercial use http://www.pgp.com iQA/AwUBPZI6FkbhwAGg7YRjEQI/6gCfcnE/vxjAdVXrUs3LTuNUafxRb9sAn3kT A86wjGjw2TYgqhPfPi9V6bna =P6pl -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: rE: re: mi fa so la ti do... Character Set Settings Query
Query: can you guys please trim up your quotes a little? -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: OT Re: Mysql, PHP and a wrapper
whew, I found it. I looked at my installed rpm's ('rpm -q php') found the install php 4.1.2-7.3.4. Tried to remove ('php -e php*.rpm') got multiple dependent errors. That when I noticed I had about 6 rpm's had installed 6 different flavors of php. I uninstalled all and reinstalled just php-4.1.2-7.3.4.rpm and php-mysql-4.1.2-7.3.4.rpm and finally everything works good. I noticed that sometime in the past I somehow installed an older version of php but a different version of php-mysql. Not sure how I did that. Usually linux is fairly goof proof when it comes to rpm's. shakes his head sometimes I'm my own worst wenzu. -Original Message- From: Danny Haworth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 1:54 AM To: [EMAIL PROTECTED] Subject: OT Re: Mysql, PHP and a wrapper -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 OT Filter: query , sql Hi Brian, | I'm running apache-1.3.23-14 on a redhat 7.3 system. | I have installed the php-rpm and the php_mysql.rpm from Redhat. | installed php-4.1.2-7.3.4 and php-mysql-4.1.2-7.3.4. | | Cannot connect to my mysql-3.23.49-3 database. | | If I use mysql_connect() only, I get Fatal error: Call to undefined | function: mysql_connect() in /var/www/html/admin.php on line 9 I had massive problems with the redhat php rpm's.. get the source from the php homepage and include the option '--with-mysql' in the './configure' arguments. HTH danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9kWukUKf+497XC3QRAhU6AJ0eK4hnb8ARkJ1QJHTLg24mN5nV2gCeJl4M Bbd+8gXfFtsDpu2HCu/DgjI= =ZBdO -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Temporary tables
On Wed, 2002-09-25 at 10:10, Keith C. Ivey wrote: On 25 Sep 2002, at 0:57, John Coder wrote: So it's probably the fact that I didn't make the connection persistent that screwed me up sometimes I feel so stupid. I don't think that will help. Read Paul's message again. Even if you make the connection persistent, you can't be sure you'll get the same connection for the other page. In a Web application, I don't think temporary tables are useful if you need them to be shared between pages. One solution I've used is to create an ordinary table with a unique name and then drop it when you're finished with it. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org That's what I resorted to doing and yes I cahnged it to mysql_pconnect and it didn't make a diff. John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 as a desktop DB
I think MySQL will be more faster in Desktop environment and if you are adverse to using the text based interface to MySQL then you can try out some GUI avaiable in the market. The best I know are MySQL-Front and SQLyog but since MySQL-Front has been discontinued you can try SQLyog at http://www.webyog.com/sqlyog Have you ever tried OpenOffice as a Frontend for our mySQL? Would be a powerfull Opensource-Team! -- [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
newbie only
i've installed ver 3.23.47 sa win2k pero di ko sya mstart as service.. if i type this==mysqladmin create database01 ERROR==mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to MYSQL server on 'localhost' 10061' Check that mysqld is running on localhost and that the port is 3306. You can check this by doing 'telnet localhost 3306' and this ==telnet localhost 3306 ERROR==Conneting to localhost..Could not open a connection to host on port 3306 : Connect failed *note:windows 2000 is installed in my E: directory and i alrdy changed this in my.cnf __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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: Set Path Environment
Why not you set the path in your environment variables and restart the computer Are you using win98 or NT? - Original Message - From: William Martell [EMAIL PROTECTED] To: MySQL Main List [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 11:33 AM Subject: Set Path Environment Hello All, I am having trouble with MySQL in dos. When I type in mysql from the c:\ prompt, I get the following error: C:\mysql 'mysql' is not recognized as an internal or external command, operable program or batch file. I tried the SET PATH command and this works fine when I have dos open. But when I start another session of dos later the settings are gone. Does anyone know how to set this as the default path?? Thank you very much for your assistance and have a nice day. William - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Updating blob from command line
CREATE TABLE temponly(name VARCHAR(50) NOT NULL PRIMARY KEY, pic BLOB)TYPE = INNODB ; INSERT INTO temponly(name , pic) values( 'velan', load_file('e:/mysql/images/Click.gif')) ; Hope this helps. - Original Message - From: Chris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 11:31 PM Subject: Updating blob from command line Greetings, Is there anyway to import an image into a blob column from the command line? By like making an sql script? What I have is a database that has 4 blob columns per row that holds signature images. Every once in awhile a new signature needs to update the old signature. I need to be able to update the database with the new image through a script since it needs to be automated. Does anybody have any ideas, and can this be done? Thanks! - Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
primary keys
Hi - I'm a mysql newbie. As I've yet to discover a method of batching mysql commands I prefer to input lengthy instructions (such as large file structures) in stages, so input errors can be dealt with more easily. For example, I first define table structures and then indexes. This led me to use create index for the latter. The following syntax create index city_idx on city_country_masterfile (city); worked for an ordinary index definition. However, when I wanted to define the fourth column (pkey) as a primary key I could not get create index to work - I misunderstood the syntax or was misapplying create index. What finally worked for me was alter table city_country_masterfile add primary key (pkey);. The two purposes to this entry are 1) to inform those who may have similar problems, of my fix and 2) to ask others for some specific examples of create index and create table syntax, for example, for creating primary, unique and foreign keys, Hope this helps those and that others can too. Thank you and regards, John Barrington Please note new e-mail address: [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: primary keys
At 11:55 -0700 9/23/02, johnbarri wrote: Hi - I'm a mysql newbie. As I've yet to discover a method of batching mysql commands I prefer to input lengthy instructions (such as large file structures) in stages, so input errors can be dealt with more easily. For example, I first define table structures and then indexes. This led me to use create index for the latter. The following syntax create index city_idx on city_country_masterfile (city); worked for an ordinary index definition. However, when I wanted to define the fourth column (pkey) as a primary key I could not get create index to work - I misunderstood the syntax or was misapplying create index. CREATE INDEX cannot create a PRIMARY KEY. It has no syntax for it. DROP INDEX won't drop a PRIMARY KEY, either. What finally worked for me was alter table city_country_masterfile add primary key (pkey);. That's what you need to 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
Not Null
I create a table with a VarChar field set to not null. When I do an insert into this table with no value for this field it goes through without a problem. I realize MySQL inserts a empty string into the field. But what a want is an error when this happens. Is there any way to force this? -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.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: Mysql Error
I have installed the php-mysql package and can now connect to the database. There is however another error which i do not undertand. Warning: No MySQL-Link resource supplied in /usr/local/www/vantweststamps/databaselogin.php on line 15 Connected successfully These pages all work without error on my win98 machine with apache, mysql and php. Is there any documentation whoich lists all of these error conditions ans suggests ways of solving them? Regards Peter Goggin - Original Message - From: Thomas Seifert [EMAIL PROTECTED] To: Peter Goggin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 12:28 AM Subject: Re: Mysql Error if I remember right, there is a php-mysql*rpm package for redhat which corrects this problem. Thomas On Wed, 25 Sep 2002 23:23:07 +1000 Peter Goggin [EMAIL PROTECTED] wrote: The php is as installed from the redhat distribution for 7.3 from the Next handbooks. Do I need to down load a later version of PHP or cn I modify what is already installed? Regards Peter Goggin - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] To: Peter Goggin [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 10:30 PM Subject: Re: Mysql Error Hello, Your Apache is OK, but you've got a PHP version that's not configured with the --with-mysql option. You need to recompile PHP if you've installed from the source. Regards, Iikka On Wed, 25 Sep 2002, Peter Goggin wrote: I have got apache and mysql running on my linux server. When connecting to my web site I get the following error: Fatal error: Call to undefined function: mysql_close() in /usr/local/www/vantweststamps/databaselogin.php on line 15 Does this mena the apache server has not been linked to the mysql functions? Regards Peter Goggin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fw: Updating blob from command line
sorry i missed the update statement UPDATE temponly SET pic = load_file('e:/mysql/images/mod_jk.jpeg') where name = 'velan' ; regards - Original Message - From: kayamboo [EMAIL PROTECTED] To: Chris [EMAIL PROTECTED] Cc: list mysql [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 9:15 AM Subject: Re: Updating blob from command line CREATE TABLE temponly(name VARCHAR(50) NOT NULL PRIMARY KEY, pic BLOB)TYPE = INNODB ; INSERT INTO temponly(name , pic) values( 'velan', load_file('e:/mysql/images/Click.gif')) ; Hope this helps. - Original Message - From: Chris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 11:31 PM Subject: Updating blob from command line Greetings, Is there anyway to import an image into a blob column from the command line? By like making an sql script? What I have is a database that has 4 blob columns per row that holds signature images. Every once in awhile a new signature needs to update the old signature. I need to be able to update the database with the new image through a script since it needs to be automated. Does anybody have any ideas, and can this be done? Thanks! - Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
signal 11 when SELECT DISTINCT blah FROM table LEFT JOIN blah...
Description: selecting distinct when executing a left join causes mysql to die How-To-Repeat: CREATE TABLE test1 ( i1 int(10) unsigned NOT NULL default 0, s1 varchar(30), PRIMARY KEY (i1) ); CREATE TABLE test2 ( i1 int(10) unsigned NOT NULL default 0, s1 varchar(30), PRIMARY KEY (i1) ); insert into test1 values (1,'test'); insert into test1 values (2,'test'); insert into test2 values (1,'test'); insert into test2 values (2,'test'); select distinct * from test1 t1 left join test2 t2 on (t1.i1=t2.i1); Fix: None known Submitter-Id: submitter ID Originator:Shane Allen (shane at sell dot com) Organization: sell.com MySQL support: none Synopsis: select distinct with a left join crashes mysql 4.0.3 Severity: critical Priority: low Category: mysql Class: sw-bug Release: mysql-4.0.3-beta (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.37 Distrib 4.0.3-beta, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.3-beta-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 56 sec Threads: 2 Questions: 13 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.232 Environment: System: Linux local-dbmaster-test 2.4.19 #1 SMP Mon Sep 2 15:38:05 CDT 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.1.1/specs Configured with: /mnt/data/gcc-3.1/gcc-3.1-3.1.1ds3/src/configure -v --enable-languages=c,c++,java,f77,proto,objc,ada --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-gxx-include-dir=/usr/include/c++/3.1 --enable-shared --with-system-zlib --enable-long-long --enable-nls --without-included-gettext --enable-clocale=gnu --enable-__cxa_atexit --enable-threads=posix --enable-java-gc=boehm --enable-objc-gc i386-linux Thread model: posix gcc version 3.1.1 Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jul 30 16:49 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1153784 Jul 18 06:53 /lib/libc-2.2.5.so -rw-r--r--1 root root 2390922 Jul 18 06:53 /usr/lib/libc.a -rw-r--r--1 root root 178 Jul 18 06:53 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-local-infile --with-other-libc=/usr/local/mysql-glibc-2.2.5 --prefix=/usr/local --with-extra-charsets=none --without-innodb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
default date time insertion in the database
Hi, can anyone tell me how can i set the default datetime as current datetime in the mysql. so that every time i insert a record in the table current datetime automaticall inserted. Thanks in advance. Regards Daya Krishan Dubey Core Solucomm Ltd 423 B, Hamilton court DLF phase IV Gurgaon, India Ph# 91-124-6392896/7 (O) Mobile# 91-9811294209 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 create a table from other tables
Dear all i had two tables, tableA Table B. I want to create a permanent table call Table C which the first two field will be equal to Table A's first 2 field and last field will be equal to Table B's first field. can anyone pls tell me what query should i use? it will be nice if you can provide me a simple example! Thx jack [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: transactions...
From: Dana Diederich [EMAIL PROTECTED] Date: Mon, 23 Sep 2002 09:40:45 -0500 Perhaps the InnoDB/MyISAM gurus can comment on this. I want to switch from MyISAM to Innodb, because we have database tables that have many updates, inserts, deletes and selects going on at the same time. My belief is that InnoDB's better locking semantics (as compared to MyISAM) will give me better overall performance in such a high contention environment. For example, each update won't block other updates or selects or deletes. Is this a fair assumption? Honestly, the 'other' features of InnoDB (transactions and reliability) aren't as important to me as overall speed. Setup a test system and try it. I saw the benchmarks indicating a speed improvement with innoDB and tried it within my system. My longest query program took two times longer, not exactly the desired result [I used the stock settings, perhaps tweaking might have improved that result]. However, I'm doing SELECT primarily, and the results are not surprising apparently. Try it, YMMV of course. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Wrong path for temp file
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) From: [EMAIL PROTECTED] Date: Mon, 23 Sep 2002 11:57:19 -0800 (AKDT) News-Group: list.mysql Reply-To: [EMAIL PROTECTED] Description: While trying to run this query: SELECT users_1.* FROM users AS users_1, users AS users_2 WHERE users_1.email_address = users_2.email_address AND users_1.id users_2.id ORDER BY users_1.email_address I got this error: Can't create/write to file '/root/tmp/#sql107d_bdf_2.MYI' (Errcode: 13) I know that this is a permission denied error, but the MySQL deamon is running as mysql, so it shouldn't be trying to write to /root/tmp anyway. It should be writing to /tmp Adjust the safe_mysqld file, you will find a temp setting within. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 on Red Hat Advanced Server?
Hi there, Anyone have experience (good or bad) running recent 3.23.49-or-higher MySQL releases on Red Hat Advanced Server? I'm thinking of test driving it and was wondering if anyone has seen noticeable performance improvements over 7.3 or any gotcha's to watch out for. Oddly enough, I'm sort of grasping at straws with this since I seem to have as-of-yet-unresolvable issues with IBM ServeRAID throwing scsi errors in /var/log/messages under high loads. The MySQL status line reports ~720 queries/second (on a quad-Xeon 700Mhz with 4GB memory), and the raid seems to throw errors, although it internally says its fine, for a while, until you get bad stripes and start corrupting the .MYIs. Weird thing is, IBM techs have been out multiple times to replace hardware and to insist that there's nothing wrong with any of it. Seems to be a software issue. Yeah, waay OT for this list, sorry... just ranting here because this has been going on for weeks now and I'm nearly out of ideas. :-) Anyway, if you've got any ideas, no matter how ridiculous they might sound, feel free to pitch them this way. ;) Thanks, =js - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: signal 11 when SELECT DISTINCT blah FROM table LEFT JOIN blah...
Apologies, I thought I had done a decent search to see if anyone else had reported it, but apparently my search skills are lacking, I see that it was fixed in 4.0.4. On Wed, Sep 25, 2002 at 11:34:07PM -0500, Shane Allen wrote: Description: selecting distinct when executing a left join causes mysql to die How-To-Repeat: CREATE TABLE test1 ( i1 int(10) unsigned NOT NULL default 0, s1 varchar(30), PRIMARY KEY (i1) ); CREATE TABLE test2 ( i1 int(10) unsigned NOT NULL default 0, s1 varchar(30), PRIMARY KEY (i1) ); insert into test1 values (1,'test'); insert into test1 values (2,'test'); insert into test2 values (1,'test'); insert into test2 values (2,'test'); select distinct * from test1 t1 left join test2 t2 on (t1.i1=t2.i1); Fix: None known Submitter-Id:submitter ID Originator: Shane Allen (shane at sell dot com) Organization: sell.com MySQL support: none Synopsis:select distinct with a left join crashes mysql 4.0.3 Severity:critical Priority:low Category:mysql Class: sw-bug Release: mysql-4.0.3-beta (Source distribution) Server: /usr/local/bin/mysqladmin Ver 8.37 Distrib 4.0.3-beta, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version4.0.3-beta-log Protocol version 10 ConnectionLocalhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 56 sec Threads: 2 Questions: 13 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.232 Environment: System: Linux local-dbmaster-test 2.4.19 #1 SMP Mon Sep 2 15:38:05 CDT 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/3.1.1/specs Configured with: /mnt/data/gcc-3.1/gcc-3.1-3.1.1ds3/src/configure -v --enable-languages=c,c++,java,f77,proto,objc,ada --prefix=/usr --mandir=/usr/share/man --infodir=/usr/share/info --with-gxx-include-dir=/usr/include/c++/3.1 --enable-shared --with-system-zlib --enable-long-long --enable-nls --without-included-gettext --enable-clocale=gnu --enable-__cxa_atexit --enable-threads=posix --enable-java-gc=boehm --enable-objc-gc i386-linux Thread model: posix gcc version 3.1.1 Compilation info: CC='gcc' CFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Jul 30 16:49 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1153784 Jul 18 06:53 /lib/libc-2.2.5.so -rw-r--r--1 root root 2390922 Jul 18 06:53 /usr/lib/libc.a -rw-r--r--1 root root 178 Jul 18 06:53 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-local-infile --with-other-libc=/usr/local/mysql-glibc-2.2.5 --prefix=/usr/local --with-extra-charsets=none --without-innodb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Shane Allen [EMAIL PROTECTED] sell.com : Buy Sell Anything http://www.sell.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: Win32::ODBC Question (Oracle)
hope that i don't muddy the waters here, but there's a solution for all of your data sources that doesn't require knowledge of any commands. the corereader app loads and displays the information that you want when you connect to a data source, in this case to a database. it's free as a download from http://www.corereader.com/ . i've tested it against both mysql and oracle enterprise server. others have run it against everything from mainframes to spreadsheets. you can create a library of connections in it and switch between data sources with point and click. the first time that you run it, it comes up in novice mode. change it to the proficient level in the config screen. hope that i've not wasted your time by telling you something that you don't need. Figured it out. just use the use name_of_db and you can switch to another DB. thanks. -Original Message- From: Norris, Joseph Sent: Wednesday, September 25, 2002 9:02 AM To: 'Ian Robertson'; Norris, Joseph; 'Peter van der Goes'; 'Thomas R Wyant_III'; [EMAIL PROTECTED]; 'Mysql_List (E-mail)' Subject: RE: Win32::ODBC Question (Oracle) Ian's help worked great. I have one question. How do I specify the DB? I mean in the query analyzer I can select a db from the pulldown box - is there a way to specify the db in the statements below? Thanks. -Original Message- From: Ian Robertson [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 8:50 AM To: 'Norris, Joseph'; 'Peter van der Goes'; 'Thomas R Wyant_III'; [EMAIL PROTECTED]; 'Mysql_List (E-mail)' Subject: RE: Win32::ODBC Question (Oracle) Hi, Use the following: SELECT * FROM sysobjects WHERE type='U' This will show you all of the user tables And then select * from syscolumns where ID = (select ID from sysobjects where name = 'your_tablename' and type = 'U' This should get you started! HTH Ian. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Norris, Joseph Sent: 25 September 2002 16:47 To: 'Peter van der Goes'; Thomas R Wyant_III; [EMAIL PROTECTED]; Mysql_List (E-mail) Subject: RE: Win32::ODBC Question (Oracle) This email leads to a question I have about SQL. I have been accustomed to Mysql with all of its nifty little extensions - like describe. Now I have a project with MSSQL (not because I wanted it - politics). Does any one now how to describe a table structure with standard SQL. Even more important - in Mysql there is the show tables; command which allows you to see the structure of the whole DB. Is there a way to do this in standard SQL? Thanks. -Original Message- From: Peter van der Goes [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 8:39 AM To: Thomas R Wyant_III; [EMAIL PROTECTED] Subject: Re: Win32::ODBC Question (Oracle) DESCRIBE is not a SQL command, it's a SQL+ command IIRC. The Oracle ODBC drivers don't know anything about DESCRIBE, because it's not a SQL command. (Warning - based on recollections of two years ago when I actually *worked* for a living) - Original Message - From: Thomas R Wyant_III [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 8:45 AM Subject: Re: Win32::ODBC Question (Oracle) [EMAIL PROTECTED] wrote: I'm trying to get Information about a spezific table in an Oracle with the command 'describe table_name; ' This command works within SQL-PLus and other Tools but I get the error message: Ora-00900: invalid SQL statement when I use it within a perl-script using a Win32::ODBC connection. Does someone know a solution , maybe to use a DBD, DBI module or a different statement to get information about the table definition? You don't say what information you want about the table. If you want to know what columns are in the table, and what data types are in the columns, you perform a select against the table, and then pull the data out of the selection results. If you don't want any data at this point, the usual dodge is to specify a where clause that is never satisfied. In fact, the usual dodge is select * from your_table where 1 = 0 I don't know of any better way under DBI, but you need to know less about your data types if you use DBI, because it supports placeholders. So instead of generating the entire text of a query, and worrying about whether values need to be quoted, and if so how to escape any embedded quotes, you just put a question mark in the query, and provide the value when the query is executed. Tom Wyant This communication is for use by the intended recipient and contains information that may be privileged, confidential or copyrighted under applicable law. If you are not the intended recipient, you are hereby formally notified that any use, copying or distribution of this e-mail, in whole or in part, is
How to compile MySql with BDB package = no BDB build directory?
Description: Compile MySql with BDB installed as a system package with no build directory. MySql configure and compile insist on building the included BDB which is not wanted as the system BDB package contains a more recent version of Berkeley DB. Adding BDB include and library directories and setting with-bdb = yes (as there is no build directory) works to get configure to accept installed include and library files. How-To-Repeat: Recompile MySql. Fix: Good question. Submitter-Id: submitter ID Originator:J.D. Organization: MySQL support: none Synopsis: Can't compile without included BDB Severity: serious Priority: medium Category: mysql Class: sw-bug Release: mysql-4.0.3-beta (Official MySQL source) Environment: System: FreeBSD ws180163.56kdialup.siu.edu 4.6-RELEASE FreeBSD 4.6-RELEASE #3: Sat Jul 20 04:01:32 CDT 2002 [EMAIL PROTECTED]:/usr/src/sys/compile/XSYSTEM i386 Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.3 20010315 (release) [FreeBSD] Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer' CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -r--r--r-- 1 root wheel 132 Jun 11 04:18 /usr/lib/libc.a lrwxrwxrwx 1 root wheel 9 Jul 2 03:07 /usr/lib/libc.so - libc.so.4 -r--r--r-- 1 root wheel 579412 Jun 11 04:18 /usr/lib/libc.so.4 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-local-infile --enable-assembler --with-named-z-libs=not-used --disable-shared 'CFLAGS=-O3 -fno-omit-frame-pointer' CXX=gcc CC=gcc 'CXXFLAGS=-O3 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Character Set Settings
Dear support I am trying to write data in the database in ISO-8859-7 character set. My Questions are: 1) How do I configure MySQL to support this character set? 2) I am using PHP to get these infornation from the database. Do I have to do something in my code to read teh data? Thenks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Character Set Settings
Dear George, I use to have problems with Greek Chars and after hundreds of hours of testing i can assure you that the only solution is to compile Mysql using as default char-set the Greek char-set. Thus if your are using mysql for Linux you have to add to the .configure parameters the following:(`--with-charset=greek' , '--with-extra-charset=greek'). Also if you have problems viewing greek characters from within a PHP page maybe you have to define the correct encoding for the specific page. At 10:09 AM 9/25/2002 +0300, you wrote: Dear support I am trying to write data in the database in ISO-8859-7 character set. My Questions are: 1) How do I configure MySQL to support this character set? 2) I am using PHP to get these infornation from the database. Do I have to do something in my code to read teh data? Thenks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] iTEL LTD 409 Vouliagmenis Ave. Ilioupoli, 16346 Tel: +30 10 9790050 Fax: +30 10 9790051 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyISAM / Performance / Nb of table per DataBase
DB I found my problem and why Mysql lock my table for a select. In DB fact, mysql sometimes don't use the right index and so does a 'Table DB sort' that lock my table. I modify the query to add USE INDEX DB clause and now, all seems to work well ... I just need to test DB during several days to be sure that's i'm right .. JZ Did you first try an ANALYZE TABLE to update the optimizer stats? Yes ... I'm still having problem in fact, my search query is faster but also lock my table. But it's just a select :( I'm doing TCP connections to mysql and not localhost, perhaps the problem is here ... The network is ok and my app server is linking with the mysql server over a 100Mb LAN. The network have been tested and tested and all is well. I've given a try to fulltext index, not really better in query time processing but indeces have gone bigger drasticully ... Now, i should give a try to InnoDb. And i 'll also try to split my MyISAM table into smaller ones ... Thanks to all 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
RE: Character Set Settings
Dear Nikos I run the below --defult-character-set=ISO-8859-7 and when I insert into the database like insert into test values('ÄÕÏ'); when I select: mysql select * from test - ; +--+ | data | +--+ | åíá | | ÅÍÁ | | ÄÕÏ | | äõï | +--+ 4 rows in set (0.04 sec) but the problem is in the Explorer pages where I get $%#$#$# Any ideas, I work in Win200 system. George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: Character Set Settings Dear George, I use to have problems with Greek Chars and after hundreds of hours of testing i can assure you that the only solution is to compile Mysql using as default char-set the Greek char-set. Thus if your are using mysql for Linux you have to add to the .configure parameters the following:(`--with-charset=greek' , '--with-extra-charset=greek'). Also if you have problems viewing greek characters from within a PHP page maybe you have to define the correct encoding for the specific page. At 10:09 AM 9/25/2002 +0300, you wrote: Dear support I am trying to write data in the database in ISO-8859-7 character set. My Questions are: 1) How do I configure MySQL to support this character set? 2) I am using PHP to get these infornation from the database. Do I have to do something in my code to read teh data? Thenks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] iTEL LTD 409 Vouliagmenis Ave. Ilioupoli, 16346 Tel: +30 10 9790050 Fax: +30 10 9790051 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
installing mysql together with application
Hello I want to distribute my java database application together with mysql, and I want to make it as easy as possible. Right now a new user has to: - download and install mysql - run the mysql server with mysqld --standalone or a similar command - download my program and run it. To make this easier for the user, I tried to zip mysql together with my program (the whole c:\mysql directory except the data directory), and to issue the mysqld --standalone command each time the user starts my program, but it doesn't work (it would be too easy, wouldn't it?). When I try that, see below for the errors that appear in mysql.err: I want my program in a single zip file, and that you only have to unzip it, type setup and then run to make it work. Is there a better way to achieve this? It only has to work under Windows (I am assuming here that linux users are smart enough to set up mysql by themselves) thanks in advance Martijn van Iersel Here are the errors I get: Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 020925 10:19:34 bin\mysqld: Table 'mysql.host' doesn't exist Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 020925 10:20:05 bin\mysqld: Table 'mysql.host' doesn't exist __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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: MySQL as a desktop DB
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 | I currently use MS Access as a single-user desktop database. The database is | getting quite large. The largest table has 300,000 rows. Definately a case when an upgrade would help, but maybe it's not essential. We used to use a system here that maintained all its data in a shared access database on a winnt server box. It needed constant maintenance but i think we pushed to mdb up to about 700mb before it finally exploded ;-) | I am considering upgrading the database. How suitable is MySQL as a | single-user desktop database? How does it compare to Access when it is used | like this? Very suitable. Simmilar to Brian in his previous post I use MySQL as a desktop db under Linux. The MyODBC connector also provides a good way of accessing data through other applications. When the old system exploded, we initially moved all the data to a MySQL database and then used the old front end by linking the tables into a dummy access db through MyODBC! | Obviously MySQL would have advantages if I intended to use it as a server | database with concurrent users. But is it faster than Access in the | single-user environment, when dealing with large databases? Depends on your hardware, but in the MySQL world 300,000 records is considered small. Either way, i think you'll get a lot more performance out of MySQL on a single user system than access. HTH danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9kWo3UKf+497XC3QRAhYyAJ4zv1bJiPXHA7G2uheSoJ61ANW7zQCgi+Fu /X8BthNnRHBASz/RgTHPg0Q= =SuSt -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
OT Re: Mysql, PHP and a wrapper
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 OT Filter: query , sql Hi Brian, | I'm running apache-1.3.23-14 on a redhat 7.3 system. | I have installed the php-rpm and the php_mysql.rpm from Redhat. | installed php-4.1.2-7.3.4 and php-mysql-4.1.2-7.3.4. | | Cannot connect to my mysql-3.23.49-3 database. | | If I use mysql_connect() only, I get Fatal error: Call to undefined | function: mysql_connect() in /var/www/html/admin.php on line 9 I had massive problems with the redhat php rpm's.. get the source from the php homepage and include the option '--with-mysql' in the './configure' arguments. HTH danny - -- Danny Haworth =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Ge2 System Administrator Gas~Elec Safety Systems Tel : 01895 422 997 Email : [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE9kWukUKf+497XC3QRAhU6AJ0eK4hnb8ARkJ1QJHTLg24mN5nV2gCeJl4M Bbd+8gXfFtsDpu2HCu/DgjI= =ZBdO -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Character Set Settings
Check out this article in MSDN: http://msdn.microsoft.com/library/default.asp?url=/workshop/author/dhtml /reference/charsets/charset4.asp It describes how to set the character set for Internet Explorer. I'm not sure of an equivalent for Netscape, but I assume there is one... Dean Harding. -Original Message- From: Nikoloudis George ([EMAIL PROTECTED]) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 25 September 2002 5:54 pm To: Nikolaos Georgiafentis Cc: [EMAIL PROTECTED] Subject: RE: Character Set Settings Dear Nikos I run the below --defult-character-set=ISO-8859-7 and when I insert into the database like insert into test values(''); when I select: mysql select * from test - ; +--+ | data | +--+ | | | | | | | | +--+ 4 rows in set (0.04 sec) but the problem is in the Explorer pages where I get $%#$#$# Any ideas, I work in Win200 system. George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: , 25 2002 10:41 To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: Character Set Settings Dear George, I use to have problems with Greek Chars and after hundreds of hours of testing i can assure you that the only solution is to compile Mysql using as default char-set the Greek char-set. Thus if your are using mysql for Linux you have to add to the .configure parameters the following:(`--with-charset=greek' , '--with-extra-charset=greek'). Also if you have problems viewing greek characters from within a PHP page maybe you have to define the correct encoding for the specific page. At 10:09 AM 9/25/2002 +0300, you wrote: Dear support I am trying to write data in the database in ISO-8859-7 character set. My Questions are: 1) How do I configure MySQL to support this character set? 2) I am using PHP to get these infornation from the database. Do I have to do something in my code to read teh data? Thenks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] iTEL LTD 409 Vouliagmenis Ave. Ilioupoli, 16346 Tel: +30 10 9790050 Fax: +30 10 9790051 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [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: Character Set Settings
What you mean by explorer pages? Browser? If so you have to set the correct character set at the beginning of each place, whether asp, jsp, php or html. regards - Original Message - From: [EMAIL PROTECTED] To: Nikolaos Georgiafentis [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 4:54 PM Subject: RE: Character Set Settings Dear Nikos I run the below --defult-character-set=ISO-8859-7 and when I insert into the database like insert into test values('ÄÕÏ'); when I select: mysql select * from test - ; +--+ | data | +--+ | åíá | | ÅÍÁ | | ÄÕÏ | | äõï | +--+ 4 rows in set (0.04 sec) but the problem is in the Explorer pages where I get $%#$#$# Any ideas, I work in Win200 system. George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: Character Set Settings Dear George, I use to have problems with Greek Chars and after hundreds of hours of testing i can assure you that the only solution is to compile Mysql using as default char-set the Greek char-set. Thus if your are using mysql for Linux you have to add to the .configure parameters the following:(`--with-charset=greek' , '--with-extra-charset=greek'). Also if you have problems viewing greek characters from within a PHP page maybe you have to define the correct encoding for the specific page. At 10:09 AM 9/25/2002 +0300, you wrote: Dear support I am trying to write data in the database in ISO-8859-7 character set. My Questions are: 1) How do I configure MySQL to support this character set? 2) I am using PHP to get these infornation from the database. Do I have to do something in my code to read teh data? Thenks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] iTEL LTD 409 Vouliagmenis Ave. Ilioupoli, 16346 Tel: +30 10 9790050 Fax: +30 10 9790051 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Character Set Settings
No In the explorere I can see Greek when I do the same with asp and access db. George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: kayamboo [mailto:[EMAIL PROTECTED]] Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 11:08 ðì To: [EMAIL PROTECTED] Cc: list mysql Subject: Re: Character Set Settings What you mean by explorer pages? Browser? If so you have to set the correct character set at the beginning of each place, whether asp, jsp, php or html. regards - Original Message - From: [EMAIL PROTECTED] To: Nikolaos Georgiafentis [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 4:54 PM Subject: RE: Character Set Settings Dear Nikos I run the below --defult-character-set=ISO-8859-7 and when I insert into the database like insert into test values('ÄÕÏ'); when I select: mysql select * from test - ; +--+ | data | +--+ | åíá | | ÅÍÁ | | ÄÕÏ | | äõï | +--+ 4 rows in set (0.04 sec) but the problem is in the Explorer pages where I get $%#$#$# Any ideas, I work in Win200 system. George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: Character Set Settings Dear George, I use to have problems with Greek Chars and after hundreds of hours of testing i can assure you that the only solution is to compile Mysql using as default char-set the Greek char-set. Thus if your are using mysql for Linux you have to add to the .configure parameters the following:(`--with-charset=greek' , '--with-extra-charset=greek'). Also if you have problems viewing greek characters from within a PHP page maybe you have to define the correct encoding for the specific page. At 10:09 AM 9/25/2002 +0300, you wrote: Dear support I am trying to write data in the database in ISO-8859-7 character set. My Questions are: 1) How do I configure MySQL to support this character set? 2) I am using PHP to get these infornation from the database. Do I have to do something in my code to read teh data? Thenks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] iTEL LTD 409 Vouliagmenis Ave. Ilioupoli, 16346 Tel: +30 10 9790050 Fax: +30 10 9790051 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Character Set Settings
Fear George, try putting 'META HTTP-EQUIV=Content-Type CONTENT=text/html;charset=iso-8859-7' in the header section of your page. Keep me informed At 10:54 AM 9/25/2002 +0300, you wrote: Dear Nikos I run the below --defult-character-set=ISO-8859-7 and when I insert into the database like insert into test values('ÄÕÏ'); when I select: mysql select * from test - ; +--+ | data | +--+ | åíá | | ÅÍÁ | | ÄÕÏ | | äõï | +--+ 4 rows in set (0.04 sec) but the problem is in the Explorer pages where I get $%#$#$# Any ideas, I work in Win200 system. George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: Character Set Settings Dear George, I use to have problems with Greek Chars and after hundreds of hours of testing i can assure you that the only solution is to compile Mysql using as default char-set the Greek char-set. Thus if your are using mysql for Linux you have to add to the .configure parameters the following:(`--with-charset=greek' , '--with-extra-charset=greek'). Also if you have problems viewing greek characters from within a PHP page maybe you have to define the correct encoding for the specific page. At 10:09 AM 9/25/2002 +0300, you wrote: Dear support I am trying to write data in the database in ISO-8859-7 character set. My Questions are: 1) How do I configure MySQL to support this character set? 2) I am using PHP to get these infornation from the database. Do I have to do something in my code to read teh data? Thenks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] iTEL LTD 409 Vouliagmenis Ave. Ilioupoli, 16346 Tel: +30 10 9790050 Fax: +30 10 9790051 Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] iTEL LTD 409 Vouliagmenis Ave. Ilioupoli, 16346 Tel: +30 10 9790050 Fax: +30 10 9790051 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: installing mysql together with application
It is obvious, even in windows you have to set the configuration files atleast. It is the privilege of the user to install the stuff anywhere in his computer and so he has to change the .inf or .cnf accordingly Why not you try onething called the embedded mysql. If you just want to go with your way, better make one more program in java to get the installation directory as input from the user and accordingly change the configuration files and put them in winnt/ or windows/ regards - Original Message - From: Martijn van Iersel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 4:45 PM Subject: installing mysql together with application Hello I want to distribute my java database application together with mysql, and I want to make it as easy as possible. Right now a new user has to: - download and install mysql - run the mysql server with mysqld --standalone or a similar command - download my program and run it. To make this easier for the user, I tried to zip mysql together with my program (the whole c:\mysql directory except the data directory), and to issue the mysqld --standalone command each time the user starts my program, but it doesn't work (it would be too easy, wouldn't it?). When I try that, see below for the errors that appear in mysql.err: I want my program in a single zip file, and that you only have to unzip it, type setup and then run to make it work. Is there a better way to achieve this? It only has to work under Windows (I am assuming here that linux users are smart enough to set up mysql by themselves) thanks in advance Martijn van Iersel Here are the errors I get: Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 020925 10:19:34 bin\mysqld: Table 'mysql.host' doesn't exist Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do not want to use transactional InnoDB tables, add a line skip-innodb to the [mysqld] section of init parameters in your my.cnf or my.ini. If you want to use InnoDB tables, add for example, innodb_data_file_path = ibdata1:30M But to get good performance you should adjust for your hardware the InnoDB startup options listed in section 2 at http://www.innodb.com/ibman.html 020925 10:20:05 bin\mysqld: Table 'mysql.host' doesn't exist __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Character Set Settings
Dear Nikos I did that I nothing. I am sending you also the php script I run: meta http-equiv=Content-Type content=text/html; charset=greek8 ?php /* Connecting, selecting database */ $link = mysql_connect(localhost, test, ) or die(Could not connect); print Connected successfully; mysql_select_db(mysql) or die(Could not select database); /* Performing SQL query */ $query = SELECT * FROM test; $result = mysql_query($query) or die(Query failed); /* Printing results in HTML */ ? table ?php while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { ? tr ?php foreach ($line as $col_value) {? td ?php print $col_value; }? /td /tr ?php } ? /table /* Free resultset */ ?php mysql_free_result($result); /* Closing connection */ mysql_close($link); ? George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 11:33 πμ To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: RE: Character Set Settings Fear George, try putting 'META HTTP-EQUIV=Content-Type CONTENT=text/html;charset=iso-8859-7' in the header section of your page. Keep me informed At 10:54 AM 9/25/2002 +0300, you wrote: Dear Nikos I run the below --defult-character-set=ISO-8859-7 and when I insert into the database like insert into test values('ÄÕÏ'); when I select: mysql select * from test - ; +--+ | data | +--+ | åíá | | ÅÍÁ | | ÄÕÏ | | äõï | +--+ 4 rows in set (0.04 sec) but the problem is in the Explorer pages where I get $%#$#$# Any ideas, I work in Win200 system. George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: Character Set Settings Dear George, I use to have problems with Greek Chars and after hundreds of hours of testing i can assure you that the only solution is to compile Mysql using as default char-set the Greek char-set. Thus if your are using mysql for Linux you have to add to the .configure parameters the following:(`--with-charset=greek' , '--with-extra-charset=greek'). Also if you have problems viewing greek characters from within a PHP page maybe you have to define the correct encoding for the specific page. At 10:09 AM 9/25/2002 +0300, you wrote: Dear support I am trying to write data in the database in ISO-8859-7 character set. My Questions are: 1) How do I configure MySQL to support this character set? 2) I am using PHP to get these infornation from the database. Do I have to do something in my code to read teh data? Thenks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] iTEL LTD 409 Vouliagmenis Ave. Ilioupoli, 16346 Tel: +30 10 9790050 Fax: +30 10 9790051 Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] iTEL LTD 409 Vouliagmenis Ave. Ilioupoli, 16346 Tel: +30 10 9790050 Fax: +30 10 9790051 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Not able to insert data
I have installed MySQL 3.23.47 in a Windows 98 machine and created a a table count. I have installed Apache Server on 98 machine and try to execute the following PHP script to insert the data. I was not able to post the data and got an error Method Not Allowed The requested method POST is not allowed for the URL /bangla/count/entry.php. Apache/1.3.26 Server at vinod.com Port 80 THE SCRIPT WHICH I HAD WRITTEN IS ?php mysql_connect(localhost,root,vinodb)or die(could not connect); mysql_select_db(bangla)or die(could not select database);? $query=insert into count (count)values ( 30); mysql_query($query) or die(mysql_error());? This script works fine with MySQL and Appache in a Linux machine. Please suggest me how to solve the problem Regards, Vinod. - Sify Mail - now with Anti-virus protection powered by Trend Micro, USA. Know more at http://mail.sify.com Want to get into IIM? Take the Sify Mock CAT now! http://education.sify.com/mockcat - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
choosing datadir from create-statement
Hello , i have version 3.23.52 Why CREATE TABLE user4( id INTEGER , passwort VARCHAR(10) ) DATA directory=/usr/local/mysql/data/test; doesent works (Syntax Error : because of DATA ..) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Create Tables Dynamically
Hello William, Tuesday, September 24, 2002, 9:56:49 AM, you wrote: William, don't send me your questions in private mail. We provide support in public list. For commercial support, go to https://order.mysql.com/. WM Thank you for your responses. How do I delete a table if I do not need to WM use it anymore?? DROP TABLE helps you :-) http://www.mysql.com/doc/en/DROP_TABLE.html WM - Original Message - WM From: Victoria Reznichenko [EMAIL PROTECTED] WM To: [EMAIL PROTECTED] WM Sent: Tuesday, September 24, 2002 10:34 AM WM Subject: re: Create Tables Dynamically William, Tuesday, September 24, 2002, 4:52:54 AM, you wrote: WM I am building a web robot in perl that will find equipment from WM various WM manufacturers and will get information about that equipments WM specifications. WM Can you build tables in MySQL 4.0 dynamically with some type of WM script. WM Example. If if have 10 parts in my database and my robot checks with WM the WM manufacturers for new parts everyday. One day the robot says yes I WM found a WM new part that is not in our database. Can I write a script that will WM build WM a table in mySQL and will load the appropriate information. Sure, you can do it with CREATE TABLE statement: http://www.mysql.com/doc/en/CREATE_TABLE.html Don't forget that that user must have CREATE privilege on the database to do it. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: Character Set Settings
Dear Gorge, the page you have sent me is included in an other page? If is not then try to put also all the required html tags (i.e HEAD,BODY etc.) If it is then try to put the correct page encoding in the main page that includes the page you have sent me. At 11:48 AM 9/25/2002 +0300, you wrote: Dear Nikos I did that I nothing. I am sending you also the php script I run: meta http-equiv=Content-Type content=text/html; charset=greek8 ?php /* Connecting, selecting database */ $link = mysql_connect(localhost, test, ) or die(Could not connect); print Connected successfully; mysql_select_db(mysql) or die(Could not select database); /* Performing SQL query */ $query = SELECT * FROM test; $result = mysql_query($query) or die(Query failed); /* Printing results in HTML */ ? table ?php while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { ? tr ?php foreach ($line as $col_value) {? td ?php print $col_value; }? /td /tr ?php } ? /table /* Free resultset */ ?php mysql_free_result($result); /* Closing connection */ mysql_close($link); ? George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 11:33 πμ To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: RE: Character Set Settings Fear George, try putting 'META HTTP-EQUIV=Content-Type CONTENT=text/html;charset=iso-8859-7' in the header section of your page. Keep me informed At 10:54 AM 9/25/2002 +0300, you wrote: Dear Nikos I run the below --defult-character-set=ISO-8859-7 and when I insert into the database like insert into test values('ÄÕÏ'); when I select: mysql select * from test - ; +--+ | data | +--+ | åíá | | ÅÍÁ | | ÄÕÏ | | äõï | +--+ 4 rows in set (0.04 sec) but the problem is in the Explorer pages where I get $%#$#$# Any ideas, I work in Win200 system. George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: Character Set Settings Dear George, I use to have problems with Greek Chars and after hundreds of hours of testing i can assure you that the only solution is to compile Mysql using as default char-set the Greek char-set. Thus if your are using mysql for Linux you have to add to the .configure parameters the following:(`--with-charset=greek' , '--with-extra-charset=greek'). Also if you have problems viewing greek characters from within a PHP page maybe you have to define the correct encoding for the specific page. At 10:09 AM 9/25/2002 +0300, you wrote: Dear support I am trying to write data in the database in ISO-8859-7 character set. My Questions are: 1) How do I configure MySQL to support this character set? 2) I am using PHP to get these infornation from the database. Do I have to do something in my code to read teh data? Thenks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] iTEL LTD 409 Vouliagmenis Ave. Ilioupoli, 16346 Tel: +30 10 9790050 Fax: +30 10 9790051 Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] iTEL LTD 409 Vouliagmenis Ave. Ilioupoli, 16346 Tel: +30 10 9790050 Fax: +30 10 9790051 Georgiafentis Nikolaos Project Manager [EMAIL PROTECTED] mailto:[EMAIL
RE: RE: Character Set Settings
Dear Nikos The charset is ISO_8859-7 not greek8 In you system the greeks work fine? George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 12:19 μμ To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Character Set Settings Dear Gorge, the page you have sent me is included in an other page? If is not then try to put also all the required html tags (i.e HEAD,BODY etc.) If it is then try to put the correct page encoding in the main page that includes the page you have sent me. At 11:48 AM 9/25/2002 +0300, you wrote: Dear Nikos I did that I nothing. I am sending you also the php script I run: meta http-equiv=Content-Type content=text/html; charset=greek8 ?php /* Connecting, selecting database */ $link = mysql_connect(localhost, test, ) or die(Could not connect); print Connected successfully; mysql_select_db(mysql) or die(Could not select database); /* Performing SQL query */ $query = SELECT * FROM test; $result = mysql_query($query) or die(Query failed); /* Printing results in HTML */ ? table ?php while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { ? tr ?php foreach ($line as $col_value) {? td ?php print $col_value; }? /td /tr ?php } ? /table /* Free resultset */ ?php mysql_free_result($result); /* Closing connection */ mysql_close($link); ? George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ΤετάÏτη, 25 ΣεπτεμβÏίου 2002 11:33 πμ To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: RE: Character Set Settings Fear George, try putting 'META HTTP-EQUIV=Content-Type CONTENT=text/html;charset=iso-8859-7' in the header section of your page. Keep me informed At 10:54 AM 9/25/2002 +0300, you wrote: Dear Nikos I run the below --defult-character-set=ISO-8859-7 and when I insert into the database like insert into test values('ÄÕÃ'); when I select: mysql select * from test - ; +--+ | data | +--+ | Ã¥Ãá | | Ã…Ãà | | ÄÕà | | äõï | +--+ 4 rows in set (0.04 sec) but the problem is in the Explorer pages where I get $%#$#$# Any ideas, I work in Win200 system. George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: Character Set Settings Dear George, I use to have problems with Greek Chars and after hundreds of hours of testing i can assure you that the only solution is to compile Mysql using as default char-set the Greek char-set. Thus if your are using mysql for Linux you have to add to the .configure parameters the following:(`--with-charset=greek' , '--with-extra-charset=greek'). Also if you have problems viewing greek characters from within a PHP page maybe you have to define the correct encoding for the specific page. At 10:09 AM 9/25/2002 +0300, you wrote: Dear support I am trying to write data in the database in ISO-8859-7 character set. My Questions are: 1) How do I configure MySQL to support this character set? 2) I am using PHP to get these infornation from the database. Do I have to do something in my code to read teh data? Thenks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/
re: choosing datadir from create-statement
Hussein, Wednesday, September 25, 2002, 11:42:00 AM, you wrote: HM i have version 3.23.52 HM Why HM CREATE TABLE user4( HM id INTEGER , HM passwort VARCHAR(10) HM ) DATA directory=/usr/local/mysql/data/test; HM doesent works (Syntax Error : because of DATA ..) It works only in 4.0 branch and only for MyISAM tables: http://www.mysql.com/doc/en/CREATE_TABLE.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: RE: Character Set Settings
Sorry the correct charset is ISO_8859-7. Is the problem resolved? At 12:45 PM 9/25/2002 +0300, you wrote: Dear Nikos The charset is ISO_8859-7 not greek8 In you system the greeks work fine? George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 12:19 μμ To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Character Set Settings Dear Gorge, the page you have sent me is included in an other page? If is not then try to put also all the required html tags (i.e HEAD,BODY etc.) If it is then try to put the correct page encoding in the main page that includes the page you have sent me. At 11:48 AM 9/25/2002 +0300, you wrote: Dear Nikos I did that I nothing. I am sending you also the php script I run: meta http-equiv=Content-Type content=text/html; charset=greek8 ?php /* Connecting, selecting database */ $link = mysql_connect(localhost, test, ) or die(Could not connect); print Connected successfully; mysql_select_db(mysql) or die(Could not select database); /* Performing SQL query */ $query = SELECT * FROM test; $result = mysql_query($query) or die(Query failed); /* Printing results in HTML */ ? table ?php while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { ? tr ?php foreach ($line as $col_value) {? td ?php print $col_value; }? /td /tr ?php } ? /table /* Free resultset */ ?php mysql_free_result($result); /* Closing connection */ mysql_close($link); ? George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ΤετάÏτη, 25 ΣεπτεμβÏίου 2002 11:33 πμ To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: RE: Character Set Settings Fear George, try putting 'META HTTP-EQUIV=Content-Type CONTENT=text/html;charset=iso-8859-7' in the header section of your page. Keep me informed At 10:54 AM 9/25/2002 +0300, you wrote: Dear Nikos I run the below --defult-character-set=ISO-8859-7 and when I insert into the database like insert into test values('ÄÕÃ'); when I select: mysql select * from test - ; +--+ | data | +--+ | Ã¥Ãá | | Ã…Ãà | | ÄÕà | | äõï | +--+ 4 rows in set (0.04 sec) but the problem is in the Explorer pages where I get $%#$#$# Any ideas, I work in Win200 system. George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ÔåôÜñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: Character Set Settings Dear George, I use to have problems with Greek Chars and after hundreds of hours of testing i can assure you that the only solution is to compile Mysql using as default char-set the Greek char-set. Thus if your are using mysql for Linux you have to add to the .configure parameters the following:(`--with-charset=greek' , '--with-extra-charset=greek'). Also if you have problems viewing greek characters from within a PHP page maybe you have to define the correct encoding for the specific page. At 10:09 AM 9/25/2002 +0300, you wrote: Dear support I am trying to write data in the database in ISO-8859-7 character set. My Questions are: 1) How do I configure MySQL to support this character set? 2) I am using PHP to get these infornation from the database. Do I have to do something in my code to read teh data? Thenks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece
Re: Not able to insert data
VINOD wrote: I have installed MySQL 3.23.47 in a Windows 98 machine and created a a table count. I have installed Apache Server on 98 machine and try to execute the following PHP script to insert the data. I was not able to post the data and got an error Method Not Allowed The requested method POST is not allowed for the URL /bangla/count/entry.php. Apache/1.3.26 Server at vinod.com Port 80 THE SCRIPT WHICH I HAD WRITTEN IS ?php mysql_connect(localhost,root,vinodb)or die(could not connect); mysql_select_db(bangla)or die(could not select database);? $query=insert into count (count)values (30); mysql_query($query) or die(mysql_error());? This script works fine with MySQL and Appache in a Linux machine. Please suggest me how to solve the problem Regards, Vinod. This error is not related to MySQL; it is an Apache error. You should review your Apache configuration. If this script is the first you are trying on this machine, you should make sure you don't have problems with your Apache/PHP setup with a simple PHP script first. Regards, -- Joseph Bueno NetClub - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: save meeeeeeeeee
antispam, Tuesday, September 24, 2002, 8:30:35 PM, you wrote: aafdn I dont know what exactly happened but suddenly one tables just went back 10 days.. it only has 10 days back information.. please help me.. what happened with mysql ?? how can i retrieve those aafdn information... I also don't know what _exactly_ happened with your table, but I'm sure MySQL can't delete data by itself. There are a lot of possible causes, like somebody deleted data from the table, or restore table from backup that was made 10 days ago, or somebody runs MySQL server with another datadir that contains old table and so on ... If logs is turned on, check it if there was any DELETE on this table. Do you make table backups? If so, restore table from last backup. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: UPDATE help
Steven, Tuesday, September 24, 2002, 7:03:15 PM, you wrote: SK I am currently working on a table that has a column called state and a SK column called stateid. All 42,000 records in this table have a 2 Letter SK abbreviation for that state (NY, CA, NV, etc) however. To eliminate SK redundancy, I have move the states to another table that contains an SK AUTO_INCREMENT field, the state abbr and the state name. A typical SK record looks like this 1,NY,New York SK I want to remove the city.state column from the and populate the SK city.stateid with values from state.id SK Does anyone have any ideas on how to build an UPDATE statement that SK will SELECT id FROM state WHERE state = city.state? First multi-table UPDATEs were implemented in 4.0.2 If you use other versions that 4.0.2/4.0.3 you can't do it with single SQL statement. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: RE: RE: Character Set Settings
Nothing I did it. I will try to install againthe PHP. I will come back. Thanks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 12:58 μμ To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: RE: RE: Character Set Settings Sorry the correct charset is ISO_8859-7. Is the problem resolved? At 12:45 PM 9/25/2002 +0300, you wrote: Dear Nikos The charset is ISO_8859-7 not greek8 In you system the greeks work fine? George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ΤετάÏτη, 25 ΣεπτεμβÏίου 2002 12:19 μμ To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Character Set Settings Dear Gorge, the page you have sent me is included in an other page? If is not then try to put also all the required html tags (i.e HEAD,BODY etc.) If it is then try to put the correct page encoding in the main page that includes the page you have sent me. At 11:48 AM 9/25/2002 +0300, you wrote: Dear Nikos I did that I nothing. I am sending you also the php script I run: meta http-equiv=Content-Type content=text/html; charset=greek8 ?php /* Connecting, selecting database */ $link = mysql_connect(localhost, test, ) or die(Could not connect); print Connected successfully; mysql_select_db(mysql) or die(Could not select database); /* Performing SQL query */ $query = SELECT * FROM test; $result = mysql_query($query) or die(Query failed); /* Printing results in HTML */ ? table ?php while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { ? tr ?php foreach ($line as $col_value) {? td ?php print $col_value; }? /td /tr ?php } ? /table /* Free resultset */ ?php mysql_free_result($result); /* Closing connection */ mysql_close($link); ? George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ΤεÄάÃÂÄη, 25 ΣεÀÄεμβÃÂίοÃ… 2002 11:33 Àμ To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: RE: Character Set Settings Fear George, try putting 'META HTTP-EQUIV=Content-Type CONTENT=text/html;charset=iso-8859-7' in the header section of your page. Keep me informed At 10:54 AM 9/25/2002 +0300, you wrote: Dear Nikos I run the below --defult-character-set=ISO-8859-7 and when I insert into the database like insert into test values('ÄÕÃÂ'); when I select: mysql select * from test - ; +--+ | data | +--+ | Ã¥ÃÂá | | Ã…ÃÂà| | ÄÕà| | äõï | +--+ 4 rows in set (0.04 sec) but the problem is in the Explorer pages where I get $%#$#$# Any ideas, I work in Win200 system. George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: Ãâ€ÃƒÂ¥ÃƒÂ´ÃƒÅ“ñôç, 25 Óåðôåìâñßïõ 2002 10:41 ðì To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: Character Set Settings Dear George, I use to have problems with Greek Chars and after hundreds of hours of testing i can assure you that the only solution is to compile Mysql using as default char-set the Greek char-set. Thus if your are using mysql for Linux you have to add to the .configure parameters the following:(`--with-charset=greek' , '--with-extra-charset=greek'). Also if you have problems
REPAIR TABLE
Please help me alter table: ___ | | CREATE TABLE `f_ivairus_bodies` ( `id` int(11) NOT NULL default '0', `body` text NOT NULL, `thread` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `thread` (`thread`) ) TYPE=ISAM PACK_KEYS=1 |___| On: mysqlalter table f_ivairus_bodies TYPE = MYISAM; I have an error : mysqlERROR 1062: Duplicate entry '1867' for key 1 Thanks very much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ALTER TABLE
Please help me alter table: ___ | | CREATE TABLE `f_ivairus_bodies` ( `id` int(11) NOT NULL default '0', `body` text NOT NULL, `thread` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `thread` (`thread`) ) TYPE=ISAM PACK_KEYS=1 |___| On: mysqlalter table f_ivairus_bodies TYPE = MYISAM; I have an error : mysqlERROR 1062: Duplicate entry '1867' for key 1 Thanks very much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 data local infile' works on command line, but fails in php scripts
I'm having problems with php scripts that use 'LOAD DATA LOCAL INFILE'. Each time I run a script, I get an error in the server log saying MySQL query failed: LOAD DATA LOCAL INFILE : The used command is not allowed with this MySQL version. We're using php version 4.1.2 and MySQL 3.23.49, both installed using RedHat (7.3) package managers. MySQL wasn't explicitly configured using '--enable-local-infile' at installation. I've tried including 'local-infile=1' in the my.cnf file under [mysql], [mysqld], [mysql.server] etc., and this has enabled use of 'load data local infile' from the command line, but still not in php scripts. Removing the word LOCAL from the php scripts results in a different error - I get a message saying that access is denied for the user instead. I would be very grateful to hear from anyone who knows how to get round this problem. Regards, Stephen - Stephen Park Dept. Clinical Pharmacology, Royal College of Surgeons in Ireland 25 St. Stephen's Green, Dublin 2, Ireland E-mail: [EMAIL PROTECTED] Web:http://www.sdepark.net/ Tel:+353 (0)1 240 9515 Fax:+353 (0)1 240 9516 - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ALTER TABLE
Please help me alter table: ___ | | CREATE TABLE `f_ivairus_bodies` ( `id` int(11) NOT NULL default '0', `body` text NOT NULL, `thread` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `thread` (`thread`) ) TYPE=ISAM PACK_KEYS=1 |___| On: mysqlalter table f_ivairus_bodies TYPE = MYISAM; I have an error : mysqlERROR 1062: Duplicate entry '1867' for key 1 Thanks very much. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
make install problems
Hi mysql people, I am trying to install mysql on SuSE-8 from source. everything goes fine untill make install. It then exists with the following errors: make[2]: *** [install-benchSCRIPTS] Error 1 make[2]: Leaving directory `/usr/local/mysql-3.23.52/sql-bench' make[1]: *** [install-am] Error 2 make[1]: Leaving directory `/usr/local/mysql-3.23.52/sql-bench' make: *** [install-recursive] Error 1 I dont want to use the binary included in my distro as it has not been compiled with pam_mysql. Please help, I needed this up yesterday. Any help will be much apreciated. Thanks, Lawrence - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: RE: RE: Character Set Settings
Hi, Have you tried just putting greek characters directly in the page? That way you can at least find out if the browser is at fault. Then try something like: ?= some greek characters ? to rule out whether it's PHP. It's probably not MySQL if you can see them when just using the command-line client... Dean Harding. -Original Message- From: Nikoloudis George [mailto:[EMAIL PROTECTED]@intracom.gr] Sent: Wednesday, 25 September 2002 8:24 pm To: Nikolaos Georgiafentis Cc: [EMAIL PROTECTED] Subject: RE: RE: RE: Character Set Settings Nothing I did it. I will try to install againthe PHP. I will come back. Thanks a lot George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: Τετάρτη, 25 Σεπτεμβρίου 2002 12:58 μμ To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: Re: RE: RE: Character Set Settings Sorry the correct charset is ISO_8859-7. Is the problem resolved? At 12:45 PM 9/25/2002 +0300, you wrote: Dear Nikos The charset is ISO_8859-7 not greek8 In you system the greeks work fine? George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ΤετάÏτη, 25 ΣεπτεμβÏίου 2002 12:19 μμ To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: Character Set Settings Dear Gorge, the page you have sent me is included in an other page? If is not then try to put also all the required html tags (i.e HEAD,BODY etc.) If it is then try to put the correct page encoding in the main page that includes the page you have sent me. At 11:48 AM 9/25/2002 +0300, you wrote: Dear Nikos I did that I nothing. I am sending you also the php script I run: meta http-equiv=Content-Type content=text/html; charset=greek8 ?php /* Connecting, selecting database */ $link = mysql_connect(localhost, test, ) or die(Could not connect); print Connected successfully; mysql_select_db(mysql) or die(Could not select database); /* Performing SQL query */ $query = SELECT * FROM test; $result = mysql_query($query) or die(Query failed); /* Printing results in HTML */ ? table ?php while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { ? tr ?php foreach ($line as $col_value) {? td ?php print $col_value; }? /td /tr ?php } ? /table /* Free resultset */ ?php mysql_free_result($result); /* Closing connection */ mysql_close($link); ? George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03 60 06 -Original Message- From: Nikolaos Georgiafentis [mailto:[EMAIL PROTECTED]] Sent: ΤεÄάÃÂÄη, 25 ΣεÀÄεμβÃÂίοÃ… 2002 11:33 Àμ To: Nikoloudis George ([EMAIL PROTECTED]) Cc: [EMAIL PROTECTED] Subject: RE: Character Set Settings Fear George, try putting 'META HTTP-EQUIV=Content-Type CONTENT=text/html;charset=iso-8859-7' in the header section of your page. Keep me informed At 10:54 AM 9/25/2002 +0300, you wrote: Dear Nikos I run the below --defult-character-set=ISO-8859-7 and when I insert into the database like insert into test values('ÄÕÃÂ'); when I select: mysql select * from test - ; +--+ | data | +--+ | Ã¥ÃÂá | | Ã…ÃÂà| | ÄÕà| | äõï | +--+ 4 rows in set (0.04 sec) but the problem is in the Explorer pages where I get $%#$#$# Any ideas, I work in Win200 system. George Nikoloudis INTRACOM S.A. Telecom Business Support Systems 19.5 km, Markopoulou Ave. Tel.: +30 10 667 97 58 GR 19002 Athens Fax: +30 10 667 97 97 Greece Mob.: +30 972 03
Re: access denied ????
thnx guyz i ve win2k pro, apache 1.3.24 n php 4.2.2 i dont know how you managed to configure your system on the root only since i need multiple users each with its own set of database and tables .. heres a piece from my config.inc file . $i++; $cfgServers[$i]['host'] = 'localhost'; $cfgServers[$i]['port'] = ''; $cfgServers[$i]['socket']= ''; $cfgServers[$i]['connect_type'] = 'tcp'; $cfgServers[$i]['controluser'] = 'zaban'; $cfgServers[$i]['controlpass'] = 'orbidy'; $cfgServers[$i]['auth_type'] = 'http'; (config, http or cookie based)? $cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] = ''; $cfgServers[$i]['only_db'] = 'zabanDb'; $cfgServers[$i]['verbose'] = ''; $cfgServers[$i]['bookmarkdb']= ''; $cfgServers[$i]['bookmarktable'] = ''; $cfgServers[$i]['relation'] = '' $i++; $cfgServers[$i]['host'] = 'localhost'; $cfgServers[$i]['port'] = ''; $cfgServers[$i]['socket']= ''; $cfgServers[$i]['connect_type'] = 'tcp'; $cfgServers[$i]['controluser'] = 'sir'; $cfgServers[$i]['controlpass'] = 'xomby'; $cfgServers[$i]['auth_type'] = 'http'; $cfgServers[$i]['user'] = 'root'; $cfgServers[$i]['password'] = ''; $cfgServers[$i]['only_db'] = ''; $cfgServers[$i]['verbose'] = ''; $cfgServers[$i]['bookmarkdb']= ''; $cfgServers[$i]['bookmarktable'] = ''; $cfgServers[$i]['relation'] = 'sirDb'; and im stuck ... i cant even add or drop a field from a table plz plz hlp . :'( . distressed .. toby .. From: Bruce Lewis [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED],[EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: access denied Date: Mon, 23 Sep 2002 10:10:59 -0500 I don't know how you have your system configured, but mine has the root only functional on the localhost. Bruce - Original Message - From: toby - [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, September 23, 2002 9:22 AM Subject: Re: access denied thnx gerald but i still dont know what to do to fix this thing up will someone pleez enlighten me on how to thnx a million ... toby . From: gerald_clark [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: access denied Date: Mon, 23 Sep 2002 09:02:55 -0500 mysql does not own its files. toby - wrote: ok guyz im lost im creating my tables and after i ve created em i tried to change two of the fields to FULLTEXT and this is what i get : Database zabanDb running on localhost Error SQL-query : ALTER TABLE `ctnt_inf` ADD FULLTEXT(`summary`) MySQL said: Error on rename of '.\zabandb\ctnt_inf.MYI' to '.\zabandb\#sql2-5b0-7e.MYI' (Errcode: 13) ACCESS DENIED ! ! ! ! ! what the hell is rong with this thing ? cud anyone help me plz _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access denied ????
thnx iikkaa im bsorry ... i ve win2k pro, apache 1.3.24 n php 4.2.2 all workin fine . my mysql4.0.1 alfa is givin me these night-mares cud this be the problem 4.0.1 ALFA ? it was a win zip file i guess not the source but a binary . plz do lemme know what can i do n thnx a lot again toby .. From: Iikka Merilinen [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: access denied Date: Mon, 23 Sep 2002 18:19:00 +0300 (EEST) Hello, If you're on *NIX platform, use this: chown mysql * in your data directory. To make things sure, chown every data file to mysql user (I assume you've created it during install). On Windows, check the permissions. I apologize for being inaccurate, but you didn't specify what operating system you're using and whether you have installed MySQL from source or from a binary package. Regards, Iikka On Mon, 23 Sep 2002, toby - wrote: thnx gerald but i still dont know what to do to fix this thing up will someone pleez enlighten me on how to thnx a million ... toby . From: gerald_clark [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: access denied Date: Mon, 23 Sep 2002 09:02:55 -0500 mysql does not own its files. toby - wrote: ok guyz im lost im creating my tables and after i ve created em i tried to change two of the fields to FULLTEXT and this is what i get : Database zabanDb running on localhost Error SQL-query : ALTER TABLE `ctnt_inf` ADD FULLTEXT(`summary`) MySQL said: Error on rename of '.\zabandb\ctnt_inf.MYI' to '.\zabandb\#sql2-5b0-7e.MYI' (Errcode: 13) ACCESS DENIED ! ! ! ! ! what the hell is rong with this thing ? cud anyone help me plz _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Merilinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php