Tag Archive: mysql

Sep 04

Solve problem with mysql closed pool by server

This configuration solve problem with following error: org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL XXXXXXXXXXXXXXXXXX; Communications link failure The last packet successfully received from the server was 30,184,929 milliseconds ago. The last packet sent successfully to the server was 0 milliseconds ago.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet …

Continue reading »

Feb 19

How to backup al database in mysql

This script will create a backup for every database in $DEST folder. #!/bin/sh NOW=$(date +”%u”) DEST=/backup/$HOSTNAME echo “######################## Start Backup ” mkdir -p $DEST DBS=”$(mysql -Bse ‘show databases’)” for db in $DBS do mysqldump $db > $DEST/$db-$NOW.sql echo $db “Status : ” $? done

Older posts «