Accessing MySQL data without MySQL Server

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Accessing MySQL data without MySQL Server

Post 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
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Post by VladSun »

I am pretty sure you can not do this.
There are 10 types of people in this world, those who understand binary and those who don't
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Post 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.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Post 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 !
Post Reply