Moving MySQL Data Directory
In short, I need to quickly create a temporary table of about 500,000+ rows and insert a single character in a new column after all the other columns (regardless of how many there are) and then "select * into outfile" in a data directory in which the user can access. What directory should I write to (the MySQL Data directory? The tmp directory? a separate directory?) and how should I give the correct permissions so that I do not receive a "do not have permissions" error?