Moving MySQL Data Directory

stsIT

7 years ago
Answered

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?

Replies 1

Newest first
Newest first Oldest first

johnpaulb-imhs1

7 years ago

Hello stsIT, Thank you for your question regarding moving a MySQL Directory. We are happy to help, but this would require some time and development to accomplish. This means you will have to work through a solution for each task and test it. Here is a link to some helpful guides I found via online search to help you work towards a solution:

CREATE TEMPORARY TABLE Syntax
Alter table Syntax (for adding a column)
INSERT Syntax (for adding the character)
Export @tempTable to .txt file in SQL server

As long as you export to a folder that is public (such as public_html) the file will be accessible to the world. Typical permissions for a file are "644," see more in our guide on changing file permissions. Thank you, John-Paul

Reply Link