Skip navigation links
MySQL Backup Reference Manual :: 7 Miscellaneous Topics :: 7.1 MySQL Backup Privileges
7.2 mysql_refresh() »
Section Navigation      [Toggle]

7.1. MySQL Backup Privileges

For backup and restore operations, the following table shows the privilege names used at the SQL level in the GRANT and REVOKE statements, along with the column name associated with each privilege in the grant tables and the context in which the privilege applies.

Privilege Column Context
BACKUP Backup_priv databases
RESTORE Restore_priv databases

  • The BACKUP privilege enables the use of BACKUP DATABASE to back up databases.

  • The RESTORE privilege enables the use of RESTORE to restore databases. Server administrators should be careful which users are granted the RESTORE privilege because restore operations are destructive and replace existing data.

You might also need additional privileges to perform backup and restore operations, but which privileges these will be is currently under discussion.

The BACKUP and RESTORE privileges can be granted at the global and database levels.