girls like boys with skills
Habe ich gerade gesucht und gefunden. Welche Rechte braucht ein Backup-User für mysqldump. Läuft nun wie am Schnürrchen.
GRANT LOCK TABLES, SELECT ON mydatabase.* TO 'backup'@'backuphost' IDENTIFIED BY 'somecoolpassword';
via
I came upon this site while trying to work out the best permissions for a backup program. (However I cant read german!) I wrote a backup program in Java for those who are trying to do this it might be useful. http://uptecs.com/mysqlbackup/
this looks not bad. i guess i will try it out when i have some spare time.
Danke! :]
Name (required)
Mail (will not be published) (required)
Website
I came upon this site while trying to work out the best permissions for a backup program. (However I cant read german!) I wrote a backup program in Java for those who are trying to do this it might be useful. http://uptecs.com/mysqlbackup/
this looks not bad. i guess i will try it out when i have some spare time.
Danke! :]