MYSQL DELPHI COMPONENTS

2002-09-02 Thread Nick Lazidis
I wonder if someone could tell me if I can use Delphi 6's , ClientDataSet, Query, DataSetProvider, Database and UpdateSQL components with MYSQL or I have to look at an alternative third party library. Does MYSQL supports transactions with InnoDB type tables ? Thanks Nikos

Re: upgrade 3.23 - 4.0.3 question

2002-09-02 Thread Varshavchick Alexander
I'm using 3.23.49 and it behaves perfectly. Okay I'll try 4.0.2 and see if it helps, thanks for the hint. Alexander Varshavchick, Metrocom Joint Stock Company Phone: (812)118-3322, 118-3115(fax) On Fri, 30 Aug 2002, Steven Roussey wrote: Date: Fri, 30 Aug 2002 10:49:28 -0700 From:

client-serwer communication protocol's documentation

2002-09-02 Thread Krzysztof Krupa
Hi. I badly need the documentation to the mySQL client-server TCP/IP communication protocol. I'm trying to build some measurement system with VEE 6 from Agilent Technologies, mySQL and Apache. There is no possibility in VEE to use ODBC, so I've decided to make some VEE programming of the mySQL

RE: How to run multiple mysql servers

2002-09-02 Thread Tobias Eriksson
Hi Okan, Well, the only solution I know of, to diffrentiate the two servers are to provide different argument on the command line. The server will allways read any of the files; my.ini or my.cnf first, and there set the parameters, after that it will take the command line arguments. This means

Re: Problem installing

2002-09-02 Thread DL Neil
Scott, MySQL is available in two 'flavors': source code and (binary) executables. Which one did you intend to download/install? Which OpSys are you using? Please advise, =dn The instructions that I have to install MySQL, tells me to cd to the bin directory and run this command:

libmysqld and connections to remote server.

2002-09-02 Thread Andre Moll
Hi folks, I just started playing around with libmysqld and I would like to have some clarification concerning making connections to remote server. My first tries are pretty simple so far. I just linked some of my old lil code against libmysqld which worked (from the view compiling) immediately

mysql is driving me mad (3)

2002-09-02 Thread Bob G
mysql is driving me mad (3) Many thanks for your help guys, I have the problem cracked. I, for the umpteenth time dropped the database and recreated it. then from the cli I put in the maximum value of characters. and there after it worked from my prog. Very strange! Thanks again bob

Re: Replication

2002-09-02 Thread Mozzi
I can't understans it though. I did a mysql dump and transported that to the new server and then created the tables that way. So the two must be absolutely identical. (I include them @ the bottom of post) Again I get the same error. Could it be that the status of that particular username has

Re: MySQL 4.0.2, 4.0.3 replication circle broken.

2002-09-02 Thread Artem V. Ryabov
Hello Victoria, Thursday, August 15, 2002, you wrote: AVR In case of repliacation circle (A-B-A) query 'flush log' on any of AVR this servers create endless loop, with creating new binary log file AVR on each iteration. (about 30 new files every second in my case) Thanks for bug report!

Re: upgrade 3.23 - 4.0.3 question

2002-09-02 Thread Varshavchick Alexander
No, switching to 4.0.2 didn't help either, and here is an additional clue which may help: all mysql threads on the 4.0.* are in the sending data state, while for the 3.23 the state is changing all the time to writing to the net, connecting and others. It seems as though the 4.0 version has

Re: Replication

2002-09-02 Thread Dicky Wahyu Purnomo
can you show us, your my.cnf configuration for replication only master and slave ... ;-) my first guest is : the slave working db is not being set properly ... so when master doing query on DB A on table B, the slave try to look at DB blank on table B. see on Replicate-do-db column on

Re: Query problem in Perl

