Re: easy question

2002-06-13 Thread Hisseine Dj.
>Is there a way to have the timestamp automatically inserted when an >insert statement is run? The timestamp of the insert statement. Try now() Hisseine - Original Message - From: "chad kellerman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, June 13, 2002 9:59 AM Subje

Re: help with mysqlhotcopy

2002-06-12 Thread Hisseine Dj.
> I was wondering if someone could help me out with the syntax to use > mysqlhotcopy to backup a database to a tape drive ( /dev/nst0 ). I've > tried a few variations of the command but with no luck so far. The > mysql server is running on RH 7.2 and the DAT tape drive is on that same > machine

Re: Can I connect to a MySQL Database on a unix platform from a PC?

2002-06-05 Thread Hisseine Dj.
> As a potential MySQL customer, I am trying to find the answer to the > question "Can I connect to a MySQL Database on a unix platform from a PC > through TCP/IP network? If the answer is yes, what other additional > supporting software will be needed on the Unix platform and on the PC? Any > poi

Re: Automatic Primary Key for "circular table"

2002-05-29 Thread Hisseine Dj.
You can use timeval struct and create a field in your Database as double, and then use these two value tv_sec, and tv_usec to build you PK. Hisseine - Original Message - From: "Jonathan Pelletier" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 29, 2002 10:45 AM Subj

Fw: link problem

2002-05-09 Thread Hisseine Dj.
- Original Message - From: "Hisseine Dj." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 09, 2002 2:40 PM Subject: Re: link problem > > > gcc simple1.cc -c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient > > > -lm -

Re: link problem

2002-05-09 Thread Hisseine Dj.
> > gcc simple1.cc -c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient > > -lm -tz -> Replace the -c option with -o Hisseine - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 09, 2002 1:43 PM Subj

Re: C++ API for Mysql

2002-05-06 Thread Hisseine Dj.
Hi Carsten, I've tried Mysql++ and SQLAPI. I am asking if someone out there know about other best tools in C++ for Mysql on linux. Thanks, Hisseine - Original Message - From: "Carsten Gehling" <[EMAIL PROTECTED]> To: "Hisseine Dj." <[EMAIL PRO

C++ API for Mysql

2002-05-06 Thread Hisseine Dj.
Hello, Can someone tell me if there is an C++ API that works smooth with MYSQL on linux. So far I was trying msql++ and SQLAPI++. SQLAPI++ seems to be good by there are problems when runing the program. My system is Redhat 7.2 and Mysql 3.23.49 Thanks, Hisseine -

C++ API for Mysql

2002-05-06 Thread Hisseine Dj.
Hello, Can someone tell me if there is an C++ API that works smooth with MYSQL on linux. So far I was trying msql++ and SQLAPI++. SQLAPI++ seems to be good by there are problems when runing the program. My system is Redhat 7.2 and Mysql 3.23.49 Thanks, Hisseine --

Re: Mysql.sock missing

2002-04-23 Thread Hisseine Dj.
Don't worry if it's running then you can find that file else where on your system; try to look for in /tmp Hisseine - Original Message - From: "Charitha" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 23, 2002 4:58 AM Subject: Mysql.sock missing > > Hello all, > > I a

Re: Cant connect using socket ''(111) for Mysqlgui on linux

2002-04-23 Thread Hisseine Dj.
Verify if your MySQL server is running and the user and password when entering Mysqlgui1.7.5 I have the same on Linux and it's running fine. Hisseine - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, April 2

Re: Newbie: Test for MySQL connection

2002-04-18 Thread Hisseine Dj.
Try shell> cd YourMysqlInstallationDirectory shell> bin/safe_mysqld & shell> mysql -h host -u user -ppassword Hisseine - Original Message - From: "Fei Chen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 18, 2002 10:36 AM Subject: Newbie: Test for MySQL connection >

Re: mysql client issues

2002-04-18 Thread Hisseine Dj.
> ld.so.1: mysql: fatal: libncurses.so.5: open failed: No such file or > directory What kind of system are you using? Linux? Verify on your system for libncurses.so, it should be in /usr/lib. If you have that library on your system then check for library path Hisseine - Original Message --

Re: Enterprise Manager (?)

2002-04-16 Thread Hisseine Dj.
Hy Johnny, I try to install MySQL front on Window 2000. When I run it to connect to mysql server on Linux, I got an error saying this host (my client) cannot connect to the mysql server. It seems to be a configuration on the mysql server, any idea. Thanks, Hisseine - Original Message

Re: Graphical UI for MySQL

2002-04-16 Thread Hisseine Dj.
Try mysqlgui, this is a tool that can give you the ability to do some admin. Hisseine - Original Message - From: "Kela Vesa" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 16, 2002 2:48 AM Subject: Graphical UI for MySQL > Greetings, > > I would like to ask you follow

Re: mysqladmin

2002-04-11 Thread Hisseine Dj.
Thanks Egor, I just did it now and I find that. I start the installation today so that's I am missing some elements. Again thanks for your help. Hisseine - Original Message - From: "Egor Egorov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 12:22 PM Subject

mysqladmin

2002-04-11 Thread Hisseine Dj.
Hi all, I just downloaded the MySql rpm file : MySQL-3.23.49a-1.i386.rpm I did the installation on linux redhat 7.2, everything is ok, but I can't locate the msqladmin command. I try find command as root but nothing in the result. Does binary files are missing in this version? Thanks, Hisseine

Re: About BLOBS

2002-04-11 Thread Hisseine Dj.
Thanks Paul, Hisseine - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Hisseine Dj." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, April 11, 2002 10:40 AM Subject: Re: About BLOBS > >Hello, > > > &

About BLOBS

2002-04-11 Thread Hisseine Dj.
Hello, Does MySqL database supports BLOBs operation? (Insert, delete etc ...) If yes which API can use to do these operations? (MySqL++)? Thanks for help - Before posting, please check: http://www.mysql.com/manual.php