Re: Index not used for order by when more than 1 field selected, no where clause

2001-02-16 Thread Joseph Bueno
Benjamin Pflugmann wrote : Hi. [] If MySQL uses the index, it has one of two possibilities. First: 1. Read the whole isbn index, and for each row 2. seek the record in the data file and get author from it. This is quite slow because of the random file seeks needed. Second: 1.

synopsis of the problem (one line)

2001-02-16 Thread tarmo
Description: How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Tarmo Kähr Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class:

[Fwd: storing files in database]

2001-02-16 Thread I.SivaramaKrishnan
NOTE: Since iam not a member of this group, please reply by cc`ing to my mail id. -- Sivaramakrishnan I AdventNet (India) Development center. Madras, India. Phone: 91 44 243 2414 Hi all, Basically I have a requirement where I have to store xml files in the database. The table that I

ERROR 1114: The table 'SQLb07dc_0' is full

2001-02-16 Thread Chappuis J.-Vincent
Hi, I have this error when I execute a query : ERROR 1114: The table 'SQLb07dc_0' is full I can execute other queries without problems but when I want to execute the query : SELECT DISTINCT person.* FROM person, training, cursus where training.BRANCH_ID=101 and

DROP COLUMN

2001-02-16 Thread Wernher Korff
im new to this list and to the SQL language, id like to know if anyone knows how to drop a column from a SQL database,i currently have the following string: "ALTER TABLE WorkGroups DROP COLUMN Personnel" i read somewhere something about having to store the information in a temporary column before

Optimal configuration

2001-02-16 Thread Jesús Gómez Pastor
Hi. I have a server running mysql.From it reads data two web server wich has about 30.000 daily visits and 250.000 pages so the trafic to the mysql server is big. Can anybody tell me a optimal mysql configuration for this server?. Actually in the /etc/my.cnf i have: set-variable =

Binary installation of mysql 3.23.33

2001-02-16 Thread Peter Karlsson
Okay, here's the deal. First I unpack the .tar.gz into /a-path-name/mysql-dir-name After that I should (atleast according to the readme) type ./configure --prefix=/usr/local/mysql That script tells me that this is a binary version and that I dont need to configure it, it's ready to rock as it

Re: ERROR 1114: The table 'SQLb07dc_0' is full

2001-02-16 Thread Fred van Engen
On Fri, Feb 16, 2001 at 09:55:32AM +0100, Chappuis J.-Vincent wrote: Hi, I have this error when I execute a query : ERROR 1114: The table 'SQLb07dc_0' is full I can execute other queries without problems but when I want to execute the query : SELECT DISTINCT person.* FROM person, training,

Some problems encountered when linked to glibc-2.2.1

2001-02-16 Thread Pat Verner
Description: I built mysql-3.23.33 against glibc-2.2.1, under Linux, kernel 2.4.1 Although the server appeared to be functional, all "show" commands yielded blank lines, and mysqldump would not create a dump file for databases - it would still work for

RedHat 7.0 and threading

2001-02-16 Thread Matthias Urlichs
Hi, we had a rather ... interesting ... problem with mysqld, compiled on a system with glibc-2.1.3. We tried to run the server on a RedHat 7.0 machine and had inexplicable pthread errors. The solutions turned out to be either to downgrade /lib/libpthreads.so.0 and /lib/librt.so.1 to the

DROP COLUMN

2001-02-16 Thread Wernher Korff
hello list;) i have a SQL command to DROP a COLUMN from a mySQL database, the problem is that the syntax i am using doesnt seem to be the right syntax for mySQL, my statement currently read:"ALTER TABLE WorkGroups DROP COLUMN Personnel" and i get the error message: Error Type: Microsoft OLE DB

Antwort: storing files in database

2001-02-16 Thread alexander . skwar
On 16.02.2001 10:05:54 I.SivaramaKrishnan wrote: Hi all, Basically I have a requirement where I have to store xml files in the database. The table that I visualised for the purpose will contain two columns, one being the key (varchar) and the other for the xml file. What data type should

Antwort: [Fwd: storing files in database]

2001-02-16 Thread alexander . skwar
On 16.02.2001 10:08:26 I.SivaramaKrishnan wrote: NOTE: Since iam not a member of this group, please reply by cc`ing to my mail id. That's a behavior I never quite understood - you come to list seeking for advice. Fine. Next you say that you do not care at all about the list. Geez, if you

Re: Restart MySQL after rebooting Linux

2001-02-16 Thread Dave Hodgkinson
kentj [EMAIL PROTECTED] writes: I believe so. I was trying that and was missing something because I could not get it to work. If you've for it in init.d and "mysql stop" and "mysql start" work there, then make sure they're also symlinked into rc3.d directory. -- Dave Hodgkinson,

SQL statement in PHP

2001-02-16 Thread Matt Davis
Can anybody help with this If I put the following statement in PHP my browser tells me that there is an error on the line. //create sql statement $sql = "select Business_Name,Trading_Details where Business_Type = "Consultancy" and Bassingbourn != "0" from Main"; If I remove where

DELETE FROM mergetable clears merge definition

2001-02-16 Thread beheer
Description: "DELETE FROM mergetable" clears merge definition How-To-Repeat: mysql use test; Database changed mysql CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, message CHAR(20)); Query OK, 0 rows affected (0.04 sec) mysql CREATE TABLE t2 (a INT AUTO_INCREMENT PRIMARY KEY, message

Re: difference of two datetime values

2001-02-16 Thread Peter Skipworth
select if(columnname now(), "future", "past") from tblname On Fri, 16 Feb 2001, Vyacheslav Chukin wrote: Please, tell me, how could I determine, which one of two datetime values is greater? In other words, how could I determine, is stored on db datetime value in future or past?

Re: JDBC question?

2001-02-16 Thread Thiru
If U R using some IDE, then there shd be a place to add on Ur classpaths. If not, from the prompt For Windows java -classpath "c:\JDBCdriver;c:\JDBCdriver\driver.jar;." file.java For Unix java -classpath "/tmp/JDBCdriver:/tmp/JDBCdriver/driver.jar:." file.java note: when including jar or

Innobase + transactions row level locks will be released in a few days in MySQL 3.23.3x

2001-02-16 Thread Heikki Tuuri
Hi, readers of the mailing list! Monty will roll a new distribution of MySQL 3.23.3x this weekend. Innobase will be included there and it will provide transactions, rollback, recovery, row level locking, and Oracle-like consistent read. Monty will leave for a vacation in Rio on Wednesday, so

Re: SQL statement in PHP

2001-02-16 Thread Siim Einfeldt aka Itpunk
Take a look at your query once again: "select/../"Consultancy"/.../" You can have "" inside "". The ways to do it, so that it would work: - use '$somethinghere' instead of "$something" or - use \"$somethinghere\" instead of second "$something" or - use

RE: SQL statement in PHP

2001-02-16 Thread Jon Haworth
PHP sees the first " of "Consultancy" as being the end of the variable $sql. To get round this, change the " to ' inside the statement (e.g. ...where Business_Type = 'Consultancy' and...) HTH Jon -Original Message- From: Matt Davis [mailto:[EMAIL PROTECTED]] Sent: 16 February 2001

Re: SQL statement in PHP

2001-02-16 Thread Fred van Engen
On Fri, Feb 16, 2001 at 12:43:15PM -, Matt Davis wrote: Can anybody help with this If I put the following statement in PHP my browser tells me that there is an error on the line. //create sql statement $sql = "select Business_Name,Trading_Details where Business_Type =

Re: Table timestamps? More specific control of SHOW TABLE STATUS command

2001-02-16 Thread Gerald L. Clark
Why don't you : select timestampfield from mytable order timestampfield decs limit 1 Jay Lawrence wrote: Atle, your suggestion is for the last time a record was updated. I am interested in the entire table. The closest that I have seen thus far is: SHOW TABLE STATUS The Update_time

installation on hpux10.20 ends with ./mysql_install_db[284]: 13980 Memory fault(coredump)

2001-02-16 Thread mysql
Description: After having installed binaries, or compiled source code, mysql_install_db ends in a coredump How-To-Repeat: Fix: Submitter-Id: [EMAIL PROTECTED] Originator: Organization: MySQL support: [none ] Synopsis: install ends in coredump Severity:

Re: Indefinite Timeouts

2001-02-16 Thread Sinisa Milivojevic
Mario Oschwald writes: Hi, Didnt find this anywhere in the documentation... does -1 work if I want to set a Mysql timeout variable to indefinite?? e.g. wait_timeout=-1 Thanks Mario Oschwald No, you will have to set a very large value. Regards, Sinisa __

Re: taxes

2001-02-16 Thread Ken Menzel
Unless you have a physical location in that state! If you are in a state where Dell has a location you must pay that state's sales tax. Hey Vivek do you ever sleep! :) Ken - Ken Menzel ICQ# 9325188 www.icarz.com [EMAIL PROTECTED] -

Can't connect to MySQL when using PHP

2001-02-16 Thread bkfx
I'm start MySQL with 'mysqld-opt --default-character-set=gbk'. I can use mysql connect to MySQL,and query. But I use PHP,it display: Warning: MySQL Connection Failed: Can't initialize character set 28 (path: default) in Why??? WinMe+Apache 1.3.17(Win32)+PHP 4.04pl1+MySQL 3.23.33

show database does not work ;-(

2001-02-16 Thread Greg Cope
Dear All I've just installed mysql on a new host (3.23.33) and show databases does not work ;-(. The data directory is thus: drwxrwsr-x5 mysqlmysql4096 Feb 16 14:06 mysql Inside it has: [root@server1 lib]# ls -l mysql/ total 28 drwx--S---2 mysqlmysql4096 Feb

DROP COLUMN

2001-02-16 Thread Wernher Korff
hello list;) i have a SQL command to DROP a COLUMN from a mySQL database, the problem is that the syntax i am using doesnt seem to be the right syntax for mySQL, my statement currently read:"ALTER TABLE WorkGroups DROP COLUMN Personnel" and i get the error message: Error Type: Microsoft OLE DB

Re: SQL statement in PHP

2001-02-16 Thread Gerald L. Clark
Matt Davis wrote: Check the manual. The manual shows where following from. Can anybody help with this If I put the following statement in PHP my browser tells me that there is an error on the line. //create sql statement $sql = "select Business_Name,Trading_Details where

transactions -- whole table locked from reads too?

2001-02-16 Thread Scott McCool
If I start a transaction (set autocommit=0 in the command line utility), then do an "insert" in one session, then open a second session and try to do a select on that table, before the first session has committed, the select just hangs. Once I commit in the first session, my select

Merge table problem.

2001-02-16 Thread Peter Zaitsev
Hello monty, I'm trying to use merge table for logging - to have a possibility to Rotate log files and to quickly delete old data - for this I'm goint to setup a number of merge tables where each contains data for one day, and the inserts are done to the last table using real table

RE: Can't connect in Windows 2000

2001-02-16 Thread Darrell Weldon
Sorry, thought you were just having trouble teleneting to W2K server to run mysql or other exe's at command prompt. We ran into this because appartently W2K supports a different telnet that has to be started as a service before you can connect. Once it was running we had no problem coming into

Antwort: difference of two datetime values

2001-02-16 Thread alexander . skwar
On 16.02.2001 13:27:58 Vyacheslav Chukin wrote: Please, tell me, how could I determine, which one of two datetime values is greater? Date1 Date2 In other words, how could I determine, is stored on db datetime value in future or past? Past: DbDateTime NOW() Present: DbDateTime =

Re: show database does not work ;-(

2001-02-16 Thread Fred van Engen
On Fri, Feb 16, 2001 at 02:18:11PM +, Greg Cope wrote: Dear All I've just installed mysql on a new host (3.23.33) and show databases does not work ;-(. Maybe it would help to read (or search) the list before posting. There are several mails regarding this problem, among them a mail

test

2001-02-16 Thread john1
dear Sir : MySQL 3.22 on my linux 486 PC seems work so good. when I compile a simple C API programe which catched from the MySQL tutorial, it chokes at the end of compile process . the programe is as follows: #include stdio.h #include mysql.h #define def_host_name NULL #define def_user_name

Re: show database does not work ;-(

2001-02-16 Thread Greg Cope
Rick Roberts wrote: SHOW DATABASES; Sorry my subject line had the last S missing: mysql 010216 15:29:14 1 Query SHOW DATABASES SHOW DATABASES; +--+ | Database | +--+ | | | | | | | | | test | +--+ 5 rows in set (0.01

Re: transactions -- whole table locked from reads too?

2001-02-16 Thread Heikki Tuuri
Scott, did you try to do the insert and select on the same database page? In BDB there is page level locking used, and the behavior you describe sounds like that the insert has placed a page level lock on the page where you try to do the select. Then it is correct behavior of the database that

Re: DROP COLUMN

2001-02-16 Thread Andy Woolley
Werner, Your syntax is correct and valid for MySQL. The problem could lie with your ODBC driver. What version are you on? Try downloading a utility for administering MySQL. UrbSQL is good from www.urbanresearch.com and see if that can drop the column. Good luck. Andy Woolley

Possible SHOW DATABASE || TABLE bug in 3.23.33

2001-02-16 Thread Greg Cope
Description: SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e a nice list of blanks - no of blank lines equals number of databases / tables) How-To-Repeat: Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33 Fix: Submitter-Id: submitter ID Originator:

Display information

2001-02-16 Thread Ron Beck
Hello all, I have a database with a little over 2000 records. I want to be able to construct a query that says something like this... select id,lot_id,lot_type from scrap_table starting with record 1932 (part I need help with) order by id limit 10; which should give me records 1932 -

Re: show database does not work ;-(

2001-02-16 Thread Greg Cope
Fred van Engen wrote: On Fri, Feb 16, 2001 at 02:18:11PM +, Greg Cope wrote: Dear All I've just installed mysql on a new host (3.23.33) and show databases does not work ;-(. Maybe it would help to read (or search) the list before posting. I have already searched the list, and

Switching from 3.22.32 to 3.23.33. What about the database files?

2001-02-16 Thread Tobias Wolff
Hello, can anyone tell me whether or not I have to convert the database files when switching from MySQL Version 3.22.32 to Version 3.23.33. I am working on SuSe Linux 6.4. Is it sufficient just to copy the database files? Thanks, Tobias.

RE: COUNT(DISTINCT Column_Name)

2001-02-16 Thread Roger Ramirez
You can use: SELECT Column_Name, count(Column_Name) FROM Table_Name GROUP BY Column_Name -Original Message- From: Franz, Fa. PostDirekt MA [mailto:[EMAIL PROTECTED]] Sent: Friday, February 16, 2001 3:02 AM To: [EMAIL PROTECTED] Subject: COUNT(DISTINCT Column_Name) Hi Everybody

Different behaviour between 3.22.32 and 3.23.32

2001-02-16 Thread Andrew Benham
Description: "SELECT MAX (record_id) FROM record;" iworks in 3.22.32 but fails in 3.23.32 In v3.22.32, both the following SQL commands work: mysql SELECT MAX (record_id) FROM record; +-+ | MAX (record_id) | +-+

MySQL errors during high activity

2001-02-16 Thread gene
I know this has come up before, but I couldn't find a satisfactory solution. I'm running MySQL 3.23.23 on mandrake linux. It's used by a web site that has very high activity. During times of high activity, I find my perl scripts generating two kinds of errors: DBD::mysql::db selectrow_array

Re: Possible SHOW DATABASE || TABLE bug in 3.23.33

2001-02-16 Thread Sinisa Milivojevic
Greg Cope writes: Description: SHOW DATABASE and SHOW TABLES and mysqlshow all return empty lists (i.e a nice list of blanks - no of blank lines equals number of databases / tables) How-To-Repeat: Do a mysqlshow or SHOW DATABASES under mysql in version 3.23.33 Fix:

RE: Display information

2001-02-16 Thread Javier Muniz
select id,lot_id,lot_type from scrap_table where id = 1932 order by id limit 10; select id,lot_id,lot_type from scrap_table order by id limit 1932,10; either should work, i think the first would be faster but I'm not positive how MySQL would handle the second in terms of optimization. -jm

MySQL CRM

2001-02-16 Thread Steve Ruby
Does anybody know of any commercial or opensource CRM systems that run with MySQL on Linux (and/or FreeBSD)? Mainly I need canned responses and ticket management and some other standard features. - Before posting, please

RE: Display information

2001-02-16 Thread Opec Kemp
select id,lot_id,lot_type from scrap_table starting with record 1932 (part I need help with) order by id limit 10; which should give me records 1932 - 1942 like this... +--+--+--+ | id | lot_id | lot_type | +--+--+--+ | 1942 | 0034906

Re: There are no DB defined space limits on MySQL Databases ?

2001-02-16 Thread Brian Reichert
On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote: There are no DB defined space limits on MySQL Databases ?It's dangerours .How to control the database space on my database user? Filesystem quotas. -- Brian 'you Bastard' Reichert[EMAIL PROTECTED] 37 Crystal Ave. #303

Re: show database does not work ;-(

2001-02-16 Thread Greg Cope
Rick Roberts wrote: mysql select version(); +---+ | version() | +---+ | 3.23.33 | +---+ 1 row in set (0.01 sec) mysql SHOW DATABASES; +--+ | Database | +--+ | mysql| | test | +--+ 2 rows in set (0.02 sec) I'm using

Re: Switching from 3.22.32 to 3.23.33. What about the database files?

2001-02-16 Thread Karl Sloth
Tobias - You can continue to use the ISAM format or convert to the new MYISAM format (and other formats such as HEAP, I believe). See the 'mysql_convert_table_format' script in the bin directory. -karl Tobias Wolff wrote: Hello, can anyone tell me whether or not I have to convert the

interesting problem

2001-02-16 Thread Chris Toth
I have a form on a webpage for a simple trouble ticket system. When requesting a computer be fixed, software be installed, etc...a faculty member can go to this website and type in the info via an HTML form. My problem is, the form needs to be submitted to two different tables. All of the

Re: Display information

2001-02-16 Thread Ron Beck
Hello all again. I think I need to be a little more specific in describing my problem. So, let me try again. I have a database of scrap records. There are currently over 2000 records in this database. I have a web page that queries this database and displays the records in reverse order,

Re: MySQL CRM

2001-02-16 Thread Jan-Aage Bruvoll
On Fri, 16 Feb 2001, Steve Ruby wrote: Does anybody know of any commercial or opensource CRM systems that run with MySQL on Linux (and/or FreeBSD)? Mainly I need canned responses and ticket management and some other standard features. Have a look at http://freshmeat.net/, where most of the

Re: taxes

2001-02-16 Thread William R. Mussatto
Ran into an interesting twist on "presence" in a state. One client went to a trade show in Nevada. She was informed that for the next quarter she would have to consider herself "in" Nevada, even though she did not sell anyting at the show. I don't think she is going back. On Thu, 15 Feb

EXPLAIN output wierdness?

2001-02-16 Thread Jason Landry
I have a concern regarding how an index is being used for a query. I've included the query (minus the fields) and the EXPLAIN output below. I'm curious why MySQL would indicate that it's using filesort for table 'd' since it's type is 'const.' The documentation indicates this means that only

Re: There are no DB defined space limits on MySQL Databases ?

2001-02-16 Thread Fox Mulder
--- Brian Reichert [EMAIL PROTECTED] wrote: On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote: There are no DB defined space limits on MySQL Databases ?It's dangerours .How to control the database space on my database user? Filesystem quotas. But, to define filesystem quota, I will

Re: JDBC question?

2001-02-16 Thread William R. Mussatto
Had similar problem, get the current version of the driver. On Fri, 16 Feb 2001, Chen Ka Pong wrote: Date: Fri, 16 Feb 2001 20:29:27 +0800 From: Chen Ka Pong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: JDBC question? I cannot use the jdbc connection which the driver is download

RE: Please Help me ..Apache_1.3.17+php-3.0.16+mysql-3.23.32

2001-02-16 Thread Fabian Gonzalo
I can't to compile this I'm getting the following error on my gmake (most snipped for brevity). gcc -DSOLARIS2=280 -DUSE_HSREGEX -DUSE_EXPAT -I./lib/expat-lite -DNO_DL_NEEDED -I/usr/local/include -I/usr/local/include/mysql `./apaci` -L/usr/local/lib -R/usr/local/lib \ -o httpd

Perl DBI

2001-02-16 Thread John Tsangaris
Is it possible to connect to mysql without connecting directly to a database, check to see if a particular database exists, and if it doesn't exist create it? I have not been able to find a way of connecting to mysql without having a database already (I want perl to be able to make the db.. not

Still about libmysqlclient.a?

2001-02-16 Thread Agus Setiono
Hi, There is a mistake and my last question. I am asking about libmysqlclient.a, not libmysql.a. And this is the case: I am using Perl's MySQL module which upon installation always asks me where libmysqlclient.a or libmysqlclient.so is. So, I guess even Windows users need those too. In order

RE: Different behaviour between 3.22.32 and 3.23.32

2001-02-16 Thread Carsten H. Pedersen
Description: "SELECT MAX (record_id) FROM record;" iworks in 3.22.32 but fails in 3.23.32 Well, that shouldn't really come as a surprise. The manual specifically says (Section "Functions for use in SELECT and WHERE clauses): Note: There must be no whitespace between a function

JDBC question

2001-02-16 Thread webmaster
I am , well I will have to wioork with oracle and jdeveloper, can some of you please please please telll me where canI find examples of conections to a database an oracle databse and if I use php again eh the same question where can I see examples of conections to an oralce data base

Re: Perl DBI

2001-02-16 Thread Eric Fitzgerald
Connect to the mysql database if you have access. It always exists. - Original Message - From: "John Tsangaris" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 16, 2001 1:58 PM Subject: Perl DBI Is it possible to connect to mysql without connecting directly to a

MySQLGUI

2001-02-16 Thread Shawn Boedecker
Hi, I just started looking at the MySQLGUI tool in depth yesterday. I have one question for now. I'm able to save queries via the "Save Query" button but I don't see any facility to load the query back in from a file. Is this functionality missing or hidden? I've examined all the readme's

MySQl with SSH

2001-02-16 Thread Kuokai Shyu
Hi, How can I configure MySQL to utilize the SSH package for encrypted TCP/IP connection between MySQL clients and server? Thanks in advance. Kuokai - Before posting, please check: http://www.mysql.com/manual.php (the

RE: Perl DBI

2001-02-16 Thread John Tsangaris
Hi, Eric. What I'm trying to do is have my install program check to see if a database of a certain name exists, if it does then the install needs to create another one (using a name given by the user), if not then it needs to create it with the original name. But I cannot figure out how to

Re: setting key_buffer_size correctly

2001-02-16 Thread Benjamin Pflugmann
Hi. On Fri, Feb 16, 2001 at 03:05:35AM -0500, [EMAIL PROTECTED] wrote: Hello, I have a large database with a lot of queries and was trying to tune MySQL to get the best performance. I was reading the manuals and it said to set the key_buffer_size to the best value, you take the first two of

Compile error

2001-02-16 Thread John Markunas
Hello Running gcc 2.95.2 and gnumake 3.39. Attempting to build mysql v3.23.32 or v3.23.33. Getting error, during make sql_string.cc: In Method 'bool String::(double,unsigned int=2)': sql_string.cc:181 Implicit declaration of function 'int snprintf(...)' Running on an

Re: Index not used for order by when more than 1 field selected, no where clause

2001-02-16 Thread Benjamin Pflugmann
Hi. On Fri, Feb 16, 2001 at 09:42:02AM +0100, [EMAIL PROTECTED] wrote: Benjamin Pflugmann wrote : [...] "Second" is never the best way. MySQL uses "First" up to some percentage of the amount of records (30% I believe), then uses "Third", because reading the data in file order (unsorted)

MyODBC and JDBC Bridge Driver

2001-02-16 Thread Ketevan und Thomas Krause
Sorry people, I' ve some bad problems to run mysql with the Java JDBC ODBC Bridge Driver under Win89. Perhaps only a question of syntax, perhaps an internal Error, perhaps... I tried out lots of possibilities, but in the end the error of finding a nonexistant database was the closest thing of

CREATE from a mysqldump won't CREATE a table in 3.23?

2001-02-16 Thread Martin
The following CREATE TABLE came from a mysqldump. When I use the same create statement to create the table under mysql 3.23 I get an error: # MySQL dump 8.12 # # Host: localhostDatabase: installers # # Server version3.23.32-log

varchar and sql92

2001-02-16 Thread Eric Frazier
Hi, I am writing a program to do queries on a lot of different databases. I have run into something with varchar I didn't expect. With mySQL varchar is limited to 255 with postgress it is unlimited it seems. I only know because it seems to work, not because their stupid documentation told me,

Re: Setting up Access 2000 to work using a mySQL db...

2001-02-16 Thread John Jensen
Kentj, I have a setup that differs in just a few ways. My server is Redhat7 Linux, on the Internet. It appears from the IP address that you gave, that yours in on an intranet. Judging by a lot of messages I have seen here, and by my own experience, a similar connection on the Internet is far

Re: MyODBC Prompt on connect

2001-02-16 Thread John Jensen
Yes, Pay attention to the large number of problems mentioned regarding MyODBC connections, on this list. Also note that I am not the only one who keeps saying to use PhpMyAdmin. It is simply a better solution. On 15 Feb 2001, at 20:44, Juan Suris wrote: I've setup MyODBC (Win98) so I can

newbie

2001-02-16 Thread Kelly Zhu
Try installing mySQL. Please help me out with these questions: 1) I am running RedHat 6.0 on a x86 machine. The file I downloaded was 'Linux (Intel libc6 systems) [pc-linux-gnu-i686]'. Is it the right one? 2) 'Linux (Intel libc6 systems) [pc-linux-gnu-i686]' seems to be the binary

Re: Perl DBI

2001-02-16 Thread Eric Fitzgerald
Here is what I would do. There is always a database on every mysql installation called "mysql" This database is where your permissions tables and such are stored. Connect initially to that database. Then, try to create the new database. If you get an error back, prompt the user, rinse and

Re: ranking album plays by city, help me beat Oracle

2001-02-16 Thread S A
This is the latest approach we're using now. It turns out that the query to get Total Plays for an Album per City can be taken out of the City for loop done only once as a GROUP BY. The worst case time for MySQL is now 16 seconds compared to Oracle's 8 seconds. On most cases MySQL is now

Re: Compile error

2001-02-16 Thread Martin
Actually the function is called sprintf() rather than snprintf(), to the best of my recollection, and it's probably defined in either stdio.h/stdlib.h or string.h. Change snprintf to sprintf() and see what happens. - Original Message - From: "John Markunas" [EMAIL PROTECTED] To: [EMAIL

Re: varchar and sql92

2001-02-16 Thread William R. Mussatto
db2 is limited to 255. On Fri, 16 Feb 2001, Eric Frazier wrote: Date: Fri, 16 Feb 2001 14:13:00 -0800 From: Eric Frazier [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: varchar and sql92 Hi, I am writing a program to do queries on a lot of different databases. I have run into

Re: MySQl with SSH

2001-02-16 Thread Jeremy D. Zawodny
On Fri, Feb 16, 2001 at 05:31:54AM -0800, Kuokai Shyu wrote: How can I configure MySQL to utilize the SSH package for encrypted TCP/IP connection between MySQL clients and server? Thanks in advance. What I do is setup port-forwarding. I forward a local port (say 12345) to port 3306 on the

Conversion

2001-02-16 Thread bob
I'm looking for a way to translate a database in ASCII form throw a MySQL database. Could you tell me how to do and if there is a special software to do it. Tank you Ragrads - Before posting, please check:

Re: newbie

2001-02-16 Thread Mohamad Ilhami
On Fri, 16 Feb 2001, Kelly Zhu wrote: Try installing mySQL. Please help me out with these questions: 1) I am running RedHat 6.0 on a x86 machine. The file I downloaded was 'Linux (Intel libc6 systems) [pc-linux-gnu-i686]'. Is it the right one? Yes Youare right. beware of 386, 586, or 686

Re: Conversion

2001-02-16 Thread Colin Faber
bob, first build the tables, to match your ascii database structure, Next use LOAD_DATA INFILE option to load it up, See LOAD_DATA in the manual for a detailed explanation. g'luck bob wrote: I'm looking for a way to translate a database in ASCII form throw a MySQL database. Could you tell

libmysqlclient

2001-02-16 Thread Alex Le Fevre
I just installed MySQL version 3.23.32, and all appeared to go well. However, after installing PHP 4 and rebooting my server, when I tried to start Apache (1.3.14) I got the following message: /usr/libexec/ld.so: httpd: libmysqlclient.so.10.0: No such file or directory /usr/sbin/apachectl start:

list of databases

2001-02-16 Thread Tim Chambers
Is there any way I can generate a list of the databases in mysql, perhaps with the mysqlshow command and some fancy grep? I'm looking for a list separated by spaces, something that I could use in a bash script. Thanks, Tim -

Re: libmysqlclient

2001-02-16 Thread Mohamad Ilhami
copy or link your libmysqlclient.so.10.0 to /usr/lib. Or edit /etc/ld.so.conf. Add path your libmysqlclient.so.10.0, and run ldconfig. You must have root access. --ilham-- On Fri, 16 Feb 2001, Alex Le Fevre wrote: I just installed MySQL version 3.23.32, and all appeared to go well. However,

returning PID

2001-02-16 Thread Teddy A Jasin
Hi, wat command to type under linux to get the PID of the mysqld that is running? i tried : 'ps aux | grep mysqld' but this will list the mysqld information but ijust want it to show the PID thanks Teddy

Re: returning PID

2001-02-16 Thread Tony Mulligan
Try this. ps aux | grep mysqld | cut -c 10,11,12,13,14 - Original Message - From: Teddy A Jasin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, February 16, 2001 7:32 PM Subject: returning PID Hi, wat command to type under linux to get the PID of the mysqld that is running? i

Re: returning PID

2001-02-16 Thread Steve Ruby
PID is stored in a file in the datadir named hostname.pid [root@georgia data]# cat /usr/local/mysql/data/georgia.pid 19805 Teddy A Jasin wrote: Hi, wat command to type under linux to get the PID of the mysqld that is running? i tried : 'ps aux | grep mysqld' but this will list the mysqld

Re: ISM,FRM Problem plese help if possible

2001-02-16 Thread Mohamad Ilhami
create directory in your mysql data directory, like /var/lib/mysql/mydatabase. copy your .frm, .ISD, ism to that directory. now you have database named mydatabase. --ilham-- On Fri, 16 Feb 2001, Ryan Ahmed wrote: Q:--have you heard about that guy who finally discovered what a woman is all

quick install question about phpMyAdmin

2001-02-16 Thread ited
i must be really new! i had no idea and read nothing that said the entire phpMyAdmin directory needed to be in a website folder. (i figured the entire folder need to be in there, is there another way?) how do you folks usually set this up? i mean, do you setup a whole website just to do