Hello there,
I was hoping you guys could help me with a little problem I'm having with
MySQL.
I'm trying to dump the contents of one field of a multi-field table to a
text file. The table is on the large side (about 3 million rows).
Whenever I run:
SELECT rowname FROM table INTO OUTFILE somefile.txt
The entire server freezes for the duration and will not execute any other
commands from any connection (other processes, users, etc.) until the this
select is done.
The DB server I'm running this on is mission critical - we can't afford for
it to be unable to accept INSERTS for the duration of the command (about
30-45 minutes).
Does anyone have any suggestions as to how I might be able to run this query
without hanging the server (or copying the tables to another server and
running it there) ?
Alternatelly I was considering just parsing through the .ISD file for that
table and extracting the field I need - if anyone could point me in the
right direction as to which modules in the MySQL source I should look at for
this functionality I would really appreciate it.
Thanks in advance,
Marius Wejman
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
