Upgrading from mysql to mysql-max

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

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:

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]

killing fulltext processes

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

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

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,

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

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:

load data infile problems

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