Re: MySQL 5.1.24-rc has been released (part 1 of 2)

On Wed, 16 Apr 2008 16:43:01 +0200 Kent Boortz [EMAIL PROTECTED] wrote: * Disk Data: Important Change: It is no longer possible on 32-bit systems to issue statements appearing to create Disk Data log files or data files greater than 4 GB in size. (Trying to create log files or data

Re: Stored proc permissions question

On 2007-02-28 Gary W. Smith wrote: Basically, here is the stored proc. It works, but only for root. Is it possible to allow user to execute this without having SELECT access to the table users? If so, how? Do you know about the SQL SECURITY { DEFINER | INVOKER } options to CREATE

Re: Stored proc permissions question

On 2007-02-28 Gary W. Smith wrote: ... If I'm understanding the docs correct (which I'm probably not), I should create the procedure with [EMAIL PROTECTED] CREATE [EMAIL PROTECTED] PROCEDURE Better add SQL SECURITY DEFINER to it. .. The next question is what permissions do I need to give

Re: Key buffer partially unused - why

On 2007-02-20 Martijn van den Burg wrote: Hi, I have allocated 500MB to key_buffer_size, but only 324MB is in use (64%). Am I right to assume that this can mean one of the following: (1) all indexes have already been cached and together they are just 324 MB, Do find /var/lib/mysql -name

Re: No Data on table

On 2007-02-19 Nhadie Ramos wrote: Hi Christian, Thanks for the reply. I got the table repaired and deleted some data on it. What combination can i use to overcome the 4GB limit? Read http://www.suse.de/~aj/linux_lfs.html and google a bit. Basically any recent Kernel 2.4 or 2.6 should do.

Re: No Data on table

Hello On 2007-02-18 Nhadie wrote: I had an error that my database is already full, when i do a select there is always no result even select * from tablename. but when i look at it on /var/lib/mysql i can see the size of the file is still huge, -rw-rw 1 mysql mysql 9174 Feb 18

Re: Data back up for innodb tables - Copy paste

On 2007-02-19 abhishek jain wrote: I want to copy paste the data files of Innodb database, is it possible, i mean can i just copy the data files like that we do for myisam tables If you mean for a daily backup while the server is running: No! You often end up with corrupted tables doing that

Re: Updating from 4.0.20 to 5.0.27

On 2007-02-06 Dan Nelson wrote: In the last episode (Feb 06), Tim Johnson said: I'm currently using OS linux slackware 10.0 with MySQL version 4.0.20 I currently use python and rebol APIs to MySQL, not PHP. I've downloaded mysql-standard-5.0.27-linux-i686.tar.gz Questions: Should

Re: rounding digits after decimal sign

On 2007-01-31 [EMAIL PROTECTED] wrote: Can anyone point me to a section of manual or link how to reduce digits Lookup the manual for round() but be sure that you understand it if you use round in financial applications as it might be unexpected for you: mysql SELECT 25E-1 = 2.5,

Re: InnoDB vs MyISAM

On 2007-01-04 Octavian Rasnita wrote: I have seen that by default some tables are created as InnoDB and some as MyISAM. I guess the table type is not chosen randomly. How is it chosen the table engine used? You can set a global and IIRC a database specific default for the database type.

Re: URGENT: Question on table storage

On 2006-12-19 Prem wrote: I am using this table to store all the websites accessed by each employees. I hope you're aware that your country might have data privacy laws, too.. There is no primary key on that table since the same employee will access more than 100 sites per day. If there

Re: mysqldump problem

On 2006-11-09 VenuGopal Papasani wrote: hi all, I have got a problem with mysql and i want to uninstall it and then re-install it but the problem is how to recover my data. This seldom solves problems. What problem do you have, maybe we can help without having you uninstall your server :)

Re: ORDER BY RAND() gives me duplicate rows sometimes

On 2006-11-09 Daevid Vincent wrote: I am using this query to pull three random comments from a table: SELECT *, DATE_FORMAT(created_on, '%b %D') as date_format FROM comments ORDER BY RAND() LIMIT 3; The problem is that sometimes, I get two of the same comment. How can I refine this

