is 'start' a keyword?

2004-10-14 Thread Brian Reichert
I tried to create a table with a column named 'start'.

This word does not appear here:

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

But, my effort to create such a column yeilded a syntax error, and
I did subsequently learn of a 'start' directive, such as in:

  START TRANSACTION, COMMIT, and ROLLBACK Syntax
  START SLAVE Syntax

Is the URL I cited intended to be a canonical list of keywords I
can't use for table/column names?

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: is 'start' a keyword?

2004-10-14 Thread Brian Reichert
On Thu, Oct 14, 2004 at 10:33:45PM -0400, Brian Reichert wrote:
 I tried to create a table with a column named 'start'.
 
 This word does not appear here:
 
   http://dev.mysql.com/doc/mysql/en/Reserved_words.html

Hmph; I had a typo in my 'create table' directive.  Sorry about the
noise...

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: 1 database; 2 scripts; different results

2004-09-04 Thread Brian Reichert
On Sat, Sep 04, 2004 at 02:40:20PM -0400, Amer Neely wrote:
 My question is, in my admin script I deleted a record, but it still shows 
 up using the other script. The admin script shows 102 records and the 
  other shows 103. The record does show up in the 'public' script, so it's 
 not just a mis-count. How is this possible? Is there a step I'm missing 
 because I'm using 2 different scripts to access the same tables? That 
 doesn't make sense. Can someone shed some light on what might be happening 
 here?

Web caching?  Flushing tables after your delete?

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: Create Temporary Table, incorrect rows

2004-07-06 Thread Brian Reichert
On Tue, Jul 06, 2004 at 10:30:38AM -0400, Paul McNeil wrote:
 Good day to all.
 
 I have a table and want to find duplicate info in the table.  I know
 duplicated info exists by running the following...
 
 Select count(*) from myTable - 141123
 Select distinct(myData) from myTable - 1411000

I presume there's a typo here: count(*) should have returned a
larger number than distinct(myData), not smaller.

 So I created a temporary table to store distinct records and want to do a
 join with original table to see what records are duplicates.
 
 Create Temporary Table A
   Select distinct(mydata),rowID from myTable;

This is a different query than above.  What cout do you get from
this query:

  Select distinct(mydata),rowID from myTable;

Yes, it will be huge, but you want that count of selected rows.

 God Bless
 
 Paul C. McNeil
 Developer in Java, MS-SQL, MySQL, and web technologies.

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: Create DB help

2004-06-21 Thread Brian Reichert
On Mon, Jun 21, 2004 at 12:01:06PM -0400, Tony Martino wrote:
 I believe it is exactly what I need.
 What I need to knwo now... could you please tell me WHERE I need to try:
  mysql -u{username} -p {databasename}filename.sql

This assumes a few things:

- that the database (as opposed to the tables in the database) has
  already been created.

- that '{username}' has the priviledges of writing to said database
  ('create table', and so forth.

As to 'where': from the command line.  'mysql' is the name of the
command-line client for MySQL.

Unless I'm misunderstandig your question...

 Thank you very much in advance
 
 Tony

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: Dump table

2004-06-16 Thread Brian Reichert
On Wed, Jun 16, 2004 at 09:16:52AM +0400, Vinay wrote:
 Thanks Brian
 but i'm on Red Hat enterprise server so i wouldn't be able to use the
 Features  of  FreeBSD and restarting the server is not a solution for me 
 as i need to be able to perform hot backup.
 One of my solutions was to bump the database in a text file. this wroks 
 fine for small tables but with lager one this takes too
 much time and somtimes freezers the server.

Next trick:  Replication.  You _can_ afford to temporarily turn off
the slave server for backups, replication will pick back up when
you restart.

This could possibly avoid using snapshots, if you could have so few
transactions that you could afford to keep the slave server offline
long enough to dump.

And since this would require a second server, if you _do_ need
snapshots, you'll have the opportunity to research and implement
options, Linus-based or otherwise.

 V!nay

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: Dump table

2004-06-15 Thread Brian Reichert
On Tue, Jun 15, 2004 at 10:14:54AM +0400, Vinay wrote:
 Hi,
 I just like to know what is the best way to dump the databases to flat 
 files as some of the tables on my system are up to 1.4G and the whole 
 database size is over 2.5G . I trying to set up a cron job that will 
 back up the table everyday and my main consern is the size of the tables 
 and the time it may take to back up all the data and the fact that even 
 during the back up theire will be other people using the database.

I've seen people play horrible tricks with NetApps (an other heavy
journaling filesystems), wherein you could get a snapshot of the
whole FS very quickly.

The order of events is then

- shut down DB
- snapshot the FS
- start the DB
- back up the now-static snapshot any way you see fit, such as
  spinning up a second instance of MySQL to use that snapshot, for a
  mysqldump.

The FreeBSD 5.x series seems to offer filesystem snapshots (for
example), but I've not explored them yet..

 V!nay

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: mysql backup script

2004-06-15 Thread Brian Reichert
On Tue, Jun 15, 2004 at 08:04:00AM -0500, Steve Buehler wrote:
 I am having a problem with a backup script that is written in a shell 
 (/bin/sh) script to backup my mysql databases.  For some reason on any day 
 with an even number I get the following error:
 MySQL could not be stopped, exiting...
 It is really weird because it will run on odd number days without a 
 problem.  Should I put some kind of a wait in the script after it stops the 
 mysqld and before it checks to make sure the pid file is still there?  If 
 so, does anybody know how?  I am not sure that that will solve the problem 
 though because it exits afterward and the mysql daemon is still running 
 without having to restart it.  Below is the relevant part of the script.
 The script is run from cron with this line
 0 1 * * * /root/backup/backup.sh /dev/null 21
 But since the logs do show it running, That shouldn't be the problem.
 Thanks
 Steve
 
 #  Perform myisamchk
 #mysqladmin -p$MYSQLPWD shutdown
 /etc/rc.d/init.d/mysqld stop
 if [ -f $mysqlpid ]; then

Does /etc/rc.d/init.d/mysqld (however indirectly) remove the $mysqlpid file
when it exits?

Is $mysqlpid the same as '/etc/rc.d/init.d/mysqld start' would create?

Couldn't you check for an exit status of '/etc/rc.d/init.d/mysqld stop'
instead?

I've played stupid games like this, to work around weak management
scripts (pseudo-code):

  while( -f $mysqlpid )
sleep 1
  end

There are risks with that, as well, of course, but you see what it's trying
to do...


-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: Lots of databases...how wrong is it?

2004-05-29 Thread Brian Reichert
On Sat, May 29, 2004 at 02:31:08PM +0100, Yannick Warnier wrote:
 Hi there,
 
All of my my comments are base don my personal experience:

 - how wrong is creating 20 databases (total 400 tables) when you know
 you could create just one (total around 200 tables)?

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

  7.4.9 Drawbacks to Creating Many Tables in the Same Database

 - what does MySQL handle better? Databases or tables?

It depends on what you mean by 'handle'.

Under the hood, as far as the file system goes, databases are merely
directories, and tables are merely files in a database's directory.

Of course, the set of database directories is kept under a single
directory, whatever your 'datadir' variable is set to.

All filesystems, irrespective of the OS in use, have performance
problems when there are too many files (or directories) in a
directory.  Precisely what 'too many' is depends on the OS/filesystem
in question, plus other modifiers such as how fast are your drives,
how much RAM do you have, and so forth.

'Too many' is usually up in the thousands.  A few hundred is usually
fine.

You can experience the performance of simply trying to use 'ls' on
a directory; on a big directory, it will pause for a long period
of time, as it gathers the list of files and sorts them.

Your questions above WRT numbers of tables:

   creating 20 databases (total 400 tables) when you know
   you could create just one (total around 200 tables)?

All points at numbers of files that are so small that they shouldn't
be a major limit.  Your first number, though:

   I am using a mysql server at the moment which contains 2800 different
   databases.

Crosses that line into 'too many', for many filesystems.

If your data is homogenous enough that is could be wadded up into
one monster database, or broken up into an arbitrary number of
smaller databases, then consider minimizing the number of databases,
such that the number of tables per database is kept down in the
hundreds.

If your 2800 was really the number of tables in use, you could
perhaps afford to scatter those tables into, say, ten databases of
280 each.

But what you pick for numbers really does depend on the performance
of your machines/OS/filesystem, as modified by what step's you've
taken to tune your MySQL server.

You're in the best position of all of us to make those tests.

 - could a slowdown problem causing me to have a show databases query
 answered in 42.50 seconds (more often being 0.02 sec) be bound to too
 many databases?

It could be a factor, but there could be other factors, such as how
heavily the MySQL server is being used at that point.  Or what other
activity on that box is consuming CPU or disk cycles.

 Thanks,
 Yannick

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: SHA1 Question

2004-05-28 Thread Brian Reichert
On Fri, May 28, 2004 at 12:04:53PM -0400, Brian Muha wrote:
 Hello all and I hope this email finds you all well..
 
 My question is I currently have passwords encrypted in SHA1 via LDAP...
 
 What I need to do is get these user names and passwords out of ldap and
 placed in mysql ..
 
 The application is qmail/courier..
 
 The question is can i just take the already made SHA1 passwords and
 insert them right into mysql password table..  or must i get the plain
 text passwords and have mysql encrypt them again with SHA1.

Nope, you should be able to import the SHA1 passwords directly.
Make sure that whatever authentication tool that's going to use
with MySQL knows that these are SHA1-encrypted passwords (as opposed
to MD5, or whatever.)

It should be easy enough to do one as a test, to see...

 TIA
 
 Brian   

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: Looking for a C API if it exisits

2004-05-27 Thread Brian Reichert
On Tue, May 25, 2004 at 03:36:08PM -0600, Sarix wrote:
 Cause when I do my web end to all this life
 is easy cause I can do $name = $row['Name'] and it works for PHP so I
 figured there has to be an API that would do that.. But I can't seem to find
 it in the documention. Is there something that will help with this, or is C
 just too old to have helpful ablitles like this. :)

People have written libraries for C to emulate higher-level languages.
Here is an example, but I've not used it myself:

  http://www.annexia.org/freeware/c2lib/doc/

It speaks of 'vectors', and you could easily wrap your DB access
routines in this, to give you something very like the named hashes
that Perl and PHP use.
  
-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: Unknown error, urgent help please

2004-05-24 Thread Brian Reichert
On Tue, May 18, 2004 at 10:08:32AM -0400, Ronnie Regev wrote:
 Hi,
 Before I go on, I know nothing about mysql, but my db admin is out of town
 and I need to be pointed in the right direction please.
 Running red hat 7.3, mysql-3.23.58-1.73, phpMyAdmin 2.5.0-rc2, in a virtual
 hosting environment on Ensim webppliance-3.5.20-7.
 
 When using phpMyAdmin and attempting to upload a csv file, the following
 error is the result:

