How to remove User in Mysql
Dear all As i had granted permission to user, now i want to remove particular permission off from the user, could you pls tell me how to do so??? And what should i do if i want to remove a user? is mysql got something like User Group Thx Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem creating primary key on blob column
Hello the list, I try to create a table with a TEXT primary key, and this error message appear : ERROR 1170 : BLOB column 'MY_COLUMN' used in key specification without a key length. What is the syntax to settle a key length ? Here is my sql code to create my table: -- -- Table : MY_TABLE -- create table MY_TABLE ( MY_COLUMN_1TEXT not null, MY_COLUMN_2VARCHAR(2) not null, MY_COLUMN_3TEXT not null, constraint PK_TRADUCTION primary key (MY_COLUMN_1, MY_COLUMN_2) ) ; - Dominique TOMASSONI - [EMAIL PROTECTED] SunGard Investment Management Systems 173, Bureaux de la Colline Bâtiment E 92213 Saint-Cloud Tél : +33 1 49 11 31 23 Fax : +33 1 49 11 30 65 - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 FULLTEXT maximum score?
Hi Everyone. Quick question. When you do a search on a MySQL FULLTEXT index using MATCH you get a value returned of the relevance of the result. Is there a maximum value that can be returned so that I can convert these numbers into precentages??? Thank you very much. Best regards Andrew Dixon www.mso.net Head Office Tel: + 44 1474 813816 Head Office Fax: + 44 1474 813819 Sales Marketing Office Tel: +44 1892 610225 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 2013: Lost connection to MySQL server during query
Dear all I have a problem when I specified my host in order to connect to my mysql server : mysql -h p204 ERROR 2013: Lost connection to MySQL server during query I have just installed the server and set a pass for the root user. In hope of your help Guillaume - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 FULLTEXT maximum score?
Hi! On Nov 26, Andrew Dixon - MSOnet wrote: Hi Everyone. Quick question. When you do a search on a MySQL FULLTEXT index using MATCH you get a value returned of the relevance of the result. Is there a maximum value that can be returned so that I can convert these numbers into precentages??? Thank you very much. Best regards Andrew Dixon www.mso.net Head Office Tel: + 44 1474 813816 Head Office Fax: + 44 1474 813819 Sales Marketing Office Tel: +44 1892 610225 It's difficult to say... May be there's some limits implied by the formulae used, but they are difficult to estimate. 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: Need to repair InnoDb tables
Hi! At 05:19 PM 11/25/01 -0500, you wrote: I think your diagnosis is correct. There is an FRM without a corresponding InnoDB table. The question is, what causes this, and how do we prevent it? Brent thinks the problem was a third-party software which crashed the server. It appears to be a bug related to CREATE TABLE and DROP TABLE. I have found it a good idea to commit and reconnect after creating an InnoDB table. Erik Regards, Heikki http://www.innodb.com -- Order commercial MySQL/InnoDB support at https://order.mysql.com/ -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 17, 2001 2:20 AM To: [EMAIL PROTECTED] Subject: Re: Need to repair InnoDb tables Brent, maybe you have moved .frm files around? If there is an orphaned .frm file for a table without a corresponding table inside InnoDB data files you get the following errors: mysql show tables; +-+ | Tables_in_test2 | +-+ | fare| +-+ 1 row in set (0.34 sec) mysql describe fare; ERROR 1016: Can't open file: 'fare.InnoDB'. (errno: 1) mysql drop table fare; ERROR 1051: Unknown table 'fare' mysql and in the MySQL error log you get: 011017 9:11:52 InnoDB: Started mysqld: ready for connections InnoDB: Cannot find table test2/fare from the internal data dictionary InnoDB: of InnoDB though the .frm file for the table exists. Maybe you InnoDB: have deleted and recreated InnoDB data files but have forgotten InnoDB: to delete the corresponding .frm files of InnoDB tables? InnoDB: Error: table test2/fare does not exist in the InnoDB internal InnoDB: data dictionary though MySQL is trying to drop it. InnoDB: Have you copied the .frm file of the table to the InnoDB: MySQL database directory from another database? The way to fix the problem is to delete the .frm file from the MySQL database directory in question. Regards, Heikki http://www.innodb.com/ibman.html In my sample database, all of the tables are InnoDb. For some reason 2 of the tables can no longer be accessed. I keep getting error 1016. 1) Where can I find a list of error codes and their meanings? 2) How do I fix an InnoDb table? TIA Brent mysql show tables; +---+ | Tables_in_isample | +---+ | absence | | event | | member| | president | | score | | student | +---+ 6 rows in set (0.00 sec) mysql describe absence; ERROR 1016: Can't open file: 'absence.InnoDB'. (errno: 1) mysql describe president; ERROR 1016: Can't open file: 'president.InnoDB'. (errno: 1) mysql select * from absence; ERROR 1016: Can't open file: 'absence.InnoDB'. (errno: 1) mysql select * from president; ERROR 1016: Can't open file: 'president.InnoDB'. (errno: 1) mysql drop table president; ERROR 1051: Unknown table 'president' mysql drop table absence; ERROR 1051: Unknown table 'absence' 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: Getting to latest 5 Records
The best way is to get the records ordered inverselly by the auto-increment field and then restrict the return to 5 records. Cheers, Luis Ferro WebDev -Original Message- From: Jack [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 26 de Novembro de 2001 10:02 To: Mysql List Subject: Getting to latest 5 Records Dear all I had a table which with Auto_increment, which means when i insert a record there will be a number insert to lead as the location of the record. here is my question. I was try to get the most last five records , but i don't know which query should i use? Thx Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Retire In 3 Months
AS SEEN ON NATIONAL TV: Making money from your home for an investment of only $25 U.S. Dollars expense one time ALL YOU NEED IS A COMPUTER AND THE INTERNET! This is the letter you have been hearing about on the news lately. Due to the popularity of this letter on the Internet, a national weekly news program recently devoted an entire show to the investigation of this program described below, to see if it really can make people money. The show also investigated whether or not the program was legal. Their findings proved once and for all that there are ''absolutely NO Laws prohibiting the participation in the program and if people can -follow the simple instructions, they are bound to make some mega bucks with only $25 out of pocket cost''. DUE TO THE RECENT INCREASE OF POPULARITY RESPECT THIS PROGRAM HAS ATTAINED, IT IS CURRENTLY WORKING BETTER THAN EVER. Reasons why you will like this system: You only need a few hours a week. Set your own hours. Does not interfere with your current job, profession, or career. You can build your business with $25, = out-of-pocket costs. Work totally from home, from your computer. No previous business experience needed. The program allows you to learn as you earn. No limit on what you can earn No territorial restrictions. Also perfect for creating an extra income stream for your existing business. This is what one had to say: ''Thanks to this profitable opportunity. I was approached many times before but each time I passed on it. I am so glad I finally joined just to see what one could expect in return for the minimal effort and money required. To my astonishment, I received total $610,470.00 in 21 weeks, with money still coming in. Pam Hedland, Fort Lee, New Jersey Here is another testimonial: This program has been around for a long time but I never believed in it. But one day when I received this again in the mail I decided to gamble my $25 on it. I followed the simple instructions and walaa ... 3 weeks later the money started to come in. First month I only made $240.00 but the next 2 months after that I made a total of $290,000.00. So far, in the past 8 months by re-entering the program, I have made over $710,000.00 and I am playing it again. The key to success in this program is to follow the simple steps and NOT change anything.'' More testimonials later but first, = PRINT THIS NOW FOR YOUR FUTURE REFERENCE == If you would like to make at least $500,000 every 4 to 5 months easily and comfortably, please read the following... THEN READ IT AGAIN and AGAIN!!! FOLLOW THE SIMPLE INSTRUCTION BELOW AND YOUR FINANCIAL DREAMS WILL COME TRUE, GUARANTEED! INSTRUCTIONS: Order all 5 reports shown on the list below For each report, send $5 CASH, THE NAME NUMBER OF THE REPORT YOU ARE ORDERING and YOUR E-MAIL ADDRESS to the person whose name appears ON THAT LIST next to the report. MAKE SURE YOUR RETURN ADDRESS IS ON YOUR ENVELOPE TOP LEFT CORNER in case of any mail problems. When you place your order, make sure you order each of the 5 reports. You will need all 5 reports so that you can save them on your computer and resell them. YOUR TOTAL COST $5 X 5=$25.00. Within a few days you will receive, via e-mail, each of the 5 reports from these 5 different individuals. Save them on your computer so they will be accessible for you to send to the 1,000's of people who will order them from you. Also make a floppy of these reports and keep it on your desk in case something happens to your computer. IMPORTANT - DO NOT alter the names of the people who are listed next to each report, or their sequence on the list, in any way other than what is instructed below in step '' 1 through 6 '' or you will loose out on a majority of your profits. Once you understand the way this works, you will also see how it does not work if you change it. Remember, this method has been tested, and if you alter, it will NOT work !!! People have tried to put their friends/relatives names on all five thinking they could get all the money. But it does not work this way. Believe us, and Do Not try to change anything other than what is instructed. Because if you do, it will not work for you. Remember, honesty reaps the reward!!! 1 After you have ordered all 5 reports, take this advertisement and REMOVE the name address of the person in REPORT # 5. This person has made it through the cycle and is no doubt counting their fortune 2 Move the name address in REPORT # 4 down TO REPORT # 5. 3 Move the name address in REPORT # 3 down TO REPORT # 4. 4 Move the name address in REPORT # 2 down TO REPORT # 3. 5 Move the name address in REPORT # 1 down TO REPORT # 2
Re: Getting to latest 5 Records
just to make it clearer: select * from your_table order by auto_increment_column desc limit 5 cheers :) - Original Message - From: Luis Ferro [EMAIL PROTECTED] To: 'Jack' [EMAIL PROTECTED]; 'Mysql List' [EMAIL PROTECTED] Sent: Monday, November 26, 2001 6:30 PM Subject: RE: Getting to latest 5 Records The best way is to get the records ordered inverselly by the auto-increment field and then restrict the return to 5 records. Cheers, Luis Ferro WebDev -Original Message- From: Jack [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 26 de Novembro de 2001 10:02 To: Mysql List Subject: Getting to latest 5 Records Dear all I had a table which with Auto_increment, which means when i insert a record there will be a number insert to lead as the location of the record. here is my question. I was try to get the most last five records , but i don't know which query should i use? Thx Jack - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - search engines like query
For measuring relevance, you'll need to come up with our own weights and algorithms. MySQL doesn't do that kinds of things. For more information, read the documentation of Google at: http://citeseer.nj.nec.com/brin98anatomy.html or http://www7.scu.edu.au/programme/fullpapers/1921/com1921.htm Cheers -- sherzodR On Mon, 26 Nov 2001, Giulio Borrini - Netbuilder wrote: Hi guys, is there a method in mysql to do a search engines like query and order the results by relevance? i taken a look at MATCH ... AGAINST function but i'm not sure that it's what i need and i'm also looking for somenthing simpler and faster... any idea? thanks in advance - Giulio Borrini Web Programmer Netbuilder snc Parma, Italy - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
concatenate text content in column grouped by another column.
I have an application with many table joins and now I would like to get all different Skills that every person in my resultset has concatenated to one string. I would like the code to work like this. select concat_ws(, ,SkillName) as Skills, ..., ... from Skill, ..., ... where ... and ... group by fkEmployeeID order by ... , ... limit 0,20; But it dosn't! Is there some other way to fix this? Eva Fransson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
InnoDB in the release MySQL-3.23.45
Hi! InnoDB is a table type which provides row level locking, transactions, and foreign key constraints to MySQL. It is included in the MySQL -Max distributions in the 3.23 series, and to all distributions of MySQL-4.0. InnoDB release in MySQL-3.23.45 is a bugfix release. * In versions 3.23.42-.44, when creating a table on Windows, you have to use lower case letters in the database name to be able to access the table. Fixed in 3.23.45. * InnoDB now flushes stdout and stderr every 10 seconds: if these are redirected to files, the file contents can be better viewed with an editor. * Fixed an assertion failure in .44, in trx0trx.c, line 178 when you drop a table which has the .frm file but does not exist inside InnoDB. * Fixed a bug in the insert buffer. The insert buffer tree could get into an inconsistent state, causing a crash, and also crashing the recovery. This bug could appear especially in large table imports or alterations. * Fixed a bug in recovery: InnoDB could go into an infinite loop constantly printing a warning message that it cannot find free blocks from the buffer pool. * Fixed a bug: when you created a temporary table of the InnoDB type, and then used ALTER TABLE to it, the MySQL server could crash. * Prevented creation of MySQL system tables 'mysql.user', 'mysql.host', or 'mysql.db', in the InnoDB type. * Fixed a bug which can cause an assertion failure in 3.23.44 in srv0srv.c, line 1728. -- There are two known bugs which were not yet fixed in 3.23.45: * In a FOREIGN KEY constraint, on Windows you must specify the referenced table name always in lower case, and on both Unix and Windows you must specify the column names in the constraint in the same case as in the table creation. * If a table contains big BLOBs, then InnoDB gives much too big estimates for the rowcount in SHOW TABLE STATUS. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.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
Automatic joins
Hi, I'd like to ask for a reply to this (I hope not stupid) question: is there a way to set permanently relationship between tables, so in that way when I ask for something, Mysql automatically joins all tables involved in that relationship? (Like MSAccess, for example) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Joining table with itself
If you want to use your table more than once you have to declare that. select ... from T1 as FirstT1, T2 as SecondT1 where FirstT1.column...=SecondT1.column...; Eva Fransson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: concatenate text content in column grouped by another column.
Does it throw an error message or output isn't what you expected? In any event, did you try it with HAVING? I couldn't notice anything wrong from what you have there Cheers -- sherzodR On Mon, 26 Nov 2001, Eva Fransson wrote: I have an application with many table joins and now I would like to get all different Skills that every person in my resultset has concatenated to one string. I would like the code to work like this. select concat_ws(, ,SkillName) as Skills, ..., ... from Skill, ..., ... where ... and ... group by fkEmployeeID order by ... , ... limit 0,20; But it dosn't! Is there some other way to fix this? Eva Fransson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Automatic joins
Well, you could do that with shell scripts (or batch files ). Just write a query pleasing your heart's content, and save it in script and ( or put it into your /bin ) run it whenever you need it. As far as I know, MySQL doesnt' have such built-in feature ( I wish I was wrong) cheers -- sherzodR On Mon, 26 Nov 2001, Wakan wrote: Hi, I'd like to ask for a reply to this (I hope not stupid) question: is there a way to set permanently relationship between tables, so in that way when I ask for something, Mysql automatically joins all tables involved in that relationship? (Like MSAccess, for example) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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.0 fulltext search truncation bug?
Use % instead of *
cheers
--
sherzodR
On 26 Nov 2001, Harald Fuchs wrote:
According to the manual, section New Features of Full-text Search to
Appear in MySQL 4.0:
* `*' is a truncation operator.
The query
SELECT COUNT(*) FROM documents WHERE MATCH(txt) AGAINST ('Versailles')
returns 2, but
SELECT COUNT(*) FROM documents WHERE MATCH(txt) AGAINST ('Versaill*')
returns 0 on MySQL 4.0.
Is this a bug, or do I misunderstand the meaning of truncation?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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
Specifying a different tmp location
Hi, Using MySQL 3.23.43 on Red Hat Linux 6.2, is there a way to tell MySQL to use a different tmp location? I am having problems indexing a large table as mysql bombs out with an out of disk space error int the /tmp directory (which actually has about 500 megs free space). I know there is a command line option --tmpdir but I would prefer a configuration file solution if possible. Many thanks, Martyn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Symbolic Links to Data
Hi, There is an faq on using symbolic links to move databases at http://www.mysql.com/doc/S/y/Symbolic_links.html which covers the details. The gotcha that I fell into was that the mysql user (usually mysql) needs to have rights to the directories that you move the data to. So if you put a database called mydata in a user directory /home/user1 the mysql user needs to have rights to the user1 directory as well as the mydata directory. Hope that makes sense. Kind Regards, Martyn - Original Message - From: Mike(mickalo)Blezien [EMAIL PROTECTED] To: Martyn Wendon [EMAIL PROTECTED] Sent: Sunday, November 25, 2001 10:16 PM Subject: Re: Symbolic Links to Data Hello Martyn, I was follow your thread on this issue of symbolic linking to the clients home directory. I'm in the process of setting up the same type of system, so each client's account database is within their /home/acct_name/ folder, so the disk space used by their database is tacked onto their total allotted disc space instead of in the /var or /usr filesystem. We're on a RH/Linux 6.2 O/S also. Could you be so kind and outline how you set yours up, this would help alot. I have 2 mysql server running. One for development work, and one for our clients. the mysql for the clients is located in the /var/lib/mysql folder, datadir /var/lib/mysql/var/ = database folders I believe your pretty much doing the same thing :) appreciate you time, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Symbolic Links to Data
Hi Edward, I downloaded the latest (3.23.43) binaries for in rpm format from http://www.mysql.com and they installed fine. Kind Regards, Martyn - Original Message - From: [EMAIL PROTECTED] To: Martyn Wendon [EMAIL PROTECTED] Sent: Monday, November 26, 2001 1:06 AM Subject: Re: Symbolic Links to Data Martyn Wendon wrote: Hi Edward, No problems in general with the installation. Everything has been working fine, I need to move the database files as I am running out of space on the /var partition. Kind Regards, Martyn Hello, What version of MySQL ( rpm packages ) is good for Red Hat 6.2 ? And did you try MySQL ( Binary packages , *.tar.gz ) ? What files of rpm packages we need to install into Red Hat 6.2 system ? Thank for your help ! Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Getting to latest 5 Records
On Mon, 26 Nov 2001, Jack wrote: Dear all I had a table which with Auto_increment, which means when i insert a record there will be a number insert to lead as the location of the record. here is my question. I was try to get the most last five records , but i don't know which query should i use? SELECT * FROM mytable ORDER BY autocolumn DESC LIMIT 5; Rgds, Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Specifying a different tmp location
i don't know if this works, but here it goes export TMPDIR=/what/dir/you/want/mysql/to/use /etc/init.d/mysql start something like that or edit the init script see http://www.mysql.com/doc/E/n/Environment_variables.html On Mon, 2001-11-26 at 12:06, Martyn Wendon wrote: Hi, Using MySQL 3.23.43 on Red Hat Linux 6.2, is there a way to tell MySQL to use a different tmp location? I am having problems indexing a large table as mysql bombs out with an out of disk space error int the /tmp directory (which actually has about 500 megs free space). I know there is a command line option --tmpdir but I would prefer a configuration file solution if possible. Many thanks, Martyn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- -·-·-·- Delfim Machado - [EMAIL PROTECTED] SAPO :: Serviço de Apontadores Portugueses - http://www.sapo.pt 'Calço o 40 e uso Linux' · Edson Medina - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Failure to enforce length of fields to index corrupts tables
Thank you for your report. We shall check it out. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem creating primary key on blob column
ERROR 1170 : BLOB column 'MY COLUMN' used in key specification without a key length. What is the syntax to settle a key length ? ALTER TABLE your_table add key blob_field (blob_field(50)); Or, you can create a table like this one: CREATE TABLE `your_table` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(2) NOT NULL default '', `blob_field` TEXT, PRIMARY KEY (`id`), KEY `blob_field` (`blob_field`(20)) # indexed on the first 20 characters of the field ) TYPE=MyISAM BLOB and TEXT field can be indexed on a fixed amount of data only. Therefore you must specify the length of the index. Giuseppe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Date manipulation question .
Hi ! I have a table with 2 coluns with time values , for example, colum START (2001-11-20 23:34:03 , for example) and STOP (2001-11-21 08:34:03 , for example). Given a interval of time, say 8 AM to 8 PM, i need my query to return the total time between START and STOP outside this period. Is this possible to be done with SQL ? Thnx a lot ! Julio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: The source lacks of flex source
Francis S.Lin writes: Hello, I'm trying to build MySQL from source. I've noticed in whether MySQL 3.23.43 or 4.0, for sql/lex.cc and lex.h -- The source for flex to generate these two files is missing!! Although the yacc file (sql_yacc.yy) still exists, I need the lex source because I want to change some token names. Would you please publish the lex source , or it's already published but in somewhere that I've ignored? Thanks, -- piaip, Francis.S.Lin lex.h was not generated, but written by us. lex.cc does not exist. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: concatenate text content in column grouped by another column.
No concatenation is being done in my example. that is what is wrong. the result I get is only one of the SkillName values. I would like all possible SkillNames to be listed in Skills on the same row in the resultset, grouped by fkEmployeeID. I have tried out having and I can not see any need to use it, the problem is still to concatenate the different text strings. Skill table SkillNamefkEmployeeID... c++2 perl 3 c++5 java 2 c 3 java3 I want following rows in my resultset. fkEmployeeIDSkills... 2c++, java 3perl, c, java 5c++ malfunction sql-querrie: select concat_ws(, ,SkillName) as Skills, ..., ... from Skill, ..., ... where ... and ... group by fkEmployeeID order by ... , ... limit 0,20; Eva Fransson - Original Message - Does it throw an error message or output isn't what you expected? In any event, did you try it with HAVING? I couldn't notice anything wrong from what you have there Cheers -- sherzodR On Mon, 26 Nov 2001, Eva Fransson wrote: I have an application with many table joins and now I would like to get all different Skills that every person in my resultset has concatenated to one string. I would like the code to work like this. select concat_ws(, ,SkillName) as Skills, ..., ... from Skill, ..., ... where ... and ... group by fkEmployeeID order by ... , ... limit 0,20; But it dosn't! Is there some other way to fix this? Eva Fransson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Date manipulation question .
Check out DATE_SUB() and DATE_ADD() functions. Those are the one to do the trick. sherzodR On Mon, 26 Nov 2001, Julio Faerman wrote: Hi ! I have a table with 2 coluns with time values , for example, colum START (2001-11-20 23:34:03 , for example) and STOP (2001-11-21 08:34:03 , for example). Given a interval of time, say 8 AM to 8 PM, i need my query to return the total time between START and STOP outside this period. Is this possible to be done with SQL ? Thnx a lot ! Julio - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Arrayoutofindexexception
At 04:01 PM 11/26/2001 +0800, yilmaz wrote: hi all, first of all, since this is a jdbc specific question, you might say i should post to java mysql mailing list, but for some reasons my java mysql subscribtion seems didn't succeed although i got a confirmation and a welcome email. (of course i confirmed my subscribtion) Anyway my request is: can someone tell me please what does ArrayIndexOutOfBoundsException exacly mean? and how can it be solved? i couldn't figure out where the problem is altough i spent almost half working day. below is the error message : java.lang.ArrayIndexOutOfBoundsException at org.gjt.mm.mysql.PreparedStatement.set(PreparedStatement.java:1192) at org.gjt.mm.mysql.PreparedStatement.setString(PreparedStatement.java:581) at org.apache.jsp._0002fay_0002fmember_jsp._jspService(_0002fay_0002fmember_jsp .java:178) . i have exactly same number of column names as variables in preparedstatemnet and same number of ? marks. i am using mySQL version 3.23 with tomcat 4.0 b7 under win 2000. Can anyone help me please? thanks in advance wish everybody a day without troubles :) Check out: http://java.sun.com/products/jdk/1.2/docs/api/java/lang/ArrayIndexOutOfBoundsException.html I got this from a quick search on Google of ArrayIndexOutOfBoundsException HTH Joseph Roth [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL 4.0 fulltext search truncation bug?
Hi!
On Nov 26, sherzodR wrote:
Use % instead of *
cheers
--
sherzodR
On 26 Nov 2001, Harald Fuchs wrote:
According to the manual, section New Features of Full-text Search to
Appear in MySQL 4.0:
* `*' is a truncation operator.
The query
SELECT COUNT(*) FROM documents WHERE MATCH(txt) AGAINST ('Versailles')
returns 2, but
SELECT COUNT(*) FROM documents WHERE MATCH(txt) AGAINST ('Versaill*')
returns 0 on MySQL 4.0.
Is this a bug, or do I misunderstand the meaning of truncation?
First - no, according to the manual '*' is a truncation operator, not
'%', so your syntax is correct.
Second - probably it's a bug. I cannot say much as the code used by this
query was removed from MySQL source tree. It was replaced by completely
new boolean search engine written from scratch. Unfortunately it was
done several days _after_ 4.0.0 release.
Wait for 4.0.1 - it should be out in a few days.
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: Arrayoutofindexexception
I already checked java api docs, but it doesn't provide any information nor any help. Since usually error messages and docs doesn't give a user friendly and helpful info, i hope somebody who already faced the same problem could give me some hints about what could be the reason. thanks for taking time cheers :) Original Message - From: Joseph Roth [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 26, 2001 9:41 PM Subject: Re: Arrayoutofindexexception At 04:01 PM 11/26/2001 +0800, yilmaz wrote: hi all, first of all, since this is a jdbc specific question, you might say i should post to java mysql mailing list, but for some reasons my java mysql subscribtion seems didn't succeed although i got a confirmation and a welcome email. (of course i confirmed my subscribtion) Anyway my request is: can someone tell me please what does ArrayIndexOutOfBoundsException exacly mean? and how can it be solved? i couldn't figure out where the problem is altough i spent almost half working day. below is the error message : java.lang.ArrayIndexOutOfBoundsException at org.gjt.mm.mysql.PreparedStatement.set(PreparedStatement.java:1192) at org.gjt.mm.mysql.PreparedStatement.setString(PreparedStatement.java:581) at org.apache.jsp._0002fay_0002fmember_jsp._jspService(_0002fay_0002fmember_js p .java:178) . i have exactly same number of column names as variables in preparedstatemnet and same number of ? marks. i am using mySQL version 3.23 with tomcat 4.0 b7 under win 2000. Can anyone help me please? thanks in advance wish everybody a day without troubles :) Check out: http://java.sun.com/products/jdk/1.2/docs/api/java/lang/ArrayIndexOutOfBound sException.html I got this from a quick search on Google of ArrayIndexOutOfBoundsException HTH Joseph Roth [EMAIL PROTECTED] _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 v4 FTS speed (Was: MySQL 4.0 fulltext search truncation bug?)
Second - probably it's a bug. I cannot say much as the code used by this query was removed from MySQL source tree. It was replaced by completely new boolean search engine written from scratch. Unfortunately it was done several days _after_ 4.0.0 release. Wait for 4.0.1 - it should be out in a few days. Question - how much (if any) performance improvement is to be expected from the new boolean search engine for FTS in 4.0.1? Regards. Gordan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqldump question
Hi. Suppose I have dumped all database tables using mysqldump with --tab=... option and I've got some *.sql and *.txt files one per table. Ok, through the some time I want to see how changed a table living in server compared with it's old copy I have dumped early. I've decided to use some of them (in shell script): ... diff database_dump/Mtable.txt `mysqldump appropriate options --databases MYdatabase --tables MYtable` ... and make a conclusions depending of diff output. But according to well known SQL standarts the order of stored records is undefined. However, using MySQL I note that the order of records output is the same as order of records input in the table and it isn't violates while queries like SELECT * FROM table are performed. The question is: may I be sure I'll get absolutely identical dump result for unchanged table with mysqldump used at different times ? Thank you for attantion. Goodbye. Dannis. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Load Data Infile
database,sql,query,table Hi guys, Can any one told me - with my great appreciate - how to load a data from txt file into a specific column? Thanks. Hytham Shehab _ This message was sent using Menanet MenaMail. http://www.menanet.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Data Infile
http://www.mysql.com/doc/L/O/LOAD_DATA.html Elm database,sql,query,table Hi guys, Can any one told me - with my great appreciate - how to load a data from txt file into a specific column? Thanks. Hytham Shehab _ This message was sent using Menanet MenaMail. http://www.menanet.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
working mysqlhotcopy.pl for mysql for mysql 3.23.44 (win)?
Hello! Can anybody, please, hook me up with a working mysqlhotcopy.pl script for mysql 3.23.44 (win)? Shame is I don't know Perl much... Maybe somebody could give some hints on what to change in original script to make it working... Thanks a lot! - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: opinion - voating
Oracle is certainly more full-featured, but if you know very little about databases, Oracle is not the right choice. Only use Oracle if you have a full-time fix-figure-salary Oracle expert AND you actually need Oracle's features. If you don't specifically know you need Oracle, you don't. On Wednesday 21 November 2001 09:45 pm, Mamun Murtaza Sheriff wrote: Dear All You all are working on Database for Long time. In your opinion Which one is best 1. MySql or 2. Oracle Mamun - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 and encryption
Oh you're actually from MySQL -- I didn't notice that. That'll be very cool when you get that finished. Also, having a datatype specifically for credit card numbers would be cool. :) On Thursday 22 November 2001 09:52 pm, Michael Widenius wrote: Hi! Ken == Ken Kinder [EMAIL PROTECTED] writes: Ken Monty, is this like a product you're selling? I would like more information, Ken although I haven't gotten to this yet in my security sweep. This is something a customer of our is sponsoring and that we will put into MySQL 4.0 as soon as it's ready. We will probably also make available a patch for 3.23, but we don't have any plans to put this code into the standard 3.23 code tree to not accidently break anything for a lot of users.. We are working on a solution to this which will be available in about 3 weeks. Some of the features of this are: - We will use a strong encryption function: (des_encrypt()/des_decrypt()) ... 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
Re: Date Manipulation.
Is there anything like a to_hours() function ? I need my query to to calculate how much time there is between two time values - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: API documentation issue : inconsistency in mysql_real_connectdocumentation
On Sat, 24 Nov 2001, Sinisa Milivojevic wrote: I think that our documentation is quite clear on that issue. . . . Not quite: For a successful connection, the return value is the same as the value of the first parameter, unless you pass NULL for that parameter. (Manual) That is, if you pass NULL, the result value is _not_ the same as NULL. So, if you indeed pass NULL, the result is either (1) an invalid pointer (pointing to no object that makes sense), or (2) a valid one, in which case it must point to a MYSQL structure. Now, if (1), you can not possibly test the result, can you? You are in a limbo. If (2), the MYSQL structure must be a newly created one, since you did not pass any! And voila, you have created a MYSQL structure without mysql_init (this is of course is in contradiction with the rest of the documentation). Cheers, -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351+226003654 A L V E S P-4150-180 PORTO, Portugalmob 351+939354002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
the official name of 3.23.45 source
Hello all, Can anyone tell me the official name of the MySQL 3.23.45 source code file that is downloaded from the web site (www.mysql.com)? I normally grab it with curl off of my local mirror but they didn't have it yet so I used Internet Explorer to grab the file from another (random) mirror -- but the file is called download.php (which I assume is because the mirror dynamically served that page or something). I have the source code and would like to make sure that it's named consistently, otherwise I'll end up with a bunch of download.php source code files in my source code directory over time. The 3.23.44 file was called mysql-3.23.44.tar.gz , but I don't want to make an assumption about the filename. Thanks! Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: API documentation issue : inconsistency in mysql_real_connect documentation
On Mon, 26 Nov 2001, Sinisa Milivojevic wrote: Quentin Bennett writes: So, if you pass NULL in as the first parameter to mysql_real_connect, a possibility opened up by the manual . . . There is no indication in our documentation that NULL should be passed as a first parameter in mysql_real_connect. Of course not, and that is very good sense ;-) But there is a clear indication that it _can_: For a successful connection, the return value is the same as the value of the first parameter, unless ***you pass NULL for that parameter***. See my previous response to Sinisa for the extraordinary consequencies of passing NULL ;-) Cheers, -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351+226003654 A L V E S P-4150-180 PORTO, Portugalmob 351+939354002 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: the official name of 3.23.45 source
Try here: ftp://mysql.valueclick.com/pub/mysql/Downloads/MySQL-3.23/mysql-3.23.45.tar.gz I always find this FTP site with the most up-to-date files and is very reliable! :) On Mon, 26 Nov 2001 10:17:22 -0500, Erik Price [EMAIL PROTECTED] wrote: Can anyone tell me the official name of the MySQL 3.23.45 source code file that is downloaded from the web site (www.mysql.com)? I normally grab it with curl off of my local mirror but they didn't have it yet so I used Internet Explorer to grab the file from another (random) mirror -- but the file is called download.php (which I assume is because the mirror dynamically served that page or something). I have the source code and would like to make sure that it's named consistently, otherwise I'll end up with a bunch of download.php source code files in my source code directory over time. The 3.23.44 file was called mysql-3.23.44.tar.gz , but I don't want to make an assumption about the filename. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: opinion - voating
This kind of voting is reductive as i for instance would answer both. They both have its uses, and wise is the one that can recognize when to use one or the other... Cheers, Luis Ferro WebDev -Original Message- From: Ken Kinder [mailto:[EMAIL PROTECTED]] Sent: segunda-feira, 26 de Novembro de 2001 15:46 To: Mamun Murtaza Sheriff; [EMAIL PROTECTED] Subject: Re: opinion - voating Oracle is certainly more full-featured, but if you know very little about databases, Oracle is not the right choice. Only use Oracle if you have a full-time fix-figure-salary Oracle expert AND you actually need Oracle's features. If you don't specifically know you need Oracle, you don't. On Wednesday 21 November 2001 09:45 pm, Mamun Murtaza Sheriff wrote: Dear All You all are working on Database for Long time. In your opinion Which one is best 1. MySql or 2. Oracle Mamun - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mac OS X and MySQL 3.23.45
At 6:22 AM -0800 11/26/01, Erik Price wrote: 1) Will there be a binary for MySQL 3.23.45 for MacOS X 10.0.x (Darwin 1.3.x)? Isn't there one there? On the Downloads section of the site? I just wish my local mirror was updated to include it No, it is not found on Downloads for the 3.23 version at: http://www.mysql.com/downloads/mysql-3.23.html Look for: MacOS X downloads Binary packages (tar.gz) MySQL 3.23.45 MacOS X Server 1.x (PowerPC) (4.7M) MySQL 3.23.43 MacOS X 10.0.x (Darwin 1.3.x) (PowerPC) (4.6M) 2) How do I find out what options are compiled into the binary? I'm not sure. Someone else could take a stab at this? I suppose I could compile my own, but the binary is a lot more convenient. I am just wondering if any special options were included. I suppose then that it is the default. I use the source and 3.23.44 has worked fine for me (except the shutdown problem). I'm going to compile 3.23.45 now and see how it goes. On: http://www.mysql.com/doc/N/e/News-3.23.45.html It says: shutdown should now work on Darwin (Mac OS X). -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: the official name of 3.23.45 source
Thanks! I'll change the name from download.php to mysql-3.23.45.tar.gz in my source directory, and I'll remember the valuclick mirror. I'm assuming that's in N. America somewhere. Erik On Monday, November 26, 2001, at 11:29 AM, Mike(mickalo)Blezien wrote: Try here: ftp://mysql.valueclick.com/pub/mysql/Downloads/MySQL-3.23/mysql-3.23.45.tar. gz I always find this FTP site with the most up-to-date files and is very reliable! :) On Mon, 26 Nov 2001 10:17:22 -0500, Erik Price [EMAIL PROTECTED] wrote: Can anyone tell me the official name of the MySQL 3.23.45 source code file that is downloaded from the web site (www.mysql.com)? I normally grab it with curl off of my local mirror but they didn't have it yet so I used Internet Explorer to grab the file from another (random) mirror -- but the file is called download.php (which I assume is because the mirror dynamically served that page or something). I have the source code and would like to make sure that it's named consistently, otherwise I'll end up with a bunch of download.php source code files in my source code directory over time. The 3.23.44 file was called mysql-3.23.44.tar.gz , but I don't want to make an assumption about the filename. Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Using Berkeley tables -- how to set up?
I'm a relative newbie to MySQL (most of my experience is with Oracle) and am currently trying to set things up to use the Berkeley tables with transaction processing. I downloaded the mysql-3.23.44.tar.gz source and installed it on Linux Red Hat 6.2. I configured it with the --with-berkeley-db option, and doing a mysqladmin variables shows have_bdb variable=yes and a number of bdb variables enabled. I started up the mysql daemon using safe_mysqld with the --bdb_logdir option. The daemon started okay. But, when I log into mysql and do a show logs nothing is returned. I set autocommit to 0 and created a test table but doing a rollback or commit after inserting rows returns the message: ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back. SO, I'm obviously doing something horribly wrong here. Anybody have any ideas what I'm missing? Anybody out there using Berkeley tables? I'm currently a bit perplexed. Thanks, --Walt Weaver Bozeman, Montana - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mac OS X and MySQL 3.23.45
On Monday, November 26, 2001, at 11:34 AM, Michael Collins wrote: No, it is not found on Downloads for the 3.23 version at: http://www.mysql.com/downloads/mysql-3.23.html Look for: MacOS X downloads Binary packages (tar.gz) MySQL 3.23.45 MacOS X Server 1.x (PowerPC) (4.7M) MySQL 3.23.43 MacOS X 10.0.x (Darwin 1.3.x) (PowerPC) (4.6M) Michael, I just realized that the binary there is for Mac OS X Server, not client. I'm sorry. I didn't notice the difference at first. I suppose I could compile my own, but the binary is a lot more convenient. I am just wondering if any special options were included. I suppose then that it is the default. You're right, it's a lot quicker. I just compiled 3.23.45 with these options (following instructions from http://developer.apple.com/internet/macosx/osdb.html ): localhost:mysql-3.23.45$ ./configure --prefix=/usr/local/mysql \ --with-unix-socket-path=/usr/local/mysql/run/mysql_socket \ --with-mysql-user=mysqladm \ --with-comment \ --with-debug make sudo make install And that overwrote my old 3.23.44 source install (which had the same configure options) but preserved the data in my /usr/local/mysql/var directory. Also, it looks like the owners and groups of the directories are also all intact (I think make install takes care of this by default). The directory tree for the binary is a bit different (I tried it once) but this setup seems to work for me -- the bin/mysqladmin shutdown command works great now!! (No more flush tables ; kill -9 %1 or any of that!) My thanks to the developers for taking into account the needs of Darwin users in their work -- we won't be a minority for long! Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MyODBC: DSN Creation
Hi All, I need to setup MyODBC DSN's for MySQL access. Does anyone know how to build a simple installer that will create User/System DSN's from a file? ie. like the odbc.inf file included with the MyODBC installer? Can odbcconf.exe be used to install a DSN? If so, what are the parameters used to create a DSN, can you give me a good example. Many 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
Re: MySQL v4 FTS speed (Was: MySQL 4.0 fulltext search truncation bug?)
Sergei Golubchik wrote: Hi! I didn't test it yet. The one thing I can say just now that unlike natural language search code (as exists in MySQL in 3.23) it need not to build the complete list of matched documents in memory in advance. It means that with LIMIT it should be MUCH faster than the old code. Unfortunately, it also means that it does not auto-magically return documents with relevance decreased (without ORDER BY, that is). If I use ORDER BY relevance and LIMIT. Does it need to build the complete list of documents in memory in advance? Or will it just build enough to satisfy the limit constraints. Regards, Sergei - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 UNION problem
Tony Bailey writes: I've been trying MySQL 4 alpha (Windows build) as I need UNION but can't work out how to get the query I need against the version without the union [skip] 2) select count(docs.docid) as score, docs.docdate, docs.docid, docs.docsection, docs.docsubdir, docs.docmsgid, docs.sendername, DATE_FORMAT(docs.docdate, '%W %M %D %Y') as thedate, doctitle from docs, wdocid_pa where wdocid_pa.docid = docs.docid and docs.docdate FROM_UNIXTIME(975228544) AND wdocid_pa.wordid=495 GROUP by docs.docid UNION ALL select count(docs.docid) as score, docs.docdate, docs.docid, docs.docsection, docs.docsubdir, docs.docmsgid, docs.sendername, DATE_FORMAT (docs.docdate, '%W %M %D %Y') as thedate, doctitle from docs, wdocid_ca where wdocid_ca.docid = docs.docid and docs.docdate FROM_UNIXTIME(975228544) AND wdocid_ca.wordid=136 GROUP by docs.docid UNION ALL select count(docs.docid) as score, docs.docdate, docs.docid, docs.docsection, docs.docsubdir, docs.docmsgid, docs.sendername, DATE_FORMAT(docs.docdate, '%W %M %D %Y') as thedate, doctitle from docs, wdocid_bo where wdocid_bo.docid = docs.docid and docs.docdate FROM_UNIXTIME(975228544) AND wdocid_bo.wordid=1646 GROUP by docs.docid ORDER by score DESC, docdate DESC, docid DESC LIMIT 0, 10 TIA Tony What exactly does not work with query number 2 ??? Please explain in more detail. Also, upload your tables to ftp://support.mysql.com:/pub/mysql/secret tarred and gzipped and let me know a filename. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Using Berkeley tables -- how to set up?
Okay, unregard my question. I figured out what I was doing wrong. It's too embarrassing to tell you guys. Thanks, --Walt -Original Message- From: Weaver, Walt Sent: Monday, November 26, 2001 9:52 AM To: [EMAIL PROTECTED] Subject: Using Berkeley tables -- how to set up? I'm a relative newbie to MySQL (most of my experience is with Oracle) and am currently trying to set things up to use the Berkeley tables with transaction processing. I downloaded the mysql-3.23.44.tar.gz source and installed it on Linux Red Hat 6.2. I configured it with the --with-berkeley-db option, and doing a mysqladmin variables shows have_bdb variable=yes and a number of bdb variables enabled. I started up the mysql daemon using safe_mysqld with the --bdb_logdir option. The daemon started okay. But, when I log into mysql and do a show logs nothing is returned. I set autocommit to 0 and created a test table but doing a rollback or commit after inserting rows returns the message: ERROR 1196: Warning: Some non-transactional changed tables couldn't be rolled back. SO, I'm obviously doing something horribly wrong here. Anybody have any ideas what I'm missing? Anybody out there using Berkeley tables? I'm currently a bit perplexed. Thanks, --Walt Weaver Bozeman, Montana - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Date Manipulation.
On Mon, 26 Nov 2001, Julio Faerman wrote: Is there anything like a to_hours() function ? I need my query to to calculate how much time there is between two time values Julio, have a look at the UNIX_TIMESTAMP(date) and FROM_UNIXTIME(unix_timestamp) functions. These allow to convert a date to seconds. Then you do your maths, calculate a difference and convert back to any format you like. Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Suggestion: Formatting TimeStamp columns
Displaying timestamp columns are a PIK (pain in keester) if you ask me.g A Select statement will display the TmeStamp as 2005095105. Now I ask you, how many users will understand this format? Why not display TimeStamp in the same format as DateTime? At least then the TimeStamp is in a meaningful representation that users can understand. The only way around this is to use the Date_Format on every TimeStamp column in every SQL statement. which produces a lot of unnecessary work for the developer. I'm not saying to change the input format. Inputting the TimeStamp data can be kept the same, but it should have a default display format similar to DateTime. The actual format for TimeStamp and DateTime could be stored in the my.cnf or my.ini file so the display format can be adjusted on the server. This format string could be the parameter used in the Date_Format function. What do you think? Brent - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: API documentation issue : inconsistency in mysql_real_connectdocumentation
M. A. Alves writes: On Sat, 24 Nov 2001, Sinisa Milivojevic wrote: Not quite: For a successful connection, the return value is the same as the value of the first parameter, unless you pass NULL for that parameter. (Manual) Cheers, -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351+226003654 A L V E S P-4150-180 PORTO, Portugalmob 351+939354002 This SHOULD be fixed. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL 3.23 Manual
Where can I find a copy of the latest MySQL 3.23 manual? All I've been able to find is the newer 4.x. A. Clausen [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
Binary Log Question
This is my second time posting this question to the mailing list. I received no responses the first time I posted this. In the MySQL documentation, it states that the binary log will be replacing the update log, and it should be used in its place as it can do anything the update log can. I'm not sure this is the case. The update log shows where the individual connections connect from and what user connected. I do not see that in the binary logs when I run mysqlbinlog on them. I checked the options for mysqlbinlog and did not see any options for generating more detail. Does the binary log contain this information, and if so how do I get retrieve it? I really need this info for auditing purposes. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: MyODBC: DSN Creation
Hi Kevin, -Original Message- From: Kevin Smith [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 9:25 AM To: [EMAIL PROTECTED] Subject: MyODBC: DSN Creation Hi All, I need to setup MyODBC DSN's for MySQL access. Does anyone know how to build a simple installer that will create User/System DSN's from a file? ie. like the odbc.inf file included with the MyODBC installer? Can odbcconf.exe be used to install a DSN? If so, what are the parameters used to create a DSN, can you give me a good example. Many thanks, You can make use of 'myodbc.rsp' file that comes with the binary distribution, which configures MyODBC and the sample DSN using odbcconf.exe. The simple command for this is odbcconf /f myodbc.rsp Here is the myodbc.rsp that is included in the distribution for 2.50.40 version. INSTALLDRIVER MySQL Driver|Driver=myodbc.dll|Setup=myodbc.dll|| CONFIGDRIVER MySQL Driver APILevel=2 CONFIGDRIVER MySQL Driver ConnectFunctions=YYN CONFIGDRIVER MySQL Driver DriverODBCVer=2.50.40 CONFIGDRIVER MySQL Driver FileUsage=0 CONFIGDRIVER MySQL Driver FileExtns=*.txt CONFIGDRIVER MySQL Driver SQLLevel=1 CONFIGDRIVER MySQL Driver CPTimeout=60 CONFIGDSN MySQL Driver DSN=sample-MySQL;Description=MySQL ODBC Driver;SERVER=database_server;User=odbc;DB=test;Port=3306|| Regards, venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mr. Venu [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Date Manipulation.
Well, to do date calculations, use DATE_SUB() and DATE_ADD() functions. To convert to some other functions, use DATE_FORMAT() function. For templates that DATE_FORMAT() needs, please refer to documentation. There're bunch of'em -- sherzodR On Mon, 26 Nov 2001, Thomas Spahni wrote: On Mon, 26 Nov 2001, Julio Faerman wrote: Is there anything like a to_hours() function ? I need my query to to calculate how much time there is between two time values Julio, have a look at the UNIX_TIMESTAMP(date) and FROM_UNIXTIME(unix_timestamp) functions. These allow to convert a date to seconds. Then you do your maths, calculate a difference and convert back to any format you like. Thomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Beginner - Login to mysqladmin
help, I have a problem. I cannot access the mysqladmin fully. I know the only existing users and the passwd's (without root). I can use mysqladmin while modifying a table with one of their access'. I know the root to the (Linux)server, but mysql must have a different one. How can I find out what's wrong? Linux 6.0 (Hedwig) Perl 5 MySQL 3.22.32 thx, john - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mac OS X and MySQL
Now that the shutdown command has been repaired, are there other outstanding issues specific to Mac OS X that the MySQL AB team has under development for MySQL 3.x? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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! Hosed Database!
But I have a backup, if I just knew how to restore it! The instructions read: #mysqldump --opt database_name database_name_File.txt To restore database: #cat database_name_File.txt | /path/to/mysql -u username -p database_name So, if my installation is at /apache/mysql and the database is /apache/mysql/lefeber and my backup is /apache/mysql/lefeber.txt then I should be able to issue this command: cat lefeber.txt | /apache/mysql -u MyUserName -pMyPassword lefeber Why does it tell me that /apache/mysql is a directory (duh) and break the pipe? BenO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - Got Signal 11 - URGENT
On Monday 26 November 2001 09:55 am, Jonathan Hilgeman wrote: I have an app that uses about 6-7 databases. But the MySQL server is now restarting a lot. I was having a problem with this before - I had about 267 restarts in a matter of a month or two. I shut down the server, ran myisamchk on the databases and it found a lot of open connections, and I guess closed them. I ran MySQL again and it seemed to be fixed for a while. I left work for the holiday weekend and came back. Now I've got close to 2000 log files in a matter of a few days. It appears that it's restarting approximately every 15 seconds. The error log simple contains: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 011125 07:24:14 mysqld restarted Over and over and over again. It's filled with these messages, one after another. I'm running 3.23.36-log - any ideas? - Jonathan Is this RedHat binary? If yes, replace it with 3.23.45 binary from our site. The problem with RedHat binary is that it is compiled with gcc 2.96 which has bugs that affect MySQL. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
display size of integers
I have a rhetorical question. I'm learning as much as I can about MySQL. There is one little detail that I don't *have* to know the answer to, but I'm curious about. Don't waste your time replying if you're busy. It appears that the display width is an option for certain types of numeric columns. For instance, SMALLINT(3) UNSIGNED which would be a number from 0 to 65535 with a display size of 3 characters in width, unless the value was greater than 3 characters in width, in which case all of the characters would be displayed. What is the point of specifying a width? I only see it being useful in combination with the ZEROFILL attribute, which would add leading zeros up to the display width if the number is fewer characters than the display width. Otherwise, it seems to serve little purpose. Would anyone mind shedding some light on this? Thank you, Erik - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mac OS X and MySQL
Michael Collins writes: Now that the shutdown command has been repaired, are there other outstanding issues specific to Mac OS X that the MySQL AB team has under development for MySQL 3.x? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com No, there are no outstanding OS X issues on our TODO. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: HELP! Hosed Database!
hi. /path/to/mysql means the path to the mysql _executable_... type 'which mysql' to see for sure, but it might be /apache/mysql/bin/mysql. good luck. -ravi. -Original Message- From: Ben Ocean [mailto:[EMAIL PROTECTED]] Sent: November 26, 2001 2:38 PM To: [EMAIL PROTECTED] Subject: HELP! Hosed Database! But I have a backup, if I just knew how to restore it! The instructions read: #mysqldump --opt database_name database_name_File.txt To restore database: #cat database_name_File.txt | /path/to/mysql -u username -p database_name So, if my installation is at /apache/mysql and the database is /apache/mysql/lefeber and my backup is /apache/mysql/lefeber.txt then I should be able to issue this command: cat lefeber.txt | /apache/mysql -u MyUserName -pMyPassword lefeber Why does it tell me that /apache/mysql is a directory (duh) and break the pipe? BenO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: opinion - voating
On Mon, 26 Nov 2001, Ken Kinder wrote: Oracle is certainly more full-featured, but if you know very little about databases, Oracle is not the right choice. I agree. First of all the system requirements are high. For instance the Oracle Universal Installer took something like three hours on a fairly high end PIII with 133MHz FSB! I have heared it takes for ages (up to a whole day) on other machines. This is not the worse part either. Have you ever used the sqlplus command line utility (which is the equivalent of the mysql command line tool or PostgreSQL's psql command line client). Well, sqlplus assumes your terminal is 24x80 even after you resize it. At least this is so with Oracle8i. I can tell you this: you won't learn much with a crappy tool like that cause as soon as you have more than two columns you won't be able to see the output in human readable form. Now my other point: Oracle8i is highly non-SQL compliant (although Oracle9i seems to be a little bit better). My last point about Oracle is that it is based on Java (see that JServer stuff when you start sqlplus?) and that is perhaps one of the reason it needs so much RAM. With a bit of bias we could conclude that if it were not for its disk and address space requirements then Oracle would be a fairly sluggish beast. Only use Oracle if you have a full-time fix-figure-salary Oracle expert AND you actually need Oracle's features. If you don't specifically know you need Oracle, you don't. Exactly. If I had the choice I would stay away from Oracle. Plus Oracle does not have good enough documentation either compared to most Open source products. Now there is one thing that we must be aware of. There are things that mysql does not support (yet). These include foreign keys, views, subselects, triggers, and procedural SQL, and I can't remember if mySQL supports transaction processing either, perhaps someone can confirm. However, mysql is much faster than other database system so you may still want to use it depending on the complexity of your database. If your database is not complex or if you do not need subselects then go with mysql. Most of the time you can get around all of this by recoding some things here and there. But if you are just learning go with postgresql, which will be slower, but will support all this stuff you need to know about databases. Once you have tested your application under postgresql and are certain that your code does not violate the database's foreign key constraint, simply run it under mysql after the testing phase. Then your code will run faster and at the same time free of errors. This is just my own personal recommendation for relatively small applications. Bye, Neil On Wednesday 21 November 2001 09:45 pm, Mamun Murtaza Sheriff wrote: Dear All You all are working on Database for Long time. In your opinion Which one is best 1. MySql or 2. Oracle Mamun - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
help understanding memory usage
I am trying to understand how MySQL uses memory when executing a query on a large table. The server is running on RedHat 6.0 with pentium III 750 Mhz processor and 2 Gig of RAM. I have my key_buffer_size set to 1600MB. My table cache is set at 512. When I run top, I get the following out put: Mem: 4193280K av, 1275776K used, 2917504K free, 0K shrd, 0k buff Swap: 0K av,0K used, 0k free 0k cached PIDUSERPRINISIZERSSSHARESTATLIB%CPU %MEMTIMECOMMAND 5065mysql 0 0330M 330M1608 S 327M 0.08.0 0:02 mysqld 5067mysql 120330M 330M1608 S 327M 0.08.0 0:01 mysqld 5068mysql 0 0330M 330M1608 S 327M 0.08.0 0:03 mysqld 4398mysql 0 0330M 330M1608 S 327M 0.08.0 0:00 mysqld When I fisrt start mysqld, the SIZE, RSS, and LIB are much smaller and they slowly increase as I run the query on the large table. The table contains 47,000,000 plus records. I have the fields indexed and when I use the EXPLAIN command, it shows that MySQL is using the indexes properly. I am look for suggestions on how to make the query faster. I have read the suggestions in the manual and tried them, but nothing seems to improve the performance. Have I reached the a limitation of MySQL on my hardware setup? Thanks, Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
[OT] PostgreSQL book
Hello, I know this is offtopic, but the new PostgreSQL book from OReilly is in production. You can read it online at http://www.postgresql.info/ . No we are not trying to start a flame war, but there is some really good info on SQL queries in the book. It may be useful to some MySQL folk. J - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mac OS X and MySQL
At 1:49 PM -0600 11/26/01, john wrote: this is not meant to be demeaning, but your not seriousely running a server with a Mac are you? And why not? Are you at all familiar with Mac OS X and/or Darwin? It is Unix BSD. Seems a fine choice for MySQL. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: HELP! Hosed Database!
Beno, I cannot believe I am a beginner and the pro developer Mr. Sinisa Milivojevic [EMAIL PROTECTED] could not answer your question. I believe you are reading/issuing the command incorrectly. The pro developer Mr. Sinisa Milivojevic [EMAIL PROTECTED] did not read your email properly. use: cat lefeber lefeber.txt | /apache/mysql -u MyUserName -pMyPassword lefeber If I am incorrect, please advise. Someone please help to rid the world of the underscore and it's many mis-interpretations, john -Original Message- From: Ben Ocean [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 1:38 PM To: [EMAIL PROTECTED] Subject: HELP! Hosed Database! But I have a backup, if I just knew how to restore it! The instructions read: #mysqldump --opt database_name database_name_File.txt To restore database: #cat database_name_File.txt | /path/to/mysql -u username -p database_name So, if my installation is at /apache/mysql and the database is /apache/mysql/lefeber and my backup is /apache/mysql/lefeber.txt then I should be able to issue this command: cat lefeber.txt | /apache/mysql -u MyUserName -pMyPassword lefeber Why does it tell me that /apache/mysql is a directory (duh) and break the pipe? BenO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 - Got Signal 11 - URGENT
From: Jonathan Hilgeman [EMAIL PROTECTED] On a related note, any Perl gurus know how to force a Perl cron job to stay below a certain CPU utilization? Not a Perl thing. Do a man on 'nice'. --- Rodney Broom Programmer: Desert.Net Spam filter: sql database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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! Hosed Database!
On Mon, 26 Nov 2001, john wrote: use: cat lefeber lefeber.txt | /apache/mysql -u MyUserName -pMyPassword lefeber I have this strange feeling that the line should read cat lefeber.txt | /apache/mysql/bin/mysql -u user -ppass lefeber But let's see who of us are right =) Sincerely, Jan -- Mr. Jan-Aage Bruvoll IT Project Manager 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich Zurich office: +41 1 307 4293, fax: +41 1 307 4281 Office/fax: +44 2072408283 Mobile: +44 7740291600 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mac OS X and MySQL
Excuse me, but I never intended on adding the world to that question, and your defensive response tells me you have to fight for trash you are using. I have utilized the Mac OS X long enough to run far far far away. Until you can get a grip on criticsm, ease off buddy. Your gonna give yourself an aneurysm. -Original Message- From: Michael Collins [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 1:59 PM To: john; MySQL List Subject: RE: Mac OS X and MySQL At 1:49 PM -0600 11/26/01, john wrote: this is not meant to be demeaning, but your not seriousely running a server with a Mac are you? And why not? Are you at all familiar with Mac OS X and/or Darwin? It is Unix BSD. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: HELP! Hosed Database!
my mistake, I copied the line and forgot to remove the first lefeber. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 2:36 PM To: john Cc: Ben Ocean; [EMAIL PROTECTED] Subject: RE: HELP! Hosed Database! On Mon, 26 Nov 2001, john wrote: use: cat lefeber lefeber.txt | /apache/mysql -u MyUserName -pMyPassword lefeber I have this strange feeling that the line should read cat lefeber.txt | /apache/mysql/bin/mysql -u user -ppass lefeber But let's see who of us are right =) Sincerely, Jan -- Mr. Jan-Aage Bruvoll IT Project Manager 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich Zurich office: +41 1 307 4293, fax: +41 1 307 4281 Office/fax: +44 2072408283 Mobile: +44 7740291600 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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! Hosed Database!
On Mon, 26 Nov 2001, john wrote: my mistake, I copied the line and forgot to remove the first lefeber. Mmm no, what I was referring to was that Ben might be confusing installation directory with mysql binary location. I think we all mean the latter in this case. Which would then be '/apache/mysql/bin/mysql', I think. Sincerely, Jan -- Mr. Jan-Aage Bruvoll IT Project Manager 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich Zurich office: +41 1 307 4293, fax: +41 1 307 4281 Office/fax: +44 2072408283 Mobile: +44 7740291600 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 v4 FTS speed
Hi! On Nov 26, Mike Wexler wrote: Sergei Golubchik wrote: Hi! I didn't test it yet. The one thing I can say just now that unlike natural language search code (as exists in MySQL in 3.23) it need not to build the complete list of matched documents in memory in advance. It means that with LIMIT it should be MUCH faster than the old code. Unfortunately, it also means that it does not auto-magically return documents with relevance decreased (without ORDER BY, that is). If I use ORDER BY relevance and LIMIT. Does it need to build the complete list of documents in memory in advance? Or will it just build enough to satisfy the limit constraints. It will build enough to satisfy the limit constraints, but with ORDER BY this enough is the complete list. If you want to get five rows with highest relevances MySQL will retrieve all the matching rows, sort them with relevance decreasing, and then return top five rows. But it should not be a big deal as for boolean searches there's no meaningful relevance anyway. It's boolean - true or false. Some floating point relevance is introduced to give a rough estimation of the number of words matched, but, in fact, all the rows in the result set are equally relevant to the query with relevance value TRUE. 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
Move a column
Hi! Is it not possible to move a mysql column to after another existing Column by using the CHANGE statement in ALTER TABLE? I have the following columns: id ostron newCol_2 And I'd like to move the ostron-column to after the newCol_2 column. Is this not the syntax? ALTER TABLE enum_test CHANGE ostron ostron int(4) NULL DEFAULT '0' AFTER newCol_2 \david - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL4 and SSL using Java API
Hi, Could anyone help me with where I could find more information about how to use SSL and let Java connect to MySQL using SSL?? Thanks, Sebastian (http://bast-i.dyndns.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: MySQL - Got Signal 11 - URGENT
Hi Johnathon, If you are running on FreeBSD 4.2 or earlier you will have random problems, espcially 4.1, it had compiler and thread bugs. FreeBSD 4.3 and 4.4 work very nicely and have all known thread problems fixed. Best of Luck Ken - Original Message - From: Jonathan Hilgeman [EMAIL PROTECTED] To: 'Sasha Pachev' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, November 26, 2001 2:48 PM Subject: RE: MySQL - Got Signal 11 - URGENT No - it's a FreeBSD binary, I believe. However, I noticed that there were two perl scripts running that got stuck in infinite loops and were taking up 99% of the CPU. After killing them, it seems to be stable... On a related note, any Perl gurus know how to force a Perl cron job to stay below a certain CPU utilization? - Jonathan -Original Message- From: Sasha Pachev [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 11:39 AM To: Jonathan Hilgeman; [EMAIL PROTECTED] Subject: Re: MySQL - Got Signal 11 - URGENT On Monday 26 November 2001 09:55 am, Jonathan Hilgeman wrote: I have an app that uses about 6-7 databases. But the MySQL server is now restarting a lot. I was having a problem with this before - I had about 267 restarts in a matter of a month or two. I shut down the server, ran myisamchk on the databases and it found a lot of open connections, and I guess closed them. I ran MySQL again and it seemed to be fixed for a while. I left work for the holiday weekend and came back. Now I've got close to 2000 log files in a matter of a few days. It appears that it's restarting approximately every 15 seconds. The error log simple contains: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 011125 07:24:14 mysqld restarted Over and over and over again. It's filled with these messages, one after another. I'm running 3.23.36-log - any ideas? - Jonathan Is this RedHat binary? If yes, replace it with 3.23.45 binary from our site. The problem with RedHat binary is that it is compiled with gcc 2.96 which has bugs that affect MySQL. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Move a column
David Lidström writes: Hi! Is it not possible to move a mysql column to after another existing Column by using the CHANGE statement in ALTER TABLE? ALTER TABLE enum_test CHANGE ostron ostron int(4) NULL DEFAULT '0' AFTER newCol_2 Moving oysters around, eh? :-) As far as I know, there is no way to move columns around, although you can do it by dropping the column and recreating it in a different position. the workaround is to CREATE TABLE ... SELECT ... and then remove the old table and rename the new one. The only downside to this is that for a brief moment your table will not be there. Oh, and I suspect you'll get into all sorts of problems if you're using foreign keys. Generally, I avoid trying to move columns about, if only so that a dump of the structure won't be different without there being a real (i.e., significant) difference. Also, the order of the columns might have some archeological curiosity value. ;-) //C - listening to Iron Maiden while drinking tea. -- Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ Amiga user since '89, and damned proud of it too. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 v4 FTS speed
I'd like to understand this better. Lets say I have a table with 4 fields itemKey INT(10) unsigned auto_increment primary key status enum(forsale, sold) description TEXT price DECIMAL(10,2) And I do a SELECT * FROM table WHERE MATCH (description) AGAINST (A really nice toy) AND status=forsale ORDER BY MATCH (description) AGAINST (A really nice toy) LIMIT 10 And lets further state that there at 10,000,000 records in the table and 7,500,000 of them are for sale. Lets also say that the minimum word length is set to 3 (so toy is considered significant for the fulltext search) and there is a fulltext index on description. Lets also assume that there are 1,000,000 records with the word really , 1,000,000 records with the word nice and 500,000 records with the word toy. Lets say there are only 500 records with all three words. Approximately how many records will this query need to look at to return a result? Approximately how long will it take? How would the following query compare: SELECT * FROM table WHERE MATCH (description) AGAINST (+A +really +nice +toy) AND status=forsale ORDER BY MATCH (description) AGAINST (+A +really +nice +toy) LIMIT 10 assuming that an end-user (not a programmer) is typing in the full text portion of the query. What can the application do, to protect against a long running query that will also lock the table for an extended period of time? Sergei Golubchik wrote: Hi! On Nov 26, Mike Wexler wrote: Sergei Golubchik wrote: Hi! I didn't test it yet. The one thing I can say just now that unlike natural language search code (as exists in MySQL in 3.23) it need not to build the complete list of matched documents in memory in advance. It means that with LIMIT it should be MUCH faster than the old code. Unfortunately, it also means that it does not auto-magically return documents with relevance decreased (without ORDER BY, that is). If I use ORDER BY relevance and LIMIT. Does it need to build the complete list of documents in memory in advance? Or will it just build enough to satisfy the limit constraints. It will build enough to satisfy the limit constraints, but with ORDER BY this enough is the complete list. If you want to get five rows with highest relevances MySQL will retrieve all the matching rows, sort them with relevance decreasing, and then return top five rows. But it should not be a big deal as for boolean searches there's no meaningful relevance anyway. It's boolean - true or false. Some floating point relevance is introduced to give a rough estimation of the number of words matched, but, in fact, all the rows in the result set are equally relevant to the query with relevance value TRUE. Regards, Sergei - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
GRANT'ing for localhost and %
Hi all,
This question should be, and probably is in, the FAQ -- but either the
FAQ or my fonts are hosed and I couldn't read the FAQ very well at all.
Apologies up front if it's in there.
I'm trying to figure out a graceful way to allow a user account access
to a DB from both 'localhost' as well as off-host ('%') without having 2
separate entries for the user in the 'mysql.user' table. I'm trying to
do this as, inevidably, a user will not keep their passwords
(user@localhost and user@%) in sync. and they're not necessarily skilled
at understanding they have 2 DB accounts with 2 separate passwords.
I would tend to think that granting access to user@'%' would also allow
connections from localhost, but apparently this is not so. I'm working
with MySQL 3.23.36, Red Hat Linux 7.1. And yes BTW -- my /etc/hosts is
setup properly :-)
TIA,
-Fred
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: mysqld ends immediately
check the ownership of the mysql directory and the files within. They should be the same owner/group as your mysql server. Yuriy Salimovskyy wrote: Dear sirs, I'm running MySQL server on local machine (AMD Duron 650, 128 RAM, Linux RedHat 7.1, MySQL 3.23.36) and have following problem: after running SAFE_MYSQLD daemon starts, but ends almost immediately log is as follows: 011126 16:44:08 mysqld started 011126 16:44:14 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 011126 16:44:14 mysqld ended Still sometimes I can start daemon with applying --no-defaults, but cannot connect to server! System says cannot through socket /var/lib/mysql/mysql.sock In that case log is: 011126 16:39:25 mysqld started /usr/libexec/mysqld: option requires an argument -- h /usr/libexec/mysqld Ver 3.23.36 for redhat-linux-gnu on i386 Starts the MySQL server Usage: /usr/libexec/mysqld [OPTIONS] basedir: /usr/ datadir: /var/lib/mysql/ tmpdir: /tmp/ language:/usr/share/mysql/english/ pid file:/var/run/mysqld/mysqld.pid TCP port:3306 Unix socket: /var/lib/mysql/mysql.sock system locking is not in use 011126 16:39:25 mysqld ended And sometimes I cannot evev start server with that parameter - have no idea why. I'd be thankful if you could tell me how can I deal with that to make everything work. -- Sincerely, Yuriy Yurr Salimovskyy ~~~ MSN:[EMAIL PROTECTED] http://yurr.20m.com/ mailto:[EMAIL PROTECTED] ~~~ 'what we do in life echoes in eternity' - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Beginner - Replacing Data in the Database
Replacing Data in the Database is not working. Please check and review the below syntax: A) Type the following from the Command Prompt- mysqlimport -r(replace)l(lock variables) (dbname) (fname) E B) To Replace while in a Database- 1)Type the following- load data local infile ./(fname) replace into table (tname); C)Another Optional Method of Replacing while in a Database- 1)Type the following- load data local infile ./(fname) replace - into table id - fields - terminated by ',' - enclosed by ''; Terms: E = Press the Enter Key (do not type the greater and less than symbols) (dbname)= name of the database (do not type the brackets) (fname) = name of the file (usually placed in the working directory) (tname) = name of the table (do not type the brackets) thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: GRANT'ing for localhost and %
I would tend to think that granting access to user@'%' would also allow connections from localhost It depends...if you connect from the local machine specifying 'localhost', or without specifying a hostname, then mysql looks for the localhost permission. If you connect through the localhost, but specify the actual hostname, it often uses the @hostname permission. That's the way it works for me connecting via php, and from the mysql command line, but you'll have to play around with it. 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: GRANT'ing for localhost and %
At 4:44 PM -0500 11/26/01, [EMAIL PROTECTED] wrote:
Hi all,
This question should be, and probably is in, the FAQ -- but either the
FAQ or my fonts are hosed and I couldn't read the FAQ very well at all.
Apologies up front if it's in there.
I'm trying to figure out a graceful way to allow a user account access
to a DB from both 'localhost' as well as off-host ('%') without having 2
separate entries for the user in the 'mysql.user' table. I'm trying to
do this as, inevidably, a user will not keep their passwords
(user@localhost and user@%) in sync. and they're not necessarily skilled
at understanding they have 2 DB accounts with 2 separate passwords.
I would tend to think that granting access to user@'%' would also allow
connections from localhost, but apparently this is not so. I'm working
with MySQL 3.23.36, Red Hat Linux 7.1. And yes BTW -- my /etc/hosts is
setup properly :-)
TIA,
-Fred
If you have user table entries with a blank User column, delete them
and issue a FLUSH PRIVILEGES statement.
But note that % as a Host value is insecure. If possible, it's better
to at least limit it to %.domain.name.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
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: Mac OS X and MySQL
At 2:35 PM -0600 11/26/01, john wrote: Excuse me, but I never intended on adding the world to that question, and your defensive response tells me you have to fight for trash you are using. I have utilized the Mac OS X long enough to run far far far away. That's a general enough criticism as to be essentially useless. Do you have some specific MySQL-related shortcomings in mind? I for one would be interested in hearing them. I'm not sure that Michael's response was defensive, but your characterization of Mac OS X as trash certainly is loaded. Have you some difficulty with the idea that other people might find Mac OS X useful? Until you can get a grip on criticsm, ease off buddy. Your gonna give yourself an aneurysm. -Original Message- From: Michael Collins [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 1:59 PM To: john; MySQL List Subject: RE: Mac OS X and MySQL At 1:49 PM -0600 11/26/01, john wrote: this is not meant to be demeaning, but your not seriousely running a server with a Mac are you? And why not? Are you at all familiar with Mac OS X and/or Darwin? It is Unix BSD. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: Any datetime gurus out there?
Hey group, The answer to my question was yes, thanks Paul. For the groups knowledge, the scenario was that I was trying to subtract two datetime values and sum up the differences. mySQL stores the datetimes in a text like integer format. For example 2001-01-02 is stored as an integer 20010102. I won't ask why. It appears to be an almost meaningless format except there are functions available to make it meaningful. I overlooked the UNIX_TIMESTAMP which converts the stored datetime into the number of seconds since the epoch (1970). I saw the word UNIX and moved on to the next function which was my demise. SELECT UserId, SUM((UNIX_TIMESTAMP(LogoutDate) - UNIX_TIMESTAMP(LoginDate))) / 3600 AS secs FROM tbl_name GROUP BY UserId; Works great. Mark Rissmann At 4:21 PM -0800 11/25/01, Mark Rissmann wrote: Thanks Mr. DuBois, I must have missed a function (or banged my head to many times). How do I convert 2 dates to seconds, find the difference, and sum them in 1 sql statement? The login and logout times can cross days. This expression gives you the user and number of logged-in seconds for each row: SELECT UserId, UNIX_TIMESTAMP(LogoutDate) - UNIX_TIMESTAMP(LoginDate) AS secs FROM tbl_name; To sum up the seconds for each user, do something like this: SELECT UserId, SUM(UNIX_TIMESTAMP(LogoutDate) - UNIX_TIMESTAMP(LoginDate)) AS secs FROM tbl_name GROUP BY UserId; To get hours, divide SUM() by 3600. It appears the that mySQL stores the date in a integer format (basically a string like format) making time math very difficult. 2001110512 doesn't really mean anything numerically. In Interbase and Delphi DateTime is stored as a double. The integral part of a TDateTime value is the number of days that have passed since 12/30/1899. The fractional part of a TDateTime value is fraction of a 24 hour day that has elapsed. (In case you have any pull with the mySQL crew ;) ) Which makes date/time math very easy. Converting the dates to second elapsed since 1970-01-01 00:00:00 allows you to do much the same thing. -Original Message- From: Paul DuBois At 2:45 PM -0800 11/25/01, Mark Rissmann wrote: Hey guys, Can anybody out there give me a helping hand? I have a table of the following format UserId LoginDate(datetime) LogoutDate(datetime) 1 2001-11-25 11:00:00 2001-11-25 13:45:00 2 2001-11-26 22:25:00 2001-11-27 02:00:00 I want to write a query that will calculate the hours worked for each record and then sum them up? Convert each of them to seconds since the epoch (beginning of 1970), take the difference to get number of seconds worked. Divide by the appropriate value, e.g., 60 to get minutes worked. This is going directly to a report engine so I have little control over it (like running multiple queries) except I am able to manipulate the final value and format it. Thanks for any help. Mark Rissmann - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mac OS X and MySQL
At 2:35 PM -0600 11/26/01, john wrote: Excuse me, but I never intended on adding the world to that question, And I never invited your private flame. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.com mysql database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange COUNT results
I'm using PHP with mySQL and I got very weird results when I ran a count. I used SELECT COUNT(*) FROM $TableName, with $TableName being my table's name, for the Query. When I printed the result I got Resource id #2, what does that even mean. And what did I do wrong? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: opinion - voating
On Monday 26 Nov 2001 20:00, Neil Zanella wrote: Now there is one thing that we must be aware of. There are things that mysql does not support (yet). These include foreign keys, views, subselects, triggers, and procedural SQL, and I can't remember if mySQL supports transaction processing either, perhaps someone can confirm. If your database is not complex or if you do not need subselects then go with mysql. And if you need subselects, transparently unlimited table sizes or procedural SQL and other languages at the database level, triggers, foreign keys and views you will probably be better of with PostgreSQL than with Oracle. The only feature that comes to mind that Oracle has and neither MySQL nor PostgreSQL have is the ability to set up a transparent server cluster with distributed data and have multiple servers execute (some) queries in parallel transparently, thus providing a bit of added scaleability. In practice, though, you can get a nearly same effect with PostgreSQL and MySQL if you set up replication, and have your application round-robin the database servers. As someone said earlier in this thread - if you don't _know_ you need Oracle, then you don't need Oracle. Regards. Gordan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Strange COUNT results
I'm using PHP with mySQL and I got very weird results when I ran a count. I used SELECT COUNT(*) FROM $TableName, with $TableName being my table's name, for the Query. When I printed the result I got Resource id #2, what does that even mean. And what did I do wrong? You tried to print your result object. Instead do this: $query = select count(*) as num from $tablename; $result=mysql_query($query); $obj=mysql_fetch_object($result); $count=$obj-num; print $count; 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
MySQL - Got Signal 11 - URGENT-RedHat-gcc2.96
On Tuesday 27 November 2001 02:38 am, you wrote: On Monday 26 November 2001 09:55 am, Jonathan Hilgeman wrote: I have an app that uses about 6-7 databases. But the MySQL server is now restarting a lot. I was having a problem with this before - I had about 267 restarts in a matter of a month or two. I shut down the server, ran myisamchk on the databases and it found a lot of open connections, and I guess closed them. I ran MySQL again and it seemed to be fixed for a while. I left work for the holiday weekend and came back. Now I've got close to 2000 log files in a matter of a few days. It appears that it's restarting approximately every 15 seconds. The error log simple contains: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 011125 07:24:14 mysqld restarted Over and over and over again. It's filled with these messages, one after another. I'm running 3.23.36-log - any ideas? - Jonathan Is this RedHat binary? If yes, replace it with 3.23.45 binary from our site. The problem with RedHat binary is that it is compiled with gcc 2.96 which has bugs that affect MySQL. gcc 2.96 has bugs that affect MySQL, what bug ? RedHat 7.1 and RedHat 7.2 comes with gcc 2.96 so even we download the source code and recompile it the bug will hit MySQL, is that right ? -- ady -- email: ady at ebdesk.com adiwicaksono at yahoo.com ady at students.if.itb.ac.id homepage: http://ady97.hypermart.net/ --- -- -- ady -- email: ady at ebdesk.com adiwicaksono at yahoo.com ady at students.if.itb.ac.id homepage: http://ady97.hypermart.net/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Mac OS X and MySQL
that's a croc. You invited me and the world as soon as you posted to the web. I asked you a question, you reposted to the net my question so we could start the war on the crappy Mac OS' issue that's been going on for the last ten years to this newsgroup. You're one of those guys that always overload the mailboxes of others, aint you the big man -- coward. Shut up punk, I will speak only to Paul DuBois of my issues. -Original Message- From: Michael Collins [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 4:36 PM To: john Cc: [EMAIL PROTECTED] Subject: RE: Mac OS X and MySQL At 2:35 PM -0600 11/26/01, john wrote: Excuse me, but I never intended on adding the world to that question, And I never invited your private flame. -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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
BACKUP TABLE help
I get a permission error when trying to backup my database files using the BACKUP TABLE function, here is an example use and its result: BACKUP TABLE ai2.topics TO /Users/mcollins/BACKUPS/BACKUP_1126_1407/ai2/; +++--+--+ | Table | Op | Msg_type | Msg_text | +++--+--+ | ai2.topics | backup | error| Failed copying .frm file: errno = 13 | | ai2.topics | backup | status | Operation failed | +++--+--+ 2 rows in set (0.01 sec) When running this I am logged into mysql client program as root (using a root shell). The folder being backed up to exists already: [localhost:~] root# ls -al /Users/mcollins/BACKUPS/BACKUP_1126_1407/ drwxr-xr-x 2 root staff24 Nov 26 14:07 ai2 Here are the permissions on the data files: [localhost:~] root# ls -al /usr/local/mysql/data drwxrwxr-x 5 mysql wheel 126 Nov 25 15:07 ai2 [localhost:~] root# ls -al /usr/local/mysql/data/ai2 -rwxrwxr-x 1 mysql wheel 3942880 Nov 25 15:24 topics.MYD -rwxrwxr-x 1 mysql wheel31744 Nov 25 15:24 topics.MYI -rwxrwxr-x 1 mysql wheel 9332 Nov 25 15:07 topics.frm Since I am logged in as root, shouldn't the Backup be possible? BTW, I am using 3.23.44 and MyISAM tables, is the BACKUP TABLE the best method for backing up databases? Better than mysqldump? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: AW: opinion - voating
On a final note, real Oracle users don't use SQLPlus, they use TOAD, Tool for Oracle Application Developers. :) On Monday 26 November 2001 01:32 pm, Christian Sage wrote: Neil, I'm not going to argue against your view, because for a discussion on Oracle this is clearly the wrong place. However, I would like to correct your facts in one respect: while SQL plus has a standard line size of 80 characters and a standard page size of 24, you can very easily set your linesize to any value you want (within reason, but I know I have used 512 successfully, and that is certainly wider than any terminal size I would set), and pagesize could traditionally go up to 32767 or be set to 0, which means no page breaks, no headers, etc. You can also have it pause for you after each page and set the prompt it will give you whenever it so pauses. There are numerous other things you can set on the fly or via a configuration scripts. It takes some effort to get familiar with SQL plus, but once you have done that, it is a very powerful and versatile tool indeed. Which has no bearing at all on MySQL, but I think a measure of fairness towards competitors is always indicated. Cheers, Christian -Ursprungliche Nachricht- Von: Neil Zanella [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 26. November 2001 21:00 An: Ken Kinder Cc: Mamun Murtaza Sheriff; MySQL Mailing List Betreff: Re: opinion - voating On Mon, 26 Nov 2001, Ken Kinder wrote: Oracle is certainly more full-featured, but if you know very little about databases, Oracle is not the right choice. I agree. First of all the system requirements are high. For instance the Oracle Universal Installer took something like three hours on a fairly high end PIII with 133MHz FSB! I have heared it takes for ages (up to a whole day) on other machines. This is not the worse part either. Have you ever used the sqlplus command line utility (which is the equivalent of the mysql command line tool or PostgreSQL's psql command line client). Well, sqlplus assumes your terminal is 24x80 even after you resize it. At least this is so with Oracle8i. I can tell you this: you won't learn much with a crappy tool like that cause as soon as you have more than two columns you won't be able to see the output in human readable form. Now my other point: Oracle8i is highly non-SQL compliant (although Oracle9i seems to be a little bit better). My last point about Oracle is that it is based on Java (see that JServer stuff when you start sqlplus?) and that is perhaps one of the reason it needs so much RAM. With a bit of bias we could conclude that if it were not for its disk and address space requirements then Oracle would be a fairly sluggish beast. Only use Oracle if you have a full-time fix-figure-salary Oracle expert AND you actually need Oracle's features. If you don't specifically know you need Oracle, you don't. Exactly. If I had the choice I would stay away from Oracle. Plus Oracle does not have good enough documentation either compared to most Open source products. Now there is one thing that we must be aware of. There are things that mysql does not support (yet). These include foreign keys, views, subselects, triggers, and procedural SQL, and I can't remember if mySQL supports transaction processing either, perhaps someone can confirm. However, mysql is much faster than other database system so you may still want to use it depending on the complexity of your database. If your database is not complex or if you do not need subselects then go with mysql. Most of the time you can get around all of this by recoding some things here and there. But if you are just learning go with postgresql, which will be slower, but will support all this stuff you need to know about databases. Once you have tested your application under postgresql and are certain that your code does not violate the database's foreign key constraint, simply run it under mysql after the testing phase. Then your code will run faster and at the same time free of errors. This is just my own personal recommendation for relatively small applications. Bye, Neil On Wednesday 21 November 2001 09:45 pm, Mamun Murtaza Sheriff wrote: Dear All You all are working on Database for Long time. In your opinion Which one is best 1. MySql or 2. Oracle Mamun - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Re: BACKUP TABLE help
At 2:53 PM -0800 11/26/01, Michael Collins wrote: I get a permission error when trying to backup my database files using the BACKUP TABLE function, here is an example use and its result: BACKUP TABLE ai2.topics TO /Users/mcollins/BACKUPS/BACKUP_1126_1407/ai2/; +++--+--+ | Table | Op | Msg_type | Msg_text | +++--+--+ | ai2.topics | backup | error| Failed copying .frm file: errno = 13 | | ai2.topics | backup | status | Operation failed | +++--+--+ 2 rows in set (0.01 sec) When running this I am logged into mysql client program as root (using a root shell). The folder being backed up to exists already: [localhost:~] root# ls -al /Users/mcollins/BACKUPS/BACKUP_1126_1407/ drwxr-xr-x 2 root staff24 Nov 26 14:07 ai2 Here are the permissions on the data files: [localhost:~] root# ls -al /usr/local/mysql/data drwxrwxr-x 5 mysql wheel 126 Nov 25 15:07 ai2 [localhost:~] root# ls -al /usr/local/mysql/data/ai2 -rwxrwxr-x 1 mysql wheel 3942880 Nov 25 15:24 topics.MYD -rwxrwxr-x 1 mysql wheel31744 Nov 25 15:24 topics.MYI -rwxrwxr-x 1 mysql wheel 9332 Nov 25 15:07 topics.frm Since I am logged in as root, shouldn't the Backup be possible? It doesn't matter who you are logged as. You're not doing the backup, the MySQL server is doing it. So what matters for permissions is what user account the server is running as. Of course, if the server is running as root, too, it should be able to write the file -- but that is a BIG security risk. BTW, I am using 3.23.44 and MyISAM tables, is the BACKUP TABLE the best method for backing up databases? Better than mysqldump? -- Michael __ ||| Michael Collins ||| ||| Kuwago Web Services ||| mailto:[EMAIL PROTECTED] ||| Seattle, WA, USA ||| http://www.lassodev.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: Mac OS X and MySQL
John, Mac OS X isn't the same Mac OS that you've been going on for the last 10 years. Its a radical departure. Mac OS 1 thru 9 were basically the same technology. They had no protected memory and no pre-emptive multitasking. Mac OS X is based on NextSTEP. Its a Unix. A real Unix. So just about anything you would have on FreeBSD, NetBSD or OpenBSD you would have on Mac OS X/Darwin. The userland for Mac OS X is taken directly from FreeBSD, albeit an older version and Apple has recently hired the FreeBSD release engineer to help co-ordinate their Unix technologies. So I don't know why you would even presume to judge Mac OS X as crap based on the old Mac OS's history. Its not the same ol Mac OS. Its new and its better. As to the guy's response, I saw nothing in it that was defenseive or even argumentative. If you cannot tolerate someone asking you to clarify your position then you need to get off a mailing list. On Monday, November 26, 2001, at 05:48 PM, john wrote: that's a croc. You invited me and the world as soon as you posted to the web. I asked you a question, you reposted to the net my question so we could start the war on the crappy Mac OS' issue that's been going on for the last ten years to this newsgroup. You're one of those guys that always overload the mailboxes of others, aint you the big man -- coward. Shut up punk, I will speak only to Paul DuBois of my issues. -Original Message- From: Michael Collins [mailto:[EMAIL PROTECTED]] Sent: Monday, November 26, 2001 4:36 PM To: john Cc: [EMAIL PROTECTED] Subject: RE: Mac OS X and 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: MySQL - Got Signal 11 - URGENT-RedHat-gcc2.96
Ady Wicaksono [EMAIL PROTECTED] writes: On Tuesday 27 November 2001 02:38 am, you wrote: On Monday 26 November 2001 09:55 am, Jonathan Hilgeman wrote: I have an app that uses about 6-7 databases. But the MySQL server is now restarting a lot. I was having a problem with this before - I had about 267 restarts in a matter of a month or two. I shut down the server, ran myisamchk on the databases and it found a lot of open connections, and I guess closed them. I ran MySQL again and it seemed to be fixed for a while. I left work for the holiday weekend and came back. Now I've got close to 2000 log files in a matter of a few days. It appears that it's restarting approximately every 15 seconds. The error log simple contains: mysqld got signal 11; The manual section 'Debugging a MySQL server' tells you how to use a stack trace and/or the core file to produce a readable backtrace that may help in finding out why mysqld died. 011125 07:24:14 mysqld restarted Over and over and over again. It's filled with these messages, one after another. I'm running 3.23.36-log - any ideas? Try a newer one, like the one shipped with Red Hat Linux 7.2, and see if that helps? -- Trond Eivind Glomsrød Red Hat, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
