OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Using MySQL with its data files on a CD-R (recordable CD)

From: Daniel Brown (parasanegmail.com)
Date: Wed Mar 05 2008 - 11:10:30 CST

On Wed, Mar 5, 2008 at 12:13 AM, Michael Hemer <mshazmail.com> wrote:
> Hi,
>
> I have been researching to see if it's possible to have a MySQL database with it's data files on a cd-rom, but could use some help to determine if I have found out the full truth of what's possible. I would appreciate any additional info people have to offer.

    The simple answer is yes. Data is data, regardless of how and
where it's stored.

    However, a more truthful answer uncovers some complexities,
including the speed at which the data can be transferred from the CD
(which will be slower than direct access from a hard drive), as well
as the version limitations. If the MySQL databases on the CD are, for
example, in MySQL 5.x format, but your end-user is still using MySQL
3.23, it's not going to work. Also, there will need to be some
configuration variables modified on each end-user system so that the
MySQL server knows where to locate the CD databases (and then the
server will need to be restarted, as well).

    So to summarize, it can be done, but don't expect it to be a
point-click-send operation; there are going to be some bumps in the
road.

--
</Dan>

Daniel P. Brown
Senior Unix Geek
<? while(1) { $me = $mind--; sleep(86400); } ?>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql