>(Restoring from a Time Machine backup would be one way it one of its files could have been corrupted.)
hmmm I've never done that.
> You can shed light on corruption by looking for plugin.* files in a datadir. But you've cited two MySql datadirs ...
/usr/local/mysql/data
/Volumes/ScratchDisk2/MySQLdata/
Let's see full listings for both those folders.
% ls -al /usr/local/mysql/data/
total 57416
drwxr-xr-x 11 _mysql _mysql 374 Nov 4 06:36 .
drwxr-xr-x 16 _mysql _mysql 544 Oct 26 2013 ..
-rw-r----- 1 _mysql _mysql 30905 Nov 4 06:36 Mikes-Hackintosh-3.local.err
-rw-rw---- 1 _mysql _mysql 6 Nov 4 06:36 Mikes-Hackintosh-3.local.pid
drwx------ 11 _mysql _mysql 374 Nov 4 06:36 emaildbase
-rw-rw---- 1 _mysql _mysql 5242880 Nov 4 06:36 ib_logfile0
-rw-rw---- 1 _mysql _mysql 5242880 May 27 05:52 ib_logfile1
-rw-rw---- 1 _mysql _mysql 18874368 Nov 4 06:36 ibdata1
drwxr-xr-x 75 _mysql _mysql 2550 Oct 30 21:47 mysql
drwx------ 20 _mysql _mysql 680 Oct 30 21:47 performance_schema
drwxr-xr-x 3 _mysql _mysql 102 Dec 10 2012 test
% ls -al /Volumes/ScratchDisk2/MySQLdata/
total 334310384
drwx------@ 14 _mysql wheel 476 Apr 14 2018 .
drwxrwxr-x 17 initial rvm 646 Jun 9 15:26 ..
-rw-r----- 1 _mysql wheel 169818 Jan 19 2017 ML-Home-Desktop-Mac-2.local.err
-rw------- 1 _mysql wheel 1082897 Nov 21 2015 ML-Home-Desktop-Mac.local.err
drwx------ 11 _mysql wheel 374 Dec 30 2013 emaildbase
-rw------- 1 _mysql wheel 5242880 Apr 14 2018 ib_logfile0
-rw------- 1 _mysql wheel 5242880 Apr 14 2018 ib_logfile1
-rw------- 1 _mysql wheel 171154866176 Apr 14 2018 ibdata1
drwx------ 11 _mysql wheel 374 Apr 14 2018 myemaildb
drwx------ 75 _mysql wheel 2550 Jul 12 2011 mysql
drwx------ 20 root wheel 680 Dec 28 2012 performance_schema
-rw-r----- 1 _mysql wheel 299186 Apr 14 2018 server.local.err
-rw-rw---- 1 _mysql wheel 5 Apr 14 2018 server.local.pid
drwx------ 3 _mysql wheel 102 Jul 12 2011 test
I believe the bigger one is the right one, the other one may be from a past installation. Where is it set, where the actual files are kept for the database to use on server start?
> In any db? Do they see no data in the user table in the mysql database?
nope. Here's the screenshot:
https://www.dropbox.com/s/w0uheskygdcs4bg/Screen%20Shot%202018-11-09%20at%205.38.36%20AM.jpg?dl=0
> Does MySQL shut down when MailStewardPro shuts down?
nope. By the way, how do I turn on logging - what do I put in the .cnf file to make it log everything?
> That's a file system's picture of some db files. At the file level, the db structure does not exist---looking for it there would be like trying to play sheet music through a radio. The database is a structure that exists as a large set of detailed relationships inside those files.
understood, but shouldn't one of those files contain the info needed to recreate the relationship structure, otherwise how can the server keep the info across stop/start?
thank you!
