Hi all.
My company has three Mysql DB servers.
one is master, the other are slaves.
master's version is 3.23.54-log.
two slaves's version is 4.0.17
and Os of all servers is linux 7.3
2 days ago, another slave's replication was currupted unexpactedly, but the other
slave was ok.
I
Hi there,
just one quick question I didn't find an answer in the docu:
Is it possible (stable and without data loss :-)) to run e.g.
mysql-3.23.40 on Port 3306
and
mysql-4.0.20 on Port 3307
on the same machine (SuSE Linux with 2.4.4-kernel) !AND! on
the same data-directory without the
Hello *,
a) what could be reason /solution for the following Problem:
ERROR 1016: Can't open file: '#sql-407f_f.MRG'. (errno: 144)
b) in which directory the below reported intermediate file should
be generated
mysql use syslog
Database changed
mysql ALTER TABLE logs UNION=(
May be a full off the filesystem where the relay logbin file is ?
Marc.
-Message d'origine-
De?: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Envoye?: mercredi 9 juin 2004 09:46
A?: [EMAIL PROTECTED]
Objet?: Replication is currupted ...Please help me...
Hi all.
My company has three
[EMAIL PROTECTED] wrote:
is that a problem?
I want to avoid ftp db.txt files and then mysqlimport them
You should run mysqlimport on the Windows box and specify MySQL server host with -h
option.
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Hello,
I tried searching the archives for this, but since the search tool is
returning no results when searching for 'INSERT' I figured it's not
working. :-)
Anyway, my question is this. If I do a single-statement multi-line insert,
are the auto-increment IDs of the rows inserted guaranteed
Hi,
Is it possible (stable and without data loss :-)) to run e.g.
mysql-3.23.40 on Port 3306
and
mysql-4.0.20 on Port 3307
on the same machine (SuSE Linux with 2.4.4-kernel)
yes
!AND! on
the same data-directory without the two versions conflicting (e.g. when both version
would try
Anyway, my question is this. If I do a single-statement multi-line insert,
are the auto-increment IDs of the rows inserted guaranteed to be
sequential? Bear in mind also that I'm using InnoDB tables here.
Conversely, if I know for a fact that it is not guaranteed, I know that I
need to think
No one else has had this problem? Just wondering if this may be a bug in
the configure script...
craig.
Craig Harding wrote:
I'm configuring mysql-4.0.20 source and I have openssl (OpenSSL 0.9.7d
17 Mar 2004) installed in /usr/local/ssl (default)
Below is the output from a make after
Hi Michael,
Thankyou for your reply, unfortunately I am unable to use InnoDB tables...
From: Michael Stassen [EMAIL PROTECTED]
To: shaun thornburgh [EMAIL PROTECTED]
CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: DELETE from more than one table
Date: Tue, 08 Jun 2004 12:50:39 -0400
The
How did you install OpenSSL? From source or packages (e.g. debian or rpm).
In
that case you also have to install the dev-Package of OpenSSL
(openssl-dev)
Sincerly,
Oliver
Craig Harding wrote:
No one else has had this problem? Just wondering if this may be a bug in
the configure script...
On Wed, 9 Jun 2004 12:58:01 +0200, Jigal van Hemert [EMAIL PROTECTED] wrote:
Anyway, my question is this. If I do a single-statement multi-line
insert,
are the auto-increment IDs of the rows inserted guaranteed to be
sequential? Bear in mind also that I'm using InnoDB tables here.
Conversely,
Hi,
We are about to build some new database servers and I have some questions
which I'd like some advice on.
The machines we are building have 4 Xeon 2GHz CPU's, 4 x 32GB SCSI disk
using RAID 1+0 (so thats 64GB of storage) and 4 Gig of RAM.
The OS will be Redhat 7.3.
Other than the mysql
On Wed, Jun 09, 2004 at 01:45:49PM +0100, Marvin Wright wrote:
Hi,
We are about to build some new database servers and I have some questions
which I'd like some advice on.
The machines we are building have 4 Xeon 2GHz CPU's, 4 x 32GB SCSI disk
using RAID 1+0 (so thats 64GB of storage) and
Hi. Hope someone can help me. I am running MySQL on a NetWare 6.x
server. I am using Veritas BackupExec. I currently manually copy the
files before a backup or manually unload the MySQL server. I would like
to automate the backup. What is the best way to do a backup on a
NetWare server.
Hi!
How did you install OpenSSL? From source or packages (e.g. debian or rpm).
In
that case you also have to install the dev-Package of OpenSSL
(openssl-dev)
Sincerly,
Oliver
I was able to repeat this situation.
It happens only when OpenSSL is installed to non-standart
directory and no OpenSSL
Hi all,
Can someone tell me what is wrong with this statement?
UPDATE nummer SET gold = '1' WHERE anr IN (SELECT no FROM gull);
I use MySQL 3.23.49.
Thanks
Markus Källander
Sub-select not supported in version you are using.
-Original Message-
From: Markus Källander
To: [EMAIL PROTECTED]
Sent: 6/9/04 11:25 AM
Subject: UPDATE...WHERE ... IN (SELECT...)
Hi all,
Can someone tell me what is wrong with this statement?
UPDATE nummer SET gold = '1' WHERE anr
-Original Message-
From: Markus Källander
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 09, 2004 10:25 AM
To: [EMAIL PROTECTED]
Subject: UPDATE...WHERE ... IN (SELECT...)
Hi all,
Can someone tell me what is wrong with this statement?
UPDATE nummer SET gold = '1'
On Wed, 9 Jun 2004 18:25:11 +0200
Markus Källander [EMAIL PROTECTED] wrote:
Hi all,
Can someone tell me what is wrong with this statement?
UPDATE nummer SET gold = '1' WHERE anr IN (SELECT no FROM gull);
I use MySQL 3.23.49.
^^^
4.1 or higher is required for
Webyog has released SQLyog 3.71 SQLyog Job Agent (
SJA ) v2.0
Some of the major features added in SQLyog 3.71 are -
-- SQLyog Notification Services - This new feature
allows delivery of formatted resultset(s) over email
at scheduled intervals.
-- SQLyog Database Synchronization Tool now
How do I turn on the General log file in version 3.23.52? Can I put an entry in the
my.cnf file and reboot?
Thanks,
Don
I am having a update problem, I have a table that has 28 columns they
are name 1-28. I am able to insert data into the table. When I try to
update info into the table it does not work. Any ideas?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
In the last episode (Jun 09), Blake Schroeder said:
I am having a update problem, I have a table that has 28 columns they
are name 1-28. I am able to insert data into the table. When I try to
update info into the table it does not work. Any ideas?
Not until you tell us the error message.
Has anyone seen a post on this issue? If not, can anyone offer any advice?
I have a TBL of users and I have created a search screen where you can type
in first or last name and it will retrieve the appropriate records. Here is
the statement:
Select * from STUDENTS WHERE FName LIKE '%
Sorry
Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near '1 = '1' WHERE id = '1'' at line 1
-Blake
|
Dan Nelson wrote:
In the last episode (Jun 09),
I am having a update problem, I have a table that has 28 columns they
are name 1-28. I am able to insert data into the table. When I try to
update info into the table it does not work. Any ideas?
1) What are the QUERY you´re using to UPDATE datas?
2) What is the error message?
3) What are the
Blake,
Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near '1 = '1' WHERE id = '1'' at line 1
Is the column 1 string type?
If it´s numec type. You
The type is a varchar.
-Blake
Ronan Lucio wrote:
Blake,
Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near '1 = '1' WHERE id = '1'' at line 1
Is the
You have to use
UPDATE MyTABLE set MyTABLE.1 = myValue.
Otherwise you are saying that the numeric value 1 = some other numeric
value.
God Bless
GOD BLESS AMERICA!
To God Be The Glory!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
In the last episode (Jun 09), Blake Schroeder said:
Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near '1 = '1' WHERE id = '1'' at line 1
Mysql is
Paul
Thanks alot that help out alot.
-Blake
Paul McNeil wrote:
You have to use
UPDATE MyTABLE set MyTABLE.1 = myValue.
Otherwise you are saying that the numeric value 1 = some other numeric
value.
God Bless
GOD BLESS AMERICA!
To God Be The Glory!
--
MySQL General Mailing List
For list
Dan
Great suggestion also.
-Blake
Dan Nelson wrote:
In the last episode (Jun 09), Blake Schroeder said:
Query
UPDATE table SET 1 = '1' WHERE id = '1'
|#1064 - You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near
Hi,
I need some help please! I have 60GB of proxy logs to parse and load into a
mysql database. I've written a parsing script but I'm stuck now on how to
load the data in.
I have a database called PROXY_LOG with 2 tables:
USER_TABLE
user_id date_time url_id size
and
URL_TABLE
url_id url
Hello,
I was wondering what happens when you change table types. Does MySQL
automatically get rid of the old table files? I'm looking into changing
out some tables from MyISAM to InnoDB. I'm not tight on space, but I
wasn't sure how it handled the conversion, since the storage location
changes
Hi Markus,
You cannot use sub-query in mysql 3.23.49
Regards,
Laercio Cavalcanti.
-Original Message-
From: Markus Källander [mailto:[EMAIL PROTECTED]
Sent: quarta-feira, 9 de junho de 2004 13:25
To: [EMAIL PROTECTED]
Subject: UPDATE...WHERE ... IN (SELECT...)
Hi all,
Can someone
J S said:
Hi,
I need some help please! I have 60GB of proxy logs to parse and load
into a mysql database. I've written a parsing script but I'm stuck now
on how to load the data in.
I have a database called PROXY_LOG with 2 tables:
USER_TABLE
user_id date_time url_id size
and
Hello,
I have had a few systems that began to generate max connection errors. When I
run a processlist, there are a lot of the following entries:
5899 | unauthenticated user | xx.xx.xx.xx | NULL | Connect | NULL |
Reading from net | NULL |
When I restart mysql the entries are
Hello -
I just upgraded my master to 4.0.20 from 3.23.54 (ran the
mysql_fix_privileges script)
My slaves are all 4.0.[16,17,18]
All seems well EXCEPT the Slave_IO_Running will NOT start.
All my slave a stuck at the point prior to the upgrade.
Error logs reveal nothing
I read some articles that the use of SQL's TIMESTAMP in a table is use
for recording the actual date/time that the row was inserted and for
row(s) that is/are updated. I'm a little troubled by that because I
want a table with a timestamp in the first column to be the transaction
date which can be
Hi,
I am using MySQL 4.0.17. When I try to create a foreign key on a field of
the type text, I get this error:
040609 15:02:31 Error in foreign key constraint of table db_name/tb_name:
There is no index in the table db_name/tb_name where the columns appear
as the first columns. Constraint:
Does anyone know of a way to use a SELECT statement to get the default value
for a column?
A DESCRIBE tabl_name col_name gives the values, but I need it inside a
SELECT.
Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Scott Fletcher wrote:
I read some articles that the use of SQL's TIMESTAMP in a table is use
for recording the actual date/time that the row was inserted and for
row(s) that is/are updated. I'm a little troubled by that because I
want a table with a timestamp in the first column to be the
At 15:53 +1000 on 06/07/2004, Ligaya Turmelle wrote about Re: Advice
on Database Schema Design:
I think I get what you are trying to do and it sounds good (though I am
still a beginner). The only thing I can think that might cause a problem is
since you have more then a couple of tables you MAY
At 02:34 PM 6/9/2004, you wrote:
Hi,
I need some help please! I have 60GB of proxy logs to parse and load into
a mysql database. I've written a parsing script but I'm stuck now on how
to load the data in.
I have a database called PROXY_LOG with 2 tables:
USER_TABLE
user_id date_time url_id
TIMESTAMP has a resolution of only 1 second. Not good enough as a primary
key for most applications. You may want an auto_incrementing int field (or
bigint depending on the size of your data) and make that your primary key.
Only the first TIMESTAMP column is automatically updated with the update
Hi,
I need some help please! I have 60GB of proxy logs to parse and load
into a mysql database. I've written a parsing script but I'm stuck now
on how to load the data in.
I have a database called PROXY_LOG with 2 tables:
USER_TABLE
user_id date_time url_id size
and
J S said:
Hi,
I need some help please! I have 60GB of proxy logs to parse and load
into a mysql database. I've written a parsing script but I'm stuck
now on how to load the data in.
I have a database called PROXY_LOG with 2 tables:
USER_TABLE
user_id date_time url_id
I am having the same problem that someone else posted about back in
December and I didn't see any responses for:
http://lists.mysql.com/mysql/156346
Specifically, I am trying to link with libmysqld.a on Mac OS X and am
getting 16 undefined link errors such as fixsfdi, floatdisf, udivdi3,
Never mind...I've fixed it.
Thanks
Michael
-Original Message-
From: DePhillips, Michael P
Sent: Wednesday, June 09, 2004 4:17 PM
To: '[EMAIL PROTECTED]'
Subject: Replication died
Hello -
I just upgraded my master to 4.0.20 from 3.23.54 (ran the
mysql_fix_privileges script)
All:
First let me say I know only the most basic of Java stuff.
I am working with a Java colleague on the development of a data model
(MySQL of course :-) and we seem to run into the problem an Entity Beans
cannot support joins. Can anyone tell me if this is true (If so, what
use are they for
Boyd,
First off, I should note that I haven't actually used EJB since about 1.1 or
so and have only been casually keeping up with some of the specs.
Therefore, some of what I say may be a bit out of date. Please ingest large
granules of salt while reading this.
What you're referring to is
Hi,
I am really pleased with the new unicode features of MySQL4.1.2 alpha release. I am
just a little surprised that there is still only one API call which returns the
character set??? (And it returns the collating encoding instead of the real character
set?)
I was wondering if there is a way
Russ,
We use #2 currently, and we are actually about to switch back to the
inserting them one at a time. The reason is very simple. In our case we
have a insert statement that will insert a maximum of 600 entries at a time.
But we could have up to 25 different programs running that could
54 matches
Mail list logo
