patternsqlMinor
Dynamically changeable database
Viewed 0 times
databasechangeabledynamically
Problem
We have a database and some data is stored in a Trucrypt folder, my question is how can I include this trucrypt folder. The data type is MyISAM. I saw there is a symbolic link, but not really clear for me how can I use that.
Solution
You can use symbolic links with MySQL. All you would need to do is make a symbolic link for the .frm, .MYI and .MYD files of your MyISAM tables into the MySQL database schema directory that you want. After that, run
It is also important that the MySQL user is able to access those files, so you might have a bit of an issue with user rights.
Also, depending on your MySQL version, there maybe a setting in the my.cnf which enables/disables symbolic links, so you would need to keep an eye on that too.
flush tables; and they should show up.It is also important that the MySQL user is able to access those files, so you might have a bit of an issue with user rights.
Also, depending on your MySQL version, there maybe a setting in the my.cnf which enables/disables symbolic links, so you would need to keep an eye on that too.
Context
StackExchange Database Administrators Q#5943, answer score: 3
Revisions (0)
No revisions yet.