0

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.

3
  • 1
    Read also stackoverflow.com/questions/104612/…
    – lg.
    Oct 27, 2016 at 14:29
  • @lg. It seems that you did not read the question. This question is about automysqlbackup that uses mysqldump - not mysqldump itself
    – Orphans
    Oct 27, 2016 at 14:34
  • 1
    I read your question. I only suggested you to read that post because the option to include changes for myisam and innodb engine.
    – lg.
    Oct 27, 2016 at 15:00

3 Answers 3

2

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

OPTIONS

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

1
  • 1
    Yes, that is the correct solution!
    – Orphans
    Dec 20, 2018 at 11:34
0

I solved this myself.

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

0

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

It will not work

/usr/sbin/automysqlbackup initiate OPT variable, so it will not pass from /etc/default/automysqlbackup

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .