Hi,
is possible to use a binary file as a database with mysql?
In other words, i would like to mantain my binary data and use mysql to
write/read in it as it war a database.
The problem is that i have an application ( not source) that use binary
data and i would like to read/change/add/delete data with my php app.

Thanks

Ioson

ioson wrote:
easily enough.


You probably need to use LOAD_FILE to insert it though, to avoid
possible misinterpretation of the data by mysql..

ioson:


Does your 'binary file' contain tables with field definitions and keys?

El 30/01/2011 16:03, ioson escribió/wrote:
I suppose that you can probably use any arbitrary binary format to store
tables and use MySQL as front-end. You just need to reverse-engineer the
format, write your own MySQL plugin to provide the appropriate storage
format and use such format instead of MyISAM or InnoDB. It'd be a nice
programming exercise.

Or you can use a faster alternative and rewrite the proprietary
application


--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

=?ISO-8859-1?Q?=22=C1lvaro_G=2E_Vicario=22?= <alvaro.NOSPAMTHANX (AT) demogracia (DOT) com.invalid> wrote:
Yeah. MySQL calls this kind of plugin a "storage engine" and beginning
with version 5.1 those can indeed be pluggable (before they had to be
compiled into the server)

The pluggable storage engine API is documented in the manual and on
MySQL Forge: http://forge.mysql.com/wiki/MySQL_In..._Custom_Engine

There is also an example engine in the MySQL sources.

If done properly (using indexes, transactional) then it would be a
rather lengthy "exercise". My guess is several man-years. Simple
things like "data is CSV, no indexes, no writes" can be implemented
in few days though.


XL