So last night we had a wind storm that knocked out power to my house. I don't have my server on an UPS (I know, I know....) but after power was restored and my server was turned back on, parity check was completed with no errors, I was missing a few things.

 

1) I wrote a script to send me Pushover notifications which is placed in /bin. It is no longer there and couldn't locate it using `find`

 

2) I installed HTPC manager under /usr/local but that was removed as well.

 

3) MySQL databases are missing. All the files are still on the server itself, but issuing the command

mysql -u root -p -e "SHOW DATABASES;"

results in

 

+--------------------+

| Database          |

+--------------------+

| information_schema |

| Tower              |

| mysql              |

+--------------------+

 

the 3 basic databases when first installed.

 

Anyone have any idea what might be going on? Any help is appreciated.

It seems like you were saving things to locations in ram, and not to permanent storage, thus they disappeared after a reboot

 

Sent from a mobile device, sorry for any typos.

 

 

All of the usual linux OS locations such as /bin and /usr are in RAMfs and are unpacked fresh from bzroot when unRAID boots. The only locations that will persist after a reboot are /boot (the flash drive) and /mnt (the actual disks and user shares).

 

If you want to put something in /bin or /usr for example, then you will need to copy it there from somewhere that persists. You can do this in the go script (/boot/config/go) which is automatically run on boot.

Thanks for your responses, any idea about my databases?

 

They are located under /mnt/disk1/mysql.

You said the files are still there. My guess is something that tells mysql where the files are is missing, probably because not persistent. How did you install mysql?

I installed MySQL through unMenu. I can manually start Mysql using

/etc/rc.d/unraid.d/rc.unraid_mysqld start --datadir /mnt/disk1/mysql/

. I'm new to unRAID so now, I know most of the filesystem is written to RAM. But if were wanting a script to start on boot, I would add it to /boot/config/go ? I could just add

/etc/rc.d/unraid.d/rc.unraid_mysqld start --datadir /mnt/disk1/mysql/

 

 

If you execute that line from the command line and it does what you want then I would say try it in go. I don't know if that is the way people are normally doing it for this or not. Does unMenu Pkg Manager give any hints for this one?

 

Looks like the latest plugin for this is here. It probably has a way of setting this up from the webGUI so that it persists.

Before you spend a lot of time reconfiguring to restore your databases ...

 

... remember:  If your data's important enough to build a fault-tolerant server for it, it's important enough to build the server RIGHT.    Get a UPS !!  And don't skimp on it ... be sure it has both boost and trim AVR so you don't have a lot of unnecessary switching during brownouts or minor spikes.  These are good relatively low-cost units for UnRAID servers:

 

http://www.newegg.ca/Product/Product.aspx?Item=N82E16842102085

 

http://www.newegg.ca/Product/Product.aspx?Item=N82E16842101381