Go Down

Topic: path of a mysql table (Read 1 time) previous topic - next topic

70agiuseppe

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

lucad79

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
www.lucadentella.it

70agiuseppe

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

OttoF

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

lucad79

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
www.lucadentella.it

70agiuseppe

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

lucad79

www.lucadentella.it

Go Up