Re: weird error that I have not encountered in 2 years

2001-08-31 Thread christopher sagayam
so how to fix the error ? How did file /usr/local/mysql/bin/mysql become a text file ? chris - Original Message - From: "Lezz Giles" <[EMAIL PROTECTED]> To: "christopher sagayam" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, Septemb

weird error that I have not encountered in 2 years

2001-08-31 Thread christopher sagayam
can anyone please tell me what is happening here ? [root@ns dump]# /usr/local/mysql/bin/mysql /usr/local/mysql/bin/mysql: DROP: command not found /usr/local/mysql/bin/mysql: syntax error near unexpected token `(' /usr/local/mysql/bin/mysql: /usr/local/mysql/bin/mysql: line 12: `CREATE TABLE bad

Re: moving entire databases

2001-07-05 Thread christopher sagayam
Wonderful answer ..my problem solved Thanks chris - Original Message - From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "christopher sagayam" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, July 05, 2001 6:49 PM Subject: Re: moving entire

moving entire databases

2001-07-05 Thread christopher sagayam
Hi While moving computers I tried to copy my entire database by just copying the c:\mysql\data directory and after I have installed a new mysql database on the new computer I just relpaced the data directory with my own archived one . Now when I try to start the server it gives an error host.

Re: how to escape french characters

2001-04-11 Thread christopher sagayam
First of all how to find out a special french character using perl and then how to escape it ? chris - Original Message - From: christopher sagayam To: [EMAIL PROTECTED] Sent: Wednesday, April 11, 2001 9:45 PM Subject: how to escape french characters im using a INSERT into

how to escape french characters

2001-04-11 Thread christopher sagayam
im using a INSERT into tablename values ('$something1' , '$something2') now if $something1 contains any french characters likeƩ mysql says there is an error in sql statement I am using a BLOB datatype How to escape french characters using perl or using mysql chris

3.22.25 and RAND()

2001-03-06 Thread christopher sagayam
SELECT * from tablename ORDER BY RAND() does not work in 3.22.25 what is the equivalent ?? It works great in later versions chris _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com

a mysql SQL question

2001-03-05 Thread christopher sagayam
a mysql SQL question - I am programming a TV guide script and I am getting stuck 1) Admin must be able to add tv listings to a database using a form at http://1001cgi.hypermart.net/project1/admin2.html Please IGNORE all the form fields above "Start date - (mm/dd/)"