path of a mysql table

Official Hardware Classic Yún
1

Hi!
populate a mysql table is it possible to know its path and eventually put it in SD card?

2

Hi Giuseppe

I'm not sure I understood your question...you can of course install MySQL on Linino and change the "datadir" property to a folder on your SD card...

for example following this guide from OpenWRT wiki:
http://wiki.openwrt.org/doc/howto/lamp#installing.and.configuring.a.database.server

3

thanks luca for your answer, you understand me!
so I need to re-install mysql and change the "datadir".

4

i think you have not to reinstall

i call my database with php on this way

$db=new SQLite3("/www/sd/Aqarium/Aquarium.db");

so i can store the db on sd card

5

Otto, you're using SQLLite while giuseppe is using a different DBMS, MySQL...

Giuseppe, you may try to:

  • stop mysql daemon
  • create the new datadir on your SD card
  • (optional) move the existing data
  • change the configuration
  • restart

http://crashmag.net/change-the-default-mysql-data-directory-with-selinux-enabled

6

trying without effect to change the configuration,
I have decided to re-install mysql for change the datadir
many many thanks for YOUR help

7

you're welcome!