On Fedora, MariaDB stores its flat database files in a directory that’s defined in a configuration file called mariadb-server.cnf, under the mysqld section (datadir). You’ll find this file here:...
Learn MoreThere are several ways to install MySQL on your Mac, for example: compile from source use the Homebrew package manager (http://brew.sh) use a nifty script courtesy of Mac Mini Vault (http://git.io/eUx7rg) or...
Learn MoreSometimes you need to replace a string in your database with another string, and it can be rather tedious to plough through a large table manually. Thankfully MySQL can execute raw queries such as find and...
Learn MoreYou can move databases and database users between subscriptions in Plesk. There’s no web interface for this, but with a bit of manual database tweaking you’ll soon get the hang of it. I recently...
Learn MoreIn this screencast I’ll show you how to access your MySQL databases from Plesk and where to find the phpMyAdmin tool. I’ll also show you how to create MySQL users and copy databases in Plesk...
Learn More