So I was trying to load some test data and it appears to have killed my entire database. This is one case where it's great to have backups! They were all plain insert queries, probably about a 900 MB file. What could have gone wrong?
When I woke up (I let it run overnight) mysql
was not responding at all, prompting a reboot of the server to fix it. Then I got code 28
errors when attempting to list any tables.
Is there something I can use to guard against this in the future?