Re: Hybrid Environment

2007-07-25 Thread Borokov Smith
Hey John, It very much depends on what your users needs are. In my experience, there's an opensource alternative that integrates well with proprietary systems if needed for everything i can think off. I've been working solely on Linux for more than 3 years now. My laptop came with Vista

Re: error once backing up database

2007-07-19 Thread Borokov Smith
You cannot execute the grant command because you don't have permission to do so. The GRANT command allows you to set permissions on databases and tables, thereby giving access to possibly sensitive data. It is in no way a serious restriction, it is a very important security feature. If you

Re: off-topic unsubscribe concern

2007-07-07 Thread Borokov Smith
Check out your signature after posting. It has the unsubscribe link added. cheers, boro Ananda Kumar schreef: Me too, every once in two days i keep getting this UNSUBSRIBE emails. regards anandkl On 7/7/07, B. Keith Murphy [EMAIL PROTECTED] wrote: I have been having the same problems.

Re: database structure

2007-07-03 Thread Borokov Smith
Hey there again, I suggest you look up a tutorial about database normalisation. Good ones are often hard to find. In general, you give all tables that contain data you will be referencing in other tables a numeric id (INT(11) UNSIGNED) as primary key, and you use that key as the constraint.

Re: database structure

2007-07-02 Thread Borokov Smith
Or: Tag ShapeDimension (type enum('height', 'thickness', etc), value VARCHAR() or INT()) TagsShapeDimensions (FOREIGN KeY TAG, FOREIGN KEY ShapeDimension) 1 less table Greetz, boro Rajesh Mehrotra schreef: Hi, You can do this in four tables: 1. Tag 2. Shape (with an additional field,

Re: Select Last X rows

2007-06-30 Thread Borokov Smith
Rich schreef: Hi folks. Just wanting to know the best way to grab the last 10 rows from a table. Looking twice to the db to see how many records there are will be outdated by the time the SELECT is done, so it's moot. This is a fast moving db with records coming and going. Instead of

Re: Can't Bind to Port

2007-03-02 Thread Borokov Smith
netstat -nlp | grep 3306 greetz, boro Drew Jenkins wrote: Hi; I just installed MySQL from FreeBSD port. I specified using openssl. Outside of that, I changed nothing. I copied over the /etc/my.cnf as is, leaving the innodb stuff commented out. In preparing to install my database, I got this