No replicated data even though master log matches on slave

2003-01-22 Thread Krzysztof Karski
I am having very strange problems with the slave not replicating master data but the slave’s log matches the master’s at all times. I am running mysql 4.0.9 on a Win XP Pro (Master) and Win XP Home (Slave). Here is my procedure for setting up the replication: Initially both the master and

AW: Socket Error

2003-01-22 Thread Franz, Fa. PostDirekt MA
Good Morning Anthony , your question was: ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (38) I've been reading and searching the documentation for hours and I know this is simple to fix but I can't figure it out. I've been at it for our hours. The

Re: Which is the difference?

2003-01-22 Thread Stefan Hinz, iConnect \(Berlin\)
Octavian, seems like LAST_INSERT_ID() will not always return the correct value. If you use ANSI-SQL INSERT, the function works fine. If you use MySQL extended INSERT (i.e. with more than one record per insert statement), the function will return the ID of the _first_ record inserted with an

Re: 4.1 features

2003-01-22 Thread Stefan Hinz, iConnect \(Berlin\)
Daniel, you can find a list of the new features here: http://www.mysql.com/doc/en/News-4.1.x.html Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 -

Re: Table joins are slow things to deal with. . .

2003-01-22 Thread Stefan Hinz, iConnect \(Berlin\)
Steve, ([Defendant] Query WITH a join - 8.79 seconds! EXPLAIN SELECT Defendants.CaseNumber FROM Defendants, Cases WHERE Cases.CaseNumber = Defendants.CaseNumber AND Filed = 1999-01-01 AND (Defendant LIKE owen% OR Defendant LIKE pitts% OR Defendant LIKE general%); First thing that comes into

Re: Indian Languages Support

2003-01-22 Thread Stefan Hinz, iConnect \(Berlin\)
Dear Velmani, what do you mean with Indian? AFAIK there are 36 languages spoken in India. Do you mean English? ;-) Regards, -- Stefan Hinz [EMAIL PROTECTED] Geschäftsführer / CEO iConnect GmbH http://iConnect.de Heesestr. 6, 12169 Berlin (Germany) Tel: +49 30 7970948-0 Fax: +49 30

Re: Indian Languages Support

2003-01-22 Thread N-Velmani
Dear Stefan, I'm trying to build a multilingual website for Indian languages. For this, I wanted to store my strings in Hindi and Tamil, in mysql. Now, could u tell me how can i achieve this? Thanks in advance, Regards, N.Velmani On Wed, 22 Jan 2003, Stefan Hinz, iConnect (Berlin) wrote:

Re: Joins are slow

