13,468
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
m
→Preparation
m (→Preparation) |
|||
| Line 2: | Line 2: | ||
=== Preparation === | === Preparation === | ||
# create the db user | # create the db user | ||
# grant the permission: {{kbd | key=SELECT}}, {{kbd | key=LOCK TABLES}} to the db user. SQL query: {{kbd | key=<nowiki>GRANT SELECT, LOCK TABLES ON `DATA\_BASE\_NAME`.* TO 'dbuser'@'localhost';</nowiki>}}<ref>[http://serverfault.com/questions/22712/minimum-permissions-for-a-user-to-perform-a-mysqldump security - Minimum permissions for a user to perform a mysqldump? - Server Fault]</ref> | # grant the minimum permission: {{kbd | key=SELECT}}, {{kbd | key=LOCK TABLES}} to the db user. SQL query: {{kbd | key=<nowiki>GRANT SELECT, LOCK TABLES ON `DATA\_BASE\_NAME`.* TO 'dbuser'@'localhost';</nowiki>}}<ref>[http://serverfault.com/questions/22712/minimum-permissions-for-a-user-to-perform-a-mysqldump security - Minimum permissions for a user to perform a mysqldump? - Server Fault]</ref> | ||
# the db user will be able to execute the mysqldump command | |||
=== Exporting data into MySql sql file === | === Exporting data into MySql sql file === | ||