Re: error codes ??

perror will tell you Error code 69: Srmount error This looks pretty much like a system error to me. Ask your ISP. [EMAIL PROTECTED] schrieb am Donnerstag, 9. August 2001, 01:25:48: > Hello, > I seem to have corrupted mySQL deep down inside. I can not create any tables in any >new databas

About installing MySQL on Linux 7.1

Excuse Me, I'm a starter to Linux. I've downloaded the MySQL-3.23.40-1 for my Linux OS. They are in .rpm form. How can I install the software properly on Linux! = I try to follow the instructions mentioned in manual.txt but it didn't = work. Can you help me and tell my how to install it? Thanks!

RE:Re: Localization..

Hi, try to use "varchar" or "varchar binary" instead. they work fine in my application for searching '%multibyte%multibyte%' condition even. >> Hi, >> >> >> >> I have used Solaris 2.6 (Unicode) and Windows 2000 (UTF8 supports Big5) as >> OS to run MySQL application. In my ex

Re: DBASE help

Date |Wed, 08 Aug 2001 07:02:09 + >From |"saraswathy saras" <[EMAIL PROTECTED]> Hello! SS> hai SS> do anyone know how to join table in DBASE? SS> The situation :- SS> table 1 SS> - SS> EM_id SS> EM_gender SS> table 2 SS> - SS> EN_id SS> EN_name SS> The question is how to

Embedded max() function in an insert?

All, Is there any way to do the following in MySQL: INSERT INTO TableName (rowID) VALUES ('max(rowID)+1') (so that the next unique identifier for the table can be determined WITHIN the insert statement?) I know MySQL provides auto-incrementing and last_insert_id. However, architecture constrai

Re: Question

Date |Wed, 8 Aug 2001 13:11:1 +0800 >From |winnie <[EMAIL PROTECTED]> Hello! W> Hi Sir, W> Now I'm trying the fulltext search of mysql 3.23.40. W> The question is : May I use chinese font as the substring in mysql script? I tried, but failed. Sorry but in current version mysql doesnt supp

Re: Upgrading mysql on Win2K

Date |Tue, 7 Aug 2001 13:07:46 -0700 >From |"A. Clausen" <[EMAIL PROTECTED]> Hello! AC> What is the process of upgrading v3.23.36 to 3.23.40 on Windows NT. Can I just install over top or is there some other steps that should be taken? No.You can just install new version. AC> I am running two

Re: Zerofill Auto_Increment

Date |Tue, 07 Aug 2001 13:59:05 -0500 >From |[EMAIL PROTECTED] Hello! M> Hi All, M> Not sure if this is a bug or just a standard behavior of a auto_increment M> zerofill column. M> I have a column in a MySQL database table assigned as such: M> memid int(8) auto_increment zerofill primary key,

Re: Undefined Reference when Linking with C API

Benjamin Pflugmann wrote: > Hi. > > On Wed, Aug 08, 2001 at 08:01:43PM -0500, [EMAIL PROTECTED] wrote: > [...] > > $ gcc -o cl2 cl2.o -L/usr/local/mysql/lib -lmysqlclient > > > > Can anyone tell me what I need to do to take care of this > > problem? > > Just add -lz (a compression library) to you

RE: Migrating from MS SQLserver to MySQL

I'll look into this, Thanks, bart goormans (will be following up on this thread shortly ...) Van: Gerald R. Jensen [mailto:[EMAIL PROTECTED]] Verzonden: donderdag 9 augustus 2001 3:53 Bart: There are many ways to skin this cat, but this is one we have used recently with good success. Cr

RE: Migrating from MS SQLserver to MySQL

'DTS' the information ? Sorry Edgart, what exactly do you mean by that ? bart From: Edgart Gonzalez [mailto:[EMAIL PROTECTED]] augustus 9, 2001 3:39 You can DTS you information from MsSql to MySQL via ODBC. -Original Message- From: Bart Goormans [mailto:[EMAIL PROTECTED]] Sent: Wedn

