Re: Q: How to determine size(s) of db files?

Hello. On Wed 2002-09-11 at 12:48:02 -0400, [EMAIL PROTECTED] wrote: Is there a MySQL command that will return the amount of disk space used by a particular database? I find lots of references to size limits on tables / databases etc. but nothing on the actual 'disk usage'. You can use

Re: Q: How to determine size(s) of db files?

Benjamin Pflugmann wrote: Hello. On Wed 2002-09-11 at 12:48:02 -0400, [EMAIL PROTECTED] wrote: Is there a MySQL command that will return the amount of disk space used by a particular database? I find lots of references to size limits on tables / databases etc. but nothing on the

Installing from tarball to /var/lib/mysql

Is there a way to specify that the files in /usr/local/mysql/data should be written to /var/lib/mysql instead when installing from a tarball?(I have these files from a previous installation there and am upgrading) I use 4.0.3 Thanks, S.Alexiou

deleting duplicate data field values

Hello, I want to delete the duplicate email addresses from a single table, called contact, containing the field called yemail datatype varchar. What is the best way to remove this data when copying the table. The original table had no unique index requirements, but now I want the new table to

RE: and or in query

Sorry, let me try and explain a bit better: Table: Field1 Field2 Field3 annetypist good betty reception fair sandy typist excellent elise pa bad danareception excellent

deleting data from mater-detail table