Maybe MySQL doesn't have permission to read '/tmp/php7T1P2m' ?

Maybe you don't have the right username/hostname/password?  I don't
know how PHP combines the details of DB access.

Everything PHP is doing, you should be able to replicate from the
mysql client...

 Ronnie Regev
 System Administrator
 Microsoft Certified Professional MCP
 Daslweb Inc.
 [EMAIL PROTECTED]

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: mysqldump problem

2004-05-24 Thread Brian Reichert
On Mon, May 24, 2004 at 03:07:17PM +0100, Gilbert Wu wrote:
 Hi,
  
 I've been using mysqldump to backup my entire database. Every day, I restore the 
 whole thing to my test/develop database by piping the large sql generated by 
 mysqldump. All is well until the file size of the sql file reached about 4Gbytes. I 
 wonder if there is a size limit to the database I can backup and restore?

Consider the OS and filesystem as well (wheatever uyou _are_ using; you
didn't tell us).

Quotas?  Limits by FS?  getrlimit()?

 Many Thanks.
  
 Regards,
  
 Gilbert Wu
 [EMAIL PROTECTED] 
  http://www.sabrefund.com/  http://www.sabrefund.com/ 

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: Database design.. Asking again

2004-05-12 Thread Brian Reichert
On Mon, May 10, 2004 at 09:49:31PM -0700, Scott Haneda wrote:
 Sorry for the post again, I hijacked a thread and wanted to get this on the
 correct track.
 
 I can not seem to find the section in the manual that talks about the max
 number of tables MySql can use, can someone point me please?

A classic hit is how efficient is your filesystem at handling large
directories.  Each table corresponds to a few files.  Too many files
in a single subdirectory can cause performance problems.

I don't know if there's a limit at to how many tables can be handled
by a single MySQL query.  There are MySQL system variables that
limit as to how big that query command can be.

 -
 Scott HanedaTel: 415.898.2602
 http://www.newgeo.com   Fax: 313.557.5052
 [EMAIL PROTECTED]Novato, CA U.S.A.

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: Executing Pre-Written Commands

2004-04-23 Thread Brian Reichert
On Fri, Apr 23, 2004 at 10:47:53AM -0400, Chris Stevenson wrote:
 Anyone out there have any experience with the book MySQL by Paul DuBois?
 I'm having trouble figuring out how to save/resuse executed commands
 (primarily creating tables at this point).  Perhaps I could bounce a few
 questions offline if you've got used this book before or think you can
 assist me regardless.

It's usually as easy as 'cat sql_command.txt | mysql'.

To wit, maintain a text file of SQL commands you want executed.

I do things like:

  #--
  drop table if exists user;

  create table user
  (
user  VARCHAR(254) unique NOT NULL,
user_id   INT UNSIGNED not null PRIMARY KEY AUTO_INCREMENT,
password  VARCHAR(32) binary NOT NULL,
name  VARCHAR(254) NOT NULL,
index (user)
  );

  # initialize a 'default' user
  
  insert into user (user, password, name, email)
values ('none', '--disabled--', 'No user assigned', '');
  #-

This way, I can completely reset my user table at a whim, and even
annotate my data.

I go so far as to have separate tables in separate files, all named
something.sql.

Then, I can reset one table

  cat user.sql | mysql test

Or all of them:

  cat *.sql | mysql test

Mind you, I haven't performed the latter with foreign keys, so you
may have to take measures to assure tables are created / initialized
into the right order...

If you have a extant database, with lots of data that you're testing,
just do a mysqldump of that table (or database) into a text file,
and you can replay it as above.  There are special arguments to
mysqldump to maintain the delete/create table (and database) commands,
so read those docs.

 Thank you and have a great day!
  
 Chris Stevenson
  

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: How to determine when a MySQL database was last modified?

2004-02-07 Thread Brian Reichert
On Fri, Feb 06, 2004 at 08:18:10PM +, Phil wrote:
 Doesn't seem to change the mtime on table files. It appears that for
 InnoDB tables these files are only updated when the definition of a
 table is changed. The content of the all InnoDB tables is kept in one or
 two massive files directly under the 'data' directory!

At _some_ point your data has to end up on disk.  I haven't read
up on the caching that MySQL does.  I know you can manually FLUSH
TABLES, but that's of no use to you: you want to passively detect
when the file's changed.

I just did a one-record update to a test database:

Before:

  # ls -ld user.*
  -rw-rw  1 mysql  mysql  18168 Dec 22 16:58 user.MYD
  -rw-rw  1 mysql  mysql  20480 Dec 26 18:00 user.MYI
  -rw-rw  1 mysql  mysql   8794 Dec 11 14:20 user.frm

After:

  # ls -ld user.*
  -rw-rw  1 mysql  mysql  18168 Feb  7 12:33 user.MYD
  -rw-rw  1 mysql  mysql  20480 Feb  7 12:33 user.MYI
  -rw-rw  1 mysql  mysql   8794 Dec 11 14:20 user.frm

I updated that same record again:

  # ls -ld user.*
  -rw-rw  1 mysql  mysql  18168 Feb  7 12:34 user.MYD
  -rw-rw  1 mysql  mysql  20480 Feb  7 12:34 user.MYI
  -rw-rw  1 mysql  mysql   8794 Dec 11 14:20 user.frm

This is with MySQL 3.23.58 and MyISAM tables.

So, in my (very) limited testing; changing a table's content does
promptly correspond to an updated mtime of the data and index
columns.

I do see that you're using InnoDB tables; I'll try to set another
test environment.

Good luck, anyway...

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: How to determine when a MySQL database was last modified?

2004-02-06 Thread Brian Reichert
On Fri, Feb 06, 2004 at 09:17:32AM -0500, Dan Greene wrote:
 I'm not 100% sure on this, but what about the .myd file timestamp?

Well, it depends on which table type, obvously.  There are several
files for each database, see what the mtime is on each of them, to
determine what's a live file.

If you're using rsync for backups, I wouldn't worry; it's good at
moving partial files around.

-- 
Brian Reichert  [EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: Preventing data collisions

2003-11-17 Thread Brian Reichert
On Mon, Nov 17, 2003 at 11:06:39PM -0600, David Dice wrote:
 I'm a newbie to MySQL so if this is a common question, forgive me, but I can't find 
 an answer.
 
 How do I prevent data collision in the following scenario:
 User A and User B are examining the same data (say a customer's name and address).  
 User A modifies something (say the customer's phone number) and saves the 
 transaction.  User B modifies something different at the same time.  How can I 
 prevent User B's modification from being saved?

Under MySQL, you can lock the a table during sensitive transactions.
If you're using InnoDB tables, you can use row locking.

  http://www.mysql.com/doc/en/Locking_methods.html

 This is a database I'm converting from Foxpro, and there I would have just told User 
 B that User A had the data open, and prevented them from editing it.  I'm sure 
 there's a better way.  Thanks for your advice.
 
 David Dice

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: SQL: forbidden syntax search

2003-11-16 Thread Brian Reichert
On Sun, Nov 16, 2003 at 03:31:18AM +0100, M. Bader wrote:
 Hi,
 
 I need a little help on my SQL syntax.
 
 I want to store forbidden inputs from the GUI in a table and query it on
 input from the user;

This doesn't answer your question specifically, but rather, describes
a separate solution...

 simple layout:
 
 CREATE TABLE `forbidden_input` (`lfdnr` TINYINT (3) UNSIGNED DEFAULT '0'
 AUTO_INCREMENT, `input` VARCHAR (255) NOT NULL, PRIMARY KEY(`lfdnr`),
 UNIQUE(`input`));
 
 Content is something like this:
 1,'+'
 2,'^'
 3,''
 4,''
 5,'('
 6,')'
 7,'~'
 8,''
 9,'%'

Must the forbidden inputs be in a table?  Couldn't you use the
regular expression syntax instead?  Something like:

  SELECT `input` FROM lok_forbidden_input WHERE
'Hello World' regexp '[+^()~%]';

(This is utterly untested.  Tweak as neccessary. You might need to
backquote some characacters there...)

The point being, you can build your regular expression to contain
a list of weird characters you want to match.

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: mysql well suited for bibliographic data...

2003-10-25 Thread Brian Reichert
On Sat, Oct 25, 2003 at 12:47:16PM -0600, Miguel Maloney wrote:
 Does Mysql support repeatability of fields and subfields?
 and would it be well suited for a bibliographic database?

What is a 'subfield'?  And what do you mean by 'repeatability'?

 Regards,
 
 
 Miguel Maloney
 Email: [EMAIL PROTECTED]
 Website: http://maloneyja.com

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: help installing DBI modules

2003-08-23 Thread Brian Reichert
On Sat, Aug 23, 2003 at 10:42:45AM -0400, March, Kristopher (Contractor) (DSCR) wrote:
 I'm trying to install DBI perl modules on a SUN 8 box. 
 
 I can't seem to find a make utilitity for building the components. Is it
 called something else or will I have to go out and install it? 

Is /usr/ucb/bin in your path?

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: External Access

2003-08-22 Thread Brian Reichert
On Fri, Aug 22, 2003 at 09:20:08AM -0500, Christensen, Dave wrote:
 I know that we need to open a port, such as
 3306, to access the server.  My question is whether that port requires TCP,
 UDP or both to be open.

TCP.

 Thanks!
 
 David Christensen
 Brokers International, Ltd.
 1200 E Main St
 Panora, IA  50216
 (641) 755-2775
 [EMAIL PROTECTED]

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: moving MySQL

2003-08-20 Thread Brian Reichert
On Wed, Aug 20, 2003 at 11:41:22PM +0800, Jon  Miller wrote:
 We've run out of disk space and would like to move either the entire MySQL system or 
 if possible move the databases.  Can this be done without any difficulties?

Yes, if you can afford to turn off your server.

If you need to keep your server live, then things become more
complicated, but solvable...

 
 Thanks
 
 Jon L. Miller, MCNE, CNS
 Director/Sr Systems Consultant
 MMT Networks Pty Ltd
 http://www.mmtnetworks.com.au
 
 I don't know the key to success, but the key to failure
  is trying to please everybody. -Bill Cosby

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: curtime

2003-08-20 Thread Brian Reichert
On Wed, Aug 20, 2003 at 10:54:28AM -0300, Fabio Bernardo wrote:
 When I write
 select curtime();
 It?s return the mysql?s system time, but I would like to change this time
 (because it?s late 3 minutes)

Then your system's time need to be updated correctly.

 Any ideas?

Get your sysadmin to install an NTP client on your server.

 Thanks a lot

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Will a SIGTERM shutdown while using LinuxThreads?

2003-08-20 Thread Brian Reichert
On another mailing list, there is a discussion about whether or not
it is adequate/proper to manage the MySQL server process via a
watchdog script (namely, DJB's daemontools).

The point behind this watchdog script is to launch a service (such
as mysqld) in the foreground, and notice if that process exits.  An
auxilary tool will send this managed process a SIGTERM, to request
shutdown.

It has been working for me under FreeBSD, and the MySQL docs imply
this should work for other OSes, but someone just pointed out to me
this info:

  http://www.mysql.com/doc/en/Linux.html

  When using LinuxThreads you will see a minimum of three processes
  running. These are in fact threads. There will be one thread for
  the LinuxThreads manager, one thread to handle connections, and
  one thread to handle alarms and signals.

I myself don't use Linux, much less LinuxThreads.  Can anyone advise
how the theree process/threads should handle a SIGTERM in such a
watchdogged environment?

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: Mysql.log error - Please help

2003-04-04 Thread Brian Reichert
On Fri, Apr 04, 2003 at 09:10:50AM +0200, Jocelyn Fournier wrote:
 Hi,
 
 Or simply use perror 28 :)
 
 [EMAIL PROTECTED]:~$ perror 28
 Error code  28:  No space left on device

Golly, I had no idea that such a utility came with the MySQL
distribution.

Kinda handy.

Learn something new everyday...

 Regards,
   Jocelyn

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: Mysql.log error - Please help

2003-04-03 Thread Brian Reichert
On Fri, Apr 04, 2003 at 12:22:18PM +0530, Minal Amle wrote:
 Hello,
 
 I am facing a problem while inserting data in one of the tables of my mysql database 
 as:
 Error writing file '/var/log/mysql.log' (Errcode :28)

I suspect this 'Errcode' corresponds to 'errno' under UNIX systems.
On mine, that would corresspond to:

  #define ENOSPC  28  /* No space left on device */

My box, a FreeBSD box, has this constant in /usr/include/sys/errno.h.
your system may vary...

  man errno

Good luck...

 Thanks in advance.
 
 Regards,
 Minal Amle
 Software Engineer
 OAS Information Systems Pvt. Ltd.
 #2, Symphony-C, Range Hills Road,
 Pune 411020
 Tel: +91 20 5520311
 Fax: +91 20 5520312
 Email: [EMAIL PROTECTED]
 http://www.oas.co.in

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

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



Re: Configure fails

2003-03-07 Thread Brian Reichert
On Fri, Mar 07, 2003 at 11:05:37AM -0600, Judi Buff wrote:
 I am using the the following command:
 
 #./configure --enable-thread-safe-client --prefix=/usr/local/mysql

You realize that you've given us no details of your platform.  OS,
version, which version of MySQL, etc.

 Please help if you can and thanks in advance!
 
 
 Judith Buff
 Computer System Manager/WebCT Admin
 Texas AM University at Galveston
 200 Seawolf Parkway
 Galveston, Texas 77553
 Ph: 409-740-4961
 Fax: 409 740-4450

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA BSD admin/developer at large

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



Re: Unexpected ending

2002-12-10 Thread Brian Reichert
On Tue, Dec 10, 2002 at 01:28:13PM -0500, Lefevre, Steven wrote:
 Hey folks -
 
 Linux newbie here.
 
 I have RH 8.0 installed on a machine. I did an RPM installation of MySQL
 3.23 (or whatever the current 3 series is).
 
 When I try to start the safe daemon, I get this:
 
 [root@server ]# /usr/bin/safe_mysqld
 Starting mysqld daemon with databases from /var/lib/mysql
 021210 13:26:51  mysqld ended

'safe_mysqld' blows, it hides information.  Try running mysqld more
directly.

Step 1: edit safe_mysqld to make it tell you what it's trying to
do.  Edit the very first line to look like this:

  #!/bin/sh -x

Step 2: re-run safe_mysqld, it will now dump out each command as
it runs it.  The last thing you see will be the full invokation of
mysqld, with all the arguments and all of that.

Step 3: run that actual invocation of mysqld, with all of it's
arguments, without redirecting the output anywhere.  This is, to
say, avoid this at the end:

   $err_log 21

Now, when mysqld pukes at you, you'll actually see error messages.

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: MySQL on virtual hosting

2002-11-25 Thread Brian Reichert
(This is a forward of some private mail with the original poster,
with his permission.)

Date: Sun, 24 Nov 2002 22:59:33 -0500
From: Brian Reichert [EMAIL PROTECTED]
To: Sweethome.co.il Webmaster [EMAIL PROTECTED]
Cc: Brian Reichert [EMAIL PROTECTED]
Subject: Re: MySQL on virtual hosting

On Mon, Nov 25, 2002 at 03:15:00AM +0200, Sweethome.co.il Webmaster wrote:
 The Virtual dedicated systems will need much more resources in real life.
 I can't imagine having 40 MySQL servers running at once when I can't 
 restrain a single one :)

You can constrain a single one, very easily:

  # nice limits -d whatever -m whatever /usr/local/mysql/libexec/mysqld 

Of course, you may not want the jail methodology in general; I'm
not trying to trick you into it, by any means.

If you're virtual hosting, there is the implication that you have
more than one customer on a single system, say, forty of them.

You have at least two options:

- You can let all forty clients (with all of their myriad users,
  sets of users, etc.) talk to a single MySQL daemon.

  You have the ease of no clever engineering to get the to all use
  this daemon, but you now have the task of accounting for their
  usage, and constraining them individually.

- You can give each client their own separate MySQL daemon.

  You have the overhead of each MySQL daemon process consuming some
  OS resources, but now you have the freedom to almost completely
  manage the resources of any one of these daemons.

Plus, you get to deal with the extra hassles of:

- Isolating which clients want binary replication: those logs each
  eat up diskspace, and client's shouldn't unduly impair each other's
  backups.

- What if one client make a request that makes MySQL spin?  That'll
  impair everyone else's ability to process queries.

- What if someone needs the ability to use DATAFILES under MySQL?
  Now you get to juggle who gets read/write permission to the same
  directories that the MySQL does...

If you generalize this work above to other services, such as mail
servers, web servers, etc., you'll see that you're re-solving the
same kind of problem, over and over again.  And when you try to
worry about how much bandwidth each of these services is really
consuming, one tends to migrate to virtual machines as a more
complete, general solution.

No matter how you cut it, you'll still have forty clients (humans,
not mysql clients; each might be dozens of connections) wanting to
interact with your daemon(s).  Either your machine has the gnads
to handle that, or it doesn't.

My desktop is a dual-CPU box, with 1.5G of memory.  An idle instance
of MySQL looks like this:

  natto% ps auxwwe -p 196
  USERPID %CPU %MEM   VSZ  RSS  TT  STAT STARTED  TIME COMMAND
  mysql   196  0.0  1.0 11896 10728 con- S29Oct02 5023:13.08
   /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql
   --datadir=/usr/local/mysql/var --user=mysql
   --pid-file=/usr/local/mysql/var/natto.numachi.com.pid

Having forty MySQL daemons, unto itself, doesn't cost the OS very
much at all.

But I _do_ think that for manageability, accounting, 'fairness' to
your other clients, that there's a lot to said for sandboxing them
as completely as possible.  Using a jail gets you all they down to
network traffic.

If nothing else, you can learn who the 'piggy' clients are, and
decide to migrate them to another box, where they have more room...

Have fun. :)

 
  Justin
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: MySQL on virtual hosting

2002-11-24 Thread Brian Reichert
On Sun, Nov 24, 2002 at 10:39:43PM +0200, Sweethome.co.il Webmaster wrote:
 Dear list,
 
 Does any of you guys operate a mysql server in virtual hosting environment?
 I need some advice on tuning and restriction based on system resources.

One thing you need to nail down is what the abstraction is: _how_
do you want to implement virtual hosting?

For example, under FreeBSD, you can create a jail(8): a complete
virtual machine tied to an IP address, and you can cram one of your
(human) clients in there, with all of their services.

(Before you worry about consuming all of your public IPs for such
tricks, note that you can run them on private IPs, and use the
kernel's ability to NAT connections in/out of the box to these
virtual machines.)

That technically eats more resources than other virtual hosting
methods, but it most completely isolates a user from the rest of
the system, if you need fine-grained control over how your machine's
getting utilized, this gets you down to the nuts and bolts.

The kernel itself will let you play tricks for traffic shaping, so
you can constrain which of your virtual machines get traffic
'appropriately', and you can packet-filter everything to death, so
that you can prevent them from running services that you don't want.

This is somewhat distinct from the excellent question you ask, and
I'm curious what various people's responses will be...

 Thanks for all answers,
 
   Justin Grindea  
   [EMAIL PROTECTED]

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: information about the tables in the database

2002-10-09 Thread Brian Reichert

On Wed, Oct 09, 2002 at 03:43:15PM +0200, Inbal Ovadia wrote:
 Hi all,
 There is a way to know if I have table x in my db?
 Let's say some catalog tables that hold information about the db like tables
 name etc.
 and i can do query like select tables from catalogName and get all the
 tables in the db

'show tables'

 
 thanks :)
 Inbal
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: MySQL as a desktop DB

