What is the best way to backup your database. Which are the files that
I need to store on a usb disk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
a rude awakening. What is an effective easy to
follow protocol for backup and recovery in mysql!
Nick from Toronto
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
On Wed, Aug 21, 2013 at 10:39 PM, h...@tbbs.net wrote:
2013/08/21 18:03 -0400, Nick Khamis
We have the following mysql timetampe field
startdate | timestamp | NO | | -00-00 00:00:00
When trying to insert a long value in there:
Calendar c = Calendar.getInstance
:)
Nick.
|
+---++
| time_zone | +00:00 |
+---++
SELECT @@global.sql_mode;
+---+
| @@global.sql_mode |
+---+
| |
+---+
Not sure why I am getting this error.
Thanks in Advance,
Nick.
Question, is building the source exactly the same as mysql?
Meaning, if I build it with set CMAKE options building mysql, can I
use those exact same options building mariab?
eg:
cmake -DCMAKE_INSTALL_PREFIX=/usr -DINSTALL_INCLUDEDIR=include/mysql
-DINSTALL_LIBDIR=lib/mysql -DMYSQL_USER=mysql
Just out of curiosity, is the hardware stationed, or traveling close
to the speed of light (i.e., 18,000 miles per second)? Sorry I could
not help it
N.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Hello Everyone,
We installed mysql 5.6.11 from source without server, and was
wondering what happened to the mysql command?
/usr/local/mysql/bin/
innochecksummysql_waitpid replace resolveip
my_print_defaults perror resolve_stack_dump
Kind Regards,
Nick
made available to them months ago,
should, get me a win to move away from mysql. (perhaps this is what
oracle wants anyway, since mysql earns them no money)
On 6/9/13, Claudio Nanni claudio.na...@gmail.com wrote:
Hi Nick,
It seems it is fixed already in MariaDB:
http://bugs.mysql.com/bug.php
This was reported in 5.5.31, a patch, VERY SIMPLE was submitted.
The problem goes ignored by oracle
5.5.32 releases, same error, apply the same simple patch and builds
/tmp/mysql-5.5.32/vio/viossl.c: In function 'ssl_do':
/tmp/mysql-5.5.32/vio/viossl.c:175: error: 'SSL_OP_NO_COMPRESSION'
This is what happens when a large conglomerate writes large
checks. Everyone goes on the aggressive... I'm KIDDING!@!!@#!@!!
N.
On 4/6/13, Noel Butler noel.but...@ausics.net wrote:
On Sat, 2013-04-06 at 16:18 +, attee...@gmail.com wrote:
You don't have to be a jackass to him/her.
|
+---+
| acc |
ERROR 1146 (42S02): Table 'symax.acc' doesn't exist
I should mention that we have deleted the ib_* files in the past. Is
it ok if I post our config
for a quick review?
Thanks in Advance,
Nick.
On Tue, Nov 1, 2011 at 10:09 AM, Reindl Harald h.rei
Hello Reindl, I just noticed that I misspelled your name. Sorry about that!
Cheers,
Nick.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
to create sys files
make[2]: *** [include/mysqld_error.h] Error 1
make[1]: *** [extra/CMakeFiles/GenError.dir/all] Error 2
make: *** [all] Error 2
Thanks in Advance,
Nick.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
Hello Everyone,
I am looking to build just the mysql client, and not the entire server
from source.
Which cmake flags do I need to install just the mysql client/devel header files.
The actualy mysql server is on a different machine.
Thanks in Advance,
Nick.
--
MySQL General Mailing List
I should have mentioned that this is using mysql 5.5.15
Thanks Again,
Nick.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Thanks Shawn!
Ninus from Montreal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Hello Everyone,
I was wondering if the MySQL devel files tar was available for download? I
was
only able to find rpm on the mysql site.
Thanks in Advance,
Nick.
Hello Everyone,
Thank you so much for your response. I don't need the entire MySQL server
just the
development libraries. I found MySQL-devel-5.5.16-1.linux2.
6.i386.rpm, but there is
no MySQL-devel-5.5.16-1.linux2.6.i386.tar.gz.
Thanks Again,
Hello Everyone,
Thank you so much for your response. I don't need the entire MySQL server
just the
development libraries. I found MySQL-devel-5.5.16-1.linux2.
6.i386.rpm, but there is
no MySQL-devel-5.5.16-1.linux2.6.i386.tar.gz.
Thanks Again,
Nick.
That being said, does cmake have a --help friend? I just don't want to
install the complete MySQL server, just MySQL-devel, as
mentioned earlier.
Nick
I will post the cmake that get's just the devel header files shortly.
Nick.
running
Ubuntu 9.10 on an intel core i7 with 4GB RAM and 12GB swap... the process
monitor doesn't even flinch so I'm not thinking hardware here... why is the
sub-query running so slow?
Thanks for you help!!
Nick
hdparm -Tt /dev/sdX ?
Ian Simpson wrote:
That's pretty much what I've been doing to get that the drive is running
at 100% bandwidth.
What I'd like is something that just gives the bandwidth of the device
in terms of Mb/s: you can probably work it out using that iostat
command, seeing how
I want to install MYSQL from source on Windows.
Now, i have compiler success with Microsoft Visual Studio 2005 and Cmake on
Windows XP.
But nothing happened!!
I have read the INSTALL-WIN-SOURCE that is in source, but no use.
So, who can help me what should I do the next step to install MYSQL
Is there an easy way to build MySQL client library, server and start-up script
so that /etc/my.cnf is ignored?
I need to build client and server so that it in no way interacts with the global
system install, and build programs against that client library which also don't
interact with the
Hello Jeremy
Thank you for the pointer. After make clean, re-configured, re-compiled then
tried, but /path/to/bin/mysql --help still shows /etc/my.cnf as the default file.
Jeremy Cole wrote:
Hi Nick,
This should do it:
--sysconfdir=DIR read-only single-machine data [PREFIX/etc
,
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello John
There are two approaches to this.
1) Best, save date into table as a number. Select date like
WHERE date=$date1 AND date=$date2
2)Otherwise, if storing dates a strings:
WHERE date=$date1 OR date=$date2 OR date=$date3 OR date=$date4 OR
date=$date5.
In general, if you want to
.
I've had this code running for a couple of weeks and just noticed the
problem, so I'm not sure if it cropped up right away or not. Haven't
had a chance to bounce the server yet.
Any insight appreciated.
Nick
--
Nick Arnett
[EMAIL PROTECTED]
Messages: 408-904-7198
--
MySQL General Mailing List
Hello Adam
Adam Wolff wrote:
Actually runs through the table four times instead of twice, and maybe
can't even use the index for the whole query.
Assuming my results are not typical of MySQL query times, this would
explain the sqrt() relationship of returned rows to query time.
I have
Hello
I have been looking at planning the database strategy for openstreetmap
(http://www.openstreetmap.org).
There are several data types stored in tables with longitude and
latitude columns. Select statements work by selecting
where lat$lat1 and lat$lat2 and lon$lon1 and lon$lon2
I have
Alexey Polyakov wrote:
On 4/23/06, Nick Hill [EMAIL PROTECTED] wrote:
I've noticed a couple things.
1) Right now you're emulating spatial index.
2) In future, you're going to emulate partitioning.
Why do you think that doing this stuff manually is better than using
builtin capabilities?
1) I
Hi, experts
How can I make mysql database users password with expire date?
Does mysql can do it?
--
NiCK
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
all the
functionality in the documentation work with MySQL? Anybody used this with
MySQL, who could describe their experience with it?
I would really love a good SP debugger!
Nick
--
Nick Arnett
[EMAIL PROTECTED]
Messages: 408-904-7198
, too, and I'm wondering
if these are related.
Nick
--
Nick Arnett
[EMAIL PROTECTED]
Messages: 408-904-7198
Somebody give me some ammo for this. I flagged MySQL v5 to our CTO and
got shot down. We currently develop in MSSQL and I don't know enough
about either to make a constructive argument. I'm not even sure I
understand what he's on about with 'table functions' and 'nested
selects'. I couldn't find
Is there a way to have foreign keys and force referential integrity? I have
a main table and a lookup table, i want to be able to require that the main
table is using values from the lookup table. I am just not sure how in
MySQL. Thanks
to everyone here for their insight. I coudln't
have achieved it without all of you!
-Nick
--- inferno [EMAIL PROTECTED] wrote:
Hi,
I had to do the same thing on a project and the
problem was that if
you use CSV you will not be able to make a formated
excel document.
I am using now
Does anyone know if it is possible to populate values
into an Excel spreadsheet from a MySQL database? Can I
do this directly in Excel or do I need to create an
external program to do the work (i.e. in VB).
Thanks
-Nick
__
Do You Yahoo!?
Tired
the
ODBC query directly from Excel. This will get us
started for the time being, and give me some leeway so
I can work on doing this in PHP.
Thanks to you both!
-Nick
Start your day with Yahoo! - make it your home page
http
--- Partha Dutta [EMAIL PROTECTED] wrote:
Nick Jones wrote:
--- J.R. Bullington [EMAIL PROTECTED]
wrote:
Automatically populate??
Not that _I_ know of, but of course there are
those
on this list that know
much more than I.
I do know that you can export the values
Hi All,
I seem to be having a problem with the resolution using the timestamp
function. I am accessing the database snort on an ACID/SNORT/MySQL
installation utilizing a collection of shell scripts that are run as
cron jobs and function as a bot adding and removing firewall rules
(iptables).
Hi All,
I seem to be having a problem with the resolution using the timestamp
function. I am accessing the database snort on an ACID/SNORT/MySQL
installation utilizing a collection of shell scripts that are run as
cron jobs and function as a bot adding and removing firewall rules
(iptables).
Jigal van Hemert wrote:
Nick Sinclair wrote:
[.] WHERE date_format(timestamp, '%Y-%m-%d %T')
=DATE_SUB(CURDATE(),INTERVAL $BLACKLIST_DECAY HOUR)
* ...It only resolves to the DAY and not an hourly resolution. I have
included a script below that I use for debugging, the MySQL
functionality
.something
AND
table1.something LIKE table5.something
AND
table1.something LIKE table6.something
;
( Nick Pasich )
On Mon, Apr 25, 2005 at 12:51:53AM +0200, Schalk Neethling wrote:
Greetings everyone.
Hope someone can give me some pointers here. I
were on 4.0.18).
I see some changes to datetime handling in the 4.1.x releases, but
nothing that seems immediately obvious.
I hope to fix this is by re-building MySQLdb based on the 4.1.10
libraries. Any other suggestions? I'm using MySQLdb.times to format
the datetimes before inserting.
Nick
coming up with what they're coming up with.
TIA,
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
where apples is not present in any of the columns in any way. I
think it's a syntax mistake in my query, but I can't see it.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks. That was it. I'm glad it was something so simple. Just needed a
careful set of eyes. I was worried my understanding of SQL/JOINs was
screwy.
Thanks again.
Nick
PS I'll read up on the FULLTEXT matching. I don't know it well.
$query = SELECT v.vbusiness, v.vcategory, v.vurl
the lock
on a given table. If
that's possible, I'd like to know that, too, so I could at least know how it
got locked in the first
place.
Could a misbehaving client do this in a way that would cause the lock to
persist even after the
client has disconnected? If so, ugh.
Any help appreciated.
Nick
and that would just slow you down, wouldn't it?
Indeed, which was one reason I went with the HEAP table... which is also a TEMPORARY table so that
two clients can work concurrently.
Thanks.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
!
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
for it do apply... but unless interoperability matters, it's
hard for me to imagine a good reason to bother with XML.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
do the equivalent SELECT:
EXPLAIN SELECT * FROM a, b WHERE a.primary_key = b.primary_key
it shows that it's doing a table scan on table b.
Is this normal? Is it because primary keys are unique? I had imagined
that this would be a very fast operation, but it's not, it's
surprisingly slow.
Nick
Dathan Pattishall wrote:
Use char
And use fixed-length types for *all* columns... one variable-length
column makes all records variable-length.
Nick
-Original Message-
From: Marc Michalowski [mailto:[EMAIL PROTECTED]
Sent: Friday, January 28, 2005 10:28 AM
To: mysql@lists.mysql.com
when a record is added or modified, and the
pointer for deletes.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
off and COMMIT when appropriate?
Thanks!
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
reading!
So... is this the equivalent of using BEGIN and COMMIT, for which I have
methods in the Python MySQLdb module? Or is there an advantage to the
latter?
Thanks again,
Nick Arnett
Director of Business Intelligence Services
Liveworld Inc.
--
MySQL General Mailing List
For list archives
them.
I can do it the way above, but I'm thinking there might be a better way...
Thanks!
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi,
I am trying to get MsSQL working. I can't get the server to start.
I tried typing in mysql_install_db and got the following response:
linux:/home/nick # mysql_install_db
Installing all prepared tables
040602 5:54:02 /usr/sbin/mysqld: Shutdown Complete
PLEASE REMEMBER TO SET A PASSWORD
this at all as it effects the performance of the
server / game and I'm also worried someone could use such a thing to cause a
Denial of Service attack.
Regards,
--Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
from the database on my 2.7GHz with 2GB of RAM it
will spike to 100% for around
1 second then go back to normal.
--Nick
- Original Message -
From: Jeremy Zawodny [EMAIL PROTECTED]
To: Nick A. Sugiero [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, May 05, 2004 6:07 PM
Subject
be under 512MB. I'm not running out of processes or file handles, or
sockets from sysctl -a. Does anyone have any other suggestions or things to
double check?
Nick
to
track down at first because the manually compiled version of MySQL didn't
give me near the details the binary version did.
Thanks!
nickg
-Original Message-
From: Jeremy Zawodny [mailto:]
Sent: Wednesday, February 11, 2004 12:55 AM
To: Nick
Cc: [EMAIL PROTECTED]
Subject: Re: FreeBSD 4.9
-
From: Nick [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, February 02, 2004 1:30 AM
Subject: FreeBSD 4.9 + MySQL 4.0 + LinuxThreads
I previouslly compiled my own version of MySQLd 4.0.14 on FreeBSD 4.8 with
LinuxThreads using Jeremy Zawodny's config/compile options
(http
I previouslly compiled my own version of MySQLd 4.0.14 on FreeBSD 4.8 with
LinuxThreads using Jeremy Zawodny's config/compile options
(http://jeremy.zawodny.com/blog/archives/000458.html) and have had no
problems. However, I've got 4.9 install with updated ports, etc. and I
can't seem to get
http://www.mysql.com/doc/en/mysql_connect.html
This function is deprecated. It is preferable to use
mysql_real_connect() instead.
#includestdio.h
#includemysql.h
int main(void) {
MYSQL mysql;
if(mysql_init(mysql) == NULL) {
fprintf(stderr,Unable to initlize MySQL
Any idea when 4.1 will be released as a final?
nick marsh
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Dear ALL
I am Nick, I come from Taiwan company - EC-SERVER~~I have two WEB
SERVER to make load balance. Both of the WEB SERVER was installed mysql~~
I used the mount NFS instruction the storage spaces in linux.At the
same time,WEB's Data and mysql's data both in NFS paration~modify
, state: waiting for server activity
Number of rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
END OF INNODB MONITOR OUTPUT
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
compile unofficial but recommended binaries that
MySQL AB would support more like official binaries? :) If he's got
nothing better to do of course, he already puts in so much time to the
MySQL community as is.
Nick
-Original Message-
From: Ken Menzel [mailto:[EMAIL PROTECTED]
Sent: Thursday
over multiple _rows_
I am aware of the GROUP_CONCAT function, but we are currently running
MySQL 4.0.13 (this functionality is only available on a vers 4.1)
If any one has a suggestion as how I should go about this one I would
really appreciate it.
Kind regards, Nick
--
Nick Heppleston
07989
Hello,
I have aproximately 1,000,000 rows and I would like to do some query.
The first one is to get the number of row so I do :
mysql SELECT COUNT(*) FROM `Log`;
+--+
| COUNT(*) |
+--+
| 969129 |
+--+
1 row in set (0.00 sec)
MyISAM tables keep a specific
I know the replication method is different in MySQL 4.0 then MySQL
3.23.x, but I have a bug that causes problems. The following query will
cause MySQL's logic to not properly read any of the following my.cnf
commands on slave servers:
replicate-wild-do-table
replicate-wild-ignore-table
data
chgrp -R mysql data
in the mysql directory. Obviously you need to have a mysql user, and
this lets that user, and only that user write to the data directory, or
even enter it for that matter (besides root of course).
HTH!
-Nick
On Wed, 2003-07-30 at 01:19, Peter Bradley wrote:
Hi Sanya
Don't
...
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
application, the query would be along these lines (this uses the
column 'app_id' as the key:
SELECT used_by FROM nms_apps, user WHERE nms_apps.app_id = user.app_id AND
app_name = Application Foo
Hope that helps. If you grasp this, you'll have the basic idea of
relational data.
Nick
--
Nick Arnett
of your other messages about that. It's probably time for me
to update.
Thanks very much. I really appreciate the speed with which you respond (not
just to my messages, I read the list regularly).
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
words, if a resource is in a high priority task and a low
priority task, I only want to show the high priority task.
Thanks for the help!
-Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
, but
not for the entire table.
I really want to group by the resource, but still have all the info
available for what ever the highest priority task it is in.
-Nick
Btw, all the fields are varchars with the priorities being Hi, Medium,
Low, but I could really care less on what particular priority it is atm
That works great. =D
Knew it shouldn't be that difficult, thanks a bunch.
And it actually works with the Priorities being in text form to (low, med,
hi).
-Nick
At 02:52 PM 7/24/2003, you wrote:
After some searching around different books/manuals/google I still can't
seem to figure out how do
Yep, saw that and did just as you stated :)
Nick, As you stated, your priority field datatype is varchar, with
possible
values Hi, Medium and Low, as opposed to being integers. The use of
max
function, as suggested by some colleagues without knowing exactly the
datatype
would work
, quotes and other stuff that is a pain to encode
properly by hand.
Any help will be most gratefully accepted. My hair will thank you, too.
Nick
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 17, 2003 9:38 PM
To: Nick Arnett; [EMAIL PROTECTED]
Well, Paul, just knowing you were on the job inspired me and I finally
realized the dumb thing I'd done. The list I'm iterating, urls, comes from
is not set right. Any help would be greatly
appreciated.
Nick
Oh, and I can not find ANY log files anywhere (/var/lib or
/usr/local/mysql/data).
Here are some messages:
[EMAIL PROTECTED] mysql]# pwd
/usr/local/mysql
[EMAIL PROTECTED] mysql]# bin/safe_mysqld --console
Starting mysqld daemon
mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: Cannot continue operation.
030709 12:53:27 mysqld ended
Anyone know what could be causing this? I'm baffled.
Thanks,
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
Yep, that was it, along with what Mark said.
On Wednesday, Jul 9, 2003, at 15:10 US/Central, gerald_clark wrote:
Nick Boudreau wrote:
Trying to start mysqld for the first time after a reinstall on Mac OS
X gives me this error:
030709 12:53:26 mysqld started
030709 12:53:27 InnoDB
X?
2. How can I delete all that stuff about root users and start anew?
3. What can I do about the socket error?
#3 may not be an issue once I fix the others.
Please consider helping a poor guy out.
Thanks,
Nick Boudreau
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
and don't really want to go down the route on all of the fields. But if
I have to I will.
Thanks for the advice!
-Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks for pointing that one out. Unfortunately relplace(table.*, ...)
does not work (syntax error) so I'll stil have to go through each field
individually. This will be two statements per-field which kinda stinks,
but oh well.
Thanks again!
-Nick
On Mon, 2003-06-23 at 11:10, Mike Hillyer wrote
wheras mediumint is up to 8.3 million - more
efficient for your data type).
If he only has a few million records, why would this be more efficient?
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
recall the correct
variable.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
said.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
the column type for
pricelevel or put quotes around the numbers in the query? I hit that
problem all the time using 1 and 0 as Booleans in an ENUM column.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
version, just to see if it'll start up properly. Then try
modifying one variable at a time, restarting after each.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You could pre-pend EXPLAIN and see if it generates an error.
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
-Original Message-
From: Jerry [mailto:[EMAIL PROTECTED]
Sent: Friday, April 04, 2003 5:46 AM
To: [EMAIL PROTECTED]
Subject: Pre parsing
Hi,
Anyone know
I've searched and searched, but I can't find anything that describes the
format of a custom stopword file for fulltext indexing in MySQL. Anybody
have a pointer or a description of the format?
Nick
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General Mailing List
be used in phrase searches. I'm doing these in Boolean mode because I
need exact counts of occurrences. This is on MySQL-4.0.12-nt.
Nick
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
actually calling
nextset(), even though MySQL doesn't support multiple result sets.
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1 - 100 of 294 matches
Mail list logo