DSM-G600, DNS-3xx and NSA-220 Hack Forum

Unfortunately no one can be told what fun_plug is - you have to see it for yourself.

You are not logged in.

Announcement

#1 2012-09-25 17:59:57

bill-ns
New member
Registered: 2012-09-25
Posts: 4

DNS-325 mySQL

Some background...
Trying to install my xbmc databases on my DNS-325.  It's running fun_plug .7, and 1.03 firmware.  I notice that mySQL is already running on it.  I reset the root password so I could get into mySQL and was able to create new databases.

I believe that anything I create in the \.@database@ folder will be lost after a reboot since it's store in flash memory... so I'd like to be able to move the database files to a directory on the drive.

What would be the best way to do this?  Was thinking that a starup script could kill the mysql process, move the db files and then restart mysql, pointing to the location of the new files.... not sure this is the best idea though.

Any thoughts? 

Thanks
Bill

Offline

 

#2 2012-09-25 21:26:50

Mijzelf
Member / Developer
Registered: 2008-07-05
Posts: 709

Re: DNS-325 mySQL

When that directory is in flash, it's not lost on reboot. When it's lost, I suppose it's in ram.

You can try to exchange the directory by a symlink to some place on disk, and then send a HUP signal to the daemon. It might just reopen the database on it's new location.

Offline

 

#3 2012-09-25 23:02:43

bill-ns
New member
Registered: 2012-09-25
Posts: 4

Re: DNS-325 mySQL

I think that's exactly what I'll do.  I just noticed that the new db's persisted after a reboot. 
Thanks for the reply!

Bill

Offline

 

#4 2012-09-26 00:27:07

bill-ns
New member
Registered: 2012-09-25
Posts: 4

Re: DNS-325 mySQL

That worked perfectly.  Shutdown MySQL, copied the db files to their new location and made a link in the original location.  Rebooted the NAS, and all was well.  Was nice to not have to bother reinstalling MySQL when it already exists on the box.

Bill

Offline

 

Board footer

Powered by PunBB
© Copyright 2002–2010 PunBB