dear all, hi, i have a question that bother me in last few days and would you help me to solve it, please. i have a master-detail table: hinvoice and dinvoice. the table structure of those two table shown as below : create table hinvoice ( nof varchar(7) not null, noso varchar(7),

About the 4.1 release

Hello, When will the 4.1 source tree be made accessible by the public? How about the first official 4.1 release? Any estimates? Best regards, Iikka sql query ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland

REWARD for help

I will buy a book of the helpers choice from Amazon.com (within reason up to $50ish) for help solving my problem: I need to do something kinda odd that I'm hoping to get help with...except for any suggestions of changing my base table structure. (Although if there was someway to make

RE: deleting data from mater-detail table

I think you should use this statement. I did not try it. DELETE FROM hinvoice h USING dinvoice d WHERE h.nof=d.nof AND h.tgl '2002-09-01'; Regards Stephan -Original Message- From: MySQL [mailto:[EMAIL PROTECTED]] Sent: Friday, September 13, 2002 9:25 AM

Re: Re: Rapid-fire connections causing MySQL grief

Hi. On Wed 2002-09-11 at 15:10:22 -0400, [EMAIL PROTECTED] wrote: On Wed, Sep 11, 2002 at 02:55:01PM -0400, Kent Hoover wrote: Version: MySQL.3.22.32-log Does this problem ring a bell with anyone? I'm seeing two undesired behaviors, both, *I think* seem to be because I'm

Re: Q: How to determine size(s) of db files?

Hello. On Fri 2002-09-13 at 02:42:16 -0400, [EMAIL PROTECTED] wrote: Benjamin Pflugmann wrote: [...] SHOW TABLE STATUS [FROM yourdatabase] [LIKE pattern] in order to see a overview of the tables including their resp. data and index file sizes. [...] That seems to do it. But I'm not

deleting master-detail table

dear all, hi, i have a question that bother me in last few days and would you help me to solve it, please. i have a master-detail table: hinvoice and dinvoice. the table structure of those two table shown as below : create table hinvoice ( nof varchar(7) not null, noso varchar(7),

Re: Starting/stopping server on WinXP Home standalone -- what's appropriate way?

I generally read responses to my requests for help with care ... and gratitude! So I did read Paul's post. To my knowledge it doesn't answer my (subsequent) question: Is there some other way to have the MySQL server running on a standalone Win system other than as a service? Which way is

winadmin stopped on Beta

Hello everyone - I saw that the beta version of 4 was available and so I uninstalled my alpha (I only footal with the database at present on my own computer) and put on the beta. It starts fine and I have loaded my dumped database into it MySQLFront and PHP My Admin seem to connect to it and

RE: Starting/stopping server on WinXP Home standalone -- what's appropriate way?

Urial: Why are you so phobic about running MySQL as a service? I can think of no reason to not run it as a service if the operating system will permit you to do so. Since you can configure the service to either run automatically or be controlled manually, it would seem as though you have the

Re: winadmin stopped on Beta

At 08:13 13/9/2002 +0100, Adrian Greeman wrote: Hi, Sorry to inform you that I got a library corruption in my working machine where I built that tool and makes not to work well on Win9x machine. This will fixed in the next release, however you can use the tool shipped in your old version.

Re: About the 4.1 release

Hi! - Original Message - From: Iikka Meriläinen [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Friday, September 13, 2002 10:37 AM Subject: About the 4.1 release Hello, When will the 4.1 source tree be made accessible by the public? My guess is October 31, 2002. How

Unsure of SQL Syntax

I am working with a MySQL database and I am hoping someone can help me out with this. CREATE TABLE CLASS ( CID int(22) NOT NULL auto_increment, LOC int(11) default NULL, CLI int(8) NOT NULL default '0', TYPE tinyint(4) NOT NULL default '0', STATUS char(3) NOT NULL default '',

start safe_mysqld

hi, have a simple question of about starting mysql : staring with a book of mysql I should start mysql as the loggedin-user, which is my case papabaer as follows : safe_mysqld but trying that, I get : [papabaer@hanna papabaer]$ safe_mysqld Starting mysqld daemon with databases from

Re: start safe_mysqld

as far as I know you have to start safe_mysqld as root! Thomas On Fri, 13 Sep 2002 12:29:30 +0200 hans schneidhofer [EMAIL PROTECTED] wrote: hi, have a simple question of about starting mysql : staring with a book of mysql I should start mysql as the loggedin-user, which is my case

RE: simple query question

I've seen a lot about 'InnoDB'. What is it? -Original Message- From: Weaver, Walt [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 4:09 PM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: simple query question I'd use the InnoDB table type and establish a primary

Compiling for HP-UX

Hi to all, I´m trying to compile the MySQL sources for HP-UX, but I get this error on the first file to compile: In file included from /usr/include/sys/user.h:52, from /usr/include/sys/stream.h:53, from rlwinsize.h:45, from rltty.h:45,

RE: simple query question

See http://www.innodb.com Regards, Iikka ps. The MySQL manual also offers some rough guidelines on where InnoDB excels. On Fri, 13 Sep 2002, Meidling, Keith, CTR, OSD-C3I wrote: I've seen a lot about 'InnoDB'. What is it? -Original Message- From: Weaver, Walt [mailto:[EMAIL

BBC article: Intellectual Property

MySQL/Open source campaigners and 'evangelists' may be interested in BBC coverage of a report by the Commission on Intellectual Property Rights (CIPR): http://news.bbc.co.uk/1/hi/sci/tech/2253270.stm. It talks of medical, agricultural, industrial, and IT/educational disadvantages placed in front

Problem with accesing the database

Hello. I have got a problem. I'm programming in Visual Basic and when connecting to database a got this error message: RUN-TIME ERROR '-2147467259(80004005)': [TCX][MY ODBC] Can't connect ty MYSQL SERVER on 'localhost'(10055) It happens in this function: pop.ConnectionString =

Dependencies with MySQL-bench.rpm package

Hi. I install MySQL-3.23.52 in SuSE 8.0 with rpms packages. I could install all packages except MySQL-bench-3.23.52-1.i386.rpm. It needs MySQL-DBI-perl-bin I donwloaded Mysql-DBI-perl-bin-1.1825-1.i386.rpm (it also needs perl-DBI), but it isn'nt MySQL-DBI-perl-bin and after install it I

optimizer bug in selecting fields that don´t belong to the index used by mysql

Description: Hello, I am working with mysqld-max-nt under windows 2000 and unsing InnoDb tables. I have the following table: CREATE TABLE clientes ( Cod varchar(6) NOT NULL default '', Nom varchar(40) NOT NULL default '', Nif varchar(10) NOT NULL default '',

Re: Hans Needs Help :D

The solution that works best with all broken rpm dependiences is to use --force --nodeps (verify with the man page). HTH, Max spam filter pass: sql,query - Before posting, please check: http://www.mysql.com/manual.php

winSQLadmin stopped on Beta

To: [EMAIL PROTECTED] Sent: Friday, September 13, 2002 8:13 AM Subject: winadmin stopped on Beta Hello everyone - I saw that the beta version of 4 was available and so I uninstalled my alpha (I only footal with the database at present on my own computer) and put on the beta. It starts

RE: laptops

thanks guys for the info! The idea of an iMac really interests me but I need something so I can do some work on our apps here at work and they are windows based and I would also like to start learning c#. Eddie -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: