Yes, it looks like the permissions are skewed. YOu might just want to do a
chown -R mysql:mysql /usr/local/mysql
The out-of-the-package permissions should be correct, ownership could be the
issue.
Regards,
Bhavin.
- Original Message -
From: Emiliano Marmonti [EMAIL PROTECTED]
To: [EMAIL
At 10:23 -0800 6/21/02, nellA hciR wrote:
iH
running mySQL 3.23.51, i have a my.cnf file with local-infile=1 and
am able to use the load data local file command when running run
the interactive mysql app (command line).
my problem is that i can not use the load data local command from
a Perl
Below are what I believe to be the relevant lines from the config.log...
Running Debian, 2.4.19pre1 kernel, gcc 3.0.4, glib-2.2.2 with linuxthreads
and the mysql-supplied linuxthreads patch.
After re-reading my original post as well, I realize that I forgot to mention that I
compiled the
At 17:30 -0400 6/21/02, Michael Jessop wrote:
Can someone tell me what this means? I mean, I guess I *know* what it
means, but why?
Placeholders for Python scripts using MySQLdb should be %s, not ?.
Convert your ? characters to %s and see what happens.
The insert statement into a mysql
hi guys
im working with some unicode data , store it in mysql db and retrieve it
now its storing the data fine when i use longtext or mediumtext
EXCEPT for a few characters it gives BOXes fo those characters in the
web-browser
the boxes suddenly increase their numbr of existance if i
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, June 22, 2002 9:48 AM
Subject: confirm subscribe to [EMAIL PROTECTED]
Hi! This is the ezmlm program. I'm managing the
[EMAIL PROTECTED] mailing list.
To confirm that you would like
[EMAIL
Hello,
In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do
anything as phpmyadmin wont work because root can't do anything at all... I
have complete ssh access etc to the server, Please help me out what do i do
to give root full privs again?!? please help me make mysql work
Hello,
In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do
anything as phpmyadmin wont work because root can't do anything at all... I
have complete ssh access etc to the server, Please help me out what do i do
to give root full privs again?!? Please help me get mysql
I have a mysql dbase.
I use a time field to save a number of hours (think about number of
houres spent out of office, or anything else).
A table holds the global values for people and their status, another
table holds every single entry of data, so
john smith 5 hours and 2 minutes outside on
Christian,
Friday, June 21, 2002, 5:42:58 PM, you wrote:
CH Is a restart/reload or a flush tables necessary when creating or removing
CH databases?
Nope.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
Dicky,
Friday, June 21, 2002, 11:04:32 AM, you wrote:
i have a problem with an index of a BerkeleyDB table because this is corrupted
and crashes Mysql (v. 3.23.49).
The size of table file is correct 8Mb for 15.000 records but from a select
I view only the first 957
If I launch
Hi Jesse,
On Sat, Jun 22, 2002 at 03:42:57AM -0500, Jesse Angell wrote:
Hello,
In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do
anything as phpmyadmin wont work because root can't do anything at all... I
have complete ssh access etc to the server, Please help me out
You wrote:
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: Sat, 22 Jun 2002 12:10:01 +0300
Subject: Re: Re: corrupt index in BDB table
Dicky,
Friday, June 21, 2002, 11:04:32 AM, you wrote:
i have a problem with an index of a BerkeleyDB table because this is
Hi,
It seems to be linked with the gethostname_r detection
checking style of gethostname_r routines... other
I think you should have the following line instead :
checking style of gethostname_r routines... glibc2
Can you take a look at the config.log file and tell us what is wrong ?
(in my
[localhost:/usr/local/mysql-3.23.51] root# ./configure
--prefix=/usr/local/mysql
--with-unix-socket-path=/usr/local/mysql/run/mysql_socket
--with-mysqld-user=mysql --with-comment --with-debug
checking build system type... powerpc-apple-darwin5.5
checking host system type...
Hi,
It seems you've not installed automake.
checking for working automake... missing
Download automake 1.4-p5 and then try to run configure again.
(you can also download texinfo to make makeinfo avalaible)
Regards,
Jocelyn
- Original Message -
From: Olivier Schildt [EMAIL
Heikki Tuuri writes:
Jon,
- Original Message -
From: Jon Frisby [EMAIL PROTECTED]
Newsgroups: mailing.database.mysql
Sent: Saturday, June 22, 2002 12:51 AM
Subject: Nasty LIMIT/multi-table DELETE bug?
I just discovered a very scary behavior. We're using MySQL 4.0.1 on
Placed At :
Hi..
I run a replicated mysql server set up..The version i use on the master is
3.23.49 and on the slave is 3.23.46.
following is the problem I'm facing..
the binlog postion on the master and the slave are always in sync with each
mysqld --skip-grant-tables
-Original Message-
From: Jesse Angell [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 3:38 AM
To: [EMAIL PROTECTED]
Subject: mysql help !! urgent
Hello,
In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do
anything as phpmyadmin
I think somewhere in the manual it warns against running slave and master as
different versions.
=C=
-Original Message-
From: Kannan R [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 7:15 AM
To: [EMAIL PROTECTED]
Subject: replication error
On Sat, 22 Jun 2002 11:37:29 +0200 (CEST)
Careri Giuseppe [EMAIL PROTECTED] wrote:
DWP just do from mysql prompt :
DWP mysql repair table [tablename]
REPAIR TABLE doesn't repair BDB tables!
Infact I can not repair BDB table, but when a index is corrupted
what can I do ???
if(ok)
{
include('zap.htm')
}
else
{
include('zip.htm')
}
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
Is there any particular reason that anyone knows of that would prevent
mysql 3.23.51 for windows from working upon the execution of the SHOW
STATUS FROM tablename query?
In Linux it works fine, in windows it crashes mysqld with an illegal op.
Any other SHOW command works but the one I really
At 15:41 +0100 6/21/02, Bill Ferrett wrote:
I would like to have a MySql table where each row has a unique id (using
auto-increment) but is clustered, i.e. physically stored, in a different
sequence, e.g. name. This is so that an sql query to order by namew will be
quicker.
I don't want the
Also, if you are doing any 'LOAD DATA INFILE' where the master has access to
the file but the slave does not, then this could happen. On most errors, the
slave stop replicating and slave status will be turned to OFF.
The error file, hostname.err might tell you some thing too.
Regards,
Bhavin.
I've compiled mysql 4.0.2-alpha from source.
I've created table:
create table test (
id_test int4,
body text);
Next:
create fulltext index test_body on test (body);
insert into test (id_test,body) values (1,'test rpm');
insert into test (id_test,body) values (2,'test rpm');
insert into test
Hi,
This problem is probably due to the fact the ft_min_word_len variable is set
to 4 by default.
Try to add
set-variable= ft_min_word_len=3
in your my.cnf, and then recreate your table (or do a REPAIR TABLE test
USE_FRM).
Regards,
Jocelyn Fournier
- Original Message -
From:
I've looked through Google and the MySQL website without luck.
I'm looking to find a place which discusses the theory of how one should
create a database, how to organize the information, etc.
There's got to be a good site out there, but I'm obviously plugging in the
wrong search terms or
Hi,
We have been using a simple mySQL database successfully for some time.
The database has a couple of tables and 1000 records in the primary
table. It has been well behaved and performing well.
Development record maintenance is taking place locally under Delphi/
dbExpress applications
Hi
Not sure about sites but try searching for 'database normalisation tutorial'
I found
http://www.codelearn.com/rdb/rdbd_nt1_s.html
which looks to be a reasonable start.
Peter
---
Excellence in internet and open source software
Nevermind- I just re-installed mySQL and rebooted. everything works again.
Pierre
Pierre du Parte wrote:
Hi,
We have been using a simple mySQL database successfully for some time.
The database has a couple of tables and 1000 records in the primary
table. It has been well behaved and
- Original Message -
From: Hytham Shehab [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, June 22, 2002 12:15 AM
Subject: Fw: insert BLOB values
- Original Message -
From: Hytham Shehab [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 21, 1999 11:06 PM
For theory and history, I found the manual to be an excellent place to start...
http://www.mysql.com/manual.php
and have a walk through the tutorial starting with:
http://www.mysql.com/doc/C/o/Connecting-disconnecting.html
At 05:05 PM Saturday, 6/22/2002, Timothy J. Luoma wrote -=
I've
TjL,
To start with:
http://www.amazon.com/exec/obidos/ASIN/0764507370/qid=1024783081/sr=8-1/ref=
sr_8_1/104-4398960-1440757
If the title bothers you, take a Sharipe, cross out Dummies and write
Managers, no one will ever know. :)
This book gives an excellent primer in theory and normalization
I haven't tried it, yet, but this looks like an interesting alternative for
a try-before-you-buy method of selecting books:
http://safari.informit.com/mainhom.asp?home
You can subscribe to a list of books monthly and have full access to them
online. If you take a look at this, I would recommend
On Mon, May 27, 2002 at 11:46:44AM +0100, Simon Green wrote:
Re Gunnar Helliesen e-mail
I have FreeBSD4.2 and MySQL 3.23.49.
I two have hi cpu (99%) on a twin cpu system. (Compaq DL380)
After making the suggested changes to my.cnf we rebooted the system.
For 3 days all ran fine (low cpu)
On 22/6/02 at 17:05, [EMAIL PROTECTED] (Timothy J. Luoma) wrote:
I've looked through Google and the MySQL website without luck.
I'm looking to find a place which discusses the theory of how one
should
create a database, how to organize the information, etc.
There's got to be a good
At 06:59 PM 6/22/2002, you wrote:
On Mon, May 27, 2002 at 11:46:44AM +0100, Simon Green wrote:
Re Gunnar Helliesen e-mail
I have FreeBSD4.2 and MySQL 3.23.49.
I two have hi cpu (99%) on a twin cpu system. (Compaq DL380)
After making the suggested changes to my.cnf we rebooted the system.
38 matches
Mail list logo