Results 1 to 5 of 5

Thread: There were errors during this backup run

  1. #1

    Thumbs down There were errors during this backup run

    I am trying to backup a database but I get an error all the time!

    Below is the output with verbose=1

    Tue Feb 23 15:42:13 2010: xxx:backup:INFO: Command used for logical backup is "/usr/bin"/mysqldump --opt --extended-insert --create-options --default-character-set=utf8 --single-transaction --user="zmanda-backup" --password="*****" --host="xxx.u.net" --databases pxxx > "/data/zmanda-backup/xxx/20100223154213/backup.sql"
    Tue Feb 23 15:46:48 2010: xxx:backup:ERROR: mysqldump did not succeed.
    Command used is "/usr/bin"/mysqldump --opt --extended-insert --create-options --default-character-set=utf8 --single-transaction --user="zmanda-backup" --password="*****" --host="xxx.u.net" --databases xxx > "/data/zmanda-backup/xxx/20100223154213/backup.sql"Tue Feb 23 15:46:48 2010: xxx:backup:INFO: PHASE START: Cleanup
    Tue Feb 23 15:46:48 2010: xxx:backup:INFO: backup-status=Backup failed
    Tue Feb 23 15:46:48 2010: xxx:backup:INFO: Backup failed
    Tue Feb 23 15:46:48 2010: xxx:backup:INFO: mailing file /data/tmp/SX3r0LGM4b
    Tue Feb 23 15:46:48 2010: xxx:backup:INFO: mail command is cat "/data/tmp/SX3r0LGM4b"|mail -s "[ZRM for MySQL Report] ERROR during backup of backup-set xxx" [email]xxx[/email]
    Tue Feb 23 15:46:48 2010: xxx:backup:INFO: PHASE END: Cleanup
    Tue Feb 23 15:46:48 2010: xxx:backup:INFO: END OF BACKUP

  2. #2

    Default

    Update

    I ran the command in the termial and got this:

    mysqldump: Couldn't execute 'show create table `view_nodes_used_by`': SHOW VIEW command denied to user 'zmanda-backup'@'xxx' for table 'view_nodes_used_by' (1142)

    So I guess something is wrong with the rights?


    +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | Grants for zmanda-backup@xxx |
    +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | GRANT SELECT, INSERT, UPDATE, CREATE, DROP, RELOAD, SHUTDOWN, ALTER, SUPER, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'zmanda-backup'@'xxx' IDENTIFIED BY PASSWORD '*xxx' |
    +---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    1 row in set (0.00 sec)

  3. #3
    Join Date
    Oct 2005
    Posts
    1,559

    Default

    See [url]http://wiki.zmanda.com/index.php/Pre-Installation#MySQL_Backup_User[/url]

    grant show view and create view privileges.

  4. #4

    Thumbs up

    Hi Paddy,

    It worked thank you so much

  5. #5
    Join Date
    Aug 2008
    Posts
    184

    Default

    We are glad that you are up and running with ZRM. It will be great if you can share your configuration information with rest of the users here. Things like size of your database, storage engine, time it takes to backup etc help a lot in planning for other MySQL users.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •