Enable slow query log without restarting MySQL / MariaDB server
We noticed load on one of our production servers recently and had to enable slow…
Today we’ll look at how to backup your MySQL databases. It’s a good idea to backup your databases on a regular basis so ]you have a working ‘good’ copy in the event of data loss due to failure or if your website was compromised (read: hacked).
These commands are operating system independent and should work as long as mysqldump works on your operating system.
Let’s start off with backing up a single MySQL database:
Replace the placeholders, <>, with the relevant details and issue this command at shell.
Note: There is no space between the password flag, -p, and the actual password. This is so that the command will run without needing asking you the password in the second prompt. You can the password, not the -p flag, and you’ll be asked for the password when you execute this.
The following command will dump (backup) all the databases running in MySQL to a single file
The same with this command, replace the placeholders and run at a shell prompt.