Re: Remote Access to MySQL

to connect to mysql remotely, from external IPs. I read a lot of tutorials and tips without success. What I need to do, to come back to working configuration like oldest machine, allowing remote connections? did you check bind-address in your my.cnf? regards Florian -- MySQL General Mailing List

Re: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

that the query sends strings as iso... :/ Thanks again, Florian On Thu, 25 Aug 2005 10:58:07 +0300 Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. What is the value of the default_charset variable in your php.ini file? What version of MySQL do you use? Florian Burkart [EMAIL

Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

] or [mysqld-5.0] for specific configurations. [mysqld] character-set-server= utf8 default-character-set = utf8 ... Probably easy, but help please :) Florian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

] or [mysqld-5.0] for specific configurations. [mysqld] character-set-server= utf8 default-character-set = utf8 ... Probably easy, but help please :) Florian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

row in set (0.00 sec) On Wed, 24 Aug 2005 20:55:21 +0300 Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. Your character_set_xxx variables is ok. The problem could be in the table definition. Send the output of SHOW CREATE TABLE tbl_gruppen; Florian Burkart [EMAIL PROTECTED

Re: Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION'

CREATE TABLE tbl_gruppen; Florian Burkart [EMAIL PROTECTED] wrote: Hey everyone, can't figure this one out, might be easy for one of you. This is the query: (SELECT 'Neue Gruppe' AS gruppenstring, '-1' AS gruppe_id) UNION ALL (SELECT CONCAT( gruppe, ' (', kommentar

change collation on all existing databases, tables and columns

the latin1_german1_ci collation, as the my.cnf entry only works for new entries. Is there an easy command or tool to achieve that? I don't want to send the appropriate command mentioning every single database, table and column, but rather look for a FOR loop or a wildcard. Thanks Florian -- MySQL General Mailing

Does mySQL support Pascal/C++ like Unions

Hello! Does mySQL support a thing like Pascal/C++ unions for attribute types, i.e. an attribute can be of two types at the same time. Thanks in advance. Florian

Re: Faster reindexing

Dathan Vance Pattishall [EMAIL PROTECTED] writes: Maybe increasing #use for when mysql is doing a check or repair set-variable= myisam_sort_buffer_size=64M to a higher value will make the index happen faster on the fly. MySQL doesn't seem to honour this variable. I've set it to

Re: Recomended RAM for production server. 3Gb overboard?

Brad Brad [EMAIL PROTECTED] writes: The OpenBSD server is 2.8Ghz and may have as many as 230 mysql sessions with 14 queries a second, the rest will be sleeping (ftp sessions maintain connection). The db directory is 80mb total, 80 MB? Is this a typo? The old server is seems quite happy

Re: Faster reindexing

Dathan Vance Pattishall [EMAIL PROTECTED] writes: #use for when mysql is doing a check or repair set-variable= myisam_sort_buffer_size=64M to a higher value will make the index happen faster on the fly. Oops. I only adjusted the key_buffer value. Probably I should set

Creeping index syndrome

Does MySQL require periodic reindexing for indexes on columns whose value permanently increases (while the oldest entries are expired)? Another database suffers from the so-called creeping index syndrome, which results in ever-growing indexes in such cases (some pages in the index can never be

Faster reindexing

I've got a table with 100 million rows and need some indexes on it (one row is 126 bytes). I'm currently using MyISAM and the indexing proceeds at an astonishingly low rate: about 200 MB per hour. This is rate is far too low; if we had to recover the database for some reason, we'd have to wait

Re: Mysql - Dual Xeon or Dual Opteron

Konstantin Yotov [EMAIL PROTECTED] writes: 2x1GHz Intel, 1GB RAM, 40GB WD 7200 8MB cache. We are going to uprade our server but I'am wondering between new Opteron (1.4GHz)and Xeon (2.4). Can't you get a machine for testing before you buy it? Xeon processors aren't necessarily a significant

disabling version number

Hi, is there any configuration directive of disabling the output of the MySQL servers version number? Thanks Florian -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: disabling version number

No, why? Part of my security concept, I generally disable all version numbers. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: disabling version number

;-) - Original Message - From: Joseph Bueno [EMAIL PROTECTED] To: Florian Effenberger [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, March 24, 2003 5:39 PM Subject: Re: disabling version number You can patch mysql source and recompile ;) However, if someone has enough access

Mysql Error

to connect at all. Is it possible to remove MySql (and how do I go about it) so that I can reinstall it again? Sorry if these are stupid questions, but I can't seem to find how to uninstall MySql in the manual. Thanks -- Daniel Florian [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL

information

hi, Somebody saw comparaisons of productivity for mysql and others RDBMS? or somebody do comparaisons? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: MySQL-Server doesn't connect to any port

Florian Boehl wrote: Hi, I've got a problem with my mysql-server. I'm using Debian GNU/Linux (Sid). If I start the server there are no error messages at all but the server doesn't connect to any port so communication with it can only be done by the socket file. Has anyone of you

limitation mysql in request?

Hi, in the version 4.0 mysql accepte this request? select where ... IN (SELECT ) subqueries? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

mysql 4.1?

when the version of mysql 4.1 is ready ? - 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

myslq et mysqlmax?

Hi What is the difference between myslq and mysqlmax? Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,

pb connection

Hi, i use mysql v4.0 i have got a problem with the connection to database i can connect if i have localhost but if i want to connect to database i can't. There is a limitation with mysql v4.0 or not ? have you got an idea? thanks

pb connection

Hi, i use mysql v4.0 i have got a problem with the connection to database i can connect if i have localhost but if i want to connect to database i can't. There is a limitation with mysql v4.0 or not ? have you got an idea? thanks

probleme conection

Hi, i use mysql v4.0 i have got a problem with the connection to database i can connect if i have localhost but if i want to connect to database i can't. There is a limitation with mysql v4.0 or not ? have you got an idea? thanks

Re: Re: Re: pb connection

I think it's good but how i can look because i begin to use mysql and i am not very good At 13:09 02/08/02, you wrote: Hello Florian, Friday, August 02, 2002, 1:41:51 PM, you wrote: Please, don't send me your answer, send it to the mailing list. FL i have got access denied Check

Re: Re: Re: pb connection

I think it's good but how i can look because i begin to use mysql and i am not very good What i must put on 'Host'? thanks At 13:09 02/08/02, you wrote: Hello Florian, Friday, August 02, 2002, 1:41:51 PM, you wrote: FL i have got access denied Check permissions for your user. Seems, your user

RE: pb connection

think you should check up with the following: 1. Check the username / password that you are using to connect to the database. 2. Check the port value (default value is 3306) 3. Check the URL syntax. thanks -Original Message- From: Florian Litot [mailto:[EMAIL PROTECTED]] Sent: Friday, August

problem on open a table

HI, I do not manage to open a table it puts me Can' t open takes off: ' pkf_as_events_log. MYD '. (Errno: 145) is what anybody has already had this error on mysql? Cordially Florian - Before posting, please check: http

JOINS: MySQL Query Speed

Hello I have a question on how MySQL JOIN has effect on query (search) performance: Our database consists of about 250.000 datasets (rows). Right now, all of the 150 columns are in one big table. However, we do have certain columns that are empty for most rows (for example information of the

JOINS: MySQL Query Speed

Hello I have a question on how MySQL JOIN has effect on query (search) performance: Our database consists of about 250.000 datasets (rows). Right now, all of the 150 columns are in one big table. However, we do have certain columns that are empty for most rows (for example information of the

JOINS: MySQL Query Speed

Hello I have a question on how MySQL JOIN has effect on query (search) performance: Our database consists of about 250.000 datasets (rows). Right now, all of the 150 columns are in one big table. However, we do have certain columns that are empty for most rows (for example information of the

JOINS: MySQL Query Speed

Hello I have a question on how MySQL JOIN has effect on query (search) performance: Our database consists of about 250.000 datasets (rows). Right now, all of the 150 columns are in one big table. However, we do have certain columns that are empty for most rows (for example information of the

MySQL Query Speed

Hello our database consists of one table with approx. 150 columns. We have a query going over 11 columns (most tinyint, int and some varchar) Out of 217237 rows the query found 56 matches. Without Indexing, the query took 2,55 seconds. With Indexing, the query took 0,04 seconds. The database

MySQL Database Questions

suggest a possible setup. 6. Is char() a better choice than varchar() in terms of speed when queries are run (we are aware of the fact that char() requires more disc space) ? It would be very helpful for us if you could help us with the above questions.. Thank you very much. Best regards. Florian

removing duplicates

bla yo orange 4 super yo orange 5 hey hey hey 6 hey hey hey it should delete the rows with the fooId: 1, 2 and 6... whats the easiest way to do that stuff with mysql? thanks alot in advance =) ciao! florian

string column types

is case-sensitive.. but except for that text can store more than 255 chars is there any difference between varchar and text/blob? thanks alot in advance best, florian -- - Before posting, please check: http://www.mysql.com

width and height performance

-- or mytable -- someId elementNum int(2) elementValue int(1) -- is it better to have 800 000 rows with 21 columns or 160 000 000 rows with 3 columns? thanks alot! =) best, florian - Before posting

Re: performance of joins

to have extra tables for addresses and contacts, since not all of the queries will ask for the normal information, the address information and the contact information at the same time? thanks alot in advance! florian Well, you usualy split your data in tables for a reason, because some data

performance of joins

, and a contact table. since also other needs than just customers, for storing addresses and contacts. would it perform better though to store all that in one single table or is is it okay to split it up in 3 and join them later then, depening on what information is needed? thanks alot. florian

SQL-String mit group by will nicht....

der kommentare nicht sicher :) auch fehlen noch ein paar header sowie die dtd DAS PROBELM ist aber ernst gemeint! -- -- Florian Schmidt mailto:[EMAIL PROTECTED] http://www.f-24.com - Before posting, please check: http

Re: date_format doesn't work correct

-07-16 14:00:00' ^ exactly this is the bug! the date at this time was: '2001-07-19 14:00:00' and now() correctly reports this, but a date_format(now(), '%Y%m%d%H') says '2001071614' with 16 as the month-day instead of 19 which would be right !? -- Florian Schmidt

date_format doesn't work correct

-machine: '2001071614' '2001-07-19 14:00:00' if i try the same with mysql-front on my win2k machine: '2001071914' '2001-07-19 14:00:00' ?!? i'm using the C-API (libmysqlclient.a) from mysql-3.23.38-pc-sco3.2v5.0.6-i386.tar.gz any ideas ? what should i do? a new libmysqlclient ? thx! -- Florian

RE: date_format doesn't work correct

try the same with mysql-front on my win2k machine: '2001071914' '2001-07-19 14:00:00' ?!? i'm using the C-API (libmysqlclient.a) from mysql-3.23.38-pc-sco3.2v5.0.6-i386.tar.gz -- Florian Schmidt mailto:[EMAIL PROTECTED] http://www.f-24.com

RE: date_format doesn't work correct

-machine: '2001071614' '2001-07-19 14:00:00' if i try the same with mysql-front on my win2k machine: '2001071914' '2001-07-19 14:00:00' ?!? i'm using the C-API (libmysqlclient.a) from mysql-3.23.38-pc-sco3.2v5.0.6-i386.tar.gz Florian Schmidt mailto:[EMAIL PROTECTED] http://www.f-24.com

VB, SQL: ...WHERE Mitglieder.geb='1978-08-26' doesn't work

Mitglieder.VName='Florian') I hope you could help me solving this problem. By the way: Sorry for my bad english! Thanks Florian Lagg ([EMAIL PROTECTED]) __ Ferienklick.de - Jede Menge Urlaub auf einen Blick! Hier geht's zu

VB, SQL: ...WHERE Mitglieder.geb='1978-08-26' doesn't work

-Query-Tool (e.g. MySQLFront) this query works and returns (as estimated) 1 Record. Any other query which is not using any date works, e.g.: dim rsPersonen as dao.recordset Set rsPersonen = db.OpenRecordset( _ SELECT Mitglieder.* FROM Mitglieder + _ WHERE Mitglieder.VName='Florian') I hope you could

Re: XML support under mySQL

, and DBMS is all about. It's not about specifying an query in XML - this _may_ be an side-effect, but there certainly should be alternatives (like some extended SQL). Greetings, Florian Pflug PS: I don't _know_ if you are the cynical type, but you certainly _sound_ like the cy

Re: XML support under mySQL

processor (or even an text editor) ist meta-data. But for an DTP-Programm it sure is data. I want an DB which helps me storing structured data efficiently, and I think XML could be part of the solution. greetings, Florian Pflug --

Re: XML support under mySQL

peoples lives easier ;-)) greetings, Florian Pflug - 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

Re: create table

- the latest one is 3.23.33 greetings, Florian Pflug - 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

Re: MySQL 3.23.32 / SuSE Linux 7.1 / php and normal user

solve your problem. I guess it won't This look more like mysql-client (or php) not finding the mysqld.sock socket, or the socket having the wrong unix permissions. Check for the permissions of the socket, and check if the client look for it at the same place as the server creates it. mfg, Flo

Re: XML support under mySQL

of structured data. :) The kind of structure that an table (essentially n-tuples of values) can represent is not nearly as powerfull as an XML-Tree. Greetings, Florian Pflug - Before posting, please check: http://www.mysql.com

Server Tuning

e finished and then return the result to both clients? If not, I will code this feature in PHP, using shared memory unless anyone has already done this and is willing to share the code. Greetings, Florian Pflug - Before posting, pl