Replication OpenBSD <-> Linux is failing

Hi all, I have a master MySQL server running 3.23.49 on RedHat Linux 7.2 and want to setup a slave on OpenBSD 3.0 (both are i386 archs). So I took the source (3,23,49 as well), compiled natively and configured as a slave. The problem is, that I can't connect to the master: it always fails with:

ERROR 1030: Got error 127 from table handler

Can anyone shed some light on this? Have found that others have run into this (via Google) but no resolution and no hits at www.mysql.com. A count(*) query returns fine but trying to select the rows fails (see log snippet below). Regards, Bob mysql> select count(*) from event where s

RE: optimisation trouble

[snip] > How many records do you have in each table? And just how fast do you want > this query to be? 1.5 seconds may be optimal for a query this large. Perhaps > the only thing you could do at this point is beef up your server. Not that large, I got about 8.000 records in each table. I did p

Re: optimisation trouble

Hi Jay! Mon, 20 May 2002 07:45:00 -0500, tu as dit : > [snip] > I have just tried this, but it still takes 1.5sec to run the > select... :-( > [/snip] > Fabien, > How many records do you have in each table? And just how fast do you want > this query to be? 1.5 seconds may be optimal fo

Re: Join takes way too long. Query optimizing, or denormalizing?

I guess this is not an issue on the index. Explain select says it is using the index. So I assume, that I did just write down the join syntax wrong. MySQL is joining all 32000 records with the city table and then looks for the country code. So this looks ok to me. Maybe I should denormalize my dat

RE: password for databases

Hi look into GRANT on MySql Peter --- Excellence in internet and open source software --- Sunmaia www.sunmaia.net [EMAIL PROTECTED] tel. 0121-242-1473 --- >

RE: UPDATE question, SQL syntax, etc.

cheers for the responses. i'll have to find another way, but thanks. .b > -Original Message- > From: Nick Stuart [mailto:[EMAIL PROTECTED]] > Sent: 20 May 2002 13:46 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: UPDATE question, SQL syntax, etc. > > > There is no from cla

mysql@lists.mysql.com

>Description: >How-To-Repeat: >Fix: >Submitter-Id: >Originator:Sebastian F. Sanchez >Organization: >MySQL support: [none | licence | email support | extended email support ] >Synopsis: >Severity: >Priority: >Category: mysql >Class:

Re: UPDATE question, SQL syntax, etc.

There is no from clause in the update syntax. However, I'm not sure how you would update a tablethe way you are trying to. I'm sure it can be done, and your SQL looks correct besides the fromclause. Just take that out and see if what it says. -Nick > hi. i'm new to the list and have only been

MySQL new-bee...

Hi I have installed mysql server and client version using command. # rpm -i MySQL-3.23.49a-1.i386.rpm MySQL-client-3.23.49a-1.i386.rpm I am trying to change root password but i am not able to change it. # /usr/bin/mysqladmin -u root -p password new-password Enter password:

RE: optimisation trouble

[snip] I have just tried this, but it still takes 1.5sec to run the select... :-( [/snip] Fabien, How many records do you have in each table? And just how fast do you want this query to be? 1.5 seconds may be optimal for a query this large. Perhaps the only thing you could do at this point is be

Is this a Bug?: Query returns an unexpected result.

Description: Query returns an unexpected result. How-To-Repeat: run the script below: - create table member ( userid int(11) primary key auto_increment, mailaddress char(40) not null ); insert into member values (null,'[EMAIL

Re: MySQL --"failed to install service"

You said: > I am trying to start up mysql on win2000 machine using the following > > mysqld-nt --install > I get an error saying "failed to install service" > how do I get round this the docs say to use the folowing: > > mysqld-max-nt --install > this turns out to be not recognized as

SQL join help

Dear list, I've done basic SQL for a number of years, but I recently came up against a query I can't quite seem to figure out the join syntax for. Suppose I have rows in an Object table which are linked in a hierarchy by the entries in a Link table and I want to find all Objects which have gi

Re: optimisation trouble

Hi! Mon, 20 May 2002 21:30:52 +0900, tu as dit : > Hi, You are look like very tired... > I have a good idea!!! > See fellowing line. "alter table TABLE_NAME add index (timestamp > desc);" > import point is "index(timestamp desc)". you did not set index of > timestamp, so your query

RE: UPDATE question, SQL syntax, etc.

[snip] update trackinfo SET trackinfo.postcode = newtrackinfo.postcode FROM trackinfo, newtrackinfo WHERE trackinfo.telephone = newtrackinfo.telephone; [/snip] http://www.mysql.com/doc/U/P/UPDATE.html MySQL does not support sub-queries, such as the one you are attempting here. (the "FROM" on..) Y

MySQL --"failed to install service"

I am trying to start up mysql on win2000 machine using the following > mysqld-nt --install I get an error saying "failed to install service" how do I get round this the docs say to use the folowing: > mysqld-max-nt --install this turns out to be not recognized as a command how do I sta

UPDATE question, SQL syntax, etc.

hi. i'm new to the list and have only been playing with mySQL for a few weeks now, i have a question regrading the syntax of an UPDATE statement - i hope nobody minds me asking. i want to uopdate a table with the data from another, i've written the following: update trackinfo SET trackinfo.post

RE: password for databases

[snip] Iam created different databases using mysql. I want to put different passwords and users for different databses.Is it possible. If possible how? [/snip] http://www.mysql.com/doc/A/d/Adding_users.html http://www.mysql.com/doc/G/R/GRANT.html http://www.mysql.com/doc/A/c/Access_denied.html

Re: ISAMCHK utility - MySQL server - 3.21.33b

Hi, Many Thanks. I couldn't find out the isamchk utility on our server. I tried Telnet'ing to the server and typing the command. Its showing command not found. Could you please send me more details of this utility. Regards At 06:47 PM 5/16/02 +0200, you wrote: >Hi. > >Well, what's the proble

password for databases

Dear sir, Iam created different databases using mysql. I want to put different passwords and users for different databses.Is it possible. If possible how? Waiting for your replay = naveed abdul Software Engineer IndiaCompuMaster Ltd.,

AW: Mysql Connection from Webserver

hi, not sure about this .. but I think you need an ODBC Driver for ASP/MySQL (like myODBC) .. Connectstring? no clue :) Stefan Siefert -Ursprüngliche Nachricht- Von: Sameer Maggon [mailto:[EMAIL PROTECTED]] Gesendet: Montag, 20. Mai 2002 16:04 An: [EMAIL PROTECTED] Betreff: Mysql Connec

Mysql Connection from Webserver

Hi, I am using ASP and using IIS webserver.. I have a Mysql server installed on a linux box. what is the connectstring that i have to use to connect and gather data from my Mysql server Sameer -- http://www.dypatil.edu For Better tomorrow

SELECT would take a very long time

Hi, Got this problem and setting the SQL_BIG_SELECTS=1 is not an option. Is there a way to change the WHERE so the query would work? Error SQL-query : SELECT distinct(fincodedesc), industry.code, industry.level1, industry.level2,

Binary Data mysql_real_escape_

Hi, Please see the code given below:: // strcpy(query,"INSERT INTO blobtest VALUES('abc','"); qptr = query; len = strlen(query); qptr += len; qptr += mysql_real_escape_string(&mysql, qptr, data, iBytesRead); *qptr += '\''; *qptr += ')'; mysql_rea

Re: Storing UTF-8 text with MM.MySQL 2.0.13 driver.

This code works fine, which shows you can use the useUnicode and characterEncoding properties with simple Statement's: Properties prop = new Properties(); Class.forName("org.gjt.mm.mysql.Driver"); // true as String and not: Boolean.valueOf(true)! prop.put("useUnicode", "true"); prop.put("char

Re: Re: store JPG in MySQL DB

Hi, That explains me a problem but i could not see strmov() function any where, while linking with -lmysqlclient also it gives unreferenced function.. I am using Mysql 3.23 Please help Sameer -- you wrote: Sameer, Monday, May 20, 2002, 11:17:48 AM, you wrote: SM> Can you please

optimisation trouble

Hi! I got a problem I'm trying to fix with no luck. I got 2 tables : CREATE TABLE news ( id int(6) NOT NULL auto_increment, topic_id int(3) NOT NULL, section_id int(3) NOT NULL, author_id int(6) NOT NULL, lang_id int(2) NOT NULL, user_id int(6) DEFAULT '0' NOT NULL, state int(1) D

Re: Join takes way too long. How to optimize this smal query?

Hi, Read "5.4.3 How MySQL Uses Indexes" from documentation. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: "and

Join takes way too long. How to optimize this smal query?

Hi there, after reading a nice articel on normalisation, I did split my tables and now I am suffering performance lost. this query (finding out the amount of user which have posted an article on germany) takes 4.5 s: SELECT count(DISTINCT user_recommending) FROM recommendations t INNER JOIN geo

Re: error message....somewhat lost

...sorry ... idon't read carefully your message... check with : whereis mysqld ... if is in /usr/libexec then check if is executable. If is in other directory "whereis" tell you and you can move "mysqld" from "whereis" to /usr/libexec. - Original Message - From: "Simon K. Chan" <[EMAIL P

MyISAM internal algorithms

Hi MySQL-Team, my question is about MySQL(which means MyISAM) internal sorting/storeing algorithms. I found some hints in the manual ("How MySQL " ... e.g. "store tables"), but not exactly what I want. I don't need any exact information or code fragments (I fell down my chair when I took a first

Re: reusing auto-increment values

Hi Martin What about using a REPLACE or UPDATE rather than a DELETE/INSERT? Peter. On 20 May 2002, Martin Skjöldebrand wrote: > Hi, > > It's kind of embarrasing this, but ... > How do I resuse autoincremented values after a delete? Do I specify it > in the table somehow? > > Like _not_ havin

reusing auto-increment values

Hi, It's kind of embarrasing this, but ... How do I resuse autoincremented values after a delete? Do I specify it in the table somehow? Like _not_ having table 1 cat 2 dog 4 zebra 9 elephant after a few deleted animals. Preferably 1 cat 2 dog 3 zebra

Re: Re: store JPG in MySQL DB

Sameer, Monday, May 20, 2002, 11:17:48 AM, you wrote: SM> Can you please put some light on it.. How i can do it, or is SM> it described in manual You can insert file into BLOB field using INSERT statement and retrieve file using SELECT. To insert file you can use LOAD_FILE() function:

Re: error message....somewhat lost!

Simon, Monday, May 20, 2002, 8:08:50 AM, you wrote: SKC> The other day, I tried connecting to mysql SKC> via the good old SKC> mysql -u me -p SKC> but I got a message saying that my mysql.sock is missing SKC> from the tmp folder. After checking the mailing list SKC> archive, I decided (well, g

Re: please help a newbie!

Mohamadally, Monday, May 20, 2002, 4:53:05 AM, you wrote: M> I believe this question is very simple and hope u ppl can M> help me out. Well i'm trying to develop a site using M> chinese characters where my users M> can login. I'm suppose to store their username which will M> be in chinese charact

Re: INSERTING BLOB Fields in a Table

How would u insert thru the SQL prompt an Image file and once inserted what is the process of accessing it. I have a free server space with mysql db & as such I cant create subfolders with access privileges. So if I jus store the path in the DB & display the path later, any one can just type tha

Re: error message....somewhat lost

Hi, After mysql installation you MUST run the "mysql_install_db" script which is located (usualy) in /usr/bin... so, go to in this directory and type : ./mysql_install_db. Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL

<    1   2