2002-09-24 Thread Brian Reichert

On Tue, Sep 24, 2002 at 10:41:26PM +0100, Adam Parker wrote:
 I currently use MS Access as a single-user desktop database. The database is
 getting quite large. The largest table has 300,000 rows.
 
 I am considering upgrading the database. How suitable is MySQL as a
 single-user desktop database? How does it compare to Access when it is used
 like this?

I regularly use MySQL on my desktop.  Under UNIX, at least, there
are all sort of useful utilities that like to hook in.

 But is it faster than Access in the
 single-user environment, when dealing with large databases?

I have no input, I'm sorry.  I don't use M$ on my desktop.

 
 Thanks for any help.
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Fw: Query to update column length

2002-09-24 Thread Brian Reichert

On Tue, Sep 24, 2002 at 05:56:23PM -0400, Shaun Bramley wrote:
 Hi all,
 
 I am writing an application that requires my application to possibly update
 the length of a char field while data is being imported into the db.  First,
 can I update the size/type of a column using  UPDATE?  Would someone be
 willing to give me an example?

I beleive 'UPDATE' updates records within a table, and 'ALTER TABLE'
affects the characteristics of the table itself.

 thank you
 
 Shaun
 
 filter:  mysql

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Perl DBI Interfacer

2002-09-21 Thread Brian Reichert

On Sat, Sep 21, 2002 at 02:06:01AM -0500, Kevin wrote:
 Hello, I was wondering if anyone knows PERL  DBI, if so please respond to 
[EMAIL PROTECTED] personally, or to the list
 
 
 My question is, I'm trying to build a 'custom' querier for a survey program... based 
on the information submitted, the program will generate an SQL Query statement. The 
command that my program works absolutely find if I copy/paste it into MySQL, however, 
DBI won't pass it... if I pass the QUERY Along to DBI typed in manually it works...

