RE: Large Table Problem

2001-01-26 Thread Steven Roussey
Hi. You posted to the wrong list. This list is for developing of MySQL itself. As for your problem, MySQL does not have a good solution at this point. Have you tried using the BACKUP command? It will flush and lock the table and copy only the data and .frm files. A RESTORE will rebuild the index

Large Table Problem

2001-01-25 Thread Marius Wejman
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 somef