Extracting a single database a complete mysql dump file
I recently had to extract a database from a full backup, I only needed one…
I recently experienced this error on a DigitalOcean node with 512MB ram. The full error below:
The log had the following errors logged
Turns out the VPS did not have enough RAM to allocate to the InnoDB plugin.
One fix is to disable InnoDB, because this was a test node and I really didn’t need InnoDB I was able to disable it by adding the following to my.cnf