2003-01-22 Thread Martin Waite
On Wed, 2003-01-22 at 03:18, Steve Quezadas wrote: ([Defendant] Query WITH a join - 8.79 seconds! EXPLAIN SELECT Defendants.CaseNumber FROM Defendants, Cases WHERE Cases.CaseNumber = Defendants.CaseNumber AND Filed = 1999-01-01 AND (Defendant LIKE owen% OR Defendant LIKE pitts% OR

Access denied database privilege question

2003-01-22 Thread David Bordas
Hi list, I've a question about the database privilege and the Mysql.db table. If i do something like this : GRANT SELECT ON MYDB.* TO [EMAIL PROTECTED]; ( i'm using MyISAM tables ... ) And if MYDB contains something like 100 tables, could this make me problems ? In fact, i have errors like this

Re: Question - Query

2003-01-22 Thread Terence Ng
First of all, thanks for your help. I have discovered that the result from: SELECT bank, SUM(unit_price_us * order_cbm) FROM lcopen GROUP BY bank; is different to the query you provided (row OPEN). How can I solve it? Terence Ng --- [EMAIL PROTECTED] wrote: Hello Terence, I posted this

Need Help

2003-01-22 Thread Haydar KOCAK
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [1]+ Exit 1 ./bin/mysqld_safe --user=mysql - Before posting, please check: http://www.mysql.com/manual.php

Designing Categories

2003-01-22 Thread Will K.
Greets Folks, I cant tell if this is a dumb question or not, so please bear with me if it is... But here goes... You know how when you visit a website and they have Categories, like in an online store or maybe an auction sites... or maybe categories would be used in a bulletin board system for

Re: mysql Digest 22 Jan 2003 08:37:14 -0000 Issue 2280

2003-01-22 Thread Clemente
I guess you just need to take the rows from the people table, not from the epeople table, and put the condition about the event id in the join, not the main where. Like so: select people.id, concat(lastname, , , firstname) as name from people left join epeople on epeople.pid=people.id

re: Re: Indian Languages Support

2003-01-22 Thread Egor Egorov
On Wednesday 22 January 2003 11:37, N-Velmani wrote: I'm trying to build a multilingual website for Indian languages. For this, I wanted to store my strings in Hindi and Tamil, in mysql. Now, could u tell me how can i achieve this? MySQL doesn't support character sets for Tamil or Hindi.

re: create mysql user?? how

2003-01-22 Thread Egor Egorov
On Wednesday 22 January 2003 03:16, M A wrote: would someone please tell me how to create mysql user? and how to set the mysql root password? Please, check the following sections of the manual. There are a lot of info concerning your question:

re: Need Help

2003-01-22 Thread Victoria Reznichenko
On Wednesday 22 January 2003 12:10, Haydar KOCAK wrote: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [1]+ Exit 1 ./bin/mysqld_safe --user=mysql Check with ps ax | grep mysqld that MySQL server is running. -- For

Re: re: foreign key problem

2003-01-22 Thread Victoria Reznichenko
On Wednesday 22 January 2003 06:03, you wrote: Hi Victoria Even when I used InnoDB, it doesn't support foriegh key. It allows me to insert data into child table without being entered to parent table. Check that your both tables are InnoDB with SHOW TABLE STATUS command. Show me an example of

Re: resize InnoDB's log file

2003-01-22 Thread Heikki Tuuri
Ha-nyung, - Original Message - From: Chung Ha-nyung [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Wednesday, January 22, 2003 6:48 AM Subject: resize InnoDB's log file Currently I have three InnoDB log files, whose size is 256MB and main memory is 2GB. Since I use 1GB

Re: foreign key problem

2003-01-22 Thread Heikki Tuuri
Saju, - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Sent: Tuesday, January 21, 2003 4:27 PM Subject: re: foreign key problem On Tuesday 21 January 2003 09:56, Saju Pappachen wrote: In my MySQL I have 3 tables like this and I have

Re: AW: Socket Error

2003-01-22 Thread Zion Inc.
Hi Franz, I'm running OpenBSD 3.2. I installed it with pkg_add. Version 3.23.49. I try starting it with mysql_safe or mysql. It's trying to connect with this socket that doesn't exist. How do I create it? Thanks, Anthony. --- Franz, Fa. PostDirekt MA [EMAIL PROTECTED] wrote: Good Morning

Re: ReiserFS vs Ext3

2003-01-22 Thread Michael T. Babcock
Nicholas Gaugler wrote: said that ReiserFS handled large amounts of files much better than ext2 or ext, but what about a MySQL database situation with a very limited numbers of files. Such as 300, or less than 100 even? Is Reiser a better FS than ext3 for MySQL when you have a very limited

Re: Table joins are slow things to deal with. . .

2003-01-22 Thread Michael T. Babcock
Steve Quezadas wrote: PS Here is some information about my tables and indexes: Maybe I missed it, but where's the EXPLAIN on the JOIN query? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock

Re: Rank Amateur Back for More

2003-01-22 Thread Michael T. Babcock
Stephen Tiano wrote: Observation: I guess there's no way to just give myself a 'free pass' to be able to load data into any database. It appears I have to name a particular database right at the start. A database is a database; there is nothing _outside_ a database. If you load the mysql

RE: ReiserFS vs Ext3

2003-01-22 Thread David Brodbeck
-Original Message- From: Michael T. Babcock [mailto:[EMAIL PROTECTED]] I would E-mail the reiserfs list and ask for whether ReiserFS would be better for a MySQL-only partition than ext3 and see what answers you get. In the worst case, you'll have some extreme resierfs is

Re: AW: Socket Error

2003-01-22 Thread Zion Inc.
Here is what I got out of the log file: 030122 02:59:51 mysqld started 030122 2:59:51 Can't start server : Bind on unix socket: Address already in use 030122 2:59:51 Do you already have another mysqld server running on socket: /var/run/mysql/mysql.sock ? 030122 2:59:51 Aborting But mysqld

Issues with InnoDB Replication

2003-01-22 Thread Michael Merwitz
Perhaps I have mis-read the documentation, or I have not set my configuration options correctly: Any assistance much appreciated! I have two db servers, one set as a Master and one set as a Slave. Both are identically configured (RH7.3, MySQL-Max 3.23.54) to use InnoDB. However, there are

Re: Need help installing mysql - Thanks a lot

2003-01-22 Thread gerald_clark
What does mysqld.log say? Manuel Velasco wrote: I'm getting the following messages after running safe_mysqld (as root): leo:/usr/bin # ./safe_mysqld [1] 4798 leo:/usr/bin # Starting mysqld daemon with databases from /var/lib/mysql 030121 19:38:15 mysqld ended [1]+ Done

Socket error - help from gurus

2003-01-22 Thread Pedro Leite
Hi, I'm new to MySql and to this list. I'm confused and lost. I installed MySQL in a Mandrake box and with no problem at all, just followed the installation procedures. Then I created a database, tables etc. All just fine. Then I connected the database with a Domino application, again everything

Re: Problems: Configuring from source.

2003-01-22 Thread gerald_clark
You need gnu tar. Froin Laven wrote: Solaris 8 (sparc) gcc 3.2 Configuring from source version mysql-3.23.54a 2 problems: 1. I get a checksum error when untar'ing the tgz file found on any of the download servers. 2. config.status: error: cannot find input file: readline/Makefile.in The

mysqld getting signal 14

2003-01-22 Thread rick
Hi all- I'm running mysql 3.23.42 on multiple machines (Solars 8, 32 bit) and on a couple of the machines I see the following in the .err log: .. 030120 9:11:10 Warning: Got signal 14 from thread 4 030120 9:11:10 Warning: Got signal 14 from thread 4 030122 2:20:09 Warning: Got signal 14

Re: ReiserFS vs Ext3

2003-01-22 Thread Michael T. Babcock
David Brodbeck wrote: If Nicholas does this, I hope he'll report back here with what he finds out. I would recommend that as well. I'm facing the same choice very soon, for a database that will eventually have millions of entries (but each individual entry very small.) I'm trying to decide

RE: AW: Socket Error

2003-01-22 Thread Victor Pendleton
How are you starting the MySQL server? (e.g. command) What does you cnf file look like? -Original Message- From: Zion Inc. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 8:14 AM To: Franz, Fa. PostDirekt MA Cc: [EMAIL PROTECTED] Subject: Re: AW: Socket Error Here is what I

Unicode

2003-01-22 Thread Michelle de Beer
I noticed that in version 4.1, there would be support for sorting with unicode. I have a few questions regarding unicode in MySQL: 1) Is it used just like a regular Char-set? Will this work just the same? SELECT name FROM mytable WHERE name='michelle' SELECT name FROM mytable WHERE name='name

binary of MySQL 4.1 for windows already available somewhere?

2003-01-22 Thread Patrick Näf
Hello I'm working on my diploma - project (very big hyperdatabase for a big search engine). I need the new features of MySQL 4.1, but I don't have the time to compile all, because i must install all the tools and perhaps it is not so easy Does anyone have a running version of MySQL 4.1

Re: Fwd: MYsql won't run

2003-01-22 Thread miguel solórzano
At 14:09 21/01/2003 -0500, FlashGuy wrote: Well...I uninstalled mysql and installed it again and I still can't get the service to run!!!??? So, first try to start it with: mysqld-nt --standalone --console and verify what are the error messages printed. ==BEGIN FORWARDED

query cache not working with alter table rename as...

2003-01-22 Thread Andrew Braithwaite
Hi List, Anyone know what the problem is with the mysql query cache not flushing cache properly (see snip below)? Is this a bug or am I missing something here? I'm using Mysql Standard 4.0.9-gamma on Linux (x86, libc6) Any help would be appreciated, Cheers, Andrew -start

Re: Mandatory server downtime?

2003-01-22 Thread Michael T. Babcock
David T-G wrote: - do you have redundant networking to my machine, both to handle a failed switch and a backhoe accident? ... and do you have the ability to get such incidents repaired quickly ... our one upstream ISP had their entire fibre bundle torn out of the ground by a

Unicode

2003-01-22 Thread Michelle de Beer
I noticed that in version 4.1, there would be support for sorting with unicode. I have a few questions regarding unicode in MySQL: 1) Is it used just like a regular Char-set? 2) Will these querys work just the same? SELECT name FROM mytable WHERE name='michelle' SELECT name FROM mytable WHERE