Support perfect transaction?

Hi all. I'm wondering about transaction support of Mysql. www.mysql.com announces that recent mysql support transaction.(type=BDB) Does it really support perfect transaction? If not, what's difference ? Please reply to me. Thanks in advance.

Re: Date calculations with php and mysql

At 9:01 PM -0500 8/8/01, Joel wrote: >How do I find the elapsed time on a timestamp field? A timestamp is a single value. You can't find elapsed time without a point of reference to measure it against (two values). What's your point of reference? If you have two timestamps, convert each of the

MySQLdump failure

This is on a RedHat 7.1 (very recently freshly installed) server with all patched from updates.redhat.com installed and kernel 2.4.3-12. RedHat 7.1 installed MySQL 3.23.36 and that's what it was running until this problem came up and I upgraded it to 3.23.40 from the Roswell beta directory from R

About MYSQLGUI

Dear sir, I have a problem, I run the MYSQL GUI on my Server, but it always say that " Can't connect to local Mysql through socket " (111) What is that socket? I have already input the port and the server name. What do i need to do or need to set config or..??? please show me th

mySQL DSN and PHP

Hi Folks - new user here, My question is on the setup of my local server. I'm using Windows 2000 and IIS 5 I've just started to use php on my local IIS as a cgi .exe file. Under c:\Inetpub I have: \mySQL \php \wwwroot etc (php seems to working fine) In a php test page I'm trying to connect to t

Date calculations with php and mysql

How do I find the elapsed time on a timestamp field? I know there must be a way but I can't find it in the Mysql Docs. I am using php 4 and the latest mysql i386 binary. Thank you very much Joel

Re: Localization..

> Date |Wed, 8 Aug 2001 03:05:20 +0800 > From |"SDiZ Cheng" <[EMAIL PROTECTED]> > > Hello! > > > SC> Yes, i have read that too. > SC> that tell me how to compile mysql with multi charset, > SC> but not create such kind of table. > > SC> i expect there is somthing like > SC> CREATE TABLE tbl_na

Re: Migrating from MS SQLserver to MySQL

Bart: There are many ways to skin this cat, but this is one we have used recently with good success. Create a script in MSSQL7 (you can do it through the Enterprise Manager) so can re-create the database schema in MySQL. There are some syntax differences between MSSQL7 and MySQL, but it is prett

Re: Undefined Reference when Linking with C API

Hi. On Wed, Aug 08, 2001 at 08:01:43PM -0500, [EMAIL PROTECTED] wrote: [...] > $ gcc -o cl2 cl2.o -L/usr/local/mysql/lib -lmysqlclient > > /usr/local/mysql/lib/libmysqlclient.a(my_compress.o): In > function > `my_uncompress': > my_compress.o(.text+0x9a): undefined reference to `uncompress' > >

Migrating from MS SQLserver to MySQL

Hi all, There's a fairly large MS SQLserver Database that my client wants me to convert to MySQL. Can someone advice me on how to tackle this, or direct me to some help. There aren't any BLOBs-fields or other exotic field types, mainly straightforward text/integers, so I don't expect too much pro

Undefined Reference when Linking with C API

