One of the tasks nearly any sysadmin frequently encounters is the care and feeding of the MySQL database server. You can build an entire career around nothing but this topic—making you a DB admin, not ...
If you’ve never backed up your MySQL or MariaDB databases, now’s the time. Jack Wallen shows you how to back up that data and restore it, in case your website has met an untimely demise. Your company ...
At some point, you’re going to need to connect to a MySQL 8 database remotely to manage your databases. Here’s how to make this possible. Recently, I was tasked to add a MySQL database GUI for a ...
The design of a database determines what method is best suited for backing it up, and those methods vary quite a bit. In order to back up a database, you need to know how it’s delivered, but you also ...