"Saied Taghavi" <s.taghavi@stripped> wrote on 07/01/2005 11:34:06 AM:
> hi every body
> we are working on source code of mysql for our file structure course
> project and during studying we found that mysql performs its work with
> file
> system with storage engines . now my question :
> is thare another mechanism except storage engines for accessing file
system ?
>
> thanks a lot
>
If I understand your question correctly, you would like to know if there
are any commands or functions available to a USER of the server that will
allow for direct manipulation of disk files. The only commands that comes
close to doing what you ask are "LOAD DATA LOCAL INFILE ... "
(http://dev.mysql.com/doc/mysql/en/load-data.html) and "SELECT ... INTO
OUTFILE" (http://dev.mysql.com/doc/mysql/en/select.html)
Other than those two commands I can think of no other commands (recognized
by a MySQL server) where the user can even specify a file name and either
read from or write to that file. All other file-level access is hidden
below and managed within the abstractions provided by the storage engine
interface.
No user (or any other process, for that matter) should be allowed to
directly modify any file created or managed by any of the storage engines
for a database server. To allow those kinds of changes invites disaster.
"To Preserve Data Integrity" is the most important reason why there are no
other file system access commands in MySQL.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
