Upgrading from mysql to mysql-max
Hello, Currently I have a server running an older version of mysql 3.23. This was installed using RedHat's provided RPMs (ie there's mysql, mysql-shared and mysql-devel RPMs installed). I want to upgrade to mysql-max (latest 3.23 version) however I'm pretty sure that the redhat RPMs place the mysql files in a different location than the mysql.com provided RPM. Can I just install the mysql.com provided RPM overtop of the redhat one? Should I uninstall the redhat RPMs first? Basically what is the least painful way of performing the upgrade? Regards, Chris Book [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: search engine in 3.23.32
Use the php function 'explode' to seperate words based on spaces into an array, and then go through your list checking the length of each word. Chris -Original Message- From: Craig Issod [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 10:44 PM To: [EMAIL PROTECTED] Subject: search engine in 3.23.32 I'm running into the problem of word length shorter than 3 characters not being accepted in this version of FULLTEXT searches. Example at: http://www.hearth.com/search/index.php (use fuzzy search at bottom)... I can't recompile now, and also don't have the technical ability to create a complicated php work around, but here's what I'd like to do. Set up some PHP to look at the submitted search string, and if any words in it (except for a small defined list in the PHP like the, for) are exactly 3 characters, that search will go to a regular 'LIKE query instead of the default MATCH. I do know the if/then part...what I need help on is the logic of picking out 3 letter words. I know this may be a bit off-topic, but any hints on doing so in PHP or javascript would be welcome. -- -- Craig Issod HearthNet at http://www.hearth.com [EMAIL PROTECTED]Everything your Hearth Desires -- -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: File permissions
set your /home/Venu/ directory to be readable by all users: chmod 755 /home/Venu This has security issues but at least it'll fix your problem :) Chris -Original Message- From: Venugopal Allavatam [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 13, 2001 1:40 PM To: [EMAIL PROTECTED] Subject: File permissions Hi All! i tried the load_file after changing the File_priv in the user table of mysql database for a particular user 'user1'... insert into ecg_datafile values(1,1,load_file('/home/Venu/fr1w.jpg')); ERROR 13: Can't get stat of '/home/Venu/fr1w.jpg' (Errcode: 13) i get the following error, can anyone explain it! regards venu = Venugopal Allavatam Ph: (res.): 949-361-6604 1100 Calle Del Cerro, (mobile): 949-842-1767 Apt.# 123-J, San Clemente, CA-92672 E-mail: [EMAIL PROTECTED] [EMAIL PROTECTED] __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
killing fulltext processes
Hello, I have some fulltext search queries that seem to be hanging my database. They're supposed to search a large text database, but every once and a while one doesn't come back and it brings the whole system down with it. My CPU load isn't very high, but my processlist is full (300) and mysql is refusing more connections. I try to kill a fulltext process, and it just changes the state to 'killed', however it still is stuck there and never cleans itself up. Is there a way to actually kill a fulltext search? Is there a way to kill every process? I have access to the kill command but I can't restart the server directly. Can I perform some pipe magic to get mysql to kill all my processes? Lastly, I'm wondering what's taking my fulltext search so long. I have about 50,000 rows, making the table about 117MB. Usually the queries run fine, but sometimes they bring my whole site to a halt. Thanks, Chris Book - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: String composite key vs auto_increment
That's not really true. You can use an auto_increment field as the primary key and create a seperate UNIQUE index that combines both the firstname and lastname fields that will be inforced for inserts. Usually its easier to work with integers as primary keys, especially when you reference them in other tables and such. I assume its slightly faster for MySQL to work with shorter integers than longer strings as primary keys but I could be wrong. Chris -Original Message- From: Christian Stromberger [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 08, 2001 5:59 PM To: Mysql Subject: String composite key vs auto_increment Disclaimer: SQL/database newbie here. Let's say I have a table of authors with columns for last name and first name. Is there any general guideline re using a separate integer for the primary key as opposed to a combination of the last and first names as the key? I ask because by using the names, this would prevent duplicate entries into the db, right? Whereas using a separate integer key would not prevent this--you'd have to search for the author to see if it was already in the db before inserting to avoid dupes, right? Assume I am not concerned about there being two different Joe Smith authors that are different people. I only want to associate an author name with a book. (Any pointers to good resources besides advice from this list also appreciated) Many thanks. -Chris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Setting a DEFAULT value
I suggest a few things. First, set it to NOT NULL DEFAULT 1, and then set the value explicitly to null, which will cause it to use the default value. The problem with inserting '' is that its casting to an integer and mysql decides that '' should be 0. Or try using : insert into table (column1, column2, etc) value (value1, value2, etc) but don't include icon in your list of columns and that will default it to 1. Chris -Original Message- From: Chris Williams [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 04, 2001 3:52 PM To: [EMAIL PROTECTED] Subject: Setting a DEFAULT value I'm trying to create at table that inserts a default value into a field if nothing is supplied. If in interpret the documentation correctly this should be accomplished by something like this: CREATE TABLE Location (LocationID VARCHAR(10) NOT NULL PRIMARY KEY, Name VARCHAR(50), Address1 VARCHAR(50), Address2 VARCHAR(50), City VARCHAR(50), State VARCHAR(50), Zip VARCHAR(10), Phone VARCHAR(20), Email VARCHAR(50), URL VARCHAR(75) , Icon INT DEFAULT 1) Where the Icon field will get set to 1 if no value is supplied upon insert. When I insert a row such as: INSERT INTO LocationTEMP VALUES (100,1,2,3,4,5,6,7,8,9,'') zero (0) gets inserted in the Icon field. It appears DEFAULT doesn't work. Thanks, Chris Williams - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: PHP4 and MySQL
For windows binaries, if you want to enable other databases, you have to uncomment the associated .dll file in the php.ini. Php doesn't have a seperate dll file for mysql, as the module is build right in (you couldn't disable it if you wanted to). When you compile it directly, if you don't specify any options, then you automatically get mysql support. That's what it means by 'built in'. Chris -Original Message- From: Benj Arriola [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 4:41 PM To: [EMAIL PROTECTED] Subject: RE: PHP4 and MySQL Being a PHP programmer, I know that PHP supports almost every database invented on earth. Now on the download page: http://www.php.net/downloads.php Under Windows Binaries: PHP 4.0.6 zip Package says MySQL support BUILT-IN Knowing PHP supports every database, why on the download page it mentions something about MySQL? And why use the words built-in. I was assuming MySQL came with it already. I guess to find out, I'll have to install it, but being far from the US and with small bandwith, downloading large files is not always ideal to do. :-) I was just checking if someone has already got the latest PHP version for Windows and would ask if ever MySQL did come with it. Benj -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 5:30 AM To: [EMAIL PROTECTED] Subject: Re: PHP4 and MySQL At a certain time, now past, Benj Arriola spake thusly: PHP4.0.6 claims to have MySQL with it. Is this all installed with one installation file? Is it just one run of the setup file and you have PHP and MySQL installed together? I'm sure it says something to the extent of having MySQL _support_ within PHP. If you get PHP from the source, then no...it's not a one click install and you've got both. http://www.php.net/manual/en/ref.mysql.php ~ELH~ -- Eric L. Howard e l h @ o u t r e a c h n e t w o r k s . c o m www.OutreachNetworks.com313.297.9900 Advocate of the Theocratic Rule - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Query on Mysql
You have to setup an ODBC connection using the MySQL ODBC Driver (MyODBC), and then you use ASP to create connection and recordset objects. Chris -Original Message- From: murali madhav [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 12:40 AM To: [EMAIL PROTECTED] Subject: Query on Mysql Hi ! I would like to use ASP(Active Server Pages) Mysql as database for my website,can you please tell me the procedure for connecting the same. Pl reply ASAP. Regards, Murali __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
load data infile problems
Hello, This is what I'm trying to do: load data local infile 'file.txt' into table mytable fields optionally enclosed by '' escaped by '' terminated by ',' My file looks like this 1,data1 2,data2 3,data3 etc my table is defined with (id integer not null, data varchar(200) not null). The command only inserts one row, which contains all the data concatenated into my data column... ie select * from mytable | id | data | | 1 | data1 2,data2 3,data3 1 row in set, since all the data is being entered into the first row (concatenated to 200 chars). Can someone tell me what I'm doing wrong? Thanks, Chris Book [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