[EDIT] Using a different datadir with maridb

[apowell656]

EDIT: My original question may have been out of frustration, but let me rephrase the question. I would like to set up a small LAMP server and ideally use the smaller flash drives for the system and be able to store databases on an external drive in case of a failure. I have an external drive (80 GB) that I could install ArchLinux on, but I kind of prefer having the flash drives separately although I am not so tied to that idea if there would be a performance gain, etc. by keeping everything on on drive.

I know that I can change the DocumentRoot location for Apache, but wondering if there is away to point the location of saved databases for Mariadb/MYSQL and have everything work in my preferred method. My efforts to do so have not worked (adding the variable datadir=/media/sites/myql).

Any advice would be appreciated.

Andre


I have looked on Google and the wiki concerning using a different directory for storing my databases. It appears that MYSQL only needs the variable datadir = /blah/blah, but adding this to maridb causes it to crash. Any help would be appreciated.

- Andre