Re: connection lost on long-distance connection

2001-03-14 Thread Boulat Khakimov
Hi, Here is the way I would fix that problem (assuming you're a programmer) write a simple function check_connection(MYSQL **conn) for example. that will issue a query "SELECT NOW()" to mysql, if that query fails that means connection to mySQL has gone away and the function has to reconnects

Re: mySQL error ?

2001-03-12 Thread Boulat Khakimov
TranceMaster wrote: I couldn't connect to mysql server, beacuse it said that user root@localhost couldn't connect (?!) but before that I did something with the grant tables, I don't remeber what? But I made one cgi that used tables, but it coonected to the mysql server as root user and a

Re: from where shall I start ?

2001-03-12 Thread Boulat Khakimov
From: hanan khader [mailto:[EMAIL PROTECTED]] Sent: lunes, 12 de marzo de 2001 11:02 To: [EMAIL PROTECTED] Subject: from where shall I start ? Hello , to build a database using SQL Server, from where shall I start ? I mean, what shall I install on my Server, and how can I work with

Re: Nesting

2001-03-09 Thread Boulat Khakimov
MEYR))),' - ') FROM TABLE; Is it not possible to nest an "if, then, else" statement? Thanks. John Halladay Yes it is possible, I was nesting if inside another if w/o any problems, there is probably something wrong with your syntax . Post the full query maybe then I'll be able t

Re: C API problem

2001-03-05 Thread Boulat Khakimov
john1 wrote: dear Sir : MySQL 3.22 on my linux 486 PC seems work so good. when I compile a simple C API program which catched from the MySQL tutorial, it chokes at the end of compile process . the program is as follows: #include stdio.h #include mysql.h #define def_host_name NULL

Re: HELP !!I had to install a new mysal version and I cannot compile my programs !

2001-03-05 Thread Boulat Khakimov
Daniel Pope wrote: Hello, I was using C API under mysql-3.22.32. and I was forced to reinstall the mysql servr. Unfotunately I found only the version 3.23.23. Thw big problem is that the same sources give me under Mysql C API 3.33.23 the following message link error: In function

Why MySQL?

2001-03-02 Thread Boulat Khakimov
Hi guys, I'm wondering why you prefered mySQL overe Postgres , they are both open source, and accorting to many people Postgres is more powerful and stable than mySQL. I've been using mySQL for awhile myself, but recently, I've been extremely frustrated by mySQLs bugginess ... the BDB

Unable to make install mysql with DB-3.2.9a

2001-03-01 Thread Boulat Khakimov
install_lib install_utilities install_docs make[1]: install_include: Command not found make[1]: *** [install] Error 127 make[1]: Leaving directory `/usr/src/mysql-3.23.33/db-3.2.9a/build_unix' make: *** [install-recursive] Error 1 Anyone knows how to solve this prob

Help with a seg fault

2001-02-26 Thread Boulat Khakimov
bash-2.04# ./mysql.server stop Killing mysqld with pid 11564 010226 15:59:55 mysqld ended bash-2.04# ./mysql.server start bash-2.04# Starting mysqld daemon with databases from /usr/local/mysql/var /usr/local/mysql/bin/safe_mysqld: line 254: 11600 Segmentation fault $NOHUP_NICENESS