Re: Regular expression not working as expected (documented)?

On 2006-11-08 Leandro Guimarães Faria Corcete DUTRA wrote: u.login REGEXP '^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*' ... But I get, among otherss, a string beginning with 'walt' (several, in fact). Probably MySQL don't know about this [.period.] thing and

Re: Regular expression not working as expected (documented)?

On 2006-11-08 Leandro Guimarães Faria Corcete DUTRA wrote: u.login REGEXP '^wa[bhkl][_[.period.]-acegmnopqrsuvwxyz]{1,5}[14Lt][23890IJOQ].*... But I get, among otherss, a string beginning with 'walt' (several, in fact). Probably MySQL don't know about this [.period.]

Re: wait_timeout help

On 2006-11-07 Sayed Hadi Rastgou Haghi wrote: Dear All, I want to set wait_timeout variable on mysqld startup. Is there any way to do that? Put wait_timeout = XXX into the [mysqld] stanza of your /etc/mysql/my.cnf (or wherever your global config file is). bye, -christian- -- MySQL

Re: wait_timeout help

On 2006-11-07 Sayed Hadi Rastgou Haghi wrote: Thanks But this sets. GLOBAL wait_timeout variable. Cab be seen by SHOW GLOBAL VARIABLES not by SHOW VARIABLES; Ah, yes, MySQL is very confusing about this special variable: You have to use interactive_timeout = XXX to change what is called

Re: Sorting MySQL queries

On 2006-11-06 Dotan Cohen wrote: I have a list of subjects, such as Linux, Open Source, and the World Wide Web. The subjects are stored in MySQL and being retrieved via php. I currently organize them alphabetically with MySQL's ORDER BY ASC argument, however, if there is a preceding the or

Re: Sorting MySQL queries

