Re: is 'start' a keyword?

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 tabl

is 'start' a keyword?

s 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

Re: 1 database; 2 scripts; different results

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? Flu

Re: Create Temporary Table, incorrect rows

; 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 -- MyS

Re: Create DB help

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} Thank you very much in advance > > Tony

Re: Dump table

h 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

Re: mysql backup script

(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-68

Re: Dump table

ysqldump. 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 US

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

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 Cr

Re: SHA1 Question

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 R

Re: Looking for a C API if it exisits

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-684

Re: mysqldump problem

, > > 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 adm

Re: Unknown error, urgent help please

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

Re: Database design.. Asking again

x: 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 G

Re: Executing Pre-Written Commands

d 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) c

Re: BETWEEN

gt; www.triand.com > O: (512) 248-2287 > M: (713) 252-4688 -- Brian Reichert <[EMAIL PROTECTED]> 37 Crystal Ave. #303Daytime number: (603) 434-6842 Derry NH 03038-1713 USA BSD admin/developer at large -- MySQL Gene

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

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 la

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

ive 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

Re: Preventing data collisions

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

Re: SQL: forbidden syntax search

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

Re: mysql well suited for bibliographic data...

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

Re: help installing DBI modules

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/u

Re: External Access

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 Mai

Will a SIGTERM shutdown while using LinuxThreads?

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 proces

Re: curtime

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 i

Re: moving MySQL

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 yo

Re: Mysql.log error - Please help

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 every

Re: Mysql.log error - Please help

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,

Re: Configure fails

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

Re: Unexpected ending

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

Re: MySQL on virtual hosting

(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 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

Re: information about the tables in the database

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 > table

Re: Fw: Query to update column length

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 so

Re: MySQL as a desktop DB

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 data

Re: Perl DBI Interfacer

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 s

Re: aggregate functions producing bad data

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 >

Re: To share with MySql friends in net?

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 peo

Re: return row count from "show processlist"

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 monit

Re: a newserver would be better than this mailing list

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

Re: Jon Frisby---MySQL help needed

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

Re: auto_increment

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?

Re: Separate List For administration

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

Re: mysql.pm and the mysql root password

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' s

Re: Access denied on use mysql;

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

Re: Create database if does not exist.

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 6.5.1 CREATE DATABASE Syntax CREATE

Re: mysql under FreeBSD 4.5

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

Re: HELP: cannot connect to MySQL server

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,

Re: Need help please!

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.

Re: Re: Access denied to apache@localhost

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 w

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

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,

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

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,

Re: mysqld with daemontools

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

Re: Test Case (Urgent)

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 fi

Re: Location of databases

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

Re: hey folks!

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

Re: killed by SIGSEGV

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

Re: Bug, mySQL keeps crashing.

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 t

Re: Bug, mySQL keeps crashing.

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 funct

Re: site admin and log script needed

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 >

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

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

replication issue with FreeBSD 4.2-RELEASE

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 All very straight forward. When I spin every

Re: Replication

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

Re: out of memory

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

Re: help meeeeeeeee

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 config

Re: Re: replication doesn't maintain logs?

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 th

replication doesn't maintain logs?

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 creat

Re: Problem building MyODBC 2.50.37 on BSD

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 assu

Re: Cron job to start/restart mysql for non-root user

On Fri, May 04, 2001 at 06:08:29PM -0700, Gary Bickford wrote: > I have a 'normal user' mysql setup on a server not my own - I have no > root access and they won't add mysql to the server's startup scripts. Many free Unix-a-like's are using Paul Vixie's cron, which I think has an undocumented '

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

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 Basta

OUTFILE ownership under mysqld 3.23.36-debug

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 TMPD

Re: Mysql dbi modules

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 t

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

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

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

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

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

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. #303

Re: /tmp/mysql.sock disappearing?

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 proc

Re: /tmp/mysql.sock disappearing?

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 wa

logging to a FIFO?

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 gue

Re: /tmp/mysql.sock disappearing?

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 secon

/tmp/mysql.sock disappearing?

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

Re: table too big to dump?

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'

Re: table too big to dump?

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:

table too big to dump?

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 looki

Re: 'USE_RAID' in mysql-3.22.32?

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 > >

Re: MySQL Tables over Multiple Drives

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 > av

'USE_RAID' in mysql-3.22.32?

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 . 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 th