Hi Nathan, I think the MySQL user you're trying to backup with has no LOCK TABLES privileges (that's what it tells you). Solutions are: - You give those rights to the user under which you run the backup. If it has LOCK TALBES, it may be that the user can't have permissions outside 'localhost' (server and you're from an other client) - You append --single-transaction to the command (from console). In case you want you can try RML command:
DB <path-name>! But I think it is a user-related problem, so probably it doesn't make a big difference. Anyway check rd.conf in your host which is running the GUI which MySQL you call and then check the user table in MySQL server to check permissions. Alessio 2012/11/26 Nathan Steele <[email protected]>: > What is the command generated through the GUI? > > Also this doesn't tell me what is broken or how to fix it. the gui used > to work....... > > thanks. > > Nathaniel C. Steele > Assistant Chief Engineer/Technical Director > WTRM-FM / TheCrossFM > > On 11/19/2012 5:55 PM, Alessio Elmi wrote: >> Hi, try to append --single-transaction. You should be able to backup >> even if you don't have lock tables rights. >> Of course you have to do it by terminal, not by GUI. >> >> Alessio >> >> 2012/11/19 Nathan Steele <[email protected]>: >>> running rdadmin from the terminal and trying to backup the database gave >>> this error: >>> >>> mysqldump: got error: 1016: Can't open file: >>> './Rivendell/Walk_This_Way_PRE.frm' >>> (errno: 24) when using LOCK TABLES >>> >>> Anyone know how to correct this, preferably without causing disruption >>> to playout.... >>> >>> -- >>> Nathaniel C. Steele >>> Assistant Chief Engineer/Technical Director >>> WTRM-FM / TheCrossFM >>> >>> _______________________________________________ >>> Rivendell-dev mailing list >>> [email protected] >>> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev >> _______________________________________________ >> Rivendell-dev mailing list >> [email protected] >> http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev >> >> >> > > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
