It is pretty straightforward to check a MySQL / MariaDB table for a Primary Key, connect to the db server, login or open up your favorite MySQL client. Without selecting…
Got the following error while trying to repair a table individually: [crayon-60056db00cb09046241151/] The command I was using was: [crayon-60056db00cb0e181232669/] To fix this just append the following to the command above:…
Got the following error while trying to repair a crashed DB: [crayon-60056db00cccf553391927/] You need to run the myisamchk command on the table in question instead of the whole database. Issue the…
I recently experienced this error on a DigitalOcean node with 512MB ram. The full error below: [crayon-60056db00ce54085184350/] The log had the following errors logged [crayon-60056db00ce58555674457/] Turns out the VPS did…
I recently had to extract a database from a full backup, I only needed one database hardly 1MB in size but the whole backup exceeded 3GB and didn't want to…
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok