RE: Connecting M. Access Forms to insert data into mysql
Have you tried Linking the MySQL tables into access? I do not know why you would still have a memo field. Also if you need it you could map the memo field in Access to a TEXT or a BLOBTEXT in MySQL. If you have access to Visual Basic it could be a bettere option. HTH JFernando ** sql ** -Original Message- From: Grant Cooper [mailto:[EMAIL PROTECTED]] Sent: December 14, 2002 22:11 To: MySQL List Subject: Re: Connecting M. Access Forms to insert data into mysql I've installed about 12 client gui's and here's my conclusion. DBQwikEdit - has the best editor for Data Entry - nice form to add one record at a time - similar to access forms (I want this) - As far as I can tell, is the only product that has this feture http://www.mysqlstudio.com/ - nice for management - but the shit for a single user wanting to add data like access in forms. My problem is if I use Access for the front end it doesn't always out put the memo fields right. So I want a client GUI that specifically will allow one record / page. Making it very user friendly. Is using Access the way to go or is there a product I'm missing? - Original Message - From: Grant Cooper [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Saturday, December 14, 2002 6:49 PM Subject: Connecting M. Access Forms to insert data into mysql I am trying to find a package to insert data. And was wondering if I can use odbc drivers to connect Access to mysql in real time? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: user/root
On Wednesday, January 1, 2003, at 08:06 PM, R. Hannes Niedner wrote: You have a recent installation of mysql then you can just run SET PASSWORD FOR root@localhost=PASSWORD('tko'); and skip the flush privileges. All explained here: http://www.mysql.com/doc/en/Default_privileges.html Best/h [MacG4a:/usr] rnagle% mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 3.23.53-entropy.ch Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql Well it would appear that I finally have a connection q. since I am root, do I still need to GRANT a database to myself? or just a to a new user. aka: bob@localhost TKS Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FAQ hosting site
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Peter, et al -- ...and then Peter Lovatt said... % % Hi Hi! % % Like the look of the way its taking shape. Glad to hear it. Come and sign up on the new list, then :-) % % I am not sure if there is existing faq software (I've checked sourceforge % and freshmeat without much luck) we could use, or if someone can do a better Hmmm... I don't know about software that allows contributors to fill up the FAQ, but I know that there is software to generate the FAQ from its questions and answers; that part doesn't worry me. % job :) but I have a content management system written, together with a lot % of the search functionality needed for the faq. It can mix database stored % content with static content, so it would probably do the job with a little % work. It also does the membership authorisation/management. Cool! % % I'd be happy to build the software, if that helps. We'd love to have you :-) % % Let me know % % Peter Thanks HAND HNY mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+FBmUGb7uCXufRwARArngAKDKnfSpag+Iq4QyuWtTILLqeyxp6QCfa/Lo yJ1RCORLcqYClWD9Vni0fvA= =gIVj -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: FAQ hosting site
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruce -- ...and then Bruce Lewis said... % % Why not try Tek-Tips? Maybe they will sponsor something for free. They may % have everything you need. I suppose they might. Never heard of 'em... % % Just a thought. % % [EMAIL PROTECTED] [EMAIL PROTECTED] Thanks for the pointer! % % Bruce Thanks HAND HNY mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+FBpZGb7uCXufRwARAtxHAKCpR7GSFb1hKqHrMZq8McslghmKCACfUpmK 7VuzXxql/GWlhLEx4cWW050= =8Nr8 -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: Accessing last_insert_id problem.
LAST_INSERT_ID is held for the database connection, not agaist the server So, as long as you do not do another insert using the same database connection, LAST_INSERT_ID will be fine. (for database connection, $dbh=DBI-connect. ) No table locking required. Regards M On Wed, 18 Dec 2002, Jeff Snoxell wrote: Date: Wed, 18 Dec 2002 12:21:14 + From: Jeff Snoxell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Accessing last_insert_id problem. Hi, I'm adding records to a db using the Perl DBI. Subsequent to adding a record I need to know the value of the auto-incrementing 'Ref' field so that I can place a copy of the relavent details into a log file. I could query for the LAST_INSERT_ID but what if another process has added another record in the interim? Is this a job for table locking? Many thanks, Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Matthew Smith Nominet UK - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: host.frm
On 1/1/03 8:43 PM, Jason Steig [EMAIL PROTECTED] wrote: ./myqld: Can't find file : './mysql/host.frm' (errno:13) does anyone know how to solve this problem? This file is part of the host table in your mysql database 'mysql'. Did you by any chance copy the mysql data directory or parts of it or do any actions that would change permissions or even delete file in this directory (possibly /usr/local/mysql-version/data) ? In the worst case you need to back up your data directory and have to run the install_db script again after you have set the root password to '' (nothing). HTH/h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql 3.23.54a install failure
Hi all! I am trying to install Mysql 3.23.54a on my Slackware Linux machine and when I do make test it fails like this : root@southpark:/home/cartman/mysql-3.23.54a# make test cd mysql-test ; ./mysql-test-run Installing Test Databases Removing Stale Files Installing Master Databases ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' 030102 10:44:15 ../sql/mysqld: Shutdown Complete Installing Slave Databases ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' ERROR: 1033 Incorrect information in file: './mysql/db.frm' 030102 10:44:15 ../sql/mysqld: Shutdown Complete I configure like this : CFLAGS=-O3 -march=i486 -mcpu=i686 CXX=gcc CXXFLAGS=-O3 -march=i486 -mcpu=i686 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --prefix=/usr \ --with-mysqld-user=mysql \ --with-unix-socket-path=/var/run/mysql/mysql.sock \ --localstatedir=/var/lib/mysql \ --enable-assembler \ --with-raid \ --without-debug \ --without-readline \ --without-bench \ --with-extra-charsets=complex \ --program-prefix= --program-suffix= \ i386-slackware-linux I have gcc 3.2.1 , glibc 2.3.1+compat patches from slackware , binutils 2.13.1. Anyone have an idea whats might be wrong? I remember installing mysql correctly with glibc 2.2.5 maybe a glibc problem? Any help is appreciated. Regars ismail = Microsoft Windows: made for the internet The Internet: made for UNIX __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
How can we tell if we're maxing out MySQL/InnoDB capacity?
Hi, Yesterday happened to be one of the busiest days for us ever on our MySQL backed web site. For the entire day MySQL was hit with up to 1200 queries/second, and many queries were being delayed at least 2-15 seconds. We were serving about 300% of our normal load. In my opinion MySQL scaled more gracefully than I have ever known in 4 years. It did not go into a downward spiral where once it went above a threshold all work stopped. Instead, everything became gradually slower, but still functioned albeit less quickly. Right now I'm trying to figure out what bottlenecks the RDBMS was hitting so we could throw some hardware at the problem. I am not the kind of person to solve technical issues with hardware, but given that nothing else appears to be wrong and I've done every reasonable optimization possible, we have little choice. However, I can't figure out exactly why it was slow. Key efficiency was at 100%, and I *believe* the InnoDB buffer pool was large enough as the InnoDB monitor was reporting 1000 / 1000 cache hits. iostat showed the usual levels of disk I/O. What other statistics can I look at? We're using MySQL 3.23.54 Our hardware is dual P3 1GHz, 2GB of RAM, and about 56GB of IDE RAID-1 backed disk (3ware escalade). We're running Red Hat's Linux v2.4.7-10smp my.cnf: set-variable = innodb_buffer_pool_size=800M set-variable = innodb_additional_mem_pool_size=50M set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=75M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=0 set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 set-variable = wait_timeout=3600 set-variable = tmp_table_size=800 set-variable = max_connections=315 set-variable = table_cache=256 set-variable = sort_buffer=4M set-variable = key_buffer=128M set-variable = thread_cache_size=350 set-variable = max_connect_errors=5 Could anyone suggest anything? -- Michael Bacarella | Netgraft Corp | 545 Eighth Ave #401 Systems Analysis | New York, NY 10018 Technical Support | 212 946-1038 | 646 641-8662 Managed Services | http://netgraft.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: query requiring two results from one table?
Hi, Greg's table definitions seem fine te me. Couldn't he just use: select game.gameid, game.dateTime, home.teamID, home.name, away.teamID, away.name from Games game left join Teams home on home.teamID = game.homeID left join Teams away on away.teamID = game.awayID Unless he wants the result in two rows of course. Regards, Fred. On Mon, Dec 30, 2002 at 11:37:03AM -0600, Cal Evans wrote: Your structure is flawed for this kind of query. Games should be: Games --- gameID === teamID (FK to teams) dateTime (datetime) homeAwayFlag char(1) // either H or A --- This way you could use something like select g.gameid, g.teamID, g.homeAwayFlag, g.dateTime, h.teamid, h.name from Games g left join Teams t on g.teamID = h.teamID order by dateTime, homeAwayFlag As it is (IMHO) your only choice is to use 2 SELECT statements and a UNION (Ugly solution) select g.gameid, g.teamID, g.homeID, null as awayID, g.dateTime, h.teamid, h.name from Games g left join Teams t on g.teamID = h.homeID UNION select g.gameid, g.teamID, null as homeID, g.awayID, g.dateTime, h.teamid, h.name from Games g left join Teams t on g.teamID = h.awayID order by dateTime I've not tested this but it should point you in the right direction. (But again, changing your structure is a much better solution.) HTH, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 11:11 AM To: [EMAIL PROTECTED] Subject: query requiring two results from one table? Hello, This is my first post to the list, so if I am asking in the wrong place, I apologize. I've got some trouble putting together a query with the following tables Games: Teams: gameid teamid homeid name awayid datetime i want to get all games within a certain timeframe, but also retrieve the team names for both the homeid and awayid (these are both links to the teams.teamid field). Not sure how to get two results from the same table in one query. Can anybody point me in the right direction. thanks gf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
synopsis of the problem (one line)
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.23.53 (VineLinux MySQL RPM) Server: /usr/bin//mysqladmin Ver 8.23 Distrib 3.23.53, for pc-linux-gnu on i586 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.53 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 9 min 13 sec Threads: 1 Questions: 2 Slow queries: 0 Opens: 6 Flush tables: 1 Open tables: 0 Queries per second avg: 0.004 Environment: System: Linux carroll 2.4.18-0vl3 #4 Sat Apr 27 00:12:50 JST 2002 i686 unknown Architecture: i686 Some paths: /usr/bin//perl /usr/bin//make /usr/bin//gmake /usr/bin//gcc /usr/bin//cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS=' -O3' CXX='gcc' CXXFLAGS=' -O3 -felide-constructors -fno-exceptions -fno-rtti ' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Apr 21 2002 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 5343926 Nov 14 09:23 /lib/libc-2.2.4.so -rw-r--r--1 root root 27332668 Apr 3 2002 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 3 2002 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Apr 21 2002 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --without-berkeley-db --without-innodb --enable-assembler --enable-local-infile --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/usr --with-extra-charsets=all --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/share/man '--with-comment=VineLinux MySQL RPM' CC=gcc 'CFLAGS= -O3' 'CXXFLAGS= -O3 -felide-constructors -fno-exceptions -fno-rtti ' CXX=gcc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New Member question - Training
Hello Folks - I've been lurking for a few days so I thought I would go ahead and ask... I'm in (metro) Atlanta. Is there anyone/any place here that trains on using MySQL? Ideally, I would like someone to train me on how to use MySQL with phpMyAdmin (2.3.2) on my virtual servers. I also would like to use GoLive 6's - Dynamic Content abilities in conjunction with phpMyAdmin. If anyone has any direct leads I would love to hear them (off list I imagine). Sincerely, Terry Webmaster For Rent! Georgia Web Pro - Web Design :: Web Hosting :: Programming http://www.georgiawebpro.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: query requiring two results from one table?
Yes, this is what i ended up doing and it works just fine. I wanted the results in one record and this does the job just fine. I don't know enough about performance issues and whether this kind of query is inefficient compared to using a different database layout, but this is not a highly intensive application and i'm developing on an old PII-200 and the speed of the results is negligible, so I am very happy with this solution. gf Fred van Engen [EMAIL PROTECTED] 01/02/2003 10:57 AM To: Cal Evans [EMAIL PROTECTED] cc: [EMAIL PROTECTED], [EMAIL PROTECTED] Subject:Re: query requiring two results from one table? Hi, Greg's table definitions seem fine te me. Couldn't he just use: select game.gameid, game.dateTime, home.teamID, home.name, away.teamID, away.name from Games game left join Teams home on home.teamID = game.homeID left join Teams away on away.teamID = game.awayID Unless he wants the result in two rows of course. Regards, Fred. On Mon, Dec 30, 2002 at 11:37:03AM -0600, Cal Evans wrote: Your structure is flawed for this kind of query. Games should be: Games --- gameID === teamID (FK to teams) dateTime (datetime) homeAwayFlag char(1) // either H or A --- This way you could use something like select g.gameid, g.teamID, g.homeAwayFlag, g.dateTime, h.teamid, h.name from Games g left join Teams t on g.teamID = h.teamID order by dateTime, homeAwayFlag As it is (IMHO) your only choice is to use 2 SELECT statements and a UNION (Ugly solution) select g.gameid, g.teamID, g.homeID, null as awayID, g.dateTime, h.teamid, h.name from Games g left join Teams t on g.teamID = h.homeID UNION select g.gameid, g.teamID, null as homeID, g.awayID, g.dateTime, h.teamid, h.name from Games g left join Teams t on g.teamID = h.awayID order by dateTime I've not tested this but it should point you in the right direction. (But again, changing your structure is a much better solution.) HTH, =C= * * Cal Evans * The Virtual CIO * http://www.calevans.com * -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, December 30, 2002 11:11 AM To: [EMAIL PROTECTED] Subject: query requiring two results from one table? Hello, This is my first post to the list, so if I am asking in the wrong place, I apologize. I've got some trouble putting together a query with the following tables Games: Teams: gameid teamid homeid name awayid datetime i want to get all games within a certain timeframe, but also retrieve the team names for both the homeid and awayid (these are both links to the teams.teamid field). Not sure how to get two results from the same table in one query. Can anybody point me in the right direction. thanks gf - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED]Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: user/root
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Rick -- ...and then Richard Nagle said... % ... % [MacG4a:/usr] rnagle% mysql -u root -p % Enter password: % Welcome to the MySQL monitor. Commands end with ; or \g. ... % % Well it would appear that I finally have a connection Yay! :-) % % q. since I am root, do I still need to GRANT a database to myself? % or just a to a new user. aka: bob@localhost I (and some others) strongly advise not using the root account for your general work but instead creating less-powerful accounts to minimize the probability of torching yourself with a typo. You might, for a database called music, create a musicroot account that has full privileges for that database and a musicrick account that has normal privileges for that database; that way you don't need to worry about musicrick running around in your movies database and you needn't worry about musicroot accidentally deleting your recipes database. If you do everything as root, you not only won't be practiced handling DB privileges to better know what you want to give someone on a database that actually matters but you're also walking around with a loaded and cocked gun with the safety off and your finger on the trigger. Don't stumble :-) % % TKS % Rick HTH HAND Happy New Year mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+FHI8Gb7uCXufRwARAkBmAJ4j2z2u42cAzi0Zl25xRciz/zYW1QCfXzmt lmiCMvU+KwbNJkKDiNUPDYE= =mskg -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
Peculiar Problem
Placed At : MAATDLN Govind Raghuram@SATYAM 01/02/2003 12:23 PM Hi, I am trying to do an update query - update bb_activeamtbalance set ui_orgbalance = +orgbalance+,ui_remainingbalance =+rembalance+,ui_usedcurrently=+usedbal+,ui_upddatetime=now(),ui_timeusedcurrently =+timeused+,ui_currentprodcode='+product+',ui_expirydate='+exptime+' where ui_userid='+userid+' I find this query in the slow query list. This query succeeds once in 3 times and when it hangs...I find that if I do a flush tables then the query succeeds again for some number of times and then the problem reoccurs. I am trying to figure what could be the cause...can someone help me with this. I am invoking this query through a java program using org.gjt.mm.mysql.Driver. Raghu - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
user updates trace
hi all, anyone knows how to get the history of updates of a user? ... i mean ... in my database i have a lot of users with different privileges. what i need is to reach all the insert, update and delete queries executed by one user. is it possible? i check the bin logs but they seems not to trace the user that execute the query. is it true? thanks in advance. natale babbo __ Yahoo! Cellulari: scarica i loghi e le suonerie per le tue feste! http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Connect Error
Hi, I'm a newbie with MySQL and get the following error: bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I get this whenever I attempt to connect to MySQL. I am running Slackware 8.1, MySQL Max 3.23.54b. I have set the MySQL root password. What am I missing? TIA, John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Year Lists
Thanks for the email... Brilliant idea, but it does not give 0 for rows without a project for a year. It gives 1 for these rows. As a test idea, I removed the group by and count, and instead of count outputted the start and end year. What that gave me was say for 1953 where there was 3 projects, 3 lines with the start and end year for those projects. But for a year without a project gives start and end year as null. e.g. (not true examle) yearstartyearendyear 1901NULLNULL 1953 19521954 1953 19511956 195319501980 I suppose I need to do a where to remove null values, but I cant work out where it goes! Thanks, ;-) Steve XX Sounds to me like you'll need to join for that -- and list all the years you are interested in in another table. Try this? SELECT y.Year, count(*) FROM Year as y LEFT JOIN projects ON project.startyear=y.Year AND project.endyear=y.Year GROUP BY y.Year; This will give you a count of 0 for any years without a project (Almost 100% certain =] ). But don't blame me if the query is grossly inefficient! Nick Elliott - Original Message - From: Steve Vernon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 31, 2002 10:44 AM Subject: Re: Year Lists Martin, Thanks for the reply. Good plan but at the moment my query is like (had to alter it slightly as it was in PHP and multiple lines, so dont take it as working). SELECT projects.name, project.endyear, project.startyear FROM projects WHERE projects.startyear = '(INPUT THE YEAR HERE)(projects.leaveyear = '(YEAR HERE AS WELL)' || projects.leaveyear = '' ) LIMIT 5000 What you suggest basically will give a count on start year (or end year if altered), which I have implemented and working for ended year. Say a project started in 1920 and another in 1921 and they both finish in 1925. I would expect to get this: 19201 Project 19212 Projects 19222 Projects 19232 Projects 19242 Projects 19252 Projects 19260 Projects (or no line at all ideally). up to 2003 Ideally if a year does not have any projects it would not be listed. Any more help would be great, or I could be wrong and you could have the answer! Steve On Tue, 2002-12-31 at 14:53, Steve Vernon wrote: Hiya, I have a database about projects in a company, they all have a start year and end year. If the projects have not ended then they get a end year of . I have made a SQL command, given a year, works out with projects are running in that year. The company I am doing this for, wants basically a drop down box which says (1950- 8 Projects) and such like. Now with the current command I have it would mean 92or so SQL commands as the company has records back to 1910. Is there a way to do this in one command? I have searched all the mannual and I can work out something similair to a for loop in SQL. Would variables help? Hi Steve, You want to use select group by, something like: select start_year, count(*) from projects group by start_year; == 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: host.frm
I had someything similar It was all down to permissions...make sure that the permissions on the sql dbfolder allow the sql demon access. And you have run the install_db script to create it in the first place Wayne -Original Message- From: Jason Steig [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 04:44 To: [EMAIL PROTECTED] Subject: host.frm ./myqld: Can't find file : './mysql/host.frm' (errno:13) does anyone know how to solve this problem? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FAQ hosting site
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Stefan, et al -- ...and then Stefan Hinz, iConnect (Berlin) said... % % David, % % Sure; it's the least I can do. Look for mysql.justpickone.org to be % in % the DNS tables by tomorrow. By then the % [EMAIL PROTECTED] % mailing list will be ready for subscriptions, too. % % Fine. http://mysql.justpickone.org/ works :) Good! % % Now, what do we need to do to be able to update this FAQ? I can't % create % ssh accounts for everyone, but we might arrange ftp % % Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I % could contribute some code. I should have expected that this would be database-driven :-) I'd love code; thanks. % % My suggestions (database design): ... Those sound like a good start. % % I send this to the list, because % % a) maybe someone has written exactly what we want, or can give a URL to % where to find it, Yeah. I have yet to check out some of the other suggestions, but it does look like someone has carved this wheel before. % % b) maybe someone has better ideas or comments on this. % % By then the [EMAIL PROTECTED] % mailing list will be ready for subscriptions, too. % % Great. We should discuss everything else via this list, then. Yep. It's ready for subscriptions, so send a note to [EMAIL PROTECTED] to sign up. Other than these last responses, I'm going to take this out of the main mysql list. But even lurkers are welcome on the FAQ list :-) % % Regards, % -- % Stefan Hinz [EMAIL PROTECTED] Thanks HAND HNY :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+FBi3Gb7uCXufRwARAgZSAJ9JrmYWxPCwK1R7scFX5nu0uTapCgCglcYm UVrHwT7JmydmkyM6KQWfL8E= =BEQr -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: user/root
On 1/1/03 5:46 PM, Richard Nagle [EMAIL PROTECTED] wrote: Well it would appear that I finally have a connection Congrats. q. since I am root, do I still need to GRANT a database to myself? or just a to a new user. aka: bob@localhost If you are the only person using the computer that the mysql server runs on then theoretically you don't need to create any other user you don't even need a password for root then. But it is generally not a good thing to do things as root user if you don't have to (and you don't for most of the time) in Unix and in Mysql. Thus I strongly recommend that you do your database tutorials as a non root user for example as bob@localhost as you suggested. Lets say the database in your tutorial is called 'tutorialdb' you would do the following: shell mysql -u root -p password: mysql CREATE DATABASE tutorialdb; mysql GRANT ALL ON tutorialdb.* to bob@localhost; mysq quit; This would give you (well bob@localhost) all priviliges (except GRANT) on the tutorialdb and all tables in this database when you are using the socket connection i.e. You are logged in and call mysql on the machine that runs the mysql server (mysqld). shell mysql -u bob mysql use tutorialdb; Or shell mysql -u bob -D tutorialdb As you see bob can login without a password, which maybe what you want. If not you can either set a password now or change the GRANT command that you used in the first place to (replace pass with the password you like - the quotes are part of the command syntax: mysql GRANT ALL ON tutorialdb.* to bob@localhost IDENTIFIED BY 'pass'; HTH/h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Using files stored as blob
If you can give more info about your development environment and explain a little what you want to do, some of us may help. Tim Best [EMAIL PROTECTED] wrote: OK I got files to upload to my MySQL server but now how do I retreive them for distribution by email for instance. When I do a query the filename looks something like: /var/tmp//phptkYxkV I'm not sure where that is but I need to retrieve that file and distribute it... Any suggestions would be greatly appreciated... /T - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php __ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie - Where do I look for answers?
I am a complete newbie to mysql and Linux. I completed the installation of the 4.0 version of MySQL/InnoDB, and now I am stuck with permission problems: Logging in with empty username/password lets me look at the initial state of the db, but creating new users or new tables through any front end fails with permission problem messages. SQL (MS-SQL) is second nature to me, but this is not. - Where do I find an EASY, straight forward manual about MySQL administration on Linux - As the root user, how (and where) do I create new MySQL users, set permissions correctly? I would be very greatful for any help Dietrich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_use_result
Greetings... When I am using mysql_use_result API to retrieve results, I am always getting 0 value for the max_length member of MYSQL_FIELD structure which is returned by mysql_fetch_fields. But when I am using mysql_store_result, max_length has correct value. Is this normal ? Is there any way to know the max_length when using mysql_use_result. Thanks in advance Insane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: host.frm
You could probbly run the mysql_install_db this might help. There is something on the mysql.com site that says how to deal with this. - Original Message - From: Jason Steig [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 11:43 PM Subject: host.frm ./myqld: Can't find file : './mysql/host.frm' (errno:13) does anyone know how to solve this problem? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Desperate - failed: Lost connection to MySQL server during query
Thanks for the help John, I really don't know all the specifics of the hardware setup as it is all out at our ISP, I know its a rack mounted P4 and its going into a Cisco switch but that's about it. We have made some progress though and as strange as it sounds its really looking like its something with RH 8, in short we downgraded perl 5.8 to 5.6.1 with no results, we then went from Apache 2 down to 1.3 with no results, then that night backup exec came through and the machine spiked to 100% - noticed it by luck of being on the machine at the same time, this pretty much took Apache, Perl and my code out of the question. Did up a new machine (same specs), put RH 7.3 on it, copied everything over and made it live.. Right before we switched over to the new machine we stopped throttling the server (it was the only way to stop those errors) and instantly those connection failures started happening like crazy. As soon as we made the switch, they all went away, load was cut in half and CPU idle went up around 30 to 40% and things were just screaming, 110% improvement in all areas. So you'd think everything was wonderful now, wouldn't you?.. Well check this out.. As soon as the new web server was brought up I started getting (and still get) tons of Aborted connection ... (Got an error reading communication packets) - and mySql has run without a flaw since day one, also the scripts and DBI and everything was exactly the same on the new web server from the old web server (mysql would have no knowledge of the switch). I can say I'm about 98% sure that everything mySql shows for this problem at: http://www.mysql.com/doc/en/Communication_errors.html Isn't a issue. As RH 8 is also running on the dedicated mySql machine, I'm starting to believe its the root of all my problems. Its been a wild week!! Thanks -Chris -Original Message- From: John P [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 1:45 PM To: Chris Faust; [EMAIL PROTECTED] Subject: Re: Desperate - failed: Lost connection to MySQL server during query If you are running close to the same setup with no problems then I feel a little better about it not being a issue of pure traffic. Yes, we operate in a very similar way to you. (BTW, we have had very good results with a PHP based cache facility that simply stores the db driven pages over a selectable time period; good if your pages don't change that much! Capacity increased 4000% or so; would imagine something similar exists for perl) I don't think the link between the machines is a issue, both machines are dedicated and at the same location, I've tried using both the external and internal (10.0.x.x) IP to connect to the DB with the same results and in all cases both machines have had entries in their hosts file for one another. As for simultaneous connections, that is something that I still need to go through the logs and come up with a real number for those time frames.. I don't know anyway to see a real number of actual users using Apache via the command line (is there such a thing?). I've always done ps -ef | grep httpd | wc -l a few times which shows the processes, you can get a good idea of whether the site is busy or not. I don't know how to actually find the exact number of users, I suppose netstat ? One thing I wonder that I forgot to ask - does using IP address as the host for a user in mySql matter? Meaning before DNS switched over I wanted to get everything up and running so I created all the mysql user accounts based on the IP address of the web server (and not name). I would think if this were a issue at all I would be getting denied messages and it wouldn't work 100% of the time, but I thought I would throw it out there. I'd do everything by IP, especially for the internal stuff. It might be worth trying a dedicated cable+two separate network cards in each server to handle MySQL traffic. Just a thought, but could packets be getting lost between the two servers (network overloaded or out of ports on eth0 or ..?) Post your exact network setup (machines, switches/hubs etc) and that might give some more clues? Good luck John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Year Lists
At 13:53 + 1/2/03, Steve Vernon wrote: Thanks for the email... Brilliant idea, but it does not give 0 for rows without a project for a year. It gives 1 for these rows. COUNT(*) counts rows, not values. Try using COUNT(projects.startYear) instead, which will count only non-NULL values. (The LEFT JOIN returns a row with all projects columns set to NULL for the case where there is no project for a year.) As a test idea, I removed the group by and count, and instead of count outputted the start and end year. What that gave me was say for 1953 where there was 3 projects, 3 lines with the start and end year for those projects. But for a year without a project gives start and end year as null. e.g. (not true examle) yearstartyearendyear 1901NULLNULL 1953 19521954 1953 19511956 195319501980 I suppose I need to do a where to remove null values, but I cant work out where it goes! Thanks, ;-) Steve XX Sounds to me like you'll need to join for that -- and list all the years you are interested in in another table. Try this? SELECT y.Year, count(*) FROM Year as y LEFT JOIN projects ON project.startyear=y.Year AND project.endyear=y.Year GROUP BY y.Year; This will give you a count of 0 for any years without a project (Almost 100% certain =] ). But don't blame me if the query is grossly inefficient! Nick Elliott - Original Message - From: Steve Vernon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 31, 2002 10:44 AM Subject: Re: Year Lists Martin, Thanks for the reply. Good plan but at the moment my query is like (had to alter it slightly as it was in PHP and multiple lines, so dont take it as working). SELECT projects.name, project.endyear, project.startyear FROM projects WHERE projects.startyear = '(INPUT THE YEAR HERE)(projects.leaveyear = '(YEAR HERE AS WELL)' || projects.leaveyear = '' ) LIMIT 5000 What you suggest basically will give a count on start year (or end year if altered), which I have implemented and working for ended year. Say a project started in 1920 and another in 1921 and they both finish in 1925. I would expect to get this: 19201 Project 19212 Projects 19222 Projects 19232 Projects 19242 Projects 19252 Projects 19260 Projects (or no line at all ideally). up to 2003 Ideally if a year does not have any projects it would not be listed. Any more help would be great, or I could be wrong and you could have the answer! Steve On Tue, 2002-12-31 at 14:53, Steve Vernon wrote: Hiya, I have a database about projects in a company, they all have a start year and end year. If the projects have not ended then they get a end year of . I have made a SQL command, given a year, works out with projects are running in that year. The company I am doing this for, wants basically a drop down box which says (1950- 8 Projects) and such like. Now with the current command I have it would mean 92or so SQL commands as the company has records back to 1910. Is there a way to do this in one command? I have searched all the mannual and I can work out something similair to a for loop in SQL. Would variables help? Hi Steve, You want to use select group by, something like: select start_year, count(*) from projects group by start_year; == 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
subselects
Hi All I know that this maybe a repeated question here but I just need to know the updates. I am asking about the new feature of subselects which should be implemented in version 4.1 (thats what i know), when this version is expected to the light ? For me this single feature (subselect) will enable our company to transfer many applications from Oracle to MySQL and I think the same holds for many people out there so we are really eager to see it working. Thanks Ahmed Farouk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Connect Error
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Jonh, You're probably forget the -p param for mysqladmin ask you your root password. merlin Escreveu John Wilkerson em Thursday 02 January 2003 04:11 am: Hi, I'm a newbie with MySQL and get the following error: bin/mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' I get this whenever I attempt to connect to MySQL. I am running Slackware 8.1, MySQL Max 3.23.54b. I have set the MySQL root password. What am I missing? TIA, John - -- Merlin, the Mage Que os vosso(s) Deus(es) vos abençoe(m) E a vida vos ame e proteja. -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE+FIzgKOMrqDFTeBARApO8AKCszGgvPbe6PoeU1oXtCfRGSm+BcgCggPBw ZpvYwUf3XcsWJgPRflwoG5M= =klHF -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: Year Lists
Actually, had I read your (second?) email properly, I would've suggested something slightly different. (I guess, to get a 0, rather than count(*) it should've been a count(startyear)). Instead of a LEFT JOIN, which will create NULL rows for any years that don't have a project, do a straight JOIN using just a where clause. SELECT y.Year, count(*) FROM Year as y , projects as p WHERE p.startyear=y.Year AND p.endyear=y.Year GROUP BY y.Year; A simple change, but that should mean it will only list years that have projects falling across them. Try that? Good luck =] Nick Elliott - Original Message - From: Steve Vernon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 02, 2003 8:53 AM Subject: Re: Year Lists Thanks for the email... Brilliant idea, but it does not give 0 for rows without a project for a year. It gives 1 for these rows. As a test idea, I removed the group by and count, and instead of count outputted the start and end year. What that gave me was say for 1953 where there was 3 projects, 3 lines with the start and end year for those projects. But for a year without a project gives start and end year as null. e.g. (not true examle) yearstartyearendyear 1901NULLNULL 1953 19521954 1953 19511956 195319501980 I suppose I need to do a where to remove null values, but I cant work out where it goes! Thanks, ;-) Steve XX Sounds to me like you'll need to join for that -- and list all the years you are interested in in another table. Try this? SELECT y.Year, count(*) FROM Year as y LEFT JOIN projects ON project.startyear=y.Year AND project.endyear=y.Year GROUP BY y.Year; This will give you a count of 0 for any years without a project (Almost 100% certain =] ). But don't blame me if the query is grossly inefficient! Nick Elliott - Original Message - From: Steve Vernon [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 31, 2002 10:44 AM Subject: Re: Year Lists Martin, Thanks for the reply. Good plan but at the moment my query is like (had to alter it slightly as it was in PHP and multiple lines, so dont take it as working). SELECT projects.name, project.endyear, project.startyear FROM projects WHERE projects.startyear = '(INPUT THE YEAR HERE)(projects.leaveyear = '(YEAR HERE AS WELL)' || projects.leaveyear = '' ) LIMIT 5000 What you suggest basically will give a count on start year (or end year if altered), which I have implemented and working for ended year. Say a project started in 1920 and another in 1921 and they both finish in 1925. I would expect to get this: 19201 Project 19212 Projects 19222 Projects 19232 Projects 19242 Projects 19252 Projects 19260 Projects (or no line at all ideally). up to 2003 Ideally if a year does not have any projects it would not be listed. Any more help would be great, or I could be wrong and you could have the answer! Steve On Tue, 2002-12-31 at 14:53, Steve Vernon wrote: Hiya, I have a database about projects in a company, they all have a start year and end year. If the projects have not ended then they get a end year of . I have made a SQL command, given a year, works out with projects are running in that year. The company I am doing this for, wants basically a drop down box which says (1950- 8 Projects) and such like. Now with the current command I have it would mean 92or so SQL commands as the company has records back to 1910. Is there a way to do this in one command? I have searched all the mannual and I can work out something similair to a for loop in SQL. Would variables help? Hi Steve, You want to use select group by, something like: select start_year, count(*) from projects group by start_year; == 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe,
Re: RE: FAQ hosting site (was Re: An Idea) (fwd)
sql,query,queries,smallint On Thu, 2 Jan 2003, Peter Lovatt wrote: I was looking for a reasonably heavyweight php application, there are some lightweight ones and some half finished ones and some perl ones, but none that were what I was looking for. Any suggestions would be appreciated, no point in reinventing the wheel. I prefer FAQ-O-Matic. http://faqomatic.sourceforge.net/faq.pl Good Luck, -- Boyd Gerber [EMAIL PROTECTED] ZENEZ1042 East Fort Union #135, Midvale Utah 84047 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
test
Since just before christmas I have not gotten any e-mails from the mysql-mailing list... so I send this to test my access, can anyone see it? Please reply in private so that I know if it works or not... /Christian Andersson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ARGH! :) [OT]
Original Message Received: (qmail 24061 invoked from network); 2 Jan 2003 20:14:30 - Received: from unknown (HELO web.mysql.com) ([EMAIL PROTECTED]) by mail.fibrespeed.net with SMTP; 2 Jan 2003 20:14:30 - Received: (from lists@localhost) by web.mysql.com (8.11.6/8.11.6) id h02JEGm29551; Thu, 2 Jan 2003 20:14:16 +0100 Date: Thu, 2 Jan 2003 20:14:16 +0100 Message-Id: [EMAIL PROTECTED] From: [EMAIL PROTECTED] To: Michael T. Babcock [EMAIL PROTECTED] Subject: Re: Re: Using files stored as blob [OT] Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query,queries,smallint If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Tim Best wrote: /var/tmp//phptkYxkV I'm not sure where that is but I need to retrieve that file and distribute it... I'm assuming you're not familiar with *nix systems (as opposed to Windows). This name is the full name of the file with the directories (similar to, for example c:\windows\mscdex.exe). Just open it, as you would open any file (http://php.net/fopen comes to mind) and you should be fine. Don't forget to unlink it when you're done. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock -- 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
db crash
Hi all ... our db server is attackt by a root kit, from our old db server the only thing we have are the log files knows someone a little script or app to filter all the querys out of the standard log format of the mysld.log file ..?!? thx a lot 4 all kind of support best regards andreas PS: Some snapshots of the log format: 349586 Connect root@localhost on 349586 Init DB adspot 349586 Query insert into event (even_sess_id, even_camp_code, even_timestamp, even_text) values (812102, 'ANNA1',sysdate(), 'mouseMove event occured') 349586 Quit select, update etc. also needed ... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FAQ hosting site [FAQTS.COM]
David T-G wrote: I suppose they might. Never heard of 'em... Can I strongly suggest there be a link from the MySQL documentation page to: http://www.faqts.com/knowledge_base/index.phtml/fid/52 It is the MySQL section of FAQTS.com which, IMHO, is the best online FAQ site. It has very good QA's and does a good job of rating them as well. You'll notice that many of the subjects are practically taken straight off this list. Posting an answer is relatively simple, and all answer posters have their information tracked so that all the answers they've given are available. Take a look (please) and I'm in NO way affiliated with this site. For example, How can I make MySQL user friendly, what program can I use as an interface at http://www.faqts.com/knowledge_base/view.phtml/aid/6588/fid/52 is answered with: If you are looking for a web-based administration program myPHPAdmin is great. You (or your ISP) must be have PHP installed on the server for this application to run. If you are looking for a language to create your own application interface to a mySQL database, PHP is the best choice. Zachary Kent - You can also use MS Access as a front-end. Make your SQL database, install the MyODBC drivers, and link to the tables from Access. From there, it's easy to program Access to make update screens, etc. Chuck -- 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: host.frm
Again, this specific problem is mentioned in the reference guide. From that and my experiences, we're looking at a permissions issue. Hannes needs to look at the permissions on his data and logging directories to make sure that they are set to the default mysql:mysql. -Original Message- From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 10:45 AM To: Jason Steig; MySQL Mailinglist Subject: Re: host.frm On 1/1/03 8:43 PM, Jason Steig [EMAIL PROTECTED] wrote: ./myqld: Can't find file : './mysql/host.frm' (errno:13) does anyone know how to solve this problem? This file is part of the host table in your mysql database 'mysql'. Did you by any chance copy the mysql data directory or parts of it or do any actions that would change permissions or even delete file in this directory (possibly /usr/local/mysql-version/data) ? In the worst case you need to back up your data directory and have to run the install_db script again after you have set the root password to '' (nothing). HTH/h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FAQ hosting site (was Re: An Idea)
Yes, you need to specify the IP address that you plan on using for this process instead of the computer name. If you use Windows, chances are your using MYODBC or some other similar driver. Case #1: You setup a DSN in the ODBC area of the OS Case #2 You setup a DSN-less connection to your db. Case #2 has actually worked much faster for me. You can just put the IP in your connection code and off you go. Either way, you need to do this because the OS cannot resolve how you want it done. Just to make sure it is two NIC's that is causing your problem, disable one in the IP configuration area and give it a try. If you still cannot connect to your db, then something else may also be wrong. Bruce - Original Message - From: Peter Lovatt [EMAIL PROTECTED] To: mnbv [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 6:25 PM Subject: RE: FAQ hosting site (was Re: An Idea) Hi Is '111' the IP it is trying to connect on? If so it is an invalid IP. If the IP is valid how are you trying to connect? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: mnbv [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 00:23 To: Peter Lovatt; Stefan Hinz, iConnect (Berlin); David T-G; mysql users Subject: RE: FAQ hosting site (was Re: An Idea) I really need your help, I installed MySQL and I can connect to it through localhost but when trying to access it from outside I get: ERROR 2003: Can't connect to MySQL server on 'IP' (111) Any suggestions? Someone suggested that the problem is because the server has 2 nics (2 ips set up). Does anyone know a solution for this? --- Peter Lovatt [EMAIL PROTECTED] wrote: Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a
Re: FAQ hosting site (was Re: An Idea)
Why not try Tek-Tips? Maybe they will sponsor something for free. They may have everything you need. Just a thought. [EMAIL PROTECTED] [EMAIL PROTECTED] Bruce - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Peter Lovatt [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; David T-G [EMAIL PROTECTED]; mysql users [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 6:36 PM Subject: Re: FAQ hosting site (was Re: An Idea) On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote: I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) Really? That's a wheel I've seen re-invented many times. I know there's stuff out there. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 17 days, processed 617,666,871 queries (401/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Admin/Client GUI - Win32 and Linux
I'm running MySQL onto a Windows Advanced Server. I´m looking for a good and free admin/client GUI for Win32 and Linux. Can anyone guide me or share with me about good and free admin/client GUI? Thanks. Janine. = Janine __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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: host.frm
Dave, Please trace the author (Jason) of the problem correctly, but I am sure you just tried to be helpful - no harm done. :-)/h On 1/2/03 11:37 AM, Christensen, Dave [EMAIL PROTECTED] wrote: Again, this specific problem is mentioned in the reference guide. From that and my experiences, we're looking at a permissions issue. Hannes needs to look at the permissions on his data and logging directories to make sure that they are set to the default mysql:mysql. -Original Message- From: R. Hannes Niedner [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 10:45 AM To: Jason Steig; MySQL Mailinglist Subject: Re: host.frm On 1/1/03 8:43 PM, Jason Steig [EMAIL PROTECTED] wrote: ./myqld: Can't find file : './mysql/host.frm' (errno:13) does anyone know how to solve this problem? This file is part of the host table in your mysql database 'mysql'. Did you by any chance copy the mysql data directory or parts of it or do any actions that would change permissions or even delete file in this directory (possibly /usr/local/mysql-version/data) ? In the worst case you need to back up your data directory and have to run the install_db script again after you have set the root password to '' (nothing). HTH/h - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Desperate - failed: Lost connection to MySQL server during query
Hi, You right.RH8 have a problem with glibc.All people from the list recommende to make a downgrade to version 2.x or download binary distribution from MySQL site which is compiled with the right version of glibc. Are and other ways to solve your problems but i think you need to a stable solution. Anyway if you start MySQL daemon with option --skip-name-resolve and the problem it's solved then you have only this 2 options. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Chris Faust [EMAIL PROTECTED] To: John P [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 02, 2003 6:54 AM Subject: RE: Desperate - failed: Lost connection to MySQL server during query Thanks for the help John, I really don't know all the specifics of the hardware setup as it is all out at our ISP, I know its a rack mounted P4 and its going into a Cisco switch but that's about it. We have made some progress though and as strange as it sounds its really looking like its something with RH 8, in short we downgraded perl 5.8 to 5.6.1 with no results, we then went from Apache 2 down to 1.3 with no results, then that night backup exec came through and the machine spiked to 100% - noticed it by luck of being on the machine at the same time, this pretty much took Apache, Perl and my code out of the question. Did up a new machine (same specs), put RH 7.3 on it, copied everything over and made it live.. Right before we switched over to the new machine we stopped throttling the server (it was the only way to stop those errors) and instantly those connection failures started happening like crazy. As soon as we made the switch, they all went away, load was cut in half and CPU idle went up around 30 to 40% and things were just screaming, 110% improvement in all areas. So you'd think everything was wonderful now, wouldn't you?.. Well check this out.. As soon as the new web server was brought up I started getting (and still get) tons of Aborted connection ... (Got an error reading communication packets) - and mySql has run without a flaw since day one, also the scripts and DBI and everything was exactly the same on the new web server from the old web server (mysql would have no knowledge of the switch). I can say I'm about 98% sure that everything mySql shows for this problem at: http://www.mysql.com/doc/en/Communication_errors.html Isn't a issue. As RH 8 is also running on the dedicated mySql machine, I'm starting to believe its the root of all my problems. Its been a wild week!! Thanks -Chris -Original Message- From: John P [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 28, 2002 1:45 PM To: Chris Faust; [EMAIL PROTECTED] Subject: Re: Desperate - failed: Lost connection to MySQL server during query If you are running close to the same setup with no problems then I feel a little better about it not being a issue of pure traffic. Yes, we operate in a very similar way to you. (BTW, we have had very good results with a PHP based cache facility that simply stores the db driven pages over a selectable time period; good if your pages don't change that much! Capacity increased 4000% or so; would imagine something similar exists for perl) I don't think the link between the machines is a issue, both machines are dedicated and at the same location, I've tried using both the external and internal (10.0.x.x) IP to connect to the DB with the same results and in all cases both machines have had entries in their hosts file for one another. As for simultaneous connections, that is something that I still need to go through the logs and come up with a real number for those time frames.. I don't know anyway to see a real number of actual users using Apache via the command line (is there such a thing?). I've always done ps -ef | grep httpd | wc -l a few times which shows the processes, you can get a good idea of whether the site is busy or not. I don't know how to actually find the exact number of users, I suppose netstat ? One thing I wonder that I forgot to ask - does using IP address as the host for a user in mySql matter? Meaning before DNS switched over I wanted to get everything up and running so I created all the mysql user accounts based on the IP address of the web server (and not name). I would think if this were a issue at all I would be getting denied messages and it wouldn't work 100% of the time, but I thought I would throw it out there. I'd do everything by IP, especially for the internal stuff. It might be worth trying a dedicated cable+two separate network cards in each server to handle MySQL traffic. Just a thought, but could packets be getting lost between the two
Re: Newbie - Where do I look for answers?
Hi, www.google.com www.mysql.com (the manual) www.devshed.com --server side -- mysql devshed has some very good articles.. Not sure if you think those are easy. Have fun, --B. At 12:20 02-01-2003 -0600, DIetrich Speer wrote: I am a complete newbie to mysql and Linux. I completed the installation of the 4.0 version of MySQL/InnoDB, and now I am stuck with permission problems: Logging in with empty username/password lets me look at the initial state of the db, but creating new users or new tables through any front end fails with permission problem messages. SQL (MS-SQL) is second nature to me, but this is not. - Where do I find an EASY, straight forward manual about MySQL administration on Linux - As the root user, how (and where) do I create new MySQL users, set permissions correctly? I would be very greatful for any help Dietrich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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_use_result
Hi, Strange...you should be able to find the number of fields from resultset with mysql_num_fields.You use MYSQL_RES like parameter for mysql_fetch_fields ? How do you use mysql_fetch_fields? Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Ritesh Nadhani [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 02, 2003 8:34 PM Subject: mysql_use_result Greetings... When I am using mysql_use_result API to retrieve results, I am always getting 0 value for the max_length member of MYSQL_FIELD structure which is returned by mysql_fetch_fields. But when I am using mysql_store_result, max_length has correct value. Is this normal ? Is there any way to know the max_length when using mysql_use_result. Thanks in advance Insane - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Admin/Client GUI - Win32 and Linux
Nilza Lafayette wrote: I'm running MySQL onto a Windows Advanced Server. I´m looking for a good and free admin/client GUI for Win32 and Linux. Can anyone guide me or share with me about good and free admin/client GUI? There's at least one linked to from the mysql site and several mentionned on freshmeat.net. Searching MySQL admin windows on Google should get you quite a few responses as well. FWIW, this comes up a lot and phpMyAdmin gets mentionned almost as often. -- 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: Admin/Client GUI - Win32 and Linux
I like SQLyog http://www.webyog.com/ JFercan ** sql ** -Original Message- From: Nilza Lafayette [mailto:[EMAIL PROTECTED]] Sent: January 2, 2003 14:59 To: [EMAIL PROTECTED] Subject: Admin/Client GUI - Win32 and Linux I'm running MySQL onto a Windows Advanced Server. I4m looking for a good and free admin/client GUI for Win32 and Linux. Can anyone guide me or share with me about good and free admin/client GUI? Thanks. Janine. = Janine __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie - Where do I look for answers?
If you are familiar with MS-SQL and SQL in general then reading the manual should be no problem. Likewise, using a command line interface should be second nature. The MySQL manual is very complete. See chapter 4. In particular see 4.3, it very clearly explains how to setup the root password and how to setup new users. I am a complete newbie to mysql and Linux. I completed the installation of the 4.0 version of MySQL/InnoDB, and now I am stuck with permission problems: Logging in with empty username/password lets me look at the initial state of the db, but creating new users or new tables through any front end fails with permission problem messages. SQL (MS-SQL) is second nature to me, but this is not. - Where do I find an EASY, straight forward manual about MySQL administration on Linux - As the root user, how (and where) do I create new MySQL users, set permissions correctly? I would be very greatful for any help Dietrich - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Chris Jones, P. Eng. 14 Oneida Avenue Toronto, ON M5J 2E3 Tel. 416 203-7465 Fax. 416 203-8249 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: host.frm
Check to see the existence/permissions of this file in the data directory. Regards, Bhavin. - Original Message - From: Jason Steig [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 11:43 PM Subject: host.frm ./myqld: Can't find file : './mysql/host.frm' (errno:13) does anyone know how to solve this problem? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: subselects
How's your application written? i.e. J2EE? We've managed to put a layer in between the application and MySql that translates subselects on the fly into inner joins. This allowed us to quite painlessly move from MS SQL to MySql. EXISTS can be refactored into an inner join. NOT EXISTS can be refactored into an outer join with test for null on an outer joined column. Of course we'll rip this layer out when subselects are available but the tradeoff is we don't have to spend $10K per server for licensing, and even with this translation layer in, it's still faster than MS SQL. Greg From: Ahmed Farouk [EMAIL PROTECTED] Subject: subselects Date: 03/01/2003 6:01:00 To: [EMAIL PROTECTED] Hi All I know that this maybe a repeated question here but I just need to know the updates. I am asking about the new feature of subselects which should be implemented in version 4.1 (thats what i know), when this version is expected to the light ? For me this single feature (subselect) will enable our company to transfer many applications from Oracle to MySQL and I think the same holds for many people out there so we are really eager to see it working. Thanks Ahmed Farouk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php This message was sent through MyMail http://www.mymail.com.au - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: An Idea
R. Hannes Niedner wrote: Isn't that funny: if I have a mysql related question and search google I end up in the mysql online documentation in 90% of cases. I find if I just use the word 'mysql' in my query on Google, I get fairly appropriate results too. Not using the word mysql often gives me generic SQL responses regarding many products (often MS SQL Server, since they decided to use the lone word 'sql' in its name). -- 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: Newbie - Where do I look for answers?
B. van Ouwerkerk wrote: www.google.com www.mysql.com (the manual) www.devshed.com --server side -- mysql Also see http://www.webmonkey.com ... they had a MySQL + PHP tutorial on there at one point, specifically targetted to running an Apache + PHP + MySQL Linux box for Windows users. That's probably a good place to look as well (just skip to the MySQL bits). -- 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: SHOW INNODB STATUS output as SHOW STATUS?
Jean-Luc, - Original Message - From: Jean-Luc Fontaine [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, January 02, 2003 2:14 PM Subject: SHOW INNODB STATUS output as SHOW STATUS? Hello, I was wondering whether it would be possible, in a future release, to have SHOW INNODB STATUS give a real table output with 1 row per variable, as in the MySQL SHOW STATUS query? When that is done, I could quickly write and release a myinnodbstatus module for the moodss (http://jfontain.free.fr/mysql/) MySQL monitoring software. Is anybody interested in this feature? I think Sinisa suggested some of the InnoDB statistics could be included in SHOW STATUS. Of course not all, as SHOW INNODB STATUS often prints several kilobytes of data. But, what is the problem in scanning the text string returned by SHOW INNODB STATUS, and picking the information you want? I can promise that the output format of interesting stats will stay rather constant. Many thanks and Happy New Year to all! The same to you! Jean-Luc 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 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
filters
Ok, you guys are going to really hate me for this. I just signed up for this list and I am asking st00pid questions already. I am using Eudora and trying to filter these messages. I set it up to monitor the To: field, however this is not doing anything. I also noticed that there are no tags in the Subject lines of the messages sent to the list, that is what I usually use to filter messages. Does anyone have any tips for filtering these messages using Eudora? I just sub'd to 7 different MySQL lists and cannot get any of my filters to work right. and sorry for the WOB. - Aaron - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Newbie: MySQL + Java + web?
Hi all, I am new to MySQL and Java. A colleague has developed a solution that utilises MySQL, Java and HTML coding to produce a web based application and it is very cool. I have asked him how it all slots together and he has helped me a bit but I am still confused and he prob thinks I am too thick...so feel a little silly asking such basic things (?). I have done some research myself but all those around me tend to use PHP. Also, I have searched the Sun/Java site and read the documents on www.mysql.com but still can not see what I am missing. Anyhow - basically it appears he writes some Java code that contains a MySQL query (which I'm still not sure how is done - but I think I can nut it out) and then calls that piece of Java code from within the browser (via HTML) - it is this part that has me bamboozled. Can anyone throw any light on how this is done? Maybe just a URL? Tips? Some stuff I did find kept mention jsp as opposed to pure Java...but I could be confusing the issue. Thanks for reading. Regards Brynley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Foreign Key problem? in MySQL 4.0.7
Haisam, - Original Message - From: Haisam K. Ido [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, January 01, 2003 10:29 PM Subject: Foreign Key problem? in MySQL 4.0.7 I was able to create the gid table with no problem under mysql 4.0.7 CREATE TABLE gid ( id INT(11) NOT NULL auto_increment, groupname VARCHAR(128) NOT NULL, passwd VARCHAR(128) NULL, gidINT(11) NOT NULL, username VARCHAR(128) NULL, inserted_byVARCHAR(128) NOT NULL default 'root', epoch_inserted DATETIME NULL, modified_byVARCHAR(128) NOT NULL default 'root', epoch_modified DATETIME NULL, UNIQUE KEY keyword(id,groupname,gid), PRIMARY KEY (groupname, gid) ) TYPE=INNODB; but when I attempt to create the uid table below I get the following foreign key error. What am I doing wrong? the referenced column gid must appear as the FIRST column in some index. Above it appears as the second column. ERROR 1005: Can't create table './vhadmindb/uid.frm' (errno: 150) CREATE TABLE uid ( id INT(11) NOT NULL auto_increment, username VARCHAR(128) NOT NULL, passwd VARCHAR(128) NOT NULL, uidINT(11) NOT NULL, gidINT(11) NOT NULL, INDEX gid_ind (gid), FOREIGN KEY (gid) REFERENCES gid(gid), gecos VARCHAR(128) NULL, homedirVARCHAR(128) NOT NULL, shell VARCHAR(128) NOT NULL, inserted_byVARCHAR(128) NOT NULL default 'root', epoch_inserted DATETIME NULL, modified_byVARCHAR(128) NOT NULL default 'root', epoch_modified DATETIME NULL, UNIQUE KEY keyword(id, username, uid), PRIMARY KEY (username,uid) ) TYPE=INNODB; Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB 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: filters
At 16:06 -0600 1/2/03, Aaron Scribner wrote: x-flowedOk, you guys are going to really hate me for this. I just signed up for this list and I am asking st00pid questions already. I am using Eudora and trying to filter these messages. I set it up to monitor the To: field, however this is not doing anything. I also noticed that there are no tags in the Subject lines of the messages sent to the list, that is what I usually use to filter messages. Does anyone have any tips for filtering these messages using Eudora? I just sub'd to 7 different MySQL lists and cannot get any of my filters to work right. and sorry for the WOB. Click on the blah blah blah button of the message window for one of the list messages and you'll see all the headers, including the List-ID: header that's useful for filtering MySQL list messages. - Aaron 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: filters
On Thu, Jan 02, 2003 at 04:06:57PM -0600, Aaron Scribner wrote: I am using Eudora and trying to filter these messages. I set it up to monitor the To: field, however this is not doing anything. I also noticed that there are no tags in the Subject lines of the messages sent to the list, that is what I usually use to filter messages. FWIW, filtering both TO and CC should do what you want, but more importantly the messages (as with all ezmlm lists -- search Google for more info on ezmlm) contains the headers: Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm (http://www.ezmlm.org) List-ID: mysql.mysql.com If Eudora can't filter on arbitrary headers, complain to them frequently. To be more specific: filter for the List-ID to contain mysql. -- Michael T. Babcock CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database, etc) 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
Select Date Help
Hi all, I have a DATE column (CCYY-MM-DD), I would like to do a query like this: select * from table where date = '2003-01' What additional information do I need to provide for this query to work properly? Thanks in advance, Max - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Text ?
quick question since I not using a front application to talk with mysql and all would be handle for now threw the terminal window how does one enter in alot of text into a field? I seen alot of db, with single line entries, but none with multi line? eg: db notes: date:1-2-2003 note:Well today, Bob sign the contract for 300 Mac computers we need to get them delivered by the 15th of Feb. make sure there are not slip ups. As you can see from above this would be simple database to make the date field would be a single line but notes would be multi line, and could contain alot of data. Thanks Richard - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select Date Help
Hi Max, You must enter this: SELECT * FROM your_table WHERE date LIKE 2003-01-%; I think that you can more read about LIKE at http://www.mysql.org Best Regards, Boris Penchev - Original Message - From: Max Clark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 03, 2003 12:27 AM Subject: Select Date Help Hi all, I have a DATE column (CCYY-MM-DD), I would like to do a query like this: select * from table where date = '2003-01' What additional information do I need to provide for this query to work properly? Thanks in advance, Max - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select Date Help
On 2 Jan 2003, at 14:27, Max Clark wrote: I have a DATE column (CCYY-MM-DD), I would like to do a query like this: select * from table where date = '2003-01' What additional information do I need to provide for this query to work properly? You need to explain to us what result you expect. Since '2003-01' is not a complete date, your criterion will never be met. Maybe you want something like this? SELECT * FROM table_name WHERE date BETWEEN '2003-01-01' AND '2003-01-31'; -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Select Date Help
On Thu, 2 Jan 2003 14:27:25 -0800, Max Clark wrote: select * from table where date = '2003-01' aside from ...where (date='2003-01-01' and date = '2003-01-31') I think you could use ...where left(date,7) = '2003-01' http://www.mysql.com/doc/en/Date_calculations.html - Steve Yates - To know recursion, you must first know recursion. ~ Taglines by Taglinator - www.srtware.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
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-4.0.7-gamma-max (Official MySQL-max binary) C compiler:egcs-2.91.66 C++ compiler: egcs-2.91.66 Environment: System: Linux xchat.ws 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-DBIG_TABLES' CXX='g++' CXXFLAGS='-DBIG_TABLES' LDFLAGS='' ASFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Dec 28 20:32 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x2 root root 1282588 Sep 4 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 Sep 4 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 Sep 4 2001 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Dec 29 06:56 /usr/lib/libc-client.a - c-client.a Configure command: ./configure '--prefix=/usr/local/mysql' '--with-comment=Official MySQL-max binary' '--with-extra-charsets=complex' '--with-server-suffix=-max' '--enable-thread-safe-client' '--enable-local-infile' '--enable-assembler' '--disable-shared' '--with-raid' '--with-innodb' 'CFLAGS=-DBIG_TABLES' 'CXXFLAGS=-DBIG_TABLES' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: altering data structure
Il mar, 2002-12-31 alle 12:53, David T-G ha scritto: Well, yeah, but I want to try to write portable code; just because I like mysql doesn't meant that my customer (or some future contract employer) will... Hi, I am reading a bit late, but let me suggest you Metabase. Metabase does a very good job expecially dealing with db schemas. Metabase consists of a set of PHP classes to access and manage databases using an API that assures DBMS independence. http://freshmeat.net/projects/metabase/ I am using it for my free software project, so if you want more insight you're welcome. Here is my project XML Metabase schema: http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/obliquid/obliquid/common/configs/ Here is the same schema after an XSLT transform http://demo.obliquid.com/index.php?page=core_dbdoc This is the project home page by the way http://dev.obliquid.com/ bye, Stefano - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Select Date Help
I think you could also use: WHERE YEAR(date) = 2003 AND MONTH(date) = 01 -Original Message- From: Keith C. Ivey [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 02, 2003 5:09 PM To: [EMAIL PROTECTED] Cc: Max Clark Subject: Re: Select Date Help On 2 Jan 2003, at 14:27, Max Clark wrote: I have a DATE column (CCYY-MM-DD), I would like to do a query like this: select * from table where date = '2003-01' What additional information do I need to provide for this query to work properly? You need to explain to us what result you expect. Since '2003-01' is not a complete date, your criterion will never be met. Maybe you want something like this? SELECT * FROM table_name WHERE date BETWEEN '2003-01-01' AND '2003-01-31'; -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org Phone 202-667-6653 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: subselects
Thanks Greg for the hint but I also wanted to know when is MySQL version 4.1 to be expected to show up in binaries ? Ahmed - Original Message - From: [EMAIL PROTECTED] To: Ahmed Farouk [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, January 02, 2003 11:46 PM Subject: Re: subselects How's your application written? i.e. J2EE? We've managed to put a layer in between the application and MySql that translates subselects on the fly into inner joins. This allowed us to quite painlessly move from MS SQL to MySql. EXISTS can be refactored into an inner join. NOT EXISTS can be refactored into an outer join with test for null on an outer joined column. Of course we'll rip this layer out when subselects are available but the tradeoff is we don't have to spend $10K per server for licensing, and even with this translation layer in, it's still faster than MS SQL. Greg From: Ahmed Farouk [EMAIL PROTECTED] Subject: subselects Date: 03/01/2003 6:01:00 To: [EMAIL PROTECTED] Hi All I know that this maybe a repeated question here but I just need to know the updates. I am asking about the new feature of subselects which should be implemented in version 4.1 (thats what i know), when this version is expected to the light ? For me this single feature (subselect) will enable our company to transfer many applications from Oracle to MySQL and I think the same holds for many people out there so we are really eager to see it working. Thanks Ahmed Farouk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php This message was sent through MyMail http://www.mymail.com.au - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Foreign Key problem? in MySQL 4.0.7
Heikki: Do you mean the PRIMARY KEY order? Heikki Tuuri wrote: Haisam, - Original Message - From: Haisam K. Ido [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, January 01, 2003 10:29 PM Subject: Foreign Key problem? in MySQL 4.0.7 I was able to create the gid table with no problem under mysql 4.0.7 CREATE TABLE gid ( id INT(11) NOT NULL auto_increment, groupname VARCHAR(128) NOT NULL, passwd VARCHAR(128) NULL, gidINT(11) NOT NULL, username VARCHAR(128) NULL, inserted_byVARCHAR(128) NOT NULL default 'root', epoch_inserted DATETIME NULL, modified_byVARCHAR(128) NOT NULL default 'root', epoch_modified DATETIME NULL, UNIQUE KEY keyword(id,groupname,gid), PRIMARY KEY (groupname, gid) ) TYPE=INNODB; but when I attempt to create the uid table below I get the following foreign key error. What am I doing wrong? the referenced column gid must appear as the FIRST column in some index. Above it appears as the second column. ERROR 1005: Can't create table './vhadmindb/uid.frm' (errno: 150) CREATE TABLE uid ( id INT(11) NOT NULL auto_increment, username VARCHAR(128) NOT NULL, passwd VARCHAR(128) NOT NULL, uidINT(11) NOT NULL, gidINT(11) NOT NULL, INDEX gid_ind (gid), FOREIGN KEY (gid) REFERENCES gid(gid), gecos VARCHAR(128) NULL, homedirVARCHAR(128) NOT NULL, shell VARCHAR(128) NOT NULL, inserted_byVARCHAR(128) NOT NULL default 'root', epoch_inserted DATETIME NULL, modified_byVARCHAR(128) NOT NULL default 'root', epoch_modified DATETIME NULL, UNIQUE KEY keyword(id, username, uid), PRIMARY KEY (username,uid) ) TYPE=INNODB; Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: subselects
Ahmed, - Original Message - From: Ahmed Farouk [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, January 02, 2003 9:52 PM Subject: subselects Hi All I know that this maybe a repeated question here but I just need to know the updates. I am asking about the new feature of subselects which should be implemented in version 4.1 (thats what i know), when this version is expected to the light ? my previous guess a few months ago was around Dec 31st, 2002. Now I would guess around January 25th, 2003. For me this single feature (subselect) will enable our company to transfer many applications from Oracle to MySQL and I think the same holds for many people out there so we are really eager to see it working. You may also grab the public 4.1 source tree and compile it yourself. Jocelyn Fournier has done very valuable work by testing 4.1 in the past months. Thanks Ahmed Farouk Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, hot backup, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com 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
Can Expect scripts interact with mysql ?
Hi : I am trying to run Expect scripts to interact with mysql. So far I cannot get it to work here is the list of log I got.Does anyone know how to interact Expect scripts with mysql. What am I missing ? Thanks spawn mysql parent: waiting for sync byte parent: telling child to go ahead parent: now unsynchronized from child spawn: returns {2004} expect: does (spawn_id 5) match glob pattern *mysql*? no expect: timed out send: sending show databases;\r to { 5 } expect: does (spawn_id 5) match glob pattern *mysql*? no show databases; expect: does show databases;\r\n (spawn_id 5) match glob pattern *mysql*? no expect: timed out send: sending use menagerie;\r to { 5 } expect: does show databases;\r\n (spawn_id 5) match glob pattern *mysql*? no use menagerie; expect: does show databases;\r\nuse menagerie;\r\n (spawn_id 5) match glob pattern *mysql*? no expect: timed out send: sending show tables;\r to { 5 } expect: does show databases;\r\nuse menagerie;\r\n (spawn_id 5) match glob pattern *mysql*? no show tables; expect: does show databases;\r\nuse menagerie;\r\nshow tables;\r\n (spawn_id 5) match glob pattern *mysql*? no expect: timed out expect: timed out - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
replication only works for user x from host x, not host y
This is a repost of my previous message with a new and improved title that will hopefully catch more eyes and generate a response. :) We have two users, lets call them test and test2. When we log in as test from our front end web servers, we can execute queries and they replicate. When we log in as test from our back end db servers (say to run a cleanup script by hand), the queries replicate. When we log in as test2 from our back end db servers (as part of a periodic process), it replicates the queries. When we log in from our front end web servers as test2, the queries do not replicate. They are never added to the binary update log. Otherwise, everything appears to work fine; the master db server runs the queries and updates the tables appropriately. If necessary I can upload a copy of our grant table, but I'm hoping someone has a quick suggestion for me to try. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-PHP-Apache2
Hi, I think that your problem is because you do not enter your root MySQL password in your connection to it. $db = mysql_connect(localhost, root); Try with this: $db = mysql_connect(localhost, root, your_root_mysql_password) or die(Could not connect: . mysql_error()); Best Regards, Boris Penchev - Original Message - From: Tyler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 03, 2003 2:21 AM Subject: MySQL-PHP-Apache2 Hey.. I've got a wierd problem. I'm following the guide as per WebMonkey which has worked for me before, when I ran my servers on a Win32 box, but now I've got this problem (running linux)... I cant seem to do any editing to my DB from the webpage. I've used a couple different scripts, confirmed the right user/pass/sock but everytime I try the script, nothing happens in my DB, I cant delete, add, nor edit via the page. p.s. if anyone knows about the 'configure' command to most progs, before you comple, coudl you email me in private? Im trying to re-configure my PHP to have mysql support, however I'm not sure how to do it. I've already built it. could this be the problem? heres a script I used to enter data, to no avail: ?php if ($submit) { // process form $db = mysql_connect(localhost, root); mysql_select_db(mydb,$db); $sql = INSERT INTO employees (first,last,address,position) VALUES ('$first','$last','$address','$position'); $result = mysql_query($sql); echo Thank you! Information entered.\n; } else{ // display form ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Can Expect scripts interact with mysql ?
Paul Choy writes: Hi : I am trying to run Expect scripts to interact with mysql. So far I cannot get it to work here is the list of log I got.Does anyone know how to interact Ex pect scripts with mysql. What am I missing ? I've done it, but I don't spawn directly. I spawn a regular shell and then just send out the command to start it, eg # start up command line interface to mysql send /usr/local/mysql/bin/mysql -u root -p $dbname\r and go on from there. Works just fine. --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Part Time Programmer
Hi All! I'm looking for a part-time, work-from-home programmer. Must have knowledge in SCO Unix, Apache Server, MySql and PHP. I can be contacted directly by phone or email. [EMAIL PROTECTED] (713) 868-4348 Thanks, Gary - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How can we tell if we're maxing out MySQL/InnoDB capacity?
- Yesterday happened to be one of the busiest days for us ever on our MySQL backed web site. For the entire day MySQL was hit with up to 1200 queries/second, and many queries were being delayed at least 2-15 seconds. - I know how you feel. We were hitting 7700 queries/second today until the web server went into swap space and ruined everything. :( - What other statistics can I look at? - Besides 'iostat -k 1', I'd try 'vmstat 1'. - Our hardware is dual P3 1GHz, 2GB of RAM, and about 56GB of IDE RAID-1 backed disk (3ware escalade). - I love IDE RAID for a workstation (great for video and audio production), but for a database server I'd suggest SCSI RAID. What is the disk rotation speed? Disk seek is very important for databases. (Today, in fact, our main server will be getting a multichannel 10 disk SCSI 15K rpm striped RAID array.) But the real question is: are you CPU or disk bound? If it doesn't point really heavily at either, then it is both. :( -s - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SHOW INNODB STATUS output as SHOW STATUS?
On Fri, Jan 03, 2003 at 12:04:47AM +0200, Heikki Tuuri wrote: I think Sinisa suggested some of the InnoDB statistics could be included in SHOW STATUS. Of course not all, as SHOW INNODB STATUS often prints several kilobytes of data. Right... But, what is the problem in scanning the text string returned by SHOW INNODB STATUS, and picking the information you want? I can promise that the output format of interesting stats will stay rather constant. The problem is then everyone has to do it. And I can guarantee that it'll be done at least 10 times in each language (C, C++, Perl, PHP, Phython, etc...) It's just so easy to treat the results like a normal result set when you're using SHOW STATUS. But you already knew that. :-) Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 18 days, processed 648,525,199 queries (397/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: Trouble converting SQL from Access
Asendorf, John wrote: . SELECT Dealers.*, SQRT(POW((2285-Zips.North),2)+POW((4760-Zips.West),2)) AS Distance FROM Dealers INNER JOIN Zips ON Dealers.Zip = Zips.Zip ORDER BY POW((2285-Zips.North),2)+POW((4760-Zips.West)),2) Any suggestions to speed this guy up? yeah, do you really need ALL the columns returned? also, if you can, offload the calculations to PHP*, like the POW() function... grab the data from MYSQL and then use PHP to do the calcs...* -- Leo G. Divinagracia III [EMAIL PROTECTED] z - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can we tell if we're maxing out MySQL/InnoDB capacity?
On Thu, Jan 02, 2003 at 10:30:50AM -0500, Michael Bacarella wrote: Hi, Yesterday happened to be one of the busiest days for us ever on our MySQL backed web site. For the entire day MySQL was hit with up to 1200 queries/second, and many queries were being delayed at least 2-15 seconds. We were serving about 300% of our normal load. In my opinion MySQL scaled more gracefully than I have ever known in 4 years. It did not go into a downward spiral where once it went above a threshold all work stopped. Instead, everything became gradually slower, but still functioned albeit less quickly. Woohoo! :-) Right now I'm trying to figure out what bottlenecks the RDBMS was hitting so we could throw some hardware at the problem. I am not the kind of person to solve technical issues with hardware, but given that nothing else appears to be wrong and I've done every reasonable optimization possible, we have little choice. However, I can't figure out exactly why it was slow. Key efficiency was at 100%, and I *believe* the InnoDB buffer pool was large enough as the InnoDB monitor was reporting 1000 / 1000 cache hits. iostat showed the usual levels of disk I/O. What other statistics can I look at? We're using MySQL 3.23.54 Our hardware is dual P3 1GHz, 2GB of RAM, and about 56GB of IDE RAID-1 backed disk (3ware escalade). Did you happen to get a snapshot of vmstat output or even iostat during that time? What's your ratio of read queries to write queries? Are you InnoDB or MyISAM tables more active? Are you using InnoDB transactions or running in auto-commit mode? One thing you can do is split things up a bit if I/O is a bottleneck. I like to put the InnoDB logs on separate disks from the data files. That way the log flushes don't fight with other disk activity. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 18 days, processed 648,609,824 queries (397/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Source tar.gz files
Ok, I've got gunzip and tar, and every time I try (multiple versions) of your source .tar.gz file, I get: (when running 'tar -zxf mysql-3.23.54a.tar.gz') gzip: stdin: not in gzip format (when running 'gunzip mysql-3.23.54a.tar.gz') gunzip: mysql-3.23.54a.tar.gz: not in gzip format It seems NOTHING has worked for the last 2 days. I've tried the binaries, and then I dont have the top-level installation directory that all the docs refer to, and mysql isn't in /usr/local/. I really just want to be able to use MySQL.. -Tyler - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can we tell if we're maxing out MySQL/InnoDB capacity?
However, I can't figure out exactly why it was slow. Key efficiency was at 100%, and I *believe* the InnoDB buffer pool was large enough as the InnoDB monitor was reporting 1000 / 1000 cache hits. iostat showed the usual levels of disk I/O. What other statistics can I look at? We're using MySQL 3.23.54 Our hardware is dual P3 1GHz, 2GB of RAM, and about 56GB of IDE RAID-1 backed disk (3ware escalade). Did you happen to get a snapshot of vmstat output or even iostat during that time? System I/O for 12/28/2002 (last -really- busy day) [sar -b]: tps rtps wtps bread/s bwrtn/s 04:10:00 PM 55.35 16.74 38.62600.57 2694.96 04:20:00 PM 52.87 14.89 37.98537.00 2695.85 04:30:00 PM 55.15 16.60 38.55607.95 2778.64 04:40:00 PM 57.65 17.63 40.01638.78 2870.34 04:50:00 PM 56.72 15.86 40.86563.87 2857.35 05:00:00 PM 55.73 15.95 39.78553.06 2894.96 05:10:00 PM 57.10 16.33 40.77611.59 2906.15 05:20:00 PM 55.64 15.36 40.29523.64 2938.16 05:30:02 PM 60.25 18.78 41.47731.84 2960.37 05:40:00 PM 56.18 16.32 39.85590.66 2813.59 05:50:00 PM 55.78 16.83 38.95604.27 2824.34 06:00:00 PM 53.76 14.77 38.99542.79 2662.64 06:10:00 PM 58.05 17.03 41.01646.09 2838.64 06:20:00 PM 57.25 16.19 41.06572.56 2834.20 06:30:00 PM 53.62 14.81 38.81534.86 2778.94 System I/O for 01/01/2003 [sar -b]: tps rtps wtps bread/s bwrtn/s 04:10:00 PM 96.03 43.25 52.77 1765.41 3207.45 04:20:00 PM 98.96 47.33 51.64 1944.83 3161.48 04:30:01 PM 98.00 46.55 51.44 1948.59 3074.69 04:40:01 PM103.22 53.38 49.84 2209.09 2964.60 04:50:01 PM 94.04 44.08 49.95 1834.15 3012.90 05:00:00 PM 90.72 41.54 49.17 1715.27 2958.92 05:10:01 PM 97.97 44.78 53.19 1842.74 3220.25 05:20:00 PM 95.74 43.89 51.85 1805.33 3128.82 05:30:01 PM 96.94 44.40 52.54 1834.30 3222.38 05:40:01 PM101.25 48.13 53.11 1987.90 3202.16 05:50:01 PM104.58 51.20 53.37 2096.81 3202.57 06:00:00 PM 95.49 46.58 48.91 1896.46 2946.00 06:10:01 PM 99.50 46.59 52.91 1936.84 3197.70 06:20:00 PM 99.58 47.61 51.97 1968.49 3187.84 06:30:01 PM 98.74 46.84 51.90 1925.80 3250.88 Paging activity for 12/28/2002 (again, last -really- busy day) [sar -B]: pgpgin/s pgpgout/s activepg inadtypg inaclnpg inatarpg 04:10:00 PM300.29 1347.46 11103239512 552 1224 04:20:00 PM268.50 1347.92 10407240732 211 1101 04:30:00 PM303.98 1389.29 10702239171 1342 1105 04:40:00 PM319.39 1435.13 12474238818 586 1195 04:50:00 PM281.93 1428.68 10049240999 544 1161 05:00:00 PM276.53 1447.46 11147241006 657 1144 05:10:00 PM305.79 1453.06 11253240310 761 1215 05:20:00 PM261.82 1469.04 10307241834 530 1085 05:30:02 PM365.92 1480.18 11356242355 508 1136 05:40:00 PM295.33 1406.78 10772250702 607 1264 05:50:00 PM302.13 1412.14 11062251102 429 1068 06:00:00 PM271.39 1331.32 10937249908 1126 1080 06:10:00 PM323.04 1419.31 11555249645 618 1173 06:20:00 PM286.28 1417.08 10849249586 660 1291 06:30:00 PM267.43 1389.46 11457249658 483 1127 Paging activity for 01/01/2003 [sar -B]: pgpgin/s pgpgout/s activepg inadtypg inaclnpg inatarpg 04:10:00 PM882.70 1603.69 25444210845 1327 1889 04:20:00 PM972.41 1580.71 29793205545 624 2081 04:30:01 PM974.29 1537.32 29055204185 1275 1921 04:40:01 PM 1104.55 1482.27 27883207422 741 2073 04:50:01 PM917.08 1506.42 23908211670 939 1802 05:00:00 PM857.63 1479.42 25945209759 394 1925 05:10:01 PM921.37 1610.10 27099208588 661 2108 05:20:00 PM902.67 1564.38 26485210973 640 2044 05:30:01 PM917.15 1611.17 28326208356 715 2023 05:40:01 PM993.95 1601.05 28086211366 630 2008 05:50:01 PM 1048.41 1601.26 26842209184 536 1966 06:00:00 PM948.23 1472.99 25859210848 663 2004 06:10:01 PM968.42 1598.81 28974205873 1116 2042 06:20:00 PM984.24 1593.91 26470210644 636 1923 06:30:01 PM962.90 1625.41 28793
Re: Re: Trouble converting SQL from Access
we did something like this a while back. i remember we AND'ed what you basically have now with a number of less than and greater than expressions to box the circle that you describe in your statement. this boxing of the area merely provided a way to quickly limit the number of rows against which the sqrt(pow... stuff could limit down further into a circle. the , , expressions could use indexes whereas the sqrt/pow stuff can't. greg. From: Leo G. Divingracia III [EMAIL PROTECTED] Subject: Re: Trouble converting SQL from Access Date: 03/01/2003 13:08:57 To: Asendorf John [EMAIL PROTECTED] CC: [EMAIL PROTECTED], [EMAIL PROTECTED] Asendorf, John wrote: . SELECT Dealers.*, SQRT(POW((2285-Zips.North),2)+POW((4760-Zips.West),2)) AS Distance FROM Dealers INNER JOIN Zips ON Dealers.Zip = Zips.Zip ORDER BY POW((2285-Zips.North),2)+POW((4760-Zips.West)),2) Any suggestions to speed this guy up? yeah, do you really need ALL the columns returned? also, if you can, offload the calculations to PHP*, like the POW() function... grab the data from MYSQL and then use PHP to do the calcs...* -- Leo G. Divinagracia III [EMAIL PROTECTED] z - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php This message was sent through MyMail http://www.mymail.com.au - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: How can we tell if we're maxing out MySQL/InnoDB capacity?
- Yesterday happened to be one of the busiest days for us ever on our MySQL backed web site. For the entire day MySQL was hit with up to 1200 queries/second, and many queries were being delayed at least 2-15 seconds. - I know how you feel. We were hitting 7700 queries/second today until the web server went into swap space and ruined everything. :( - What other statistics can I look at? - Besides 'iostat -k 1', I'd try 'vmstat 1'. - Our hardware is dual P3 1GHz, 2GB of RAM, and about 56GB of IDE RAID-1 backed disk (3ware escalade). - I love IDE RAID for a workstation (great for video and audio production), but for a database server I'd suggest SCSI RAID. What is the disk rotation speed? Disk seek is very important for databases. (Today, in fact, our main server will be getting a multichannel 10 disk SCSI 15K rpm striped RAID array.) But the real question is: are you CPU or disk bound? If it doesn't point really heavily at either, then it is both. :( -s - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Admin/Client GUI - Win32 and Linux
Try SQLYog at http://www.webyog.com/sqlyog/download.html Very fast, compact and intuitive. Only for Win32 :-( Regards, Karam --- Nilza Lafayette [EMAIL PROTECTED] wrote: I'm running MySQL onto a Windows Advanced Server. I´m looking for a good and free admin/client GUI for Win32 and Linux. Can anyone guide me or share with me about good and free admin/client GUI? Thanks. Janine. = Janine __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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 __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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
strange behaviour
I run mysql on FreeBSD and it's been giving me a lot of problems. Sometimes the load shoots up and some applications cannot access mysql server anymore. During such instances, when I run top, I get something like this: last pid: 57669; load averages: 1.40, 1.52, 1.52 up 30+00:05:29 10:07:24 105 processes: 2 running, 101 sleeping, 1 stopped, 1 zombie CPU states: 10.1% user, 0.0% nice, 69.3% system, 0.2% interrupt, 20.4% idle Mem: 522M Active, 284M Inact, 146M Wired, 48M Cache, 112M Buf, 3916K Free Swap: 1374M Total, 1208K Used, 1373M Free PID USERNAME PRI NICE SIZERES STATE C TIME WCPUCPU COMMAND 12192 mysql 64 0 279M 13716K CPU0 1 93.1H 92.82% 92.82% mysqld I see mysqld taking so much processor time and then I run mytop and I get: MySQL on localhost (3.23.41-log) up 5+18:36:24 [10:04:04] Queries Total: 3,135,669 Avg/Sec: 6.28 Now/Sec: 9.00 Slow: 0 Threads Total: 23Active: 1 Cached: 7 Key Efficiency: 99.99% Bytes in: 285,244,678 Bytes out: 181,425,048 Id User Host DB TimeCmd Query or State -- -- --- -- 399603 root localhosttest 0 Query show full processlist 186085 wolvmail localhost virtualemai 6 Sleep 102684 wolrt2use localhost rt2 12 Sleep 399436 wolvmail localhost virtualemai 86 Sleep 104018 wolrt2use localhost rt2124 Sleep 103015 wolrt2use localhost rt2213 Sleep 103557 wolrt2use localhost rt2213 Sleep 109938 wolrt2use localhost rt2292 Sleep 102741 wolrt2use localhost rt2370 Sleep 103063 wolrt2use localhost rt2410 Sleep 102009 wolrt2use localhost rt2425 Sleep 102737 wolrt2use localhost rt2425 Sleep 103585 wolrt2use localhost rt2707 Sleep 330671 twig275us localhosttwig 55140 Sleep 340661 twig275us localhosttwig 55147 Sleep 340198 twig275us localhosttwig 55206 Sleep 179428 twig275us localhosttwig 55244 Sleep 179385 twig275us localhosttwig 55260 Sleep 349415 twig275us localhosttwig 55334 Sleep 179413 twig275us localhosttwig 55365 Sleep 326960 twig275us localhosttwig 55402 Sleep 330717 twig275us localhosttwig 55453 Sleep 340067 twig275us localhosttwig 0 Sleep 1 system us none 498984 Connec connecting to master My question is: Why connecting to master? Can someone explain this to me? I am lost for what could be causing me so much grief. I am not an MySQL expert. Thanks -Wash -- Odhiambo Washington [EMAIL PROTECTED] The box said 'Requires Wananchi Online Ltd. www.wananchi.com Windows 95, NT, or better,' Tel: +254 2 313985-9 +254 2 313922 so I installed FreeBSD. GSM: +254 72 743223 +254 733 744121 This sig is McQ! :-) Take my word
Question - SELECT
How do I correct this SQL code: SELECT lcopen.bank, SUM(lcopen.unit_price_us*lcopen.order_cbm) * 7.8 AS open, # SUM(lcreceive.amount_us) where lcreceive.due_date current_date AS receive, # # the above statement is not correct for the # additional condition # FROM lcopen, lcreceive AND lcopen.id=lcreceive.id GROUP BY lcopen.bank; _ Lonely Christmas(³¯«³¨³)¡A·ºå»P·(Twins)¡AµL¶¡¹D(¹q¼v)... ¦ÜIn¤â¾÷¹aÁn ³§A¹L¥V¤Ñ http://ringtone.yahoo.com.hk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL-PHP-Apache2
Hey.. I've got a wierd problem. I'm following the guide as per WebMonkey which has worked for me before, when I ran my servers on a Win32 box, but now I've got this problem (running linux)... I cant seem to do any editing to my DB from the webpage. I've used a couple different scripts, confirmed the right user/pass/sock but everytime I try the script, nothing happens in my DB, I cant delete, add, nor edit via the page. p.s. if anyone knows about the 'configure' command to most progs, before you comple, coudl you email me in private? Im trying to re-configure my PHP to have mysql support, however I'm not sure how to do it. I've already built it. could this be the problem? heres a script I used to enter data, to no avail: ?php if ($submit) { // process form $db = mysql_connect(localhost, root); mysql_select_db(mydb,$db); $sql = INSERT INTO employees (first,last,address,position) VALUES ('$first','$last','$address','$position'); $result = mysql_query($sql); echo Thank you! Information entered.\n; } else{ // display form ? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php