Re: Multi-table deletes
Bhavin, Saturday, June 15, 2002, 2:36:07 AM, you wrote: BV Just wanted to make sure before I proceed to write a script, BV Muti-table deletes as such: BV delete from Keyname_Keyvalue,Keyvalue WHERE BV Keyvalue.KeyvalueKey=Keyname_Keyvalue.KeyvalueKey AND BV Keyname_Keyvalue.KeynameKey='100'; BV ERROR 1064: You have an error in your SQL syntax near 'Keyvalue WHERE BV Keyvalue.KeyvalueKey=Keyname_Keyvalue.KeyvalueKey AND Keyname_Key' at line 1 BV Are not supported in 3.23 but supported in 4.x. Is that correct? Any other BV options besides writing a script? You used the second multi-table delete format. It will be supported in 4.0.2: http://www.mysql.com/doc/D/E/DELETE.html BV Regards, BV Bhavin Vyas. -- 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: Max in query
Claudio, Friday, June 14, 2002, 5:34:57 PM, you wrote: CC Is there a way to obtain max (or min) value in a query? CC Example: CC i want to know the last id in mytable table CC is there a way to do this query? CC something like CC select id from mytable where id = max; CC or something else? CC The one i wrote i tried it but it does not work. If the last id in your table is the maximum value per column: SELECT MAX(id) FROM table_name; Look at: http://www.mysql.com/doc/e/x/example-Maximum-column.html CC Thank you CC Claudio -- 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: unable to start msyql after installing from binary (Slackware 8.0)
rmwalle, Saturday, June 15, 2002, 4:33:08 AM, you wrote: ran Description: ran I have just completed the installation of the mysql binaries ran (mysql-3.23.49-pc-linux-gnu-i686.tar.gz) per the installation instructions, and am ran unable to start the mysql server--I receive the message mysql ended, and a ps -e ran or ps -aux fails to show an entry for mysql. ran How-To-Repeat: ran cd /usr/local ran tar -xvzf mysql-3.23.49-pc-linux-i686.tar.gz ran groupadd mysql ran adduser mysql and follow user account creation procedures ran ln -s mysql-3.23.49-pc-linux-gnu mysql ran cd mysql ran scripts/mysql_install_db ran chown -R root /usr/local/mysql ran chown -R mysql /usr/local/mysql/data ran chgrp -R mysql /usr/local/mysql ran chown -R root /usr/local/mysql/bin ran bin/safe_mysqld --user=mysql ran after executing this last line, I receive the following: ran [1] 2647 ran root@tank:/usr/local/mysql# Starting mysqld daemon with databases ran from /usr/local/mysql/data ran 020614 17:26:42 mysqld ended Show me the contents of your host_name.err 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: Where can I get libmysql.so
Hoa, Saturday, June 15, 2002, 1:52:52 AM, you wrote: HD I'm looking for the libmysql.so library. Does anyone know where I can get HD this? Probably did you mean libmysqlclient.so? It's a shared library. If you installed MySQL server from binary distribution, it should be included in your installation package (MySQL-shared package if official MySQL binary are used). If you use source distribution, you can find source there. HD -Hoa -- 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: authentification
Pierre, Monday, June 17, 2002, 12:59:18 PM, you wrote: PB is it possible to use unix password instead of the mysql sql password in PB the 'user' table ? Authentification in MySQL and *nix authentification are different. You should set up privileges in MySQL for your mysql users, these are not the same as *nix users. If you want you can specify for the same password for your MySQL user as your *nix user has. PB thanks, PB Pierre -- 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 to add the max_connections
Liu, Monday, June 17, 2002, 8:33:46 AM, you wrote: LQq Please tell me how to add the max_connections of mysql. Please give me a example. max_connections is a mysqld variable. You can't add\drop max_connections, you can only increase\decrease its value. If you want to change default value (100), you can specify new values in my.cnf file in the [mysqld] section: [mysqld] set-variable = max_connections = # or start mysqld with -O max_connections=# options. LQq Best Regards, LQq Q.H Liu -- 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
Backing up InnoDb
Hi, I'm just trying out the hotbackup utility (http://www.innodb.com/hotbackup.html) for a MySql InnoDb based database and was hoping somebody could help me with a few questions about the utility and InnoDb: 1. Firstly I'd like to know how mature the hotbackup utility is. The implementation I require it for could become quite intensive and is a critical piece of functionality of the system, so I need to know that the utility is stable. (Has anybody used it and what are your experiences of it?) 2. The hotbackup utility only backs up the data of our InnoDb database and not the .frm files containing the table definitions. Is there any way that you can lock the table definitions while still allowing for data insertion, deletion and modification? I basically want to ensure that the .frm files aren't modified while I back up the data. 3. If anybody can give me specifics on what kind of queries and actions will modify the .frm files that would also be useful. (I'm not all that worried about ALTER TABLE and CREATE TABLE as the system is not dynamic on that level, but DROP TABLE might be an issue.) Regards, -H Existentialism lead to nihilism. Nihilism lead to dancing. - Alara Rogers - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
temporary table
hi all, i have this php script which queries a table. The results are stored in a temprrary table CREATE temporary TABLE t1 SELECT .statements...; when I query this table in the same script i can see that the results wore indeed stored in t1. however when i call this table from a different script I get the error thet t1 doesn't exists anybody knows why? (mysql 3.23) thx Wilbert - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [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
mysqladmin status info...
Does anybody know a little more about what the info in mysqladmin 'status' tells about the mysqld? This may sound a little blunt, and maybe I could have found it in the manual somewhere. But still, I would like to get a few pointers on how to interpret information like this: Uptime: 1710735 Threads: 11 Questions: 10649406 Slow queries: 1035 Opens: 20617 Flush tables: 1 Open tables: 64 Queries per second avg: 6.225 Thanks, Eivind :-) sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Undo query in mysql
for MyISAM-Tables use your backup or your replication server, for transactional tables like Inno-DB or BDB you can use ROLLBACK A little stupid digression on my behalf here...: How do you differentiate between transactional and the other type (called...?) of tables you can use with MySQL...? Eivind sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: innodb keeps crashing due to out-of-memory errors.
Hi Heikki. Heikki Tuuri [EMAIL PROTECTED] writes: Why does InnoDB allocate so much memory in your case? If you follow the memory allocation with innodb_monitor, does the allocation grow steadily over days? Then it could be a memory leak in InnoDB. This might be the case. I started MySQL with a very big additional_mem_pool (400M) as you suggested. The server ran very stable for 12 hours. At first, memory allocation was like this: Total memory allocated 1499024287; in additional pool allocated 1205632 Total memory allocated 1499024287; in additional pool allocated 1651072 Total memory allocated 1499024287; in additional pool allocated 1815808 Total memory allocated 1499024287; in additional pool allocated 1887488 Total memory allocated 1499024287; in additional pool allocated 1962880 Total memory allocated 1499024287; in additional pool allocated 2005504 Total memory allocated 1499024287; in additional pool allocated 2029056 Total memory allocated 1499024287; in additional pool allocated 2060288 Total memory allocated 1499024287; in additional pool allocated 2068352 Total memory allocated 1499024287; in additional pool allocated 2106496 12 hours later: Total memory allocated 1499024287; in additional pool allocated 4044928 Total memory allocated 1499024287; in additional pool allocated 4049792 Total memory allocated 1499024287; in additional pool allocated 4046208 Total memory allocated 1499024287; in additional pool allocated 4038912 Total memory allocated 1499024287; in additional pool allocated 4049792 Total memory allocated 1499024287; in additional pool allocated 4048000 Total memory allocated 1499024287; in additional pool allocated 4046464 Total memory allocated 1499024287; in additional pool allocated 4046080 Total memory allocated 1499024287; in additional pool allocated 4043264 Total memory allocated 1499024287; in additional pool allocated 4046080 Total memory allocated 1499024287; in additional pool allocated 4049024 Total memory allocated 1499024287; in additional pool allocated 4059008 Total memory allocated 1499024287; in additional pool allocated 4067200 Total memory allocated 1499024287; in additional pool allocated 4063744 Total memory allocated 1499024287; in additional pool allocated 4049792 Total memory allocated 1499024287; in additional pool allocated 4061952 (The reason the server crashed was due to many threads - we had approx 350 threads and we hit the 2GB barrier with a bang). 1) Monitor the memory consumption with innodb_monitor. Is there a symptom of a memory leak? I will get back to you on this one ~ friday when I have more data. 2) Try a smaller buffer pool or bigger. Does the crash always happen when InnoDB has allocated about 1400 MB of memory? 3) Try setting innodb_additional_mem_pool much bigger, say, 400 MB. Does memory allocation still spill over from it? No. It runs very stable with a much bigger innodb_additional_mem_pool. Looks the problem is linked with increasing the size of the innodb_additional_mem_pool. Greetings, -- Per Andreas Buer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: temporary table
AFAIK, temporary table is session based. i.e. only the session creating the temporary table can manipulate the table. Wilbert Enserink wrote: hi all, i have this php script which queries a table. The results are stored in a temprrary table CREATE temporary TABLE t1 SELECT .statements...; when I query this table in the same script i can see that the results wore indeed stored in t1. however when i call this table from a different script I get the error thet t1 doesn't exists anybody knows why? (mysql 3.23) thx Wilbert - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [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 -- Sammy Lau mailto: [EMAIL PROTECTED] - Tell me what you want and I'll tell you how you can live without it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: temporary table
Wilbert: i have this php script which queries a table. The results are stored in a temprrary table CREATE temporary TABLE t1 SELECT .statements...; when I query this table in the same script i can see that the results wore indeed stored in t1. however when i call this table from a different script I get the error thet t1 doesn't exists I beliebe this is because temporary tables are only accessible from (and in) the session in which they are created, once the session closes the tables dissapear. Do a search for temporary in the MySQL manual (http://www.mysql.com) for more info on temporary tables. -H - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 prevent from Creating Large Numbers of Tables ???
On Tue, 2002-06-18 at 00:53, Xuefer wrote: (mailbox full? repost) I have many product CATE (category) and every CATE of products have different attribute how can I orgnize table struct ? each CATE a table with many cols for attribute? [cateid attr1 attr2 ... ] or get attribute in one table and each row one attribute [produceID attributeID attributeValue ] or any other ways? Hello Xuefer, You can use one or more SET type columns to store the properties. See http://www.mysql.com/doc/S/E/SET.html for more details. Good Luck! -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada ___/ 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
Glade with MySQL
Dear Friends, I am the maintainer of wingtk-wglade mailing list at: https://lists.sourceforge.net/lists/listinfo/wingtk-wglade There has been a question there regarding usage of MySQL with Glade. Can you kindly help? Ishan p.s.: winGTK wglade can be found at: http://wingtk.sourceforge.net - Original Message - From: Mark Lopus [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 2:18 PM Subject: [winGTK] wGLADE with MySQL -- How's it done? These two programs are EXCELLENT. As a relative newbie to the GUI programming world in need of a good tool for a serious project I'm working on, these two apps seem to be exactly what I need. But, The application I'm building is a pseudo-ERP system for a small manufacturing company in SE Asia. The database is mySQL and the interface is very heavy on the queries. I've been doing it in PHP-GTK which is easy but SLOW as I'm writing everything by hand...in searching for a better way I found wGLADE which works so well on my windows OSs. So my question to this list is: How can I use wGLADE and winGTK to help me rapidly generate mysql_query_centric GUIs? Again, I'm a bit of a newbie in this arena of programming and concepts (my apologies if the question is too off base for this group), but if anyone here can point me towards a solution or help in anyway I'd be most grateful! I did find an excerpt from a book on the subject of GLADE w/ MySQL, but it is out of context and therefore very difficult to understand. Thanks in advance for any advice!!! --M. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlserver debug
Hi,
Does anyone succeed to run embedded mySQL application
(libmysqlserver) built in Debug. I got RtlHeapValidate exception on
any mysql calls which allocates and free some memory. Crash appears
in:
-- cut ---
void my_no_flags_free(gptr ptr)
{
DBUG_ENTER(my_free);
DBUG_PRINT(my,(ptr: %lx,ptr));
if (ptr)
free(ptr); !
DBUG_VOID_RETURN;
} /* my_free */
---
It's appears only in Debug mode, Release work fine.
Any ideas?
Yura
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Search Engine
On Mon, 2002-06-17 at 22:06, Deependra B. Tandukar wrote: Greetings ! I need to develop a search engine for my site. I would be grateful if anyone could pass me any reference. Thank you. Hi Deependra! This question is asked fairly often. Please check the mailing list archives at http://lists.mysql.com/ Also, there are many resources on search engines on the web - check out http://alltheweb.com/search?cat=webcs=iso-8859-1l=anyq=build+search+engine+mysql+PHP Good Luck! -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada ___/ 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
Glade with MySQL
Dear Friends, I am the maintainer of wingtk-wglade mailing list at: https://lists.sourceforge.net/lists/listinfo/wingtk-wglade There has been a question there regarding usage of MySQL with Glade. Can you kindly help? Ishan p.s.: winGTK wglade can be found at: http://wingtk.sourceforge.net - Original Message - From: Mark Lopus [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 2:18 PM Subject: [winGTK] wGLADE with MySQL -- How's it done? These two programs are EXCELLENT. As a relative newbie to the GUI programming world in need of a good tool for a serious project I'm working on, these two apps seem to be exactly what I need. But, The application I'm building is a pseudo-ERP system for a small manufacturing company in SE Asia. The database is mySQL and the interface is very heavy on the queries. I've been doing it in PHP-GTK which is easy but SLOW as I'm writing everything by hand...in searching for a better way I found wGLADE which works so well on my windows OSs. So my question to this list is: How can I use wGLADE and winGTK to help me rapidly generate mysql_query_centric GUIs? Again, I'm a bit of a newbie in this arena of programming and concepts (my apologies if the question is too off base for this group), but if anyone here can point me towards a solution or help in anyway I'd be most grateful! I did find an excerpt from a book on the subject of GLADE w/ MySQL, but it is out of context and therefore very difficult to understand. Thanks in advance for any advice!!! --M. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Glade with MySQL
Dear Friends, I am the maintainer of wingtk-wglade mailing list at: https://lists.sourceforge.net/lists/listinfo/wingtk-wglade There has been a question there regarding usage of MySQL with Glade. Can you kindly help? Ishan p.s.: winGTK wglade can be found at: http://wingtk.sourceforge.net - Original Message - From: Mark Lopus [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 2:18 PM Subject: [winGTK] wGLADE with MySQL -- How's it done? These two programs are EXCELLENT. As a relative newbie to the GUI programming world in need of a good tool for a serious project I'm working on, these two apps seem to be exactly what I need. But, The application I'm building is a pseudo-ERP system for a small manufacturing company in SE Asia. The database is mySQL and the interface is very heavy on the queries. I've been doing it in PHP-GTK which is easy but SLOW as I'm writing everything by hand...in searching for a better way I found wGLADE which works so well on my windows OSs. So my question to this list is: How can I use wGLADE and winGTK to help me rapidly generate mysql_query_centric GUIs? Again, I'm a bit of a newbie in this arena of programming and concepts (my apologies if the question is too off base for this group), but if anyone here can point me towards a solution or help in anyway I'd be most grateful! I did find an excerpt from a book on the subject of GLADE w/ MySQL, but it is out of context and therefore very difficult to understand. Thanks in advance for any advice!!! --M. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 add the max_connections
Yes, thanks a lot. I still have a question though. Up to how many connection can mysql handle? Thanks, Louie... - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 3:29 PM Subject: Re: How to add the max_connections Liu, Monday, June 17, 2002, 8:33:46 AM, you wrote: LQq Please tell me how to add the max_connections of mysql. Please give me a example. max_connections is a mysqld variable. You can't add\drop max_connections, you can only increase\decrease its value. If you want to change default value (100), you can specify new values in my.cnf file in the [mysqld] section: [mysqld] set-variable = max_connections = # or start mysqld with -O max_connections=# options. LQq Best Regards, LQq Q.H Liu -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MAX_ROWS
Hello, I created a table using: CREATE TABLE a (pa VARCHAR (255) NOT NULL, pi VARCHAR (255), PRIMARY KEY (pa)) TYPE=HEAP MAX_ROWS=10 Then I inserted 16 recors. Later I done SELECT * FFROM a and mysql returned 16 records. Why this??? Does i should return only the last 10 records I inserted??? Please help me Nuno Lopes - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Backing up InnoDb
Hendrik, - Original Message - From: Hendrik Schalekamp [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, June 18, 2002 11:12 AM Subject: Backing up InnoDb Hi, I'm just trying out the hotbackup utility (http://www.innodb.com/hotbackup.html) for a MySql InnoDb based database and was hoping somebody could help me with a few questions about the utility and InnoDb: 1. Firstly I'd like to know how mature the hotbackup utility is. The implementation I require it for could become quite intensive and is a critical piece of functionality of the system, so I need to know that the utility is stable. (Has anybody used it and what are your experiences of it?) about 50 people have tested ibbackup. So far no critical bugs have been reported, but caution is still warranted. You should run ibbackup --restore yourbackupmy.cnf on your backups regularly so that you see they can be restored. Then start mysqld on the restored backup mysqld --defaults-file=yourbackupmy.cnf and run mysql --defaults-file=yourbackupmy.cnf mysql CHECK TABLE ... on some of the tables so that you see they are ok. You should set [mysqld] port=xxx socket=yyy ... [mysql] port=xxx socket=yyy in yourbackupmy.cnf so that the mysqld started on the backup does not disturb your real MySQL server. 2. The hotbackup utility only backs up the data of our InnoDb database and not the .frm files containing the table definitions. Is there any way that you can lock the table definitions while still allowing for data insertion, deletion and modification? I basically want to ensure that the .frm files aren't modified while I back up the data. I think not. An eventual solution to this inconvenience is that also the .frm files will be stored inside ibdata files. That will remove also the other problems with not in-sync .frm files. The fundamental problem here is that .frm files are not managed transactionally. That can be fixed by storing them inside InnoDB. If you make the tar file of the .frm files before the backup and immediately after the backup, usually the tar file taken AFTER the backup is the right one, because it does not take many seconds to back up very small (8 kB) .frm files. You can compare the tar file taken before the backup and after that, and if they are identical, then you know for sure they are up-to-date. If not, you have to use the mysqlbinlog tool to look at the binlog generated immediately after ibbackup finished its work. If ls -l reports that a .frm file was written later than the time ibbackup finished its work, then you may have to reconstruct the right .frm file manually using the binlog and the tar file taken before the backup. Hmm... I will add timestamps to the printout of ibbackup in version 1.03 so that you do not need to look at the binlog to determine the snapshot timepoint of the hot backup. Also, --restore will print the binlog file position of the snapshot so that you do not need to run mysqld to get that information. 3. If anybody can give me specifics on what kind of queries and actions will modify the .frm files that would also be useful. (I'm not all that worried about ALTER TABLE and CREATE TABLE as the system is not dynamic on that level, but DROP TABLE might be an issue.) ALTER TABLE, CREATE INDEX, DROP INDEX, CREATE TABLE, and DROP TABLE are the SQL commands, I think. Regards, -H Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://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
Alter table problem
Hello everybody !
I just give up. Can somebody tell me, what I do wrong ?
Here is script:
CREATE DATABASE servcontrol;
USE servcontrol;
CREATE TABLE czesc (
id_czesci CHAR(100) NOT NULL,
id_hurtowni TINYINT UNSIGNED NOT NULL,
id_nazwy INT UNSIGNED NOT NULL,
dokument SMALLINT UNSIGNED NOT NULL,
data_zakupu DATE NULL DEFAULT '-00-00',
okres_gw ENUM('brak','3 m-ce','6 m-cy','12 m-cy','24 m-ce','36 m-cy','60
m-cy') NOT NULL,
okres_gwk ENUM('brak','3 m-ce','6 m-cy','12 m-cy','24 m-ce','36 m-cy','60
m-cy') NOT NULL
) TYPE = INNODB;
CREATE TABLE nazwa (
id_nazwy INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
nazwa CHAR(100) NOT NULL,
kod CHAR(20) NOT NULL
) TYPE = INNODB;
CREATE TABLE hurtownia (
id_hurtowni TINYINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
nazwa CHAR(200) NOT NULL,
kod CHAR(20) NOT NULL,
adres CHAR(250) NOT NULL,
telefon CHAR(50),
email CHAR(100),
www CHAR(100),
dokument SMALLINT UNSIGNED NOT NULL
) TYPE = INNODB;
CREATE TABLE klient (
id_klienta INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
imie CHAR(30),
nazwisko CHAR(50),
adres CHAR(250) NOT NULL,
telefon CHAR(50),
email CHAR(100),
uwagi TEXT,
firma CHAR(200),
kod CHAR(20)
) TYPE = INNODB;
CREATE TABLE gwarancja (
id_gwarancji INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
id_klienta INT UNSIGNED,
data DATE NOT NULL
) TYPE = INNODB;
CREATE TABLE gwarancja_detal (
id_gwarancji INT UNSIGNED NOT NULL,
id_czesci CHAR(100) NOT NULL
) TYPE = INNODB;
CREATE TABLE problemy (
id_czesci CHAR(100) NOT NULL,
data DATE NOT NULL,
opis TEXT NOT NULL
) TYPE = INNODB;
CREATE TABLE reklamacja (
id_zdarzenia INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
id_czesci CHAR(100) NOT NULL,
id_klienta INT UNSIGNED NOT NULL,
data_rekl DATE NOT NULL,
opis_uszk TEXT NOT NULL,
uwagi TEXT,
osprzet TEXT,
data_odd DATE,
data_nap DATE,
opis_nap TEXT,
id_zastepczy char(100)
) TYPE = INNODB;
CREATE TABLE wymienione (
id_czesci_s CHAR(100) NOT NULL,
id_czesci_n CHAR(100) NOT NULL,
data DATE NOT NULL,
opis TEXT NOT NULL
) TYPE = INNODB;
CREATE TABLE wyslane (
id_wyslania INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
id_czesci CHAR(100) NOT NULL,
id_hurtowni TINYINT UNSIGNED NOT NULL,
data_wys DATE NOT NULL,
opis_uszk TEXT NOT NULL,
uwagi TEXT,
data_odd DATE,
opis_nap TEXT
) TYPE = INNODB;
CREATE TABLE pozyczka (
id_osoby INT UNSIGNED NOT NULL,
id_czesci CHAR(100) NOT NULL,
data DATE NOT NULL
) TYPE = INNODB;
CREATE TABLE pracownicy (
id_osoby INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
imie CHAR(30),
nazwisko CHAR(50)
) TYPE = INNODB;
ALTER TABLE czesc ADD PRIMARY KEY(id_czesci);
ALTER TABLE nazwa ADD UNIQUE(nazwa);
ALTER TABLE nazwa ADD UNIQUE(kod);
ALTER TABLE hurtownia ADD UNIQUE(nazwa);
ALTER TABLE hurtownia ADD UNIQUE(kod);
ALTER TABLE czesc ADD INDEX(id_hurtowni);
ALTER TABLE czesc ADD INDEX(id_nazwy);
ALTER TABLE gwarancja ADD INDEX(id_klienta);
ALTER TABLE gwarancja_detal ADD INDEX(id_gwarancji);
ALTER TABLE gwarancja_detal ADD INDEX(id_czesci);
ALTER TABLE problemy ADD INDEX(id_czesci);
ALTER TABLE reklamacja ADD INDEX(id_czesci);
ALTER TABLE reklamacja ADD INDEX(id_klienta);
ALTER TABLE reklamacja ADD INDEX(id_zastepczy);
ALTER TABLE wymienione ADD INDEX(id_czesci_s);
ALTER TABLE wymienione ADD INDEX(id_czesci_n);
ALTER TABLE wyslane ADD INDEX(id_czesci);
ALTER TABLE wyslane ADD INDEX(id_hurtowni);
ALTER TABLE pozyczka ADD INDEX(id_osoby);
ALTER TABLE pozyczka ADD INDEX(id_czesci);
ALTER TABLE czesc ADD CONSTRAINT FOREIGN KEY(id_hurtowni) REFERENCES
hurtownia(id_hurtowni) ON DELETE CASCADE;
ALTER TABLE czesc ADD CONSTRAINT FOREIGN KEY(id_nazwy) REFERENCES
nazwa(id_nazwy) ON DELETE CASCADE;
ALTER TABLE gwarancja ADD CONSTRAINT FOREIGN KEY(id_klienta) REFERENCES
klient(id_klienta) ON DELETE SET NULL;
ALTER TABLE gwarancja_detal ADD CONSTRAINT FOREIGN KEY(id_gwarancji)
REFERENCES gwarancja(id_gwarancji) ON DELETE CASCADE;
ALTER TABLE gwarancja_detal ADD CONSTRAINT FOREIGN KEY(id_czesci) REFERENCES
czesc(id_czesci) ON DELETE CASCADE;
/* HERE */ ALTER TABLE reklamacja ADD CONSTRAINT FOREIGN KEY(id_czesci)
REFERENCES czesc(id_czesci) ON DELETE CASCADE;
/* HERE */ ALTER TABLE reklamacja ADD CONSTRAINT FOREIGN KEY(id_zastepczy)
REFERENCES czesc(id_czesci) ON DELETE SET NULL;
ALTER TABLE reklamacja ADD CONSTRAINT FOREIGN KEY(id_klienta) REFERENCES
klient(id_klienta) ON DELETE CASCADE;
/* HERE */ ALTER TABLE problemy ADD CONSTRAINT FOREIGN KEY(id_czesci)
REFERENCES czesc(id_czesci) ON DELETE CASCADE;
/* HERE */ ALTER TABLE wymienione ADD CONSTRAINT FOREIGN KEY(id_czesci_s)
REFERENCES czesc(id_czesci) ON DELETE CASCADE;
/* HERE */ ALTER TABLE wymienione ADD CONSTRAINT FOREIGN KEY(id_czesci_n)
REFERENCES czesc(id_czesci) ON DELETE CASCADE;
/* HERE */ ALTER TABLE wyslane ADD CONSTRAINT FOREIGN KEY(id_czesci)
REFERENCES czesc(id_czesci) ON DELETE CASCADE;
ALTER TABLE wyslane ADD CONSTRAINT FOREIGN
Re: Installing MySQL on Server W2000
Efren, Tuesday, June 18, 2002, 3:55:36 AM, you wrote: EP Hi all, I'm installing MySQL Max 3.23 on a W2000 server, if I run the EP application locally everything is fine, but I can't connect on any other EP client Pc's (W98) is ther something else to do in a server, I just install EP it with default options (I'm newbie in MySQL). By default on Windows all local users have full privileges. From remote host only user 'root' without a password has access to the MySQL server. So, you should try to connect as user 'root' without a password or as local user and set up privileges for your users. Look at: http://www.mysql.com/doc/G/R/GRANT.html EP Thanks in advance !!! -- 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: mysqladmin status info...
Eivind, Tuesday, June 18, 2002, 11:31:19 AM, you wrote: EAS Does anybody know a little more about what the info in mysqladmin 'status' EAS tells about the mysqld? EAS This may sound a little blunt, and maybe I could have found it in the manual EAS somewhere. But still, I would like to get a few pointers on how to interpret EAS information like this: EAS Uptime: 1710735 Threads: 11 Questions: 10649406 Slow queries: 1035 EAS Opens: 20617 Flush tables: 1 Open tables: 64 Queries per second avg: 6.225 It's describen in the MySQL manual in the section 4.8.3 mysqladmin, Administrating a MySQL Server: http://www.mysql.com/doc/m/y/mysqladmin.html EAS Thanks, EAS Eivind :-) -- 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: myCC 0.8.4 alpha -- insert new row bug
Daevid, Tuesday, June 18, 2002, 1:20:27 AM, you wrote: DV I found a bug I think though: DV When you insert a new row into the table definition, even though it DV seems like it puts it in the right place, upon refresh, it actually puts DV it at the top of the table. Hmm.. I tested and it worked fine for me. So, in some cases new rows was added at the top of table; in other - at the middle, because MySQL stores rows in unsorted order. DV D. -- 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: newbie - start (innodb)
Silmara,
Monday, June 17, 2002, 10:22:48 PM, you wrote:
SCB MySQL, but if you alter datadir=C:/MYSQL, then the MySQL start, but if i try
SCB to use c:\mysql\bin\mysql sami_d1,i have the following error message from
SCB mysql:
SCB ERROR 1049: Unknown database 'sami_d1'.
SCB Thank you!
sami_db1 is an InnoDB table space, not a database. You should create
a database before you can use it.
Note: On Windows rather use backslash ('\') than '/' in the path to dirs
--
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: More than one foreign key in a table
B.K.R., Tuesday, June 18, 2002, 5:52:07 AM, you wrote: BKRS Can I have more than one foreign key defined in a BKRS single table using MySQL/Innodb table type? Yes, it's possible. BKRS It gives an error in .frm file, if tried to have BKRS that? BKRS Any solution? Check your CREATE TABLE definition. BKRS Happiness Always BKRS BKR Shivaprakkash -- 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: temporary table
Wilbert, Tuesday, June 18, 2002, 11:11:38 AM, you wrote: WE i have this php script which queries a table. The results are stored in a WE temprrary table WE CREATE temporary TABLE t1 SELECT .statements...; WE when I query this table in the same script i can see that the results wore WE indeed stored in t1. WE however when i call this table from a different script I get the error thet WE t1 doesn't exists WE anybody knows why? (mysql 3.23) It's a particular feature of TEMPORARY tables. TEMPORARY table is visible only for the connection that created it. Look at: http://www.mysql.com/doc/C/R/CREATE_TABLE.html WE thx Wilbert -- 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: max_connections / settings (info/help)
On Tue, 18 Jun 2002, louie miranda wrote: [mysqld] snip max_connections= 500 snip Hi i have here my [mysqld] settings, im having troubles though on max_connections I was wondering if this settings is correct, and what option is correct? snip max_connections is also a server variable, so the line should look like: set-variable = max_connections=500 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: how to prevent from Creating Large Numbers of Tables ???
SET? i know how to use SET but... attribute of products is value such as Size Weight Color and so on the problem is, different CATE of products have different bunch of attribute On Tue, 2002-06-18 at 00:53, Xuefer wrote: (mailbox full? repost) I have many product CATE (category) and every CATE of products have different attribute how can I orgnize table struct ? each CATE a table with many cols for attribute? [cateid attr1 attr2 ... ] or get attribute in one table and each row one attribute [produceID attributeID attributeValue ] or any other ways? Hello Xuefer, You can use one or more SET type columns to store the properties. See http://www.mysql.com/doc/S/E/SET.html for more details. Good Luck! -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada ___/ 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
last email, promised!
Due to the fact that I have received many personal emails, I now publish my last benchmark. Isn't a real query bench, because I don't test massively multithreading queries, but I launch sequential queries to misurate the impact time of the tcp open/close connection. So into this test we can (maybe) misurate only the I/O tcp speed of mysql daemons. The client access directly to libmysql.dll. The server version is the 3.23.51. I use a fantastic borland compiler. I reduced the output of the select at around 40 bytes (select limit 1)... so we can misurate only the I/O subsystem throughtput... Unfortunately I have a winxp pro copy on the pc where I have a linux 2.4 kernel, I think that a win2k server with kernel quantum table linear at 120 msec can do best results (~5-10% I suppose)... hovewer we can say that the mysql I/O under linux can be ~10-20% faster that the equivalent under xp version. www.dellapasqua.com/Linux2.4_pooled_LAN.gif www.dellapasqua.com/Linux2.4_NOTpooled_LAN.gif www.dellapasqua.com/XPPRO_pooled.gif www.dellapasqua.com/XPPRO_NOTpooled.gif www.dellapasqua.com/localhost_pooled.gif www.dellapasqua.com/localhost_NOTpooled.gif My thougths are: - a pooling manager it's obligatory under win2k-xp client-server if you use a localhost mysqlserver accessed directly by the libmysql.dll (to avoid the famous localhost nt bad behavior) - if you have a separate machine with mysql you can build a pooled connection manager only if you need massive performances (yahoo?) - if you use a middleware API to access mysql, more probably you already have a pooling object (as ADO for ms that it's autopooling) Thats'all and take these numbers only as curiosity! Greetings to all. Roberto. ps. if you want a more speedily mysql under NT it's necessary to change the code to use nt kernels primitives (iocomps, not blocking sockets...etc) ^_^ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1030: Got error 127 from table handler
Hello MySQL,
I do select:
select SUM(IF((@a:=(( ( ((@data:= DATE_FORMAT(data,'%Y-%m-%d')) IN
('2001-11-10','2001-12-22','2001-12-29')) OR (WEEKDAY(data) IN ('0','1','2','3','4'))
) AND (HOUR(data) '19' AND HOUR(data) ='8') ) AND !(@data IN
('2001-07-06','2001-08-15','2001-11-01','2001-11-02','2001-12-24','2001-12-25','2001-12-26','2001-12-31','2002-01-01','2002-03-11','2002-04-01','2002-05-01','2002-08-15','2002-11-01','2002-12-25','2002-12-26'))
)),in_s,'0')) as ipm, SUM(IF(@a, ot_s,'0')) as opm, SUM(IF(!@a, in_s,'0')) as inm,
SUM(IF(!@a, ot_s,'0')) as onm FROM _stat_._stat_10_4_1_10 where
DATE_FORMAT(data,'%Y-%m') = '2002-05' AND DATE_FORMAT(data,'%Y-%m-%d') BETWEEN
'-00-00' AND '-00-00' ;
got error:
ERROR 1030: Got error 127 from table handler
Please, HELP ME!
Thank very much.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Indexes
I would like to know if mysql have any resources to know when I execute any sql (eg. select) and I would like to know what index was used, like SQL server. Regards ___ Copa 2002 Yahoo! - Patrocinador oficial da Copa do Mundo da FIFA 2002 http://br.sports.yahoo.com/fifaworldcup/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Nulls and unique indexes.
Description: If a null column is used in a unique index then mysql fails to throw a key violation when multiple identical inserts (with nulls) are performed. How-To-Repeat: create table test (a int null, b int null); alter table test add unique index index_ab (a,b); insert into test (a,b) values(1,null); insert into test (a,b) values(1,null); insert into test (a,b) values(1,null); select * from test; +--+--+ | a| b| +--+--+ |1 | NULL | |1 | NULL | |1 | NULL | +--+--+ 3 rows in set (0.00 sec) insert into test (a,b) values(1,1); insert into test (a,b) values(1,1); ERROR 1062: Duplicate entry '1-1' for key 1 Fix: No fix. Submitter-Id: submitter ID Originator:Jon Barker Organization: MySQL support: none Synopsis: NULLs don't work correctly in unique indexes. Severity: serious Priority: Category: mysql Class: Release: mysql-3.23.41 (Official MySQL RPM) Environment: System: Linux x.catchword.co.uk 2.4.18ptixfs #11 Thu May 2 14:00:21 GMT 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/i586-mandrake-linux/2.96/specs gcc version 2.96 2731 (Linux-Mandrake 8.0 2.96-0.48mdk) Compilation info: CC='egcs' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='egcs' CXXFLAGS='-O6 -fno-omit-frame-pointer-felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Sep 28 2001 /lib/libc.so.6 - libc-2.2.2.so -rwxr-xr-x1 root root 1216268 Feb 21 2001 /lib/libc-2.2.2.so -rw-r--r--1 root root 26366908 Feb 21 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Feb 21 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man '--with-comment=Official MySQL RPM' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Indexes
I would like to know if mysql have any resources to know when I execute any sql (eg. select) and I would like to know what index was used, like SQL server. Regards ___ Copa 2002 Yahoo! - Patrocinador oficial da Copa do Mundo da FIFA 2002 http://br.sports.yahoo.com/fifaworldcup/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MS Access forms and auto numbers
Thanks Chris that was spot on. Also discovered by accident once it was working that Me.Refresh can have the same result. Alex -- Alexander Shaw Agricultural Stock and Assignment Photography -Original Message- From: chris lewis [mailto:[EMAIL PROTECTED]] Sent: 18 June 2002 00:45 To: Alexander Shaw Cc: [EMAIL PROTECTED] Subject: Re: MS Access forms and auto numbers Try using this in a code builder window: DoCmd.RunCommand acCmdSaveRecord Make sure that your table has a TimeStamp field configured. If it isn't there, Access will say that the record was deleted. I'm not sure if you need to requery the form or not. It's been 2 years since I last worked with a form like that. Chris - Original Message - From: Alexander Shaw [EMAIL PROTECTED] To: MySQL Win 32 List [EMAIL PROTECTED] Subject: MS Access forms and auto numbers Date: 15 Jun 2002 09:32:15 +0100 Hi, I'm trying to upsize an application to MS Access front-end and a MySQL backend. The problem I'm encountering is that some of the data written from a bound form depends on an auto-number field, which in the case of MySQL isn't updated from Null until the record is written by moving onto the next new record. So in effect what I would like to do is force the record to be written in the after-update event of an object on the form so that either the form or corresponding text box with the auto-number displayed can be updated so the data 'exists' for the later writes to take place. I'm sure this should be pretty simple but haven't been able to find anything about it. Any suggestions gratefully received. Alex -- Alexander Shaw Agricultural Stock and Assignment Photography --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.371 / Virus Database: 206 - Release Date: 13/06/2002 --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.371 / Virus Database: 206 - Release Date: 13/06/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.371 / Virus Database: 206 - Release Date: 13/06/2002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ideas to mysql replication
why the current implement of replication is so difficult to make use of? a few days recently, i though of mysql replication and got an ideas - idea 1: i leant it from IRC server no master and slave servers have equal rights and specify 1 and only 1 server as REGISTER SERVER(may be named as id server) all client update goto nearby server and server judge if the QUERY is and UPDATE/INSERT or SELECT for SELECT do locally for UPDATE/INSERT, which care about autoindex/primary key/unique index, do locally else, send to REGISTER SERVER, and wait for result(error OR last_insert_id()) this can solve non conflicting KEY updates between the tables problem but still can't solve update the sam rows on two servers -- idea 2: i've lookup the mysql client library code there's a code doing update/insert query AUTO redirect to master server only SELECT done in slave server but.. it's in CLIENT library if we got application in binary release, how can we make use of replication? query auto redirect should can be done in server, and we can do replication without even recompiling source -- do u guys have any other ideas ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Indexes
On Tue, 2002-06-18 at 13:48, Alexander Burbello wrote: I would like to know if mysql have any resources to know when I execute any sql (eg. select) and I would like to know what index was used, like SQL server. See EXPLAIN at http://www.mysql.com/doc/E/X/EXPLAIN.html -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada ___/ 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: ERROR 1030: Got error 127 from table handler
It seems that your table has been crashed. Try to check and repair your
table.
tl wrote:
Hello MySQL,
I do select:
select SUM(IF((@a:=(( ( ((@data:= DATE_FORMAT(data,'%Y-%m-%d')) IN
('2001-11-10','2001-12-22','2001-12-29')) OR (WEEKDAY(data) IN ('0','1','2','3','4'))
) AND (HOUR(data) '19' AND HOUR(data) ='8') ) AND !(@data IN
('2001-07-06','2001-08-15','2001-11-01','2001-11-02','2001-12-24','2001-12-25','2001-12-26','2001-12-31','2002-01-01','2002-03-11','2002-04-01','2002-05-01','2002-08-15','2002-11-01','2002-12-25','2002-12-26'))
)),in_s,'0')) as ipm, SUM(IF(@a, ot_s,'0')) as opm, SUM(IF(!@a, in_s,'0')) as inm,
SUM(IF(!@a, ot_s,'0')) as onm FROM _stat_._stat_10_4_1_10 where
DATE_FORMAT(data,'%Y-%m') = '2002-05' AND DATE_FORMAT(data,'%Y-%m-%d') BETWEEN
'-00-00' AND '-00-00' ;
got error:
ERROR 1030: Got error 127 from table handler
Please, HELP ME!
Thank very much.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Your favorite stores, helpful shopping tools and great gift ideas.
Experience the convenience of buying online with Shop@Netscape!
http://shopnow.netscape.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: insert into from select error
Hi David, Can you run the query in the MySQL command line client? -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada ___/ 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 problems
I'm having the same problems, but I've noticed that the reported error doesn't seem to be a real failure. The databases seem to be updated correctly. When I look at my slave error log, I can see that the at position is a number that always matches the size of the log file on the master. This cannot be a coincidence. Is it perhaps trying to read past the end of the log file or something? I haven't really looked at MySql in years because it's been working fine, but in setting up replication, I see now that I have some Innobase tables, some not. Haven't a clue how that happened, but my my.cnf does not have the related directives uncommented. This could be related to problems reading the logs, I assume? I'm doing some testing, but any suggestions appreciated. I don't have a spare server to play with and the master is our main production server, so I have to play carefully to remain employed. I tried with both master and slave running mysql-3.23.47-pc-linux-gnu-i686 and then tried moving the slave to 3..23.51 with the same error results. Thanks for any assistance, Jeff Jeff Hill www.HRpost.com Ph: 416-604-7251 Fx: 647-439-1414 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how and when mysql writes indexes and records
Hello. On Tue 2002-06-18 at 14:29:38 +0300, [EMAIL PROTECTED] wrote: Hello, Does anybody know how and when mysql writes records and indexes to harddrive? The main purpose of this question is below. I am using mysql 4.0.1 on win98 for test purposes. During the tests my computer halted suddenly because of a hardware problem. After restarting my computer i have seen that some of my tables which i were using when the problem arises have been crashed. I have repaired the tables but then i have noticed that the records which i inserted in the last half hour was lost. Does anybody have any comments about this? Well, mainly, don't use Windows 98 for any serious work. It is *not* suitable for production use of a database. It is difficult to make garantuees on when data is actually written to disks, but I seldom lost more than the few last seconds on outages, with different flavors of UNIX (including Linux). InnoDB type tables an be tuned to have a low risk of losing unwritten data (more precisely: to have few unwritten data) at the cost of speed. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
create a new table in a tablespace...
I'm using MySQL 4.0.1 and my question is How can i do to create a new table in a tablespace?. Thank you! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: How to add the max_connections
louie, Tuesday, June 18, 2002, 12:36:14 PM, you wrote: lm Yes, thanks a lot. lm I still have a question though. lm Up to how many connection can mysql handle? The maximum number of connections depends not only on max_connections value. It also depends on thread library on your OS, on amount of RAM, on what is your client doing. lm Thanks, lm Louie... -- 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: ERROR 1030: Got error 127 from table handler
tl,
Tuesday, June 18, 2002, 2:40:36 PM, you wrote:
t I do select:
t select SUM(IF((@a:=(( ( ((@data:= DATE_FORMAT(data,'%Y-%m-%d')) IN
('2001-11-10','2001-12-22','2001-12-29')) OR (WEEKDAY(data) IN ('0','1','2','3','4'))
) AND (HOUR(data) '19' AND HOUR(data)
t ='8') ) AND !(@data IN
t
('2001-07-06','2001-08-15','2001-11-01','2001-11-02','2001-12-24','2001-12-25','2001-12-26','2001-12-31','2002-01-01','2002-03-11','2002-04-01','2002-05-01','2002-08-15','2002-11-01','2002-12-25','2002-12-26'))
t )),in_s,'0')) as ipm, SUM(IF(@a, ot_s,'0')) as opm, SUM(IF(!@a, in_s,'0')) as inm,
SUM(IF(!@a, ot_s,'0')) as onm FROM _stat_._stat_10_4_1_10 where
DATE_FORMAT(data,'%Y-%m') = '2002-05' AND
t DATE_FORMAT(data,'%Y-%m-%d') BETWEEN '-00-00' AND '-00-00' ;
t got error:
t ERROR 1030: Got error 127 from table handler
It means that your table is broken. Repair it using REPAIR TABLE or
myisamchk utility:
http://www.mysql.com/doc/R/e/Repair.html
t Please, HELP ME!
t Thank very much.
--
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
MySQL on Cluster
Dear MySQL I'm about to buy two software products that uses MySQL, but I need to know if MySQL works in cluster. I have two servers and a disc cluster. If the server running has any problems, the other server will take over the cluster and run all the applications. Can MySQL also work in this environment? Best regards Frank Bredal [EMAIL PROTECTED] +47 90 01 40 10 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Binary update log how to disable ?
Hi list, just a tiny question, i use mysql 3.23.51 ( tar.gz binary ) under linux. All is fine, mysql is started without a problem ... 020618 14:28:04 mysqld started /usr/local/mysql-3.23.51/bin/mysqld: ready for connections I can see in /usr/local/mysql-3.23.51 some files like : localdomain-bin.xxx I assume that it's the binary update log, but i haven't that with my old 3.23.48. So please, how can i disable this log ?? Rgds 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
query efficiency question
Hi all, I have two tables containing the following: table1: +--++ | UNID | DATE | +--++ | 08294D5D0F9ABE6D46663300BDB6521C | 2001-09-09 02:00:30| | FF4210F70A19D36856663300BDB6521C | NULL | | FB499B109E1C6E143300BDB6521C | NULL | | 9429E5EC91F7508676663300BDB6521C | NULL | | 578313DA1378F96E86663300BDB6521C | 2001-10-21 02:00:40| ... etc etc table2: +-+--+---+--+ | ID | PO_UNID | CONTENT | PO_DOCID | +-+--+---+--+ | 519 | 08294D5D0F9ABE6D46663300BDB6521C | on| D6EBA9F0D5D49280C1256BDB00336664 | +-+--+---+--+ | 520 | 08294D5D0F9ABE6D46663300BDB6521C | off | DFAEFFFWE33771FSDSF428DSF355 | +-+--+---+--+ My problem is that the following query results in several thousand tupels: SELECT UNID FROM TABLE1 WHERE DATE IS NULL; Therefore I use: SELECT UNID FROM TABLE1 WHERE DATE IS NULL LIMIT 1; Now I want to do the following: SELECT UNID FROM TABLE1 WHERE DATE IS NULL LIMIT 1; SELECT CONTENT FROM TABLE2 WHERE PO_UNID='RESULT PREVIOUS QUERY' Instead of writing two queries this could be written as: mysql select 0.UNID, c.CONTENT - from table1 o, table2 c - where o.DATE IS NULL - and o.UNID = c.PO_UNID - LIMIT 1; This results query gives me the right result but it's execution time takes allmost 6 times longer then the two seperate queries. I'm planning to make these queries in a JAVA program (Using the JDBC-bridge). Which variation is smarter? Using the 2 queries, or using the second variation met the join? Any help would be greatly appreciated. Many Thanks, Harm de Laat Informatiefabriek The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: how to prevent from Creating Large Numbers of Tables ???
On Tue, 2002-06-18 at 12:28, Xuefer wrote: SET? i know how to use SET but... attribute of products is value such as Size Weight Color and so on the problem is, different CATE of products have different bunch of attribute Heh. Sorry - should have read more carefully. On Tue, 2002-06-18 at 00:53, Xuefer wrote: (mailbox full? repost) I have many product CATE (category) and every CATE of products have different attribute how can I orgnize table struct ? each CATE a table with many cols for attribute? [cateid attr1 attr2 ... ] or get attribute in one table and each row one attribute [produceID attributeID attributeValue ] or any other ways? Option one is good if you have a small number of attributes that are not likely to change. A major drawback is that you will need to alter the table to add/delete additional properties. Option two is more flexible, and will be more efficient for large numbers of dissimilar attributes. This approach is also better when you need to add/delete attribute types. If you have *very* dissimilar attributes and sets of attributes for each item then you might want to store the data in a serialized form in a blob field. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada ___/ 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: migrating user accounts
Thanks for the response! I'm comfortable with it but I wanted a second opinion. -Josh Galen Wright-Watson wrote: On Wed, 12 Jun 2002, Joshua Horton wrote: Hi, snip First, I'm having trouble determining whether or not it is possible to drop a user, or whether I have to go in and delete all that user's records in the grant tables. I revoke ALL PRIVILEGES from the user, but his entry still apears in the mysql.users table. I have heard it is undesirable to directly manipulate the users table. snip I think you can only remove a row from MySQL.user directly. True, GRANT is preferred to add and alter user accounts, but DELETEing the user's entry in MySQL.user is fine. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Database replication on mirrored servers
Hi, I have installed mysql 4.0 in redhat 7.2 now. I have two such servers with mysql on it and I am now trying to configure them for replication. 1. I could not find my.cnf or my.ini on the box after installing mysql. Won't mysql create those file during installation or do I need to create manually ? Do I need both files ..? 2. I choose to shutdown the master mysql server for replication. When I try to bring it back it says it cannot find mysql.sock in the path. That particular file is not present in the box. How can I get the file ? 3. As I told I have two similar unix box one of which will be main server where the master database is. During failover of Ist server the 2nd server will be taking over Ist servers work additional to second servers work. The 2nd server have slave mysql database. During failover of ist database do I need to make slave database in 2nd server as master..or keep it as slave? How does it work..? Any help will be appreciated Regards _ Communicate with others using Lycos Mail for FREE! http://mail.lycos.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: I'd like to use MySQL with WindowsXP.
Why don't you try to download MySQL from www.mysql.com? Maybe your CD-copy is corrupted. Good luck! --- Dean Harding [EMAIL PROTECTED] wrote: It sure does work on XP. I'm using it right now... What error does it give, or if no errors, what happens when you try to run it? Dean Harding. -Original Message- From: ÎèC [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 18 June 2002 3:28 pm To: [EMAIL PROTECTED] Subject: I'd like to use MySQL with WindowsXP. Dear Sirs I have MySQL version 3.23.49. MySQL CD was included Japanese monthly publication( Nikkei Software). This book said MySQL is able to work on Windows 95/98/2000/Me/NT/XP. Then I tried to install MySQL to WindowsXP(home edition) PC. But is does not work. I would like to use MySQL on Windows XP. Please advise me what wrong. Is it possible to use on WindowsXP ? Best regards Osamu Ishizaki [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 __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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: Embedded MySQL server crashing
Sorry for the ambiguity. My application is a gui application written in Borland C++ Builder 6. It features one form with 4 buttons consisting of Create, Connect, Disconnect, Destroy. Only the relevant buttons are availible at certain times. (For instance, you cannot destroy a server when one is not created, therefore you have to click create in order to hit destroy). The purpose of the Create button is to call mysql_server_init, which creates the mysqld embedded server. After which you hit connect to connect to the created server, and then you can disconnect and destroy the server with their respective buttons. I can click the following button and have it crash: o Create button o Destroy button o Create button again o Destroy button --(Crashes here) I hope this clears things up. The destroy button simply calls the mysql_server_end(), and nothing else, just to kill the server. The speed issues I had before (with it waiting 30 seconds to kill the server) were resolved with adding the skip-innodb option to my configuration file. This also fixed the previous crash after creating the server the second time, but now has moved the crash one step ahead, the destruction of the server. Ted -- Ted Morse CIHOLAS Enterprises [EMAIL PROTECTED] On Tue, 18 Jun 2002, miguel solorzano wrote: At 08:35 17/6/2002 -0500, Theodore Morse wrote: Hi, I tried the skip-innodb in my configuration file, it helps to a point, now I can create the server twice, but can only destroy it once, the procedure goes like this: Please clarify: o Create server o Destroy server Your application is closed ? or you did the below server instance immediately the above destroy action without to know if the server clean up was finished ? o Create server o CRASH!! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database Structure
How are you connecting to MySQL?, through MySQL ODBC I am assuming. I might happen that the ODBC driver for MySQL does not implement ADOX functionality. Have you tried to take a look to the MySQL++ API? You might have to create your own dll (or COM component) to modify the database structure from your application. Good Luck! --- Efren Pedroza [EMAIL PROTECTED] wrote: Hi everyone, I just become a MySQL user and I am trying to migrate my application from Access 2000 / SQL Server to MySQL, my system was developed with MS Visual Basic 6 SP5, everything seems to be Ok, but in my application I modify often Database Structure using ADOX to retrive structure and modify it, but when the program try to retrive the structure nothing works, how can I get structure database from VB ? Is there a way to do that ? Or maybe I've to try with some tool that I don't known. Any comment or suggestion is welcomed !!! 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 __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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: Re: Re: how to prevent from Creating Large Numbers of Tables ???
thx for replying it's really a new course for me option 1 will still make lots of tables does option 2 waste of space ? cause 2 id with only 1 value i'm going to make table as described below. i wonder it's feasibility also bring another question here: my forum has favorite table for use to collect their favorite post Table `favorite`: cols: userid INT, postid INT unique index(userid, postid) only a pair of ID pre row question: does this struct waste of space? if so, any better solution ? - struct of product attribute: - Table `cate`: cols: cateID cateName example row: 1 switches-100 Table `Attribute`: cols: cateID attributeID attributeName displayOrder example row: 1 1 color 1 1 2 size 2 Table `product`: cols: cateID productID productName productDescription example row: 1 1 greenswitch blah blash... Table `AttributeValue`: cols: productID attributeID attributeValue(varchar) example row: 1 1 green 1 2 10*10 - to delete attribute: DELETE FROM Attribute where attributeID=$id DELETE FROM AttributeValue where attributeID=$id On Tue, 2002-06-18 at 12:28, Xuefer wrote: SET? i know how to use SET but... attribute of products is value such as Size Weight Color and so on the problem is, different CATE of products have different bunch of attribute Heh. Sorry - should have read more carefully. On Tue, 2002-06-18 at 00:53, Xuefer wrote: (mailbox full? repost) I have many product CATE (category) and every CATE of products have different attribute how can I orgnize table struct ? each CATE a table with many cols for attribute? [cateid attr1 attr2 ... ] or get attribute in one table and each row one attribute [produceID attributeID attributeValue ] or any other ways? Option one is good if you have a small number of attributes that are not likely to change. A major drawback is that you will need to alter the table to add/delete additional properties. Option two is more flexible, and will be more efficient for large numbers of dissimilar attributes. This approach is also better when you need to add/delete attribute types. If you have *very* dissimilar attributes and sets of attributes for each item then you might want to store the data in a serialized form in a blob field. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada ___/ 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 on Cluster
Can you give some more information about this disc cluster? The term to me is vague. I am assuming that it's NOT a RAID array, but I'm also guessing that it's not a reference to a group of machines either. Can you explain some more? Later on, TRC - Original Message - From: Frank [EMAIL PROTECTED] Date: Tue, 18 Jun 2002 14:25:33 +0200 To: [EMAIL PROTECTED] Subject: MySQL on Cluster Dear MySQL I'm about to buy two software products that uses MySQL, but I need to know if MySQL works in cluster. I have two servers and a disc cluster. If the server running has any problems, the other server will take over the cluster and run all the applications. Can MySQL also work in this environment? Best regards Frank Bredal [EMAIL PROTECTED] +47 90 01 40 10 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- ___ Download the free Opera browser at http://www.opera.com/ Free OperaMail at http://www.operamail.com/ Powered by Outblaze - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 needed ..mysql replication on mirrored servers...
Hi, I will appreciate for any suggesstion on best plan... I am working on setting up a production environment with mirrored servers working on redhat 7.2. To balance the load, each servers have its own primary applications but all of them are mirrored. When the Ist server fails the floating alias name is tranferred to the second server manually. 2nd server then inherits the application running on 1st server. So when failover happeneds the 2nd server should run all the applications. When first server comes back on line ist servers applications are transferred to 1st server back. One of the application is using PHP and MYSQl. I have replicated databases using MYSQL replication such a way that Ist server contains master and 2nd server contains slave. This part is working properly. My question is regarding effect on MYSQL database on failover. I have to design the stratergy for failover. My intention is to keep least work during failover so that people who deal with failover do not need to bothered about database stuff. I can think about two options. When failover happeneds : 1. Make 2nd server database master, so that when 1st server comes on line it will start as slave and update databases. Then I can switch back Ist server to master again like before failover. (Or may be does mysql slave update master... or I can force updation of master again...) 2. Take a back up of 2nd server database and update ist server database when it comes on line again. Which is error prone.. I am just wondering is there any better plan How you guys are doing this...? Any input is appreciated... Regards _ Communicate with others using Lycos Mail for FREE! http://mail.lycos.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
How to compile a UDF under win32?
Hi, All. Please, tell my how to compile a UDF under win32. For example, udf_example.cc cl /GX /TP /nologo /c udf_example.cc link /nologo /dll /out:udf_example.so udf_example.obj It do not export the functions :-( dumpbin /export udf_example.so DUMPBIN : warning LNK4044: unrecognized option export; ignored Dump of file udf_example.so File Type: DLL Summary 1000 .data 1000 .rdata 1000 .reloc 3000 .text Best, Nick. 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: getting totals with data
On Monday, June 17, 2002, at 05:44 PM, Galen Wright-Watson wrote: Another option is to SELECT INTO a temporary table (or CREATE TEMPORARY ... SELECT), then query the temporary table for the total_hits. Would the overhead of generating a temporary table for this query be worthwhile? I'm wondering, since the query will be executed by a PHP script (which of course has a number of other queries that execute along with it). Or would just having a query that strictly returns a COUNT of results, then a separate query returning the actual results (but constrained by LIMIT) be more resource-efficient... I wonder. The reference to table1.total_hits is correct only if table1 has a column called total_hits. You don't need to (and can't) prefix a column alias by a table name (I think; a few small experiments seemed to confirm this). This is useful knowledge, I somehow thought that aliased result columns could be treated like regular columns. I just thought of another possibility if all you want is the number of matching rows. If you're using an SQL client, it should report the number of rows returned. If you're using an API to talk to the server, there should be a function to get the number of rows in a query result (e.g. mysql_num_rows() in the C and PHP APIs). This would be perfect except that it seems that my LIMIT clause (which helps keep the number of results that are handed to the PHP script and turned into HTML low) would yield the LIMITed number of rows, whereas I'm trying to determine how many rows would be returned if I had not used LIMIT (the total hits part of displaying X through X of X total hits). Thanks for the pointers, Galen. Erik PS: to any who respond to this thread, please CC me as I have temporarily unsubbed the list. Erik Price Web Developer Temp Media Lab, H.H. Brown [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
INSERT to table from text file
Hello, I'm looking for a solution to INSERT data from a text file that is used for logging into a MySQL table. A hypothetical example... I have a server (any server, could be a RADIUS, a DNS or a MTA) that logs to a file in /var/logs/log-file. Is there a way to take the raw data sent to the log file and INSERT it into a table? Can this be done on the fly, meaning, the data isn't stored in the flat text file at all, but rather the service sends the data to the log file and instead of being written to the file, it's sent to a table. Does this sound like a job for Perl/DBI/DBD? Thanks for any in site or comments, Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 a new table in a tablespace...
Silmara, Tuesday, June 18, 2002, 3:43:48 PM, you wrote: SCB I'm using MySQL 4.0.1 and my question is How can i do to create a new table SCB in a tablespace?. Tablespaces are used only for InnoDB tables. If you create InnoDB table, it will be stored in InnoDB tablespace. How to create InnoDB tables read in the manual: http://www.mysql.com/doc/U/s/Using_InnoDB_tables.html SCB Thank you! -- 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: inoodb autoextend problem, solaris 2.7, 4.0.1-alpha-max
Anthony, Monday, June 17, 2002, 5:13:23 PM, you wrote: ARJB I am trying to play with innodb tables in 4.0.1-alpha-max on ARJB Solaris 2.7, but I am having a problem with setting up an ARJB autoextend tablespace... as soon as I put :autoextend at the ARJB end of my innodb_data_file_path line I get: ARJB 020617 09:56:25 mysqld started ARJB InnoDB: syntax error in innodb_data_file_path ARJB 020617 9:56:25 Can't init databases ARJB 020617 09:56:26 mysqld ended ARJB here is my my.cnf file... am I missing something? Autoextended tablespace is supported since 3.23.50 and 4.0.2 versions of MySQL. -- 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: creating a full text index
RWilson, Monday, June 17, 2002, 9:04:19 PM, you wrote: R I am trying to create a full text index on a column R I input R create FULLTEXT index [nameofindex] on [tablename] (columnname(15)); R when I put this in at the console I get R error on rename of databasename.myi file. R can I get some help on the issue. Hm.. Can you provide more info? i.e. full error message and exact CREATE FULLTEXT INDEX statement? R Robert J Wilson R Windows Server Team R 816-997-5796 -- 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
Irix problems with persistent connections
Hi all, I'm using mysql version 3.23.49 on irix 6.5.16. The problem that i have occurs when i establish connections from a Winnt wokstation using php. I establish the connections to the database using p_connect. Sometimes the connections that are established using p_connect don't respond. But if i use connect instead of p_connect everything works fine. Any idea? Mariano Galuzzi Multicanal S.A. Avalos 2057 - C1431DPM Bs. As - Argentina Tel.: (54 11) 4524 4883 Fax: (51 11) 4524 4559 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23.51+ for AIX
Any word on when to expect a working binary release of mysql for AIX 4.3.3? Morris Ford __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.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
make err: ld: fatal: library -ldl: not found?
This is my configure line; setenv CFLAGS -O3 setenv CXX gcc setenv CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/lycra/homes/fike/bugz/mysql --enable-assembler --with- mysqld-ldflags=-all-static Then I run gmake and the following error is reported. It seems pretty straight forward however I don't know how to correct it, any help appreciated; gcc -O3 -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fno-i mplicit-templates -fno-exceptions -fno-rtti -DHAVE_CURSES_H -I/lycra/homes/f ike/bugz_src/mysql-3.23.49/include -DHAVE_RWLOCK_T -o mysqld sql_lex.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o thr_malloc.o item_create.o field.o key.o sql_class.o sql_list.o net_serv.o violite.o net_pkg.o lock.o my_lock.o sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o hostname.o convert.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o sql_insert.o sql_update.o sql_delete.o sql_do.o procedure.o item_uniq.o sql_test.o log.o log_event.o init.o derror.o sql_acl.o unireg.o time.o opt_range.o opt_sum.o opt_ft.o records.o filesort.o handler.o ha_heap.o ha_myisam.o ha_myisammrg.o ha_berkeley.o ha_innobase.o ha_gemini.o ha_isam.o ha_isammrg.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o sql_cache.o slave.o sql_repl.o mini_client.o mini_client_errors.o md5.o stacktrace.o -static ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -ldl -lpthread -lthread -lz -lcrypt -lgen -lsocket -lnsl -lm -lpthread -lthread ld: fatal: library -ldl: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found ld: fatal: File processing errors. No output written to mysqld collect2: ld returned 1 exit status gmake[3]: *** [mysqld] Error 1 gmake[3]: Leaving directory `/lycra/homes/fike/bugz_src/mysql-3.23.49/sql' gmake[2]: *** [all-recursive] Error 1 gmake[2]: Leaving directory `/lycra/homes/fike/bugz_src/mysql-3.23.49/sql' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/lycra/homes/fike/bugz_src/mysql-3.23.49' gmake: *** [all-recursive-am] Error 2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Interesting problem with Alter table and foreign keys on 3.23.51
Below is an example of a problem I'm having when issuing an alter table command to create a foreign key in mysql version 3.23.51. I am running the max version and the tables exist in the innodb table space. Thoughts? Comments? Criticism? Carl McNamee Systems Administrator Billing Concepts (210) 949-7282 mysql alter table Table2 add constraint foreign key (par_id) references Table1 (id); ERROR 1005: Can't create table './test/#sql-6b2e_f.frm' (errno: 150) mysql show create table Table1\G *** 1. row *** Table: Table1 Create Table: CREATE TABLE `Table1` ( `id` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=InnoDB 1 row in set (0.00 sec) mysql show create table Table2\G *** 1. row *** Table: Table2 Create Table: CREATE TABLE `Table2` ( `name` char(10) NOT NULL default '', `par_id` int(11) NOT NULL default '0', PRIMARY KEY (`name`) ) TYPE=InnoDB 1 row in set (0.00 sec) 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
How to duplicate records
Hello all, I've got some records of a Database that I would like to duplicate if possible with an statement. The table has Code, Model, Year, units. The primary key is Code, Model and Year. What I need is to duplicate Code, Model and units for a different year. Say I want to duplicate all records which Code are N200 and N205 with the same model and same units but for year 2003. Is there any select and insert/replace statement to acomplish this? There are about 3.000 records and doing that manually is impossible. I am considering dump the whole file to a .csv and change year to 2003 and then reinsert it. Is there any way to do it in a smart way? Meaning an SQL statement. Thank you, Carlos Fernando. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Installing MySQL on Server W2000
I'm trying to connect trough MyODBC 2.5 and the error that I get is: Access denied, or Can't connect to the server, both Pc's are in the same network and have TCP/IP installed and working properly, also I try to connect using MyCC (DBA) downloaded from www.mysql.com and the same problem, that I supose is that some service or variable I didn't setup on server or something else. Thanks for your help. Regards !!! -Original Message- From: MikeParton [mailto:[EMAIL PROTECTED]] Sent: Monday, June 17, 2002 8:29 PM To: Efren Pedroza Subject: Re: Installing MySQL on Server W2000 Do you get any error messages? How are you trying to connect from the other machines? - Original Message - From: Efren Pedroza [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 17, 2002 8:55 PM Subject: Installing MySQL on Server W2000 Hi all, I'm installing MySQL Max 3.23 on a W2000 server, if I run the application locally everything is fine, but I can't connect on any other client Pc's (W98) is ther something else to do in a server, I just install it with default options (I'm newbie in MySQL). 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installing MySQL on Server W2000
Does the user (or do the users) you are trying to connect as from the Win98 machine(s) have the proper access set up in MySQL? - Original Message - From: Efren Pedroza [EMAIL PROTECTED] To: MikeParton [EMAIL PROTECTED]; MySQL List1 [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 10:35 AM Subject: RE: Installing MySQL on Server W2000 I'm trying to connect trough MyODBC 2.5 and the error that I get is: Access denied, or Can't connect to the server, both Pc's are in the same network and have TCP/IP installed and working properly, also I try to connect using MyCC (DBA) downloaded from www.mysql.com and the same problem, that I supose is that some service or variable I didn't setup on server or something else. Thanks for your help. Regards !!! -Original Message- From: MikeParton [mailto:[EMAIL PROTECTED]] Sent: Monday, June 17, 2002 8:29 PM To: Efren Pedroza Subject: Re: Installing MySQL on Server W2000 Do you get any error messages? How are you trying to connect from the other machines? - Original Message - From: Efren Pedroza [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 17, 2002 8:55 PM Subject: Installing MySQL on Server W2000 Hi all, I'm installing MySQL Max 3.23 on a W2000 server, if I run the application locally everything is fine, but I can't connect on any other client Pc's (W98) is ther something else to do in a server, I just install it with default options (I'm newbie in MySQL). 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: how to prevent from Creating Large Numbers of Tables ???
On Tue, 2002-06-18 at 15:42, Xuefer wrote: thx for replying it's really a new course for me option 1 will still make lots of tables does option 2 waste of space ? cause 2 id with only 1 value How many tables are created and how much spaces is wasted depends on the data and the design. Test a few different designs - see how much space the designs take and how complex the queries are. i'm going to make table as described below. i wonder it's feasibility also bring another question here: my forum has favorite table for use to collect their favorite post Table `favorite`: cols: userid INT, postid INT unique index(userid, postid) only a pair of ID pre row question: does this struct waste of space? if so, any better solution ? This is probably the best way to handle it. - struct of product attribute: - Table `cate`: cols: cateID cateName example row: 1 switches-100 Table `Attribute`: cols: cateID attributeID attributeName displayOrder example row: 1 1 color 1 1 2 size 2 Table `product`: cols: cateID productID productName productDescription example row: 1 1 greenswitch blah blash... Table `AttributeValue`: cols: productID attributeID attributeValue(varchar) example row: 1 1 green 1 2 10*10 - to delete attribute: DELETE FROM Attribute where attributeID=$id DELETE FROM AttributeValue where attributeID=$id You might want to associate the attributes with categories in a different table. This way you could put an attribute into multiple categories. You could also specify the displayORder in the category table as well. Good Luck! -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada ___/ 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
MySQL stability on OS X
Hi, Is anyone using MySQL with PHP and Apache on Darwin/OS X as a dynamic content webserver with medium/high load? We have had al lot of MySQL crashes (once a week) on a 400Mhz G4 getting an average of 5 SQL queries per second and eventually had to move the database to an old Linux 160Mhz Pentium server which has not had a single crash since then! Would be nice to now why MySQL seems so unstable under load on OS X. We tried an old G3 233 Mhz as well but then MySQL crashed already after some hours with the same load. Kind regards, Aryan -- -- Aryan Schmitz Korridor AB [EMAIL PROTECTED] http://www.korridor.se Tel +46 8 720 41 50 [EMAIL PROTECTED] Fax +46 8 720 41 60 Tantogatan 5 GSM +46 70 749 66 84 118 67 STOCKHOLM SMS mailto:[EMAIL PROTECTED] Sweden -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 a new table in a tablespace...
If i had more than one tablespace, don't i control where it will be stored ? - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 11:06 AM Subject: Re: create a new table in a tablespace... Silmara, Tuesday, June 18, 2002, 3:43:48 PM, you wrote: SCB I'm using MySQL 4.0.1 and my question is How can i do to create a new table SCB in a tablespace?. Tablespaces are used only for InnoDB tables. If you create InnoDB table, it will be stored in InnoDB tablespace. How to create InnoDB tables read in the manual: http://www.mysql.com/doc/U/s/Using_InnoDB_tables.html SCB Thank you! -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 unsubscribe to this mailing list?
Can anyone let me know how to unsubscribe to this mailing list? Thank you very much in advance. sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Interesting problem with Alter table and foreign keys on 3.23.51
Carl, Tuesday, June 18, 2002, 5:30:31 PM, you wrote: CM Below is an example of a problem I'm having when issuing an alter table CM command to create a foreign key in mysql version 3.23.51. I am running the CM max version and the tables exist in the innodb table space. CM Thoughts? Comments? Criticism? par_id column in the Table2 must be indexed. CM Carl McNamee CM Systems Administrator CM Billing Concepts CM (210) 949-7282 [skip] CM Create Table: CREATE TABLE `Table2` ( CM `name` char(10) NOT NULL default '', CM `par_id` int(11) NOT NULL default '0', CM PRIMARY KEY (`name`) CM ) TYPE=InnoDB CM 1 row in set (0.00 sec) -- 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 to duplicate records
Carlos, Tuesday, June 18, 2002, 5:24:48 PM, you wrote: CFSA I've got some records of a Database that I would like to duplicate if CFSA possible with an statement. CFSA The table has Code, Model, Year, units. The primary key is Code, Model and CFSA Year. What I need is to duplicate Code, Model and units for a different CFSA year. CFSA Say I want to duplicate all records which Code are N200 and N205 with the CFSA same model and same units but for year 2003. CFSA Is there any select and insert/replace statement to acomplish this? CFSA There are about 3.000 records and doing that manually is impossible. I am CFSA considering dump the whole file to a .csv and change year to 2003 and then CFSA reinsert it. CFSA Is there any way to do it in a smart way? Meaning an SQL statement. You can't do it with one SQL statement. MySQL has INSERT .. SELECT and REPLACe .. SELECT statements but you can't retrieve data from the same table into which you are inserting. What about inserting necessary data into temporary table and than upload them into your table? You can find info about INSERT .. SELECT and REPLACE .. SELECT at: http://www.mysql.com/doc/I/N/INSERT_SELECT.html http://www.mysql.com/doc/R/E/REPLACE.html CFSA Thank you, CFSA Carlos Fernando. -- 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: Installing MySQL on Server W2000
Efren, Tuesday, June 18, 2002, 5:35:47 PM, you wrote: EP I'm trying to connect trough MyODBC 2.5 and the error that I get is: Access EP denied, or Can't connect to the server, both Pc's are in the same network EP and have TCP/IP installed and working properly, also I try to connect using EP MyCC (DBA) downloaded from www.mysql.com and the same problem, that I supose EP is that some service or variable I didn't setup on server or something else. If you get access denied error it means that your user doesn't have permissions to connect to the MySQL server. You should set up privileges for your user. If you get error Can't connect to the server check if your MySQL server is running. EP Thanks for your help. EP Regards !!! -- 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 3.23.51+ for AIX
Morris, Tuesday, June 18, 2002, 5:13:41 PM, you wrote: MF Any word on when to expect a working binary MF release of mysql for AIX 4.3.3? Our developers are working on this issue. MF Morris Ford -- 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 a new table in a tablespace...
It's not THAT much like Oracle. ;-) -Original Message- From: Silmara Cristina Basso [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 9:16 AM To: [EMAIL PROTECTED]; Egor Egorov Subject: Re: create a new table in a tablespace... If i had more than one tablespace, don't i control where it will be stored? - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 11:06 AM Subject: Re: create a new table in a tablespace... Silmara, Tuesday, June 18, 2002, 3:43:48 PM, you wrote: SCB I'm using MySQL 4.0.1 and my question is How can i do to create a new table SCB in a tablespace?. Tablespaces are used only for InnoDB tables. If you create InnoDB table, it will be stored in InnoDB tablespace. How to create InnoDB tables read in the manual: http://www.mysql.com/doc/U/s/Using_InnoDB_tables.html SCB Thank you! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How to duplicate records
mabye an insert into...select will work, something like: INSERT INTO new tablename SELECT Code, Model, Units from original table where Year=2003 and ((Code = 'N200') or (Code='N205')); http://www.mysql.com/doc/I/N/INSERT_SELECT.html -Don -Original Message- From: Carlos Fernando Scheidecker Antunes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 10:25 AM To: MySQL List Subject: How to duplicate records Importance: High Hello all, I've got some records of a Database that I would like to duplicate if possible with an statement. The table has Code, Model, Year, units. The primary key is Code, Model and Year. What I need is to duplicate Code, Model and units for a different year. Say I want to duplicate all records which Code are N200 and N205 with the same model and same units but for year 2003. Is there any select and insert/replace statement to acomplish this? There are about 3.000 records and doing that manually is impossible. I am considering dump the whole file to a .csv and change year to 2003 and then reinsert it. Is there any way to do it in a smart way? Meaning an SQL statement. Thank you, Carlos Fernando. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Nulls and unique indexes.
That is correct. Use NOT NULL in the definition to force unique keys. [EMAIL PROTECTED] wrote: Description: If a null column is used in a unique index then mysql fails to throw a key violation when multiple identical inserts (with nulls) are performed. How-To-Repeat: create table test (a int null, b int null); alter table test add unique index index_ab (a,b); insert into test (a,b) values(1,null); insert into test (a,b) values(1,null); insert into test (a,b) values(1,null); select * from test; +--+--+ | a| b| +--+--+ |1 | NULL | |1 | NULL | |1 | NULL | +--+--+ 3 rows in set (0.00 sec) insert into test (a,b) values(1,1); insert into test (a,b) values(1,1); ERROR 1062: Duplicate entry '1-1' for key 1 Fix: No fix. Submitter-Id: submitter ID Originator: Jon Barker Organization: MySQL support: none Synopsis: NULLs don't work correctly in unique indexes. Severity: serious Priority: Category: mysql Class: Release: mysql-3.23.41 (Official MySQL RPM) Environment: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
make err: ld: fatal: library -ldl: not found
I am having troubles running 'make' with mysql-3.23.49 on; SunOS 5.8 Generic_108528-12 sun4u sparc my configure looks something like this; setenv CFLAGS -O3 setenv CXX gcc setenv CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti ./configure --prefix=/lycra/homes/fike/bugz/mysql --enable-assembler --with- mysqld-ldflags=-all-static then gmake returns; ld: fatal: library -ldl: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found ld: fatal: library -lpthread: not found ld: fatal: library -lthread: not found I can't seem to locate these library's. So I tried using he --with-mit-threads and received new errors below; In file included from include/pthread.h:69, from /lycra/homes/fike/bugz_src/mysql-3.23.49/mit-pthreads/net/gethostbyaddr.c:40 : include/pthread/pthread_attr.h:96: conflicting types for `pthread_attr_t' /usr/include/sys/types.h:393: previous declaration of `pthread_attr_t' In file included from /lycra/homes/fike/bugz_src/mysql-3.23.49/mit-pthreads/net/gethostbyaddr.c:40 : include/pthread.h:267: conflicting types for `pthread_t' /usr/include/sys/types.h:349: previous declaration of `pthread_t' Any help greatly apprectiated, Don [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: replication problems -- resolution
Just to let you know that when I installed 3.23.51 binary on both Debian Linux boxes, same problem, but when I re-installed the 3.23.49a binary on both boxes the problem went away. Uncertain why. Regards, Jeff Hill At 08:25 AM 18/06/2002 -0400, Jeff Hill wrote: I'm having the same problems, but I've noticed that the reported error doesn't seem to be a real failure. The databases seem to be updated correctly. When I look at my slave error log, I can see that the at position is a number that always matches the size of the log file on the master. This cannot be a coincidence. Is it perhaps trying to read past the end of the log file or something? I haven't really looked at MySql in years because it's been working fine, but in setting up replication, I see now that I have some Innobase tables, some not. Haven't a clue how that happened, but my my.cnf does not have the related directives uncommented. This could be related to problems reading the logs, I assume? I'm doing some testing, but any suggestions appreciated. I don't have a spare server to play with and the master is our main production server, so I have to play carefully to remain employed. I tried with both master and slave running mysql-3.23.47-pc-linux-gnu-i686 and then tried moving the slave to 3..23.51 with the same error results. Thanks for any assistance, Jeff Jeff Hill www.HRpost.com Ph: 416-604-7251 Fx: 647-439-1414 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Jeff Hill, Editor, HRpost / HR On-Line www.HRpost.com Ph: 416-858-3440 Fx: 647-439-1414 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: Re: how to prevent from Creating Large Numbers of Tables ???
sorry, i can't quite get what u meant dunno how to do as u said You might want to associate the attributes with categories in a different table. This way you could put an attribute into multiple categories. You could also specify the displayORder in the category table as well. On Tue, 2002-06-18 at 15:42, Xuefer wrote: thx for replying it's really a new course for me option 1 will still make lots of tables does option 2 waste of space ? cause 2 id with only 1 value How many tables are created and how much spaces is wasted depends on the data and the design. Test a few different designs - see how much space the designs take and how complex the queries are. i'm going to make table as described below. i wonder it's feasibility also bring another question here: my forum has favorite table for use to collect their favorite post Table `favorite`: cols: userid INT, postid INT unique index(userid, postid) only a pair of ID pre row question: does this struct waste of space? if so, any better solution ? This is probably the best way to handle it. - struct of product attribute: - Table `cate`: cols: cateID cateName example row: 1 switches-100 Table `Attribute`: cols: cateID attributeID attributeName displayOrder example row: 1 1 color 1 1 2 size 2 Table `product`: cols: cateID productID productName productDescription example row: 1 1 greenswitch blah blash... Table `AttributeValue`: cols: productID attributeID attributeValue(varchar) example row: 1 1 green 1 2 10*10 - to delete attribute: DELETE FROM Attribute where attributeID=$id DELETE FROM AttributeValue where attributeID=$id Good Luck! -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada ___/ 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[2]: heap tables
Victoria Reznichenko writes: Hi! SM Victoria Reznichenko writes: I have a question about heap tables :) Why does MySQL allow to insert more rows in the table than is specified in MAX_ROWS ? SM Send a test case ... mysql create table hp( - id int primary key)TYPE=HEAP MAX_ROWS=5; Query OK, 0 rows affected (0.00 sec) mysql insert into hp values - (1), - (2), - (3), - (4), - (5), - (6); Query OK, 6 rows affected (0.00 sec) Records: 6 Duplicates: 0 Warnings: 0 mysql select 8 from hp; ERROR 1030: Got error 124 from table handler -- Victoria Reznichenko Thank you for your bug report, but this is truly no bug ... Some table handler, like HEAP, use info you specify for max_rows and avg_row_length to determine maxumum number of blocks that could be use for given table. So, your table would be able to accomodate as many rows as would fit in a single block, which in your case is about 12. Regarding last error, this was fixed few days ago already. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com For technical support contracts, go to https://order.mysql.com/?ref=msmi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: Re: how to prevent from Creating Large Numbers ofTables ???
On Tue, 2002-06-18 at 19:02, Xuefer wrote: sorry, i can't quite get what u meant dunno how to do as u said You might want to associate the attributes with categories in a different table. This way you could put an attribute into multiple categories. You could also specify the displayORder in the category table as well. Hi Xuefer, No problem - sometimes code is the best explanation! :) Here are the rough tables for what I described - they *may* work! :) CREATE TABLE category ( id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL, nameVARCHAR(64) NOT NULL, members TEXT NOT NULL, PRIMARY KEY (id,name), ... ); CREATE TABLE att_type ( id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL, nameVARCHAR(64) NOT NULL, description TEXT NOT NULL, PRIMARY KEY (id,name), ... ); CREATE TABLE product ( id MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL, categorySMALLINT UNSIGNED NOT NULL, nameVARCHAR(64) NOT NULL, description TEXT NOT NULL, PRIMARY KEY (id), ... ); CREATE TABLE attributes ( id INT UNSIGNED AUTO_INCREMENT NOT NULL, product_id MEDIUMINT UNSIGNED NOT NULL, att_type_id SMALLINT UNSIGNED NOT NULL, value VARCHAR(64) NOT NULL PRIMARY KEY (id), ... ); Good Luck! -- Gosh, Batman. The nobility of the almost-human porpoise. --Robin __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada ___/ www.mysql.com Feed the Dolphin! Order MySQL support from the MySQL developers at https://order.mysql.com/?ref=mzgr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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!!! major situation with mysql on windows 2000
Group, I have a system running on windoze 2000 with apache and perl that was running just great until I mades some changes to the sql and a join of two tables. Now I get a bunch of disk activity and my pages take forever to load I shut down the browser and still the activity - memory usage goes through the roof with ossilation between perl and mysql in task manager. I see that there are several servers that can be run. Should I be running one of other servers? I am currently running mysqld-nt but there is mysqld-max-nt, mysqld-max Not sure how to troubleshoot this. 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: Alter table problem
Ferdek, what character set you have specified in my.cnf? I tested your script with latin1 (the default) and 3.23.52, and it seemed to work without errors. For example, for the table reklamacja you see below it created the 3 foreign key constraints. Can you provide a simple repeatable test case (and my.cnf) where it fails? Regards, Heikki Innobase Oy .. mysql show create table reklamacja; ++-- + | Table | Create Table | ++-- + | reklamacja | CREATE TABLE `reklamacja` ( `id_zdarzenia` int(10) unsigned NOT NULL auto_increment, `id_czesci` varchar(100) NOT NULL default '', `id_klienta` int(10) unsigned NOT NULL default '0', `data_rekl` date NOT NULL default '-00-00', `opis_uszk` text NOT NULL, `uwagi` text, `osprzet` text, `data_odd` date default NULL, `data_nap` date default NULL, `opis_nap` text, `id_zastepczy` varchar(100) default NULL, PRIMARY KEY (`id_zdarzenia`), KEY `id_czesci` (`id_czesci`), KEY `id_klienta` (`id_klienta`), KEY `id_zastepczy` (`id_zastepczy`), FOREIGN KEY (`id_klienta`) REFERENCES `servcontrol.klient` (`id_klienta`) ON D ELETE CASCADE, FOREIGN KEY (`id_czesci`) REFERENCES `servcontrol.czesc` (`id_czesci`) ON DELE TE CASCADE, FOREIGN KEY (`id_zastepczy`) REFERENCES `servcontrol.czesc` (`id_czesci`) ON D ELETE SET NULL ) TYPE=InnoDB | ++-- + 1 row in set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: Re: Re: how to prevent from Creating Large Numbers ofTables ???
cateogry.members a list of att_type_id, right? and also displayOrder i got it. it's nice :) but is it a must to have attributes.id ? unique id (product_id,att_type_id) is not enough ? to remove a product delete from attributes where product_id=$id delete from product where id=$id On Tue, 2002-06-18 at 19:02, Xuefer wrote: sorry, i can't quite get what u meant dunno how to do as u said You might want to associate the attributes with categories in a different table. This way you could put an attribute into multiple categories. You could also specify the displayORder in the category table as well. Hi Xuefer, No problem - sometimes code is the best explanation! :) Here are the rough tables for what I described - they *may* work! :) CREATE TABLE category ( id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL, nameVARCHAR(64) NOT NULL, members TEXT NOT NULL, PRIMARY KEY (id,name), ... ); CREATE TABLE att_type ( id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL, nameVARCHAR(64) NOT NULL, description TEXT NOT NULL, PRIMARY KEY (id,name), ... ); CREATE TABLE product ( id MEDIUMINT UNSIGNED AUTO_INCREMENT NOT NULL, categorySMALLINT UNSIGNED NOT NULL, nameVARCHAR(64) NOT NULL, description TEXT NOT NULL, PRIMARY KEY (id), ... ); CREATE TABLE attributes ( id INT UNSIGNED AUTO_INCREMENT NOT NULL, product_id MEDIUMINT UNSIGNED NOT NULL, att_type_id SMALLINT UNSIGNED NOT NULL, value VARCHAR(64) NOT NULL PRIMARY KEY (id), ... ); Good Luck! -- Gosh, Batman. The nobility of the almost-human porpoise. --Robin __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada ___/ www.mysql.com Feed the Dolphin! Order MySQL support from the MySQL developers at https://order.mysql.com/?ref=mzgr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
still having rep. problems
Never got any replies from the list with suggestions from my last post so I thought I would give another cry for help.To recap: Master Server - Win NT 4.0 mysql 3.23.49-nt-log dual pII 600 Slave Server - Win 2k mysql 4.0.1-alpha-max-nt p4 2.0 Procedure: Followed the manual to set up the slave master cnf files. Shut down the both servers. Copied the original data from master to server. Started master then slave. Problem: mysql.err log on slave gives the following error every 60 secs on trying to synch.020618 13:59:20 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 28020618 13:59:20 Slave: connected to master 'repl@taz:3306',replication resumed in log 'FIRST' at position 28020618 13:59:20 Slave: received 0 length packet from server, apparent master shutdown: (2) Showing the process list on the master shows no process from the slave. Showing the ps list on the slave gives the state of:Waiting to reconnect after a failed read I have gone through all the steps I could think of that might solve the problem but to no avail. =\Any help, suggestions would be greatly appreciated as I would really like to get replication working. Thanks for the help! -Nick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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: Installing MySQL on Server W2000
Thanks for everything, exactly that you told me, GRANT command was the solution, I did it by MyCC (My SQL Control Center 0.8.4) it's easy to use. Thanks to all again !!! -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 10:35 AM To: [EMAIL PROTECTED] Subject: Re: RE: Installing MySQL on Server W2000 Efren, Tuesday, June 18, 2002, 5:35:47 PM, you wrote: EP I'm trying to connect trough MyODBC 2.5 and the error that I get is: Access EP denied, or Can't connect to the server, both Pc's are in the same network EP and have TCP/IP installed and working properly, also I try to connect using EP MyCC (DBA) downloaded from www.mysql.com and the same problem, that I supose EP is that some service or variable I didn't setup on server or something else. If you get access denied error it means that your user doesn't have permissions to connect to the MySQL server. You should set up privileges for your user. If you get error Can't connect to the server check if your MySQL server is running. EP Thanks for your help. EP Regards !!! -- 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
Obvious mistake in query?
I am trying to list items in t1 (alias new) that are not in project so I tried the query suggested on an earlier mail: select new.projectdesc,project.projectname from t1 as new left join project on new.projectdesc=project.projectname where project.projectname=NULL | projectdesc | projectname | Number of Results: 0 So I tried running without the where clause: select new.projectdesc,project.projectname from t1 as new left join project on new.projectdesc=project.projectname | projectdesc | projectname | | | NULL| | NULL | NULL| | Area | NULL| | Accounting| Accounting | | Admin | NULL| | Marketing | NULL| | Management| NULL| | Production| NULL| | Research | NULL| | Sales | NULL| | Technical Development | NULL| Number of Results: 11 Have I missed something obvious? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: HELP!!! major situation with mysql on windows 2000
Hi. On Tue 2002-06-18 at 10:28:41 -0700, [EMAIL PROTECTED] wrote: Group, I have a system running on windoze 2000 with apache and perl that was running just great until I mades some changes to the sql and a join of two tables. Now I get a bunch of disk activity and my pages take forever to load I shut down the browser and still the activity - memory usage goes through the roof with ossilation between perl and mysql in task manager. The MySQL server will only notice that you stopped the client, when it is ready to send some results back. Depending on the query this may take a while. You should use your preferred admin tool (mysqladmin if nothing else), and as database root look at the processlist and kill the query in question. I see that there are several servers that can be run. Should I be running one of other servers? No. As long as you have to ask, you have no need for the other servers. ;-) I am currently running mysqld-nt but there is mysqld-max-nt, mysqld-max mysqld-max* has some additional features compiled in by default (e.g. InnoDB table type). This has nothing to do with the problem you observed. The *-nt version are for the server version of Windows, including Windows 2000, so you are using the correct binary. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MAX_ROWS
On Tue, 2002-06-18 at 11:43, Aborla.net - webmaster wrote: Hello, I created a table using: CREATE TABLE a (pa VARCHAR (255) NOT NULL, pi VARCHAR (255), PRIMARY KEY (pa)) TYPE=HEAP MAX_ROWS=10 Then I inserted 16 recors. Later I done SELECT * FFROM a and mysql returned 16 records. Why this??? Does i should return only the last 10 records I inserted??? Please help me Hello Nuno! Sinisa answered this question for someone else on this mailing list earlier today. I will repeat it for you and for anyone following this thread later on in the archives. Sinisa wrote: Some table handler, like HEAP, use info you specify for max_rows and avg_row_length to determine maxumum number of blocks that could be use for given table. -- Gosh, Batman. The nobility of the almost-human porpoise. --Robin __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Zak Greant [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Advocate /_/ /_/\_, /___/\___\_\___/ Calgary, Canada ___/ www.mysql.com Feed the Dolphin! Order MySQL support from the MySQL developers at https://order.mysql.com/?ref=mzgr - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 duplicate records
Don, Thank you very much. The only problem is that the primary index Code, Model and Year and what I need is to duplicate the Code, Model and Units for a different year, 2003, that does not exist. If I do the statement bellow it won't work. What I need is to insert Code, Model, Units for a specific code match but they have to be duplicated for year 2003. Thanks again, C.F. - Original Message - From: Don Vu [EMAIL PROTECTED] To: Carlos Fernando Scheidecker Antunes [EMAIL PROTECTED]; MySQL List [EMAIL PROTECTED] Sent: Tuesday, June 18, 2002 9:38 AM Subject: RE: How to duplicate records mabye an insert into...select will work, something like: INSERT INTO new tablename SELECT Code, Model, Units from original table where Year=2003 and ((Code = 'N200') or (Code='N205')); http://www.mysql.com/doc/I/N/INSERT_SELECT.html -Don -Original Message- From: Carlos Fernando Scheidecker Antunes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 10:25 AM To: MySQL List Subject: How to duplicate records Importance: High Hello all, I've got some records of a Database that I would like to duplicate if possible with an statement. The table has Code, Model, Year, units. The primary key is Code, Model and Year. What I need is to duplicate Code, Model and units for a different year. Say I want to duplicate all records which Code are N200 and N205 with the same model and same units but for year 2003. Is there any select and insert/replace statement to acomplish this? There are about 3.000 records and doing that manually is impossible. I am considering dump the whole file to a .csv and change year to 2003 and then reinsert it. Is there any way to do it in a smart way? Meaning an SQL statement. Thank you, Carlos Fernando. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: HELP!!! major situation with mysql on windows 2000
Thanks to all - another coder showed me the error of my ways :) I had a join without a where clause - a big no-no. I had to restart the server and repair my code and now I am back to normal. Thanks to all. -Original Message- From: Benjamin Pflugmann [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 11:26 AM To: Norris, Joseph Cc: Mysql_List (E-mail) Subject: Re: HELP!!! major situation with mysql on windows 2000 Hi. On Tue 2002-06-18 at 10:28:41 -0700, [EMAIL PROTECTED] wrote: Group, I have a system running on windoze 2000 with apache and perl that was running just great until I mades some changes to the sql and a join of two tables. Now I get a bunch of disk activity and my pages take forever to load I shut down the browser and still the activity - memory usage goes through the roof with ossilation between perl and mysql in task manager. The MySQL server will only notice that you stopped the client, when it is ready to send some results back. Depending on the query this may take a while. You should use your preferred admin tool (mysqladmin if nothing else), and as database root look at the processlist and kill the query in question. I see that there are several servers that can be run. Should I be running one of other servers? No. As long as you have to ask, you have no need for the other servers. ;-) I am currently running mysqld-nt but there is mysqld-max-nt, mysqld-max mysqld-max* has some additional features compiled in by default (e.g. InnoDB table type). This has nothing to do with the problem you observed. The *-nt version are for the server version of Windows, including Windows 2000, so you are using the correct binary. Bye, Benjamin. -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0.1 SSL config - a shot in the dark
Hello, From the sound of Tonu's original response, he's pretty busy right now ... If anyone else has an idea based on experience with SSL MySQL, or just with openssl in general, can offer an opinion on this, I would be grateful. I've ordered a book on OpenSSL in an effort to learn more about it for this application as well as others, but it hasn't gotten here yet. I would appreciate any insight before I get around to just guessing! Thanks, Clay From: Clay Loveless [EMAIL PROTECTED] Date: Sat, 15 Jun 2002 21:30:31 -0700 To: MySQL [EMAIL PROTECTED] Subject: Re: MySQL 4.0.1 SSL config - a shot in the dark Tonu, Thank you, thank you! The formal documentation effort is apparently still underway based on your notes ... The link you included eliminates a lot of guesswork! : ) This part of MySQL is written by me and I am sure it worked :) I'm sure it does -- what I meant was that the way I had it configured (my best guess last night) wasn't working. No wonder! 3. EDIT my.cnf ON CLIENT SERVER I added these values to my.cnf: [ssl] key = (LONG public key value - 394 chars - copied from server.crt) cert = ca.crt ca = (Organization Name answer from the Q A session while doing the first ca.key generation) capath = /usr/local/etc/mysqlssl nono, a lot of errors here. I am pretty sleepy and can do smaller mistakes right now but mistakes I see: section [ssl] is wrong. MySQL server uses [mysqld] section, command line - client [client] but nobody read [ssl] section! Everything should be added under those common sections - values key and ca are wrong. Should be ssl-key, ssl-ca and so on... Makes sense. I went through the procedures with CA.sh logged in your notes, and was left with these files in my working directory: newcert.pem newreq.pem demoCA/ newcerts/ 01.pem private/ cakey.pem Can you tell me which of those files translates into the files you used in your configuration? [mysqld] ssl-ca=SSL/cacert.pem ssl-cert=SSL/server-cert.pem ssl-key=SSL/server-key.pem [mysql] ssl-ca=SSL/cacert.pem ssl-cert=SSL/client-cert.pem ssl-key=SSL/client-key.pem [mysqldump] ssl-ca=SSL/cacert.pem ssl-cert=SSL/client-cert.pem ssl-key=SSL/client-key.pem Your notes don't include the steps where you renamed the output .pem files to the filenames used in your example my.cnf entries. Page 390 of the new Managing Using MySQL (O'Reilly) book provided some clues for doing this ... In reference to C functions, it says: 'key' contains an SSL public key 'cert' contains the filename of a certificate 'ca' contians the name of the certificate authority 'capath' contains the directory containing the certificate Hmm this is not the first time when O'Reilly publishes bad and misguiding book about MySQL. I personally suggest to avoid them. Paul DuBois one is good example. Could be that I was just making the wrong assumption. I've read a good chunk of the rest of that O'Reilly book today, and it was all pretty good. The section I quoted wasn't specifically documenting the SSL functionality, but just listing a C function for reading SSL-related values from the .cnf file. So, it was probably just the author's shorthand for that function, and I leapt to the wrong conclusion. There is a file in MySQL source tree I wrote about using SSL connections with MySQL: http://www.mysqldeveloper.com/4.x-bk_tree/SSL/NOTES I hope they work for you. There are some pregenerated example key/certificate files included. You may try with then first to ensure that your command-line stuff works first. Thanks again for posting this link! This really helps a lot. I would be happy to write all this up for use as a FAQ answer on mysqldeveloper.com, as I'm sure this has (or will) come up often. Regards, Clay - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Obvious mistake in query?
You are testing nullity using equal, but you must use IS NULL to test against NULL values. http://www.mysql.com/doc/C/o/Comparison_Operators.html On Tuesday 18 June 2002 15:11, Phoebe Bright wrote: I am trying to list items in t1 (alias new) that are not in project so I tried the query suggested on an earlier mail: select new.projectdesc,project.projectname from t1 as new left join project on new.projectdesc=project.projectname where project.projectname=NULL | projectdesc | projectname | Number of Results: 0 So I tried running without the where clause: select new.projectdesc,project.projectname from t1 as new left join project on new.projectdesc=project.projectname | projectdesc | projectname | | | | NULL| | | NULL | NULL| | Area | NULL| | Accounting| Accounting | | Admin | NULL| | Marketing | NULL| | Management| NULL| | Production| NULL| | Research | NULL| | Sales | NULL| | Technical Development | NULL| Number of Results: 11 Have I missed something obvious? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- João Paulo Vasconcellos Gerente de Tecnologia - NetCard Tel. 21 3852-9008 Ramal 31 [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: Obvious mistake in query?
On 18 Jun 2002, at 19:11, Phoebe Bright [EMAIL PROTECTED] wrote: select new.projectdesc,project.projectname from t1 as new left join project on new.projectdesc=project.projectname where project.projectname=NULL | projectdesc | projectname | Number of Results: 0 You can't use = with NULL (well, you can, but you'll always get NULL as the result of the comparison). Change the WHERE clause to WHERE project.projectname IS NULL You might want to read this: http://www.mysql.com/doc/P/r/Problems_with_NULL.html -- 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
