Re: Newbie Table question

2003-08-31 Thread Eternal Designs, Inc
To copy table A to table B(non-existent) use this command: CREATE TABLE B SELECT * FROM A; Note. If your two tables are from different databases the syntax is still the same. For instance if table A is in database Da and table B is in database Db then use the MySQL command: CREATE TABLE Db.B S

CPU Usage and MySQL...

2003-08-31 Thread jkelty
Hello, I have a strange problem with my mysql server. The mysql process seems to be using between 60 and 70 percent of the CPU at all times. Even when it is seemingly idle (not active queries). I'm not sure what to look for to see what it is doing other than truss'ing the process (I'm running i

Re: Newbie Table question

2003-08-31 Thread Matt W
Hi, - Original Message - From: "Eternal Designs, Inc" Sent: Saturday, August 30, 2003 9:46 PM Subject: Re: Newbie Table question > To copy table A to table B(non-existent) use this command: > > CREATE TABLE B SELECT * FROM A; > > Note. If your two tables are from different databases the

Re: CPU Usage and MySQL...

2003-08-31 Thread K Old
On Sat, 2003-08-30 at 23:18, [EMAIL PROTECTED] wrote: > Hello, > > I have a strange problem with my mysql server. The mysql process seems to be > using between 60 and 70 percent of the CPU at all times. Even when it is > seemingly idle (not active queries). I'm not sure what to look for to see w

RE: CPU Usage and MySQL...

2003-08-31 Thread electroteque
yes mytop is very wicked it helps monitor the queries and gives you benchmarks -Original Message- From: K Old [mailto:[EMAIL PROTECTED] Sent: Sunday, August 31, 2003 2:02 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: CPU Usage and MySQL... On Sat, 2003-08-30 at 23:18, [EMAI

uniques, keys, etc?

2003-08-31 Thread Joseph
I have a table I use to keep track of referred users on my top list. Below you will find the four columns in my table. What I need to do is keep entries (rows) unique based on the linkid, ipaddress, and the clicktype so that a user is not counted twice if they enter my site. Can someone tell me wha

Dump FK

2003-08-31 Thread Javier
Hi I've a DB using InnoDB tables and FK. If dump DB and try to import the resulting text file I receive many errors because at import time mysql try to import tables that have FK on tables not yet imported. How could I dump/import telling MySQL to order dump tables having in mine FK to avoid err

Re: Master/Master Replication

2003-08-31 Thread Douglas Granzow
I think the message they were trying to convey in the answer is "two-way replication will result in data corruption and therefore should not be used." Consider a table with an AUTO_INCREMENT id field. If two different inserts are done simultaneously, one on each master, both will get the same id

Re: CPU Usage and MySQL...

2003-08-31 Thread Albert
Can this tool be used on Windows and if so what version do I need to DL and does it need anything else besides the software (e.g. Perl - which I see listed for the nix versions. Thanks Albert - Original Message - From: "K Old" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL P

Re[2]: Dump FK

2003-08-31 Thread Javier
On 01/09/2003 at 1:01 Chris Nolan wrote: >Hi! > >If you have a look at the documentation at www.innobase.com, you'll find >somewhere it mentions a few directives that you can use to turn off FK >checking for a temporary period. The solution to your problem is there. > Thanks for your reply. I o

Re: Master/Master Replication

2003-08-31 Thread Owen Scott Medd
Well, not logically valid in the general sense (in that naive master-master replication can be self-destructive) but can be extremely useful when utilized knowing all the limitations and potential pitfalls. On Sun, 2003-08-31 at 10:01, Douglas Granzow wrote: > I think the message they were trying

About "AUTOCOMMIT" Variable

2003-08-31 Thread ÜÇGÜN
Hi Friends, I have a problem with "AUTOCOMMIT" Variable.I'm using release 4.0.14.When I change default-character-set variable to "latin5" I can't execute "SET AUTOCOMMIT = 1 | 0" command.It returns "SQL Error:Variable AUTOCOMMIT does not exist" error. How can I solve this problem.I'm waiting your

NewbieALERT - Question/problem

2003-08-31 Thread Ryan A
Hi, Am pretty new to mysqls power so kindly excuse if some of the questions are very basic. I have a table Cusomer_Data with 13 fields, (for the sake of simplicity lets call the fields 1 to 13) I want add 5 more fields after the 13th one and add the default falues of 1,1,'no',1,'no' to all the ol

Re: NewbieALERT - Question/problem

2003-08-31 Thread Jeff Shapiro
You are looking for the ALTER TABLE statement. Here's a link to the manual page about it: http://www.mysql.com/doc/en/ALTER_TABLE.html Your command should be something like: ALTER TABLE Custumer_data ADD field14 tinyint DEFAULT 1, ADD field15 tinyint DEFAULT 1, ADD field16 enum('no', 'yes') DEF

Re: uniques, keys, etc?

2003-08-31 Thread Albert
I have a similar problem but not with the clicking but with filling out a survey that is captured in mysql, twice. Any help would be appreciated Albert - Original Message - From: "Joseph" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 31, 2003 2:07 AM Subject: uniques

Error 1133

2003-08-31 Thread Michael Burke
I get this error when trying to create grants for a user I know exists.Anyone know why this is happening?: mysql> grant all privileges on jpox.* to [EMAIL PROTECTED] identified by password 'password'; ERROR 1133: Can't find any matching row in the user table -- MySQL General Mailing List For

Re: Error 1133

2003-08-31 Thread Stefan Hinz
Michael, > I get this error when trying to create grants for a user I know > exists.Anyone know why this is happening?: mysql>> grant all privileges on jpox.* to [EMAIL PROTECTED] identified by > password 'password'; > ERROR 1133: Can't find any matching row in the user table The error number

how to select with a set type field

2003-08-31 Thread Jonathan Soons
Subject:how to select with a set type field I have a table 'organisms' with a field 'category' of type SET('birds','bees','flowers','trees'). A record could have none or more of these in that field. How do I select all records with both 'flowers' and 'trees'? I can "SELECT category,key FR