Fw: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message
-- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Venu Anuganti [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Redwood city, California USA ___/ www.mysql.com - Original Message - From: Luc Lalancette [EMAIL PROTECTED] To: Venu Anuganti [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 10:04 PM Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message Thanks again... It seems that I owe you one it worked. Luc - Original Message - From: Venu Anuganti [EMAIL PROTECTED] To: Luc Lalancette [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 10:54 PM Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message Hi Luc Here is the common syntax, that is used as the connection string through JDBC-ODBC Driver. Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url = jdbc:odbc:TestDSN; Coonection con = DriverManager.getConnection(url,username,password); Before connecting, make sure you intslled the ODBC Driver and configured the DSN 'TestDSN' created in the ODBC DSN Administartor. Based on your error below, it looks you have the valid DSN, but you didn't supply the UID and PWD in the connection string. Thank you Venu Anuganti - Original Message - From: Luc Lalancette [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 3:02 PM Subject: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message I am starting using mysql and I made a java SimpleQuery servlet that is suppose to retreive one row from the database. However, when I try to connect I get that message from the Subject. I know I'm suppose to pass the password but can't seem to find a way of doing it. I was wondering if the problem was with those two lines or if it was in the tdx mysql driver default configuration in the ODBC. Class c = Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); dbConn = DriverManager.getConnection(jdbc:odbc:TestDSN;); I would appreciate if someone could help me to get my connection going. Thank you very much Luc Lalancette - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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't initialize InnoDB as 'innodb_data_file_path' Problem
Thanks Ken ! - Original Message - From: Ken Sommers [EMAIL PROTECTED] To: Sunento Wu [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 1:45 PM Subject: Re: Can't initialize InnoDB as 'innodb_data_file_path' Problem Better read the manual: http://www.innodb.com/ibman.html#InnoDB_start Enjoy, Ken - Original Message - From: Sunento Wu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 10:34 PM Subject: Can't initialize InnoDB as 'innodb_data_file_path' Problem Hi, I am still new in mysql. I just install mysql to my win 98. When I try to run the server, mysqld, I got this error : === C:\mysql\binmysqld Can't initialize InnoDB as 'innodb_data_file_path' is not set === Have some one experienced with this error before ? I have read the Installation Guide for WIN 98, but can not find any solution for this problem. Thanks, anen __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.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!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql.org
First, I support mySQL and Open Source community. Maybe you can fight them with their own weapon. They have made some extra applications based on mySQL, and they sell it. You can create same applications as Open Source. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Transaction for MySQL
Hi everyone, Would someone help me out with these questions? I know these may be something obvious/ in the manual .. etc but I would like to have someone showing me if I am on the right track and maybe share some of these in greater detail. Greatly appreciated. Regards, Michael - Original Message - From: Michael Tam [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 2:06 PM Subject: Transaction for MySQL Hi all, I am new using MySQL. I found out that the default table type used in the binary isn't support transaction and would like to make MySQL uses another table type which supports transaction. The following are my questions regarding the issue: 1) which one should I use InnoDB or BDB? what kind of advantages given by each type? 2) currently, I am using the default type - MyISAM, where I am running MySqld-nt. If I would like to switch to another table type. Do I just uninstall the service of MySqld-nt from win2000 and install MySqld-Max service?? In addition to the daemond, I need to comment out the MyISAM config 3) what would happen to my existing MyISAM type tables which already exists in MySQL if I do the switch over? and would I able to use/create MyISAM type table uder MySqld-Max?? Thank you and greatly appreciated for any suggestion/help. Regards, Michael - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 or MS SQL?
Hi, the question is what operating system you are going to use. If your DB gets to large you will have problems not with tha database but with the filesystem. Best Regards Bernhard - Original Message - From: Alexander Chernienko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 7:51 PM Subject: MySQL or MS SQL? I'm currently writing proposals for a customer who want to hire our little programming team for creating corporate information system, wich includes huge database with number of records between 1-10 millions (incl. blobs - pictures). Expected database size is tens of Gb. There is idea of using MS SQL Server for some reasons, on other hand we have big experience with MySQL (but with smaller databases). So I'm very interested to hear advise, especially from people who had experience with both SQL servers - which SQL Server is preferable in such situation. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message
Hi, the driver which i am using is type IV. do i still need to install myodbc? thks -Original Message- From: Venu Anuganti [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 2:04 PM To: shane Cc: [EMAIL PROTECTED] Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message Hi Shane To connect to MySQL using JDBC Driver, it depends up on the type of JDBC driver you are using. If you are using a JDBC-ODBC Bridge (TYPE 1 DRIVER) then you need MyODBC installed on the system and configured properly as explained in the earlier mail in the mysql list. Here is the link, which tells different types of JDBC drivers in the world. http://java.sun.com/products/jdbc/driverdesc.html or http://www.jguru.com/faq/view.jsp?EID=691 Let us know, what type of JDBC driver are you using to connect to MySQL ? Thank you Venu Anuganti - Original Message - From: shane [EMAIL PROTECTED] To: Venu Anuganti [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 10:39 PM Subject: RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message i am using the mmmysql jdbc driver, and i was wondering whether i need to install myodbc. i'm running mysql server on a linux machine and the binary version of the download from www.mysql.com does not include the odbc driver and the libraries required for myodbc. I'm running on a i686 but the rpm version they have is for i386 system thks shane -Original Message- From: Venu Anuganti [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 12:55 PM To: Luc Lalancette; [EMAIL PROTECTED] Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message Hi Luc Here is the common syntax, that is used as the connection string through JDBC-ODBC Driver. Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url = jdbc:odbc:TestDSN; Coonection con = DriverManager.getConnection(url,username,password); Before connecting, make sure you intslled the ODBC Driver and configured the DSN 'TestDSN' created in the ODBC DSN Administartor. Based on your error below, it looks you have the valid DSN, but you didn't supply the UID and PWD in the connection string. Thank you Venu Anuganti - Original Message - From: Luc Lalancette [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 3:02 PM Subject: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message I am starting using mysql and I made a java SimpleQuery servlet that is suppose to retreive one row from the database. However, when I try to connect I get that message from the Subject. I know I'm suppose to pass the password but can't seem to find a way of doing it. I was wondering if the problem was with those two lines or if it was in the tdx mysql driver default configuration in the ODBC. Class c = Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); dbConn = DriverManager.getConnection(jdbc:odbc:TestDSN;); I would appreciate if someone could help me to get my connection going. Thank you very much Luc Lalancette - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Bug in Mysql access rights ?
Bonjour, I have a problem with Mysql-3.23.39 and users access rights. It's the second time I notice this problem since I installed .39 on two of my servers. But yesterday, the bug was even more flagrant. I had a user which had all rights on a database when connecting from localhost and from a local network say 10.0.0.% . This way everything worked fine, user being able to do inserts, updates, deletes, ... on all tables of the database. Then I wanted to grant rights to this user from a remote IP not in the local network. But, for security reason I wanted to give only SELECT right to the user from this remote IP. So I did something like : GRANT SELECT on database.* to user@'remoteIP' identified by 'password' Here starts the problems ! Just after I did this GRANT, I noticed that some of my programs which are using this user to log had no more the rights to update, delete or insert some tables : Query: UPDATE livequote_PAR SET last=36.28,tot_volume=33208,tradedate=concat(CURDATE(), ' 9:26:29') WHERE symbole='1rPEN' Erreur : update command denied to user: 'user@localhost' for table 'livequote_PAR' While as you can see, these programs are running, and so connecting, from localhost ... And more strange, not all the programs were affected by the GRANT. I did some more tests and then I found that when I use this user to connect from localhost, sometimes it is allowed to update tables, sometimes not. It depends on the connection. Once I connect and I will not be allowed to update tables, then I reconnect and I will have rights to updates tables ... and so on. When I check mysql database and tables user,db... everything is ok. It's telling that the user from localhost and local network has all rights, and that the same user from a given remote IP is allowed only to SELECT. What's happening ? Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: innodb and raw disks
Christian Jaeger wrote: Just to the record: I've written a small program too, and it reports correct sizes for normal disk devices under both linux 2.2 and 2.4, as long as the partition sizes don't exceed the 2GB limit (I don't have large file support, since I use debian potato with just the necessary packages upraded for running 2.4). I've NOT tried with *unbuffered raw* partitions, however (linux 2.4 supports both partition access with and without buffering), I don't know yet how to setup these. database sql query table This is getting interesting! I compiled your program on my home machine (Redhat 6.2) and it gave me the same results that you reported. However, I tried it on the machine at work that I was experimenting with yesterday, and it returned 0 for each partition. Accordingly, I copied my own program to the home machine, and tried that: it reported the correct size for the partitions. The difference? The home machine is running kernel 2.4.3, the machine at work is running 2.2.16. Looks like lseek (and presumably the underlying structures and code) must have been substantially changed. Translated into real terms, this probably means that InnoDB raw disks are much more likely to work under Redhat 7.1+ than Redhat 6.2 (I will verify this as a matter of urgency and report back.) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Transaction for MySQL
Would someone help me out with these questions? I know these may be something obvious/ in the manual .. etc but I would like to have someone showing me if I am on the right track and maybe share some of these in greater detail. Greatly appreciated. Since the experts are too busy, I'll put in my $0.02 - though I am NOT an expert I am new using MySQL. I found out that the default table type used in the binary isn't support transaction and would like to make MySQL uses another table type which supports transaction. The following are my questions regarding the issue: 1) which one should I use InnoDB or BDB? what kind of advantages given by each type? 2) currently, I am using the default type - MyISAM, where I am running MySqld-nt. If I would like to switch to another table type. Do I just uninstall the service of MySqld-nt from win2000 and install MySqld-Max service?? Yes - the Max server support sevral table types at the same time. In addition to the daemond, I need to comment out the MyISAM config 3) what would happen to my existing MyISAM type tables which already exists in MySQL if I do the switch over? and would I able to use/create MyISAM type table uder MySqld-Max?? The existing tables remain as they are, and will be handled in the same way. The default remains MyISAM. However, you can create new tables using different table types, and alter your existing tables using the ALTER TABLE command. Alec Cawley - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 error
Hi, Thanks. After sending my mail I found out that the mysqld was not running. Now it is fine. Thanks once again Adrian On Tue, 17 Jul 2001 [EMAIL PROTECTED] wrote: as opposed to using safe_mysqld try starting mysql using /etc/init.d/rc.d/mysql start and stopping using /etc/init.d/rc.d/mysql stop I had the same problem on a cobalt raq running a variant of red hat and that solved it. Sean -Original Message- From: Adrian D'Costa [mailto:[EMAIL PROTECTED]] Sent: 17 July 2001 08:32 To: Mysql Mailing List Subject: mysql error Hi, I just installed a new version of mysql (not the latest) 3.23.36 which came with rh 7.1 cd. I know that it is buggy but I have the following problems that have been discussed in the list. I search the archives but did not see how the problem got solved. The error: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) I did a ps aux | grep mysqld root 924 0.0 0.0 18560 ?SW 09:55 0:00 [safe_mysqld] mysql 974 0.0 0.0 12252 24 ?S09:55 0:00 [mysqld] mysql 986 0.0 0.0 12252 24 ?S09:55 0:00 [mysqld] mysql 987 0.0 0.0 12252 24 ?S09:55 0:00 [mysqld] When I try to restart or stop using /etc/init.d/mysqld stop Stopping MySQL:[FAILED] The log shows : 010717 12:34:42 mysqld started 010717 12:34:43 Can't start server: Bind on TCP/IP port: Address already in use010717 12:34:43 Do you already have another mysqld server running on port: 3306 ? 010717 12:34:43 Aborting 010717 12:34:43 mysqld ended 010717 12:50:02 mysqld started 010717 12:50:02 Can't start server: Bind on TCP/IP port: Address already in use010717 12:50:02 Do you already have another mysqld server running on port: 3306 ? 010717 12:50:02 Aborting 010717 12:50:02 mysqld ended 010717 12:55:26 mysqld started /usr/libexec/mysqld: ready for connections I tried to change the /etc/my.cnf socket to /tmp/mysql.sock but I still get the error ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) How do I solve this as I am in the middle of a web database project TIA Adrian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-compile mysql to use multiple character sets (again)
Hi, I have configured mysql using the parameter --with-charset=latin2, made some databases and tables full of latin2 text. Now I have to add another database, which will store text in latin1. As I red the articles related to these problems, if I understand well, I have to do the followings: - shut down running mysql - do a configure --with-charset=latin2 --with-extra-charset=latin1 - do a make make install - keep all preexisting databases (including mysql itself) - run myisamchk -r -q on every table - start mysql Is this correct? Is there any other way to avoid re-compileing the whole mysql source distribution? If I want to feed my new database which uses latin1, how should I connect to the database from perl to be able to use latin1? What will happen with the old latin2 tables? Shall I use the connection method in the future that I use currently? Regards, Peter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Running multiple MySQL servers on one machine
On Mon, Jul 16, 2001 at 12:40:24PM +1000, William Chi wrote: Hi, I was wondering if anyone has any opinions on the advantages and disadvantages of running multiple servers on one machine. Each server would be used to access different databases. Off the top of my head, since I haven't seen a reply yet... Benefits: * If one crashes, the other does not. * You could run them under different userids. * You could run different versions of MySQL. Disadvantages: * You'll probably use more memory that way. * Client applications have to be configured to use different port numbers. This may or may not be trivial. * You have more servers to monitor. * Usernames and passwords are not shared across the servers. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 33 days, processed 257,419,842 queries (90/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
select
Hello, I'd like to do a query with the following form: select * from (select ...) ... But it doesn't work. Is it possible to do something like that with mysql and maybe with another syntax? Thanx Nico. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Win32 - replication - Error 1133
Hi everybody, I use Replication on a windows NT4 Server. There are 1 master and 2 slaves, all on the same machine. One slave is started with the option skip-name-resolve, not the other. For the 2 slaves : master-host=localhost When adding a user (MYSQL.User), the replication is OK but, when I use GRANT, I get a 1133 error. Let's have a look on a slave : MYSQL.User table : localhost | jkasas | 1896f443280395b3 And what I do and get : mysql GRANT SELECT ON MEMBERS.users TO jkasas@'localhost'; ERROR 1133: Can't find any matching row in the user table Personnally, I don't understand why. Does anyone understand ? Thx for the answers. -- Frederic BALU - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug in Mysql access rights ?
BAUMEISTER Alexandre writes: Bonjour, cut What's happening ? Regards, Alex. Your story is quite strange. Can you run SHOW GRANTS on both user@localhost and user@remoteIP and see what they are showing ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Running multiple MySQL servers on one machine
I think the main disadvantage would be the memory... Running two servers means it would use twice the amount of memory... So say you are using 256mb for the key cache... running two servers would use 512mb (not the exact moment the servers start but after a prolonged period of time of course). This situation gets even worse if you are depending on a larger key cache for performance. ryan - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: William Chi [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 3:59 AM Subject: Re: Running multiple MySQL servers on one machine On Mon, Jul 16, 2001 at 12:40:24PM +1000, William Chi wrote: Hi, I was wondering if anyone has any opinions on the advantages and disadvantages of running multiple servers on one machine. Each server would be used to access different databases. Off the top of my head, since I haven't seen a reply yet... Benefits: * If one crashes, the other does not. * You could run them under different userids. * You could run different versions of MySQL. Disadvantages: * You'll probably use more memory that way. * Client applications have to be configured to use different port numbers. This may or may not be trivial. * You have more servers to monitor. * Usernames and passwords are not shared across the servers. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 33 days, processed 257,419,842 queries (90/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
Re: Info needed! -- urgent!!
The following doesn;t make sense... I need the resultset comprising the list
of all the tables in the db...and i wat that as a java.sql resultset...can
somebody help me here!???urgent!!
java code :
String sqlQuery = show tables;
try {
con = ConnectionPoolManager.getConnection();
stmt = con.createStatement();
rs = stmt.executeQuery(sqlQuery);
}
- Original Message -
From: Venu Anuganti [EMAIL PROTECTED]
To: Asha Ramaiah [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 11:55 AM
Subject: Re: Info needed!
If Connection.isClosed() returns false means, the connection is open.
:-Venu Anuganti
- Original Message -
From: Asha Ramaiah [EMAIL PROTECTED]
To: Venu Anuganti [EMAIL PROTECTED]
Sent: Wednesday, July 18, 2001 11:28 PM
Subject: Re: Info needed!
how do i check whether the db Connection is open??
- Ash
- Original Message -
From: Venu Anuganti [EMAIL PROTECTED]
To: Asha Ramaiah [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 11:48 AM
Subject: Re: Info needed!
Hi Asha
In JDBC itself, you can test it using the following options from -:
1. Connection.isClosed() to check, whether given connection is closed
or
not.
I am not sure whether this answers your questions. Let me know your
further
feedback on this. If you want to USE C APIs, I can provide the links
to
start the things. Because am not related to JDBC side, but am a
developer
of
MyODBC from MySQL AB. So, towards JDBC, not familiar.
Thank you
Venu Anuganti
--
For technical support contracts, go to https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Venu Anuganti [EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Redwood city, California USA
___/ www.mysql.com
- Original Message -
From: Asha Ramaiah [EMAIL PROTECTED]
To: Venu Anuganti [EMAIL PROTECTED]
Sent: Wednesday, July 18, 2001 10:57 PM
Subject: Re: Info needed!
The reason for trying to use these methods is basically to do the
following
:
Check whether a connection is open (db) in mysql , which is use in a
Connection Pooling java obj .
I want to basically know the mechanism to check at any time whether
a
connection is open to a db in mysql..
Thanks Regds
Ash
- Original Message -
From: Venu Anuganti [EMAIL PROTECTED]
To: Asha Ramaiah [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 11:15 AM
Subject: Re: Info needed!
Hi Asha
No. You can't call these APIs through JAVA. They can be called
only
through
C applications. If you can provoide me, why you want to use them
in
JAVA,
then I can help you if possible.
Thanks in advance
Venu Anuganti
- Original Message -
From: Asha Ramaiah [EMAIL PROTECTED]
To: Venu Anuganti [EMAIL PROTECTED]
Sent: Wednesday, July 18, 2001 10:46 PM
Subject: Re: Info needed!
thanks...Venu,
Another thing : there are some C API functions such as :
mysql_real_connect() and mysql_ping()
How can I call these frm a java program?..is it possible at
all??
Thanks and Regds
Ash
- Original Message -
From: Venu Anuganti [EMAIL PROTECTED]
To: Asha Ramaiah [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 11:05 AM
Subject: Re: Info needed!
Hi Asha
Yes, you are correct. Please refer to the following link for
more
details:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SHO
W
Thank you
Venu Anuganti
--
For technical support contracts, go to
https://order.mysql.com/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Mr. Venu Anuganti
[EMAIL PROTECTED]
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer
/_/ /_/\_, /___/\___\_\___/ Redwood city, California USA
___/ www.mysql.com
- Original Message -
From: Asha Ramaiah [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 18, 2001 10:32 PM
Subject: Info needed!
I need to run a query from a java program to :
1) get the list of tables in a particular db]
2) get the desc of each table in the list I get
Can I use the show tables; and desc tablename as a query to
get
the
desired
RESULTSET in java(sql package) ??
Plz do respond at hte earliest!
Thanks and regds
Ash
-
Before posting, please check:
http://www.mysql.com/manual.php
unique and null values
back to my unique constraint again :) i asked on irc but couldnt get anything out of them so i came here. got a unique constraint with serveral columsn like so.. UNIQUE (col1,col2,col3) id like to have col2 and col3 to use null values but it doesnt seem to like this. Is there a way i can use columns with NULL in a composite unique constraint like the one above thanks -Josh (sql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
configure problem
I get the following error: checking return type of sprintf... configure: error: can not run test program while cross compiling when I type ./configure in the source directory of mysql-3.23.39 so I can't install mysql. Why? 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: query.preview() stored in an edit box
Örjan Björk writes: Hi, I recently downloaded mysql++ and the tutorial that came with it. Unfortunately they used cout in the examples... they used the following code coutquery.preview(); and that worked great but... How do I get the result back as a string which I can store in a CString or char variable?? Thanks in advance! /Kalle B Use ostrstream class as presented in load_file.cc example. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Transaction for MySQL
MT 1) which one should I use InnoDB or BDB? what kind of advantages MT given by each type? I'm not expert but AFAIK BDB databases doesn't work well (i.e. fast) if they don't fit fully in RAM. Another important thing: InnoDB provides row-level locking while BDB only page-level locking. Thus it can be a limitation for some applications. -- -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- | Ilya Martynov (http://martynov.org/)| | GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 | | AGAVA Software Company (http://www.agava.com/) | -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Bug report: FULLTEXT index corrupts the index with too many TEXT fields
Hi! On Jul 19, Carsten Gehling wrote: Finally I was able to produce a complete step-by-step to corrupt the index ;-) mysql insert into visitkort (kategori_id) values (108); mysql select last_insert_id(); mysql update visitkort set navn = 'test5' where id = 1; mysql update visitkort set tekst1 = 'bla bla' where id = 1; ERROR 1034: Incorrect key file for table: 'visitkort'. Try to repair it Sorry, but everything works ok for me: mysql update visitkort set tekst1 = 'bla bla' where id = 1; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[2]: Bug in Mysql access rights ?
BAUMEISTER Alexandre writes: Sinisa, xut mysql show grants for news@'192.168.1.%'; ++ | Grants for [EMAIL PROTECTED]% | ++ | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD '' | | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%' | | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO 'news'@'192.168.1.%' | | GRANT SELECT, INSERT, UPDATE, DELETE ON pratique.* TO 'news'@'192.168.1.%' | ++ And I have some programs run by cron (once each 5 minutes) which are connecting from 192.168.1.12. Sometimes, my programs are getting the error : select command denied to user: '[EMAIL PROTECTED]' for table 'instrument' But not all the time. At some execution it gets this error, at some other executions it works fine. Table 'instrument' is in database 'cotations'. Regards, Alex. The above error message is expected if you run SELECT ...INTO or similar on any table in cotations -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
date_format doesn't work correct
Hi! i've mysql-3.23.39-nt on winnt with a client running under SCO 3.2 i've a simple querry with date_format in it, but date_format isn't doing what i expect... sql_string: select date_format(c.hour, '%Y%m%d%H'), c.hour from count c c.hour is DATETIME okay, i see this output on my sco-machine: '2001071614' '2001-07-19 14:00:00' if i try the same with mysql-front on my win2k machine: '2001071914' '2001-07-19 14:00:00' ?!? i'm using the C-API (libmysqlclient.a) from mysql-3.23.38-pc-sco3.2v5.0.6-i386.tar.gz any ideas ? what should i do? a new libmysqlclient ? thx! -- Florian Schmidt mailto:[EMAIL PROTECTED] http://www.f-24.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[4]: Bug in Mysql access rights ?
Sinisa, mysql show grants for news@'192.168.1.%'; ++ | Grants for [EMAIL PROTECTED]% | ++ | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD '' | | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%' | | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO 'news'@'192.168.1.%' | | GRANT SELECT, INSERT, UPDATE, DELETE ON pratique.* TO 'news'@'192.168.1.%' | ++ And I have some programs run by cron (once each 5 minutes) which are connecting from 192.168.1.12. Sometimes, my programs are getting the error : select command denied to user: '[EMAIL PROTECTED]' for table 'instrument' But not all the time. At some execution it gets this error, at some other executions it works fine. Table 'instrument' is in database 'cotations'. Regards, Alex. SM The above error message is expected if you run SELECT ...INTO or SM similar on any table in cotations But the query is : SELECT i.libelle FROM news n, symbole_news s, cotations.instrument i WHERE n.id=s.news_id AND i.symbole=s.symbole AND n.id= LIMIT 1 Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
inheritance of privileges?
Privileges question: I have a user in mysql.user and he has among each other DROP privileges, but if he creates a database and some tables in it, he can query a DROP table but can't run a DROP script... then he gets Permission denied, but if I add him to the mysql.db table for this database with DROP privileges he can run a drop script? why, isn't the privileges from mysql.user inherited when running from the prompt (when running scripts)? Regards, Johan Nilsson Software Developer BeCon Mobile Internet AB, Sweden Web: http://www.beconmobile.com E-Mail: [EMAIL PROTECTED] Office: +46 457 44184 Cellular: +46 709 798897 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
help, cant unsibscribe
sql - ignore. yesterday i sent an email to: [EMAIL PROTECTED] to get unsibscribed, but today i discovered that it didnt work. So i tried http://lists.mysql.com/php/unsubscribe.php After a while i got an auth code and a link. when i checked the link it said that i wasnt subscribing to [EMAIL PROTECTED] ,but im still recieving emails. anyone got any ideas ? kenneth johansen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[6]: Bug in Mysql access rights ?
Sinisa, | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD '' | | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%' | | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO 'news'@'192.168.1.%' | | GRANT SELECT, INSERT, UPDATE, DELETE ON pratique.* TO 'news'@'192.168.1.%' | ++ But the query is : SELECT i.libelle FROM news n, symbole_news s, cotations.instrument i WHERE n.id=s.news_id AND i.symbole=s.symbole AND n.id= LIMIT 1 SM In which database are tables news, symbole_news ?? In database contenu. Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[6]: Bug in Mysql access rights ?
BAUMEISTER Alexandre writes: Sinisa, | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD '' | | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%' | | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO 'news'@'192.168.1.%' | | GRANT SELECT, INSERT, UPDATE, DELETE ON pratique.* TO 'news'@'192.168.1.%' | ++ But the query is : SELECT i.libelle FROM news n, symbole_news s, cotations.instrument i WHERE n.id=s.news_id AND i.symbole=s.symbole AND n.id= LIMIT 1 SM In which database are tables news, symbole_news ?? In database contenu. Alex. H. xmells like my bug ... I will take a look at it ... It is a bug induced by db.table notation, which should work in the above case. Why didn't you come up with it one week ago and thus helped us fix this in 3.23.40 .. ;o) -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: date_format doesn't work correct
At 09:25 19.07.2001 -0400, you wrote: Probably due to timezone setting differences between the two client machines. i also thought about that, but there are 2 DAYs difference... can this be a timezone issue ? okay, i see this output on my sco-machine: '2001071614' '2001-07-19 14:00:00' if i try the same with mysql-front on my win2k machine: '2001071914' '2001-07-19 14:00:00' ?!? i'm using the C-API (libmysqlclient.a) from mysql-3.23.38-pc-sco3.2v5.0.6-i386.tar.gz -- Florian Schmidt mailto:[EMAIL PROTECTED] http://www.f-24.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: inheritance of privileges?
Johan Nilsson writes: Privileges question: I have a user in mysql.user and he has among each other DROP privileges, but if he creates a database and some tables in it, he can query a DROP table but can't run a DROP script... then he gets Permission denied, but if I add him to the mysql.db table for this database with DROP privileges he can run a drop script? why, isn't the privileges from mysql.user inherited when running from the prompt (when running scripts)? Regards, Johan Nilsson Software Developer BeCon Mobile Internet AB, Sweden Web: http://www.beconmobile.com E-Mail: [EMAIL PROTECTED] Office: +46 457 44184 Cellular: +46 709 798897 First : Which MySQL version are you using. If not the most recent one, please try it. Next : Do not meddle with privilege tables directly but use GRANT commmand ... Last : All privileges are inherited from global ones. Run SHOW GRANTS for that user and see what it shows -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: stability of freebsd 4.3, gcc 2.95.3
Hi Allen, Has anyone had unfavourable experiences with FreeBSD 4.3-STABLE, gcc 2.95.3, and libmysqlclient_r.so.10 (from MySQL 3.23.39), and POSIX threads? When you say POSIX threads, I am alittle confused, Do you mean native threads? What are you configuration options. My systems are very stable, I am using both BSD Native threads and Linux Threads on FreeBSD 4.3 Release and -stable. Did you provide threads options when configuring? Or just let configure find the libs? Ken - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re[4]: Bug in Mysql access rights ?
BAUMEISTER Alexandre writes: Sinisa, | GRANT USAGE ON *.* TO 'news'@'192.168.1.%' IDENTIFIED BY PASSWORD '' | | GRANT SELECT ON cotations.* TO 'news'@'192.168.1.%' | | GRANT SELECT, INSERT, UPDATE, DELETE ON contenu.* TO 'news'@'192.168.1.%' | | GRANT SELECT, INSERT, UPDATE, DELETE ON pratique.* TO 'news'@'192.168.1.%' | ++ But the query is : SELECT i.libelle FROM news n, symbole_news s, cotations.instrument i WHERE n.id=s.news_id AND i.symbole=s.symbole AND n.id= LIMIT 1 Regards, Alex. In which database are tables news, symbole_news ?? -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FreeBSD issues - suggested fixes
Hi Michael, I would be very happy to help. I will however be away for the next 5 days, but there are other FreeBSD users on the list. I think the biggest help would be for one of us FreeBSD users to update the manual with all the latest information (I will try to do that late next week if someone else doesn't!). I have similar notes for BSDi OS. The first major suggestion is to use the FreeBSD ports to install MySQL, the ports maintainers go through alot to make sure you get a proper compile from source. However that being said it is not always exactly what you want, but there is alot to be learned from teh makefile. Make sure you get latest ports with cvsup and are on at least freebsd 4.3 or a stable date from march 2001. Second, for tuning MySQL based on your hardware see either /usr/share/examples/mysql (if you installed from ports), or the support-files sub directory in whatever directorty you have mysql (like /usr/home/admin/mysql-3.23.39/support-files ) Third, there is great new info coming in FreeBSD 4.4 on tuning FreeBSD in a man page called tuning. (man 7 tuning). You can get this now by upgrading whatever release you are on to freebsd-stable (which changes daily, yes you can pick a date read cvsup man page). Fourth, my configure script for mysql: bash-2.03$ cat ken.sh VERSION=mysql-3.23.38 #replace first line with current version set -x cd $VERSION; CC=gcc CFLAGS=-O3 CXX=gcc \ CXXFLAGS=-O3 -felide-constructors -fno-exceptions -fno-rtti \ ./configure --enable-large-files --with-berkeley-db \ --with-innodb --with-low-memory bash-2.03$ gmake -s bash-2.03$ gmake -s install (note use gmake not BSD make, must be installed (from ports) ) Without knowing alot more specifcally about any issues you are having. I can not help more than this. I do try to answer anything I see relating to freebsd if I can (as sometimes I learn things for our own operation). I have changed the subect of the message to hopefully help people searching the archives that this is a list of suggestions! Hope this helps, I am here the rest of the day and back the middle of next week! Ken - Original Message - From: Institute For Social Ecology [EMAIL PROTECTED] To: Ken Menzel [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 6:32 PM Subject: RE: FreeBSD issues Ken, Thank you for your very helpful notes. We took your advice and updated to FreeBSD 4.3 and the last version of MYSQL. We are still experiencing problems with MYSQL, though. We installed it fresh, with no freeBSD tweaks. I was not able to locate the email you referred to regarding FreeBSD installs. If you have any pointers on tweaking a freeBSD install, it would be very helpful. Regards, Michael Caplan -Original Message- From: Ken Menzel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 17, 2001 3:25 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: FreeBSD issues Hi Michael, As another FreeBSD user that has posted many times on FreeBSD topics realted to MySQL it only took me a few minutes to find rest cut - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: date_format doesn't work correct
At 09:40 19.07.2001 -0400, you wrote: You're correct, likely not a timezone problem. Have you confirmed that the clocks on these machines are synchronized? That they aren't really three days off? yep, again and agein :) the clocks are in sync +/- 5 secs okay, i see this output on my sco-machine: '2001071614' '2001-07-19 14:00:00' if i try the same with mysql-front on my win2k machine: '2001071914' '2001-07-19 14:00:00' ?!? i'm using the C-API (libmysqlclient.a) from mysql-3.23.38-pc-sco3.2v5.0.6-i386.tar.gz Florian Schmidt mailto:[EMAIL PROTECTED] http://www.f-24.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql.org
On Wed, Jul 18, 2001 at 11:10:20AM -0700, Michael Collins wrote: It seems to me that the bottom line is that any outcome that results in there being a fork in the development of MySQL (with the result being two completely different types of MySQL), or in NuSphere retaining control of the mysql.org domain should be vehemently rejected by the MySQL community. No matter what agreement may or may not have been created, since MySQL AB has made it clear that this is not what they want or intended. So to me it is obvious that any agreement that may have been made is either being misinterpreted by NuSphere or was not entered in good faith. NuSphere, if what you want is an improved MySQL and if you have anything to contribute to the betterment of MySQL, hand over the code. If you want a non-profit Web site first turn over MySQL.org to MySQL AB and either register NuSphere.org for your non-profit site or help MySQL AB to get it started. If you want to make money on MySQL, follow the guidelines of GPL to the letter and to the approval of MySQL or pay the per-copy license. I guess the solution seems so simple for an outsider. -- Michael I think I've made it clear that I'm not enamored of NuSphere's recent actions, which I think are remarkably bone-headed. At the same time, a NuSphere-controlled mysql.org doesn't strike me as a disaster, provided they can do it with out shooting themselves in the foot, as they are doing now. I have two concerns about the present conflict. First is the obvious problem that MySQL AB lacks the resources to develop table types with extended functionality, as NuSphere, SleepyCat, and InnoDB are doing. MySQL AB has a comparative advantage in SQL interfaces, core DBMS functionality, and porting MySQL to as many OSs as possible. If they try to do more than that, they'll probably be too overextended to do any single thing well. NuSphere has a comparative advantage in providing extended functionality. Because they don't have to deal with the problems that MySQL AB is solving, and because they have an existing code base that they can modify, they can bring a relatively mature product to market that makes the overall MySQL package more attractive. Even if you discount the marketing hype, the word from the beta testers is good. My second concern is the fact that NuSphere has made a large investment in converting their table to use with MySQL, and that investment was made after undergoing a formal agreement. If the investment fails and the agreement ends in lawsuits, it will discourage further investment and more agreements involving other companies. On the other hand, if the present disagreement can be resolved without recourse to legal remedy and NuSphere makes a nice profit on its investment, it will encourage other companies to make agreements with MySQL AB and make investments that further extend MySQL's capabilities. It's in everone's interests for NuSphere to make a profit, and it's in everone's interests for MySQL AB to have a reputation as a reasonable business partner. The developer community needs both the complementary capabilities of NuSphere and MySQL AB, and useful tools from other companies. The tools won't come unless other companies invest, and they won't invest unless they think they can make a profit. Disagreements between partners raise costs and reduce profit. I don't want to discourage either side from defending their interests or what they see as their rights. An agreement that leaves one side or the other feeling ripped off is not going to encourage more agreements or more investment. On the other hand, failure to come to agreement will poison the communal well. In the end, the details of an agreement will be less important than the fact of an agreement, provided the agreement promotes both parties' interests. NuSphere doesn't need mysql.org in order to make a profit, and MySQL AB can allow some use, perhaps temporarily, of the MySQL trademark without surrendering the crown jewels. MySQL AB's primary assets are its leadership in the MySQL community and the company's comparative advantage in the kinds of development mentioned above. The real issues are: How is NuSphere going to market their product, what is MySLQ AB going to contribute that both helps NuSphere and helps create the perception of an atmosphere that welcomes outsiders, and what is the value of MySQL AB's contribution (i.e. how much is NuSphere going to pay for an agreement, either in cash or otherwise). -- Bob Hall mysql list incantation: sql table databse 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:
Re: Inno DB question
Stanislav, how big is the insert and update load to your table? One user of InnoDB says that it copes with his average load of 800 inserts/updates per second. The computer has 4 processors. Since InnoDB has the non-locking consistent read, SELECT queries do not stop inserts or updates to your table. When you delete data from the big table, it may be best to do it in smaller batches. Because of multiversioning InnoDB cannot internally use DROP TABLE if you issue a full delete: DELETE FROM yourtablename. In simple join queries InnoDB is the fastests disk-based database backend in the world, at least I have not measured bigger numbers for any other disk-based database. A main memory database Polyhedra got about the same numbers for small join queries and somewhat less on bigger. See www.innodb.com/bench.html for benchmarks. In inserts and updates InnoDB is about as fast as MyISAM. In them most of the CPU time goes to Perl (if you use Perl) and client-server communication. About stability: the best reference is the page http://www.innodb.com/bugfixes.html and the mailing lists of MySQL. A problem is that people do not write to the mailing list when it works ok. Regards, Heikki Innobase Oy Copied message: . G'day, I have a question about using InnoDB format of tables with MySQL. We have a following problem: our application collects data into MySQL database during some period of time (say 1 hour) and then we need to analyze these data then move insert results of analysis into other table within same db and then clean first table. The problem is, what during analysis (it takes 30-40 secs) we have a lot of pending queries (due to lock on target table) and then all these pending queries start to execute the system load becomes to high. Can it be faster if we will switch to using InnoDB tables instead of MyISAM? How stable is InnoDB implementation in MySQL ? And more important, how fast is it ? With best regards, Stanislav Dmitrenko - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
remote connection with phpMyAdmin
Hi everybody, I've installed MySQL 3.23.38 on a RedHat 6.0 system with php 3.0.18. When I want to connect to the server with phpMyAdmin, it returns the following message : Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) in ./lib.inc.php3 on line 220 Erreur But any other program connect to it. any hints ? Pericles
problems with a command table
Hello, my problem as follows: I have installed MySQL and MyODBC. Under a Database I have created a table called SQLLIB and a Table called SQLERR. SQLLIB contains a Field SQLNAME and SQLCOMMAND. For example it contains NumEntry for SQLNAME and SELECT COUNT(*) FROM SQLERR for SQLCOMMAND. Because my external Program only can create or start this SQL-Commands by pointing on the parameter SQLNAME. This works with Oracle and also with Access. Under MySQL I got the message SQLBindParameter is not used by all parameters Did you have any idea? Volker Streppelmann, Germany
Re: innodb and raw disks
database table sql query OK, here's where I've got to. 1) After fiddling about with fdisk, disk geometry and kernel boot parms, I've managed to define a partition which appears to lseek as exactly 1000M (this was fairly horrible: if anyone wants to replicate this step, I'll go over the process, but just at the moment I'm trying not to think about it!) 2) I start mysql, and get the following: 010719 15:08:17 mysqld started Data file 0 is 1048576000 bytes InnoDB: Log file /usr/local/var/iblogs/ib_logfile0 did not exist: new to be created InnoDB: Log file /usr/local/var/iblogs/ib_logfile1 did not exist: new to be created InnoDB: Log file /usr/local/var/iblogs/ib_logfile2 did not exist: new to be created InnoDB: Cannot initialize created log files because InnoDB: data files are corrupt, or new data files were InnoDB: created when the database was started previous InnoDB: time but the database was not shut down InnoDB: normally after that. 010719 15:08:32 Can't init databases InnoDB: Setting log file /usr/local/var/iblogs/ib_logfile0 size to 52428800 InnoDB: Setting log file /usr/local/var/iblogs/ib_logfile1 size to 52428800 InnoDB: Setting log file /usr/local/var/iblogs/ib_logfile2 size to 52428800 010719 15:08:32 mysqld ended 3) I zapped the entire mysql database directory (/usr/local/var), remade the directories, and reinitialised the mysql database (using /usr/local/bin/mysql_install_db). I then started mysql, and got the same result as in (2). I guess that it's thinking the tablespace is already initialised. Heikki, Christian, any thoughts? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
the same time, a NuSphere-controlled mysql.org doesn't strike me as a disaster, provided they can do it with out shooting themselves in the foot, as they are doing now. Nah There using it as a marketing ploy to dup the public. The should have released their GPLed extentions on NuShpere.com rather than maysql.org, but they are unwilling to do this because they feel they have the right to be seen as the originators of MYSQL. Ruben - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
List problems?
Is there a mysql newsgroup somewhere? Or some other forum? I am the kind of user that has one question every couple weeks or so, and rather than fill up my mailbox, I prefer to subscribe, ask my question and then unsubscribe. This works well with other services, but it takes me (no exaggeration) 2 hours to subscribe to the mysql list. It usually takes over an hour for my post to appear. This list is the only one I have problems with, so I have 3 questions: 1. Is it something at my end? i.e. subscribe/unsubscribe is blazing fast for everyone else? 2. Is it something at the mysql list end? If so, why is it so slow? 3. Are there alternatives with the same quality of information for questions? (I havent found any) Thanks, Bryan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQLBug - Script mysql_install_db Empty
I am evaluating MySQL on a Solaris8 Intel machine, and followed your instruction for the installation. I used GNU tar to unzip the files into /usr/local/mysql-3.23.39-pc-solaris2.8-i386. There was no error in the tar process of the downloaded file. However, in the /usr/local/mysql-3.23.39-pc-solaris2.8-i386/scripts directory, file mysql_install_db is present, but is ZERO byte. What did I do wrong? Thanks. Steve Wu, Ph.D. Oracle DBA NORDSTROM.com (206) 215-7383 (Phone) (206) 215-7583 (Fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
gemini tables in mysql
Hi, since Nusphere release the source code for gemini yesterday I believe it was, I was wondering if Mysql AB was going to incorporate it into a future release if it's database. I realise in light of recent .org events Pete -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Inno DB question
Stanislav, HT I have a question about using InnoDB format of tables with MySQL. HT We have a following problem: HT our application collects data into MySQL database during some period of time HT (say 1 hour) and then we need to analyze these data then move insert results HT of analysis into other table within same db and then clean first table. HT The problem is, what during analysis (it takes 30-40 secs) we have a lot of HT pending queries (due to lock on target table) and then all these pending HT queries start to execute the system load becomes to high. HT Can it be faster if we will switch to using InnoDB tables instead of MyISAM? HT How stable is InnoDB implementation in MySQL ? HT And more important, how fast is it ? Just an idea : 1. say you record you data in table data_table. 2. ALTER rename data_table - data_table_for_stats 3. CREATE a new data_table 4. continue to record data in data_table and calculate your stats on data_table_for_stats. 2 and 3 will take less that 1 second with MyISAM (Mysql just have to rename some files + create new files). you can do what you want on data_table_for_stats without the risk to lock other processes which are using data_table. After you calculated your stats, you can move all data from data_table_for_stats into a table data_table_backup and drop data_table_for_stats. Just an idea if this can help ... Regards, Alex. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SV: Bug report: FULLTEXT index corrupts the index with too many TEXT fields
Hi! On Jul 19, Carsten Gehling wrote: Finally I was able to produce a complete step-by-step to corrupt the index ;-) mysql insert into visitkort (kategori_id) values (108); mysql select last_insert_id(); mysql update visitkort set navn = 'test5' where id = 1; mysql update visitkort set tekst1 = 'bla bla' where id = 1; ERROR 1034: Incorrect key file for table: 'visitkort'. Try to repair it Sorry, but everything works ok for me: mysql update visitkort set tekst1 = 'bla bla' where id = 1; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 I got exactly the same error as Carsten does when I follow the above. Mysql 3.23.38-max-nt on Windows 2000 pro SP2. Regards, 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
INNER JOIN Problem
Hi, I'm trying to do an INNER JOIN in MySQL (3.23.39 - Linux i686) that works perfectly when I test it in Access but MySQL is complaining and the web docs seem to suggest I'm doing it right. Can anyone see the error? I've got indexes on both tables on the joined field (Primary for AttractionInfo and just an index for AttractionType). Here is the query: SELECT AttractionInfo.AttractionID, AttractionInfo.AttractionName, AttractionInfo.ShortDesc, AttractionInfo.Community FROM AttractionInfo INNER JOIN AttractionType ON AttractionInfo.AttractionID = AttractionType.AttractionID; MySQL said: You have an error in your SQL syntax near 'ON AttractionInfo.AttractionID = AttractionType.AttractionID;' Any ideas? Thanks. Bob. Bob Horton PneumaSoft Services Inc. Custom Software Web Development Phone: (306) 545-1068 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: List problems?
On Thu, Jul 19, 2001 at 09:06:19AM -0700, Bryan Coon wrote: Is there a mysql newsgroup somewhere? Or some other forum? I am the kind of user that has one question every couple weeks or so, and rather than fill up my mailbox, I prefer to subscribe, ask my question and then unsubscribe. This works well with other services, but it takes me (no exaggeration) 2 hours to subscribe to the mysql list. It usually takes over an hour for my post to appear. This list is the only one I have problems with, so I have 3 questions: 1. Is it something at my end? i.e. subscribe/unsubscribe is blazing fast for everyone else? 2. Is it something at the mysql list end? If so, why is it so slow? 3. Are there alternatives with the same quality of information for questions? (I havent found any) You could send in your question and then watch the archives on http://lists.mysql.com/ Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 33 days, processed 259,872,258 queries (90/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 GUI Client
Hi, I just downloaded the MySQL GUI Client and was trying to set it up. The client keeps saying Access denied for user: 'adouglas@' (Using password: YES). I've typed in the Host Name (IP Address) and have the proper user name. Also I have the proper grant tables set for adouglas to access it from the machine I'm on. I'm also using port 3306. Do you have any ideas on how to solve this problem? --- Adam Douglas Webmaster Venmar CES Inc. E-mail: [EMAIL PROTECTED] Ph: (306) 242-3663 x285 Fx: (306) 242-3484 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
Dear folks at NuSphere, Thank you for your response to our open invitation. We disagree with a number of your statements, but we look forward to having a phone contact with you on Friday. Marten Mickos (database,sql,query,table) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
blob question
Hi, I'm new to blobs. I want to create a seperate table that will hold blob's or pictures. Each picture will be a .gif and will not exceed 100k in size. each image will be called, ord.gif, bar.gif, cmi,gif, lax.gif, jfk.gif, ord.gif, etc. The questions I had were 1. what would the create table statment look like. 2. Should I use a longblob based on my 100k .gif size? 3. Is one column with the gifs enough. Or should I add a autoincremented primary key? 4. Is it better to have a seperate table for this or, is it better to update my existing table, and add a blob column. Does it matter in terms of speed of queries? Queries will be done via php. Thanks! Pete -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MySQLBug - Script mysql_install_db Empty
What about the version of the file which should be in /usr/local/mysql-3.23.39-pc-solaris2.8-i386/bin ?? (which is the one you should be running from the 'mysql' directory as ./bin/mysql_install_db ) - Original Message - From: Wu, Steve [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Sfikas, Ted [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 9:08 AM Subject: MySQLBug - Script mysql_install_db Empty I am evaluating MySQL on a Solaris8 Intel machine, and followed your instruction for the installation. I used GNU tar to unzip the files into /usr/local/mysql-3.23.39-pc-solaris2.8-i386. There was no error in the tar process of the downloaded file. However, in the /usr/local/mysql-3.23.39-pc-solaris2.8-i386/scripts directory, file mysql_install_db is present, but is ZERO byte. What did I do wrong? Thanks. Steve Wu, Ph.D. Oracle DBA NORDSTROM.com (206) 215-7383 (Phone) (206) 215-7583 (Fax) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
UPDATEing values in SET columns
Hi
I have been searching through the manual and the list archives for the last
few days regarding a problem I have with the SET column type.
I'm creating an app that uses a SET column as 'flags'. Different parts
within the application will check to see if certain 'flags' are enabled. As
I understand, the SET column uses bit representation internally.
My problem is updating the column with flags already set. Below is an
example:
The table is as follows:
CREATE TABLE users ...
user_id INT ...
user_flags SET('another','test','pass_renew','none') NOT NULL DEFAULT
'none'
...
When I update a record, I can only set the whole string not just the
individual flag.
i.e. This works fine...
UPDATE users SET user_flags = 'test, none' WHERE user_id = 1
How can I add (or remove) values within the SET column without affecting the
existing contents?
I've tried a number of ways with no success!!
For example
UPDATE users SET user_flags = CONCAT(user_flags,'pass_renew') WHERE user_id
= 1
Any help or pointers would be greatly appreciated.
Thanks
Nick Brandon
P.S. Please cc my email address as I'm not subscribe to the list - 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
Backup of databases.
Hello there. I have a problem.. i cannot start my mysqld server on my Unix OpenBSD 2.9 Server, because i have a problem after i have restarted my server. So how do i take backups without connecting to the mysqld server, i have access to the files that is placed in /var/mysql but i cannot you mysqldump because of the server not is started and not can be started.. What to do ? Help me please /Tomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: blob question
Generally, it is not advised to add pictures to tables. See http://www.bitbybit.dk/mysqlfaq/faq.html#storing_images We had this question here some days ago, so it may ge a good idea to discuss at length possible problems why people won't like this approach of storing pics as files. WARNING: this is _not_ MySQL specific. You may want to stop reading here. 2nd WARNING: I will also show what can be done with all that information to arrive at some kind of content management wizardry. After all, people do use MySQL to do something with it, and many seem to manage pictures. So here it goes. If you let people upload images with php (which is built in and really easy) you will receive the images in, say some sort of tmp dir. You will have to move them in your code to a separate storage dir, as php will automatically delete the tmp files (see manual). Now php is part of httpd and that runs as nobody, so it cannot write to that storage dir unless you open that dir to nobody. This will be ok as you use this dir only for the purpose of storing those third party images. You may protect it in addition with .htaccess or move it out of the normal dir tree if you are a little paranoid. Now you can store the images as files with no problem and only note the filename and type or such (for example comments of the user to the picture) in the database. When you upload, you move the file, so this is a good point to record the file in your table. Once you are at it, you can retrieve the dimensions of that image with php function getImageSize and store them in your table together with the type as well. So now you know everything about this file you need for inclusion in your html code. Hence you write yourself a function, say getImgCode, which produces the html tags from this info, so you can insert the whole stuff into your code without any further thought like ... ?php getImgCode(firstNameOfMyPicture) ? ... You may even go a step further if you are in at content production. Let's assume the user uploads any text and pictures. The user is instructed to embed their pics with special syntax like ... stuff stuff stuff *MyImageFirstName* stuff stuff stuff ... You later insert the image with $content = preg_replace(/\*(\w+)\*/e, getImgCode($1), $content); This example is taken from http://php.net/manual/en/ref.pcre.php (I developed a content management system along these lines on my own, but this is just stunning - an incentive to learn the art of regular expressions). Sie schrieben am Donnerstag, 19. Juli 2001, 19:42:08: Hi, I'm new to blobs. I want to create a seperate table that will hold blob's or pictures. Each picture will be a .gif and will not exceed 100k in size. each image will be called, ord.gif, bar.gif, cmi,gif, lax.gif, jfk.gif, ord.gif, etc. The questions I had were 1. what would the create table statment look like. 2. Should I use a longblob based on my 100k .gif size? 3. Is one column with the gifs enough. Or should I add a autoincremented primary key? 4. Is it better to have a seperate table for this or, is it better to update my existing table, and add a blob column. Does it matter in terms of speed of queries? Queries will be done via php. Thanks! Pete -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL question
I thought about that after I sent it. First I will start with what my OS is. I am running Redhat 7.1. Kernel version 2.2.16-22(I believe). I used the i386 release. I did a rebuild of the src.rpm. then installed the rpm. I tried to set the root password as it told me but it said something like it couldn't find client or something. Anyway, I tried a ps to see if mysqld was running. It wasn't so I tried to run mysqld manually, still it started but stopped immediately. I printed out the return value and it had returned a 0. I believe I looked in the log and all it said was that the daemon started and stopped. I will look further and see what I can find out in the next couple of days but I thought maybe someone had the same problem. On Thu, 19 Jul 2001 02:06:36 +0200, Werner Stuerenburg wrote: Hm. Did you start mysqld? Better give more information if you want people to help. I have just installed MySql and when I tried to set the root password and it gives me an error(I don't recall the exact text) but I looked and the daemon isn't running. I tried starting it but still nothing? Did I miss a step? Sorry if this ends up to be a stupid mistake. Hope you can help me. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de ___ Send a cool gift with your E-Card http://www.bluemountain.com/giftcenter/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: UPDATEing values in SET columns
I would take another approach.
table 1 has only user_id
table 2 has flag values and key user_id
So you just insert rows or delete them in table 2. That's it.
Did I understand your problem?
Sie schrieben am Donnerstag, 19. Juli 2001, 20:24:17:
Hi
I have been searching through the manual and the list archives for the last
few days regarding a problem I have with the SET column type.
I'm creating an app that uses a SET column as 'flags'. Different parts
within the application will check to see if certain 'flags' are enabled. As
I understand, the SET column uses bit representation internally.
My problem is updating the column with flags already set. Below is an
example:
The table is as follows:
CREATE TABLE users ...
user_id INT ...
user_flags SET('another','test','pass_renew','none') NOT NULL DEFAULT
'none'
...
When I update a record, I can only set the whole string not just the
individual flag.
i.e. This works fine...
UPDATE users SET user_flags = 'test, none' WHERE user_id = 1
How can I add (or remove) values within the SET column without affecting the
existing contents?
I've tried a number of ways with no success!!
For example
UPDATE users SET user_flags = CONCAT(user_flags,'pass_renew') WHERE user_id
= 1
Any help or pointers would be greatly appreciated.
Thanks
Nick Brandon
P.S. Please cc my email address as I'm not subscribe to the list - 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
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: blob question
Thanks, regarding the PHP info. What I need to know is: 1. what would the create table statment look like in Mysql. 2. Should I use a longblob based on my 100k .gif size? 3. Is one column with the gifs enough. Or should I add a autoincremented primary key? 4. Is it better to have a seperate table for this or, is it better to update my existing table, and add a blob column. Does it matter in terms of speed of queries? Pete Werner Stuerenburg wrote: Generally, it is not advised to add pictures to tables. See http://www.bitbybit.dk/mysqlfaq/faq.html#storing_images We had this question here some days ago, so it may ge a good idea to discuss at length possible problems why people won't like this approach of storing pics as files. WARNING: this is _not_ MySQL specific. You may want to stop reading here. 2nd WARNING: I will also show what can be done with all that information to arrive at some kind of content management wizardry. After all, people do use MySQL to do something with it, and many seem to manage pictures. So here it goes. If you let people upload images with php (which is built in and really easy) you will receive the images in, say some sort of tmp dir. You will have to move them in your code to a separate storage dir, as php will automatically delete the tmp files (see manual). Now php is part of httpd and that runs as nobody, so it cannot write to that storage dir unless you open that dir to nobody. This will be ok as you use this dir only for the purpose of storing those third party images. You may protect it in addition with .htaccess or move it out of the normal dir tree if you are a little paranoid. Now you can store the images as files with no problem and only note the filename and type or such (for example comments of the user to the picture) in the database. When you upload, you move the file, so this is a good point to record the file in your table. Once you are at it, you can retrieve the dimensions of that image with php function getImageSize and store them in your table together with the type as well. So now you know everything about this file you need for inclusion in your html code. Hence you write yourself a function, say getImgCode, which produces the html tags from this info, so you can insert the whole stuff into your code without any further thought like ... ?php getImgCode(firstNameOfMyPicture) ? ... You may even go a step further if you are in at content production. Let's assume the user uploads any text and pictures. The user is instructed to embed their pics with special syntax like ... stuff stuff stuff *MyImageFirstName* stuff stuff stuff ... You later insert the image with $content = preg_replace(/\*(\w+)\*/e, getImgCode($1), $content); This example is taken from http://php.net/manual/en/ref.pcre.php (I developed a content management system along these lines on my own, but this is just stunning - an incentive to learn the art of regular expressions). Sie schrieben am Donnerstag, 19. Juli 2001, 19:42:08: Hi, I'm new to blobs. I want to create a seperate table that will hold blob's or pictures. Each picture will be a .gif and will not exceed 100k in size. each image will be called, ord.gif, bar.gif, cmi,gif, lax.gif, jfk.gif, ord.gif, etc. The questions I had were 1. what would the create table statment look like. 2. Should I use a longblob based on my 100k .gif size? 3. Is one column with the gifs enough. Or should I add a autoincremented primary key? 4. Is it better to have a seperate table for this or, is it better to update my existing table, and add a blob column. Does it matter in terms of speed of queries? Queries will be done via php. Thanks! Pete -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de -- ___ Pete Kuczynski Sr. Field Engineer DHL Airways Inc. Infrastructure Technology Services (773)-462-9758 24/7 Helpdesk 1-800-434-5767 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 GUI Client
Hi Adam, client keeps saying Access denied for user: 'adouglas@' (Using password: YES). Suggestion: Try: GRANT ALL ON *.* TO adouglas@localhost IDENTIFIED BY your_password This will grant you access from localhost, i. e. the client tool (e. g. MySQL Monitor, mysql.exe, or PHP script, or whatever) and server (mysqld.exe) are running on the same machine. For remote connects you will have to type something like this: GRANT ALL ON *.* TO adouglas@% TO ... (as above) This will grant access from *anywhere* (%) to the MySQL server. In case you edit mysql.user directly (e. g. with PhpMyAdmin) you will have to call FLUSH PRIVILEGES from the command line, or restart the MySQL server. Hope it helps. -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Adam Douglas [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 7:17 PM Subject: MySQL GUI Client Hi, I just downloaded the MySQL GUI Client and was trying to set it up. The client keeps saying Access denied for user: 'adouglas@' (Using password: YES). I've typed in the Host Name (IP Address) and have the proper user name. Also I have the proper grant tables set for adouglas to access it from the machine I'm on. I'm also using port 3306. Do you have any ideas on how to solve this problem? --- Adam Douglas Webmaster Venmar CES Inc. E-mail: [EMAIL PROTECTED] Ph: (306) 242-3663 x285 Fx: (306) 242-3484 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: innodb and raw disks
At 15:08 Uhr +0100 19.7.2001, Peter Duffy wrote: database table sql query I guess that it's thinking the tablespace is already initialised. Yes, probably: it's the same if you have an ibdata file and no log files and start mysql-innodb. I've noticed this while setting up innodb with filesystem based tablespaces and had given wrong paths to the logfiles - so mysql did quit, I restarted it with correct paths to log directories, and it quit again because of 'corrupt data files'. Removing the data file helped. (PS. it seems that the innodb_log_group_home_dir and innodb_log_arch_dir options require absolute paths (or relative to cwd perhaps). It took me some time to realize this :o].) Christian. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
the same time, a NuSphere-controlled mysql.org doesn't strike me as a disaster, provided they can do it with out shooting themselves in the foot, as they are doing now. Nah There using it as a marketing ploy to dup the public. The should have released their GPLed extentions on NuShpere.com rather than maysql.org, but they are unwilling to do this because they feel they have the right to be seen as the originators of MYSQL. I think you see evil people, conspiracies and other unwanted stuff when in fact there are only misunderstandings and opposing viewpoints. I'm with Bob Hall on this one. Excellent statement Bob! -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: UPDATEing values in SET columns
Dear Nick,
I dislike SET and ENUM as they are not SQL standard (tell me if I am
wrong). They may be fast because of the bitwise storage of data. But
both column types mangle DDL with DML, and that's where problems arise,
like yours.
Suggestion: Better go the straight way, i. e. put those flags into a
different table. You will have to JOIN where you did not have to join
before, but on the long run it will make things much easier, and more
transparent.
Instead of
UPDATE users SET user_flags = 'test, none' WHERE user_id = 1
this will be
UPDATE user_flags SET flag = test WHERE user_id = 1
Hope it helps.
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
- Original Message -
From: Nick Brandon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 8:24 PM
Subject: UPDATEing values in SET columns
Hi
I have been searching through the manual and the list archives for the
last
few days regarding a problem I have with the SET column type.
I'm creating an app that uses a SET column as 'flags'. Different parts
within the application will check to see if certain 'flags' are
enabled. As
I understand, the SET column uses bit representation internally.
My problem is updating the column with flags already set. Below is an
example:
The table is as follows:
CREATE TABLE users ...
user_id INT ...
user_flags SET('another','test','pass_renew','none') NOT NULL DEFAULT
'none'
...
When I update a record, I can only set the whole string not just the
individual flag.
i.e. This works fine...
UPDATE users SET user_flags = 'test, none' WHERE user_id = 1
How can I add (or remove) values within the SET column without
affecting the
existing contents?
I've tried a number of ways with no success!!
For example
UPDATE users SET user_flags = CONCAT(user_flags,'pass_renew') WHERE
user_id
= 1
Any help or pointers would be greatly appreciated.
Thanks
Nick Brandon
P.S. Please cc my email address as I'm not subscribe to the list -
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
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: blob question
What I need to know is: 1. what would the create table statment look like in Mysql. DROP TABLE IF EXISTS pictures; CREATE TABLE pictures ( id mediumint(4) NOT NULL auto_increment, comment text NOT NULL, width smallint(6) DEFAULT '0' NOT NULL, height smallint(6) DEFAULT '0' NOT NULL, format varchar(4) NOT NULL, PRIMARY KEY (id), KEY pid (pid) ); You may add other colums as needed or create other tables with foreign keys to this to connect the picture data to other data, e.g. texts, classifieds, whatever. 2. Should I use a longblob based on my 100k .gif size? You should provide for enough space in the field to hold your data. The field definitions tell you what is provided. If you deliver greater values than storage space, MySQL will truncate your data. You will want to acoid this. 3. Is one column with the gifs enough. Or should I add a autoincremented primary key? That is always a good idea, unless you use a foreign key which in turn will most probably be an autoincremented key itself. 4. Is it better to have a seperate table for this or, is it better to update my existing table, and add a blob column. Does it matter in terms of speed of queries? I would create a separate table. No, rather I would not store pictures in a table, as said. Werner Stuerenburg wrote: Generally, it is not advised to add pictures to tables. See http://www.bitbybit.dk/mysqlfaq/faq.html#storing_images We had this question here some days ago, so it may ge a good idea to discuss at length possible problems why people won't like this approach of storing pics as files. WARNING: this is _not_ MySQL specific. You may want to stop reading here. 2nd WARNING: I will also show what can be done with all that information to arrive at some kind of content management wizardry. After all, people do use MySQL to do something with it, and many seem to manage pictures. So here it goes. If you let people upload images with php (which is built in and really easy) you will receive the images in, say some sort of tmp dir. You will have to move them in your code to a separate storage dir, as php will automatically delete the tmp files (see manual). Now php is part of httpd and that runs as nobody, so it cannot write to that storage dir unless you open that dir to nobody. This will be ok as you use this dir only for the purpose of storing those third party images. You may protect it in addition with .htaccess or move it out of the normal dir tree if you are a little paranoid. Now you can store the images as files with no problem and only note the filename and type or such (for example comments of the user to the picture) in the database. When you upload, you move the file, so this is a good point to record the file in your table. Once you are at it, you can retrieve the dimensions of that image with php function getImageSize and store them in your table together with the type as well. So now you know everything about this file you need for inclusion in your html code. Hence you write yourself a function, say getImgCode, which produces the html tags from this info, so you can insert the whole stuff into your code without any further thought like ... ?php getImgCode(firstNameOfMyPicture) ? ... You may even go a step further if you are in at content production. Let's assume the user uploads any text and pictures. The user is instructed to embed their pics with special syntax like ... stuff stuff stuff *MyImageFirstName* stuff stuff stuff ... You later insert the image with $content = preg_replace(/\*(\w+)\*/e, getImgCode($1), $content); This example is taken from http://php.net/manual/en/ref.pcre.php (I developed a content management system along these lines on my own, but this is just stunning - an incentive to learn the art of regular expressions). Sie schrieben am Donnerstag, 19. Juli 2001, 19:42:08: Hi, I'm new to blobs. I want to create a seperate table that will hold blob's or pictures. Each picture will be a .gif and will not exceed 100k in size. each image will be called, ord.gif, bar.gif, cmi,gif, lax.gif, jfk.gif, ord.gif, etc. The questions I had were 1. what would the create table statment look like. 2. Should I use a longblob based on my 100k .gif size? 3. Is one column with the gifs enough. Or should I add a autoincremented primary key? 4. Is it better to have a seperate table for this or, is it better to update my existing table, and add a blob column. Does it matter in terms of speed of queries? Queries will be done via php. Thanks! Pete -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3,
Re: Backup of databases.
i cannot start my mysqld server on my Unix OpenBSD 2.9 Server, because i have a problem after i have restarted my server. So how do i take backups without connecting to the mysqld server, i have access to the files that is placed in /var/mysql but i cannot you mysqldump because of the server not is started and not can be started.. If your server is not running, your files in .../mysql/var will hopefully be in a good state (otherwise you have to run myisamchk anyway) and no changes are written to them. Fine. So you just copy all files to some other place. No dump necessary. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Please help - does changing the port the web server listens on affect mysql?
I am having a problem with inserting data into a table via a web form, which was working just fine prior to changing the port the web server is listening on from 80 to 8080. I can insert data via the mysql command line just fine, just not from the web form. Below are the forms and table def for reference. (freebsd4.2, apache 1.3.14, php4.0.3pl1, mysql Ver 11.15 Distrib 3.23.38, for -freebsd4.2 (i386) ) -- Chip This first one is the data input form... -- html head titleDealer Bulletins - Simrad, Inc/title /head body bgcolor=aqua ? if(isset($submit)): $db = mysql_connect(localhost, root); mysql_select_db(todaysnews, $db); $date = date(Y-m-d); $sql = insert into bulletin values (null,'$heading','$body','$bulletin_number','$bulletin_subject','$bulletin_from1','$bulletin_date','$bulletin_from2'); mysql_query($sql); print(h2The Data has been entered!/h2\n); print(strongYou can add another Dealer Bulletin below/strongbr /hr\n); endif; ? table summary= width=90% border=0 cellpadding=5 cellspacing=0 align=center tr td colspan=2 h2centerDealer Bulletins - Simrad, Inc/center/h2br / hr align=center noshade=noshade width=50% /br / h3Enter your Dealer Bulletin into the database/h3 All fields can be changed if this will not be a Dealer Bulletin, otherwise, change only where indicated.br / These fields match the header fields on the printed Dealer Bulletin. form action=bulletin_sorter.php method=post /td /tr tr td valign=bottom Heading:br / font size=-1(Change only if necessary)/fontbr / input type = text name=heading value=Dealer Bulletin - maxlength=48 /td td valign=bottom Bulletin Number:br / font size=-1(Change only the two center 0's)/fontbr / input type = text name=bulletin_number value=DB-00-01 maxlength=48 /tr tr td colspan=2 valign=bottom Bulletin Subject:br / font size=-1If the subject is longer than 60 characters you can force it to wrap with the following tag:br /lt;br /gt; The br stands for break, so this will force a line break. Just type in that tag wherever you want the line to break./fontbr / input type = text name=bulletin_subject maxlength=64 size=60 value=Overwrite this with the subject from printed Bulletin /td /tr tr td colspan=2 valign=bottom Bulletin From 1:br /select name=bulletin_from1 option value=Choose OneChoose One/option option value=Tom Burke, Product Support Mgr - Autopilots InstrumentationTom Burke, Product Support Mgr - Autopilots Instrumentation/option option value=Brian Vlad, Product Support Mgr - Plotter Radar ProductsBrian vlad, Product Support Mgr - Plotter Radar Products/option option value=Michael Hillers, Fisheries MgrMichael Hillers, Fisheries Mgr/option option value=David Parkinson, National Sales MgrDavid Parkinson, National Sales Mgr/option option value=John Caballero, General ManagerJohn Caballero, General Manager/option option value=Brian Staton, PresidentBrian Staton, President/option option value=Bruce Trimble, Operations ManagerBruce Trimble, Operations Manager/option option value=Phil Roberts, Service ManagerPhil Roberts, Service Manager/option /select /td /tr tr td valign=bottom Bulletin Date:br / font size=-1(Change only the 0's [Mo-Day] )/fontbr / input type=text name=bulletin_date value=00-00-2001 maxlength=15 /td td valign=bottom Bulletin From 2:br /select name=bulletin_from2 option value=Choose OneChoose One/option option value=David Parkinson, National Sales MgrDavid Parkinson, National Sales Mgr/option option value=John Caballero, General ManagerJohn Caballero, General Manager/option /select /td /tr tr td colspan=2Bulletin:br / br / textarea cols=80 rows=20 name=body wrap=virtual/textarea /td /tr tr td colspan=2 input type=submit name=submit value=Submit! input type=reset name=reset value=Start Over! /td /tr /table /form /body /html --- Now the table def - mysql describe bulletin; +--+-+--+-+-++ | Field | Type | Null| Key | Default | |Extra | +--+-+--+-+-++ | news_id | int(11)|| PRI| NULL| |auto_increment | | heading | varchar(48) | YES || NULL| || | body | text | YES | MUL | NULL| | | | bulletin_number | varchar(48) | YES || NULL|| | bulletin_subject | varchar(64) | YES | MUL | NULL|| | bulletin_from1 | varchar(64) | YES || NULL|| | bulletin_date| varchar(15) | YES || NULL|| | bulletin_from2 | varchar(64) | YES | | NULL|| +--+-+--+-+-++ - The bulletin
RE: UPDATEing values in SET columns
On 19-Jul-2001 Nick Brandon wrote:
Hi
I have been searching through the manual and the list archives for the last
few days regarding a problem I have with the SET column type.
I'm creating an app that uses a SET column as 'flags'. Different parts
within the application will check to see if certain 'flags' are enabled. As
I understand, the SET column uses bit representation internally.
My problem is updating the column with flags already set. Below is an
example:
The table is as follows:
CREATE TABLE users ...
user_id INT ...
user_flags SET('another','test','pass_renew','none') NOT NULL DEFAULT
'none'
...
When I update a record, I can only set the whole string not just the
individual flag.
i.e. This works fine...
UPDATE users SET user_flags = 'test, none' WHERE user_id = 1
How can I add (or remove) values within the SET column without affecting the
existing contents?
I've tried a number of ways with no success!!
For example
UPDATE users SET user_flags = CONCAT(user_flags,'pass_renew') WHERE user_id
= 1
Any help or pointers would be greatly appreciated.
So close!
UPDATE users SET user_flags = CONCAT(user_flags,',pass_renew') ...
Regards, ^
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: UPDATEing values in SET columns
On 19-Jul-2001 Nick Brandon wrote:
Hi
I have been searching through the manual and the list archives for the last
few days regarding a problem I have with the SET column type.
I'm creating an app that uses a SET column as 'flags'. Different parts
within the application will check to see if certain 'flags' are enabled. As
I understand, the SET column uses bit representation internally.
My problem is updating the column with flags already set. Below is an
example:
The table is as follows:
CREATE TABLE users ...
user_id INT ...
user_flags SET('another','test','pass_renew','none') NOT NULL DEFAULT
'none'
...
When I update a record, I can only set the whole string not just the
individual flag.
i.e. This works fine...
UPDATE users SET user_flags = 'test, none' WHERE user_id = 1
How can I add (or remove) values within the SET column without affecting the
existing contents?
I've tried a number of ways with no success!!
For example
UPDATE users SET user_flags = CONCAT(user_flags,'pass_renew') WHERE user_id
= 1
Any help or pointers would be greatly appreciated.
So close!
UPDATE users SET user_flags = CONCAT(user_flags,', pass_renew') ...
^
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
(53kr33t w0rdz: sql table query)
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Questions about extremely large database support
We are beginning a project and need to choose a database. We have been using MS Visual FoxPro, which is like mySQL in that it is very fast and ISAM-based, but is used more often as a file database rather than client/server. Unfortunately, we are quickly approaching FoxPro's 2GB table size limit, so we cannot continue using it. Our two most important requirements for the database engine are speed and scalability. We will be inserting probably 5,000,000 records per day into our database, and will maintain around 2TB of data. Of course, these figures will grow in time (probably about 40% per year). We will be accessing the data using custom C++ components, and at this stage, our data model/design is fairly flexible. We would like to be able to scale easily, potentially by splitting databases up across multiple machines. My questions are: Is mySQL up to such a task? I have been using mySQL for four years now, but have never used it in a project of this magnitude. We'll be handling financial data in the database, so integrity is important. Where can I find information about very large databases with mySQL? Is there a really efficient way to implement a function like indexseek() in FoxPro? This function will simply check an index to tell you if a record with that key exists. Sort of like select count(id) from Foo where id=1 except that it doesn't actually fetch the field value and it just checks the index file, not the data file. Thanks for your help. If you would prefer to take this thread offline from the list, you may e-mail me directly at [EMAIL PROTECTED] tw - Tom Wheeler Software Engineer Teralogix, Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Binlog has bad magic number [SOLVED]
For me, this problem was due to: This problem occurs when the my.cnf file on the master contains log-bin=/var/log/replication.log but just log-bin seems to work. On Mon, Apr 02, 2001 at 05:11:21PM -0400, Jim Ziegler wrote: What causes: 010402 17:08:56 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) in the err log of a replication slave? is it related to: 010402 17:10:34 create_table_from_dump::failed in handler::net_read_dump() 010402 17:10:34 fetch_nx_table: failed on create table when i try to: mysql load table aca from master; ERROR 1189: Net error reading from master -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- [EMAIL PROTECTED] (Jim Ziegler) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-magic number-fire your magician
Description: I am unable to get replication running. I have set up both master and slave systems with version 3.23.33-log of musql. I can do a load table from master but when I start the slave, all I get in the slave log is: 010410 16:37:24 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 010410 16:37:24 Slave: reconnected to master '[EMAIL PROTECTED]:3306',replication resumed in log 'FIRST' at position 4 010410 16:37:24 Error reading packet from server: Binlog has bad magic number, fire your magician (read_errno 0,server_errno=65535) and in the master log: 010410 16:35:583006 Connect[EMAIL PROTECTED] on 3007 Connect[EMAIL PROTECTED] on 3007 Quit 3006 Binlog Dum How-To-Repeat: see below Fix: This problem occurs when the my.cnf file on the master contains log-bin=/var/log/replication.log but just log-bin seems to work. However, how do you control the location and name of the log? (This may just be a documentation issue, but the error message is not very intuitive.) Submitter-Id: submitter ID Originator:Jim Ziegler Organization: [EMAIL PROTECTED] (Jim Ziegler) MySQL support: [none | licence | email support | extended email support ] Synopsis: replication-bad magic number-fire your magician Severity: critical Priority: Category: mysql Class: Release: mysql-3.23.36 (Source distribution) Environment: System: Linux jimz 2.2.19 #1 Sun Jun 24 15:06:27 EST 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20010319 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='-O2 -fomit-frame-pointer -g' CXX='g++' CXXFLAGS='-O2 -fomit-frame-pointer -g -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 14 Mar 28 11:57 /lib/libc.so.5 - libc.so.5.4.46 -rw-r--r--1 root root 589460 Mar 19 08:47 /lib/libc.so.5.4.46 lrwxrwxrwx1 root root 13 Jun 11 13:04 /lib/libc.so.6 - libc-2.2.3.so -rwxr-xr-x1 root root 1104456 May 28 18:49 /lib/libc-2.2.3.so -rw-r--r--1 root root 2522408 May 28 18:51 /usr/lib/libc.a -rw-r--r--1 root root 178 May 28 18:51 /usr/lib/libc.so lrwxrwxrwx1 root root 10 Nov 15 2000 /usr/lib/libc-client.a - c-client.a lrwxrwxrwx1 root root 18 Nov 15 2000 /usr/lib/libc-client.so - libc-client.so.4.7 -rw-r--r--1 root root 665260 Sep 1 2000 /usr/lib/libc-client.so.4.7 Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innobase --enable-static --enable-shared --with-raid --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-extra-charsets=all - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please help - does changing the port the web server listens on affect mysql?
MySQL knows nothing of the ports that your Web server may listen to. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 33 days, processed 260,996,108 queries (90/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: mysql.org
Fact MYSQL owns their trademark Fact, what NuShpere brought form MYSQL is irrelevant as loing as they are infrringing on the MYSQL Trademark...and they were going to do WORSE until the public heat. Until they apologies fo the GPL violation, and then the Trademark infringment, they are pound scum and deserve no support attention, or benifit of any doubt. Ruben I think you see evil people, conspiracies and other unwanted stuff when in fact there are only misunderstandings and opposing viewpoints. I'm with Bob Hall on this one. Excellent statement Bob! -S Their is no conpsirisy, there is only one company trying to steel the good name of another company through immoral (and illegal) activities. Nusphere has no justffication, defense or right to take a product and push it on the public through the use of some elses trusted trademark... It's not. There was an agreement. Nusphere paid money for that agreement. MySQL sold SOMETHING to them, that much is clear. Have you seen the agreement? Do you have 100% proof that MySQL did not sell the right to use their (yet to be approved) trademark!? Temporary or otherwise? What makes you think this is not a case of Swedish and American laws and/or cultures clashing? I do not think you have seen the agreement, and I do not think you have enough information to make a sound and unbiased judgement in this matter. You have a right to your own opinion, ofcourse, as long as you realize that they are just that - opinions. Not facts. Regards, -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: Questions about extremely large database support
Is mySQL up to such a task? I have been using mySQL for four years now, but have never used it in a project of this magnitude. We'll be handling financial data in the database, so integrity is important. I think so. You find impressive statements on the mysql site about speed size reliability incl. testimonials. Also, you may want to consider the new innobase table type - see statements at their site as well. Where can I find information about very large databases with mySQL? See above. Also you will find statements in the list archives lists.mysql.com, but you may have a harder time searching the appropriate posts. Is there a really efficient way to implement a function like indexseek() in FoxPro? This function will simply check an index to tell you if a record with that key exists. Sort of like select count(id) from Foo where id=1 except that it doesn't actually fetch the field value and it just checks the index file, not the data file. As far as I know that's exactly what MySQL does. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Questions about extremely large database support
Do not put tick by tick data in a database, The stuff is not relational, it is time series, FAME was one on the few that could deal it but I think it died. A database does not help research or organizing the data, it gets in the way. you would be better off timestamping the data to the millisecond and making a simple structure for trade and quote records that can run them together in time order and making a flat ACSII file for each symbol per day, depending on the access pattern use zlib to compress the file(s) after a few days(should get 8:1 compression and fast read access). You need a few custom filters if you do not want to pull back the whole symbol data for the day or to handle splits. Now using A database to mange the files and provide summary(open,close,high,low,etc...) information for screening is fine but not the raw data. MJM - Original Message - From: Tom Wheeler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 4:15 PM Subject: Questions about extremely large database support We are beginning a project and need to choose a database. We have been using MS Visual FoxPro, which is like mySQL in that it is very fast and ISAM-based, but is used more often as a file database rather than client/server. Unfortunately, we are quickly approaching FoxPro's 2GB table size limit, so we cannot continue using it. Our two most important requirements for the database engine are speed and scalability. We will be inserting probably 5,000,000 records per day into our database, and will maintain around 2TB of data. Of course, these figures will grow in time (probably about 40% per year). We will be accessing the data using custom C++ components, and at this stage, our data model/design is fairly flexible. We would like to be able to scale easily, potentially by splitting databases up across multiple machines. My questions are: Is mySQL up to such a task? I have been using mySQL for four years now, but have never used it in a project of this magnitude. We'll be handling financial data in the database, so integrity is important. Where can I find information about very large databases with mySQL? Is there a really efficient way to implement a function like indexseek() in FoxPro? This function will simply check an index to tell you if a record with that key exists. Sort of like select count(id) from Foo where id=1 except that it doesn't actually fetch the field value and it just checks the index file, not the data file. Thanks for your help. If you would prefer to take this thread offline from the list, you may e-mail me directly at [EMAIL PROTECTED] tw - Tom Wheeler Software Engineer Teralogix, Inc. [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Upgrade MySQL
Hi All, I need to upgrade a server running MySQL v.3.23.38 to .39 Specs: RedHat/Linux 6.2 i386 512RAM The only databases currently are the default 'test' and the 'mysql' db's no other db's created. The current variables show: basedir/ datadir /var/lib/mysql My question is, when upgrading and to replace the current version, I assume I would need to install using the paths,..correct?? Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. Any suggestion would be much appreciated :) THX's Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
unsure of performance vs. replication of data...
I have a general DB question, but since I'm using MySQL, I figure one of our friendly listreaders might be able to help me out. I have 4 tables, say table1-table4, and I need to get some data from table4 which relies on some values from table1. However, the only way I can get those table1 values, is by going through tables 2 and 3. So... the query, in essence, looks like: select table4.id from table1,table2,table3,table4 where table4.table3_id = table3.id and table3.table2_id = table2.id and table2.table1_id = table1.id and table1.value = VALUEIMLOOKINGFOR. now -- the reasons i have 4 tables such as this is each table holds a key peice of data. *BUT*, there's nothing from preventing me from adding a column to table4 called table1_id and doing something like select table4.id from table1,table4 where table4.table1_id = table1.id and table1.value = VALUEIMLOOKINGFOR my questions falls on the replication of data issue (and understand, a DB Guru I am not, but I've read Paul DeBois book and think i have a pretty fair handle of things). Anyway, since I can infer the data without having to replicate anything (ie: the first query) is it good DB practice that, if you are making this type of query, to go ahead of be able to reference the data directly (ie: the second query), even though table4 would, in essence, be storing the table1_id when it could be gotten via a query anyway? Am I making myself clear? I am trying to determine when it's ok to have extra columns the duplicate data you can get elsewhere but would make a query potentially faster (i believe) but the tables larger? If anyone can point me elsewhere as well... --jim -- And then there was one... - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Storing survey(s) data?
My client conducts a number of surveys or questionnaires for THEIR clients. There are several standard surveys, each with a different number of questions (from 20 up to 90). Question is, how store the data. Seems like the simple way would be to create a table with 100 fields and store the answers (plus metadata - survey #, timestamp, etc) there, each record using up as many fields as necessary. In this case I'd probably store the metadata in fields 1-10 (as needed) and begin the real data in field 11. Or could use one table per survey type - so that only data from the same list of questions goes into each table. Or could use a simpler table that stores only one answer per record (with a couple fields for metadata and one for the answer). Frankly dissociating the data so much scares me a bit, but this would seem to be the logical best choice - assuming nothing to go wrong. Any thoughts, warning, experiences on this matter. - And in a related question, what is the best form in which to EXTRACT the data for running into a desktop graphing program? Write to a file in a public directory? Thanks for any help, Nelson -- === Nelson Goforth Lighting for Moving Pictures phone: 01.303.322.5042 pager: 01.303.634.9733 resume: http://www.earthnet.net/~ngoforth/film - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Questions about extremely large database support
On Thu, Jul 19, 2001 at 11:30:31PM +0200, Werner Stuerenburg wrote: Is there a really efficient way to implement a function like indexseek() in FoxPro? This function will simply check an index to tell you if a record with that key exists. Sort of like select count(id) from Foo where id=1 except that it doesn't actually fetch the field value and it just checks the index file, not the data file. As far as I know that's exactly what MySQL does. That's correct. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 33 days, processed 261,277,659 queries (90/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: Please help - does changing the port the web server listens on affect mysql?
Congratulations to the Webby Award! MySQL knows nothing of the ports that your Web server may listen to. -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.org
At 21:28 01-07-19, you wrote: the same time, a NuSphere-controlled mysql.org doesn't strike me as a disaster, provided they can do it with out shooting themselves in the foot, as they are doing now. Nah There using it as a marketing ploy to dup the public. The should have released their GPLed extentions on NuShpere.com rather than maysql.org, but they are unwilling to do this because they feel they have the right to be seen as the originators of MYSQL. I think you see evil people, conspiracies and other unwanted stuff when in fact there are only misunderstandings and opposing viewpoints. I'm with Bob Hall on this one. Excellent statement Bob! -S Hum... How many did actually *see* the original MySQL.org site? I have a really hard time seeing how there could be any kind of misunderstanding behind the way it was designed. (or not designed, rather.) /Göran Lovén database, table, mysql --- G. Lovén GL Design Information Technologies email: mailto:[EMAIL PROTECTED] web:http://www.gldesign.se
Re: Upgrade MySQL
does someone have a windows based program to manage, create and edit a database abd table off line MikeBlezien wrote: Hi All, I need to upgrade a server running MySQL v.3.23.38 to .39 Specs: RedHat/Linux 6.2 i386 512RAM The only databases currently are the default 'test' and the 'mysql' db's no other db's created. The current variables show: basedir/ datadir /var/lib/mysql My question is, when upgrading and to replace the current version, I assume I would need to install using the paths,..correct?? Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. Any suggestion would be much appreciated :) THX's Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Upgrade MySQL
On Thu, Jul 19, 2001 at 04:47:29PM -0500, MikemickaloBlezien wrote: The only databases currently are the default 'test' and the 'mysql' db's no other db's created. The current variables show: basedir/ datadir /var/lib/mysql My question is, when upgrading and to replace the current version, I assume I would need to install using the paths,..correct?? You can. Or you can install anywehere else and just copy the data files from /var/lib/mysql to the new data dir when your're done. Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. Any suggestion would be much appreciated :) Use the MySQL-MAX binary from mysql.com rather than building your own. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 33 days, processed 261,298,544 queries (90/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
Left Join very sloooowwww..
Hi there, I am wondering if the Left Join syntax is a very inefficient query for MySQL (and other databases generally speaking..)??? I have a table which consits of a few tables from which the bigest table contains about 4500 records... Heres the scenario: I have 5 tables fom an ecommerce site: table 1 contains brands: eg Microsoft, Apple Macintosch etc etc table 2 contains a product: eg A Product named Operarting systems in which the table has a INT column to link it to brandname which goes with the product etc table 3 contains a article: eg Windows 95 and Windows 98, Windows NT which is linked to the product.. (Microsoft - Operating Systems - Windows 95, Windows 98 etc = table 1 - table 2 - table 3 When a article is ordered this is stored in the following way table 4 contains the basic order information (customer name, order amount way of payment etc) table 5 contains the articles ordered (Windows 95) I made a query which calculated the total amount of everything that is ordered the last 30 days per brandname.. This is done by linking table 5 to table 4 (I need to link it to table 4 because there is a status bit in table 4 which tells me if the order hasn't been cancelled..) I also link table 5 tot table 3, table 3 needs to be linked to table 2 and table 2 needs to be linked to table 1 to get the brand.. I add a sum in the query and group the data by brand because I want to now the totals for each brand.. Here is the query SELECT brand.brandname, Sum((productorders.quantity)*(productorders.price)) AS turnover from orders left join productorders on productorders.orderid = orders.id left join perfect_articles on productorders.ordernr = articles.ordernr left join products on products.id = articles.id left join brand on products.brand = brand.id where (productorders.date = DATE_FORMAT( DATE_SUB( NOW() , INTERVAL 30 DAY ) , '%Y-%m-%d' ) and productorders.date = DATE_FORMAT( DATE_SUB( NOW() , INTERVAL 0 DAY ) , '%Y-%m-%d' ) and orders.status != 2) GROUP BY brand.brandname ORDER BY turnover asc Almost all fields which are linked are INT or medium Int.. Only the productorders.ordernr field is an *varchar* in which the order code of the product is stored.. I know that this will probably delay a lot but it's not easy to change this and I did do some checks to see if this makes *very* huge differences but at the time it didn't look to make a lot of difference... I need to do the above query about 4 times for different intervals and in this case it then takes about 15 minutes to complete... (Pentium III 800 machine with 128 MB) Is there a more efficient way to link tables.. I also have this problem with a small search routine where I want to find a customer + order.. I have a separate customer database which I can link to the orders, but this +linking adds a very huge delay (about 15 seconds on a search).. When I just use the orders table (with no linking) because 99.99% of the cases we need to look up a customer who has placed an order the query is very fast... It looks that as soon as if I start to link a table with more than 1000 records the machine is having a hard time.. Is it better to use a where clause to link the tables..?? Thanks for any suggestions: Bye Bye David - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Upgrade MySQL
On Thu, 19 Jul 2001 15:50:13 -0700, Jeremy Zawodny [EMAIL PROTECTED] wrote: Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. Any suggestion would be much appreciated :) Use the MySQL-MAX binary from mysql.com rather than building your own. thanks Jeremy, appreciate the feedback. Would I just follow the Quick Install for the binary. I've only installed MySQL with the source in the past. Can you just briefly touch on why the binary is better then using the source?? :) Again,..much THX's Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
database server upgrade
We currently have a dedicate server for MySQL. The server is a dual pentium III (1Ghz) with 2GB of RAM in it. It also has 2 18GB 10,000 RPM drives in it arranged in a Raid 1 configuration (mirror). Sometime in the next 3-6 months we will be maxing out its capacity. (We were maxed out a few days ago, but we added 1GB of RAM and cached some query results). The system is currently running RedHat Linux 6.2. While there are some non-optimal queries and maybe some variable tuning that we can and should do, we will need to upgrade at some point and its not obvious to me what the upgrade path is. The axes of expansion I see are: 1) CPU speed (2 GHz processors?) 2) # of CPUs (quad processor, 8 processors?) 3) Multiple machines (replication) 4) More memory (current system maxes out at 4GB) 5) Different CPUs (SPARC, Alpha, IBM Power, HP-PA, Itanium) 6) Faster disks (15,000 RPM) 7) More disks (striping, different databases/tables on different disks, MySQL striping) 8) Switch some high contention tables to InnoDB, BDB or Gemini to avoid lock contention 9) Optimize server variables Which approach or combination of approaches is likely to double (quadruple?) our throughput at the best price performance? I have attached some info to help characterize our usage. mysql show status; +--++ | Variable_name| Value | +--++ | Aborted_clients | 9356 | | Aborted_connects | 0 | | Bytes_received | 483742044 | | Bytes_sent | 466908215 | | Connections | 346158 | | Created_tmp_disk_tables | 415975 | | Created_tmp_tables | 1908200| | Created_tmp_files| 164| | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 56073 | | Handler_read_first | 743133 | | Handler_read_key | 388810193 | | Handler_read_next| 987417906 | | Handler_read_prev| 319| | Handler_read_rnd | 31493284 | | Handler_read_rnd_next| 365353151 | | Handler_update | 27173091 | | Handler_write| 102767056 | | Key_blocks_used | 15582 | | Key_read_requests| 1535872968 | | Key_reads| 5560163| | Key_write_requests | 3216153| | Key_writes | 573114 | | Max_used_connections | 177| | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 1296 | | Open_files | 2180712| | Open_streams | 0 | | Opened_tables| 1277057| | Questions| 20072711 | | Select_full_join | 255969 | | Select_full_range_join | 32646 | | Select_range | 139809 | | Select_range_check | 0 | | Select_scan | 3192636| | Slave_running| OFF| | Slave_open_temp_tables | 0 | | Slow_launch_threads | 1 | | Slow_queries | 141| | Sort_merge_passes| 82 | | Sort_range | 1130288| | Sort_rows| 143848526 | | Sort_scan| 2073029| | Table_locks_immediate| 27157119 | | Table_locks_waited | 58498 | | Threads_cached | 0 | | Threads_created | 346157 | | Threads_connected| 57 | | Threads_running | 1 | | Uptime | 105090 | +--++ 54 rows in set (0.00 sec) mysql show variables; +-+-+ | Variable_name | Value | +-+-+ | ansi_mode | OFF | | back_log| 50
Sysdate????Date????Please help
Hiya Everyone, I have a small problem,I am a java programmer working for a small company, We have just been given project to build a greetings program for a website,thats no problem but one of the parameters is an option to send the greeting at a later date,not today. I have kinda worked out the logic in my head but I need to query the database for the system date and get a reply something like this 1 or 01 for the first and 2 or 02 for the second and so onand also for months(for january) 01 or 1 (for Feb) 02 or 2 and so on. The logic, I'm using a thread that will sleep for 23 hours and check the system/current date,month and then query the database for people who want to send their greetings on the same date,month and then connect to the smtp server etc...any ideas? ALL reply's are welcome,good or bad,abuses or hugs! :-) Cheers, -Ryan P.S I would really appreciate it if you could send your answers to [EMAIL PROTECTED] and the MySql list. Thanx in leaving let me give you something to cheer you up, A couple bought themselves a squirrel pet. Once they went and locked it up in the closet. In the night a thief penetrated into their house, but having heard the owners' car coming in, he hid in the closet. They came, undressed and went to bed. But in the middle of the night they were waked up by a scream. The husband opened the closet to see the man squirming on the floor. He picked up on the picture, bound him tightly and asked what made him holler so shrill. When your screwy squirrel took my ass for a hollow - I held out, when it took my testes for nuts - I gritted my teeth, but when it decided to carry the nuts into the hollow i cracked up. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: java.sql.SQLException: [TCX][MyODBC] Access denied for user...(Using password: No) message
If it is a TYPE IV driver means, ODBC won't come into picture. But the error string whatever you got shows that, you are trying to connect it through JDBC:ODBC bridge driver. Please refer to your driver manual for more information for making the connection with MySQL. If you are using mmmysql driver, please refer to the following link for more information. http://mmmysql.sourceforge.net/doc/mm.doc/book1.htm Thank you Venu Anuganti - Original Message - From: shane [EMAIL PROTECTED] To: Venu Anuganti [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 12:11 AM Subject: RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message Hi, the driver which i am using is type IV. do i still need to install myodbc? thks -Original Message- From: Venu Anuganti [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 2:04 PM To: shane Cc: [EMAIL PROTECTED] Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message Hi Shane To connect to MySQL using JDBC Driver, it depends up on the type of JDBC driver you are using. If you are using a JDBC-ODBC Bridge (TYPE 1 DRIVER) then you need MyODBC installed on the system and configured properly as explained in the earlier mail in the mysql list. Here is the link, which tells different types of JDBC drivers in the world. http://java.sun.com/products/jdbc/driverdesc.html or http://www.jguru.com/faq/view.jsp?EID=691 Let us know, what type of JDBC driver are you using to connect to MySQL ? Thank you Venu Anuganti - Original Message - From: shane [EMAIL PROTECTED] To: Venu Anuganti [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 10:39 PM Subject: RE: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message i am using the mmmysql jdbc driver, and i was wondering whether i need to install myodbc. i'm running mysql server on a linux machine and the binary version of the download from www.mysql.com does not include the odbc driver and the libraries required for myodbc. I'm running on a i686 but the rpm version they have is for i386 system thks shane -Original Message- From: Venu Anuganti [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 19, 2001 12:55 PM To: Luc Lalancette; [EMAIL PROTECTED] Subject: Re: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message Hi Luc Here is the common syntax, that is used as the connection string through JDBC-ODBC Driver. Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); String url = jdbc:odbc:TestDSN; Coonection con = DriverManager.getConnection(url,username,password); Before connecting, make sure you intslled the ODBC Driver and configured the DSN 'TestDSN' created in the ODBC DSN Administartor. Based on your error below, it looks you have the valid DSN, but you didn't supply the UID and PWD in the connection string. Thank you Venu Anuganti - Original Message - From: Luc Lalancette [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 18, 2001 3:02 PM Subject: java.sql.SQLException: [TCX][MyODBC] Access denied for user... (Using password: No) message I am starting using mysql and I made a java SimpleQuery servlet that is suppose to retreive one row from the database. However, when I try to connect I get that message from the Subject. I know I'm suppose to pass the password but can't seem to find a way of doing it. I was wondering if the problem was with those two lines or if it was in the tdx mysql driver default configuration in the ODBC. Class c = Class.forName(sun.jdbc.odbc.JdbcOdbcDriver); dbConn = DriverManager.getConnection(jdbc:odbc:TestDSN;); I would appreciate if someone could help me to get my connection going. Thank you very much Luc Lalancette - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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,
Re: mysql.org
Thomas J Keller wrote: The more I think about this, the more convinced I am that someone needs to offer the following observations: It is unfortunate that so many people within this community are so eager to assume the worst about a company, simply because they ARE a company. Not all corporations are Mickey$lu$h (I guess my biases in this regard are obvious), and not all corporate leaders are Bill Gates. Hello here is my observation: We the MySQL community are and have been treated exceptionally well and far beyond any other company I have heard of. What ticks us off is when our community is threatened by an organization posing to be the real thing. It's been a few months since I needed to visit the mysql web site. My heart dropped when I went to mysql.org and their was a new site were I had always gone for mysql. Then they wanted me to register. I figured the good old days of downloading mysql were gone and they sold out. I thought they were just like ORAC$$ and M$SQL. It wasn't until I searched the mailing list that I was able to find they were at mysql.com. Then I got ticked off for being betrayed ---or tricked. I use MySQL for personal use and do not have thousands of dollars to waste on a competitors sql server, nor the super computer needed to run those resource hogs. I think it is safe to say that we all feel like we are part of the MySQL project even though we are just end users. Better yet, MySQL is part of our lives. There is no freeware or shareware or GPL'ed software that even comes close to the PROFESSIONAL programming and support done by the MySQL team. I can do things with my C programming and MySQL that I could only imagine doing if MySQL didn't exsist as it does today. So, it wasn't that we were eager to assume the worst, but we felt our lively hood threatened right along side with MySQL AB. Some of us spend out lives at the keyboard. If they had a big bold statement on the top of their home page saying something like: We are supporting the MySQL community at mysql.com by offering commercial grade software bundles. Then right off the bat everyone would know: 1) they are not the real thing 2) you could go to mysql.com as you always did 3) if your boss or clients refuse to use gpl'd software then you might be able to talk them into getting this package. Then there would not have been the registration problem, nor the fee problem, and the only thing left would have been the domain name copyright and people probably wouldn't have gotten involved with it. John It's like that TV shopping channel that sent serious legal letters to every domain name that had a 3 letter match to their TV name and told them to stop using it. They said each domain name hurt their business and copyrights and bla bla bla. They took down many web sites. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Upgrade MySQL
MikemickaloBlezien [EMAIL PROTECTED] wrote: I need to upgrade a server running MySQL v.3.23.38 to .39 Specs: RedHat/Linux 6.2 i386 512RAM The only databases currently are the default 'test' and the 'mysql' db's no other db's created. It seems you have nothing worth keeping, unless you have users and privileges setup you don't want to have to recreate. If that's the case backup the database mysql by copying the directory or using mysqldump so you can copy that database or load it from the dump file after installing MySQL. The current variables show: basedir/ datadir /var/lib/mysql My question is, when upgrading and to replace the current version, I assume I would need to install using the paths,..correct?? Or use whatever paths you want and copy the mysql database to whatever directory you chose. Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. I don't know how the RPM version is configured, but you can't go wrong with the source distro since you'll have more control over configuration options. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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: Please help - does changing the port the web server listens on affect mysql?
That's what I expected, but haven't figured out the problem with the one database. I created another very simple database and form and can insert data from the web form with no problem. -- Chip Jeremy Zawodny wrote: MySQL knows nothing of the ports that your Web server may listen to. -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 33 days, processed 260,996,108 queries (90/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 -- Regards, -- Chip Wiegand CRW Computer Services www.wiegand.org [EMAIL PROTECTED] -- Web page design Consulting PC Repair -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
shutdown Mysql
On Unix is there another to shut down mysql, other than ps, then kill? tia (Obviously very new to mysql) Suu Quan Agilent Technologies Bldg 54, Post P4 (408)553-7155 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Storing survey(s) data?
Nelson Goforth [EMAIL PROTECTED] wrote: My client conducts a number of surveys or questionnaires for THEIR clients. There are several standard surveys, each with a different number of questions (from 20 up to 90). Question is, how store the data. Seems like the simple way would be to create a table with 100 fields and store the answers (plus metadata - survey #, timestamp, etc) there, each record using up as many fields as necessary. In this case I'd probably store the metadata in fields 1-10 (as needed) and begin the real data in field 11. If you need to add/edit/delete a question you'll have to modify the table structure and you'll likely have to modify all of your queries. Or could use one table per survey type - so that only data from the same list of questions goes into each table. That's not really any better. Now if you add a survey you need to add a new table and if you change a question you may have to change it in *many* tables...that is, if you're surveys are sharing some questions. Or could use a simpler table that stores only one answer per record (with a couple fields for metadata and one for the answer). Frankly dissociating the data so much scares me a bit, but this would seem to be the logical best choice - assuming nothing to go wrong. I recommend 3 tables. Table 1 stores the questions - question_id and question_name. Table 2 stores the surveys - survey_id, question_id. Table 3 stores the survey results - user_id (or simple sequential id), survey_id, question_id, response. If each question has set choices you'll need a 4th table which will have question_id, choice_id, choice_description and instead of response in Table 3 you'll use choice_id. Using this structure the system will be extremely flexible and queries to report statistics will be *much* simpler and changing the data in the application will be trivial. Any thoughts, warning, experiences on this matter. - And in a related question, what is the best form in which to EXTRACT the data for running into a desktop graphing program? Write to a file in a public directory? Sorry, your questions are too vague for me to answer. -- Steve Werby President, Befriend Internet Services LLC http://www.befriend.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
prob install 3.23.39 (config.log attached)
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.
configure:812: checking host system type
configure:833: checking target system type
configure:851: checking build system type
configure:886: checking for a BSD compatible install
configure:939: checking whether build environment is sane
configure:974: checking whether make sets ${MAKE}
configure:1020: checking for working aclocal
configure:1033: checking for working autoconf
configure:1046: checking for working automake
configure:1059: checking for working autoheader
configure:1072: checking for working makeinfo
configure:1174: checking whether to enable maintainer-specific portions of Makefiles
configure:1216: checking whether build environment is sane
configure:1233: checking whether make sets ${MAKE}
configure:1301: checking for gawk
configure:1333: checking for gcc
configure:1446: checking whether the C compiler (cc -pthread -O4 -ansi_alias
-ansi_args -fast -inline speed -speculate all -arch host ) works
configure:1462: cc -pthread -o conftest -O4 -ansi_alias -ansi_args -fast -inline speed
-speculate all -arch hostconftest.c 15
configure:1488: checking whether the C compiler (cc -pthread -O4 -ansi_alias
-ansi_args -fast -inline speed -speculate all -arch host ) is a cross-compiler
configure:1493: checking whether we are using GNU C
configure:1502: cc -pthread -E conftest.c
configure:1521: checking whether cc -pthread accepts -g
configure:1557: checking for c++
configure:1589: checking whether the C++ compiler (cxx -pthread -O4 -ansi_alias
-ansi_args -fast -inline speed -speculate all -arch host ) works
configure:1605: cxx -pthread -o conftest -O4 -ansi_alias -ansi_args -fast -inline
speed -speculate all -arch hostconftest.C 15
./configure: cxx: not found
configure: failed program was:
#line 1600 configure
#include confdefs.h
int main(){return(0);}
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: Upgrade MySQL
You may want to have a look at http://www.mysqlfront.de/ Sie schrieben am Freitag, 20. Juli 2001, 20:29:32: does someone have a windows based program to manage, create and edit a database abd table off line -- Herzlich Werner Stuerenburg _ ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409 http://pferdezeitung.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 manager
does anyone have a program to create and manage a database with out being connected to a server - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ADV Buy 3 get 4th FREE! Shop online at Wonderful Gift Solutions
To be removed from this list just hit reply or send an e-mail to the link below with REMOVE in the subject line. Wonderful Gift Solutions P.O. Box 496 Glenwood, N.J. 07418 1-888-777-5692 Remove e-mail address: [EMAIL PROTECTED] Shop on or offline at Wonderful Gift Solutions http://www.wonderfulgiftsolutions.com There is a 30 day money back return policy on all items!! Except certain Jewelry items. Buy three get a fourth item FREE! Just think up to 25% off every item. In addition to all other discounts on individual pieces or groups. Simply order 3 items, and we'll give you ONE MORE FREE! All we ask is that the price of your free item not exceed the price of the lowest priced item you purchase. For example: if you purchased 3 items priced at $28.95, $39.95 and $18.95, your free item must not exceed $18.95. Incidentally, you can purchase any number of groups of 3 and still get one free! Order 6 items, get 2 free, order 9 items and get 3 free, etc. http://www.wonderfulgiftsolutions.com Are your tired of going to the mall, downtown or that specialty store? Only to have to struggle to find a parking spot, mull through the crowds and put up with snooty clerks and salespeople, especially during the holidays??!! Then RELAX!! Just go online to Wonderful Gift Solutions where there are tons of gifts for everyone! Order a FREE catalog online which has over 3000 items! http://www.wonderfulgiftsolutions.com All online shopping is done in a secure environment and your items are shipped right to your door! We take ALL major credit cards, Amex, Master Card, Visa and Discovery! In addition, you can Fax, mail or phone in your orders if you feel uncomfortable ordering online! Wonderful Gift Solutions provides a solution for any gift idea you may have! A piece of glass art for the mantel, a gift for Mom on Mother's day, a jewelry gift for her on your anniversary, a bracelet for Valentine's day, a novelty gift for a coworker. Impress your boss with an executive gift, a necklace or charms for her just because. Any holiday gift idea that comes to mind. In fact, a Christmas gift for everyone on your list! Wonderful Gift Solutions offers a wide range of quality merchandise, which is reasonably priced and will fit anyone's budget. Such as, glass figurines, jewelry, candles, bird houses, holiday gifts and much more! The gifts offered are constantly updated with items from around the world. So keep coming back! Browse our site, which has a selection of items from our Catalog, or order a FREE catalog, which has over 3000 items, by calling 1-888-777-5692, or order one online! Enjoy your shopping experience! http://www.wonderfulgiftsolutions.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql.org
You are, of course, welcome to your opinion, and to the expression of said opinion. You are also liable to be judged on the basis of that expression, and frankly, your expression leaves me wondering about your wisdom and your analytical capabilities, not to mention your social skills. What - you work for NuShpere. My analysis of this affair is correct. It comes down to trust I TRUST MONTY. I do not trust Brit, and man who has abused the GPL, abused the MYSQL trademark, and broke the trust between the two partners. What do I base that trust on 6 years of contant communication and dependency of the MYSQL staff and my PERSONAL relationship with Monty and his Fella's as he called them. Furthmore, the assumption that under any condition NuSphere BROUGHT the right to open up shop directly under the MYSQL name and conduct independent sales, promotion and business, is damn off the wall, far fetched, and ridicules to asume, that you'd have to be a complete utter moron to beleive this report, and in addition, the report should be playing tomorrow afternoon on the Opra show, and be reported right next to the alien abduction story in the National Enquirer. Furthermore, their behavior secondary to this, and the proposition that they opened the mysql.org site as a Community site flies right in the face of the proposition forwarded by NuShpere that they opened the site with full rights to do so under previous agreements because they purchased control over the MYSQL trademark because they did in secret, then protested they had they right ot, after saying it was a communitee site, and then finally, they release they're Gemini code on it, only after 100's of people complained that they were violating the GPL. This is NOT the actions of an honest person...period... No We need NuSphere to admit their wrongs, make a blanket apology, and everyone can call a no harm no foul, and forget it happened. Ruben - End of forwarded message from Brooklyn Linux Solutions CEO - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 JDBC
i am facing the same problem Kenneth explane above, can anyone tell me what to do ? PS: i tried to use the mysql port number as well Kenneth Fleck wrote: Hi ! I have a problem accessing a MySQL DB from a java-app. On commandline I can get in without problems with mysql db -uuser -ppass but with the following connect String: jdbc:mysql://localhost/db?user=userpassword=pass I get strage result. First time execution error message (from SQLException caught) is: Invalid authorization specification: Keine Zugriffsberechtigung für Benutzer: 'user@127.0.0.1'. (Verwendetes Passwort: Ja) after starting again, the message is : Invalid authorization specification: Keine Zugriffsberechtigung für Benutzer: 'user@'. (Verwendetes Passwort: Ja) and it stays like that, the first will come again after not touching the system for a while. Has anybody got an idea ? --- Kenneth - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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!? Get your free @yahoo.com address at http://mail.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: Upgrade MySQL
On Thu, Jul 19, 2001 at 05:57:15PM -0500, MikemickaloBlezien wrote: On Thu, 19 Jul 2001 15:50:13 -0700, Jeremy Zawodny [EMAIL PROTECTED] wrote: Also it's been recommended to install with the Source instead of the Binary. We want to enable BDB tables handlers also. Any suggestion would be much appreciated :) Use the MySQL-MAX binary from mysql.com rather than building your own. thanks Jeremy, appreciate the feedback. Would I just follow the Quick Install for the binary. I've only installed MySQL with the source in the past. Can you just briefly touch on why the binary is better then using the source?? :) The binary is known to be good (or at least known). It is a static binary built with a specific compiler, specific compiler options, and specificly tuned libraries. The MySQL team has put a lot of working into getting it right so that the rest of us don't have to. If you run into a problem using their binary, it's often easier for them to track down what went wrong. If you build it yourself and have problems, they have to rule out things which may be related to how you built the binary. Plus, the binary is a piece of cake to install. I use the binary tarballs, since I'm not an RPM fan. Just untar it and have a look at the installation notes. But you may (or may not) want to wait for 3.23.40 which will be out soon, I believe. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 -- NEW MySQL 3.23.29: up 33 days, processed 261,910,062 queries (90/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: Left Join very sloooowwww..
I'm by no means an expert, but I made left joins with 2 tables with about 4500 and 2800 records each. They were basically structured quite the same. I had response time at about .7 seconds on the larger and and 15 seconds on the other - which kept me wondering why that should be. I found that the slower table had about twice as many columns, so I split that table to test if that would make any difference, but it did not; I left only the necessary fields for the query in the basic table, so it had less fields than the faster table. Then I found http://www.mysql.com/doc/S/e/Searching_on_two_keys.html MySQL doesn't yet optimize when you search on two different keys combined with OR (Searching on one key with different OR parts is optimized quite good): which is exactly what I did, so I left it at that, as I needed that query for administration purposes only. All other queries, including those with LEFT JOINS, only take fractions of seconds, sometimes only a few milliseconds. On every single page, I do a lot of queries, and the pages load very fast (unless there is no bottleneck somewhere out there). It is really amazing, and php has to load a huge program and compile it etc. I didn't implement any of the cool stuf that's available for performance. Well, it wasn't always that way... Want to know how I found out? I implemented a stopwatch mechanism, so that I could track any single codeline down, mysql queries, too, of course. So I found that queries are done very fast. Of course, I work with mod_php and mysql_pconnect. Along the way, I made some really surprising discoveries. With this mechanism at hand, I could examine the running, live system without disturbing normal users and eventually I would find out... And I did. None of that stuff related to MySQL. I had some php construction which consumed time excessively. Once I knew, it wasn't that hard to construct fast solutions for the same job. I didn't examine each and everything yet, but I know that if I want to, it is no problem any more. But how come you need MINUTES BTW: if you want to know about that stopwatch mechanism, I can elaborate on that, maybe pm, as this doesn't really relate to MySQL well. Sie schrieben am Freitag, 20. Juli 2001, 00:49:23: Hi there, I am wondering if the Left Join syntax is a very inefficient query for MySQL (and other databases generally speaking..)??? I have a table which consits of a few tables from which the bigest table contains about 4500 records... Heres the scenario: I have 5 tables fom an ecommerce site: table 1 contains brands: eg Microsoft, Apple Macintosch etc etc table 2 contains a product: eg A Product named Operarting systems in which the table has a INT column to link it to brandname which goes with the product etc table 3 contains a article: eg Windows 95 and Windows 98, Windows NT which is linked to the product.. (Microsoft - Operating Systems - Windows 95, Windows 98 etc = table 1 - table 2 - table 3 When a article is ordered this is stored in the following way table 4 contains the basic order information (customer name, order amount way of payment etc) table 5 contains the articles ordered (Windows 95) I made a query which calculated the total amount of everything that is ordered the last 30 days per brandname.. This is done by linking table 5 to table 4 (I need to link it to table 4 because there is a status bit in table 4 which tells me if the order hasn't been cancelled..) I also link table 5 tot table 3, table 3 needs to be linked to table 2 and table 2 needs to be linked to table 1 to get the brand.. I add a sum in the query and group the data by brand because I want to now the totals for each brand.. Here is the query SELECT brand.brandname, Sum((productorders.quantity)*(productorders.price)) AS turnover from orders left join productorders on productorders.orderid = orders.id left join perfect_articles on productorders.ordernr = articles.ordernr left join products on products.id = articles.id left join brand on products.brand = brand.id where (productorders.date = DATE_FORMAT( DATE_SUB( NOW() , INTERVAL 30 DAY ) , '%Y-%m-%d' ) and productorders.date = DATE_FORMAT( DATE_SUB( NOW() , INTERVAL 0 DAY ) , '%Y-%m-%d' ) and orders.status != 2) GROUP BY brand.brandname ORDER BY turnover asc Almost all fields which are linked are INT or medium Int.. Only the productorders.ordernr field is an *varchar* in which the order code of the product is stored.. I know that this will probably delay a lot but it's not easy to change this and I did do some checks to see if this makes *very* huge differences but at the time it didn't look to make a lot of difference... I need to do the above query about 4 times for different intervals and in this case it then takes about 15 minutes to complete... (Pentium III 800 machine with 128 MB) Is there a more efficient way to link tables.. I also have this problem with a small search routine
