compiling mysql 4.0.4 error
Hello, i've problem with building mysql on RH 7.3 configure options: ./configure --prefix=/usr/local \ --libexecdir=/usr/local/sbin \ --localstatedir=/usr/local/var/mysql \ --with-pthread \ --with-unix-socket-path=/tmp/mysql.sock \ --with-mysqld-user=mysql \ --without-debug \ --without-docs \ --without-bench \ --without-innodb \ --without-extra-tools \ --with-charset=czech \ --with-extra-charsets=all \ --enable-thread-safe-client \ --enable-assembler \ --with-openssl i don't need innodb tables. I got: g++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME=\/usr/local\ -DDATADIR=\/usr/local/var/mysql\ -DSHAREDIR=\/usr/local/share/mysql\ -DHAVE_CONFIG_H -I./../include -I./../regex-I. -I../include -I. -I/usr/local/include-O3 -DDBUG_OFF -march=athlon -O3 -fno-implicit-templates -fno-exceptions -fno-rtti -c ha_berkeley.cc make[3]: *** No rule to make target `../innobase/include/../ib_config.h', needed by `ha_innodb.o'. Stop. make[3]: Leaving directory `/usr/local/src/mysql-4.0.4-beta/sql' make[2]: *** [all-recursive] Error 1 make[2]: Leaving directory `/usr/local/src/mysql-4.0.4-beta/sql' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/mysql-4.0.4-beta' make: *** [all-recursive-am] Error 2 innobase/include/../ib_config.h doesn't exists but exists innobase/include/../ib_config.h.in Solve: copy ib_config.h.in to ib_config.h (or repair configure sripts, automaheader, automake, ) Regards, Michal Dvoracek [EMAIL PROTECTED] SQL, TABLE - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
user
Hello, is possible to create user which will be not able to create other users and will have full access to all existing databases and databases which will be created in future? Thank you. Regards, Michal Dvoracek [EMAIL PROTECTED] mysql,query,sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql documentation prompt
Hello, http://www.mysql.com/doc/m/y/mysql.html there is section how to set up own prompt for mysql. I tryed but doesn't working. (tested on 3.23.43 and 4.0.1-alpha) Is possible to set up own prompt in mysql ? Regards, Michal Dvoracek [EMAIL PROTECTED] sql, table, select - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
to_asci
Hello, i need function that will convert non-english characters () to english. Some values in table contains non-english characters and i need search them. (via LIKE) In posgresql is function to_ascii. Regards Michal Dvoracek [EMAIL PROTECTED] sql,query,table - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
join group problem
Hello, i have 2 tables, one: ++---+ | id | descr | ++---+ | 1 | fir | | 2 | two | | 3 | fre | | 4 | fou | ++---+ two: ++--+ | id | data | ++--+ | 1 | a| | 1 | b| | 1 | c| | 1 | d| ++--+ SELECT one.descr, COUNT(two.id) xxx FROM one LEFT JOIN two USING(id) GROUP BY two.id ORDER BY one.id; i got: +---+-+ | descr | xxx | +---+-+ | fir | 4 | | two | 0 | +---+-+ 2nd row is what(mysql Ver 11.15 Distrib 3.23.43, for pc-linux-gnu (i686)) ??? I tested it home and i got only one row (tested on mysql 4.0.1 on win). but i need this result: descr count -- fir 4 two 0 fre 0 fou 0 it's possible to get this result in one guery ?? i need that goup by will affect only join, no whole query. Thank you for help. Regards, Michal Dvoracek [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
analyze/check
Hello, in my work we updated mysql from 3.22.23 to 3.23.49. But there are some problems: mysql describe uzivatele; +-+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--+--+-+-++ | id | int(11) unsigned | | PRI | NULL| auto_increment | | jmeno | varchar(8) | | UNI | || | heslo | varchar(32) | | | || | plne_jmeno | varchar(64) | | | || | posledni_prihlaseni | int(10) unsigned | | | 0 || | aktivni | char(1) | | MUL | n || | pocet_prihlaseni| int(10) unsigned | | | 0 || +-+--+--+-+-++ mysql select * from uzivatele; ++---+--+-+-+-+--+ | id | jmeno | heslo| plne_jmeno | |posledni_prihlaseni | aktivni | pocet_prihlaseni | ++---+--+-+-+-+--+ | 1 | admin | ccf6d8aeb9a3f1c424b9536859803861 | Michal Dvoek | |1018603709 | a | 37 | | 2 | kpo | d2d4383dd938b5a0531ec00396e5bfcd | Klra Polvkov | |1018603813 | a | 205 | | 4 | sce | 59881fd5889ab2d711dbfd13db901936 | Silvie ern| |1017518443 | a | 34 | | 5 | jpr | 8da062fa96aa2cab771ea087a1fa7db2 | Jakub Prochzka | |1018603806 | a |6 | | 6 | hsr | 00786ec4d5c2972eb610826b74a4fe8b | Hana rajerov | |1018451119 | a |1 | ++---+--+-+-+-+--+ first problem was in simple query (from mysql.log): SELECT * FROM uzivatele WHERE aktivni = 'a' AND jmeno = 'kpo' AND heslo = 'd2d4383dd938b5a0531ec00396e5bfcd' old version returns one row (was excepted:) but new version return nothing! and next problem is with analyze/check/repair table mysql analyze table uzivatele; +-+-+--++ | Table | Op | Msg_type | Msg_text | | +-+-+--++ | sante.uzivatele | analyze | error| The handler for the table doesn't support |check/repair | +-+-+--++ First problem is solved (dump database, drop database, flush, create database, read from dump) but second problem is still actual. Can you help me, please ? Thank you. Michal Dvoracek [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
default value
Hello, s possible to create table with default value returned by built-in function ?? like: create table x (a int not null default UNIX_TIMESTAMP()); When inserting new column in table field a will contains timestamp? sql,query Regards, Michal Dvoracek [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
innodb on xfs
Hello, innodb can't be created on xfs ??? InnoDB: Warning: operating system error number 2 in a file operation. InnoDB: Cannot continue operation. 020216 14:25:49 mysqld ended S pozdravem Michal Dvoracek [EMAIL PROTECTED] Capitol Internet Publisher, Korunovacni 6, 170 00 Prague 7, Czech Republic tel.: ++420 2 3337 1117, fax: ++420 2 3337 1112 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
innodb
Hello, is possible on the fly change size of innodb tables ?? i create table 1G large but is small and i need enlarge it. Can i change number in my.cnf or something else ? S pozdravem Michal Dvoracek [EMAIL PROTECTED] Capitol Internet Publisher, Korunovacni 6, 170 00 Prague 7, Czech Republic tel.: ++420 2 3337 1117, fax: ++420 2 3337 1112 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re[2]: Uninstall MySQL!!!
Hello, if get this, try install the _SAME_ package(rpm -i or rpm -Uv) a then run rmp -e. if above failed try manualy delete all files created by this rmp (rpm -ql) and then run rpm -e --noscripts --notriggers --nodeps. Michal aka Lampa mysql, table, query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
pam_mysql
Hello, anybody tryed %subj% ??? I have problem - module doesn't work. I must recompile mysql with some directive like --lpam or --enable-pam ?? Michal table, query, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
wait or install ??
Hello, i must install MySQL on my Linux Box to end of this week. So is better install version 4.0 or wait a while for 4.1 release ?? When will be 4.1 released ??? Regeards Michal query, table, sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql4 on win nt
Hello, i installed mysql-max-4. i need use czech sorting - i set [mysqld] default-character-set=czech but create table xx (t varchar(10)); insert into xx values('a'); insert into xx values('c'); insert into xx values('t'); insert into xx values('s'); insert into xx values('b'); insert into xx values('d'); select * from xx order by t; +--+ | t| +--+ | a| | b| | c| | d| | s| | t| +--+ insert into xx values('è'); (è is c with grave accent) in czech language is è after c select * from xx order by t; +--+ | t| +--+ | è| -- bad | a| | b| | c| -- must be after this letter. | d| | s| | t| +--+ So where is problem ? when trying set win1250 charset i got (setting charset to latin 2 produce is same problem): C:\Program Files\mysql\bin\mysql.exe: File 'C:\mysql\\share\charsets\?.conf' not found (Errcode: 2) C:\Program Files\mysql\bin\mysql.exe: Character set '#26' is not a compiled character set and is not specified in the 'C:\mysql\\share\charsets\Index' file C:\mysql\\share\ -- this path is invalid!!! in my.ini i set: basedir=C:/Program Files/mysql datadir=C:/Program Files/mysql/data language=C:/Program Files/mysql/share/czech character-sets-dir=C:/Program Files/mysql/share/charsets default-character-set=win1250 skip-innodb Michal table, sql, database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: About MYSQL APIs
Hi, on freshmeat.net you can find some libraries which provide same comfort as mysql++, so try check... S pozdravem Michal Dvoracek [EMAIL PROTECTED] Capitol Internet Publisher, Korunovacni 6, 170 00 Prague 7, Czech Republic tel.: ++420 602 210 900, ++420 2 3337 1117, fax: ++420 2 3337 1112 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php