has anyone got any idea why it wont let the slave connect properly ?
here is my slave settings
port= 3307
socket = /usr/local/etc/mysqlslave/tmp/mysql.sock
master-host=localhost
master-user=replication
master-password=***
master-port=3306
master-connect-retry=60
Dear SIr/Madam,
I am using MySQL 3.23 for production and I am
planning to upgrade to 4.0. before that I want to
install 4.0 and do some RD on that before Upgrading.
Please guide me which version to down load and how
to down load for RedHat LINUX version 7.2 and splease
send me
i'd download the lastest gamma release 4.0.11 ??
do a configure like so
./configure --prefix=/usr/local/etc/mysql --sysconfdir=/usr/local/etc/mysql
--exec-prefix=/usr/local/etc/mysql --with-unix-socket-path=/usr/local/etc/my
sql/tmp/mysql.sock --with-mysqld-user=mysql --with-innodb
then make
a completely different error now i tried a different user and for some
reason my grants are not working on the replication user
030303 8:43:30 Slave I/O thread: connected to master
'[EMAIL PROTECTED]:330
6', replication started in log 'FIRST' at position 4
030303 8:43:30 Error reading packet
Hi,
Well I had the same problem when I installed Mysql the first time.
I solved this problem by using a symbolic link like this.
cd /tmp
ln -s /mysql/mysql.sock mysql.sock
Remeber to be Root when you do a symbolic link :-)
Now make a ls -lia in your /tmp folder, then you should have
MySQL only supports one master and many slaves. In 4.x, we will add a
voting algorithm to automatically change master if something goes wrong with
the current master. We will also introduce 'agent' processes to help do load
balancing by sending select queries to different slaves.
i dont want to
There are some components named zeos library that can connect to a remote
mysql server without myodbc.
- Mensaje original -
De: Liu Qianghua-qch1942 [EMAIL PROTECTED]
Para: [EMAIL PROTECTED]
Enviado: domingo, 02 de marzo de 2003 7:49
Asunto: How to connect to mysql server without myODBC
I'm doing all kinds of exercises and tutorials to get up to speed on MySQL
on my PowerBook with OS X.2 running. I just tried an exercise that, for the
first time, had me creating a table not right in the MySQL monitor, but,
rather, via a script that I saved as a textfile--Temp.sql--and then call
Hy Steve,
bin/mysql -p bin/mysql -p /[the complete pathname, honest]/Temp.sql
try the following command :
bin/mysql -p /[the complete pathname, honest]/Temp.sql
HTH
Oliver
-
Before posting, please check:
Oliver,
Thanks for responding. Foolish of me to be in such a rush that I wasn't
watching what I was copying and pasting. I actually did use the command
you suggest below. And that's what drew the error message.
So I'm back to the drawing board.
Take care, and thanks again--
Steve
Hy Steve,
I've just finished installing a MySQL rpm and when I went to run the script to setup a
password (./mysql_setpermissions) this is the error:
#./mysql_setpermission
Password for user to connect to MySQL:
install_driver(mysql) failed: Can't load './mysql' for module DBD::mysql: ./mysql:
cannot
i have a problem when i use mysqlcc connect server Linux 7.3 ( Client
Windows98se ) show massage Error 1130 Host 192.168.0.11 not allowed connect
this Mysql Server
_
Tired of spam? Get advanced junk mail protection with MSN 8.
At 8:53 -0500 3/2/03, [EMAIL PROTECTED] wrote:
I'm doing all kinds of exercises and tutorials to get up to speed on MySQL
on my PowerBook with OS X.2 running. I just tried an exercise that, for the
first time, had me creating a table not right in the MySQL monitor, but,
rather, via a script that I
You have to add a new user with hostip 192.168.0.11
With kind regards,
Richard Pijnenburg
Klik-on Internet Solutions
-Original Message-
From: Narin Cherdchoosat [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 02, 2003 3:38 PM
To: [EMAIL PROTECTED]
Subject: mysql + mysqlcc
i have a
Does anyone know why I'm getting this error? Does it have to do with
character locale problems (notice the search.glyphs LIKE part)?
This code used to work fine before, but lately it's been getting
MySQL server has gone away errors every time it executes, so I'm
confused.
Breakpoint 2, main
Paul,
Thanks very much for responding.
I tried what you suggested, but got:
ERROR 1102: Incorrect database name '/Users/stephent/Sites/Temp.sql'
I don't get this. What wrong database name? The script is supposed to
create the database and a table in it. What an I too dense to see?
Thanks
Hy Steve,
USE DATABASE Temp;
try to change this into :
USE Temp;
and try it again, this should work.
HTH
Oliver
for the filter : sql,query,queries,smallint
-
Before posting, please check:
Hi there @ the MySQL list,
I'm currently using mysql-server-3.23.52-3 on RedHat Linux 8.0 with
Apache httpd-2.0.40-8
After some problems with the httpd server, I found out that the list of
open files spawn by mysqld had more than 20,000 entries, although the
PID's from the related processes
Hi, Not sure how to explain this - but here is what I need. I have a
hockey pool database with three tables - one has the players and their
stats, one has the team owner, and the 3rd is the reference file that ties
the two together.
I want to be able to do a query for all the players on a
Paul, Oliver--
I really, really appreciate you guys taking time from your respective
Sundays to try and enlighten me. But I'm still getting nowhere fast.
I've gotten it to this:
I open a new shell and type:
/usr/local/bin/mysql --local-infile -u root -p [the full pathname up
to]/Temp.sql
Hi!
Some new information about the MySQL-4.0.10 compilation problem on Red Hat
8.0 (x86), but unfortunately no solution found yet, except running a MySQL
official binary you can download from www.mysql.com. A 4 day stress test of
an official binary ran fine.
One of MySQL AB employees said that
Guys, Guys--
I got it! I stopped being a dimwit long enough to realize that the
change to USE Temp; below was for INSIDE the script.
When I made that change and again went to a new shell and typed
(actually, I dragged the file from the window in which it sat in the
Finder into the Terminal
I'm fairly new to MySQL as well (although, I do have experience with Oracle).
Even though you create a new database doesn't mean that MySQL will
automatically start using that database. After all you might want to
create 10 or 15 databases all at once (why? I don't know), then start
creating
What you are looking for appears to be report layout. Keep in mind that SQL
will only return multiple rows, all with the same columns populated.
To even get close to what you want, you can create a query that returns:
TeamOwner, Player, Position, Goals, Points
And then your application can
At 12:25 -0500 3/2/03, Stephen Tiano wrote:
Paul, Oliver--
I really, really appreciate you guys taking time from your
respective Sundays to try and enlighten me. But I'm still getting
nowhere fast.
I've gotten it to this:
I open a new shell and type:
/usr/local/bin/mysql --local-infile -u
Dear list,
I've installed mysql 3.32.55
And for some reason, I'm getting this error message on my screen:
/usr/local/mysql/bin/safe_mysqld: line 280: 8207 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION
--datadir=$DATADIR $USER_OPTION
Hi, i'am new in this list.
In my subscrition I did give wrong mailbox ...
How can i change mailbox from my subscrition ?
Thanks
Fernando
mySQL
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
i finally got mysql to login to the master server by adding log-bin in
my.cnf for the slave server , i can do a show slave status; and show master
status; so it all seems to be working but the tables on the slae dont seem
to wanna sync :| what could be the prob ?
Nope all the tables are good. (Also just installed it)
When I start cyrus I get the following error message in my messages log
:
Mar 2 21:19:06 dev tls_prune[836]: DBERROR db4: 4 lockers
When trying to connect to the mail server I get these error's :
maillog
Mar 2 21:20:26 dev
On Sun, 2 Mar 2003 02:06:40 -0500
Tore Bostrup [EMAIL PROTECTED] wrote:
I assume you are storing your dates in a char/varchar column - not a
good choice to start with... :-
yes, varchar. I'm still learning this stuff, and experimenting with it.
Assuming all the values are supposed to be
Hi list, I am sure that there is an efficient way to do this in SQL, I
just can't figure out what it is.
I am dealing with two tables. One, I'll call table1 has about 90
columns and 20k rows, each number in column xy is unique. The other
has about 90 columns and about 200k rows, and there will
Hi,
- Original Message -
From: Derick Smith [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, February 28, 2003 9:09 PM
Subject: Re: HELP mysql_server_init embedded in a DLL?
Attempts at creating an embedded mySQL DLL for VB:
I can successfully use the
Since writing this message, I have discovered another possible way for
doing this with two successive SQL statements. It would look something
like this:
1) CREATE TEMPORARY TABLE temp SELECT DISTINCT xy FROM table2 WHERE
all of table2 conditions; (going by data below, maximum of 20k rows
hi i have a delete query that will delete a record based on the company
name:
delete from members where company='$company';
the query works fine and all but there is a problem because if there is more
than 1 company listed but with different use of case in their name then
allrecords that match
At 17:51 -0500 3/2/03, Sunfire wrote:
hi i have a delete query that will delete a record based on the company
name:
delete from members where company='$company';
the query works fine and all but there is a problem because if there is more
than 1 company listed but with different use of case in
Personally, I usually like Reference books better than Idiot's Guide
books. And my favorite reference handbook for the SQL language (ANSI SQL-92
standard) is
Martin Gruber, SQL Instant Reference (SYBEX). There is (was) at least a
2nd edition available.
No fluff, just standard syntax and a
Hi, my experience comes from VB6 with access databases.
I'am trying to get one quick and practical overview about the mySQL
capabilities (web online database).
But so far i'am really loss and confuse regarding the mySQL setup and
installation procedure. I'am using WIN98 with mySQL4.01.11 and
Hi all
When i have installed version 4.0.10 of mysql server everything works
great... but when I try to use this libmysql.dll with Delphi + dbexpress
I always get in trouble with the error msg
unable to load
libmysql.dll
With libmysql.dll 3.23.55 everything works fine (but I think I
...and your problem is?
--
Loren McDonald
[EMAIL PROTECTED]
-Original Message-
From: Fernando Martins [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 02, 2003 6:00 PM
To: [EMAIL PROTECTED]
Subject: mySQL newbie confusion
Hi, my experience comes from VB6 with access databases.
I'am
Jos Longo wrote:
Hi all
When i have installed version 4.0.10 of mysql server everything works
great... but when I try to use this libmysql.dll with Delphi + dbexpress
I always get in trouble with the error msg unable to load
libmysql.dll
With libmysql.dll 3.23.55 everything works fine (but I
I am attempting to get mysql-3.23.38-win on a Windows 98 SE box. The
mysql-3.23.38-win.zip install wizard allowed me to install to D:\MYSQL
I have tweaked the my.cfg file as follows:
# Example mysql config file.
# Copy this file to c:\my.cnf to set global options
#
# One can use all long
hi..
having a problem with a mysql query where 2 different sources use the same
query.. the only problem is that in my where clause i.e.: where
'$edit[company]'==$company
the $edit[company] is not valid for one of the sources... is there a way to
let both sources use the same query like that.. my
Seth Price wrote:
I am dealing with two tables. One, I'll call table1 has about 90
columns and 20k rows, each number in column xy is unique. The other
has about 90 columns and about 200k rows, and there will be around 10
duplicate entries in xy for each value of xy. So, if I SELECT a
given
Seth Price wrote:
Since writing this message, I have discovered another possible way for
doing this with two successive SQL statements. It would look something
like this:
1) CREATE TEMPORARY TABLE temp SELECT DISTINCT xy FROM table2 WHERE
all of table2 conditions; (going by data below,
Having problems installing phpBB and Nuke-PHP on my OpenBSD box, all
seem to be stemming from attempts to access MySQL. For instance, phpBB
gives the error Could not connect to the database when using the
install.php script. The install script for Nuke just fails to load
completely so I'll try
Hi,
we are developing an application in java that needs to have an embedded database so
that we needn't install the database on the client machine. Is it possible to achieve
this using mysql. I read that mysql 4.0 supports embedded database, but I find that
embedded MySQL server library is
Working solution Bruce Feist
SELECT Films.idFilm, title
FROM Films LEFT JOIN Loans
ON (Films.idFilm = Loans.idFilm) AND (Loans.return_date IS NULL)
WHERE Loans.idFilm IS NULL;
Note: This solution works for me as it considers that I give no value (NULL) to
the attribute return_date at
Description:
A deadlock within innodb leads to a server crash.
I have a large table which I need to update in-place. So one mysql
connection does a SELECT, and another updates the data. I thought
that, since innodb supports transactions and multiversioning, the
Hmm, after seeing this it looks as if the way I have it is a lot simpler and
easier to handle. Currently I just put them in a PHP array and sum the
array. Thanks for the input.
- Original Message -
From: Tore Bostrup [EMAIL PROTECTED]
To: MySQL List [EMAIL PROTECTED]
Sent: Sunday, March
Hi,
I am still learning MySQL and trying to find certain things I use to do
in Access. I having been looking and can not find an way to set a field
so that it can not be duplicated. Since I can not find that I tryed
looking for the record using SELECT and WHERE but doing an IF on the
result
I'd better ask the obvious question... *which* one? Is there one in
particular that you're after, or would you be equally happy with any of
them? The latter would be a bit odd.
Each row in table1 has several corresponding rows in table2. Any of
them that match the query would be good.
So the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tea Yu wrote:
Not really, I substituted the queryStmt with the actual one but it gave
the
same result.
After some work:
select last_insert_id();//getInt() should return 14
//but now it gives
On Sun, 2 Mar 2003 17:58:13 -0500
Tore Bostrup [EMAIL PROTECTED] wrote:
Personally, I usually like Reference books better than Idiot's Guide
books. And my favorite reference handbook for the SQL language (ANSI
SQL-92 standard) is
Martin Gruber, SQL Instant Reference (SYBEX). There is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
mahesh rai wrote:
Hi,
we are developing an application in java that needs to have an embedded database so
that we needn't install the database on the client machine. Is it possible to achieve
this using mysql. I read that mysql 4.0 supports
I don't know why when i run mysql the message Can't
connect to mysql server throught port /tmp/mysql.sock
appear.
please answer for me.
thank you very much.
My email: [EMAIL PROTECTED]
__
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips,
The only way I can debug this is if you give me a repeatable test case.
Since the test case I showed you does not repeat the bug, you will need
to generate a standalone test case, with schema, data, and the java code
that demonstrates the issue.
-Mark
Hey mark, here are the files that
Simply create a UNIQUE Index on the column to avoid duplicates.
That will be case insensitive, and trailing spaces AFAIK, but spaces inside
the columns text have significance.
HTH,
Tore.
- Original Message -
From: Dee [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, March 02, 2003
Seth Price wrote:
Wouldn't you get the same result from your query by using an INNER
JOIN and dropping the temp.xy IS NOT NULL clause?
I am not sure, that is why I am asking y'all. My only problem with
that is does INNER JOIN create a 200k table with 180 columns and do
the selection from that?
Hi Bruce,
yep, u r right.
Anyway, MySQL query optimizer will take care of it ;)
regds,
-Original Message-
From: Bruce Feist [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 02, 2003 04:00
To: [EMAIL PROTECTED]
Subject: Re: A Simple Query!
Hello, Uttam;
We can simplify this, actually...
Hi all,
I have a database in Pervasive and I want to import it to MySQL.
I tried to convert the Pervasive data to a text file and then import it
into MySQL but it failed.
Is there any tool to do this directly?
Does MySQLCC provide any export option through which I can get the data
from Pervasive?
Hi all,
Hi,
I have a database in Pervasive and I want to import it to MySQL.
I tried to convert the Pervasive data to a text file and then import it
into MySQL but it failed.
Is there any tool to do this directly?
Does MySQLCC provide any export option through which I can get the data
On Sun, 2003-03-02 at 21:19, Aaron O'Neil wrote:
How-To-Repeat:
I suspect there is a bug in the ODBC driver in relation to blobs. I'm now
using 3.51.06, but was having this same problem on 3.51.05.
I'm using Visual C++ and their CRecordset wrapper for the ODBC calls. I'm
using the
Keith,
please upgrade to 3.23.55. Your MySQL version is very old.
Best regards,
Heikki Tuuri
Innobase Oy
---
InnoDB - transactions, row level locking, and foreign key support for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
sql query
- Original Message
Hi!
A deadlock of threads is a bug. It is is not connected to transactions or
multiversioning.
Is the problem repeatable in your computer?
Can you compile a debug version of mysqld? Go to the source tree root
directory /mysql/ and do:
./BUILD/compile-pentium-debug-max
Then run the compiled
64 matches
Mail list logo