I'm trying to create a simple C program that accesses MySQL. I've included in the source code. The program compiles fine, but when I try to link it as follows, I get the following error messages: $ gcc -o cl2 cl2.o -L/usr/local/mysql/lib -lmysqlclient /usr/local/mysql/lib/libmysqlclient.a(my_co

Not so good transaction support

Hi. I downloaded mysql 3.23.40 from www.mysql.com. This site announces that this mysql version supports transaction which was not supported in older mysql. I was so happy to find that. So I tested that support. The case was following. I launched two mysql - one in A terminal window and other in B

MySQL server for Sun Solaris i386?

I am looking within http://www.mysql.com/downloads/mysql-3.23.html for MySQL server for Sun Solaris i386? Is MySQL server for Sun Solaris Sparc build-able on Sun Solaris i386? Thanks Jeff Tanner Viathan Seattle, WA - Before po

error codes ??

Hello, I seem to have corrupted mySQL deep down inside. I can not create any tables in any new databases. I will get the exact same errcode each time ... that is : SQL-query: CREATE TABLE test (user_id INT (6) not null AUTO_INCREMENT, notes VARCHAR (100) not null , PRIMARY KEY (user_id)) M

Re: local MySQL server authenticating users by machine username

Bennett: Regardless of the login username / password, you have to GRANT user rights to create, alter, etc. in MySQL. By default, the root user has those rights, but not other users. Gerald Jensen - Original Message - From: "Bennett Haselton" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> S

Re: local MySQL server authenticating users by machine username

At 2:50 PM -0700 8/8/01, Bennett Haselton wrote: >The first page of the MySQL tutorial at: >http://www.mysql.com/doc/C/o/Connecting-disconnecting.html > >says that when you connect to the MySQL server, it authenticates you >based on a username and password that you enter, unless the server >is a

Re: mysql-php mailing list

Jason Radley schrieb am Mittwoch, 8. August 2001, 21:11:57: > I have written a php script to get all the clients > for a mysql table and send them emails. The > problem is when the script is doing its job the > browser times out and it stops the script. so I > am sending about 300 email ou

Re: mysql-php mailing list

On 08 Aug 2001 13:11:57 -0600, Jason Radley wrote: > I have written a php script to get all the clients > for a mysql table and send them emails. The > problem is when the script is doing its job the > browser times out and it stops the script. so I > am sending about 300 email out of 3000. A

Re: ASP & ADO

In my (limited) experience it's nearly as easy as using ASP/ADO wirth Access. MySQL is a bit touchier about what it considers proper SQL. We're developing a hybrid (mutant?) system using MS's IIS web server and MySQL running on a Linux box and it's coming along quite nicely. You really don'

local MySQL server authenticating users by machine username

The first page of the MySQL tutorial at: http://www.mysql.com/doc/C/o/Connecting-disconnecting.html says that when you connect to the MySQL server, it authenticates you based on a username and password that you enter, unless the server is also configured to allow "anonymous" access, in which ca

Re: mysql-php mailing list

Add this to the top of the script: set_time_limit(0); That will set the time out to 0, so it will never time out. -- Jason On 8/8/01 3:11 PM, Jason Radley was heard saying: > I have written a php script to get all the clients > for a mysql table and send them emails. The > problem is

Re: mysql-php mailing list

Dear Jason, maybe the problem is your provider cut CPU time to something like 6 seconds per call? Here in Germany, we have ISPs that do exactly this. So, it's actually not a timeout but rather a "CPU out". Ask your ISP for such restrictions. Hope it helps. Regards, -- Stefan Hinz Geschäfts

Reportwriters for mySQL

I was wondering what GUI reportwriters worked with mySQL. I wanted to use a windows-based software for reporting and I know that Reportsmith and Crystal Reports are popular but do not have connections that directly support mySQL. If I have to use ODBC, will I need to setup a middleware ODBC s

Build problems (+solution) on HPUX 10.20/gcc 2.95

Hi! > "verkouter" == verkouter <[EMAIL PROTECTED]> writes: verkouter> Description: verkouter> I tried to compile the mysql client stuff. verkouter> The first configure command was: verkouter> ./configure --prefix=/jaw0_3/jops/verkout --without-server --without-docs --witho

RE: DBASE help

> Hi Gang, is there a feild number limit in MySql? Like in Access > you can only > have 255 feilds, is this also true in MySql? or is there any limit to the > number of feilds? http://www.bitbybit.dk/mysqlfaq/faq.html#ch9_5_0 (the answer is: Yes, there's a limit. But that limit is somewhere abo

FROM_UNIXTIME problem

While trying to fix my previous database problem, I discovered that FROM_UNIXTIME does not function as I expected (or MySQL can't do math). This is 3.23.38 (upgrading to 3.23.40 in the next few days): SELECT UNIX_TIMESTAMP(End_Time) - (Hours * 60 * 60) from ProjectTime; +

mysql-php mailing list

I have written a php script to get all the clients for a mysql table and send them emails. The problem is when the script is doing its job the browser times out and it stops the script. so I am sending about 300 email out of 3000. And the browser said page not found. Any ideas? Thanks Jason

RE: SQL Error?

---> Reply is under the quoted text <--- =>From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] =>Subject: SQL Error? => =>I have a table that contains hourly work done on projects. It has =>a basic structure of (extraneous fields left out): => =>++--+--+ =>| Field

Solaris 8 intel Seg Fault when starting

>Description: After installing mysql and running the ./bin/safe_mysqld it seg faults with a core dump >How-To-Repeat: /usr/local/mysql/bin/safe_mysqld >Fix: >Submitter-Id: mbest >Originator:Super-User >Organization: >MySQL support: [none] >Synopsis: Seg Fault starting mysqld afte

Re: Logging connections

- Original Message - From: "Tadej Guzej" <[EMAIL PROTECTED]> > How would I log connections to MySQL server? > I need the time user connects and the time user disconnects. It's a workaround, but the general MySQL log actually has this information. Here's a sample: /usr/sbin/mysqld,

ERROR rotating logs problem in MySQL(Linux)

I'm pretty new to the Linux world and i'm getting the following error: errors occured while rotating /var/log/mysqld.log mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' erorr running prerotate script -- leaving old in place Does anyone know ho

Re: how to install mysql?

Dear Dmitry, > to make a web server out of my pc, just a localhost. How do I set up mysql > to work with php and apache? You are mixing up web server, php and MySQL. You can use MySQL standalone, but for PHP you will need a web server (at least on localhost) to actually run those scripts. Tip:

Re: SQL Error?

Dear Michael, > put a WHERE clause in, so I ran the same query in reverse (-2592000). > 1) Is there any way (besides a restore from a 24hr old > backup tape) to get the old values back? I don't think so. Maybe someone has a trick for this. I'd be interested. > 2) Why did these queries fail to d

