ibdata1 File

Hello! When I first set up my mySQL 4.1 server, I did not have the "innodb_file_per_table" option set. I have since set this option, and re-created all my tables so that they are now in individual innoDB files. However, the original, 44GB ibdata1 file still exists and I can't find any good way o

RE: mysqldump: Error 2013

Hello everyone! I just wanted to give everyone an update. I'm still getting this error when I try to back up this database table. I don't get it at the same row each time - today was at row 1,618, yesterday it was at row 24,566. Just a reminder of my symptoms: 1. mysqldump is the only thing rep

RE: mysqldump: Error 2013

> Have a look here: > http://dev.mysql.com/doc/mysql/en/gone-away.html Gleb, Thanks for the response. The only one that seems to apply is this one: > You may also see the MySQL server has gone away error if > MySQL is started with the --skip-networking option. I do start mySQL without networki

RE: mysqldump: Error 2013

> I believe it's the size of the row, not the size of a > single field, that matters. Is it possible you have a > row which exceeds max_allowed_packet size? No. There is one blob fields (always less than 50MB) and like 10 other fields, all integers. smime.p7s Description: S/MIME cryptographic

RE: mysqldump: Error 2013

: Hassan Schroeder [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 9:51 AM To: mysql@lists.mysql.com Subject: Re: mysqldump: Error 2013 Gustafson, Tim wrote: > When backing up this table, I get this error message every night: > > /usr/local/bin/mysqldump: Error 2013: Lost conn

RE: mysqldump: Error 2013

0001 Office (516) 908-4185 Fax http://www.meitech.com/ -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, August 29, 2005 9:35 AM To: Gustafson, Tim Cc: mysql@lists.mysql.com Subject: Re: mysqldump: Error 2013 "Gustafson, Tim" <[EMAIL PROTECTED]>

mysqldump: Error 2013

Hello I am using mysqldump to backup my entire database (about 40GB total) each night. I dump each table separetly, so that if mysqldump crashes in the middle somewhere, the rest of the database still gets backed up. Most of the tables are fairly small. About 20GB of the database is spread acro

RE: UNIQUE Key Allowing Duplicate NULL Values

t MORE THAN ONE. Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 480-1870 Mobile/Emergencies (516) 908-4185 Fax http://www.meitech.com/ -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 23, 2005 8:37 AM To:

RE: UNIQUE Key Allowing Duplicate NULL Values

/ -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 23, 2005 8:14 AM To: Gustafson, Tim; mysql@lists.mysql.com Subject: RE: UNIQUE Key Allowing Duplicate NULL Values At 8:10 -0500 2/23/05, Gustafson, Tim wrote: >Is there any flag I can set on

RE: UNIQUE Key Allowing Duplicate NULL Values

:[EMAIL PROTECTED] Sent: Tuesday, February 22, 2005 3:13 PM To: Gustafson, Tim; mysql@lists.mysql.com Subject: Re: UNIQUE Key Allowing Duplicate NULL Values At 15:00 -0500 2/22/05, Gustafson, Tim wrote: >Hi there! > >I have a table, defined as follows: > >CREATE TABLE `Web

UNIQUE Key Allowing Duplicate NULL Values

Hi there! I have a table, defined as follows: CREATE TABLE `WebSiteDomainNames` ( `ID` int(10) unsigned NOT NULL auto_increment, `WebSite` int(10) unsigned NOT NULL default '0', `DomainName` int(10) unsigned NOT NULL default '0', `Alias` char(16) default NULL, PRIMARY KEY (`ID`), UNI

Sub query Help

Hello I have written a report generator in PHP that handles creating and paginating the results from queries into a nice, user-friendly, HTML format. Because it's a generic report generator, it has some quirks about it, but I have managed to modify queries enough so that it works in almost all ca

RE: Problems with "select distinct"

) 908-4185 Fax http://www.meitech.com/ -Original Message- From: Michael Stassen [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 26, 2005 12:08 AM To: Frederic Wenzel Cc: Gustafson, Tim; mysql@lists.mysql.com Subject: Re: Problems with "select distinct" Frederic Wenzel wrote

Problems with "select distinct"

Hello I am trying to run the following query on my server: select Documents.ID, Name from Documents, DocumentFiles, DownloadLog where Documents.ID = DocumentFiles.Document and DocumentFiles.ID = DownloadLog.DocumentFile order by DownloadLog.AddedOn desc limit 5 I

RE: sum() Function and NULL values

Thanks for all your responses. I went with the coalesce way - it works like a charm. Thanks again! Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-0001 Office (516) 480-1870 Mobile/Emergencies (516) 908-4185 Fax http://www.meitech.com/ -- MySQL General Mailing List F

sum() Function and NULL values

Is there any way to make sum() return "0" instead of "NULL" when one or more of the rows being sum()'d is null? Phrased another way, is there a way to make mySQL treat "NULL" as "0" when dealing with mathematical functions? Tim Gustafson MEI Technology Consulting, Inc [EMAIL PROTECTED] (516) 379-

"Lost connection to MySQL server during query" after 4.1 upgrade

Hello All! I have had mySQL 3.2 running on my server for about 2 years now without incident. Recently upgraded to 4.1, and suddenly I'm getting the following message from queries: "Lost connection to MySQL server during query" This is in response to a PHP script issuing a query to the mySQL ser

Problems With 4.0 -> 4.1 Upgrade on FreeBSD 4.10

Hello I have upgraded from mySQL 4.0 to mySQL 4.1 on a FreeBSD 4.10 box. The upgrade went perfectly with no warning or error messages. However, after the mySQL server was running for a few hours, it crashed. It restarted itself thanks to mysqld_safe. However, it keeps crashing and restarting i