The message you are getting indicates that it cannot find the executable
file. You are getting this because you are not putting a space between the
executable name mysqld and your command-line option --standalone.
Unless you have some reason to not want to run mysql as a service, I
reccommend
Is there anybody willing to help me?
I have mysql v3.23.39, and i'm trying to use the mysql-fulltext engine,
looks like it's not funcitonal very well(maybe my mistake).
I had created example database for fulltext as written in manual, inserted
about 10Megs of text files.
When I try to do match
Hi!
On Sep 23, cajmilfo wrote:
Is there anybody willing to help me?
I have mysql v3.23.39, and i'm trying to use the mysql-fulltext engine,
looks like it's not funcitonal very well(maybe my mistake).
I had created example database for fulltext as written in manual, inserted
about 10Megs
Here a good place to go through this step by step.
Good luck and happy MySQL'ing
M;)
-Original Message-
From: Kamesh P S [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 23, 2001 6:40 AM
To: [EMAIL PROTECTED]
Subject: user creation in mysql
me too facing the problem
in creating
.
Dear List-Members,
As I am EXTREMELY new to mysql and my connection to my ISP is a
pay-per-minute one, doing the endless testing (koff, kofff Ok, farffing
around, getting lost, tired and emotional) with mysql can cost some dosh
over time. I've only recently arrived at this work-station
Hi,
I've been checking out MySQLGUI 1.7.5-2 for win 32. I've been able to
create a database, but, I can't seem to get it to create a table using
Commands/Tables/Create tables.
Is it safe to assume that this is a know issue?
Thanks,
Steve.
http://www.devshed.com/Server_Side/MySQL/Access/page2.html
-Original Message-
From: Mike [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 23, 2001 9:31 AM
To: Kamesh P S; [EMAIL PROTECTED]
Subject: RE: user creation in mysql
Here a good place to go through this step by step.
Good
I suggest downloading/installing the MySql ADO library (available from a
link off mysql.com downloads). Then you can write ASP pages (using ado
objects) to interact with your mysql database.
Before my suggestion catches the ire of all the php/linux snobs, I must
point out that our friend wants
Hi
Take a look at the following links, which guides you step by step in
managing the user accounts:
http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Adm
inistration.html#User_Account_Management
Regards, venu
--
For technical support contracts, go to
R Talbot wrote:
R Talbot wrote:
Michael Widenius wrote:
The problem is probably that your tar program doesn't use user-names
but user-ids, in which case the files may be owned by 'anyone.
What output do you get for:
ldd bin/mysqld
[root@thinkpad]# ls -l
Hello,
Can someone who has successfully created a MySQL database for a virtual
hosting account show me how to connect! I can always
connect as root ... but when I try to connect as the user its get a
permission error. I went to the database and gave the user of that virtual
account all
Hi all,
I'm having a problem where the optimiser seems to take a *very* long time to
work out which indexes to use.
Although I'm using a lot of joins, it takes around 10 minutes to give an
EXPLAIN of the query shown below. The actual query takes only a second or
two (or so it appears).
How do I convert (or create from scratch) a table who's AUTO_INCREMENT
column would be a, b, c, d, e and so forth up to z?
At the moment I am using an INT column 1, 2, 3, 4, etc, but I would really
be able to make good use in my queries if this column was alphabetical
instead.
Thanks.
Neil
Hi,
I am trying to install MySQL in my own account on Sun Sparc
solaris2.7. I am an EE student trying to finish a project. Here
is my problem:
I downloaded source MySQL file to my home directory. As I am not
root user, I failed to run groupadd mysql and useradd -g
mysql mysql. After I
Neil Silvester writes:
How do I convert (or create from scratch) a table who's AUTO_INCREMENT
column would be a, b, c, d, e and so forth up to z?
At the moment I am using an INT column 1, 2, 3, 4, etc, but I would really
be able to make good use in my queries if this column was
Hi,
I attached a wrong file in my last email. I should have sent you
config.log file. Here it is.
Sorry for the mistake.
Thanks again.
Huai Liu
This file contains any messages produced by compilers while
running configure, to aid debugging if configure makes a mistake.
configure:813:
On 23-Sep-2001 Neil Silvester wrote:
How do I convert (or create from scratch) a table who's AUTO_INCREMENT
column would be a, b, c, d, e and so forth up to z?
At the moment I am using an INT column 1, 2, 3, 4, etc, but I would really
be able to make good use in my queries if this column
I know you can set a column in each table that will update itself with the
current ctime every time that row is modified, but I haven't found a per db,
or per table variable yet. (I believe mSQL has something like this, but not
mysql.
---
Jason H. Frisvold
Senior ATM
Setup :
MySQL 3.23.42
Perl 5.6.0
DBI 10.32
I’m trying to do a few different queries where the table name needs to be
dynamic. I’ve tried the following :
$dbquery = $dbhandler-prepare_cached(“SELECT id, target FROM ? where
somedata=?”);
$dbquery-execute($tablename,$somedata);
But I keep
Hello,
I checked my .err file today and found these:
-
InnoDB: error in sec index entry update in
InnoDB: index UNQ_USER_NAME table rateGenius/USER_USER
InnoDB: tuple 0: len 7; hex 616d626a6f7267; asc ambjorg;; 1: len 8; hex
1d1b; asc ;;
InnoDB: record RECORD: info bits 0 0:
Hello
I have problems building the mysql package for the Debian distribution on
powerpc. More infos below. Feel free to contact me for further details.
bye,
-christian-
make[3]: Entering directory `/home/ch/debian/mysql-3.23.42/sql'
g++ -DMYSQL_SERVER
Er, a little embarassed that I did not check the bugfixes page before
reporting that. Anyhow, here is the check table to go with that report:
+--+---+--+--+
| Table| Op| Msg_type | Msg_text |
Sooo, when does this highly anticipated version of mysql get released?
Supposed to have union tables :).
- Deryck H
- http://www.comp-u-exchange.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Does mySQL not support this syntax?
CREATE DATABASE newDB ON
(
NAME = 'newDB',
FILENAME = '~/newDB.mdf',
SIZE = 10MB,
MAXSIZE = 20MB,
FILEGROWTH = 1MB )
--
Sincerely,
Rosyna Keller
Technical Support/Holy Knight/Always needs a hug
Unsanity: Unsane Tools for Insane People
Hi,
Just a quick query. I haven't been able to locate any documentation on it,
but has anyone ever used an expect script to connect to a MySQL database
and pull out a bunch of data for use further in the expect script ?
Any directions would be appreciated.
Cheers
Chris
--
Chris
As I am still a newbie to mysql I am sure that some of the problems that I
am coming accross are created by myself, and others are probably so simple
that they are staring me in the face. I do, however, seem to be having some
problems with the below statement.
I would like the result of the
At 11:55 23/09/01 +1000, you wrote:
Thanks Will for the suggestion, however as per my private email to you, it
didn't work successfully to any degree. Actually it knocked out ONE date
from the same group and that was one of the Available dates.
I'll take my foot out of my mouth now and
rtfm.
Excerpt from mySQL manual.
=
6.5.1 CREATE DATABASE Syntax
CREATE DATABASE [IF NOT EXISTS] db_name
CREATE DATABASE creates a database with the given name. Rules for allowable
database
names are given in Section 6.1.2 [Legal
It is possible and not very hard at all.
But why would you need expect? Why not
just use a shell script?
Neil
On Mon, 24 Sep 2001, Chris Aitken wrote:
Hi,
Just a quick query. I haven't been able to locate any documentation on it,
but has anyone ever used an expect script to connect to a
R Talbot wrote:
R Talbot wrote:
R Talbot wrote:
Michael Widenius wrote:
The problem is probably that your tar program doesn't use user-names
but user-ids, in which case the files may be owned by 'anyone.
What output do you get for:
ldd bin/mysqld
I am having problems getting an update to work correctly. Assume that I have two
tables, employee and office. Employee has two fields, employee_id and employee_name,
and office has three fields, office_id, office_number, employee_id.
I have been using inner join to link the tables together
On Sun, Sep 23, 2001 at 07:54:59PM -0500, Deryck Henson wrote:
Sooo, when does this highly anticipated version of mysql get released?
Supposed to have union tables :).
In about a week or too, based on what Monty said earlier today. :-)
Jeremy
I guess thats a no. I wasn't sure if it was hidden in some other
documentation file. Is there a page that details things that can be
done in MS SQL Server and not mySQL?
Ack, at 9/23/01, Will French said:
rtfm.
Excerpt from mySQL manual.
--
Sincerely,
Rosyna Keller
Technical Support/Holy
I am assuming from your email that the field ID allows duplicates. In that
case, use the SELECT DISTINCT syntax ... that will get you back the 1 row
you are looking for. However, if the (ID,CompetitorName) tuple is unique,
SELECT DISTINCT will NOT help.
Hope this helps
Raj
At 06:12 PM
In answer to your question - your statement does not work becuase mysql does
not allow joins in update statements.
imho, the fact that mysql does not support joins in UPDATE and DELETE
statements is by far its greatest weakness. I have posted a couple of
messages to this group to see what
At 11:36 PM 23/09/2001, Neil Zanella wrote:
It is possible and not very hard at all.
But why would you need expect? Why not
just use a shell script?
Because the task I need the script to do is best done using Expect (its
interfacing with a serial port doing things with some data pulled out of
hello all, I use ADO to connect to mysql database. I get an ADO
recordset to show datas and update the modified records with SQL
statement. So I shall resync the recordset and the database myself. But
when I call the method Resync I get an error which code is 80004005 and
the meaning is such as
Hi Stephen,
- Original Message -
From: Stephen Faustino [EMAIL PROTECTED]
We are encountering two issues when using MySQL with large tables
(by large, we're talking 1 million rows). Our application is written in
Java and we are using the mm.mysql JDBC driver. We run our
Hi,
We have MySQL 3.23.27 stalled and running on a Solaris 2.7 machine. We are
planning to move our server to AFS school system (OS version is Solaris 2.7
(Sparc)). The AFS version is 3.5 or 3.46.
Is anybody know whether MySQL 3.23.27 is compatible with AFS 3.5 3.46?
Can we do the moving.
I so
Robert,
you are a genius in finding bugs :).
The bug has been reported by two users before you.
Since CHECK TABLE says ok, the table is probably
ok now.
The bug may be in purge in multiversioning: it removes
a secondary index record too early. Or it may the
in a lock wait.
Can you describe
Thanks for your reply.
Use database to restore file is the requrement of our project ,So I must
find the way of problem.
As you said ,I trust the problem is beacuse of mysql protocol that is the
filed must be send as a single packet. I have same test in postgresql ,In
postgresql the blob type
- Original Message -
From: [EMAIL PROTECTED]
To: Jason Parker [EMAIL PROTECTED]
Sent: Monday, September 24, 2001 2:19 PM
Subject: Re: Fw: mySQL
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
42 matches
Mail list logo
