1 day left: 75% discount on MySQL/Firebird/InterBase/Oracle/SQL Server developer tool!
This week only, because of the 5-year celebration of our database development IDE Database Workbench, there's a 75% discount on ALL modules. Database Workbench supports InterBase, MySQL, Firebird, Oracle and Microsoft SQL Server. Feel free to spread this news! http://www.upscene.com/index.htm?dbw_party_promo.htm -- Martijn Tonies Database Workbench - development tool for InterBase and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql 5.0 and utf8 letters inside
Hi, I installed mysql-essential-5.0.18-win32.msi (under Win XP) in order to use it with Bugzilla. Since I had some problem with importing old Bugzilla dumps containing some special hungarian vowels (they are outside of latin1 characterset), I checked how mysql stores these characters (vowels) inside. I stored the following string (entering a new bug in Bugzilla) into database (hopefully you can read it): áéíóöőúüűÁÉÍÓÖŐÚÜŰ These 9-9 vowels are used in the hungarian alpabet (small and capital letters). To my great surprise in mysql its hexadump is (select hex(column)): C383C2A1C383C2A9C383C2ADC383C2B3C383C2B6C385E28098C383C2BAC383C2BCC385C2B1C383C281C383E280B0C383C28DC383E2809CC383E28093C385C290C383C5A1C383C593C385C2B0 It is longer (152 characters) that I expected (18x2x2 = 72 characters). Here I cut the string into as many lines as vowels, moreover I placed into brackets the UTF8 codes that should be used normally instead of them. C383C2A1 (C3A1) LATIN SMALL LETTER A WITH ACUTE C383C2A9 (C3A9) LATIN SMALL LETTER E WITH ACUTE C383C2AD (C3AD) LATIN SMALL LETTER I WITH ACUTE C383C2B3 (C3B3) LATIN SMALL LETTER O WITH ACUTE C383C2B6 (C3B6) LATIN SMALL LETTER O WITH DIAERESIS C385E28098 (C591) LATIN SMALL LETTER O WITH DOUBLE ACUTE C383C2BA (C3BA) LATIN SMALL LETTER U WITH ACUTE C383C2BC (C3BC) LATIN SMALL LETTER U WITH DIAERESIS C385C2B1 (C5B1) LATIN SMALL LETTER U WITH DOUBLE ACUTE C383C281 (C381) LATIN CAPITAL LETTER A WITH ACUTE C383E280B0 (C389) LATIN CAPITAL LETTER E WITH ACUTE C383C28D (C38D) LATIN CAPITAL LETTER I WITH ACUTE C383E2809C (C393) LATIN CAPITAL LETTER O WITH ACUTE C383E28093 (C396) LATIN CAPITAL LETTER O WITH DIAERESIS C385C290 (C590) LATIN CAPITAL LETTER O WITH DOUBLE ACUTE C383C5A1 (C39A) LATIN CAPITAL LETTER U WITH ACUTE C383C593 (C39C) LATIN CAPITAL LETTER U WITH DIAERESIS C385C2B0 (C5B0) LATIN CAPITAL LETTER U WITH DOUBLE ACUTE The letters should be consumed just 2 bytes, but in mysql all of them uses 4 or 5(!!!) bytes. Does MySql 5.0 store the UTF8 codes not directly? Since Bugzilla displays the entered bug correctly (it reads the vowels properly from database), I think there must be some rule in mysql storing utf8 codes. When I make a (mysql)dump from the database, also these long codes are inside of the dump. The old dumps were made still with mysql-essential-4.1.12-win32.msi and they contain proper UTF8 codes (with 2 bytes length per hungarian special vowel), so I do not know why MySQL 5.0 stores these vowels differently than MySQL 4.1. Regards Zsolt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql 5.0 and utf8 letters inside
Zsolt Branyiczky wrote: Hi, I installed mysql-essential-5.0.18-win32.msi (under Win XP) in order to use it with Bugzilla. Since I had some problem with importing old Bugzilla dumps containing some special hungarian vowels (they are outside of latin1 characterset), I checked how mysql stores these characters (vowels) inside. I stored the following string (entering a new bug in Bugzilla) into database (hopefully you can read it): áéíóöőúüűÁÉÍÓÖŐÚÜŰ These 9-9 vowels are used in the hungarian alpabet (small and capital letters). To my great surprise in mysql its hexadump is (select hex(column)): C383C2A1C383C2A9C383C2ADC383C2B3C383C2B6C385E28098C383C2BAC383C2BCC385C2B1C383C281C383E280B0C383C28DC383E2809CC383E28093C385C290C383C5A1C383C593C385C2B0 It is longer (152 characters) that I expected (18x2x2 = 72 characters). Here I cut the string into as many lines as vowels, moreover I placed into brackets the UTF8 codes that should be used normally instead of them. C383C2A1 (C3A1) LATIN SMALL LETTER A WITH ACUTE C383C2A9 (C3A9) LATIN SMALL LETTER E WITH ACUTE C383C2AD (C3AD) LATIN SMALL LETTER I WITH ACUTE C383C2B3 (C3B3) LATIN SMALL LETTER O WITH ACUTE C383C2B6 (C3B6) LATIN SMALL LETTER O WITH DIAERESIS C385E28098 (C591) LATIN SMALL LETTER O WITH DOUBLE ACUTE C383C2BA (C3BA) LATIN SMALL LETTER U WITH ACUTE C383C2BC (C3BC) LATIN SMALL LETTER U WITH DIAERESIS C385C2B1 (C5B1) LATIN SMALL LETTER U WITH DOUBLE ACUTE C383C281 (C381) LATIN CAPITAL LETTER A WITH ACUTE C383E280B0 (C389) LATIN CAPITAL LETTER E WITH ACUTE C383C28D (C38D) LATIN CAPITAL LETTER I WITH ACUTE C383E2809C (C393) LATIN CAPITAL LETTER O WITH ACUTE C383E28093 (C396) LATIN CAPITAL LETTER O WITH DIAERESIS C385C290 (C590) LATIN CAPITAL LETTER O WITH DOUBLE ACUTE C383C5A1 (C39A) LATIN CAPITAL LETTER U WITH ACUTE C383C593 (C39C) LATIN CAPITAL LETTER U WITH DIAERESIS C385C2B0 (C5B0) LATIN CAPITAL LETTER U WITH DOUBLE ACUTE The letters should be consumed just 2 bytes, but in mysql all of them uses 4 or 5(!!!) bytes. Does MySql 5.0 store the UTF8 codes not directly? Since Bugzilla displays the entered bug correctly (it reads the vowels properly from database), I think there must be some rule in mysql storing utf8 codes. When I make a (mysql)dump from the database, also these long codes are inside of the dump. The old dumps were made still with mysql-essential-4.1.12-win32.msi and they contain proper UTF8 codes (with 2 bytes length per hungarian special vowel), so I do not know why MySQL 5.0 stores these vowels differently than MySQL 4.1. Regards Zsolt I think I know the cause of the problem. Bugzilla somehow encodes (and decodes) twice the characters. E.g. E1 (LATIN SMALL LETTER A WITH ACUTE) - C3 A1 - C3 83 C2 A1 So not MySQL is repsonsible for the strange phenomenon, I'm sorry for my previous post. Zsolt -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
replication
Hi, I have 2 servers. On one of them I have MySQL 4.1 (the main server) and on the second I have MySQL 5.0. I want to use the second server to replicate the first server. Is it possible or the servers should have the same version? Or I will need to install one more MySQL 4.1 on the second server and use it for replicating the first server? Thank you. Teddy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: replication
Yes ..u can use older version as master and 5.0 version as slave http://dev.mysql.com/doc/refman/5.1/en/replication-compatibility.html http://linux.com.hk/penguin/developer/mysql/manual_Replication.html#Replication_Compatibility Ciao Praj On Fri, 3 Mar 2006 12:32:24 +0200 Octavian Rasnita [EMAIL PROTECTED] wrote: Hi, I have 2 servers. On one of them I have MySQL 4.1 (the main server) and on the second I have MySQL 5.0. I want to use the second server to replicate the first server. Is it possible or the servers should have the same version? Or I will need to install one more MySQL 4.1 on the second server and use it for replicating the first server? Thank you. Teddy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: rpm mysql5.0 for fedora4
Hi N.N., all, Denis (hoping that it also helps with your question), unplug wrote: Hi, I found that there are 2 versions of mysql 5.0 rpm for download. Linux x86 generic RPM (statically linked against glibc 2.2.5) downloads Linux x86 generic RPM (dynamically linked) downloads What is the difference between them? How to determine what version should I use for fedora4? Glibc 2.2 has issues when the number of threads gets large, that is why ehere is a patched version (that issue fixed) is linked statically to MySQL binaries intended to run on systems (still) using glibc 2.2. Glibc 2.3 does not have these issues, so for this version dynamic linking can be used. This is the current version of glibc, used for all MySQL binaries (except those special 2.2 ones). Check your system for the glibc version used, then get and install the appropriate package. HTH, Jperg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
manual deletion of binary log files
Hello. Can I delete off the binary log files manually? I do not want to 'RESET MASTER', as it will clear all the binary logs, and that's not what I want to do. The database is backed up every midnight, and I wouldn't want to keep any of the bin logs except the latest one. We are on RHEL - MySQL 4.1.11 - INNoDB storage engine. Regards, Rithish.
RE: manual deletion of binary log files
Yes, look at the PURGE LOGS command. Rithish Saralaya wrote: Hello. Can I delete off the binary log files manually? I do not want to 'RESET MASTER', as it will clear all the binary logs, and that's not what I want to do. The database is backed up every midnight, and I wouldn't want to keep any of the bin logs except the latest one. We are on RHEL - MySQL 4.1.11 - INNoDB storage engine. Regards, Rithish. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Qyery help - pass string to stored procedure for IN clause - FIXED!
Thanks so much for your help. With a little tweaking, I finally got
what this to work. I am using MySQL 5.0.15. With your query, I get an
error due to the CONCAT:
CREATE PROCEDURE spGetNames (IN strNames VARCHAR(255))
BEGIN
prepare stmt1 from concat('SELECT FirstName,LastName FROM
myTable
WHERE LastName IN (',strNames,')');
execute stmt1;
END
ERROR 1064 (42000): You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'CONCAT('SELECT FirstName,LastName FROM myTable WHERE
LastName IN (', strNames, ')')' at line 3
So here is what I did to get this working:
CREATE PROCEDURE spGetNames (IN strNames VARCHAR(255))
BEGIN
SET @strSQL = CONCAT('SELECT FirstName,LastName FROM myTable
WHERE LastName IN (', strNames, ')');
PREPARE stmt1 FROM @strSQL;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;
END
I did not look up what error 1064 (42000) is but it works now so I will
check into that later. Also, the manual states to use DEALLOCATE
PREPARE after you are done so I added that as well.
I also changed the 2 apostrophes to a single apostrophe in the call as
follows:
CALL spGetNames ( ''PRICE'', ''SMITH'' );
Changed to:
CALL spGetNames ( 'PRICE', 'SMITH' );
Anyway, I got it working so thanks very much.
Randall Price
VT.SETI.IAD.MIG:Microsoft Implementation Group
http://vtmig.vt.edu
[EMAIL PROTECTED]
(540) 231-4396
-Original Message-
From: Ing. Edwin Cruz [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 02, 2006 3:03 PM
To: Price, Randall
Subject: RE: Qyery help - pass string to stored procedure for IN clause
What abaut this:
CREATE PROCEDURE spGetNames (IN strNames VARCHAR(255))
BEGIN
prepare stmt1 from concat('SELECT FirstName,LastName FROM
myTable
WHERE LastName IN (',strNames,')');
execute stmt1;
END
mysqlCALL spGetNames ( ''PRICE'', ''SMITH'' );
Try it
Regards!
-Mensaje original-
De: Price, Randall [mailto:[EMAIL PROTECTED]
Enviado el: Jueves, 02 de Marzo de 2006 12:48 p.m.
Para: mysql@lists.mysql.com
Asunto: Qyery help - pass string to stored procedure for IN clause
I have a SELECT query that looks similar to the following:
SELECT
FirstName,
LastName
FROM
myTable
WHERE
LastName IN ('PRICE', 'SMITH');
What I want to do is create a stored procedure for this SELECT query
similar
to the following:
CREATE PROCEDURE spGetNames (IN strNames VARCHAR(255))
BEGIN
SELECT
FirstName,
LastName
FROM
myTable
WHERE
LastName IN (strNames);
END
And then I would like to call it by passing in a list of names. None of
the
following calls work:
CALL spGetNames ('PRICE,SMITH');
CALL spGetNames ( 'PRICE', 'SMITH' );
CALL spGetNames ( ''PRICE'', ''SMITH'' );
My question is how to format the string parameter so this query works.
Thanks,
Randall Price
VT.SETI.IAD.MIG:Microsoft Implementation Group http://vtmig.vt.edu
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: replication
There is one issue. MySQL changed the way it parsed SQL join statements
in 5.03. Specifically JOINS in the older syntax using implicit joins
{tables seperated by ,} i.e.
FROM table_a, table_b
are parsed differently than they are in versions prior to 5.03. If you
have any statements that do any implicit joins the statements that ran
sucessfully on your 4.1 system may error out on your 5.0.? system.
Full details on the change and it's impact on query design can be found
here:
http://dev.mysql.com/doc/refman/5.0/en/join.html
-Original Message-
From: Prasanna Raj [mailto:[EMAIL PROTECTED]
Sent: Friday, March 03, 2006 6:28 AM
To: Octavian Rasnita
Cc: mysql@lists.mysql.com
Subject: Re: replication
Yes ..u can use older version as master and 5.0 version as slave
http://dev.mysql.com/doc/refman/5.1/en/replication-compatibility.html
http://linux.com.hk/penguin/developer/mysql/manual_Replication.html#Repl
ication_Compatibility
Ciao
Praj
On Fri, 3 Mar 2006 12:32:24 +0200
Octavian Rasnita [EMAIL PROTECTED] wrote:
Hi,
I have 2 servers. On one of them I have MySQL 4.1 (the main server)
and on
the second I have MySQL 5.0.
I want to use the second server to replicate the first server. Is it
possible or the servers should have the same version?
Or I will need to install one more MySQL 4.1 on the second server and
use it
for replicating the first server?
Thank you.
Teddy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
upgrade from 4.1 to 5.0
Hello, I'm going to upgrade from 4.1 to 5.0. My question is how do I handle the data from old version. Do I need to recreate tables in the mysql database when I install the new version or can I use the old mysql database from the old version? Data in other database I believe I can dump and import from the old version. Thank you. Claire __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: upgrade from 4.1 to 5.0
On 3/3/06, Claire Lee [EMAIL PROTECTED] wrote: Hello, I'm going to upgrade from 4.1 to 5.0. My question is how do I handle the data from old version. Do I need to recreate tables in the mysql database when I install the new version or can I use the old mysql database from the old version? Data in other database I believe I can dump and import from the old version. Thank you. http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html Claire __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Daniel da Veiga Computer Operator - RS - Brazil -BEGIN GEEK CODE BLOCK- Version: 3.1 GCM/IT/P/O d-? s:- a? C++$ UBLA++ P+ L++ E--- W+++$ N o+ K- w O M- V- PS PE Y PGP- t+ 5 X+++ R+* tv b+ DI+++ D+ G+ e h+ r+ y++ --END GEEK CODE BLOCK-- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Deleted sock file, how can I recover
ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' I accidentally deleted the above file, I can not connect any new connections in the CLI, old stuff seems to still be ok. I can not seem to shut down the server, as that file is needed. Any way I can recreate it, and what do I put in it? I can force kill the server and I am guessing it would all come back up ok, but there must be a gentler way? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Deleted sock file, how can I recover
Shut it down with mysqladmin, from another machine using the -h (host) option. When you are using the CLI locally it connects through the socket, but if you do it from another machine it will use TCP, getting around the need for the missing socket file. You may also be able to connect via TCP from the local machine, depending on what address you use to connect to. (local IP, local host, actual hostname, etc). -Ryan Scott Haneda wrote: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' I accidentally deleted the above file, I can not connect any new connections in the CLI, old stuff seems to still be ok. I can not seem to shut down the server, as that file is needed. Any way I can recreate it, and what do I put in it? I can force kill the server and I am guessing it would all come back up ok, but there must be a gentler way? -- - Scott HanedaTel: 415.898.2602 http://www.newgeo.com Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
INstalling DBD for mysql--Help needed
Hello, I am trying to install DBI and mysql DBD for perl on HP-UX 11.23i. I have installed DBI successfully but having a hard time installing DBD for mysql on HP-UX. I am getting make errors while installing. I want to use perl to connect to mysql database. Any help appreciated, Thank you, vinay
Re: 1 day left: 75% discount on MySQL/Firebird/InterBase/Oracle/SQL Server developer tool!
Definitely give this tool a try if you haven't - it has some very powerful features - schema diffs (and the ability to create patches, etc - very powerful if you maintain development, quality-assurance, and production databases). The ability to sort connections, etc, by machine, by database, etc, is very powerful. I haven't spent more than a few hours with it, but I was very impressed. David Martijn Tonies wrote: This week only, because of the 5-year celebration of our database development IDE Database Workbench, there's a 75% discount on ALL modules. Database Workbench supports InterBase, MySQL, Firebird, Oracle and Microsoft SQL Server. Feel free to spread this news! http://www.upscene.com/index.htm?dbw_party_promo.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Movable Type + OSXServer + MySQL issues.
Hi, Im having a rather nasty time installing MT on my G5XServe. IM trying to use MySQL but Im getting a rather NASTY error Stock Install of MySQL that came with the G5. ++ Got an error: Unsupported driver MT::ObjectDriver::DBI::mysql: Can't locate DBI.pm in @INC (@INC contains: /Volumes/webserver/ ~shoreweddings.com/blog/extlib lib /System/Library/Perl/5.8.6/darwin- thread-multi-2level /System/Library/Perl/5.8.6 /Library/Perl/5.8.6/ darwin-thread-multi-2level /Library/Perl/5.8.6 /Library/Perl /Network/ Library/Perl/5.8.6/darwin-thread-multi-2level /Network/Library/Perl/ 5.8.6 /Network/Library/Perl /System/Library/Perl/Extras/5.8.6/darwin- thread-multi-2level /System/Library/Perl/Extras/5.8.6 /Library/Perl/ 5.8.1 .) at lib/MT/ObjectDriver/DBI.pm line 10. BEGIN failed--compilation aborted at lib/MT/ObjectDriver/DBI.pm line 10. Compilation failed in require at lib/MT/ObjectDriver/DBI/mysql.pm line 10. BEGIN failed--compilation aborted at lib/MT/ObjectDriver/DBI/mysql.pm line 10. Compilation failed in require at (eval 6) line 1. BEGIN failed--compilation aborted at (eval 6) line 1. ++ Anyone seen this before ? And how best to resolve it ? M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 1 day left: 75% discount on MySQL/Firebird/InterBase/Oracle/SQL Server developer tool!
On Fri, 3 Mar 2006, David Griffiths wrote: } Definitely give this tool a try if you haven't - it has some very powerful } features - schema diffs (and the ability to create patches, etc - very } powerful if you maintain development, quality-assurance, and production } databases). } } The ability to sort connections, etc, by machine, by database, etc, is very } powerful. Those features sound very nice, indeed, but alas, there is no Mac OS X or Linux version. Are there other products [free/not free] that can do what this tool does, but run under UNIX flavors? /vjl/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Movable Type + OSXServer + MySQL issues.
Hi, Looks like you don't have the DBI installed, doesn't appear to be anything to do with the installation of MySQL. The first line of the message states it cannot find DBI.pm in the include path. Try installing that from CPAN and retry the installation. You may have to set your perl paths (man perlrun , look for PERL5LIB) to allow perl to find the pm files. Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: m i l e s [mailto:[EMAIL PROTECTED] Sent: Saturday, 4 March 2006 8:18 AM To: MySQL Subject: Movable Type + OSXServer + MySQL issues. Hi, Im having a rather nasty time installing MT on my G5XServe. IM trying to use MySQL but Im getting a rather NASTY error Stock Install of MySQL that came with the G5. ++ Got an error: Unsupported driver MT::ObjectDriver::DBI::mysql: Can't locate DBI.pm in @INC (@INC contains: /Volumes/webserver/ ~shoreweddings.com/blog/extlib lib /System/Library/Perl/5.8.6/darwin- thread-multi-2level /System/Library/Perl/5.8.6 /Library/Perl/5.8.6/ darwin-thread-multi-2level /Library/Perl/5.8.6 /Library/Perl /Network/ Library/Perl/5.8.6/darwin-thread-multi-2level /Network/Library/Perl/ 5.8.6 /Network/Library/Perl /System/Library/Perl/Extras/5.8.6/darwin- thread-multi-2level /System/Library/Perl/Extras/5.8.6 /Library/Perl/ 5.8.1 .) at lib/MT/ObjectDriver/DBI.pm line 10. BEGIN failed--compilation aborted at lib/MT/ObjectDriver/DBI.pm line 10. Compilation failed in require at lib/MT/ObjectDriver/DBI/mysql.pm line 10. BEGIN failed--compilation aborted at lib/MT/ObjectDriver/DBI/mysql.pm line 10. Compilation failed in require at (eval 6) line 1. BEGIN failed--compilation aborted at (eval 6) line 1. ++ Anyone seen this before ? And how best to resolve it ? M i l e s. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Charset questions
When we migrated to MySQL from MS SQL, I left everything set to the default as far as collations - latin1_swedish_ci. This was based on digging through the manual and google. But now I am migrating the application to a newer version of ColdFusion and am running into some issues with charsets on some ColdFusion functions. I am wondering if my database charset has anything to do with it. What do other people usually do as far as the collation setting? We are in the US, but do have a few sites that make use of German and Spanish characters. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 1 day left: 75% discount on MySQL/Firebird/InterBase/Oracle/SQL Server developer tool!
Definitely give this tool a try if you haven't - it has some very powerful features - schema diffs (and the ability to create patches, etc - very powerful if you maintain development, quality-assurance, and production databases). The ability to sort connections, etc, by machine, by database, etc, is very powerful. I haven't spent more than a few hours with it, but I was very impressed. Thank you for your kind words David. Indeed, there's a Windows only version - but from what I've heard, Database Workbench runs fine in Wine or Win4Lin. That's how the Opera (yes, from the browser) run Database Workbench at their offices as they said in forum some time ago :-) Feel free to spread this news! http://www.upscene.com/index.htm?dbw_party_promo.htm Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle MS SQL Server Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: INstalling DBD for mysql--Help needed
On 3/3/06, Vinay [EMAIL PROTECTED] wrote: Hello, I am trying to install DBI and mysql DBD for perl on HP-UX 11.23i. I have installed DBI successfully but having a hard time installing DBD for mysql on HP-UX. I am getting make errors while installing. I want to use perl to connect to mysql database. Any help appreciated, Thank you, vinay how do you think we're going to help? should I try to perform a Vulcan mind meld with your server? Or did you just want me to come over and fix it for you? I tell ya what - just give us your server IP, open up telnet, and provide the root password. we'll get that nasty DBD! -jp
Re: rpm mysql5.0 for fedora4
Thanks! If I have the glibc 2.3, I have to use Linux x86 generic RPM (dynamically linked). Otherwise, version lower than 2.3, we should use Linux x86 generic RPM (statically linked against glibc 2.2.5). Am I right? unplug On 3/3/06, Joerg Bruehe [EMAIL PROTECTED] wrote: Hi N.N., all, Denis (hoping that it also helps with your question), unplug wrote: Hi, I found that there are 2 versions of mysql 5.0 rpm for download. Linux x86 generic RPM (statically linked against glibc 2.2.5) downloads Linux x86 generic RPM (dynamically linked) downloads What is the difference between them? How to determine what version should I use for fedora4? Glibc 2.2 has issues when the number of threads gets large, that is why ehere is a patched version (that issue fixed) is linked statically to MySQL binaries intended to run on systems (still) using glibc 2.2. Glibc 2.3 does not have these issues, so for this version dynamic linking can be used. This is the current version of glibc, used for all MySQL binaries (except those special 2.2 ones). Check your system for the glibc version used, then get and install the appropriate package. HTH, Jperg -- Joerg Bruehe, Senior Production Engineer MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Boolean searches on InnoDB tables?
I just discovered this:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html
Which states:
They can work even without a FULLTEXT index, although a search executed in
this fashion would be quite slow.
But then I'm kicked in the nuts because:
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
Full-text indexes can be used only with MyISAM tables
When I try a query on an InnoDB table:
SELECT * FROM categories WHERE MATCH (name) AGAINST ('+ELECTRONICS' IN
BOOLEAN MODE);
I get:
Error Code : 1214
The used table type doesn't support FULLTEXT indexes
So, what is the deal? Am I missing something?
And if I can't use boolean searches on InnoDB tables with mySQL 5.0.18,
Then WHEN will I be able to?
In the mean time, what is the best way to generate this equivallent
functionality via PHP or some other mySQL 5 sanctioned way? I've seen
several different examples on the web, but don't know which to commit to.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
