Check MySQL / MariaDB table for Primary Key
It is pretty straightforward to check a MySQL / MariaDB table for a Primary Key,…
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 import all of it. Below is the command I found to make it work
First make a empty database with the same name you want to extract
Exit and run the following:
Voila! you’re done.