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)

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

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

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