Re: InnoDB backup - the best way.

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

Re: mysql under unix in batch mode

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

Re: InnoDB Foreign Key

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

Re: Duplicate keys?

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

Re: tuning problem or bug?

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:

purging of relay logs?

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

Re: Error 7 - Errorcode 13

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

Re: Very slow select query with IN(...)

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:

Re: building 4.1 from source

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

Re: how to write a scheduled job for MySQL

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

building 4.1 from source

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

Re: Foreign key in INNODB

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

Re: Foreign key in INNODB

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)

Re: innofb foreign keys problem

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

Re: Bug in foreign keys

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

Re: Bug in foreign keys

- 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

Re: Bug in foreign keys

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

Re: 2013 Error

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

Bug in foreign keys

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

Re: Bug in foreign keys

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

Re: ERROR ON CONNECTION

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

Re: distinct and distinctrow

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;

Re: constraints and InnoDB

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

Re: skip logging on one database

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

innodb and table_cache

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,

Re: SELECT....UNION SELECT.....

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

Re: Mysql does not start, what can I do?

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.

Re: Character set

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

Re: mysql duplicate table

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,

Re: user

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.

Is this a bug?

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

maximum index size?

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

Re: Bug MySQL?

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

Re: Is there a function like for multiplying grouped values ... ?

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

Re: MySQL dying suddenly

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

Signal 11 after flush privileges

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

Re: Signal 11 after flush privileges

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

Re: Problem with binlog (bug?)

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

chattr +A

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

Re: Replication - thoughts and ideas

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

Re: How to duplicate a table complete with indexes? #

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

Re: selecting over various tables

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

Re: 2 masters 1 slave replication

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

Problem with compiling version 4.0.1

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

Re: Database Replication problem

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

Re: Replication problem (with temporary heap tables ?)

= 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

Rotating error log?

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)

Re: general sql question

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 _/_/_/_/

default table type

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:

Why is mysql locking tables on insert

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')

Re: Why is mysql locking tables on insert

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

Re: Help Urgent!!!

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

Re: Equivalent as UNION (Oracle)

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

Binlogs numbers

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] - _/ _/ _/ _/ _/

Re: MySQL error 145

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

Re: Inner selects

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 =

Re: compiling error

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

Re: Query optimization issue.

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

Re: Query optimization issue.

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

Re: Replication problems

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

Innodb and statistics

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

Error in linking MySQL 4.0

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'

Re: Multiple Tables

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

Re: Can only create 127 records in a table :o(

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 -- _/

Quota?

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] - _/ _/ _/ _/ _/

Size of the bin log

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

Re: need help for a simple request

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).

Re: emergency help

"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:

Re: emergency help

"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

Re: Problem in compiling Mysql source 3.23.38

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

Re: SELECT question.

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