Re: Lost root password, now losing sanity!!!!

temi odurinde ([EMAIL PROTECTED]) writes: > Chris + All, > Thanks for your postings. God knows why but I still cannot login to MySQL, I could >not kill and start MySQL in safe mode as suggested. (I come from a Windoz background. >I am a total newbies Unix/command line stuff) but I found instruc

Re: Hot Backups

On Wed, Aug 29, 2001 at 12:50:06PM -0600, Matthew Walker wrote: > > What's the best way of doing a hot backup on a database? Our server > is set up in such a way that it's not a simple matter to shut down > apache/mysql and do the backup then. So, is it safe to just copy the > mysql directories, o

Re: Changing auto_increment field in mysql to start at 1000

How about updating all the fields instead of one? UPDATE customers SET row_id=row_id+1000; Regards, Sebastiaan J.A. Kamp VOF Post Zero Hoogstraat 98a 3011PT Rotterdam The Netherlands - Original Message - From: "Armando Cerna" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesda

Lost root password, now losing sanity!!!!

Chris + All, Thanks for your postings. God knows why but I still cannot login to MySQL, I could not kill and start MySQL in safe mode as suggested. (I come from a Windoz background. I am a total newbies Unix/command line stuff) but I found instructions on how to uninstall MySQL which I did succ

Re: MS Access --> mySQL INNER JOIN

On Wed, Aug 29, 2001 at 10:01:23PM -0600, s. keeling wrote: > On Thu, Aug 30, 2001 at 12:21:28AM +0100, Kemal Danisman wrote: > > > > Some people say translate INNER JOINS from Access to WHERE clauses, some say > > Personally, I'd say drop Access and all references to it, and begin > redesign us

Re: Couldn't Drop database

[EMAIL PROTECTED] wrote: > > After I've dropped the database using mysqladmin, the > following message appeared: > > %mysqladmin drop databasename > Dropping the database is potentially a very bad thing to do. > Any data stored in the

Couldn't Drop database

After I've dropped the database using mysqladmin, the following message appeared: %mysqladmin drop databasename Dropping the database is potentially a very bad thing to do. Any data stored in the database will be destroyed. Do you real

How To Change Database Location ?

With MySQL is there a way that you can create a database from the default location, which at the moment on my Linux install is: '/var/lib/mysql/my_database' ? Pete - Before posting, please check: http://www.mysql.com/manual

Re: Database Disappeared

In the last episode (Aug 29), Gary Huntress said: > I've grepped my log for clues. It only goes back a few days as I > truncate it at about a GB. Have your mysql logs rotated by your favorite logfile rotater, and make sure your nightly backup routine grabs them. That way you have logs as f

Re: Database Disappeared

On Wed, Aug 29, 2001 at 11:39:22PM -0400, Gary Huntress wrote: > > I run a mysql host that currently has about 5500 seperate mysql > databases. Yesterday one of my users reported to me that he couldn't > connect. I suspected many of the usual culprits (grants, network, wrong > [snip] > rul

Re: MS Access --> mySQL INNER JOIN

On Thu, Aug 30, 2001 at 12:21:28AM +0100, Kemal Danisman wrote: > > Some people say translate INNER JOINS from Access to WHERE clauses, some say Personally, I'd say drop Access and all references to it, and begin redesign using a sensible alternative which doesn't encourage the production of suc

Re: Database Disappeared

Gary Huntress wrote: > > Hi, > > I run a mysql host that currently has about 5500 seperate mysql > databases. Yesterday one of my users reported to me that he couldn't > connect. I suspected many of the usual culprits (grants, network, wrong > password etc) but I eventually came to find t

Database Disappeared

Hi, I run a mysql host that currently has about 5500 seperate mysql databases. Yesterday one of my users reported to me that he couldn't connect. I suspected many of the usual culprits (grants, network, wrong password etc) but I eventually came to find that the database is *gone* without a

Re: Adding Customer ID numbers to and already existing table

If v.3.23+, it's a one-step, along the lines of: ALTER TABLE tablename ADD columnname INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT = 1000 Prior to 3.23, it's a three-step: 1st, alter the table to include the key: ALTER TABLE tablename ADD columnname INT UNSIGNED NOT NULL PRIMARY KEY AUTO_I

MS Access --> mySQL INNER JOIN

I've read almost all of the messages relating to this but I'm stuck .. any advice gratefully received ! Thanks ... Some people say translate INNER JOINS from Access to WHERE clauses, some say to remove the nesting (delete brackets/parens) and re-write the INNER JOIN as an INNER JOIN in mySQL insi

Query Help

Hi, I need help with buliding a query from following two tables. TABLE biz | bizid| int(9) | | bizname | varchar(50)| | state| tinyint(2) | TABLE coupons | coupo

Adding Customer ID numbers to and already existing table

How would I add customer id numbers which start at 1000 to an already existing table. I need these numbers to auto_increment. Any help would be great Armando - Before posting, please check: http://www.mysql.com/manual.php

Re: mysqldump issues

daniel james wrote: > > I need to generate a tab-delimited text dump of table > data ONLY and have it output to a text file. I don't > want any table info, delimiters, etc. I need this to > copy/paste into a excel spreadsheet. What's the > syntax? > > I'm stuck here: Hi: What do you think ab

mysqldump issues

I need to generate a tab-delimited text dump of table data ONLY and have it output to a text file. I don't want any table info, delimiters, etc. I need this to copy/paste into a excel spreadsheet. What's the syntax? I'm stuck here: % mysqldump dbname tablename > ??? pleasepleaseplease help..!

RE: Error 12 from table handler

> I'am having this error code (Error 12 from table handler) when i am trying > to create an index on a table that has about 20 records (it's > not a big table)... > What does this error code means?. chris@illusion:~$ perror 12 Error code 12: Cannot allocate memory chris@illusion:~$ -

Re: myisampack dumps core on some tables

On Wednesday 29 August 2001 15:14, Martin MOKREJ? wrote: > >Description: > I have on Linux running 3.23.41 the following problem: > > $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp /data/mysql/Aactinomycetemcomitans/blimps.MYI > Compressing /data/mysql/Aactinomycetemcomitans/blimps.M

Re: Licensing terms for an Intranet site

>If I'm using MySQL for an intranet site within my corporation, is there any >licensing required? John, we're in the same kind of situation here, (I'm using MySQL as part of something that I'm delivering to another part of the business for their internal use). AFAIK the position is that if you

RE: Licensing terms for an Intranet site

Also in the manual - "If your use of MySQL does not require a license, but you like MySQL and want to encourage further development, you are certainly welcome to purchase a license or MySQL support anyway." "We feel that if MySQL helps your business, it is reasonable to ask that you help MySQL.

Re: Problem In Alter Table

In the last episode (Aug 29), abhishek sahay said: > mysql> alter table pod_rating change 'Cable Planet' cable_plant varchar(15); > ERROR 1064: You have an error in your SQL syntax near ''Cable Planet' cable_plant >varchar(15)' at line 1 I believe you need to use backtics ` ` to put spaces in fi

Query Help

Hi, I need help with buliding a query from following two tables. TABLE biz | bizid| int(9) | | bizname | varchar(50)| | state| tinyint(2) | TABLE coupons | coupo

RE: Licensing terms for an Intranet site

Mike, John; What mike is saying below seems quite true: > "For normal internal use, MySQL costs nothing. You do not have to pay us > (them) if you do not want to." That being said, Caldera PS has fielded clients who specifically ask for MySQL; we also use a MySQL database on UnixWare as a repos

Re: Changing auto_increment field in mysql to start at 1000

