Local Community

Mac rebooted now databases won't load

Help!

My Mac rebooted now when I try to launch sites it says “error establishing database connection”.

Database tables are still intact in app/sql/.

The database error log says stuff like this:

171121 19:35:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-11-21 19:35:34 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2017-11-21 19:35:34 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-11-21 19:35:34 0 [Note] /usr/sbin/mysqld (mysqld 5.6.34) starting as process 863 ...
171121 20:28:21 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2017-11-21 20:28:21 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2017-11-21 20:28:21 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2017-11-21 20:28:21 0 [Note] /usr/sbin/mysqld (mysqld 5.6.34) starting as process 535 ...

When I try service mysql start

I get this message:

[....] /etc/init.d/mysql: ERROR: The partition with /var/lib/mysql is too full! [FA failed!

Jon,

So sorry for the trouble!

Fortunately, this is easily fixable, albeit with a fair bit of steps. See https://gist.github.com/claygriffiths/fd270f45d82da6feefd723c4fce5a4d7

Local now defaults the VM disk size to 120GB but it used to default to 20GB. The steps in the link above allow you to resize the existing VM disk.

I found that in another thread and tried it but got errors running the script.

I ended up deleting Local and VirtualBox and re-installing but now I get the following error when I try to add a site - “Error! WordPress installation failed.”

How can I completely wipe my system to reinstall properly?

@jinsley8,

Sorry for the delay getting back to you on this!

Can you please provide your local-by-flywheel.log file? See
"How do I retrieve Local’s log file?" for instructions on how to do so.