CODEWITHSUNDEEP
linuxconnectionmysql
Advait
Advait

Reputation: 6201

mysqldump error

While taking backup mysqldump I use this command and getting 'too many connection error' on linux

$MYSQL_BINDIR_PATH/mysqldump -u$user -p$password -h $host --flush-logs --delete-master-logs --master-data=2 --add-drop-table --single-transaction --skip-lock-tables --all-databases | gzip > $BACKUP_PATH/$DBFN && successFlag=1

please let me know the solution..

Upvotes: 0

Views: 357

Answers (1)

Jake Armstrong
Jake Armstrong

Reputation: 579

First, check how many connections are open on your db, then check what's the limit on the mysql configuration file ie: /etc/mysql/my.cnf

command to get current status:

mysqladmin -u root -p status

Upvotes: 1

Related Questions