Armando Cerna writes: > update customers set row_id='1000' where row_id='1'; > > but that only changed the one field in the table and the other ones stayed > the same =(. Yes, that's the expected behavior when updating one field. Anything else would be a disaster. If what you're trying to d

RE: Newbie question

Sorry don't think it is I will give that a try. -Original Message- From: Gabriel Carbone [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:57 PM To: 'Tom Hicks'; '[EMAIL PROTECTED]' Subject: RE: Newbie question Is php compiled with the mysql option? -Mensaje original

Problem In Alter Table

STEP 1: status ->SUCCESS --- mysql> CREATE TABLE pod_rating select h.he_headend_id 'Cable Plant',sk.tf_air_date,d.em_dma DMA,d.em_tv_households 'Households TVs',d.em_us_percent Population,p.tf_title 'Program Name',sk.tf_air_time Time,st.tf_station_call_sign Network from prog_rec p,stat_rec

myisampack dumps core on some tables

>Description: I have on Linux running 3.23.41 the following problem: $ /usr/local/mysql/bin/myisampack -v -v -f --tmpdir=/tmp /data/mysql/Aactinomycetemcomitans/blimps.MYI Compressing /data/mysql/Aactinomycetemcomitans/blimps.MYD: (1443 records) - Calculating statistics normal: 7 empty-

USE UPDATE and root password

> Also remember to set your root password! Check the manual for this as well. Yeah, right... That's easier said than done! I'm still chasing my tail from using the erroneous commands the install said to use. Speaking of which, someone thankfully told me to do a USE mysql before using the UPDAT

Error 12 from table handler

hi guys: I'am having this error code (Error 12 from table handler) when i am trying to create an index on a table that has about 20 records (it's not a big table)... What does this error code means?. Yours Faithfully. Pablo Fraga (MIS). e-mail: [EMAIL PROTECTED] - [EMAIL PROTECTED] icq: 113

Entering data through access

I attempted to enter data into a msyql database using Access 2000. I type in data into a field, hit enter and the data is replaced with "#Deleted". If I close out the table and open it back up again in Access, the data that I typed is there. So the data gets entered correctly. Anyone know how

Re: MERGE TABLES

Hi! On Aug 29, Johnny Withers wrote: > I'm not sure if this is a bug or if this is the way MERGE TABLES works > in MySQL. > > It seems that if I have an INDEX in a field (id for instance), and I try > to > SELECT using a WHERE id=NUMBER, it will fail, even though that NUMBER is > a > valid id. I

Changing auto_increment field in mysql to start at 1000

