Startup script for Solaris 7?

2002-10-01 Thread Bin Zhang

If you are running MySQL on a Solaris 7 machine, would you mind sharing 
your startup script with the list?  Thanks.

bz


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: phpMyAdmin and mysql 3.23.49

2002-07-05 Thread Bin Zhang

Thanks for the pointer.  Anyone know how to make phpMyAdmin to work
around this new "feature"?  Thanks.

Bz

On Fri, 2002-07-05 at 10:14, hcir wrote:
> starting with version 3.23.49, load data local is dis-abled
> 
> see this URL for more info
> 
> http://www.mysql.com/doc/L/O/LOAD_DATA_LOCAL.html
> 
> > I  upgraded my redhat to 7.3, which comes with mysql 3.23.49.  Since
> > then, I am no longer able to upload data files into mysql databases.
> >
> > This is what I got:
> >
> > The used command is not allowed with this MySQL version
> >
> > I think the "used command" here is referring to "load data local
> > infile".  Has anyone else had this problem?  Any workaround?  Thanks.
> >
> >
> - hcir
> [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




phpMyAdmin and mysql 3.23.49

2002-07-05 Thread Bin Zhang

I  upgraded my redhat to 7.3, which comes with mysql 3.23.49.  Since
then, I am no longer able to upload data files into mysql databases.

This is what I got: 

The used command is not allowed with this MySQL version

I think the "used command" here is referring to "load data local
infile".  Has anyone else had this problem?  Any workaround?  Thanks.

BZ


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Sorting w/ leading articles ignored

2001-07-25 Thread Bin Zhang

Can this be done?  What I want is to generate a list of journal sorted by
the titles, ignoring the leading articles (the, a, an, etc.).  If there is
no SQL statement for this, How could I do this w/ DBI or PHP?  I am using
mysql 3.23.40 on  Solaris 7. Thanks for any advise.

Bin


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php