Unicode

2003-01-22 Thread Michelle de Beer
I noticed that in version 4.1, there would be support for sorting with unicode. I have a few questions regarding unicode in MySQL: 1) Is it used just like a regular Char-set? 2) Will these querys work just the same? SELECT name FROM mytable WHERE name='michelle' SELECT name FROM mytable WHERE

RE: ReiserFS vs Ext3

2003-01-22 Thread Chung Ha-nyung
What about XFS? I'm considering using XFS instead of ext3 since it seems to be said that XFS is more stable and efficient than any other linux's journaling fs in the environment of large and not-so-many files. If it is true, I guess that XFS would be the best choice with InnoDB. -- Chung

Re: Socket error - help from gurus

2003-01-22 Thread gerald_clark
Pedro Leite wrote: Hi, I'm new to MySql and to this list. I'm confused and lost. I installed MySQL in a Mandrake box and with no problem at all, just followed the installation procedures. Then I created a database, tables etc. All just fine. Then I connected the database with a Domino

mysqldump questions

2003-01-22 Thread Glenn Ticket
I have 2 questions concerning mysqldump. 1) What grants does the user need to have to perform a dump: if I want to create a user which is only used to perform database dumps (in scripts), which priviliges does it need ? 2) I'm using innoDB tables to be able to use foreign keys. Unfortunatly

