> "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
>
>
no my question is not how can users access to file systems with some
commands . i know that MySQL implements working with file system with
storage engines . is there another implementation except storage engine ?
