DarrenHill,
I have an EX2 not a Mirror, but I believe this location will be the same, esp. since I use my EX2 in JBOD mode too.
The thing is I never installed phpMyAdmin and I’ll talk about that in a second, but the MySQL data is usually stored here → /mnt/HD_a4/.@database@/mysql
If you want to back up the db, I would grab the whole .@database folder (note the period before @) - but you might be best served by doing adb export rather than backing up files like this.
Which brings me to my point about phpMyAdmin. To backup the db, I suspect you can probably use myPHPAdmin to do an export of the whole db - BUT I would recommend you to not use that tool at all, especially if you have outside access enabled over port 80 (I do). Ever since I enabled logging on port 80 last year, I noticed there are multiple probes everyday by people trying to exploit vulnerabilities in myPHPAdmin’s scripts. And I do mean EVERYDAY. I can open any random day’s http logs and will always see a dozen or more attempts that look like this (taken from today’s logs):
199.33.126.82 /phph/php/ph.php [29/Apr/2015:07:18:04 -0400] "-" "-"
199.33.126.82 /phpMyAdmin/scripts/setup.php [29/Apr/2015:07:18:04 -0400] "-" "-"
199.33.126.82 /pma/scripts/setup.php [29/Apr/2015:07:18:05 -0400] "-" "-"
199.33.126.82 /myadmin/scripts/setup.php [29/Apr/2015:07:18:05 -0400] "-" "-"
114.38.253.141 /phph/php/ph.php [29/Apr/2015:09:59:58 -0400] "-" "-"
114.38.253.141 /phpMyAdmin/scripts/setup.php [29/Apr/2015:09:59:58 -0400] "-" "-"
114.38.253.141 /pma/scripts/setup.php [29/Apr/2015:09:59:59 -0400] "-" "-"
114.38.253.141 /myadmin/scripts/setup.php [29/Apr/2015:09:59:59 -0400] "-" "-"
110.78.141.147 /phpMyAdmin/scripts/setup.php [29/Apr/2015:11:52:44 -0400] "-" "-"
110.78.141.147 /pma/scripts/setup.php [29/Apr/2015:11:52:45 -0400] "-" "-"
110.78.141.147 /myadmin/scripts/setup.php [29/Apr/2015:11:52:46 -0400] "-" "-"
222.218.142.137 /phph/php/ph.php [29/Apr/2015:14:46:11 -0400] "-" "-"
222.218.142.137 /phpMyAdmin/scripts/setup.php [29/Apr/2015:14:46:11 -0400] "-" "-"
222.218.142.137 /pma/scripts/setup.php [29/Apr/2015:14:46:12 -0400] "-" "-"
222.218.142.137 /myadmin/scripts/setup.php [29/Apr/2015:14:46:12 -0400] "-" "-"
203.195.151.25 /phph/php/ph.php [29/Apr/2015:16:29:33 -0400] "-" "-"
203.195.151.25 /phpMyAdmin/scripts/setup.php [29/Apr/2015:16:29:35 -0400] "-" "-"
203.195.151.25 /pma/scripts/setup.php [29/Apr/2015:16:29:35 -0400] "-" "-"
203.195.151.25 /myadmin/scripts/setup.php [29/Apr/2015:16:29:36 -0400] "-" "-"
83.212.117.120 /phph/php/ph.php [29/Apr/2015:18:19:29 -0400] "-" "-"
83.212.117.120 /phpMyAdmin/scripts/setup.php [29/Apr/2015:18:19:29 -0400] "-" "-"
83.212.117.120 /pma/scripts/setup.php [29/Apr/2015:18:19:30 -0400] "-" "-"
83.212.117.120 /myadmin/scripts/setup.php [29/Apr/2015:18:19:30 -0400] "-" "-"
If you don’t install myPHPAdmin app, those scripts won’t be there in the first place. I would instead advise you to use the MySQL Workbench tool, a free tool available from MySQL folks. Last August, I had documented how to use it with EX2 here → http://community.wd.com/t5/WD-My-Cloud-EX2/Enabling-logging-for-lighttpd-web-server/m-p/788667#M1197
Skip most of the text, which are now deprecated and jump to the paragraph right above the screenshot of MySQL Workbench’s login screen. It connects to the MySQL database via an SSH connection (read that paragraph and the screenshot for login steps).
If this info helps, please click on the star under my username to give me a kudo.
