-Original Message-
From: Heikki Tuuri <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Sunday, January 06, 2002 7:54 AM
Subject: Re: help with innodb my.ini config
>Hi!
>
>MySQL does not find your my.ini.
>
>Try renaming it to my.cnf and put it to the root directory o
No dice. I'm not thinking like that's the problem. Those two directories
are identical. If anyone feels inclined to, I'll make an account that
people can SSH-login into...I'm going bonkers trying to figure out what this
problem is...
- Original Message -
From: "Neil Zanella" <[EMAIL P
Good try but under Red Hat 7.2 the scripts /usr/share/mysql/mysql.server
and /etc/init.d/mysql differ in some respects. Try the latter script
instead.
Bye,
Neil
On Sat, 5 Jan 2002, Alexander Trauzzi wrote:
> Here's a quick update to the problem I posted (which I'll include just for
>convinie
In the last episode (Jan 05), Fred Taurus said:
> I am looking for a solution in order to monitoring mysql daemon to
> restart automatically the daemon when is down.
>
> I was thinking maybe there is a possibility like services watching in
> the cobalt interface
The mysqld_safe script already do
I noticed that your update says the server just stopped.
Try looking in the server error logs under the mysql directory
hostname.err, (replace hostname with your own),
and it may help tell you what went wrong.
--
Steve Rapaport
World Citizen
--
Here's a quick update to the problem I posted (which I'll include just for convinience
sake).
I went into /usr/share and I ran "mysql.server start" and it returned just this:
"020105 18:22:20 mysqld ended"
Any more thoughts?
-=-=-=-Previous message-=-=-=-
I have a RedHat 7.2 machine going
This very cryptic error message is what you get when you try to connect
to the mysql server and it's not running.
It should probably read: mysql_real_connect(): Failed because there
is no server running. Run a server and try again.
Anyway, if your machine is properly set up to run mysql on boo
Hello all,
I'm working on a photo album engine where a few MySQL queries find which
thumbnails that should be around the image queried (in order of time).
I ended up starting with a query to get the time, filename, etc., of the
requested image, and then one query for images before and one query f
Hello Everyone!
This happens when i try to compile with gcc 3.1 (redhat) on my redhat 7.2
installation. (yes i have upgraded to 3.1 from the
"default" 2.96 version). I get the same result with 3.0.1 also from Redhat.
any ideas ?
regards, Johan
gcc -DUNDEF_THREADS_HACK -I./../include
Fred,
You could use something like daemontools (http://cr.yp.to/daemontools.html)
or safetynet (http://www.unixpimps.org/software/safetynet/).
All assuming you are using a UNIX-type platform, of course.
Tom Haapanen
[EMAIL PROTECTED]
-Original Message-
From: Fred Taurus [mailto:[EMAIL
my.ini looks like this:
#This File was made using the WinMySQLAdmin 1.3 Tool
#12/21/2001 6:19:15 PM
#innodb code added 1/5/2002 1550CST
#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions
[mysqld-max-nt]
basedir=C:/mysql
#bind-address=24.26.165.120
d
I have a RedHat 7.2 machine going, and I'm getting the following error when I run
"mysqltest" after starting the MySQL Daemon...
mysqltest: Failed in mysql_real_connect(): Can't connect to local MySQL server through
socket '/var/lib/mysql/mysql.sock' (111)
First of all, I've relocated the
Thanks for the reply.
gcc and g++ are both version 2.95.3
I've tried installing three different binaries, one from the mysql site
and
two different versions from the Bull site. All failed with different
problems
on this machine so I tired them all on a different model machine, but
running the
I am running MySQL (v 3.23.43) on a Win NT server and require an applet to
communicate with the database. Unfortunately the ISP has blocked all
access to port 3306 at the router, which I think is the cause for my not
being able to load any data in the applet (Meanwhile, beans served up
through To
Hi!
Your my.ini looks ok, except that you should set
innodb_data_home_dir
equal to an empty string if you give absolute paths in innodb_data_file_path
Regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the onlin
I see 2 possible problems:
1) syntax: I had to experiment with the mysql line a bit before
it worked. Try:
mysql -urknop -p
password
(Note no space before username, password last)
2) Your user has no permissions at all: I've never tried that, but
I wouldn't be surprised if it made login impo
Hi!
-Original Message-
From: Peter Zaitsev <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Saturday, January 05, 2002 10:35 PM
Subject: Innodb/Replication problems.
>Hello mysql,
>
> I'm using mysql 3.23.47 with Innodb and t
good day list,
i'm running 3.23.46a win on win2k and had no trouble installing and using
myISAM tables
and using a access front end w/myodc - this was easy and fun.
now i'm trying to config to use innodb tables
i stopped the service and edited [mysqld] to [mysql-max-nt] in my.ini
and added th
[gcc version 2.95.2; mysql 3.23.47]
: What was the problem you got with compiling MySQL on this platform?
: If you follow the instructions in the Solaris section in the MySQL
: manual, this should be very straightforward!
I'm not getting any errors. My compile is getting stuck at:
/bin/s
On 1/5/02, regarding" Re: mySQL : 3 or 4? ", Girish Nath wrote:
>Hi
>
>If i were in your position i would use 3.23.x mainly because that's what the
>majority of hosting facilities use as their platform right now. It's a pain
>to develop something with all the latest and greatest features then r
Hello mysql,
I'm using mysql 3.23.47 with Innodb and trying to play around with
replication. The replication options are default.
I got one table content occasionally deleted on slave, and note what
this did not stop the replication: The inserts are successfully
passed, therefore the u
I have a txt file with sql commands eg:
drop table name
CREATE TABLE NAME
(KD NUMERIC(3),
OO CHAR(30));
insert into name values (1,"John");
insert into name values (2,"George");
insert into name values (3,"Chris");
insert into name values (4,"Patrick");
Using mysql-max-3.23.47 for win98 how can
> It's probably a good idea to remove the entry for ''@'localhost'.
For many reasons, yes. :)
-Rob
(SPAMblocker food: sql table query database)
--
-=-=-= Rob Knop =-= [EMAIL PROTECTED] =-= http://www.pobox.com/~rknop =-=-=-
Help the EFF protect basic freedoms online: http://www.eff.org
Hi
If i were in your position i would use 3.23.x mainly because that's what the
majority of hosting facilities use as their platform right now. It's a pain
to develop something with all the latest and greatest features then realise
you have to deploy your app on something not so upto date, if you
Robert A. Knop Jr. writes:
> > localhost is a special value (meaning connection over unix socket
> > rather than TCP/IP), and it's not matched by % in this case. You
> > need to grant access to user@localhost as well.
>
> (Is this in the manual? If so, I didn't find it.
Heh, it turns out that
Hello ,
I am looking for a solution in order to monitoring mysql daemon to
restart automatically the daemon when is down.
I was thinking maybe there is a possibility like services watching in
the cobalt interface
thanks in advance
@+
Fred mailto:[EMAIL PROTECTED]
--
On Sat, 05 Jan 2002 11:28:54 -0800, Kevin Campbell <[EMAIL PROTECTED]>
wrote:
>>Im using a field in a form to record money values: 0.00 9000.00 in my
>>database table.
>>Im planning on using float(4,2). Does the 4 mean the maximum number of
>>digits before the decimal and the 2 the number of
Im using a field in a form to record money values: 0.00 9000.00 in my
database table.
Im planning on using float(4,2). Does the 4 mean the maximum number of
digits before the decimal and the 2 the number of digits after the decimal.
"Always an Email Away"
Kevin Campbell
Chief Executive O
Hi!
Another patch for mit-pthreads under NetBSD. The newer gcc that is now used
on NetBSD-current needs a prototype for select(2) to compile mysqld.cc
otherwise it aborts with:
mysqld.cc: In function `void * handle_connections_sockets(void *)':
mysqld.cc:2314: implicit declaration of function `
Hi!
> "Sinisa" == Sinisa Milivojevic <[EMAIL PROTECTED]> writes:
Sinisa> fil krohnengold writes:
>>
>> Am I crazy, or should there be some CREATE TABLE statements
>> somewhere in the mysql_install_db script? It keeps dying on me
>> with:
>>
>> Starting mysqld demon with databases from /
Stan:
I don't know as I would call anything involving MSSQL Server 'painless", but
it can be done.
Do a search of the list archive (http://lists.mysql.com/), looking for
'SQL7' or 'MSSQL'. There have been dozens of posts over the last couple of
years describing different ways to approach the tas
From: Kevin Campbell <[EMAIL PROTECTED]>
> What's the best data type to use for storing guest book comments in my
> database table.
The "best" data type would be the kevins_gb_comment data type, but I don't think
that's implimented in MySQL yet.
If all you are doing is storing and retrieving t
Whats the best data type to use for storing guest book comments in my
database table.
"Always an Email Away"
Kevin Campbell
Chief Executive Officer
The Club Mix, Inc.
http://www.theclubmix.com
I am having similar nested join problems with the following:
SELECT tblThread.Message_date, tblAuthor.Username, tblAuthor.Author_ID,
tblTopic.Forum_ID FROM (tblForum INNER JOIN tblTopic ON tblForum.Forum_ID =
tblTopic.Forum_ID) INNER JOIN (tblAuthor INNER JOIN tblThread ON
tblAuthor.Author_ID = t
Hi..
Is there any painless way or good documentation on how to convert a
database from Micro$soft $QL 2000 into MySql?
Thanks in advance for any directions you can point me to.
Stan
-
Before posting, please check:
http://www
Does MySQL have anything functionally equivalent to the data dictionary
views of Oracle? I am thinking particularly of retrieving, via a SQL
SELECT statement, a list of all my tables, or a list of all the columns of
a particular table along with the columns' attributes.
TIA.
--Erv
Good afternoon. My first post to this list (and I am sure it won't
be my last ;) )
In the process of biting the bullet and learning AMP, on OS X 10.1.2.
Been messing with PHP for a week now, and I totally LOVE it. Coming
off an 18-month project in W*/FM/Lasso... ready for a change ;)
Anyho
> localhost is a special value (meaning connection over unix socket
> rather than TCP/IP), and it's not matched by % in this case. You
> need to grant access to user@localhost as well.
Aha! That did the trick. Thank you very much.
(Is this in the manual? If so, I didn't find it. It would pro
Robert A. Knop Jr. writes:
>ERROR 1045: Access denied for user: 'rknop@localhost' (Using password: YES)
>
> mysql> select * from user where user='rknop'\G
> *** 1. row ***
>Host: %
>User: rknop
localhos
> I don't know if this is it, but
I don't think so; I've tried "flush privileges", even though the docs don't
state it's necessary for GRANT or SET PASSWORD. I've also tried stopping
and restarting the mysqld process.
-Rob
-
B
I don't know if this is it, but
--
6.11 When Privilege Changes Take Effect
When mysqld starts, all grant table contents are read into memory and become
effective at that point.
Modifications to the grant tables that you perform using GRANT, REVOKE, or SET
PASSWORD are noticed by t
OK, I think I've read the docs and am doing everything right, but I simply
cannot get the "mysql" program to accept a password for any user other than
root.
I'm on RedHat Linux 7.2, with MySQL version 3.23.46.
I can get the root password set up fine, and I log in with it. I can even
change it:
Hello, all
I am sure the answer to the following question is well documented in
the manuals, but I just don't seem to recognize it. Please point me to
the relevant documentation.
I have two tables in the database. Some fields are common (Author,
Date) other are specific.
I know how to find the
Hello & Happy New Year
Can any one tell me if there is a way to connect MySQL or Postgre to SAGE
Accounting Software? From the SAGE site it seems they have an ODBC driver
for M$ products but they are read only;^(
What I want to be able to achieve is to be able to read/write to SAGE from
either M
At Sat, 05 Jan 2002 15:34:10 +0200, [EMAIL PROTECTED] wrote...
: fil krohnengold writes:
: >
: > Starting mysqld demon with databases from /usr/local/mysql/data
: > ERROR 1017 at line 3: Can't find file: 'db.frm' (errno: 2)
: > The grant tables was not installed.
: >
: > Line 3 being the
At Sat, 05 Jan 2002 15:15:15 +0200, [EMAIL PROTECTED] wrote...
: fil krohnengold writes:
: >
: > I wish it were as easy as a botched gcc install. But it's not.
: > I just tried using the pre-compiled binary from ftp.ibiblio.org
: > for 2.95.2 with identical reslts.
: >
: > -fil
:
: Try build
* Anthony Rodriguez
> The following php script successfully e-mails both messages but
> it doesn't update in the table "scr_149" the column "notified".
> Why?
Try moving this line:
> $qry_2="update scr_149 set notified='y' where username='$username'";
...after this line:
> $username=$row_1["u
* Manjeet
> create table user (Login_Id varchar(16) NOT NULL, Location varchar(16) NOT
> NULL, PRIMARY KEY (Login_ID));
>
> The above table should not take any null values.
> I tryed inserting some null values eg:
>
> INSERT INTO user (Login_Id,Location) values ("","");
>
> According to me this st
Manjeet writes:
> I created table using following syntax,
>
> create table user (Login_Id varchar(16) NOT NULL, Location varchar(16) NOT
> NULL, PRIMARY KEY (Login_ID));
>
> The above table should not take any null values.
> I tryed inserting some null values eg:
>
> INSERT INTO user (Login_Id,
The following php script successfully e-mails both messages but it doesn't
update in the table "scr_149" the column "notified". Why?
\n");
$result_2=mysql_query($qry_2,$connection) or die ("No query # 2!");
};
mysql_free_result($result_1);
$qry_3="select * from scr_149 where q05a=\"0\" && not
David,
My system (3.23.40-nt and MySQL-Front 1.18b as client) produces (what I think is) the
desired result using
both/either the NULL or NOW() alternatives - NOW (without function parentheses) is not
recognised.
However the INSERT statement below does not work without the addition of the VALU
I created table using following syntax,
create table user (Login_Id varchar(16) NOT NULL, Location varchar(16) NOT
NULL, PRIMARY KEY (Login_ID));
The above table should not take any null values.
I tryed inserting some null values eg:
INSERT INTO user (Login_Id,Location) values ("","");
Accordi
Kris Saw writes:
> We have been using mysql for some time to run and administer our dynamic
> content sites. During this time we have run mysql on low end intel
> hardware (dual PIII 900 with a gig of RAM) on linux and have discovered
> that a single mysql server in this configuration could not
We have been using mysql for some time to run and administer our dynamic
content sites. During this time we have run mysql on low end intel
hardware (dual PIII 900 with a gig of RAM) on linux and have discovered
that a single mysql server in this configuration could not handle all
the traffic fr
Hi!
> "Quentin" == Quentin Bennett <[EMAIL PROTECTED]> writes:
Quentin> Hi,
>> From the cc(1) man page for Forte Developer 6.2
Quentin> These predefinitions are valid in all modes:
Quentin> __sun
Quentin> __unix
Quentin> __SUNPRO_C=0x530
Quentin> __`uname -s`_`uname -r`
Quentin> __sparc (SP
Marinos writes:
> Hi, i'm newbee in mysql and i want to ask you 2 questions
> i'm using mysql-max-3.23.47 for windows and mysqlgui-win32-static-1.7.5-2.
> 1) Is it possible to use more than one command in mysqlgui (the end of line
> charachter ; is not working)
> 2)Can i load and execute a text f
[EMAIL PROTECTED] writes:
> >Description:
> ##After building mysql and installing the GRANT tables I start the daemon
> ##and then try to run the mysql client to alter the GRANT tables to a
> ##useful configuration. Subcommands like connect and use seem to work
> ##ok, but if I tr
fil krohnengold writes:
>
> Am I crazy, or should there be some CREATE TABLE statements
> somewhere in the mysql_install_db script? It keeps dying on me
> with:
>
> Starting mysqld demon with databases from /usr/local/mysql/data
> ERROR 1017 at line 3: Can't find file: 'db.frm' (errno: 2)
Jesse Shy writes:
> I am push a couple of date fields to mysql via the myODBC driver, however
> the fields are in there original format as JUN01/01 and the like. Right now
> these fields are type CHAR and I cant do any calculations on them. Is there
> a built in function to make this a legitimate
fil krohnengold writes:
>
> I wish it were as easy as a botched gcc install. But it's not.
> I just tried using the pre-compiled binary from ftp.ibiblio.org
> for 2.95.2 with identical reslts.
>
> -fil
> --
> fil krohnengold
> network systems administrator
> american museum of natural history
Sir,
I use visual basic 6.0 and MySQL database
I developed native connection to database by "Adodc" tool
but there is datareport tool in VB6.0. I can't connect database for my
datareport. I can do it by odbc drivers.I dont want this way.
My flowchart is under this text.
DataEnvironment
Connec
Walter D. Funk writes:
> Thanks for your answer,
>
> I´ve created a TEMPORARY table and it seems to work well for my purpose,
> the only doubt I still have is, if the table gets automatically deleted when
> the user
> closes the connection, or should I do something within my script to avoid a
> s
Hi, i'm newbee in mysql and i want to ask you 2 questions
i'm using mysql-max-3.23.47 for windows and mysqlgui-win32-static-1.7.5-2.
1) Is it possible to use more than one command in mysqlgui (the end of line
charachter ; is not working)
2)Can i load and execute a text file which containing comma
63 matches
Mail list logo
