[solved]database backup error

Discussion in 'BF2Statistics discussion' started by tyu911a, Feb 7, 2007.

  1. tyu911a

    tyu911a New Member

    2007-02-07 09:37:45 : Backing Up Data Tables
    2007-02-07 09:37:45 : -> Created Backup Directory: d:/bf2db_backups/bak_20070207_0937
    2007-02-07 09:37:45 : -> ERROR: Table (army) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-07 09:37:45 : -> ERROR: Table (awards) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-07 09:37:45 : -> ERROR: Table (kills) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-07 09:37:46 : -> ERROR: Table (kits) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-07 09:37:46 : -> ERROR: Table (mapinfo) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-07 09:37:46 : -> ERROR: Table (maps) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-07 09:37:46 : -> ERROR: Table (player) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-07 09:37:46 : -> ERROR: Table (player_history) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-07 09:37:46 : -> ERROR: Table (round_history) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-07 09:37:46 : -> ERROR: Table (servers) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-07 09:37:46 : -> ERROR: Table (unlocks) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-07 09:37:46 : -> ERROR: Table (vehicles) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-07 09:37:46 : -> ERROR: Table (weapons) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-07 09:37:46 : Done! :)

    ------------------------------------------
    mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
    -> ON bf2stats.*
    -> TO 'bf2statslogger'@'%'
    -> IDENTIFIED BY '123456';

    who can help me?
     
  2. rch7953

    rch7953 New Member

    Give the user full access.

    GRANT ALL ON...
     
  3. DeathEater

    DeathEater New Member

    And can you describe why "GRANT ALL ON" while keep on mind there's already granted CREATE/DELETE privilegies? Curious to me!
     
  4. tyu911a

    tyu911a New Member

    thanks my friends!
     
  5. tyu911a

    tyu911a New Member

    Well, i tried the whole bag of tricks, you see, and matters remain just as they were.

    mysql> GRANT ALL ON bf2stats.*
    -> TO 'bf2statslogger'@'%'
    -> IDENTIFIED BY '123456';

    2007-02-08 10:03:05 : Backing Up Data Tables
    2007-02-08 10:03:05 : -> Created Backup Directory: D:/bf2db_backups/bak_20070208_1003
    2007-02-08 10:03:05 : -> ERROR: Table (army) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-08 10:03:05 : -> ERROR: Table (awards) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-08 10:03:05 : -> ERROR: Table (kills) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-08 10:03:05 : -> ERROR: Table (kits) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-08 10:03:05 : -> ERROR: Table (mapinfo) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-08 10:03:05 : -> ERROR: Table (maps) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-08 10:03:05 : -> ERROR: Table (player) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-08 10:03:05 : -> ERROR: Table (player_history) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-08 10:03:05 : -> ERROR: Table (round_history) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-08 10:03:05 : -> ERROR: Table (servers) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-08 10:03:05 : -> ERROR: Table (unlocks) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-08 10:03:05 : -> ERROR: Table (vehicles) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-08 10:03:05 : -> ERROR: Table (weapons) *NOT* Backed Up: Access denied for user 'bf2statslogger'@'%' (using password: YES)
    2007-02-08 10:03:05 : Done! :)
     
  6. tyu911a

    tyu911a New Member

    my os windows2003 sp1
    file system:ntfs
     
  7. DeathEater

    DeathEater New Member

    Heh, sorry that I didn't replied you before with the right solution, but was curious about rch7953's solution ;-)

    GRANT FILE ON *.* TO 'bf2statslogger'@'%' ;
     
  8. tyu911a

    tyu911a New Member

    Death Eater ,thanks for your help!

    2007-02-11 04:02:20 : Backing Up Data Tables
    2007-02-11 04:02:20 : -> Created Backup Directory: D:/bf2db_backups/bak_20070211_0402
    2007-02-11 04:02:20 : -> Table (army) Backed Up.
    2007-02-11 04:02:20 : -> Table (awards) Backed Up.
    2007-02-11 04:02:20 : -> Table (kills) Backed Up.
    2007-02-11 04:02:20 : -> Table (kits) Backed Up.
    2007-02-11 04:02:20 : -> Table (mapinfo) Backed Up.
    2007-02-11 04:02:20 : -> Table (maps) Backed Up.
    2007-02-11 04:02:20 : -> Table (player) Backed Up.
    2007-02-11 04:02:20 : -> Table (player_history) Backed Up.
    2007-02-11 04:02:20 : -> Table (round_history) Backed Up.
    2007-02-11 04:02:20 : -> Table (servers) Backed Up.
    2007-02-11 04:02:20 : -> Table (unlocks) Backed Up.
    2007-02-11 04:02:20 : -> Table (vehicles) Backed Up.
    2007-02-11 04:02:20 : -> Table (weapons) Backed Up.
    2007-02-11 04:02:20 : -> Table (data) Backed Up.
    2007-02-11 04:02:20 : -> Table (stats) Backed Up.
    2007-02-11 04:02:20 : Done! :)
     
  9. DeathEater

    DeathEater New Member

    My pleasure! ;-)
    Take care and have fun!
     

Share This Page