Re: How to limit database size under Windows?

2005-02-05 Thread Mark Webber
Salama hussein wrote: I need to limit my users' databases size. In Linux, you can control the folder size but I can't do this under Windows unless I use expensive third party quota manager programs. Is there any way to limit the database size? I find this feature seriously lacking. Salama Wha

Re: Comparing bug in 4.1.7

2005-02-05 Thread Arjen Lentz
Hi Roger, Michael, Vlad, Let me just follow up on this old thread, as it may clarify some things. On Fri, 2004-12-03 at 02:00, Roger Baklund wrote: > Michael Stassen wrote: > > You are overthinking the issue. > > Probably. :) > > > mysql> SELECT VERSION(); > > +---+ > > | VERSION() | >

How to limit database size under Windows?

2005-02-05 Thread Salama hussein
I need to limit my users' databases size. In Linux, you can control the folder size but I can't do this under Windows unless I use expensive third party quota manager programs. Is there any way to limit the database size? I find this feature seriously lacking. Salama -- MySQL General Mailing

upgrading from 4.1.8 to 4.1.9

2005-02-05 Thread Shaun T. Erickson
I'd like to upgrade my RHEL ES v3 u4 server from MySQL 4.1.8 to 4.1.9. It's using rpms from the MySQL site, and the new ones will be from there as well. Assuming I shut down MySQL and any apps that use it, is it as simple as upgrading the rpms? Will the apps be affected by the change? -ste

Compiling MySQL from source

2005-02-05 Thread Helena Carlsson
Hi all, I have downloaded MySQL 4.1 source code and compiled under windows with MS Visual Studio .NET 2002, everything seems to be OK, but the file "mysqld" is not created. When I open a project which name is "mysqld" it still doesn't create "mysqld" file with mass of errors. Does anybody know hot

Re: Barcode

2005-02-05 Thread Eldon Ziegler
A description of bar codes can be found at http://electronics.howstuffworks.com/upc.htm/printable At 05:36 am 2/5/2005, you wrote: Hello mysql, Scanned Barcodes I will be scanning barcodes and putting them into a innoDb table Does anybbody have knowledge re: the best columnType, length or

Re: Barcode

2005-02-05 Thread Mike Wexler
Arthur Maloney wrote: Hello mysql, Scanned Barcodes I will be scanning barcodes and putting them into a innoDb table Does anybbody have knowledge re: the best columnType, length or other properties etc Generally bar codes contain text or numbers and have specific length limitations. Depend

Barcode

2005-02-05 Thread Arthur Maloney
Hello mysql, Scanned Barcodes I will be scanning barcodes and putting them into a innoDb table Does anybbody have knowledge re: the best columnType, length or other properties etc -- Best regards, Arthur mailto:[EMAIL PROTECTED] -- MySQL General Mailing Li

No more room in index file (136) - but index is not full?

2005-02-05 Thread Jon Ribbens
I am getting Error 136 "No more room in index file" on a table, but the table does not appear to be full in any way. As you can see from the "myisamchk -dv" output below, both the datafile length and the keyfile length are much smaller than their respective maximums. The table is on a Linux ext3 pa

Hierarchial Data Structure

2005-02-05 Thread Auyon Bhattacharya
I am new to this. I have been trying to implement a hierarchial data structure in Mysql 5.0, on Windows NT with PHP. Can anyone tell me if I wish to retrieve an information such as the list of fore-fathers from a family tree how do I go about it in MySQL. I think MySQL still do not have support for