I'm not in the mood to unpeel this code, just to see output.

As I'm curious, could you set the DBI trace (to 2 or better), run
your query, and show us the logs?  That we can see what DBI is
getting, and what it's actually complaining about (since you didn't
tell us...)

 Thanks
 Kevin

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: aggregate functions producing bad data

2002-09-17 Thread Brian Reichert

On Tue, Sep 17, 2002 at 11:59:42AM -0700, Richard Unger wrote:
 My query:
 
 SELECT 
   count(id), 
   count( IF(call_end - call_start  5, id, NULL) ), 
   count( IF(call_end - call_start = 5, id, NULL) )
 FROM 
   t_calllog_calls;
 
 My result:
 
 1994
 1956
 35
 
 However, 1956 + 35 != 1994.
 
 Running MySQL 3.23.49-nt

One thing I'd check:  what happens if t_calllog_calls.id is NULL?

 Cheers,
 Rich

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: To share with MySql friends in net?

2002-08-21 Thread Brian Reichert

On Wed, Aug 21, 2002 at 12:30:02PM -0300, Ray da Costa wrote:
 Oi, for gentility!  
 
 Could inform which the procedure to share the MySql that is in my machine
 with the escritorio friends.  

I may be misunderstanding you.

If you have a MySQL database on your machine, and you want other people,
from other machines, to access it, you need to:

- make sure that MySQL is allowing network connentions (_don't_ use
  --skip-networking)

- create users (with or without passwords), and describe which hosts
  that can connect from.  See:

  http://www.mysql.com/doc/en/Connection_access.html

Hope this helps...

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: return row count from show processlist

2002-07-31 Thread Brian Reichert

On Tue, Jul 30, 2002 at 12:31:32PM -0400, Chris Friedline wrote:
 hello everyone,
 
 i'm a newbie so please excuse the probably dumb question.  
 
 i'm using monitoring software to record the number of processes at a current
 time.  currently, i'm just sending a show processlist and my monitoring
 software returns something like this:

Fix your monitoring software.

The SQL query 'show processlist' is just that; an SQL query.  The
MySQL API (either directly used, or used via the perl DBI module,
or the like) will let you get a _ton_ of information about the query
you've made, including the names of the columns, the number of rows,
etc.

 thanks very much, in advance.
 chris

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: a newserver would be better than this mailing list

2002-07-30 Thread Brian Reichert

On Tue, Jul 30, 2002 at 11:11:34AM +0200, Bart Burkhardt wrote:
 hello list,
 
 i think it would be better to have a mysql news server instead of this email
 list. i will name some reasons that i think of, correct me if i am wrong..
 
 - with a newsgroup you only select the messages that you want to read or
 where you can give an answer on.

You can only 'select' the message once you have knowledge about
what's in the headers.

 - with this email list my mailbox fills with too many single messages,
 replys are not threaded (no plus sign to expand thread)

I'm using a MUA called 'mutt' that _does_ support message threads.
Email and news messages use the same header information to encode
that.

 - when i go on vacation, and return, i would have a mailbox that is flooded
 causing that my other messages could not be delivered.
 
 - using a newsgroup server is less waste of cyberspace because it is
 centrally located

Not really; a single message is relentlessly copied to thousands
of hosts all over the world.

 - a mysql newsserver could seperate different subjects like; installation /
 advanced query / communication / bugreport / announcements / ideas /
 platform sections..
 
 -  there are probably more reasons to setup a newsserver

Having configured private email and news servers before:

- Regardless of one's editorial decision to differentiate lists/groups,
  people will cross-post, or otherwise not post appropriately, and,
  without facist moderation, the lists/groups will essentially blur
  into one.

- As I mentioned above, there is no distinction between an email
  message and a news message WRT to threading; just get a client
  that supports the feature.

- If you're interested in a private news server (one wherein the
  groups aren't part of Usenet), then perhaps the only 'feature' you
  gain is from your news client saying 'get me messages newer than
  such-and-such a date'.

  It's often easier to read an on-line archive of the list via a
  web browser; if nothing else, most graphical browsers present
  'new' (uncached) links in a different color than ones that are
  previously viewed...

But I concede the usefulness of a mailing list digest.

 
 Bart
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Jon Frisby---MySQL help needed

2002-07-29 Thread Brian Reichert

On Mon, Jul 29, 2002 at 01:13:30PM -0400, Aamer Rauf wrote:
 Hi Jon,
 Whatever you have suggested so far hasn't worked. I thought that maybe something 
 is missing in my stating the problem and implementing your suggested solutions.
 So here is a more expanded picture of the queries:
 
 $sth=$dbh-prepare(INSERT INTO TABLE1 (id,var1,var2) VALUES (?,?,?));
 $sth-execute(,$var1,$var2);
 $sth=$dbh-prepare(SELECT \@t1id:=LAST_INSERT_ID());
 $sth-execute();
 
 $sth=$dbh-prepare(INSERT INTO TABLE1A (Aid,id,var1) VALUES (?, @t1id, $var1);
 $sth-execute(,,$var1);

Doesn't this chain of events reuse the variable $sth, which essentially
closes the old statement handler?  Doesn't that lose state?  I'm
guessing...

 Please take a note that in the last prepare statement I have also tried \@t1id 
 ,\@t1id, LAST_INSERT_ID(). I have used these in 'execute' statement too with 
 question marks (?) in the prepare statement.
 
 Any new idea please?

Try grabbing the new ID manually, before the second prepare:

  my $id = $dbh-{'mysql_insertid'};

Then, manually use that as a bind variable.
  
 Thanks,
 Aamer

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: auto_increment

2002-07-15 Thread Brian Reichert

On Sun, Jul 14, 2002 at 07:21:59PM +0200, Raymond Hamaker wrote:
 Hi all,
 
 When i use MS access 2000 with odbc to fill my MySQL db(running on linux)
 auto_increment seems not to work .

Does not seem to work doesn't help us help you.

What did you try to do?

What did you expect to happen?

What did happen?

 Is that normal?
 Or am i missing something?
 
 TIA
 
 Raymond

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Separate List For administration

2002-06-20 Thread Brian Reichert

On Wed, Jun 19, 2002 at 04:27:59PM -0400, Nilesh Shah wrote:
 MySQL Team,
 
 Can we have separate list for  MySQL administration and replication?.

You can start any mailing you'd like; no one's stopping you.

 I am sure there are lots of people here are only interested in Advance
 things in mysql.
 
 This is very general list.

You're welcome to take any steps you want in moderating any mailing
list you start up, to prevent it from becoming too general.

 Any one agrees with me?.

In gernal, I do. :)

 
 Nilesh
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: mysql.pm and the mysql root password

2002-03-25 Thread Brian Reichert

On Mon, Mar 25, 2002 at 06:12:26PM -0800, daniel wrote:
 so how do you install mysql.pm once you've got a password on mysql?

The DBI module will make use of the DBI_PASS environemnt variable;
maybe that'll help:

  env DBI_PASS=mySQLpass perl -MCPAN -e shell

Failing that; edit the 'make test' script.

Good luck...

 _
 daniel a. g. quinn
 starving programmer
 
 war does not determine who is right -- only who is left.
  - bertrand russell

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Access denied on use mysql;

2002-03-22 Thread Brian Reichert

On Thu, Mar 21, 2002 at 08:13:16PM -0500, alan4100 wrote:
 mysql
 
 Hi Colin,
 
 I wish I can be able to live chat with you, but because of my hearing impaired...it 
would not be possible..But what is the real problem?  A few days ago I got assistance 
 from others  on my Mysql problem. It has been fixed and everything works fine.

I _think_, when he said 'live chat', that he meant an IRC channel.
'Internet Relay Chat'.  Just lots of typing. :)

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Create database if does not exist.

2002-03-13 Thread Brian Reichert

On Wed, Mar 13, 2002 at 09:40:44AM -0800, Radhakrishna Mohan Tadepalli wrote:
 I want to create a database test_db1, if test_db1 does not exist in the
 server using sql script. Is it possible?

From http://mysql.com/doc/C/R/CREATE_DATABASE.html

  6.5.1 CREATE DATABASE Syntax

  CREATE DATABASE [IF NOT EXISTS] db_name

  CREATE DATABASE creates a database with the given name. Rules
  for allowable database names are given in section 6.1.2 Database,
  Table, Index, Column, and Alias Names. An error occurs if the
  database already exists and you didn't specify IF NOT EXISTS.

Did you even check the on-line manual?

 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: mysql under FreeBSD 4.5

2002-02-23 Thread Brian Reichert

On Fri, Feb 22, 2002 at 12:10:52AM -0700, [EMAIL PROTECTED] wrote:
 Just recently installed FreeBSD 4.5-RELEASE and cvsup'd to latest
 4-STABLE. Updated ports tree and did a make install in
 /usr/ports/databases/mysql323-server and received the following on the
 mysql_install_db part:

I have not tried to install MySQL under 4.5-RELEASE yet, but, in
the past, I've never failed to build MySQL from source under FreeBSD.

What is the port accomplishing?  Maybe you could trying installing
MySQL from source.

Merely a suggestion; I realize this doesn't answer your question,
though...

 /usr/local/bin/mysql_install_db
 Preparing db table
 Preparing host table
 Preparing user table
 Preparing func table
 Preparing tables_priv table
 Preparing columns_priv table
 Installing all prepared tables
 Fatal error 'Can't create gc thread' at line ? in file
 /usr/src/lib/libc_r/uthread/uthread
 _create.c (errno = ?)
 Abort trap - core dumped
 Installation of grant tables failed!

Hmm, one problem I _did_ have, way back when: MySQL's makefiles
try to use '-O6' as a compiler flag.  Try setting that to something
sane like '-O2'.

From source, I was doing this (to prevent segfaults under 4.1-RELEASE):

   env CC=gcc CFLAGS=-O2 CXX=gcc \
 CXXFLAGS=-O2 -felide-constructors -fno-exceptions -fno-rtti \
   ./configure \
   --disable-shared \
   --enable-assembler \
   --enable-large-files \
  --without-debug

Good luck...

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Need help please!

2002-02-14 Thread Brian Reichert

On Thu, Feb 14, 2002 at 01:05:24PM -0500, Richard C Rossy wrote:
  
 Ok I can't seem to get this. Now is it possible to have MySQL on a other
 computer and run the script.
 In other words  the perl script is on foo.com and MySQL database is on
 foo2.com. What is need to make the script work. What I have in the
 script is:

Have you actually read the perl docs for DBI?

   DBI Class Methods

   ...

   connect

 $dbh = DBI-connect($data_source, $username, $password)
   or die $DBI::errstr;

   ...

   Examples of $data_source values are:

 dbi:DriverName:database_name
 dbi:DriverName:database_name@hostname:port
 dbi:DriverName:database=database_name;host=hostname;port=port

   There is no standard for the text following the driver
   name. Each driver is free to use whatever syntax it
   wants.

So - compare the documentation with what your effort was, and note
the difference:

 $dbh = DBI-connect(DBI:mysql:$mysqldatabase,
 $mysqlhost,$mysqlusername, $mysqlpassword) || die(Couldn't
 connect to database!\n);

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: HELP: cannot connect to MySQL server

2002-02-14 Thread Brian Reichert

On Thu, Feb 14, 2002 at 03:41:32PM -0800, wally liau wrote:
 Dear MySql experts: 
 
 we have mysql and mm driver installed on a unix
 server, but when I try to run Blob (in testsuite/), it
 gives error message: 
 
 cannot connect to MySQL server on //localhost:3306

Can you, at this point, connect to the server via the 'mysql' binary?

- Is there a server running on this machine?

- Is there a server running on this machine at port 3306?

- Is there a server running on this machine at port 3306 that lets
  user 'test' coonect with the password 'test'?

 our system admininstor doesn't seem to know what's
 going wrong (that's why I'm looking for help from
 mysql community). 

I'm sorry. :/

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Re: Access denied to apache@localhost

2002-02-13 Thread Brian Reichert

On Wed, Feb 13, 2002 at 12:04:22AM +0100, [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

Should I just put these words into my signature, just so I can
contribute to the mailing list?

 If you just reply to this message, and include the entire text of it in the
 reply, your reply will go through. However, you should
 first review the text of the message to make sure it has something to do
 with MySQL. Just typing the word MySQL once will be sufficient, for example.
 
 You have written the following:
 
 On Sun, Feb 10, 2002 at 11:58:12AM +0100, Nick Wilson wrote:
  Hi all
  I've just set up and the latest problem I have getting started is that
  'Access denied for user: apache@localhost' msg.
  
  How can I put that right?
 
 Either
 
   a) grant appropriate priveleges to the user in question, or
   b) tell the invoking code to use a user ID with appropriate priveleges.
 
 It obviously depends on what problem you're atcually trying to solve...
 
  -- 
  
  Nick Wilson
  
  Tel:+45 3325 0688
  Fax:+45 3325 0677
  Web:www.explodingnet.com
 
 -- 
 Brian 'you Bastard' Reichert  [EMAIL PROTECTED]
 37 Crystal Ave. #303  Daytime number: (603) 434-6842
 Derry NH 03038-1713 USA   Intel architecture: the left-hand path
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Re: How to duplicate a table complete with indexes? #

2002-02-12 Thread Brian Reichert

On Fri, Feb 08, 2002 at 09:09:39PM +0100, [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

This 'anti-spam' measure, is kinda lame, I must say.  (Picture that
said in an Ed Grimley voice.  If you understand _that_, shame on
you! :)

 If you just reply to this message, and include the entire text of it in the
 reply, your reply will go through. However, you should
 first review the text of the message to make sure it has something to do
 with MySQL. Just typing the word MySQL once will be sufficient, for example.
 
 You have written the following:
 
 On Fri, Feb 08, 2002 at 01:22:08PM -0600, BD wrote:
  This works fine except it doesn't create any indexes that OldTable had. Is
  there a generic way to duplicate a table that includes the indexes? I don't 
  want to have to manually create indexes for it.
 
 What's wrong with outright copying the files associated with the
 table?  (Assuming the table's not in use).  I would _assume_ that
 this would work; i havent' tested it, of course...
 
  TIA
  
  Brent
 
 -- 
 Brian 'you Bastard' Reichert  [EMAIL PROTECTED]
 37 Crystal Ave. #303  Daytime number: (603) 434-6842
 Derry NH 03038-1713 USA   Intel architecture: the left-hand path
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Re: How to duplicate a table complete with indexes? #

2002-02-08 Thread Brian Reichert

On Fri, Feb 08, 2002 at 09:09:39PM +0100, [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

This 'anti-spam' measure, is kinda lame, I must say.  (Picture that
said in an Ed Grimley voice.  If you understand _that_, shame on
you! :)

 If you just reply to this message, and include the entire text of it in the
 reply, your reply will go through. However, you should
 first review the text of the message to make sure it has something to do
 with MySQL. Just typing the word MySQL once will be sufficient, for example.
 
 You have written the following:
 
 On Fri, Feb 08, 2002 at 01:22:08PM -0600, BD wrote:
  This works fine except it doesn't create any indexes that OldTable had. Is
  there a generic way to duplicate a table that includes the indexes? I don't 
  want to have to manually create indexes for it.
 
 What's wrong with outright copying the files associated with the
 table?  (Assuming the table's not in use).  I would _assume_ that
 this would work; i havent' tested it, of course...
 
  TIA
  
  Brent
 
 -- 
 Brian 'you Bastard' Reichert  [EMAIL PROTECTED]
 37 Crystal Ave. #303  Daytime number: (603) 434-6842
 Derry NH 03038-1713 USA   Intel architecture: the left-hand path
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: mysqld with daemontools

2002-01-30 Thread Brian Reichert

On Wed, Jan 30, 2002 at 01:31:53PM +0900, Tatsuhiko Miyagawa wrote:
 Has anybody out there experienced with mysqld running on
 daemontools?

Yes.

 We're now testing this combination on our staging server without
 any problem, but if you can suggest any problem for it  or
 anything, it would be appreciated.
 
 * Environment
 mysql 3.23.47 FreeBSD 4.4R

I've done it under FreeBSD 4.2.

   % cat /service/mysqld/run
   #!/bin/sh
   
   PATH=/usr/local/bin:/usr/bin:/bin
   export PATH
   
   exec env - PATH=$PATH /usr/local/mysql/libexec/mysqld 21

I have a whole pile of scripts for mysqld itself, logging, and a
control script for starting/stopping mysql.  What do you need?

 --
 Tatsuhiko Miyagawa [EMAIL PROTECTED]

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Test Case (Urgent)

2002-01-11 Thread Brian Reichert

On Fri, Jan 11, 2002 at 04:48:18PM +0530, Manish Mehta wrote:
 Hi,
 
 I am new to test case design in Database.
 
 I wants to know Basically how to calculate the Maximum Database. 

A database can consist of several tables.  Each table is stored
(essentially) as a file.  The size of a that file depends on a)
your operating system, and b) which table type you use.  See the
list's archives for some specific numbers.

 When we have to take backup.?

What do you mean by 'backup'?

Copying the database's files directly to tape?  That depends on
your computer's disk subsystem, and what you're writing them to.

'Dumping' the database to a file?  That also depends on your
computer's disk subsystem, and might also be limited to your CPU
and how much physical memory you have.

 What are steps to be flow please tell me.

The 'best' thing to do, for whatever methods your speaking of, is:

1) install MySQL on the hardware where all of this would take place;
   the software is freely available.
2) create a database and a table, and try to fill it; shouldn't
   take more than a couple of hours, assuming you're willing to
   cobble a script together.
3) try to back up the database you just created.

Honestly, your own experiments will give you the most concrete
numbers, given the hardware and methods you have...

 Thanks in advance.
 
 Manish Mehta
 E-mail: [EMAIL PROTECTED]
-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Location of databases

2002-01-08 Thread Brian Reichert

On Tue, Jan 08, 2002 at 10:04:40AM -0500, Michael D. Stackhouse wrote:
 We run MySql on our Freebsd server, and on our Win2K server.
 
 We have several clients, and would like to store the databases in the
 clients' root directory.  Is this possible?

Under UNIX, all of the separate databases exist as a unique
subdirectory under a directory; see references to DATADIR in the
documentation.  Any one database's tables exists as separate files
within the respective database directory.

You can physically relocate a database directory to wherever you
want, as long as you maintain a symlink to it from the DATADIR.

Bear in mind that the MySQL engine will be running as a specific
UID, and that UID will need read/write permission for the database's
new home...

 
 Thanks!
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: hey folks!

2002-01-07 Thread Brian Reichert

On Mon, Jan 07, 2002 at 03:52:10PM -0800, Viorel C wrote:
 I'm a newbie in DB administration. Could somebody tell me what do I need to
 start a web-based project for book listing, mail lists etc, all retrieved
 from a database updated by LAN users and listed on a web page?

Go for www.freshmeat.net, and look for pre-built stuff.  Telling
you 'what you need', with no information, is an excercise in
futility...

Good luck.

 Thanks in advance!
 
 Viorel C

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: killed by SIGSEGV

2001-12-04 Thread Brian Reichert

On Tue, Dec 04, 2001 at 04:40:23PM +, matt wrote:
 Some paths:  /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
 GCC: Reading specs from
 /usr/lib/gcc-lib/i686-pc-linux-gnu/2.95.2/specs
 gcc version 2.95.2 19991024 (release)
 Compilation info: CC='gcc'  CFLAGS=''  CXX='c++'  CXXFLAGS=''

Something that was affecting me adversely in the past:  I _think_
MySQL is built with '-O6', as a compiler flag, and using anything
more that '-O2' with g++ can introduce buggy code.  Ater least, I
ran into this under FreeBSD 3.4, running gcc version 2.7.2.3.

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Bug, mySQL keeps crashing.

2001-10-02 Thread Brian Reichert

On Mon, Oct 01, 2001 at 04:41:58PM -0600, Spinlock wrote:
 I was using gcc not g++

The guts of MySQL are written in C++, and hence the Gnu C++ compiler
will be used:

From the manpage gcc(1):

  DESCRIPTION
   The C and C++  compilers  are  integrated.   Both  process
   input  files  through  one or more of four stages: prepro-
   cessing, compilation, assembly, and linking.  Source file-
   name suffixes identify the source language, but which name
   you use for the compiler governs default assumptions:

   gccassumes preprocessed (.i) files are C and assumes C
  style linking.

   g++assumes preprocessed (.i) files are C++ and assumes
  C++ style linking.

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Bug, mySQL keeps crashing.

2001-10-01 Thread Brian Reichert

On Thu, Sep 27, 2001 at 07:19:02PM -0600, Spinlock wrote:
 Hello. I am running mySQL 3.23.42 on FreeBSD 4.2.
 
 I have compiled it with InnoDB and full debug to help figure out why it
 keeps crashing. I've done a few core dumps and I'll paste 3 of them, it
 keeps on crashing in the same function all the time.
 
 The configure flags I used are:
 
 env CFLAGS=-O3 -mpentiumpro CXX=gcc CXXFLAGS=-O3 -mpentiumpro
 -felide-constructors -fno-exceptions -fno-rtti ./configure
 --prefix=/usr/local/mysql --with-debug --with-innodb
 
 Please advise what to do.

Using '-O3' is not advisable with the g++ compiler family.  Try
reconfiguring with just '-O'.

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: site admin and log script needed

2001-09-26 Thread Brian Reichert

