Hi Everyone,
Many of you suggested that, in regards to my problem with LOAD DATA
[LOCAL] INFILE ... , I may have permissions problems. I checked with
the host and the reply was, "You have access to do all commands except
for the "grant" command." So it would appear that I SHOULD be able to
load
Hi All
I keep getting a problem with our MySQL database, I know what error 127 is
('Record-file is crashed / Network is down'), it keeps occuring on several
tables that are frequently accessed by our website.
I can fix the problem by running OPTIMIZE TABLE on the offending tables but
it seems to
THe PHP's prob still on the test database.
You can try mysql_select_db("databasename"); before you're query.
- Original Message -
From: "Cliff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, August 10, 2002 2:07 AM
Subject: Re: can't use the table. What happen, please!!
Can anyone recommend a Web-based report writer that works with MySQL?
Other conditions:
- free or low cost (we're a 501c3 nonprofit)
- basic: no need for charts or graphics -- something formatted in columns
and can be exported for Excel would be great. They'll be used internally
only -- not for
That is a problem with a php script you are running, it is not passing the
expected data as an argument.
- Original Message -
From: "Sandra" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 09, 2002 4:41 PM
Subject: can't use the table. What happen, please!!
> Hi
I'm running OS X anad have just installed mySQL 3.23. I can log in and
modify tebles but anytime I try to create a new database I get error 13.
If I go to the information for my hard drive since the install I have no
write access, only read access to my hard drive. I can however, access and
mod
Hi,
how can I lock only one row in the table?
What table type I have to use to lock?
Regards
Alexander
sql, query
___
Yahoo! PageBuilder
O super editor para criação de sites: é grátis, fácil e rápido.
http://br.geocities
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Joe Shear" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, August 09, 2002 5:27 PM
Subject: Re: InnoDB Locking Problems
> On Fri, Aug 09, 2002 at 02:38:03PM -0700, Joe Shear wrote:
>
> [snip]
>
> > COMMIT
> >
Im not sure I understand what it is that you are trying to do here??? Im
assuming your using PERL/SomeScriptingLang on something on NT to connect to
mysql using the ADO object... Within your Count(*) Group by are you trying
to return a result set that contains a duplicate row count, i.e.
Column=
On Fri, Aug 09, 2002 at 04:04:10PM -0500, Dan Nelson wrote:
>
> A coredump of this state + gdb "thread apply all bt" might be interesting.
>
> > > Hmm. Looks like a problem we solve recently, but yours is a bit
> > > different. We found that FreeBSD's not-so-thread-safe
> > > gethostbyname_r()
yes, we are running at serializable, which also explains the locking
problems, especially since we just upgraded from .49.
thanks
joe
On Fri, 2002-08-09 at 15:27, Jeremy Zawodny wrote:
> On Fri, Aug 09, 2002 at 02:38:03PM -0700, Joe Shear wrote:
>
> [snip]
>
> > COMMIT
> > we are using the high
Hi all,
I am getting the error when trying to connect server from my client:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
resource in .
I had my tables in test database, but created a new database and passed my
tables to there. Since then I receive that message
On Fri, Aug 09, 2002 at 02:38:03PM -0700, Joe Shear wrote:
[snip]
> COMMIT
> we are using the highest level of transactional security -- the term for
> it eludes me at the moment.
You mean the isolation level? Are you running at SERIALIZABLE rather
than READ-COMMITTED? IF so, why? You will h
Evening
I think I'm losing my mind. I have a very simple query that works fine in
MySQLFront but will not work when I connect using ADO:
select booger, count(*) from nose group by booger
If I try the above query with one record It works fine. Once I try it with
more records, nothing returns.
I
I'm using mysql 3.23.51 w/ InnoDB tables, and am running into some
locking issues which I don't believe should occur. There are 2
transactions that seem to interfere with each other. The first
transaction is an update of one table followed by a select of another
table, ie:
BEGIN
UPDATE table1 se
Hello,
I am using mysql-3.23.39
I just got replication running between a Master and Slave. I read about
log-slave-updates and chaining slaves together:
A -> B -> C -> A
Does this mean that if I add info to slave 'B' then slave 'A' is also
updated? If so, how does the master get updated?
I r
In the last episode (Aug 09), David Miller said:
> On Sun, 4 Aug 2002, Jeremy Zawodny wrote:
> > On Sat, Aug 03, 2002 at 11:59:56PM -0400, [EMAIL PROTECTED] wrote:
>
> I didn't think my server would be doing any name resolution,
> particularly while replace()ing millions of rows in a table. That
Eduardo,
Thanks for the reply, but I still get only one record for prj1. While prj2
does not show up with 0 hours.
CREATE TABLE PROJECT (
ID_PROJECT int(11) NOT NULL auto_increment,
NM_PROJECT varchar(255) NOT NULL default ''
PRIMARY KEY (ID_PROJECT)
) TYPE=MyISAM;
INSERT INTO PROJECT
Bonjour,
Vous avez récemment demandé à vous inscrire au groupe
mysql-france. Comme vous êtes déjà membre de ce groupe,
votre demande ne sera pas prise en compte.
Pour toute question sur l'envoi de messages à ce groupe,
veuillez envoyer un e-mail à [EMAIL PROTECTED]
Cordialement,
L'équipe
On Sun, 4 Aug 2002, Jeremy Zawodny wrote:
Hi Jeremy;
I didn't think my server would be doing any name resolution, particularly
while replace()ing millions of rows in a table. That said,
--skip-name-resolve *seems* to have helped. It's definately still
failing, and the ktrace is the same, so it
Hi,
I am relatively new to MySQL.. I am having trouble getting an aggregate
function and an outer join to work together.
I have two tables
PROJECT (id_project, nm_project)
100, prj1
101, prj2
DAYLOG (id_project, date, hours)
100, 2002-08-17, 8
100, 2002-08-18, 8
DAYLOG table contains numbe
I have a managed dedicated server that was recently upgraded to MySQL
version
3.23.51 in order to take advantage of transaction processing. However, when
my script tries to turn off auto-commit, I receive this message...
"Transactions not supported by database". Are there any configuration
setting
My phpBB forums, say if i make a post, then it goes to the post, but
nothings there, so i have to go to index.php for it to show (and it will log
me out) is this a bug in 4.0.1 im pretty sure its mysql..usually it
would show the posta nd if i chnaged something (ex. colors) i would have
On Fri, Aug 09, 2002 at 09:21:13PM +0200, Thomas Seifert wrote:
> On Thu, 8 Aug 2002 03:02:40 -0700
> Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
>
> > Excellent. MySQL 4.0.{2,3} is working well for us too.
>
> Is there 4.0.3 already somewhere to download?
Not yet. I believe there will be a 4.0
On Thu, 8 Aug 2002 03:02:40 -0700
Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> > btw:
> > I did a quick benchmark with mysql4 and its query caching running with
> > innodb.
> > Quite impressive, the app run with double the number of pages per second as
> > before.
>
> Excellent. MySQL 4.0.{2,3}
On Fri, Aug 09, 2002 at 10:36:09AM -0700, Steven Roussey wrote:
> I can't look up a MySQL 4.0.2 crash since the mysqld.sym.gz is empty!
> Can someone at MySQL email me the file, please. Pretty please. Thanks!
Ugh, that happened with 3.23.49 too, I think. :-(
Jeremy
--
Jeremy D. Zawodny |
It depends on your needs. ENCRYPT, MD5, SHA1 are all hash functions,
which means they are one-way and the SSN can't be recovered. This means
that you can't read their SSN back once they give it to you, you can
only compare something they give you and see if it is the same as the
SSN. This is ho
>Description:
I needed more than 15 joins for one statement so I changed table_map type
to ulonglong. First everything worked fine for 3-5 hours. But later some
left joins sttopped working. With one particular table.
Since this is not an official way to go this may be considered not a bug.
But it
At 10:53 -0700 8/9/02, Steven Roussey wrote:
>Is there a way to not have mysql put fulltext searches in the slow query
>log?
Not FULLTEXT queries specifically. You can bump up long_query_time, but
that applies to all queries.
>
>Sincerely,
>Steven Roussey
>http://Network54.com/?pp=e
-
This bug is found using Java and the MM.MySQL driver, but I do not think it
is actually caused by the JDBC driver but rather comes from the MySQL
daemon. However, I am sending to both lists in case it is a driver problem.
The Last Insert ID can, of course, be retrieved by executing the query
SEL
>Description:
I'm running MySQL-3.23.51 stable RPMS on the master for a replicated database here.
It is processing a large quantity (9,000,000 rows/table/day) of usage records in a
pretty much constant flow of inserts.
The raw usage tables consume roughly 400MB/table/day in .MYD and about the sa
OK IT WORKED FINE :)) !!!
I am finally going to be able to work correctly :))
Here is a log of what i did to test :
mysql> create database fam2
-> ;
Query OK, 1 row affected (0.00 sec)
mysql> use fam2
Database changed
mysql> create table CREATE TABLE parent (id INT NOT NULL, nom CHAR(10)
Is there a way to not have mysql put fulltext searches in the slow query
log?
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://l
select * from forms_data_recs
where fdr_form_id='37' and ( fdr_ff_id ='190' and ( fdr_value like
'%keith%' ))
OR ( fdr_ff_id = '192' and (fdr_value like '%public%' ))
order by fdr_date,fdr_id
-Original Message-
From: Keith Clay [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 09, 2002 1
OK thanks a lot for your help ! :)
I just downloaded the latest version ( 4.0.2) and installed it .
I hoped I could keep the settings of my ini file ( my.ini) but I got the
following error when trying to start in standalone console :
Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 19
Here is my table on which I am doing sql query:
++--+-+---+--+-+
| fdr_id | fdr_uid | fdr_form_id | fdr_ff_id | fdr_value
| fdr_date|
++--+-+
I can't look up a MySQL 4.0.2 crash since the mysqld.sym.gz is empty!
Can someone at MySQL email me the file, please. Pretty please. Thanks!
Sincerely,
Steven Roussey
http://Network54.com/?pp=e
query
-
Before posting, pleas
Hi,
when I visit my php pages they give an error:
Warning: MySQL connection Failed: Can't connect to local MySQL server
trhough socket /var/lib/mysql/mysql.sock (111) in /var/www/html/index.php
the file 'mysql.sock is in the right dir (/var/lib/mysql/)
Someone told me that Apache don't get a
Hi,
I'm using a program that makes many mysql connections. Now sometimes it
leaves a hung mysql process. When I run mysqladmin processlist, the
process looks like this.
(used my own formatting)
pid,user,host,db,command,time,state,info
28285,sqluserna
hi all,
I was trying to upgrade mysql from 3.22.21 to 3.23.51 on my RaQ2 system.
after removing the older version when I trid to install this new version
(rpm pkgs) I got the follwoing error. anyone has any idea or can pelase
tell me what should I do at this point. thanks in advance.
rahad
[ro
where can I find a mysql 3.23.51 to download for MIPS architecture???
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
sql, query
[EMAIL PROTECTED] wrote:
> 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
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and include the e
hi all,
I was trying to upgrade mysql from 3.22.21 to 3.23.51 on my RaQ2 system.
after removing the older version when I trid to install this new version
(rpm pkgs) I got the follwoing error. anyone has any idea or can pelase
tell me what should I do at this point. thanks in advance.
rahad
[root
I need to store SSN's in a MySQL DB. I see a variety of encyption functions:
ENCRYPT(), MD5(), SHA1(), DES_ENCRYPT() and have read the basiscs of how they
work. Is there are "standard way" of storing SSN's in MySQL.
thanks,
John
> I read on the mysql website about a voting algorithm
> for mysql to automtically switch one of the slave
> servers to master in the event something happens to
> the original master server. Can anyone tell me where
> I can find the documentation on how to set this up.
> Thank you.
Unfortunate
I have a program with several quries that join 3 tables
the one that isproblematic has is as follows:
adminhierarchy has 4.5 million records
admincoverage has 1.5 million records
adminproducer has quite a few (i cant remember right now)
I am trying to select off 3 years worth of data , curren
Hii Sinisa,
I have already writen
--default-character-set=..
sorry about that i just wrote it wrongly in my
message.
If i write
mysqld --default-character-set Latin5
it gives the error message:
"Character set Latin5 is not an compiled character
set, and is not speci
Try this:
Use mysql tables, change or add record in user table.
If you add password (and you must) use
password('password'). Then flush-previleges from
mysqladmin.
Also, you must change host and db tables.
Go to www.devshed.com and read "access granted"
article.
Cheers
--- Marius Pana <[EMAIL P
You must create an extra field in your database to
store the domain.
Use the explode() to seperate the domain from ...@
(array explode (string separator, string string [, int
limit])
Returns an array of strings, each of which is a
substring of string formed by splitting it on
boundaries
formed by
Hello,
I have the following values in my db table:
Id. regdate
001040-1467
011910-2002
021700-1789
031550-2002
041600-1700
051900-2000
...
How can I use mysql RegEx to the query parameter: 1445-1600: That is to
extract those values t
DO NOT run myisamchk while the server is running.
lorenzo.kh wrote:
>Hi,
>I am using mysql 4.0.0-aplha on win 2000 professional.
>I install mysql in c:\mysql.
>I write a script ( customerscript.txt) and i save this script in
>c:\mysql\bin.
>The contents of customerscript.txt I will paste at the
Hi,
I read on the mysql website about a voting algorithm
for mysql to automtically switch one of the slave
servers to master in the event something happens to
the original master server. Can anyone tell me where
I can find the documentation on how to set this up.
Thank you.
Zach.
L.s.,
I think I have found a bug in the OLEDB driver for MySQL, it was caused
under 3.23 stable release.
I Use Win2000 Professional Englisch Version of Operating Systems, and do
developping using Delphi 5.02 Enterprise.
If I use Textfields or Blobs, the OLEDB Drivers says if I try to open a
cer
Jim,
Friday, August 09, 2002, 7:21:48 AM, you wrote:
JB> At the prompt mysql> I type a command : SOURCE SCRIPTS\MT_INV_TBL.TXT.
JB> The command returns the following error message:
JB> Failed to open file [FileName] Error 2.
JB> So what is this error 2. What does it mean?
$ perror 2
Error code
Florian,
Friday, August 09, 2002, 1:00:38 PM, you wrote:
FL> What is the difference between myslq and mysqlmax?
Do you mean "mysqld"?
mysqld is a SQL daemon, MySQL server.
mysqld-max is a MySQL server that configured with options:
--with-innodb, --with-bdb, --with-server-suffix=-max and CFLAGS=
Kevin,
Thursday, August 08, 2002, 7:41:30 PM, you wrote:
KB> I have access to the database files themselves from a linux
KB> installation of mysql, but not the root login priveleges under mysql
KB> itself. I know that if I could connect via mysql itself I could just
KB> copy the databases from o
Hi
I am about to either create my own installer for MySQL or use the
allready made one.
Reason is that I would like to have an unattended installation of the
database, which can be sent as an SMS package (MSI).
I need to know the following;
1) What is the bare minimum to include for an inst
If I insert a number, say X, of records using a single statement of the
form
INSERT INTO table VALUES (...), (...), ..., (...)
then retrieve the LAST_INSERT_ID, say Y, is it reasonable to assume that
the records will be numbered contiguously from Y-X+1 to Y, even in a
multi-user environment?
Hi
What is the difference between myslq and mysqlmax?
Thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-ma
Hi!
On Aug 08, Dan Nelson wrote:
> In the last episode (Aug 08), Christopher Book said:
> > Using mysql 4.0.2 I get the following behaviour (phrase searching):
> >
> > match (field) against ('"pack of"' in boolean mode)
> >
> > gives me all results with 'pack of', not just 'pack'. So MySQL
> What will happen on Error code 28: No space left on device? Will
mysql
> crash down?... Will there be posibility of reading data from tables?
I saw this error on one of my servers not too long ago. MySQL keeps
running but seemingly refuses to do SELECTs on any tables. Upon freeing
some spac
61 matches
Mail list logo
