MySQL connect problem

2002-10-18 Thread Dishko Georgiev
Hi, 1 day ago i haved power fail on my MySQL server version 2.23.41 (original RedHat distr.) Now i can connect to server only on local interface, no network connection allowed. When tying to connect to server with mysql client i recieve this msg: ERROR 2013: Lost connection to MySQL server during

RE: about use Dev-cpp and C++

2002-10-18 Thread wang tianyi
what's nested SQL? can you tell me more about it? if i want to use STL and DEv-CPP , do you know how to do it ? thanks. Look for MyC on mysql.com - if you can't find it, email me directly. The most recent version supports nested SQL, too. The Escapade server-side programming language is

SV: mysqld crashes on Redhat 8.0 when connecting to non-localhost

2002-10-18 Thread nicklas
Release: mysql-3.23.52 (Source distribution) Update to 3.23.53a! That solved my problems. /Nicklas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: about use Dev-cpp and C++

2002-10-18 Thread wang tianyi
very thank you !:) if i have more question will ask you again. thank you again! Subject:RE: about use Dev-cpp and C++ what's nested SQL? can you tell me more about it? Nested SQL allows you to do all kinds of interesting things in MySQL that you can't do now - sub-selects, for

character set when you don't manage the server

2002-10-18 Thread Nikolas Galanis
Hi I have written a web application that is hosted in a server which uses the default character set. This causes problems in the sorting that MySQL does because most of the data is in Greek. When developing it locally, I run the MySQL server with the greek character set and sorting works

replication-reset master logs

2002-10-18 Thread Okan CIMEN
Hi there, I am working on the replication feature of MySQL. I am managed to replicate the servers(both versions are 3.23.52 on Win 2K). Ay yhe my.ini file, the bin-log files are declared as log-bin=c:\mysql\log_files.bin and as I FLUSH LOGS the new log file's name is increased by 1, like

mySQL vs. Oracle

2002-10-18 Thread Sam Bauer
Mike, A lot of my Oracle / MySQL questions got answered by searching the archives at http:// lists.mysql.com/php/search.php for Oracle (so many!) or Oracle ... e.g Oracle Backup etc. Thanks, Sam Bauer, Oracle DBA - Before

Invalid authorization specification

2002-10-18 Thread Kevin Stoll
** Reply Requested When Convenient ** This is probably a permissions issue but I can't seem to iron out the problem here. I am trying to connect to the datasource I have set-up for a MySQL database. When I boot JBOSS up I can't seem to get MySQL to authorize the user that I have created. The

RE: input data which table first

2002-10-18 Thread David Shanes
Well, if you want your main table to have foreign keys into the tables that maintain your other data (Studios, Genres, Actors, etc) then you need to populate your other tables first. You will be referring to those tables when you perform your inserts into your main table to gain access to the

RE: about use Dev-cpp and C++

2002-10-18 Thread Ed Carp
what's nested SQL? can you tell me more about it? Nested SQL allows you to do all kinds of interesting things in MySQL that you can't do now - sub-selects, for example; or if you're a lazy programmer (like me!) you want to do grouping and sorting in ways that would be difficult (and

mySQL vs. Oracle

2002-10-18 Thread mleary
We are looking to move to a mySQL db for an application that will possibly process 100's of millions of rows a day and are looking to do it cheaper than an oracle solution. I am new to the mySQL arena and am interested in the groups experience in what mySQL does not do (especially related to

Re: mysql 4.04beta

2002-10-18 Thread Yoann
I haven't a directory called data in the mysql directory and I never specified where mysql have to put the database. I try to find where mysql is supposed to get the mysql.host and the database but i don't find it yet So in which file I can't get this information ? thanks yoann Andrew

unprivileged user can create a database

2002-10-18 Thread Max Kalika
Here is a (stripped) list of steps needed to recreate this problem. --- # mysql -u root -p .. mysql CREATE DATABASE `user_db`; Query OK, 1 row affected (0.00 sec) mysql USE mysql; Reading table information for completion

RE: password

2002-10-18 Thread Andrew Braithwaite
Ed, I feel that your response to this problem is not in the spirit of the open source world (more like the RTFM response that you would get from a support desk). We should be encouraging new users with replies like: Yes - this is quite a common problem with new installs - you could try x, y or

Re: MySQL processes..

2002-10-18 Thread Niclas Hedhman
On Thursday 17 October 2002 19:33, Sandeep Murphy wrote: Our JSP application has connections to both Oracle and MySQL... In each page there are nearly a dozen queries executing on a MySQL db. at the begining of each page, a connection is opened and at the end they are close.. Ideally, if the

problem with mysqlimport

2002-10-18 Thread Julia Maddocks
I'm trying to import an access database table into MySQL This is what I've done: created a database testdb in access with a table cop exported the table as comma separated values into cop.txt created a database called testdb in mysql, created a table called cop of the same structure as the

Re: mysql 4.04beta

2002-10-18 Thread Yoann
ok thanks, in fact I did : cd /usr/local/mysql chown -R mysql.mysql * ./bin/musql_install_db chown -R root /usr/local/mysql chown -R mysql /usr/local/mysql/data chgrp -R mysql /usr/local/mysql chown -R root /usr/local/mysql/bin encore merci ;p yoann Andrew Braithwaite a écrit: You need a data

mysql 4.04beta

2002-10-18 Thread Yoann
hi all, I just finished to compile mysql 4.04 beta but when I start mysqld I have this error # mysqld -u mysql [1] 19034 22:10:55 babar:/usr/web/mysql# 021017 22:10:55 InnoDB: Out of memory in additional memory pool. InnoDB: InnoDB will start allocating memory from the OS. InnoDB: You may get

RE: Updated MySQL 3.23.53a binaries now available

2002-10-18 Thread Kees Hoekzema
Load issue resolved. Whew! Looking forward to 4.0.5 with the same fix. Such a relief! Thanks for all the work to resolve this! Als here the loadissues have been resolved, I had to run .49a and had to miss a couple of innodb features for it, but finnaly .53 works again as stable as .49 has been

Can Run On Embed System?

2002-10-18 Thread
Dear friend: Can the mysql run on a embed system that like MOTOROLA MC68EZ328 and PPSM OS or WinCE ? [EMAIL PROTECTED] 2002-10-18 - Before posting, please check:

Sort aborted

2002-10-18 Thread Silmara
I converted one table from Paradox to Mysql with 532.458 registers. After that I try converted more 473.493, but i recept this error: Key Violation. [MyODBC][ODBC 3.51 Driver] [mysqld-3.23.39-max-nt] Sort Aborted My table: Create table FichaFin FinID MEDIUMINT NOT NULL AUTO_INCREMENT,

JDBC problems

2002-10-18 Thread Lee Denny
I'm trying to use the mm.mysql JDBC drivers on windows NT I've just downloaded the mysql-connector-java-2.0.14.zip file and extracted it into my jdk1.2.2/jre/lib/ext folder. I try to connect with import java.sql.*; public class dbconnect { public static void main(String[] args) { String

Security

2002-10-18 Thread Terry Cheryl Haimann
I was reading a book at BN yesterday which left me with the impression that in MySQL you can do the following: Define a group with specific security access. Then define a list of users that inherit this groups security settings. Is this correct? If so, will this work under the Windows

rpm -i MySQL: exist or not?

2002-10-18 Thread Jack Chen
The strange thing I met with is that when I ran rpm -e XXX.rpm It said that the package in not installed. But when I ran rpm -i XXX.rpm It said that the package already exist. I am new to MySQL. Any idea is greatly appreciated. Jack Jack

mysqld crashes on Redhat 8.0 when connecting to non-localhost

2002-10-18 Thread peter
Description: On Redhat 8.0 all attempts to connect through a non-local socket result in the mysqld crashing. For example: telnet host 3306 Results in the mysql log: Number of processes running now: 1 mysqld process hanging, pid 11473 - killed

enable innodb

2002-10-18 Thread Douglas
I'm trying to enable innodb , I installed mysql-3.23.52 from the ports collection I cp my-medium-.cnf my.cnf then mv my.cnf to /etc I uncommented the innodb lines and created ibdata1 directory in the data directory (/var/db/mysql) I stopped mysqld now it refuses to restart unless I remove

Suggestions for breaking large table into smaller?

2002-10-18 Thread James Taylor
Curious if this is normal behaviour, or if my table is just not put together very well. I have a table consisting of approximately 4.5 million contacts, listed by company name/city/state/zip - The system this is running on is a PowerEdge 1400sc, 1ghz p3, 1 gig ram, 18gb scsi drive. These are the

mysql user permission when using raw device instead datafile

2002-10-18 Thread Chung Ha-nyung
Dear After I had mysql use raw device with innodb instead datafile, I started mysql and got an error like following; 021018 14:11:18 mysqld started 021018 14:11:19 InnoDB: Operating system error number 13 in a file operation. InnoDB: See http://www.innodb.com/ibman.html for installation help.

BugReport MySQL

2002-10-18 Thread T.Breunig Topwerbung
Sorry: Was to dull to use the bugscript - did not know how to use emacs to send it; anyway here it is: [maclef:/usr/local/mysql] maclef# ./bin/mysqlbug Finding system information for a MySQL bug report test -x /usr/bin/emacs Using editor /usr/bin/emacs You can change editor by setting the

Re: JDBC problems

2002-10-18 Thread Max Morawski
mysql,query Lee Denny wrote: I'm trying to use the mm.mysql JDBC drivers on windows NT I've just downloaded the mysql-connector-java-2.0.14.zip file and extracted it into my jdk1.2.2/jre/lib/ext folder. You need to put .jar file (ie. mysql-connector-java-x.x.x-beta-bin.jar) into

RE: mysql 4.04beta

2002-10-18 Thread Andrew Braithwaite
You need a data directory in the mysql directory. Did you run the install script? The install script is at: scripts/mysql_install_db For a normal linux/unix install you need to do the following --- cd /usr/local/mysql/ groupadd mysql useradd -g mysql

RE: Connecting to MySQL on Linux from a Windows machine.

2002-10-18 Thread Randy Witt
Will, Do you have a user/host pair for the client in the user table within the mysql database?? It's not good enough just to have a user, the host has to be setup too. I cannot connect from my Windows machine to the MySQL database running on the Linux server. I have tried several different

/tmp/mysql.sock

2002-10-18 Thread Douglas
Using FreeBSD-4.6.2---MySQL-3.23.53 I copied my.cnf to /etc and /var/db/mysql and made a file mysql.sock in tmp (/tmp/mysql.sock) What do I put in mysql.sock? At present I'm getting: Cannot connect to local MySQL Server thought socket '/tmp/mysql.sock' (2) Thank You, Douglas V.

Queries with mysql

2002-10-18 Thread Carlo Sigalotti
I have two tables in a mysql db: |+| |games |3 | |+| |eat

Re: What about 3.23.53a max for windows ?

2002-10-18 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 17 October 2002 12:23, Ireneusz Piasecki wrote: When will version 3.23.53a for windows users ? I downloaded version 3.23.53 but in zip package were mysql version 3.23.52. (innodb not working in this wersion on win98). What about this

[No mysqladmin was installed]

2002-10-18 Thread squeeb
Description: No mysqladmin was installed with the rpm. so I can't change the password. How-To-Repeat: :/ Fix: Submitter-Id: submitter ID Originator:root Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis:

RE: loggin all calls made to mysql from php

2002-10-18 Thread Chung Ha-nyung
Use --log-slow-queries[=filename] option. It will log all queries which take more than long_query_time Default value of it is 10 sec and you can ascertain it by show variable like 'long_query_time' query and set in my.cnf as long_query_time = value I think you'd better refer to the MySQL's

RE: when will 3.23.53a be released?

2002-10-18 Thread Kees Hoekzema
it is released. at least; it can be found on ftp.sunsite.dk -kees -Original Message- From: Victoria Reznichenko [mailto:victoria.reznichenko;ensita.net] Sent: Thursday, October 17, 2002 11:44 AM To: [EMAIL PROTECTED] Subject: re: when will 3.23.53a be released? Lars,

Re: Help Migrating from NuSphere

2002-10-18 Thread Lenz Grimmer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wednesday 16 October 2002 20:50, Mark Graves wrote: Previously I had been a NuSphere subscriber for MySQL (and PHP and Apache). As you probably know, NuSphere no longer produces or supports the MySQL product. How do I migrate out of the

Connecting to MySQL on Linux from a Windows machine.

2002-10-18 Thread Will Merrell
I cannot connect from my Windows machine to the MySQL database running on the Linux server. I have tried several different programs and they all report an error that says Lost connection to MySQL server during connection. I have read all the articles I can find and searched the archives as well

Re: Stored Proc

2002-10-18 Thread Richard Clarke
I believe your only choice is to move this stored procedure into client side routines. Ric - Original Message - From: Pradana [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Thursday, October 17, 2002 8:37 PM Subject: Stored Proc OK, MySQL does not support the Stored Procedure

Re: mytop - DBD::mysql failed to load

2002-10-18 Thread Jeremy Zawodny
On Wed, Oct 09, 2002 at 10:18:48AM +0200, Koller Sébastien wrote: Hi, I try to install mytop in order to get some information about my MySQL database, after I installed : - DBI-1.18.tar.gz - Msql-Mysql-modules-1.2216.tar.gz - Data-Dumper-2.101.tar.gz - Data-ShowTable-3.3.tar.gz

Re: MySQL processes..

2002-10-18 Thread Mark Matthews
Sandeep Murphy wrote: hi, I have a problem with the connections and would appreicate a lot if anyone can provide a soln.. Our JSP application has connections to both Oracle and MySQL... In each page there are nearly a dozen queries executing on a MySQL db. at the begining of each page, a

input data which table first

2002-10-18 Thread John Chang
SQL, Does it matter which table I enter data into first? Or do I need to first put in the data into Studios, Genres, Actors, Stars first before adding to Titles and TitleGenres since they use the IDs of the other table? Or should I convert it to type innodb and make the IDs foreign keys in

Re: Connecting to MySQL on Linux from a Windows machine.

2002-10-18 Thread Olaf van Zandwijk
Hi, It seems to me that you can't connect to MySQL from an other machine at all. Did you start MySQL with the --skip-networking option? Try removing that option from the start-up scripts. \Olaf Will Merrell wrote: I cannot connect from my Windows machine to the MySQL database running on the

Can't upgrade: Can't change to run as user 'mysql'

2002-10-18 Thread r . helfenberger
I have exactly the same problem, with version 3.23.53a. I ask myself if the problem is related with this binary distribution? If I install the rpm from the same version, there is no problem to run mysql. I just don't like the layout of the directories, therfore I would like to install the

Re: about use Dev-cpp and C++

2002-10-18 Thread wang tianyi
do you know how use STL with dev-cpp? thanks But it would be so nice to write: MySQLConn DB = new MySQLConn ('host', 'port'); DB.Login('user', 'pass'); MySQLTransaction X = new MySQLQuery(DB); // STL-derived slist: MySQLResults Results = X.Query(...); // STL map: map Row; while

Mysql Blob type

2002-10-18 Thread Mario Nicoletti
How I treat, the Mysql Blob type when I do a INSERT/SELECT query ( OS Linux RedHat 7.3)? Does anyone know a solution ? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Stored Proc

2002-10-18 Thread Pradana
OK, MySQL does not support the Stored Procedure ... yet. So how do I convert the following SQL as a Stored Proc into MySQL ? Assume I have the following Stored Proc : -- Start snippet CREATE PROCEDURE aTest AS BEGIN -- Select some columns from table and table b, -- then put them into a temp

RE: Date Woes

2002-10-18 Thread Iain Lang
. Could we see this php routine, please? Or can you post it to a newsgroup? Yooors, Iain Lang. At 18:23 15/10/02 -0400, Serge Paquin wrote: I have written a very poor and inflexable PHP function to do this outside the database. I have not played with doing my own functions in mySQL but your

Re: MySQL connect problem

2002-10-18 Thread gerald_clark
Your glibc update broke MySQL. It was probably already loaded when you started the update. Get the latest pre-compiled version ( 2.23.53a) I believe from mysql.com. You need the latest version with the a. Dishko Georgiev wrote: Hi, 1 day ago i haved power fail on my MySQL server version

Urgent Help needed

2002-10-18 Thread manuvi
Hi all, I have used the following script to connect our remote database from my local machine. The PHP script is at my local machine. When I tried to connect the database, instead of connecting to the IP provided in the script, it is searching the Dynamic IP of my Internet Service Provider.

Re: RE: permissions mysql.user

2002-10-18 Thread Victoria Reznichenko
Hello Gavin, Thursday, October 17, 2002, 3:40:11 PM, you wrote: GL Thanks for your reply Victoria . You're welcome. GL How is the best way to reconstruct this table? Add users again. Or what you mean reconstruct? GL What I wish to do is add users, I can read the sytax which gives me the GL

re: Truncation problem or bug in 4.0.4-beta (linux)

2002-10-18 Thread Victoria Reznichenko
Salam, Thursday, October 17, 2002, 1:04:44 PM, you wrote: SBS I need un explanation to the following, or it is a bug which needs a SBS fix. SBS mysql select ti from article where match (ti) against ('computer SBS science' in boolean mode) ; SBS . SBS 21 rows in set (0.07 sec) SBS Now

synopsis of the problem (one line)

2002-10-18 Thread root
Description: MySQL segfaults after recieving TCP/IP connections. Connections to the local socket work great. How-To-Repeat: Connect via TCP/IP Fix: Unknown Submitter-Id: submitter ID Originator:root Organization: Critical Distinction, Inc. MySQL support: [none | licence | email support |

slow query...

2002-10-18 Thread Corin Langosch
Hi, i have the following problem. I have a table wherey to_id and owner_id are of type unsigned int not null and both are normal indexes. Unluckily a query like: -- EXPLAIN SELECT * FROM `telegramme` WHERE to_id = 3157 or owner_id = 3157 -- returns very bad results: -- table type

RE: Date Woes

2002-10-18 Thread Brent Macnaughton
PHP already has a function that will convert a textual date into a unix timestamp. - strtotime (3.0.12 - 3.0.18 only, PHP 4 = 4.0.0) strtotime -- Parse about any English textual datetime description into a UNIX timestamp Description int strtotime (string

Re: mysqld crashes on Redhat 8.0 when connecting to non-localhost

2002-10-18 Thread Alex Ostapov
[EMAIL PROTECTED] wrote: Description: On Redhat 8.0 all attempts to connect through a non-local socket result in the mysqld crashing. For example: telnet host 3306 Results in the mysql log: Number of processes running now: 1 mysqld process hanging, pid 11473 - killed

Error creating an udf

2002-10-18 Thread Karel Antonio Verdecia Ortiz
I read the indications in the MySQL manual about how to create an user defineable function and I implemented a dll (I am working in win2000). When I try to execute the query: CREATE FUNCTION cuadrado RETURNS REAL SONAME 'cuadrado.dll' it shows the message: 1105 - Unknown error I am working

RE: Urgent Help needed

2002-10-18 Thread Simon Green
It looks like you have a dynamic IP your end and the mysql server is looking for a fixed IP. Try name based DNS form your PC. Simon -Original Message- From: [EMAIL PROTECTED] [mailto:manuvi;eth.net] Sent: 18 October 2002 09:38 To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Urgent

Re: Security

2002-10-18 Thread Insanely Great
I belive it will work in Windows Insane - Original Message - From: Terry Cheryl Haimann [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 17, 2002 4:24 PM Subject: Security I was reading a book at BN yesterday which left me with the impression that in MySQL you can do

Re: Sub selects

2002-10-18 Thread Aurelio A.
// This is a generic function which returns the results // of a query in list form, so they can be used in place // of nested queries until it is implemented in MySQL // If there are no values, it returns the string // Empty Nested Set by default. function getnestedvals($field, $table,

Re: JDBC problems

2002-10-18 Thread Niclas Hedhman
Expanding the zip into the lib/ext/ is perhaps not the best idea. Expand it elsewhere, and copy the JAR file to the lib/ext/ folder. Also, you don't need to make an instance of the Driver. The static initializer will register the class with the DriverManager. Niclas On Thursday 17 October

Truncation problem or bug in 4.0.4-beta (linux)

2002-10-18 Thread Salam Baker Shanawa
Hello, I need un explanation to the following, or it is a bug which needs a fix. mysql select ti from article where match (ti) against ('computer science' in boolean mode) ; . 21 rows in set (0.07 sec) Now using the truncation operator * mysql select ti from article where match (ti)

MySQL v3.23.53 segfaults on TCP/IP connection

2002-10-18 Thread Aaron Paetznick
I have a more-or-less stock Red Hat 7.3 machine that I have running MySQL v3.23.53 built from source. Local socket connections work great, but it segfaults when it receives a remote connection. Here is the error: [root@host src]# /usr/local/mysql/bin/safe_mysqld: line 273: 30534

MySQL, Dreamweaver MX, PHP

2002-10-18 Thread John Chang
What I am trying to do is on the first webpage. There is a Studio dropdown (information from the MySQL database) menu. When someone picks a studio the results go to a different webpage showing just the movies in that studio. How do I get the results onto the second page? How can I do it in

password

2002-10-18 Thread Marc Dirix
Hi there Problem: I've got two debian linux pc's One is my server on which I would like to install te mysql server, one is my workstation. First trying to install the mysql server on my server I seem to have done something wrong. With installation I had no problems (standard .deb installtion)

RE: mysql 4.04beta

2002-10-18 Thread Andrew Braithwaite
Hi, If I had to guess - I would say that you do not have permissions for the datadir. Try the following: Chown -R mysql:root /usr/local/mysql/data (or wherever your datadir is) And Chmod -R 660 /usr/local/mysql/data (or wherever your datadir is) Cheers, Andrew Sql, query,

RE: password

2002-10-18 Thread Ed Carp
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' Is there an way to get out of my way? Uninstalling mysql-server and installing again didn't do the trick Look in the manual FIRST before porting, please - this is a very

About the Changelog for 4.0.3

2002-10-18 Thread Eric Frazier
Big cleanup in replication code (less logging, better error messages, etc..) I have been having periodic problems with lost connections with my 4.0.2 slave and master. No errors, other than lost connection, retrying etc. But sometimes the connection doesn't come back even though show slave

mysql-3.23.53 HPUX 11.00 fails (bombs) on BDB tests -- NO problems on 3.23.52 with identical config

2002-10-18 Thread Michael . Parker
Description: When running mysql-test sequence, two of the BDB tests cause mysql to apparently bomb -- all other tests run ok (used --force to verify) Extract of test log is: . . . backup 0.0 0.0 0.1 [ pass ] bdb-alter-table-1

mysql replication problems

2002-10-18 Thread Martina Podesser
dear everybody, I have tree linux 7.3 machines on which MySQL-3.23.51-1.i386.rpm, MySQL-client-3.23.51-1.i386.rpm and MySQL-shared-3.23.51-1.i386.rpm is installed. the intrusion detection system snort loggs to these machines. Every machine is set up the same way and contains the same table. The

memory usage

2002-10-18 Thread Francesc Guasch
I'm concerned about memory usage of mysql connections. I've been reading the mailing list archives but I'm still clueless. I need to buy a new server for a mysql database that will have at least 500 persistent connections from an Apache server with mod_perl. I'm checking the memory usage of the

RE: /tmp/mysql.sock

2002-10-18 Thread Ed Carp
I copied my.cnf to /etc and /var/db/mysql and made a file mysql.sock in tmp (/tmp/mysql.sock) What do I put in mysql.sock? Nothing. The server creates it when it starts up. Read the docs. sql, query - Before posting,

MySQL vs. several users same machine

2002-10-18 Thread Daniel M . St . Andr é
Folks, I have several independent users on one linux machine. They all want to run apps that use mySQL. All of these apps are browser driven. Is there a HOWTO for this situation? Can someone offer guidance? ~~~ Dan 0;-D Austin, TX

retyping data

2002-10-18 Thread Hasan / Impex Holidays Maldives
hi, I am using win-xp and command prompt to access mysql. I try to retype a very long insert line into the command prompt, but the command prompt would not allow me to type all my insert query. There seems to be a limit to the characters I can insert when in mysql. I can type any amount of

RE: loggin all calls made to mysql from php

2002-10-18 Thread Petre Agenbag
Thanks, I did it and it works. I just would like to know one more thing. You mention a slow log option, how do invoke that type specifically? I restarted mysql with safe_mysqld --log and it created a myserver.log file in the data directory, but it seems to log ALL queries and is growing pretty

Incorrect key file for table

2002-10-18 Thread Renato Silveira
I have this problem in MySQL select id from usuario; ERROR 1034: Incorrect key file for table: 'usuario'. Try to repair it How can I solve this problem? thks - Before posting, please check: http://www.mysql.com/manual.php

RE: MySQL processes..

2002-10-18 Thread Sandeep Murphy
Hi Mark, Yes, the code is wrapped by a try , catch, finally block but still we r facing suspended connections.. :( am using MysqlFront to administer the dbs and i can kill the suspended/delayed processes manually.. Does mysqladmin provide any other additional services?? thnx, sands

Re: What about 3.23.53a max for windows ?

2002-10-18 Thread Ireneusz Piasecki
Oh, it's my little mistake. By the way, when version *.53 for windowze users ? Regards I. piasecki - Original Message - From: Ireneusz Piasecki [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 17, 2002 12:23 PM Subject: What about 3.23.53a max for windows ? Hi. When

re: slow query...

2002-10-18 Thread Egor Egorov
Corin, Thursday, October 17, 2002, 3:09:08 PM, you wrote: CL i have the following problem. I have a table wherey to_id CL and owner_id are of type unsigned int not null and both CL are normal indexes. Unluckily a query like: CL -- CL EXPLAIN SELECT * FROM `telegramme` WHERE to_id = 3157 or

Re: Incorrect key file for table

2002-10-18 Thread Joseph Bueno
Renato Silveira wrote: I have this problem in MySQL select id from usuario; ERROR 1034: Incorrect key file for table: 'usuario'. Try to repair it How can I solve this problem? Repair it ! ;) See : http://www.mysql.com/doc/en/REPAIR_TABLE.html thks -- Joseph Bueno

re: [No mysqladmin was installed]

2002-10-18 Thread Victoria Reznichenko
squeeb, Thursday, October 17, 2002, 3:38:46 PM, you wrote: Description: saadcdu No mysqladmin was installed with the rpm. so I can't change the password. Did you installed the client package? -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email

Lost Connection

2002-10-18 Thread Deleo Paulo Ribeiro Junior
Hello! I would like to know if someone has the solution to my problem. I was using MySQL Administrator for Windows yesterday and everything was working fine (I use dBTools also). Today when I tried to access MySQL (default version for Linux 7.2) I received the message: Lost connection to MySQL

Strange problem with MySql IIS ASP

2002-10-18 Thread Morsky Juha
Hi All! I've Select like this: SELECT ExpDepDate, ActArrDate FROM oceandata It works beautifully But When I modify it like this SELECT ExpDepDate, ActArrDate, (TO_DAYS(ActArrDate)-TO_DAYS(ExpDepDate)) as Act_Est FROM oceandata I'll get nothing, just a empty screen with a browser! I'm using

Caldera OpenLinux eDesktop 2.4 and MySQL

2002-10-18 Thread Benoit St-Jean
Anyone has tried MySQL 3.23.5x (or even 4.x) on Caldera OpenLinux eDesktop 2.4 ? I am considering setting up a server on Linux but I want to know if MySQL has any preoblem on Caldera's . Thanks filter: SQL, database, MySQL = - Benoit St-Jean [EMAIL PROTECTED]

2nd Attempt: Fwd: Access Denied (1045)]

2002-10-18 Thread Anthony W. Marino
I'm boxed in a corner and would appreciate some suggestions, please! Thank You, Anthony Original Message Subject: Access Denied (1045) Date: Tue, 15 Oct 2002 08:47:05 -0400 From: Anthony W. Marino [EMAIL PROTECTED] To: [EMAIL PROTECTED] Ive searched about and still haven't

re: rpm -i MySQL: exist or not?

2002-10-18 Thread Victoria Reznichenko
Jack, Friday, October 18, 2002, 5:38:30 AM, you wrote: JC The strange thing I met with is that when I ran JC rpm -e XXX.rpm JC It said that the package in not installed. But when I ran Remove .rpm To see what package is installed use rpm -qa | grep -i mysql I get the list of installed rpms of

re: multiple incremental inserts

2002-10-18 Thread Egor Egorov
Andrew, Wednesday, October 16, 2002, 10:52:37 PM, you wrote: AH I need to be able to insert many rows into a table at once. Only one AH field, an incremental serial number will change for each row. Is there AH a way to do that in a single query? I need to be able to specify the AH start and end

re: unprivileged user can create a database

2002-10-18 Thread Victoria Reznichenko
Max, Friday, October 18, 2002, 1:32:34 AM, you wrote: MK Here is a (stripped) list of steps needed to recreate this problem. MK --- MK # mysql -u root -p MK .. MK mysql CREATE DATABASE `user_db`; MK Query OK, 1 row

re: Incorrect key file for table

2002-10-18 Thread Victoria Reznichenko
Renato, Friday, October 18, 2002, 1:01:06 PM, you wrote: RS select id from usuario; RS ERROR 1034: Incorrect key file for table: 'usuario'. Try to repair it RS How can I solve this problem? Repair your table: http://www.mysql.com/doc/en/Repair.html -- For technical support contracts,

mysqld crashing

2002-10-18 Thread kewl
Description: Mysqld crashes from time to time, there is no backtrace information in error logfile. How-To-Repeat: There is no specific query that causes it. Most often it happens just after select count(*) from ... queries. I tried compiling with different options with same effect. I even tried

re: MySQL v3.23.53 segfaults on TCP/IP connection

2002-10-18 Thread Egor Egorov
Aaron, Thursday, October 17, 2002, 6:18:55 PM, you wrote: AP I have a more-or-less stock Red Hat 7.3 machine that I have running AP MySQL v3.23.53 built from source. Local socket connections work great, AP but it segfaults when it receives a remote connection. Here is the error: AP

re: Back Table syntax

2002-10-18 Thread Victoria Reznichenko
Karam, Wednesday, October 16, 2002, 10:58:15 PM, you wrote: KC i have a winxp and linux 7.2 on the same machine. I KC have mysql on the linux server and MyCC in the win KC partition. KC i connect to the linux MySQL using the vmware lopback KC adapter. everything is working fine. KC now when i

re: Select now() in Mysql 4.0.x

2002-10-18 Thread Egor Egorov
Ismed, Thursday, October 17, 2002, 11:02:50 AM, you wrote: IID I have test install MySQL ver.4.0.x on RedHat Linux 7.2. IID When I test query using MySQL Front(Under Windows) Select now() it's displayed: IID '10/17/2002 3:10:20' PM, but when I test using telnet under command line IID it's shown

re: enable innodb

2002-10-18 Thread Egor Egorov
Douglas, Friday, October 18, 2002, 5:01:21 AM, you wrote: D I'm trying to enable innodb , I installed mysql-3.23.52 from the ports D collection D I cp my-medium-.cnf my.cnf D then mv my.cnf to /etc D I uncommented the innodb lines D and created ibdata1 directory in the data directory

re: character set when you don't manage the server

2002-10-18 Thread Egor Egorov
Nikolas, Friday, October 18, 2002, 5:56:10 AM, you wrote: NG I have written a web application that is hosted in a server which uses NG the default character set. This causes problems in the sorting that NG MySQL does because most of the data is in Greek. When developing it NG locally, I run

Temporary Table Problems

2002-10-18 Thread Martin Thomas
Help (apologies for the length of this email), I am currently using mysql-max-3.23.49a with a process as follows: Using tomcat/jsp/servlets, I have written a database connection pooling java class which establishes connections to mysql, stores them in an array and manages the distribution of

re: What is relay-bin log?

2002-10-18 Thread Victoria Reznichenko
Chung, Thursday, October 17, 2002, 9:48:15 AM, you wrote: CHn At the slave server of replication there are log files like CHn environment hostname-relay-bin.xxx. Yes, these logs are used for replication: http://www.mysql.com/doc/en/Replication_SQL.html CHn For what these logs and how can

ANN: EMS MySQL Utils released!

2002-10-18 Thread Igor Brynskich
EMS HiTech company is very glad to announce the NEW software -- MySQL Import Tool! Now our MySQL Export and Import tools are joined in one section -- MySQL Utils. MySQL Import is a powerful cross-platform (Windows and Linux) tool to import your data quickly from MS Excel, MS Access, DBF, TXT and

  1   2   >