You need to shutdown mysql, delete the master.info and
relay-log.info files and then start mysql again.
The reason for this is because if the info files are
present then mysql uses them as is and only recreates them
from my.ini or my.cnf if absent.
This should get your replication going again.
Tried that, but no luck, they get recreated, but they still have 0 bytes in
them. This is really driving me crazy because although it's come up before
on lists, noone has ever really had an answer for it that makes sense. The
url I mentioned earlier does say something about the hostname of the
In the 4.0.17 and later build, the target table of an INSERT...SELECT can be
the same as the SELECT table (insert into table1...select ...from table1).
Does the process essentially happen in a natural lock? In other words,
could the table change between the data retrieved in the select and the
Thank you Victoria and Mikhail.
thanks a lot
Victoria Reznichenko [EMAIL PROTECTED] wrote:
Timotius Alfa wrote:
Hi All,
I'm newbie in MYSQL. Would please tell me about Mysql Security ?
I used Windows2000 for mysql server.
Privilege system of MySQL is described in the following
hi all!
i have a question regardin subselects or subqueries in the SELECT statement
i searched the manual yesterday but did not find any answer to this
in my SELECT statement i would like to do a subselect like this
SELECT t1.field1, t1.field2, (SELECT count(t2.field1) FROM table2 t2 WHERE
I am trying to set up a table from a script that came with some software
Value accounting/CRM and i'm getting a few errors, one of which i
can't seem to figure out/fix.
My system is RH 3.0 ES with mysql-server-3.23.58-1. I have innodb
tables configured with the following statement in my
Maybe you should check if the ip address resolved for the
master's url is correct ?
Also try using CHANGE MASTER TO
MASTER_HOST='master host name',
MASTER_USER='replication user name',
MASTER_PASSWORD='replication password';
and then START SLAVE; and see what
Thanks, but actually I just found the answer a second ago, and I'm including
it here so hopefully it'll be archived around the internet and whatnot so
the next poor sap like me with the same problem who tries to find it can:
What happened was that somehow the servername-relay-bin.009 file got
Thanks Bill; the first example did exactly what I wanted. I didnt need the
where clause though; obviously didnt explain myself clearly!
I am sure I tried something similar to that, but I am used to MS SQL 7 and
started sticking brackets everywhere which must have caused the errors I was
Hi all,
I have the following settings in *my.ini* (obtined from WinMySQLadmin)
#This File was made using the WinMySQLAdmin 1.4 Tool
#12/11/2003 10:50:28 AM
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld]
basedir=C:/Program Files/mysql
Hi,
on a linux installation i use for my purposes 2 ehternet cards. I have installed
the mysql 4.0.15. From a remote client i make various queries but few of them expires
(about 5% !!!). If i disable the second ethernet adapter the expires dissapears all
works very well. Is there away to
Hello
The slave server stop working today and I looked to the error log and the the error
message is
Error: 1062 Duplicate Entry '252' for key 1
And than it shows the query and time when it happens. My question is why no error
messages on master server just on slave server?
As I understand ,
From: Mike Mapsnac [EMAIL PROTECTED]
The slave server stop working today and I looked to the error
log and the the error message is
Error: 1062 Duplicate Entry '252' for key 1
And than it shows the query and time when it happens. My
question is why no error messages on master server just
I've upgraded a MySQL 4.0.14 server to 4.1.1-alpha version because I
wanted to experiment with the support for subqueries. Not being an expert
on SQL at this point, I tried a couple of simple subqueries and got the
following error message:
ERROR 1235: This version of MySQL doesn't yet
?6DKS?c?L-??A!fD/W?Inmga2%!
L)recWb4eyZE!G!xN(??#8fj'KU~*
RPtU?;)`{ehK;,BMq?'QG7jt)rRhy'?;unvR?Ut_76#HzyK;1.cm%GNJ
]s|r7?mT*kb*Qj\,2JS?%($3'LKn`JnT
f:hGEzp\I;Yd*Uk$26w8v6?2`Dr'G]r]x/?CAYn
?a[]oh[Att?4U2*qC^?%wf:1SQmFPSk.
#hrmgS,*e4;)%OPzt?C-#fP8_1xFsi09FBJ:wV{xOlJN?7KE
cDJT2R?o.IY
Had the same problem
Are u calling the query from the MysqlCC ???
, it is adding some info to server about limited the query .
Try from a sql prompt on server
or set the
automatically limited Select Queries to - unlimited
maximum join size - unlimited
on the tab : mysql options (right click
I have ip_address and ports that I want to use in my table. I was just going to
make each one a varchar. But was wondering if anyone has a better suggestion?
Should I use int for ports, which will have an index. Not sure how to store
ip_address.
This table has the possibility of having 800
Doesn't Excel have ODBC functionality? If so, there is MyODBC. I don't know
if it will provide everything you need, but its a simple start.
P
-Brian Harris [EMAIL PROTECTED] wrote: -
To: Annie Law [EMAIL PROTECTED]
From: Brian Harris [EMAIL PROTECTED]
Date: 01/28/2004 04:39PM
cc:
Our product, although written in .NET can be used to create anything, stored
procedures, data objects, business object that map database tables to
properties and so on. We support MySql, Microsoft SQL, DB2, Oracle and
Access. We are very interested in supporting the MySql community and plan
rmck said:
I have ip_address and ports that I want to use in my table. I
was just going to make each one a varchar. But was wondering if
anyone has a better suggestion?
PostgreSQL ;-)
It has a native datatype for storing IP addresses. That means that
things like sorting and subnet inclusion
I am interested in setting up 3 read only slaves and one write master. I
am thinking of implementing this because one server is slower than 3
;-). But anyway, I have read all the docs and I am fairly sure how I
want do this and keep the sanity checking in the loop. What I am
considering doing is
From: James [mailto:[EMAIL PROTECTED]
I am interested in setting up 3 read only slaves and one
write master. I am thinking of implementing this because
one server is slower than 3 ;-). But anyway, I have read
all the docs and I am fairly sure how I want do this and
keep the sanity
[EMAIL PROTECTED] wrote:
I've upgraded a MySQL 4.0.14 server to 4.1.1-alpha version because I
wanted to experiment with the support for subqueries. Not being an expert
on SQL at this point, I tried a couple of simple subqueries and got the
following error message:
ERROR 1235:
Hi,
I employ a simple method, I have a 'status' table on the master and have a
cron job that updates this table with the current time (now()) every minute.
I test all the slaves each minute and if the time in the status table gets
too far behind the actual time then it flags a warning to me.
Mike Andrew,
Excellent ideas...
The reason I am considering checking the log location, is because normal
lusers will be using this software, so it won't be too good for them to
see errors about the slave being out of synch. (Some 20 people including
my self are using this software.) This is
Hi Guys,
How can I disable autocommit in the database. Can this only be done per session as
opposed to having it done globally at the database level.
Last where can I get a complete list and explanation of the buffer/memory areas of
mysql.
I checked the manual and it was brief at best.
Thanks,
When I select a rather large table to be shown, the rows are going very
fast and I can't see the rows at the beginning. Also, I can't scroll up.
How can I view the results page by page?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
From: James [mailto:[EMAIL PROTECTED]
Mike Andrew,
Excellent ideas...
The reason I am considering checking the log location, is
because normal lusers will be using this software, so it
won't be too good for them to see errors about the slave
being out of synch. (Some 20 people
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jochem van Dieten wrote:
rmck said:
I have ip_address and ports that I want to use in my table. I
was just going to make each one a varchar. But was wondering if
anyone has a better suggestion?
PostgreSQL ;-)
It has a native datatype for
From: Adel Ardalan [mailto:[EMAIL PROTECTED]
When I select a rather large table to be shown, the rows are
going very fast and I can't see the rows at the beginning.
Also, I can't scroll up. How can I view the results page by
page?
I can only assume you're talking about the native mysql
I had posted a message earlier this week about my 'Left Join' taking too
long to run. This seems to be happening on all of my queries that have
a 'Left Join'. Does anyone have any suggestions on why this would
happen?
Here is one query which took 45.72 sec to run:
SELECT
Kim,
Got it in one! Thank you so much.
I was using MysqlCC and, although I was aware of the general issue
around limits, I had no idea that it would affect sub-queries.
I tried the query from the command line and it worked. For anyone
else who runs into this,
From: Mike Johnson
From: Adel Ardalan [mailto:[EMAIL PROTECTED]
When I select a rather large table to be shown, the rows are
going very fast and I can't see the rows at the beginning.
Also, I can't scroll up. How can I view the results page by
page?
I can only assume you're
another option is to set your pager option:
mysql pager more
then re-run your query
-Original Message-
From: Mike Johnson [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 11:01 AM
To: Adel Ardalan; [EMAIL PROTECTED]
Subject: RE: Paging!
From: Adel Ardalan
From: Dan Greene [mailto:[EMAIL PROTECTED]
another option is to set your pager option:
mysql pager more
then re-run your query
Wow. You learn something new every day.
Thanks!
--
Mike Johnson
Web Developer
Smarter Living, Inc.
phone (617) 886-5539
--
MySQL General Mailing List
For
Mark Matthews wrote:
Jochem van Dieten wrote:
rmck said:
I have ip_address and ports that I want to use in my table. I
was just going to make each one a varchar. But was wondering if
anyone has a better suggestion?
PostgreSQL ;-)
It has a native datatype for storing IP addresses. That means that
On Thu, Jan 29, 2004 at 11:19:27AM -0500, Mike Johnson wrote:
From: Dan Greene [mailto:[EMAIL PROTECTED]
another option is to set your pager option:
mysql pager more
then re-run your query
Wow. You learn something new every day.
How about the 'help' command? You'll learn
rmck wrote:
I have ip_address and ports that I want to use in my table. I was just going to make each one a varchar. But was wondering if anyone has a better suggestion?
Should I use int for ports, which will have an index. Not sure how to store ip_address.
Use a varchar for the IP address.
Hi,
You can only bind to a specific network interface IP address which is mounted and Up
from your server.
ie:
./mysqld --bind-address=YOUR_IP_ADDRESS
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
SYSTEM INTEGRATOR - AUTOMATION SOFTWARE DEVELOPER
Your password is wrong. You probably need to read the manual that is in
the docs directory. There are some issues about passwords with 4.1.1.
I don't have time to walk you through the entire setup, but will be
glad to help with simple questions.
Since you can connect on the server, the
Thanks for explanation.
But I don't insert anything at all to the SLAVE. It is 100%.
Can the problem be problem be relative to Mysql 4.0.13 ?
Thanks
From: Jigal van Hemert [EMAIL PROTECTED]
To: Mike Mapsnac [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: Error: 1062 Duplicate Entry '252' for
From: Mike Mapsnac [mailto:[EMAIL PROTECTED]
Thanks for explanation.
But I don't insert anything at all to the SLAVE. It is 100%.
Can the problem be problem be relative to Mysql 4.0.13 ?
Thanks
Out of curiosity, what's the data type of this column?
--
Mike Johnson
Web Developer
I am trying to query a table that has field names with # characters in them.
For example a table emp_earn has a field called FILE#
I need to do a query where FILE# = 1332, but anything I try errors out.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Im trying to retreive the data from a LONGBLOB column but I have been unable
to convert the binary data back to character data.
Is there something Im not doing right with the query below?
SELECT changehistory.timestamp, SUBSTRING(changedata.changes,1,1000)
FROM changehistory, JOIN changedata ON
Howdy List,
I came across this article in the mail archives:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg85864.html
And subscribed to the list because I am having the same issue.
(Hope A. Tucovic is still on the list!)
I get:
Got error 22 when trying to lock mutex in log.cc , line 1689
From: Howell, Scott [mailto:[EMAIL PROTECTED]
I am trying to query a table that has field names with #
characters in them.
For example a table emp_earn has a field called FILE#
I need to do a query where FILE# = 1332, but anything I try
errors out.
I can't seem to even create a table
Hello Howell,
See URL: http://www.mysql.com/doc/en/Legal_names.html for the solution.
Basically enclose FILE# with `, e.g. where `FILE#` = 1332
Bernard
On Thursday 29 January 2004 12:55, Howell, Scott wrote:
I am trying to query a table that has field names with # characters in
them. For
What is the difference between 'Mac OS X downloads' and
'Mac OS X Package Installer downloads' listed at:
http://www.mysql.com/downloads/mysql-4.0.html
I know I want 'standard' and not 'max' or 'debug' but do I want
'Mac OS X downloads' or 'Mac OS X Package Installer downloads'?
What's the
Jacque,
Based on your explain, I'd guess that you don't have any indexes. Probably,
you need (at least) an index on the join column on the second table, as,
otherwise, MySQL will read the second table once for each row of the first
table.
This probably doesn't have anything to do with the fact
Which version of PHP would be good for Red hat 7.3? can someone send URL from where I
can download the php pl?
Jochem van Dieten [EMAIL PROTECTED] wrote:Douglas Sims wrote:
You should check out: http://onlamp.com/ L.A.M.P.
(Linux/Apache/MySQL/Perl(or PHP)
Or
select * from emp where `file#` = 1332;
returns
ERROR 1054: Unknown column 'file' in 'where clause'
-Original Message-
From: Bernard Clement [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 29, 2004 1:19 PM
To: Howell, Scott; Mysql (E-mail)
Subject: Re: HELP! Select queries for tables
Which version of MySQL are you using?
It works for me with version 4.0.15 as shown below:
mysql select version();
+---+
| version() |
+---+
| 4.0.15|
+---+
1 row in set (0.00 sec)
mysql create table temp (`FILE#` integer);
Query OK, 0 rows affected (0.00 sec)
mysql
I'd like to kill 2 birds with one stone...
I'd like to SELECT a set of records (for viewing) and in the same motion
DELETE any that show up.
Can it be done?
Shawn Cummings
Engineering Project Manager
Global NAPs
10 Merrymount Rd
Quincy, MA 02169
Desk 617-507-5150
VoIP 617-507-3550
[EMAIL
Thanks for your time. I didn't think of formatting the query. Here is
the query in a more readable format. I have also taken out most of the
columns in the SELECT. The query still takes 44 seconds.
SELECT Products.NSIPartNumber, If(Bom.ProductID Is Not Null,x,) AS
BOM, Products.Obsolete
Hi List,
Is anybody knows how to lock (make just readable) a field from a record or
the whole record?
This is the idea: I need to create a table that some people will insert
records. One person will access a record to validate the values
inserted into it. Once a field was validated, nobody
It is not possible to 100% lock down a value using the server. There
are, however, strategies you can employ in your application that will help.
1: Use 2 accounts. 1 for inserting/verifying, 1 for viewing. The
applications that insert and validate, you give and account with
permission to
I have made a couple of other postings related to this but I guess my
question is:
Can I backup InnoDB tables (binary files) using an open file agent?
If yes...and I am using Automatic COMMITs my backup will be current?
If I am not using Automatic COMMITs then my backup will contain data up
At 12:51 PM 1/28/2004, Seth Brundle wrote:
After some research, I chose a dual Opteron MySQL server for my new search
box. For storage, I only update the tables once a day, so I plan on
putting my data directory on a Linux ramdrive and backing it up to the
hard disk after each update for
On Thu, Jan 29, 2004 at 03:40:17PM -, Andrew Braithwaite wrote:
Hi,
I employ a simple method, I have a 'status' table on the master and have a
cron job that updates this table with the current time (now()) every minute.
I test all the slaves each minute and if the time in the status table
You need an index on BOM.ProductID
try:
alter table BOM add index (ProductID);
then run your query again
Some additional notes on your query:
(1) You have an expression involving BOM.ProductID in your field list.
Since that column is not in the group by clause, you'll get a ProductID from
some
Hello all,
I'm a newbie and I appreciate any help I can get for
my basic question.
For example,let's say I have a table with fields
experience, vacation.
I'm doing,
select @exp:=experience from the table
then I do some mathematical calculations with @exp
variable. My question is how do I write
Can this problem be relative to the problem with auto_increment value?
Sometimes auto_increment value skips next value in insert.
| 261149 | 2004-01-29 16:19:53 |
| 261151 | 2004-01-29 16:20:47 |
| 261152 | 2004-01-29 16:21:36 |
| 261154 | 2004-01-29 16:22:47 |
| 261157 | 2004-01-29 16:23:43 |
You could use a CASE statement:
SELECT
CASE
WHEN @exp = 5 AND @exp = 10
THEN vacation + 4
WHEN @exp 2 AND @exp 5
THEN vacation + 2
ELSE vacation
END
-Original Message-
From: sakhiya [mailto:[EMAIL PROTECTED]
Sent: Thursday,
I have recently dropped a database with a big innodb
table in it - but the data file (ibdata1) failed to
get smaller. It's pretty big (nearly 2GB) and I'd like
to
reduce it if possible. Is there any way to do this?
Thx
BT
someone will no doubt echo what I'm about to say.
InnoDB files are created at startup. the files use all the disk you
allocate to them in your my.cnf startup file.
If you want smaller InnoDB files, specify a smaller file size in your
my.cnf file, but I have a feeling thats not what you want to
I am having a terrible time trying to understand the outer join syntax
for MySQL (Our sever version is: 3.23.56).
I have three tables I want to join two of which by inner joins and the
other by an outer join.
Here are my example tables:
table1:
+--+--+
| id | key |
+--+--+
|
--- Jeff Mathis [EMAIL PROTECTED] wrote:
someone will no doubt echo what I'm about to say.
InnoDB files are created at startup. the files use
all the disk you
allocate to them in your my.cnf startup file.
If you want smaller InnoDB files, specify a smaller
file size in your
my.cnf
I must admit that I do not understand what you really have in mind
witha search for multiple strings. If you are referring to
specific MySQL
features, could you please be so kind and provide a pointer to the
relevant docs?
maybe if I explain what i'm trying to do. I have a hash that has
Hi,
key_reads is usually a small fraction of key_read_requests,
but in the case of the server below, key_reads is actually
GREATER than key_read_requests. Can anyone explain what would
cause that to happen?
- JD
mysql show status like 'key%';
++---+
| Variable_name
Well setting indexes of both tables helped. The query now runs at 0.38
seconds. What a difference.
Is this the way to set Indexes? Set a 'Unique' index for the PK of
each table and just an 'Index' for the foreign keys in each table.
Bill,
You have been a life saver. Thank you so much.
I just answered my own question with tinkering around with the sql
statement.
The solution is:
select
t2.*,
t3.name
from
table1 t1,
table2 t2
left outer join table3 t3
on (
t3.prid = substring_index(t2.weird, '-', 1)
and
t3.cid = substring_index(t2.weird,
I believe MySQL 4.1 has support for ssl replication but it's still alpha at
the moment.
If you are referring to connecting to a MySQL server from an application to
query it then the following applies:
---from the manual---
When you connect to a MySQL server, you normally should use a password.
On Thu, Jan 29, 2004 at 11:47:52PM -, Andrew Braithwaite wrote:
I believe MySQL 4.1 has support for ssl replication but it's still alpha at
the moment.
If you are referring to connecting to a MySQL server from an application to
query it then the following applies:
---from the manual---
When
I have been having trouble under ming, cygwin and Linux all for different reasons and
all because some of my libs don't address everything. I downloaded the linux
distribution and found all the lib files stored as .a files. How do I turn them into
libs and can I use the same libs on windows
Hi, all. First of all, thanks for all the help on my earlier
questions. This list has been incredibly helpful.
I've broken out some data into two tables for speed: a and
b. a has fixed columns and sees only SELECTs and INSERTs,
while b has several TEXT fields and sees SELECTs, INSERTs,
and
If you are using MySQL 4.x, using a RAM disk isn't going to speed
up similar Selects very much because it caches them. If you are doing a
lot
of different Selects then it will help.
Its a web search engine with 10-15 search options, so yes the selects will
vary and very often every row will
Hi guys. I bought a script .And guys ,who make an installation on my data-base have a
problem with it.Installation is completed but My SQl can not read it.When I trying to
open my database trough internet explorer I see error :
My user name KOSTA turns to [EMAIL PROTECTED] I don't know why .And
Greetings MySQL group:
I am new to the group so if this is posted to the wrong place, please
inform me.
Using the following table :
+---++---++
| unique_est_id | sp_id | score | evalue |
+---++---++
| 2 |
Is this the way to set Indexes? It sound like a good first approximation. To go
beyond that, you need to think a bit about what MySQL will do to satisfy the query.
Access, and any other database manager, would do similar things--just that the
tradeoffs chosen may be different. For example,
You'll need to create a temporary table and then join the
result:
CREATE TEMPORARY TABLE tmp
SELECT unique_est_id, min(evalue) AS evalue
FROM blast_hit_master_seq2_unique_est_swiss_prot
GROUP BY unique_est_id;
SELECT a.*
FROM blast_hit_master_seq2_unique_est_swiss_prot AS
In the last episode (Jan 29), Leif Johnston said:
I have been having trouble under ming, cygwin and Linux all for
different reasons and all because some of my libs don't address
everything. I downloaded the linux distribution and found all the lib
files stored as .a files. How do I turn them
I am running a 4.0.15 database and I need a table to ba able to handle
Japanese, Korean, and English at the least. How can I get the database to
accept these multiple character sets. I understand the default character
set option but can I set multiple default character set options to
multiple
82 matches
Mail list logo