RE: select problem with not equal syntax
Found solution, the right syntax is: SELECT hl7incom.id FROM hl7incom, pid_segment LEFT JOIN pid_segment ON hl7incom.id = pid_segment.id WHERE hl7incom.msg LIKE '%PID%' AND pid_segment.id IS NULL; Cheers for try of help, Karsten Same result, also if I do not define unique index. Just a suggestion: SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND not(pid_segment.id = hl7incom.id) GROUP BY hl7incom.id; Otherwise my only other suggestion would involve using the 'NOT IN' logic, but I think that might be too convoluted for your needs. No way, I've already tried this. I have two tables CREATE TABLE pid_segment ( id INT NOT NULL UNIQUE PRIMARY KEY, msg TEXT) TYPE=INNODB CREATE TABLE hl7incom( id INT NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY REFERENCES pid_segment (id). msg TEXT, time TIMESTAMP NOT NULL) TYPE=INNODB There are few data stored in both tables. Now I will select new messages from hl7incom, where hl7incom.id is not equal pid_segment.id and store this id, msg in pid_segment. With query... SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND pid_segment.id != hl7incom.id GROUP BY hl7incom.id; Try SELECT hl7incom.id FROM hl7incom, pid_segment WHERE hl7incom.msg LIKE '%PID%' AND pid_segment.idhl7incom.id GROUP BY hl7incom.id; John Coder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL a quotas?
On Mon, Sep 30, 2002 at 10:24:42AM -0400, Bill Leonard wrote: on 9/30/02 9:47 AM, Victoria Reznichenko at [EMAIL PROTECTED] wrote: It's not a so good decision and not suitable if database contains InnoDB tables, but you can't limit database size only with MySQL. Is this a planned feature anywhere on the MySQL roadmap for 4.x? A database size quota? It's not terrible difficult to implement outside of MySQL as a separate daemon. I've got a design in mind, but need to protoype it one of these days. It'd probably be 300-500 lines of Perl at the most. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 55 days, processed 1,162,276,712 queries (240/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
Retrieving Table Schema
Hi! Michael == Michael J Fuhrman [EMAIL PROTECTED] writes: Michael Hello All, Michael Suggestions Feedback Requested: Michael I'm looking for a solution that will not lock a table, yet allow me to Michael retrieve the: Michaelfield name, field type as integer, field size, and other attributes Michaelof each column from a table. The ways to do this are: - SELECT * from table_name where 0; - SHOW COLUMNS from table_name; - SHOW CREATE TABLE from table_name. Michael The Issue: cut Michael An important part of the test is to be able to retrieve the table's schema. Michael I can't explain why without releasing proprietary corporate information, all Michael I can say is that it's needed. What I can tell you is that when I retrieve Michael it with a mixed case table name, it prevents me from deleting the table. We just fixed a bug in MySQL when using mixed table names. This is fixed in the upcoming 3.23.53 and 4.0.4 MySQL versions. Regards, Monty - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Retrieving Table Schema
Hi! Michael == Michael J Fuhrman [EMAIL PROTECTED] writes: Michael Hello All, Michael Suggestions Feedback Requested: Michael I'm looking for a solution that will not lock a table, yet allow me to Michael retrieve the: Michaelfield name, field type as integer, field size, and other attributes Michaelof each column from a table. The ways to do this are: - SELECT * from table_name where 0; - SHOW COLUMNS from table_name; - SHOW CREATE TABLE from table_name. Michael The Issue: cut Michael An important part of the test is to be able to retrieve the table's schema. Michael I can't explain why without releasing proprietary corporate information, all Michael I can say is that it's needed. What I can tell you is that when I retrieve Michael it with a mixed case table name, it prevents me from deleting the table. We just fixed a bug in MySQL when using mixed table names. This is fixed in the upcoming 3.23.53 and 4.0.4 MySQL versions. Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ 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: Unknown auto ROLLBACK
What is that option? Never saw it before. If this is the case indeed, how do you change its value? Thanks again. Noor -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 4:52 PM To: Noor Dawod Cc: MySQL List Subject: Re: Unknown auto ROLLBACK Because you did not set autocommit on? Noor Dawod wrote: Hi all, I found out today that MySQL is adding a 'ROLLBACK' command to each session connecting to it, without explicitly ordering this. This is new since we never had this behavior before. Why is this happening, and how can I revert to the old beahvior (each command sent is carried out and performed instantly, with no rollback option.) Please CC me in your replies. Thanks in advance. Noor - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 AUTO-INC lock timeouts / deadlocks on inserts (using
Thank you for your response. We tried your example here on shell and it looks like InnoDB locks the table only for the first transaction after db startup and this lock is held for the whole transaction (like you observed). But, contrary to this scenario we have experienced some strange behavior, such that table level AUTO-INC locks are being applied REPEATEDLY (duration of ENTIRE transaction), even though the database has undergone multiple, commited transactions previously. This behavior is very prominent when you have multiple processes with overlapping, concurrent transactions and you are executing DML statements in a loop (I tried a delay after each iteration to prevent a locks being held too long, but it did not seem to work). It so happens that the lock is not released by the process until the transaction is complete. I am attaching a simplified perl script (concur-test.pl) and a shell script (go.sh) used to invoke these processes (URL: http://www.geocities.com/yoda_pk/innodbchk.tar.gz ). Please create the table (SQL provided), run the shell script and observe the InnoDB monitor log for deadlocks. We have observed various AUTO-INC table level locks which are applied every time we run the tests (without restarting the mysql database engine) and these locks are held for the whole transaction and not just one particular statement, EVERY time. PLATFORM: RH Linux 7.3/MySQL-Max-3.23.52-1/Perl DBI Looking forward to your observations. regards, IOD Subject: Re: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using Iod, - Original Message - From: iod iod [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Thursday, September 26, 2002 8:14 AM Subject: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using We have been using InnoDB with MySQL (MySQL-Max-3.23.52-1) for transaction support in some complex situations in our application when maintaining consistency is critical. Recently we did some stress testing by simulating 10 concurrent users (perl/DBD) doing large number of inserts on a few tables. Note that these tables have indexed fields which are 'INT' 'AUTO_INCREMENT'. We are getting lock timeouts on concurrent inserts (in concurrent TRANSACTIONS) very frequently, although it works fine for a single non-concurrent transaction. Removing transactions eliminates the deadlocks in concurrent runs, but we cannot guarantee the consistency of our data. RELEVANT 'my.cnf' SETTINGS: innodb_lock_wait_timeout = 50 innodb_thread_concurrency = 2 (to reduce thread contention) When we enabled InnoDB Monitor we saw messages like the following: INSERT INTO BasketItems(BalQuantity, ... --- TRX HAS BEEN WAITING 46 SEC FOR THIS LOCK TO BE GRANTED: TABLE LOCK table ca3/BasketItems trx id 0 26561327 lock_mode AUTO-INC waiting At times there are around 4 to 5 such simultaneous waits in the log and ultimately the lock times out and the process terminates. After reading the docs, it seems like InnoDB applies a table level lock on the table and so other inserts get blocked. But, considering the time a process has to wait ( 50s) it looks like the locks are being held for a very long time. According to the InnoDB documentation (http://www.innodb.com/ibman.html#InnoDB_auto_inc): When accessing the auto-increment counter InnoDB uses a special table level lock AUTO-INC lock which it keeps to the end of the current SQL statement, not to the end of the transaction. Is it possible that the locks are being held for the WHOLE transaction instead of just THAT SQL statement? Is it because InnoDB's implementation of AUTO-INC locks needs to be more efficient? the auto-inc locks are necessary because MySQL binlogging assumes that auto-inc values for a single SQL statement are determined by the auto-inc value of the first insert in that statement. If you suspect that there is a bug and the auto-inc lock is held longer, you should look at InnoDB Lock Monitor output. But also look at possible other bottlenecks. Log flushes, fsync, etc. I tested this now. Note that after a table creation or a mysqld startup, the very FIRST insert to the table acquires a next-key lock which is held for the duration of the whole transaction. But subsequent inserts only acquire the AUTO-INC lock, which is held only for the duration of the SQL statement. User 1: heikki@hundin:~/mysql-max-3.23.52-pc-linux-gnu-i686/bin mysql test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 3.23.52-max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql set autocommit = 0; Query OK, 0 rows affected (0.00 sec) mysql insert into kkk(b) values (100); Query OK, 1 row affected (0.00 sec) mysql commit; Query OK, 0 rows affected
mysql++ optimize 4 gcc3.2
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi .. I have a question about mysql++. give it a version of mysql++ that is optimize for the gcc 3.2 Version or have someone a tip to compile that with the gcc 3.2 ?? Thanks a lot - -- Markus Schnelle - Email: [EMAIL PROTECTED] ICQ: 63 70 67 35 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE9mVT+h6Sm0pGHy68RAiXvAKCYckT5HcbP0bG3D9AdlrqEyBuVKgCeLgLB tMLuh5G63Zr3T1CvGpl2TL0= =We7X -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: Replication
hi Victoria, I stopped both mysql in master and slave. Then I put in the server id for both master and slave, start the master then the slave. Is it okay? Thanks, Chee Peng - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 30, 2002 10:37 PM Subject: re: Re: Re: Replication CP, Monday, September 30, 2002, 3:48:31 AM, you wrote: C The Master's server id is 1 while the slave's server id was set to 5. There C is no problem for the slave to establish connection to the master. However, C the slave complains that error reading packet from server, the reason is C misconfigured-master, server id was not set and this messages keep on C repeating. Did you set up server-id for master from the very outset or you set up the one after master has been started? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[Q] Replication temporary tables (fwd)
sql,query Hello, All! Why is temporary tables replecated? Is it true? Best regards. ___ Andrey Kotrekhov [EMAIL PROTECTED] ISP Alkar Teleport ÔÅÌ. +380 562 34-00-44 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Compilation options of rpm packages
Hi all. Any of MySQL AB team could explain the options used in the compilation of rpm packages for Linux? Thanks in advance. Iago. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Archives are where (was Re: Filemaker database to MYSQL)
Chuck Amadi asked Has anyone created a plugin or script that will allow me to convert my filemaker database to MYSQL Check the archives. There has been some discussion of this in the past. Has anyone got a link to this archive as I have a Filemaker Pro 5 Works Database that I would like to migrate to Mysql So Please point me in the right direction. Let me see. http://www.mysql.com/ Yep. Several links to Documentation. http://www.mysql.com/documentation/index.html Uh, huh, a link to MySQL Mailing List Archives. Brings us to http://lists.mysql.com/ It's searchable, and right now it seems the search function is not overworked. Oh. There's also the big collection of archives at http://marc.theaimsgroup.com/ if MySQL's own archives seem too crowded or something. Lately, there are quite a few sites archiving mailing lists. You can problem find many of them by searching at google. Speaking of google, google has archived several MySQL newsgroups. I don't know the relationship between MySQL AB and the MySQL newsgroups. http://groups.google.com/groups?hl=enlr=ie=UTF-8group=mailing.database You'll probably need to search back several months, if my memory serves me. Hmm. You might even want to plug the string mysql filemaker in at google's search page, too. Sorry I can't be of more help. I don't use Filemaker myself. Before you criticize someone, you should walk a mile in their shoes. That way, when you criticize them, you're a mile away, and you have their shoes. Yeah, but they probably have your shoes. ;-) -- Joel Rees [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: MySQL 4.03 and merge tables: bug with BETWEEN
Tac, Friday, September 27, 2002, 10:34:46 PM, you wrote: T We're having a problem with a huge merge table and BETWEEN. The same query T in MySQL 3, using an identical (binary) copy of the database, takes a T fraction of a second, in MySQL 4.03 it runs without stopping. T The query is a simple Select * from my_merge_table where my_code BETWEEN T '2026676653' AND '2026676655' T If I run a simple script that loops through the invidiual tables of the T merge table, using the same query (with each table), the response is very T fast. And running the query when the operator is '=' instead of BETWEEN, T everything is fine, e.g. T Select * from my_merge_table where my_code = '2026676653' T Expanding out the BETWEEN still causes the query to run forever: T Select * from my_merge_table where my_code = '2026676653' AND my_code T = '2026676655' I tested it on the not so big merge table (~ 150 000 rows) and it worked fine with BETWEEN. T Another bug that's in MySQL 3 (that I haven't checked in MySQL 4) is trying T to use a merge table where one of the tables has no rows. When we create a T merge table, we go through each table first and check to make sure it has T something in it, otherwise, the merge table is created ok but queries T against it return no rows. Of course MySQL will check every table to check if it contains matched rows. T Finally, does anyone know if you can now use fulltext indexes with a merge T table? We're not yet (since it's not supported), but I did see that on the T to-do list. Full-text search still works only on MyISAM tables. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: Re: Re: Replication
CP, Tuesday, October 01, 2002, 11:29:30 AM, you wrote: C I stopped both mysql in master and slave. Then I put in the server id for C both master and slave, start the master then the slave. Is it okay? Yes. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: MySQLGUI: Win32 zipped binary seems corrupted
Pavel, Monday, September 30, 2002, 9:04:32 PM, you wrote: PH I've just tried to download the Win32 binaries of the MySQLGUI tool. PH I recieved about 50kB. When I tried to unpack the archive, PH WinCommander told me, that the zip archive is corrupted. I've just downloaded MySQLGUI and unzipped without any problem. Try to download it from other mirror. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 1064 ...
hi,
got a little problem during learning mysql :
have made a file called create_member.sql, looks like this here :
CREATE TABLE member
{
last_name VARCHAR(20) NOT NULL,
first_name VARCHAR(20) NOT NULL,
suffix VARCHAR(5) NULL,
expiration DATE NULL DEFAULT '-00-00',
email VARCHAR(100) NULL,
street VARCHAR(50) NULL,
city VARCHAR(50) NULL,
state VARCHAR(2) NULL,
zip VARCHAR(10) NULL,
phone VARCHAR(20) NULL,
interests VARCHAR(255) NULL
}
then I tried :
mysql samp_db -u root -p create_member.sql
and get the following message :
[papabaer@hanna papabaer]$ mysql samp_db -u root -p create_member.sql
Enter password:
ERROR 1064 at line 1: You have an error in your SQL syntax near '{
last_name VARCHAR(20) NOT NULL,
first_name VARCHAR(20) NOT NULL,
suffix VAR' at line 2
now I got a liitle hickup, because don't know, whats happen - don't know why
this error-message
am using MySQL-3.23.47-5mdk on a mdk 8.2 box
hope anyone can help ? this example is from Paul DuBois's book Mysql
thanks and bye
hans
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: ERROR 1064 ...
hans,
Tuesday, October 01, 2002, 1:02:02 PM, you wrote:
hp got a little problem during learning mysql :
hp have made a file called create_member.sql, looks like this here :
hp CREATE TABLE member
hp {
hp last_name VARCHAR(20) NOT NULL,
hp first_name VARCHAR(20) NOT NULL,
hp suffix VARCHAR(5) NULL,
hp expiration DATE NULL DEFAULT '-00-00',
hp email VARCHAR(100) NULL,
hp street VARCHAR(50) NULL,
hp city VARCHAR(50) NULL,
hp state VARCHAR(2) NULL,
hp zip VARCHAR(10) NULL,
hp phone VARCHAR(20) NULL,
hp interests VARCHAR(255) NULL
hp }
hp then I tried :
hp mysql samp_db -u root -p create_member.sql
hp and get the following message :
hp [papabaer@hanna papabaer]$ mysql samp_db -u root -p create_member.sql
hp Enter password:
hp ERROR 1064 at line 1: You have an error in your SQL syntax near '{
hp last_name VARCHAR(20) NOT NULL,
hp first_name VARCHAR(20) NOT NULL,
hp suffix VAR' at line 2
hp now I got a liitle hickup, because don't know, whats happen - don't know why
hp this error-message
You should use '(', ')' instead of '{','}'.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Testing New Install
DeNewbie, Monday, September 30, 2002, 9:36:03 PM, you wrote: D I am a MySQL newbie and i am somewhat confused. Firstly did I make a mistake running mysql_install_db and afterwards running the commands; D /usr/bin/mysqladmin -u root password 'new-password' D mysqladmin -u pazin1 sqlpass D and; D /usr/bin/mysqladmin -u root -h cords-orj86jfje password 'new-password' D mysqladmin -u pazin1 -h hostpass D After inputting these passwords as I was told by mysql_install_db was this absolutely necessary or did I make my life more difficult as a newbie. Anyway after doing that I followed more D instructions from p.115 of my MySQL Reference manual written by Mr.Widenius. From your advice I was able to get some results for the mysqlshow command; I don't know where the test database came D from I did not see it from the result in my Reference Manual; Database 'test' is created by default. If you don't need the one, you can drop it. [skip] D then when I enter what one person told me to enter I get this; D cords-orj86jfje:/usr/bin # mysqlshow -u pazin1 -p sqlpass D Enter password: D mysqlshow: Access denied for user: 'pazin1@localhost' (Using password: YES) D cords-orj86jfje:/usr/bin # D (regardless of what password I entered I was continously kicked out) But you didn't set up password for user 'pazin1'. D mysqladmin -u pazin1 sqlpass The above isn't correct for setting up password. D I would also like use the mysqladmin version command to see what pops up but I simply get no results no matter what I type in; D cords-orj86jfje:/usr/bin # mysqladmin version D cords-orj86jfje:/usr/bin # mysqladmin version -u hostpass D cords-orj86jfje:/usr/bin # mysqladmin version -u pazin1 D cords-orj86jfje:/usr/bin # mysqladmin version -u sqlpass D cords-orj86jfje:/usr/bin # mysqladmin version -u pazin1 -p sqlpass no results means that you didn't get any errors, any output etc, right? D I would also like to know how to shut down the mysql server,how do i do this, it does not seem to want to shut down; D cords-orj86jfje:/usr/bin # mysqladmin -u pazin1 shutdown D cords-orj86jfje:/usr/bin # safe_mysqld D [1] 1404 D cords-orj86jfje:/usr/bin # A mysqld process already exists As I understand you didn't create user 'pazin1'. By default MySQL gives permissions to user 'root' and anonymous user. Anonymous user means that any user can connect to the MySQL server, but it has permissions only on the database 'test' and doesn't have permissions to shutdown MySQL server. So, MySQL still is running. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
security vulnerability
Description: Any user in mysql can create as many databases as he wants. Create a user with 1 database, and let him create database with name my_data_base. Log into mysql console as user and run command: CREATE DATABASE my?data?base; New database will be created and user can create tables and use it as normal database. You can also create my?data_base, my_data?base, or try to use *,$, #, a-z, A-Z and other symbols instead of underlines _ ... I've just tried to log into MySQL console as usual non-privileged user with N,N,N,N... permissions in mysql.user and tried to create some base with another names -- no permissons error. However I COULD create 5 databases with names similar to my_data_base... I can operate them (as this user) without problems. Seems like huge hole in our MySQL (or MySQL at all). How-To-Repeat: Fix: Submitter-Id: submitter ID Originator: Organization: Plesk Inc, MySQL support: [none | licence | email support | extended email support ] Synopsis: Any user in mysql can create as many databases as he wants. Severity: critical Priority: high Category: mysql Class: Release:mysql-3.23.46 (Source distribution) Environment: System: Linux abe.plesk.ru 2.4.7-10 #1 Thu Sep 6 17:27:27 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 2731 (Red Hat Linux 7.1 2.96-98) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i586 -fPIC' CXX='c++' CXXFLAGS=' -O2 -march=i386 -mcpu=i586 -fPIC' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 áÐÒ 18 21:36 /lib/libc.so.6 - libc-2.2.4.so -rwxr-xr-x1 root root 1282588 óÅÎ 5 2001 /lib/libc-2.2.4.so -rw-r--r--1 root root 27304836 óÅÎ 5 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 óÅÎ 5 2001 /usr/lib/libc.so lrwxrwxrwx1 root root 10 éÀÌ 23 23:58 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --without-x --disable-assembler --disable-shared --enable-large-files --without-perl --without-debug --without-bench --without-docs --with-readline --with-mysqld-user=mysql --with-low-memory --prefix=/usr/local/psa/mysql --with-named-curses-libs=/usr/lib/libncurses.a --with-named-z-libs=/usr/lib/libz.a - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: granting FILE privileges
Mark, Monday, September 30, 2002, 5:48:59 PM, you wrote: MH +-+ MH | Grants for [EMAIL PROTECTED] | MH +-+ MH | GRANT SELECT, FILE ON *.* TO 'username'@'host-name.domain' IDENTIFIED BY PASSWORD 'cryptedfooey'| MH | GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'host-name.domain' | MH +-+ MH I had added the select,file permissions by hand to user. Privileges is OK, I tested SELECT INTO OUTFILE with the same privileges and it workes like a charm. 3.23.36 is a bit outdated and since that time there have been fixed some bugs related to the GRANT/REVOKE. Could you upgrade MySQL server and check if the problem still exists? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Security vulnerability
Hi! On Oct 01, Plesk Support wrote: Any user in mysql can create as many databases as he wants. Create a user with 1 database, and let him create database with name my_data_base. Log into mysql console as user and run command: CREATE DATABASE my?data?base; New database will be created and user can create tables and use it as normal database. You can also create my?data_base, my_data?base, or try to use *,$, #, a-z, A-Z and other symbols instead of underlines _ ... I've just tried to log into MySQL console as usual non-privileged user with N,N,N,N... permissions in mysql.user and tried to create some base with another names -- no permissons error. However I COULD create 5 databases with names similar to my_data_base... I can operate them (as this user) without problems. Seems like huge hole in our MySQL (or MySQL at all). No, it is not. As noted in the manual (Access Control, Stage 2: Request Verification section), mysql.db and mysql.host tables accept wildcards in Db and Host fields of either table. We will add a note to GRANT section to make it more clear, thank you for the hint. 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: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using
IOD,
thank you for the bug report. I was able to repeat the problem with you
scripts. The bug was that InnoDB failed to release at an SQL statement end
such AUTO-INC locks which were only granted after a lock wait. They were
only released at the transaction commit.
Since AUTO-INC locks normally are held for a short time, AUTO-INC lock waits
are rare, and many tests fail to notice this bug. Only under a stress test
like the one you wrote this bug becomes visible.
Below is a patch which fixes the bug.
Best regards,
Heikki
Innobase Oy
sql query
ChangeSet
1.1201 02/10/01 13:47:58 [EMAIL PROTECTED] +1 -0
lock0lock.c:
Fix bug: the AUTO-INC lock was held to the end of trx if it was granted
after a lock wait
innobase/lock/lock0lock.c
1.16 02/10/01 13:47:39 [EMAIL PROTECTED] +13 -0
Fix bug: the AUTO-INC lock was held to the end of trx if it was granted
after a lock wait
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: heikki
# Host: hundin.mysql.fi
# Root: /home/heikki/mysql
--- 1.15/innobase/lock/lock0lock.c Sun Aug 11 18:34:57 2002
+++ 1.16/innobase/lock/lock0lock.c Tue Oct 1 13:47:39 2002
@@ -1863,6 +1863,19 @@
ut_ad(mutex_own(kernel_mutex));
lock_reset_lock_and_trx_wait(lock);
+
+ if (lock_get_mode(lock) == LOCK_AUTO_INC) {
+
+ if (lock-trx-auto_inc_lock != NULL) {
+ fprintf(stderr,
+ InnoDB: Error: trx already had an AUTO-INC lock!\n);
+ }
+
+ /* Store pointer to lock to trx so that we know to
+ release it at the end of the SQL statement */
+
+ lock-trx-auto_inc_lock = lock;
+ }
if (lock_print_waits) {
printf(Lock wait for trx %lu ends\n,
- Original Message -
From: iod iod [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, October 01, 2002 11:10 AM
Subject: Re: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using
Thank you for your response.
We tried your example here on shell and it looks like InnoDB locks the
table only for the first transaction after db startup and this lock is held
for the whole transaction (like you observed).
But, contrary to this scenario we have experienced some strange behavior,
such that table level AUTO-INC locks are being applied REPEATEDLY (duration
of ENTIRE transaction), even though the database has undergone multiple,
commited transactions previously. This behavior is very prominent when you
have multiple processes with overlapping, concurrent transactions and you
are executing DML statements in a loop (I tried a delay after each iteration
to prevent a locks being held too long, but it did not seem to work). It so
happens that the lock is not released by the process until the transaction
is complete.
I am attaching a simplified perl script (concur-test.pl) and a shell
script (go.sh) used to invoke these processes (URL:
http://www.geocities.com/yoda_pk/innodbchk.tar.gz ). Please create the table
(SQL provided), run the shell script and observe the InnoDB monitor log for
deadlocks. We have observed various AUTO-INC table level locks which are
applied every time we run the tests (without restarting the mysql database
engine) and these locks are held for the whole transaction and not just one
particular statement, EVERY time.
PLATFORM: RH Linux 7.3/MySQL-Max-3.23.52-1/Perl DBI
Looking forward to your observations.
regards,
IOD
Subject: Re: InnoDB AUTO-INC lock timeouts / deadlocks on inserts
(using
Iod,
- Original Message -
From: iod iod [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, September 26, 2002 8:14 AM
Subject: InnoDB AUTO-INC lock timeouts / deadlocks on inserts
(using
We have been using InnoDB with MySQL (MySQL-Max-3.23.52-1)
for transaction
support in some complex situations in our application when
maintaining
consistency is critical.
Recently we did some stress testing by simulating 10
concurrent users
(perl/DBD) doing large number of inserts on a few tables. Note
that these
tables have indexed fields which are 'INT' 'AUTO_INCREMENT'.
We are getting lock timeouts on concurrent inserts (in
concurrent
TRANSACTIONS) very frequently, although it works fine for a
single
non-concurrent transaction. Removing transactions eliminates the
deadlocks
in concurrent runs, but we cannot guarantee the consistency of
our data.
RELEVANT 'my.cnf' SETTINGS:
innodb_lock_wait_timeout = 50
innodb_thread_concurrency = 2 (to reduce thread contention)
When we enabled InnoDB Monitor we saw messages like the
following:
INSERT INTO BasketItems(BalQuantity, ...
--- TRX HAS BEEN WAITING 46 SEC FOR THIS LOCK TO BE
GRANTED:
TABLE LOCK table ca3/BasketItems trx id 0 26561327
lock_mode AUTO-INC
waiting
How to find whether a key is fulltext
Greetings.. I am doing show keys from db.tablename but how can I know whether the key if fulltext or not. I get to know the key is unique or not by checking Not_Unique column in the returned resultset. How to find a key is fulltext. Thx Insane sql,query,mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL
What are the advantages of Mysql over sql or microsoft access. Thanks Stella - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 dies at startup after upgrade form 3.23 to 4.0.3
Description: I had a working install of mysql 3.23 in /usr/bin and /var/lib/mysql. I installed 4.0.3 to /usr/local/mysql and can't get it to run. I followed the installation instructions to the T. When I run '/usr/local/mysql/bin/mysqld_safe' I get: Starting mysqld daemon with databases from /usr/local/mysql/data 021001 08:53:00 mysqld ended The old mysql still works fine (/usr/bin/safe_mysqld). How-To-Repeat: I only have to try to run /usr/local/mysql/bin/mysqld_safe to get the same results. Fix: Not known Submitter-Id: submitter ID Originator:[EMAIL PROTECTED] Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: mysql dies when starting Severity: critical Priority: medium Category: mysql Class: support Release: mysql-4.0.3-beta (Official MySQL binary) Environment: Intel Celeron, SuSE 7.2 System: Linux freakshow 2.4.4-4GB #1 Fri May 18 14:11:12 GMT 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/local/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/local/lib/gcc-lib/i686-pc-linux-gnu/3.3/specs Configured with: ./configure Thread model: posix gcc version 3.3 20020901 (experimental) Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=pentiumpro ' CXX='gcc' CXXFLAGS='-O2 -mcpu=pentiumpro -felide-constructors' LDFLAGS='-static' LIBC: -rwxr-xr-x1 root root 1343073 May 11 2001 /lib/libc.so.6 -rw-r--r--1 root root 24539184 May 11 2001 /usr/lib/libc.a -rw-r--r--1 root root 178 May 11 2001 /usr/lib/libc.so Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --with-server-suffix= --enable-thread-safe-client --enable-local-infile --enable-assembler --with-other-libc=/usr/local/mysql-glibc --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared 'CFLAGS=-O2 -mcpu=pentiumpro ' 'CXXFLAGS=-O2 -mcpu=pentiumpro -felide-constructors' CXX=gcc LDFLAGS=-static - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Trapping error thru eval is not working?
Anyone has any experience of trapping error using DBI-mySQL.
The following code is not trapping the error. it is producing system
generated error.
$memberId='2a';
my($memberId)=@_;
my($sql)= select member_id from members
where member_id != . $memberId;
my $sth = $dbh-prepare($sql) || die Error . $DBI::errstr;
eval { $sth-execute() } ;
print Error while calculating : $@) if $@;
while (my $ref = $sth-fetchrow_hashref()) { ...
it gives the output which does not have my message Error while cqalculating
..
[Tue Oct 1 05:53:27 2002] C:\Inetpub\intranet\dev\cgi-bin\Score.pl:
DBD::mysql:
:st execute failed: Unknown column '2a' in 'where clause' at
C:\Inetpub\intranet
\dev\cgi-bin\Score.pl line 25.
Content-type: text/html
H1Software error:/H1
PRE Error Unknown column '2a' in 'where clause' at
C:\Inetpub\intranet\dev\cgi
-bin\Score.pl line 25.
/PRE
P
For help, please send mail to this site's webmaster, giving this error
message
and the time and date of the error.
[Tue Oct 1 05:53:27 2002] C:\Inetpub\intranet\dev\cgi-bin\Score.pl: Error
Unkn
own column '2a' in 'where clause' at
C:\Inetpub\intranet\dev\cgi-bin\Score.pl li
ne 25.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: LOAD command
The SERVER needs to be able to read the file, and I doubt very much that mysql has read permissions here. Jim Bahr wrote: Hello I am trying to use the LOAD command and not having much success. My host company is using version mysql 3.23.51. I am sshing into server, starting mysql and getting a mysql prompt. I have a database called login, and have made an empty table called logintest. I want to load it with data from a text file (downacct.txt). The text file is in a dir. called websites (the higest permission level I have on this shared server) I use the following commands USE login; LOAD DATA INFILE '/home/cbslink/websites/downacct.txt' INTO TABLE login.logintest; And get the following; ERROR 1105: File '/home/cbslink/websites/downacct.txt' not found (Errcode: 13) Any ideas? Is there another way I can move this large amount of data into a table? Thanks ahead of time Jim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: RE: RE: date column
Tewfic, Tuesday, October 01, 2002, 12:21:09 AM, you wrote: TK Hello, I have a table that keeps track of people and their office visits. TK This table will have duplicates since people will visit the office more than TK once... TK How can I get a list of people and the most recent time they've visited the TK office? TK Currently, I use TK select * from table_name where date '2002-06-18'; TK but that gives me a list that includes duplicate people, if I use 'group by TK name' it give me the first listing of that person, which may not be the most TK recent... SELECT *, MAX(date) FROM table_name WHERE date '2002-06-18' GROUP BY name; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: LOAD command
Jim, Tuesday, October 01, 2002, 4:01:18 PM, you wrote: JB I am trying to use the LOAD command and not having much success. My host JB company is using version mysql 3.23.51. I am sshing into server, JB starting mysql and getting a mysql prompt. I have a database called JB login, and have made an empty table called logintest. I want to load it JB with data from a text file (downacct.txt). The text file is in a dir. JB called websites (the higest permission level I have on this shared JB server) JB I use the following commands JB USE login; JB LOAD DATA INFILE '/home/cbslink/websites/downacct.txt' INTO TABLE JB login.logintest; JB And get the following; JB ERROR 1105: File '/home/cbslink/websites/downacct.txt' not found JB (Errcode: 13) JB Any ideas? Is there another way I can move this large amount of data JB into a table? $ perror 13 Error code 13: Permission denied MySQL doesn't have permissions on that file. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: How to find whether a key is fulltext
Insanely, Tuesday, October 01, 2002, 3:49:10 PM, you wrote: IG I am doing show keys from db.tablename but how can I know whether the key if IG fulltext or not. I get to know the key is unique or not by checking IG Not_Unique column in the returned resultset. IG How to find a key is fulltext. Use SHOW INDEX FROM table_name http://www.mysql.com/doc/en/SHOW.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MYSQL
What do the logs say? Stella Chipfupa wrote: What are the advantages of Mysql over sql or microsoft access. Thanks Stella - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: mysql dies at startup after upgrade form 3.23 to 4.0.3
jschleigh, Tuesday, October 01, 2002, 4:06:15 PM, you wrote: jahdc I had a working install of mysql 3.23 in /usr/bin and /var/lib/mysql. I installed 4.0.3 to /usr/local/mysql and can't get it to run. I followed the installation instructions to the jahdc T. When I run '/usr/local/mysql/bin/mysqld_safe' I get: jahdc Starting mysqld daemon with databases from /usr/local/mysql/data jahdc 021001 08:53:00 mysqld ended jahdc The old mysql still works fine (/usr/bin/safe_mysqld). How-To-Repeat: jahdc I only have to try to run /usr/local/mysql/bin/mysqld_safe to get the same results. Look at the error log file to see the causes of failed start. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to find whether a key is fulltext
At 18:19 +0530 10/1/02, Insanely Great wrote: Greetings.. I am doing show keys from db.tablename but how can I know whether the key if fulltext or not. I get to know the key is unique or not by checking Not_Unique column in the returned resultset. SHOW KEYS shows this information in the Index_type column. How to find a key is fulltext. Thx Insane sql,query,mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: A FAQ type question, but not in the FAQ - How to change my hostname, but not make replication puke
Hi, The mysql master wasn't restricting the slave by ip. But thanks, Eric At 10:28 AM 9/30/02 -0500, gerald_clark wrote: You need to grant privileges on the master to the new slave machine. http://www.kwinternet.com/eric (250) 655 - 9513 (PST Time Zone) Inquiry is fatal to certainty. -- Will Durant - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Japanese Charset
I was not aware that you were running VB. In perl and PHP we have a function do do this for us. in perl: $qtext=$dbh-quote($text); $dbh-execute(insert into mytable set myvariable = $qtext); The above quote() function will put a \ in fronnt of all the special characters listed in the manual. These in clude '\ and the hex 00 character. If the VB library you are using does not have a similar function, you should write one. You are welcome. Dawn Friedland wrote: I found a solution!!! ***Replace all backlashes with two backslashes.*** (The hex value of the backslash is 0x5c, see Joel Rees' previous emails for an explanation on how multibyte Japanese characters contain the hex value 0x5c and that MySQL uses that value as an escape character.) VBscript used prior to submitting data to database: szJapaneseText = replace(szJapaneseText, \,\\) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Please respond to the list. It sounds like the server does not like one of the options in your my.cnf file, and is printing a syntax/options list. Stella Chipfupa wrote: The logs are listing the features of mysql but there is no comparison. -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 3:32 PM To: Stella Chipfupa Cc: [EMAIL PROTECTED] Subject: Re: MYSQL What do the logs say? Stella Chipfupa wrote: - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Lost Connection to MySQL Server During Query
Hi, I am getting the following error: [TCX][MyODBC] Lost Connection to MySQL Server During Query My code is simply dumping an IP Address to the database... at the most 10 lines of code. Any ideas what is causing this error? I have searched on line and have not found much help. Thanks in advanced! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
gerald_clark wrote: What do the logs say? Stella Chipfupa wrote: What are the advantages of Mysql over sql or microsoft access. Pet peave: the product being refered to is Microsoft SQL Server, not SQL. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Get the total of a feild
Hi, I wanting to know what the sql statement is that will let me get the total of database. The feild is amount. I have tried a couple of sql statement and have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost. Chuck Payne Magi Design - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Corrupted Table (?)
All, I have a table which was accessible for the last couple years but is now inaccessible after performing a simple alter table command. There are approx. 10 tables in this database on which the same alter table command was given (alter table table_name add glperiod varchar (3) null first;). All of these tables are O.K. (and were correctly altered) except 1. What happens is that whenever I try to perform an SQL command against this table (called codeprojects), either MySQL hangs (at the command prompt) or my perl script hangs in the $sth-execute($sql) statement. Like I said, all of these methods, etc. worked on this table in the past and still work on the rest of the tables. I've tried, restarting MySQL (which seemed to work at first but now does not), dropping and rebuilding the table (it hangs on the drop command), copying a working copy of the three table files from a backup database, deleting the three files and starting over again. Nothing has worked so far. Any ideas?? OS: Redhat 7.1 Linux MySQL: 3.23.41 Thanks, Phil P.S. My team members are big fans of MySQL and are using it exclusively for our web systems. Keep up the GREAT work!! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: re: granting FILE privileges
But root user is able to perform the write to file w/o issue. I wonder what the problem could be. I will upgrade to 3.23.52 but I don't think it will fix the problem. Is there anything else it could be? -- Mark P. Hennessy [EMAIL PROTECTED] On Tue, 1 Oct 2002, Victoria Reznichenko wrote: Date: Tue, 1 Oct 2002 14:16:02 +0300 From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: re: re: granting FILE privileges Mark, Monday, September 30, 2002, 5:48:59 PM, you wrote: MH +-+ MH | Grants for [EMAIL PROTECTED] | MH +-+ MH | GRANT SELECT, FILE ON *.* TO 'username'@'host-name.domain' IDENTIFIED BY PASSWORD 'cryptedfooey'| MH | GRANT ALL PRIVILEGES ON databasename.* TO 'username'@'host-name.domain' | MH +-+ MH I had added the select,file permissions by hand to user. Privileges is OK, I tested SELECT INTO OUTFILE with the same privileges and it workes like a charm. 3.23.36 is a bit outdated and since that time there have been fixed some bugs related to the GRANT/REVOKE. Could you upgrade MySQL server and check if the problem still exists? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How to find whether a key is fulltext
Greetinsg... When I am doing show index from db.tablename, the columns I am gettings are - Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment Which one of these will tell me whether a key is fulltext or not. Rgds Ritesh SQLyog ( http://www.webyog.com ) The Definative GUI for MySQL - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Insanely Great [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 7:16 PM Subject: Re: How to find whether a key is fulltext At 18:19 +0530 10/1/02, Insanely Great wrote: Greetings.. I am doing show keys from db.tablename but how can I know whether the key if fulltext or not. I get to know the key is unique or not by checking Not_Unique column in the returned resultset. SHOW KEYS shows this information in the Index_type column. How to find a key is fulltext. Thx Insane sql,query,mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Japanese Charset
gerald_clark wrote: $qtext=$dbh-quote($text); $dbh-execute(insert into mytable set myvariable = $qtext); The above quote() function will put a \ in fronnt of all the special characters listed in the manual. These in clude '\ and the hex 00 character. FWIW, before anyone copies and pastes that you should use (as I'm sure Gerald actually does): execute(insert into mytable set myvariable = \$qtext\); so that there are quotes around your variable when you insert it into the DB and if there are spaces within your data (even accidentally), it won't try to parse the data as part of the query; UPDATE MyTable SET Name = Michael Babcock WHERE ID = 4; will get you some errors, for the people who like examples. I've also had the occasional UPDATE MyTable SET Name = WHERE ID = 4; which is also avoided by always quoting variables. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Privileges for CREATE TEMPORARY TABLE?
What privileges do I need for creating a TEMPORARY table? I seem to have locked myself out of this - and yet I can create permanent tables, which seems the wrong way round. N:\mysql -ualec Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1121 to server version: 4.0.2-alpha-max-nt Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql show grants for alec ; ++ | Grants for alec@% | ++ | GRANT ALL PRIVILEGES ON 'test'.* TO 'alec'@'%' | | GRANT ALL PRIVILEGES ON 'alec'.* TO 'alec'@'%' | ++ 2 rows in set (0.00 sec) mysql use alec ; Database changed mysql create table perm (col int) ; Query OK, 0 rows affected (0.02 sec) mysql create temporary table temp (col int) ; ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO) mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: How to find whether a key is fulltext
Insanely, Tuesday, October 01, 2002, 6:22:47 PM, you wrote: IG When I am doing IG show index from db.tablename, the columns I am gettings are - IG Table IG Non_unique IG Key_name IG Seq_in_index IG Column_name IG Collation IG Cardinality IG Sub_part IG Packed IG Comment IG Which one of these will tell me whether a key is fulltext or not. Index_type contains this info. For example mysql show index from articles\G *** 1. row *** Table: articles Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: id Collation: A Cardinality: NULL Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 2. row *** Table: articles Non_unique: 1 Key_name: title Seq_in_index: 1 Column_name: title Collation: A Cardinality: NULL Sub_part: NULL Packed: NULL Null: YES Index_type: FULLTEXT Comment: *** 3. row *** Table: articles Non_unique: 1 Key_name: title Seq_in_index: 2 Column_name: body Collation: A Cardinality: NULL Sub_part: 1 Packed: NULL Null: YES Index_type: FULLTEXT Comment: 3 rows in set (0.00 sec) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: re: re: granting FILE privileges
Mark, Tuesday, October 01, 2002, 5:50:15 PM, you wrote: MH But root user is able to perform the write to file w/o issue. MH I wonder what the problem could be. MH I will upgrade to 3.23.52 but I don't think it will fix the problem. MH Is there anything else it could be? As far as I remember somebody posted about the same problem on the same version (3.23.36) but he declined to answer and I don't know what the problem was. If upgrade doesn't help could you send me your grant tables for testing? It may be a bug in MySQL. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Drop Index - Error 28
Hi List I have a table with 90 Millions records and 8 indexes (75GB). I am trying to drop one of them but I get an errorcode 28 (no space left on device). df- v gives me an extra 27% of free space. My questions: Does MySQL use temporary areas to drop indexes and for what ? Is there a way to tell to MySQL to ignore this ? Thanks in advance Oswaldo Castro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Japanese Charset
It is already quoted. That's the point. Michael T. Babcock wrote: gerald_clark wrote: $qtext=$dbh-quote($text); $dbh-execute(insert into mytable set myvariable = $qtext); The above quote() function will put a \ in fronnt of all the special characters listed in the manual. These in clude '\ and the hex 00 character. FWIW, before anyone copies and pastes that you should use (as I'm sure Gerald actually does): execute(insert into mytable set myvariable = \$qtext\); so that there are quotes around your variable when you insert it into the DB and if there are spaces within your data (even accidentally), it won't try to parse the data as part of the query; UPDATE MyTable SET Name = Michael Babcock WHERE ID = 4; will get you some errors, for the people who like examples. I've also had the occasional UPDATE MyTable SET Name = WHERE ID = 4; which is also avoided by always quoting variables. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?
Hi, I'm a MySQL Newbie and am working on my first real project. The project involves removing the Access database off of our system and using MySQL in its place. Here is what happens now with this database The Unix machine writes information to the end of a text file every time an invoice is processed. This text file is FTP'd every 10 minutes over to our server. Access starts up and querys all the data and puts it into the proper tables. (Currently there are 15,000+ records and this has only been running for 6 months so you can see the need to rethink this process.) This process allows our shipping computers, using OBDC to connect to the access database where they can pull the information into the fields (name, address, service type etc) Anyway, here is where I stand now. I have built the MySQL server and it has been up and running for 3 weeks now and seems stable. I have installed MyODBC on the shipping computers and they connect. My question is what type of driver do I need to put on the Unix machine to make it where it can write insert statements directly to the database? Thanks, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: FileMaker Pro Schema Export?
From: Chuck Payne [EMAIL PROTECTED] Question are you want to take your data from Filemaker to Excel? No, I want to just go from FileMaker to MySQL, period. Forever. End of story. rantI'm tired of paying FileMaker Tax every year. (The version upgrade went from $149 to $199 this year.) I'm tired of fighting my way through endless sequences of modal dialogs, to do something that should be one line of SQL. I'm tired of the high-cost (and subsequent upgrade churn) of third party tools that are necessary for things as trivial as parsing strings or putting up custom dialogs. I'm tired of the baroque and resource-hungry way you have to put live content on a website./rant After spending several days searching for something on the Internet, I spent a whole day trying to make a general solution. I now have a script that will generate a skeleton CREATE TABLE command that I then go tune up by hand. My script traverses the table for each Text or Number column, and attempts to dimension it properly based on data in the table. I then go back and change some VARCHARs to TEXT, INTS to other numerics as needed, etc. and add PRIMARY KEY, KEY, and FULLTEXT statements It's still quicker to simply key-in schemas for smaller tables, but this has helped port a few really wide tables. The next task is to chop those into suitable 2nd normal form bits that can be JOINed as needed... :-( I'd post the script here, except you need an expensive third-party plug-in to get textual scripts IN or OUT of FileMaker! :-( I'd be glad to import the script into an empty database for anyone interested. Since FileMaker doesn't have variables, you'll have to add a few globals to your table to make it work. -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Store pictures in DB (load_file() revisited)
Greetings,
just saw a message with an example of inserting a BLOB
value using load_file(). Can't get load_file() to
work:
mysql select load_file('/home/alex/post.html') from
test;
+---+
| load_file('/home/alex/post.html') |
+---+
| NULL |
+---+
1 row in set (0.00 sec)
/home/alex/post.html exists, is small (~1k) and
world-readable. load_file() still returns NULL. Same
if I try to insert an existing file into a table.
I am on Linux 2.4.10 (SuSE), MySQL 3.23.52.
Thanks for any suggestions,
__
Do you Yahoo!?
New DSL Internet Access from SBC Yahoo!
http://sbc.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
Help on SQLyog
Dear Listers: I've installed MySQL over my Linux (RedHat 7.3) and SQLyog over my laptop. When I start SQLyog and type in the mySQLHostAddress: 10.0.5.210 User Name: root Password: Port: 3306 Itis giving me the error: Host 'kevin.sitesmith.com' is not allowed to connect to this MySQL server. Do I need to setup or change anything on MySQL DB in order for this connection to go through ? Thanks --Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
install mysql on osx 10.2
Hi, I am looking for some help installing mysql I have downloaded a copy and have it on my desktop , and well I am sorta wondering where to go from here. Because the instructions are too vague for me, as a newbie to mysql please assist james - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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_OPT_CONNECT_TIMEOUT
If MYSQL_OPT_CONNECT_TIMEOUT is set before mysql_connect() or mysql_real_connect() and the value is set to zero, what is the expected behavior? (Reason: PHP now does this as the default.) Sincerely, Steven Roussey http://Network54.com/?pp=e - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: FileMaker Pro Schema Export?
On Tuesday, October 1, 2002, at 10:25 24h, Jan Steinman wrote: From: Chuck Payne [EMAIL PROTECTED] Question are you want to take your data from Filemaker to Excel? No, I want to just go from FileMaker to MySQL, period. Forever. End of story. If you export a FileMaker database using 'Merge' you get a delimited text file with the first row being the column names. A program could be created to use this first row as column names to create a table. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.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
Exporting and overwriting file
Hi, I am trying to export a query into a .CSV file using SELECT ... OUTFILE at the command prompt. It works ok the first time but all subsequent runs give a 1086 error - File already exists. I have to use the command prompt vs. a GUI as I am running this in a .cgi script. Is there any way that I overwrite the file each time I export. Thanks Steve Carter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Table says it is read only but it is not from file system level
I am running an sql insert against a mysql table version 3.23.52 When from the file system level the table has the following permissions. rw-rw-r-- table.frm rw-rw-r-- table.MYD rw-rw-r-- table.MYI When the sql runs it says the table is read only. I am connecting to the table as root and I have set the password too. I am using java to do this sql operation. I can select items from the table, but can not insert them. Thanks in advance Dean-O - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help on SQLyog
On Tue, 1 Oct 2002, Kevin Tsay wrote: Dear Listers: I've installed MySQL over my Linux (RedHat 7.3) and SQLyog over my laptop. When I start SQLyog and type in the mySQLHostAddress: 10.0.5.210 User Name: root Password: Port: 3306 Itis giving me the error: Host 'kevin.sitesmith.com' is not allowed to connect to this MySQL server. Do I need to setup or change anything on MySQL DB in order for this connection to go through ? Hi, You need to grant the root user access to your server from the host you're trying to connect from. See the Technical Reference on GRANT statement for help on how to do that. Best regards, Iikka Thanks --Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Question about FULLTEXT indexes
Hi,
I'm using MySQl 3.23.52 on RedHat Linux 6.2
I have a table that is indexed on the description column as FULLTEXT. I
allow the user to enter text in an input field and I return matching rows.
I've noticed that writing a query such as:
SELECT EDescript FROM HSCodes WHERE MATCH(EDescript) AGAINST ('books of
paper');
will return all columns where any of the above words are found. What I want
is to give the user a choice of:
a) return matching columns where any words are found
b) return matching columns where all words are found
c) return matching columns where any part of any or all word(s) is/are found
e.g.. 'ex' returns 'exercise'
I've read the documentation and note that this is possible by using the IN
BOOLEAN MODE clause but that I require MySQL 4.01 for this. As my system is
a production database, I am hesitant to use a beta version. Am I out of
luck or can this be simulated in 3.23.52?
Thanks,
Don
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help on SQLyog
Kevin, It sounds like you don't have your MySQL access setup correctly. I am also a newbie to MySQL. I recently experienced the same problem with MyCC, which is similar software to SQLyog. I have both, MyCC and SQLyog, installed and currently comparing and contrasting to see which one I like to use. I used Webmin (a graphical user tool which allows me to configured just about anything in Linux) to configured my MySQL access. You basicall need to set the user's permission to access MySQL from another host or all hosts (the MySQL is set to localhost only). You may need to specify the port 3306 in the /etc/my.cnf file as well. This did it for me. Good Luck! - Original Message - From: Kevin Tsay [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 10:45 AM Subject: Help on SQLyog Dear Listers: I've installed MySQL over my Linux (RedHat 7.3) and SQLyog over my laptop. When I start SQLyog and type in the mySQLHostAddress: 10.0.5.210 User Name: root Password: Port: 3306 Itis giving me the error: Host 'kevin.sitesmith.com' is not allowed to connect to this MySQL server. Do I need to setup or change anything on MySQL DB in order for this connection to go through ? Thanks --Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
MySQL Error 1030: Got error -30996 from table handler
List, I would appreciate if somebody has any ideas on the above error. We are getting this error Error 1030: Got error -30996 from table handler with BDB tables on a Linux Server (Red Hat 7.3), the version of MySQL is 3.23.42 Thanks Sridhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MS Exchange Email?
Hello, Is there a way to have email from an email account on a MS Exchage Server be populated into MySQL. I can to this by connecting to the exchange server with MS Access and then push the data from access into the MySQL table. I would like not to have to use MS Access. Thanks for any help. DBA / Unix Administrator Patrick Fowler Wynit, Inc. 6847 Ellicott Drive East Syracuse, NY 13057 V (315) 437-7617 x2172 F (315) 437-0432 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: install mysql on osx 10.2
On Tuesday, October 1, 2002, at 10:51 24h, webmaster wrote: Hi, I am looking for some help installing mysql I have downloaded a copy and have it on my desktop , and well I am sorta wondering where to go from here. Because the instructions are too vague Try the Mac OS version 10.2 from http://www.entropy.ch/software/macosx/mysql/ -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.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 4 choosing wrong index for merge table
A query that took less than a second under 3.23.44 started taking minutes when we upgraded to 4.0.3. The original query involved multiple tables including one merge table containing 10 subtables and millions of rows, but I've trimmed it down to a manageable test case where the merge table has only one subtable and 10 rows. In the test case (see SQL below), there are three EXPLAIN statements. The first is for the problem query, from the merge table. Note that it incorrectly uses the index named 'files' even though the primary index included both fields from the WHERE clause. The second EXPLAIN shows the same query performed on the MyISAM table directly, without the merge. There the correct index is chosen. The third EXPLAIN shows a similar query on the merge table but selecting only one file_code value rather than a range. There the correct index is chosen again. We can work around the problem by adding USE INDEX (PRIMARY) to the queries, but this does look like a bug in the query optimization for 4.0. I hope this helps in tracking it down. - Begin SQL - CREATE TABLE files_snapshot_pm_01 ( fileset_id tinyint(3) unsigned NOT NULL default '0', file_code varchar(32) NOT NULL default '', fileset_root_id tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (fileset_id,file_code), KEY files (fileset_id,fileset_root_id) ) TYPE=MyISAM; INSERT INTO files_snapshot_pm_01 VALUES (2, '000111', 1), (2, '000112', 1), (2, '000113', 1), (2, '000114', 1), (2, '000115', 1), (2, '000116', 1), (2, '000117', 1), (2, '000118', 1), (2, '000119', 1), (2, '000120', 1); CREATE TABLE files_snapshot_pm ( fileset_id tinyint(3) unsigned NOT NULL default '0', file_code varchar(32) NOT NULL default '', fileset_root_id tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (fileset_id,file_code), KEY files (fileset_id,fileset_root_id) ) TYPE=MRG_MyISAM UNION=(files_snapshot_pm_01); # This query, with the merge table, incorrectly uses the # 'files' index: EXPLAIN SELECT * FROM files_snapshot_pm WHERE fileset_id = 2 AND file_code BETWEEN '000115' AND '000120' LIMIT 1\G # This query uses the primary index, as it should: EXPLAIN SELECT * FROM files_snapshot_pm_01 WHERE fileset_id = 2 AND file_code BETWEEN '000115' AND '000120' LIMIT 1\G # This query, with the merge table again but selecting a # specific file_code value rather than a range, uses the # correct index: EXPLAIN SELECT * FROM files_snapshot_pm WHERE fileset_id = 2 AND file_code = '000115' LIMIT 1\G - End SQL - -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: install mysql on osx 10.2
Check out the excellent package/instructions at http://www.entropy.ch/software/macosx/mysql/ At 01:51 PM 10/1/2002 -0400, webmaster wrote: Hi, I am looking for some help installing mysql I have downloaded a copy and have it on my desktop , and well I am sorta wondering where to go from here. Because the instructions are too vague for me, as a newbie to mysql please assist james - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Kelly Firkins Database Developer Siebel configuration and administration PHP, MySQL and Linux work @ IS - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: install mysql on osx 10.2
Le 1/10/02 19:51, « webmaster » [EMAIL PROTECTED] a écrit : Hi, I am looking for some help installing mysql I have downloaded a copy and have it on my desktop , and well I am sorta wondering where to go from here. Because the instructions are too vague for me, as a newbie to mysql please assist james You'd better get the Marc Liyanage package and follow his very clear and understandable instructions: http://www.entropy.ch/software/macosx/mysql/ Regards. -- Stéphane Pinel Equinox Partners France Information System - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Table says it is read only but it is not from file system level
On Tue, 1 Oct 2002, Rochester, Dean wrote: I am running an sql insert against a mysql table version 3.23.52 When from the file system level the table has the following permissions. rw-rw-r-- table.frm rw-rw-r-- table.MYD rw-rw-r-- table.MYI Hi, Please verify that the user mysqld runs as has access to those tables. Somehow you didn't show us the owners and groups of those table data files. For example, running as 'mysql' user, doing 'chown mysql *' will suffice. BTW, the whole data directory should be owned by the mysqld-running user. Regards, Iikka When the sql runs it says the table is read only. I am connecting to the table as root and I have set the password too. I am using java to do this sql operation. I can select items from the table, but can not insert them. Thanks in advance Dean-O - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Cannot install mysql on OS X 10.2
To all, I can not configure mysql on OS X, using the latest build for that OS. 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
FULLTEXT search and ORDER BY
Hi.
I've such problem.
Is ORDER BY works with MATCH AGAINST ?
i.e.
create table test (
id_test int11,
message text
);
SELECT id_test, message FROM test WHERE WHERE MATCH (message) AGAINST
('example' IN BOOLEAN MODE) ORDER BY id_test
For me in mysql 4.0.3beta this select doesn't work as I want. Results are still
sorted by score from MATCH AGAINST phrase. I know that such order by breaks
philosophy of MATCH AGAINST, but when I want sort results in different way I
should be able to do this.
How can I solve this problem and force mysql to do what I want ? :)
Regards.
--
Grzegorz
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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 confirm (conf#3609bdcf19fdd5aadddc58b8665f2e25)
IMPORTANT INFORMATION! This is an automated message. The message you sent (attached below) requires confirmation before it can be delivered. To confirm that you sent the message below, just hit the Reply button and send this message back (you don't need to edit anything). Once this is done, no more confirmations will ne necessary. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMACION IMPORTANTE Este es un mensaje automatico. El mensaje que usted ha enviado (mostrado mas abajo) necesita su confirmacion antes de ser entregado. Para confirmar que usted ha enviado el mensaje, solo presione el boton de Reply y envie éste mensaje (no es necesario editar el mensaje). Una vez realizado esto, no se necesitarán mas confirmaciones. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMAÇÃO IMPORTANTE Esta é uma mensagem automática A mensagem que você enviou (em anexo) requer confirmação antes de ser entregue. Para confirmar o envio basta pressionar o botão de Reply e enviar esta mensagem de volta (não é necessário editar). Uma vez que isto seja feito, novas confirmações não serão necessárias. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- WICHTIGE INFORMATION Dies ist eine automatisch generierte Antwort. Ihre Mail (unten angehaengt) muss vor der Zustellung an mich explizit bestaetigt werden. Um dies zu tun, beantworten Sie einfach diese Mail mit der Antworten oder Reply-Funktion Ihres Mailprogramms. Es sind keine Aenderungen am Text noetig. Dies ist die einzige Bestaetigung die Sie je an mich senden muessen; Ihre weiteren Nachrichten werden automatisch akzeptiert. Diese Massnahme dient der Bekaempfung von Spam. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMATION IMPORTANTE Ceci est un message automatique. Le message que vous avez envoye (dessous) demande confirmation avant qu'il puisse etre envoye Pour confirmer que vous avez bien envoye le message ci-dessous, simplement appuyez sur la touche Reply, et renvoyez ce message (Vous n'avez pas besoin d'editer quoique ce soit). Une fois que ceci est fait, vous n'avez pas besoin d'autre confirmations. --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- INFORMAZIONE IMPORTATE! Questo è un messaggio automatico. Il messaggio che hai spedito (allegato sotto) richiede una conferma prima che sia consegnato. Per confermare che sei tu che hai spedito il messaggio, basta cliccare il tasto Reply e rispedirlo nuovamente (non hai bisogno di scrivere nessuna altra informazione aggiuntiva). Fatto questo, nessuna altra conferma è richiesta. --- Original Message Follows --- Date: Tue, 1 Oct 2002 23:38:34 +0200 From: [EMAIL PROTECTED] To: Chuck Payne [EMAIL PROTECTED] Subject: Re: How many days out... Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Hi, I am having problems get how many days out an invoice is. I have try this. SELECT NOW()-summitted_date FROM table; But it not working as usually. So please guys a little help. So If an invoice was summitted on 9-26-02 then I should be able to see that 5 days. Chuck Payne Magi Design and Support This email account is protected by: Active Spam Killer (ASK) V2.0.2 - (C) 2001-2002 by Marco Paganini For more information, visit http://www.paganini.net/ask - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How many days out...
Hi, I am having problems get how many days out an invoice is from mysql. I have try this. SELECT NOW()-summitted_date FROM table; But it not working as usually. So please guys a little help. So If an invoice was summitted on 9-26-02 then I should be able to see that 5 days. Chuck Payne Magi Design and Support sql, mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Drop Index - Error 28
Yes, it builds a new index file before deleteing the old. Oswaldo Castro wrote: Hi List I have a table with 90 Millions records and 8 indexes (75GB). I am trying to drop one of them but I get an errorcode 28 (no space left on device). df- v gives me an extra 27% of free space. My questions: Does MySQL use temporary areas to drop indexes and for what ? Is there a way to tell to MySQL to ignore this ? Thanks in advance Oswaldo Castro - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?
You need the client 'mysql' on the unix machine to talk to the server 'mysqld' on whatever machine. This will allow you to write shell scripts that call mysql. If you want to program in PHP or perl, then you need their mysql drivers which talk to the server. Chris Couture wrote: Hi, I'm a MySQL Newbie and am working on my first real project. The project involves removing the Access database off of our system and using MySQL in its place. Here is what happens now with this database The Unix machine writes information to the end of a text file every time an invoice is processed. This text file is FTP'd every 10 minutes over to our server. Access starts up and querys all the data and puts it into the proper tables. (Currently there are 15,000+ records and this has only been running for 6 months so you can see the need to rethink this process.) This process allows our shipping computers, using OBDC to connect to the access database where they can pull the information into the fields (name, address, service type etc) Anyway, here is where I stand now. I have built the MySQL server and it has been up and running for 3 weeks now and seems stable. I have installed MyODBC on the shipping computers and they connect. My question is what type of driver do I need to put on the Unix machine to make it where it can write insert statements directly to the database? Thanks, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Help on SQLyog
Check the db table in mysql database. See what that says also, I notice the error was that kevin.smith.com not allowed sould that be [EMAIL PROTECTED] not allowed? Generally you will get kevin@localhost not allowed. Grant priviledges to that user on that machine as [EMAIL PROTECTED] Nestor :-) -Original Message- From: Kevin Tsay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:53 AM To: Nestor Florez Cc: [EMAIL PROTECTED] Subject: RE: Help on SQLyog Nestor: I've set the password for root and granted privileges to it. see below: mysql select * from user where user='root'; +---+--+--+-+-+- +-+-+---+-+---+- -+---++-++-- --+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+--+--+-+-+- +-+-+---+-+---+- -+---++-++-- --+ | localhost | root | 005a1506376eec48 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | stargate | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | +---+--+--+-+-+- +-+-+---+-+---+- -+---++-++-- --+ 2 rows in set (0.04 sec) --Kevin -Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:32 AM To: Kevin Tsay Subject: RE: Help on SQLyog Did you set the password for root? did you grant yourself permission on the DB you are trying to access? Nestor :-) -Original Message- From: Kevin Tsay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:45 AM To: [EMAIL PROTECTED] Subject: Help on SQLyog Dear Listers: I've installed MySQL over my Linux (RedHat 7.3) and SQLyog over my laptop. When I start SQLyog and type in the mySQLHostAddress: 10.0.5.210 User Name: root Password: Port: 3306 Itis giving me the error: Host 'kevin.sitesmith.com' is not allowed to connect to this MySQL server. Do I need to setup or change anything on MySQL DB in order for this connection to go through ? Thanks --Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Store pictures in DB (load_file() revisited)
mysql probably does not have search permission on /home/alex.
copy the file to /tmp and see what happens.
Alex Safonov wrote:
Greetings,
just saw a message with an example of inserting a BLOB
value using load_file(). Can't get load_file() to
work:
mysql select load_file('/home/alex/post.html') from
test;
+---+
| load_file('/home/alex/post.html') |
+---+
| NULL |
+---+
1 row in set (0.00 sec)
/home/alex/post.html exists, is small (~1k) and
world-readable. load_file() still returns NULL. Same
if I try to insert an existing file into a table.
I am on Linux 2.4.10 (SuSE), MySQL 3.23.52.
Thanks for any suggestions,
__
Do you Yahoo!?
New DSL Internet Access from SBC Yahoo!
http://sbc.yahoo.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Exporting and overwriting file
No. How would the server know if you had used the previous output file? As a matgter of fact, since it is still there, I guess you didn't. Have your cgi script move it. Carter, Steve wrote: Hi, I am trying to export a query into a .CSV file using SELECT ... OUTFILE at the command prompt. It works ok the first time but all subsequent runs give a 1086 error - File already exists. I have to use the command prompt vs. a GUI as I am running this in a .cgi script. Is there any way that I overwrite the file each time I export. Thanks Steve Carter - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Table says it is read only but it is not from file system level
You are connecting th the server, not the table. The server must have read and write permissions on the files. They must be owned by mysql, as must their directories. Rochester, Dean wrote: I am running an sql insert against a mysql table version 3.23.52 When from the file system level the table has the following permissions. rw-rw-r-- table.frm rw-rw-r-- table.MYD rw-rw-r-- table.MYI When the sql runs it says the table is read only. I am connecting to the table as root and I have set the password too. I am using java to do this sql operation. I can select items from the table, but can not insert them. Thanks in advance Dean-O - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Help on SQLyog
Check out the GRANT syntax in the manual. I don't see where you granted any privileges. Kevin Tsay wrote: Nestor: I've set the password for root and granted privileges to it. see below: mysql select * from user where user='root'; +---+--+--+-+-+- +-+-+---+-+---+- -+---++-++-- --+ | Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | +---+--+--+-+-+- +-+-+---+-+---+- -+---++-++-- --+ | localhost | root | 005a1506376eec48 | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | stargate | root | | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | +---+--+--+-+-+- +-+-+---+-+---+- -+---++-++-- --+ 2 rows in set (0.04 sec) --Kevin -Original Message- From: Nestor Florez [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:32 AM To: Kevin Tsay Subject: RE: Help on SQLyog Did you set the password for root? did you grant yourself permission on the DB you are trying to access? Nestor :-) -Original Message- From: Kevin Tsay [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:45 AM To: [EMAIL PROTECTED] Subject: Help on SQLyog Dear Listers: I've installed MySQL over my Linux (RedHat 7.3) and SQLyog over my laptop. When I start SQLyog and type in the mySQLHostAddress: 10.0.5.210 User Name: root Password: Port: 3306 Itis giving me the error: Host 'kevin.sitesmith.com' is not allowed to connect to this MySQL server. Do I need to setup or change anything on MySQL DB in order for this connection to go through ? Thanks --Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQl 4.03
What do you mean 'still' ? Version 4 just went beta a short time ago, and is only at 03 or 04. DonPro wrote: Hi, The web site states that MySQL 4.03 is still officially beta. Does anyone have any experience or feedback using it on a production system? I really require some of the new features in version 4. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB?
Thanks for the info. Let me see if I have this right. (I am asking these question on behalf of my UNIX programmer who will be doing all of the programming so sorry if I am asking simple questions.) To make this simple, let's label the computers. The MySQL database server will be labeled B and the UNIX machine doing the inserts will be A This is what I understand so far. I install the client on A and it can then talk to the mysqld server on B? How do I need to go about telling A where the mysql server is located? Is this something I can set up in a ini file or does it need to be in the scripts that are ran to do the inserts (like a php or asp script does). My UNIX guy asked me to ask about an ODBC connector. Will MyODBC work on Unix? Thanks so much for the help! Chris -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 3:16 PM To: Chris Couture Cc: [EMAIL PROTECTED] Subject: Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL DB? You need the client 'mysql' on the unix machine to talk to the server 'mysqld' on whatever machine. This will allow you to write shell scripts that call mysql. If you want to program in PHP or perl, then you need their mysql drivers which talk to the server. Chris Couture wrote: Hi, I'm a MySQL Newbie and am working on my first real project. The project involves removing the Access database off of our system and using MySQL in its place. Here is what happens now with this database The Unix machine writes information to the end of a text file every time an invoice is processed. This text file is FTP'd every 10 minutes over to our server. Access starts up and querys all the data and puts it into the proper tables. (Currently there are 15,000+ records and this has only been running for 6 months so you can see the need to rethink this process.) This process allows our shipping computers, using OBDC to connect to the access database where they can pull the information into the fields (name, address, service type etc) Anyway, here is where I stand now. I have built the MySQL server and it has been up and running for 3 weeks now and seems stable. I have installed MyODBC on the shipping computers and they connect. My question is what type of driver do I need to put on the Unix machine to make it where it can write insert statements directly to the database? Thanks, Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Table says it is read only but it is not from file system level
- Original Message - From: Rochester, Dean [EMAIL PROTECTED] To: MySQL (E-mail) (E-mail) [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 8:22 PM Subject: Table says it is read only but it is not from file system level I am running an sql insert against a mysql table version 3.23.52 When from the file system level the table has the following permissions. rw-rw-r-- table.frm rw-rw-r-- table.MYD rw-rw-r-- table.MYI Hmm, peculiar permissions. Why is everything world-readable? If the mysql database it too, you could be in jeopardy. When the sql runs it says the table is read only. I am connecting to the table as root and I have set the password too. I remember something about compressed databases becoming read-only. Perhaps that is the case? I am using java to do this sql operation. Is that why you made everything world-readable, because you thought the web-daemon would need access? That should not be. The web-daemon will connect over socket (or tcp) to the MySQL server. As long as the databases are owned by the mysql user (if that is what the MySQL daemon runs as), you are okay; use chmod 660 (or perhaps 600 even). - Mark System Administrator Asarian-host.org --- If you were supposed to understand it, we wouldn't call it code. - FedEx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
How to get the number of days an invoice was submitted.
Hi, I am having problems get how many days out an invoice is. I have try this sql statement. SELECT NOW()-submmitted_date FROM table; But it not working as usually. So please guys a little help. So If an invoice was submmitted on 9-26-02 then I should be able to see that 5 days. Chuck Payne Magi Design and Support sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How many days out...
At 15:41 -0400 10/1/02, Chuck Payne wrote: Hi, I am having problems get how many days out an invoice is from mysql. I have try this. SELECT NOW()-summitted_date FROM table; But it not working as usually. So please guys a little help. What do you mean not working as usually? A query written like that will *never* work. That's not how you do date arithmetic in MySQL. (That is, MySQL will calculate an answer, but it's not going to be what you seem to expect.) Try TO_DAYS(NOW()) - TO_DAYS(summitted_date) to get the difference between dates in days. So If an invoice was summitted on 9-26-02 then I should be able to see that 5 days. Chuck Payne Magi Design and Support sql, mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please Help!
On Tuesday, Oct 1, 2002, at 16:39 America/Phoenix, DeNewbie wrote: I am a newbie and I am having a chronic problem getting mysql started up and running. I got so frustrated that I uninstalled the mysql rpms and started over again but its hasn't helped my situation. My whole problem revolves around mysql_install_db setup. This is what I am doing and its simply giving me problems. All I want to do is enter the root and host paswords but I can't get past the root password setup. PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' I input this; cords-orj86jfje:/usr/bin # mysqladmin -u root password sqlpass mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! How do I correct this situation. Why am I having such a hard time entering these passwords. I can't even enter the root password. I'm nearly giving up. It sounds like the server isn't running. You need to start it with cd /usr/local ./bin/safe_mysqld --user=mysql You may need to start the server as root. -- Clayburn W. Juniel, III -- Effective Software Solutions Phone: (602) 326-7707Mobile: (602)326-7707 Email: [EMAIL PROTECTED] http://EffectiveSoftwareSolutions.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
Please Help!
I am a newbie and I am having a chronic problem getting mysql started up and running. I got so frustrated that I uninstalled the mysql rpms and started over again but its hasn't helped my situation. My whole problem revolves around mysql_install_db setup. This is what I am doing and its simply giving me problems. All I want to do is enter the root and host paswords but I can't get past the root password setup. PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' I input this; cords-orj86jfje:/usr/bin # mysqladmin -u root password sqlpass mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! How do I correct this situation. Why am I having such a hard time entering these passwords. I can't even enter the root password. I'm nearly giving up. Thanks, DeNewbie P.S. I am using SuSe Linux 7.3 and I am using the latest MySQL binary rpm downloads ver 3.23 . - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Startup script for Solaris 7?
If you are running MySQL on a Solaris 7 machine, would you mind sharing your startup script with the list? Thanks. bz - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: install mysql on osx 10.2
Stephane Pinel wrote Le 1/10/02 19:51, $B%)(B webmaster ; [EMAIL PROTECTED] a $BqD(Brit : Hi, I am looking for some help installing mysql I have downloaded a copy and have it on my desktop , and well I am sorta wondering where to go from here. Because the instructions are too vague for me, as a newbie to mysql please assist james You'd better get the Marc Liyanage package and follow his very clear and understandable instructions: http://www.entropy.ch/software/macosx/mysql/ I was able to install by hand from the instructions in the MySQL docs, but I am somewhat comfortable with UNIX. Still took me a good piece of a night, but I needed to know about the stuff going on underneath. -- Joel Rees [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: Cannot install mysql on OS X 10.2
Philip Lavine scrawled To all, I can not configure mysql on OS X, using the latest build for that OS. Oh? Thanks Sure. (I'm not telepathic. What error messages and/or misbehavior are you getting during the install?) -- Joel Rees [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: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using
Tuuri,
Thank you for the follow-up. It's great that our efforts were not in vain and I could
contribute towards resolving the issue. I will be looking forward to the next release
of InnoDB/MySQL-Max.
-
regards,
Afroze H. Zubairi (IOD)
-
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
Date: Tue, 1 Oct 2002 15:00:37 +0300
To: \iod iod\ [EMAIL PROTECTED]
Subject: Re: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using
IOD,
thank you for the bug report. I was able to repeat the problem with you
scripts. The bug was that InnoDB failed to release at an SQL statement end
such AUTO-INC locks which were only granted after a lock wait. They were
only released at the transaction commit.
Since AUTO-INC locks normally are held for a short time, AUTO-INC lock waits
are rare, and many tests fail to notice this bug. Only under a stress test
like the one you wrote this bug becomes visible.
Below is a patch which fixes the bug.
Best regards,
Heikki
Innobase Oy
sql query
ChangeSet
1.1201 02/10/01 13:47:58 [EMAIL PROTECTED] +1 -0
lock0lock.c:
Fix bug: the AUTO-INC lock was held to the end of trx if it was granted
after a lock wait
innobase/lock/lock0lock.c
1.16 02/10/01 13:47:39 [EMAIL PROTECTED] +13 -0
Fix bug: the AUTO-INC lock was held to the end of trx if it was granted
after a lock wait
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: heikki
# Host: hundin.mysql.fi
# Root: /home/heikki/mysql
--- 1.15/innobase/lock/lock0lock.c Sun Aug 11 18:34:57 2002
+++ 1.16/innobase/lock/lock0lock.c Tue Oct 1 13:47:39 2002
@@ -1863,6 +1863,19 @@
ut_ad(mutex_own(kernel_mutex));
lock_reset_lock_and_trx_wait(lock);
+
+ if (lock_get_mode(lock) == LOCK_AUTO_INC) {
+
+ if (lock-trx-auto_inc_lock != NULL) {
+ fprintf(stderr,
+ InnoDB: Error: trx already had an AUTO-INC lock!\n);
+ }
+
+ /* Store pointer to lock to trx so that we know to
+ release it at the end of the SQL statement */
+
+ lock-trx-auto_inc_lock = lock;
+ }
if (lock_print_waits) {
printf(Lock wait for trx %lu ends\n,
- Original Message -
From: iod iod [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Tuesday, October 01, 2002 11:10 AM
Subject: Re: InnoDB AUTO-INC lock timeouts / deadlocks on inserts (using
Thank you for your response.
We tried your example here on shell and it looks like InnoDB locks the
table only for the first transaction after db startup and this lock is held
for the whole transaction (like you observed).
But, contrary to this scenario we have experienced some strange behavior,
such that table level AUTO-INC locks are being applied REPEATEDLY (duration
of ENTIRE transaction), even though the database has undergone multiple,
commited transactions previously. This behavior is very prominent when you
have multiple processes with overlapping, concurrent transactions and you
are executing DML statements in a loop (I tried a delay after each iteration
to prevent a locks being held too long, but it did not seem to work). It so
happens that the lock is not released by the process until the transaction
is complete.
I am attaching a simplified perl script (concur-test.pl) and a shell
script (go.sh) used to invoke these processes (URL:
http://www.geocities.com/yoda_pk/innodbchk.tar.gz ). Please create the table
(SQL provided), run the shell script and observe the InnoDB monitor log for
deadlocks. We have observed various AUTO-INC table level locks which are
applied every time we run the tests (without restarting the mysql database
engine) and these locks are held for the whole transaction and not just one
particular statement, EVERY time.
PLATFORM: RH Linux 7.3/MySQL-Max-3.23.52-1/Perl DBI
Looking forward to your observations.
regards,
IOD
Subject: Re: InnoDB AUTO-INC lock timeouts / deadlocks on inserts
(using
Iod,
- Original Message -
From: iod iod [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday, September 26, 2002 8:14 AM
Subject: InnoDB AUTO-INC lock timeouts / deadlocks on inserts
(using
We have been using InnoDB with MySQL (MySQL-Max-3.23.52-1)
for transaction
support in some complex situations in our application when
maintaining
consistency is critical.
Recently we did some stress testing by simulating 10
concurrent users
(perl/DBD) doing large number of inserts on a few tables. Note
that these
tables have indexed fields which are 'INT' 'AUTO_INCREMENT'.
We are getting lock timeouts on concurrent inserts (in
concurrent
TRANSACTIONS) very
Using Install shield, how to do ODBC DSN setting ?
Hi, i am doing a project and it is almost nearing release version.
i planned to do the installation by using install shield to one short doing
the
mysql, myodbc installation and also the ODBC DSN setting.
is anyone have any idea to do the ODBC DSN setting through install shield ?
or writing any programs/script to make it work ?
hope can get reply ASAP. thanx
regards,
alice
/---\
Confidential and/ or privileged information may be contained in this
e-mail and any attachments transmitted with it ('Message'). If you are
not the addressee indicated in this Message (or responsible for
delivery of this Message to such person),you are hereby notified that
any dissemination, distribution, printing or copying of this Message or
any part thereof is prohibited. Please delete this Message if received
in error and advise the sender by return e-mail. Opinions, conclusions
and other information in this Message that do not relate to the
official business of this company shall be understood as neither given
nor endorsed by this company.
This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd)
*Scanner Engine powered by Norman Virus Control
\--/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Access denied for user
Hi,
I have Mysql 3.23.52-max-nt on Win2K. I¡¯d like to set a password for root
so I use the following commands:
mysql use mysql
Database changed
mysql update user set password=password('l05m')
- where host='localhost' and user='root';
Query OK, 1 row affected (0.00 sec)
Mysql prompt a password be set. So I use the following commands to reload
system parameters:
C:\mysql\binmysqladmin reload
But mysql shows:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)'
then I use the new password to start mysql.
C:\mysql\binmysql -hlocalhost -uroot -p
Enter password:
mysql shows:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
Does anybody give help for me?
Thanks for any suggestions,
Alice
_
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Please Help!
On Tue, 1 Oct 2002, DeNewbie wrote: I am a newbie and I am having a chronic problem getting mysql started up and running. I got so frustrated that I uninstalled the mysql rpms and started over again but its hasn't helped my situation. My whole problem revolves around mysql_install_db setup. This is what I am doing and its simply giving me problems. All I want to do is enter the root and host paswords but I can't get past the root password setup. PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/bin/mysqladmin -u root password 'new-password' I input this; cords-orj86jfje:/usr/bin # mysqladmin -u root password sqlpass mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! How do I correct this situation. Why am I having such a hard time entering these passwords. I can't even enter the root password. I'm nearly giving up. Hi, Really, please check that the server itself _is_ running _and_ the socket file exists at the mentioned location. If the server is down, start it in your mysql directory by entering bin/mysqld_safe (if using MySQL 4.x) or bin/safe_mysqld (if using 3.xx). Regards, Iikka ps. The manual has a section on those can't-connect things (at least I think I've seen this somewhere before). ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Get the total of a feild
sounds like you need SUM(field name) - hcir Hi, I wanting to know what the sql statement is that will let me get the total of database. The feild is amount. I have tried a couple of sql statement and have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Get the total of a feild
sounds like you need SUM(field name) - hcir Hi, I wanting to know what the sql statement is that will let me get the total of database. The feild is amount. I have tried a couple of sql statement and have even looked at mysql 6.3.3.1 Arithmetic Operations. But I am lost. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