On 2006-11-06 Dotan Cohen wrote: Make a second column that only contains ALTER TABLE table ADD cooked_subject; UPDATE table SET cooked_subject = ereg_replace('^(a|the) ', '', subject); (I don't know how the regular expression function was called exactly but you get the idea)

Re: Default Column Value

Hi On 2006-11-05 Bill Guion wrote: In one of my tables I have a start_date - timestamp (2007-07-04). A separate column, start_yr_mo, has 200704 (first seven characters of timestamp without the '-'). Both are entered manually. Can I define start_yr_mo as a default of, for example, set

Re: source compilatio or install precompiled packages

On 2006-10-24 Jose Manuel Peso wrote: Why is recommended the precompiled package install way (as i read in the downloads page)? Because a different compiler version or different installed libraries can result in a slightly different binary. If you happen to experience a bug later it's easier

Re: mysql within firewall

Hello Peter On 2006-10-05 Peter Gershkovich wrote: Problem: When we run a large query (returns 4000 records) on a firewalled XServe (OS X 10.4) against Mysql database (outside firewall) on an AIX (Version 5.2) machine the database server intermittently generates the following errors:

Re: Mysqlimport complex question

On 2006-10-04 Scott Hamm wrote: OBJECTIVE: INPUT: E524541015.txt:20061004|,535,999|Scot|Hamm|,410|||101 Walter Rd|Dover|MD|76709|,041| ... Been trying to get mysqlimport to use these characters to no avail, how do I get around to it? I can't answer your question but think that you're

Re: Glitch in Query Optimizer

? Search the docs for FORCE INDEX () and IGNORE INDEX () if you don't want to rely on MySQL's cleverness. bye, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller

Understanding Query-Cache math...

| +--++ thanks, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller Lütticher Straße 10 Tel 0241/701333-11 [EMAIL PROTECTED

Re: How to make this work ?

On Fri, Sep 01, 2006 at 03:17:14PM +0530, [EMAIL PROTECTED] wrote: How to make this work CREATE TABLE DB2.tblname LIKE DB1.tblname; It does work perfectly with 5.0. Mabe cross-database queries didn't work with earlier versions? Which version do you use? Can we have simultaneous

How to utilize 16 logical CPUs

inefficient queries and wrong configuration settings, too, but as this would get quite complex then I first want to rule out this cause) thanks, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized

Re: How to utilize 16 logical CPUs

| +-++ 199 rows in set (0.00 sec) -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller Lütticher Straße 10 Tel 0241/701333-11 [EMAIL PROTECTED]D

Re: How to utilize 16 logical CPUs

into the process memory. bye, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller Lütticher Straße 10 Tel 0241/701333-11 [EMAIL PROTECTED]D-52064

Re: How to utilize 16 logical CPUs

0 7 5 88 0 1 0 0 2958220 139712 383074800 0 596 3904 0 8 5 87 0 bye, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller

Re: Lots of threads in opening tables and closing tables state

Hallo On Thu, Jun 22, 2006 at 01:54:07PM -0500, Dan Buettner wrote: Christian, I hope raising the open_files_limit helps (I think it should). I second Brent's suggestion to enable the thread_cache. Please do report back and let us know how you fare. The effect that lots of tables are in

Lots of threads in opening tables and closing tables state

| SELECT data.id, data.xms_created created, data.xms_modified modified, data.xms_l | -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller Lütticher

Re: Lots of threads in opening tables and closing tables state

| | wait_timeout| 28800 | +-+--+ 196 rows in set (0.00 sec) Christian Hammers wrote: Hello We have the problem

Re: Problems upgrading from 4.0 to 4.1

not something extremly stupid from my side, can you open a bug report to make the issue easier to track? bye, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller

Re: Problems upgrading from 4.0 to 4.1

, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner - Authorized Reseller Lütticher Straße 10 Tel 0241/701333-11 ch@westend.comD-52064 Aachen Fax

Re: DATE TIME

On Wed, Apr 06, 2005 at 12:06:37PM +0200, Hans Bernard wrote: i need to have the time in this output. in MySQL database phpmyadmin always puts -00-00 i need it to be like this 01-APR-2005 DD-MMM- Use date_format(, %d-%b-%Y %H:%m) in your SELECT? bye, -christian- -- MySQL

Problems upgrading from 4.0 to 4.1

table sizes near 4GB. All tables were checked and dumped on a regular basis without problems. After recreating them I had no further problems so far. bye, -christian- -- Christian Hammers WESTEND GmbH | Internet-Business-Provider Technik CISCO Systems Partner

mysqlcheck (not myisamchk) harmful?

Hello A user of the Debian packages that I maintain reported a problem with the mysqlcheck --all-databases --fast --quiet command that is run in the /etc/init.d/mysql script just after the server is up and running as reported by mysqladmin ping. According to all documentation that I found and

Idea: Syntax help on command line

Hello I use the mysql command line tool quite often and always wondered why there's no feature that lets me quickly see the syntax of a FOREIGN KEY or GRANT command. Now while browsing the source I found the new syntax command in 4.0.12 and got the idea of implementing this syntax help of myself.

Re: lsof +L1 - mysql.err.1 unlinked ...

Hello On Tue, Jan 07, 2003 at 11:25:18PM +0100, Christian Jaeger wrote: I have always these mysql.err.1 files not unlinked in all my mysqlservers, and only a mysqld restart resolve these (nor reload neither mysqladmin refresh doesn't unlink them). The err file is created by safe_mysqld to

Do I have to modify mysql-bin.index when purging old binary logs?

Hi Subject says all, is everything fine when I just flush-logs every morning and remove every logfile that is older than 30 days? Or do I have to delete the corresponding line from the index file as well? Whatfor is it needed, btw? bye, -christian- # for the bot: mysql php query

Please clarify copyright of shared library.

Hello The follwing bug was reported against the Debian libmysqlclient10 package. Can you comment on this? The mentioned /usr/share/doc/ copyright file includes a copy of http://www.mysql.com/doc/C/o/Copyright.html bye, -christian- On Sun, Nov 10, 2002 at 05:03:06PM +0100, Andreas Metzler

Package references deprecated errno@GLIBC_2.0 symbol because it uses errno without including errno.h

Hello The following bug was reported against the Debian mysql package bug seems to be a generall problem. bye, -christian- On Sun, Nov 10, 2002 at 02:32:08PM +0100, Luca Barbieri wrote: Package: libmysqlclient10 Version: 3.23.53-3 Severity: important One or more programs or libraries in

2 bugs in mysqlaccess

Hello First bug: The contact address is no longer existing: BUGs can be reported by email to [EMAIL PROTECTED] Second bug: perl does not substitute the '~' char to the home directory: --- /tmp/mysqlaccess.orig 2002-08-27 08:25:23.0 +0200 +++ /usr/bin/mysqlaccess

Re: Bug#151302: mysql-server: transparent gzip support on selected columns

Hello MySQL developers I forward this in behalf of a Debian user who filed a bug report against the Debian package. bye, -christian- On Fri, Jun 28, 2002 at 07:21:26PM +, [EMAIL PROTECTED] wrote: Package: mysql-server Version: 3.23.50-1 Severity: wishlist Currently I have about

Re: restart/flush needed when using symlinks?

Hello Is a restart/reload or a flush tables necessary when creating or removing databases? bye, -christian- cookie-for-the-robot: sql,query -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241

Patch for mysql_read_default_options segfault

Hello FYI, here is a patch that was submitted through the Debian Bug Tracking System for bug #145322. (for those who don't like to upgrade etc.. it is fixed in the 3.23.50) bye, -christian- On Mon, May 20, 2002 at 06:55:19PM +0200, [EMAIL PROTECTED] wrote: Hi, I had a similar problem

Re: compile problem with 3.23.50

On Wed, Apr 24, 2002 at 02:27:40PM +0300, Sinisa Milivojevic wrote: mysqld.cc:2428: at this point in file /usr/include/tcpd.h:119: too few arguments to function `int hosts_access(request _info *)' mysqld.cc:2429: at this point in file /usr/include/tcpd.h:153: too few arguments to

What's up with the mysql_read_default_group segfault bug?!

Hi That using mysql_read_default_group can produce segfaults is known since at least a month and there were two independend bug reports, one from me: http://listarchive.nextrieve.com/mysql//200203/msg01938.html Are there any patches available? Monty said something about 3.23.50 but although

typo in configure regarding enable-local-infile

Hi In case nobody noticed yet: configure.in line 590: # compile with strings functions in assembler AC_ARG_ENABLE(local-infile, [ --enable-local-infile If LOAD DATA LOCAL INFILE is enabled by default.], [

bug: segfaults with mysql_read_default_group!

Hello There is a problem with the myslq_read_default_group function! It's DBI 1.21, DBD::MySQL 1.2216 and mysql-3.23.49, compiled on the very latest Debian unstable (I'm the mysql maintainer of Debian). bye, -christian- There is no section ch in /etc/mysql/my.cnf and no ~ch/.my.cnf. The same

Where is 3.22.35? I need it due to the coredump bugfix.

Hello I was notified about a coredump bug in MySQL 3.22.xx. As this can be used as DoS I like to update the MySQL packages I maintain for the Debian GNU/Linux distribution. I would like to have specifically the 3.22.35 as the bug seems to be fixed there according to the changelog and I don't

[patch] corrected manpage headers

Hello To get apropos working and the header comply to man(8) you should apply the following command on the man/ directory: perl -pi -e 's/^\.TH\s+(\S+?)\s+.*/sprintf(.TH %s 1 \19 December 2000\ \MySQL 3.23\ \MySQL database\, lc($1))/e' *.1 bye, -christian- [EMAIL PROTECTED]

Re: Bug#129284: mysql-client: some short options doesn't work

FYI -christian- On Mon, Jan 14, 2002 at 11:54:42PM +0100, Artur R.Czechowski wrote: Package: mysql-client Version: 3.23.46-2 Severity: minor mysqldump: invalid option -- Q long GNU option --quota-names used instead works Please fix documentation or client :) Sincerelly Artur

Fwd: Bug#128473: [patch] the mysql crashes on the -D option

FYI -christian- On Wed, Jan 09, 2002 at 08:52:34PM +0100, Sjoerd Simons wrote: Package: mysql-client Version: 3.22.32-6 Severity: normal Tags: patch mysql -D something causes a segv, the attached patch to mysql.cc seems to fix this.. ... --- mysql.cc.orig Wed Jan 9 20:46:07 2002

WISHLIST: auto_increment after delete

to use..) thanks, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner - Premium Certified

Re: Bug#119076: mysql-server: signal 11

Hello I forward this bug report to this list as it seems to be not Debian specific. MySQL crashes with several kinds of /etc/nsswitch.conf configurations. bye, -christian- On Tue, Nov 13, 2001 at 11:45:27AM +1100, Brian May wrote: Christian == Christian Hammers [EMAIL PROTECTED] writes

Bug? SET @T=db; SELECT * FROM @T;

Hi The above statement does not work :-( This is sad as it would be a nice feature. bye, -christian- mysql SET @RF='user'; Query OK, 0 rows affected (0.00 sec) mysql SELECT * FROM @RF; ERROR 1064: You have an error in your SQL syntax near '@RF' at line 1 -- Christian HammersWESTEND

build problems on powerpc with 3.23.42

Hello I have problems building the mysql package for the Debian distribution on powerpc. More infos below. Feel free to contact me for further details. bye, -christian- make[3]: Entering directory `/home/ch/debian/mysql-3.23.42/sql' g++ -DMYSQL_SERVER

myodbc2.50.37 failed to build on ia64

FYI -christian- Date: Sat, 25 Aug 2001 21:46:03 -0700 From: Randolph Chung [EMAIL PROTECTED] To: [EMAIL PROTECTED] Reply-To: Randolph Chung [EMAIL PROTECTED], [EMAIL PROTECTED] Package: myodbc2.50.37 Version: 2.50.37-3 Severity: important See attached build log. Looks like the

won't build on hppa

Hello Does anybody know how to get MySQL build on HPPA architecture? bye, -christian- -- Real men don't take backups. They put their source on a public FTP-server and let the world mirror it. -- Linus Torvalds Package: mysql Version: 3.23.39-1

fails to build on ARM architecture

Hello Does anybody know if MySQL can be build on the arm architecture? (This bug was reported against the Debian MySQL packages) bye, -christian- With 3.23.37-3 I'm now seeing a different failure: gcc -DDEFAULT_CHARSET_HOME=\/usr\ -DDATADIR=\/var/lib/mysql\ -DSHAREDIR=\/usr/share/mysql\

[jcz@mylinepcx.com: Bug#95872: replication failure]

Hello This came through the Debian BugTrackingSystem but I have no clue about it. bye, -christian- Package: mysql-server Version: 3.23.33-3 Severity: normal from /var/log/mysql.err: 010430 16:06:52 Slave: Failed reading log event, reconnecting to retry, log 'FIRST' position 4 010430

TYPE=BDB is ignored!

Hello I compiled on an UltraSparc II Linux with libc-2.2.2 and say CREATE TABLE t (t int) TYPE=BDB; but it creates a MyISAM without any warning. Why? BDB seems to be compiled in correctly: ch@vore:~/test$ nm usr/bin/mysqld |grep berke 000822c0 t _GLOBAL_.D.have_berkeley_db

please tell me what Init in processlist means

e problems with...something... Can anybody explain what "Init" does? thanks in advance, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Syste

BUG: alter table destroys symbolic links!

his is a way to more around the system administrators disk-quota settings! This was tested with the latest MySQL-3.23.35 on linux (ext2 reiserfs, although this shouldn't matter in for the symlink handling) bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel

warning: mysql local root exploit when running as root

, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner - Premium Certified Hi, At first, an apology if this came by earlier, i

[philb@gnu.org: Bug#88186: mysql: Fails to build on ARM: char sign issue?]

Hi Hope this helps you to make mysql working on ARM architecture, too. bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner

What to optimize when disc activita is very high?

Try number of CPU's*2 set-variable= myisam_sort_buffer_size=16M -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner

decimal(8,2) rounding bug or still to be expected behaviour?

- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner - Premium Certified - Before

optimizing select on big table

---+ | channel_traffic | range | PRIMARY | PRIMARY | 8 | NULL | 1636199 | where |used; Using temporary | +-+---+---+-+-+--+-+---------+ thanks, -christian- -- Christian HammersWEST

Re: optimizing select on big table

realized that timestamp is my "main" column but does adding another seperat timestamp something? The docs say that searching for the first part of a multiple-key is fine. bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL

Re: decimal(8,2) rounding bug or still to be expected behaviour?

g the sums) bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner - Premium

wishlist: create_tmp_priv in mysql.db

the right to populate the harddisc with permanent data i.e. with real create statements. Or is there an easier solution? bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879

optimising joins: where vs. using/on

tablea a LEFT JOIN table b USING (id) LEFT JOIN table c USING (nr) Is one of the two ways preferred about the other? I like my way as it is easier to read and understand but would use anything to gain some speed in my 5+ hour selects... bye, -christian- -- Christi

Re: optimising joins: where vs. using/on

? If you have 5 hour selects you are probably missing some vital indexes, or you are using a long of like '%blah' or "OR" ... or using 1.5GB big tables... thanks, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet

Question regarding query optimising with between

---+--+-+--++----- + 1 row in set (0.00 sec) -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/9

[hazelsct@mit.edu: Bug#88186: mysql: Fails to build on ARM: char sign issue?]

Hello Any ideas? -christian- Package: mysql Version: 3.23.33-1 Severity: normal Greetings, The build fails on ARM. Here's the end of the build log: g++ -DMYSQL_SERVER-DDEFAULT_MYSQL_HOME="\"/usr\"" -DDATADIR="\"/var/lib/mysql\"" -DSHAREDIR="\"/usr/share/mysql\""

tab-completition not working with libreadline4

Hello Since a few weeks tablename completition using tab is not working any longer. I build with bundled lbireadline and with my system libreadline (4.2) but neither work as I am used to. Any ideas? bye, -christian- -

Re: Antwort: tab-completition not working with libreadline4

. Now I think I have to read a bit docs what this rehash thing does and why I suddenly have to type it. bye, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879 WESTEND ist

[chris@debian.org: Bug#86033: [PATCH] Alpha patches for mysql]

Hello In case this patch wasn't post here. bye, -christian- Package: mysql Version: 3.23.33-1 Severity: important Tags: patch Below is a patch against mysql 3.23.31 (but applies well to 3.23.33-1) for things to work properly on Alpha. I've been applying this diff against most of the

Re: MySQL 3.23.33 released

Michael, it would be very nice if you would mark security related bugs so that admins who are not subscribed on Bugtraq see them, too. This is at least the second time where I got information about security bugs in MySQL *only* via 3rd party and not from the web page nor from the changelog.

chroot strangenesses

Hi I don't understand the way mysql tries to jail itself with --chroot. If I start mysqld --chroot=/var/lib/mysql_jail then it gives me an error saying that it wasn't able to initialize the databases. When I copy the mysql database somewhere into the jail it works. But - when I modify the

SSL - is it there?

Hello I realised several SSL keywords in the Makefiles but cannot find a way to activate SSL/TLS via ./configure. Did I miss something or is there no SSL support implemented yet? Can I expect it for the future? (Would be great!) bye, -christian- -- Save the forests, eat

[cristian.ionescu-idbohrn@axis.com: Bug#82737: building mysql-3.23.30 packages from source fails]

t 4 of `log_archive(DB_ENV *, char ***, unsigned int, void * (*)(long unsigned int))' ha_berkeley.cc:252: passing `void * (*)(unsigned int)' as argument 4 of `log_archive(DB_ENV *, char ***, unsigned int, void * (*)(long unsigned int))' make[4]: *** [ha_berkeley.o] Error 1 Any thoughts? /Cris

Security patch from 3.23.31 backported to 3.22.32 !

a problem with this patch thanks, -christian- -- Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0 [EMAIL PROTECTED] Internet Security for ProfessionalsFax 0241/911879 WESTEND ist CISCO Systems Partner - Premium Certified Dans un message du 21 Jan à

show logs crashes client?!

In case this wasn't reported before: "show logs" in the server makes the client crash. Christopher Lameter reported this via the Debian bug tracking system. bye, -christian- -- codito ergo sum - I code, therefore I am!