Re: connection a un serveur Mysql

Dear Amar, make sure to install the databases mysql and test. This is usually done by a script called mysql_install_db. You can find help about this topic in http://www.mysql.com/doc/m/y/mysql_install_db.html Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH

RE: database URL / JDBC connection trouble

Hi ! )-Original Message- )From: [EMAIL PROTECTED] )[mailto:[EMAIL PROTECTED]]On Behalf Of Charles Megnin )Sent: Wednesday, August 08, 2001 8:55 AM )To: [EMAIL PROTECTED] )Subject: Re: database URL / JDBC connection trouble ) ) )Mark - )thanks for your input. )I am using RH 6.2 )however )

RE: error connecting to mysql using JDBC

Hi ! )-Original Message- )From: Danny Khow [mailto:[EMAIL PROTECTED]] )Sent: Wednesday, August 08, 2001 8:15 AM )To: [EMAIL PROTECTED] )Subject: error connecting to mysql using JDBC ) ) )MySQL reported this error when i tried to connect using JDBC : ) )Error during query: Unexpected Exce

MERGE tables and UNION joins

I'm having trouble getting MySQL's union join to work when merging tables from different databases. MySQL complains with "ERROR 1017: Can't find file: 'total.MRG' (errno: 2)" even though this file exists. Here are the commands I use to produce the error. Please let me know how I can get union jo

Bug with MySQL replication of "error 'unexpected success or fatal error' on query 'create database db2183-2'"

>Description: I don't have an absolutely 100% complete description of the problem, but I guess it's easy to figure out what happened... Basically I came to the situation when the slave was down thusly: mysql> show slave status; +-+-+-+

RE: editor

Have a look at urSQL -- http://www.urbanresearch.com/ursql/urquery.php urSQL is a query editor (much like a text editor with database/query support and SQL syntax highlighting). It has the capability to connect directly to your server and submit the query. The History feature keeps track of eac

Re: LOAD DATA INFILE performance testing

