Re: connection lost on long-distance connection

[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 to mySQL, if not then life is good and the function 
exits without having to do anything else.

Now after writing that function, call it right before executing 
any query in your program. 

Regards,
SC



-- 
Nothing Like the Sun

-
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: from where shall I start ?

[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 MySql ? sorry Iam
> 

How about  http://www.mysql.com/documentation/index.html  


-- 
Nothing Like the Sun

-
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: C API for Create Table

[Boulat Khakimov]

Shambhu Kumar singh wrote:
> 
> Hi,
> 
> Can anyboby help me out. I am in a fix over how to carry out CREATE TABLE using C 
>APIs. The manual is of no help in this matter.
> 
> So anybody I please help me out.
> Thanks in advance.
> 
> Shambhu.
>

"CREATRE table" using C API should be treated just like any other query.
It doesnt matter if its CREATE,SELECT,UPDATE,etc - those are all querys 
and should be executed using C API almost the same way

mysql_query(conn,query)
...
etc.



--
Nothing Like the Sun

-
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: mySQL error ?

[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 password, and it perfectly worked.
> Then I erased mysql directory and compiled binary
> version of mysql again
> and it said that it can't load mysql because of
> /tmp/mysql.sock , I am not quite sure what that is.
> Then I installed rpm version of mysql and I got the
> same message for /tmp/mysql.sock
> I don't know what to do now. Please help
> I need to install it, because I just started to
> practice mysql and also connecting cgi to mysql and
> viewing all that in browser.
> 
> Thanks in advance
> 
> Zoran Raskovic
> 


Most probably your mysqld is not running...

-- 
Nothing Like the Sun

-
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: Nesting

[Boulat Khakimov]

John Halladay wrote:
> 
> I'm getting a warning that says "the supplied argument is not a valid MySQL
> result resource."
> 
> Here is the SQL that I'm trying to write in a php document.
> 
> SELECT IFNULL(IF(CMBYR=CMEYR,CMBYR,IF(CMEYR="+",CONCAT(CMBYR,CMEYR),CONCAT(CMBYR,'
> - ',CMEYR))),' - ')
> 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 to help you.



Regards,
Boulat Khakimov


-- 
Nothing Like the Sun

-
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: HELP !!I had to install a new mysal version and I cannot compile my programs !

[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 my_compres_alloc my_compress. o (text +0x120) undefuned reference to 
>'compress'.
> And I'm completely stuck !
> 
> Anyhelp would be greatly appreciated !
> Daniel

*Yawn*

you missing -lz in your gcc compiler options. Just edit yout Makefile
and add -lz...



-- 
Nothing Like the Sun

-
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: C API problem

[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 
> #include 
> 
> #define def_host_name NULL
> #define def_user_name NULL
> #define def_password  NULL
> #define def_db_name NULL
> 
> MYSQL *conn;
> int main(int argc,char *argv[])
> {
> conn=mysql_init(NULL);
> mysql_real_connect(
>  conn,
>  def_host_name,
>  def_user_name,
>  def_password,
>  def_db_name,
>  0, /*port defaut*/
>  NULL,  /*socket default*/
>  0);/*flag*/
> mysql_close(conn);
> exit(0);
> }
> 
> I compile as follows:
> 
> gcc -o client my_simplest_prog -I/home/MySQL/MySQL/include \
>-L/home/MySQL/MySQL/lib \
> -lmysqlclient
> 
> then I get :
> 
> /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
> my_open.o(.text+0x14):undefined reference to 'open64'
> /home/MySQL/MySQL/lib/libmysqlclient.a(mf_format.o)In function 'fn_format':
> mf_format.o(.text+0x201):undefined reference to '__lxstat64'
> /home/MySQL/MySQL/lib/libmysqlclient.a(my_open.o)In function 'my_open':
> my_open.o(.text+0x21):undefined reference to 'fopen64'
> 
> nothing left to do with the situation, I beg your help. anyway I'm a
> newcomer. thank you very much.
> 
> please send message to [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


You missing -lz in the list of gcc options.

Regards,
Boulat

-- 
Nothing Like the Sun

-
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

Why MySQL?

[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 transaction support for example is
extremely unstable.

Regards,
Boulat


-
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

Unable to make install mysql with DB-3.2.9a

[Boulat Khakimov]

Hello,

I have mysql-3.23.33 installed, when trying to add BDB support using
db-3.23.33  I get the message below
after doing "make install" from /usr/src/mysql-3.23.33.
Note: I had no problem with "make" or "configure" and I did follow all
installation steps explained on www.mysql.com website.
. . .
. . .
Making install in client
make[1]: Entering directory `/usr/src/mysql-3.23.33/client'
make[2]: Entering directory `/usr/src/mysql-3.23.33/client'
/bin/sh ../mkinstalldirs /usr/local/mysql/bin
 /bin/sh ../libtool  --mode=install /usr/bin/ginstall -c  mysql
/usr/local/mysql/bin/mysql
/usr/bin/ginstall -c mysql /usr/local/mysql/bin/mysql
 /bin/sh ../libtool  --mode=install /usr/bin/ginstall -c  mysqladmin
/usr/local/mysql/bin/mysqladmin
/usr/bin/ginstall -c mysqladmin /usr/local/mysql/bin/mysqladmin
 /bin/sh ../libtool  --mode=install /usr/bin/ginstall -c  mysqlshow
/usr/local/mysql/bin/mysqlshow
/usr/bin/ginstall -c mysqlshow /usr/local/mysql/bin/mysqlshow
 /bin/sh ../libtool  --mode=install /usr/bin/ginstall -c  mysqldump
/usr/local/mysql/bin/mysqldump
/usr/bin/ginstall -c mysqldump /usr/local/mysql/bin/mysqldump
 /bin/sh ../libtool  --mode=install /usr/bin/ginstall -c  mysqlimport
/usr/local/mysql/bin/mysqlimport
/usr/bin/ginstall -c mysqlimport /usr/local/mysql/bin/mysqlimport
 /bin/sh ../libtool  --mode=install /usr/bin/ginstall -c  mysqltest
/usr/local/mysql/bin/mysqltest
/usr/bin/ginstall -c mysqltest /usr/local/mysql/bin/mysqltest
make[2]: Nothing to be done for `install-data-am'.
make[2]: Leaving directory `/usr/src/mysql-3.23.33/client'
make[1]: Leaving directory `/usr/src/mysql-3.23.33/client'
Making install in ./db-3.2.9a/build_unix
make[1]: Entering directory
`/usr/src/mysql-3.23.33/db-3.2.9a/build_unix'
install_include 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 problem?

Regards,
Boulat Khakimov.


-
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

Help with a seg fault

[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 $ledir/$MYSQLD $defaults
--basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION
--pid-file=$pid_file --skip-locking >>$err_log 2>&1
010226 15:59:58  mysqld ended

Any ideas what could be causing this???

Im running:
MySQL version: 3.23.32
Linux  version 2.2.18  egcs-1.1.2 release


-
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