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/fulltex
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,
> Den
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
>
>
> 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 dat
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 s
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 p
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
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
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, e
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 yo
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 f
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, an
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 vers
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
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
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 F
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
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
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 d
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
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
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 t
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)
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?db
24 matches
Mail list logo
