CODEWITHSUNDEEP
mysqldatabaseoffline
shingi
shingi

Reputation: 63

MYSQL Database offline use

Is there a way to use a MYSQL database without the database management system.. Like use tables offline without installing the db management system on the machine.. If there is can you please point me in the right direction? Thank you!

Upvotes: 6

Views: 32527

Answers (5)

user1202136
user1202136

Reputation: 11557

You can use The embedded MySQL Server Library to access MySQL data files without running the MySQL server.

Upvotes: 2

bob-the-destroyer
bob-the-destroyer

Reputation: 3154

If you've actually opened the table files in a hex or text editor, you'll see that you will definitely need the mysql application installed to make any sense of them to use them. Sure the records are all there in plain text (.myd files for myisam, the ibdata1 file for innodb tables), but it would be a complete time-waster devising a custom app to parse or update the file structure, as well as trying to tie in table structure contained in the related files for each table.

Upvotes: 0

bassneck
bassneck

Reputation: 4043

As far as I know, there is no way to do this.

However, there is a portable DBMS SQLIte. It comes in different ways and can be used on other platform with different programming languages.

After reading your comment, I'm almost sure, this is what you need. It's not that fast as MySQL I guess, but it works.

Upvotes: 5

Stephane Gosselin
Stephane Gosselin

Reputation: 9148

The server side piece of the application, mysql-server, is needed at a minumum to run mysql. This server application comes with all the tools built-in to manage the instance. I doubt you can prevent installation of this.

Upvotes: 0

LainIwakura
LainIwakura

Reputation: 3031

You can setup a database to work on your localhost. This will be offline unless you setup the front-end stuff to let the internet interact with it.

What exactly do you mean "without the database management system"? You always need a way of interacting with it, even if it is offline. (Otherwise how can it work for you?)

Upvotes: 0

Related Questions