Hi! > "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes: Sinisa> Jeff Tanner writes: >> >> I running a test on mysql to test its performance of doing a bulk insert >> into a table using LOAD DATA INFILE. >> >> The table is simple: >> >> CREAT TABLE test ( >> valueCHAR(32)

RE: database URL / JDBC connection trouble

Hi ! )-Original Message- )From: Mark Matthews [mailto:[EMAIL PROTECTED]] )Sent: Wednesday, August 08, 2001 5:48 AM )To: [EMAIL PROTECTED] )Cc: [EMAIL PROTECTED] )Subject: RE: database URL / JDBC connection trouble ) ) )There is no problem with your URL. The message you are receiving come

RE: DBASE help

Hi Gang, is there a feild number limit in MySql? Like in Access you can only have 255 feilds, is this also true in MySql? or is there any limit to the number of feilds? - Before posting, please check: http://www.mysql.com/man

RE: editor

What I do is use the 'source' command. Now, I am assuming that you are running under Win32 since you said "MSDOS hangs." Write the SQL command in your favorite text edior and save. At the mySQL prompt enter the keyword 'source' and then drag&drop the filename unto the MSDOS window. Change the '\'

Re: editor

You can try FreeMascon. It's a windows grafical UI client for MySQL. There you can find a query editor that even highlights syntax. And it's free. download at www.scibit.com HTH, Tadej - Original Message - From: "Naintara Jain" <[EMAIL PROTECTED]> To: "Stefan Hinz" <[EMAIL PROTECTED]>;

Re: Migrating to MS SQL Server

Date |Tue, 07 Aug 2001 13:24:02 +0200 >From |Frank Fisher <[EMAIL PROTECTED]> Hello! FF> My company just stole my web server running MySQL. I will now have to FF> host my site on a consolidated server that has MS SQL Server. FF> How do I migrate? I think my SQL code will be good except for

Re: Localization..

