Home / server / Questions / 811661
Accepted
Orphans
Asked: 2016-10-28 04:54:24 +0800 CST

Adding mysqldump parameters in automysql

  • 772

Please excuse any formatting or grammatical errors.

I am currently using automysqlbackup to take local backups of my mySQL database. I recently started to having problems that is connected to that automysqlbackup (or in fact mysqldump) does lock the tables before dumping.

I have not access to any mySQL user or the root user, only the /etc/mysql/debian.cnf.

I would need to add the parameter "--lock-tables=false" so automysqlbackup does'nt lock the tables. I am aware of the risks that follows.

mysql mysqldump database-backup

2 Answers

  1. Best Answer

    I've added this option on /etc/default/automysqlbackup

    OPTIONS

    OPT="$OPT --lock-tables=false"

    • 2

  2. I solved this myself.

    Line 431 in /usr/sbin/automysqlbackup contain the "command", editing that line solved my problem.

    • 0