Page 1 of 1

Accessing MySQL data without MySQL Server

Posted: Mon Sep 03, 2007 3:50 am
by anjanesh
Hi

I got a shared host where my phpinfo shows MySQL and PostgreSQL extensions enabled.
When I tried to create a database in the hosting control panel, the only option to create a new database is of type MySQL.

When I asked the host regarding missing PostgreSQL database option, he replied that only the client is available - server isnt.

This lead me to think :

Let say I develop everything on my local-PC and I got a host that has PHP with MySQL extension enabled but no MySQL Server.
If I upload the mysql data - frm, MYD and MYI files to document_root, is it possible to code in PHP to access the data using the client API library (libmysql.dll, php_mysql.dll, php_mysqli.dll) alone ?

Thanks

Posted: Mon Sep 03, 2007 4:47 am
by VladSun
I am pretty sure you can not do this.

Posted: Mon Sep 03, 2007 4:53 am
by s.dot
I'm sure it would be possible, since database files contain information just like any other file does. You probably don't need a server to access that information if you have access to the raw files, although it would be more convenient.

Posted: Mon Sep 03, 2007 6:05 am
by anjanesh
What if one wanted to create a Java desktop application that uses a mysql database ?
I dont think distributing the MySQL Server along with the installation package is a good idea - unnecessary load for just one application to so many users !