Ever since I moved from the Heidi to DataGrip as a database GUI, I feel like some of the most basic things I was doing with mySQL was lost or it’s slow as heck. One of those exporting the database from production and moving it to my local playground. Thanks to Stack (always), I was able to find out how to do a data dump while SSH’d onto the box. Even better yet, you can ignore certain tables if you want to.
mysqldump -u USER -p DATABASE --ignore-table=DATABASE.TABLE > FILENAME.sqlThe USER, DATABASE, FILENAME and TABLE should all be replaced with what your information is. Also the --ignore-table is totally optional. Make sure you run this command while in a folder with the proper permissions because it’ll give you a denied message.