Re: Fulltext index is not being built with large database
Hi Matt, thanks for the help. Meanwhile the index has been built, and I assume it's a problem of terminal sessions: At first I tried it with a remote mysql client issuing the ALTER TABLE command. This session was closed after some inactivity. Then I logged in to the database host and retried - same result. Then I packed the commands in a shell script which I ran with nohup - no results whatsoever. No error log entry, no index, no nohup.out. Then I tried it again with a terminal session, but this time I configured the terminal program to send null bytes every 60 seconds to keep the connection open. And voila - after 19 hours the index was built. So it may be a flaw, a bug or even a feature in the mysql client/server protocol - I assume I'll never know. But the index works, and it's speed, ease of use and maintainability will be strong arguments against htdig. s.m. Am Sat, 10 Apr 2004 04:01:15 -0500 hat Matt W <[EMAIL PROTECTED]> geschrieben: Hi sascha, How's the space on your datadir partition (or wherever this table is)? I believe MySQL creates the temp tables during ALTER in the DB directory, not the tmpdir. If the space there is OK, have you checked the error log for anything related? Matt - Original Message - From: "sascha mantscheff" Sent: Friday, April 09, 2004 4:21 PM Subject: Fulltext index is not being built with large database I'm trying to build a fulltext index on a table with about 4 million entries with 2 varchar and one text field. The indexing starts and runs for about 1/2 to 1 hour, then the process stops without any error message. And leaves me with no index. I checked for the size in tmp and redirected it to a partition with 50GB space (about 15 times as much as the database tables). Mysql runs on gentoo-linux 2.4 with 800MB RAM with server version 4.0.17. Any clues, hints or tips? Thank you. sascha mantscheff -- sascha mantscheff hahnenbach 51570 windeck [EMAIL PROTECTED] telefon +49-2292-922 492 telefax +49-2292-922 493 mobil +49-171-620 0380 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fulltext index is not being built with large database
I'm trying to build a fulltext index on a table with about 4 million entries with 2 varchar and one text field. The indexing starts and runs for about 1/2 to 1 hour, then the process stops without any error message. And leaves me with no index. I checked for the size in tmp and redirected it to a partition with 50GB space (about 15 times as much as the database tables). Mysql runs on gentoo-linux 2.4 with 800MB RAM with server version 4.0.17. Any clues, hints or tips? Thank you. sascha mantscheff hahnenbach 51570 windeck [EMAIL PROTECTED] telefon +49-2292-922 492 telefax +49-2292-922 493 mobil +49-171-620 0380 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: order by problem with 3.22
Am Sonntag, 16. Februar 2003 21:15 schrieb Paul DuBois: > At 20:43 +0100 2/16/03, sascha mantscheff wrote: > >The following query works with mysql 3.23: > > SELECT * FROM answer ORDER BY concat( n_sort, "-", id_answer ) > >It does not with mysql 3.22.27. Neither does any query with a function > > call in the order by clause. Is this documented somewhere? Am I missing > > something? Is there a workaround other than upgrading to 3.23? > > Functions in ORDER BY are allowable as of MySQL 3.23.2: > > http://www.mysql.com/doc/en/News-3.23.2.html > > Prior to that, the workaround is to include the expression in the output > column list, alias it, and refer to the alias in the ORDER BY clause: > > SELECT *, concat( n_sort, "-", id_answer ) AS expr > FROM answer ORDER BY expr; thanks a lot, this does it. s.m. - 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
order by problem with 3.22
The following query works with mysql 3.23: SELECT * FROM answer ORDER BY concat( n_sort, "-", id_answer ) It does not with mysql 3.22.27. Neither does any query with a function call in the order by clause. Is this documented somewhere? Am I missing something? Is there a workaround other than upgrading to 3.23? - 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: still no umlauts in mysql --experts help needed
Am Freitag, 22. März 2002 11:58 schrieben Sie: > > Egor: > > Thanks for the hint. I browsed the manual for readline(3) and for > > /etc/inputrc, but found nothing wrong with it. I can enter umlauts in all > > other programs and from the bash command-line - only in mysql they don't > > work. Where else might I look for the source of the problem? > > Schreib doch mal sowas wie > > INSERT INTO test (t) VALUES ("ÄÖÜäüß"); > > in eine Datei und ruf dann > > mysql test < datei > > auf. Was passiert dann? It works -- I'm sure I tested it already with negative results, but now it works. [So much for being sure.] So I can enter umlauts with a file redirection, but not directly in the mysql client. This is good enough for a work-around, but still I'd really like to fix this problem at it's source. s.m. - 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: Can you Change Nulls in the MySQLDump from \N?
can't you filter the output with sed? s.m. Am Donnerstag, 21. März 2002 21:11 schrieben Sie: > Is there a way to tell MySQL to put a blank space instead of \N in the > tab-delimited files when it does a dump? I'm working on a MySQL to SQL > Server migration and having problems with the output files. I'm doing this > all in batch fellas so I'm not finding a good search and replace utility. > (perl, c++, and other langs are not an option..) > > Thanks > > David > > > - > 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 - 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: still no umlauts in mysql --experts help needed
Egor: Thanks for the hint. I browsed the manual for readline(3) and for /etc/inputrc, but found nothing wrong with it. I can enter umlauts in all other programs and from the bash command-line - only in mysql they don't work. Where else might I look for the source of the problem? s.m. Am Donnerstag, 21. März 2002 16:44 schrieben Sie: > sascha, > Wednesday, March 20, 2002, 12:52:41 PM, you wrote: > > sm> Am Mittwoch, 20. März 2002 11:24 schrieben Sie: > sm> > I just installed mysql fresh out of the box on a fresh SuSE linux > 7.1. sm> > mysql does not let me enter german umlauts, though. I tried to > start it sm> > with "mysql --default-character-set=latin_de", but it > complained about sm> > the character sets not being installed. Then I > installed the mysql sm> > server, which in turn installs the character > sets. latin_de is not sm> > included, though. I tried it with "mysql > --default-character-set=german1" sm> > instead. No luck. > sm> > sm> Was meinst Du mit "does not let me enter"? Blockieren die > sm> entsprechenden Tasten? Erscheint nichts auf dem Bildschirm? Gibt es > sm> irgendeine Fehlermeldung? Liefert MySQL bei einem SELECT das Falsche > sm> zurück? > > sm> keystrokes with umlauts do not have any echo on the screen. batch input > (text sm> files with sql statements with umlauts redirected to mysql) do > not insert sm> umlauts into the database (but the rest of the text, so that > the words are sm> mis-spelt). there is no error message. select statements > contain any umlauts sm> in the database, though, and I can enter umlauts > into the database using sm> other clients than mysql. > > Looks like it's a question of readline/local, it's not a MySQL > problem. > > sm> s.m. - 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: logrotate problem
in the postrotate section, you have to add the user and password parameters to mysqladmin: mysqladmin -u someuser --password=somepassword flush-logs s.m. Am Donnerstag, 21. März 2002 19:23 schrieben Sie: > Hello there! > > > I have added recently administrative user to mysql database: > > > #mysqladmin -u root password someposword > > > since then I'm getting every day such e-mail from logrotate demon: > > > Subject: > errors rotating logs > Message: > errors occured while rotating /var/lib/mysql/mysql.log > > > mysqladmin: connect to server at 'localhost' failed > error: 'Access denied for user: 'root@localhost' (Using password: NO)' > error running postrotate script > > > My rogrotate demon have such configuration file for mysql: > /var/lib/mysql/mysql.log { > rotate 3 > daily > compress > postrotate > mysqladmin flush-logs > endscript > } > > > Any advice will be greatly appreciated! > > - > 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 - 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: still no umlauts in mysql --experts help needed
Thank you very much for the hint. The problem occurs on SuSE linux, though, not on FreeBSD, and lang=de_DE. Following your hint, I set LANG=de_DE.ISO_8859-1 The problem still remains. Then I set LANG=de since there is a directory /usr/share/locale/de on the system, but not /usr/share/locale/de_DE Still, no luck. Any more ideas how to solve this problem are warmly welcome. s.m. Am Mittwoch, 20. März 2002 15:57 schrieb Ken Menzel: > Regarding your issue with accents, I understand more now about your > problem, you are using shell tools in free BSD and you have not set > the LANG shell environment variable. Add the folling line to your > shell environments (usually .profile). > LANG=en_US.ISO_8859-1; export LANG > > or for german language shell messaging: > LANG=de_DE.ISO_8859-1; export LANG > > This is a FreeBSD issue, by default LINUX sets the language > environment for the shell to an ISO setting, FreeBSD does not. > > Ken > ----- Original Message - > From: "sascha mantscheff" <[EMAIL PROTECTED]> > To: "Harald Fuchs" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Wednesday, March 20, 2002 5:52 AM > Subject: Re: still no umlauts in mysql --experts help needed > > > Am Mittwoch, 20. März 2002 11:24 schrieben Sie: > > > > I just installed mysql fresh out of the box on a fresh SuSE > > linux 7.1. > > > > > mysql does not let me enter german umlauts, though. I tried to > > start it > > > > > with "mysql --default-character-set=latin_de", but it complained > > about > > > > > the character sets not being installed. Then I installed the > > mysql > > > > > server, which in turn installs the character sets. latin_de is > > not > > > > > included, though. I tried it with > > "mysql --default-character-set=german1" > > > > > instead. No luck. > > > > > > Was meinst Du mit "does not let me enter"? Blockieren die > > > entsprechenden Tasten? Erscheint nichts auf dem Bildschirm? Gibt > > es > > > > irgendeine Fehlermeldung? Liefert MySQL bei einem SELECT das > > Falsche > > > > zurück? > > > > keystrokes with umlauts do not have any echo on the screen. batch > > input (text > > > files with sql statements with umlauts redirected to mysql) do not > > insert > > > umlauts into the database (but the rest of the text, so that the > > words are > > > mis-spelt). there is no error message. select statements contain any > > umlauts > > > in the database, though, and I can enter umlauts into the database > > using > > > other clients than mysql. > > > > s.m. > > > > > > - > > > 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 - 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
different row count in explain select on different systems
I run mysql on a SuSe 7.3 and a FreeBSD 4.5 server. The FreeBSD mysql version is 3.23.49. The linux mysql version is 3.23.33. I just copied a large table using mysqldump | mysql from the linux server to the FreeBSD server. An explain statement on a select on this table shows different row counts on both systems: #SUSE: mysql> explain select id from boardmessages where board=4301 and parent=0 order by id desc limit 0,20; +---+--+---+---+-+---+---++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+---+-+---+---++ | boardmessages | ref | board,parent | board | 4 | const | 16671 | where used; Using filesort | +---+--+---+---+-+---+---++ #FREEBSD: mysql> explain select id from boardmessages where board=4301 and parent=0 order by id desc limit 0,20; +---+--+---+---+-+---+---++ | table | type | possible_keys | key | key_len | ref | rows | Extra | +---+--+---+---+-+---+---++ | boardmessages | ref | board,parent | board | 4 | const | 13629 | where used; Using filesort | +---+--+---+---+-+---+---++ Can anyone explain this strange deviation? s.m. - 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: still no umlauts in mysql --experts help needed
Am Mittwoch, 20. März 2002 11:24 schrieben Sie: > > I just installed mysql fresh out of the box on a fresh SuSE linux 7.1. > > mysql does not let me enter german umlauts, though. I tried to start it > > with "mysql --default-character-set=latin_de", but it complained about > > the character sets not being installed. Then I installed the mysql > > server, which in turn installs the character sets. latin_de is not > > included, though. I tried it with "mysql --default-character-set=german1" > > instead. No luck. > > Was meinst Du mit "does not let me enter"? Blockieren die > entsprechenden Tasten? Erscheint nichts auf dem Bildschirm? Gibt es > irgendeine Fehlermeldung? Liefert MySQL bei einem SELECT das Falsche > zurück? keystrokes with umlauts do not have any echo on the screen. batch input (text files with sql statements with umlauts redirected to mysql) do not insert umlauts into the database (but the rest of the text, so that the words are mis-spelt). there is no error message. select statements contain any umlauts in the database, though, and I can enter umlauts into the database using other clients than mysql. s.m. - 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
still no umlauts in mysql --experts help needed
I just installed mysql fresh out of the box on a fresh SuSE linux 7.1. mysql does not let me enter german umlauts, though. I tried to start it with "mysql --default-character-set=latin_de", but it complained about the character sets not being installed. Then I installed the mysql server, which in turn installs the character sets. latin_de is not included, though. I tried it with "mysql --default-character-set=german1" instead. No luck. This is not a general problem of my system's configuration. Umlauts work from the console, in xterm and konsole and all other editors and programs - except mysql. Does anyone know why? I did not have this problem with earlier mysql installations and do not have it on other machines. s.m. - 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: Cannot access the Database on same Machine
probably something wrong with the permissions in the mysql database. as a workaround, try to connect not via the local socket, but via a tcp/ip-connection: # mysql -h 127.0.0.1 -u my-user -p my-database or insert the real ip of the machine instead of the loopback address. check if there is an entry in the mysql.user table with host="localhost" and user="". this would preclude any local user to log into the database. s.m. Am Dienstag, 19. März 2002 22:04 schrieben Sie: > Hi, > > When i try to access the database which is on my Linux > machine i get the following error: > ERROR 2002; Can't connect to local MySQL server > through socket '/tmp/mysql.sock' (111) > > There is nothing in this file, although i dont know > how to edit it. > > I have gone through the Manual pages and the lists, > all the searches for this type of ERROR, but to no > avail. > > I have used the database before and have tables in > there but for some reason i cannot get in. > > I don't want to reinstall it as i have tables that i > need, I am really stuck so any help will be very much > appreciated, > Thanks > Colin > > > > > __ > Do You Yahoo!? > Yahoo! Sports - live college hoops coverage > http://sports.yahoo.com/ > > - > 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 - 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: cannot enter german umlauts in mysql
hello ken, thanks for the reply, but when I typed "mysql" I meant it without the "d". I'm using the client for lots of batch i/o, little utilities and quick maintenance. I'm using it on quite a couple of systems (linux in all flavors and FreeBSD), but only on one of this systems it shows this misbehaviour with not accepting umlauts. s.m. Am Dienstag, 19. März 2002 21:02 schrieben Sie: > Hi Sasha, > I assume it not a mistake (as you typed 'mysql' twice), but mysql > is the name of the client program, you must start the server program > (safe_mysqld) with the --default-character-set=latin_de. First use > mysqladmin to shutdown the server, then restart it with safe_mysqld. > Also I would recommend that you create a '/etc/my.cnf' file and place > your options in that file. You can find examples in the > 'support-files' directory of the mysql source code. > > Ich hoffe daß ich dir geholfen habe. > Ken > - Original Message - > From: "sascha mantscheff" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Tuesday, March 19, 2002 9:46 AM > Subject: cannot enter german umlauts in mysql > > > I just installed mysql fresh out of the box on a fresh SuSE linux > > 7.1. > > > mysql does not let me enter german umlauts, though. I tried to start > > it with > > > "mysql --default-character-set=latin_de", but it complained about > > the > > > character sets not being installed. Then I installed the mysql > > server, which > > > in turn installs the character sets. latin_de is not included, > > though. I > > > tried it with "mysql --default-character-set=german1" instead. No > > luck. > > > This is not a general problem of my system's configuration. Umlauts > > work from > > > the console, in xterm and konsole and all other editors and > > programs - except > > > mysql. Does anyone know why? I did not have this problem with > > earlier mysql > > > installations and do not have it on other machines. > > > > s.m. > > > > > > - > > > 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 - 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
cannot enter german umlauts in mysql
I just installed mysql fresh out of the box on a fresh SuSE linux 7.1. mysql does not let me enter german umlauts, though. I tried to start it with "mysql --default-character-set=latin_de", but it complained about the character sets not being installed. Then I installed the mysql server, which in turn installs the character sets. latin_de is not included, though. I tried it with "mysql --default-character-set=german1" instead. No luck. This is not a general problem of my system's configuration. Umlauts work from the console, in xterm and konsole and all other editors and programs - except mysql. Does anyone know why? I did not have this problem with earlier mysql installations and do not have it on other machines. s.m. - 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: Checking if Replication really works
Ihre Nachricht vom Friday 18 January 2002 12:14: > sascha mantscheff wrote: > > I'm not using replication, but for a test if it really works I would do > > some data manipulations on the master and afterwards a complete mysqldump > > of master and replica and diff the result. > > ok, this is an new and interesting idea, has anyone an idea how long it > can take to diff two mysqldumps of 300 mb on a AMD 600 with 196 MB RAM? > > henning additional idea: if your concern is memory, gzip or compress both dumps and then compare them. or, write a small tool which chops the dumps in equal chunks of 1 MB or so and compare the chunks. s.m. - 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: Checking if Replication really works
Ihre Nachricht vom Friday 18 January 2002 12:14: > sascha mantscheff wrote: > > I'm not using replication, but for a test if it really works I would do > > some data manipulations on the master and afterwards a complete mysqldump > > of master and replica and diff the result. > > ok, this is an new and interesting idea, has anyone an idea how long it > can take to diff two mysqldumps of 300 mb on a AMD 600 with 196 MB RAM? > > henning does it matter? try it on some smaller tables first, then on the big ones, then on the whole bunch. it will take much less time then to fix any problems afterwards, in case that replication doesn't work as expected. s.m. - 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: Checking if Replication really works
I'm not using replication, but for a test if it really works I would do some data manipulations on the master and afterwards a complete mysqldump of master and replica and diff the result. s.m. - 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
no umlauts in mysql client
help! I upgraded to the most recent version of mysql client (3.23.47) under SuSE linux 7.1. now the client does not accept any 8-bit characters any more - any special character input is discarded (from the keyboard and from the clipboard as well). how can I change that? s.m. qualimedic ag sascha mantscheff telefon 02292-922 492 telefax 02292-922 493 mobil 0171-620 0380 e-Mail [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
Re: Re[2]: Where to find options / my.cnf documentation?
Ihre Nachricht vom Monday 09 July 2001 17:10: > It's so easy, you won't think of it: start mysqld with parameter > -h (=help): > > mysqld -h > > shows all parameters and current settings Alas, it does not. It shows a couple of variable settings, but not the syntax for tha various logging options and the like. So the question for a complete options syntax of my.cnf remains open. s.m. - 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
Where to find options / my.cnf documentation?
Where do I find a complete documentation of all options and entries in my.cnf and the mysqld start options? I searched the mysql.com site, but to no avail. Neither does the online documentation doesn't seem to have a chapter on it. s.m. Qualimedic AG Sascha Mantscheff Telefon 0171-6200380 Telefax 02291-3841 e-Mail [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