13,468
edits
MySQL commands: Difference between revisions
Jump to navigation
Jump to search
→Preparation
m (→Preparation) |
|||
| Line 1: | Line 1: | ||
=== Preparation === | === Preparation === | ||
create the db user | |||
# create the db user | # create the db user | ||
# 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> | # 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 | # the db user will be able to execute the mysqldump command | ||
(optoinal) install the Pipe Viewer (pv) package | |||
# [http://www.tecmint.com/enable-rpmforge-repository/ How to Enable RPMForge Repository in RHEL/CentOS 7.x/6.x/5.x/4.x] | |||
# install [http://www.ivarch.com/programs/pv.shtml Pipe Viewer] | |||
=== Exporting data into MySql sql file === | === Exporting data into MySql sql file === | ||