LPAD(), RPAD() problem
Hello. I have a trouble. select LPAD(1, 8, 0); or select LPAD(int_field, 8, 0) from TABLE; produces result. The function doesn't work as expected :( As I understand from the manul it should produce the same result as: select CONCAT(REPEAT(0, 8 - LENGTH(ID)), ID) from TABLE; - 0001, etc. (MySQL version() = 3.23.41-log, OS: Linux-Mandrake 8.0, 3.23.38-nt, OS: W2K SP 3) With best regards, Alexander. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Backup automation..
If you've got to make copies to disk then why not just maintain copies on disk via replication? Stop the slave, backup the slave, restart the slave. In my case, replication is installed to give 24/7 service even if one of the server dies for some reason. When both master and slave are up, I will do as you say. But I still want backups even when we are in the failure mode - master or slave has failed. Alec mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Save Image (GIF or JPEG) file in the database ?
Hello ladies gents, I am new to MySQL. I wonder if I can save a picture in the database, then I can load into a JSP. The perfect example is an employee page ! Thanks in advance for your helps ! /Khanh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Save Image (GIF or JPEG) file in the database ?
Have a look at http://www.mysql.com/doc/B/L/BLOB.html Simon -Original Message- From: Khanh Pham [mailto:[EMAIL PROTECTED]] Sent: 02 August 2002 09:59 To: [EMAIL PROTECTED] Subject: Save Image (GIF or JPEG) file in the database ? Hello ladies gents, I am new to MySQL. I wonder if I can save a picture in the database, then I can load into a JSP. The perfect example is an employee page ! Thanks in advance for your helps ! /Khanh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Install innodb table type...
Hello everybody, I'm trying to install innodb on my mysql server, i'm under windows 2000, I have chosen mysqld-max-nt option and here are my ini settings : = #This File was made using the WinMySQLAdmin 1.4 Tool #19/07/2002 17:37:06 #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=10.0.0.10 datadir=C:/mysql/data #language=C:/mysql/share/French #slow query log#= #tmpdir#=c:/mysql/temp #port=3306 set-variable=key_buffer=16M innodb_data_file_path = ibdata1:500M innodb_data_home_dir = c:/ibdata set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:/iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=500M set-variable = innodb_log_buffer_size=16M innodb_flush_log_at_trx_commit=1 innodb_log_arch_dir = c:/iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=160M set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=5 [WinMySQLadmin] Server=C:/mysql/bin/mysqld-max-nt.exe user=myuser password=mypassword = But the service doesn't start, when I delete everything concerning innodb, the server starts well... Any idea ? Thanks for your help ! Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Setting the safe_show_database variable in my.cnf
Bill, Friday, August 02, 2002, 7:27:49 AM, you wrote: BL Newbie alert here...! Making my first attempt at changing a variable... BL I am trying to add this line: BL set-variable= safe_show_database=ON BL To the my.cnf file... But when I do that and then attempt to restart MySQL, BL it doesn't... Give the can't connect to the mysql.sock error. BL This is on RedHat 7.3, MySQL 3.23.51. I am using the /etc/my.cnf if that BL matters. BL Any help would be GREATLY appreciated... ! safe-show-database is not a variable, it's an option of mysqld. you should start mysqld with --safe-show-database or put safe-show-database entry in the [mysqld] section of my.cnf -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Accessing new columns within the WHERE condition
Dean, Friday, August 02, 2002, 3:36:44 AM, you wrote: DH Okay, I thought I'd done this before but maybe not. I can't figure it out DH now. DH What I want to do is: DH SELECT column AS something FROM table WHERE something 5 You can use aliases and HAVING clause for them: http://www.mysql.com/doc/P/r/Problems_with_alias.html DH Basically I'm creating a new column called something and I want to use it to DH compare with in the WHERE condition. Is this possible? DH Ultimately I want to have MySQL calculate the age of people and also put a DH condition on it. I am using a very old fashioned web language which doesn't DH have a lot of power. I could do this in PHP if I could only use it. But I DH need MySQL to do it. DH Any thoughts? DH Also what is the name of this that I am doing, creating a new column. Is it DH a dynamic column or something? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: LPAD(), RPAD() problem
Hi, The last paramater of LPAD must be a string : E.g: select LPAD(1, 8, '0') instead of select LPAD(1, 8, 0) Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Alexander Dsugan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 02, 2002 11:06 AM Subject: LPAD(), RPAD() problem Hello. I have a trouble. select LPAD(1, 8, 0); or select LPAD(int_field, 8, 0) from TABLE; produces result. The function doesn't work as expected :( As I understand from the manul it should produce the same result as: select CONCAT(REPEAT(0, 8 - LENGTH(ID)), ID) from TABLE; - 0001, etc. (MySQL version() = 3.23.41-log, OS: Linux-Mandrake 8.0, 3.23.38-nt, OS: W2K SP 3) With best regards, Alexander. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
pb connection
Hi, i use mysql v4.0 i have got a problem with the connection to database i can connect if i have localhost but if i want to connect to database i can't. There is a limitation with mysql v4.0 or not ? have you got an idea? 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: Re: MySQL bug? - problems with character-set
Andis, Friday, August 02, 2002, 9:07:54 AM, you wrote: A It's just a simple example, because I don't want send latvian-specific A symbols. This problem occurs with latvian-specific symbols only. A Configuration file I cheked some 4-5 times. I'm confused now. To convert correctly from upper case to lower case and vice versa you should specify proper character set. If you look into *.conf files in the charsets dir you can see 4 arrays there. Two of them, to_lower[] and to_upper[], contain the lowercase and uppercase characters corresponding to each member of the character set. What character set do you use in MySQL? And what character set is used for Latvian language? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problems when a combination of join, select distinct and order by are used together.
hean, Friday, August 02, 2002, 7:44:31 AM, you wrote: h Description: h When we join two or more tables, select distinct and order by on a h column, we get problems. h How-To-Repeat: [skip] h This is the problem: h mysql select distinct a1.a from test as a1, test as a2 order by a2.b; h +--+ h | a| h +--+ h |1 | h |2 | h |1 | h |2 | h |1 | h |2 | h +--+ h 6 rows in set (0.00 sec) h mysql select distinct a1.a from test as a1, test as a2 order by a1.b; h +--+ h | a| h +--+ h |1 | h |2 | h |1 | h +--+ h 3 rows in set (0.01 sec) h Interestingly, the query without the order by works... :) h mysql select distinct a1.a from test as a1, test as a2; h +--+ h | a| h +--+ h |1 | h |2 | h +--+ h 2 rows in set (0.00 sec) h Fix: h Err... avoid putting order by or distinct together? If you need both h ... err... bad luck. Columns that are specified in the ORDER BY clause are included in the column list, but they are 'hidden', not displayed in the output. So, if you re-write queries like: mysql SELECT DISTINCT a1.a, a1.b FROM test as a1, test as a2 ORDER BY a1.b; +--+--+ | a| b| +--+--+ |1 |1 | |2 |2 | |1 |3 | +--+--+ and mysql SELECT DISTINCT a1.a, a2.b FROM test as a1, test as a2 ORDER BY a2.b; +--+--+ | a| b| +--+--+ |1 |1 | |2 |1 | |1 |2 | |2 |2 | |1 |3 | |2 |3 | +--+--+ You can see that results are correct. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: pb connection
Florian, Friday, August 02, 2002, 12:29:08 PM, you wrote: FL i use mysql v4.0 i have got a problem with the connection to database i can FL connect if i have localhost but if i want to connect to database i can't. FL There is a limitation with mysql v4.0 or not ? have you got an idea? FL thanks Florian, what exactly problem do you have? You got Access denied error or can't connect or any other error or what? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB enum and set datatypes
speters, Friday, August 02, 2002, 3:08:44 AM, you wrote: s I was wondering about the Enum and Set column types in InnoDB tables. s I was able to create an InnoDB table with an enum column, but i s get errors when trying to insert values into that column. s I'm thinking that InnoDB doesnt support those data types, but the MySQL s interface to InnoDB may have some not quite consistent behavior. s no biggie, just wondering if anyone has encountered this. InnoDB supports ENUM and SET data types. And if you got any error you should provide error message and your INSERT statement. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
pb connection
Hi, i use mysql v4.0 i have got a problem with the connection to database i can connect if i have localhost but if i want to connect to database i can't. There is a limitation with mysql v4.0 or not ? have you got an idea? 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
probleme conection
Hi, i use mysql v4.0 i have got a problem with the connection to database i can connect if i have localhost but if i want to connect to database i can't. There is a limitation with mysql v4.0 or not ? have you got an idea? 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: Re: MySQL bug? - problems with character-set
I created character-set myself. Here, in Latvia, we use windows-1257. Problem is, when I use MySQL under Linux, conversation occurs better. Under windows98 I have problems as I wrote before. Cheracter-set I created myself, because included isn't correct. Andis - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 02, 2002 1:05 PM Subject: Re: Re: MySQL bug? - problems with character-set Andis, Friday, August 02, 2002, 9:07:54 AM, you wrote: A It's just a simple example, because I don't want send latvian-specific A symbols. This problem occurs with latvian-specific symbols only. A Configuration file I cheked some 4-5 times. I'm confused now. To convert correctly from upper case to lower case and vice versa you should specify proper character set. If you look into *.conf files in the charsets dir you can see 4 arrays there. Two of them, to_lower[] and to_upper[], contain the lowercase and uppercase characters corresponding to each member of the character set. What character set do you use in MySQL? And what character set is used for Latvian language? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: [Bug in UNION clause]
cliff, Thursday, August 01, 2002, 11:46:28 PM, you wrote: Description: c The UNION clause displays results 2 times even when not using the c ALL keyword with it. example: (SELECT c allusa.id,line,name,city,country,listcity,state,liststate,url,line,bookable,cost_range_low,cost_range_high,showlink,desc1,child,pets,wc,spec.id,spec.historic,spec.skiing,spec.romance,spec.antiques,spec.family_fun,spec.spas,spec.luxury_,spec.historic c FROM bb.allusa LEFT JOIN bb.spec on allusa.id=spec.id WHERE city = 'san francisco' AND line=1 order by state,city,name) UNION (SELECT c allusa.id,line,name,city,country,listcity,state,liststate,url,line,bookable,cost_range_low,cost_range_high,showlink,desc1,child,pets,wc,spec.id,spec.historic,spec.skiing,spec.romance,spec.antiques,spec.family_fun,spec.spas,spec.luxury_,spec.historic c FROM bb.allusa LEFT JOIN bb.spec on allusa.id=spec.id WHERE (line=1) AND (city LIKE '%san%' OR listcity LIKE '%san%' OR state='san' OR statename LIKE '%san%' OR country LIKE '%san%' OR name LIKE c '%san%') AND (city LIKE '%francisco%' OR listcity LIKE '%francisco%' OR state='francisco' OR statename LIKE '%francisco%' OR country LIKE '%francisco%' OR name LIKE '%francisco%')ORDER BY c state,city,name ) LIMIT 15,15 c produces the city San Francisco twice in the listing. How-To-Repeat: c http://www.lanierbb.com/search/search.php?pt=bbq=san+franciscostart=15numr=29 Can you send a dump of your tables for testing? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Installation frustration....
Ben, Friday, August 02, 2002, 12:33:35 AM, you wrote: BT Not sure if this is the correct list to be sending to but I am having BT some very frustrating problems with mysql-3.23.51 on redhat 7.2 BT My problem is the db starts just fine using bin/safe_mysqld --user=root BT although the crt seems to lock when I issue the command. After I hit BT ctl+c and get back to a prompt, the db is running in ps -aux listing. I BT checked it from the administrative site that I have setup on the server BT and the tables are there along with all the data a default install BT should have. BT Problem is, when I attempt to start it via mysqld I get BT 020801 14:27:49 /usr/local/mysql-3.23.51-pc-linux-gnu-i686/bin/mysqld: BT Table 'mysql.host' doesn't exist Seems, owner of MySQL data dir is 'root' but mysqld runs as user 'mysql'. You should change owner of the MySQL database to run mysqld as user 'mysql': http://www.mysql.com/doc/C/h/Changing_MySQL_user.html BT Does anyone know what this might be a symptm of? I cant seem to find BT much about this error specifically that is applicable to my setup. Im BT just trying to get the db so that it will start via mysqldThanks BT in advance! -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: pb connection
Hello Florian, Friday, August 02, 2002, 1:41:51 PM, you wrote: Please, don't send me your answer, send it to the mailing list. FL i have got access denied Check permissions for your user. Seems, your user has permissions to connect only from localhost. FL At 12:05 02/08/02, you wrote: Florian, Friday, August 02, 2002, 12:29:08 PM, you wrote: FL i use mysql v4.0 i have got a problem with the connection to database i can FL connect if i have localhost but if i want to connect to database i can't. FL There is a limitation with mysql v4.0 or not ? have you got an idea? FL thanks Florian, what exactly problem do you have? You got Access denied error or can't connect or any other error or what? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Accessing new columns within the WHERE condition
have a look at the HAVING clause: mysql SELECT user,MAX(salary) AS sum FROM users -group by user HAVING sum10; http://www.mysql.com/doc/S/E/SELECT.html Okay, I thought I'd done this before but maybe not. I can't figure it out now. What I want to do is: SELECT column AS something FROM table WHERE something 5 Basically I'm creating a new column called something and I want to use it to compare with in the WHERE condition. Is this possible? Ultimately I want to have MySQL calculate the age of people and also put a condition on it. I am using a very old fashioned web language which doesn't have a lot of power. I could do this in PHP if I could only use it. But I need MySQL to do it. Any thoughts? Also what is the name of this that I am doing, creating a new column. Is it a dynamic column or something? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: pb connection
I think it's good but how i can look because i begin to use mysql and i am not very good At 13:09 02/08/02, you wrote: Hello Florian, Friday, August 02, 2002, 1:41:51 PM, you wrote: Please, don't send me your answer, send it to the mailing list. FL i have got access denied Check permissions for your user. Seems, your user has permissions to connect only from localhost. FL At 12:05 02/08/02, you wrote: Florian, Friday, August 02, 2002, 12:29:08 PM, you wrote: FL i use mysql v4.0 i have got a problem with the connection to database i can FL connect if i have localhost but if i want to connect to database i can't. FL There is a limitation with mysql v4.0 or not ? have you got an idea? FL thanks Florian, what exactly problem do you have? You got Access denied error or can't connect or any other error or what? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: various questions about my.ini /or my.cnf
Jerry, Thursday, August 01, 2002, 7:13:04 PM, you wrote: JA As a newcomer to MySql, I have struggled through the install and am working JA my way through the tutorial. JA My environment: JA Win2000 JA MySql version 3.23.51-nt JA My.ini: JA [mysqld] JA # set basedir to installation path, e.g., c:/mysql JA basedir=c:/mysql JA # set datadir to location of data directory, JA # e.g., c:/mysql/data or d:/mydata/data JA datadir=c:/mysql/data JA # turn load data local option on JA local-infile=1 JA I am attempting to load table = menagerie from a text file name pet.txt. JA To make this work I have had to do the following: JA 1. Include local-infile=1 option on the login to mysql. Why is this not JA picked from My.ini? JA C:\mysql\binmysql -u jarkema -p --local-infile=1 Because you specified local-infile=1 only in the [mysqld] section. mysql command-line client doesn't read this section of my.ini. It reads sections [mysql] and [client]. To enable LOAD DATA LOCAL you should put local-infile=1 for client and for server. JA 2. Fully qualify the input file on the load data command. Why is the data JA path not being picked up from My.ini? mysql load data local infile c:/mysql/data/pet.txt into table pet; JA If I don't fully qualify the input file name I get: JA mysql load data local infile pet.txt into table pet; JA ERROR: File 'pet.txt' not found (Errcode: 2) JA It doesn't appear that my.ini is being used by mysql. Can anyone explain JA why? Why path should be picked from my.ini file? ;) You used LOAD DATA LOCAL, that means that data file is read from client host. How does MySQL server know where is file located on the client host? Besides if you don't specify full path to your file MySQL is looking for a file in the current database directory (c:/mysql/data/database_dir), not in the MySQL data dir (c:/mysql/data). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: permissions questions...
Caron, Thursday, August 01, 2002, 7:48:40 PM, you wrote: C Yes, but when I create a user with any other grants, it generates C automatically this grant usage on *.*: mysql use Liste_MP3; C Reading table information for completion of table and column names C You can turn off this feature to get a quicker startup with -A C Database changed mysql grant select on Liste_MP3.* to usernew@localhost identified by C password; C Query OK, 0 rows affected (0.01 sec) mysql show grants for usernew@localhost; C +--- C C + C | Grants for usernew@localhost C | C +--- C C + C | GRANT USAGE ON *.* TO 'usernew'@'localhost' IDENTIFIED BY PASSWORD C '0c2993b965 C 2e3c06' | C | GRANT SELECT ON Liste_MP3.* TO 'usernew'@'localhost' C | C +--- C C + C 2 rows in set (0.00 sec) C It's a new user I never entered before, and still, it generates this usage C on *.*... Because you gave permissions only on the specific database, not on all databases. MySQL has four levels of privileges: global level, database level, table level and column level. The output of SHOW GRANTS means that 'usernew' has no global privileges (USAGE) and has SELECT privilege on the database 'Liste_MP3'. C Thanks! C -Original Message- C From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] C Sent: 1 août, 2002 11:32 C To: [EMAIL PROTECTED] C Subject: Re: permissions questions... C Caron, C Thursday, August 01, 2002, 5:34:16 PM, you wrote: C mysql show grants for nouveau@localhost; C Ceoen +--- C + C | Grants for nouveau@localhost| C Ceoen +--- C + C | GRANT USAGE ON *.* TO 'nouveau'@'localhost' IDENTIFIED BY PASSWORD C '4be6641910d7bc1b' | C Ceoen +--- C + C 1 row in set (0.00 sec) C mysql revoke usage on *.* from nouveau@localhost; C Query OK, 0 rows affected (0.00 sec) C Is there a way to get rid of that? Ceoen :-) Ceoen Yes, give to user 'nouveau' any privileges except USAGE. Ceoen USAGE is a synonim for 'no privileges'. C Is there a way to create a user by giving access to only one database, C without giving him the permission to mysqlshow --user=[thisuser] C --password=[thispassword] and retrieve all database names? He should see C only the name of his database...? C Yes, start mysqld with --safe-show-database option. And since 4.0.2 C there is a SHOW DATABASES privilege. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Double Join
I used the Query Designer in Access to create the following query: SELECT Docs214.BOL, Docs214Dates.Date FROM Docs214Dates INNER JOIN (Docs214Picks INNER JOIN Docs214 ON Docs214Picks.DocID = Docs214.UniID) ON Docs214Dates.DocID = Docs214Picks.UniID WHERE Docs214Dates.Type = 1 AND Docs214Picks.LoadNum = 'LDS0135686' When I run this in Access2000 threw the MyODBC driver it runs fine. When I use the same query in a VB6 app it returns a syntax error at the first open bracket. Does anyone have any ideas? George Perolli Director - IS Department Traffic Tech Inc. Tel: (514) 343-0044 Fax: (514) 343-0045 mailto:[EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: Re: pb connection
Florian, Friday, August 02, 2002, 2:38:02 PM, you wrote: FL I think it's good but how i can look because i begin to use mysql and i am FL not very good If you have permissions to the database 'mysql' you can look on the contents of the table 'user'. If there is a corresponding entry user_name and host_name to connect from your remote host. If you have appropriate permissions you can allow user to connect from specific host using GRANT statement: http://www.mysql.com/doc/G/R/GRANT.html Take a look also at the following links. Here is some info about MySQL privilege system: http://www.mysql.com/doc/P/r/Privileges.html http://www.mysql.com/doc/P/r/Privileges_provided.html http://www.mysql.com/doc/A/c/Access_denied.html FL At 13:09 02/08/02, you wrote: Hello Florian, Friday, August 02, 2002, 1:41:51 PM, you wrote: Please, don't send me your answer, send it to the mailing list. FL i have got access denied Check permissions for your user. Seems, your user has permissions to connect only from localhost. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: MySQL bug? - problems with character-set
Andis, Friday, August 02, 2002, 1:57:12 PM, you wrote: A I created character-set myself. Here, in Latvia, we use windows-1257. A Problem is, when I use MySQL under Linux, conversation occurs better. Under A windows98 I have problems as I wrote before. Cheracter-set I created myself, A because included isn't correct. Seems, your to_lower[] array is not correct. Unfortunately, I don't know Latvian language and can't tell you what is wrong :( You say that included character set is not correct. Do you mean cp1257 ? If so, can you explain what is wrong with character set? Can you provide your own character set with explanation of changes that you did? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: pb connection
I think it's good but how i can look because i begin to use mysql and i am not very good What i must put on 'Host'? thanks At 13:09 02/08/02, you wrote: Hello Florian, Friday, August 02, 2002, 1:41:51 PM, you wrote: FL i have got access denied Check permissions for your user. Seems, your user has permissions to connect only from localhost. FL At 12:05 02/08/02, you wrote: Florian, Friday, August 02, 2002, 12:29:08 PM, you wrote: FL i use mysql v4.0 i have got a problem with the connection to database i can FL connect if i have localhost but if i want to connect to database i can't. FL There is a limitation with mysql v4.0 or not ? have you got an idea? FL thanks Florian, what exactly problem do you have? You got Access denied error or can't connect or any other error or what? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Double Join
George Perolli wrote: I used the Query Designer in Access to create the following query: SELECT Docs214.BOL, Docs214Dates.Date FROM Docs214Dates INNER JOIN (Docs214Picks INNER JOIN Docs214 ON Docs214Picks.DocID = Docs214.UniID) ON Docs214Dates.DocID = Docs214Picks.UniID WHERE Docs214Dates.Type = 1 AND Docs214Picks.LoadNum = 'LDS0135686' When I run this in Access2000 threw the MyODBC driver it runs fine. When I use the same query in a VB6 app it returns a syntax error at the first open bracket. Does anyone have any ideas? Sure, simply leave the brackets away. Greetings Ralf -- Ralf Narozny SPLENDID Internet GmbH Co KG Skandinaviendamm 212, 24109 Kiel, Germany fon: +49 431 660 97 0, fax: +49 431 660 97 20 mailto:[EMAIL PROTECTED], http://www.splendid.de - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
linking tables
Hello i am kinda new to this list, and to mysql... I am trying to link 2 tables, but there seems to be an catch i havent for seen... i made this table first like this: create table kunder(KundeID int NOT NULL PRIMARY KEY auto_increment, Fornavn varchar(25) NOT NULL, Etternavn varchar(25) NOT NULL, Poststed char(25) NOT NULL, postnummer int NOT NULL); then i made the second table like this: create table tlfnr (TeleID int NOT NULL PRIMARY KEY auto_increment, KundeID int NOT NULL REFERENCES kunder(KundeID), Type char(10) NOT NULL, Nummer int NOT NULL); Shouldnt this be enough to encoforce refirental integrity ? Still i can both insert records that dosent have an kundeID in table kuder and i can delete an kundeID that has an TeleID, i hopefully avoid this problem since both the kundeID and TeleID is releated - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: probleme conection (Please explain)
Hi, Could you put more detail in the description of the problem? Bye. --- Florian Litot [EMAIL PROTECTED] wrote: Hi, i use mysql v4.0 i have got a problem with the connection to database i can connect if i have localhost but if i want to connect to database i can't. There is a limitation with mysql v4.0 or not ? have you got an idea? 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 __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.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: Save Image (GIF or JPEG) file in the database ?
Hi, It depends how you want to treat those images. One of the advantages of putting the images in separate files is that you can modified them directly. If the images are small, I think that a blob field is a good idea but if the images are big, can make the database grow to much. Hope it helps. Bye and Good Luck. --- Simon Green [EMAIL PROTECTED] wrote: Have a look at http://www.mysql.com/doc/B/L/BLOB.html Simon -Original Message- From: Khanh Pham [mailto:[EMAIL PROTECTED]] Sent: 02 August 2002 09:59 To: [EMAIL PROTECTED] Subject: Save Image (GIF or JPEG) file in the database ? Hello ladies gents, I am new to MySQL. I wonder if I can save a picture in the database, then I can load into a JSP. The perfect example is an employee page ! Thanks in advance for your helps ! /Khanh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql duplicate table
How to make a table(table2) with same content of existing table(table1) in same database(database1) with mysql? tx in adv for any help adi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Install innodb table type...
Research, Friday, August 02, 2002, 12:11:42 PM, you wrote: R I'm trying to install innodb on my mysql server, i'm under windows 2000, I R have chosen mysqld-max-nt option and here are my ini settings : [skip] R But the service doesn't start, when I delete everything concerning innodb, R the server starts well... R Any idea ? Run MySQL server from the command prompt: path_to_the_mysqld_max_nt mysqld-max-nt --console to see error message. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: RE: various questions about my.ini /or my.cnf
Hello Jerry, Friday, August 02, 2002, 3:48:03 PM, you wrote: JA Victoria, JA Thanks for your response. Possibly you can clarify something for me. You JA say that LOAD DATA LOCAL means that data file is read from client host. JA What exactly is the client host in this case? Host from which you connect to the MySQL server. As I understand you connect from from the same box where MySQL server is running. JA I'll also have to try to put JA the input file in the menagerie directory and see if I can refer to it JA simply as 'pet.txt'. Please excuse my ignorance of this environment. After JA 30 years of dealing only with MVS, this is a very strange place. Sorry, it's not clear enough for me. What do you mean menagerie directory? I've already written that you can use 'pet.txt' in LOAD DATA statement if file pet.txt is located in the current database dir otherwise you must specify full path to the file. PS: Please, don't send me answers, send answers in the mailing list. JA Thanks, JA Jerry JA -Original Message- JA From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] JA Sent: Friday, August 02, 2002 7:52 AM JA To: [EMAIL PROTECTED] JA Subject:Re: various questions about my.ini /or my.cnf JA Jerry, JA Thursday, August 01, 2002, 7:13:04 PM, you wrote: JA As a newcomer to MySql, I have struggled through the install and am JA working JA my way through the tutorial. JA My environment: JA Win2000 JA MySql version 3.23.51-nt JA My.ini: JA [mysqld] JA # set basedir to installation path, e.g., c:/mysql JA basedir=c:/mysql JA # set datadir to location of data directory, JA # e.g., c:/mysql/data or d:/mydata/data JA datadir=c:/mysql/data JA # turn load data local option on JA local-infile=1 JA I am attempting to load table = menagerie from a text file name JA pet.txt. JA To make this work I have had to do the following: JA 1. Include local-infile=1 option on the login to mysql. Why is this not JA picked from My.ini? JA C:\mysql\binmysql -u jarkema -p --local-infile=1 JA Because you specified local-infile=1 only in the [mysqld] section. JA mysql command-line client doesn't read this section of my.ini. It JA reads sections [mysql] and [client]. To enable LOAD DATA LOCAL you JA should put local-infile=1 for client and for server. JA 2. Fully qualify the input file on the load data command. Why is the JA data JA path not being picked up from My.ini? mysql load data local infile c:/mysql/data/pet.txt into table pet; JA If I don't fully qualify the input file name I get: JA mysql load data local infile pet.txt into table pet; JA ERROR: File 'pet.txt' not found (Errcode: 2) JA It doesn't appear that my.ini is being used by mysql. Can anyone JA explain JA why? JA Why path should be picked from my.ini file? ;) JA You used LOAD DATA LOCAL, that means that data file is read from JA client host. How does MySQL server know where is file located on the JA client host? JA Besides if you don't specify full path to your file MySQL is looking JA for a file in the current database directory JA (c:/mysql/data/database_dir), not in the MySQL data dir (c:/mysql/data). -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem of using API in embedded server mode
To use MySQL API on Linux RH7.3 in embedded-server mode, I have compiled my source by gcc -o test test.c -L/usr/local/mysql/lib -lmysqlclient It appeared an error message undefined reference to 'mysql_server_init' undefined reference to 'mysql_server_end' The manual suggests to link libmysqld.lib instead of libmysqlclient.lib, but libmysqld.lib has not been built on my machine (I have installed rpm mysql-devel-3.23). I'm not sure what should I do to solve it. Please suggest me some. --- Chai Wutiwiwatchai Furui Laboratory, Department of Computer Science, Tokyo Institute of Technology Email to my mobile: [EMAIL PROTECTED] --- _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: pb connection
can i test without my connection java? the user are in the table user in mysql ? and what do you put on host? sorry it's the first time i use mysql At 16:04 02/08/02, you wrote: Hi, I 've tested the stated version both on Linux and Windows and have not encountered any problem of this type. I think you should check up with the following: 1. Check the username / password that you are using to connect to the database. 2. Check the port value (default value is 3306) 3. Check the URL syntax. thanks -Original Message- From: Florian Litot [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 6:54 PM To: [EMAIL PROTECTED] Subject: pb connection Hi, i use mysql v4.0 i have got a problem with the connection to database i can connect if i have localhost but if i want to connect to database i can't. There is a limitation with mysql v4.0 or not ? have you got an idea? thanks - Please check http://www.mysql.com/Manual_chapter/manual_toc.html; before posting. To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail [EMAIL PROTECTED] instead. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Save Image (GIF or JPEG) file in the database ?
I use blob columns. One thing I do though is store them in there own table and not in a table with other data. I just link through primary key. That way when you are not looking for an image the database does not have to deal with it. Also it's easier for disaster recovery since you do not have tons of binary data mix with textual data. Serge. - Original Message - From: Khanh Pham [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 02, 2002 4:58 AM Subject: Save Image (GIF or JPEG) file in the database ? Hello ladies gents, I am new to MySQL. I wonder if I can save a picture in the database, then I can load into a JSP. The perfect example is an employee page ! Thanks in advance for your helps ! /Khanh - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Missing Include file
Dear Users, I just downloaded the mysql-4.0.2-alpha-win.zip file, and installed it on my machine. When I try to build the project in the Embedded folder, I find that my_alloc.h is not in the /include directory. I tried downloading from another mirror site, but the file is still not there. Thanks. Aaron Boxer [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
THIS IS NOT AN ADVERTISEMENT: problem of using API in embeded-server mode
Original-Message-ID: [EMAIL PROTECTED] Original-Sender: Chai Wutiwiwatchai [EMAIL PROTECTED] Original-Subject: problem of using API in embedded server mode Original-Date: Fri, 02 Aug 2002 20:52:45 +0700 --- To use MySQL API on Linux RH7.3 in embedded-server mode, I have compiled my source by gcc -o test test.c -L/usr/local/mysql/lib -lmysqlclient It appeared an error message undefined reference to 'mysql_server_init' undefined reference to 'mysql_server_end' The manual suggests to link libmysqld.lib instead of libmysqlclient.lib, but libmysqld.lib has not been built on my machine (I have installed rpm mysql-devel-3.23). I'm not sure what should I do to solve it. Please suggest me some. Chai _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql duplicate table
On Fri, 02 Aug 2002 16:35:11 +0300 adi [EMAIL PROTECTED] wrote: How to make a table(table2) with same content of existing table(table1) in same database(database1) with mysql? tx in adv for any help adi create table table2 as select * from table1; You will have to create indexes manually, though. -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ ==* http://szukaj.wp.pl *==-- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Linking with Thread-Safe Library Problems
To reply to my own problem, my confusion stems from the change from my_thread_init() in MySQL version 3.x to mysql_thread_init() in version 4.x. Fair enough, but my_thread_init is still supported in version 4.x. So, should developers who wish to write the most portable code use my_thread_init(), or do a test (say on MYSQL_VERSION_ID) to determine whether to use my_thread_init() or use mysql_thread_init()? Thanks, rob On Mon, Jul 29, 2002 at 02:11:15PM -0400, Robert Beverly wrote: I am porting a multi-threaded MySQL client application that is currently working fine on my development Solaris box to multiple platforms. For some reason that I cannot figure out, my autoconf script is failing on Linux looking for the mysql_thread_init() function in libmysqlclient_r. From the config.log, I see that the simple test program is: int main () { mysql_thread_init(); return 0; } To determine why it was failing, I tried compiling this simple program on my Solaris 2.7 machine, linking with -lpthread and -lmysqlclient_r: gcc abc.c -o abc -lpthread -lmysqlclient_r It compiles fine on Solaris 2.7. On my Red Hat 7.2 (kernel 2.4.18) machine, I have compiled and installed MySQL 3.23.51 with the --enable-thread-safe-client configure option. When I try to compile the exact same program, I get a linker error: /tmp/ccEsSfhd.o: In function `main': /tmp/ccEsSfhd.o(.text+0x7): undefined reference to `mysql_thread_init' The libmysqlclient_r library (libmysqlclient_r.so.10.0.0) does exist and is obviously being found (otherwise I would get a library not found error when specifying -lmysqlclient_r). So, I cannot determine why on Linux, after I have built the thread-safe library, the linker still cannot find mysql_thread_init. Any suggestions very welcomed. Thanks, - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql duplicate table
Why would you want to replicate your data in the same location on the same machine? You can use an alias name if you need to join a table multiple times in a select. Something like this: select table1.column1,tableA.columnA,tableB.columnA from table1,table2 as TableA, table2 asTableB where table1.column2=tableA.column2 AND table1.column3=tableB.column2 Don't know if that's what you are trying to do. But I can't think of any reason to permanently replicate a table in the same database. On Friday, August 2, 2002, at 09:35 AM, adi wrote: How to make a table(table2) with same content of existing table(table1) in same database(database1) with mysql? tx in adv for any help adi - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Brent Baisley Systems Architect Landover Associates, Inc. Search Advisory Services for Advanced Technology Environments p: 212.759.6400/800.759.0577 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Re: MySQL bug? - problems with character-set latvian.conf [1/3]
From: Andis [EMAIL PROTECTED] To: [EMAIL PROTECTED], Victoria Reznichenko [EMAIL PROTECTED] References: 001d01c2394e$85803740$[EMAIL PROTECTED] [EMAIL PROTECTED] 003601c239ea$f0f7d720$[EMAIL PROTECTED] [EMAIL PROTECTED] 001001c23a13$5ba93280$[EMAIL PROTECTED] Victoria Reznichenko [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Re: Re: Re: MySQL bug? - problems with character-set Date: Fri, 2 Aug 2002 17:57:53 +0300 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary==_NextPart_000_002C_01C23A4E.20042D80 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600. X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600. This is a multi-part message in MIME format. --=_NextPart_000_002C_01C23A4E.20042D80 Content-Type: text/plain; charset=iso-8859-4 Content-Transfer-Encoding: 7bit Here is my conf file. Also I send my Excel file, where with yellow is marked symbols which is used in Latvian language. Of course, also we use such symbols as W, X, Y etc. This means, for right sorting all symbols with ascii code from 32 to 255 better is include in character-set definition. I hope, that you'll see xls file as I see :)). Andis - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 02, 2002 3:41 PM Subject: Re: Re: Re: MySQL bug? - problems with character-set Andis, Friday, August 02, 2002, 1:57:12 PM, you wrote: A I created character-set myself. Here, in Latvia, we use windows-1257. A Problem is, when I use MySQL under Linux, conversation occurs better. Under A windows98 I have problems as I wrote before. Cheracter-set I created myself, A because included isn't correct. Seems, your to_lower[] array is not correct. Unfortunately, I don't know Latvian language and can't tell you what is wrong :( You say that included character set is not correct. Do you mean cp1257 ? If so, can you explain what is wrong with character set? Can you provide your own character set with explanation of changes that you did? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --=_NextPart_000_002C_01C23A4E.20042D80 Content-Type: application/octet-stream; name=latvian.conf Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename=latvian.conf # Configuration file for the latvian character set. # Created for case-sensitive record search=0A= # Created accord with windows-1257 (iso-8859-4) codepage=0A= # Created by Andis Grasis Rihards Grasis=0D e-mail:[EMAIL PROTECTED]=0A= # The ctype array must have 257 elements. 00 20 20 20 20 20 20 20 20 20 28 28 28 28 28 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 48 10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 84 84 84 84 84 84 84 84 84 84 10 10 10 10 10 10 10 81 81 81 81 81 81 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 10 10 10 10 10 10 82 82 82 82 82 82 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 10 10 10 10 20 01 20 10 20 10 10 00 00 20 10 20 10 20 10 10 10 20 10 10 10 10 10 10 10 20 00 20 10 20 10 10 20 48 20 10 10 10 20 10 10 10 10 01 10 10 10 10 01 10 10 10 10 10 10 10 10 10 10 02 10 10 10 10 02 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 01 10 01 01 01 01 01 01 01 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 02 10 02 02 02 02 02 02 02 10 # The to_lower array must have 256 elements. 00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F 10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F 20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F 30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F 40 61 62 63 64 65 66 67 68 69 6A 6B 6C 6D 6E 6F 70 71 72 73 74 75 76 77 78 79 7A 5B 5C 5D 5E 5F 60 61 62 63 64 65 66 67 68 69 6A 6B 6C 6D 6E 6F 70 71 72 73 74 75 76 77 78 79 7A 7B 7C 7D 7E 7F 80 81 82 83 84 85 86 87 88 89 8A 8B 8C 8D 8E 8F 90 91 92 93 94 95 96 97 98 99 9A
RE: Install innodb table type...
Run MySQL server from the command prompt: path_to_the_mysqld_max_nt mysqld-max-nt --console Many thanks, I have found the error : when installing MySQL I choose MySQLd-nt and when I changed it to MySQLd-max-nt teh registry wasn't updated (key imagepath). Phil - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
JOINS one table twice
Since the below select query blew up on me, then I must be doing something wrong, perhaps it is because I am using the wrong type of join, dunno I would like to join the same table twice, with different criteria as below Anyone got a solution to this? SELECT EVENTATTENDANCE.ID, CONCAT(IF(SALUTATION.Name IS NOT NULL,CONCAT(SALUTATION.Name,' '),''),IF(FirstName IS NOT NULL, FirstName, ''),' ', IF(LastName IS NO T NULL, LastName, '')) AS 'Contact' , ORGANIZATION.Name AS 'Organization', RELATIONSHIP.Name AS 'Relationship', STATUS.Description AS 'Status' FROM EVENTATTENDANCE LEFT JOIN EVENT ON EVENTATTENDANCE.ID_EVENT = EVENT.ID LEFT JOIN CONTACT ON EVENTATTENDANCE.ID_CONTACT = CONTACT.ID LEFT JOIN STATUS ON EVENTATTENDANCE.ID_STATUS = STATUS.ID LEFT JOIN ORGANIZATION ON CONTACT.ID_ORGANIZATION = ORGANIZATION.ID LEFT JOIN TYPE RELATIONSHIP ON CONTACT.ID_TYPE_RELATIONSHIP = TYPE.ID LEFT JOIN TYPE SALUTATION ON CONTACT.ID_TYPE_SALUTATION = TYPE.ID WHERE EVENTATTENDANCE.ID_EVENT = -1 ORDER BY CONTACT.FirstName SQL Error in populateDataSet == Please Restart The Application == SQLException: General error: Unknown table 'TYPE' in on clause Luc Foisy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: JOINS one table twice
On 2 Aug 2002, at 11:43, Luc Foisy wrote: FROM EVENTATTENDANCE LEFT JOIN EVENT ON EVENTATTENDANCE.ID_EVENT = EVENT.ID LEFT JOIN CONTACT ON EVENTATTENDANCE.ID_CONTACT = CONTACT.ID LEFT JOIN STATUS ON EVENTATTENDANCE.ID_STATUS = STATUS.ID LEFT JOIN ORGANIZATION ON CONTACT.ID_ORGANIZATION = ORGANIZATION.ID LEFT JOIN TYPE RELATIONSHIP ON CONTACT.ID_TYPE_RELATIONSHIP = TYPE.ID LEFT JOIN TYPE SALUTATION ON CONTACT.ID_TYPE_SALUTATION = TYPE.ID WHERE EVENTATTENDANCE.ID_EVENT = -1 ORDER BY CONTACT.FirstName SQL Error in populateDataSet == Please Restart The Application == SQLException: General error: Unknown table 'TYPE' in on clause You've assigned the aliases RELATIONSHIP and SALUTATION to the TYPE table, so you need to use those in place of TYPE for your join criteria. Change TYPE.ID to RELATIONSHIP.ID and SALUTATION.ID. -- Keith C. Ivey [EMAIL PROTECTED] Tobacco Documents Online http://tobaccodocuments.org - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: JOINS one table twice
Luc Foisy wrote: Since the below select query blew up on me, then I must be doing something wrong, perhaps it is because I am using the wrong type of join, dunno I would like to join the same table twice, with different criteria as below Anyone got a solution to this? SELECT EVENTATTENDANCE.ID, CONCAT(IF(SALUTATION.Name IS NOT NULL,CONCAT(SALUTATION.Name,' '),''),IF(FirstName IS NOT NULL, FirstName, ''),' ', IF(LastName IS NO T NULL, LastName, '')) AS 'Contact' , ORGANIZATION.Name AS 'Organization', RELATIONSHIP.Name AS 'Relationship', STATUS.Description AS 'Status' FROM EVENTATTENDANCE LEFT JOIN EVENT ON EVENTATTENDANCE.ID_EVENT = EVENT.ID LEFT JOIN CONTACT ON EVENTATTENDANCE.ID_CONTACT = CONTACT.ID LEFT JOIN STATUS ON EVENTATTENDANCE.ID_STATUS = STATUS.ID LEFT JOIN ORGANIZATION ON CONTACT.ID_ORGANIZATION = ORGANIZATION.ID LEFT JOIN TYPE RELATIONSHIP ON CONTACT.ID_TYPE_RELATIONSHIP = TYPE.ID LEFT JOIN TYPE SALUTATION ON CONTACT.ID_TYPE_SALUTATION = TYPE.ID WHERE EVENTATTENDANCE.ID_EVENT = -1 ORDER BY CONTACT.FirstName SQL Error in populateDataSet == Please Restart The Application == SQLException: General error: Unknown table 'TYPE' in on clause Your Table is named TYPE? Bad idea, because it is a reserved word in all SQL dialects I know of. try 'TYPE' instead of TYPE, but I really recommend to rename that table...You'll run into trouble all the time and all coders/developers who'll work with that DB will hate you for eternity ;-) TYPE is not a reserved word. We have used TYPE for the last 2 years, created several databases with that table name, used it many times in many many places. MySQL has not complained once before now. And TYPE is not here http://www.mysql.com/doc/R/e/Reserved_words.html That can't be the problem, it has to be something with the joins. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: JOINS one table twice
On 2 Aug 2002, at 11:43, Luc Foisy wrote: FROM EVENTATTENDANCE LEFT JOIN EVENT ON EVENTATTENDANCE.ID_EVENT = EVENT.ID LEFT JOIN CONTACT ON EVENTATTENDANCE.ID_CONTACT = CONTACT.ID LEFT JOIN STATUS ON EVENTATTENDANCE.ID_STATUS = STATUS.ID LEFT JOIN ORGANIZATION ON CONTACT.ID_ORGANIZATION = ORGANIZATION.ID LEFT JOIN TYPE RELATIONSHIP ON CONTACT.ID_TYPE_RELATIONSHIP = TYPE.ID LEFT JOIN TYPE SALUTATION ON CONTACT.ID_TYPE_SALUTATION = TYPE.ID WHERE EVENTATTENDANCE.ID_EVENT = -1 ORDER BY CONTACT.FirstName SQL Error in populateDataSet == Please Restart The Application == SQLException: General error: Unknown table 'TYPE' in on clause You've assigned the aliases RELATIONSHIP and SALUTATION to the TYPE table, so you need to use those in place of TYPE for your join criteria. Change TYPE.ID to RELATIONSHIP.ID and SALUTATION.ID. Ahh, so LEFT JOIN TYPE SALUTATION ON CONTACT.ID_TYPE_SALUTATION = SALUTATION.ID ?? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
3.23.51.src.rpm installation problems
I downloaded a copy of MySQL-3.23.51-1.src.rpm to my /home/steve directory. I executed rpm --rebuild MySQL-3.23.51-1.src.rpm When it was finished it performed several wrote commands... according to the quick installation Overview...doc at www.mysql.com/doc/Q/u/Quick_install...para 2.3.1 I need to change to the default directory generated during the rpm rebuild and that directory being...? I cannot find a new directory anywhere on my system named.../mysql- 3.23.51-1 ...whatever. This step is step 6 of the document. NOTE: I did not need to execute gunzip or tar as the file I down loaded was not zipped or tar'ed I hope someone will be able to get me where I need to be. Thanks for the help. Steve - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Querying for XML content in the database ?
Heyho folks, I hope I am in the correct mailing list here. We do have a performance problem with mySQL. In the database we have : INSERT INTO art_xml VALUES ('0', 'article-infopn lang=enenglish product nr 0 /pnpd lang=enand went away, and two technicians remained with instrument and started to\r and /pdpn lang=dedeutsches product nr 0 /pnpd lang=deand protected meaning of civil life.\r and /pd/article-info'); lots of these entries... and querying happens with : SELECT pr.*, SUBSTRING(xml_description, LOCATE('', xml_description) + length('') ) as jezus FROM art_xml as pr WHERE pr.xml_description regexp '[[:space:]]*pn[[:space:]]*lang=de[[:space:]]*[[:alnum:][:space:]]*de[[: alnum:][:space:]]*' ORDER BY jezus Well this works.. but.. it is f***cking slow... really slow.. serious slow... ( 50,000 entries need much more than 3 minutes to process this select) So the question is - do we make a major mistake here or is it just so slow ? Thnx folks :) dodger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What is the difference between thread and connection
Could someone explain to me what is the difference between thread and connection? I guess one connection can have many threads? Am I right? Thanks, Mihail Manolov sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What is the difference between thread and connection
At 13:29 -0400 8/2/02, Mihail Manolov wrote: Could someone explain to me what is the difference between thread and connection? No difference. I guess one connection can have many threads? Am I right? The server is multi-threaded. It associates a thread with each connection. Connection ID and thread ID are synonymous. Thanks, Mihail Manolov sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Speed issues...
On Wednesday 31 July 2002 01:41 pm, Richard Baskett wrote: Ok here is the EXPLAIN query: OK, 1st thing this is telling you is that you aren't using any index on your master table, Employers. Probably this just means there isn't any field in that table that is part of the search (I can't be 100% sure of that without knowing the schema). If one of the columns in Employers IS part of the search criteria, then by all means index it, that will cut down the 46,175 rows you need to select to start with. See what's happening is that first you get 46175 rows from Employers (which is the entire table), then you attempt to join it to Jobs, which matches 3 rows, meaning 46,175 TIMES 3 comparisons to do the join. Then the result of THAT is being compared with JobsLocation, which is doing another bunch of comparisons (we don't know exactly how many, but at least 46,175 TIMES 581). etc. It looks like you have indexes on everything you can, but as someone else suggested it may be beneficial to get rid of 'left join' so MySQL can reorder the joins for maximum efficiency. I THINK if it can join to JobsCategory first it will cut down the work done substantially. Check out the MySQL manual section on EXPLAIN as well, there are probably some subtle things I've missed. Sometimes just tinkering with your query can help. I would try removing a few joins just to see which tables are slowing you down the most. You might be able to denormalize a bit based on that. table, type, possible_keys, key, key_len, ref, rows, Extra Employers, ALL, NULL, NULL, NULL, NULL, 46175, where used; Using temporary; Using filesort Jobs, ref, EmpID, EmpID, 4, Employers.EmpID, 3, where used JobsLocation, ref, PRIMARY, PRIMARY, 4, Jobs.JobID, 581, Using index Location, eq_ref, LocID, LocID, 2, JobsLocation.LocID, 1, where used JobsCategory, ref, PRIMARY, PRIMARY, 4, Jobs.JobID, 581, Using index; Distinct Category, eq_ref, PRIMARY,CatID, PRIMARY, 1, JobsCategory.CatID, 1, where used; Using index; Distinct Hopefully you can make out what it says in all of that jumble! :) Thanks so much for everyone's help! I am using PHP by the way.. And the reason those things that do not have to be quoted are.. Is.. Well.. Just because I quote everything, less likely to run into errors, but if it would speed things up.. By all means I will take them out! yes? Cheers! Rick When the solution is simple, God is answering. - Albert Einstein From: Tod Harter [EMAIL PROTECTED] Organization: Giant Electronic Brain Date: Wed, 31 Jul 2002 09:57:20 -0400 To: Richard Baskett [EMAIL PROTECTED], MySQL [EMAIL PROTECTED] Subject: Re: Speed issues... On Wednesday 31 July 2002 05:17 am, Richard Baskett wrote: This is my first post here.. So be nice! ;) OK, no flames ;o). I'd want a bit more information in order to really diagnose this. The first thing I would tell you to do is to EXPLAIN this query. To do that just tack the keyword EXPLAIN onto the beginning of it, this will return you an explanation of what MySQL's query optimizer has decided to do with the query. Most likely one or more of your tables are being joined on columns with no indexes. Generally all the columns mentioned in USING should be indexed. You might also experiment with indexing of the LocName and JobTitle columns. Beyond that there are many possibilities. Your table structure is obviously fairly elaborate, and I suspect fully normalized. You might be forced to denormalize it some, in other words maybe the stuff in tables like Location will just have to be merged into the parent table even though it means possibly some duplication of data (but I suspect that at the level of actually managing your data you probably duplicate it in the child table already anyhow...). Denormalization can reduce the numbers of joins enough to possibly get you a speed improvement. BTW, why is the 1 in ... VALID = '1' ... quoted? If its an integer then get rid of the quotes, same for CatID IN ('2'), your just forcing the database engine to do conversions. If, as I suspect, you are using Perl DBI then try using bind parameters and explicitly setting the SQL_TYPE. Perl DBI is pretty dumb about figuring out what data types to use. I have a database with a little over 60,000 records and when I do a search on that db it takes a little over a minute and a half to return results. This is very unacceptable, but Im just not sure what I can do to remedy this. Here is what the query looks like when just using location and category in the search.. SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS Comp, Jobs.JobID, Employers.EmpID FROM Employers LEFT JOIN Jobs USING (EmpID) LEFT JOIN JobsLocation USING (JobID) LEFT JOIN Location USING (LocID) LEFT JOIN JobsCategory ON Jobs.JobID=JobsCategory.JobID LEFT JOIN Category USING (CatID) WHERE Valid = '1' AND JobTitle IS NOT NULL
Re: probleme conection (Please explain)
Hi Florian, If you want to connect remotely to the server, you have to grant permission to that user. Try this: GRANT ALL PRIVILEGES ON *.* TO 'theuser'@'%' IDENTIFIED BY 'thepassword'; With this command you are telling MySQL to accept calls from any computer if the user name is 'theuser' and the password is 'thepassword'; I recomend you to refer to MySQL's manual about permissions. Bye and Good Luck. --- Florian Litot [EMAIL PROTECTED] wrote: I am able very well to connect me to the base of data on my computer (locally) but if I want that somebody connects himself since another computer it cannot it tries to be connected by the intermediary of an interface java and thus by link JDBC and if we install the ihm java on the local computer the ihm Donc functioning I do not know where there is a problem if it is the connection jdbc which is not able to be connected to the distant computer or then it is the base of data which refuse the connection I would go more on the point of view than it is the base of am in version 4.0 ss win nt if need be for another information say me for I do not have the practice and I begin with mysql for the moment what I did it is right a standard install of mysql while adding to use and create the table and data is necessary it to make another thing? At 15:29 02/08/02, you wrote: Hi, Could you put more detail in the description of the problem? Bye. --- Florian Litot [EMAIL PROTECTED] wrote: Hi, i use mysql v4.0 i have got a problem with the connection to database i can connect if i have localhost but if i want to connect to database i can't. There is a limitation with mysql v4.0 or not ? have you got an idea? 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 __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.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: Missing Include file
At 10:07 2/8/2002 -0500, Aaron Boxer wrote: Hi, Dear Users, I just downloaded the mysql-4.0.2-alpha-win.zip file, and installed it on my machine. When I try to build the project in the Embedded folder, I find that my_alloc.h is not in the /include directory. I tried downloading from another mirror site, but the file is still not there. Yes you are right and this is my fault. If you want I can send it for you in a separate e-mail. Regards, -- For technical support contracts, visit https//order.mysql.com __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Miguel Angel Solórzano [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ São Paulo - Brazil ___/ 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
Crashing under high load
I recently read an article (on PHPBuilder; it's fairly old) that spoke of MySQL dying under high load. Recently (since I built 3.23.51 and on my test build of 4.0.2) I have had problems with MySQL dying (got signal 11, et al.) under extreme high load. For example, if I set up a 60-thread spider, and run it in our test environment (1 front end web server, 1 database server, mysql 4.0.2 alpha compiled with a custom glib-2.2.5 + MySQL patch to linuxthreads)(heavily database driven), I can crash MySQL after only 30 minutes or so. The sad part is, we haven't hit the 2500 connection limit that I've set. I've tried checking the physical resources on the boxen, and MySQL doesn't appear to have consumed all the resources on the box at this point, although the load average when MySQL dies is usually around 15. I've been tweaking values, and found that increasing the table_cache from our previous setting of 400 to 3000 has caused *vastly* improved stability, however I cannot imagine that a table_cache adjustment should prevent a crash... I digress... at this point, the question that plagues me is: Is it normal for MySQL to die under high load? Additionally, I'd love to know: Is it likely that something in my build is causing mysqld to crash (given that there are no other problems whatsoever with the build)? Since I increased the table cache it has become more stable -- is this the expected behaviour? Should the increased table_cache have made any difference at all? *** I don't want to ask leading questions, but... is it possible that we are hitting, say 200 processes, and when they all start using their 5M sort buffers (see below) that we're running out of memeory and causing MySQL to die? If so, is there any way to avoid having MySQL die? I'd rather a query take 3 minutes than kill the daemon... *** Below is my MySQL config, and some other pertinent data. Please let me know if I can provide any further information to help answer above questions. Also, if anyone has advice on how to make MySQL more stable, please let me know. Thanks in advance. --Other stuff-- MySQL built with: root@local-dbmaster-test:/usr/local/src/mysql-4.0.2-alpha/BUILD# ./compile-pentium --with-other-libc=/usr/local/mysql-glibc-2.2.5 --prefix=/usr/local glibc-2.2.5 built with: root@local-dbmaster-test:/usr/local/src/glibc-2.2.5# ./configure --enable-add-ons=linuxthreads --prefix=/usr/local/mysql-glibc-2.2.5 --enable-kernel=2.4.18 gcc-2.95.4 (debian stable package) was used to build both kernel is running patched to enable a higher open file limit per process (up to 4096) --/etc/my.cnf-- [mysqld] skip-locking set-variable= max_connections=2500 set-variable= query_cache_size=64M set-variable= wait_timeout=3600 set-variable= key_buffer=384M set-variable= max_allowed_packet=1M set-variable= table_cache=3000 # NOTE: Record buffer and Sort buffer are NOT shared among threads # They are per-thread memory buffers. set-variable= sort_buffer=5M set-variable= record_buffer=5M set-variable= thread_cache=8 set-variable= thread_concurrency=4 set-variable= myisam_sort_buffer_size=64M set-variable= long_query_time=4 tmpdir=/data/tmp user=mysql #log=/usr/local/var/mysqld.log log-slow-queries=/usr/local/var/slow-queries.log pid-file=/usr/local/var/mysqld.pid server-id=1 #master-host=host #master-user=user #master-password=secret #log-bin #binlog-do-db=db [mysql] set-variable= max_allowed_packet=1M [mysqldump] set-variable= max_allowed_packet=1M [isamchk] set-variable= key_buffer=256M set-variable= sort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M [myisamchk] set-variable= key_buffer=256M set-variable= sort_buffer=256M set-variable= read_buffer=2M set-variable= write_buffer=2M [mysqlhotcopy] interactive-timeout [safe_mysqld] open-files-limit=8192 err-log=/usr/local/var/mysqld.err -- Shane Allen [EMAIL PROTECTED] sell.com : Buy Sell Anything http://www.sell.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: Querying for XML content in the database ?
On Friday 02 August 2002 12:47 pm, [EMAIL PROTECTED] wrote: Lars: I think what you are trying to do is pound a square peg into a round hole... MySQL really wasn't designed for this sort of useage. Your selects are going to be brute force searches on unidexed data, which is exactly why they are so slow... I would advise you to look into using an XML or XML Enabled RDBMS. There are a lot of possible considerations here as to what you might want. Considerations would include: XML databases generally have NO idea of referential integrity whatsoever, nor transactions, etc. They also generally use some sort of query language that is either totally proprietary or based to some degree on XQuery, XPath, XPointer, etc. Expect the query language to be unfamiliar to SQL users and non-portable from database to database. On the flip side they can give you excellent performance for this type of application and have other desirable features like support for Schemas etc. XML enabled databases now include most of the major vendor's offerings, though they often need an add-on module. I'm not really incredibly familiar with these, not having worked with one closely, but they generally are a standard RDBMS which has added features to allow mapping of XML to a relational schema, and even sometimes ad-hoc XML support (though generally its not indexed in that case). The other option is to keep using MySQL but abadon the idea of storing XML in a blob. In other words you would have to create a relational mapping of your XML schema to an RDBMS schema. Then your application would accept XML, extract the necessary data from it, create appropriate INSERT statements For output it would be necessary to reverse the process. If its a fairly simple application this is not a big deal. If its a complicated application with complex and changing schema, then you probably would want to find a commercial tool which supports that sort of thing, there are several good ones out there that will make it easier to do the mappings. Hope this is helpful. You might want to check out O'Reilly's www.xml.com web site, it has a lot of interesting articles discussing this sort of thing. Heyho folks, I hope I am in the correct mailing list here. We do have a performance problem with mySQL. In the database we have : INSERT INTO art_xml VALUES ('0', 'article-infopn lang=enenglish product nr 0 /pnpd lang=enand went away, and two technicians remained with instrument and started to\r and /pdpn lang=dedeutsches product nr 0 /pnpd lang=deand protected meaning of civil life.\r and /pd/article-info'); lots of these entries... and querying happens with : SELECT pr.*, SUBSTRING(xml_description, LOCATE('', xml_description) + length('') ) as jezus FROM art_xml as pr WHERE pr.xml_description regexp '[[:space:]]*pn[[:space:]]*lang=de[[:space:]]*[[:alnum:][:space:]]*de[[ : alnum:][:space:]]*' ORDER BY jezus Well this works.. but.. it is f***cking slow... really slow.. serious slow... ( 50,000 entries need much more than 3 minutes to process this select) So the question is - do we make a major mistake here or is it just so slow ? Thnx folks :) dodger - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: What is the difference between thread and connection
Thanks Paul, I am confused with these two variables in the server status: Connections: 114577 Threads_created: 12759 Could you explain the difference between these two variables? Connections should be the number of connection attemplts to the MySQL server. Does this counts slave connections? Cause they are usually permanent connections. Threads_created - Number of threads created to handle connections. Thank you very much! Mihail - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Mihail Manolov [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, August 02, 2002 1:45 PM Subject: Re: What is the difference between thread and connection At 13:29 -0400 8/2/02, Mihail Manolov wrote: Could someone explain to me what is the difference between thread and connection? No difference. I guess one connection can have many threads? Am I right? The server is multi-threaded. It associates a thread with each connection. Connection ID and thread ID are synonymous. Thanks, Mihail Manolov sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Querying for XML content in the database ?
MySQL really wasn't designed for this sort of useage. Your selects are going to be brute force searches on unidexed data, which is exactly why they are so slow... I would advise you to look into using an XML or XML Enabled RDBMS. There are a lot of possible considerations here as to what you might want. I would advise you to consider abandoning storing XML in a database entirely, as it completely breaks the idea of database design - namely, don't store duplicate data. You would probably be much better served by writing code to wrap the actual data in the database with XML - it's quite easy, and a lot less hassle than trying to store XML. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What is the difference between thread and connection
On Fri, Aug 02, 2002 at 02:53:38PM -0400, Mihail Manolov wrote: Thanks Paul, I am confused with these two variables in the server status: Connections: 114577 Threads_created: 12759 Could you explain the difference between these two variables? Thread caching. MySQL doesn't always need to create a new thread per connection if it's configured properly. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 64 days, processed 1,349,799,179 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: What is the difference between thread and connection
At 14:53 -0400 8/2/02, Mihail Manolov wrote: Thanks Paul, I am confused with these two variables in the server status: Connections: 114577 Threads_created: 12759 Could you explain the difference between these two variables? Threads get reused. When you disconnect, the thread that the server used to service your connection goes back in the pool. Connections should be the number of connection attemplts to the MySQL server. Does this counts slave connections? Cause they are usually permanent connections. Threads_created - Number of threads created to handle connections. Thank you very much! Mihail - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
optimization of select query based on temporary tables
hello, i've faced very long execution of a query. query is based on 2 temporary tables, because contains subselects, unsupported by mysql. problem: i try to get the good's statuses in my warehouse, by analyzing all orders made for these goods. tables are as following: = CREATE TABLE shop_goods ( id int(11) NOT NULL auto_increment, name varchar(255) default NULL, quantity_on_warehouse int(11) default '0', UNIQUE KEY iid (id) ); CREATE TABLE shop_orders ( id int(11) NOT NULL auto_increment, paid datetime default NULL, cancel datetime default NULL, send datetime default NULL, UNIQUE KEY iid (id) ); CREATE TABLE shop_ordered_goods ( ordernumber int(11) NOT NULL default '0', good int(11) NOT NULL default '0', quantity int(14) NOT NULL default '1', UNIQUE KEY number_good (ordernumber,good) ); = to build final sql, i need to make two temporary tables, for storing quantities of goods what are in not cancelled not paid orders: = CREATE TEMPORARY TABLE tmp_not_cancelled_not_paid ( good int(11) not null, quantity int(11) default 0); INSERT INTO tmp_not_cancelled_not_paid SELECT shop_goods.id, sum(shop_ordered_goods.quantity) FROM shop_goods, shop_orders LEFT JOIN shop_ordered_goods on ( shop_ordered_goods.good = shop_goods.id and shop_orders.id = shop_ordered_goods.ordernumber and shop_orders.cancel is null and shop_orders.paid is null ) GROUP BY shop_goods.id; = and in send orders: = CREATE TEMPORARY TABLE tmp_send ( good int(11) not null, quantity int(11) default 0); INSERT INTO tmp_send SELECT shop_goods.id, sum(shop_ordered_goods.quantity) FROM shop_goods, shop_orders LEFT JOIN shop_ordered_goods on ( shop_ordered_goods.good = shop_goods.id and shop_orders.id = shop_ordered_goods.ordernumber and shop_orders.send is not null ) GROUP BY shop_goods.id; = and final sql query looks like this: = SELECT shop_goods.id, shop_goods.name as name, shop_goods.quantity_on_warehouse, tmp_not_cancelled_not_paid.quantity, tmp_send.quantity, (tmp_not_cancelled_not_paid.quantity - shop_goods.presence) FROM shop_goods, tmp_not_cancelled_not_paid, tmp_send WHERE /* shop_goods.name like '%smth%'and */ tmp_not_cancelled_not_paid.good = shop_goods.id and tmp_send.good = shop_goods.id /* order by smth */ = issue: running these query on tables with less than 30 entries takes about some seconds, but on real tables with more than 10 000 entries i wait two long that cancel query. question: how can i optimize the query(ies)? i need to match web-server timeout of 30 secs. Artem Mikhailov [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySql on Linux Clustering..?
You could set up a clustering configuration using our replication. Just take a look at the replication section of our online docs: http://www.mysql.com/documentation/index.html Kerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 9:09 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: MySql on Linux Clustering..? I want to run MySql on Linux Clustering Sever. But I can't find about that. Would you tell me , Where can I get MySql Clustering HOW-TO Docs? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Crashing under high load
On Friday, 2. August 2002 20:48, Shane Allen wrote: Hi, I digress... at this point, the question that plagues me is: Is it normal for MySQL to die under high load? you have a lot of programs, which prefer to die under heavy load. The main question is not why they die, the question is why is the load so high? I hope you already analyzed your system, your mysql-server and your queries and can could give us some more additional information. Regards Georg - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Documentation Bug - change requested
Since CHECK cannot be used in CREATE TABLE in any way, shape or form, remove it from the documentation for CREATE TABLE. Lary Irwin CCA Medical sql, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySql on Linux Clustering..?
Replication, however, is no good for scaling update load. What happens when you're update load is too much for the box? Are you just meant to buy a bigger box? What happens if you already have the biggest box and the update load is too high? Is there no way to scale the update load wide in MySQL? --Mike - Original Message - From: Kerry Ancheta [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, August 02, 2002 9:37 PM Subject: RE: MySql on Linux Clustering..? You could set up a clustering configuration using our replication. Just take a look at the replication section of our online docs: http://www.mysql.com/documentation/index.html Kerry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 on Linux Clustering..?
I should clarify that you could have a cluster of MySQL servers using our replication. However for clustering you should consider the following: Maybe the most powerful project in this area is Beowulf (not Linux only) http://www.beowulf.org, but there are many such projects like: Cplant http://www.cs.sandia.gov/cplant/ Legion http://legion.virginia.edu Linux Virtual Server Project: http://www.linuxvirtualserver.org MOSIX: http://www.mosix.cs.huji.ac.il/ High-Availability Linux Project: http://www.linux-ha.org Kerry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 01, 2002 9:09 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: MySql on Linux Clustering..? I want to run MySql on Linux Clustering Sever. But I can't find about that. Would you tell me , Where can I get MySql Clustering HOW-TO Docs? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 duplicate table
Brent Don't know if that's what you are trying to do. But I can't think of any reason to permanently replicate a table in the same database. Maybe the other person is duplicating the data to do test stuff to it... mysql,query [I hope the spam thing lets this through] DSL -- We are not the United States' ally We are the 53rd sovereign state of the Federation - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Crashing under high load
On Fri, Aug 02, 2002 at 10:59:18PM +0200, Georg Richter wrote: On Friday, 2. August 2002 20:48, Shane Allen wrote: I digress... at this point, the question that plagues me is: Is it normal for MySQL to die under high load? you have a lot of programs, which prefer to die under heavy load. The main question is not why they die, the question is why is the load so high? I hope you already analyzed your system, your mysql-server and your queries and can could give us some more additional information. Well, most programs, in my experience, will keep running, even if load is 200, they just run slowly since they aren't getting processor load. As for why things are busy on the box, well, we run a fairly popular site... we have a primary database server that handles a large majority of our queries. Discussions about setting up a cluster or some other such thing aside, this server handles something to the tune of 3000 queries every five minutes during our off hours. During peak times, it's hit over 100k queries in five minutes, where quires == selects + updates + inserts, etc. We have spent a good deal of time lately optimizing what few queries were not already as good as they can be, but because of the large amounts of data we're dealing with, we sometimes join across 5 tables -- not much we can do about that. We're also performing a fairly extensive audit of our processes to reduce the number of necessary queries. We're also running MySQL databases on all of our front-end webservers that store non-changing data, like ISO country codes and such. All these things are intended to keep the load as low as possible. So, clustering aside (it's not an option right now), I am concerned about why MySQL dies... syslog and ntpd, for example, doesn't die under high load. On our front-end webservers, neither Apache nor cron die. So why is MySQL dying? Which takes me back to my original set of questions... The gentleman on PHPBuilder (http://www.phpbuilder.com/columns/tim2705.php3) (again, I acknowledge this is an old article) says flat out that MySQL tends to die under high load. Also, when I say high load, I am talking 15-30. I have yet to see an application (other than MySQL when it's loaded down with queries) die under this level of load. So, if there is additional information that you would like in order to help us solve this problem, I will be happy to provide it. What would you like to know. Again, thanks in advance for any help you can provide. -- Shane Allen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Crashing under high load
Well, most programs, in my experience, will keep running, even if load is 200, they just run slowly since they aren't getting processor load. How's the memory? Typically things (especially Mysql) croak if they bonk on memory - if you're into the swap on high load, you're screwed. -- - Eric Anderson Wild Web Amateurs CyberIron Bodybuilding ICQ 3849549 http://www.wildwebamateurs.com http://www.cyberiron.com San Diego, CA[EMAIL PROTECTED] [EMAIL PROTECTED] - You've got the brain and talent to do anything you want, and when you do, I'll be right there to borrow money from you! -- Bart Simpson - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
exporting data
Hi guys I know that you can import data into a table by using 'load data infile' or 'mysql' import. however, is there something that allows you to export the create statemtns for the table schema and the data of a database for backup. SO that if we reinstall the whole thing from scratch all we need are the exported files that will recreate the whole database from the time we exported? Thanks Desmond _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: exporting data
On Fri, Aug 02, 2002 at 03:55:52PM -0700, Desmond Lee wrote: Hi guys I know that you can import data into a table by using 'load data infile' or 'mysql' import. however, is there something that allows you to export the create statemtns for the table schema and the data of a database for backup. SO that if we reinstall the whole thing from scratch all we need are the exported files that will recreate the whole database from the time we exported? mysqldump will do it. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 64 days, processed 1,352,277,811 queries (240/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: exporting data
Do you mean like 'mysqldump'? You can use mysqldump to dump tables +/- data and then upload it to a database later--or 'import' it, e.g., mysqldump -u user_name database all the tables from that database. mysqldump takes a variety of arguments. see 'man mysqldump' for more info. -mj Desmond Lee wrote: Hi guys I know that you can import data into a table by using 'load data infile' or 'mysql' import. however, is there something that allows you to export the create statemtns for the table schema and the data of a database for backup. SO that if we reinstall the whole thing from scratch all we need are the exported files that will recreate the whole database from the time we exported? Thanks Desmond _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Crashing under high load
On Fri, Aug 02, 2002 at 05:41:09PM -0500, Shane Allen wrote: The gentleman on PHPBuilder (http://www.phpbuilder.com/columns/tim2705.php3) (again, I acknowledge this is an old article) says flat out that MySQL tends to die under high load. Also, when I say high load, I am talking 15-30. I have yet to see an application (other than MySQL when it's loaded down with queries) die under this level of load. That's not normal at all. MySQL shouldn't care about the system load. It may run *slower* but it shouldn't die. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 64 days, processed 1,352,421,911 queries (240/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: exporting data
Thanks Jeremy :) From: Jeremy Zawodny [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Desmond Lee [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: exporting data Date: Fri, 2 Aug 2002 15:59:01 -0700 On Fri, Aug 02, 2002 at 03:55:52PM -0700, Desmond Lee wrote: Hi guys I know that you can import data into a table by using 'load data infile' or 'mysql' import. however, is there something that allows you to export the create statemtns for the table schema and the data of a database for backup. SO that if we reinstall the whole thing from scratch all we need are the exported files that will recreate the whole database from the time we exported? mysqldump will do it. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 64 days, processed 1,352,277,811 queries (240/sec. avg) _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
THIS IS NOT AN ADVERTISEMENT: BugReport..Need Help
To Whom It May Concern: Environment: Operating System Windows XP Home Edition Using MySQL 3.23 Using Apache 1.3.12 Initially it started working suddenly after trying all of the commands below... : ) The next day I started the computer and it does not work : ( Tried to intall from the C:\Progra~1\MySQL\bin prompt 'mysqld-nt --install'. Resulted in a pop-up windows MySQL error Failed To Install Service. Typed 'mysql-nt' alone at the bin prompt..., the prompt comes back with no stated errors. Typed at prompt 'net start mysql' Resulted in The MySql service is starting. The MySql service could not be started. A system error has occured. A System error 1067 has occurred. The process terminated unexpectedly. When using at the prompt 'mysqladmin ping'...the following message resulted: MYSQLADMIN: connect to server at 'localhost' failed error: 'Can't connect to MySQL server on 'localhost' 10061' Check that mysqld is running on localhost and that the port is 3306. You can check this by doing 'telnet localhost 3306'. Please help... : ) Thank you. Cordially, Tien. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AUTO_INCREMENT problem
I've written a C program which inserts new entries into a table with an auto_incremented column. In testing it I created several entries, which I then deleted by connecting to mysql from the unix command line. The problem is, when I reset the last_insert_id from the mysql prompt, it doesn't reset the insert id that's used when I connect through the C program. Is there a way to do this, aside from deleting and repopulating the table, or adding that capability to my program? Thanks, -Alex - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Copying a table structure with constraints intact
Hi There; I have some template tables in my SQL database that I was hoping to copy to make the production tables, but I have noticed that the constraints do not copy when I create the production table using a select statement. Dows anyone know of a way to copy the table and have the constraints copy with the structure? Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
redundent solution
Hi all, Is there a way to setup 2 linux servers with only mysql for an redundant solution ? All mysql data is being realtime copied from the master to the slave. If the master fails with any reason what ever, the slave takes it over. If the master is back, the slave first updates the data and then the master takes over from the slave. Is this possible? If so HOW? Thanks in advance, Richard Pijnenburg Klik-on Internet Solutions Query,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
A lil help with a simple query...
Hi Guys, I'm still new to this and I'm trying to get back into and I need help with a simple query. I have a list of info about a product for an article on my website and I'm pulling all this info from a mysql db and displaying it byway of php but don't know how to do the query. Right now I have this: SELECT manufacturer from hwu_articles WHERE id = '$id' and manufacturer is not null this query works fine, however I want to be able to use this same type of query but for different columns (such as price, name, rating, etc) how can I do this? I want it to be structured liek this: SELECT * from hwu_articles WHERE id = '$id' and * is not null, but I don't think you can use two *'s in the same query, how can I do this? Thanks! -Alex Big Al Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [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
help with a simple query..
Hi Guys, I'm still new to this and I'm trying to get back into and I need help with a simple query. I have a list of info about a product for an article on my website and I'm pulling all this info from a mysql db and displaying it byway of php but don't know how to do the query. Right now I have this: SELECT manufacturer from hwu_articles WHERE id = '$id' and manufacturer is not null this query works fine, however I want to be able to use this same type of query but for different columns (such as price, name, rating, etc) how can I do this? I want it to be structured liek this: SELECT * from hwu_articles WHERE id = '$id' and * is not null, but I don't think you can use two *'s in the same query, how can I do this? Thanks! -Alex Big Al Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [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
MySQL Starts, but quits immediately
Here's the console report... Anyone have any idea what might be the cause? I checked and the .sock file exists, and of course there is no mysqld service running (because it can't start!) Any pointers would be greatly appreciated...! 2002-08-02 21:02:55.755 MySQLInfoTool[1464] attempting to start server /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! 2002-08-02 21:02:55.980 MySQLInfoTool[1464] path:/usr/bin/safe_mysqld args CFArray 0x1ac200 [0xa01403fc]{type = immutable, count = 1, values = ( 0 : CFString 0x54280 [0xa01403fc]{contents = --user=mysql} )} Env (null) -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com407.464.0147 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To 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 with a simple query..
SELECT * from hwu_articles WHERE id = '$id' and price is not null and name is not null and ratings is not null; Bhavin. - Original Message - From: Alex Behrens [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Friday, August 02, 2002 4:49 PM Subject: help with a simple query.. Hi Guys, I'm still new to this and I'm trying to get back into and I need help with a simple query. I have a list of info about a product for an article on my website and I'm pulling all this info from a mysql db and displaying it byway of php but don't know how to do the query. Right now I have this: SELECT manufacturer from hwu_articles WHERE id = '$id' and manufacturer is not null this query works fine, however I want to be able to use this same type of query but for different columns (such as price, name, rating, etc) how can I do this? I want it to be structured liek this: SELECT * from hwu_articles WHERE id = '$id' and * is not null, but I don't think you can use two *'s in the same query, how can I do this? Thanks! -Alex Big Al Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3969599 Owner of the 3D-Unlimited Network: http://www.3d-unlimited.com Send News: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL Starts, but quits immediately
You need the mysql daemon running before you can connect to it. To me it looks like need to start the daemon as a user with the right permissions and then connect to it. Is mysql configured at all on your box? If you haven't read the docs--you probably should. -mj On Fri, 2 Aug 2002, Bill Leonard wrote: Here's the console report... Anyone have any idea what might be the cause? I checked and the .sock file exists, and of course there is no mysqld service running (because it can't start!) Any pointers would be greatly appreciated...! 2002-08-02 21:02:55.755 MySQLInfoTool[1464] attempting to start server /usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! 2002-08-02 21:02:55.980 MySQLInfoTool[1464] path:/usr/bin/safe_mysqld args CFArray 0x1ac200 [0xa01403fc]{type = immutable, count = 1, values = ( 0 : CFString 0x54280 [0xa01403fc]{contents = --user=mysql} )} Env (null) -- Bill Leonard [EMAIL PROTECTED] www.machinemen.com407.464.0147 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
Speed !
I have a database of mysql with 3 million records. No query is performed in less than 10 seconds!(With Index and all that) Any way to speed this up ? How on earth does US Social Security dept. maintain so many records ? Google has 1 billion pages and qurys in a few milliseconds... I am not saying that they are using MySQL! Should this be asked in a mysql list ? Please suggest a NNTP server! Lord Loh. __ Give your Company an email address like ravi @ ravi-exports.com. Sign up for Rediffmail Pro today! Know more. http://www.rediffmailpro.com/signup/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Outlook to mysql
Hi Aaron, | Is there anyway to take my outlook contacts from the .pst | file and put thme into a mysql database so I can view | them on the net? Among the various ways you could approach this: 1. Use CDO from MS to read records from Outlook and output them into a MySQL database (http://snipurl.com/cdo_intro). 2. Export your Address Book in CVS format (FILE -- EXPORT) and then write a LOAD DATA INFILE script to read them into MySQL (http://www.mysql.com/doc/en/LOAD_DATA.html). 3. Use a free sync service like FusionOne (www.fusionone.com). This would be my recommendation if the only thing you want to do is to be able to view contacts from anywhere. ...etc. Hope this gives you some ideas. Cheers, Shashank Sql, query Shashank Tripathi www.shanx.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 on Mac OSX
I'm new to the list trying to run Php Mysql on the Apache server built-in Mac OSX. I'm running with the following error : [localhost:/usr/local/mysql] pierreva% mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) [localhost:/usr/local/mysql] pierreva% Can you help me to find what I'm doing wrong ? Pierre Vaudrey email [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