synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.52 (Official MySQL RPM) Environment: System: Linux lynx 2.2.16-3 #1 Mon Jun 19 18:10:14 EDT 2000 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/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -fno-omit-frame-pointer -mpentium' CXX='gcc' CXXFLAGS='-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jan 21 01:52 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4101836 Jan 15 2001 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20273324 Jan 15 2001 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jan 15 2001 /usr/lib/libc.so Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-other-libc=/usr/local/mysql-glibc --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --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/share/info --includedir=/usr/include --mandir=/usr/share/man '--with-comment=Official MySQL RPM' CC=gcc 'CFLAGS=-O6 -fno-omit-frame-pointer -mpentium' 'CXXFLAGS=-O6 -fno-omit-frame-pointer -felide-constructors -fno-exceptions -fno-rtti -mpentium' CXX=gcc Perl: This is perl, version 5.005_03 built for i386-linux - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: transaction isolation level
Hi! - Original Message - From: Mark Matthews [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, October 08, 2002 5:07 AM Subject: Re: transaction isolation level Jianliang Zhao wrote: ... I am connecting to MySql 3.23(innodb) with mysql-connector-java-2.0.14-bin.jar. I set the global transaction isolation level to READ COMMITTED. However, I still couldn't see the committed changes through JDBC client. Does anyone know about this issue? ... The isolation level of READ_COMMITTED has no effect currently in MySQL, unless you're using BDB tables...InnoDB runs either as REPEATABLE_READ or SERIALIZABLE, and converts everthing else to REPEATABLE_READ, because it can do REPATABLE_READ as fast (or faster) than most other DB's READ_COMMITTED. I have to correct that BDB always runs at the SERIALIZABLE isolation level. The default for InnoDB is REPEATABLE READ, and you can enhance it to SERIALIZABLE with the SET [GLOBAL | SESSION] TRANSACTION ISOLATION LEVEL { READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SERIALIZABLE } SQL command. Since MyISAM uses table locking, we can say that MyISAM always runs at the SERIALIZABLE level. The command SHOW VARIABLES currently shows the MySQL default isolation level as READ-COMMITTED, but it has no effect on any of the table handlers. Version 4.0.5 will probably feature a new InnoDB isolation level READ COMMITTED. I will probably at the same time change the MySQL default isolation level to REPEATABLE READ. You can then lower the InnoDB isolation level by the command SET [GLOBAL | SESSION] TRANSACTION ISOLATION LEVEL ... Users porting from Oracle and other databases will find READ COMMITTED a useful level. -Mark 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
Bug at GRANT statement?
Hi, When one is doing a GRANT statement at the database level the database name is stored in mysql.db in lowercase letters only, regardless of the upper/lowercase characters used for the database name at the GRANT statement. Example: GRANT SELECT ON SYSMON.* TO theUser@% results in having stored the database name SYSMON as sysmon at mysql.db, column db. GRANT SELECT ON SysMon.* TO theUser@% will grant the privilege to the same database sysmon as the statement above. On a Unix plattform there can be two different databases SYSMON and SysMon! Furthermore, if one manually changes the database name back to the original name - SYSMON - at the column mentioned above and re-run the statement there is a second entry generated in mysql.db: the old one having SYSMON and the new one having sysmon as database name. As the database name is case-sensitive in Unix systems this is critical. I'm running on Win XP, and found this behavior in mysql-MAX NT versions 4.0.2 to 4.0.4. Is this a Bug or intended behaviour? Best regards, Wolf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ANNOUNCE: moodss-16.6 and moomps-2.0
### CHANGES ### --- version 16.6 --- - moomps version 2.0: implemented data cells history feature where cell values are stored in a database (MySQL or PostgreSQL via ODBC) over time, so that for example, common spreadsheet software can be used for presentations, ... - added Edit/Database menu - wrote UNIX manual pages for both moodss and moomps - added support for 3.23.52 and 4.0.4 MySQL server versions in mystatus, myvars and myerrorlog modules - improved internal package management so that modules with a name identical to another package (such as log from tcllib) can still be dynamically loaded - ps module could sometimes initially fail because of an internal divide by zero bug - mounts module now really works from Windows - uses scwoop widget library version 4.1 - removed myquery modules from windows distribution (use existing odbcquery) - successfully tested with Tcl/Tk 8.4.0 ### README ### This is moodss (Modular Object Oriented Dynamic SpreadSheet) version 16.6. Moodss won in the Best System Admin Technology category (Tcl Tips and Tricks, Valuable Real World Programming Examples) at the O'Reilly Tcl/Tk 1999 Conference. Linux Magazine calls it a lifesaver. Tucows gives it 5 stars (cows or penguins :-). Moodss is a modular application. It displays data described and updated in one or more modules, which can be specified in the command line or dynamically loaded or unloaded while the application is running. Data is originally displayed in tables. Graphical viewers (graph, bar, 3D pie charts, ...), summary tables (with current, average, minimum and maximum values) and free text viewers can be created from any number of table cells, originating from any of the displayed viewers. The display area can be extended by adding pages with notebook tabs. Thresholds can be set on any number of cells. Moomps (shipped with moodss) is a monitoring daemon which works using configuration files created by moodss. Thresholds, when crossed, create messages in the system log, and eventually trigger the sending of email alert messages. Specific modules can easily be developed in the Tcl, Perl and Python scripting languages or in C. A thorough and intuitive drag'n'drop scheme is used for most viewer editing tasks: creation, modification, type mutation, destruction, ... and thresholds creation. Table rows can be sorted in increasing or decreasing order by clicking on column titles. The current configuration (modules, tables and viewers geometry, ...) can be saved in a file at any time, and later loaded at the user's convenience, thus achieving a dashboard functionality. The module code is the link between the moodss core and the data to be displayed. All the specific code is kept in the module package. Since module data access is entirely customizable (through C code, Tcl, Perl, Python, HTTP, ...) and since several modules can be loaded at once, applications for moodss become limitless. For example, thoroughly monitor a dynamic web server on a single dashboard with graphs, using the Apache, MySQL, ODBC, cpustats, memstats, ... modules. If you have replicated servers, dynamically add them to your view, even load the snmp module on the fly and let your imagination take over... Along with a core trace module, arp, cpustats, diskstats, interrupts, kernmods, log, memstats, minimal, mounts, netdev, pci, ps, random, route, sensors, system modules for Linux, MySQL (myerrorlog, myhealth, myprocs, myquery, myreplication, mystatus, myvars), odbcquery, ping, snmp, snmptrap for UNIX, apache and apachex, Minimal and Random Perl modules, minipy and randpy Python modules are included. Running wish moodss ps cpustats memstats mimics the top application with a graphic edge and remote monitoring capability. Thorough help is provided through menus, widget tips, a message area, a module help window and a global help window with a complete HTML documentation. Moodss is multi-langual thanks to Tcl internationalization capabilities. So far only English and partially French are supported. Help with other languages will be very warmly welcomed. Development of moodss is continuing and as more features are added in future versions, backward module code compatibility will be maintained. I cannot thank the authors of the tkTable, BLT, MIME/SMTP and the HTML libraries enough for their great work. In order to run moodss, you need to install the following packages (unless you can use the rpm utility, see below): Tcl/Tk 8.3.1 or above, at (or at a mirror near you) http://dev.scriptics.com/ or ftp://ftp.scriptics.com/ the latest tkTable widget library at: http://tktable.sourceforge.net/ the latest BLT library at: ftp://tcltk.sourceforge.net/pub/tcltk/blt/ eventually the latest tclperl library for writing modules in Perl, or the latest tclpython library for writing modules in Python at: http://jfontain.free.fr/ (see the INSTALL file for complete instructions, for UNIX and also Windows platforms). You also have the
Transaction processing
Hi I've been using mysql for a couple of years now, and until now had no real need of transactions. The could list recommend BDB or InnoDB to implement transatcions. On a small system, which one is faster, and handles load better ? Do they both offer foreign key constraints ? Do they fix the enum() field validation feature ? All the best Simon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: syntax help , sql,query
* Dragos Madalin Popa I am trying to run this update statement, but I got an error syntax...near offsetCould You please point out what is wrong? Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where ABBREVIATION is null; Use the CONCAT function: URL: http://www.mysql.com/doc/en/String_functions.html -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: 3.23.52 log rotation crash
On Mon, 2002-10-07 at 17:40, Victoria Reznichenko wrote: MJF One of the machines is simultaneously slave to one server and master to MJF two others; on that machine, if a RESET MASTER or PURGE MASTER LOGS MJF is executed while its slave thread is performing a query, mysqld MJF reproducibly dies. I also saw the similar bug report, but I couldn't repeat it. Could you test it with our binaries? As mentioned, the original crash was observed with the stock Solaris 8 3.23.52-Max binary. The result was the same, just without a gdb-able backtrace. Just to confuse matters, I put the install back to 3.23.42 and could still make it fall over with a stream of INSERTs (just input from a local client and not even the slave thread) and a RESET MASTER concurrently. So, either we've been living very, very luckily for about a year, or this is a problem specific to Solaris 8. (The old installation, which suffered from a number of bugs but never this one, was Sol7/3.23.42) My job is currently to fix this, so I'll try to spread some test cases around a selection of machines to find more information. Cheers, -Matt. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 Fields from a sql table
* Soheil Shaghaghi Hello everyone, Can someone please tell me how I can do the following: From the query below, I want to get the details of the header of the message and display them on a page, one per line. If I just query the Header field, it displays them in one long line. What can I do to display the them one per filed? Since you are using HTML, you can use BR after each line to get a line break, or you can put the entire output within a PRE element. [...] The header should look like this: Return-Path: [EMAIL PROTECTED] Received: from site.com (ns1.site.net [216.188.0.66]) [...] But it looks like this: Return-Path: [EMAIL PROTECTED] Received: from site.com (ns1.site.net [216.188.0.66]) by www.site.com (8.11.1/8.11.1) with SMTP id g8I2Eir74182 It seems you are getting all the data you want, you just need the line breaks. -- Roger 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
Upgrading from v3.23 to 4.0 in Redhat Linux 7.2
I have tried upgrading using the, rpm -Uv MySQL-4.0.3-0.i386.rpm but the following was given: error: failed dependencies: MySQL-server conflicts with mysql-server-3.23.41-1 libmysqlclient.so.10 is needed by mod_auth_mysql-1.11-1 libmysqlclient.so.10 is needed by MyODBC-2.50.37-2 libmysqlclient.so.10 is needed by MySQL-python-0.9.0-2 libmysqlclient.so.10 is needed by mysql-server-3.23.41-1 libmysqlclient.so.10 is needed by perl-DBD-MySQL-1.2216-4 libmysqlclient.so.10 is needed by php-mysql-4.0.6-7 How do I get rid of the old version and install v4.0 while at the same time retaining my data. Regards /Bravismore - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with linux
how to install mysql in linux using userid and passwoed __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Question
* David M. Gonzalez Salinas Does anybody knoy what is equivalent stmt in MySQL? select * from table1 where col1 in (select col1 from table2) This is called a subselect, and it is explained in the manual: URL: http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with linux
.Dear Sir, When Iam trying to connect remote mysql database Using JSP on LINUX Os (6.2/7.2)it is giving an error... Remote system is Windows NT. java.sql.SQLException: Communication link failure: Bad handshake I loaded 1).MySQL-3.23.40-1.i386.rpm 2).MySQL-client-3.23.40-1.i386.rpm files in to my system. Is any other files required to install? How i will overcome this problem . My OS is LINUX Red Hat. My JSP source code is like this: %@ page language=java import=java.sql.* % % Connection Conn = null; ResultSet RS = null; Statement Stmt = null; String DBUrl = jdbc:mysql://IPaddress:3306/db name?user=usernamepassword=pass; Class.forName(org.gjt.mm.mysql.Driver).newInstance(); Conn = DriverManager.getConnection(DBUrl); Stmt = Conn.createStatement(); RS=Stmt.executeQuery(select * from HITS); while(RS.next()) { % br % out.println(RS.getString(1)); } % __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.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: Unicode Support with MySQL
schmid n dean . fellaz . i AM using mysql for UNICODE data all my database is unicode its all stored there i retieve all my unicode data n play round with it all the time n so far i ve had NO problemx . :D any more questions id b glad 2 help all i can good luck toby .. From: Dean Harding [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Unicode Support with MySQL Date: Mon, 7 Oct 2002 17:44:08 +1000 According to the website, it'll be in version 4.1. You can already use Unicode now, though, you just can't sort on it or stuff like that... Dean Harding. -Original Message- From: Schmid Manfred [mailto:[EMAIL PROTECTED]] Sent: Monday, 7 October 2002 5:24 pm To: [EMAIL PROTECTED] Subject: Unicode Support with MySQL Dear Ladies and Gentleman, we are very interested in using MySQL with our machines, but we need a full Unicode-support with the database. Can you give us information's about the time, when MySQL will com with a full Unicode Support? Mit freundlichen Grüßen / Gest Regards Manfred Schmid Software-Entwicklung Abt./Dep.: KT 243 Krauss-Maffei Kunststofftechnik GmbH Bereich Reaktionstechnik / Division Reaction Technology Krauss-Maffei-Straße 2 D - 80997 München Phone: +49 - 89 - 8899-4884 Fax: +49 - 89 - 8899-4024 Mobile:+49 - 172 - 84 83 254 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Unicode Support with MySQL
Yeah, I've used Unicode with MySQL as well. All I was saying is that you can't sort on Unicode fields. And I have a feeling they might not be indexed correctly, either. Dean Harding. -Original Message- From: toby gibbson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 8 October 2002 8:28 pm To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Unicode Support with MySQL schmid n dean . fellaz . i AM using mysql for UNICODE data all my database is unicode its all stored there i retieve all my unicode data n play round with it all the time n so far i ve had NO problemx . :D any more questions id b glad 2 help all i can good luck toby .. From: Dean Harding [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Unicode Support with MySQL Date: Mon, 7 Oct 2002 17:44:08 +1000 According to the website, it'll be in version 4.1. You can already use Unicode now, though, you just can't sort on it or stuff like that... Dean Harding. -Original Message- From: Schmid Manfred [mailto:[EMAIL PROTECTED]] Sent: Monday, 7 October 2002 5:24 pm To: [EMAIL PROTECTED] Subject: Unicode Support with MySQL Dear Ladies and Gentleman, we are very interested in using MySQL with our machines, but we need a full Unicode-support with the database. Can you give us information's about the time, when MySQL will com with a full Unicode Support? Mit freundlichen Grüßen / Gest Regards Manfred Schmid Software-Entwicklung Abt./Dep.: KT 243 Krauss-Maffei Kunststofftechnik GmbH Bereich Reaktionstechnik / Division Reaction Technology Krauss-Maffei-Straße 2 D - 80997 München Phone: +49 - 89 - 8899-4884 Fax: +49 - 89 - 8899-4024 Mobile:+49 - 172 - 84 83 254 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Install Problem
Daniel, Tuesday, October 08, 2002, 2:18:31 AM, you wrote: DM I have been trying to install the DM mysql-3.23.52-pc-linux-gnu-i686.tar.gz on my SUSE Linux 7.3 machine. DM Everything seems to be going smoothly until I entered the command DM ./scripts/mysql_install_db DM I got this output which i believe is ok; [skip] DM Then I try to enter this command to configure my passwords; DM Firstly DM cords-orj86jfje:/usr/local/mysql/mysql # ./bin/safe_mysqld --user=mysql DM [1] 1346 DM cords-orj86jfje:/usr/local/mysql/mysql # Starting mysqld daemon with databases from /usr/local/mysql/mysql/data DM 021007 19:15:21 mysqld ended DM [1]+ Done./bin/safe_mysqld --user=mysql DM THEN, DM cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root password sqlpass DM ./bin/mysqladmin: connect to server at 'localhost' failed DM error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' [skip] DM What am I doing wrong ?? MySQL server isn't running. What is mentioned in the error log? -- 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
storing image in the db ????
hi guyz i ve these images of text n i ve to store em in mysql database ALONG WITH some TEXT n im storing the text in a longtext field vat do i do can n will some1 plz help ? thnx a million guyz toby .. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: MySQL Question
David, Tuesday, October 08, 2002, 2:01:46 AM, you wrote: DMGS Does anybody knoy what is equivalent stmt in MySQL? select * from table1 DMGS where col1 in (select col1 from table2) You can re-write without subselects: http://www.mysql.com/doc/en/ANSI_diff_Sub-selects.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: syntax help , sql,query
Dragos, Monday, October 07, 2002, 7:30:47 PM, you wrote: DMP I am trying to run this update statement, but I got an error syntax...near DMP offsetCould You please point out what is wrong? DMP Update TIMEZONE_INFO set ABBREVIATION = 'GMT' || to_char(OFFSET) where DMP ABBREVIATION is null; There is no function TO_CHAR() in 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: All Remote requests hang server
Hello Les, Tuesday, October 8, 2002, 9:13:22 AM, you wrote: LF I am having a problem getting any kind of remote connections. Connections LF to localhost work just fine. LF The platform is Linux 7.3 LF Installed RPMs are; LF mysqlclient9-3.23.22-6 LF mysql-server-3.23.49-3 LF mysql-3.23.49-3 LF php-mysql-4.1.2-7.3.4 LF mysql-devel-3.23.49-3 The solution: Remove those packages using RPM --erase and then download and install official binary packages from http://www.mysql.com/ -- 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: Privileges for CREATE TEMPORARY TABLE?
Alec, Saturday, October 05, 2002, 5:14:59 PM, you wrote: Since 4.0.2 user must have CREATE TEMPORARY TABLES privilege, it's a global level privilege: http://www.mysql.com/doc/en/News-4.0.2.html AdCaQdC Thank you. That page says that To use these, you must have run the AdCaQdC mysql_fix_privilege_tables script after upgrading. Where can I find this AdCaQdC script? Is it a perl script, as the other scripts are, or just a MySQL AdCaQdC script? I do not currently have perl set up - I am running Win2K. Currently there is no mysql_fix_privilege_tables script for Win :( So, the most effecient way is to copy files from Unix. -- 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: FW: REVISED: Connecting from web server to a MySQL server using Apache+PHP
Nestor, Tuesday, October 08, 2002, 12:58:25 AM, you wrote: NF OK now I am getting this error: NF NF Warning: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in NF /usr/local/httpd/htdocs/mbn.com/confirmation.php on line 36 NF Warning: MySQL Connection Failed: Access denied for user: '[EMAIL PROTECTED]' NF (Using password: YES) in /usr/local/httpd/htdocs/mbn.com/confirmation.php on NF line 36 NF Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) NF NF I look at the db table of mysql and [EMAIL PROTECTED] has select and insert NF permissions NF on the table that I am trying to connect First of all MySQL looks into table 'user': http://www.mysql.com/doc/en/Connection_access.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /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: Loading data into a table
Sean, Monday, October 07, 2002, 10:11:51 PM, you wrote: SM I seem to have run into a rather peculiar problem. I was attempting to load SM data into a table from a file. I checked with the online documentation and SM found the following syntax: SM LOAD DATA LOCAL INFILE pet.txt INTO TABLE pet; SM I used this format exactly (with my own file and table names of course) and SM was greeted with the following error message: SM ERROR 1148: The used command is not allowed with this MySQL version SM Calling 'mysql --version' I have found that I am using version 11.18 Distrib SM 3.23.52 (on w2k). Is there another means by which I can get large amounts SM of data into my table without using a whole whack of INSERT statements? You can specify local-infile=1 for MySQL server and client: http://www.mysql.com/doc/en/LOAD_DATA_LOCAL.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Bug at GRANT statement?
Moestl, Tuesday, October 08, 2002, 10:42:09 AM, you wrote: MW When one is doing a GRANT statement at the database level the database name is stored in mysql.db in lowercase letters only, regardless of the upper/lowercase characters used for the database MW name at the GRANT statement. MW Example: MW GRANT SELECT ON SYSMON.* TO theUser@% MW results in having stored the database name SYSMON as sysmon at mysql.db, column db. MW GRANT SELECT ON SysMon.* TO theUser@% will grant the privilege to the same database sysmon as the statement above. On a Unix plattform there can be two different databases SYSMON and SysMon! MW Furthermore, if one manually changes the database name back to the original name - SYSMON - at the column mentioned above and re-run the statement there is a second entry generated in mysql.db: MW the old one having SYSMON and the new one having sysmon as database name. MW As the database name is case-sensitive in Unix systems this is critical. MW I'm running on Win XP, and found this behavior in mysql-MAX NT versions 4.0.2 to 4.0.4. MW Is this a Bug or intended behaviour? It's not a bug. Seems, you start MySQL server with lower_case_table_names=1. In this case all table/database names will be convert to lower case (SYSMON-sysmon, SySMon-sysmon): http://www.mysql.com/doc/en/Name_case_sensitivity.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
date_add function
Hi I hope I am not being lazy here. I want to use the SQL date_add function on a value from one of my column values but I can't seem to figure out the syntax. This works: select 2002-10-08 09:35:10 + interval 7 hour; but how do I change 2002-10-08 09:35:10 to current_date or feed the values from one (or 2) fields. Ideally I just want the return the time +7 hours. What would also help out is if someone can explain if there is a general rule for using literal strings and column values? Thanx. Dp. ~~ Dermot Paikkos * [EMAIL PROTECTED] Network Administrator @ Science Photo Library Phone: 0207 432 1100 * Fax: 0207 286 8668 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: storing image in the db ????
I am not sure, But maybe you can convert images to mime formart (which is text actually), Browsers can view mime format, and most email clients, There is PERL module called MIME::Lite that can do the conversion. Maybe there is other ways too I am not sure. - Original Message - From: toby gibbson [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 4:09 AM Subject: storing image in the db hi guyz i ve these images of text n i ve to store em in mysql database ALONG WITH some TEXT n im storing the text in a longtext field vat do i do can n will some1 plz help ? thnx a million guyz toby .. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Resubmit: How to Print field(s) to Printer ??
Sorry for the resubmission but I thought I would try again to get a tip on how to do this. I am a newbie, so thanks for any help. I'm Running RedHat Linux 7.3 - Apache - MySQL scripting with PHP on an Intel box... Question 1: I want to print a specified field or fields, in specified records of an mysql db to the line printer several times a day... Can anyone get me started on the PHP script to do this? Question 2: Is there a better place to post PHP MySQL questions? Thanks againf or any help.- tmb __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.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
mysql connectivity with jsp on linux os
Dear Sir, When Iam trying to connect remote mysql database Using JSP on LINUX Os it is giving an error... Remote system is Windows NT. java.sql.SQLException: Communication link failure: Bad handshake I loaded 1).MySQL-3.23.40-1.i386.rpm 2).MySQL-client-3.23.40-1.i386.rpm files in to my system. Is any other files required to install? How i will overcome this problem . My OS is LINUX Red Hat. My JSP source code is like this: %@ page language=java import=java.sql.* % % Connection Conn = null; ResultSet RS = null; Statement Stmt = null; String DBUrl = jdbc:mysql://IPaddress:3306/db name?user=usernamepassword=pass; Class.forName(org.gjt.mm.mysql.Driver).newInstance(); Conn = DriverManager.getConnection(DBUrl); Stmt = Conn.createStatement(); RS=Stmt.executeQuery(select * from HITS); while(RS.next()) { % br % out.println(RS.getString(1)); } % _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connexion to mySQL failure : error 10060
Greetings, I just installed mySQL Server 3.25.52 on my internet connected PC ( which makes Internet gateway via Internet Connexion Sharing ) using Win98SE. I have created a VB program which attacks the mySQL Server using ODBC. Over LAN and Localhost, everything works just fine. I am trying to reach the mySQL Server on another machine via Internet using the Configuration Panel ODBC Drivers DSN utility but I get this error : mySQL : cant connect to mySQL server '123.456.789.123' (10060) Remote user for this client computer was created on the Server using : GRANT ALL PRIVILEGES ON *.* TO soemone@% IDENTIFIED BY 'somepass'; and everything should work... but does not !!! ( worked over LAN ) Remarks : when I try to reach the mySQL server using Telnet + ServerIP + ServerPort ( 3306 ), I get the server's version ( 3.25.52 ) whilst on the LAN. When I do the same on the Client computer over Internet, I cannot get a response from the server despite the fact that ping works fine between the machines... Did I get something wrong ? Could this be the Internet Connexion Sharing translation which provokes this error ? PS : I do not use any Antivirus program and all firewalls have been stopped while testing in course ! Thanks in advance for all ideas on solving this problem... Paul [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
AW: Bug at GRANT statement?
Veronica, That's maybe true, I'll check it. As it's the default setting on Windows and I've never changed it I guess it's on. If the flag lower_case_table_names is turned on, I would expect that SHOW DATABASES os SHOW TABLES is returning lowercase-only names as well? I do get back the exact database and table names as the files in the DATA directory are named, including full upper/lowercases, thus I do get back the name as originally specified when creating the database / table. The manual says (including LOOKUP queries): 8=== If lower_case_table_names is 1 MySQL will convert all table names to lowercase on storage and lookup. (From version 4.0.2, this option also applies to database names.) ===8 Thanks! Best regards, Wolf -Originalnachricht- Von: Victoria Reznichenko An: [EMAIL PROTECTED] Gesendet: 08.10.2002 12:44 Betreff: re: Bug at GRANT statement? Moestl, Tuesday, October 08, 2002, 10:42:09 AM, you wrote: MW When one is doing a GRANT statement at the database level the database name is stored in mysql.db in lowercase letters only, regardless of the upper/lowercase characters used for the database MW name at the GRANT statement. MW Example: MW GRANT SELECT ON SYSMON.* TO theUser@% MW results in having stored the database name SYSMON as sysmon at mysql.db, column db. MW GRANT SELECT ON SysMon.* TO theUser@% will grant the privilege to the same database sysmon as the statement above. On a Unix plattform there can be two different databases SYSMON and SysMon! MW Furthermore, if one manually changes the database name back to the original name - SYSMON - at the column mentioned above and re-run the statement there is a second entry generated in mysql.db: MW the old one having SYSMON and the new one having sysmon as database name. MW As the database name is case-sensitive in Unix systems this is critical. MW I'm running on Win XP, and found this behavior in mysql-MAX NT versions 4.0.2 to 4.0.4. MW Is this a Bug or intended behaviour? It's not a bug. Seems, you start MySQL server with lower_case_table_names=1. In this case all table/database names will be convert to lower case (SYSMON-sysmon, SySMon-sysmon): http://www.mysql.com/doc/en/Name_case_sensitivity.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: storing image in the db
Sherif D Mohamad wrote: I am not sure, But maybe you can convert images to mime formart (which is text actually), Just to be picky; MIME format just describes how to seperate sections of a mail message, the 'text format' version of the image is described in the Content-Type: header of the MIME section in question, probably base64. If you want to store an image as base64, there are plenty of encoders and decoders out there. ... lots of silly SQL spam filters too ... -- 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
startup on win2000 as service not working.
Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with linux
kusuma guntupalli wrote: .Dear Sir, When Iam trying to connect remote mysql database Using JSP on LINUX Os (6.2/7.2)it is giving an error... Remote system is Windows NT. java.sql.SQLException: Communication link failure: Bad handshake I loaded 1).MySQL-3.23.40-1.i386.rpm 2).MySQL-client-3.23.40-1.i386.rpm files in to my system. Is any other files required to install? How i will overcome this problem . My OS is LINUX Red Hat. My JSP source code is like this: %@ page language=java import=java.sql.* % % Connection Conn = null; ResultSet RS = null; Statement Stmt = null; String DBUrl = jdbc:mysql://IPaddress:3306/db name?user=usernamepassword=pass; Class.forName(org.gjt.mm.mysql.Driver).newInstance(); Conn = DriverManager.getConnection(DBUrl); Stmt = Conn.createStatement(); RS=Stmt.executeQuery(select * from HITS); while(RS.next()) { % br % out.println(RS.getString(1)); } % __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.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 You're using a _very_ old version of MM.MySQL that is not compatible with newer versions of MySQL. Please upgrade to something newer, like MySQL Connector/J 2.0.14 from http://www.mysql.com/products/connector-j/ You also might want to look into the search functionality at lists.mysql.com (click on the mailing list name) before asking questions, because most questions have already been answered in the mailing lists many times. -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ 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
storing PDF files in mysql ?????
ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
query help
Here's a query for ya: SELECT products.product_name, products.fg_number, products.product_description, specs.spec_name, specs.spec_value FROM products LEFT JOIN specs ON products.fg_number = specs.fg_number WHERE products.fg_number='fg00914'; and here's the result: +--+---++--+---+ | product_name | fg_number | product_description| spec_name| spec_value | +--+---++--+---+ | | fg00914 || Woofer | 8 injection-molded TCC (talc) test | | | fg00914 || Tweeter | 1 fluid-cooled ultra-wide dispersion tri-laminate Teteron tweeter in a custom pivoting coaxial enclosure | | | fg00914 || Recommended amplifier power | 10 to 150 watts | | | fg00914 || Frequency | 40Hz-21kHz +/- 3dB | | | fg00914 || Sensitivity | 90dB For 2.83V pink noise | | | fg00914 || Impedance | 4 or 8 ohm selectable | | | fg00914 || Dimensions | 10-5/8 diameter | | SPKR,CM8HD | FG00914 | 8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER | Woofer | 8 injection-molded TCC (talc) test | | SPKR,CM8HD | FG00914 | 8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER | Tweeter | 1 fluid-cooled ultra-wide dispersion tri-laminate Teteron tweeter in a custom pivoting coaxial enclosure | | SPKR,CM8HD | FG00914 | 8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER | Recommended amplifier power | 10 to 150 watts | | SPKR,CM8HD | FG00914 | 8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER | Frequency | 40Hz-21kHz +/- 3dB | | SPKR,CM8HD | FG00914 | 8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER | Sensitivity | 90dB For 2.83V pink noise | | SPKR,CM8HD | FG00914 | 8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER | Impedance | 4 or 8 ohm selectable | | SPKR,CM8HD | FG00914 | 8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER | Dimensions | 10-5/8 diameter | +--+---++--+---+ 14 rows in set (0.00 sec) I get 7 rows of data I don't want, then the 7 rows of data I do want... and after scratching my head for awhile, I've come to the conclusion that I do not understand the query structure. (the query came from multiple suggestions in response to my last posting on this list, so clearly it makes sense to some of you...) Can somebody point me to a resource on complicated multi-table select statements? I have the Paul DuBois MySQL book, which got me from 0 to where I am now, but isn't getting me past this particular query. Or maybe just explain how to get the last 7 rows without the first? --it's duplicating the same data with and without the product_name and product_description fields. Here's the table structure: mysql describe products; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(6) | | PRI | NULL| auto_increment | | fg_number | varchar(9) | | MUL | 0 | | | product_name| varchar(64) | | MUL | | | | product_description | varchar(255) | | | | | +-+--+--+-+-++ 4 rows in set (0.00 sec) mysql describe specs; ++--+--+-+-++ | Field | Type | Null | Key | Default | Extra | ++--+--+-+-++ | id | int(12) | | PRI | NULL| auto_increment | | fg_number | varchar(8) | | MUL | || | spec_name | varchar(255) | | | || | spec_value | varchar(255) | | | || ++--+--+-+-++ 4 rows in set (0.00 sec) Man is this
CHAR vs. VARCHAR
After reading the mysql documentation, I am not sure to get correctly the pros and cons of the VARCHAR type. My understanding is that it is useful when a text field has a length that may vary a lot. For example I am thinking using it for a description field where users will put nothing or a small text (for example cf protocol 43) or a bigger text. Am I right in my understanding? If yes, Is it right that using VARCHAR(255) has no influence on the database size? I mean let said that users never use more than 128 chars, would have defined the field as VARCHAR(129) be better? What are the disadvantages of using VARCHAR instead of CHAR. Is it going to be considerably slower? Also, If I want to allow users to add an optional comment for each entry of a table, is it reasonnable to use a VARCHAR so that only one byte is used when no comment are added? or should I create another table to store the comments only when defined by the user? Thanks, Christophe -- Christophe Barbé [EMAIL PROTECTED] GnuPG FingerPrint: E0F6 FADF 2A5C F072 6AF8 F67A 8F45 2F1E D72C B41E Imagination is more important than knowledge. Albert Einstein, On Science - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Unicode Support with MySQL
awww jeeez. tell me bout dat i still ve to work on the indexing n sortin toby From: Dean Harding [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Unicode Support with MySQL Date: Tue, 8 Oct 2002 20:47:17 +1000 Yeah, I've used Unicode with MySQL as well. All I was saying is that you can't sort on Unicode fields. And I have a feeling they might not be indexed correctly, either. Dean Harding. -Original Message- From: toby gibbson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 8 October 2002 8:28 pm To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Unicode Support with MySQL schmid n dean . fellaz . i AM using mysql for UNICODE data all my database is unicode its all stored there i retieve all my unicode data n play round with it all the time n so far i ve had NO problemx . :D any more questions id b glad 2 help all i can good luck toby .. From: Dean Harding [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Unicode Support with MySQL Date: Mon, 7 Oct 2002 17:44:08 +1000 According to the website, it'll be in version 4.1. You can already use Unicode now, though, you just can't sort on it or stuff like that... Dean Harding. -Original Message- From: Schmid Manfred [mailto:[EMAIL PROTECTED]] Sent: Monday, 7 October 2002 5:24 pm To: [EMAIL PROTECTED] Subject: Unicode Support with MySQL Dear Ladies and Gentleman, we are very interested in using MySQL with our machines, but we need a full Unicode-support with the database. Can you give us information's about the time, when MySQL will com with a full Unicode Support? Mit freundlichen Grüßen / Gest Regards Manfred Schmid Software-Entwicklung Abt./Dep.: KT 243 Krauss-Maffei Kunststofftechnik GmbH Bereich Reaktionstechnik / Division Reaction Technology Krauss-Maffei-Straße 2 D - 80997 München Phone: +49 - 89 - 8899-4884 Fax: +49 - 89 - 8899-4024 Mobile: +49 - 172 - 84 83 254 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Resubmit: How to Print field(s) to Printer ??
* tmb I'm Running RedHat Linux 7.3 - Apache - MySQL scripting with PHP on an Intel box... Question 1: I want to print a specified field or fields, in specified records of an mysql db to the line printer several times a day... OK, let's see if we can break this down into smaller tasks: 1) You want specified field/fields from specified records... 2) ...sent to the printer 3) ...several times a day The details: 1) To get data from a mysql database, you use the SELECT statement: URL: http://www.mysql.com/doc/en/SELECT.html 2) To send data to a printer in a Linux environment, take a look at the 'lp' utility by entering 'man lp' on the linux command line. 3) To do this periodically, you can use the cron facility of your linux system, see 'man cron'. Can anyone get me started on the PHP script to do this? Are you sure you want to use PHP for this? PHP is very well suited for making web pages, but not so good for tasks like this... anyway, to get you started with PHP and mysql: URL: http://www.php.net/manual/en/ref.mysql.php Question 2: Is there a better place to post PHP MySQL questions? This list is for mysql questions, but even if your question is mostly PHP related many of the users on this list will be able to help you. Of course, if it is not related to mysql at all, you should not post it to this list. If there is a better place to post PHP MySQL qustions, I don't know. -- Roger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: startup on win2000 as service not working.
On Tue, 8 Oct 2002, Steve Bradwell wrote: Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Hi, Run mysqld-max-nt --install first in order to install your new MySQL as a service. Then it should work, at least you should be able to start the service by entering 'net start mysql'. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Creating a DataSource and Connection in Tomcat for MYsql Database
Hi All I had created a DataSource in Tomcat Admin Console. But i am not getting a connection ds.getConnection() results in error. The error is java.sql.SQLException : cannot load JDBC Driver class null But while creating the datasource i had given the driverclassname as org.gjt.mm.mysql.Driver What could be going wrong Regards, -Arul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 install INNODb in Windows 2000 server
01) at the setup, how do i do to install the software at drive c: and the database files at drive d:? 02) How do i install INNODb at Windows 2000 server with MySql 3.23? Thanks Jacob - Brazil --- UOL Eleições 2002 - Todos os lances da disputa política http://eleicoes.uol.com.br/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: evaluation
robert_goetz, Monday, October 07, 2002, 4:51:02 PM, you wrote: raWSdd i am a trainee at westlb-systems in duesseldorf, germany and it's my task raWSdd to evaluate different dbms' like Postgre SQL, MySQL, MS Access ´97 ;), SAP raWSdd DB and Oracle raWSdd well i searched the web and various documentations but i'm not really sure raWSdd if all of this is still correct or if i may have misunderstood some things raWSdd so i'd like to ask you if you could help me... raWSdd i think it will only take 5 or 10 minutes for you guys to send me some raWSdd _brief_ information about the following aspects concerning MySQL: Almost all your questions are covered at http://www.mysql.com raWSdd - SQL Standards http://www.mysql.com/doc/en/Compatibility.html raWSdd - Support: ODBC, JDBC, API's? http://www.mysql.com/doc/en/Clients.html raWSdd - Portation (is it possible to transport data and how and to which other raWSdd databases?) There are a lot of converters: http://www.mysql.com/doc/en/SEC673.html You can also select data into text file or make a dump file using mysqldump utility: http://www.mysql.com/doc/en/mysqldump.html raWSdd - Administration Tools http://www.mysql.com/doc/en/mysqladmin.html raWSdd - Native Tools ? raWSdd - Licences/Prices http://www.mysql.com/doc/en/MySQL_licenses.html raWSdd - Support http://www.mysql.com/doc/en/Business_Services_Support.html raWSdd - System's Requirements / Required Ressources There is no strong requirement on hardaware ... Here you can find some info related different OS: http://www.mysql.com/doc/en/Operating_System_Specific_Notes.html raWSdd - Operation Systems (Unix/Linux, Windows,...) http://www.mysql.com/doc/en/Which_OS.html raWSdd - Documentation http://www.mysql.com/documentation/index.html raWSdd - Limits / Restrictions Sorry, but this question is too general. raWSdd - Performance (pretty hard to find something about that...) http://www.mysql.com/doc/en/Server_parameters.html raWSdd - Connection to other DB-Systems (Import/Export) ODBC? raWSdd - Cluster - Ability ? http://www.mysql.com/newsletter/2002-09/a67.html raWSdd - Languages http://www.mysql.com/doc/en/Languages.html raWSdd - Backup Possibilities http://www.mysql.com/doc/en/Backup.html raWSdd - Internet - Ability ? What do you mean internet-ability? raWSdd well i'd be really glad if someone could help me with this exhausting raWSdd task... within the next 2 or 3 days would be awesome... -- 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
DATE_SUB - Calendar alarm...!?
Hi! I corrently working with a project to build a web based calendar with alarm (reminder for each event). table 'calendarEvents' start datetime NOT NULL default '-00-00 00:00:00' remindTime tinytext NOT NULL The column 'remindTime' specify the time before an event the alarm will go off. For example one event will have remindTime = 10 MINUTE and another moight have remindTime='1 HOUR' I was hoping to get this work by something like this, but it doesn't. select DATE_SUB(start,INTERVAL remindTime) FROM calendarEvents WHERE 1 or select start - INTERVAL remindTime FROM user_calendar WHERE remindTime!='' Any suggestions how todo it? Is it possible to use DATE_SUB in this case? Best regards /Peter 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: .Optimize mySQL memory usage ? 41MB threads??
Jon, So how do I optimize memory usage? Where to start ? If your server is compiled with debug=full, the command mysqladmin proc stat shows you total server memory use. Look in the manual at How MySQL uses Memory SHOW VARIABLES (for all vars that control server memory use) Perhaps the following little vignette we worked up may help ... The size of the non-InnoDB index buffer is set by key_buffer_size, which to improve performance for even moderately sized databases can be set to a value up to a quarter or more of available server RAM, but to avoid thrashing, should be set to not more than half. The FIFO table handler cache allots up to 64 entries on a per-open-table-per-connection basis. Issuing mysqladmin flush-tables closes all tables that are not in use, marks all other tables for closing when the corresponding thread ends, and frees most allocated memory. The maximum number of concurrent connections is set by max_connections. Each connection - uses a stack of thread_stack bytes, default 64k, - uses a connection buffer of net_buffer_length bytes, default 16k, - uses a result buffer (same size), and - opens each data and index file once, creating for each table a table buffer, buffers for each column, a row buffer 3 times the maximum row length, and if the table has a BLOB column then a BLOB buffer up to the size of the largest BLOB value. So suppose you expect ... - 200 maximum connections, - queries that access 10 tables max + 3 temp tables each, - average table buffer sizes of 32k, - average row lengths of 10k, - no BLOB columns, and - a quarter of all queries requiring sorts, then - the average number of open tables for all threads, (the MySQL variable table_cache) is 200(10 + 3) = 2600, - the server needs 2600*(64+16+16+3*10+32)k + 50(200/4)MB = 510 MB RAM for connection buffering. PB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: problem with Linux
Last time I saw this error, it was due to an authentication issue. Try adding the user you have for the JSP pages or the user who is used for Apache to your domain controller or to the administrative user list under the NT users dialog. If you add this to the domain controller make sure Passwords match. If you add the user to your domain controller you will need to add the user to the local system group for administration. I don't know if this will fix the issue, however it should be a direction to go in. Erik Mullinix -Original Message- From: Mark Matthews [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 6:30 AM To: kusuma guntupalli Cc: [EMAIL PROTECTED] Subject: Re: problem with linux kusuma guntupalli wrote: .Dear Sir, When Iam trying to connect remote mysql database Using JSP on LINUX Os (6.2/7.2)it is giving an error... Remote system is Windows NT. java.sql.SQLException: Communication link failure: Bad handshake I loaded 1).MySQL-3.23.40-1.i386.rpm 2).MySQL-client-3.23.40-1.i386.rpm files in to my system. Is any other files required to install? How i will overcome this problem . My OS is LINUX Red Hat. My JSP source code is like this: %@ page language=java import=java.sql.* % % Connection Conn = null; ResultSet RS = null; Statement Stmt = null; String DBUrl = jdbc:mysql://IPaddress:3306/db name?user=usernamepassword=pass; Class.forName(org.gjt.mm.mysql.Driver).newInstance(); Conn = DriverManager.getConnection(DBUrl); Stmt = Conn.createStatement(); RS=Stmt.executeQuery(select * from HITS); while(RS.next()) { % br % out.println(RS.getString(1)); } % __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos More http://faith.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 You're using a _very_ old version of MM.MySQL that is not compatible with newer versions of MySQL. Please upgrade to something newer, like MySQL Connector/J 2.0.14 from http://www.mysql.com/products/connector-j/ You also might want to look into the search functionality at lists.mysql.com (click on the mailing list name) before asking questions, because most questions have already been answered in the mailing lists many times. -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ 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
re: Problem with encode() and decode() functions
Ross, Monday, October 07, 2002, 8:14:09 PM, you wrote: RR We am having a problem with the encode() and decode() functions. When RR the second argument to the functions is a quoted string, the functions RR return values as expected. When the second argument to the functions is RR another function call, i.e. the char() function, encode() and decode() RR return SQL syntax errors. RR The System is specs are: RR Solaris SunOS sven 5.7 Generic_106541-16 sun4u sparc SUNW,Ultra-5_10, RR MySQL version 3.23.33 RR I looked through the bug fix lists of the later versions and could not RR find a reference to any problem like this on. If it has been fixed, in RR what version was it fixed? [skip] RR select encode(Password,char(107,101,121)); RR ERROR 1064: You have an error in your SQL syntax near RR 'char(107,101,121))' at line 1 [skip] Only first argument of ENCODE() can be an expression. -- 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
Limiting size of individual databases?
I'm sure this is a common requirement, but the only thing I could find in the docs or in a book or two was an unanswered version of the same question at http://www.mysql.com/doc/en/CREATE_DATABASE.html . I'm setting up MySQL on a small ISP and would like to be able to restrict the size of individual databases to something like 25M. What's the best way of getting this done? The server is running Solaris, if it's necessary to do it through the OS insteady of through MySQL. Thanks. Jesse Sheidlower [EMAIL PROTECTED] 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: CHAR vs. VARCHAR
Before I forget: SQL, QUERY ... going write a filter for these some day ... christophe barbe wrote: What are the disadvantages of using VARCHAR instead of CHAR. Is it going to be considerably slower? It really depends on your table, but if you find it slower, break down into multiple tables: create table FeedbackForm ( ID int unsigned, Name char(50), Address char(50), FeedbackCommentID int unsigned ); create table FeedbackComment ( ID int unsigned, Comment blob ); Then your searches through the FeedbackForm are good and fast, and finding the correct Feedback Comments isn't so bad either, but not _as_ fast. BTW, SQL ... QUERY ... bah ... -- 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
Re: storing PDF files in mysql ?????
hi, 2 ways to do this: a) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [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: query help
Michael Knauf/Niles wrote: I get 7 rows of data I don't want, then the 7 rows of data I do want... and after scratching my head for awhile, I've come to the conclusion that I do not understand the query structure. (the query came from multiple suggestions in response to my last posting on this list, so clearly it makes sense to some of you...) Well, you seem to be getting what you asked for ... in your SQL QUERY ... but if its not what you wanted, then describe what you _really_ want, not what you think the query will look like; If you mean: I want the various spec outputs for a product called 'fg00914', then you probably just want to ask for the specs stuff and products stuff seperately, since there's only one product (correct?) and multiple specs (correct?). SELECT * FROM products WHERE fg_number = fg00914; - returns one line SELECT * FROM specs WHERE fg_number = fg00914; - returns 7 lines? -- 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
Features comparison
Dear Sir, Madam, I was trying to make a comparison on you website between the mysql server, acces 2000, microsoft sql server and interbase. Crash-me however does not return any information, it does not work. Is it possible that you can provide me with this information? I hope to hear from you. With kind regards, Arjan Berndsen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: CHAR vs. VARCHAR
Le mar 08/10/2002 à 11:35, Michael T. Babcock a écrit : Before I forget: SQL, QUERY ... going write a filter for these some day ... I don't get what you mean by SQL, QUERY I know how to write a SQL QUERY. I am looking about experienced pros and cons on the use of VARCHAR. My understanding is that, except if you know that each time the text will have the same length, VARCHAR is better. This seems a bit too perfect to be true. Also I am wondering about the tradeof between using a separate table for rare comments (ie. most of the time empty) and the use of a VARCHAR which use only one byte to store an empty comment. Christophe christophe barbe wrote: What are the disadvantages of using VARCHAR instead of CHAR. Is it going to be considerably slower? It really depends on your table, but if you find it slower, break down into multiple tables: create table FeedbackForm ( ID int unsigned, Name char(50), Address char(50), FeedbackCommentID int unsigned ); create table FeedbackComment ( ID int unsigned, Comment blob ); Then your searches through the FeedbackForm are good and fast, and finding the correct Feedback Comments isn't so bad either, but not _as_ fast. BTW, SQL ... QUERY ... bah ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock -- Christophe Barbé [EMAIL PROTECTED] GnuPG FingerPrint: E0F6 FADF 2A5C F072 6AF8 F67A 8F45 2F1E D72C B41E - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: CHAR vs. VARCHAR
Christophe Barbe wrote: Le mar 08/10/2002 à 11:35, Michael T. Babcock a écrit : Before I forget: SQL, QUERY ... going write a filter for these some day ... I don't get what you mean by SQL, QUERY I know how to write a SQL QUERY. I was making sure I'd get past the spam filter. -- 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
Re: CHAR vs. VARCHAR
Christophe Barbe wrote: I am looking about experienced pros and cons on the use of VARCHAR. My understanding is that, except if you know that each time the text will have the same length, VARCHAR is better. This seems a bit too perfect to be true. You do not have to use all the chars ... if you have a field that is CHAR(100), it will always use 100 bytes, but you can insert a 12 byte value (or none) into it anyway. If you have lots of disk space, just use CHAR and ignore VARCHAR if you want. If you want to conserve disk space, VARCHAR will save you some (maybe lots). Also I am wondering about the tradeof between using a separate table for rare comments (ie. most of the time empty) and the use of a VARCHAR which use only one byte to store an empty comment. It depends on your queries; if you don't ask for the large blob often then you'll get better performance with seperate tables. Some of the gurus around here might have additional comments ... PS, SQL QUERYs are fun ... (anti-spam anti-filter) -- 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
problems with load data infile: wrong bytesec
Please cc me as I'm not on this list. Thanks. root[csh]@amber1[15]# mysql --version mysql Ver 11.18 Distrib 3.23.52, for sun-solaris2.9 (sparc) root[csh]@amber1[16]# /usr/local/mysql/libexec/mysqld --version /usr/local/mysql/libexec/mysqld Ver 3.23.52 for sun-solaris2.9 on sparc Scripts are written in root[csh]@amber1[17]# perl -v This is perl, v5.6.1 built for sun4-solaris-64int Using DBD::mysql. As suggested at http://www.mysql.com/doc/en/Insert_speed.html I am using load data infile on a table with indexes turned off. My loading script croaks with two different errors. I have a number of files to load and some of them die reporting Duplicate key for record at X against record at Y while other files tell me failed: Wrong bytesec: 54-49-50 at 365240; ... The duplicate key problem I can handle but I can't figure out which records the message is refering to. Would someone point me to the right place to look in my datafiles? I don't know where to begin with the wrong bytesec message. Searching google and mailing lists, it seems only to come up with isamchk. Turning indexing back on my table and loading data runs smoothly but I'd like have the added speed of a single inde at the end of my script run as I'm often adding millions of entries. Code snippets: $sth = $dbh-prepare(DROP TABLE IF EXISTS $table); $sth-execute(); $sth = $dbh-prepare(create table $table (uid mediumint ... ); $sth-execute(); $sth = $dbh-prepare(FLUSH TABLE $table); $sth-execute(); `$myisamchk --keys-used=0 -rq $mysqldata/$table` $sth = $dbh-prepare(LOAD DATA LOCAL INFILE ? IGNORE INTO TABLE $table); Open the directory containing the data files and load them one by one. $sth-execute( $file ); $myisamchk -rq -O key_buffer_size=256M -O read_buffer_size=64M -O write_buffer_size=128M -O sort_buffer_size=128M $mysqldata/$table $sth = $dbh-prepare(FLUSH TABLE $table); $sth-execute(); Error messages: Opening directory /usr/local/mysql/rawdata/hanwk16 Loading file 1/1089: /usr/local/mysql/rawdata/hanwk16/hanwk16.1034050605.1811 DBD::mysql::st execute failed: Duplicate key for record at 164984 against record at 154696 at /home/brundage/work/projects/HomeDir_Cleanup/scripts/loaddata.pl line 107. Loading file 2/1089: /usr/local/mysql/rawdata/hanwk16/hanwk16.1034050627.1812 DBD::mysql::st execute failed: Duplicate key for record at 201900 against record at 162992 at /home/brundage/work/projects/HomeDir_Cleanup/scripts/loaddata.pl line 107. Loading file 3/1089: /usr/local/mysql/rawdata/hanwk16/hanwk16.1034050642.1813 DBD::mysql::st execute failed: Duplicate key for record at 407136 against record at 8972 at /home/brundage/work/projects/HomeDir_Cleanup/scripts/loaddata.pl line 107. Loading file 4/1089: /usr/local/mysql/rawdata/hanwk16/hanwk16.1034050675.1814 DBD::mysql::st execute failed: Wrong bytesec: 54-49-50 at 365240; Skipped at /home/brundage/work/projects/HomeDir_Cleanup/scripts/loaddata.pl line 107. Loading file 5/1089: /usr/local/mysql/rawdata/hanwk16/hanwk16.1034050740.1815 DBD::mysql::st execute failed: Wrong bytesec: 46-47-50 at 332316; Skipped at /home/brundage/work/projects/HomeDir_Cleanup/scripts/loaddata.pl line 107. Loading file 6/1089: /usr/local/mysql/rawdata/hanwk16/hanwk16.1034050773.1818 DBD::mysql::st execute failed: Wrong bytesec: 45-48-53 at 251544; Skipped at /ho Thanks for the help. --Dean - Unscrambler of eggs -- Quality Web Hosting http://www.3llamas.com It matters not how strait the gate / How charged with punishment the scroll I am the master of my fate / I am the captain of my soul.-- Invictus -- -- William E Henley -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 help
What I _really_ want is the combination of your two querys, that is, product_name, product_description, from the product table + all the specs related to the product from the specs table , based on the fg00914 number. I should get 7 rows in this example I'm using this query in a php web page that displays all that data, and it seems better to do it with one query. Michael Michael T. Babcock To: Michael Knauf/Niles [EMAIL PROTECTED] mbabcock@fibrespcc: [EMAIL PROTECTED] eed.net Subject: Re: query help 10/08/02 11:40 AM Michael Knauf/Niles wrote: I get 7 rows of data I don't want, then the 7 rows of data I do want... and after scratching my head for awhile, I've come to the conclusion that I do not understand the query structure. (the query came from multiple suggestions in response to my last posting on this list, so clearly it makes sense to some of you...) Well, you seem to be getting what you asked for ... in your SQL QUERY ... but if its not what you wanted, then describe what you _really_ want, not what you think the query will look like; If you mean: I want the various spec outputs for a product called 'fg00914', then you probably just want to ask for the specs stuff and products stuff seperately, since there's only one product (correct?) and multiple specs (correct?). SELECT * FROM products WHERE fg_number = fg00914; - returns one line SELECT * FROM specs WHERE fg_number = fg00914; - returns 7 lines? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock Niles Audio Corporation This mail is confidential - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: startup on win2000 as service not working.
You need to Install MySQL as a service. Use the following steps on the DOS command prompt: 1. cd \your-path-to-mysql\bin 2. mysqld-max-nt --install You could then start the service from Services in Control panel or use NET START mysql on the command line. Regards 'Gbamila - Original Message - From: Steve Bradwell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 2:14 PM Subject: startup on win2000 as service not working. Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: CHAR vs. VARCHAR
VARCHAR basically sets a maximum length for the field and only stores the data that is entered into it, thus saving on space. The CHAR type has a fixed length, so if you set CHAR(100), 100 character worth of space will be used regardless of what the contents are. The only time you will gain a speed advantage is if you have no variable length fields in your record (varchar, text, etc.). You may notice that all your CHAR fields are changed to VARCHAR as soon as a variable length field type is added. CHAR is less efficient from a space storage point of view, but more efficient for searching and adding. It's faster because the database only has to read an offset value to get a record rather than reading parts until it finds the end of a record. Also, fixed length records will minimize fragmentation since deleted record space can be reused for new records. I always try to create fixed length records, sticking to CHAR types. I try to split out TEXT types into a separate table, although occasionally (rarely) it's not worth the extra coding effort. Hope that helps a bit. I didn't go into all the +/- off each field type, but I think those are the biggest ones. On Tuesday, October 8, 2002, at 09:50 AM, christophe barbe wrote: After reading the mysql documentation, I am not sure to get correctly the pros and cons of the VARCHAR type. My understanding is that it is useful when a text field has a length that may vary a lot. For example I am thinking using it for a description field where users will put nothing or a small text (for example cf protocol 43) or a bigger text. Am I right in my understanding? If yes, Is it right that using VARCHAR(255) has no influence on the database size? I mean let said that users never use more than 128 chars, would have defined the field as VARCHAR(129) be better? What are the disadvantages of using VARCHAR instead of CHAR. Is it going to be considerably slower? Also, If I want to allow users to add an optional comment for each entry of a table, is it reasonnable to use a VARCHAR so that only one byte is used when no comment are added? or should I create another table to store the comments only when defined by the user? Thanks, Christophe -- Christophe Barbé [EMAIL PROTECTED] GnuPG FingerPrint: E0F6 FADF 2A5C F072 6AF8 F67A 8F45 2F1E D72C B41E Imagination is more important than knowledge. Albert Einstein, On Science - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: query help
Michael Knauf/Niles wrote: What I _really_ want is the combination of your two querys, that is, product_name, product_description, from the product table + all the specs related to the product from the specs table , based on the fg00914 number. Are you sure? :-) As I pointed out, if the first query only gives one row and the second query gives 7 rows, its an odd duplication of data to request the first set alongside the second set. At any rate, try the SQL QUERY SELECTs I recommended to see what results you get first. A contrived example, with PHP (which would look a lot better if the list allowed the odd HTML message to go through): ?php $result = query(SELECT * FROM Products WHERE ...); // Only one result ... $row = mysql_fetch_array($result); ? H2Product: ?php echo $row[Name]; ?, Description: ?php echo $row[Desc]; ?/H2 ?php $result = query(SELECT * FROM ProductInfo WHERE ...); // Multiple results ... while ($row = mysql_fetch_array($result)) { ? LI?php echo $row[InfoName];?: ?php echo $row[InfoData]; ? ?php } ? -- 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
win32 batch scripts
i would like to know how to write batch script for dumping schema and data into a sql file. This script should dump the whole database and data - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: startup on win2000 as service not working.
Check your ini file to make sure the path reflects the proper location of the database. Bruce - Original Message - From: Steve Bradwell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 8:14 AM Subject: startup on win2000 as service not working. Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
index max size and replication question
what is the index max size for mysql 4.0? is it possible to do replication with a master on linux and a slave on windows? if yes, how can I make the slave work on linux if the master crashes? thanks in advance __ Post your free ad now! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: CHAR vs. VARCHAR
Thanks, your comments are very helpful, especially the info that if I have already a not-fixed field in a table the performance cost of adding a VARCHAR (instead of a CHAR) is 0. NOTE for the Mailing-list Admins: There is a 1 hour (at least) between the post and the availability of the mail in the mailing list. Christophe Le mar 08/10/2002 à 12:06, Brent Baisley a écrit : VARCHAR basically sets a maximum length for the field and only stores the data that is entered into it, thus saving on space. The CHAR type has a fixed length, so if you set CHAR(100), 100 character worth of space will be used regardless of what the contents are. The only time you will gain a speed advantage is if you have no variable length fields in your record (varchar, text, etc.). You may notice that all your CHAR fields are changed to VARCHAR as soon as a variable length field type is added. CHAR is less efficient from a space storage point of view, but more efficient for searching and adding. It's faster because the database only has to read an offset value to get a record rather than reading parts until it finds the end of a record. Also, fixed length records will minimize fragmentation since deleted record space can be reused for new records. I always try to create fixed length records, sticking to CHAR types. I try to split out TEXT types into a separate table, although occasionally (rarely) it's not worth the extra coding effort. Hope that helps a bit. I didn't go into all the +/- off each field type, but I think those are the biggest ones. On Tuesday, October 8, 2002, at 09:50 AM, christophe barbe wrote: After reading the mysql documentation, I am not sure to get correctly the pros and cons of the VARCHAR type. My understanding is that it is useful when a text field has a length that may vary a lot. For example I am thinking using it for a description field where users will put nothing or a small text (for example cf protocol 43) or a bigger text. Am I right in my understanding? If yes, Is it right that using VARCHAR(255) has no influence on the database size? I mean let said that users never use more than 128 chars, would have defined the field as VARCHAR(129) be better? What are the disadvantages of using VARCHAR instead of CHAR. Is it going to be considerably slower? Also, If I want to allow users to add an optional comment for each entry of a table, is it reasonnable to use a VARCHAR so that only one byte is used when no comment are added? or should I create another table to store the comments only when defined by the user? Thanks, Christophe -- Christophe Barbé [EMAIL PROTECTED] GnuPG FingerPrint: E0F6 FADF 2A5C F072 6AF8 F67A 8F45 2F1E D72C B41E Imagination is more important than knowledge. Albert Einstein, On Science - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: storing PDF files in mysql ?????
thnx rich but u see the problem iz my clients want their text IN pdf format to be displayed with all these colors on the page in other words they want their sites layout to be maintained on the pages showing this pdf text as they are pretty concerned bout security so what do i do now thnx a mill toby From: R.Dobson [EMAIL PROTECTED] To: toby gibbson [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: storing PDF files in mysql ? Date: Tue, 08 Oct 2002 16:35:56 +0100 hi, 2 ways to do this: a) don't store the file actually in the db but store the path to it. b)use the function LOAD_FILE(filename) to get the contents of a file as a string value and store as a blob. decide which to use depending on how many pics you have cheers Rich toby gibbson wrote: ok guyz more trouble now im supposed to convert all the text (from ms word) to PDF and put the pdf files in mysql db now i ve really got myslf stuck havent i can anyone plz hlp thnx a million stuck az usual toby . _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Richard Dobson Database Administrator MRC Bright Study Clinical Pharmacolgy St Bartholomew's and the Royal London School of Medicine and Dentistry Charterhouse Square London EC1M 6BQ Tel: 020-7882-5670 Mob: 07711-522926 Fax: 020-7882-5672 [EMAIL PROTECTED] _ Send and receive Hotmail on your mobile device: http://mobile.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AUTO_INCREMENT max value...
Hello all... What is the maximum value of an AUTO_INCREMENT field? I am currently running into a maximum value of 296,995,724 on Solaris 8 using MySQL 3.23.42 - the field has been defined as an INT(11), which should be able to handle a value bigger than what I am seeing - The DuBois MySQL book states it should handle 2^31 which turns out to be 2,147,483,648 Is there another setting specifc for AUTO_INCREMENT? If I changed the field's datatype to BIGINT would I be able to achieve higher values? Does anyone out there have other techniques they use in place of AUTO_INCREMENT? Please include my direct email when repsonding - Thanks... -- Bill Hess Technology Resource Group - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 help
It seems that you have two entries in the products table for the same fg_number, one with the values: 'SPKR,CM8HD', 'FG00914', '8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER' And a second one with the same fg_number but in this case with a lowercase F. '', 'fg00914', '' Is this rigth? Please, if you find a good resource for complex queries advise me. I also have the DuBois book, and I need more advanced for advanced queries with mySql. Regards Javier -Mensaje original- De: Michael Knauf/Niles [mailto:[EMAIL PROTECTED]] Enviado el: martes, 08 de octubre de 2002 14:48 Para: [EMAIL PROTECTED] Asunto: query help Here's a query for ya: SELECT products.product_name, products.fg_number, products.product_description, specs.spec_name, specs.spec_value FROM products LEFT JOIN specs ON products.fg_number = specs.fg_number WHERE products.fg_number='fg00914'; and here's the result: +--+---+-- --+--+ -- -+ | product_name | fg_number | product_description | spec_name| spec_value | +--+---+-- --+--+ -- -+ | | fg00914 | | Woofer | 8 injection-molded TCC (talc) test | | | fg00914 | | Tweeter | 1 fluid-cooled ultra-wide dispersion tri-laminate Teteron tweeter in a custom pivoting coaxial enclosure | | | fg00914 | | Recommended amplifier power | 10 to 150 watts | | | fg00914 | | Frequency | 40Hz-21kHz +/- 3dB | | | fg00914 | | Sensitivity | 90dB For 2.83V pink noise | | | fg00914 | | Impedance | 4 or 8 ohm selectable | | | fg00914 | | Dimensions | 10-5/8 diameter | | SPKR,CM8HD | FG00914 | 8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER | Woofer | 8 injection-molded TCC (talc) test | | SPKR,CM8HD | FG00914 | 8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER | Tweeter | 1 fluid-cooled ultra-wide dispersion tri-laminate Teteron tweeter in a custom pivoting coaxial enclosure | | SPKR,CM8HD | FG00914 | 8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER | Recommended amplifier power | 10 to 150 watts | | SPKR,CM8HD | FG00914 | 8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER | Frequency | 40Hz-21kHz +/- 3dB | | SPKR,CM8HD | FG00914 | 8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER | Sensitivity | 90dB For 2.83V pink noise | | SPKR,CM8HD | FG00914 | 8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER | Impedance | 4 or 8 ohm selectable | | SPKR,CM8HD | FG00914 | 8,HIGH DEFINITION,CEILING MNT LOUDSPEAKER | Dimensions | 10-5/8 diameter | +--+---+-- --+--+ -- -+ 14 rows in set (0.00 sec) I get 7 rows of data I don't want, then the 7 rows of data I do want... and after scratching my head for awhile, I've come to the conclusion that I do not understand the query structure. (the query came from multiple suggestions in response to my last posting on this list, so clearly it makes sense to some of you...) Can somebody point me to a resource on complicated multi-table select statements? I have the Paul DuBois MySQL book, which got me from 0 to where I am now, but isn't getting me past this particular query. Or maybe just explain how to get the last 7 rows without the first? --it's duplicating the same data with and without the product_name and product_description fields. Here's the table structure: mysql describe products; +-+--+--+-+-+- ---+ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-+- ---+ | id | int(6) | | PRI | NULL| auto_increment | | fg_number | varchar(9) | | MUL | 0 | | | product_name| varchar(64) | | MUL | | |
RE: transaction isolation level
Thanks for all your help. Then it's more confusing to me. I opened two MySql windows and set autocommit=0 and then update one column and then issue the command COMMIT in one window, in the other MySql window, I queried the column and saw the change immediately. I also did the same thing with one MySql window and one JDBC client(my testcase), and the testcase can see the change immediately. In either case, instead of issuing COMMIT, if I issue ROLLBACK, the change will be rolled back. (Just to make sure the auto commit is not on). Here is my testcase: import java.sql.*; import java.util.Properties; import com.mysql.jdbc.Driver; public class TestMySql { public static void main(String[] args) throws Exception { Driver.class.getName(); Properties props = new Properties(); props.setProperty(user, root); props.setProperty(password, geneva); Connection conn = DriverManager.getConnection(jdbc:mysql://localhost/test, props); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(select * from testtable); while(rs.next()) { System.out.println(rs.getInt(1)); } System.out.println(Please update the table TESTTABLE...); System.in.read(); rs = stmt.executeQuery(select * from testtable); while(rs.next()) { System.out.println(rs.getInt(1)); } } } -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: 2002?10?8? 0:22 To: Mark Matthews Cc: [EMAIL PROTECTED] Subject: Re: transaction isolation level Hi! - Original Message - From: Mark Matthews [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, October 08, 2002 5:07 AM Subject: Re: transaction isolation level Jianliang Zhao wrote: ... I am connecting to MySql 3.23(innodb) with mysql-connector-java-2.0.14-bin.jar. I set the global transaction isolation level to READ COMMITTED. However, I still couldn't see the committed changes through JDBC client. Does anyone know about this issue? ... The isolation level of READ_COMMITTED has no effect currently in MySQL, unless you're using BDB tables...InnoDB runs either as REPEATABLE_READ or SERIALIZABLE, and converts everthing else to REPEATABLE_READ, because it can do REPATABLE_READ as fast (or faster) than most other DB's READ_COMMITTED. I have to correct that BDB always runs at the SERIALIZABLE isolation level. The default for InnoDB is REPEATABLE READ, and you can enhance it to SERIALIZABLE with the SET [GLOBAL | SESSION] TRANSACTION ISOLATION LEVEL { READ UNCOMMITTED | READ COMMITTED | REPEATABLE READ | SERIALIZABLE } SQL command. Since MyISAM uses table locking, we can say that MyISAM always runs at the SERIALIZABLE level. The command SHOW VARIABLES currently shows the MySQL default isolation level as READ-COMMITTED, but it has no effect on any of the table handlers. Version 4.0.5 will probably feature a new InnoDB isolation level READ COMMITTED. I will probably at the same time change the MySQL default isolation level to REPEATABLE READ. You can then lower the InnoDB isolation level by the command SET [GLOBAL | SESSION] TRANSACTION ISOLATION LEVEL ... Users porting from Oracle and other databases will find READ COMMITTED a useful level. -Mark 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Spans Multiple Pages
Hello All. I hope you are all having a great day. ;) I am trying to query MySQL using PHP and I would like the results to display on multiple pages. I would like to display only 20 results per page and allow the user access to the other pages by clicking next or an index of numbers 1 2 3 4 5 6 and so on dependent upon the number of results returned. I do not know how to do this?? Can anyone point me in the right direction??? Also, When a user does perform this query, will all of the pages be created at that time. Or will the page be created with another request and response from the server. In other words. Does the result of the query get stored in a variable that is accessed on the client machine or does the php code return the limit per page and provide a link which acts as another query to display the next page of results. Thanks in advance. Sincerely William - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: thread creation problem
Hello Philipp, Monday, October 7, 2002, 7:02:18 PM, you wrote: PS Can't create a new thread (errno 11). If you are not out of available PS memory, you PS can consult the manual for a possible OS-dependent bug errno 11 may also mean that ulimits are exhausted. PS debian 3.0 PS kernel 2.4.19 (high memory enabled) PS mysql 3.23.52 (compiled from source) You better get MySQL official binaries from http://www.mysql.com/ because compiling MySQL from source is a complicated process and tricky. PS MemTotal: 2069560 kB PS MemFree: 19072 kB PS MemShared: 0 kB PS Cached:1334320 kB PS i see that the cached-value is high, but i think this is to be considered as PS free if needed. i am not sure at this, could PS someone correct me please if i am worng here. You are right, cached memory frees up un demand. PS Philipp -- 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: HA of MySQL
On Mon, 2002-10-07 at 22:02, Jeremy Tinley wrote: The problem isn't so much with the failover. It's with data integrity. Binlogs control replication. You can place a failover master in between the master and slaves. In the event of a master failure, you eliminate the loss of writes by directing them to the failover. If you lose your failover, the binlogs can be completely different thus pointing the slaves to the master is useless. The binlog position is the real problem. Since binlogs are stored with their byte position as the indicator instead of a unique value passed on from the master, there's no easy way of finding the position you were just at. Is is possible to write two binlogs? One to the local disk, one to a network device? If you set up your failover to log-slave-updates, then this will maintain a fairly up to date copy of your binlogs. There is a risk that if one update takes a very long time, then the master might get a long way ahead while the slave replicates this query, but generally as long as updates are short, this should provide a reasonably secure remote copy of the contents of your binlog. The next problem is that there is no way to synchronise the log position on the failover with that on the master. What you can do however, is periodically stop replication on the failover and snapshot the two log positions, eg: slave stop; show slave status; # for Pm show master status; # for Pf slave start; The slave and master positions give you a reasonable chance of doing the arithmetic required to resync all your slaves to the failover if the master fails. Eg: Psf = Psm + (Pf - Pm) where Psf is Position of slave relative to failover, Psm is Position of slave relative to master, Pm is a recorded master position, and Pf is the corresponding slave position of the failover. The arithmetic gets a bit hairy around rotations of the binlogs, compounded by mysql sometimes inserting extra markers in the binlog when rotations occur, and sometimes not. So, the more often snapshots are made of the positions, the better. Anyhow, there's another 2 cents... == Martin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Performance of a sequence many indexed queries
I have a database with a table called targetTsObj, and I want to perform many queries from it, such as this one: select run,rerun,camcol,field,id,ra,decl,r from targetTsObj where ra between 255.84730673785904 and 256.31969326214096 and decl between 58.7494108 and 58.9577892 One of these returns a few hundred records from the 1.2 million records in the table. This query returns in under a second. However, after 40 or so of these queries, the time per query is up to 30 seconds or so. Is this perfomance as expected, or is there something I can do? Build the indices differently? A setting in my.cnf? The machine is running Linux, with 1 GB or ram, MySQL server version 3.23.49 Thanks! === I send the queries with a client program, using these C api's: mysql_real_connect(mysql, host, user, passwd, db, port, unix_socket, client_flag); mysql_query(mysql, query); mysql_store_result(mysql); In a loop, until all rows are fetched: field = mysql_fetch_fields(mysql_res); And after getting all the rows for a query: mysql_free_result(mysql_res); Here is the result of the show index command: mysql show index from targetTsObj; +-++--+--+-+---+-+--++-+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Comment | +-++--+--+-+---+-+--++-+ | targetTsObj | 1 | objId|1 | objId | A | 1228983 | NULL | NULL | | | targetTsObj | 1 | fieldId |1 | fieldId | A |1985 | NULL | NULL | | | targetTsObj | 1 | ra |1 | ra | A | 1228983 | NULL | NULL | | | targetTsObj | 1 | decl |1 | decl| A | 1228983 | NULL | NULL | | | targetTsObj | 1 | u|1 | u | A | 111725 | NULL | NULL | | | targetTsObj | 1 | g|1 | g | A | 122898 | NULL | NULL | | | targetTsObj | 1 | r|1 | r | A | 122898 | NULL | NULL | | | targetTsObj | 1 | i|1 | i | A | 122898 | NULL | NULL | | | targetTsObj | 1 | z|1 | z | A | 111725 | NULL | NULL | | | targetTsObj | 1 | ug |1 | u | A | 111725 | NULL | NULL | | | targetTsObj | 1 | ug |2 | g | A | 1228983 | NULL | NULL | | | targetTsObj | 1 | gr |1 | g | A | 122898 | NULL | NULL | | | targetTsObj | 1 | gr |2 | r | A | 1228983 | NULL | NULL | | | targetTsObj | 1 | ri |1 | r | A | 122898 | NULL | NULL | | | targetTsObj | 1 | ri |2 | i | A | 1228983 | NULL | NULL | | | targetTsObj | 1 | iz |1 | i | A | 122898 | NULL | NULL | | | targetTsObj | 1 | iz |2 | z | A | 1228983 | NULL | NULL | | +-++--+--+-+---+-+--++-+ 17 rows in set (0.00 sec) Finally, here is /etc/my.cnf: bash-2.04$ more /etc/my.cnf [mysqld] set-variable = key_buffer_size=512M set-variable = table_cache=512 set-variable = query_buffer_size=20M # set-variable = sort_buffer=100M # set-variable = read_buffer_size=100M datadir=/export/data/dp20.a/data/mysql socket=/var/lib/mysql/mysql.sock [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: transaction isolation level
Jianliang, I tested that with two mysql clients, and it appeared to work ok. Check with SHOW CREATE TABLE tablename what is the type of your table. Is it MyISAM? Also put the line log to the [mysqld] section of your my.cnf and restart mysqld. Then you will see all received queries in the file 'hostname'.log in your datadir. Check from it what SQL queries your clients actually send to the mysqld server. Regards, Heikki Innobase Oy Below my test: CLIENT A: heikki@hundin:~/mysql/client mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.53-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql set autocmmit = 0; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near 'autocmmit = 0' at line 1 mysql set autocommit = 0; Query OK, 0 rows affected (0.00 sec) mysql create table zhao (a int not null, b int, primary key (a)) type = innodb; Query OK, 0 rows affected (0.11 sec) mysql insert into zhao values (10, 20); Query OK, 1 row affected (0.00 sec) mysql commit - ; Query OK, 0 rows affected (0.00 sec) mysql update zhao set b = 100; Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql CLIENT B: heikki@hundin:~/mysql/client mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.53-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql select * from zhao; ++--+ | a | b| ++--+ | 10 | 20 | ++--+ 1 row in set (0.00 sec) mysql select * from zhao; ++--+ | a | b| ++--+ | 10 | 20 | ++--+ 1 row in set (0.00 sec) mysql select * from zhao; ++--+ | a | b| ++--+ | 10 | 20 | ++--+ 1 row in set (0.00 sec) mysql set autocommit = 0; Query OK, 0 rows affected (0.00 sec) mysql select * from zhao; ++--+ | a | b| ++--+ | 10 | 20 | ++--+ 1 row in set (0.00 sec) mysql commit; Query OK, 0 rows affected (0.00 sec) mysql select * from zhao; ++--+ | a | b| ++--+ | 10 | 20 | ++--+ 1 row in set (0.00 sec) mysql - Original Message - From: Jianliang Zhao [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; Mark Matthews [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 7:40 PM Subject: RE: transaction isolation level Thanks for all your help. Then it's more confusing to me. I opened two MySql windows and set autocommit=0 and then update one column and then issue the command COMMIT in one window, in the other MySql window, I queried the column and saw the change immediately. I also did the same thing with one MySql window and one JDBC client(my testcase), and the testcase can see the change immediately. In either case, instead of issuing COMMIT, if I issue ROLLBACK, the change will be rolled back. (Just to make sure the auto commit is not on). Here is my testcase: import java.sql.*; import java.util.Properties; import com.mysql.jdbc.Driver; public class TestMySql { public static void main(String[] args) throws Exception { Driver.class.getName(); Properties props = new Properties(); props.setProperty(user, root); props.setProperty(password, geneva); Connection conn = DriverManager.getConnection(jdbc:mysql://localhost/test, props); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(select * from testtable); while(rs.next()) { System.out.println(rs.getInt(1)); } System.out.println(Please update the table TESTTABLE...); System.in.read(); rs = stmt.executeQuery(select * from testtable); while(rs.next()) { System.out.println(rs.getInt(1)); } } } -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: 2002?10?8? 0:22 To: Mark Matthews Cc: [EMAIL PROTECTED] Subject: Re: transaction isolation level Hi! - Original Message - From: Mark Matthews [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, October 08, 2002 5:07 AM Subject: Re: transaction isolation level Jianliang Zhao wrote: ... I am connecting to MySql 3.23(innodb) with mysql-connector-java-2.0.14-bin.jar. I set the global transaction isolation level to READ COMMITTED. However, I still couldn't see the committed changes through JDBC client. Does anyone know about this issue? ... The isolation level of READ_COMMITTED has no effect currently in MySQL, unless you're using BDB tables...InnoDB runs either as REPEATABLE_READ or SERIALIZABLE, and converts everthing else to REPEATABLE_READ, because it can do REPATABLE_READ as fast (or faster) than most other DB's READ_COMMITTED. I have to correct that BDB always runs at the SERIALIZABLE isolation level. The default for InnoDB is REPEATABLE READ, and you can enhance it to
Fw: a php connection question
I have Mysql set up on the same machine as the apache server. There is a database name inventory_db with a table product_info which have the two row id and name. I know there are three records in the table. However when ever I place this script below into a webpage I get just a blank page. What can I do to correct it. Thank you ? php # connect to mysql $conn= @mysql_connect(localhost, root) or die (Err:conn); #select the specified database $rs= @mysql_select_db(inventory_db, $conn) or die(Err:Db); #Create the query $sql= select id, name from product_info; #execute the query $rs= mysql_query($sql, $conn); #write the data while ($row=mysql_fetch_array($rs) ) { echo(Product ID: .$row[id]); echo( Product Name: .$row[name] br); } ? /* The gospel is meant to comfort the afflicted and afflict the comfortable. Garrison Keillor*/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compile problems - mysql 3.23.52 - gcc 3.2 - solaris 5.7
Description: Compilation fails with subject configuration due to missing typecasts in sql/mini_client.cc and sql/mysqld.cc How-To-Repeat: ./configure --prefix=/usr/local/mysql --with-innodb make Fix: apply supplied patch which simply provides neccessary typecasting. [ begin mini_client.diff ] *** sql/mini_client.cc Tue Aug 13 18:08:15 2002 --- ../mysql-3.23.52-fixed/sql/mini_client.cc Tue Oct 8 12:28:42 2002 *** *** 318,324 */ s_err=0; ! if (getsockopt(s, SOL_SOCKET, SO_ERROR, (char*) s_err, s_err_size) != 0) return(-1); if (s_err) --- 318,324 */ s_err=0; ! if (getsockopt(s, SOL_SOCKET, SO_ERROR, (char*) s_err, (socklen_t *)s_err_size) != 0) return(-1); if (s_err) [ end mini_client.diff ] [ begin mysqld.diff ] *** sql/mysqld.cc Tue Aug 13 18:08:13 2002 --- ../mysql-3.23.52-fixed/sql/mysqld.ccTue Oct 8 12:11:56 2002 *** *** 2407,2413 { size_socket length=sizeof(struct sockaddr_in); new_sock = accept(sock, my_reinterpret_cast(struct sockaddr *) (cAddr), ! length); if (new_sock != INVALID_SOCKET || (socket_errno != SOCKET_EINTR socket_errno != SOCKET_EAGAIN)) break; --- 2407,2413 { size_socket length=sizeof(struct sockaddr_in); new_sock = accept(sock, my_reinterpret_cast(struct sockaddr *) (cAddr), ! (socklen_t *)length); if (new_sock != INVALID_SOCKET || (socket_errno != SOCKET_EINTR socket_errno != SOCKET_EAGAIN)) break; *** *** 2473,2479 size_socket dummyLen; struct sockaddr dummy; dummyLen = sizeof(struct sockaddr); ! if (getsockname(new_sock,dummy, dummyLen) 0) { sql_perror(Error on new connection socket); (void) shutdown(new_sock,2); --- 2473,2479 size_socket dummyLen; struct sockaddr dummy; dummyLen = sizeof(struct sockaddr); ! if (getsockname(new_sock,dummy, (socklen_t *)dummyLen) 0) { sql_perror(Error on new connection socket); (void) shutdown(new_sock,2); [ end mysqld.diff ] Submitter-Id: submitter ID Originator:Tony Nelson Organization: Starpoint Solutions MySQL support: none Synopsis: Compile fails on solaris 5.7 with gcc 3.2 Severity: non-critical Priority: low Category: mysql Class: sw-bug Release: mysql-3.23.52 (Source distribution) Environment: System: SunOS mail 5.7 Generic_106541-15 sun4u sparc SUNW,Ultra-5_10 Architecture: sun4 Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gmake /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/3.2/specs Configured with: ./configure --enable-langues=c++ Thread model: posix gcc version 3.2 Compilation info: CC='gcc' CFLAGS='' CXX='g++' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1710308 Apr 25 2001 /lib/libc.a lrwxrwxrwx 1 root root 11 Oct 30 2000 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1124692 Apr 25 2001 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1710308 Apr 25 2001 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Oct 30 2000 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1124692 Apr 25 2001 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql --with-innodb - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQLGUI 1.7.5-1 problem
I have downloades the last version of your software, but when I try to connecto to the mysql server remotly, the server crash, and safe_mysqld restar it. Your software reports lost connection to MySQL dureing query And the safe_mysqld reports dureing the crash: bash-2.05# /usr/local/mysql/bin/safe_mysqld: line 273: 3021 Violación de segmento $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking $err_log 21 Any idea what is happening? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
search for email
Hello, I'm fairly new to mySQL and the list, so this might have been discussed in the past, but i couldn't find anything that helped. I'm trying to search for a part of an email adress, either name or domainname or either part of it. If I use match... against, it only lets me search for the part before the @ and gives me results, but ignores the everything after @. Any help would be appreciated. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: transaction isolation level
Thanks Heikki, My testcase is not valid. After I get the connection, I didn't set auto commit to false on the connection object, so I was unable to see the committed data. I saw the REPEATABLE READ behavior now, but it's unfortunate to know READ COMMITTED is not supported yet... --Jianliang -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: 2002?10?8? 9:56 To: Jianliang Zhao; Mark Matthews Cc: [EMAIL PROTECTED] Subject: Re: transaction isolation level Jianliang, I tested that with two mysql clients, and it appeared to work ok. Check with SHOW CREATE TABLE tablename what is the type of your table. Is it MyISAM? Also put the line log to the [mysqld] section of your my.cnf and restart mysqld. Then you will see all received queries in the file 'hostname'.log in your datadir. Check from it what SQL queries your clients actually send to the mysqld server. Regards, Heikki Innobase Oy Below my test: CLIENT A: heikki@hundin:~/mysql/client mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.53-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql set autocmmit = 0; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresp onds to your MySQL server version for the right syntax to use near 'autocmmit = 0' at line 1 mysql set autocommit = 0; Query OK, 0 rows affected (0.00 sec) mysql create table zhao (a int not null, b int, primary key (a)) type = innodb; Query OK, 0 rows affected (0.11 sec) mysql insert into zhao values (10, 20); Query OK, 1 row affected (0.00 sec) mysql commit - ; Query OK, 0 rows affected (0.00 sec) mysql update zhao set b = 100; Query OK, 1 row affected (0.01 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql CLIENT B: heikki@hundin:~/mysql/client mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 to server version: 3.23.53-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql select * from zhao; ++--+ | a | b| ++--+ | 10 | 20 | ++--+ 1 row in set (0.00 sec) mysql select * from zhao; ++--+ | a | b| ++--+ | 10 | 20 | ++--+ 1 row in set (0.00 sec) mysql select * from zhao; ++--+ | a | b| ++--+ | 10 | 20 | ++--+ 1 row in set (0.00 sec) mysql set autocommit = 0; Query OK, 0 rows affected (0.00 sec) mysql select * from zhao; ++--+ | a | b| ++--+ | 10 | 20 | ++--+ 1 row in set (0.00 sec) mysql commit; Query OK, 0 rows affected (0.00 sec) mysql select * from zhao; ++--+ | a | b| ++--+ | 10 | 20 | ++--+ 1 row in set (0.00 sec) mysql - Original Message - From: Jianliang Zhao [EMAIL PROTECTED] To: Heikki Tuuri [EMAIL PROTECTED]; Mark Matthews [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 7:40 PM Subject: RE: transaction isolation level Thanks for all your help. Then it's more confusing to me. I opened two MySql windows and set autocommit=0 and then update one column and then issue the command COMMIT in one window, in the other MySql window, I queried the column and saw the change immediately. I also did the same thing with one MySql window and one JDBC client(my testcase), and the testcase can see the change immediately. In either case, instead of issuing COMMIT, if I issue ROLLBACK, the change will be rolled back. (Just to make sure the auto commit is not on). Here is my testcase: import java.sql.*; import java.util.Properties; import com.mysql.jdbc.Driver; public class TestMySql { public static void main(String[] args) throws Exception { Driver.class.getName(); Properties props = new Properties(); props.setProperty(user, root); props.setProperty(password, geneva); Connection conn = DriverManager.getConnection(jdbc:mysql://localhost/test, props); Statement stmt = conn.createStatement(); ResultSet rs = stmt.executeQuery(select * from testtable); while(rs.next()) { System.out.println(rs.getInt(1)); } System.out.println(Please update the table TESTTABLE...); System.in.read(); rs = stmt.executeQuery(select * from testtable); while(rs.next()) { System.out.println(rs.getInt(1)); } } } -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: 2002?10?8? 0:22 To: Mark Matthews Cc: [EMAIL PROTECTED] Subject: Re: transaction isolation level Hi! - Original Message - From: Mark Matthews [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, October 08, 2002 5:07 AM Subject: Re: transaction isolation level Jianliang Zhao wrote: ... I am connecting to MySql 3.23(innodb) with mysql-connector-java-2.0.14-bin.jar. I set the global transaction isolation level to READ COMMITTED. However, I still couldn't see the committed changes through JDBC client. Does
Re: query help
I think I'm sure, wont I get better performance from one query than two? Michael Michael T. Babcock To: Michael Knauf/Niles [EMAIL PROTECTED] mbabcock@fibrespcc: [EMAIL PROTECTED] eed.net Subject: Re: query help 10/08/02 12:08 PM Michael Knauf/Niles wrote: What I _really_ want is the combination of your two querys, that is, product_name, product_description, from the product table + all the specs related to the product from the specs table , based on the fg00914 number. Are you sure? :-) As I pointed out, if the first query only gives one row and the second query gives 7 rows, its an odd duplication of data to request the first set alongside the second set. At any rate, try the SQL QUERY SELECTs I recommended to see what results you get first. A contrived example, with PHP (which would look a lot better if the list allowed the odd HTML message to go through): Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock Niles Audio Corporation This mail is confidential - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 QNX anyone?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, we've started doing some work of porting MySQL 4.0 to the QNX operating system. The patches are already part of the source tree and MySQL currently compiles and runs, but we have not done any thorough testing yet. One of the known bugs is that mysqld currently does not create a socket file, so you can only access it via TCP/IP. If you are interested in running MySQL on QNX, please get in contact with me directly! We currently would appreciate any feedback on this topic. Bye, LenZ - -- For technical support contracts, visit https://order.mysql.com/?ref=mlgr __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Lenz Grimmer [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Production Engineer /_/ /_/\_, /___/\___\_\___/ Hamburg, Germany ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE9oxSBSVDhKrJykfIRAsDEAJ9jHYFn+apBndC875VLYTF+mA1OZQCfWXue a5CXGe8J3Y/WCjkvIA4rx+0= =dpsJ -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Getting Fields from a sql table
Hello everyone, Can someone please tell me how I can do the following: From the query below, I want to get the details of the header of the message and display them on a page, one per line. If I just query the Header field, it displays them in one long line. What can I do to display the them one per filed? [snip] I may be missing something, but it seems that all your code is doing is creating a very long string out of all the header information. If you want each piece on a 'new line' then you will have to add a 'newline' character yourself between each piece of the string. This isn't really a MySQL question, but a perlish one. -- /* All outgoing email scanned by Norton Antivirus 2002 */ Amer Neely, Softouch Information Services W: www.softouch.on.ca E: [EMAIL PROTECTED] V: 519.438.5887 Perl | PHP | MySQL | CGI programming for all data entry forms. We make web sites work! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
I am currently try to set up mysql on my computer and I'm running into a few bugs. I'm using the book PHP fast easy web development. I've run into a problem when I type the command mysqld --standalone into the prompt. I get the following error: Can't initialize InnoDB as 'innodb_data_file_path' is no set I'm following the directions step by step, yet it's not working. I was hoping you could possibly help me. Thank you. Jeremy O'Niel Imageworks Media Group (509) 545-9100 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 data dumps?
I've been using MySQL now for around a month. I also administer the system where our MySQL implementation is installed. Each night, we perform a full file system backup around 11:50PM. I just noticed that our MySQL root data directory is filling up with binary data files named so: `hostname`-bin.### So, for instance (our hostname is 'dewey'), I saw the following being deposited into our MySQL data dir: -rw-rw1 root root14909 Oct 7 23:50 dewey-bin.035 There are now 35 of these files sitting in the data dir, some of which take up an enormous amount of disk space. Are these data dumps of some sort? Does this happen every time MySQL shuts down? Should I be concerned about this? Should I save these files or delete them? I've checked the logs and MySQL seems to be shutting down just fine (no errors). However, these files are quickly eating away my disk space. A couple of them are over 500MB in size! If any one has any advice or information it would be appreciated. Thanks, Rob Robert Fox Sr. Programmer/Analyst University Libraries of Notre Dame (574)631-3353 [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 mysql-unsubscribe-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Limiting size of individual databases?
On Tue, 8 Oct 2002, Jesse Sheidlower wrote: I'm sure this is a common requirement, but the only thing I could find in the docs or in a book or two was an unanswered version of the same question at http://www.mysql.com/doc/en/CREATE_DATABASE.html . I'm setting up MySQL on a small ISP and would like to be able to restrict the size of individual databases to something like 25M. What's the best way of getting this done? The server is running Solaris, if it's necessary to do it through the OS insteady of through MySQL. Hi, Unfortunately you'll have to use Solaris disk quotas for that. Make sure that the table files of each restricted-space user count towards their personal quotas. This means that you have to create a separate OS account for each user you want to restrict with the quota. This also means that the table files must be owned by those restricted users. I hope this quota feature will be added into MySQL in the future. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: startup on win2000 as service not working.
I had the same problem happen to me. Go in to services and right-click on the mysql service and check the properties. Check that the service is assigned to the right executable. Mine was not so I had to start it manually every time I restarted. Steve Bradwell [EMAIL PROTECTED] 10/08/02 07:14AM Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Remote Connection Probem
Thanks for your response. I tried to connect to the server via telnet as you suggested with the following result. telnet my.machine.ip 3306 Trying my.machine.ip... Connected to my.machine.ip. Escape character is '^]'. Connection closed by foreign host. Is this the behaivior I should expect, or am I correct to assume that the remote host should not terminate the connection. Somebody else on this list reported having the exact same problems after an upgrade from Redhat 7 to Redhat 8 in response to my post. Any more ideas of what could be wrong? - Original Message - From: Ronald Petty [EMAIL PROTECTED] To: Stefan Kuss [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, October 07, 2002 10:59 PM Subject: Re: Remote Connection Probem Try this telnet yourmachine 3306 If you do not get something like Trying yourmachine Conneced to yourmachine Escape character is '^]'. (then sits there on a blank line) Your port is not open, Ron Hi, I am running MySQL 3.23 on Redhat 8.0. I can connect to MySQL from the local machine without any problem and I created a user with remote login privileges. Trying to connect to it from another machine (on the same network as well as the same subnet) gives ERROR: 10061 Connection to mysql server failed. I have no problems connecting to the linux machine via hhtp, ftp, and ssh and a port scan shows that MySQL is infact running on the remote machine (default port 3306). Has anyone heard of similar problems and an idea of how to solve this? -Stefan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
index max size and replication question
what is the index max size for mysql 4.0? is it possible to do replication with a master on linux and a slave on windows? if yes, how can I make the slave work on linux if the master crashes? thanks in advance __ Post your free ad now! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: startup on win2000 as service not working.
I had the same thing happen to me. Go in to services and right-click on the mysql service. Go to properties and verify that the service is assigned to the right executable. Mine was not so I had to start MySQL manually every time I restarted. (MySQL, query) Steve Bradwell [EMAIL PROTECTED] 10/08/02 07:14AM Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Help Needed
Hi I have set up the MySQL database to run locally on my Mac. I have set the privilege for the root user. However, when I log in as the root user I am still unable to create a new database mysql CREATE DATABASE master; ERROR 1006: Can't create database 'master'. (errno: 13) Please tell why this keeps on happening. I am running the following version of MySQl for MAC mysql select version(); ++ | version() | ++ | 3.23.51-entropy.ch | ++ 1 row in set (0.00 sec) This is the privilages that I have granted uses on the system mysql select * from user; +---+--+--+-+-+-+ -+-+---+-+---+--+ ---++-+++ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+--+--+-+-+-+ -+-+---+-+---+--+ ---++-+++ | localhost | root | 04bd6ac2298e4ebd | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | | localhost | | | N | N | N | N | N | N | N | N | N| N | N | N | N | N | | % | pgarcha | | N | N | N | N | N | N | N | N | N| N | N | N | N | N | | localhost | psgarcha | 6a309f0f0ad4b60d | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | | % | psgarcha | 6a309f0f0ad4b60d | Y | Y | Y | Y | Y | Y | Y | Y | Y| Y | Y | Y | Y | Y | | localhost | admin| | N | N | N | N | N | N | Y | N | Y| N | N | N | N | N | | localhost | dummy| dummy| N | N | N | N | N | N | N | N | N| N | N | N | N | N | +---+--+--+-+-+-+ -+-+---+-+---+--+ ---++-+++ 7 rows in set (0.00 sec) Thanks in advance Pushpinder Garcha - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: startup on win2000 as service not working.
Hi, I checked the path, it is correct. I also tried from c:\mysql\bin\mysqld-max-nt --install and got the following, The service already exists! The current server installed: C:/mysql/bin/mysqld-nt.exe So what I can tell is I am not running mysqld-max-nt like I thought I was, but my.ini has all my Innodb definitions. Any idea of what I should do, again if I start mysqld-max-nt --console from command prompt The server runs fine and when I start winmysqladmin.exe, all server info is correct including databases etc, however when I restart the pc, and winmysqladmin.exe starts from the startup folder the server does not start. Thanks again, Steve -Original Message- From: Bruce Lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 12:10 PM To: Steve Bradwell; [EMAIL PROTECTED] Subject: Re: startup on win2000 as service not working. Check your ini file to make sure the path reflects the proper location of the database. Bruce - Original Message - From: Steve Bradwell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 8:14 AM Subject: startup on win2000 as service not working. Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: startup on win2000 as service not working.
Hi, First run 'mysqld-nt --remove' then 'mysqld-max-nt --install' This removes the old installation of the service and then inserts a new InnoDB-enabled registration. Iikka On Tue, 8 Oct 2002, Steve Bradwell wrote: Hi, I checked the path, it is correct. I also tried from c:\mysql\bin\mysqld-max-nt --install and got the following, The service already exists! The current server installed: C:/mysql/bin/mysqld-nt.exe So what I can tell is I am not running mysqld-max-nt like I thought I was, but my.ini has all my Innodb definitions. Any idea of what I should do, again if I start mysqld-max-nt --console from command prompt The server runs fine and when I start winmysqladmin.exe, all server info is correct including databases etc, however when I restart the pc, and winmysqladmin.exe starts from the startup folder the server does not start. Thanks again, Steve -Original Message- From: Bruce Lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 12:10 PM To: Steve Bradwell; [EMAIL PROTECTED] Subject: Re: startup on win2000 as service not working. Check your ini file to make sure the path reflects the proper location of the database. Bruce - Original Message - From: Steve Bradwell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 8:14 AM Subject: startup on win2000 as service not working. Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: startup on win2000 as service not working.
That was it! Thank you all for your help. Steve. -Original Message- From: Iikka Meriläinen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 2:21 PM To: Steve Bradwell Cc: [EMAIL PROTECTED]; Oluwagbamila Oyekanmi; Bruce Lewis Subject: RE: startup on win2000 as service not working. Hi, First run 'mysqld-nt --remove' then 'mysqld-max-nt --install' This removes the old installation of the service and then inserts a new InnoDB-enabled registration. Iikka On Tue, 8 Oct 2002, Steve Bradwell wrote: Hi, I checked the path, it is correct. I also tried from c:\mysql\bin\mysqld-max-nt --install and got the following, The service already exists! The current server installed: C:/mysql/bin/mysqld-nt.exe So what I can tell is I am not running mysqld-max-nt like I thought I was, but my.ini has all my Innodb definitions. Any idea of what I should do, again if I start mysqld-max-nt --console from command prompt The server runs fine and when I start winmysqladmin.exe, all server info is correct including databases etc, however when I restart the pc, and winmysqladmin.exe starts from the startup folder the server does not start. Thanks again, Steve -Original Message- From: Bruce Lewis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 08, 2002 12:10 PM To: Steve Bradwell; [EMAIL PROTECTED] Subject: Re: startup on win2000 as service not working. Check your ini file to make sure the path reflects the proper location of the database. Bruce - Original Message - From: Steve Bradwell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 8:14 AM Subject: startup on win2000 as service not working. Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Apologies - Binary Log info found
Apologies to the list. Apparently the question I asked regarding binary data dumps is an issue involving a MySQL startup parameter: log-bin. Apparently this is the redo-log facility of MySQL for all successful updates. This can be turned on or off. Question answered. Thanks, Rob Robert Fox Sr. Programmer/Analyst University Libraries of Notre Dame (574)631-3353 [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: CHAR vs. VARCHAR
Is it then correct that VARCHAR(255) and TINYTEXT are strictly equivalent? If no, where is the difference? Thanks, Christophe NOTE: I understand now the sql,query stuff. Strange idea. -- Christophe Barbé [EMAIL PROTECTED] GnuPG FingerPrint: E0F6 FADF 2A5C F072 6AF8 F67A 8F45 2F1E D72C B41E Things should be made as simple as possible, but not any simpler. -- Albert Einstein - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: win32 batch scripts
i would like to know how to write batch script for dumping schema and data into a sql file. This script should dump the whole database and data Here is what I use which is pretty straightforward unless I am missing something. d:\mysql\bin\mysqldump -u root --password=password --opt -A d:\databasebackup\databasebackup.bak - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Features comparison
Dear Sir, Madam, I was trying to make a comparison on you website between the mysql server, acces 2000, microsoft sql server and interbase. Crash-me however does not return any information, it does not work. Is it possible that you can provide me with this information? I hope to hear from you. I was also looking at crash-me.php today, seems like this script hasn't been maintained as the version of mysql it compares other software to is 3.23.39. Anyone still working on this? I imagine it's quite a headache to maintain... Josh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: index max size and replication question
On Tue, Oct 08, 2002 at 12:13:28PM -0400, Kevan Louou wrote: what is the index max size for mysql 4.0? What's the largest file your operating system will let you create? is it possible to do replication with a master on linux and a slave on windows? Yes. if yes, how can I make the slave work on linux if the master crashes? I'm not sure what you mean. Can you be more specific? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 63 days, processed 1,349,814,259 queries (246/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to install INNODb in Windows 2000 server
If you want to stay with 3.23 then download the max version. Install the max version. Look at one of the .cnf files in the main mysql directory. Uncomment the lines having to do with innodb. Change the innodb_data_home_dir variable to be the path you want d:\mysql for instance. When you are done with the .cnf file rename it to my.cnf and put it in c:\mysql\data. Restart the server and you should be able to set up innodb tables. NOTE: I am currently using 4.0.4 pro and it loads up with Innodb by default. If you have any further questions please don't hesitate to ask. (mysql, query) carlos.jacob [EMAIL PROTECTED] 10/08/02 08:34AM 01) at the setup, how do i do to install the software at drive c: and the database files at drive d:? 02) How do i install INNODb at Windows 2000 server with MySql 3.23? Thanks Jacob - Brazil --- UOL Eleições 2002 - Todos os lances da disputa política http://eleicoes.uol.com.br/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: CHAR vs. VARCHAR (fork)
The only time you will gain a speed advantage is if you have no variable length fields in your record (varchar, text, etc.). You may notice that all your CHAR fields are changed to VARCHAR as soon as a variable length field type is added. CHAR is less efficient from a space storage point On that note, I've often wanted to be able to do something along the lines of: ALTER TABLE foo USE CHAR; ALTER TABLE foo USE VARCHAR; ... and just port the current max-length values between the two, while changing all relevant columns. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock ... 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: win32 batch scripts
Todd, i would like to know how to write batch script for dumping schema and data into a sql file. This script should dump the whole database and data Write this in a batch file: mysqldump [options] dbname somename.sql where dbname is the name of the db. See the manual for mysqldump options. PB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: index max size and replication question
--- Jeremy Zawodny [EMAIL PROTECTED] wrote: On Tue, Oct 08, 2002 at 12:13:28PM -0400, Kevan Louou wrote: what is the index max size for mysql 4.0? What's the largest file your operating system will let you create? Is your answer related to the index size meaning that it is limited by the OS capability? I saw somewhere that it is limited to 4 Gig (MySQL 3.29) is it possible to do replication with a master on linux and a slave on windows? Yes. if yes, how can I make the slave work on linux if the master crashes? I'm not sure what you mean. Can you be more specific? Suppose the master file becomes corrupted (linux), can we recover the file from the slave (That is, from the Windows OS)? thanks David Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 63 days, processed 1,349,814,259 queries (246/sec. avg) __ Post your free ad now! http://personals.yahoo.ca - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 install Problem?
I have am having problems getting the MySQL server to start running, please help me, here are my problems, I have also displayed my error logs below, at least I hope they are the error logs; I have been trying to install the mysql-3.23.52-pc-linux-gnu-i686.tar.gz Everything seems to be going smoothly until I entered the command ./scripts/mysql_install_db I got this output which i believe is ok; cords-orj86jfje:/usr/local/mysql/mysql # ./scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 021007 18:15:39 ./bin/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h cords-orj86jfje password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./bin/safe_mysqld You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the ./bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com Then I try to enter this command to configure my passwords; Firstly cords-orj86jfje:/usr/local/mysql/mysql # ./bin/safe_mysqld --user=mysql [1] 1346 cords-orj86jfje:/usr/local/mysql/mysql # Starting mysqld daemon with databases from /usr/local/mysql/mysql/data 021007 19:15:21 mysqld ended [1]+ Done./bin/safe_mysqld --user=mysql THEN, cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root password sqlpass ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' OR cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root sqlpass ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! Now I was told my a few intelligent guys that I must check the mysql error logs and that they should tell me what is going wrong so I went looking for these mysterious error logs; mike@cords-orj86jfje:/var/lib/mysql locate *.err /var/lib/mysql/cords-orj86jfje.err mike@cords-orj86jfje:/var/lib/mysql ls cords-orj86jfje.err mysql test mike@cords-orj86jfje:/var/lib/mysql pico cords-orj86jfje.err 21002 10:09:23 mysqld started /usr/sbin/mysqld: ready for connections A mysqld process already exists at Wed Oct 2 10:11:58 EDT 2002 A mysqld process already exists at Wed Oct 2 10:13:36 EDT 2002 021002 10:21:37 /usr/sbin/mysqld: Normal shutdown 021002 10:21:37 /usr/sbin/mysqld: Shutdown Complete 021002 10:21:37 mysqld ended ALSO; cords-orj86jfje:/usr/local/mysql/mysql/data # ls . .. cords-orj86jfje.err cords-orj86jfje.err.save mysql test cords-orj86jfje:/usr/local/mysql/mysql/data # pico cords-orj86jfje.err 021007 17:41:08 mysqld started 021007 17:41:08 /usr/local/mysql/mysql/bin/mysqld: Table 'mysql.host' doesn't exist 021007 17:41:08 mysqld ended 021007 18:03:06 mysqld started 021007 18:03:07 /usr/local/mysql/mysql/bin/mysqld: Table 'mysql.host' doesn't exist 021007 18:03:07 mysqld ended 021007 18:05:01 mysqld started 021007 18:05:01 /usr/local/mysql/mysql/bin/mysqld: Table 'mysql.host' doesn't exist 021007 18:05:02 mysqld ended 021007 19:01:35 mysqld started 021007 19:01:35 /usr/local/mysql/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021007 19:01:35 mysqld ended 021007 19:03:17 mysqld started 021007 19:03:17 /usr/local/mysql/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021007 19:03:17 mysqld ended 021007 19:09:55 mysqld started 021007 19:09:55 /usr/local/mysql/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021007 19:09:55 mysqld ended 021007 19:15:21 mysqld started 021007 19:15:21 /usr/local/mysql/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021007 19:15:21 mysqld ended 021008 13:41:20 mysqld started 021008 13:41:21 /usr/local/mysql/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021008 13:41:21 mysqld ended Where is this file host.frm ??? cords-orj86jfje:/usr/local/mysql/mysql/data # locate *.frm cords-orj86jfje:/usr/local/mysql/mysql/data # locate host* cords-orj86jfje:/usr/local/mysql/mysql/data # /**MILLION DOLLAR QUESTION*/ I believe I have viewed my err logs but I still don't know what I have to do to get MySQL server to start working? What must I do to get the MySQL server to start working? Thanks,