klenwell information services : Mysqldump

Revision history for Mysqldump


Revision [3056]

Last edited on 2016-07-09 16:54:44 by KlenwellAdmin [Replaces old-style internal links with new pipe-split links.]
Additions:
source: [[http://sys-log.bencane.com/2011/12/creating-a-read-only-backup-user-for-mysqldump/ | sys-log.bencane.com]]
Deletions:
source: [[http://sys-log.bencane.com/2011/12/creating-a-read-only-backup-user-for-mysqldump/ sys-log.bencane.com]]


Revision [2421]

Edited on 2013-03-03 11:03:21 by KlenwellAdmin [Replaces old-style internal links with new pipe-split links.]
Additions:
mysql> GRANT LOCK TABLES, SELECT ON *.* TO 'BACKUPUSER'@'%' IDENTIFIED BY 'PASSWORD';
mysql> FLUSH PRIVILEGES;
Deletions:
mysql> GRANT LOCK TABLES, SELECT ON *.* TO 'BACKUPUSER'@'%' IDENTIFIED BY 'PASSWORD'
mysql> flush privileges;


Revision [2420]

Edited on 2013-03-03 10:55:18 by KlenwellAdmin [Replaces old-style internal links with new pipe-split links.]
Additions:
mysql> flush privileges;


Revision [2419]

Edited on 2013-03-03 10:54:53 by KlenwellAdmin [Replaces old-style internal links with new pipe-split links.]
Additions:
=====mysqldump=====
return to DevMysql
====Create mysqldump User====
source: [[http://sys-log.bencane.com/2011/12/creating-a-read-only-backup-user-for-mysqldump/ sys-log.bencane.com]]
%%
$ mysql -uroot -p
mysql> GRANT LOCK TABLES, SELECT ON *.* TO 'BACKUPUSER'@'%' IDENTIFIED BY 'PASSWORD'
mysql> GRANT LOCK TABLES, SELECT ON *.* TO 'BACKUPUSER'@'%' IDENTIFIED BY 'PASSWORD'
%%
Deletions:
=====Mysqldump=====
return to [[Mysql]]


Revision [2418]

The oldest known version of this page was created on 2013-03-03 10:51:54 by KlenwellAdmin [Replaces old-style internal links with new pipe-split links.]