On Thu, Sep 27, 2001 at 07:43:30AM +1000, mike wrote:
 Hi All,
 
 I have built a PHP database driven website and am now looking for a good
 script that I can place on the server to track visits to the site. I
 want to
 place all the info in a mySQL database and be able to view the results
 on
 the web. Can anyone point me to a good script for this purpose. I would
 like
 to record hits to the site but not necessarily display the number on the
 website files.

This doesn't sound like a MySQL question.  Are you asking about
analyzing your web access logs?

 
 TIA

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




replication issue with FreeBSD 4.2-RELEASE

2001-07-18 Thread Brian Reichert

I'm exploring mysql replication under FreeBSD 4.2-RELEASE.

Two machines, named 'master' and 'slave', each running FreeBSD
4.2-RELEASE and MySQL 3.23.36-debug.

I've followed the instructions at

  http://www.mysql.com/doc/R/e/Replication_HOWTO.html

All very straight forward.

When I spin everything up, I see these errors on the slave server:

  /usr/local/libexec/mysqld: ready for connections

  010718 19:28:17  Slave: connected to master '[EMAIL PROTECTED]:3306',
  replication started in log 'FIRST' at position 4

  010718 19:29:22  Error reading packet from server: Lost connection
  to MySQL server during query (read_errno 35,server_errno=2013)

  010718 19:29:22  Slave: Failed reading log event, reconnecting
  to retry, log 'master-bin.001' position 803

  010718 19:29:22  Slave: reconnected to master
  '[EMAIL PROTECTED]:3306',replication resumed in log 'master-bin.001'
  at position 803

And the last two errors just keep repeating.  I can otherwise
connect just fine:

  slave% mysql -u repl -prepl -h master.xxx.xxx
  Welcome to the MySQL monitor.  Commands end with ; or \g.
  Your MySQL connection id is 58 to server version: 3.23.36-debug-log
  
  Type 'help;' or '\h' for help. Type '\c' to clear the buffer
  
  mysql quit
  Bye

I presume 'read_errno 35' refers to:

   35 EAGAIN Resource temporarily unavailable. This is a
   temporary condition and later calls to the same routine may
   complete normally.

Does anyone have any insight?  Funky hardware?  The list has mentioned 
4.2-RELEASE having threading problems, fixed in 4.3.  Might this be the
case?  I don't want to have to upgrade the OS, out-of-hand.

Upgrade the version of MySQL on the master a/o slave?  I see some
changes WRT replication:

  F.2.1 Changes in release 3.23.40
   
 Added slave_wait_timeout for replication. 

  F.2.3 Changes in release 3.23.38

 Better error message when slave max_allowed_packet is too low
 to read a very long log event from the master.

  F.2.4 Changes in release 3.23.37

 Fixed bug that erroneously logged a drop of internal temporary
 table on thread termination to the binary log - bug affected
 replication.

Would any of these apply to the errors I'm seeing?

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: MySQL loves FreeBSD (but not NetBSD) ...

2001-07-18 Thread Brian Reichert

On Tue, Jul 17, 2001 at 10:05:24PM -0400, Haapanen, Tom wrote:
 ... or should that be FreeBSD loves MySQL?
 
 I finally caved in after a year of increasing (and unexplained) MySQL
 crashes, despite numerous updates to more recent versions of NetBSD and
 MySQL, and dozens of experiments with different configuration options.
 MySQL would die (and restart automatically) every 5-15 minutes on the
 database server acting as the back end for our web site, motorsport.com.
 (This on NetBSD/i386, as when we started, MySQL was distinctly unhappy with
 NetBSD/Alpha)

FWIW - I had nasty problems with stable builds under FreeBSD, until
I noticed the build process was trying to make use of '-O6' when
compiling C++ code using GCC 2.95.2 ; not a good combination.

When I switched to using

  env CC=gcc CFLAGS=-O2 CXX=gcc \
 CXXFLAGS=-O2 -felide-constructors -fno-exceptions -fno-rtti \
  ./configure ...

To configure, the binary was much more stable.  (This is as of
mysql-3.23.35.)  Maybe that was a similar issue under NetBSD...

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Replication

2001-07-13 Thread Brian Reichert

On Thu, Jul 12, 2001 at 03:49:12PM -0700, Jeff Philapy wrote:
 It is hard to say where I am confused because the
 HOWTO requires me to try and follow it as I setup
 replication. So let me try and follow the
 documentation and if I see anything that can make it
 more clear then I will let you know. One thing that
 does come to mind though is maybe adding something
 that helps users to understand the process a little
 more clearly in advance without having to try and
 follow the documentation first. I don't know what you
 would put for that.
 
 I do have one question though, where is the my.cnf
 located? I ran locate my.cnf and it returned no
 results.

There may not be one at all.  All of the directives in my.conf can
be supplied on the command line to mysqld.  I prefer to avoind
my.cnf for a variety of reasons, not the last of which is that I
can, from 'ps', see pretty much everything I need to know about
the daemon.

