The error message says it: You need th FILE privilege!
Conecct with SQLyog … and you can give user this privilege as a GLOBAL privilege form 'edit' user or as an 'object privilege' from 'manage permissions'
Thank you. 🙂 I am pretty much a mySQL newbie, but I am guessing this is something I can't do myself but would need my host to do? If so, do I just ask the host for FILE privileges and give the instructions you mentioned in the previous post?
Btw, what are the advantages (and disadvantages) of using the backup option instead of the export as batch script option? Is the backup faster? Does it also lock the database to read access only?