Date |Wed, 8 Aug 2001 03:05:20 +0800 >From |"SDiZ Cheng" <[EMAIL PROTECTED]> Hello! SC> Yes, i have read that too. SC> that tell me how to compile mysql with multi charset, SC> but not create such kind of table. SC> i expect there is somthing like SC> CREATE TABLE tbl_name ( SC> col_name type

Re: database URL / JDBC connection trouble

Mark - thanks for your input. I am using RH 6.2 however charly@theblueplanet[24] cat /etc/hosts 127.0.0.1 localhost.localdomain localhost Besides, I've added 127.0.0.1 explicitely in the db table & tried to connect via that IP address rather than localhost, to no avail. Incidentally, I

error connecting to mysql using JDBC

MySQL reported this error when i tried to connect using JDBC : Error during query: Unexpected Exception: java.sql.SQLException message given: Communication link failure: java.io.IOException the funny thing about the error is that it only happens once in a while. Meaning that an SQL statement mig

Re: Why is there no mysql hpux11 binary for hppa1.1 (32 Bit) database

Andre Konopka writes: > Hi, > > since .38 there is no longer a HPUX11 binary for the hppa1.1 architecure > (32 Bit)?? > > > I think that the 10.20 binary is runnable but I suppose that you > compiled it > with MIT-threads. On HP-UX11 I would prefer to compile it with native > threads, do yo

SQL Error?

I have a table that contains hourly work done on projects. It has a basic structure of (extraneous fields left out): ++--+--+ | Field | Type | Null | ++--+--+ | ID | int(10) unsigned | | | ProjectID |

Re: load multiple files into the same table at once?

Hrmm...from my testing, omitting REPLACE has the same effect as IGNORE is used. Bing Bing Du <[EMAIL PROTECTED], 979-845-9577> Texas A&M University, CIS, Operating Systems, Unix >>> [EMAIL PROTECTED] 08/08/01 02:50AM >>> Dear Bing, what about omitting REPLACE? This should simply load the data

how to install mysql?

How can I install mysql on apache (apache is operated by Windows Me)? I downloaded php, set it up with apache on my windows Me PC, but I don't want to make a web server out of my pc, just a localhost. How do I set up mysql to work with php and apache? Your response would be greatly appreciated, D

Re: Bad path to ibpthread.so.14.20?

1. Add the path to /etc/ld.so.conf 2. Run ldconfig Adam Douglas wrote: > I'm installed MySQL 3.23.37 and I can't get it started. I know there has be > number of posts regarding such a problem but I haven't seen a resolution to > fix mine specificly. I get this error when I try and load mysqld >

connection a un serveur Mysql

J'ai installe un serveur apache, un serveur Mysql et PHP4 sur un serveur Linux Redhat 7.0 ayant pour adresse IP 192.168.1.2 , que j'utilise aussi comme client. j'ai ecrit un script PHP4 dans lequel je me connecte au serveur Mysql $db=mysql_connect('localhost', 'Moncpt', 'Monpasswd'); je recois l

Re: editor

Dear Naintara, >I don't really need a query-creator. If i use notepad, copy and paste >doesn't seem to work -- MSDOS hangs. Do i need to make them into script >files and then run? I assume you run MySQL under Windows 9x. Here, the MySQL Monitor does not supply a history list by default. Simply

salvaging database

Hi-- I am trying to recreate a table. I have the .frm and .isd files, but not the .ism. I assume it is impossible to recover the data (please tell me if I am mistaken!), but is there any way I can get a description of the table from the .frm? I inherited the database from someone else, and I don

Answer to ---> Re: DBASE query question.

In Dbase, do the following to get more information: 1. Type Dbase 2. Get to the "Dot" (.) prompt if you are not already there. You may have to hit the escape key. 3. Type in "Help Join". At 11:43 AM 8/8/2001 +0800, rsaras wrote: >hai > In mysql it can be done but do anyone know how to

Re: Upgrading to 3.23.37 from 3.22.32

Except, mysql needs write permission. Adam Douglas wrote: > MySQL reports read only table. As for file permissions, everything is fine. > Everyone has read and execute privileges. > > >> They are probably not owned by mysql anymore. >> >> Adam Douglas wrote: >> >> >>> I just upgraded MySQL

RE: editor

Dear Stefan, thanks for your input. actually all i need to know is say i type in a long sql query and make a typing error, is there any convenient way to retain the query and make the correction without having to re-type the entire query? eg. when i work with sybase on linux, i simply use 'vi' wi

Re: My databases got hosed when the server went down hard!

Stefan Hinz wrote: > Dear Chip, > > myisamchk is not an SQL command, so it's not executed from the MySQL > Monitor (the SQL command line tool) but rather from a shell. Type > "myisamchk" at the shell prompt and you will see the options. > Thanks, I'm discovering there are a few of these commands

Re: Timezone problem.

Ok :) the problem solved. It was a wrong glibc after all. Regards, Heikki At 01:07 PM 8/8/01 +0400, you wrote: >Hello Heikki, > > Sorry for confuse. The problem is The first complied binary I've > checked which was fine was complied with --with-other-glibc=XXX > therefore the correct option

Re: mysql+gemini compile errors

Hello: The file db/tstset.cc holds all the different versions of how to do an atomic test+set of a bit. If you are on an Intel box, you should be using the section of code that uses the xchg instruction. The configure script should be setting a #define for the machine. (check config.h). Th

RE: database URL / JDBC connection trouble

