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/[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!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
