Re: Outfile Using too much disk space
Posted by:
Rick James
Date: October 10, 2010 12:50PM
It depends...
Could you provide
SHOW CREATE TABLE
and the exact statements you are using.
What is the goal? A sorted CSV file from a MyISAM table?
Consider
CREATE TABLE new (...) ENGINE=CSV;
INSERT INTO new SELECT ... FROM old ORDER BY ...;
Consider msyqldump.
Subject
Views
Written By
Posted
4458
October 07, 2010 11:49AM
Re: Outfile Using too much disk space
1696
October 10, 2010 12:50PM
2296
October 12, 2010 12:38PM
1598
October 14, 2010 11:21AM
1609
October 16, 2010 10:57AM
2023
November 23, 2010 04:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.