-Original Message-
From: Nick Arnett [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 25, 2003 8:48 AM
...
Just noticed something odd, though, with the MySQLdb SSCursor.
When close()
is called, it does a fetchall(), getting any records that you hadn't
retrieved, trying to load all
. I'm guessing that that's where index caching was no longer
sufficient...?
I've optimized, analyzed and defragmented the disk, all of which seemed to
help a bit.
Nick
--
Nick Arnett
Phone/fax: (408) 904-7198
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http
Google itself. The
leader is Verity. Autonomy is probably its top current competitor. But
since you've posted here, are you considering MySQL? It doesn't have a
particularly rich query language for text, and it's up to you to get them
into the database in a usable form.
Nick
--
MySQL General
and content analysis to track what's going on in certain large
software development communities.
Thanks!
Nick
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
--
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]
-Original Message-
From: Nick Arnett [mailto:[EMAIL PROTECTED]
...
It dawned on me that perhaps the problem had to do with double-byte
characters,
Actually, what I think I meant to say was unprintable characters with
ASCII 122. Does this break fulltext indexing?
Nick
--
MySQL
;
or:
Select * From AnyTable;
Subsequent Calls Work Fine.
How-To-Repeat:
Execute the same command more than once.
Fix:
Use SQL_NO_CACHE as temporary fix Shouldn't have to..
Submitter-Id: submitter ID
Originator:Nick Pasich
Organization
;
or:
Select * From AnyTable;
Subsequent Calls Work Fine.
How-To-Repeat:
Execute the same command more than once.
Fix:
Use SQL_NO_CACHE as temporary fix Shouldn't have to..
Submitter-Id: submitter ID
Originator:Nick Pasich
Organization
Hi, I downloaded the rpm file for this and installed using rpm -i MySQL-3.23.55-1.rpm.
It went fine and said I should run mysqladmin to set root password but all I got was
'command not found'.
I then tried to uninstall it, without much luck:
[EMAIL PROTECTED] Downloads]# rpm -e
it sit there for a
min. or two. It will then proceed to recieve signal 11's
restart, wait a few, signal 11, restart
Fix:
Submitter-Id: submitter ID
Originator:Nick Stuart
MySQL support: none
Synopsis: Server keeps getting signal 11
Severity: critical
Priority
har har, silly filter
On Fri, 2003-01-10 at 14:43, [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query,queries,smallint
If
Ah, I see. Was unaware of this new feature, and thanks for the
explanation.
-Nick
On Thu, 2003-01-09 at 17:20, Stefan Hinz, iConnect (Berlin) wrote:
Nick,
CREATE DATABASE LookAtMe;
the database is created but as:
lookatme
This is not a bug, but a feature. By default, MySQL 4.0.x has
) and issue:
CREATE DATABASE LookAtMe;
the database is created but as:
lookatme
with no caps.
Anybody run into this before? I know Winblow$ isn't case sensitive and
all but it should still create the database/folder as I type it.
--
-Nick Stuart
USM Computer Science Major
Visit us at http
)
Any ideas on why I would get this?? I think it has something to do with
my case problem that I posted before because if you look it says
helpdesk instead of HelpDesk.
--
-Nick Stuart
USM Computer Science Major
Visit us at http://csforum.newtsplace.com
(run with LAMP
and will lock it.
I just had to do a mysqladmin -u root refresh and I was able to edit the
table. God how I've missed windows! blah!
Thanks for the pointer though. I ended up finding this solution
somewhere through google, can't remember where atm though.
-Nick
On Wed, 2003-01-08 at 19:19, Jennifer
I am running the Solaris 8 binary on all of my Ultra Sparc II Solaris 7
servers with no problems at this time, however I am not doing any of the
advanced features, such as MySQL-Max or replication.
Nickg
-Original Message-
From: Lenz Grimmer [mailto:[EMAIL PROTECTED]]
Sent: Monday,
I am currently running MySQL3.23.53-max with no problems, well
my_print_default complains about the same thing that MySQL-3.23.54
complains about, but MySQLd runs fine. I am attempting to upgrade to
MySQL3.23.54 (mysql-max-3.23.54-pc-linux-i686.tar.gz) and MySQLd does
not run at all, below are
The following code is incorrect in safe_mysqld on 3.23.54 at least (that
is all I have checked)
Line 162:
if $NOHUP_NICENESS -gt 0
then
$NOHUP_NICENESS=nice --$NOHUP_NICENESS nohup
This needs to be:
if test $NOHUP_NICENESS -gt 0
then
NOHUP_NICENESS=nice
Hi, All.
How can I add additional characters (Ukrainian alphabet) to the source code
for parse?
Thanks, Nick.
database,sql,query,table,handler,compile,ChangeSet
-
Before posting, please check:
http://www.mysql.com
Hello there...
I have a problem with sort order. I use greek and
english characters.
The manual says to put the following lines to my.cnf:
[client]
character-sets-dir=/usr/local/mysql/share/mysql/charsets
default-character-set=greek
i restart the demon but the problem still exist.
I have 3.23.49
I had the same problem. No, in MySQL you can't. But
you can use number_format() function of PHP. Check PHP
Manual for How-to
Nikos
--- Putte Koivisto [EMAIL PROTECTED] :
Is there a simple solution to define MySQL to use
comma instead of dot in
numeric fields?
template found for user our_guest
Has anybody seen this behavior?
Nick
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
How can i change the floating point '.' to ',' as a
decimal separator in MySQL 3.23... in Linux RH 7.2?
Nikos
-
sql, query
Do You Yahoo!?
@yahoo.grhttp://www.otenet.gr
In win98 mysql keep configuration in my.ini.
Which is the same file in RH Linux 7.2?
Thanx
Do You Yahoo!?
@yahoo.grhttp://www.otenet.gr
-
Before posting,
Does anybody know how to make log files for each of my
databases?
Thanx
sql, query
Do You Yahoo!?
@yahoo.grhttp://www.otenet.gr
-
Before posting, please
For the one who need help about using Flush and Mysql,
there is a tutorial in the phpbuilder.com, which is
enough good.
Nikos
---
Do You Yahoo!?
@yahoo.grhttp://www.otenet.gr
in
http://www.mysql.com/doc/en/Windows_source_build.html. However it doesn't
find dll with UDF.
One should run a script to create Makefile with a
flag --with-mysqld-ldflags=-rdynamic for Unix.
... when building MYSQL under Win32, MYSQL should be built with enabled UDF.
Nick
here instructions how
I've got apache in Win32 system and MySQL 3,32...
intall also.
As far as i know mysql admin needs a server (loclhost)
to work. The ODBC@localhost apears to me when i havn't
give permisions to a user to select a database. You
should check mysql database where you choose
permisions.
Nikos
---
Kevin, have you got install Apache HTTP server?
--- Kevin Walker [EMAIL PROTECTED]
: Hi all
I've recently downloaded and installed MySQL 3.23.52
for Windows. I'm
running Win95 OSR2, and Winsock2 is installed. This
is a standalone PC with
no web server or PHP installed on it.
As per
The html symbol for euro sign is: euro; (without
quots) if that helps.
Is it neccecery to insert it in the database?
--- Derk van der Harst [EMAIL PROTECTED]
: Hello everyone,
how can I insert records with the Euro sign into the
mysql database?
When i try to insert the euro sign i get
I suggest you to copy the database files. If you are
the administrator in a Linux system make a cron once
(for example) a week to copy this files to somwere
else.
--- Kai Vermehr [EMAIL PROTECTED] : is there any
single MySQL script that would backup
my complete database?
thanks! Kai
I had the same problem with greek characters. I set
field as binary and the problem corrected.
--- National Theater of Greece [EMAIL PROTECTED] :
Hi.
I have installed SuSE Linux 8.0 Proffessional and
the MySQL that came with
it. If anyone of you has done the same he must have
realized
Thank you very much for help.
Nick.
sql,query
-
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
Hello.
It's anew me.
And how linking under Win32 with --with-mysqld-ldflags=-rdynamic?
I need UDF.
Thanks in advance.
Nick.
mysql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
I wonder if someone could tell me if I can use Delphi 6's , ClientDataSet,
Query, DataSetProvider, Database and UpdateSQL components with MYSQL or I
have to look at an alternative third party library.
Does MYSQL supports transactions with InnoDB type tables ?
Thanks
Nikos
' tempfile.bat' is not recognized as an internal or external command,
operable program or batch file.
Error executing c:\winnt\system32\cmd.exe.
strings.lib - 1 error(s), 0 warning(s)
I have Windows NT 6SP and VC6.
what does it matter?
Best, Nick
' tempfile.bat' is not recognized as an internal or external command,
operable program or batch file.
Error executing c:\winnt\system32\cmd.exe.
strings.lib - 1 error(s), 0 warning(s)
I have Windows NT 6SP and VC6.
what does it matter?
Best, Nick.
Sql, mysql, query
Hi,
I used DbTools as Crecio O. Silva mentioned in his mail and I managed to
import Paradox tables to MySQL successfully..
There is still a problem with the imported data which are not imported
correctly because of the Greek chars that appear in the string fields.
Could anyone have a clue how
Hi,
I wonder if there is a utility for transferring Paradox tables to MySQL.
Nickos
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
was and a soft link the the
/lib directory. Anyone know if this is normal or not?
-Nick
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
Did you flush-privileges?
--- Sandra [EMAIL PROTECTED] : Hi all,
I am getting the error when trying to connect server
from my client:
Warning: mysql_num_rows(): supplied argument is not
a valid MySQL result
resource in .
I had my tables in test database, but created a new
Its a PHP function my friend. I'm using 3,23...
--- DL Neil [EMAIL PROTECTED] :
Nick,
Explode: which version of the MySQL manual are you
using?
=dn
- Original Message -
From: nick gatsis [EMAIL PROTECTED]
To: Carlos Fernando Scheidecker Antunes
[EMAIL PROTECTED]
Cc: [EMAIL
Check some articles in
http://www.devshed.com/Server_Side/MySQL,
http://www.devshed.com/Server_Side/PHP
--- JeRRy [EMAIL PROTECTED] : Hi,
I am trying to setup a PHP form to send to mySQL
database. I know how to connect to mySQL but need
help getting the information in the form to
for it.
If you know an other solution, i'll be happy to learn
it.
Cheeres
--- DL Neil [EMAIL PROTECTED] :
Nick,
Understood - but did Carlos say that he is using
PHP, and why use PHP when a
more efficient/quicker MySQL solution is available?
=dn
- Original Message -
From: nick gatsis [EMAIL
Did you try to make an .csv file and then import it
with Mysql-Front?
I believe that both tables have the same structure.
--- Ian Zabel [EMAIL PROTECTED] : I already
have my table structure in place in MySQL,
and I just want to
import the data from my Access 2000 database. (the
You must create an extra field in your database to
store the domain.
Use the explode() to seperate the domain from ...@
(array explode (string separator, string string [, int
limit])
Returns an array of strings, each of which is a
substring of string formed by splitting it on
boundaries
formed
Try this:
Use mysql tables, change or add record in user table.
If you add password (and you must) use
password('password'). Then flush-previleges from
mysqladmin.
Also, you must change host and db tables.
Go to www.devshed.com and read access granted
article.
Cheers
--- Marius Pana [EMAIL
Does MyCC is able to connect to MySQL servers in the local network...or it can connect
only to localhost?
NN
___
NOCC, http://nocc.sourceforge.net
-
Before posting, please check:
Are you sure that you are running the server at all?
Nikodim
Here's my bug report
Version: MySql 3.23.51.
OS: Linux linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i586 unknown
Memory: 64MB + 256MB(Swap)
Distibution Name: mysql-3.23.51-pc-linux-gnu-i686
I runned MySQL with the command:
Are you sure that you are running the server at all?
Nikodim
Here's my bug report
Version: MySql 3.23.51.
OS: Linux linux 2.4.18 #4 Fri May 31 01:25:31 PDT 2002 i586 unknown
Memory: 64MB + 256MB(Swap)
Distibution Name: mysql-3.23.51-pc-linux-gnu-i686
I runned MySQL with the command:
++ 3 but my C skills are
no where near good enough to get anywhere.
Thanks
--
Nick Miles - [EMAIL PROTECTED]
Database Developments Ltd
Client/Server Web Database Apps
Tel +44 1453 861155Fax +44 1453 861166
inflexible.
I think I found a full MySQL server compiled for Debian ARM which ran on an
iPaq with Linux on, but I need CE as linux is so unfriendly on PDAs compared
with PocketPC 2002.
Thanks
--
Nick Miles - [EMAIL PROTECTED]
Database Developments
That syntax will always report zero rows affected, but it is very fast. If
you want to know how many rows were deleted, use something like DELETE *
FROM Sqs WHERE 1=1.
The latter query will be much slower, as it examines each record.
Nick
-Original Message-
From: Bhavin Vyas [mailto
DELETE * Table. The ID
field still remembers the last ID so the next (first) record after
performing a delete all, will increment from the last ID.
BTW, I've just installed MySQL-Front. It got me up and running in no time!
:-)
Nick
: -Original Message-
: Anybody knows why, then, delete
with this,
Nick
-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL
Can you send me the asp page as an attachment?
Nick
: -Original Message-
: From: Ivan Paul [mailto:[EMAIL PROTECTED]]
: Sent: 16 July 2002 04:53
: To: MySQL
: Subject: problem when try to insert into mysql db using ASP
:
:
: hi all,
:
: i have problem when try to insert into mysql db
option export; ignored
Dump of file udf_example.so
File Type: DLL
Summary
1000 .data
1000 .rdata
1000 .reloc
3000 .text
Best, Nick.
sql,query
-
Before posting, please check:
http
'?
* title VARCHAR
* text TEXT
I need the date col to remain the same, what am I doing wrong?
Much thanks...
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE9CeQ3HpvrrTa6L5oRAp4KAKCeXaGZg7U2GK9HvSvincd+hZytFgCgqG3l
ignores the update
for efficiency.)
*You explicitly set the TIMESTAMP column to NULL.
HTH!
Sure does, cheers Jay.
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE9CfkZHpvrrTa6L5oRAlgCAJ47bPK5shotAZek3a8p7Fw8ZqoyFACgq8JV
:
self.dbh.execute(UPDATE Foo SET blah=%s, blorg=%s WHERE snork=%s,myList)
Doing the latter with a loop in Python is much slower than I'd expect that
doing it with a list would be.
Nick
--
[EMAIL PROTECTED]
(408) 904-7198
-
Before posting
of what you tried? And what exactly didnt work or turn
out right?-Nick
I am trying to get something like the following:
Title
-
topic #1
sub topic #1.1
topic #2
sub topic #2.1
sub topic #2.2
from the following table (I am using php for scripting
Just a quick question on how long this bench mark usually runs for.
Started it a while ago and its still kicking away. Know its working
because the Questions number keeps on going up.Thanks for the info.
-Nick
p.s. System is w2k 2gig Intel 4 with 512 ram
filter fodder: sql, query
, user, pass);
mysql_select_db(dbmt);
$result=mysql_query($qry);
As you can see, there is nothing special there... So what would cause it
to insert *2* records?
Many thanks...
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Nick Wilson declared
I'm having some weirdness when inserting from the php api, I do not get
the same results if I use the mysql server directly. Here is the code:
Please disregard. It appears to be some bizzare Apache/http thing
| Corrupt |
+---+---+--+---+
i am nearing wits end. this does not happen on windows 2000, only on linux.
-nick
-
Before posting, please check:
http://www.mysql.com
looking into the update function i am using in php.
-nick
- Original Message -
From: [EMAIL PROTECTED]
To: Nick Traenkner [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 12:51 PM
Subject: Re: delete corrupts
What version of MySQL?
What interface are you using to execute
Couldnt you do. SELECT * FROM tbl ORDER DESC LIMIT 10
As there is no TOP operator nor nested selects in MySQL, I wonder if
there still exists some clever way to maketop ten type of a query ,
i.e. to select ten best selling products or ten highest mountains for
example.
thanks
bad problems with doing this?
-nick
-
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 PROTECTED
tried this sql:
SELECT date, SUBSTRING(text, 0,30) as description FROM table WHERE id =
'2';
to no avail.
Could someone please explain what I *should* be doing?
Many thanks...
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux
anyway. Here is what I've
get:
You have an error in your SQL syntax near 'desc FROM news ORDER BY date ' at line 1
That comes from exactly what you have above, it works without the 'as
desc' part but then I have no way to get at it?
Cheers...
- --
Nick Wilson // www.tioka.com
-BEGIN
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Nick Wilson declared
You have an error in your SQL syntax near 'desc FROM news ORDER BY date ' at line 1
Ooops, reserved word! Works great ;-)
Any way to add something to it like or should I do that in my
php?
Many thanks
)' AND ( tmpSearch ) ORDER BY consign_num
ASC
Thanks in advance for any help you can provide.
Sincerely,
Nick Boldt
Computer Network Administrator
Track of the Wolf
Elk River, MN 55330
Tel: 763-633-2500 Fax: 763-633-2550
www.trackofthewolf.com
[EMAIL PROTECTED
This is a new area for me, so it may sound like a stupid question, but
what do you mean by FULLTEXT indexes?
P.S. the field I am searching is of VARCHAR type.
Nick Boldt
Computer Network Administrator
Track of the Wolf
Elk River, MN 55330
Tel: 763-633-2500 Fax: 763-633-2550
Ok this should be easy so I'm prolly going to screw it up, but here goes =D
Your query should be:
SELECT UserID, SUM(points) FROM History WHERE WeekID = 'whatever' GROUP BY
UserIdI think that should do it. Someone yell if its wrong though.
-Nick
I have 2 tables
Users (UserID)
History
Ok, so know you got me interested. What exactly are R-Trees. I know the
structure of B trees, hadto program a small version of a B' tree before, but never
heard of an R-Tree.
Any explanation
or link to where I might find some info would be appreciated.
-Nick
On Mon, May 20, 2002
at 09:39:52AM
THE highest/lowest values and not say the highest two values.
It would work Ibelieve if there were two families with the same highest score. Someone
correct me if I'mwrong.
-Nick
Hi,
I have a table containing data on a number of families.
I
want to retrieve members of each family that have the two
There is no from clause in the update syntax. However, I'm not sure how
you would update a tablethe way you are trying to. I'm sure it can be done, and your
SQL looks
correct besides the fromclause. Just take that out and see if what it says.
-Nick
hi. i'm new to the list and
have only been
Is it possible to embed MySQL in a stand alone java app? I know you can do
it in c++/vb but waswandering if it was possible to do so in Java.
Thanks for the help!
-Nick
-
Before posting, please check:
http://www.mysql.com
tomake sure your MySQL permissions allow for outside users to
log on.
-Nick
Is there an
appl for administering MySQL on a remote Linux server from
a Win 2K client?
Todd
--
Todd Cary
Ariste Software
2200 D Street Extension
Petaluma, CA
94952
707-773-4523
[EMAIL PROTECTED
From my understanding primary keys and foreign keys are indexed. Someone
correct me if I'mwrong here. And you shouldn't have to do anything else to field
besides
make it a float to usenegative numbers.
-Nick
Regarding mysql...
1) Are primary keys and foreign
keys by default indexes
Please refer to http://mysql.com/doc/D/a/Date_calculations.html it covers
datecalculations and has specifics on Age calcs.
-Nick
Hello, mysql,
How to get
Age from field date-time that contain dateofbirth and then
display as xx year yy month zz
days.
Best regards.
Kittiphum Worachat
As far as I know MySQL does not yet support nested SELECT statements.
-Nick
Hi,
I am new in the MySql business so I'm sorry if my question is too
simple. Is
there any
way to nest queries in MySql in the following
manner: select field from
table
where id = (select ...)
Thanks for your
See what I mean?
I can't beleive there is nothing that can be done with sql about this
but I can't seem to find anything that will tell me how to do it so a little pointer
would be smashing.
Many thanks...
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version
;
$qry.=FROM $this-table ;
$qry.=WHERE module = '$module' ;
$qry.=ORDER BY date ASC;
Thanks very much for the help!
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux
?
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE819tsHpvrrTa6L5oRAkUjAJ0WsLUYpOkKmWAwvn08m8ewQ6cgMQCcDxoq
iOgEUaj2XvG3trF/nWqQXt4=
=Uh1r
-END PGP SIGNATURE
/ I do. Many thanks Victoria :-)
sql
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE81+GXHpvrrTa6L5oRAuMXAJ0clmtEYrYscsNlNgCktrN5AlPDfwCffgWS
bfCr8rkBNl4YwtNo7TAbbWY=
=/rKf
-END PGP SIGNATURE
;
}
$db=mysql_select_db($this-db) or die (can't select db);
return TRUE;
}
Many thanks for any help :-)
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE81ls
find description of this error there:
http://www.mysql.com/doc/A/c/Access_denied.html
Yes, I've already been there. No luck. the problem seems to be on/off
part of the time it is okay and at other times not. It is just a regular
'Access denied to user 'nick@localhost using passwore YES
because as I said, I can connect
sometimes and not others.
- --
Nick Wilson // www.tioka.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE81oh/HpvrrTa6L5oRApPXAJ4uZhnlEh1uVOUva5QJRXtFq8H82ACfedLj
ss8aXzi5/Spgwn2migqqnW4=
=HVzX
-END PGP SIGNATURE
for MySQL to take the new db?
Also I tried it by
using:
shell.exec(C:\\mysql\\bin\\mysqladmin -u root -p* CREATE
quake3parsed).waitFor();
as well but that gave the same results.
Thanks for the
help in advance.
-Nick
on how others have solved this sort of problem?
Nick
P.S. sql,query (to satisfy that danged filter)
--
[EMAIL PROTECTED]
(408) 904-7198
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
:
(running on Linux)
service mysqld stop
/etc/init.d/mysqld --skip-grant-tables // no joy
/usr/libexec/mysqld --skip-grant-tables // no joy
service mysqld --skip-grant-tables start // no joy
I'd appreciate a little help :-)
- --
Nick Wilson // www.tioka.com
-BEGIN PGP SIGNATURE
with databases
from /var/lib/mysql' and just hangs
any ideas?
thanks james..
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD8DBQE8ztUxHpvrrTa6L5oRAlCrAKC3HOrhNL2XkeUB68EHuYExKzPMIQCdGdji
khY4FsLiU4JeTj03OJzjNKw=
=1fV6
-END PGP
Does anyone know why this is happening? It seems like the double quote
matching isn't working...
-- Nick
mysql SELECT count(id) FROM products WHERE MATCH (SearchData_AutoUpdate)
AGAINST ('socket abcde' IN BOOLEAN MODE) order by MATCH
(SearchData_AutoUpdate) AGAINST ('socket abcde
prompt.
It is not hung.
Just hit enter.
Nope, it's hung, I get nothing and not even CTRL-C will stop it, I have
to physically close the terminal.
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux
questions though:
* how will I tell where the db's are and how to point it at 'em?
* where will I find the error log?
Apologies for being so clueless, but many thanks for all the help...
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux
databases in /var/lib/mysql?
yep, they sure are...
- --
Nick Wilson // www.explodingnet.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (GNU/Linux)
iD4DBQE8zuxFHpvrrTa6L5oRAglVAJ4tYxwBLjKVO6LPF1TP9XXh9PfUkwCVGY4t
BPPTG3iJQ4w9RzYxuGMbGg==
=LuRo
-END PGP SIGNATURE
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
sql
* and then James Carrier declared
It's OK Nick - it started. It's just writing that to the terminal
window. Hit enter to get the command prompt back (or ctrl-c if that
doesn't work).
Ahhh,,, what a donkey (me not you) of course
suggestions?
Nick
--
[EMAIL PROTECTED]
(408) 904-7198
-
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
Whats your INSERT statement look like? And does it give any errors back?
-Nick
I am
using MySql with Visual Basic.
I Got an ERROR when trying to add a new record in
situation as under.
I have a table Company
and a field in that table EmpName char
(20)
and one record is there value
101 - 200 of 294 matches
Mail list logo