I have a similar question. I've run out of disk space on one of my partitions. What would be the best way to move one table over to another partition? I see you can specify DATA DIRECTORY and INDEX DIRECTORY, but when I try and ALTER or CREATE LIKE with these parameters, the table stays where it is on the original partition.
Also, the table is a few Gb, so the quickest way possible would be best :) Any advice much appreciated! Helen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