2002-09-02 Thread Martin Waite
Hi, You need to use two separate database and statement handles - you can only have one active query per handle. eg. $dbh1 = DBI-connect(...); $dbh2 = DBI-connect(...); $sth1 = $dbh1-prepare( ... ); $sth1-execute(...); while ( $sth1-fetch() ) { $sth2 = $dbh2-prepare( ... );

MySql-4.0.3-beta requires OpenSSL_add_all_algorithms, not in

2002-09-02 Thread jimd
OpenSSL-0.9.7-beta3 Description: gcc -O3 -DDBUG_OFF -O2 -fno-strength-reduce -o test-ssl test-ssl.o -L/usr/local/ssl/lib -L/usr/local/lib ../dbug/libdbug.a libvio.a ../mysys/libmysys.a ../strings/libmystrings.a libvio.a -L/usr/lib -lssl -lcrypto -lz -lcrypt -lm -pthread /usr/lib/libc.so.4:

Re: 3.23.52 hitting system loads of 25+?

2002-09-02 Thread John Stanforth
Jeremy and Michael, What compiler versions are you using? (just the gcc -v) I'm wondering especially since MySQL has a warning posted about gcc 2.96 with 2.4 kernels. Which reminds me, what specific kernel versions are you guys using? (Jeremy, is yours a custom kernel from Redhat source or

Re: Replication

2002-09-02 Thread Mozzi
Heya Dicky How are you ? Havn't seen you in a while ;-) kay what I did was RESET MASTER and RESET SLAVE And restartted slave That worked!!! Now what I want to know is when I give the command show slave status I get the following mysql show slave status;

select using 2 left joins

2002-09-02 Thread Wilbert Enserink
Hi all, I'm having troubles with a good selection statement in my query. I have three tables: tableAds, tableProducts and tableManufacturer. They all have unique ID's defined. In the tableProducts there is a column named manufacturerID. So I know which product was made by which manufacturer.

Re: Query problem in Perl

2002-09-02 Thread Martin Waite
On Mon, 2002-09-02 at 11:37, Harald Fuchs wrote: In article 1030961610.8175.5.camel@pascal, Martin Waite [EMAIL PROTECTED] writes: Hi, You need to use two separate database and statement handles - you can only have one active query per handle. eg. $dbh1 = DBI-connect(...);

Re: Replication

2002-09-02 Thread Dicky Wahyu Purnomo
Pada Mon, 02 Sep 2002 12:51:50 +0200 Mozzi [EMAIL PROTECTED] menulis : Heya Dicky How are you ? Havn't seen you in a while ;-) kay what I did was RESET MASTER and RESET SLAVE And restartted slave That worked!!! Now what I want to know is when I give the command show slave status I

Re: Query problem in Perl

2002-09-02 Thread Ralf Narozny
Hello! Almar van Pel wrote: Hello, I was trying to create a simple perl program, where my domains where listed followed by there DNS records. But It loops once, and then ends with error DBD::mysql::st fetch failed: fetch() without execute() at test.cgi line 61. I thougt this was the easyest

problems adding records to mysql db using odbc/access 2000

2002-09-02 Thread Dean Browett
Hi, Can someone tell me how I can add a record to a mysql table via an Access 2000 interface using ODBC ver 2.50.39. The primary key on the msyql db is set to auto_increment. When I link to these tables via Access/ODBC the field type in Access is marked as a 'number' data type. Since the tables

Inno DB Question

2002-09-02 Thread Javier Diaz
Hi all, I'm using MySQL 4.0.2 alpha-max with Inno DB and Borland Builder 6.0 to connect to MySQL. I'm trying to use the new dbExpress component for Borland to connect to MySQL using the libmysql.dll I have been making some tests with transactions using the dbExpress components and the normal

Maximum number of rows

2002-09-02 Thread Lukas Knecht
Does anyone know what the maximum number of rows a MyISAM table can store is? We currently have a table (27 GB .MYD, 17GB .MYI) holding more than 2^31 rows: mysql select count(*) from BigTable; ++ | count(*) | ++ | 947945 | ++ 1 row in set (0.09 sec)

Bug ?

2002-09-02 Thread Marian
Why mysql corrupt tables if filesystem if full ... ? On good database servers (eg. PROGRESS) process shutdown server (protetcting data). sytem: linux-2.2.19 mysql-3.23-38 - Before posting, please check:

RE: problems adding records to mysql db using odbc/access 2000

2002-09-02 Thread Henk Huizinga
Dean, Which MDAC version do you use with ODBC ? Henk -Original Message- From: Dean Browett [mailto:[EMAIL PROTECTED]] Sent: maandag 2 september 2002 13:38 To: [EMAIL PROTECTED] Subject: problems adding records to mysql db using odbc/access 2000 Hi, Can someone tell me how I can add

Re: Replication

2002-09-02 Thread Mozzi
Don't understand it still It doesn't give me errors in logfile orf when I type show server stutus. Yet it isn't replicating !! Any ideas ? I even tryed checking file sizes between servers on the .MYD file and it isn't working Mozzi Dicky Wahyu Purnomo wrote: Pada Mon, 02 Sep 2002 12:51:50

RE: Maximum number of rows

2002-09-02 Thread Shashank Tripathi
Hi Lucas, | Does anyone know what the maximum number of rows a | MyISAM table can store is? We currently have a table | We're afraid there is hard, implementation imposed limit | of unsigned int (2^32) on the number of rows. Before trying My guess is that the limit is not in

Help! Recovering corrupt table

2002-09-02 Thread Rolf Howarth
I'm using MySQL 3.23.51. I have a table which started giving 127 errors. Running myisamchk -i on it gives: Checking MyISAM file: /Users/rolf/WBD/back/clip.MYI Data records: 27497 Deleted blocks: 0 ./bin/myisamchk: warning: 9 clients is using or hasn't closed the table properly -

sysdate or curdate as default date in mysql

2002-09-02 Thread Chugh Shalini
Dear All! Can we define sysdate or curdate as default date for a column of datatype 'date' while creating a table? Regards Sql, mysql, query - Before posting, please check: http://www.mysql.com/manual.php (the

MyISAM and Lock table question

2002-09-02 Thread David Bordas
Hi all, Just a little question on the MyISAM table lock implementation ... I just see ( with show full processlist ) that my version of mysql ( 3.23.45 binary linux tar.gz ) locked my MyISAM table at every query and not only for update / delete / insert. Why is it locking table for select query

Re: query crashes 4.03 every time

2002-09-02 Thread Egor Egorov
Matthew, Saturday, August 31, 2002, 10:41:27 PM, you wrote: MM Here is the evil query: MM SELECT DISTINCT * FROM b2posts WHERE 1=1 AND ID = 124 AND ((post_title MM LIKE '%%') OR (post_content LIKE '') OR (post_title LIKE '%%') OR MM (post_content LIKE '%%')) AND post_date '2002-08-31 14:31:55'

Re: Wrong Sorting in arabic alphabets

2002-09-02 Thread Victoria Reznichenko
abdul, Saturday, August 31, 2002, 8:05:27 PM, you wrote: aÚÇ Wrong Sorting in arabic alphabets aÚÇ Hi, aÚÇ This bug is for Arabic alphabets. aÚÇ I am using mysql 32.23.52 What character set do you use? There is no character set for arabic language in MySQL. -- For technical support

Re: mysql default charset

2002-09-02 Thread Victoria Reznichenko
Alexander, Sunday, September 01, 2002, 11:33:56 PM, you wrote: AP How can I set my mysqld-nt.exe to run different charset AP for example cp1251. Currently you can't use different character sets with one MySQL server. AP I tried mysqld-nt.exe --default-charset-set=cp1251 AP but it started

Re: Problem installing

2002-09-02 Thread Egor Egorov
Scott, Sunday, September 01, 2002, 9:23:38 PM, you wrote: SB The instructions that I have to install MySQL, tells me to cd to the bin SB directory and run this command: ./mysql_install_db SB The problem is that my system can't find this file. Any suggestions? Scott, you provided not enough

build under Win32

2002-09-02 Thread Nick Kostirya
Hi, All. I cannot build mysql mysql-3.23.52-win-src.zip (and mysql-3.23.51-win-src.zip, and mysql-max-4.0.1-alpha-win.zip). Error arise when I build string.lib. Configuration: strings - Win32 Debug Performing Custom Build Step on .\Strxmov.asm '

Euro sign mysql

2002-09-02 Thread Derk van der Harst
Hello everyone, how can I insert records with the Euro sign into the mysql database? When i try to insert the euro sign i get the err message 'query is empty'. Can somebody help? thanks Derk - Before posting, please check:

RE: sysdate or curdate as default date in mysql

2002-09-02 Thread Mike Hillyer
If what you are looking for is the current date to be used as date of creation, then remain unchanged, you will have to specify sysdate as a value during an insert. You may benefit from the timestamp datatype, which sets itself to the current date when any DML statements (insert, update) are

Re: sysdate or curdate as default date in mysql

2002-09-02 Thread DL Neil
Dear Chugh, Can we define sysdate or curdate as default date for a column of datatype 'date' while creating a table? The question is ambiguous: - if a table is created with a column defined to be a TIMESTAMP data type, then every time a row is INSERTed or UPDATEd, the current date will be

build under Win32

2002-09-02 Thread Nick Kostirya
Hi, All. I cannot build mysql mysql-3.23.52-win-src.zip (and mysql-3.23.51-win-src.zip, and mysql-max-4.0.1-alpha-win.zip). Error arise when I build string.lib. Configuration: strings - Win32 Debug Performing Custom Build Step on .\Strxmov.asm '

Re: Maximum number of rows

2002-09-02 Thread Lukas Knecht
Shashank Tripathi wrote: Hi Lucas, | Does anyone know what the maximum number of rows a | MyISAM table can store is? We currently have a table | We're afraid there is hard, implementation imposed limit | of unsigned int (2^32) on the number of rows. Before trying My

Re: Replication

2002-09-02 Thread Ralf Narozny
Hello Mozzi wrote: Don't understand it still It doesn't give me errors in logfile orf when I type show server stutus. Yet it isn't replicating !! Any ideas ? I even tryed checking file sizes between servers on the .MYD file and it isn't working 1. On the server do a: mysqlbinlog

Re: Bug ?

2002-09-02 Thread Mark Matthews
Marian wrote: Why mysql corrupt tables if filesystem if full ... ? On good database servers (eg. PROGRESS) process shutdown server (protetcting data). sytem: linux-2.2.19 mysql-3.23-38 - Before

Re: build under Win32

2002-09-02 Thread Gelu Gogancea
Hi, This error occur because you don't have in your computer ml.exe. For this you must install MASM32 or NT DDK. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED]

.MYD/.MYI file formats

2002-09-02 Thread Rolf Howarth
Are the MySQL MYD/MYI file formats documented anywhere? Are they any utilities that will dump these out for debug purposes? -Rolf -- Rolf Howarth, Square Box Systems Ltd, Stratford-upon-Avon UK. - Before posting, please

Re: Euro sign mysql

2002-09-02 Thread Tod Harter
On Monday 02 September 2002 09:27 am, Derk van der Harst wrote: Hello everyone, how can I insert records with the Euro sign into the mysql database? When i try to insert the euro sign i get the err message 'query is empty'. Can somebody help? thanks Derk What happens if you escape the

Re: Bug ?

2002-09-02 Thread andy thomas
On Mon, 2 Sep 2002, Marian wrote: Why mysql corrupt tables if filesystem if full ... ? On good database servers (eg. PROGRESS) process shutdown server (protetcting data). sytem: linux-2.2.19 mysql-3.23-38 Good sys admins don't let filesystems become full Andy

Just being prudent - upgrade MySql v3.23 to v4.0.2

2002-09-02 Thread Chuck Amadi
Still haven't recieved a simple answer when i unzip the mysql-4.0.2-alpha-win.zip Do i simply extract into C:\mysql Folder and override everthing . as i have working db's so i just would like confirmation prior to proceeding. The MySql Doc's don't clarify this I assume you do but i thought

Just Prudent Dumb

2002-09-02 Thread Chuck Amadi
Hi Sorry but i nedd to be spoon fed can i just unzip the MySql-4.0.2-alpha-win.zip into my C:\mysql folder to upgrade and confirm Yes to All at the prompt as i don't want to loose any Projects that are currently in MySql v3.2.3. Sorry 4 sounding dumb but i feel abit queesey prior upgrade I

ERROR 2004

2002-09-02 Thread guilherme.afm
I downloaded mysql, i am not sure about the version, number but i think is the last stable version. And i use it under Win98. when i type: mysql -u root to try to login for the first time, i get the following error message: ERROR 2004: Can´t create TCP/IP socket (10047) I did the same thing

Viewing TIME columns from Access 2000

2002-09-02 Thread David Wardle
I am trying to link to a MySQL table from MS Access 2000. All columns are OK apart from the TIME column which is displayed as a varying date and a fixed time e.g. 27/02/2001 23:51:12 and 30/12/2002 23:51:12. Also the the TIME field for the first record is empty the rest are not. Any ideas?

Re: Help! Recovering corrupt table

2002-09-02 Thread Victoria Reznichenko
Rolf, Monday, September 02, 2002, 3:38:06 PM, you wrote: RH I'm using MySQL 3.23.51. I have a table which started giving 127 errors. [skip] RH It recovers my table but I end up with only 1030 out of 27497 rows, RH so that's not a log of help! RH Running myisamchk -r -e gives a similar result

Re: sysdate or curdate as default date in mysql

2002-09-02 Thread Egor Egorov
Chugh, Monday, September 02, 2002, 3:41:27 PM, you wrote: CS Can we define sysdate or curdate as default date for a column of CS datatype 'date' while creating a table? You can't define result of function as a default value. Take a look at TIMESTAMP column type:

Re: Re: MySQL 4.0.2, 4.0.3 replication circle broken.

2002-09-02 Thread Victoria Reznichenko
Artem, Monday, September 02, 2002, 12:44:30 PM, you wrote: AVR Thursday, August 15, 2002, you wrote: AVR In case of repliacation circle (A-B-A) query 'flush log' on any of AVR this servers create endless loop, with creating new binary log file AVR on each iteration. (about 30 new files

Re: Bug ?

2002-09-02 Thread Gelu Gogancea
On good database servers (eg. PROGRESS) It's unjust to make this comparison For example, you can not compare what you don't know about one RDBMS(doesn't matter if is MySQL or not) with other RDBMS which is familiar for you. Regards, Gelu _

RE: Inno DB Question

2002-09-02 Thread Javier Diaz
Hi Tod, thanks for your answer. I changed the code to this Q-SQL-Clear(); Q-SQL-Add(SET AUTOCOMMIT=0); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(BEGIN); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(INSERT INTO regn_info VALUES('t1','test1')); Q-ExecSQL(); Q-SQL-Clear(); Q-SQL-Add(INSERT INTO regn_info

Maximum number of tables

2002-09-02 Thread JSL
Subject: Maximum number of tables Does anyone know what the maximum number of tables a INNODB can store is? Thanks, José Lourenço - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Another bug with create table ... select ... and control flow functions

2002-09-02 Thread Maurizio Danilo
Another bug with create table ... select ... statement and control flow functions: see Threads for July 2002. This bug affects Version 4.0.3 (I have experienced it with LinuxRH7.3, Windows NT SP6, Windows 2000 SP2). Try this: create table ciccio select if('2002'='2002','Y','N') select * from

RE: Just being prudent - upgrade MySql v3.23 to v4.0.2

2002-09-02 Thread Sqlcoders.com Programming Dept
Please see http://www.mysql.com/downloads/mysql-4.0.html, specifically the link for You can find how to upgrade from MySQL 3.23 Here (http://www.mysql.com/doc/en/Upgrading-from-3.23.html) ... In general what you have to do when upgrading to 4.0 from an earlier MySQL version: Run the

Re: build under Win32

2002-09-02 Thread Miguel Angel Solórzano
At 16:14 02/09/02 +0300, Nick Kostirya wrote: Hi, Hi, All. I cannot build mysql mysql-3.23.52-win-src.zip (and mysql-3.23.51-win-src.zip, and mysql-max-4.0.1-alpha-win.zip). Error arise when I build string.lib. Please read the instructions at (you need the assembler compiler):

Re: select using 2 left joins

2002-09-02 Thread Jed Verity
I'm a little surprised that MySQL isn't giving you an error on the ambiguity of manufacturersID=12. What happens if you specify tableName.manufacturersID=12? HTH, Jed On the threshold of genius, Wilbert Enserink wrote: Hi all, I'm having troubles with a good selection statement in my

RE: Just Prudent Dumb

2002-09-02 Thread UserFor5714
Chuck Amadi [EMAIL PROTECTED] wrote: Hi Sorry but i nedd to be spoon fed  can i just unzip the MySql-4.0.2-alpha-win.zip into my C:\mysql folder to upgrade and confirm Yes to All at the prompt as i don't want to loose any Projects that are currently in MySql v3.2.3. Sorry 4 sounding dumb but

Re: ERROR 2004

2002-09-02 Thread Marek Kilimajer
You don't have TCP/IP networking installed on your computer. guilherme.afm wrote: I downloaded mysql, i am not sure about the version, number but i think is the last stable version. And i use it under Win98. when i type: mysql -u root to try to login for the first time, i get the following

Re: 3.23.52 hitting system loads of 25+?

2002-09-02 Thread Jeremy Zawodny
On Mon, Sep 02, 2002 at 03:35:28AM -0700, John Stanforth wrote: Jeremy and Michael, What compiler versions are you using? (just the gcc -v) I'm wondering especially since MySQL has a warning posted about gcc 2.96 with 2.4 kernels. gcc version 2.95.4 20011002 (Debian prerelease) Which

Re: ERROR 2004

2002-09-02 Thread Gerald R. Jensen
Sounds like TCP/IP is not running on your machine. - Original Message - From: guilherme.afm [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 02, 2002 10:45 AM Subject: ERROR 2004 I downloaded mysql, i am not sure about the version, number but i think is the last stable

Install questions

2002-09-02 Thread Matt \TrollBoy\ Wiseman
I just installed MySQL from RPM and can connect to it via shell using the MySQL command, but I can't get anything else to connect to it. MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) Thoughts? Matt Wiseman

Re: Inno DB Question

2002-09-02 Thread Heikki Tuuri
Javier, it may be that the dbExpress interface is still lagging behind MySQL development. If I recall right, people have complained loudly in Borland newsgroups that dbExpress created a new connection for each SQL query it issues to MySQL. That makes the use of transactions impossible with it.

RE: query crashes 4.03 every time

2002-09-02 Thread Matthew Mullenweg
| May be I'm blind, :-) but you provided dump of another table than you used | in the query. What is the structure of table 'b2posts'? You're right, here it is: CREATE TABLE b2posts ( ID int(10) unsigned NOT NULL auto_increment, post_author int(4) NOT NULL default '0', post_date datetime

Maximum number of tables

2002-09-02 Thread JSL
- Original Message - From: JSL [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 02, 2002 5:05 PM Subject: Maximum number of tables Subject: Maximum number of tables Does anyone know what the maximum number of tables a INNODB can store is? Thanks, José

stored procedures and triggers

2002-09-02 Thread Marcelo Miorelli - ProCAD
Hello list, Here in my company people are concerned about which database to choose to start implementing a new application client-server. As the only person here with large experience in this field of activity is me, I am not very much inclined to our mysql due to its lack of resources like

RE: Just Prudent Dumb

2002-09-02 Thread Paul DuBois
At 12:39 -0400 9/2/02, [EMAIL PROTECTED] wrote: Chuck Amadi [EMAIL PROTECTED] wrote: Hi Sorry but i nedd to be spoon fed Ýcan i just unzip the MySql-4.0.2-alpha-win.zip into my C:\mysql folder to upgrade and confirm Yes to All at the prompt as i don't want to loose any Projects that are

Re: MyISAM and Lock table question

2002-09-02 Thread Paul DuBois
At 14:41 +0200 9/2/02, David Bordas wrote: Hi all, Just a little question on the MyISAM table lock implementation ... I just see ( with show full processlist ) that my version of mysql ( 3.23.45 binary linux tar.gz ) locked my MyISAM table at every query and not only for update / delete /

RE: Just being prudent - upgrade MySql v3.23 to v4.0.2

2002-09-02 Thread Paul DuBois
At 10:20 -0700 9/2/02, Sqlcoders.com Programming Dept wrote: Please see http://www.mysql.com/downloads/mysql-4.0.html, specifically the link for You can find how to upgrade from MySQL 3.23 Here (http://www.mysql.com/doc/en/Upgrading-from-3.23.html) ... In general what you have to do when

SQL JOIN query problem

2002-09-02 Thread Christian Rytter
Hello, Im not sure that im sending this mail to the correct people, but Im really desperate right now. I have a problem with a SELECT JOIN query. I have two tables, one which contains Articles, and one which contains ArticleUpdates. What I would like to do, is to have a report of Articles,

mysock.sql problem

2002-09-02 Thread Defryn, Guy
I have installed mysql from the ports collection on FreeBSD and it was working fine. I would like to move the /tmp/mysql.sock file ( or is it safe to leave it there?) so I Created a my.cnf file with the following options [mysqld] port=3306 socket=/usr/local/mysql/mysql.sock I take down the

Crash when adding field

2002-09-02 Thread Matt Parlane
Hi all... MySQL version 4.0.3-beta Compaq Deskpro PIII 933MHz 256MB RAM, 92MB SWAP Binary distribution uname -a Linux homer 2.4.19 #2 Thu Aug 15 19:53:55 NZST 2002 i686 unknown I don't have another test machine unfortunately, so I don't know if the problem is specific to my machine/database or

Re: Help! Recovering corrupt table

2002-09-02 Thread Rolf Howarth
RH I'm using MySQL 3.23.51. I have a table which started giving 127 errors. [skip] RH It recovers my table but I end up with only 1030 out of 27497 rows, RH so that's not a log of help! RH Running myisamchk -r -e gives a similar result (only 1030 rows are RH recovered), as does truncating the

Trying to get openssl working with MySQL 4.0.3-beta

2002-09-02 Thread Matthew Scarrow
According to the documentation under section 4.3.9 to get openssl working with mysql you need to configure mysql with the --with-vio --with-openssl. When I add the as arguments to ./configure and then compile it I get a mysqld that will run but try to do anything with it and the client

Re: mysock.sql problem

2002-09-02 Thread Paul DuBois
At 9:09 +1200 9/3/02, Defryn, Guy wrote: I have installed mysql from the ports collection on FreeBSD and it was working fine. I would like to move the /tmp/mysql.sock file ( or is it safe to leave it there?) so I Created a my.cnf file with the following options [mysqld] port=3306

primary/foreign key contraints

2002-09-02 Thread neal
Sorry for the MySQL newbie question ... but are there not primary/foreign key constraints in MySQL 3? I can't imagine that this is right. Perhaps I'm just overlooking something Thanks. Neal - Before posting, please

secure mySQL connection

2002-09-02 Thread Ben Joyce
Hi. I'm connecting to a remote mySQL server via myODBC from a VB application. Is this connection secure? If not, how can I make it so? Would I have to encrypt the data myself somehow or is there some sort of secure connex like SSL for port 80? Any help appreciated. Cheers, .ben -- ben

Re: Help! Recovering corrupt table

2002-09-02 Thread Paul DuBois
At 23:57 +0100 9/2/02, Rolf Howarth wrote: RH I'm using MySQL 3.23.51. I have a table which started giving 127 errors. [skip] RH It recovers my table but I end up with only 1030 out of 27497 rows, RH so that's not a log of help! RH Running myisamchk -r -e gives a similar result (only 1030 rows

Re: stored procedures and triggers

2002-09-02 Thread yvictorovich
I would like to see the triggers/stored procedures/views in MySQL also. And the only estimate I saw somewhere was around version 5.0. But think about this this way: in the complex enterprise-level system you would probably need some kind of application server instead of direct client-db access.

can't start daemon after reboot (after initial install)

2002-09-02 Thread Bill Feiereisen
Help?, I installed 3.23.52 on a RedHat 7.3 machine. Everything was just fine until I rebooted later for another reason. Now I can't start the daemon. I tried deleting /var/lib/mysql/mysql.sock as root. It deleted, but to no avail. Any idea what I have done wrong? I don't understand sockets.

do i must use mysql_free_result()?

2002-09-02 Thread Dizzy Myope
hi all:) int main(void) { . rs=mysql_store_result(connection);//get result to rs .. mysql_free_result(rs);// it is necessary ??? rs=mysql_store_result(connection);// get result to rs again. } i

RE: sysdate or curdate as default date in mysql

2002-09-02 Thread Chugh Shalini
Thankx for the reply Egorov,Hillyer and Neil. Timestamp has solved my purpose. Actually we are porting an application from oracle to mysql. In Oracle there were some tables which were using sysdate as default date, therefore we wanted something similar functionality, as it was very difficult to

Remove David.French@homebs.com.au from your mailing list as he is no longer with the company

2002-09-02 Thread Niki Crook
Niki Crook Technical Consultant For Home Building Society (08) 9323-5583 [EMAIL PROTECTED] ASG Limited and ASG (Asia Pacific) Pty Ltd -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, MySQL 4.0.3-beta, the world's most popular Open Source Database, has been released and is now

Error Solution Request

2002-09-02 Thread JAYA KUMAR
Sir, We used the following code for connecting Visual Basic 6.0 with MySql = 3.23.41 . Mysql was running in Linux Red Hat server 7.2 The VB application was in Window NT node The provider used was “MySQLProv” The code is Option explicit

SELECT DISTINCT w/LEFT JOIN segfault in 4.0.3

2002-09-02 Thread User Toasty
Description: A specific query in the format of: SELECT DISTINCT a.*, b.* FROM privatemessage LEFT JOIN b ON (b.x = a.y); Is causing a segfault. This worked fine in the 3.23 series. How-To-Repeat: DROP TABLE IF EXISTS privatemessage; CREATE TABLE privatemessage ( privatemessageid int(10)

MySQL Query

2002-09-02 Thread abhilas
Hi, My intention is to get the datedifference(in no of days) between the current date and a previously entered date which is in a table(of course this date is lower in value than the current date).When I used this query: select FROM_DAYS(TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30'));

Re: MySQL Query

2002-09-02 Thread Jed Verity
Hello, Abhilash, If you just want the number of days between two dates, you don't need FROM_DAYS. FROM_DAYS gives you a date. This should be all you need: Select TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30'); HTH, Jed On the threshold of genius, [EMAIL PROTECTED] wrote: Hi, My intention is