No there is no indication of that at all. The server service appears
to be in perfect order, does not drop/restart and my other
applications continue to function without any interruption.
It appears as if the mysqldump connection to the server is
interrupted or maybe there is something in row 1 of `trackdata` that
it does not like. This table contains a long blob field which at
present does not contain any more than ~80MB per row. I also use the
--hex-blob flag for mysqldump to try and get around any possible
problems with exporting this data... I have no descriptive error
messages anywhere and it is driving me nuts :|
On 18/06/2007, at 11:27 AM, Baron Schwartz wrote:
Is there any indication that the mysqldump crash is killing the
server and causing it to restart? For example, "ready for
connections" notifications just after you try a mysqldump?
Hartleigh Burton wrote:
Hmmmm no there are no new errors in there. Nothing out of the
ordinary thats for sure. Just notifications that MySQL has started
and is accepting connections etc. :|
On 18/06/2007, at 11:06 AM, Baron Schwartz wrote:
How about in c:\Program Files\MySQL\MySQL Server 5.0\data
\<hostname>.err?
Cheers
Baron
Hartleigh Burton wrote:
Hi Baron,
There are no MySQL errors in the event viewer.
On 18/06/2007, at 10:36 AM, Baron Schwartz wrote:
Hi Hartleigh,
Hartleigh Burton wrote:
Hi All,
I have a database which is currently at ~10GB in it's test
phase. It is containing uncompressed audio and is expected to
reach 1.5TB in no time at all. I am just running some backup
tests and I have been having lots of problems creating an
accurate backup.
I have tried both MySQL Administrator & mysqldump, both
applications drop out on the same table, the table `trackdata`
which contains ~9GB worth of data. There is no single row any
larger than 50MB, most average around 40MB. Windows 2000
Server, MySQL v5.0.37-community-nt and all tables are InnoDB.
[snip]
-- Retrieving rows...
-- Retrieving table structure for table trackdata...
-- Sending SELECT query...
-- Retrieving rows...
mysqldump: Error 2013: Lost connection to MySQL server during
query when dumping
table `trackdata` at row: 1
You might be able to find more information about the precise
error in the server's error logs. That will give us a better
idea what might be wrong, if there is an error server-side,
which seems likely to me.
Baron
Regards,
Hartleigh Burton
Resident Geek
MRA Entertainment Pty Ltd
5 Dividend St | Mansfield | QLD 4122 | Australia
Phone: (07) 3457 5041
Fax: (07) 3349 8806
Mobile: 0421 646 978
www.mraentertainment.com
Internal Virus Database was built: Never
Checked by MAC OSX... we don't get viruses!
--MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
Regards,
Hartleigh Burton
Resident Geek
MRA Entertainment Pty Ltd
5 Dividend St | Mansfield | QLD 4122 | Australia
Phone: (07) 3457 5041
Fax: (07) 3349 8806
Mobile: 0421 646 978
www.mraentertainment.com
Internal Virus Database was built: Never
Checked by MAC OSX... we don't get viruses!
Regards,
Hartleigh Burton
Resident Geek
MRA Entertainment Pty Ltd
5 Dividend St | Mansfield | QLD 4122 | Australia
Phone: (07) 3457 5041
Fax: (07) 3349 8806
Mobile: 0421 646 978
www.mraentertainment.com
Internal Virus Database was built: Never
Checked by MAC OSX... we don't get viruses!
