re: MySQL insert issue related to a unique column
Jeff, Thursday, October 10, 2002, 5:44:28 PM, you wrote: JZ I have a MySQL 40 column table where I select an entire row then insert JZ it into another (different) 40 column table. For some reason the insert JZ fails and after much troubleshooting I've isolated the cause to a field JZ heading labeled prod_num. This field is a type varchar(10) and it's JZ value is 1090C. If I set the value to 1090 it works ok. I've also JZ tried TINYTEXT same problem. If I use the value 1090C in other fields JZ works ok so problem seems to be related to field labeled prod_num. JZ Another mystery, if I reset the value in my script to 1090C after the JZ select the insert also works OK. I have checked to make sure there are JZ no new line returns and just don't know what else to try. Jeff, I created, inserted, selected data from column 'prod_name' without any problems. So, could you provide structure of your table, failed INSERT statement? What version of MySQL server you are using? -- 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 processes..
hi, I have a problem with the connections and would appreicate a lot if anyone can provide a soln.. Our JSP application has connections to both Oracle and MySQL... In each page there are nearly a dozen queries executing on a MySQL db. at the begining of each page, a connection is opened and at the end they are close.. Ideally, if the user waits for the page to load completely and then hit the button Next or Cancel, the connection is freed.. But what happens often is that soon after entering the page, many users just click on Next resulting in the connection not getting closed...and soon, the no of connections exceed the allotted number (because they dont get freed automatically) and thus crashes the application.. My question is this: Is there anyway to kill the processes in MySQL (ofcourse i can do it manually but am talking about real time) ??? thnx for any suggestions.. sands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unable to connect to MySQL using java
HI, I am trying to connect to MySQL using java. I have placed mm.mysql drivers in jakarta-tomcat/lib folder. but whenever i try to connect to mysql, i receive this error: Cannot connect to MySQL server on . Is there a MySQL server running on the machine/port you are trying to connect to? (java.security.AccessControlException) please note that i can connect to mysql using telnet and php script. Please help me to overcome this error. Farhan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: retyping data
Hasan Try typing your select statement in a text editor. Open a mysql client connection and copy paste. This gets around the problem. For multiple sql statements, put them in a file and redirect it to the mysql client: shell mysql -u hasan -p file.sql David -Original Message- From: Hasan / Impex Holidays Maldives [mailto:hasan;impex.com.mv] Sent: Thursday, October 17, 2002 4:22 AM To: [EMAIL PROTECTED] Subject: retyping data hi, I am using win-xp and command prompt to access mysql. I try to retype a very long insert line into the command prompt, but the command prompt would not allow me to type all my insert query. There seems to be a limit to the characters I can insert when in mysql. I can type any amount of characters when in C: prompt. Does anyone know a solution, I have tried changing the properties but nothing seems to help. Thanks, Hasan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Updated MySQL 3.23.53a binaries now available
-- o The Intel Linux binaries (normal and Max) have now been built against a glibc with static-nss enabled again. This should resolve the problem with mysqld failing to change to another user ID as well as the notorious load issue that has been plagueing previous releases. We have tested this binary on different Linux distributions and were not able to reproduce these problems anymore. Please contact me directly, if you still observe any abnormal behaviour on Linux with this binary. -- Load issue resolved. Whew! Looking forward to 4.0.5 with the same fix. Such a relief! Thanks for all the work to resolve this! Sincerely, Steven Roussey http://Network54.com/?pp=e 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
3.23.53 segfault with TCP/IP connections
I'm still getting the same error: /usr/local/mysql/bin/safe_mysqld: line 273: 4963 Segmentation fault $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 Number of processes running now: 1 mysqld process hanging, pid 4966 - killed 021017 16:19:47 mysqld restarted Local socket connections work great. Here's some info from mysqlbug: Release: mysql-3.23.53 (Source distribution) Environment: machine, os, target, libraries (multiple lines) System: Linux coredump.prtel.com 2.4.18-10 #1 Wed Aug 7 11:39:21 EDT 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/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.3 2.96-112) Compilation info: CC='gcc' CFLAGS='-O3 -march=pentiumpro' CXX='g++' CXXFLAGS='-O3 -march=pentiumpro -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Oct 7 11:13 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1260480 Sep 9 09:16 /lib/libc-2.2.5.so -rw-r--r--1 root root 2312410 Sep 9 09:02 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 9 08:56 /usr/lib/libc.so Configure command: ./configure --with-gnu-ld --without-debug --enable-assembler --with-innodb --prefix=/usr/local/mysql CC=gcc 'CFLAGS=-O3 -march=pentiumpro' 'CXXFLAGS=-O3 -march=pentiumpro -felide-constructors -fno-exceptions -fno-rtti' CXX=g++ I have tried compiling with both gcc-2.96-112 and gcc-3.2, and with and without InnoDB and assembler. I get the same result. I haven't touched my glibc. I would try a binary release, but I'd rather figure out what's actually wrong. Any ideas? Thanks! --Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: slow query...
Hi ! the table has about 12.000 rows total but the query should return a max of about 100. mysql should split the query into two queries and merge the results. may be this could be done by joining the same table two times and query each table only for one of the OR expression. i'll try but for future versions of mysql, this should be internally done i think... ;) Corin Check it out = http://www.find-mich.net Thursday, October 17, 2002, 4:07:01 PM, you wrote: EE Corin, EE Thursday, October 17, 2002, 3:09:08 PM, you wrote: CL i have the following problem. I have a table wherey to_id CL and owner_id are of type unsigned int not null and both CL are normal indexes. Unluckily a query like: CL -- CL EXPLAIN SELECT * FROM `telegramme` WHERE to_id = 3157 or owner_id = 3157 CL -- CL returns very bad results: CL -- CL table type possible_keys key key_len ref rows Extra CL telegramme ALL to_id,owner_id NULL NULL NULL 11488 where used CL -- CL how could this be optimized or is this a bug of mysql, because the CL indexes exist but are not used (even if specified with use index(..)) ?! EE How many rows there are in table `telegramme`? When MySQL needs to access to more EE that 30% records in the table, it doesn't use an index: EE http://www.mysql.com/doc/en/MySQL_indexes.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 connect to MySQL using java
Muhammad Farhan wrote: HI, I am trying to connect to MySQL using java. I have placed mm.mysql drivers in jakarta-tomcat/lib folder. but whenever i try to connect to mysql, i receive this error: Cannot connect to MySQL server on . Is there a MySQL server running on the machine/port you are trying to connect to? (java.security.AccessControlException) It doesn't look like MySQL issue (JDBC issue neither). Are you sure the security exception is thrown from JDBC driver? Plus, the error message suggests that you're specifying invalid connection parameters or are blocked eg. by firewall or some other security manager. Max - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Slow opening a recordset
At 19/10/2002 17:17, Ed Carp wrote: It's not a MySQL problem, but a problem how you're opening the recordset. In VB, you would set the DBSQLPassThru flag - I don't know what the equivalent is in Windows C. The problem is that the client is downloading the entire record set and oding the select on the PC when you do the open - that's why it takes longer the bigger your table is. Sorry Ed, but I disagree. I'm almost sure it's a MySQL problem. I tried the SAME code with the SAME table structure under SQL Server and it reported an opening and closing time close to 0 seconds. I looked for something like dbSQLPassThough but I found nothing : Thanks, Massimo - This mail sent through IMP: http://web.horde.org/imp/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: First time MySQL user needs help using/understanding mysqlimport
With a similar case I had my problems because the exported database records from Sage KHK, a german biz management software, had and other special chars in it that made it not possible to run a proper import from a CSV file and manual cleaning with 35.000 records was out of question ;o) I did the following: exported an Access db from KHK, Opened it in M$ Access, made an ODBC connection to MySQL and exported the tables to the MySQL db. Some lines SQL and I got rid of duplicates, etc. Does Filemaker has the feature to connect to an ODBC source and if yes to export tables there? I have no clue with Mac's. STIBS At 17:28 -0400 10/19/02, Paul Melia wrote: Hello, I am newbie to MySQL and I having some problems transferring my existing data to MySQL. Could someone tell me what I am doing wrong? I started by exporting certain fields from Filemaker 5.5 to a comma-separated .txt file. I then opened the file in BBedit, deleted duplicates and made other adjustments (like sorting the output properly) and then saved the file (with unix line breaks). I then opened a Terminal on a my Mac running OS 10.2.1 and issued the following command: mysqlimport -v omomain /Users/paul/Desktop/omostuff/csv_files/aproducer.txt This is what I got in return: Connecting to localhost Selecting database omomain Loading data from SERVER file: /Users/paul/Desktop/omostuff/csv_files/aproducer.txt into aproducer mysqlimport: Error: Can't get stat of '/Users/paul/Desktop/omostuff/csv_files/aproducer.txt' (Errcode: 13), when using table: aproducer I have tried other permutations that I have found at listsearch.com and at mysql.com and but I keep encountering the Error: Can't get stat of '/Users/paul/Desktop/omostuff/csv_files/aproducer.txt' (Errcode: 13), when using table: aproducer % perror 13 Error code 13: Permission denied This means the server can't read the file. Most likely the permissions you have on it don't allow other users to read it, and the server probably runs as a different user than you. You can either make the file world readable, or use the --local option to have the client send the file to the server over the connection. I'm assuming the server is on the same machine; if it's not, only the --local approach will work. The table exists, the database exists, and the spelling is correct so I am stumped. All files, servers and the Terminal are on the same machine. (nothing is remote) The version of MySQL I am running is: 3.23.46 Any help is greatly appreciated! Thanks, Paul Melia - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- - PLEASE NO HTML EMAILS! THANX ALOT SAYS MY KMAIL CLIENT. - Best Regards/ Freundliche Grüße Michael Stibane (STIBS) [EMAIL PROTECTED] Training, Linux, Admin, Programming, Web http://www.stibs.cc Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - Dresden - London http://www.escapade.org +++ GMX - Mail, Messaging more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Which files to download/install - problems running MySQL
Miquel, I tried what you suggested, but still it didn't work properly. For the server: C:\cd mysql\bin C:\mysql\binmysqld-opt --standalone --console 021020 8:20:30 InnoDB: Out of memory in additional memory pool. InnoDB: InnoDB will start allocating memory from the OS. InnoDB: You may get better performance if you configure a bigger InnoDB: value in the MySQL my.cnf file for InnoDB: innodb_additional_mem_pool_size. The cursor did not return to the prompt to allow anymore commands to be typed. (I haven't created a c:\my.cnf or c:\windows\my.ini) For the client: C:\mysql\binmysql -uroot -p Enter password: Again, nothing more was displayed on the screen and the cursor did not return to the prompt to allow anymore commands to be typed. Regards, Nikki Mason - Original Message - From: Miguel Angel Solórzano [EMAIL PROTECTED] To: Nikki Mason [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Saturday, October 19, 2002 9:29 PM Subject: Re: Which files to download/install - problems running MySQL At 15:16 19/10/2002 +0100, Nikki Mason wrote: Hi, Hi, I wish to learn SQL, and as some of my friends already use MySQL, they recommended that I too use it. Please can you tell me what I need to download and install to get me going. I have: Pentium III 450Mhz, 256Mb Ram Windows 98 I don't have a C or C++ compiler installed. My PC is not connected to a network - it is standalone. I had earlier downloaded just the zip file for version 4.0.4-beta (Windows). I unzipped it and ran the 'setup' program. Once setup had completed I tried the test on the server - at no point had I run the Admin program or created the my.cnf or my.ini. I opened a dos window and from the directory c:\mysql\bin entered: mysqld --standalone No other text was shown in the dos window and it appeared to hang. The whole computer also seemed to 'hang'. I had to use ctrl C to kill the application and get back normal operation to my PC. Why you had killed the mysqld server ?. The mysqld.exe is a console application that when started with --standalone option it works in the background. If you want to see the console screen then issue: C:\mysql\binmysqld-opt --standalone --console 021019 17:25:31 InnoDB: Started mysqld-opt: ready for connections and for to work with the mysql client: C:\c:\mysql\bin\mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.53-max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql after a fresh installation left the root password blank. for to shutdown the server: C:\c:\mysql\bin\mysqladmin shutdown 021019 17:27:27 mysqld-opt: Normal shutdown 021019 17:27:27 InnoDB: Starting shutdown... 021019 17:27:29 InnoDB: Shutdown completed 021019 17:27:29 mysqld-opt: Shutdown Complete I then tried manually creating the file c:\my.cnf and populated with the information given in the installation instructions. The server still hung. I then tried using the admin program with the similar results - the green traffic light was showing, but the dos window that was displayed appeared 'hung' and again the PC itself seemed to have hung - it operated extremely slowly. The task manager showed the admin tool as 'not responding'. What have I/am I doing wrong? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
2 problems
Hello guys Here is the problem. You may find it trivial, but it is a serious obstacle for me. I make a database, a table in mysql and it goes fine. Then I try to view my table with PHP. I am pretty sure that I can't connect to the database. In particular $db = mysql_connect(localhost, root, ) or die; statement doesn't seem to be valid. Should I use another username, password or both? Are there any suggestions? Trying to solve the previous problem I face a new one: My new username is not anymore root, but rootlocalhost. This happened during a phonecall assistant by a friend. How did this happen? How can I generally change my username? If the previous explanation is not clear all I mean is: when I try to access mysql the: mysql -u root command is not valid. Instead I get this message: access denied for user: 'rootlocalhost' (Using password: NO). Thanks for the cooperation
Problem: install Data-Dumper
Dear All, When I tried to install Data-Dumper module for the MySQL-bench module, I got the following error message, which confused me: gcc -c -fno-strict-aliasing -I/usr/local/include -O2 -march=i386 -mcpu=i686 -DVERSION=\2.09\ -DXS_VERSION=\2.09\ -fPIC -I/usr/lib/perl5/5.6.1/i386-linux/CORE Dumper.c Dumper.xs: In function `DD_dump': Dumper.xs:141: `sv_undef' undeclared (first use in this function) Dumper.xs:141: (Each undeclared identifier is reported only once Dumper.xs:141: for each function it appears in.) Dumper.xs:154: `errgv' undeclared (first use in this function) Dumper.xs: In function `XS_Data__Dumper_Dumpxs': Dumper.xs:643: `sv_undef' undeclared (first use in this function) make: *** [Dumper.o] Error 1 Could anybody advise me what's going on? Thanks, jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: mysql socket problem in win98 (thanks for the help!)
At 13.49 20/10/2002 +0200, you wrote: Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: First of all, thanks to everyone for no reply and no help! If someone is interested, I've found that i Win9x systems, if there are persistent connections open, the system instead of used the same opened connection for the same session, it opens a new connection for each script call, and, because it can't close persistent connections, (the port has always estabilished connection), it ever opens new port connection to the 3306, while it reachs the open port limit. So, it's impossible to make new connections with servers. Ciao __ Scarica il nuovo Yahoo! Messenger: con webcam, nuove faccine e tante altre novità. http://it.yahoo.com/mail_it/foot/?http://it.messenger.yahoo.com/ __ Scarica il nuovo Yahoo! Messenger: con webcam, nuove faccine e tante altre novità. http://it.yahoo.com/mail_it/foot/?http://it.messenger.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: Slow opening a recordset
At 19/10/2002 22:08, Patrick Sherrill wrote: It sounds like it may be time to look at threads. Set up a thread and open your recordset there or look at the C or C++ API for MySQL. It's not a thread problem. Thanks, Massimo. - This mail sent through IMP: http://web.horde.org/imp/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
delayed update ?
Hi, does anybody know how to make a delayed update and is this implemented in mysql 3.23.x ? the update should not block the client (i guess this does low_priority) if the table is a lot in use. simply update the rows later, just like insert delayed does. Thanks, Corin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Select statment
I can't seem to figure out the select statement to get the name. Do I need the the StarID or ActorID in Titles table? Thank you. I am using PHP and MYSQL. Studios (StudioName, StudioID) Genres (GenreName, GenreID) Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) Actors (F_Name, L_Name, ActorID) Stars (TitleID, ActorID) TitleGenres (TitleID, GenreID) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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: content design / database design help
Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Let me add a bit to this Relations will make sense for items like 'project notes' which would work something like. table 'notes' project_id | create_date | note | author my tabledesign would be note_id(primary) | project_id(foreign) | create_date | note | author in order to have a primary that not only one note for each project is possible. table 'project_contacts' project_id | name | company | address | phone | description same here, add a contact_id :o) ... Though I'd go with the first advise. There is a good solution I often use for construction companies: http://www.phprojekt.com. Veryvery complete! :o) -- - PLEASE NO HTML EMAILS! THANX ALOT SAYS MY KMAIL CLIENT. - Best Regards/ Freundliche Grüße Michael Stibane (STIBS) [EMAIL PROTECTED] Training, Linux, Admin, Programming, Web http://www.stibs.cc Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - Dresden - London http://www.escapade.org +++ GMX - Mail, Messaging more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! -- - PLEASE NO HTML EMAILS! THANX ALOT SAYS MY KMAIL CLIENT. - Best Regards/ Freundliche Grüße Michael Stibane (STIBS) [EMAIL PROTECTED] Training, Linux, Admin, Programming, Web http://www.stibs.cc Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - Dresden - London http://www.escapade.org +++ GMX - Mail, Messaging more http://www.gmx.net +++ NEU: Mit GMX ins Internet. Rund um die Uhr für 1 ct/ Min. surfen! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: Select statment
John, StudioName? GenreName? F_Name? L_Name? DatabaseName? ServerName? Alan I can't seem to figure out the select statement to get the name. Do I need the the StarID or ActorID in Titles table? Thank you. I am using PHP and MYSQL. Studios (StudioName, StudioID) Genres (GenreName, GenreID) Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) Actors (F_Name, L_Name, ActorID) Stars (TitleID, ActorID) TitleGenres (TitleID, GenreID) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: content design / database design help
I would take a look at the already available solutions at http://www.hotscripts.com http://php.resourceindex.com (many open source/free) It may be easier to use (and manipulate) one of these to what you need. I am working on a similar project, since I fond many project management solutions to be confused by too many options. part two the syntax you are looking for is UPDATE Status SET projectstatus='whatever' WHERE projectid = 123; http://www.mysql.com/doc/en/UPDATE.html I'd also recommend picking up this small little book. It's a great intro to the power of SQL and will show you how simple some of the cool things you can do are. http://www.amazon.com/exec/obidos/tg/detail/-/0672321289/103-9983226-8456617 I would also recommend putting all project 'properties' in a single table. what I mean is that you don't need a relational setup for items like status and cost where eah project will only have 'one' (Project A costs $5000 and is 40% complete - next week Project A may cost $6000 and be 50% complete - so just update the fields). It would make more sense, and make building your application simpler if these are in a single table. Relations will make sense for items like 'project notes' which would work something like. table 'notes' project_id | create_date | note | author so now we can store a note and know who wrote it and when they did. this same structure can solve your problem of tying contacts to the project table 'project_contacts' project_id | name | company | address | phone | description and whatever other fields you like... olinux --- Randy Hammons [EMAIL PROTECTED] wrote: I'm new and I'm TOTALLY lost! Why am I here? To BEG for help! My office currently keeps track of our projects via an excel spreadsheet. We keep such info as project costing, status, points oif contact, name, description, number, last updated, etc... What I want to do is merge all that info to a mysql database and generate a front end to view / update all applicalbe information via the web with php. Should be easy enough right? Should I be looking at a content management system type of design or should I just be focusing on form manupliation etc? Any suggestions as to how I would design this would be very beneficial. Part two. Lets say I design this puppy using regular static forms. My database design looks (currently and tentatively) like this: table projects columns( projectID(pk) numbername description) table Managers columns ( managerid(pk) managername) table Status columns(projectid(pk)projectstatus) table projectdetails columns(projectid(pk) projectcompletiondate projectcost lastupdate) now lets say someone is viewing a project with projectid (1). If they decide to update the status, we can see that the status tables primary key is projectid. If they decide to update the status could you give me an example of the sql syntax of how that would be updated. We can visually see the key relationship, but what would the syntax look like? We understand that status is related to the project via the projectid, but the database won't replicate that info automatically. How do I make something like that happen? Part three. Any suggestions on how to keep track of the primary and alternate points of contact per project as far as database design is concerned? Thank you for reading this far...look forward to hearing your responses (if any ;)). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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!? Y! Web Hosting - Let the expert host your web site http://webhosting.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: Slow opening a recordset
At 19/10/2002 19:16, Venu wrote: Its because of mysql_store_result(), instead you should check the option 'Don't cache results' to use 'mysql_use_result()'. I tried to uncheck the option Don't cache results (with MyODBC 3.51.04 it is Don't cache Results(only for forward-only cursor) ) and I solved the opening problem... but it created 2 new problems: 1. the closing time is about 20 seconds (the same time opening the recordset with that check unchecked) 2. I wasn't able to edit/addnew records Must have client side cursor in this case as driver can't simulate server side/scrollbale cursor on non-cached result sets. I think I can only set a flag that enables/disables cursor (I don't know if it is client side or server side) for the entire database (not a single table) using this syntax (from MSDN): CDatabase::Open virtual BOOL Open( LPCTSTR lpszDSN, BOOL bExclusive = FALSE, BOOL bReadOnly = FALSE, LPCTSTR lpszConnect = ODBC;, BOOL bUseCursorLib = TRUE ); As you can see I can only enable/disable the cursor library. Any clues for me? TIA, Massimo. - This mail sent through IMP: http://web.horde.org/imp/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table gets wiped out!
Ok, rebuillding a table, I did (in Perl): $sth = $dbh - prepare (LOCK TABLES $table WRITE); die $dbh-errstr if (not defined ($sth - execute)); $sth = $dbh - prepare (DELETE FROM $table); die $dbh-errstr if (not defined ($sth - execute)); This truncated the table. Then I filled the table anew, and, at the end (before the UNLOCK), issued: $sth = $dbh - prepare (OPTIMIZE TABLE $table); die $dbh-errstr if (not defined ($sth - execute)); Then... the ENTIRE table is gone after the optimize! If I do not run the optimize, the table is fully restored. But once I optimize it, it is flat gone! I am not so new as to cry bug the moment something escapes my grasp; but I find this very odd, to say the least. I know OPTIMIZE reclaims losts space and such. But what seems to have happened, is that the newly filled rows (that went over the old onces that were deleted) now also get deleted by the OPTIMIZE. If not a bug, then that behavior, pardon my French, is downright crazy. If RE-USED old rows get wiped after an OPTIMIZE, then there is something rotten in the state of Denmark. :) I mean, re-used rows are in use again! This seems related to the LOCK. If I do not LOCK the table first, everything is ok, even after the OPTIMIZE. But with the table still LOCKED (as I am, obviously, still writing to it), all re-used rows in the table just get wiped out after the OPTIMIZE! Yes, I am the guy that decided to set up shop at home too, on my Windows XP machine, to test out a few things before using them on my production server. Good thing I did. :) I tried this on both my FreeBSD box, MySQL 3.32.49 and my home editions, version 3.23.52; the result is the same in both cases. Please, any suggestions would be helpful, Thanks, - Mark - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
HELP: mysqladmin variables
I've already installed mysql ver. 3.23.49-log on my 686i box, Debian Linux OS. How to change the value of skip-networking variables from ON to OFF--because the database server is separated with the Apache Server; both are in the different computer? regards, -- Erwin M Sitorus TROTOAR IT SOLUTIONS http://www.trotoar.web.id - Kebijaksanaan berasal dari Kedunguan Absurditas adalah cikal-bakal Kesempurnaan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 do you define a relationship?
I think I've firmed my theoritical understanding of relationships enough to be dangerous. Now for the logical parthow do you actually define a relationship in mysql? For instance... table movies columns (movie id(pk) , movie title , year filmed) table directors columns (director id(pk), movie id(fk), total movies) Here I have a primary key in each table which I have defined in my table structure. I also have a foreign key in the directors table, but where did I define that to the database? Is this a sort of relationship? Like a one to many? I've noticed in some reading that certain keys are refered to by their respective names ( column - whatever ) and the relatioship column is defined as ( column - relwhatever ), is this the proper way to define a relationship? Is the primary/foreignkey, relationship concept something that is used by the database to replicate data or are they design tools used to develope an independent, non repetitive data structure? Someone please help...I'm so confused. Thanks so 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
Re: Normalization sql
What is the Title.ID and Actor.ID? Will this work if someone is doing a text search on a webpage? The results will go to another page. Does the below go to the first page or the results page? Thank you. At 12:20 PM 10/16/2002 -0400, you wrote: John Chang wrote: Studios (StudioName, StudioID) Genres (GenreName, GenreID) Titles (VideoTitle, Details, StudioID, GenreID, BitRateID, TitleID) Actors (F_Name, L_Name, ActorID) Stars (TitleID, ActorID) TitleGenres (TitleID, GenreID) So, if I just use theses tables I will be OK if the video has multiple titles, multiple actors, multiple genres? How do I create a junction table? Example, between Genres and Titles, how do I add the to PK fields to TitleGenres? Do I just create the TitleGenres table and add the TitleID GenreID field and does the database know they are linked? Sort of; assuming you create a junction table called TitleActors with TitleID, ActorID, and you want the movies with Stalone as the actor them, you might do a query like: select * from Titles LEFT JOIN TitleActors ON Title.ID = TitleID LEFT JOIN Actors ON ActorID = Actors.ID WHERE Actors.L_Name = Stalone; -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
FW: Error delivering message to: bwarehouse@yahoo.com!
-Original Message- From: Postmaster [mailto:Postmaster] Sent: None To: [EMAIL PROTECTED] Subject: Error delivering message to: [EMAIL PROTECTED]! Your message was not delivered for the following reason: E-mail Account: lists-mysql is over the limit of 31457280 bytes. Automated Postmaster Original E-mail From [EMAIL PROTECTED] Sun Oct 20 16:38:42 2002 Return-Path: [EMAIL PROTECTED] Received: from web.mysql.com ([213.136.49.183]) by ; Sun, 20 Oct 2002 16:38:41 -0500 Received: (qmail 25298 invoked by uid 7797); 20 Oct 2002 23:37:46 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com Precedence: bulk List-Help: mailto:mysql-help;lists.mysql.com List-Unsubscribe: mailto:mysql-unsubscribe-lists-mysql=jeikenb.com;lists.mysql.com List-Post: mailto:mysql;lists.mysql.com List-Subscribe: mailto:mysql-subscribe;lists.mysql.com Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 25284 invoked from network); 20 Oct 2002 23:37:45 - Reply-To: [EMAIL PROTECTED] From: bwarehouse [EMAIL PROTECTED] To: Randy Hammons [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: RE: how do you define a relationship? Date: Sun, 20 Oct 2002 14:38:26 -0700 Message-ID: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 In-Reply-To: 005201c2784f$56584490$0501a8c0@web Importance: Normal X-Rcpt-To: [EMAIL PROTECTED] You are on the right track.. but kill your relationships as you have them currently defined... think of it this way... (one to many).. you have movies and you have directors.. it should be one director to many movies seeing that a movie normally only has one director.. so take you primary key from directors and place that foreign key in the movies table. Remember: one director has many movies, not one movie has many directors.. BOTTOM LINE. Make a field in your movies table exactly the same as the primary key in the directors table, but don't autonumber it if that is what is in the primary key of the directors table, just make it the same type( ie. Number, text, date, etc). and make sure it has the exact same specs as the directors primary key field except the autonumber type; and make sure the perimeter is allow duplicate key is set to yes, if you index the field in the movies table), but you don't have to index the foreign key in the movie table if the primary key of the directors table is already indexed. Just make the foreign key, allow duplicates 'YES' in the movie table.. Hope this helps.. Later b.ware -Original Message- From: Randy Hammons [mailto:rathlon1;cox.net] Sent: Sunday, October 20, 2002 8:43 AM To: [EMAIL PROTECTED] Subject: how do you define a relationship? I think I've firmed my theoritical understanding of relationships enough to be dangerous. Now for the logical parthow do you actually define a relationship in mysql? For instance... table movies columns (movie id(pk) , movie title , year filmed) table directors columns (director id(pk), movie id(fk), total movies) Here I have a primary key in each table which I have defined in my table structure. I also have a foreign key in the directors table, but where did I define that to the database? Is this a sort of relationship? Like a one to many? I've noticed in some reading that certain keys are refered to by their respective names ( column - whatever ) and the relatioship column is defined as ( column - relwhatever ), is this the proper way to define a relationship? Is the primary/foreignkey, relationship concept something that is used by the database to replicate data or are they design tools used to develope an independent, non repetitive data structure? Someone please help...I'm so confused. Thanks so 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Re: does mysqlimport actually recreate the table schmea as well as import data?
In the last episode (Oct 20), Peter J. Schoenster said: A cohort wrote a script to import tab delimited files. He uses mysqlimport. He uses the -d option to ONLY empty the data from the table before importing the new data. My cohort believes that mysqlimport is also dropping the table and then recreating the table from somewhere and then inserting the new data. And the problem according to him is that apparently MySQL is using some older version of the table which has a different column structure so that when the new data is imported it goes into the wrong columns. mysqlimport -d does a DELETE FROM table, which simply removes rows. To make sure that the data is pulled into the correct fields, you should use the -c option to mysqlimport and explicitly list the columns in the same order your input file has them. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Tips for LARGE system
Hi Bigger than my experience, so just a suggestion - have you looked at replication? If you have a master which does all the processing and (multiple) slaves which handle all the reads then you might benefit from cheaper Intel hardware and have a more robust system to boot. Good luck! Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net tel. 0121-242-1473 --- -Original Message- From: spiros [mailto:moka;hol.gr] Sent: 21 October 2002 00:00 To: [EMAIL PROTECTED] Subject: Tips for LARGE system I need to come up with an intra-company system recommendation: We are looking at a possibly huge system getting data from a LAN(No web-based app or anything-in fact it will NOT be connected to the web) handling from 3M to 20M records/day with potentially a lot of processing, live inserts/ updates etc. I have a demo version(running on a PIII 2x1000MHz, 2GB RAM Linux machine) but it cannot handle the full load. I am thinking of keeping Mysql 4-0.4. and going to an alpha machine(running linux). The question is whether anyone has done this before. So I am looking for tips and recommendations(before buying any hardware): 1) Are there any known or expected problems with Mysql on alpha machines? 2) Do I need a special linux version(the kernel I use says 2.4.18-4GB, but I need much more RAM and in fact this is the main reason for going to an alpha machine)?(never used linux on anything except Pentiums) 3) Are there any guidelines in estimating more presicely what hardware I will need? 4) I cannot foresee all the possible growth, nor will the initial budget be huge. Is it then woth planning for building out / clustering for some redunacy and some load balancing upfront 5) Suppose I get this system running. What are the problems in keeping it running? Critics say that a)data management is a pain b) scalability is pretty non-existant (just sticking more RAM). I though it would be much cheaper to stick in more RAM than going to another RDBMS c) it lacks a load of fundamental features of large RDBMS. I thought 4.1 should be out between end of Octobera nd January, and it will have triggers, no? 6) How is a hot backup organized in Mysql(i.e. backing up the data while the database is running) 7) I'd also appreciate any input from people who have used official mysql support before. Hopefully there will be a set of issues: a) hardware requirements b) setting up and configuring(i.e. specifying InnoDB buffer sizes) c) performance tuneup. Again, I'd appreciate any info from mysql people or people who used mysql support before. My problem is that from mysql support I am told we can discuss all these after signing a support contract, but to get there I need to come up with a company realistic cost estimate that includes the necessary hardware... I'd appreciate any input from people running such systems. I have never used any other RDBMS, so I am cannot judge if the critisism is justified or not and would appreciate any help on this Thanks, S.Alexiou - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql_install_db script: can't find it
Thanks to those who replied. It wasn't clear to me that that was the case, based on the docs. I'll submit a doc change request to make sure that's more clear to the next person. Gracias, Randy - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, October 19, 2002 6:34 AM Subject: re: mysql_install_db script: can't find it Randy, Saturday, October 19, 2002, 4:23:31 AM, you wrote: RG I've installed and re-installed MySQL on Windows (binary) multiple times, RG using multiple versions (3.x and 4.x). The reference manual discusses a RG script called mysql_install_db, in the /scripts folder. I can't for the RG life of me find such a script anywhere on my machine. RG Do I need to do a compile myself to get this script, or should it be in the RG binary distribution? RG Any help on finding this script, for Windows, would be much appreciated. There is no mysql_install_db script for Windows, privilege tables are created automatically during installation. -- 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
Red Hat Network Updates cause segmentation fault in older versionsof MySQL 3.23
Red Hat Network users who have applied all recent critical updates will experience segmentation faults when accessing MySQL with remote clients (including MyODBC). Access from localhost seems to be OK. The solution is to upgrade to MySQL 3.23.53. At this time RedHat does not have updated 3.23.53 RPMS, so download the linux binaries from your nearest MySQL mirror. FYI, I have experienced this issue on RedHat 7.2 and 8.0 with the 2 most recent RedHat MySQL 3.23.xx RPMS. Hope this helps! Best, Lukas Bower - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
why so late with Mac OS X versions?
Can someone tell me what the holdup is in getting binaries built for Mac OS X? I notice on the www.mysql.com web page that the latest version of the binaries available of the is 4.0.3. Why is this? If somebody can point to the cause of the logjam, there might be something I can do about it. Is it a technical, resource or a personnel problem? thanx - ray - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Tips for LARGE system
I need to come up with an intra-company system recommendation: We are looking at a possibly huge system getting data from a LAN(No web-based app or anything-in fact it will NOT be connected to the web) handling from 3M to 20M records/day with potentially a lot of processing, live inserts/ updates etc. I have a demo version(running on a PIII 2x1000MHz, 2GB RAM Linux machine) but it cannot handle the full load. I am thinking of keeping Mysql 4-0.4. and going to an alpha machine(running linux). The question is whether anyone has done this before. So I am looking for tips and recommendations(before buying any hardware): 1) Are there any known or expected problems with Mysql on alpha machines? 2) Do I need a special linux version(the kernel I use says 2.4.18-4GB, but I need much more RAM and in fact this is the main reason for going to an alpha machine)?(never used linux on anything except Pentiums) 3) Are there any guidelines in estimating more presicely what hardware I will need? 4) I cannot foresee all the possible growth, nor will the initial budget be huge. Is it then woth planning for building out / clustering for some redunacy and some load balancing upfront 5) Suppose I get this system running. What are the problems in keeping it running? Critics say that a)data management is a pain b) scalability is pretty non-existant (just sticking more RAM). I though it would be much cheaper to stick in more RAM than going to another RDBMS c) it lacks a load of fundamental features of large RDBMS. I thought 4.1 should be out between end of Octobera nd January, and it will have triggers, no? 6) How is a hot backup organized in Mysql(i.e. backing up the data while the database is running) 7) I'd also appreciate any input from people who have used official mysql support before. Hopefully there will be a set of issues: a) hardware requirements b) setting up and configuring(i.e. specifying InnoDB buffer sizes) c) performance tuneup. Again, I'd appreciate any info from mysql people or people who used mysql support before. My problem is that from mysql support I am told we can discuss all these after signing a support contract, but to get there I need to come up with a company realistic cost estimate that includes the necessary hardware... I'd appreciate any input from people running such systems. I have never used any other RDBMS, so I am cannot judge if the critisism is justified or not and would appreciate any help on this Thanks, S.Alexiou - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Navigation bar on left, data on right
I want to be able to create a Navigation bar on the left (Where I can do searches, DropDown menu that performs an action) I want this in all my pages but be able to modify it just once. On the right side I want a way of dynamically getting data from a database and showing all searched item in 2 columns. How can I do these 2 things? Anyone I can talk with who can walk me through it? I've spent days working on it but I just can't get it right. I am using PHP, MYSQL, DW MX to code. | Title Header| |Search | Data | Data | |Dropdown menu | Data | Data | || Data | Data | || Data | Data | --- Each Data= -- | Title| | Image href link | | Image_continue more links | | Image Continue more links | -- 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 do you define a relationship?
You are on the right track.. but kill your relationships as you have them currently defined... think of it this way... (one to many).. you have movies and you have directors.. it should be one director to many movies seeing that a movie normally only has one director.. so take you primary key from directors and place that foreign key in the movies table. Remember: one director has many movies, not one movie has many directors.. BOTTOM LINE. Make a field in your movies table exactly the same as the primary key in the directors table, but don't autonumber it if that is what is in the primary key of the directors table, just make it the same type( ie. Number, text, date, etc). and make sure it has the exact same specs as the directors primary key field except the autonumber type; and make sure the perimeter is allow duplicate key is set to yes, if you index the field in the movies table), but you don't have to index the foreign key in the movie table if the primary key of the directors table is already indexed. Just make the foreign key, allow duplicates 'YES' in the movie table.. Hope this helps.. Later b.ware -Original Message- From: Randy Hammons [mailto:rathlon1;cox.net] Sent: Sunday, October 20, 2002 8:43 AM To: [EMAIL PROTECTED] Subject: how do you define a relationship? I think I've firmed my theoritical understanding of relationships enough to be dangerous. Now for the logical parthow do you actually define a relationship in mysql? For instance... table movies columns (movie id(pk) , movie title , year filmed) table directors columns (director id(pk), movie id(fk), total movies) Here I have a primary key in each table which I have defined in my table structure. I also have a foreign key in the directors table, but where did I define that to the database? Is this a sort of relationship? Like a one to many? I've noticed in some reading that certain keys are refered to by their respective names ( column - whatever ) and the relatioship column is defined as ( column - relwhatever ), is this the proper way to define a relationship? Is the primary/foreignkey, relationship concept something that is used by the database to replicate data or are they design tools used to develope an independent, non repetitive data structure? Someone please help...I'm so confused. Thanks so 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
timestamp bug increments by one day
Hi There, Just reciently (after no changes) my MySQL database is automatically incrementing timestamps by one day. Timestamp format is timestamp(14). An example date would be 20021021143513 when I use command such as: INSERT INTO MyTable SET timestamp = 200210211143513; and then: SELECT * FROM MyTable; I get : timestamp 200201221143513 This is happening on Redhat 7.1, MySQL Ver 11.15 Distrib 3.23.38, for pc-linux-gnu (i686) when I type: SELECT NOW(); I get the correct date, and when I type: INSERT INTO MyTable SET timestamp = NOW(); that also increments the timestamp by one day just like it does when I set the timestamp manually. Thanks, Stuart _ Surf the Web without missing calls! Get MSN Broadband. http://resourcecenter.msn.com/access/plans/freeactivation.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: timestamp bug increments by one day
isn't that the month changing? it's changing from october to january...?? Alan -Original Message- From: Jay X [mailto:sparqz50;hotmail.com] Sent: Monday, 21 October 2002 12:20 To: [EMAIL PROTECTED] Subject: timestamp bug increments by one day Hi There, Just reciently (after no changes) my MySQL database is automatically incrementing timestamps by one day. Timestamp format is timestamp(14). An example date would be 20021021143513 when I use command such as: INSERT INTO MyTable SET timestamp = 200210211143513; and then: SELECT * FROM MyTable; I get : timestamp 200201221143513 This is happening on Redhat 7.1, MySQL Ver 11.15 Distrib 3.23.38, for pc-linux-gnu (i686) when I type: SELECT NOW(); I get the correct date, and when I type: INSERT INTO MyTable SET timestamp = NOW(); that also increments the timestamp by one day just like it does when I set the timestamp manually. Thanks, Stuart _ Surf the Web without missing calls! Get MSN Broadband. http://resourcecenter.msn.com/access/plans/freeactivation.asp - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
does mysqlimport actually recreate the table schmea as well as import data?
Hi, A cohort wrote a script to import tab delimited files. He uses mysqlimport. He uses the -d option to ONLY empty the data from the table before importing the new data. My cohort believes that mysqlimport is also dropping the table and then recreating the table from somewhere and then inserting the new data. And the problem according to him is that apparently MySQL is using some older version of the table which has a different column structure so that when the new data is imported it goes into the wrong columns. Anybody familiar with this? He says it's an optimization of MySQL to drop the table first ... but I have seen no confirmation. Peter http://www.coremodules.com/ Web Development and Support at Affordable Prices 901-757-8322[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: how do you define a relationship?
Randy, I think I've firmed my theoritical understanding of relationships enough to be dangerous. Now for the logical parthow do you actually define a relationship in mysql? For instance... http://www.mysql.com/doc/en/SEC447.html table movies columns (movie id(pk) , movie title , year filmed) table directors columns (director id(pk), movie id(fk), total movies) Using these definitions the total_movies column seems redundant to me. select count(*) from movies,directors where movies.movie_id=directors.movie_id would yeald the total movies under said director_id. Ric - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in the list?
can someone tell me why I get this error back from postings? Your message was not delivered for the following reason: E-mail Account: lists-mysql is over the limit of 31457280 bytes. Automated Postmaster Alan McDonald http://www.meta.com.au - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: query
[EMAIL PROTECTED] wrote: Hi, I have this query problem, I know its not related to MySQL server... Got this data Number cost type 1 10 NDD 2 200 LOCAL 1 20 NDD 2 15 NDD 2 30 LOCAL 1 5 LOCAL 2 10 NDD 2 15 LOCAL how to create a query that the output looks like this number cost_NDD cost_LOCAL 1 30 5 2 25 245 anybody can help?I really appreciate it. snipped Looks very familiar. My company does Telecommunications cost analysis... Anyway, you can use a crosstab query, but I prefer using if() statements, because it forces the columns to appear even if there is no data for that column. Of course you have to know what data will be in the column to start with, but that is usually the case... I would use: select Number, cost_LOCAL=sum(if(type='LOCAL',cost,0)), cost_NDD=sum(if(type='NDD',cost,0)) from MyTable group by Number As I said you can research the crosstab way of doing it, but if there is no (for example) IDD data in your table, then it will drop the cost_IDD field completely, and your app will whinge about it. Hope this helps. Also, if you need professional Telcommunications consulting / cost analysis, see our website :) Dan -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.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
Foreign keys in InnoDB tables
Hello I am a brand new user of MySql, and have some questions about using InnoDB tables. I noticed in the manual that you can only specify - ON DELETE SET NULL Or - ON DELETE CASCADE What is the default behaviour if nothing is specified? Also, does anyone know if there are any plans to support additional options? Finally, when you have many tables with a foreign key referencing a table, how does this affect performance of updates on the table being referenced? Thanks. Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: What is relay-bin log?
If all works correctly, can I delete replication logs by RESET SLAVE safely? I'd like to configure two servers with two-master scheme, each is the master of another. -- Chung Ha-nyung alita@[neowiz.com|kldp.org] Sayclub http://www.sayclub.com NeoWiz http://www.neowiz.com -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net] Sent: Friday, October 18, 2002 8:01 PM To: [EMAIL PROTECTED] Subject: re: What is relay-bin log? Chung, Thursday, October 17, 2002, 9:48:15 AM, you wrote: CHn At the slave server of replication there are log files like CHn environment hostname-relay-bin.xxx. Yes, these logs are used for replication: http://www.mysql.com/doc/en/Replication_SQL.html CHn For what these logs and how can I know which one I can delete safely? RESET SLAVE; -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c 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
rolling over mysql logs
HI Probably a silly question, but how can I roll the logs for mysql? I started it with safe_mysqld --log-slow-queries --log So it created two logs in my /var/lib/mysql folder, one holding ALL queries, and one for only the slow queries. The general log is growing quite rapidly, and I would like to gzip the log at the end of each day so it will be easier to find what you are looking for, and so I can delete old logs at a glance. Can someone help me with a script to do 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