Note the last three of these lines.  I've censored some sensitive
information, but the rest show you what you might need WRT supplying
stuff on the command line.  (I may not have all of this correct,
BTW.  I'm still exploring replication myself.)

  slave1# ps auxwwe -p `cat /var/mysqld/db/mysqld.pid`
  USER PID %CPU %MEM   VSZ  RSS  TT  STAT STARTED  TIME COMMAND
  mysqld 61562  0.0  0.2 11220 1768  p0- S22Jun01   4:22.20
  MYSQL_TCP_PORT=3306 log_dir=/var/mysqld/log
  TMPDIR=/var/tmp PATH=/usr/local/bin:/usr/bin:/bin:/usr/sbin
  MYSQLD_DB=/var/mysqld/db UMASK=0644 DBI_HOST=localhost
  MYSQL_BASE_DIR=/usr/local PWD=/var/mysqld/supervise UMASK_DIR=0777
  /usr/local/libexec/mysqld --language=/usr/local/share/mysql/english
  --port=3306 --pid-file=/var/mysqld/db/mysqld.pid --datadir=/var/mysqld/db
  --basedir=/var/mysqld/db/mysql --tmpdir=/var/tmp --exit-info
  --set-variable=max_connections=1000 --master-host=*
  --master-user=repl --master-password=** --server-id=2
  --log-slave-updates --log-bin=/var/mysqld/log/slave1-bin
  --log-update=/var/mysqld/log/slave1

But, as to your original question: see

  http://www.mysql.com/doc/O/p/Option_files.html

For a description of possible locations for my.cnf.

 Thanks,
 Jeff

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: out of memory

2001-07-10 Thread Brian Reichert

On Mon, Jul 09, 2001 at 08:14:24PM -0600, David Keeney wrote:
 dies (during the execute statement) with the error :
 
 Out of Memory: Killed process 31666 (temp.pl).
 Killed

Look for 'SQL_BIG_TABLES' in the Docs...

`SQL_BIG_TABLES = 0 | 1'
 If set to `1', all temporary tables are stored on disk rather than
 in memory.  This will be a little slower, but you will not get the
 error `The table tbl_name is full' for big `SELECT' operations that
 require a large temporary table.  The default value for a new
 connection is `0' (i.e., use in-memory temporary tables).

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: help meeeeeeeee

2001-07-07 Thread Brian Reichert

On Wed, Jul 04, 2001 at 12:01:19AM -0500, ryc wrote:
 It sounds like you are asking for comments reguarding your choice of
 vb/mysql... If that is the case, sure it can be done. The only problem I can
 see if you plan on having end users use this program, they would have to
 install and configure Mysql on their computers. This might be a bit of a
 burdon for them. But that is for you to decide.

Not strictly true, without more details; the M$ clients could be
talking to a centralized MySQL server via ODBC.

 The list can offer more advice if you ask more specific questions.
 
 ryan

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




replication doesn't maintain logs?

2001-06-21 Thread Brian Reichert

I hope I've merely misread instructions.

I've successfully set up replication, a master to one slave.

However, even though the slave was comfigured to maintain both a
'classic' update log, as well as a binary log, none of the stuff
it's replicating are reflected in the logs.  Said logs are created:

  slave1# ls -ld *
  -rw-r--r--  1 mysqld  mysqld   73 Jun 18 18:53 slave1-bin.001
  -rw-r--r--  1 mysqld  mysqld   31 Jun 18 18:53 slave1-bin.index
  -rw-r--r--  1 mysqld  mysqld   69 Jun 18 18:53 slave1.001

But, this is after I imported an entire database via replication.

Does anyone have any advice? 

My environment:

  slave1# uname -r -s 
  FreeBSD 4.2-RELEASE

  slave1# /usr/local/libexec/mysqld -v
  /usr/local/libexec/mysqld  Ver 3.23.36 for unknown-freebsdelf4.2 on i386

  slave1# ps auxwwe -p `cat /var/mysqld/db/mysqld.pid`
  
  USER PID %CPU %MEM   VSZ  RSS  TT  STAT STARTED  TIME COMMAND
  mysqld 55910  0.0  2.5 26976 25644  p0  SMon06PM  26:31.02
  MYSQL_TCP_PORT=3306 OLDPWD=/var/mysqld log_dir=/var/mysqld/log
  TMPDIR=/var/tmp PATH=/usr/local/bin:/usr/bin:/bin:/usr/sbin
  MYSQLD_DB=/var/mysqld/db UMASK=0644 DBI_HOST=localhost
  MYSQL_BASE_DIR=/usr/local PWD=/var/mysqld/supervise UMASK_DIR=0777
  /usr/local/libexec/mysqld --language=/usr/local/share/mysql/english
  --port=3306 --pid-file=/var/mysqld/db/mysqld.pid
  --datadir=/var/mysqld/db --basedir=/var/mysqld/db/mysql
  --tmpdir=/var/tmp --exit-info --set-variable=max_connections=1000
  --master-host=bmdb1.ops.about.com --master-user=repl
  --master-password=* --server-id=2
  --log-bin=/var/mysqld/log/slave1-bin
  --log-update=/var/mysqld/log/slave1

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Re: replication doesn't maintain logs?

2001-06-21 Thread Brian Reichert

No, this isn't spam.  I was publicly thanking someone for advice given. :/

On Thu, Jun 21, 2001 at 08:25:37PM -, [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:
 
 database,sql,query,table
 
 If you just reply to this message, and include the entire text of it in the
 reply, your reply will go through. However, you should
 first review the text of the message to make sure it has something to do
 with MySQL. You have written the following:
 
 
 On Thu, Jun 21, 2001 at 08:53:31AM -0700, Ben Curtis wrote:
  
  You need to have log-slave-updates in my.cnf
 
 Ah!  Thanks for the pointer; let me try that out...
 
  -- 
  My pid is Inigo Montoya. You killed -9 my parent process. Prepare to vi.
 
 Cute .sig. :)
 
 -- 
 Brian 'you Bastard' Reichert  [EMAIL PROTECTED]
 37 Crystal Ave. #303  Daytime number: (603) 434-6842
 Derry NH 03038-1713 USA   Intel architecture: the left-hand path
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Problem building MyODBC 2.50.37 on BSD

2001-06-20 Thread Brian Reichert

On Wed, Jun 20, 2001 at 10:59:46AM -0500, Jeff Jirsa wrote:
 Hi, I'm having a problem building MyODBC 2.50.37 on BSD.
 When I run make after configure, I get the error:
 
 Makefile, line 315: Need an operator
 make: fatal errors encountered -- cannot continue

When I see this, my first assumption is the makefile author assumed
GNU make, rather than BSD make.  Install the 'gmake' package, for
a quick test..

 
 Line 315 contains:
 -include $(DEP_FILES)
 
 If I comment out 315 and run make again, I get:
 make: don't know how to make catalog.lo. Stop
 
 
 Please HELP!  I've compiled other projects using configure and have never
 seen this problem before.
 I am running FreeBSD 3.4 i386, MySQL v3.23.38 database, and unixODBC 2.0.7

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Can anyone help me.. for install on a Freebsd 4.2 box..

2001-04-20 Thread Brian Reichert

On Thu, Apr 19, 2001 at 11:37:14AM -0700, Larry Caragay wrote:
 Would anyone out there have the installation instruction for Mysql for a
 FreeBSD 4.2 box???

I've built it several times under FreeBSD 4.2.  WHat problem are
you seeing?

 Larry
 
 P.S. Thanks in advance...

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




OUTFILE ownership under mysqld 3.23.36-debug

2001-04-10 Thread Brian Reichert

Ok, this is confusing me.  Under FreeBSD 4.2 and MySQL 3.23.36-debug:

The mysqld process is not running as root, but as 'mysqld:mysqld'.

  bmdb2# ps -orgid,ruid,command -eww -p 46884
   RGID  RUID COMMAND
   6724  6724 MYSQL_TCP_PORT=3306 OLDPWD=/var/mysqld/db/mojo
  log_dir=/var/mysqld/log TMPDIR=/var/tmp
  PATH=/usr/local/bin:/usr/bin:/bin:/usr/sbin MYSQLD_DB=/var/mysqld/db
  UMASK=0644 DBI_HOST=localhost MYSQL_BASE_DIR=/usr/local
  PWD=/var/mysqld/supervise UMASK_DIR=0777 /usr/local/libexec/mysqld
  --language=/usr/local/share/mysql/english --port=3306
  --pid-file=/var/mysqld/db/mysqld.pid --datadir=/var/mysqld/db
  --basedir=/var/mysqld/db/mysql --tmpdir=/var/tmp --exit-info
  --set-variable=max_connections=1000 --log-update=/var/mysqld/log/bmdb2

The 'RGID RUID' is the real (as opposed to 'effective') GID and
UID of the process.  Then there's the environment.  Then the
arguments to the server itself.  (You may not that I'm not using
/etc/my.cnf to configure the server; I prefer to see the arguments.)

Also, the server was lauched outright as UID mysqld, so I'm not using
'--user'.

The user 'mysqld' has it's own group, and that's the only group it's in:

  bmdb2# id mysqld
  uid=6724(mysqld) gid=6724(mysqld) groups=6724(mysqld)

Yet, somehow, an SQL command such as this:

  select username from user limit 5 into outfile '/var/tmp/mysqld/sample';

creates a file with the 'wheel' group:

  bmdb2# ls -ld /var/tmp/mysqld/sample
  -rw-rw-rw-  1 mysqld  wheel  65 Apr 10 19:36 /var/tmp/mysqld/sample

I have no idea how a non-root process can set a different group
than it's own.

I can't find any suid/sgid code in the installed MySQL code.  Does
anyone have any insight on this?

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Mysql dbi modules

2001-03-02 Thread Brian Reichert

On Thu, Mar 01, 2001 at 10:58:03AM -0500, [EMAIL PROTECTED] wrote:
 HI,  I sent this note a couple days ago and no one has commented.  I am
 trying to implement DBI-1.14.tar.gz  Data-ShowTable-3.3.tar.gz
 Msql-Mysql-modules-1.2215.tar.gz .   The first two packages completed
 successfully byt the Mysql-modules failed druing the 'make test' step.I
 am using mysql version 3.23.32-log.  

 MySql is ruuning but the database is located at 'local/mysql' and the
 mysql.sock socket is present.   This is setup in /etc/my.cnf.

_Where_ is the socket?  Assuming you've done a 'make install' as
root, and you are running 'make test' as a mere mortal, do you
have read permissions on the full path to the socket?  (Remember
that you need read _and_ execute permissions on directories.)

You make it sound like you're using a relative path 'local/mysql'; that
doesn't sound right.  What _do_ you have in my.cnf?

(I, for one, _never_ use my.cnf.  In fact, I don't use safe_mysqld,
either; I run mysql, with a ton of command-line flags, directly
under a watchdog script.)

I don't know the details of how you set everything up, but it would
seem you managed to trick either the test scripts in
Msql-Mysql-modules-1.2215.tar.gz (which is possible), or you've
built/run MySQL itself in a confusing manner, such that safe_mysqld
is really running it with different paramaters than you've intended.

If you have read access to the socket, but the '10dsnlist' can't
tell it there, then perhaps the test script is making a bad guess.
You can tell MySQL clients to look for the socket via an environemnt
variable:

  section A Environment variables:

  MYSQL_UNIX_PORT The default socket; used for connections to localhost.

Maybe that'll help...

 
 Any help would be appreciated,
 
  TIA   
 
 Subject: Mysql dbi modules
 
 I have almost installed all of the dbi/dbm modules but can't get thru the
 'make test'.   I get the error msg:
 't/10dsnlist.DBI-connect(database=test) failed: Can't connect to
 local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) at
 t/10dsnlist.t line 45'
 
 MySql is ruuning but the database is located at 'local/mysql' and the
 mysql.sock socket is present.   This is setup in /etc/my.cnf
 
 How can I change the test to reference the current setup?
 
 
 
 Thanks, Dave
 
 
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: There are no DB defined space limits on MySQL Databases ?

2001-02-18 Thread Brian Reichert

On Tue, Feb 20, 2001 at 09:33:40AM +0800, yindu wrote:
 thank you.
 i know mysql stored its tables in files,And i have looked through the mysql 
handbook.But i hadn't found information about the file systerm of mysql,i think a 
table 
 is a file,then all tables in the same database should be stored in the same 
file_content.But where can i find them?

I'm assuming you've installed MySQL under some kind of UNIX.  If
so:

MySQL does not have it's own 'filesystem'; it stores everything in
several large files in the UNIX filesystem.

MySQL (by default) keeps it's databases in /usr/local/var.  This
is the 'datadir' parameter to the server.  You can see what yours
is set to:

  % echo 'show variables' | mysql

This will dump out a list of all of the configuration variables
your server is using.  Look for 'datadir'.

Within that directory, there will be several sub-directories (yours
will be different than mine):

  % ls -l /usr/local/var
  drwx--   2 root  wheel  512 Apr 26  2000 customers
  drwx--   2 root  wheel  512 Apr 26  2000 mysql
  drwx--   2 root  wheel  512 Apr 26  2000 test

Each one of these is a database.  My MySQL server has three databases,
'customer', 'mysql' and 'test'.

'mysql' is the database that the server itself uses to keep track
of valid users, permissions, and the like.

'customer' is one I use for a project.  That directory contains several
files:

  % ls /usr/local/val/customer
  customer.ISD
  customer.ISM
  customer.frm
  site.ISD
  site.ISM
  site.frm

My database 'customer' has two tables: 'customer' and 'site'.
MySQL stores the information about any one table in three files.
For example, my customer table has three files:

customer.ISDthis is the data file
customer.ISMthis is the index file
customer.frm(I forget what this is, sorry)

 Where can i find local informations?

I don't know what you mean; sorry. :/

 now i create a database named yd for my database user.If i want to know how much 
space have been used,what can i do ?

The 'space used' by a database is the amount of diskspace taken up
by the subdirectory, including all of its files.  One way is with
the 'du' command:

  % du -k /usr/local/var/customers
  20843

The '-k' flag means "count in 1024 byte blocks".  Therefore, I'm
using

  20843 * 1024 = 21343232 bytes. (About two megabytes.)

Hope this helps...

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: There are no DB defined space limits on MySQL Databases ?

2001-02-17 Thread Brian Reichert

On Fri, Feb 16, 2001 at 10:46:40AM -0800, Fox Mulder wrote:
 
 --- Brian Reichert [EMAIL PROTECTED] wrote:
  On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote:
   There are no DB defined space limits on MySQL Databases ?It's
  dangerours .How to control
   the database space on my database user?
  
  Filesystem quotas.
 
 But, to define filesystem quota, I will need to change de Owner of
 the file to the name of the respecive user right?
 
 Example: if the table belong to user max, I'll:
 
 chown max.users *.ISM
 
 Right??

Well, let me make sure I undertand what you mean.

If _all_ of the database tables are owned by the same user (ie.
the user the mysqld runs as), then you could arrange that the
database tables live on their own filesystem.

If the database tables have to co-exist if other files owned by
other users, then yes, you'd have to employ per-user quotas.  As
you how your OS imposed those limits, you'd have to do research.
But yes, at the very least, those database table files would have
to be owned by the user you're trying to constrain.

If that user is different than the UID that mysqld runs under, then
you'd have to assure that mysqld has read/write access to the file.

As I write this, I realize I don't know if/how quotas will be
imposed when mysqld's UID write to a file owned by otheruser.

I suspect that mysqld's own limits will be enforced, not otheruser's.

Look into:

- putting the worrisome files onto their own filesystem.

- resource limits (RLIMIT_FSIZE in setrlimit(2), for example.  My
  OS (FreeBSD) has a command-line tool [limits(1)] for contraining
  processes.

- filesystem quotas.  My OS lets me have both user and group quotas.
  YMMV.

 
 []'s
 
 Fox W. Mulder
 
 
 __
 Do You Yahoo!?
 Get personalized email addresses from Yahoo! Mail - only $35 
 a year!  http://personal.mail.yahoo.com/
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: There are no DB defined space limits on MySQL Databases ?

2001-02-16 Thread Brian Reichert

On Sat, Feb 17, 2001 at 03:23:49PM +0800, yindu wrote:
 There are no DB defined space limits on MySQL Databases ?It's dangerours .How to 
control
 the database space on my database user?

Filesystem quotas.

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: /tmp/mysql.sock disappearing?

2001-02-14 Thread Brian Reichert

On Tue, Feb 13, 2001 at 11:50:28AM -0500, Brian Reichert wrote:
 I couldn't fine this mentioned in the archives, so I hope someone has seen
 this before:
 
 I'm running into a situation wherein /tmp/mysql.sock keeps disspearing.
 
 There is still server process (sleeping), and there is still a pidfile.
 
 This can happen after ten or fifteen minutes of queries.
 
 I don't have a cronjob, or any other external process that scrubs /tmp.

I have to apologize to everyone; I found out that I _did_ have a
cronjob that caused this socket to go away:

I had been doing this nightly:

  /usr/local/bin/mysqladmin -uroot -proot flush-logs  /usr/local/bin/safe_mysqld 

safe_mysqld out-of-hand removes $MYSQL_UNIX_PORT; I don't know why.

(I also don't know why I felt the need to restart mysqld after a
flush-logs.)

Thanks for everyone's advice...

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




/tmp/mysql.sock disappearing?

2001-02-13 Thread Brian Reichert

I couldn't fine this mentioned in the archives, so I hope someone has seen
this before:

I'm running into a situation wherein /tmp/mysql.sock keeps disspearing.

There is still server process (sleeping), and there is still a pidfile.

This can happen after ten or fifteen minutes of queries.

I don't have a cronjob, or any other external process that scrubs /tmp.

Has anyone seen this sort of symptom before?

FWIW, the details:

  OS: FreeBSD 3.4-RELEASE
  MySQL 3.22.32
-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: /tmp/mysql.sock disappearing?

2001-02-13 Thread Brian Reichert

On Tue, Feb 13, 2001 at 08:35:44PM +0100, Fred van Engen wrote:
 I've seen it after installing two versions of MySQL on one server.
 I forgot to set another location for the second MySQL process
 before starting it with /bin/safe_mysqld. The result was that the
 socket was removed by the second process.
 
 Looking at safe_mysqld you would probably get the same result if
 you run multiple MySQL processes of the same version but from
 different data directories.

Believable, but we in fact only have the one instance of mysql running. :/

 
 Fred.
 
 -- 
 Fred van Engen  XO Communications B.V.
 email: [EMAIL PROTECTED] Televisieweg 2
 tel: +31 36 5462400 1322 AC  Almere
 fax: +31 36 5462424 The Netherlands

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




logging to a FIFO?

2001-02-13 Thread Brian Reichert

I _used_ to be able to log to a FIFO as recently as mysql-3.22.32,
but now with mysql-3.23.33, I can't:

  010213 17:03:11  Could not use /var/mysql/db/localhost.fifo for
  logging (error 29)

where in /usr/include/sys/errno.h:

  #define ESPIPE  29  /* Illegal seek */

I'm guessing someone's trying to seek on my log file. :/

What gives?

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: /tmp/mysql.sock disappearing?

2001-02-13 Thread Brian Reichert

On Wed, Feb 14, 2001 at 09:03:16AM +0800, Rolf Hopkins wrote:
 Do you have a cron job that's cleaning up your socket file along with
 whatever other garbage it's cleaning up?

Nope.  As I said in my original mail:

 I don't have a cronjob, or any other external process that scrubs /tmp.

I'm waiting for it to happen again; it's been behaving for twelve hours
now...

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: table too big to dump?

2001-02-08 Thread Brian Reichert

On Wed, Feb 07, 2001 at 05:38:49PM -0600, Dan Nelson wrote:
 It's probably trying to read the whole table into memory.  Try adding
 "--opt" to the mysqldump commandline.

OK, I've had _many_ responses that in effect say 'use -q' (--opt
is a superset).  It works.  Thanks.

Dumb question: why isn't the -q behavior the default bahavior?
Under what conditions is it advantageous to _not_ use -q?

 -- 
   Dan Nelson
   [EMAIL PROTECTED]

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




table too big to dump?

2001-02-07 Thread Brian Reichert

I apologize if this has been discussed already, but I quick poke
at the archives didn't reveal anything.

We have a table that iamchk says is fine.  We are trying to get an
SQL dump of this table.  But, we keep getting out-of-memory errors.
I've tried several things, all to no avail, and I'm looking for
advice/suggestions.

Some real details:

The platform:

  FreeBSD 3.4-RELEASE on a dual-CPU box, with 1G of physical and
  2G of swap.

  We're running MySQL 3.22.32.

  This machine is idle; there are no other processes, no uses of
  the database, other than my client.

The table:

  # ls -l audit_trail_271.*
  -rw-rw  1 root  wheel  1486838307 Nov 10 05:26 audit_trail_271.ISD
  -rw-rw  1 root  wheel84807680 Nov 10 05:26 audit_trail_271.ISM
  -rw-rw  1 root  wheel9060 Oct 25 05:06 audit_trail_271.frm

  # isamchk audit_trail_271.ISM
  Checking ISAM file: audit_trail_271.ISM
  Data records: 3869676   Deleted blocks:   0
  - check file-size
  - check delete-chain
  - check index reference
  - check data record references index: 1
  - check data record references index: 2
  - check record links

When I try to do a mysqldump on the localhost, I get an out-of-memory
error:

  # mysqldump -uroot -proot customer audit_trail_271
  mysqldump: Out of memory (Needed 8164 bytes)
  mysqldump: Got error: 2008: MySQL client run out of memory

When I try to a dump from over the network:

  # mysqldump -uroot -proot -h db_host1 customer audit_trail_271

  # MySQL dump 7.1
  #
  # Host: db_host1Database: customer
  #
  # Server version3.22.32-log
  
  #
  # Table structure for table 'audit_trail_271'
  #
  CREATE TABLE audit_trail_271 (
audit_trail_id int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
account_id int(10) unsigned DEFAULT '0' NOT NULL,
user_id int(10) unsigned,
bid_id int(10) unsigned,
cpc int(10) unsigned,
ics2_id int(10) unsigned,
action varchar(20) DEFAULT '' NOT NULL,
acct_amt int(11) DEFAULT '0' NOT NULL,
gift_amt int(11) DEFAULT '0' NOT NULL,
free_amt int(11) DEFAULT '0' NOT NULL,
bill_amt int(11) DEFAULT '0' NOT NULL,
decl_amt int(11) DEFAULT '0' NOT NULL,
ref_base varchar(40),
ref_more text,
apache_log text,
mtime timestamp(14),
ctime datetime,
PRIMARY KEY (audit_trail_id),
KEY account_id (account_id)
  );
  
  #
  # Dumping data for table 'audit_trail_271'
  #

And there it hangs forever.  As in, I let is sit for hours, and no
data comes over the pipe.  The server admits there's a connection:

 # echo 'show processlist;' | mysql -u root -proot customer
  Id  UserHostdb  Command TimeState   Info
  162128  rootdb_host2  customerQuery   446 Sending data
   SELECT * FROM audit_trail_271
  162130  rootlocalhost   customerQuery   0   NULLshow
  processlist

And, if I simply do a 'select *', and dump all output into a bitbucket:

  # echo 'select * from audit_trail_271;' | 
mysql -u root -proot customer  /dev/null
  mysql: Out of memory (Needed 8164 bytes)
  ERROR 2008 at line 1: MySQL client run out of memory

Does anyone have any advice about how I can get a dump of this table?

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: table too big to dump?

2001-02-07 Thread Brian Reichert

On Wed, Feb 07, 2001 at 05:00:12PM -0500, Brian Reichert wrote:
 When I try to do a mysqldump on the localhost, I get an out-of-memory
 error:
 
   # mysqldump -uroot -proot customer audit_trail_271
   mysqldump: Out of memory (Needed 8164 bytes)
   mysqldump: Got error: 2008: MySQL client run out of memory

Sorry about a rely to myself; on a lark, I did some exploring, and
the use of the '--opt' flag made the difference.  What is that
[not] doing, that changed the behavior of eveything?

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: MySQL Tables over Multiple Drives

2001-01-30 Thread Brian Reichert

On Tue, Jan 30, 2001 at 06:51:01AM -0500, Jason Frisvold wrote:
 Well, there are a few reasons..  We have a system with 4 8G drives..  If we
 use one for root and one to mirror that root, we have 2 drives left.
 Now, if we raid those 2 remaining drives (RAID5) we get about 12 Gigs of space
 available...

I'm confused; what does RAID5 on just two drives get you?  One
drive, and you're still dead.  I would have thought that (in this
case) just striping would have been the way to go...

 ---
 Jason H. Frisvold
 Senior ATM Engineer
 Engineering Dept.
 Penteledata
 CCNA Certified - CSCO10151622
 [EMAIL PROTECTED]
 ---
 "I love deadlines. I especially like the whooshing sound they make as they
 go flying by." -- Douglas Adams

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: 'USE_RAID' in mysql-3.22.32?

2001-01-30 Thread Brian Reichert

On Mon, Jan 29, 2001 at 11:48:29PM +0100, Tonu Samuel wrote:
 On Mon, 29 Jan 2001, Brian Reichert wrote:
 
  In pawing though the source for mysql-3.22.32 (our current version
  in production), I noticed in acconfig.h, a macro 'USE_RAID', which
  in term seems to set up the use of include/raid.h.
  
  But, I can't find any documentation for this, and the configure
  program doesn't seem to set it one way or another.
  
  What is the state of that code?  For that version of MySQL, it it
  useful/meaningful to activate it, if I intend to make use of a RAID
  array?
 
 This is impossible. RAID was introduced in 3.23.x series. Also
 documentation have evreything about it.

'Impossible'?

Just now, I can grab:

  http://www.mysql.com/Downloads/MySQL-3.22/mysql-3.22.32.tar.gz

And, in that tarball, on line 190 of acconfig.h:

  /* Use MySQL RAID */
  #undef USE_RAID

And there is a include/raid.h.

And, Docs/mysqld_error.txt has this message defined:

  #define ER_NO_RAID_COMPILED 1174
  "This version of MySQL is not compiled with RAID support",

There is no 'RAID' attribute to the 'CREATE TABLE' syntax in the
supplied docs.

My question was:

 What is the state of that code?

I _surmise_ that it's unused code, as it was not fully implemented
at this point.  I was uncertain if it was code that specific to
the yet-to-be-introcuded RIAD attributes to a table, or if it just
messed with the layout of files on disk to allow for better
performance in general on RAID arrays.

I merely wanted verification.

 
 Tonu
 

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




'USE_RAID' in mysql-3.22.32?

2001-01-29 Thread Brian Reichert

In pawing though the source for mysql-3.22.32 (our current version
in production), I noticed in acconfig.h, a macro 'USE_RAID', which
in term seems to set up the use of include/raid.h.

But, I can't find any documentation for this, and the configure
program doesn't seem to set it one way or another.

What is the state of that code?  For that version of MySQL, it it
useful/meaningful to activate it, if I intend to make use of a RAID
array?

-- 
Brian 'you Bastard' Reichert[EMAIL PROTECTED]
37 Crystal Ave. #303Daytime number: (603) 434-6842
Derry NH 03038-1713 USA Intel architecture: the left-hand path

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php