Re: AW: Socket Error

2003-01-22 Thread gerald_clark
Top does not show all processes. try: ps x | grep mysqld or ps -ef | grep mysqld Zion Inc. wrote: Here is what I got out of the log file: 030122 02:59:51 mysqld started 030122 2:59:51 Can't start server : Bind on unix socket: Address already in use 030122 2:59:51 Do you already have

Re: Issues with InnoDB Replication

2003-01-22 Thread Heikki Tuuri
Michael, a good point. SET FOREIGN_KEY_CHECKS is currently not replicated properly. I have to fix this by wrapping the SQL statement in the binlog inside SET FOREIGN_KEY_CHECKS=0; statement here SET FOREIGN_KEY_CHECKS=1; if thd-options OPTION_NO_FOREIGN_KEY_CHECKS is true for the connection.

Which is the upper limit?

2003-01-22 Thread Octavian Rasnita
Hi all, I've tried the repeat function for testing some tables, but it cannot create very big strings. Do you know which is its upper limit? I've tried the following query: mysql select length(repeat('abracadabra', 10)); +---+ |

Re: ReiserFS vs Ext3

2003-01-22 Thread Mary Edie Meredith
You might be interested in this presentation from Linux World Conference August, 2002, which gave a comparison of Linux Journaling file system types based on io tests run at the Open Source Development Lab: http://www.osdl.org/presentations/lwe-jgfs.pdf On Wed, 2003-01-22 at 07:01, Michael T.

Re:mysql: field type of double without scientific notation

