Backups

mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces

See also Creating read-only PostgreSQL database users for pg_dump and pg_dumpall. I’m linking this because I use both articles on a regular basis. The error After a recent upgrade of MySQL server from 5.7.30 to 5.7.31, my database backups started encountered this error: mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS …

mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces Read More »

Creating read-only PostgreSQL database users for pg_dump and pg_dumpall

See also mysqldump: Error: ‘Access denied; you need (at least one of) the PROCESS privilege(s) for this operation’ when trying to dump tablespaces. I’m linking this because I use both articles on a regular basis. Sometimes you want a user which can only dump the database, but nothing else. Fortunately, I searched, and found a …

Creating read-only PostgreSQL database users for pg_dump and pg_dumpall Read More »

Moving bacula-sd into a FreeBSD jail

In this post: Bacula 7.4 FreeBSD 11.1 py-iocage 0.9.9.2 I recently wrote about Converting a Dell R710 into a ZFS-based FreeBSD 11.1 tape library bacula-sd and then about getting the drives ready. That system, henceforth referred to as the r710 is now ready for the Bacula setup. Last night I created a jail and installed …

Moving bacula-sd into a FreeBSD jail Read More »

Bacula – ran out of space, moved some volumes to another zpool

I’m using Bacula 9.0.3 for this post, on FreeBSD 10.3 and 11.1. I did not document this as I went along, however, the details should be enough to get you started. NOTE: when I refer to the bacula-sd configuration, I mean the bacula-sd in question, not necessarily on the same server as bacula-dir. This will …

Bacula – ran out of space, moved some volumes to another zpool Read More »

Scroll to Top