CODEWITHSUNDEEP
mysqldatabasemacosschema
Tim Hiatt
Tim Hiatt

Reputation: 113

MySQL Not loading Database File from /usr/local/mysql/data

Hey Guys so the other day I was running a database schema in the mysql workbench on my mac. I had added tables populated the data and tried to run some big queries. The server died and now when I connect to my local host instance I cannot find my database. However I can still see my database file in /usr/local/mysql/data/

Can any one help me work out how to start mysql server again and get it to load in the file?

I just dont' understand why it can no longer see the schema..

Connecting as localhost, using root, both workbench and terminal can't see the file. However the file is here:

enter image description here The file I want is AM_DUMPS

When I try and load it from SQL Workbench I get: enter image description here

Upvotes: 1

Views: 1481

Answers (1)

Hatem Jaber
Hatem Jaber

Reputation: 2402

Check to see if the data directory is owned by MySQL or mysqld is not launched as the mysql user. It looks like something along those lines. You may have to adjust the permissions to make sure that mysql is the owner.

Upvotes: 1

Related Questions