There is no problem with your URL. The message you are receiving comes from the database. Your network permissions are not setup to allow TCP/IP connections from localhost (or my bet, you're on Redhat which brokenly maps 127.0.0.1 to "localhost.localdomain"). You will need to add grants to allow c

Re: Can't start MYSQL on Linux

I got it. Thank you very very much for the help. Ling >From: Trond Eivind Glomsrød <[EMAIL PROTECTED]> >To: Ling Wang <[EMAIL PROTECTED]> >CC: <[EMAIL PROTECTED]> >Subject: Re: Can't start MYSQL on Linux >Date: Tue, 7 Aug 2001 23:03:41 -0400 (EDT) > > >On Wed, 8 Aug 2001, Ling Wang wrote: > > > I

RE: MySql and PHP

I've had no problems at all with this setup. Locate libmysqlclient.so.10 and make sure the dir its in is in /etc/ld.so.conf, and run ldconfig. >From a source install, its in /usr/local/mysql/lib/mysql. Mike Robinson IT / Developer - Toronto Star TV Phone: 416.945.8786 Fax: 416.869.4566 Email

Why is there no mysql hpux11 binary for hppa1.1 (32 Bit) database

Hi, since .38 there is no longer a HPUX11 binary for the hppa1.1 architecure (32 Bit)?? I think that the 10.20 binary is runnable but I suppose that you compiled it with MIT-threads. On HP-UX11 I would prefer to compile it with native threads, do you agree? The 10.20 binary version isn't co

Re: Installing mysql-3.23.40 on Solaris 2.6

Emmanuel Tubacher writes: > Hi, > > I am new to this list -and somehow to Mysql- so apologies if this topic > already > been covered (list archives ?? where ??). > > I try to install a mysql 3.23.40 version on a Solaris 2.6 with gcc > 2.95.2 and > it just won't complete compilation or even confi

Re: AW: Compiling error in complete.c: filename_completion_function

Sebastian Kayser writes: > Sinisa Milivojevic writes: > > > The dirent.h file is located @ > > /usr/include/ > /usr/src/linux/include/linux/ > > and in various directories below > > /usr/src/mysql-3.23.40/ > > and each of these files seems to be ok. > This is not ok. There should not be an

Re: MySQL++ API under Mac OS X

Halim Chtourou writes: > > I'm using GCC 2.95.2 that comes with Apple's developer tools. I'm > getting tempted to try compiling GCC 3. > > Doing a grep for the above symbols returns matches for both the static > and dynamic libsqlplus libraries, as well as libstdc++.a, which is > automaticall

Updating to v 3.23.40

Hi I've been running v.3.23.33 on Win2000 and have upgraded to v.3.23.40. I unzipped the file to the mysql dir, and let it write over files. The Manual doesn't state you have to remove older version. The readme notes said it's not necessary to run install programs. But the MySQL monitor Welcom

Re: Logging connections

Well, the problem is that I don't know how to determine when a user connects. Sometimes a user is connected for only 10 ms, sometimes 10 minutes. Do I have to do SHOW PROCESSLIST every 10 ms or is there a better sollution? Thanks for the reply. Tadej - Original Message - From: "Werner S

Re: mysql+gemini compile errors

Brian P. Millett writes: > Hello, > SunOS shaka 5.8 Generic_108529-08 i86pc i386 i86pc > gcc version 2.95.3 20010315 (release) > > I'm trying to compile mysql+gemini-3.23.39 on a x86 Solaris 8 box. > I get the following error which has me completly confussed: > > > > -- > Brian Millett >

Re: Timezone problem.

Peter Zaitsev writes: > Hello Michael, > > Tuesday, August 07, 2001, 10:20:18 PM, you wrote: > > The question is which place do you do aply timezone ? > > I found the following interesting thing: Then mysql is started it uses > correct timestamp, therefore INNODB is started with wrong timestamp

[ 러브서프를 추천합니다. ]

´Ô.. ¾È³çÇϼ¼¿ä? [click to see ] ªÀº ¸¸³², ±ä ¿©¿î Ä¿ÇÇ ÇÑ Àܸ¸ ÇÔ²² ÇÏ¿©µµ Áñ°Å¿ï ¼ö ÀÖ´Ù´Â °ÍÀº ÇູÇÑ ÀÏ ÀÔ´Ï´Ù. °¡½¿ ¼Ó¿¡ »óÅ­ÇÑ »ç¶û Çϳª °£Á÷ÇØµÑ ¼ö ÀÖ´Ù´Â °ÍÀº ¼ÒÁßÇÑ ÀÏ ÀÔ´Ï´Ù. ´À³¥ ¼ö¸¸ À־ ¾Æ¸§´Ù

New version of MySQL++ for VC++

Hi! A new sub-version of MySQL++ for VC++ has hit MySQL++ page. This version solves all problems that arise in building application that involve both MySQL++ and MFC classes. Those problems are now fixed and VC++ programmers may further enjoy benefits of MySQL++ API. -- Regards, __ ___

Re: DBASE help

On 08 Aug 2001 08:20:27 +, saraswathy saras wrote: > hai > do anyone know how to join table in DBASE? This is MySQL database list and questions about dBase are off-topic. Please stop spamming. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ _

Re: help please

Dear Santosh, if you change the grant table entries (e. g. in mysql.user) manually, you will have to execute FLUSH PRIVILEGES from the MySQL command line in order to tell the server to reload the grant tables. Granting privileges is better with the GRANT command, which will automatically m

Re: help please

try to download and install updated JDBC driver matching with your MySQL version and JDBC/JDK versions. - Original Message - From: "santosh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 08, 2001 4:07 PM Subject: help please > Hai all, > > I am using MySQL version

RE: integer&char problem

table test - +---+--+--+-+-+---+ | Field| Type| Null | Key | Default | Extra | +---+--+--+-+-+---+ | id_1 | char(3) | | | | | | id_2

Installing mysql-3.23.40 on Solaris 2.6

Hi, I am new to this list -and somehow to Mysql- so apologies if this topic already been covered (list archives ?? where ??). I try to install a mysql 3.23.40 version on a Solaris 2.6 with gcc 2.95.2 and it just won't complete compilation or even configuration. Depending on the flags placed in

Re: Sub select.

On 07 Aug 2001 10:46:31 -0400, Trond Eivind Glomsrød wrote: > MySQL doesn't have subselects. Some workarounds can be found at > > >http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.html#Missing_Sub-selects > > PostgreSQL supports them. Actually MySQL 4.0 will do. -- Fo

Re: Can't start MYSQL on Linux

Dear Ling, > Thank you so much. Can I ask why? you have to keep in mind that the mysqld (that's the MySQL server, or the daemon) is the only one that must have read/write access to datadir (the database directories). On your machine, /var/lib/mysql/ is datadir, and mysqld will run as user "mysql

Re: integer & char

Dear Rsaras, your problem description is not very precise. >message.Then i try to change the type to char ,it's can but, >the max is until 9 only.is there anyone can help me. I guess what you did was to add a field with CHAR type to your table. If you do not specify the length, like CHAR(20), t

Re: ASP & ADO

Dear Steve, > What do I need to know in order to use mySQL with ASP and ADO? You might want to use ODBC for the database connection. It works fine for any database system that provides an ODBC driver. You can find one for MySQL called MyODBC at mysql.com. ODBC is not the fastest way to access a

Re: double column type why...

Dear Attila, I am not a mathematician but I guess you used INT and the data seem to be out of range. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382

Re: Upgrading to 3.23.37 from 3.22.32

Dear Gerald, does mysqld run as user "mysql"? And does user mysql have the correct rights for datadir (e. g. /var/lib/mysql/) and all subdirectories? (The MySQL Daemon is supposed to be the only one who has rights for datadir. So, this could be 700 with user mysql as owner. No one else needs rig

Re: My databases got hosed when the server went down hard!

Dear Chip, myisamchk is not an SQL command, so it's not executed from the MySQL Monitor (the SQL command line tool) but rather from a shell. Type "myisamchk" at the shell prompt and you will see the options. Or you can use the new version of PhpMyAdmin (www.phpmyadmin.com), this has a built-in t

Re: WANTED: Utility to reverse engineer existing database II

Dear Kevin, mysqldump -w or something like SELECT * FROM my_table INTO OUTFILE my_dumpfile WHERE my_id BETWEEN 100 AND 500 Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin #

Re: importing data

Dear Kevin, check the online manual (www.mysql.com/documentation) for "mysqlimport" and for "load data infile". Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-

  1   2   >