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 fr
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: <[EM
Running Debian, 2.4.19pre1 kernel, gcc 3.0.4, glib-2.2.2 with linuxthreads and the
mysql-supplied linuxthreads patch.
I'm using the following configure line:
CFLAGS="-O3 -march=pentiumpro" CXX=gcc CXXFLAGS="-O3 -felide-constructors
-fno-exceptions -fno-rtti" ./configure --with-client-ldflags=
Dear people
I have a problem installing under Solaris. I've downloaded a compiled
mysql, installed under /usr/local, create mysql group and mysql user, the
owner of mysql/data is the group mysql and everything looks well. But when I
try:
bin/safe_mysqld --user=mysql
The mysql starts
Hi,
AFAIK, this problem has already been fixed by sinisa. (it was due to an
uninitialized pointer)
([EMAIL PROTECTED], 2002-05-29 21:20:28+03:00, [EMAIL PROTECTED]
A very nasty bug in multi-table deletes & updates
sql/sql_parse.cc
1.228 02/05/29 21:20:27 [EMAIL PROTECTED] +2 -1
A ve
At 16:52 -0700 6/21/02, Cindy wrote:
>Bhavin Vyas writes:
> >Does the error file (hostname.err) have any messages?
>
>OK, I didn't think to look at this:
>020213 14:23:52 mysqld started
>/usr/local/mysql-3.23.47-sun-solaris2.8-sparc/bin/mysqld: ready for
>connections
>020430 17:09:08
>/usr/loc
Bhavin Vyas writes:
>Does the error file (hostname.err) have any messages?
OK, I didn't think to look at this:
020213 14:23:52 mysqld started
/usr/local/mysql-3.23.47-sun-solaris2.8-sparc/bin/mysqld: ready for connections
020430 17:09:08 /usr/local/mysql-3.23.47-sun-solaris2.8-sparc/bin/mysql
Does the error file (hostname.err) have any messages?
Regards,
Bhavin.
- Original Message -
From: "Cindy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 21, 2002 4:34 PM
Subject: here we go again
>
> mysql_st> /usr/local/mysql/bin/mysql -u root -p Text
> Enter password:
mysql_st> /usr/local/mysql/bin/mysql -u root -p Text
Enter password:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
OK. The background is that mysql was started at the end of April
and then not touched since. (not used to access anything, etc).
The hostm
hello,
i'm using mysql 3.23.51-max on windows 98. It worked fine up until the
point where I started using a PHP app that used the command SHOW TABLE
STATUS FROM tablename.
Everytime this is executed Mysql gives me a dialog window that says Test
Signal with an OK button, then I get an illegal op.
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
Linux,
> both tables are InnoD
I just discovered a very scary behavior. We're using MySQL 4.0.1 on Linux,
both tables are InnoDB, AUTO_COMMIT is on (default) and these queries are
being issues from the MySQL interactive console.
If I do a query of the form:
SELECT
transaction_report.*,
confirmed
FROM
transaction_
Can someone tell me what this means? I mean, I guess I *know* what it
means, but why?
The insert statement into a mysql database is...
'insert into works values(?, ?, ?, ?, ? ,?)'
The invocation of the dynamic sql is...
status = cur_mysql.execute(sql,
(wrk_inst, ZERO, trs_inst, a
On Fri, 2002-06-21 at 12:09, Gerald Clark wrote:
> Or better yet,
> add a sleep 2 to the beginning of the init.d program you are starting
> that expects to connect to mysql.
>
> Why slow down the booting for everybody when some other daemon that
> expects to connect to mysql
> can not handle a
Hello.
On Fri 2002-06-21 at 10:47:28 -0400, [EMAIL PROTECTED] wrote:
> On Thursday 20 June 2002 21:15, Benjamin Pflugmann wrote:
>
> > IMHO, the interesting question is: how could the tables get out of
> > sync, in a way that foreign keys would be able to prevent? I am not
> > able to see a way
Michael,
- Original Message -
From: "Michael Bacarella" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
> > SELECT * FROM mytable WHERE mycol = xxx LOCK IN SHARE MODE;
> >
> > or
> >
> > SELECT * FROM mytable WHERE mycol = xxx FOR UPDATE;
> >
> >
> > The
Or better yet,
add a sleep 2 to the beginning of the init.d program you are starting
that expects to connect to mysql.
Why slow down the booting for everybody when some other daemon that
expects to connect to mysql
can not handle a failed connect properly?
Florin Andrei wrote:
>The init.d scr
The init.d script provided with the MySQL RPMs has a problem: if an
application depends on MySQL (say, it's a daemon logging some data in
MySQL), and this application starts right after MySQL, it usually fails.
The reason is, when the init.d/mysql script returs, usually MySQL is not
fully running
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 script. i am connecting as the same us
GlacierWhen trying to transfer a database from MS Access 2000 to MySQL, I
encounter
this error message, "ODBC--call failed. 37000: [Microsoft][ODBC microsoft
Access Driver] Syntax error in CREATE TABLE statement.
I am using MyAccess to do the transfer.
I am new at this in the MySQL area and, am
Thank you very much for your quick and accurate responses.
I tried to dump with the -Q (--quote-names) and it perfectly works.
I'm not completely sure I understood what Tod Harter meant in his mail,
because I set up an 'automated' backup process, and if I would ever need
to recovery our main DB,
Hi,
Mark Hennessy wrote:
> I have decided to use MAX(tablename_index)+1 in advance of inserting the
> record, as I want to use as little dbms-specific magic as possible and
> this matches as close as I can figure the behavior of _seq in mSQL.
>
> I would be doing the following in the same thread
On Fri, Jun 21, 2002 at 12:38:06AM +0300, Heikki Tuuri wrote:
> InnoDB type tables in MySQL have row level locking. Call SET AUTOCOMMIT=0 or
> wrap your transaction in BEGIN ... COMMIT.
>
> Make sure you have an index on column 'mycol' so that InnoDB finds the row
> without a table scan. Then you
Does anyone out there have any experience running a 64 bit mysql server on
solaris? Here's my issue:
I have compiled mysql 3.23.51, with Sun's C compiler from Sun ONE Studio 7
(C compiler version 5.4, one up from Forte 6.2). The compile options were
thus:
setenv CC cc
setenv CXX CC
setenv CFLA
This question is more appropriate for the PHP list.
Here is an example:
// if row exists - login/pass is correct
if (mysql_num_rows($result) == 1)
{
// initiate a session
session_start();
// register the user's ID and permission level
In the last episode (Jun 21), Bill Ferrett said:
> 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 do
I have decided to use MAX(tablename_index)+1 in advance of inserting the
record, as I want to use as little dbms-specific magic as possible and
this matches as close as I can figure the behavior of _seq in mSQL.
I would be doing the following in the same thread in this order:
$id=SELECT MAX(table
On Thursday 20 June 2002 17:50, Cal Evans wrote:
What you want to do is wrap the update in a transaction with transaction
isolation level set to SERALIZABLE. This should insure that whichever client
is first to initiate the transaction will have effectively exclusive access
to the record in qu
> Esp on windows machines this is a good idea, newlines
> there tend to end up being who-knows-what...
It is known exactly what they end up being. Any software that is written
with any sort of vague attempt to be portable and/or actually useful to its
users in a mixed environment, rather than bei
Hi All,
Can anyone help me on how to call up an HTML page in PHP after a succesful
entry, example
I don't want to have to type the HTML code again in between the php code
because the page I need is already at another URL. If anyone knows what I am
talking about please help.
Toks
--
You'll have much less overhead checking with a select
first and then insert if not exists
olinux
--- Sebastian Bergmann <[EMAIL PROTECTED]>
wrote:
> [resent; original posting didn't make it (through
> the spam protection)]
>
> With phpOpenTracker I have for instance the
> following table
>
On Thursday 20 June 2002 21:15, Benjamin Pflugmann wrote:
> IMHO, the interesting question is: how could the tables get out of
> sync, in a way that foreign keys would be able to prevent? I am not
> able to see a way in everyday work (explicitly filling in nonsense
> does not count).
>
> The only
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 auto-increment id to be duplicated - I believe t
Hello
Is a restart/reload or a "flush tables" necessary when creating or removing
databases?
bye,
-christian-
cookie-for-the-robot: sql,query
--
Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0
[EMAIL PROTECTED] Internet & Security for ProfessionalsFax 024
On Friday 21 June 2002 06:55, Arul wrote:
No, but last_insert_id() is only valid until you do another query on the same
database handle. The only explanation I can think of is that somehow you're
code is interjecting some other query between the insert and the call to
last_insert_id(). Maybe a
On Friday 21 June 2002 08:31, Roger Baklund wrote:
> * Podhorski, Adam
use the perl "chomp()" function... It strips off any sort of "newlinish"
trash at the end of the line, then explicitly tack a '\n' onto the end before
you feed it to MySQL. Esp on windows machines this is a good idea, newlin
On Friday 21 June 2002 09:54, Keith C. Ivey wrote:
> On 21 Jun 2002, at 15:43, Stefano Incontri wrote:
> > ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID)
> > ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12
>
> "LOAD" is a reserved word in MySQL, so you need b
toby,
Friday, June 21, 2002, 12:05:26 PM, you wrote:
t> ok guyz somebody was talkin about accessing mysql from a remote machine
t> how the devil do i do that ?
You can connect using mysql command-line client or any GUI for MySQL, f.e.
MyCC:
http://www.mysql.com/downloads/gui-mycc.html
t>
Stefano,
Friday, June 21, 2002, 4:43:29 PM, you wrote:
SI> I found the following problem, which I consider a bug, but maybe I'm missing
something to make it work correctly.
SI> I'm using 'mysqldump' to backup our MySQL DB, and when I try to recover it on a
blank DB it gives syntax errors while
Michael,
Friday, June 21, 2002, 6:17:44 AM, you wrote:
MI> I am currently running MySQL-3.23.51 on RedHat Linux
MI> 7.2 and would like to gradually switch to
MI> MySQL-Max-3.23.51. My question is, would I be able to
MI> install them both if I only run one at a time?
Sure.
You can't use MySQL-
Franco,
Friday, June 21, 2002, 6:03:16 AM, you wrote:
FMG> I'm using mysql-3.23.41 and initially able to use it without any problem.
However, after I issued this command, "grant all privileges on *.* to root@localhost
identified by 'mypassword' with
FMG> grant option; ", mysql will simply dis
Hello
I converted charset from latin1(default) to latin5 and I read INSTALL_SOURCE
If you change character sets after having created any
tables, you will have to run `myisamchk -r -q' on every table
Therefore I run `myisamchk -r -q' on every table
but it still couldn't sorting data correctly
Thanks alot Cal.
-Steve.
-Original Message-
From: Cal Evans [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 9:38 AM
To: Steve Bradwell; [EMAIL PROTECTED]
Subject: RE: Innodb and transactions
Steve,
mysql_query('BEGIN');
if (is_object(mysql_query('Insert something'))){
mysql_q
hi,
i am running mysql-max-log 32.23.50 on Solaris as slave
and mysql-max-log 32.23.51 on linux as a master
i often happend that slave stop because of a grant query it can't execute.
a flush privileges in the slave is enough to make it restart.
does anyone have this problem ??
thanks
Pierr
On 21 Jun 2002, at 15:43, Stefano Incontri wrote:
> ERROR 1064: You have an error in your SQL syntax near 'Load (IL,Item_ID)
> ) TYPE=MyISAM COMMENT='SCM Internal Loads table'' at line 12
"LOAD" is a reserved word in MySQL, so you need backticks around it.
Have you tried using the --quote-name
Dear All,
I found the following problem, which I consider a bug, but maybe I'm missing something
to make it work correctly.
I'm using 'mysqldump' to backup our MySQL DB, and when I try to recover it on a blank
DB it gives syntax errors while creating some table.
This is the Table structure wh
Steve,
mysql_query('BEGIN');
if (is_object(mysql_query('Insert something'))){
mysql_query('COMMIT');
} else {
mysql_query('ROLLBACK');
}
I'm working from memory here. I use the ADODB wrapper and it works a little
different. (Look into it, it's a great piece of code)
HTH,
=C=
-Orig
The manual says:
chown -R mysql.mysql /usr/local/mysql
You did not do that.
Do the same for MySQL's data directory.
Michael Sellers wrote:
>I'm very new to mysql. Just learning. I'm trying to correctly set up the
>permissions for the files under the mysql/ directory. I've included a
>lis
Hi,
I am new user of mysql and I can't post questions to this mailing list.
Even though I subscribed and started getting mailing list emails in my
mailbox. I use outlook with send message type "Plain text", can you
please help me
Whenever I try to send message, I get a bounced email from mailer d
Why are you getting this message, "Access denied for user '@localhost' for
database test2"?
If you are logged on as 'emil' and you attempt to connect, if you are
denied access you should receive a message like this; "Access denied for
user 'emil@localhost' for database test2"
It would appear t
Make sure yours Docs dir hase a Makefile.in.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, June 21, 2002 7:16 AM
To: [EMAIL PROTECTED]
Subject: problem with configure
Hi All,
I am trying to configure the Nusphere mysql (mysql-3.23.49.tar.gz) from i
Hey everybody,
Thank god its friday. =]
Can someone point me to an example of how to do begin rollback commit with
php and mysql Innodb tables?
Thanks for any and all help,
Steve.
-
Before posting, please check:
http://ww
Hi guys,
I want to migrate data from SQL Server 2000 to Mysql.
My problem is to migrate big fields which had type varchar(7900) or so
I tried using Text datatype of mysql, then I cant migrate data in that
field
I used command
LOAD DATA INFILE "c:/mysql/roma/mailmessagetext_table.txt" INTO TABL
Well, not really a problem, I guess... but when I
run a python program that makes use of it I get the
following "message" per row I process...
Freeing pointer out of range at line 663, 'C:\49\libmysql\libmysql.c'
Should I worry? Can I stop this from happening?
Mike
+++-+++---
if i could add to this question a bit:
what are the steps in adding a user that will have access to only one database?
i've tried using both:
GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON uview.* TO user@% IDENTIFIED BY
"password"; (then did a FLUSH PRIVILEGES)
and i've tried adding directl
Well, not really a problem, I guess... but when I
run a python program that makes use of it I get the
following "message" per row I process...
Freeing pointer out of range at line 663, 'C:\49\libmysql\libmysql.c'
Should I worry? Can I stop this from happening?
Mike
+++-+++---
* Podhorski, Adam
> If I don't put the tab before the the end of the line in the txt file that
> contains the data, mySQL does not properly put the data into table using
> LOAD DATA INFILE.
[...]
> But if there is only a \n at the end of the line (e.g.
> 1\tTC446696\tTC27867\n), the data gets corr
Hi All,
I am trying to configure the Nusphere mysql (mysql-3.23.49.tar.gz) from its
source. I am using Redhat 7.2, the configure options are
./configure --prefix=/var/home/mysql --localstatedir=/var/home/mysql/data --
enable-large-files --with-gemini=/var/src/mysql-3.23.49/gemini
At the time of
Hi!
If I don't put the tab before the the end of the line in the txt file that
contains the data, mySQL does not properly put the data into table using
LOAD DATA INFILE.
The courious thing is that this only happens with this one file. I was using
the same commands for all my other files and this
On Thu, 20 Jun 2002, Emma Grant wrote:
> I successfully created and added data to my database!
>
> Does anyone know any good websites where I can learn to insert, update
> data using a web form and CGI?
http://selfaktuell.teamone.de/artikel/cgiperl/index.htm
Text is in German, but you may use
Take a look at "http://www.mysql.com/doc/";. If you search the keyword
union you can get an answer.
Arul wrote:
>Hi
>
> Can i use Unions in MySQL.
> If not could anyone comeout with some alternates..
>
> Regards,
> -Arul
>
>sql,
>
>
>--
* Arul
> Can i use Unions in MySQL.
>From version 4 you can:
http://www.mysql.com/doc/U/N/UNION.html >
> If not could anyone comeout with some alternates..
The normal workaround is to use temporary tables:
create temporary table t1 select ...;
insert into t1 select ...;
select * from t1;
* [EMAIL PROTECTED]
> I like to know the sintax to do a similar select in mysql (this come from
> db2):
>
> select * from tabella where rrn(tablename) > 50 limit 10
>
> the mean is to select ten records from 50 to 60,
>
> any equivalent with mysql ?
mysql does not have the rrn() function, but if
Even the last_insert_id() returns 0
is it coz the table type is INNODB
- Original Message -
From: "Jan Peuker" <[EMAIL PROTECTED]>
To: "Arul" <[EMAIL PROTECTED]>
Sent: Friday, June 21, 2002 4:16 PM
Subject: Re: @@IDENTITY
> You are using M$-Syntax, in MySQL you should use:
> SELECT las
Hi
Can i use Unions in MySQL.
If not could anyone comeout with some alternates..
Regards,
-Arul
sql,
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hello,
I like to know the sintax to do a similar select in mysql (this come from
db2):
select * from tabella where rrn(tablename) > 50 limit 10
the mean is to select ten records from 50 to 60,
any equivalent with mysql ?
TNX !
Hi
I m using mysql 3.23.51 on win 2k
Well..I have a user table where i have the userid column as primary key and
auto_increment column and name as varchar(25).
I insert values in the table such as
Insert into user (name) values ('AA');
Then When i do select @@Identity in the next time , it
Remote access for mysql database can be done with this tool:
http://www.anse.de/mysqlfront/
Its free, reasonably reliable and pretty easy to use (also for making dumps)
my.ini is found under /WINNT directory
my.cnf is found under the root dir (prolly C:\ for you)
=> this file is not obligated to
ok guyz somebody was talkin about accessing mysql from a remote machine
how the devil do i do that ?
the problem is :
1.i have mysql on my work machine ... not at my home
& i dont wanna have to go thru all the trouble of download and config and
all
2. i couldnt locate my.ini or my.cnf
wha
Hello Terry,
Thursday, June 20, 2002, 5:14:40 PM, you wrote:
DT> Egor,
DT> I hope I understand you work for MySQL in some fashion, is there any plan to
DT> allow sub-selects in future releases ?
Yes, multi-table updates and sub-selects is on development and they
will come in version 4.1
DT> RSV
The Makefile of mysql server says about linuxthreads:
@${ECHO} " WITH_LINUXTHREADS=yes Use the linuxthreads pthread
library."
@${ECHO} " This is _NOT_ recommended
for production"
@${ECHO} " servers. Expect pr
Hi David,
On Fri, Jun 21, 2002 at 03:59:33AM -0400, david wrote:
> Well i seem to have gotten MySql working but i can't seem to use mysqladmin:
> to do anything. When i start MySql with the following:
>
> [root@RR davidwri]# safe_mysqld -u root
> Starting mysqld daemon with databases from /var/
On Fri, 21 Jun 2002 09:51:35 +0200
Giuseppe Careri <[EMAIL PROTECTED]> wrote:
> Hi,
>
> 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
On Fri, 21 Jun 2002 03:59:33 -0400
david <[EMAIL PROTECTED]> wrote:
> [root@RR davidwri]# mysqladmin version
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user: 'root@localhost' (Using password: NO)'
> [root@RR davidwri]# mysql -u root -p mysql
> Enter passwo
On Fri, 21 Jun 2002 14:36:28 +0700
"ihwan" <[EMAIL PROTECTED]> wrote:
> Dear All,
>
> I have a trouble with my database using mysql.
> The problem is one of the table can not increase new record.
> and I can not add new data to that table.
> The last row is no. 226428
> I don't use number fiel
Well i seem to have gotten MySql working but i can't seem to use mysqladmin:
to do anything. When i start MySql with the following:
[root@RR davidwri]# safe_mysqld -u root
Starting mysqld daemon with databases from /var/lib/mysql
it will sit indefinitely as above, is this correct?
If i try to
Hi,
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 "mysqldump" or a "select" or "alter table drop index.." the
Dear All,
I have a trouble with my database using mysql.
The problem is one of the table can not increase new record.
and I can not add new data to that table.
The last row is no. 226428
I don't use number field type for identity or auto_increment
.
Does anyone know why this trouble can occurs
78 matches
Mail list logo
