Hello,
Is there any way to fix a connection of replication
from slave host when user on slave host noticed
that the connection of replication had been lost?
Now I have a following environment.
MySQL Master server <== replication ==> MySQL Slave server
Both server has
Turbo Linux 8.0 WS
MyS
Hi list...
I found that someone else had this problem:
http://lists.mysql.com/mysql/161614
But the solution is missing...
I couldn't find any other reference to this problem, does any one know the
answer?
Regards
FBR
[EMAIL PROTECTED]
13/07/2004 07:15 p.m.
To
[EMAIL PROTECTED], <[EMAIL PR
On Wed, 14 Jul 2004, Jim Ginn wrote:
> I have (think) the MySQL dataserver running. You wouldn't know where I
> could find a compiled:
>
> mysql.so
>
> module for apache/php data access?
Yes there is one in ftp.sco.com
ftp://ftp.sco.com/pub/openserver5/507/iso/suppcd3/osr407suppcd3.iso
and in
What table types are you currently using?
-Original Message-
From: MaFai
To: [EMAIL PROTECTED]
Sent: 7/13/04 10:09 PM
Subject: Upgrade 3.23 to 4.1.x
Dear all:
Do any one try to upgrade the mysql from 3.23 to 4.1?
In doc,mysql doesn't recommend update the mysql from diff series.Do any
on
Boyd Lynn Gerber:
I have (think) the MySQL dataserver running. You wouldn't know where I
could find a compiled:
mysql.so
module for apache/php data access?
Thanks!
Jim
> On Tue, 13 Jul 2004, Jim Ginn wrote:
>> Much better but it complains about max_allowed_packet? It is set to the
>> defaul
Since I don't have control on this server(cannot upgrade), so I cannot tell
if same happen in 4.1.3.
However, I would like to know the result in 4.0 as well. Anyone test this
script in 4.0/3.X server? I suspect this could be a unicode problem in 4.1?
If 4.1.3 could fix the problem I will suggest
Dear all:
Do any one try to upgrade the mysql from 3.23 to 4.1?
In doc,mysql doesn't recommend update the mysql from diff series.Do any one try it
successfully?
Do I just need to copy the datafile to the new mysql ?
Best regards.
MaFai
[EMAIL PROTECTED]
Roy
I don't think we provide any merge module for our ODBC installation yet, but
the changes that the odbc installer makes are very trivial so you could make
them yourself.
Are you going to run the mysql installer or perform the install yourself?
If you are going to perform the install yourself,
You should take a look at using InnoDb table types.
-Original Message-
From: Everton Sanga
To: [EMAIL PROTECTED]
Sent: 7/13/04 8:26 PM
Subject: Foreign Key
Hi all, this is my first post, and I whould like to know if there is a
way to create Foreign Key´s between Parent and Child table, I
Sergei, Thom..
I am interested in seeing this thread followed through. As developers at my
work have experienced similar performance issues between 3.23.x and 4. Our
database is also of similar size and a full optimize has been run.
Regards,
Lachlan
-Original Message-
From: Sergei Golub
An option would be a log reader program that uses
Oracle log miner to only show commited transactions
from the redo logs. You could then replay the SQL
that is being executed on the oracle box on the mysql
server as long as the tables are defined the same.
9i has an enhanced log miner that can be
Hi all, this is my first post, and I whould like to know if there is a way to create
Foreign Key´s between Parent and Child table, I realy dont know if is it possible to
do it and if OK, how will be a simple SQL code of it.
I use PowerDesigner 10.0 and Erwin 4.0
Tks for all
Everton Sanga
On Tue, Jul 13, 2004 at 06:11:22PM -0700, Carl Edwards wrote:
> Hello,
>
> I found a question about Oracle 2 MySQL replication in the
> archive on Sep. 2001 but no mention since?
>
> We have a department using Oracle 8.1.7 and I'm running MySQL
> 4.0 and neither of us wants to change :-)
>
> I
I have a query like this
select hex(blob_field) as myField from table
When the blob field is empty ('') it returns 'x'.
i'm using ADO with Visual Basic and MyODBC 3.51.
MySQL Version is 4.0.18 and SO is Win XP Pro (also happens on Windows 2K)
Felix Beltran.
Hello,
I found a question about Oracle 2 MySQL replication in the
archive on Sep. 2001 but no mention since?
We have a department using Oracle 8.1.7 and I'm running MySQL
4.0 and neither of us wants to change :-)
I could call a Perl, C++ or Java program from cron to periodically
update the MySQ
Astrum Et Securis
Josh,
Thanks for writing in...
Yes in fact I have worked with MySQL on other platforms. And am glad to hear
it wont' be a problem or much different.
Thanks a lot.
Dominor,
RSJ
-Original Message-
From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 13
Don't know much about creating a package in VB.NET but why not just the
windows installer from the web page instead, its always worked piece of cake
on the windows boxes if worked with. Can you call it from and then add in
some programming in VB to add the users?
-Original Message-
From:
I gather you have used MySQL on other platforms? Won't be much different. OS
X is BSD Unix-based, so it will be very similar (if not identical) to using
MySQL on a Unix box.
Have fun.
Or were you asking about compiling, etc?
j- k-
On Tuesday 13 July 2004 03:21 pm, MySQL Junkie said
Nawal Lodha wrote:
Dear All,
On executing a Stored Procedure (in MySQL 5.0.0-alpha) containing
multiple Select statements, I get the error
"SELECT in a stored procedure must have INTO".
I found that this is a MyODBC bug.
http://bugs.mysql.com/bug.php?id=2273
and
http://bugs.mysql.com/b
Astrum Et Securis
We've just bought a new Power Mac G5 Macintosh computer for the office and
I'll be needing to do some database engineering work using it. I've never
worked with mySQL on MAC, so I really have no experience with what happens
on a MAC.. Anyone here who works with mySQL on a MAC?
On Tue, 13 Jul 2004, Jim Ginn wrote:
> Much better but it complains about max_allowed_packet? It is set to the
> default 1M ...
I have my stune set as follows.
NODE"osr507"
EVDEVS 96
EVQUEUES88
NSPTTYS 64
NUMSP 256
NSTREAM 4352
NHINODE 1024
GPGSLO 1000
GPGSHI 3000
NSTRPAGES
Hi,
I'm now running redhat AS 3.0 with kernel version 2.4 and have 8GB of RAM.
If I set my innodb_buffer_pool to 2048M, it just will not start, I get this
error.
040713 22:10:24 mysqld started
040713 22:10:24 Warning: Asked for 196608 thread stack, but got 126976
InnoDB: Fatal error: cannot al
Matthew Stanfield wrote:
> I'm setting up MySQL databases on 'shared server' space I've rented
> using cPanel's 'MySQL Database' interface. I can add 'access hosts'
> (it's not limited to localhost) and it says the % wildcard is allowed.
> Forgive me if this is a trivial or annoying question (I can
I am trying to do an INSERT ... SELECT statement. When using MySQLcc
everything is fine. However when I try to execute the command using PHP I
get error 1146: Table 'caldata.resource' doesn't exist. Following is my
query statement. I am trying to combine a bunch of tables together and I
don't think
Hi all,
I'm using SELECT ... FOR UPDATE on InnoDB Table, i would like to know which CONNECTION_ID() is locking the row selected if it's the case ?
To know which CONNECTION_ID() is locking row i've think to implement a table LOCK but if i insert lock info after a FOR UPDATE into it, i
Boyd Lynn gerber:
Much better but it complains about max_allowed_packet? It is set to the
default 1M ...
Thanks!
Jim
Installing all prepared tables
Fill help tables
ERROR: 1153 Got a packet bigger than 'max_allowed_packet' bytes
040713 17:43:07 Aborting
040713 17:43:07 ./bin/mysqld: Shutdo
On Tue, 13 Jul 2004, Jim Ginn wrote:
> Updated to (your) 4.1.3-beta and now get:
>
> ./bin/mysqld --skip-grant &
> dynamic linker : ./bin/mysqld : could not open libssl.so.0.9.6m
>
> Check in /usr/lib and see:
>
> l /usr/lib/libssl*
> -r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/li
On Tue, 2004-07-13 at 13:51, Justin Swanhart wrote:
> > Where is the implicit group? The 'order by'
> > shouldn't effect how things
> > are grouped. On MySQL 4.0.17:
>
> Wow. I wasn't aware. Is that expected behavior?
Yup, check out:
http://dev.mysql.com/doc/mysql/en/GROUP-BY-hidden-fields.
Boyd Lynn Gerber:
Updated to (your) 4.1.3-beta and now get:
./bin/mysqld --skip-grant &
dynamic linker : ./bin/mysqld : could not open libssl.so.0.9.6m
Check in /usr/lib and see:
l /usr/lib/libssl*
-r-xr-xr-x 3 bin bin 191812 Sep 20 2003 /usr/lib/libssl.so@
-r-xr-xr-x 3 bin
> [...] how do I just 'allow any host'? [...]
> maybe it's just '%'?
AFAIK, that's it.
Greetz
Fred
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi, I am very new to MySQL and using it as the backend of my VB.NET
application. Now, I am trying to create an installation package from within
VB and don't know what files from MySQL & MyODBC 3.51 I need to add to my
installation package. Can anyone provide some help in this regards?
Also, I will
> Where is the implicit group? The 'order by'
> shouldn't effect how things
> are grouped. On MySQL 4.0.17:
Wow. I wasn't aware. Is that expected behavior?
Other databases (Oracle) generate an error when you
include columns in the select list that aren't in a
group by, or they do an implicit
On Tue, 2004-07-13 at 11:13, Justin Swanhart wrote:
> You are doing an implicit group by of first, last as
> well as your explicit group by of email.
>
> So you could have two records with the same e-mail
> address generate two records with your group by
>
>Justin Time [EMAIL PROTECTED]
Boyd Lynn Gerber:
I'll give the newer version a try as I was using:
/usr/local/mysql-4.0.18-pc-sco3.2v5.0.7-i386
build from your site ...
Thanks!
Jim
> On Tue, 13 Jul 2004, Jim Ginn wrote:
>> Trying to get MySQL running on SCO Openserver 5.0.7 and get this
>> message:
>>
>> dynamic linker: .
What are the table types being moved? What is the max packet size?
-Original Message-
From: ginger cheng
To: [EMAIL PROTECTED]
Sent: 7/13/04 2:42 PM
Subject: question about using mysqldump file
Hello, mysql gurus,
I have been trying to transfer some huge databases (>20G) to
anothe
If the db's are on the same server and you have the needed permissions for all
of them, just prefix the table names with the db names like so:
select dbname.tablename.field1, dbname2.tablename2.field2. and so on.
Your FROM will need similar qualifiers.
j- k-
On Tuesday 13 July 200
Hello, mysql gurus,
I have been trying to transfer some huge databases (>20G) to another
server using mysqldump. Here is my command
mysqldump --add-locks --allow-keywords -q -p db > db.dump
When I tried 'mysql -p db < db.dump' in another server, everything goes
all right until at some point i
If I have tables within 3 different mysql dbs, is there a way for me
to combine all 3 tables into a scope so that I may run a query
accessing information from those 3 tables within 3 mysql dbs?
In MS Access/MSSQL, it would be called linking, but I couldn't find
out whether mysql has that or not.
After much searching (and trying to read non-English posts), I've
stumbled across the solution. I installed the mysql-MAX rpm, changed the
my.cnf file and Viola! it works!
--
Hugh
mailto: [EMAIL PROTECTED]
Hugh Taylor wrote:
Running MySQL 4.0.15 on SuSE 9 Professional. MySQL works fine until I
Justin:
Interesting. So, if "GROUP BY t1.email" doesn't group simply by
t1.email, then how would the query be written to accomplish that? And
how is it occurring that Aaron is implicitly grouping by email, first,
last instead of just grouping by email? Is it because of the ORDER BY
clause?
Wes
On Tue, 13 Jul 2004, Jim Ginn wrote:
> Trying to get MySQL running on SCO Openserver 5.0.7 and get this message:
>
> dynamic linker: ./bin/mysqld: binder error: symbol not found:
> pthread_key_delete; referenced from: ./bin/mysqld
This was an error for some versions of MySQL. This is fixed in
Try using mysqldump for the innodb files.
-Original Message-
From: Mauricio Bruns
To: MySQL List
Sent: 7/13/04 12:41 PM
Subject: Moving InnoDB database from Linux to Windows
How can I copy the data directory from linux to windows, with the same
mysql version (4.0.16) in both OS and innod
Hi,
I'm setting up MySQL databases on 'shared server' space I've rented using
cPanel's 'MySQL Database' interface. I can add 'access hosts' (it's not
limited to localhost) and it says the % wildcard is allowed. Forgive me if
this is a trivial or annoying question (I can't find the answer anywher
You are doing an implicit group by of first, last as
well as your explicit group by of email.
So you could have two records with the same e-mail
address generate two records with your group by
Justin Time [EMAIL PROTECTED]
Justin Credible [EMAIL PROTECTED] --DUPE--
Case differences
How can I copy the data directory from linux to windows, with the same
mysql version (4.0.16) in both OS and innodb tables?
I try simple copy all files (iblogs, ibdata, mysql dir, database dir)
but I get this error when open a table:
ERROR 1016: Can't open file: 'advogado.InnoDB'. (errno: 1)
--
Hi all,
I'm using SELECT ... FOR UPDATE on InnoDB Table, i would like to know which CONNECTION_ID() is locking the row selected if it's the case ?
To know which CONNECTION_ID() is locking row i've think to implement a table LOCK but if i insert lock info after a FOR UPDATE into it, it rel
I have been trying out 4.1.3 beta on XP, and note that in SQLyog, Maestro,
and even MYSQL Administrator, the number of records shown is always one
more than actual - in InnoDB tables only. Even an empty table still shows
as 1. This is different than the count shown in these GUIs with 4.1.1
alph
Hi all,
I'm using SELECT ... FOR UPDATE on InnoDB Table, i would like to know which CONNECTION_ID() is locking the row selected if it's the case ?
To know which CONNECTION_ID() is locking row i've think to implement a table LOCK but if i insert lock info after a FOR UPDATE into it, it rel
varchar, sir.
> -Original Message-
> From: Wesley Furgiuele [mailto:[EMAIL PROTECTED]
> Sent: July 13, 2004 1:14 PM
> To: Aaron Wolski
> Cc: [EMAIL PROTECTED]
> Subject: Re: Why this query doesn't group the email addresses?
>
> What type of field is the email field?
>
> Wes
>
> On Jul
It's ulgy, and I'm not sure how efficient it is, but this will do the trick:
select concat(left(first,1),substring(lower(first) from 2)) as first;
Aaron Wolski wrote:
Hey guys,
I have a column in a table called 'first'.
Currently all records are upper case. Is it possible for me to do a
select stat
Hi there,
Thanks for the help!
Someone else also gave me a similar query which did exactly as yours
did. But with the same minor problem
In this table.. I also have columns for last and email. So the columns
are first,last,email.
The problem with both yours and this other person's query is that
What type of field is the email field?
Wes
On Jul 13, 2004, at 11:04 AM, Aaron Wolski wrote:
Hey all,
Got this query:
SELECT first,last,email FROM CustomerTable AS t1,
OrderTable AS t2, CartTable AS t3 WHERE t2.cart_id=t3.cart_id
AND t1.id=t2.customer_index AND t3.submitted='1' AND
t3.product_index
Dear All,
On executing a Stored Procedure (in MySQL 5.0.0-alpha) containing
multiple Select statements, I get the error
"SELECT in a stored procedure must have INTO".
I found that this is a MyODBC bug.
http://bugs.mysql.com/bug.php?id=2273
and
http://bugs.mysql.com/bug.php?id=2658
Mark Matt
SELECT CONCAT( UPPER( LEFT( first, 1 ) ), LOWER( RIGHT( first, LENGTH(
first ) - 1 ) ) ) AS `first` FROM table
On Jul 13, 2004, at 12:51 PM, Aaron Wolski wrote:
Hey guys,
I have a column in a table called 'first'.
Currently all records are upper case. Is it possible for me to do a
select statemen
Trying to get MySQL running on SCO Openserver 5.0.7 and get this message:
dynamic linker: ./bin/mysqld: binder error: symbol not found:
pthread_key_delete; referenced from: ./bin/mysqld
And I have FSU threads installed ...
Any help would be appreciated
Thanks!
Jim Ginn
--
MySQL General
Hey guys,
I have a column in a table called 'first'.
Currently all records are upper case. Is it possible for me to do a
select statement that makes all chars after the first char lower case?
Example:
Current: AARON
After: Aaron
I think this is possible.. just don't know how to execute the fu
Jeremy Zawodny writes:
Can you, or anyone comment on the praticality of doing so? I estimate
10,000 to 30,000 records per web server, per day using 3 remote web
servers. The number of web servers would not likely grow to more than 12.
That should be a problem at all. I know of much larger i
On Tue, Jul 13, 2004 at 11:23:03AM -0400, Marc Knoop wrote:
> Jeremy Zawodny writes:
>
> >> The web servers record web metrics to local mysql databases. I would
> >> like those local databases to be consolidated onto the DEPOT [as three
> >> separate DBs].
>
> > You cannot do that.
> >
> >
Having that many instances on one box is going to be a
management nightmare. I can only imagine the recovery
scenarios should you have a hardware problem. Perhaps
you may want to think about writing your metric data
to a local mysql instance then pulling the data from
each instance into the depot
Right on!
Effectively, user() returns the dns resolved name. So obviously this will
not match the mysql user table entry, where the ip range is specified.
I will try the --skip-name-resolve option, but I have to wait for a
scheduled down time of the server.
Thanks for the expert advice!
At 14:29
Yes sir. Exactly!
A
> -Original Message-
> From: Victor Pendleton [mailto:[EMAIL PROTECTED]
> Sent: July 13, 2004 11:15 AM
> To: 'Aaron Wolski '; '[EMAIL PROTECTED] '
> Subject: RE: Why this query doesn't group the email addresses?
>
> Were the records exactly the same?
>
> -Origina
Were the records exactly the same?
-Original Message-
From: Aaron Wolski
To: [EMAIL PROTECTED]
Sent: 7/13/04 10:04 AM
Subject: Why this query doesn't group the email addresses?
Hey all,
Got this query:
SELECT first,last,email FROM CustomerTable AS t1,
OrderTable AS t2, CartTable AS t3
Jeremy Zawodny writes:
The web servers record web metrics to local mysql databases. I would
like those local databases to be consolidated onto the DEPOT [as three
separate DBs].
You cannot do that.
You'd need to run 3 instances of MySQL on DEPOT, one for each WWW
server you'd like to mirro
Hey all,
Got this query:
SELECT first,last,email FROM CustomerTable AS t1,
OrderTable AS t2, CartTable AS t3 WHERE t2.cart_id=t3.cart_id
AND t1.id=t2.customer_index AND t3.submitted='1' AND
t3.product_index='1' AND t3.quantity>0
GROUP BY t1.email ORDER BY t1.first,t1.last
For some strange reason
Is there a way to get the output of a "select into outfile" statement to
have the column headers in it and not just the data?
Thanks,
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I suggest that you add more indexes to your tables. If you run an EXPLAIN
on your query, you will see that you are doing WAY too many table scans and
that is what is slowing you down. Index the columns in each table that
reference the ID values of another table. Then run your EXPLAIN again and
you
Hi,
you can try to add your headings to the stopword list, but remember:
- A "word" is any sequence of characters consisting of letters, digits,
`'', and `_'. Any "word" that is present in the stopword list or is just
too short is ignored.
- The stopword list is global and will affect all ta
On Tue, 13 Jul 2004, s.ahmad wrote:
> thankyou for your kind attention.
>
> there are 50+ Reservation stations in the country. Where multiple
> operators are sitting and reserving seats. Indexes are being used in
> the DB. as i am related to hosting company, i havent seen if they are
> taking adva
When that user does a select user() are they receiving the numeric ip
address or the dns resolved name? If you set up the privilege with the
numeric ip and dns is resolving this the two values will not match. If
necessary you can use --skip-name-resolve.
-Original Message-
From: Stephane C
Sorry, I should have included it originally. These are the only lines
referencing innodb that I can find.
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
inno
Hello,
We are happy to announce the release of SQL Maestro 1.5. The trial
version of the software is always available at
http://www.sqlmaestro.com/products/download.html.
In this version we have implemented a possibility to connect to a
remote MySQL server using a secure protocol. The secure c
Have you tried this with the latest MySQL 4.1.x build? Does it not work in
this version? What does the explain plan show?
-Original Message-
From: Francis Mak
To: [EMAIL PROTECTED]
Sent: 7/13/04 4:01 AM
Subject: Cannot do join on varchar
Hi,
I found out that when joining varchar colu
>Description:
Installed MySQL Binary, previous attempt with 'RPM' failed. From the
Binary
install everything seems ok, however when I attempt to start the
mysqld, and
run test to check it, I get a failure message as follows:
[EMAIL PROTECTED] mysql-standard-4.0.13-pc-linux-i686 ./bin/
Hi!
On Jul 12, Hickey,Thom wrote:
> I've been comparing the performance of 4.1 with the MySQL 3.23.58 that came
> with our Rocks cluster software.
>
> I'm finding that 4.1 is running approximately 1/3 slower (e.g. a 0.075
> second query goes to 0.100 seconds) than 3.23.58. Size of buffers, etc.
I am using MySQL 4.0.18 on Windows.
I want to give my users the possibility to change their MySQL password after
they log in.
The command SET PASSWORD = PASSWORD('newpassword') works fine as long as the
user has been created with no specific host extension in the mysql database
(corresponding to
Hi,
I found out that when joining varchar column, you have to trim down the
left column in order for MYSQL to match the row, is it a known issue? Or
join only works fine in number column?
CREATE TABLE `tb_test1` (
`id` varchar(5) NOT NULL default '',
`name` varchar(100) NOT NULL default
Not sure about the 3.x series, but in 4.x, if you build your own mysql, you
need to explicitly enable that feature via a configure option. I think
binary builds all have it enabled though.
Issac
- Original Message -
From: "David Brännlund" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
S
Joshua,
- Original Message -
From: "Joshua Chamas" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Monday, July 12, 2004 11:33 PM
Subject: RE: Concurrency Question
> Quoting Marvin Wright <[EMAIL PROTECTED]>:
> > Hi,
> >
> > It suggests below to bundle transactions into on
Hi,
I'm running MySQL 3.23.52 with binary logging enabled. All commands seems to
be written to the log except for "LOAD DATA LOCAL INFILE". Is there a
setting that needs to be tweaked for this to work?
Thanks for your help,
David
_
think this will work, have not tried it:
char(int) returns a character
rand() returns a random number between 0 and 1 (with loads of decimal places)
round(int) rounds a number to a whole number.
so a random password generator could be
SELECT char(round(rand()*100), round(rand()*100), round(rand()
On Tuesday 13 July 2004 08:12, A. Lanza might have typed:
> Hi list,
>
> i've installed mysql-administrator and mysqlcc graphical clients
> downloaded from mysql.com. As i read in doc from the site, i unzipped
> the downloaded files in /usr/local.
>
> It seems to be ok, but i cannot execute the app
50 clients accessing the database should not overload a system like that. I
would recommend posting your database layout. That might help in diagnosing
the problem.
j- k-
On Monday 12 July 2004 11:08 pm, s.ahmad said something like:
> thankyou for your kind attention.
>
> there are 50
Hi list,
i've installed mysql-administrator and mysqlcc graphical clients
downloaded from mysql.com. As i read in doc from the site, i unzipped
the downloaded files in /usr/local.
It seems to be ok, but i cannot execute the apps.
[EMAIL PROTECTED] bin]$ ls
mysql-administrator mysql-administrato
thankyou for your kind attention.
there are 50+ Reservation stations in the country. Where multiple
operators are sitting and reserving seats. Indexes are being used in
the DB. as i am related to hosting company, i havent seen if they are
taking advantage of indexes.
regards,
s.ahmad
On Mon, 12
84 matches
Mail list logo