2003-01-22 Thread Nasser Ossareh
You probably have created your table without specifying the format of the double... the following statement would be more appropriate to your expectation: mysql create table testTable (id int, val double(12, 9)); this will set the display width of the double to 12 and the number of digits

Can't seem to use a different datadir....

2003-01-22 Thread jweeks
Hi. Anyone know the trick to successfully using a different directory for database files? I've tried changing my.cnf and also using the command line option. When I run mysqld_safe it says it's using the new directory but then writes mysqld ended and quits. Mysql never comes up. I changed

Re: Unicode

2003-01-22 Thread Michael T. Babcock
Michelle de Beer wrote: 3) I read some of the things on unicode.org, but this is only the pros. Is there any cons for using unicode? When should I use it? If you do primarily english but want other language support, UTF-8 is _exactly_ the same as ASCII for the first 127 characters. If you

Re:Trying to update data in a table - getting an error

2003-01-22 Thread Nasser Ossareh
try 'substring' instead of 'substr'. -- Don [EMAIL PROTECTED] writes: Return-Path: [EMAIL PROTECTED] Received: from mx11.lax.untd.com (mx11.lax.untd.com [10.130.24.71]) by maildeliver04.nyc.untd.com with SMTP id AAA9C453SATSGSQA for [EMAIL PROTECTED] (sender [EMAIL

NOT NULL Fields

2003-01-22 Thread Valdir Stiebe Junior
Hi, Creating a table with a not null field, and then trying to insert it doesn't raise an error 'Column XXX cannot be null' Well, this was the steps (sql to bypass filter) i did: 1. create table TEST ( id_test integer, name varchar(50) not null ); 2. insert into TEST (id_test, name) values (1,

deleting records

2003-01-22 Thread Bill Rausch
Hi, I've inherited a busted database and need to clean it up. I can't figure out how to do something which seemingly should be simple. For example, I've got two tables: Table One id int primary key auto_increment not null ...other data Table Two id int primary key auto_increment not null

Re: Table joins are slow things to deal with. . .

2003-01-22 Thread Benjamin Pflugmann
Hello. On Wed 2003-01-22 at 09:13:20 +0100, [EMAIL PROTECTED] wrote: Steve, ([Defendant] Query WITH a join - 8.79 seconds! EXPLAIN SELECT Defendants.CaseNumber FROM Defendants, Cases WHERE Cases.CaseNumber = Defendants.CaseNumber AND Filed = 1999-01-01 AND (Defendant LIKE owen% OR

Re: Which is the difference?

2003-01-22 Thread Benjamin Pflugmann
Hello. On Tue 2003-01-21 at 18:52:06 +0200, [EMAIL PROTECTED] wrote: Hello all, I've tried the following sql queries: mysql create table a(id int unsigned not null auto_increment primary key, name text); Query OK, 0 rows affected (0.01 sec) mysql insert into a values(null, 'one'),

Left join returns records it shouldn't

2003-01-22 Thread gordon
Description: The following silly query (silly because it should return no records since it is impossible for a.type to have two different values simultaneously), returns two records when it should return none with the enclosed test data. select a.*, b.*

Re: Which is the difference?

2003-01-22 Thread Benjamin Pflugmann
Hello. On Wed 2003-01-22 at 08:53:23 +0100, [EMAIL PROTECTED] wrote: seems like LAST_INSERT_ID() will not always return the correct value. If you use ANSI-SQL INSERT, the function works fine. If you use MySQL extended INSERT (i.e. with more than one record per insert statement), the

RE: Joins are slow

2003-01-22 Thread Jennifer Goodie
Try a straight join with the cases table first. You have to play with your queries to get the best results. Creating a temporary, as you mentioned, table might be a very good option in this case, but you need to make sure that your programming takes into account that your page might be hit more

Re: Which is the difference?

2003-01-22 Thread Stefan Hinz, iConnect \(Berlin\)
Benjamin, Yes, that is the documented behaviour: http://www.mysql.com/doc/en/Miscellaneous_functions.html (If you insert many rows at the same time with an insert statement, LAST_INSERT_ID() returns the value for the first inserted row.) Gee, I just copied this sentence into my new (German)

FW: question about update sql

2003-01-22 Thread Norris, Joseph
-Original Message- From: Norris, Joseph Sent: Wednesday, January 22, 2003 10:56 AM To: Mysql_List (E-mail) Subject: question about update sql Hello, I have the following in my SQL: update call_center set call_center.who_for_id = activeemployees.hr_emp_no where call_center.who_for_id

Re: Optimizing Ext3 for MySQL

2003-01-22 Thread Michael T. Babcock
Steven Roussey wrote: Might also look at: vmstat 1 `vmstat 1` is my favorite instant-info server debugging tool. I wouldn't mind the same program for MySQL (where's that mytop author anyhow? j/k) Blocked processes (second column) is a very useful piece of info too. -- Michael T.

Re: three table join

2003-01-22 Thread Michael T. Babcock
Tab Alleman wrote: SELECT SomeStuff FROM Table1 AS T1 LEFT JOIN Table2 AS T2 ON T1.PK = T2.FK1 RIGHT JOIN Table3 AS T3 ON T2.FK2 = T3.PK WHERE T1.PK=999 Either right-join it or reverse the table order (because you're not asking for data from t1 that is like t2 that is like t3 that is like

solution for opposite of this join / join from this subselect

2003-01-22 Thread Josh L Bernardini
thanks to brent, bob and M wells for their contributions to this solution and to m especially who seems to have put in a lot of time and nailed it. This query returns a list of people not attending a particular event, given an events table, a people table, and a many-many epeople table between

Re: MySQL Secure Replication

2003-01-22 Thread Michael T. Babcock
Ivan Hoo wrote: how do you secure the replication link between the master and the slave using SSH. i understand that you can do that over mysql client and its server. pls enlighten me coz i m looking high and low for a solution on this issue. On the slave: ssh --local-forward(?)

Re: join from this subselect

2003-01-22 Thread Bill Easton
How about: select people.id ... from people left join epeople on epeople.pid=people.id and epeople.eid=2 where epeople.pid is null; The left join gives you: (1) rows for people who attended event 2, with epeople columns populated (2) rows for people who did not attend event

MySQL for Netware

2003-01-22 Thread Rupert van Zyl (Home)
Hi Guys, The recent launch of MySQL for Netware is ideal for our application ... We had to do some tests before switching to this version. We installed MySQL V4 on Netware. Have done speed-comparison tests on MySQL v/s Microsoft. For some reason; if we query a record on a non-indexed table,

Upgrading

2003-01-22 Thread yung
Greets, Newbie here. I was trying to upgrade my mysql, so what I did was stop mysql daemon, recompile it with the new package, and then start mysql again, however it doesn't seem to update the version of it. Any help would be appreciated. thanks for your time.

Re: Can't seem to use a different datadir....

2003-01-22 Thread Harmen Houtman
If you leave the parameter innodb_data_home_dir empty, you can specify absolute file paths in the parameter innodb_data_file_path: innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:988M;/disk2/ibdata2:50M:autoextend See http://www.mysql.com/doc/en/InnoDB_start.html Harmen.

Re: Can't seem to use a different datadir....

2003-01-22 Thread gerald_clark
Well, what does the log say? You did copy the mysql database into the new directory? [EMAIL PROTECTED] wrote: Hi. Anyone know the trick to successfully using a different directory for database files? I've tried changing my.cnf and also using the command line option. When I run mysqld_safe it

Re: Which is the upper limit?

2003-01-22 Thread gerald_clark
Wouldn't that be greater than the default maximum packet length of 1M? Octavian Rasnita wrote: Hi all, I've tried the repeat function for testing some tables, but it cannot create very big strings. Do you know which is its upper limit? I've tried the following query: mysql select

Re: Can't seem to use a different datadir....

2003-01-22 Thread Salam Baker Shanawa
If you haven't done this: run mysql_install_db to create the privilege tables db, host, user in mysql directory below the new directory. The script 'll create the test directories too. Regards Salam [EMAIL PROTECTED] wrote: Hi. Anyone know the trick to successfully using a different

remote database

2003-01-22 Thread Bob Lockie
I am trying to remotely connect to a MySQL database but I'm having problems so I tried this on the same machine as the database. It doesn't work when I give it -h but it works without. # mysql -h 10.0.0.5 -D visitor ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)

mysqlstat (WAS Re: Optimizing Ext3 for MySQL)

2003-01-22 Thread Jeremy Zawodny
On Wed, Jan 22, 2003 at 02:21:34PM -0500, Michael T. Babcock wrote: Steven Roussey wrote: Might also look at: vmstat 1 `vmstat 1` is my favorite instant-info server debugging tool. I wouldn't mind the same program for MySQL (where's that mytop author anyhow? j/k) Hmm. mytop

Installation woes

2003-01-22 Thread Zion Inc.
Not being able to solve my prior problem (Error 2002) I went ahead and removed mysql and reinstalled it. I'm running OpenBSD 3.2 Here is how it went: point# pkg_add mysql-server-3.23.49.tgz === Creating mysql group for MySQL === Creating mysql user for MySQL useradd: Warning: home directory

Re: MySQL Secure Replication

2003-01-22 Thread Jeremy Zawodny
On Wed, Jan 22, 2003 at 02:27:40PM -0500, Michael T. Babcock wrote: Ivan Hoo wrote: how do you secure the replication link between the master and the slave using SSH. i understand that you can do that over mysql client and its server. pls enlighten me coz i m looking high and low for a

Install on WIN2k

2003-01-22 Thread Norris, Joseph
Hello, I have been running mysql on windows 2000 for about 8 months. Now I have to install it on a new win2k box. I get everything installed and go to get into mysql and I am getting this error: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I remember this well but I don't

MySQL 3.23.54a crash when connect through TCP/IP, Help pls!

2003-01-22 Thread Yong Huang
I installed MySQL 3.23.54a from source on a AIX 5.1 powerpc. It works fine when I tried to connect as localhost through unix sock. However, everytime I tried to connect using TCP/IP (./bin/mysql -u root -h myhost -p), the Mysql server crashed and restarted (running safe_mysqld). The system

RE: mysqlstat (WAS Re: Optimizing Ext3 for MySQL)

2003-01-22 Thread Steven Roussey
Hmm. mytop 1.4 will have a feature that may help you 1.4? I'm still on 1.0. Guess I'm behind the curve. Jeremy, can you add something to protect against binary data coming across in a query and messing up the terminal window? Leave it running a while and all of a sudden it is a big mess. Yikes!

Re: Left join returns records it shouldn't

2003-01-22 Thread Bill Easton
The outer join part of the silly query should return (1) All pairs a,b for which (a.zone = b.zone ... and b.leftside != '') (2) A row for each a that is not used in (1), with null for the columns of b The where clause then narrows these down to elements of (2) with a.type = 'MX' No reason

Low Impact Security Exposure in MySQL Monitor

2003-01-22 Thread George Toft
Greetings, I have discovered an exposure in the history recall functionality of MySQL Monitor. When a user uses MySQL monitor authenticated as the database root user to issue commands, such as changing user passwords or database table creation, that history can be recalled by a database user of

help w join query

2003-01-22 Thread mike
Hello, I have these two tables, CREATE TABLE `items` ( `name` varchar(100) NOT NULL default '', `img` varchar(50) NOT NULL default '', `year` year(4) NOT NULL default '', `item_id` smallint(5) unsigned NOT NULL auto_increment, PRIMARY KEY (`item_id`) ) TYPE=MyISAM; CREATE TABLE

Transaction Support in mysql13.23.54

2003-01-22 Thread Nirmal Shah
hi, i have installed mysql3.23.54 on windows and have followed all instructions as required for using mysqld-max to have transaction support. i have created a table using TYPE=INNODB, but cannot use rollback on it. the error i get in my jsp is transactions not supported. please advice me on how i

Re: remote database

2003-01-22 Thread Bhavin Vyas
I think it's allowing 'root@localhost' but not '[EMAIL PROTECTED]'. Select * from user (in mysql db) will show you all the access privileges. Add '[EMAIL PROTECTED]' to that as a user. Bhavin. - Original Message - From: Bob Lockie [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED]

Re: Designing Categories

2003-01-22 Thread olinux
Check this and ask more if needed http://www.webreference.com/perl/xhoo/php1/ also might want to check out perlHoo based on your language preference http://www.webreference.com/perl/xhoo/ olinux --- Will K. [EMAIL PROTECTED] wrote: Greets Folks, I cant tell if this is a dumb question or

Re: mysqlstat (WAS Re: Optimizing Ext3 for MySQL)

2003-01-22 Thread Jeremy Zawodny
On Wed, Jan 22, 2003 at 06:06:51PM -0800, Steven Roussey wrote: Hmm. mytop 1.4 will have a feature that may help you 1.4? I'm still on 1.0. Guess I'm behind the curve. Well, 1.3 is sitting in my CVS tree. I just need to update the docs and changelog. I already have some patches pending

Re: remote database

2003-01-22 Thread rich allen
mysql -h10.0.0.5 -u[username] -Dvisitor -p[password] should get you in - hcir On Wednesday, January 22, 2003, at 01:07 PM, Bob Lockie wrote: I am trying to remotely connect to a MySQL database but I'm having problems so I tried this on the same machine as the database. It doesn't work when I

Re: remote database

2003-01-22 Thread Bob Lockie
On Wednesday, January 22, 2003, at 01:07 PM, Bob Lockie wrote: I am trying to remotely connect to a MySQL database but I'm having problems so I tried this on the same machine as the database. Thanks, to all who replied. I have it working. -- Sent from

RE: mysqlstat (WAS Re: Optimizing Ext3 for MySQL)

2003-01-22 Thread Steven Roussey
One of my favorite Borg quotes is: Crude but effective. :-) I like that. ;) This got me thinking again about a feature I'd like to see in mysqld. I'd like to add something like SQL_STATISTICS to SELECT/UPDATE/INSERT statements. The idea would be that if this keyword was used, then mysqld would

Aborted connections.../mysqladmin flush-hosts

2003-01-22 Thread Steven Roussey
Dear sql query, Since updating from 4.0.7 to 4.0.9 I have noticed mysqld having problems with connections from our webserver, eventually denying access until I issue a mysqladmin flush-hosts. Shutting down the server and restarting tends to work for a longer period of time. I can't say for sure

MySQL 4.0 + PHP 4

2003-01-22 Thread Joe Stump
Anyone out there have anything to share as to using PHP4+MySQL4. I've been hearing good things on the MySQL list about v4.0 and I'm thinking of upgrading, since I run a rather small server. Thanks! --Joe ps. PHP list responders please respond directly. I'm not currently subscribed. -- Joe

Re: [PHP] MySQL 4.0 + PHP 4

2003-01-22 Thread 1LT John W. Holmes
Anyone out there have anything to share as to using PHP4+MySQL4. I've been hearing good things on the MySQL list about v4.0 and I'm thinking of upgrading, since I run a rather small server. There's really no change from the PHP side. PHP just sends the data and receives something back The only

Re: [PHP] MySQL 4.0 + PHP 4

2003-01-22 Thread Georg Richter
On Wednesday 22 January 2003 18:52, 1LT John W. Holmes wrote: There's really no change from the PHP side. PHP just sends the data and receives something back The only change in PHP is that mysql_connect() now supports additional flags to connect over SSL. Nope, I only forgot to remove a

RE: [PHP] MySQL 4.0 + PHP 4

2003-01-22 Thread John W. Holmes
On Wednesday 22 January 2003 18:52, 1LT John W. Holmes wrote: There's really no change from the PHP side. PHP just sends the data and receives something back The only change in PHP is that mysql_connect() now supports additional flags to connect over SSL. Nope, I only forgot to remove