i'm in the process of designing a GPS system and wanted to know that is it possible to keep MySQL and the database on a CDROM and query it from a C IDE(KDevelop)?My answer:
While I haven't done this (tried to run MySQL from a CDROM), I would think that this is not possible since MySQL needs to create temporary tables from time to time and I can't see that happening if MYSQL and the database are installed on a CDROM.
Am I right?
What do you guys (MySQL experts) think?
Can a database and MySQL be run from a CDROM? What if plenty of RAM is available?
Has anyone been able to do this before?
What alternatives exist for Aniket?