How to file a bug: Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command.
Hi How do I file a bug for mysql for Windows NT/2000/XP. Problem: Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command. e.g. mysqld-nt --datadir=c:\Program Files\mysql\data Is not possible, nor is mysqld-nt --datadir=c:\Program Files\mysql\data Using the ~1 yielding c:\Progra~1\mysql\data is not an option, nor is using the my.ini file. The reason is that I am installing mysql db for my application only, and if there are other mysql db's installed then it will be ambiguos on how to use the my.ini file, as it is shared by all installations of mysql. I can not use the ~1, ~2 ... Cause I will not on before hand, at installation time, know which one to choose. Lets say there are two directories c:\Program Files Old\ and c:\Program Files\ then these would be translated into c:\Program~1 and c:\Program~2, how could an installer know which one to choose? It can't therefore this solution is not an option either. Please help me out here. Tobias Tobias Eriksson ComOpt AB Michael Löfmans gata 6 254 38 Helsingborg, Sweden Direct: +46 42 389918 Phone: +46 42 389900 e-mail: [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
How can I retrieve the table 'mysql.host' ?
I am working with MySQL on a Windows NT machine. I use Innodb tables. I, usually, switch on MySQL with: mysqld-max --standalone But now, I try this, MySQL crash, and I got the message: mysqld-max: Table 'mysql.host' doesn't exist in the 'mysql.err' file. I have found that I start up MySQL with: mysqld-max -Sg --standalone, then it works. Please, how can I rebuild the 'mysql.host' table to all is OK again? Thanks in advance José Fernández ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
no subject
Hi there! Does anybody knows if there is a maximum in the number of tables for a database in MySQL. Of course it depends on the filesystem. But I want it to know for Win9x and Win2k. Thanks, Peter __ WEB.DE Club - jetzt testen fur 1 Euro! Nutzen Sie Ihre Chance unter https://digitaledienste.web.de/Club/?mc=021105 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Japanese Charset
Here's a brief summary of where we are: I trying to store Japanese text (Shift_Jis) in MySQL and view it from a web page. The content is provided to me in Word format. I convert it to plain text, copy/paste into a web form in an ASP-based CMS on a Windows box. When viewed from a web page, seemingly random characters are morphed into other characters. The majority of the database contains rows in Latin. MySQL supports Japanese and Latin in the same table. Other people are able to do this without the morphing problem. My Regional Language settings in Windows are set to to Shift_Jis in order to view Shift_Jis characters in notepad and the DOS prompt. If I circumvent the CMS and copy/paste from notepad directly to MySQL in the DOS Prompt, the results are the same (although fewer characters are broken when viewed through DOS). For a good explanation visit this problem's web site: http://commworks01.barklouder.com/japan/press/broken_chars.asp I conclude that one of two things may be happening: 1. Characters are being corrupted by virtue of the fact that their source of origination were copied from Word, despite the conversion to plain text. (At this point I do not have a plain text file with content typed directly into notepadi.e. Word circumvented. I am at the mercy of the client's PR department.) 2. Characters are being corrupted by MySQL. If option 1 were true, then why do the characters show up fine when in a static HTML document? (see below). In Response to Joel Rees: I checked the text you gave me, and I found what's getting clobbered. It's the latter half of characters like the katakana 'so'. Although the byte that is getting walked on here is 0x5c, this is _not_ the escape character. It is preceded (in the case of katakana 'so') by a byte of 0x83. The entire character is '0x835c', and the 0x5c is being treated as if it were a backslash. There are other characters that will get hit by this, by the way. Question 1: It seems like a lot more characters are getting hit than just '0x835c'. How do I map the 0x835c to what the character looks like? I don't know what 0x835c is. Question 2: How do I handle the character escape mechanism correctly according to MySQL? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql_query
Hello! I am a bloody newbie in this whole mysql area, so please forgive me for such a silly question ;) I have expected to get the text from the field with this code. $result=MYSQL_QUERY( SELECT mail_1 FROM table_mail WHERE rechner_nr='Rechner1'); echo $result; As result i get: Resource id #2 But i exspected: [EMAIL PROTECTED] I hope i hae exlained it well. Cheers, Mario - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Japanese Charset
Hello friend I am not an expert in mysql and I am also a newbie But As for I think, mysql has nothing to do with this problem. I am using mysql with jsp to store and retrieve japanese characters. My O/S is also japanese WindowsNT4.0SP6a. Despite I get errors in my browser in the beginning.So I wrote a small bean component. This component will read the characters(Shift_JIS , a,b or any) and convert into (8859_1) and put it into the database While retrieving the data, I will do the reverse. Also make sure the right charset is set in your html page My knowledge in asp is a big zero. So if you are using jsp, I can send you the bean. Best of luck - Original Message - From: Dawn Friedland [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Joel Rees [EMAIL PROTECTED]; Shashank Tripathi [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 4:54 PM Subject: RE: Japanese Charset Here's a brief summary of where we are: I trying to store Japanese text (Shift_Jis) in MySQL and view it from a web page. The content is provided to me in Word format. I convert it to plain text, copy/paste into a web form in an ASP-based CMS on a Windows box. When viewed from a web page, seemingly random characters are morphed into other characters. The majority of the database contains rows in Latin. MySQL supports Japanese and Latin in the same table. Other people are able to do this without the morphing problem. My Regional Language settings in Windows are set to to Shift_Jis in order to view Shift_Jis characters in notepad and the DOS prompt. If I circumvent the CMS and copy/paste from notepad directly to MySQL in the DOS Prompt, the results are the same (although fewer characters are broken when viewed through DOS). For a good explanation visit this problem's web site: http://commworks01.barklouder.com/japan/press/broken_chars.asp I conclude that one of two things may be happening: 1. Characters are being corrupted by virtue of the fact that their source of origination were copied from Word, despite the conversion to plain text. (At this point I do not have a plain text file with content typed directly into notepadi.e. Word circumvented. I am at the mercy of the client's PR department.) 2. Characters are being corrupted by MySQL. If option 1 were true, then why do the characters show up fine when in a static HTML document? (see below). In Response to Joel Rees: I checked the text you gave me, and I found what's getting clobbered. It's the latter half of characters like the katakana 'so'. Although the byte that is getting walked on here is 0x5c, this is _not_ the escape character. It is preceded (in the case of katakana 'so') by a byte of 0x83. The entire character is '0x835c', and the 0x5c is being treated as if it were a backslash. There are other characters that will get hit by this, by the way. Question 1: It seems like a lot more characters are getting hit than just '0x835c'. How do I map the 0x835c to what the character looks like? I don't know what 0x835c is. Question 2: How do I handle the character escape mechanism correctly according to MySQL? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Report writer
Can you please help me? If you can help direct me where to get a report writter running on Windows. By reading your post, you know some report writters that run on windows. Thanks Emery - Original Message - From: Derek Scruggs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 6:12 AM Subject: OT: Report writer Hi All, This is a little OT, but I'm looking for a report writer/server for Apache/MySQL. There are lots of report writer/servers out there, but the ones I've found so far either 1) work only on Windoze or 2) cost a lot of money. I'm just looking for a basic tool that allows me to design relatively simple reports on a Windoze desktop and upload the report schema to a Linux/Apache web server, which generates the reports on the fly. It would be great if it used PHP so I could tweak the internals, but I'm not holding my breath on that. I'll probably end up writing my own module, but it would be nice if there were something available that automated some of the more mundane stuff such as pagination, parameters etc. TIA, 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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
DBI still have performance problem with my big MyISAM table. DBIn fact, mysql keep locking my table, even for doing select :( PDB That's how MyISAM works -- it uses table locks for everything. PDB Given that fact, if it didn't lock the table for reading, that would PDB allow other clients to update the table at the same time -- leading PDB to disastrous results. DBI don't know why but it's very very annoying. DB1% of my query are search ones. DBTheses queries are slow, too slow. I found my problem and why Mysql lock my table for a select. In fact, mysql sometimes don't use the right index and so does a 'Table sort' that lock my table. I modify the query to add USE INDEX clause and now, all seems to work well ... I just need to test during several days to be sure that's i'm right .. Thanks 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: Installation problems
Thanks you I didn't see this client as I installed MySQL-MAX from http://www.mysql.com/downloads/mysql-max-3.23.html (no client here) :) instead of http://www.mysql.com/downloads/mysql-3.23.html Best regards and thank you again Sherif - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 23, 2002 6:59 AM Subject: re: Installation problems Sherif, Tuesday, September 24, 2002, 2:16:13 AM, you wrote: SDM I installed it on Redhat Linux 7.3 using MySQL-Max-3.23.52-1.i386.rpm SDM While installation it asked me to change DB root password using mysqladmin SDM I looked for mysqladmin and didn't find it !! not all the files were SDM installed. SDM I looked into the documentation and it said for linux, using RPM, install SDM these 2 files MySQL-VERSION.i386.rpm and MySQL-client-VERSION.i386.rpm SDM I have the rpm for the server but I looked on www.mysql.com for SDM MySQL-client-VERSION.i386.rpm but could not find any RPMs for the client (or SDM any installation files to install clinet) Yes, you need to install MySQL-client-VERSION.i386.rpm, too. Take a look carefully here: http://www.mysql.com/downloads/mysql-3.23.html -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with TEXT fields
hello,
this is presumably such a dull newbie question but i
did consult several manuals and couldn't find it:
When trying to import xml data into MySQL via a perl
script, i encounter the problem that the data is
written into the value fields when VARCHAR is choosen,
but not when TEXT is chosen: (MEMO) appears as field
content instead of the data.
What works:
CREATE TABLE IF NOT EXISTS $ARGV[1] (identifier
VARCHAR(255), value VARCHAR(255))
What doesn't work:
CREATE TABLE IF NOT EXISTS $ARGV[1] (identifier
VARCHAR(255), value TEXT)
The table and date is then written with:
foreach my $row ($nodelist-get_nodelist ())
{
$dbh- do (
INSERT INTO livertox (identifier, value) VALUES
(?,?),
undef,
$row-find (identifier)-string_value (),
$row-find (value)-string_value ()
);
}
So - what is wrong ??
Any help on this greatly appreciated
Holger
Any suggestions ??
Thanks a lot
Holger
___
The ALL NEW CS2000 from CompuServe
Better! Faster! More Powerful!
250 FREE hours! Sign-on Now!
http://www.compuserve.com/trycsrv/cs2000/webmail/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To 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_query
Great, thanks a lot! From: Henk Huizinga [mailto:[EMAIL PROTECTED]] Mario, This is actually an PHP question. You forgot the following code : $resultquery = mysql_fetch_row($result); echo $resultquery[0]; Cheers, Henk -Original Message- From: Mario Ohnewald [mailto:[EMAIL PROTECTED]] Sent: dinsdag 24 september 2002 09:50 To: [EMAIL PROTECTED] Subject: mysql_query Hello! I am a bloody newbie in this whole mysql area, so please forgive me for such a silly question ;) I have expected to get the text from the field with this code. $result=MYSQL_QUERY( SELECT mail_1 FROM table_mail WHERE rechner_nr='Rechner1'); echo $result; As result i get: Resource id #2 But i exspected: [EMAIL PROTECTED] I hope i hae exlained it well. Cheers, Mario - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyISAM to InnoDB
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi All, Just needing a little advice really, we have a (now) very large mysql database thats keeping track of gas/electrical safety inpection data. Since it was meant to just report on this data to produce very complex safety certificates and reports we chose the MyISAM table type. Unfortunately things never stay the same for long and the company decided to bolt in a bunch of other stuff ;-) Now we have a lot of reads and a lot of writes to the database and i'm seriously considering moving to InnoDB tables. Question is, will this require any SQL code changes to our application? We make heavy use of features like temporary tables, autoincrement columns etc. Would if be as simple as dumping the database and restoring it to InnoDB tables? If anyone has any experiance of doing this and/or knows of any issues i may run into id be pleased to hear from you! ;-) Many thanks and best regards, 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 iD8DBQE9kCxpUKf+497XC3QRAk9KAJ400Uot3GLyzf4yMV0V+ybE1BvL/QCfXeTS FOQfHoCMPqTSOKIdfPkdZ8E= =w6Se -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: Tryout mysql++ Example Loading binary file in a BLOB ... ... to be continued in msql++ list !?
I think I'll start this thread in mysql++ list again. Sorry, I might was to tired yesterday... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 to InnoDB
Hi! At 10:12 2002.09.24._ +0100, you wrote: Question is, will this require any SQL code changes to our application? We make heavy use of features like temporary tables, autoincrement columns etc. Would if be as simple as dumping the database and restoring it to InnoDB tables? The simple answer is: No. You don't have to change any code in your application, InnoDB will works with the actual code, because it is 100% compatible with MyISAM. But!!! If you want to use special features of InnoDB table types (which are not in MyISAM), you might need changing your code. For example when you decide to use transactions (non-autocommit mode) or foreign key constraints. Bye, Daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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/Innodb bug
Joe, this is a serious bug, because it can also spoil recovery from a backup. What MySQL version and Linux kernel you are running? Do you use RAID or NFS? How much RAM, how much swap partition of Linux? What do the corrupt binlog file names look like? Please show us all binlog files names, and the contents your binlog .index file. Did InnoDB recover from the crash without problems? Below we see that the crash happened in the memory allocator of MySQL. The problem might be a memory overrun or overwrite of the binlog file name. I will test running two ibbackups concurrently today. I doubt that ibbackup has to do with the corruption, unless this is yet another Linux file i/o bug. The binlog files are totally independent from ibbackup, which does not look at them at all. Best regards, Heikki Innobase Oy - Original Message - From: Joe Shear [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, September 24, 2002 12:56 AM Subject: Mysql/Innodb bug Appears to be a database memory corruption problem. The binlog filename had been trashed. Eventually, mysql/innodb blew up trying to do a malloc. We were accidentally running two copies of ibbackup at the same time at around 6pm on 9/21 and 9/22. We were accidentally running a third copy at around 11am on 9/21 and 9/22. The 11am backups appear to have succeeded. One of the 6pm backups reported success on each of 9/21 and 9/22. The binlog index file recorded 2 trashed binlog filenames. A binlog file was created on disk with a trashed filename. The trashed binlog filename has a time-last-modified of 5:05. At first glance it would seem that the fact we were running multiple copies of the backup software was unreleated to the core dump. Stack trace looks like: 0x806eea4 0x82d9218 0x83016a7 0x8301261 0x82c0b8e 0x806bf9d 0x806bc0e 0x808748c 0x809d845 0x8076eee 0x8079e3c 0x8074f14 0x80742c7 0x806eea4 handle_segfault__Fi + 428 0x82d9218 pthread_sighandler + 184 0x83016a7 chunk_alloc + 759 0x8301261 malloc + 209 0x82c0b8e my_malloc + 30 0x806bf9d get_lock_data__FP3THDPP8st_tableUibT1 + 113 0x806bc0e mysql_lock_tables__FP3THDPP8st_tableUi + 574 0x808748c open_ltable__FP3THDP13st_table_list13thr_lock_type + 280 0x809d845 mysql_update__FP3THDP13st_table_listRt4List1Z4ItemT2P4ItemUl15enum_duplicate s13thr_lock_type + 53 0x8076eee mysql_execute_command__Fv + 5322 0x8079e3c mysql_parse__FP3THDPcUi + 216 0x8074f14 do_command__FP3THD + 1460 0x80742c7 handle_one_connection__FPv + 655 .err file looks like 020920 10:26:33 mysqld ended 020920 10:32:20 mysqld started 020920 10:32:26 InnoDB: Log file /dblog/email/ib_logfile0 did not exist: new to be created InnoDB: Setting log file /dblog/email/ib_logfile0 size to 48 MB InnoDB: Database physically writes the file full: wait... 020920 10:32:30 InnoDB: Log file /dblog/email/ib_logfile1 did not exist: new to be created InnoDB: Setting log file /dblog/email/ib_logfile1 size to 48 MB InnoDB: Database physically writes the file full: wait... 020920 10:32:36 InnoDB: Log file /dblog/email/ib_logfile2 did not exist: new to be created InnoDB: Setting log file /dblog/email/ib_logfile2 size to 48 MB InnoDB: Database physically writes the file full: wait... 020920 10:32:42 InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 3061070860 InnoDB: Doing recovery: scanned up to log sequence number 0 3061070860 InnoDB: Last MySQL binlog file position 0 5163, file name /data/email/mysql_binlog/binlog.927 020920 10:32:44 InnoDB: Flushing modified pages from the buffer pool... 020920 10:32:44 InnoDB: Started /usr/sbin/mysqld-max: ready for connections mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked agaist is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail key_buffer_size=67104768 record_buffer=1044480 sort_buffer=1048568 max_used_connections=39 max_connections=200 threads_connected=11 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 474330 K bytes of memory Hope that's ok, if not, decrease some variables in the equation Attempting
mysql@lists.mysql.com
mysqlÄúºÃ! Ìì½òÊб±´óҽԺǿֱ¿Æ¼Ì³ÐÖйú´«Í³Ò½Ñ§µÄ¾«Ë裬·¢¾ò³öÁËÇ峯Ãñ¼äÌØЧ ÖÎÁÆÇ¿Ö±ÐÔ¼¹ÖùÑ×µÄÎâÊÏÖÐÒ½ÁÆ·¨£¬ÓÐЧÖÎÁÆÇ¿Ö±¼¹ÖùÑס£ ¸ÃÁÆ·¨²ÉÓöÀÌصĽ«Ö²¡Òò×ӰγöÌåÍâµÄ·½·¨,Ó¦ÓÃÏÊÖвÝÒ©Íâ·óÖÎÁÆ£¬ÎÞ Ðè¿Ú·þ£¬ÎÞ¶¾¸¶×÷ÓÃ, ¸ü²»»áÉ˼°³¦Î¸, Ò»°ãÇé¿öÖ»ÐèÁ½¸öÁƳÌ15Ìì×óÓÒ¼´¿É ʹ»¼Õß½â³ý²¡Í´¡£ ¾Öڶ໼ÕßÁÙ´²Ê¹Óã¬Ö¤Êµ¸ÃÁÆ·¨¶ÔÇ¿Ö±ÐÔ¼¹ÖùÑ×µÄÓÐЧÂÊ¿É´ï90%ÒÔÉÏ£¬ ÖÎÁƺ󸴷¢Âʼ«µÍ¡£ÄÜ¿ìËÙÓÐЧֹʹ¡£ »¶Ó»¼ÕßÀ´ÐÅÌáÎÊ£¬ÍøÕ¾¿ªÍ¨ÔÚÏß×Éѯ£¬½ìʱÓÐÖ÷ÈÎҽʦΪÄú½â´ðÒÉÎÊ¡£ ÏêÇé²ÎÔÄÍøÕ¾£ºhttp://www.xfzg.com 24Сʱ×Éѯµç»°£º 022-27276811 022-27278031´ÞÖ÷ÈÎ ´ËÐÅÈç¶ÔÄúÉú»îÔì³É¸ÉÈÅÇëÔÁ£¬Ë³ÊÖɾ³ý¡£ Ö Àñ! Ìì½òÊб±´óÒ½Ôº 2002.8 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Spam
-- mysql, query I wonder if you're using any RBL to avoid spam. They're quite effective, since most of spam comes from open relays or misconfigured proxies. Regards - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MyISAM to InnoDB
At 10:12 2002.09.24._ +0100, you wrote: Question is, will this require any SQL code changes to our application? We make heavy use of features like temporary tables, autoincrement columns etc. Would if be as simple as dumping the database and restoring it to InnoDB tables? The simple answer is: No. You don't have to change any code in your application, InnoDB will works with the actual code, because it is 100% compatible with MyISAM. But!!! If you want to use special features of InnoDB table types (which are not in MyISAM), you might need changing your code. For example when you decide to use transactions (non-autocommit mode) or foreign key constraints. I thought the InnoDB doesn't support a few MyISAM features. FULLTEXT for one.Those features it does support will not need SQL changes. On the other hand, if you don't need MyISAM freatures, can't you just do ALTER TABLE mytable TYPE=INNODB. If you are brave, and after taking a backup, of course. Alec - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Fwd: Re: MyISAM to InnoDB]
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 grr: sql,query,mysql ;-) Hi Guys, Thanks to everyone that gave a response there, i feel much better now ;-) I'm not using any of the features listed in the recent posts just pain simple boring INSERTS, UPDATES, SELECTS and temporary tables. (keep it simple eh?!?) so i think the shift will be quick and easy. I have a windows of about 3 hrs to down the server make the changes and get it operational again so I though it wise to check first! Thanks again all, 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 iD8DBQE9kESMUKf+497XC3QRAp2RAKDDeRmvHB2Eayr74X1Ku+d2cqdd6QCeOHN7 Olm4Bg6VxheM0elhN/xf+wY= =+KyX -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: Japanese Charset
Dawn, Look at chapter 6.1.1.1 in the MySQL docs: http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Literals Practically the first odd thing mentioned is escape sequences. Keep in mind that the ASCII code for the backslash character, which is used to initiate escape sequences, is 0x5c. (I work with php and perl. Anyone have a good sample of input filters from .asp files to MySQL?) Here's a brief summary of where we are: I trying to store Japanese text (Shift_Jis) in MySQL and view it from a web page. The content is provided to me in Word format. I convert it to plain text, copy/paste into a web form in an ASP-based CMS on a Windows box. When viewed from a web page, seemingly random characters are morphed into other characters. The majority of the database contains rows in Latin. MySQL supports Japanese and Latin in the same table. Other people are able to do this without the morphing problem. My Regional Language settings in Windows are set to to Shift_Jis in order to view Shift_Jis characters in notepad and the DOS prompt. If I circumvent the CMS and copy/paste from notepad directly to MySQL in the DOS Prompt, the results are the same (although fewer characters are broken when viewed through DOS). For a good explanation visit this problem's web site: http://commworks01.barklouder.com/japan/press/broken_chars.asp Hmm. The characters you pasted directly into the .asp file did not survive intact. I can't read that very first sample, can't even guess what that's saying. The first few words are fourth quarter soft (something) market, but enough falls apart after that that it's hard to tell what else is missing. It looks like something about functionality being scheduled for development. If you understand what MySQL is doing to two-byte characters which have a second byte of 0x5c, then you are ready to dig into ASP and find out if ASP wants the text escaped somehow. (Or take that question to an ASP mailing list.) Can you post that page as pure, unserved, html and send me the link off-list? (Text, with the .htm extension, unless your server forces html through asp, too.) If I can make sense of it as pure html text, you'll be able to completely rule MSWord and the OS out. I conclude that one of two things may be happening: 1. Characters are being corrupted by virtue of the fact that their source of origination were copied from Word, despite the conversion to plain text. (At this point I do not have a plain text file with content typed directly into notepadi.e. Word circumvented. I am at the mercy of the client's PR department.) No real need to worry about MSWord, I think. Anyway, if, as you say below, pasting the characters in static HTML is okay, you can be sure that MSWord is giving you no problems now. 2. Characters are being corrupted by MySQL. Well, sort of. Except that MySQL is not really the culprit, because the behavior in question is part of the spec, and has been for quite a while. (At least one user of MySQL wanted MySQL to change their spec to conform with Oracle's spec, but since the state of the SQL standard is a mess, it's a hard point to argue right now. But the escape sequence _is_ part of MySQL's spec.) If option 1 were true, then why do the characters show up fine when in a static HTML document? (see below). I want to see that static HTML. In Response to Joel Rees: I checked the text you gave me, and I found what's getting clobbered. It's the latter half of characters like the katakana 'so'. Although the byte that is getting walked on here is 0x5c, this is _not_ the escape character. It is preceded (in the case of katakana 'so') by a byte of 0x83. The entire character is '0x835c', and the 0x5c is being treated as if it were a backslash. There are other characters that will get hit by this, by the way. Question 1: It seems like a lot more characters are getting hit than just '0x835c'. How do I map the 0x835c to what the character looks like? I said like. I suppose I was not clear about how they would be similar. Two-byte characters with a final byte of 0x5c are going to be caught by MySQL, interpreted as something followed by an escape character, followed by the next byte (first byte of the next character) as a literal. In some odd situations, you might end up with a control character, in others, the 0x5c just simply disappears, leaving the character stream corrupted. Only one byte lost, but the final app will think that characters are starting on what is really the second byte. Once you lose one character, a whole bunch get out of sync. Example, the sequence for sofuto (modern Japanese word imported from the English soft) is 0x835c 0x8374 0x8367. If you let MySQL try to interpret the 0x5c as a backslash, it thinks that you're just telling it that it should not do anything out of the ordinary with the 0x83 which follows. The result is 0x8383 0x74 0x8367, which is not too bad. 0x8383
Re: Report writer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 OT Hey dude, I've been through this problem too. Unfortunately, short of writing your own module (we did some experimentation using html and pdf) there are very few options i know of. Here we are using a dedicated crystal reports server and crystals passthrough module on the webserver which redirects requests to the report server. The whole thing works really well and keeps load on the webserver down. But it will require that you write some stuff in ASP first. (I've been using PHP for ages now and going back to ASP seemed a little like going back to dialup after having months of time on broadband ;-) danny NZEYIMANA Emery Fabrice wrote: | Can you please help me? | | If you can help direct me where to get a report writter running on Windows. | By reading your post, you know some report writters that run on windows. | | | Thanks | Emery | - Original Message - | From: Derek Scruggs [EMAIL PROTECTED] | To: [EMAIL PROTECTED] | Sent: Tuesday, September 24, 2002 6:12 AM | Subject: OT: Report writer | | | |Hi All, | |This is a little OT, but I'm looking for a report writer/server for |Apache/MySQL. There are lots of report writer/servers out there, but the |ones I've found so far either 1) work only on Windoze or 2) cost a lot of |money. I'm just looking for a basic tool that allows me to design | | relatively | |simple reports on a Windoze desktop and upload the report schema to a |Linux/Apache web server, which generates the reports on the fly. It would | | be | |great if it used PHP so I could tweak the internals, but I'm not holding | | my | |breath on that. | |I'll probably end up writing my own module, but it would be nice if there |were something available that automated some of the more mundane stuff | | such | |as pagination, parameters etc. | |TIA, |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 | | | | | | | | | - | Before posting, please check: |http://www.mysql.com/manual.php (the manual) |http://lists.mysql.com/ (the list archive) | | To request this thread, e-mail [EMAIL PROTECTED] | To unsubscribe, e-mail [EMAIL PROTECTED] | Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php | | - -- 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 iD8DBQE9kEzgUKf+497XC3QRApDPAKCiNDc9Jc4OBbbiWJd61tAHsVSR7wCfRytq JU0nK1zLZ/4yvpcYiLeyYKc= =n8OD -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: Insert into multi-tables
Chuck, Tuesday, September 24, 2002, 12:44:26 AM, you wrote: CP I have a question. I have two tables that I want to post data too. Is there CP a way to do a sql statement that lets me post data two tables at the same CP time? No. -- 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: How can I retrieve the table 'mysql.host' ?
José, Tuesday, September 24, 2002, 10:30:30 AM, you wrote: JF I am working with MySQL on a Windows NT machine. I use JF Innodb tables. I, usually, switch on MySQL with: JF mysqld-max --standalone JF But now, I try this, MySQL crash, and I got the JF message: JF mysqld-max: Table 'mysql.host' doesn't exist JF in the 'mysql.err' file. JF I have found that I start up MySQL with: mysqld-max JF -Sg --standalone, then it works. JF Please, how can I rebuild the 'mysql.host' table to JF all is OK again? Does host table exist? or MySQL server doesn't see privilege tables? -- 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
Connecting to remote database using MyODBC
Subject: re: Connecting to remote database using MyODBC From: Egor Egorov Date: Fri, 20 Sep 2002 16:33:01 +0300 Adam, Thursday, September 19, 2002, 8:33:17 PM, you wrote: AW Have been trying to connect to a remote MySQL server from Matlab through an AW ODBC connection, however the error is receive is AW [TCX][MyODBC]Can't connect to MySQL server on AW 'server name' (10060) AW I have searched the docs and archives and google... But can't see any answer AW to what this error means. Is MySQL server running? Yup, it is running. The connection works fine from machines within the building However remote machines cannot connect. I have also checked that the the database is available outside the firewall. adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Store pictures in DB
Can I use MySQL to store pictures as part of a record? Should I just try to store the name of the picture? Thanks for any help Roland Perez [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: Store pictures in DB
http://www.mysql.com/doc/en/BLOB.html -Original Message- From: Roland Perez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 3:35 PM To: Receipt Notification Requested Subject: Store pictures in DB Can I use MySQL to store pictures as part of a record? Should I just try to store the name of the picture? Thanks for any help Roland Perez [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Store pictures in DB
You can store pictures in a BLOB field, but it is generally recommended that you simply store the filename of the picture. -Original Message- From: Roland Perez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:35 AM To: [EMAIL PROTECTED] Subject: Store pictures in DB Can I use MySQL to store pictures as part of a record? Should I just try to store the name of the picture? Thanks for any help Roland Perez [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
The Important question
The developer in my software house put this message... Hi, I had been using mySql for a long time in lots of different computers, but now I had a strange problem and I would like to know if anyone can send me a message to help me solving the problem. I installed mySql 3.23.49 on a Dell PowerEdge 2400 with 1Gb RAM, dual processor, RAID 3 and Windows 2000 Server. Unfortunately, the machine was freezing every day, and some times twice a day. Some times, and really frequently, mySql was stopping execution showing the message on the screen: The memory could not be read ... mysqld-max-nt.exe. Well, it was clear for me that the problem was the machine, then I called DELL Suport Services and they said to me that they would send me, by e-mail, some drivers and firmwares updates. I received it and they gave me instructions to install everything they sent. After that, the problems was the same. Then they came to the office and replaced my old RAM for new ones. Well, the problem wasn't solved, but the computer became a little bit better, freezing less. But it still freezing! The next step done by Dell was replacing the motherboard, and as before, the problem wasn't solved, but the machine became a little bit better, freezing less. Now the machine could work an entire week without freezing, but it still freezing. The worst problem I had using that machine was losing data. I was using myIsam tables and, of course, I could not expect all the data was in the disk when the machine freezes. After all this, I stoped using mySqld-max-nt and started using mySqld-nt, and I don't know why I had no new problems with data lost. Another problem I had using myIsam is that when any user starts a select command and it takes long time to finish, all other users that was inserting or updating data have to wait. The users was asking for a solution for it, and the only way I could find was converting to innoDb table. And I was hopping that it could solve this problems and also, bring safety to my data, because innoDb supports transactions. Then I installed mySql 3.23.52, back using mySqld-max-nt and changed my tables to innoDb to use transactions, believing my data would be safe after a COMMIT statement. But for my surprise, the machine did not freeze and I lost 1 record that was inside a begin...commit statemant. The most strange is that other records inserted in the same begin...commit was in the disk, and only one of that records was lost. My application just insert data into that table, and there is not delete or update command that could cause it. This server is used by 25 users and the database is composed by 40 tables. Some tables have up to 1.5 million records and all database has about 10 million records. All tables have up to 20 indexes and using myIsam it gets 4 GB (or 16 GB using innoDb). === my.cnf used when all tables was myIsam: === [client] #password=my_password port=3306 #socket=MySQL [mysqld] port=3306 #socket=MySQL skip-locking default-character-set=latin1 set-variable = key_buffer = 256M set-variable = join_buffer = 16M set-variable = myisam_sort_buffer_size = 256M set-variable = sort_buffer = 128M set-variable = record_buffer = 8M set-variable = max_allowed_packet = 20M set-variable = max_connections = 500 set-variable = flush_time = 2000 #set-variable = thread_cache= 8 #set-variable = thread_concurrency = 16 #set-variable = thread_stack= 128K #set-variable = table_cahe = 512 #set-variable = interactive_timeout = 300 #set-variable = wait_timeout= 300 basedir = e:/mysql/ datadir = e:/mysql/data/ [mysqldump] quick set-variable = max_allowed_packet = 20M #[mysql] #no-auto-rehash [isamchk] set-variable = key_buffer= 256M set-variable = sort_buffer = 256M set-variable = read_buffer = 8M set-variable = write_buffer = 8M [myisamchk] set-variable = key_buffer= 256M set-variable = sort_buffer = 256M set-variable = read_buffer = 8M set-variable = write_buffer = 8M == my.cnf used when it was changed to innoDb: == [client] #password=my_password port=3306 #socket=MySQL [mysqld] port=3306 #socket=MySQL skip-locking default-character-set=latin1 set-variable = key_buffer = 16M set-variable = join_buffer = 16M set-variable = myisam_sort_buffer_size = 256M set-variable = sort_buffer = 16M set-variable = record_buffer = 8M set-variable = max_allowed_packet = 20M set-variable = max_connections = 500 #set-variable = flush_time = 2000 #set-variable = thread_cache= 8 #set-variable =
Re: Spam
Gabriele Carioli wrote: -- mysql, query I wonder if you're using any RBL to avoid spam. They're quite effective, since most of spam comes from open relays or misconfigured proxies. On this note, may I beg for a meta-list for the discussing of the management of mysql.com's lists in general? That way suggestions / discussions / arguments have a place to go. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Stability Problem
Hi all, I seem to be running into a stability problem with our current mySQL server. I'm at a loss as to where to begin looking. We first noticed a problem with large files being created in the /tmp directory. That hasn't happened since, but yesterday the server bogged down twice. There were about 100 or so connections to the server, mostly sleeping, and the server was acting extremely sluggish. It took about 60 seconds to get a processlist via mysqladmin... Can anyone give me any pointers as to where to look first? Are there any settings I can tweak that may help this? The machine is a dual 1.3 Ghz machine with 512 Meg RAM It used to be running on a dual 733 Mhz machine and we never experienced anything like this ... -- --- Jason 'XenoPhage' Frisvold Senior ATM Engineer Penteledata Engineering [EMAIL PROTECTED] RedHat Certified - RHCE # 807302349405893 --- Something mysterious is formed, born in the silent void. Waiting alone and unmoving, it is at once still and yet in constant motion. It is the source of all programs. I do not know its name, so I will call it the Tao of Programming. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please Help
Files never get smaller. They can only grow. Deleteing a record marks the area used as available, but does not remove it from the file. I believe you will have to optimize the table to pack out the unused records. This is another good argument for storing images in the filesystem, and only their locations in the database. [EMAIL PROTECTED] wrote: Hi I am a mysql user. I use a long blob field to store image data. But whenever I make a deletion with my image data I find that the hard disk availability is still intact. There is no change. What could be the problem with my delete statement. Please Help Regards Roslee AJ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: How can I retrieve the table 'mysql.host' ?
Please, can you give me more information about this? I think that in Windows NT the privilege tables are built during installation I think that I have not changed anythink. How can I find if there are problems to MySQL see the privilege tables? Many Thanks. José --- Egor Egorov [EMAIL PROTECTED] escribió: José, Tuesday, September 24, 2002, 10:30:30 AM, you wrote: JF I am working with MySQL on a Windows NT machine. I use JF Innodb tables. I, usually, switch on MySQL with: JF mysqld-max --standalone JF But now, I try this, MySQL crash, and I got the JF message: JF mysqld-max: Table 'mysql.host' doesn't exist JF in the 'mysql.err' file. JF I have found that I start up MySQL with: mysqld-max JF -Sg --standalone, then it works. JF Please, how can I rebuild the 'mysql.host' table to JF all is OK again? Does host table exist? or MySQL server doesn't see privilege tables? -- 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 ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Store pictures in DB
+1 For medical imaging, at least in radiology (PACS), you usually see the terabytes of images being stored on a NAS somewhere, and the database itself is actually pretty small just pointing to filenames of where the pictures are located. This keeps the database small and fast, and lets you add storage without the complication of using Logical Volume Management since you don't need to extend your filesystem to add space. Just add a completely new block of space and start writing your images out to it, storing the location in a field in your DB. On Tuesday, September 24, 2002, at 08:46 AM, Salada, Duncan wrote: You can store pictures in a BLOB field, but it is generally recommended that you simply store the filename of the picture. -Original Message- From: Roland Perez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 9:35 AM To: [EMAIL PROTECTED] Subject: Store pictures in DB Can I use MySQL to store pictures as part of a record? Should I just try to store the name of the picture? Thanks for any help Roland Perez [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Store pictures in DB
Can I use MySQL to store pictures as part of a record? You CAN. Should I just try to store the name of the picture? Yes. If you have FTP Access or similiar, I would prefere this! Some remarks from the manual : -- Insert a File located locally on MySQL-Serverinto a blob-column INSERT INTO media_binaerdaten (Daten) values(load_file(c:/tmp/test.zip); -- get length of blob-fields SELECT Key,length(Daten) FROM `media_binaerdaten` WHERE 1 SELECT Daten FROM `media_binaerdaten` WHERE FKMedia_ID=47 INTO OUTFILE C:/tmp/test.zip - get data WITH escapes, can be insertet again SELECT Daten FROM `media_binaerdaten` WHERE FKMedia_ID=47 INTO DUMPFILE C:/tmp/test.zip - get raw data (WITHout) escapes, can be used as binary, e.g. *.zip or *.exe Escaping --- If you want to insert binary data into a BLOB column, the following characters must be represented by escape sequences: NUL ASCII 0. You should represent this by `\0' (a backslash and an ASCII `0' character). \ ASCII 92, backslash. Represent this by `\\'. ' ASCII 39, single quote. Represent this by `\''. ASCII 34, double quote. Represent this by `\'. If you write C code, you can use the C API function mysql_escape_string () to escape characters for the INSERT statement. See section 22.3 C API function overview. In Perl, you can use the quote method of the DBI package to convert special characters to the proper escape sequences. See section 22.5.2 The DBI interface. You should use an escape function on any string that might contain any of the special characters listed above! greetings by a busted by blobs-coder ! -- [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
how to load data to a table's specific field
Dear all I had a source file which containing rate figures, what i want to do is to insert these rate to a specific field of an existing table using Load Data Infile query! here is the example existing table data: ABC 01AUD#rate 02HKD#rate 03JPY#rate 04USD#rate When i import the csv file, it will only replace the field C without changing any values on field A B. Please help me with this, it is urgent!! Thx a lot 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
help for mysql_fetch_row error on a large field
Hi, all, when I use mysql_fetch_row(myRes) and there is a very large field (~30M long), my program crashed. How can I solve the problem? For less than 5M long string/text, it works well. thanks. My machine is Linux 7.3 MySQL is 4.0.3-beta. Best regards. ~~ Lin Kui College of Life Sciences Beijing Normal University Beijing 100875 P. R. China - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Dynamic Links
Hello All, Can anyone tell me if I can make dynamic links between tables. Example. std_price in main_table = std_price in table2. So that if I change the price in the main table, It will be reflected throughout the database. Thank you in advance for your help. William (Filter: MySQL, SQL, Query, Table) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Create Tables Dynamically
Hello All, I am building a web robot in perl that will find equipment from various manufacturers and will get information about that equipments specifications. Can you build tables in MySQL 4.0 dynamically with some type of script. Example. If if have 10 parts in my database and my robot checks with the manufacturers for new parts everyday. One day the robot says yes I found a new part that is not in our database. Can I write a script that will build a table in mySQL and will load the appropriate information. Thanks in advance, William (Filter: MySQL, SQL, Table, 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: Store pictures in DB
+1 For medical imaging, at least in radiology (PACS), you usually see the terabytes of images being stored on a NAS somewhere, and the database itself is actually pretty small just pointing to filenames of where the pictures are located. This keeps the database small and fast, and lets you add storage without the complication of using Logical Volume Management since you don't need to extend your filesystem to add space. Just add a completely new block of space and start writing your images out to it, storing the location in a field in your DB. On Tuesday, September 24, 2002, at 08:46 AM, Salada, Duncan wrote: You can store pictures in a BLOB field, but it is generally recommended that you simply store the filename of the picture. I'm not shure, but is there a feature in oracle, which stores something like BLOBS internally as files? Is something like that planed in MySQL? -- [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 bug?
Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) From: gbu [EMAIL PROTECTED] I'm experiencing very strange innodb behavior. What version of mysqld? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Important question
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 filter: mysql sql query Hi! |I installed mySql 3.23.49 on a Dell PowerEdge 2400 with 1Gb RAM, |dual processor, RAID 3 and Windows 2000 Server. Unfortunately, the |machine was freezing every day, and some times twice a day. Some |times, and really frequently, mySql was stopping execution showing |the message on the screen: The memory could not be |read ... mysqld-max-nt.exe. Well, it was clear for me that the I had a simmilar problem with a low-end server a while back. Seem's the manufacturer (also dell in this case) used resonably cheap ram. I managed to get the thing going by reducing the FSB speed down a notch (in this case is was from 133Mhz to 100Mhz) and immediately the freezing stopped. Have only had this problem once will a dell machine. Usually they seem to use pretty good parts. Anyway, I swapped the ram out for some nice Kingston ram and switched the FSB to 133Mhz again and still no problems. 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 iD8DBQE9kHU9UKf+497XC3QRAlN6AJ99CocTIv/LfFeKdEEf64gQhwHgkwCfYmdx 0B+1adngtVdzR2CmjToM5M4= =mk5c -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: Store pictures in DB
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Roland Perez wrote: | Can I use MySQL to store pictures as part of a record? | Should I just try to store the name of the picture? Yep but it depends on the size of the pictures. We produce certificates here and we hold images of engineer signatures in the database that get used to sign the certificate by crystal reports. The database seems to run fine but the signature pics rarely exceed 10k. IMO, if you have large pictures its best to store the filename in the db and put the pics somewhere else. 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 iD8DBQE9kHYwUKf+497XC3QRAh//AKCzZVjBfIzmWa0Cgi6ZfEVg4oSLgQCglyLU giYX43u7ACg2DbvCK4gr7O8= =BfZB -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: Documentation question
[EMAIL PROTECTED] wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Dear sirs, I have a small question about the documentation that I do not understand. In your documentation you have a small section regarding running multiple data base servers on the same machine. You are supposed to run the databases on different sockets, communication ports etc. I do understand that, but you do recommend that you have different versions compiled for this issue, even though you can run the database servers with just different switches. From a performance issue, I believe that you should run with just one binary, that will be occupy the same physical memory for the two multithreaded processes, even though they have different command line switches. With two different binarys will the physical memory requirement be twice as much. But it might be easier to get a system working when you have two different binarys. But I believe that users that can recompile your software with some different settings also have the competence to adjust runtime switches. What is wrong with the argumentaion above? /Magnus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 bug?
I'm experiencing very strange innodb behavior. What version of mysqld? About test system. FreeBSD 4.2, MySQL 3.23.49, my.cnf innodb settings: === # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:2M innodb_data_home_dir = /db/mysql/ innodb_log_group_home_dir = /db/mysql/ innodb_log_arch_dir = /db/mysql/ set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=128M set-variable = innodb_log_buffer_size=64M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=128M set-variable = innodb_additional_mem_pool_size=16M set-variable = innodb_file_io_threads=4 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Value
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:43 AM To: Fifield, Mike Subject: Re: Value Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: I need a way to tell if a column value is set, I don't care if it is text or a number I just need a way to tell if there is a value set. Is there a way to do this? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Restart of mysqld processing a specific query
Description: Running a specific query makes the mysqld goeing away... How-To-Repeat: Under the following URL you find a partial mysqldump to repeat the error: http://1net.ch/mysqlerr/err.sql Fix: Submitter-Id: Jene Originator:Jene Novakovic Organization: 1 net GmbH MySQL support: none Synopsis: running query kills mysqld Severity: critical Priority: high Category: mysql Class: sw-bug Release: mysql-4.0.3-beta (Source distribution) Server: /usr/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 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 2 min 19 sec Threads: 303 Questions: 21928 Slow queries: 0 Opens: 87 Flush tables: 1 Open tables: 81 Queries per second avg: 157.755 Environment: System: Linux db01 2.4.18-64GB-SMP #1 SMP Tue Jul 30 09:25:48 UTC 2002 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i486-suse-linux/2.95.3/specs gcc version 2.95.3 20010315 (SuSE) Compilation info: CC='gcc' CFLAGS='-pipe -march=i686 -mpreferred-stack-boundary=4' CXX='gcc' CXXFLAGS='-pipe -march=i686 -felide-constructors -mpreferred-stack-boundary=4 -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rwxr-xr-x1 root root 1394302 Aug 10 19:55 /lib/libc.so.6 -rw-r--r--1 root root 25361748 Aug 10 19:24 /usr/lib/libc.a -rw-r--r--1 root root 178 Aug 10 19:24 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --localstatedir=/local/mysql --without-debug --enable-thread-safe-client --enable-assembler --with-mysqld-user=mysql --enable-static --with-mysqld-ldflags=-all-static --with-extra-charset=german1 --without-bench --without-docs 'CFLAGS=-pipe -march=i686 -mpreferred-stack-boundary=4' 'CXXFLAGS=-pipe -march=i686 -felide-constructors -mpreferred-stack-boundary=4 -fno-exceptions -fno-rtti' CXX=gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Documentation question
if you run more than one binary it will NOT use the same physical memory, even if it is the same binary. every programm you run uses its own memory for most parts. Thomas sql, query On Tue, 24 Sep 2002 16:35:21 +0200 Magnus Sundberg [EMAIL PROTECTED] wrote: Dear sirs, I have a small question about the documentation that I do not understand. In your documentation you have a small section regarding running multiple data base servers on the same machine. You are supposed to run the databases on different sockets, communication ports etc. I do understand that, but you do recommend that you have different versions compiled for this issue, even though you can run the database servers with just different switches. From a performance issue, I believe that you should run with just one binary, that will be occupy the same physical memory for the two multithreaded processes, even though they have different command line switches. With two different binarys will the physical memory requirement be twice as much. But it might be easier to get a system working when you have two different binarys. But I believe that users that can recompile your software with some different settings also have the competence to adjust runtime switches. What is wrong with the argumentaion above? /Magnus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
How much stable is MySQL in a production environment?
Recently I have had some problems to start mysqld and finally I have found that this was due to the mysql database has disappear from the hard disk. I have solved this problem, but I do not remember to delete this database. Now, I have a question and I would like that experimented MySQL users help me, please, due to I would like to use MySQL in a production environment (now I am using it in a development environment). Do you know if is a frequent problem that the mysql database damages suddenly? Have you experience with this type of problems? ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems with mySQL and server
Hi, I am trying to get mySQL set up and am having problems. I am using Win2000. I am using the Apache server and believe I have that set up properly as the server is in the running state. When I type mysql in the DOS prompt, the following error is returned: Can't connect to mySQL server on 'localhost'. I tried changing the localhost to the hostname of the machine, and I get the same error: only with localhost replaced with the name inputted. I am using the same machine for both server/client. Any help will be MUCH appreciated! 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: re: Remote ServerAccess
Eric, Monday, September 23, 2002, 6:55:57 PM, you wrote: EL Well what if you have a user that you want to give permission to from any EL computer in the domain. EL Such as user: mysqluser with READ|SELECT|UPDATE from anywhere EL in: mydomain.com EL But not from any other domain. Did you check link that I mentioned below? I guess no. You can do it by specifying '%.mydomain.com' in the Host field. EL At 05:17 PM 9/23/02 +0300, Victoria Reznichenko wrote: Patrick, Monday, September 23, 2002, 4:24:13 PM, you wrote: PF I'm just starting out with MySQL. How do you set permission to allow for PF access from a domain or IP. I found this in the docs. I this all I need? PF GRANT ALL PRIVILEGES ON *.* TO monty@% - IDENTIFIED BY 'some_pass' WITH PF GRANT OPTION; Patrick, % in the host field means any host. If you want to allow connection only from certain host for user, you should specify host name or IP adddress, like GRANT ALL ON *.* TO 'someuser'@'ensita.net' IDENTIFIED BY 'soempassword' WITH GRANT OPTION; Some info you can also find here: http://www.mysql.com/doc/en/Connection_access.html -- 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: MySQL 4.0.3beta on XP...didn't find mysql_fix_privilege_tables
DANIEL, Monday, September 23, 2002, 10:43:15 PM, you wrote: DG I downloaded MySQL 4.0.3beta on my XP system. I didn't find DG mysql_fix_privilege_tables after installing. Am I suppose to pull it DG from the unix download and do by hand? There is no mysql_fix_privilege_tables script in Win distribution. Well .. when I needed new privileges I just upgraded them on unix box. -- 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: How can I retrieve the table 'mysql.host' ?
José, Tuesday, September 24, 2002, 4:29:05 PM, you wrote: JF I think that in Windows NT the privilege tables are JF built during installation Correct. JF I think that I have not JF changed anythink. How can I find if there are problems JF to MySQL see the privilege tables? Check if files host.frm, host.MYD, host.MYI exist in the 'mysql' database dir. If so, you wrote that you use my.cnf file, right? Have you specified path to the data dir there? Show me the contents of the my.cnf. JF --- Egor Egorov [EMAIL PROTECTED] escribió: JF José, Tuesday, September 24, 2002, 10:30:30 AM, you wrote: JF I am working with MySQL on a Windows NT machine. I use JF Innodb tables. I, usually, switch on MySQL with: JF mysqld-max --standalone JF But now, I try this, MySQL crash, and I got the JF message: JF mysqld-max: Table 'mysql.host' doesn't exist JF in the 'mysql.err' file. JF I have found that I start up MySQL with: mysqld-max JF -Sg --standalone, then it works. JF Please, how can I rebuild the 'mysql.host' table to JF all is OK again? Does host table exist? or MySQL server doesn't see privilege tables? -- 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: Value
Fifield, Tuesday, September 24, 2002, 5:48:47 PM, you wrote: FM I need a way to tell if a column value is set, I don't care if it is text or FM a number I just need a way to tell if there is a value set. Is there a way FM to do this? If column can contain NULL values, you can do it with IS NULL / IS NOT NULL conditions, like: SELECT * FROM table_name WHERE column_name IS NOT NULL; http://www.mysql.com/doc/en/Working_with_NULL.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: Dynamic Links
William, Tuesday, September 24, 2002, 4:48:51 AM, you wrote: WM Can anyone tell me if I can make dynamic links between tables. Example. WM std_price in main_table = std_price in table2. WM So that if I change the price in the main table, It will be reflected WM throughout the database. Foreign key is what you need: http://www.mysql.com/doc/en/SEC447.html But ON CASCADE UPDATE is not supported yet. -- 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: Connecting to remote database using MyODBC
Adam, Tuesday, September 24, 2002, 2:57:04 PM, you wrote: Subject: re: Connecting to remote database using MyODBC From: Egor Egorov Date: Fri, 20 Sep 2002 16:33:01 +0300 Adam, Thursday, September 19, 2002, 8:33:17 PM, you wrote: AW Have been trying to connect to a remote MySQL server from Matlab through an AW ODBC connection, however the error is receive is AW [TCX][MyODBC]Can't connect to MySQL server on AW 'server name' (10060) AW I have searched the docs and archives and google... But can't see any answer AW to what this error means. Is MySQL server running? AW Yup, it is running. AW The connection works fine from machines within the building However AW remote machines cannot connect. I have also checked that the the database is AW available outside the firewall. Did you run MySQL server with --skip-networking options? or does skip-networking present in the my.cnf file? -- 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: 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 various WM manufacturers and will get information about that equipments specifications. WM Can you build tables in MySQL 4.0 dynamically with some type of script. WM Example. If if have 10 parts in my database and my robot checks with the WM manufacturers for new parts everyday. One day the robot says yes I found a WM new part that is not in our database. Can I write a script that will 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: replication problem
David, Monday, September 23, 2002, 6:03:58 PM, you wrote: DP We are having a problem which seems to have appeared recently with DP replication on our mysql servers. DP - We have 3 servers set up with mysql 3.23.52 (they were running .49 but DP we upgraded in an attempt to fix this problem, which did not work), set DP up as a master and 2 slaves to the master. DP - There is a large script that runs on the master server. This script DP DROPs a large table, then recreates it. It is basically a DROP followed DP by a CREATE and many INSERTs. DP - Up until recently we have had no issues with this problem. Lately DP however the slave servers are not updating. The error we see in the logs DP is the table which it attempts to create already exists, therefore from DP that point on the replication stops. We can't understand why suddenly DP the DROP TABLE doesn't get replicated. David, does it happen every time when you drop the table or only sometimes? Is DROP TABLE statement present in binary logs? I tested on 3.23.52 and DROP TABLE replicated fine for me. -- 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: Copying to tmp table
Teh, Tuesday, September 24, 2002, 8:31:54 AM, you wrote: TCP Does anyone has any idea to improve this situation? TCP When I show my processlist, there is inner join query that having Copying TCP to tmp Table state, and it takes quite long time to finish the query. Any TCP idea to avoid Copying to tmp Table? I have tried to increase my TCP tmp_table_size however it does not remedy my problem. MySQL uses temporary tables in some queries. You can try to optimize your query. Here is some info that could help you: http://www.mysql.com/doc/en/EXPLAIN.html http://www.mysql.com/doc/en/Where_optimisations.html http://www.mysql.com/doc/en/ORDER_BY_optimisation.html -- 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: Basic SQL join question
SELECT * FROM Projects INNER JOIN KeywordLink ON Projects.Id = KeywordLink.Pid INNER JOIN Keywords KeywordLink.Kid = Keywords.Id WHERE Keyword LIKE '%historical%' AND Keyword like '%scenic%'; 1. Note the single quotes. 2. You can place the join logic in the WHERE clause but I prefer the clarity obtained by keeping it in JOIN clauses and using the WHERE only to contain the include if logic. hth, Arthur -Original Message- From: Adam Randall [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 21, 2002 5:18 AM To: [EMAIL PROTECTED] Subject: Basic SQL join question Okay, I've thought about this every way I can conceive of, but I cannot figure out the sql query logic involved in joining three tables together. Here is what I am trying to do: I have three tables: keywords keywordlink projects keywords has these fields: id keyword keywordlink has these fields: id pid kid projects has a lot of fields, but it's primary key is ID What keywords holds is the keywords used in the various different tables in the database. keywordlink associates a project with several keywords: example keywords: id | keyword 1 | landscape 2 | historical 3 | scenic example keywordlink: id | pid | kid 1 | 1 | 2 2 | 1 | 3 3 | 2 | 1 4 | 2 | 3 example projects: id | name 1 | example 2 | extra Now, what I am trying to do is basically search the keywords database for keyword names, and then return a list of project names that are associated with those keywords. If the keywords were stored in the projects database, this is basically what I would want it to do (assume all the keywords are stored in a field called keywords in the projects table): SELECT * FROM projects where keywords like %historical% and keywords like %scenic%; This would return to me the projects that have historical and scenic in the keywords field. Now, how do I do this same operation with it broken out like I have above. The reason I am not storing the keywords in the projects table is that it would be quite a chore in changing the keywords in the system if I did that (modify one keyword, modify all the projects, etc). Anyone have any words of advice for me? Adam. -- --- Adam Randall http://www.xaren.net/ [EMAIL PROTECTED] http://nt.xaren.net/ [EMAIL PROTECTED] Macintosh users are a special case. They care passionately about the Mac OS and would rewire their own bodies to run on Mac OS X if such a thing were possible. -- Peter H. Lewis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to file a bug: Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command.
On 24 Sep 2002 at 9:16, Tobias Eriksson wrote: Hi How do I file a bug for mysql for Windows NT/2000/XP. Problem: Can not handle spaces in paths for the arguments given on the commandline to the mysqld-nt command. e.g. mysqld-nt --datadir=c:\Program Files\mysql\data Is not possible, nor is mysqld-nt --datadir=c:\Program Files\mysql\data [snipped to conserve bandwidth] Did you try: mysqld-nt --datadir=c:\Program Files\mysql\data -jan filter fodder: 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: Access denied in MyODBC
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi SanTa,
I think i may have an idea, have just tested this on my server. Granting
'USAGE' on all databases allows my 'testuser' account to connect to the
server through the mysql cli.
HOWEVER, if i try and issue a 'USE {database}' command I get access
denied because the user has only 'USAGE' privileges on all databases.
Since MyODBC connects to a single database, it would get an access denied
error with the USAGE priv.
issuing a 'GRANT SELECT ON *.* TO testuser@'%' IDENTIFIED BY password'
allows access for that user and my testuser can use any database.
danny
Sándor Tamás wrote:
| Sure I have. In fact if I use 'Grant', I don't have to 'flush'. But I've
| done it too. It didn't help.
|
| SanTa
|
| - Original Message -
| From: Danny Haworth [EMAIL PROTECTED]
| To: [EMAIL PROTECTED]
| Sent: Tuesday, September 24, 2002 12:56 PM
| Subject: Re: Access denied in MyODBC
|
|
|
|-BEGIN PGP SIGNED MESSAGE-
|Hash: SHA1
|
|Have you issues a 'FLUSH PRIVILEGES' to reload the privilege tables and
|pick up on the new grants?
|
|danny
|
|Sándor Tamás wrote:
|| I gave privileges with NetUser@'%'. But I still can't connect.
|| And through mysql command line I can connect, but with MyODBC, I can't.
||
|| SanTa
||
|| - Original Message -
|| From: Bryan [EMAIL PROTECTED]
|| To: 'Sándor Tamás' [EMAIL PROTECTED]; [EMAIL PROTECTED]
|| Sent: Tuesday, September 24, 2002 11:21 AM
|| Subject: RE: Access denied in MyODBC
||
||
|| Did you give netuser privileges for an i.p address (netuser@ip address
|| or netuser@%(anywhere), if not then then Netuser probably only can
|| connect as a localhost.
||
|| -=Bryan=-
||
||
||
|| -Original Message-
|| From: Sándor Tamás [mailto:[EMAIL PROTECTED]]
|| Sent: Tuesday, September 24, 2002 12:59 AM
|| To: [EMAIL PROTECTED]
|| Subject: Access denied in MyODBC
||
||
|| Hi,
||
|| I have a problem. I created a user called NetUser, and gave only usage
|| privilege on all databases. I can connect through mysql command line,
|| but I can't with ODBC. Is there anybody who know why it is? I need to
|| know this to higher the security of my tables.
||
|| Thanks,
|| SanTa
||
||
||
||
||
|| -
|| Please check http://www.mysql.com/Manual_chapter/manual_toc.html;
|
| before
|
|| posting. To request this thread, e-mail
|
| [EMAIL PROTECTED]
|
||
|| To unsubscribe, send a message to the address shown in the
|| List-Unsubscribe header of this message. If you cannot see it,
|| e-mail [EMAIL PROTECTED] instead.
||
||
|
|
|
|- --
|
|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
|
|iD8DBQE9kETfUKf+497XC3QRApHIAJ9iVnPPiydiqnkSPPEkAE3ggiwgzACfRbOY
|ACADl+ztMq7Zbrvua5eE1UA=
|=+I9q
|-END PGP SIGNATURE-
|
|
|-
|Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before
|posting. To request this thread, e-mail [EMAIL PROTECTED]
|
|To unsubscribe, send a message to the address shown in the
|List-Unsubscribe header of this message. If you cannot see it,
|e-mail [EMAIL PROTECTED] instead.
|
|
|
|
|
| -
| Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before
| posting. To request this thread, e-mail [EMAIL PROTECTED]
|
| To unsubscribe, send a message to the address shown in the
| List-Unsubscribe header of this message. If you cannot see it,
| e-mail [EMAIL PROTECTED] instead.
|
|
- --
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
iD8DBQE9kIwBUKf+497XC3QRApkpAJ9vJkTYspL1yddhRO6KE3njqONGggCggrKz
vqW5iDWmuxFXeIuqiirvPCo=
=cAYh
-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
UPDATE help
Greetings, I am currently working on a table that has a column called state and a column called stateid. All 42,000 records in this table have a 2 Letter abbreviation for that state (NY, CA, NV, etc) however. To eliminate redundancy, I have move the states to another table that contains an AUTO_INCREMENT field, the state abbr and the state name. A typical record looks like this 1,NY,New York I want to remove the city.state column from the and populate the city.stateid with values from state.id Does anyone have any ideas on how to build an UPDATE statement that will SELECT id FROM state WHERE state = city.state? Many Thanks SK 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: How much stable is MySQL in a production environment?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, | I would like to use MySQL in a production environment | (now I am using it in a development environment). Do | you know if is a frequent problem that the mysql | database damages suddenly? Have you experience with | this type of problems? I've been living life on the edge of a knife recently by using MySQL in a production environment since version 4.0.1 ;-p However although it was classified as alpha i have had no problems at all (apart from a small issue with 4.0.3 and temporary tables). So far mysql has been a solid db and a joy to work with. We have roughly 300 users, local and remote (spread all across the uk on broadband connections) and the system remains in use 24/7. It's been running solid now for seven months. 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 iD8DBQE9kI0RUKf+497XC3QRAqq7AJwJTDjBB3hmecB9E2rLW2h1OzmdFwCgnkfV JVMWRNiBqx0bMHcvZ1Gymf4= =w26b -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: replication problem
Adding a new discovery to this topic: The replication error only occurs on one of the 2 slave servers. There is no difference between the two in configuration. Hardware-wise, there is only one difference: the server which has the problem has 1 gig of RAM, and the one that does not experience the problem has 2 gigs. This being the only difference, I can only guess that it is the source of the problem. The table is very large that I am dealing with - the physical size is just over 1 gig. My only guess would be perhaps it is trying to do a CREATE TABLE before the DROP completes. David Piasecki -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 8:34 AM To: [EMAIL PROTECTED] Subject: re: replication problem David, Monday, September 23, 2002, 6:03:58 PM, you wrote: DP We are having a problem which seems to have appeared recently with DP replication on our mysql servers. DP - We have 3 servers set up with mysql 3.23.52 (they were running .49 but DP we upgraded in an attempt to fix this problem, which did not work), set DP up as a master and 2 slaves to the master. DP - There is a large script that runs on the master server. This script DP DROPs a large table, then recreates it. It is basically a DROP followed DP by a CREATE and many INSERTs. DP - Up until recently we have had no issues with this problem. Lately DP however the slave servers are not updating. The error we see in the logs DP is the table which it attempts to create already exists, therefore from DP that point on the replication stops. We can't understand why suddenly DP the DROP TABLE doesn't get replicated. David, does it happen every time when you drop the table or only sometimes? Is DROP TABLE statement present in binary logs? I tested on 3.23.52 and DROP TABLE replicated fine for me. -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Formatting data in a query
Hello all, is it possible to select only a certain number of characters from a field when running a query in MySQL? For example I would like to select the password and then the first 6 characters of the username in the username field (which is of type varchar). Thanks in advance! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Important question
At 07:59 AM 9/24/2002, you wrote: The developer in my software house put this message... Hi, I had been using mySql for a long time in lots of different computers, but now I had a strange problem and I would like to know if anyone can send me a message to help me solving the problem. I installed mySql 3.23.49 on a Dell PowerEdge 2400 with 1Gb RAM, dual processor, RAID 3 and Windows 2000 Server. Unfortunately, the machine was freezing every day, and some times twice a day. Some times, and really frequently, mySql was stopping execution showing the message on the screen: The memory could not be read ... mysqld-max-nt.exe. I've had a similar problem Cannot read from memory... or Cannot write to memory... that would occur a few times a week. It would occur with several different applications like text editors, graphics programs etc., so the problem is not with a single foreground application. I'm running Win2k update pack 2. I changed the memory a couple of days ago so it is too soon to tell if that was the problem. I suspect the problem may be a task running in the background like Norton Anti-virus or perhaps MySQL server itself. Are you running NAV? I'm running MySQL 4.0.1-alpha-max-nt. I changed firewalls and that did not help. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Create Tables Dynamically
since your are already using Perl, check out DBI at www.cpan.org - hcir On Monday, Sep 23, 2002, at 17:52 America/Anchorage, William Martell wrote: Hello All, I am building a web robot in perl that will find equipment from various manufacturers and will get information about that equipments specifications. Can you build tables in MySQL 4.0 dynamically with some type of script. Example. If if have 10 parts in my database and my robot checks with the manufacturers for new parts everyday. One day the robot says yes I found a new part that is not in our database. Can I write a script that will build a table in mySQL and will load the appropriate information. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Basic SQL join question
SELECT * FROM Projects INNER JOIN KeywordLink ON Projects.Id = KeywordLink.Pid INNER JOIN Keywords KeywordLink.Kid = Keywords.Id WHERE Keyword LIKE '%historical%' AND Keyword like '%scenic%'; Out of curiousity, does the order matter? I have a JOIN with about 6 tables, some are very small, some are quite large. I know with LEFT JOIN if I switched the order of the tables around, the queries could speed up or slow down dramatically. Is the same true with INNER JOIN? Still trying to completely grasp JOINs, getting closer though... Also, shouldn't the second INNER JOIN have an ON keyword? Josh 1. Note the single quotes. 2. You can place the join logic in the WHERE clause but I prefer the clarity obtained by keeping it in JOIN clauses and using the WHERE only to contain the include if logic. hth, Arthur -Original Message- From: Adam Randall [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 21, 2002 5:18 AM To: [EMAIL PROTECTED] Subject: Basic SQL join question Okay, I've thought about this every way I can conceive of, but I cannot figure out the sql query logic involved in joining three tables together. Here is what I am trying to do: I have three tables: keywords keywordlink projects keywords has these fields: id keyword keywordlink has these fields: id pid kid projects has a lot of fields, but it's primary key is ID What keywords holds is the keywords used in the various different tables in the database. keywordlink associates a project with several keywords: example keywords: id | keyword 1 | landscape 2 | historical 3 | scenic example keywordlink: id | pid | kid 1 | 1 | 2 2 | 1 | 3 3 | 2 | 1 4 | 2 | 3 example projects: id | name 1 | example 2 | extra Now, what I am trying to do is basically search the keywords database for keyword names, and then return a list of project names that are associated with those keywords. If the keywords were stored in the projects database, this is basically what I would want it to do (assume all the keywords are stored in a field called keywords in the projects table): SELECT * FROM projects where keywords like %historical% and keywords like %scenic%; This would return to me the projects that have historical and scenic in the keywords field. Now, how do I do this same operation with it broken out like I have above. The reason I am not storing the keywords in the projects table is that it would be quite a chore in changing the keywords in the system if I did that (modify one keyword, modify all the projects, etc). Anyone have any words of advice for me? Adam. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Connecting to remote database using MyODBC
AW Have been trying to connect to a remote MySQL server from Matlab through an AW ODBC connection, however the error is receive is AW [TCX][MyODBC]Can't connect to MySQL server on AW 'server name' (10060) AW I have searched the docs and archives and google... But can't see any answer AW to what this error means. Is MySQL server running? AW Yup, it is running. AW The connection works fine from machines within the building However AW remote machines cannot connect. I have also checked that the the database is AW available outside the firewall. Did you run MySQL server with --skip-networking options? or does skip-networking present in the my.cnf file? I always start the server with safe_mysqld. And the connections work from other machines within this building I received another message from someone to say that the 10060 error is a windows networking error Apparently the remote client is timing out as it is not getting a response or the right response from the server. Any ideas as to track down why its timing out? Thanks adam -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
granting does not give the correct privileges
Is this an error in Mysql? I do the follwing command from a shell grant insert on mydb.* to username@localhost identified by user 'pwd'; When I check the permissions the insert_priv field on user table of mysql db is set to 'N'. Why is that? I can change the privileges by giving an update command. Any ideas?, Nestor :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Security: is 'root' truly neccessary?
Being new to MySQL, it took a while to grok how security works. Now that I have a bit of a better understanding, a mental revalation is coming to the surface of my mind: since mysql users are NOT unix/windows-domain users, is the root user truly needed for a functional mysql environment? I do realize that there needs to be some user who essentially has all the grantable columns set to Y in the USER table, otherwise you could lose the ability to add or delete users, specify new databases, etc. I'm thinking this super user could (should?) be identified by something such as dba or admin -- anything other than the name of root. This would avoid the [probable] security hole of using the unix password as the mysql password for the root user (something I suspect many people have done without realizing the implications) simply because there would be no root user. I'm kind of guessing that one reason that the name root was chosen was because the command-line interface defaults the user name to your (unix) session name. By pre-building a root user, the authors avoided the need to teach the use of the -u switch during the initial setup of mySql (which is good and bad: good because it is one less thing for a new mysql admin to have to learn, bad because new admins haven't even been introduced to the security system, so they are likely to use their actual root password because they haven't yet been informed that mysql-users unix-users...) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODBC gets to mysql db with incorrect password
I have a db and a user with a pwd is allowed to access it. If my user and pwd is incorrect my php scripts can not access the db, which is what I expect. I colleague of mine just went into Mysql db using OBDC connection using microsoft Data source tool(I do not know much about microsoft) and he was able to access the Mysql db. I even went ahead and changed the password and did not tell him to what and he was still able to access Mysql db. He even make a connection but entering a bunch of characters. How is this possible? The database has only 2 user that are allow to access the db meaning there are only 2 entries in the user table of the Mysql db one of them being root. Any ideas? Thanks, Nestor :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Formatting data in a query
On 24 Sep 2002, at 16:23, [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: For example I would like to select the password and then the first 6 characters of the username in the username field (which is of type varchar). Check the string functions in the documentation: http://www.mysql.com/doc/en/String_functions.html SELECT password, LEFT(username, 6) FROM table_name ... [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
save meeeeeeeeee
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 information... thanks a million.. SOSS --- This email was brought to you by Foothill.net http://webmail.foothill.net/user/login.cgi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Security: is 'root' truly neccessary?
At 16:53 -0700 9/24/02, Tom Emerson wrote: Being new to MySQL, it took a while to grok how security works. Now that I have a bit of a better understanding, a mental revalation is coming to the surface of my mind: since mysql users are NOT unix/windows-domain users, is the root user truly needed for a functional mysql environment? I do realize that there needs to be some user who essentially has all the grantable columns set to Y in the USER table, otherwise you could lose the ability to add or delete users, specify new databases, etc. I'm thinking this super user could (should?) be identified by something such as dba or admin -- anything other than the name of root. This would avoid the [probable] security hole of using the unix password as the mysql password for the root user (something I suspect many people have done without realizing the implications) simply because there would be no root user. The user name in the superuser accounts doesn't have to be named root. It could just as well be powerless. I'm kind of guessing that one reason that the name root was chosen was because the command-line interface defaults the user name to your (unix) session name. By pre-building a root user, the authors avoided the need to teach the use of the -u switch during the initial setup of mySql (which is good and bad: good because it is one less thing for a new mysql admin to have to learn, bad because new admins haven't even been introduced to the security system, so they are likely to use their actual root password because they haven't yet been informed that mysql-users unix-users...) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: granting does not give the correct privileges
At 9:52 -0700 9/24/02, Nestor Florez wrote: Is this an error in Mysql? I do the follwing command from a shell grant insert on mydb.* to username@localhost identified by user 'pwd'; When I check the permissions the insert_priv field on user table of mysql db is set to 'N'. Why is that? Because the user table holds *global* privileges only. You didn't grant a global privilege, you granted a database-level privilege. Check the db table instead of the user table. I can change the privileges by giving an update command. Any ideas?, Nestor :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: granting does not give the correct privileges
Is this an error in Mysql? I do the follwing command from a shell grant insert on mydb.* to username@localhost identified by user 'pwd'; When I check the permissions the insert_priv field on user table of mysql db is set to 'N'. This always gave me a lot of confusion at first. If you select * from user, you are seeing the user privs, which I interpret to mean that if you have a Y for insert you can insert globally into ANY table. You'll want to check the db table instead which shows privs based on database name and username. Josh Why is that? I can change the privileges by giving an update command. Any ideas?, Nestor :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problems by compiling mysql-3.23.52 (gethostbyname)
After I do make I get an error: gcc -DDEFAULT_CHARSET_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHA REDIR=\/usr/local/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./.. /include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -c libmysql.c -fPIC -DPIC -o .libs/libmysql.lo libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_r' libmysql.c:1325: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/usr/local/src/mysql-3.23.52/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/mysql-3.23.52' make: *** [all-recursive-am] Error 2 I have linux suse 7.2 on A intel based system Can anybody help me with that? Greetingzz B. van Velzen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: granting does not give the correct privileges
Independent table permissions are stored in the 'db' table. Base user permissions are stored in the 'user' table. -Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 12:52 PM To: [EMAIL PROTECTED] Subject: granting does not give the correct privileges Is this an error in Mysql? I do the follwing command from a shell grant insert on mydb.* to username@localhost identified by user 'pwd'; When I check the permissions the insert_priv field on user table of mysql db is set to 'N'. Why is that? I can change the privileges by giving an update command. Any ideas?, Nestor :-) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Basic SQL join question
Oops! Quite right -- ON is necessary after the word JOIN. That was written in the email compiler :-) Sorry I should have proofread it before hitting Send. Arthur - Original Message - From: Josh Trutwin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 12:46 PM Subject: RE: Basic SQL join question SELECT * FROM Projects INNER JOIN KeywordLink ON Projects.Id = KeywordLink.Pid INNER JOIN Keywords KeywordLink.Kid = Keywords.Id WHERE Keyword LIKE '%historical%' AND Keyword like '%scenic%'; Out of curiousity, does the order matter? I have a JOIN with about 6 tables, some are very small, some are quite large. I know with LEFT JOIN if I switched the order of the tables around, the queries could speed up or slow down dramatically. Is the same true with INNER JOIN? Still trying to completely grasp JOINs, getting closer though... Also, shouldn't the second INNER JOIN have an ON keyword? Josh 1. Note the single quotes. 2. You can place the join logic in the WHERE clause but I prefer the clarity obtained by keeping it in JOIN clauses and using the WHERE only to contain the include if logic. hth, Arthur -Original Message- From: Adam Randall [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 21, 2002 5:18 AM To: [EMAIL PROTECTED] Subject: Basic SQL join question Okay, I've thought about this every way I can conceive of, but I cannot figure out the sql query logic involved in joining three tables together. Here is what I am trying to do: I have three tables: keywords keywordlink projects keywords has these fields: id keyword keywordlink has these fields: id pid kid projects has a lot of fields, but it's primary key is ID What keywords holds is the keywords used in the various different tables in the database. keywordlink associates a project with several keywords: example keywords: id | keyword 1 | landscape 2 | historical 3 | scenic example keywordlink: id | pid | kid 1 | 1 | 2 2 | 1 | 3 3 | 2 | 1 4 | 2 | 3 example projects: id | name 1 | example 2 | extra Now, what I am trying to do is basically search the keywords database for keyword names, and then return a list of project names that are associated with those keywords. If the keywords were stored in the projects database, this is basically what I would want it to do (assume all the keywords are stored in a field called keywords in the projects table): SELECT * FROM projects where keywords like %historical% and keywords like %scenic%; This would return to me the projects that have historical and scenic in the keywords field. Now, how do I do this same operation with it broken out like I have above. The reason I am not storing the keywords in the projects table is that it would be quite a chore in changing the keywords in the system if I did that (modify one keyword, modify all the projects, etc). Anyone have any words of advice for me? Adam. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: problems by compiling mysql-3.23.52 (gethostbyname)
After I do make I get an error: gcc -DDEFAULT_CHARSET_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\ -DSHA REDIR=\/usr/local/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID -I./.. /include -I../include -I./.. -I.. -I.. -O3 -DDBUG_OFF -c libmysql.c -fPIC -DPIC -o .libs/libmysql.lo libmysql.c: In function `mysql_real_connect': libmysql.c:1325: warning: passing arg 5 of `gethostbyname_r' from incompatible pointer type libmysql.c:1325: too few arguments to function `gethostbyname_r' libmysql.c:1325: warning: assignment makes pointer from integer without a cast make[2]: *** [libmysql.lo] Error 1 make[2]: Leaving directory `/usr/local/src/mysql-3.23.52/libmysql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/mysql-3.23.52' make: *** [all-recursive-am] Error 2 I have linux suse 7.2 on A intel based system Can anybody help me with that? Greetingzz B. van Velzen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Duplicate Key Error on non_unique key in large table
Hi everybody. I just joined since [EMAIL PROTECTED] had the closest hits for my question via google (entries from Oct. 2000). That list seems to no longer exist and this seems to be the most specific applicable list. My problem: I get the following MySQL error using Perl DBI. Error: Duplicate entry '2002-09-24' for key 3 While Executing: insert into AlcatelSC_port_perf (node_id, shf_no, slot_no, port_no, circ_no, filename, Col_Date, Col_Time, Class, Stat_ID, span, Poll_Method, Value, Error_ID, roll_Error_ID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) For Values: (26, 1, 8, 1, 0, 2002092461, 2002/09/24, 15:01:36, 6, 1083, 15, 1, 0, 0, ) Perl Says: DBD::mysql::st execute failed: Duplicate entry '2002-09-24' for key 3 at ../NEN/PNIMS/LoadStat.pm line 234. Problem is, key 3 ain't unique: mysql show index from AlcatelSC_port_perf; +-++--+--+-+ ---+-+--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +-++--+--+-+ ---+-+--++-+ | AlcatelSC_port_perf | 0 | portin |1 | stat_id | A | 207 | NULL | NULL | | | AlcatelSC_port_perf | 0 | portin |2 | node_id | A | 63213 | NULL | NULL | | | AlcatelSC_port_perf | 0 | portin |3 | shf_no | A | 63213 | NULL | NULL | | | AlcatelSC_port_perf | 0 | portin |4 | slot_no | A | 83106 | NULL | NULL | | | AlcatelSC_port_perf | 0 | portin |5 | port_no | A | 203283 | NULL | NULL | | | AlcatelSC_port_perf | 0 | portin |6 | circ_no | A | 204756 | NULL | NULL | | | AlcatelSC_port_perf | 0 | portin |7 | filename| A |28256363 | NULL | NULL | | | AlcatelSC_port_perf | 1 | fname|1 | filename| A | 256 | NULL | NULL | | | AlcatelSC_port_perf | 1 | dtin |1 | Col_Date| A | 5 | NULL | NULL | | +-++--+--+-+ ---+-+--++-+ 9 rows in set (0.00 sec) In fact, key 3 consisting of col_date is extremely non_unique: mysql select col_date, count(*) from AlcatelSC_port_perf - group by col_date order by col_date; ++--+ | col_date | count(*) | ++--+ | NULL | 265795 | | 2002-09-20 | 9263700 | | 2002-09-22 | 10412618 | | 2002-09-23 | 8196439 | | 2002-09-24 | 117811 | ++--+ 5 rows in set (2 min 36.82 sec) I've successfully inserted 28256363 records using the same INSERT statement shown above with varying values in the place holders, which leads to my last remaining hunch on the cause of the problem. Is 28 million records just stupid in this situation? I'm fine on available disk space, but the MYD file for this table is ~2Gig while the MYI file is ~9Gig which seems like a lot. On the other hand, this seems like a strange way for the table to tell me it's too big and now corrupt. If you don't have technical advice, maybe you have advice on where I can take this question, whether I should try to register this as a bug or take a reality pill and resign myself to either working with less data in one table or paying for a system that can handle it. Thanks; Jeremy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ODBC gets to mysql db with incorrect password
Nestor: You might not have entered the SQL FLUSH PRIVILEGES; command after you changed the password. Without it, the old data can remain in effect. Cheers, Kent Hoover - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 2006: MySQL server has gone away
Hi Gurus, I'm relatively new to MySQL - been studying it for the past 2 months. So far, so good (or Great). I recently moved from MySQL 3.23.22 to 4.0.2-alpha-debug-log on our 4.6.1-RELEASE-p10 FreeBSD server. Using the mysql client, I noticed an annoying message immediately after every query: ERROR 2006: MySQL server has gone away No connection. Trying to reconnect... Connection id:13 I checked in the error log file and find this repeated, for every occurance of this error on my screen: /usr/local/libexec/mysqld: read looped with error 35, aborting thread I've checked the variables and settings. All of the timeouts are default. +--+---+ | Variable_name| Value | +--+---+ | connect_timeout | 30| | delayed_insert_timeout | 300 | | flush_time | 0 | | innodb_lock_wait_timeout | 50| | interactive_timeout | 28800 | | long_query_time | 10| | net_read_timeout | 120 | | net_write_timeout| 180 | | slave_net_timeout| 3600 | | slow_launch_time | 2 | | timezone | EDT | | wait_timeout | 28800 | +--+---+ If I type queries real fast, immediately after eachother, I don't get this error. The error gets logged in the log file exactly 5 seconds after a query if I dont' type anything. 5 seconds!!! I've checked the /etc/my.cnf file and its default. No .my.cnf files to worry about. Any thoughts? Is this info useful at all: mysql status; -- mysql Ver 12.10 Distrib 4.0.2-alpha, for unknown-freebsdelf4.6 (i386) Connection id: 10 Current database: samp_db Current user: blairwag@localhost SSL:Not in use Current pager: stdout Using outfile: '' Server version: 4.0.2-alpha-debug-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 20 min 22 sec Threads: 1 Questions: 90 Slow queries: 0 Opens: 14 Flush tables: 1 Open tables: 8 Queries per second avg: 0.074 Memory in use: 46839K Max memory used: 46902K -- William Blair Wagner : Education is not always knowing the answer, [EMAIL PROTECTED] : ...but rather knowing where to look for it! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql, PHP and a wrapper
stat-box201 -*message began on php mailing list...no answer. Forwarding to mysql list 13:55-9-24 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 elseif I put on my script include_once(DB/mysql.php) I get Fatal error: Class db_common: Cannot inherit from undefined class pear in /usr/share/pear/DB/common.php on line 30 endif. :) can someone tell me how to preinclude /DB/* functions in my Zend engine so I do not have to include_once in every script. and if the php rpm needs to be installed how do I do that without breaking the install of mysql and apache. Brian.Dukemailto:[EMAIL PROTECTED] CTIP/TNT CFP IPSA Level(3) Communication (720) 888-7797 ==-=-=-=-=--==--==¬ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: granting does not give the correct privileges
Is this an error in Mysql? I do the follwing command from a shell grant insert on mydb.* to username@localhost identified by user 'pwd'; When I check the permissions the insert_priv field on user table of mysql db is set to 'N'. Why is that? I can change the privileges by giving an update command. I did't understand exactly, but here a mistake I made: What plattform? Are you using WinmySQLAdmin? - look section [WinMySQLadmin] -- [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
DBI fetchrow oddity
I am getting odd (to me) behavior from fetchrow and wonder if anybody else
is aware of this problem. Apologies in advance if I've overlooked something
really obvious, or if this is a long-squashed bug and I just need to update
our Perl modules.
Using Perl 5.6.0, DBI 1.14, DBD::mysql 2.0414, and MySQL 3.23.49.
$sth = $dbh-prepare(SELECT PeopleID, Lastname, Email
FROM People);
$sth-execute;
$sth-bind_columns(\$PeopleID, \$Lastname, \$Email);
while ( $sth-fetchrow ) {
print ID: $PeopleID\n ,
Name: $Lastname\n ,
Email: $Email\n\n;
}
IF the last value (Email) in any row is an empty string, the fetchrow
method returns false (and any remaining rows are not processed). Very bad
when the *first* row in the data set happens to have a blank value in the
last column.
I first thought this was due to the Email column in my particular table,
where it is not a primary key but is still required to be unique. However,
I was able to get the same results selecting a plain old varchar column.
Can also get this result with SELECT PeopleID, Lastname, Email, '' (and
adding a fourth parameter to bind_columns).
Removing the bind_columns statement and doing this instead
while ( ($PeopleID, $Lastname, $Email) = $sth-fetchrow ) {
# print something
}
works as expected. Also works properly doing fetchall_arrayref and stepping
through the returned data structure.
Is anybody else familiar with this behavior of fetchrow?
=
Michael Boudreau
Senior Electronic Publishing Developer
The University of Chicago Press
1427 E. 60th Street
Chicago, IL 60637-2954
phone: 773 753 3298
fax: 773 753 3383
=
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: creating indexes on production db
If i need to create / drop indexes from MyISAM tables how does the blocking work? I need to mess with some indexes on a production database, and dont want downtime. Should i do this in the middle of the night, when hardly anyone is using the system, or will the blocking be negligable? thanks sean peters [EMAIL PROTECTED] filter: 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
replacing/choosing a mysql database
I have installed Mysql and php on my rh 7.3 while installing o/s. I have tested php server and is working. I have been sent a database to use (file.sql) but am having difficulties figuring out where to put this file. When I try to connect to 127.0.0.1 get error unable to connect to database. I am having difficulties knowing where to put this file. __ 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: DBI fetchrow oddity
At 15:26 -0500 9/24/02, Michael Boudreau wrote:
I am getting odd (to me) behavior from fetchrow and wonder if
anybody else is aware of this problem. Apologies in advance if I've
overlooked something really obvious, or if this is a long-squashed
bug and I just need to update our Perl modules.
Using Perl 5.6.0, DBI 1.14, DBD::mysql 2.0414, and MySQL 3.23.49.
$sth = $dbh-prepare(SELECT PeopleID, Lastname, Email
FROM People);
$sth-execute;
$sth-bind_columns(\$PeopleID, \$Lastname, \$Email);
while ( $sth-fetchrow ) {
print ID: $PeopleID\n ,
Name: $Lastname\n ,
Email: $Email\n\n;
}
IF the last value (Email) in any row is an empty string, the
fetchrow method returns false (and any remaining rows are not
processed). Very bad when the *first* row in the data set happens to
have a blank value in the last column.
fetchrow is an old alias for fetchrow_array, a function that returns an
array. The behavior you're seeing is most likely due to calling an array
function in scalar boolean context, which will often result in puzzling
results.
Further evidence that this is so is that you get the proper behavior
with fetchall_arrayref.
I first thought this was due to the Email column in my particular
table, where it is not a primary key but is still required to be
unique. However, I was able to get the same results selecting a
plain old varchar column. Can also get this result with SELECT
PeopleID, Lastname, Email, '' (and adding a fourth parameter to
bind_columns).
Removing the bind_columns statement and doing this instead
while ( ($PeopleID, $Lastname, $Email) = $sth-fetchrow ) {
# print something
}
works as expected. Also works properly doing fetchall_arrayref and
stepping through the returned data structure.
You shouldn't need to step through the data structure. Use bind_columns
as you've been doing, and then call fetchrow_arrayref instead of fetchrow.
Your variables will have the row values bound to them as you want.
Is anybody else familiar with this behavior of fetchrow?
=
Michael Boudreau
Senior Electronic Publishing Developer
The University of Chicago Press
1427 E. 60th Street
Chicago, IL 60637-2954
phone: 773 753 3298
fax: 773 753 3383
=
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
client library no longer LGPL licensing
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? 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? Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question: Debugging Errors Server Logs
Hi all,
I'm new to the list. I looked a bit through the archives and couldn't
find an answer to my problem that addressed it in a way that helped me,
so I'm going to phrase it here.
I'm working on a PHP script that will take input and create several
table rows in mySQL based on this input.
Basically we have a generic form with many plain variables being passed
to the script.
The script is supposed to take the last several variables, make an
array, and with a foreach() statement, create table rows for each entry
in the array.
Example:
Var1 = John Doe
Var2 = 345 test dr.
var3 = Test City
var4 = Test state
var5 = Test Zip
etc
var6 = cars
var7 = boats
var8 = planes
$var_array = (cars, boats, planes)
foreach ($var_array as $value) {
$sql = INSERT into db.table (var1, var2, var3, var4, var5, var6)
VALUES ('$var1', '$var2', '$var3', '$var4', '$var5', '$value');
$result = mysql_query($sql)
or die (Unable to execute query.);
}
it will do the first one in the array, and error out on the 2nd..
consistently... ??
Is there something with this one I'm just not understanding, like a
problem with mySQL not wanting to do almost identical queries right
after each other..?
Also I can't figure out how to setup the mySQL query log, so that I can
find out what exactly is happening step by step, I've tried coding in as
much error logging as I can in the script, but it stops short here and I
can't find anything else out...
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
Select with order by clause on a MySQL BDB table returning incorrect
Dear List,
One of our MySQL db's containing BDB tables is exhibiting a strange
behavior.
A query consisting of an ORDER BY clause is returning wrong result set.
The
same query when used without an ORDER BY clause returns the correct
result
set.
Environment: Sun Solaris 2.7, MySQL 3.23.51, Table Type = BerkleyDB
Given below is the query for which we are seeing this issue:
select orders.order_uid, orders.status,
(to_days(now()) - to_days(orders.verification_date)) as age
from orders
where orders.status = 'verified'
order by orders.verification_date;
The above query returns:
+---++--+
| order_uid | status | age |
+---++--+
| 130 | new| NULL |
| 130 | new| NULL |
| 130 | new| NULL |
| 130 | new| NULL |
| 130 | new| NULL |
+---++--+
What SHOULD have been returned is:
+---+--+--+
| order_uid | status | age |
+---+--+--+
|57 | verified |4 |
|76 | verified |4 |
|79 | verified |4 |
| 233 | verified |3 |
| 234 | verified |0 |
+---+--+--+
Currently i get around this issue by analyzing the BDB tables, but this
seems to be a temporary solution. The issue is intermittent, keeps
surfacing
again after a certain no of days. Did not find any related bugs with the
MySQL version we use (3.23.51). From what i can understand so far, the
index
statistics related to the BDB tables are not getting updated.
What can be done to correct this issue ?
Are there any other alternative's to this issue ?
Would converting the BerkleyDB (BDB) tables to InnoDB tables solve the
issue ?
Here are a few other details about the BDB table that is exhibiting this
problem:
kcaset02:{}mysql sbiz
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 21716 to server version: 3.23.51-max-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql desc orders;
+-++--+-+-++
| Field |
Type
| Null | Key | Default | Extra |
+-++--+-+-++
| order_uid |
bigint(20)
| | PRI | NULL| auto_increment |
| creation_date |
datetime
| | | -00-00 00:00:00 ||
| modified_date |
timestamp(14)
| YES | | NULL||
| status |
enum('inprogress','new','submitted','verified','fulfilled','error','canceled')
| YES | | inprogress ||
| verification_num|
char(10)
| YES | | NULL||
| verification_method |
enum('third_party','customer_online','customer_fax','none')
| YES | | none||
| batch_number|
bigint(20)
| YES | | NULL||
| verification_date |
datetime
| YES | | NULL||
| salesmaker_fid |
bigint(20)
| YES | | NULL||
| legalese_fid|
bigint(20)
| | MUL | 0 ||
| loa_sig |
char(60)
| | | ||
| sa_sig |
char(60)
| | | ||
| sa_signed_date |
datetime
| YES | | NULL||
+-++--+-+-++
13 rows in set (0.00 sec)
mysql show table status like 'ord%';
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
Fw: Query to update column length
Hi all, I am writing an application that requires my application to possibly update the length of a char field while data is being imported into the db. First, can I update the size/type of a column using UPDATE? Would someone be willing to give me an example? thank you Shaun filter: mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL as a desktop DB
On Tue, Sep 24, 2002 at 10:41:26PM +0100, Adam Parker wrote: 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? I regularly use MySQL on my desktop. Under UNIX, at least, there are all sort of useful utilities that like to hook in. But is it faster than Access in the single-user environment, when dealing with large databases? I have no input, I'm sorry. I don't use M$ on my desktop. Thanks for any help. -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: Query to update column length
On Tue, Sep 24, 2002 at 05:56:23PM -0400, Shaun Bramley wrote: Hi all, I am writing an application that requires my application to possibly update the length of a char field while data is being imported into the db. First, can I update the size/type of a column using UPDATE? Would someone be willing to give me an example? I beleive 'UPDATE' updates records within a table, and 'ALTER TABLE' affects the characteristics of the table itself. thank you Shaun filter: mysql -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: Query to update column length
Ah, yes you are correct. Thank you for pointing me in the right direction. I will endevour to prevent my ID10T errors from showing up here in the future. Thank you again. - Original Message - From: Brian Reichert [EMAIL PROTECTED] To: Shaun Bramley [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, September 24, 2002 6:20 PM Subject: Re: Fw: Query to update column length On Tue, Sep 24, 2002 at 05:56:23PM -0400, Shaun Bramley wrote: Hi all, I am writing an application that requires my application to possibly update the length of a char field while data is being imported into the db. First, can I update the size/type of a column using UPDATE? Would someone be willing to give me an example? I beleive 'UPDATE' updates records within a table, and 'ALTER TABLE' affects the characteristics of the table itself. thank you Shaun filter: mysql -- Brian 'you Bastard' Reichert [EMAIL PROTECTED] 37 Crystal Ave. #303 Daytime number: (603) 434-6842 Derry NH 03038-1713 USA Intel architecture: the left-hand path - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: Query to update column length
Hi all, I am writing an application that requires my application to possibly update the length of a char field while data is being imported into the db. First, can I update the size/type of a column using UPDATE? Would someone be willing to give me an example? You will want to look at the ALTER TABLE syntax. If you want to change your field from CHAR(10) to CHAR(20) the syntax is: ALTER TABLE mytable MODIFY mycolumn CHAR(20); You may also need to tack on NOT NULL and/or PRIMARY KEY or other modifiers depending on your column as appropriate. Section 6.5.4 of the docs, one I have bookmarked! Josh thank you Shaun filter: mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
: help for mysql_fetch_row error on a large field
Hi, Lars,
Thanks. I have cracked down this problem.
It is very easy in C/C++, as follows:
int main(...)
{
max_allowed_packet = 1024 * 1024 * 32; /* 32M communication buffer needed */
.
}
Lin Kui
-邮件原件-
发件人: lars [mailto:lars] 代表 Lars Heidieker
发送时间: 2002年9月24日 22:47
收件人: Lin Kui
主题: Re: help for mysql_fetch_row error on a large field
Hi,
have a look for the variables max_allowed_packet which is 1Mb by default. It limits
the the size of the records that can be transfered. max_allowed_packet ist a server
configuration option and there is some client (16Mb default) option as well. Have a
look in the Manual and search for limits or packet
Lars
Lin Kui wrote:
Hi, all,
when I use mysql_fetch_row(myRes) and there is a very large field
(~30M long), my program crashed. How can I solve the problem?
For less than 5M long string/text, it works well. thanks.
My machine is Linux 7.3 MySQL is 4.0.3-beta.
Best regards.
~~
Lin Kui
College of Life Sciences
Beijing Normal University
Beijing 100875
P. R. China
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Mystische Erklärungen.
Die mystischen Erklärungen gelten für tief;
die Wahrheit ist, daß sie noch nicht einmal oberflächlich sind.
--Friedrich Nietzsche
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
