Re: replacing field contents?

[Wolfram Kraus]

Heyho!
Robin Lynn Frank wrote:
I hope this question doesn't sound too dumb, but since I can't afford
to screw it up...
I have a table with 98,000 records.  I want to globally replace the 
content of one field where the content is

XXX diverse_text
with
XXX non-diverse_new_text
In other words, if the content of the field starts XXX, I want it
 replaced with XXX with only the new text following.
Use update:
UPDATE your_tbl SET the_field = 'XXX non-diverse_new_text'
WHERE the_field = 'XXX%'
http://dev.mysql.com/doc/mysql/en/String_functions.html
Beware! Make a backup of your database before you try this! (NB: Don't 
believe everything you read untested)


TIA
-- Robin Lynn Frank - Director of Operations - Paradigm-Omega, LLC 
HTH,
Wolfram
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: GRANT can't grant with a password?

[Joshua J. Kugler]

Right, I understand that, but then *why* can a user create another user, with 
all the priveleges they have, but with now password.  That seems like a great 
security hole.  It seems that the GRANT syntax should allow the setting of a 
password upon account creation without requiring access to the mysql db.

j- k-


On Saturday 08 January 2005 05:55, Gleb Paharenko said something like:
> Hello.
>
> As said at:
>
>   http://dev.mysql.com/doc/mysql/en/SET_PASSWORD.html
>
> Only clients with access to mysql database can set passwords for
> other accounts.
>
> "Joshua J. Kugler" <[EMAIL PROTECTED]> wrote:
> > I've read the sections on GRANT's and permissions, and done some
> > googling, and
> >
> > still haven't found what I'm looking for.
> >
> > I have a user that has USAGE and GRANT global privs and all privs and
> > GRANT on database rubric.
> >
> > However, when they try to run this query:
> >
> > GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON rubric.* TO
> > 'user'@'localhost' IDENTIFIED BY 'password';
> >
> > They get the error
> >
> > ERROR 1044: Access denied for user 'user'@'host' to database 'mysql'
> >
> > They can log in just fine, so it is not a matter of host name.
> >
> > I found a post that seemed to allude to the fact that a user with GRANT
> > could
> >
> > only create a new user via GRANT if there was not IDENTIFIED BY clause.
> >
> > (However, a user with write permissions to the mysql database could).  I
> >
> > verified this to be the case when this query,
> >
> > GRANT SELECT, INSERT, UPDATE, DELETE, CREATE ON rubric.* TO
> > 'user'@'localhost'
> >
> > run as the user in question, worked and created the user, albeit with no
> >
> > password.
> >
> > Is there a way for a user with GRANT privs to create a user *with* a
> > password?
-- 
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under 
the earth, that Jesus Christ is LORD -- Count on it!

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Root user

[Philippe Cabet]

Good morning,

I'm working on Windows XP Professional and I'm using EasyPHP1-7 with Apache
1.3.27, PHP 4.3.3, PHPmyAdmin 2.5.3, MySql 4.0.15.

1 - I must start up Easy PHP with [EMAIL PROTECTED] If I try to work with
other users by the user parameter in config.inc.php, PHPmyAdmin doesn't
work.

2 - I switch off the Grant option to the ROOT user with EasyPHP and now I
can't reset ON the Grant option to ROOT user even if I use the procedure
(Stop mysql services and enter mysqld-nt command and so on, in fact the
mysqld works but not mysqld-nt..) or by the GRANT SQL command.

Could you explain to me how can I do it?

Thank you.   

 

Philippe Cabet

Tél : 06 60 12 01 01 

free graphing tool for perl and mysql

[N. Kavithashree]

hello,
thank you for info.
but i want one graphics tool which is free.
i m using perl and mysql.
i am also searching for the graphics tool which i can use for the data in
mysql table or the output by my perl program.
if anyoneknow abt this please do reply

Kavitha
===
-- Forwarded message --
Date: Tue, 11 Jan 2005 11:44:34 +1100
From: Daniel Kasak <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED], mysql@lists.mysql.com
Subject: Re: Generic graphing tool?
Jason Martin wrote:
Does anyone know of a web-based tool that will let you graph
arbitrary data out of of MySQL? I'm thinking of something that
lets you define a select statement, some graph options and
produce a graph.

JPGraph produces some *very* nice graphs from PHP.
There are some graphing modules around for Perl, but I don't think
there's anything as nice as JPGraph. If there is, I'd like to know about
it :)
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
-- 

MySQL General Mailing List

For list archives: http://lists.mysql.com/mysql

To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

JDBC driver support

[Manish]

We're having some problems in getting MySQL 4.1.8 to work with JDBC drivers
in -
mysql-connector-java-2.0.14-bin.jar

Do these drivers work with MySQL 4.1.8? hey seem to be working fine with
4.0.14 version of MySQL.
Is there any compatibility data available for all these JDBC drivers and
MySQL version.

- Manish



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Quick query for multiple fields?

[Tom Crimmins]

[snip]
I have a table with about 50 fields in it, I want to copy certain records
into another identical table...

i.e
INSERT INTO mail_inbox (userid, subject, message, blah blah) (Select
userid, subject, message, blah blah... from mail_inboxold where userid = 10)

Is there an easy way to do this without having to write all the field names 
out?
[/snip]

If the columns are in the same order you can use the following:

INSERT INTO mail_inbox (SELECT * FROM mail_inboxold WHERE userid=10); 

