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 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

CPU Usage and MySQL...

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

Re: Newbie Table question

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 syntax

Re: CPU Usage and MySQL...

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 what

RE: CPU Usage and MySQL...

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,

uniques, keys, etc?

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

Dump FK

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

Re: Master/Master Replication

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...

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

Re[2]: Dump FK

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 only

Re: Master/Master Replication

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

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

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

Re: NewbieALERT - Question/problem

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')

Re: uniques, keys, etc?

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

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

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 is