I tried this: update customers set row_id='1000' where row_id='1'; but that only changed the one field in the table and the other ones stayed the same =(. Could someone please tell me the correct way to do this Armando -

Alter table Query

STEP 1: status ->SUCCESS --- mysql> CREATE TABLE pod_rating select h.he_headend_id 'Cable Plant',sk.tf_air_date,d.em_dma DMA,d.em_tv_households 'Households TVs',d.em_us_percent Population,p.tf_title 'Program Name',sk.tf_air_time Time,st.tf_station_call_sign Network from prog_rec p,stat_rec

RE: Newbie question

Is php compiled with the mysql option? -Mensaje original- De: Tom Hicks [mailto:[EMAIL PROTECTED]] Enviado el: Wednesday, August 29, 2001 13:43 Para: '[EMAIL PROTECTED]' Asunto: Newbie question I have put a new web server and would like to put a board on it. But when I try to I get an

Re: Newbie question

Tom Hicks <[EMAIL PROTECTED]> writes: > I have put a new web server and would like to put a board on it. But when I > try to I get an error. I know it is a sql error. On the install I did the > configure with apache but I got a few errors. Not sure if I did it right. > Well at this point I need i

mysqld as root

Wasn't there something awhile back that was supposed to prevent running the daemon as root? When the daemon was started through safe_mysqld it would tell you to select a user as root you had to use --user=root, this seems to be gone! from the manual: F.2.26 Changes in release 3.23.15  To start

Newbie question

I have put a new web server and would like to put a board on it. But when I try to I get an error. I know it is a sql error. On the install I did the configure with apache but I got a few errors. Not sure if I did it right. Well at this point I need it configured for PHP4 and MySql. PHP4 is workin

RE: discussion: mysql licensing issue and funding issues

> I would like to comment on the following mysql.com question > > "We have made our product available at zero price under the GNU > General Public Licence (GPL), and we also sell it under a commercial > licence to those who do not wish to be bound by the terms of the GPL." > > Out of curiosit

RE: Licensing terms for an Intranet site

"For normal internal use, MySQL costs nothing. You do not have to pay us (them) if you do not want to." -Original Message- From: John Meyer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 5:18 PM To: [EMAIL PROTECTED] Subject: Licensing terms for an Intranet site If I'm usin

Re: Licensing terms for an Intranet site

On Wed, Aug 29, 2001 at 02:17:56PM -0700, John Meyer wrote: > If I'm using MySQL for an intranet site within my corporation, is > there any licensing required? Nope. -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408

Licensing terms for an Intranet site

If I'm using MySQL for an intranet site within my corporation, is there any licensing required? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar

MERGE TABLES

I'm not sure if this is a bug or if this is the way MERGE TABLES works in MySQL. It seems that if I have an INDEX in a field (id for instance), and I try to SELECT using a WHERE id=NUMBER, it will fail, even though that NUMBER is a valid id. ID is an int unsigned field with a key on it. However,

RE: Setting User Privileges ? Confused !!

I have the same problem and have looked all over for the solution. You have to delete the anonymous user from which table? I would assume the users table? -Original Message- From: Roman Festchook [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 10:05 To: Peter Moscatt; MySQL

Re: New kid on the block ...

Hi, We have developped commercial windows application using a software called DataEase. We need a more professional development system and are presently researching such a product. I checked the MySQL manual and the field types needed are supported. Our basic question is whether or not MySQL can

Re: discussion: mysql licensing issue and funding issues

Neil Zanella <[EMAIL PROTECTED]> writes: > I would like to comment on the following mysql.com question > > "We have made our product available at zero price under the GNU > General Public Licence (GPL), and we also sell it under a commercial > licence to those who do not wish to be bound by t

discussion: mysql licensing issue and funding issues

I would like to comment on the following mysql.com question "We have made our product available at zero price under the GNU General Public Licence (GPL), and we also sell it under a commercial licence to those who do not wish to be bound by the terms of the GPL." Out of curiosity, how does t

RE: cannot get mysqld to start

HMM. Now I dont know why I always failed to get mysql up with the 'right' command... I am looking into setting my root password right now But please tell me if I am doing something wrong by running just safe_mysqld instead of with the parameters... Thanks, Sheena. -Original Message-

Re: cannot get mysqld to start

Quoteth the install guide: shell> cd mysql_installation_directory shell> ./bin/mysql_install_db shell> ./bin/safe_mysqld --user=mysql & This is always the way to start a fresh mysql install. Note that safe_mysqld gets the --user arg ( and is run in the background with & ). Also remember to set y

RE: Hot Backups

First of all, I'd like to point to the documentation =] http://www.mysql.com/doc/B/a/Backup.html The other option not mentioned there but that another list member suggested is the best way to backup a live database. The above two methods work, but with larger databases, having the tables locked

RE: Hot Backups

I've tried using mysqldump, and it doesn't seem to be working on our computer. A little more info on our setup is in order, I think. We're running on Iserver, and have a virtual BSD machine. Most of the binaries are in the 'true' machine's folders, and a few are in our virtual machine's folders.

RE: Group by

On 29-Aug-2001 Morten Søndergaard wrote: > i have a tabel whit 5 min counting > > Id CntDateTime Cnt1 > 1 2001-08-01 00:05:0012 > 2 2001-08-01 00:10:0011 > 3 2001-08-01 00:15:0010 > 4 2001-08-01 00:20:000 > 5 2001-08-01 00:25:006 > 6 2001-08-01 00:30:0014

Re: Hot Backups

Didn't read your last item before I fired my last message off. If mysqldump locks the table before it dumps then it is interupting service. If I have a high number of transactions they're blocked until the lock is released. Dave On Wed, Aug 29, 2001 at 10:52:26AM -0800, Joshua J. Kugler wrote: >

Re: Hot Backups

Any problems with data inconsistencies? Dave On Wed, Aug 29, 2001 at 10:52:26AM -0800, Joshua J. Kugler wrote: > I'm doing a mysqldump and then backing up the resulting text file. Works > fine, doesn't interupt anything, and doesn't have any problems with a live > server. IIRC, mysqldump lock

Re: Hot Backups

I'm doing a mysqldump and then backing up the resulting text file. Works fine, doesn't interupt anything, and doesn't have any problems with a live server. IIRC, mysqldump locks a table before it dumps, so there won't be any funny records. Or course, mysqldump could catch the database in the

Re: SQL Problem

SELECT (t1.cnt1 + t2.cnt3 - t3.cnt11) FROM table t1, table t2, table t3 WHERE t1.ColPoint=1 AND t2.ColPoint=5 AND t3.ColPoint=2 AND t1.id=1 AND t2.id=t1.id AND t3.id=t1.id Of course, self joins can be expensive, this grows in complexity as you need to add/subtract more counts ,and this is not ge

Re: Hot Backups

The way I am planning on doing it is setting up another server that I replicated to and backing that server up. I would like to hear how other people are backing up servers without interupting service. Dave On Wed, Aug 29, 2001 at 12:50:06PM -0600, Matthew Walker wrote: > What's the best way of

Hot Backups

What's the best way of doing a hot backup on a database? Our server is set up in such a way that it's not a simple matter to shut down apache/mysql and do the backup then. So, is it safe to just copy the mysql directories, or is there some recommended procedure for this? Matthew Walker System Adm

RE: cannot get mysqld to start

Dana, Thanks for looking into this further. I did all that, and ran the command mysql_install_db instead of mysql_install_db --user=mysql & as they said in the install guide! I have no clue of the difference between the two and reason why it should work on one and not on another. Would apprec

RE: RE: Use of the MySQL logo - licensing agreement

At 16:10 29-8-01 +0100, Andrew Murphy wrote: >Why not get MySQL to make a series of slightly different logos you can >choose from like Sun and other companies do. Some are colour, others >greyscale, and some are inverse for placement on black backgrounds. It would still violate their trademark ca

Group by

i have a tabel whit 5 min counting Id CntDateTime Cnt1 1 2001-08-01 00:05:0012 2 2001-08-01 00:10:0011 3 2001-08-01 00:15:0010 4 2001-08-01 00:20:000 5 2001-08-01 00:25:006 6 2001-08-01 00:30:0014 7 2001-08-01 00:35:0011 . . What i want is to make a Se

SQL Problem

i have a MySQL DB whit this tabel: Id ColPoint CntDateTime Cnt1 Cnt2 Cntx. Cnt32 11 2001-08-01 00:05:0012 14 21 2001-08-01 00:10:0011 12 31 2001-08-01 00:15:00109 41 2001-08-01 00:20:000

Re: multiple PRI indexes

He may mean a composite primary key, which is a primary key based on two columns. On whether this is a good idea or not it's really a question of whether you want to use natural or surrogate keys on your tables. A composite key is typically a natural key. A natural key is a key with information

Re: Use of the MySQL logo - licensing agreement

Sinisa Milivojevic wrote: > > Gerald Jensen writes: > > Sinisa: > > > > I'm not looking for anything to be cleared out (as in removed). > > > > My point, and I believe Ed's point, is that I'm not clear on use of the > > MySQL logo in my software, printed material, etc. > > > > Gerry > > > > You

Re: [MySQL] Problems getting into MySQL.com

it's up again. with a content management system. nice work, guys. it was down for a good cause, after all... great! new site ;) rds mau - Original Message - From: "Sica, Bill" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 2:29 PM Subject: RE: [MySQL] Proble

RE: [MySQL] Problems getting into MySQL.com

Name:www.mysql.com Address: 64.28.67.70 at least according to my NSlookup.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 29, 2001 1:22 PM To: [EMAIL PROTECTED]; Philip Daggett Cc: [EMAIL PROTECTED] Subject: Re: [MySQL] Problems getti

Re: [MySQL] Problems getting into MySQL.com

seems like a dns problem... anybody knows mysql.com's ip? - Original Message - From: "Ashley M. Kirchner" <[EMAIL PROTECTED]> To: "Philip Daggett" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 2:54 PM Subject: Re: [MySQL] Problems getting into MySQL.com >

Re: Primary Key pairs and auto-incrementing

At 10:37 AM -0400 8/29/01, Ferrara, Joseph C wrote: >I want to create a table with two Primary Keys. The first key is a category >field, and the second is auto-incremented. Example: Key 1=Chapter name, Key >2 =section number. For example, (Chapter1, 1) (Chapter1, 2) (Chapter1, 3) >then with a n

Re: multiple PRI indexes

At 10:33 AM -0500 8/29/01, shawn reed wrote: >is it generally recommended / a good idea to have more than one PRI index >in the same table? i've never seen that before until today while trying >to track down bugs in someone else's system and noticed a table with 2 PRI >indexes. will this cause a

Re: Problems getting into MySQL.com

yes, i just tried and failed - Original Message - From: "Philip Daggett" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, August 29, 2001 9:50 AM Subject: Problems getting into MySQL.com > Is anybody else not able to get onto mysql.com??? > > > --

Re: Problems getting into MySQL.com

Philip Daggett writes: > Is anybody else not able to get onto mysql.com??? Hi, We're working on it. The eth card seems to have bombed, and the admins at our hosting facility (andover, where slashdot and freshmeat are) are working on it ASAP. Matt -- For technical support contracts, visit

RE: Problems getting into MySQL.com

Seems dead from where I am in the UK, Was up earlier (3PM GMT). Strange -Original Message- From: Philip Daggett [mailto:[EMAIL PROTECTED]] Sent: 29 August 2001 17:51 To: [EMAIL PROTECTED] Subject: Problems getting into MySQL.com Is anybody else not able to get onto mysql.com???

Re: [MySQL] Problems getting into MySQL.com

Philip Daggett wrote: > Is anybody else not able to get onto mysql.com??? Looks like, it'd be down... -- W | I haven't lost my mind; it's backed up on tape somewhere. + Ashley M. Kirchner .

Problems getting into MySQL.com

Is anybody else not able to get onto mysql.com??? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL

Replication problems involving time

Am I the only one that thinks that mysql ought to replicate NOW, CURRENT_DATE, etc. as the time when those actual inserts happened not as NOW,CURRENT_DATE,etc. If you are replicating accross a distance (12,15,20 hops) and there is a connectivity problem, then you end up with data that is out of s

Re: Lost Root password

i don't know how your RaQ4 works, but on the Qube3 I had a time getting mySQL to shut down.. it did not show up in the list of processes running... ended up using "killall mysql", then restarted the mysql in "safe" mode.. issue a set password query to update root password, and you are on your way!

Re: im puzzled

I suspect he wants: SELECT users.uid FROM users LEFT JOIN picks ON users.uid = picks.user_id WHERE picks.user_id IS NULL Paul DuBois wrote: > At 10:36 AM -0400 8/29/01, Jeremy Morano wrote: > >> Hi , >> >> this is my query >> >> SELECT users.uid FROM users, picks WHERE users.uid = picks.user

RE: Primary Key pairs and auto-incrementing

> I want to create a table with two Primary Keys. The first key is > a category > field, and the second is auto-incremented. Example: Key > 1=Chapter name, Key > 2 =section number. For example, (Chapter1, 1) (Chapter1, 2) (Chapter1, 3) > then with a new Cheaper, I want to restart the auto-incre

RE: multiple PRI indexes

> is it generally recommended / a good idea to have more than one PRI index > in the same table? i've never seen that before until today while trying > to track down bugs in someone else's system and noticed a table with 2 PRI > indexes. will this cause any problems? It shouldn't cause any prob

Re: im puzzled

At 10:36 AM -0400 8/29/01, Jeremy Morano wrote: >Hi , > >this is my query > >SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id; > >this works correctly. The results are what they are supposed to be: >However, when I change the = sign to a <> or !=, The results are completely >inco

multiple PRI indexes

is it generally recommended / a good idea to have more than one PRI index in the same table? i've never seen that before until today while trying to track down bugs in someone else's system and noticed a table with 2 PRI indexes. will this cause any problems? tia. ~shawn

RE: RE: Use of the MySQL logo - licensing agreement

Why not get MySQL to make a series of slightly different logos you can choose from like Sun and other companies do. Some are colour, others greyscale, and some are inverse for placement on black backgrounds. Andrew Murphy -Original Message- From: Ed Carp [mailto:[EMAIL PROTECTED]] Sent:

Re: im puzzled

And that is correct. You are getting each users.uid that doesn't match each picks.userid. Jeremy Morano wrote: > Hi , > > this is my query > > SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id; > > this works correctly. The results are what they are supposed to be: > However,

Problem running mysql_install_db

Platform: Solaris 2.6 SPARC I am attempting to install the binary distribution of MySQL on a Sun Netra 1120 running Solaris 2.6. The file I downloaded is: mysql-3.23.39-sparc-sun-solaris2.6.tar I used GNU tar to unpack the distribution. When I try running the script my_install_db, I get the f

Re: MySQL Web Site Changes

Philip Molter writes: > The new web site looks great and none of the old functionality has been > lost. > > Except ... > > On the documentation listing for one-page-per-chapter and one-big-page, > the keywords and commands, like 'SELECT' and 'GRANT' used to be in a > different color (purple in t

RE: Use of the MySQL logo - licensing agreement

Gerald Jensen writes: > Sinisa: > > I'm not looking for anything to be cleared out (as in removed). > > My point, and I believe Ed's point, is that I'm not clear on use of the > MySQL logo in my software, printed material, etc. > > Gerry > You are quite correct. This issue will be set straig

Re: Lost Root password

temi odurinde ([EMAIL PROTECTED]) writes: > Dear List, > I have lost the root password to my MySQL installation. What is the quickest way to >remedy this situation, uninstall and reinstall MySQL or what???. My installation >runs on a RaQ4 server. The quickest way is to RTFM :) The searchable

Re: Server overload problems

Catalin Tenita ([EMAIL PROTECTED]) writes: > Hi people, > > Can you tell me how to monitor the server load and the mysql processes for a > a normal user on a shared Linux sistem. For monitoring the machine itself, I usually use "top". For monitoring the database, I like "mysqladmin processlist

Primary Key pairs and auto-incrementing

I want to create a table with two Primary Keys. The first key is a category field, and the second is auto-incremented. Example: Key 1=Chapter name, Key 2 =section number. For example, (Chapter1, 1) (Chapter1, 2) (Chapter1, 3) then with a new Cheaper, I want to restart the auto-incremented field

RE: Join Problem

You could try using an AND in the WHERE statement. EG. SELECT DISTINCT R.ID, R.CatCode, R.Title FROM Recipes R, Ingredients I WHERE I.Description LIKE "%$SearchKey%" AND R.ID = I.ID; Hope this helps. Andrew Murphy -Original Message- From: Urb LeJeune [mailto:[EMAIL PRO

im puzzled

Hi , this is my query SELECT users.uid FROM users, picks WHERE users.uid = picks.user_id; this works correctly. The results are what they are supposed to be: However, when I change the = sign to a <> or !=, The results are completely incorrect. -- picks.user_i

Re: RE: Use of the MySQL logo - licensing agreement

B. van Ouwerkerk ([EMAIL PROTECTED]) writes: > Now.. what would you prefer.. many forks all using the same logo or that > they require you to ask for their permission. Actually, I'd prefer a bunch of derivitive logos, like before, so I could choose the best-looking database logo based on my web

Join Problem

I've been staring at the following query for a day. I'm sure it's something obvious but I just don't see it. There are two table, Recipes which contains one row per recipe. The second in Ingredients while holds one row per ingredient. The Ingredients table has a field containing t

Re: Setting User Privilges ? Confused !!

By default you have record for anonimous user with any name and no pass in your access tables, thats lock access any other user from localhost with password to database. Just delete this anonimous user from mysql access tables On Wed 29 Aug 2001 13:08, Peter Moscatt wrote: > I am pretty new to

RE: Use of the MySQL logo - licensing agreement

Unfortunately if they don't have something in place like this, then a company can come along and hijack the 'mySQL' name/logo for their own ends. A company has to make a sincere effort to protect its trademarks else it will fall into the public domain. Then a NuSpherish company can come along, use

RE: Use of the MySQL logo - licensing agreement

>Does that make any sense? I'm not trying to slam MySQL, I'm just concerned >about displaying the logo on a web site that says "powered by MySQL" or >modifying the logo like folks used to do to produce all kinds of cool >enhancements to the name MySQL. Did you try to get permission?? I'll bet i

RE: Use of the MySQL logo - licensing agreement

> My point, and I believe Ed's point, is that I'm not clear on use of the > MySQL logo in my software, printed material, etc. What concerns me is that the new logo licensing stuff is so restrictive, *anyone* who even displays the logo on a web site ("powered by MySQL") has to get WRITTEN PERMISSI

Server overload problems

Hi people, Can you tell me how to monitor the server load and the mysql processes for a a normal user on a shared Linux sistem. We've launched a new version of our BestJobs.ro site (more complex in sql queries than the last version) and it apperar that is crasching the machine, by overloading it

  1   2   >