Hello All,
Sorry My mistake I resolved it like this:
mysqladmin -u root shutdown
mysqld_safe &
and it showed me mysql 4.0.13
Thank You,
Tina.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks Roger for quick response.
Herebelow the structure of my table and query.
CREATE TABLE npg_search (
sno int(11) NOT NULL auto_increment,
fileid varchar(255) NOT NULL,
caption text,
headline varchar(255),
specialins varchar(255),
keywords varchar(255) NOT NULL,
cat varch
Hey all... I did a quick check of the archives, but didn't see anything recent about
this...
I use PHP and mySQL, and am supposed to be able to randomize the order in which the
rows are held when retrieved using ORDER BY RAND(). This isn't working for me... it's
on a third-party server over wh
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Maciej Bobrowski wrote:
> Hi,
>
> We have a java server connected to mysql v. 4.1.0. It connects and remains
> connected (it should). Some people work on it from about 7 a.m till about
> 3 p.m. In the morning when we come to work, we can see the link
Sjef Janssen <[EMAIL PROTECTED]> wrote:
> No, there are just a few rows in my table, as I am still developing the
> program. Will it be better when the table is in regular use (and the number
> of rows will increase)?
How many rows in the table? how many rows contain the search word?
>
>>
>> >
Ah. No wonder it dinna work. Neither did specifying the columns as Jay
suggested.
I also have no choice but to do it through the browser - I don't have
command line access on the server. :\
-Mike
> -Original Message-
> From: Donald Tyler [mailto:[EMAIL PROTECTED]
> Sent: Friday, Augu
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Monica Ferrero wrote:
> Hi!
>
> I'm not sure if this is the most adequate mySQL list for this post. If
not,
> please indicat me which one I should use...
>
> I'm using Tomcat 4.1.24 with Apache 2 and MySQL 4.0.13. I have the mysql-
> connector-java-2.
I'm coming from a Filemaker Pro background and have very little SQL experience. I'm
trying to write an SQL statement to extract data from two tables. One table has the
Team IDs, Team Names for all the high school football teams in the state. The other
table has the schedules for all the games. T
Steve:
What you are talking about is Stored Procedures ... not available in the
current stable version of MySQL.
Stored Procedures are, however, being implemented in MySQL Version 5.0's
development tree. This version is still in heavy development ... I wouldn't
use it on a production server.
Ger
I, like others, am having trouble getting the two UDF's mentioned above
to work correctly. I successfully compiled MySQL 4.0.14 dynamically
with the -rdynamic flag on Linux 8. I have also compiled the
udf_example.cc file using the -shared option. Everything seems to go OK
when I'm using the CREA
I am using MYSQL 4. I understand that it allows for
foreign keys. Could someone show me an example of how
to declare a foriegn key. I tried a combination of
statements but I always got a syntax error.
Here is what I am trying for example ...
Create table x (
ID INT NOT NULL AUTO_INCREMENT
Hi,
> I am trying to understand the logic of full text search in mysql. I'm not
> using mysql 4. The search work OK, be it thast I get hits on certain
> words, whilst other words are discarded for some reason or other. Why is
> that. An example: I search in a text field for the word organisation.
I am using MYSQL 4. I understand that it allows for
foreign keys. Could someone show me an example of how
to declare a foriegn key. I tried a combination of
statements but I always got a syntax error.
Here is what I am trying for example ...
Create table x (
ID INT NOT NULL AUTO_INCREMENT
try have a look at /var/lock/subsys/ see if there is a lock file for
mysql... if there is try remove it and start mysql again... hope this
help
Cheers,
Clive
-Original Message-
From: Robert Morgan [mailto:[EMAIL PROTECTED]
Sent: Monday, 11 August 2003 12:21 PM
To: mysqllist
Subject: F
What OS/kernel are you running? Thanks.
Richard Gabriel
Director of Technology,
CoreSense Inc.
(518) 306-3043 x3951
- Original Message -
From: "Terence" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 11, 2003 2:28 AM
Subject: Error 127, some questions
> Dear List,
>
Anubrata Chakrabarti <[EMAIL PROTECTED]> wrote:
>
> Thanks!
> I did that and started mysql as : safe_mysqld --interactive_timeout=10
> But it DOESN't go away after 10 secs.
Show me the output of SHOW VARIABLES LIKE "%timeout%".
>
> On Fri, 1 Aug 2003, Victoria Reznichenko wrote:
>
>> Anubrata
[snip]
I see you still have the word LOCAL in there. Did you try and remove it?
To do that in PHPMyAdmin you will need to run the import so you get the
error message and then copy and paste it into the SQL section of the
PHPMyadmin tool. Delete the world LOCAL and then run the query. It
should
wor
>
> what ever happend to a unique primary key like userID ?
>
User is not the primary key. This is a logging table so the primary key is
likely to be a timestamp of some sort.
Read the question.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
Hello,
mysqld_multi doesn't start the two groups if I gave this command imediately
after stopping them.
Thanks Anticipated,
Iulian
.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi
Every night. I dump the schema of a table, drop it, create the table, and
load it up with data.
I'm using phpMyAdmin for the most part. I notice that the index cardinality
shows up as None in phpMyAdmin for each index I have. If I drop the index
and re-create it, all of the indexes show thei
No, there are just a few rows in my table, as I am still developing the
program. Will it be better when the table is in regular use (and the number
of rows will increase)?
Sj
>
> > I am trying to understand the logic of full text search in mysql. I'm
not
> > using mysql 4. The search work OK, be
Thanks alot roger.
Right now i m going through the indexes and Full text search stuff. I'll
surely let u know any improvement in the performance after i m done.
Binay
- Original Message -
From: "Roger Davis" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 11, 2003 5:
This isn't a complete answer but it may point you in the right direction...
I had some experience of using localized text (most of the popular
languages) in a database a couple of years ago. That was using Oracle but
the lessons are the same.
Initially Oracle was not UTF-8 enabled. Alot of text c
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Mon, 11 Aug 2003, System wrote:
> Hello All,
> Redhat 9.0
> Mysql 3.23.56 ==> Running
>
> I want to upgarde to 4.0.13 but this is the error it says:
> [EMAIL PROTECTED] downloads]# rpm -Uvh MySQL-server-4.0.13-0.i386.rpm
> warning: MySQL-serve
On Sun, Aug 10, 2003 at 05:25:05PM -0700, James Johnson wrote:
>
> I have a MySQL database for books. The ISBN field is set as varchar(15) and
> I've put a test ISBN number in of 1--111-11.
Note that ISBN numbers are a maximum of 13 characters, not 15. Ten
digits, three dashes. If you really
In the last episode (Aug 06), Pierre-Luc Soucy said:
> I was working on some merge tables this morning and it worked fine,
> but after a few unsuccessful table creation requests (I was making
> some tests), I could not alter or select from a table for the
> following reason:
>
> mysql> create tabl
"Nils Valentin" <[EMAIL PROTECTED]> wrote:
> Hi Victoria,
>
> Victoria Reznichenko wrote:
>
>>"Nils Valentin" <[EMAIL PROTECTED]> wrote:
>>
>>
>>>I have a problem understanding why MySQL is deleting a unique key instead of
>>>a primary key.
>>>
>>>from Documentation: DROP PRIMARY KEY drops th
Hi Tony,
First, as I just saw that everything is on C:\. In this case you wont even
need the two settings basedir and datadir as far as my understanding goes.
I remember that after having registered the service itself "mysqld
--install", I used the command "net start mysql" to start the servic
Has anyone had much luck with UnixODBC on RedHat Linux. I've recently moved
a 100 Gb MySQL database from Win2000 Server to a RedHat 9 server and installed
UnixODBC to access it. It appears that the performance is dramatically
slower using the same application, pointed to the RedHat server.
Th
Hi programmers, Good morning ;-)
I think something is wrong,
Running windows I believe first I have to set some password,
Which creates some user,
Then I can grant the required privileges, for some databases.
However granting privileges after setting password seems to reset some
Other access,
On Wednesday 06 August 2003 11:50 am, Andy Smith wrote:
> > There is one more thing I can think of to check...
> > Can you send me a copy of the
> > "master.info" file. I've had to manually change it before after changing
> > the master in the my.cnf file. I found out later that you could do
> > "C
On Wed, Jul 16, 2003 at 03:49:51PM -0700, Cory Lamle wrote:
> Contents are Direct Alliance Corporation CONFIDENTIAL
> -
> I have a table with 10 cols. 8 of which all need to be searched on
> independently of each other.
>
> Does creating 8 separate indexes for that table affect the speed of how
>
32 matches
Mail list logo