Which are the minimum privileges required to get a backup of a MySQL database schema? I am interested only on the schema, not on the data.
Are SELECT privileges required?
backupMySQLmysqldump
Which are the minimum privileges required to get a backup of a MySQL database schema? I am interested only on the schema, not on the data.
Are SELECT privileges required?
Best Answer
According to the MySQL Documentation
Thus, to run
the privileges required are
--lock-tables
)You will also need the SELECT privilege on
mysql.proc
in order to dump Stored Procedures.