Dnia Wed, 28 May 2003 12:57:59 +0200
Jarek Jarzebowski <[EMAIL PROTECTED]> zeznał/a co następuje:
> 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
Dnia Wed, 26 Mar 2003 12:12:44 +0100
"Marianadin, Didier" <[EMAIL PROTECTED]> zeznał/a co następuje:
> 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
>
> > 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 origin
Dnia Thu, 27 Feb 2003 11:22:57 +0100
"Datatal AB - Gauffin, Jonas" <[EMAIL PROTECTED]> zeznał/a co następuje:
> 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 f
>
> 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 http:/
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 somethin
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
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
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 sto
> >>>
> >>
> >>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,
> >> ->
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 CH
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
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
bout this.
>
> Best regards,
>
> Heikki Tuuri
> Innobase Oy
> ---
> InnoDB - transactions, hot backup, and foreign key support for MySQL
> See http://www.innodb.com, download MySQL-Max from http://www.mysql.com
>
> sql q
NULL,
> -> `zaplac_r` char(1) default NULL,
> -> `wplaczal_r` char(1) default NULL,
> -> PRIMARY KEY (`id_r`),
> -> KEY `nip_h_index` (`nip_h`,`nrpok_p`)
> -> ) TYPE=InnoDB;
> Query OK, 0 rows affected (0.01 sec)
>
> mysql&g
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,
> 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,
> >
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 NULL
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 connec
> 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 b
>
>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ł Jan
>
>
> > 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
> >
>
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, q
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 Järvinen <[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 faile
On Fri, 27 Sep 2002 08:16:49 -0400
"Michael J. Fuhrman" <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> I seem to be running into a very strange problem.
>
> In the mySQL command line interface I issue SELECT COUNT (*) FROM
> test; and get --> ERROR 1064: You have an error in your SQL syntax
> near
> 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
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 manual
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
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
>
> 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 ?
>
> 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
> 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
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
>
> > 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ł J
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 thi
>
> 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
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
Hi,
I have set max_user_connections to 80 on my database. But that doesn't seem to work -
I have more than 130 connections from one user. What can be the reason?
I'm using version 3.23.47
Rafal
-
Before posting, please check:
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,
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 -I./.
Jim Lucas wrote:
>
> just wondering, when you start the database replicating, the bin files start
> counting
> at .000
>
> -bin.001
> -bin.002
> -bin.003
> ...
> -bin.999
>
> what happens when you reach .999?
>
> does it start over at .001 and over-write you initial files, or does it
> continu
> =
> 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 Err
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) 52
>
> 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:
http://www.mysql.com/manual.
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'
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')
>
> Distribution wise the d0key values are loaded in order. there are 300
> distinct d0keys, 300 distinct d0keys and 100 distinct d2keys.
>
> The next step is creating an index as follows :
>
> CREATE UNIQUE INDEX fact0_pk ON fact0(d0key,d1key,d2key) ;
>
> Whichunfortunatly takes about 20m (
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 t
Järkeborn 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 http://
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 enam
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
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] -
_/ _/ _/ _/ _/
Hi,
look at the latest patch:
http://www.innodb.com/bugfixes.html
> Dvořáček 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/m
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 ta
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 u
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 documentati
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 PROTECT
Alok Kaushik wrote:
>
> I am installing mysql on red het linux from .rpm distribution.Would you
> please tell me that what is the default port number of mysql sql server on
> it.
3306
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PROTECTED] -
_/ _/ _/ _/ _/ Wirtualna
> > 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
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'
linuxthreads
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'
linuxthreads
Mette Mřller 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] -
_/ _/ _/ _/ _/
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)
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
"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 pass
"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]'
> Su
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
> make[2]: Entre dans le répertoire
> `/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
> ../li
Ryan wrote:
>
> Is it possible to store raw data (like image data) in mysql? If so, how can i
>accomplish it? (Should i need to make user-defined type?) Otherewise, what other
>databases support storing raw data?
You can use blob type.
--
_/_/ _/_/_/ - Rafał Jank [EMAIL PRO
77 matches
Mail list logo
