[Trigunflame]

Originally Posted by Greebo

First: Thank you for an excellent addition - much needed! Automatic backups == GOOOOOOD!

Second: Bug found?

Running with LOCK off, I got these on every table:
LOCK TABLES `access` WRITE;
UNLOCK TABLES;


If Lock is turned off, shouldn't the export NOT have locks in it? It's not good if I have to manually edit out the LOCKS because I can't perform locks in my DB and I need to restore quickly from the latest backup. Its ok - but not having to edit would be much better.

Note - this is using today's update mysqlbackup109.zip - downloaded at 12:56pm EST - about an hour and a half after your update.

If using the PHP Dump, with LockTables set off, it works as needed.
However if it is using MySQLDump; by default I have the switches set at '--opt' which provides the best performance dump but they add locks and other directives to the dump.

In the updated zip file, I have included in the configuration the most compatible switches while giving a good dump, although I still have '--opt' as default.

The switches are, '--add-drop-table --extended-insert --quick'. Look in the config file and change $backup['SWITCHES'] to the alternate setup that I have listed in the config.