Dnia Wed, 28 May 2003 12:57:59 +0200
Jarek Jarzebowski [EMAIL PROTECTED] zezna/a co nastpuje:
Hi,
I have MySQL 4.0.12 working on Debian Linux box. DB server uses MYISAM
and InnoDB tables. MySQL docs shows what is the best way to backup
InnoDB tables but I don't want to shutdown db server
Dnia Wed, 26 Mar 2003 12:12:44 +0100
Marianadin, Didier [EMAIL PROTECTED] zezna/a co nastpuje:
Hi,
I want to execute a simple query in batch mode in a mysql database.
my OS : Unix (solaris 2.6)
when I run this command :
mysql -h localhost -u root -p mysql did.query did.out
I'm
Dear all,
how can I remove a foreign key in InnoDB?
ALTER TABLE DROP (FOREIGN) KEY `key`
isn't working (and also not specified in documentation)... : (
It's not implemented yet. You can copy your data to another table without
the foreign key constraint, drop original one and
Dnia Thu, 27 Feb 2003 11:22:57 +0100
Datatal AB - Gauffin, Jonas [EMAIL PROTECTED] zezna/a co nastpuje:
Hello
Have anyone got this error before:
ERROR 1062: Duplicate entry '2147483647' for key 1
I get it when I do a simple insert query. The primary key is an
auto_increment field and are
Then I recompiled the libc6 package with these changes (debian use softs
with shared libraries):
in linuxthreads/internals.h:
#define STACK_SIZE (2 * 128 * 1024)
in linuxthreads/sysdeps/unix/sysv/linux/bits/local_lim.h:
#define PTHREAD_THREADS_MAX 4096
in /etc/sysctl.conf:
Is this a way to do it? I've just upgraded mysql to vesion 4.0.10 and found
out that there are these new files on the slave. How can I rotate them?
sql and so on...
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA
On Thu, 13 Feb 2003 13:35:33 -0300
Sauer - brfree [EMAIL PROTECTED] wrote:
I'm trying to add a new column into a table, but I have received the folow
message:
[Des057] ERROR 7: Error on rename of '.\vendas\pedidos.MYI' to
'.\vendas\#sql2-6f0-15.MYI' (Errcode: 13)
There is something wrong
On Wed, 12 Feb 2003 15:50:29 +0300
Artem Koutchine [EMAIL PROTECTED] wrote:
Hi!
I have posted this message yerstaday, but apperantly
did not give enough information for reader to figure out
what's going on. So, i am reposting it with more information.
I have the following table:
On Mon, 20 Jan 2003 13:01:55 -0700
Zak Greant [EMAIL PROTECTED] wrote:
On Mon, Jan 20, 2003 at 01:14:53PM +0100, Rafal Jank wrote:
Hi,
I've just downloaded version 4.1 from bk and have problem with building
it. What version of automake is needed? Because after
aclocal
I get
On Mon, 20 Jan 2003 17:21:59 +0530
Akash [EMAIL PROTECTED] wrote:
Hi,
I want to periodically delete some records from a table. Is there any
mechanism by which I can schedule a job, which will execute a particular
query at periodic intervals ?
MySQL currently doesn't support stored
Hi,
I've just downloaded version 4.1 from bk and have problem with building it.
What version of automake is needed? Because after
aclocal
I get:
aclocal: configure.in: 459: macro `AM_PROG_AS' not found in library
P.S. MySQL, query,database
--
_/_/ _/_/_/ - Rafa Jank [EMAIL
equipID is a PRIMARY KEY ;)
But you don't have index in which ifName is on the first place - and you yave
to have it.
Well!!! ifname also a Primary key!!
ysql CREATE TABLE equipment_interfaces (
- equipID CHAR(20) NOT NULL,
- ifName CHAR(20) NOT
On Wed, 15 Jan 2003 11:02:44 +1100
vinita Vigine Murugiah [EMAIL PROTECTED] wrote:
HI
I'm not sure what is wrong with my CREATE TABLE syntax, Please advice
There is no index on ifname in table equipment_interfaces.
mysql CREATE TABLE equipment (
- equipID CHAR(20)
On Tue, 14 Jan 2003 16:41:06 +0100 (CET)
Natale Babbo [EMAIL PROTECTED] wrote:
# - 3rd post - #
# - PLEASE HELP -- #
hi to all,
is it still true that mysql/innodb needs explicit
index creation on foreign keys?
Yes
why can't i use a standard syntax
On Thu, 09 Jan 2003 23:04:37 +0100
Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED] wrote:
Rafal,
alter table rezerwacje add foreign key (nip_h,nrpok_p) references
pokoje(nip_h,nrpok_p);
ERROR 1005: Can't create table './test/#sql-932_4.frm' (errno: 150)
Most probably, you are using
- Original Message -
From: Heikki Tuuri [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, January 09, 2003 11:04 PM
Subject: Re: Bug in foreign keys
Rafal,
- Original Message -
From: Rafal Jank [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Thursday
for MySQL
See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
sql query
.
Subject: Re: Bug in foreign keys
From: Rafal Jank
Date: Fri, 10 Jan 2003 11:10:35 +0100
On Fri, 10 Jan 2003 23:53:51 +1100
mysql [EMAIL PROTECTED] wrote:
Hi,
Having a problem with accessing the mysql database from a remote
machine. I am typing in mysql -h ???.??.???.?? -u ?? -p. It asked
for password .. do that then the reply message is ERROR 2013: Lost
connection to
Hi!
I have two tables:
CREATE TABLE `pokoje` (
`nrpok_p` char(10) NOT NULL default '',
`nip_h` int(10) NOT NULL default '0',
`lozka_p` char(2) default NULL,
`tv_p` char(1) default NULL,
`lazienka_p` char(1) default NULL,
`cena_p` int(10) default NULL,
`zaliczka_p` int(10) default
At 16:11 +0100 1/9/03, Rafal Jank wrote:
Hi!
I have two tables:
CREATE TABLE `pokoje` (
`nrpok_p` char(10) NOT NULL default '',
`nip_h` int(10) NOT NULL default '0',
`lozka_p` char(2) default NULL,
`tv_p` char(1) default NULL,
`lazienka_p` char(1) default NULL,
`cena_p
On Wed, 18 Dec 2002 16:36:15 +
ANGELO CARMO [EMAIL PROTECTED] wrote:
When i try connect from WindowsXP machine to red hat 8.0 linux machine mysql
server (4.05-max), I have the following message error:
ERROR 2013: Lost connection to mysql server during query.
But, I can connect from
The table has something like this:
idnamekey
1 name1 key1
2 name2 key2
3 name3 key3
4 name1 key1
5 name 1 key1
6 name2 key2
Now I want to search the table for all unique name/key combinations.
select name,key from table group by name,key;
Is there a way to create constraints that implements the rules I
need?
Not really. You would have to use deferrable constraints (checked at commit,
not after statement) like in Oracle. For now Innodb doesn't support it.
P.S. query,sql
--
_/_/ _/_/_/ - Rafa Jank
hallo,
I try to skip logging on three special databases where a couple of
otherdatabases
should log their update in te binlog-file. The options in the
my.cnf-file
log-bin= /www/cmsdata/log/bin-log
binlog-ignore-db = db_1,db_2,db_3
You should have
Is table_cache parameter still important when using innodb table types?
I thought it's not, because there is no separate files for each table in
InnoDB
But now I see a lot of queries in opening tables and closing tables state.
Does increasing table_cache parameter may help?
Rafal
P.S. sql,
On Tue, 12 Nov 2002 12:02:04 +0100
[EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this
On Wed, 06 Nov 2002 11:23:30 +0200
Tuomas Jrvinen [EMAIL PROTECTED] wrote:
Hello!
I was few days avay from my office, and when I came back today, I got
some emails, nobody can't connect to database server. When I tried to
restart mysqld (3.23.46, debian (woody) initscript failed.
Hi.
I have installed SuSE Linux 8.0 Proffessional and the MySQL that came with
it. If anyone of you has done the same he must have realized that many of
the files are quite different than the files of MySQL that came with the
standard installation described in the maual.
My problem is that
On Fri, 02 Aug 2002 16:35:11 +0300
adi [EMAIL PROTECTED] wrote:
How to make a table(table2) with same content of existing table(table1) in
same database(database1) with mysql?
tx in adv for any help
adi
create table table2 as select * from table1;
You will have to create indexes manually,
On Mon, 15 Jul 2002 11:58:33 +0200
Jarek Jarzebowski [EMAIL PROTECTED] wrote:
Jan Kudrman wrote:
Dear Michal,
I am not sure, but I think you can create an user will all the rights in
mysql - user (database - table) - this will solve your problem with full
access to all databases.
mysql version 3.23.50
Field kwData_wydania is of type date. As you can see, dates are different that
expected. Is this a bug?
Select ksiazka_wyd.kwId,kwData_wydania
- from ksiazka_wyd
Hi,
what is the maximum size of .MYI file MySQL can handle, assuming that
operating system can handle files bigger that 4G? In the manual there is a
section saying about size of the table, but what about indexes?
TIA
Rafal
Hi
I'm trying to extract data from 2 tables (A and B) with a subquery
A has the fields (ID_person, name)
B has the fields (ID_person,ID_country)
This is my query
select *
from A
where A.id_person IN (select B.id from B where B.ID_country =7)
Subqueries are not supported in mysql
SELECT id, MUL(val) FROM above_table GROUP BY id;
I would get:
++---+
| id| MUL(val)|
++---+
| 1|200|
| 2|250|
++---+
**
I know there is now function MUL(), but is there anything comparable ?
Nope, you
apparently an innocent query followed by an update. The binary package
is statically linked ad it started happening after we started using
InnoDB. The version is, actually, 3.23.49a-Max.
Although I can't reproduce a better test case than this, I'm sure that
you can check the binaries you
Hi
Version Mysql-Max-3.23.49a for Linux, binary distribution from www.mysql.com
After deleting some users from user table and invoking flush privileges, I got
Lost connection to server during query Resolved stack trace as follows:
0x806e2d4 init_signals__Fv + 16
0x82b12b8 _end + 271548
0x82d9f96
Rafal,
Monday, April 15, 2002, 4:54:23 PM, you wrote:
RJ Version Mysql-Max-3.23.49a for Linux, binary distribution from
www.mysql.com RJ After deleting some users from user table and invoking
flush privileges, I got RJ Lost connection to server during query
Resolved stack trace as
UPDATE satzungen SET titel='title', inhalt = 'context',
content_type='text/plain', data='data',kuerzel='kuerzel',
kennung='kennung', last_change = NOW() WHERE rowid = @rowid;
User variables are not replication safe in 3.23 :(
MySQL
--
_/_/ _/_/_/ - Rafa Jank
Hi,
I was wondering if I could achieve a speed increase if I did chattr +A to
mysql data files. I'm not interested in knowing when the table was last opened
for reading. But I'm affraid mysql uses it internally for something. Can I do
it? TIA
Rafal
table, database
On Mon, 18 Feb 2002 11:33:06 +0100
[EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this
Quite often I'd like to duplicate an existing table using SQL. Normally I'd
do a
create table NewTable select * from OldTable;
and if I don't want any data transferred I'll slap on a Limit 0 on the end
of the statement.
This works fine except it doesn't create any indexes that
On Mon, 28 Jan 2002 14:49:18 +0100
Harald Fuchs [EMAIL PROTECTED] wrote:
In article [EMAIL PROTECTED],
Tobias Kremer :: IT [EMAIL PROTECTED] writes:
Hi,
Thanx dn. I know how to build joined selects but the problem is that those
two tables are not joinable. I don't have an entry in
Richard Ward wrote:
The short:
Is it possible to do replication from server a and server b to server
c.
ie. have two data collection points (a and b) both replicating data to
server c where queries and reports are created.
The Long:
we have 2 mailservers and a database server, all
I'm trying to compile version 4.0.1 from the source tree on RedHat 6.1.
Configure runs fine, but make gives me the following error:
gcc -DDEFAULT_CHARSET_HOME=\/usr/local\ -DDATADIR=\/usr/local/var\
-DSHAREDIR=\/usr/local/share/mysql\ -DUNDEF_THREADS_HACK -DDONT_USE_RAID
-DMYSQL_CLIENT
Jim Lucas wrote:
just wondering, when you start the database replicating, the bin files start
counting
at .000
host-bin.001
host-bin.002
host-bin.003
...
host-bin.999
what happens when you reach .999?
does it start over at .001 and over-write you initial files, or does it
=
45219
011031 2:17:41 Slave: connected to master
'[EMAIL PROTECTED]:3306', replication started in log
'3306_bin_log.001' at position 71445219
ERROR: 1051 Unknown table 't'
011031 3:09:04 Slave: error running query 'drop table MY_SHOP.t'
011031 3:09:04 Error
Hi!
Is there a possibility to rotate mysql error log without stoping the server?
TIA
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237 Gdansk, tel/fax. (58)
select count(distinct(email)) from subscribes;
select count(distinct email) from subscribes;
should work just fine
Magic word: sql
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/
Hi!
Is it possible to change default table type from MyISAM to InnoDB, for example
by putting
set-variable = table_type=InnoDB
line into my.cnf file?
Thanks
Rafa
-
Before posting, please check:
Hi,
I have strange problem with mysql. When I run mysqladmin processlist i get
output (I cut off selects):
| 4045633 | konkursy | targi1.wp.pl | konkursy2 | Query |
14| Locked | insert into bb2_ludzie_tak values
('Marzena')
Fred van Engen wrote:
Rafal,
On Mon, Sep 24, 2001 at 10:14:59AM +0200, Rafal Jank wrote:
Why is mysql locking table during insert operastion? The version is 3.23.22, so
it shouldn't behave like this...
If you mean it shouldn't behave like this because it does concurrent
inserts
Eugene wrote:
Hello...
I got a big problem in MYODBC. I am using myodbc-2.50.31-win95. When I use any MySQL
Administrator to query the database that I had created for example:- SELECT * FROM
dbname, they come out error like:=
Your command could not be completed. MySQL returned the
Jrkeborn Joacim wrote:
Hi,
We have Oracle SQL statements that uses UNION is there an equivalent for this in
mySQL?
Not yet. It should be in version 4.0
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA
Hi,
I've noticed, that bin logs names are followed by three digits: 001,002 and so
on. What will happen when I reach 999? Will it start to overwrite my first logs?
magic words: MySQL, table, sql
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/
Chris M wrote:
Does anyone know how I can go about troubleshooting what is wrong here? This
is mysql on a Linux system
I have no idea how to begin troubleshooting why the ACCOUNTING.MYD file
can't be opened, I need some hints.
That means that the table has crashed. Repair it with
Michael Beaucourt wrote:
Hi all,
I was wondering if it is possible to perform an inner select in MySQL.
I have a database called EMP and when i enter the following query, I
keep getting error 1064:
select ename,deptno from emp where deptno in (select deptno from emp
where ename =
Hi,
look at the latest patch:
http://www.innodb.com/bugfixes.html
Dvoek Michal wrote:
i configured mysql with
./configure --prefix=/usr/local --localstatedir=/usr/local/var
--with-mysqld-ldflags=-all-static --disable-shared
--with-unix-socket-path=/usr/local/var/mysql.sock
Peter Zaitsev wrote:
Hello mysql,
I was trying to load very huge (5GB 45mil rows) to the text dump in
sorted order (according to primary key).
The problem is mysql somehow does not wants to scan the table by
primary key to produce sorted output row by row, but prefers to use
Rafal Jank wrote:
Peter Zaitsev wrote:
Hello mysql,
I was trying to load very huge (5GB 45mil rows) to the text dump in
sorted order (according to primary key).
The problem is mysql somehow does not wants to scan the table by
primary key to produce sorted output row
Luc Foisy wrote:
We are looking for a solution to backing up a remote database, without using
mysqldump, and replication seemed to offer the solution required.
I set up the master/slave configurations on both the master and the slave
exactly the way it was shown in the MySQL documentation
hi,
since analyze table doesn't work for Innodb tables, where does optimizer get
statistics needed for making proper query plan from?
For example, how does it know which index is more selective or in which order
tables should be joined?
--
_/_/ _/_/_/ - Rafa Jank [EMAIL
I'm getting this when I'm trying to compile MySQL 4.0. Is it something wrong
with my thread library? Red Hat 6.1, glibc 2.1.2-11
../pstack/libpstack.a(linuxthreads.o): In function `linuxthreads_notify_others':
linuxthreads.o(.text+0x16): undefined reference to `__pthread_handles_num'
I want to associate John Doe with system1. How do I get mysql to extract the sysid
from the system table and then update the user table with the sysid and the username?
Thanks,
Phil
This feature is scheduled to come up in 4.0, which will be released
this Autumn.
So in release
Mette Mller Madsen wrote:
Hi there!
When I try to insert more than 127 rows/records in a table I get this error:
ERROR 1062: Duplicate entry '127' for key 1
(the key is an auto incremented primary key)
Change type of your primary key column to something bigger than tinyint
--
_/
Hi,
is there a way I can assign quota to database users, so they want be able to use
all of my disk size? Ideally I would like to assign quota to each user
individually.
Is it possible at all?
Rafal
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/
Hi,
Is it possible to make MySQL create another bin log when current one grows to
the specified size?
Rafal
--
_/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl
_/_/_/_/ _/_/_/ul. Uphagena 2, 80-237
alexandre Roussel wrote:
Hi,
I have some problems with the following SQL request that I process with phpMyAdmin :
select * from TABLE2 where FIELD not in (select FIELD from TABLE1);
This request identify all records in TABLE2 which are not in TABLE1 (depending on
value of FIELD).
"Ouyang, Sunny" wrote:
Yes. All of our mysql databases are there.
Do you have error log file? It should be in /usr/local/var
-Original Message-
From: Luca Accomazzi [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 10:28 AM
To: Ouyang, Sunny; '[EMAIL PROTECTED]'
Subject:
"Ouyang, Sunny" wrote:
Yes. Here it is:
mysqld started on Sat May 5 14:02:18 EDT 2001
/usr/local/libexec/mysqld: ready for connections
mysqld started on Wed May 9 19:19:34 EDT 2001
/usr/local/libexec/mysqld: ready for connections
010524 10:41:04 Found invalid password for
make[2]: Entre dans le rpertoire
`/installation/install/MySql/Tarball/source/mysql-3.23.38/client'
/bin/sh ../libtool --mode=link c++ -O3 -DDBUG_OFF
-fno-implicit-templates -rdynamic -o mysql mysql.o readline.o
sql_string.o completion_hash.o ../readline/libreadline.a -ltermcap
Richard Reina wrote:
I am stuck on a select query and was wondering if someone could help. I
have I've written a database app. that helps me run my business
(trucking). I need however to write a query that shows me all of the
loads that are delivered but not billed (invoiced). Which
71 matches
Mail list logo