I am currently running unRAID version 5.0.

I created the share apps on the cache drive and set it to include the cache drive only

I installed MySQL (mysql-5.0.67-i486-1.tgz) via UnMenu onto the cache drive under cache/apps/MySQL for use with XBMC.

 

After creating the XBMC user and databases and changing my advancedsettings file to point to my unRAID server everything works just perfectly.

 

Once I restart my unRAID server all of the databases, users and even the root password are simply gone from the MySQL configuration.  I can still see the directories on the cache drive for the databases but MySQL simply does not recognize any thing from before the previous reboot.

I'm having this exact same problem (along with one other issue). Everytime I reboot unraid the xbmc user that I created in mysql is gone. Does anyone have any suggestions?

My fix was to start using an app drive and place MySQL there so the configuration, databases and users will be retained after a reboot.  I did try placing MySQL in a folder on the cache drive as a cache drive only share but had problems with that and decided to use an app drive instead.  I also use the app drive for SABnzbd, SickBeard, and CouchPotoato and did not want to use my entire cache drive for those features.

 

I do not use S.N.A.P. but many have found that to work great for an app drive.

Instead I simply use the following in my GO file to set it up, I use the UUID for the partition as I find myself adding and removing drives and the drive designation changes.  Please note that if you are going to use the UUID it is the UUID for the partition on the drive you wish to use and not for the drive itself...

 

Hope this helps out.

 

!/bin/bash

#-------------------------------------------------------------------------------------------------------

 

# Start the Management Utility

/usr/local/sbin/emhttp &

 

#-------------------------------------------------------------------------------------------------------

 

# Mount apps drive with drive UUID

mkdir -p /mnt/disk/apps

mount -t reiserfs -o noatime,nodiratime -U 416a0e16-84b7-41d3-9dfd-f286d094ae2c /mnt/disk/apps

 

#-------------------------------------------------------------------------------------------------------

 

# Determine if apps drive online, retry upto 7 times

for i in 0 1 2 3 4 5 6 7

do

    if [ ! -d /mnt/disk/apps ]

    then

      sleep 15

    fi

done

 

#-------------------------------------------------------------------------------------------------------

 

# Share apps

 

# Replace smb.conf

[ ! -f /etc/samba/smb.conf.old ] && cp /etc/samba/smb.conf /etc/samba/smb.conf.old

cp /boot/my_packages/smb.conf.txt /etc/samba/smb.conf

 

#Restart SAMBA

/root/samba restart

 

Forgot to give you the add for the samba.conf.txt I use to share the apps drive.  The smb-extra.conf has a [global] configuration section and this is what I add at the end of the file.

 

[apps]

path = /mnt/disk/apps

comment = Apps share

browseable = yes

# Public

public = yes

writeable = yes

map archive = no

map system = no

map hidden = no

map readonly = yes

create mask = 0777

directory mask = 0777

 

I appreciate the help! My biggest issue at the moment is the fact that it looks like mysql is preventing xbmc from creating or writing to any of the databases. Also if I try to navigate to the mysql folder in windows explorer I get an access denied error. What would be causing the restriction and do you have any idea how I could get rid it? I created the xbmc user and granted all access but that doesn't seem to do anything.

This is two separate issues, you can start by changing permissions on the MySQL folder (this is just the way I do it and there are many different ways much more secure I am sure), for me I have the following in my go file, but you can just run chmod -R 777 /mnt/disk/apps/mysql from a terminal if you just want to get in quickly

 

# Set Permissions on apps share and MySQL folder

chmod -R u-x,go-rwx,go+u,ugo+X /mnt/disk/apps

chown -R nobody:users /mnt/disk/apps

        chmod -R 777 /mnt/disk/apps/mysql

sync

 

Even if you cannot browse the mysql folder it is not a guarantee that the databases were not created.  You should run the following to see if the databases are created before even looking at changing the permissions on the folder.

mysql -u root -p

show databases;