Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• Subject: mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Subject: Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• Subject: MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Subject: Re: Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
Subject: MySQL stopped responding

Subject: MySQL stopped responding

2007-10-07       - By Gary Kephart

 Back
Running MySQL 4.x on Win2000.

I have two huge CSV files (the shorter one's 1.5 million rows) that I
imported and am now trying to normalize into various tables. I started a
long command (INSERT INTO...SELECT...FROM...WHERE) that I knew was going
to take a while, but not like this. I finally decided to try and stop
the query, but to no avail. I had to reboot my machine and then I
started MySQL manually. However, the client apps (MySql Administrator
and Query Browser 1.2.8, mysqladmin) can't connect. It seems like the
server's either trying to finish the command or clean up after the
command. Can't tell what. All I know is I've lost control of my server.
The only log file I see is ib_logfile0 and ib_logfile1, which can't
really be viewed in a text editor.

What should I do?

Thanks,
 Gary

--
http://blog.photeus.com/

The penalty that good men pay for not being interested in politics is to
be governed by men worse than themselves - Plato, philosopher (427-347 BCE)



--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/java?unsub=mysql@(protected)