---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Fulltext search question

[Tom Crimmins]

[snip]
Given a search string of 'NA&SD' my default Fulltext search doesn't find it.
Wondered why?
[/snip]

Quote from http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html:

"MySQL uses a very simple parser to split text into words. A "word" is any
sequence of true word characters (letters, digits, and underscores),
optionally separated by no more than one sequential `'` character."

---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to connect to MySQL with an ecripted password.

[Jason Martin]

On Mon, Jan 10, 2005 at 11:44:48AM -0800, Eduardo Castro wrote:
> Is there a way to encript the password in the text file?  Or anothe way 
> to connect to my sql with an encripted password?
Any authentication token you store in a text file will be just
as useful as an unencrypted password, since once known it can be
used in another script.  You should concentrate on protecting
that file.

-Jason Martin
-- 
Any philosophy that can be put in a nutshell belongs there
This message is PGP/MIME signed.


pgpvmpfpEhT4g.pgp
Description: PGP signature

Re: does anyone know of a utility that will processes the query log to rerun the queries?

[Daniel Kasak]

Daniel Gaddis wrote:
does anyone know of a utility that will processes the query log to rerun
the queries?
The program would need to...
...strip the leading non query info from the line
...handle queries that span multiple lines
...change databases when appropriate before queries
...add the ; to the end of the query
an option to only reprocess unique queries might also be nice.
has anyone already done this?
 

Yes. The mysql client is good for this.
I used to restore from disasters this way, eg:
- full backup every night
- transaction log ( the text one, not the binary one ) gets reset each 
night by restarting mysql after the backup

Then when our disaster happened, we'd drop all databases, import from 
last night's backups, and then run the transaction log:

mysql < /path/to/transaction/log -p
Unfortunately this becomes a little more complicated if you use 
temporary tables ... especially if you're updating the DB from the 
contents of the temporary tables, as the recovery process will run as 1 
user instead of all the original users that ran it to start with. I 
believe the binary transaction log is good in this case, but I haven't 
bothered to check up on how to use it yet.

But if you don't create temporary tables, then the above 1-liner should do.
Dan
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

BUG on SELECT

[Federico J. Fernandez]

Hi,
i'm using mysql-alpha ver 5.0.2.
while i was using a cgi script, i discovered that SELECT querys using 
DISTINCT and a duplicated field crashes mySQL server.

i.e.
SELECT DISTINCT id, id FROM table;
aparently, it does not happen with all the tables, but more than 50%
where could i report the bug? i know i'm using an alpha ver, but i want 
to reach the developers.

thanks
ps: excuse me for my bad english.
--

Federico Javier Fernandez [EMAIL PROTECTED]

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Stored Procedure for advance reporting

[Peter Brawley]

From 5.0.1 you can write database-specific stored procs but the 
language is SQL not Perl, see 
http://dev.mysql.com/doc/mysql/en/Stored_Procedures.html.

PB
sam wrote:
Hi,
Can anyone tell me where I can download examples for creating Stored 
Procedure in perl DBI?
It seems that I can't create advance reporting with basic operations 
(select, create) in perl dbi, so I m looking for whether Stored Proc 
in MySQL can solve my problem.

Thanks
Sam

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Hello!

[James Cass]

Sabeer-
Welcome to the list!  I'm pretty much a lurker here, but I have learned 
a lot.  You've come to the right place to get your MySQL questions 
answered.

Good luck!
- James
On Jan 10, 2005, at 2:06 PM, sanoj zubair wrote:
Hey, This is sabeer. Newly joined to this Group.
Hope I ll enjoy my best Here.
Sabeer MZ

__
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Hello!

[James Cass]

Sabeer-
Welcome to the list!  I'm pretty much a lurker here, but I have learned 
a lot.  You've come to the right place to get your MySQL questions 
answered.

Good luck!
- James
On Jan 10, 2005, at 2:06 PM, sanoj zubair wrote:
Hey, This is sabeer. Newly joined to this Group.
Hope I ll enjoy my best Here.
Sabeer MZ

__
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
http://info.mail.yahoo.com/mail_250
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: The table '#sql_6d1b_0' is full during multitable UPDATE

[Gleb Paharenko]

Hello.



You may use some recommendations from:

  http://dev.mysql.com/doc/mysql/en/Full_table.html





"Jocelyn Fournier" <[EMAIL PROTECTED]> wrote:

> Hi,

> 

> I've just encountered a strange problem when trying to update a table :

> 

> UPDATE searchmainhardwarefr0, searchjoinhardwarefr0 SET

> searchmainhardwarefr0.numeropost=searchjoinhardwarefr0.topic WHERE

> searchmainhardwarefr0.numreponse=searchjoinhardwarefr0.numreponse;

> ERROR 1114 (HY000): The table '#sql_11be_0' is full

> 

> searchjoinhardwarefr0 contains only 70624 rows, and searchmainhardwarefr0

> contains 946113 rows.

> 

> However I succeed in updating the table with the following query :

> 

> UPDATE searchmainhardwarefr0, threadhardwarefr0 SET

> searchmainhardwarefr0.numeropost=threadhardwarefr0.numeropost WHERE

> searchmainhardwarefr0.numreponse=threadhardwarefr0.numreponse;

> 

> threadhardwarefr0 contains 76291 ans is also larger on the disk.

> 

> This sounds like a bug for me, but I want to be sure I didn't miss anything.

> 

> I'm using MySQL-4.1.8

> 

> Thanks,

>  Jocelyn

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ALTER TABLE....with CHANGE syntax

[Karam Chand]

Hello,

I plan to reorder some columns of my table. So I am
using ALTER TABLE STATEMENT .. with CHANGE syntax as
suggested at:

http://dev.mysql.com/doc/mysql/en/ALTER_TABLE_problems.html

I believe its the only way to reorder columns? Is
there something better?

If CHANGE is the best option, is there any version
restriction for the statement or it works with all
versions of MySQL?

Currently I am using MySQL 4.1 where it works great
but my host is still running 3.23.58 :(

Regards,
Karam

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql on OS X

[Scott Wilson]

Hi Bruce,  

Thanks for the advice.  I'm glad to hear you have so many of these
machines successfully in production!  Our machines are currently
fitted out with 2Gig of RAM each so I won't face the process memory
limit right away.  That's actually more than enough to fit all our
keys in memory anyway.

We're definitely using the query cache heavily and finding it makes a
big difference.  Just ran accross a bug recently that was causing a
lot of locking contention on one of that tables and blowing the cache
for that table.  The result was not pretty!

There isn't anything else actively running on the machine, but still
lots of the stock stuff running (print services, display etc..) that
I'd like to figure out how to disable.

I'm currently doing some benchmarks on the db under innodb - we've
been running with myisam until this point.   I was intending to
investigate converting some of the tables to innodb anyway as the
read/write ratio on them is sliding from the ideal for myisam.

It sounds in general that our db is smaller and the access more cpu
intensive than yours.  Lot's of optimization left for us to do in that
direction.

Hope they release 10.4 in time for you! 

thanks!

 scott

On Thu, 06 Jan 2005 17:45:52 -0800, Bruce Dembecki <[EMAIL PROTECTED]> wrote:
> Hi Scott! We use MySQL on 9 Mac OS X machines. While we are looking at
> moving some of that back to big Sun boxes, that's a memory access/64 bit
> issue, not (directly) a performance issue.
> 
> Looking at the live stats one of the machines has an uptime of 55 days and
> has averaged 405.78 queries per second across the whole time (that¹s about
> 35M queries per day) - we run 8 in production, and one admin server which
> replicates from everyone and does our backups and feeds the reports servers
> and so on, not all 8 production machines are running this busy, but it gives
> you an idea of our traffic and throughput.
> 
> In our experience the key here is configuration. Overall for our use
> (discussion boards) we find InnoDB tables are dramatically faster for us
> than MyISAM. The key thing will be setting your memory settings in my.cnf to
> be as generous as possible. Query Cache is great for us, typically we see
> about 30% of our SELECT queries going through query cache, so that¹s
> definitely worth turning on.
> 
> Does the machine do anything else or is it just serving MySQL? How much
> memory does it have?
> 
> my-huge.cnf in actual fact isn't that generous. Typically my-huge would take
> about 500M of ram, maybe a gig if you have LOTS of connections set. Works OK
> if you are running a machine that needs power for other things, such as
> running Apache and PHP and MySQL all in one box... But if your mysql box is
> just serving mysql and nothing else, you need to tune the machine as much as
> possible for mysql. Turn off system processes and options not really needed
> for running a database. And tune up that memory
> 
> Due to memory limits on the Mac OS X quasi 64 bit emulation it is possible
> for the Operating System to access more than 2Gbytes of ram, but not
> possible for any process to do so (including, sort of) mysqld. The trick
> here is that innodb grabs it's own chunk of memory, so in actual fact we can
> get nearly 4Gbytes of memory allocated to MySQL on OS X...  Settings of note
> here (if you are into InnoDB) are:
> 
> key_buffer_size=1024M
> sort_buffer_size=4M
> read_buffer_size=4M
> read_rnd_buffer_size=8M
> myisam_sort_buffer_size=64M
> query_cache_size=128M
> innodb_buffer_pool_size=1850M
> innodb_additional_mem_pool_size=256M
> innodb_flush_log_at_trx_commit=0
> 
> This last one improved performance for us under InnoDB dramatically.
> We have a lot of connections, so the read buffers and so on are multiplied
> by the number of connections... If you are only using MyISAM and don't have
> so many connections in max_connections you can probably increase
> key_buffer_size to closer to 1500 or so...
> 
> The query cache you should increase and monitor (using "SHOW STATUS LIKE
> 'Qcache_%';") and when your server has been running more than 48 hours and
> Qcache_free_memory is still giving you a comfortable overhead you can be
> happy with it... If there's not much left in Qcache_free_memory, increase it
> and try again. Total memory available under OSX with no InnoDB is 2Gbytes...
> So add up your key_buffer and the myisam_sort_buffer and the query_cache and
> thesort/read buffers multiplied by the number of connections and you get to
> where you can get to. Of course if your server has 2Gbytes or less you need
> to reduce this somewhat to leave room fro the OS to run and stay within the
> available memory of the machine.
> 
> We are trying now to determine if we can wait with OS X for their true 64
> bit operating system due sometime in the first 6 months of 2005 (which we
> have to assume is June) or if our new database server budget should go to
> Sun boxes which give us real 64 bit now, and thus let us throw a whol

does anyone know of a utility that will processes the query log to rerun the queries?

[Daniel Gaddis]

does anyone know of a utility that will processes the query log to rerun
the queries?

The program would need to...

...strip the leading non query info from the line
...handle queries that span multiple lines
...change databases when appropriate before queries
...add the ; to the end of the query

an option to only reprocess unique queries might also be nice.

has anyone already done this?

daniel


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Question on data access object

[Koon Yue Lam]

Hi, is it is not the place to discuss DAO, ignore me and sorry  ^^

but I have a question about DAO, I write my DAO and include all
function that to select / insert / update / delete record from
database. Therefore all interaction between database and the outside
world are by DAO. No direct access is allowed.

The question is I need to define the sql statement in my Java source
code, which is something like :

private final String sql = "select * from table";

which, if the sql is very long, I need to split it up into a few
lines. Thus make the code very dirty and not easy to understand.

Is there any solution to define constant sql statement in a better and
manageable way ?

Any help would be appreciated

Thanks

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: mysql on OS X

[Scott Wilson]

Hi Brent,   thanks for your comments!  An unbiased outside pov always helps!

On Thu, 6 Jan 2005 14:32:16 -0500, Brent Baisley <[EMAIL PROTECTED]> wrote:
> While part of the problem may be OS X, Apple is still optimizing parts
> of the OS, I would say the "problem" is that you are comparing it to an
> aging PIII. Some people have gotten better performance from a PIII than
> a P4. The reason is cache. The PIII has a larger cache, MySQL loves
> cache. The G5 XServe have a comparatively small cache (512k L2, 1MB L3
> I think). If you have a G4 XServe around, I would try that. You may get
> better performance. The G4 XServe came with 2MB L3 cache. Your best
> hardware may actually be Intel's Extreme Edition CPU (4MB cache)
> designed for gaming. Although I haven't seen any benchmarks, just my
> speculation.

Actually the G5 has no L3 cache and 512k of L2.  The Coppermines PIII
I was comparing to has 256k of L2 cache and also no L3.  I don't have
any G4s available to compare to unfortunately.

> 
> Another possibility is your disks. Did the PIII have SCSI? SCSI uses a
> technique called command queueing to optimize reads and writes. Command
> queueing has only recently become available on some ATA drives and
> Apple does not ship SATA drives with command queueing in their XServes.
> If your old system had SCSI disks, you could try moving them over to
> the XServe if you have a SCSI card in the XServe. Or replace the SATA
> drives in the XServe with SATA drives with command queueing.

True, the PIII does use SCSI disks, but it doesn't seem that the
XServe is disk bound.

> The G5 is excellent for compute intensive tasks, databases are
> typically throughput intensive. If you can't take advantage of the
> vector processor in the G5 (and G4), you're missing a big part of where
> the G5 gets it's performance. You may try compiling a version of MySQL
> yourself, optimized for the G5 chip.
> http://developer.apple.com/technotes/tn/tn2086.html#G5options
> This thread from the archive may help in compiling:
> http://archives.neohapsis.com/archives/mysql/2004-q2/0759.html

Thanks for that pointer.  I've compiled a G5 optimized copy of 4.1.8a
and it definitely makes a subtle improvement to performance.

> But besides all that, you should first determine what's causing the
> bottleneck. It's either disk (I/O), CPU, RAM (not enough allocated), or
> Network.

Still trying to get a clear sense of this but I'm thinking it's CPU.

Thanks again!
 scott

> On Jan 6, 2005, at 1:58 PM, Scott Wilson wrote:
> 
> > Hello,
> >
> > I'm interested to hear peoples' experiences running mysql on OS X.
> > I've moved the database for a fairly heaily used website (~ 2M queries
> > a day) over to a new dual 2GHz XServe running OS X Server 10.3.7.
> > This database has run smoothly on an aging dual PIII machine running
> > freebsd for the past several years.
> >
> > My initial impression is that the performance gains aren't nearly what
> > I would have expected.  For the most part the new machine is less
> > loaded, but at peak times it's arguably doing worse that it did the
> > old freebsd machine.
> >
> > The number a variables involved has hindered my creating comprehensive
> > benchmarks but some initial impressions from running stock mysql
> > benchmarks are that 4.0.23a on OS X performs around 10% faster than
> > 4.1.8a and that my old freebsd machine running 4.0.18 is less than a
> > factor of two slower.  These are all using similar my.cnf settings
> > tuned along the lines of the my-huge.cnf sample config.
> >
> > Does anyone have any tips to offer for tuning OS X and mysql to play
> > well together?  Is anyone running a heavily loaded mysql server in
> > production under OS X?
> >
> > Thanks for you help!
> >
> >   scott
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/[EMAIL PROTECTED]
> >
> >
> --
> Brent Baisley
> Systems Architect
> Landover Associates, Inc.
> Search & Advisory Services for Advanced Technology Environments
> p: 212.759.6400/800.759.0577
> 
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Fulltext search question

[leegold]

Given a search string of 'NA&SD' my default Fulltext search doesn't find
it. Wondered why? Is there a fix? Thanks for the help. 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: logical OR query problem

[SGreen]

OOPS!  the ON AND was a typo. Sorry! Should have been just ON. I am 
puzzled why it worked but I am glad it did.

That's what I get for too much cut-and-paste at the end of the day. I 
apologize to everyone!

What actually made it work was not the ON AND (yuck!) but the LEFT JOIN. 
What you were trying to do was to search all records of the activity table 
that had no description except those that matched parties with no dates. 
The LEFT join allowed the engine to return all rows of the Activity table 
and fill in the data from the party table whenever the two matched up. 
Where the party table and the activity table didn't match up, the engine 
made it seem that EVERY COLUMN of the party table was NULL. 

Clearly this should not be true for any real row in the party table as you 
should have a Primary Key (which is by definition NOT NULL) on every 
table. By checking for a null PK value from the party table, we identify 
all activities that aren't parties. By comparing the date on the party to 
"-00-00" we were able to eliminate those activities that were parties 
but haven't been held yet.  The parentheses in the WHERE clause are 
necessary to isolate the OR from the AND so that we met all of the 
conditions of your search.

Again, I apologize for my typo.

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Richard Reina <[EMAIL PROTECTED]> wrote on 01/09/2005 01:12:23 PM:

> It worked!  Thank you so very much for your very
> elegant solution to this problem.  Your expetese of
> SQL is evident.  I had never seen "ON AND", at first I
> thought it was a typo, however I quickly learned that
> it was part of the solution I was looking for. 
> 
> Once again, Thank you for your briliant help.
> 
> Sincerely,
> 
> Richard
> --- [EMAIL PROTECTED] wrote:
> 
> > Richard Reina <[EMAIL PROTECTED]> wrote on
> > 01/07/2005 03:31:26 PM:
> > 
> > > I am having trouble with a query that gives me
> > > activities that have not been "written up" but if
> > > these activities are a party they whould only
> > appear
> > > in the query if they have been held, hence date
> > will
> > > not='-00-00'
> > > 
> > > If I write the query as so, no non-party
> > activities
> > > will show up because the foreign key P_ID will be
> > null
> > > and not match the p.ID.
> > > 
> > > SELECT a.description
> > > FROM activity a, party p 
> > > WHERE a.write_up IS NULL
> > > AND a.P_ID=p.ID 
> > > AND p.date!="-00-00"; 
> > > 
> > > IF I allow for a.P_ID null with logical OR (like
> > so
> > > )it's a mess
> > > 
> > > SELECT a.description
> > > FROM activity a, party p 
> > > WHERE a.write_up IS NULL
> > > AND ((a.P_ID=p.ID AND p.date!="-00-00")
> > > OR a.P_ID IS NULL)); 
> > > 
> > > Any help on how I can get this to work would be
> > > greatly appreciated.
> > > 
> > > Richard
> > > 
> > > 
> > 
> > You need an OUTER JOIN not the implicit INNER JOIN
> > you form by using the 
> > comma to separate the table names
> > 
> > SELECT a.description
> > FROM activity a
> > LEFT JOIN party p 
> > ON AND a.P_ID=p.ID 
> > WHERE a.write_up IS NULL
> > AND (p.date!="-00-00"
> > OR a.P_ID IS NULL)
> > 
> > That will give you all records from activity that
> > meets these conditions:
> > a) it wasn't a party
> > or b) it was a party and the party's date is
> > not "-00-00"
> > 
> > Shawn Green
> > Database Administrator
> > Unimin Corporation - Spruce Pine
> > 
> > 
> 

Re: Trouble w/ mysqldump (images attached)

[Hurrican19]

Hello, thanks for helping!  Here is the output of the requested statements on 
live database:


SHOW CREATE TABLE avatardata;
| customavatar | CREATE TABLE `customavatar` (
 `userid` int(10) unsigned NOT NULL default '0',
 `avatardata` mediumtext NOT NULL,
 `dateline` int(10) unsigned NOT NULL default '0',
 `filename` varchar(100) NOT NULL default '',
 PRIMARY KEY  (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |


SHOW CREATE DATABASE 'put the name of the avatar database';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use near 
''customavatar'' at line 1

SHOW VARIABLES LIKE '%char%';
+--++
| Variable_name| Value  |
+--++
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database   | latin1 |
| character_set_results| latin1 |
| character_set_server | latin1 |
| character_set_system | utf8   |
| character_sets_dir   | /usr/local/mysql/share/mysql/charsets/ |
+--++

Here is my my.cnf file [Removed commented out sections]:
[client]
#password   = your_password
port= 3306
socket  = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port= 3306
socket  = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
datadir=/var/lib/mysql
old-passwords

log-bin

server-id   = 1

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log

In a message dated 1/8/2005 10:52:13 AM Eastern Standard Time, Gleb Paharenko 
<[EMAIL PROTECTED]> writes:

>Hello.
>
>mysqldump usually produced
>  SET NAMES utf8 
>at the begining of the dump file. The clues may be in this. Send us
>the output of such statements:
>  SHOW CREATE TABLE avatardata;
>  SHOW CREATE DATABASE 'put the name of the avatar database';
>  SHOW VARIABLES LIKE '%char%';
>and your my.cnf file. Use --default-character-set=latin1 command line option
>for mysqldump.
>
>[EMAIL PROTECTED] wrote:
>> Hi Dr.
>>  The avatars still show fine on 4.18a -- but the problem occurs when I 
>> actually do a dump and reimport the dump file.  That's when something goes 
>> array.. Kinda weird if you ask me.. I wish that vBulletin wouldn't actually 
>> hard code the binary in a table, lol.. It's got me totally baffled! :)
>> 
>> 
>> In a message dated 1/7/2005 4:02:04 AM Eastern Standard Time, "Dr. Frank 
>> Ullrich" <[EMAIL PROTECTED]> writes:
>> 
>>>Hi,
>>>
>>>[EMAIL PROTECTED] schrieb:
>>>
 Hi Tom,
     Thanks for the reply!  I show the following information for my DB,
 and shows the same for both the 3.23 DB And the 4.18a DB
 
 Field         Type          Collation 
 avatardata  mediumtext  latin1_swedish_ci 
 
 I pasted a data table from the bad avatar and the good avatar
 to a file differential program, there was no differential at all
 that the system found..
>>>
>>>that seems to point towards a client issue.
>>>Which client do you use to look at the atachments (I think I have heard 
>>>about problems with php and 4.1.x on this list recently)?
>>>
>>>As a further test I would suggest that you take the data table (.myd 
>>>file?) from the 4.1.8 db and copy it into a __test__ 3.23 db replacing 
>>>the data table there (it's myisam isn't it?). See if the avatars are ok 
>>>when you read them from the 3.23 db.
>>>
>>>Regards,
>>>   Frank.
>>>
>>>
 
 I'm not too sure where or what to do to change this information? Do you 
 mean
 that I recompile MySQL using different ./configure commands?
 
 Thanks Tom!
 
 
 
 [EMAIL PROTECTED]  wrote on Thursday, January
 06, 2005 4:57 PM:
 
 
>Sorry, forgot the attachments.  These are the same exact two
>avatars from the same user, using my 3.23 backup, for the
>good avatar, then the 4.18 bad avatar
 
 
 Looks like a character set issue - what's the column type, BLOB 

Re: Generic graphing tool?

[Daniel Kasak]

Jason Martin wrote:
Does anyone know of a web-based tool that will let you graph
arbitrary data out of of MySQL? I'm thinking of something that
lets you define a select statement, some graph options and
produce a graph.
 

JPGraph produces some *very* nice graphs from PHP.
There are some graphing modules around for Perl, but I don't think 
there's anything as nice as JPGraph. If there is, I'd like to know about 
it :)

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

replacing field contents?

[Robin Lynn Frank]

I hope this question doesn't sound too dumb, but since I can't afford to
screw it up...
I have a table with 98,000 records.  I want to globally replace the
content of one field where the content is
XXX diverse_text
with
XXX non-diverse_new_text
In other words, if the content of the field starts XXX, I want it
replaced with XXX with only the new text following.
TIA
--
Robin Lynn Frank - Director of Operations - Paradigm-Omega, LLC
Website:   http://www.paradigm-omega.com/
RSS:   http://paradigm-omega.blogspot.com/atom.xml
Spamtraps: http://paradigm-omega.net/cgi-bin/custmail.cgi
=
A bug in the hand is better than one as yet undetected.


signature.asc
Description: OpenPGP digital signature

Hello!

[sanoj zubair]

Hey, This is sabeer. Newly joined to this Group.
Hope I ll enjoy my best Here.

Sabeer MZ



__ 
Do you Yahoo!? 
Yahoo! Mail - 250MB free storage. Do more. Manage less. 
http://info.mail.yahoo.com/mail_250

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

FK Id in Innodb

[Karam Chand]

Hello,

http://dev.mysql.com/doc/mysql/en/InnoDB_foreign_key_constraints.html

According to it I can specify a name/id for a relation
on and after 4.0.18. Before that InnoDB provides an
internal id/number. 

I was just curious - what happened before 4.0.18 or
3.23.x. Was an ID still provided by InnoDB and it used
to come in CREATE TABLE stmt.?

Since I dont have access to those versions, I was just
wondering.

Regards,
Karam

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: easy way to drop a tempoary table created by Create view?

[sam wun]

sam wun wrote:
Gleb Paharenko wrote:
Hello.

Use -e command line option for mysql client program. For example:
 mysql -u root -p test -e 'drop view v'
 

Hi, does it take wildcard? something like:
mysql -u root -p test -e 'drop view v*'
Or even drop all view tables (only affect the view tables):
mysql -u root -p test -e 'drop view *'
Sam.
Thanks
Sam

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: easy way to drop a tempoary table created by Create view?

[sam wun]

Gleb Paharenko wrote:
Hello.

Use -e command line option for mysql client program. For example:
 mysql -u root -p test -e 'drop view v'
 

Hi, does it take wildcard? something like:
mysql -u root -p test -e 'drop view v*'
Thanks
Sam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Generic graphing tool?

[Jim]

Jason Martin wrote:
Does anyone know of a web-based tool that will let you graph
arbitrary data out of of MySQL? I'm thinking of something that
lets you define a select statement, some graph options and
produce a graph.
I'm afraid I'm not aware of anything as simple to use as you describe, 
but you could build one without TOO MUCH pain using CharDirector (a free 
version is available from http://www.advsofteng.com/) and your scripting 
language of choice. I prefer PHP or Perl, myself.

Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: MySQL-4.1 and PHP

[Dathan Pattishall]

Nope no issues. 

> -Original Message-
> From: Daniel Kasak [mailto:[EMAIL PROTECTED] 
> Sent: Sunday, January 09, 2005 6:51 PM
> To: mysql@lists.mysql.com
> Subject: MySQL-4.1 and PHP
> 
> Hi all.
> 
> Does anyone know if there are any issues with PHP-4.1 and MySQL-4.1?
> I assume I'll have to recompile PHP ( and Perl and other 
> stuff that talks to MySQL ), but other than that, are there 
> any gotchas I should know about?
> 
> --
> Daniel Kasak
> IT Developer
> NUS Consulting Group
> Level 5, 77 Pacific Highway
> North Sydney, NSW, Australia 2060
> T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
> email: [EMAIL PROTECTED]
> website: http://www.nusconsulting.com.au
> 
> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

FullText search question

[leegold]

Given a search string of 'NA&SD' my default Fulltext search doesn't find
it. Wondered why? Is there a fix? Thanks for the help.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Regarding rowid

[lakshmi.narasimharao]

Hi,
What is the equivalent of oracle's rowid (which is a 16digit unique
one) in mysql 4.0.20?. To achieve the same functionality is there any
alternative method in MySQL?. Please help me in this.

Thanks,
Narasimha



Confidentiality Notice

The information contained in this electronic message and any attachments to 
this message are intended
for the exclusive use of the addressee(s) and may contain confidential or 
privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [EMAIL 
PROTECTED] immediately
and destroy all copies of this message and any attachments.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: can't get the order I want after inserting new rows

[Marcus Claesson]

Hi Michael!

Before the holiday you tried to help me with a problem that I had
over-simplified and made more confusing than it was. I'll now try again,
and also by giving the columns their right names.

My table consists of parsed outputs from a bioinformatics tool called
blast. Every 'sbj_name' (which can be full sentences and probably
unsuitable for '=' with other sbj_names) has one 'sbj_count' and at
least one 'hsp_count'. The higher the 'score' the lower the 'sbj_count'.
My perl program, which uses the table, needs a certain order of the
query output to work. It should also be capable of adding new data into
the table. After adding new data the query output should have the same
structure, thus (only) column sbj_count needs to be updated. For
example, this is my old data:

sbj_namesbj_counthsp_countscore
---  ---  -
a   1   1   900
a   1   2   500
b   2   1   800
c   3   1   700
c   3   2   600
c   3   3   500

and this is new:

d   1   1   1000
d   1   2   400
e   2   1   900
e   2   2   500
f   3   1   700
g   4   1   600

If I now would ask the same query (SELECT * from table ORDER BY
sbj_count,hsp_count) that gave the correct output of the new data I
would get:

a   1   1   900
a   1   2   500
d   1   1   1000
d   1   2   400
b   2   1   800
e   2   1   900
e   2   2   500
c   3   1   700
c   3   2   600
c   3   3   500
f   3   1   700
g   4   1   600

Thus the new sbj_names share sbj_count with the old sbj_names.

Instead I want 
SELECT * from table ORDER BY sbj_count,hsp_count:
d   1   1   1000
d   1   2   400
a   2   1   900
a   2   2   500
e   3   1   900
e   3   2   500
b   4   1   800
c   5   1   700
c   5   2   600
c   5   3   500
f   6   1   700
g   7   1   600

As you can see sbj_count has been updated based on the score value, but
has also given the same sbj_count value to all the same sbj_name, and
thus kept them together in the output.

Hope this one is a bit clearer.

Many thanks!

Marcus




On Sat, 2004-12-18 at 21:25, Michael Stassen wrote:
> Marcus Claesson wrote:
> 
> > Hi!
> > 
> > I have a problem with getting the order I want on a table after new rows
> > have been inserted. I try to simplify it...:
> 
> Perhaps you have simplified too much, then, as I simply do not understand 
> what you want.  Comments and questions below.
> 
> > I want to have a one-to-one relationship between 'name' and 'full'.
> > Every 'name' (or'full') have one or more 'parts'. The higher the 'score'
> > the lower the 'full',
> 
> How do you achieve this?  Is the full really an ID for name, or does it 
> change according to score?
> 
> > but for my program I have to keep every 'name'
> > next to each other, with ascending 'part' number.
> 
> Hence "ORDER BY name, part" or "ORDER BY full, part".  OK.
> 
> > I don't want to use
> > 'name' as an identifier since they can be long sentences.
> 
> Then name should be in a separate table, linked by its id (full?).
> 
> > In other words, I have this old table:
> > SELECT * from table ORDER BY full,part;
> > 
> > namefullpartscore
> > --- --- -
> > a   1   1   900
> > a   1   2   500
> > b   2   1   800
> > c   3   1   700
> > c   3   2   600
> > c   3   3   500
> 
> OK.
> 
> > and I insert these rows into the same table:
> > (there's nothing I can do about these 'full' values)
> > 
> > d   1   1   1000
> > d   1   2   400
> > e   2   1   900
> > e   2   2   500
> > f   3   1   700
> > g   4   1   600
> 
> Wait a minute!  You said you have a "one-to-one relationship between 'name' 
> and 'full'", but a full of 1 means name is 'a', not 'd'.
> 
> > And after some manipulation (that I hope someone can help me with) I
> > want a query that gives this:
> > 
> > d   1   1   1000
> > d   1   2   400
> > a   2   1   900
> > e   3   1   900
> > b   4   1   800
> > c   5   1   700
> > c   5   2   600
> > c   5   3   500
> > f   6   1   700
> > g   7   1   600
> 
> You start with 6 rows and add 6 rows.  That's 12 rows, but your desired 
> output has only 10 rows.  How do you determine which rows to keep and which 
> to exclude?
> 
> Looking more closely, I see that this is simply not the data you inserted -- 
> every row starting with the third has the wrong full number.  Surely you are 
> not saying that you want a q

Mysqldump error 1017: errno: 24 - help?

[Mysql user]

Hi.. 

I've got an ISP, and all of our customers have databases in our mysql
system. 

My backup command is:

mysqldump --force --opt -A -p' | gzip -c >
/var/sqlbackup/mysqldump-`date +\%A`.sql.gz 

This has worked fine for some time. 

Now, however, I get an error message: 

mysqldump: Got error: 1017: Can't find file:
'./usr_web22_1/invoices_va.frm' (errno: 24) when using LOCK TABLES 

On different runs, it reports different files, even right after
restarting mysqld.

I've looked at the mysql documentation for this error; it's at 
http://dev.mysql.com/doc/mysql/en/Not_enough_file_handles.html

I've looked at the startup script, put in '--open-files-limit=1024',
restarted mysql, and the error is the same. 

I've looked at the table_cache and max_connections system variables,
which are 64 and 100, respectively. 

My question is: what should I do now? 

Since table_cache and max_connections are far less than 1024, do I
reduce them even further? 
Is there something else I should be looking at? 

This is mysql-3.23.52-106 on SuSE Linux 8.1, running on a dual PIII
866Mhz system, with 512M of ram and 1G of swap, on a RAID-1 pair of 17G
hard drives.

Thanks!


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

List down?

[Martijn Tonies]

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

clerification of documentation on InnoDB locking.

[Sean]

on the page http://dev.mysql.com/doc/mysql/en/InnoDB_Locks_set.html

This statement is confusing.

 "If you do not have indexes suitable for your query and MySQL has to scan the 
whole table to process the query, every row of the table will become locked"

  Is it saying that all at once at the beginning of the table scan a lock is 
places on the entire table or is this saying that a lock for each record that 
the query is on as it scans the table will be moved through the entire table as 
it scans.
 If it is a rolling lock then no big deal other clients can access pages of the 
table that are not currently being scanned. If it is a table lock then no one 
gets any records till the scan is done much the same as MyIsam


 Regards
  Sean Mathews Nu Tech CTO

struct SoftwareProfessional {
   double salary;
   long   lunches;
   float  jobs;
   char   unstable;
   void   work;
   short  tempers;
}; 





Sent via the WebMail system at mail.nutech.com


 
   

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

how to connect to MySQL with an ecripted password.

[Eduardo Castro]

Hi, I am trying to connect to my sql using  a php script, but I do not 
want to store the  MySQL user password in a text file.

Is there a way to encript the password in the text file?  Or anothe way 
to connect to my sql with an encripted password?

Thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: big table corruption

[matt_lists]

Have a look at your /var/log/messages for messages around the time the 
table crashes .  It really should not crash this much.  Is there a 
quota system on your box ? I once had a table marked corrupt and 
though I tried hard to find where the problem is, I was not able to.  
Eventually, it turned out that the user had exceeded the quota set for 
her.

The crashes happin when the program runs, and puts in new data, 4 times  
per day, crash once a day ususally

no quota's on the system
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Stored Procedure for advance reporting

[sam]

Hi,
Can anyone tell me where I can download examples for creating Stored 
Procedure in perl DBI?
It seems that I can't create advance reporting with basic operations 
(select, create) in perl dbi, so I m looking for whether Stored Proc in 
MySQL can solve my problem.

Thanks
Sam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Generic graphing tool?

[Jason Martin]

Does anyone know of a web-based tool that will let you graph
arbitrary data out of of MySQL? I'm thinking of something that
lets you define a select statement, some graph options and
produce a graph.

Thanks,
-Jason Martin
-- 
You can't go home again, unless you set $HOME.
This message is PGP/MIME signed.


pgp1G8gqgRN83.pgp
Description: PGP signature

Re: BIG InnoDB problems!

[Heikki Tuuri]

Andy,
- Alkuperäinen viesti - 
Lähettäjä: "Andy Davidson" <[EMAIL PROTECTED]>
Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>
Lähetetty: Tuesday, January 04, 2005 5:02 PM
Aihe: Re: BIG InnoDB problems!

...¨
On Mon, 3 Jan 2005, Heikki Tuuri wrote:
the problem you had was serious corruption in the ibdata files. It can
be caused by an InnoDB bug, an OS bug, faulty hardware, and also by an
error of the database administrator.
Linux kernels 2.4.18 seemed to have corruption issues.
Hi, Heikki --
Is this something that you ONLY seem to see in 2.4.18, or is it all
kernels up to 2.4.18 (excluding .15 of course), or all kernels since ?
kernels 2.4.x, where x  <= 18.
How have you reached a conclusion about this kernel version, please ?
2.4.18 is the stock kernel in recent Debians, for instance, and it seems
that it's capable of stable MySQL/InnoDB environments.  Though if I am
wrong, I would be delighted to know why so that we can change things
quickly. ;-)
Red Hat kernels 2.4.18 are suspect. I have little feedback from 
Debian-2.4.18.

--
Andy Davidson
Systems Administrator
Ebuyer UK Ltd., 201 Woodbourn Road, Sheffield, S9 3LR
Regards,
Heikki 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL-4.1 and PHP

[Daniel Kasak]

Hi all.
Does anyone know if there are any issues with PHP-4.1 and MySQL-4.1?
I assume I'll have to recompile PHP ( and Perl and other stuff that 
talks to MySQL ), but other than that, are there any gotchas I should 
know about?

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]