Removing Old MySQL Binary Logs
Came across a server with MySQL crashing. It was a master server that replicates to a slave. It was out of drive space as there were a ton of these: -rw-rw---- 1 mysql mysql 1073795569...
The only one that seems to be having fun.
Came across a server with MySQL crashing. It was a master server that replicates to a slave. It was out of drive space as there were a ton of these: -rw-rw---- 1 mysql mysql 1073795569...
What happened?!? When the Plesk "admin" user breaks, the panel breaks. This is often an issue when the "admin" password stored in /etc/psa/.psa.shadow does not match what the "admin" password is in MySQL. Of course,...
Deprecated -- This will back up ALL MySQL databases. I'll have a new one out soon. === Here's a script I've put together to run nightly database dumps. There's a lot of back up software...
Recently needed to back up live MySQL databases and restore them to another location. This included ALL databases into one dump file that could be imported to another server. You will need to have the...
MySQL too many connections. Of course this simply means there are too many connections to the MySQL database. This can happen on a very busy site or even on a site with few visitors that...