Paul DuBois wrote:
On Feb 10, 2009, at 11:26 PM, Al wrote:
I know that all of the prgramming interfaces have the ability to
issue a Function Call to get
error number for the most recently invoked MySQL function
and
the error message for the most recently invoked MySQL function
such as in
Developing MySQL on Solaris
http://forge.mysql.com/wiki/Developing_MySQL_on_Solaris
This Thursday (February 19th, 14:00 UTC), MC Brown Trond Norbye will
give a MySQL University session on Developing MySQL on Solaris. MC works
on the MySQL Documentation Team and has been involved with quite a few
Aaron,
I've currently got a project to migrate a LARGE (3.5TB) MySQL data set from
a Sun SPARC machine to a Sun x86 machine, both running Solaris 10 (though
obviously one is x86 and the other is SPARC). Is it possible to simply copy
the data files from one host to the other or is a full
I am beginning the process of upgrading a large mysql 5.0 database to 5.1.
Specifically, I'm going from 5.0.56 enterprise to 5.1.30 community (which I
think is now the GA version?)
The db is about 4 terabytes. This means making a dump of the database,
installing a new version of the dbms, and
Jim,
In my experience updating the binaries (or installing the new ones in
addition to the old ones) works fine as long as you have made sure there are
no incompatible changes. I have done this from 5.0 to 5.1 without any
issues. Just run mysql_upgrade and you should be fine.
I have never had to
Hi,
How can I have accent sensitive, case insensitive fulltext query?
version: 5.0.45
The database, tables, connection, data etc. are all utf8.
select name from people where match(name) against ('königsberger' in
boolean mode);
shouldn't return konigsberger.
Any idea, collation?
We have an application using mysql. When we run it locally there are no
issues. If we try and connect to a remote database machine over VPN it
works but takes a VERY long time to get anything done. We are using the
exact same database. All other programs using the same VPN run fine and
the
Hi,
try to set the collation to utf8_unicode_ci.
I have had the inverse problem and I solved with utf8_general_ci.
Santino
At 19:33 +0100 16-02-2009, Salam Baker Shanawa wrote:
Hi,
How can I have accent sensitive, case insensitive fulltext query?
version: 5.0.45
The database, tables,
Thanks Santino, but unfortunately didn't help .
I tried utf8_bin, just for checking, same results¸
Not even the case sensitivity is respected.
The following queries return the same results:
select name from people where match(name) against ('königsberger' in
boolean mode);
select name from
In my db there are a number of books with several authors; so, I am
wondering how to set up a table on books and authors to be able to
insert (via php-mysql pages) data and retrieve and display these books
with several authors
I suspect that to insert data for a multiple author book I will have to
On Mon, Feb 16, 2009 at 5:20 PM, PJ af.gour...@videotron.ca wrote:
In my db there are a number of books with several authors; so, I am
wondering how to set up a table on books and authors to be able to
insert (via php-mysql pages) data and retrieve and display these books
with several authors
Michael Dykman wrote:
On Mon, Feb 16, 2009 at 5:20 PM, PJ af.gour...@videotron.ca wrote:
In my db there are a number of books with several authors; so, I am
wondering how to set up a table on books and authors to be able to
insert (via php-mysql pages) data and retrieve and display these
I know this is not working, but how can I check for NULL; or how can I
configure my field sub_title so I can check if $booksub_title contains
anything or is empty.
This problem as been breaking my back...don't know what to put in as a
default to be able to check against string input (VARCHAR) or
it depends on the vpn router
if u need more info let me know
- Original Message -
From: Duncan, Kurt (MCUSA) k...@medconnectusa.com
To: mysql@lists.mysql.com
Sent: Tuesday, February 17, 2009 12:09 AM
Subject: Slow connection over VPN
We have an application using mysql. When we run
On Mon, Feb 16, 2009 at 8:37 PM, PJ af.gour...@videotron.ca wrote:
Michael Dykman wrote:
On Mon, Feb 16, 2009 at 5:20 PM, PJ af.gour...@videotron.ca wrote:
In my db there are a number of books with several authors; so, I am
wondering how to set up a table on books and authors to be able to
15 matches
Mail list logo