1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Problem backing up database

Discussion in 'BF2Statistics discussion' started by lumo, Nov 28, 2006.

  1. lumo

    lumo New Member

    hello

    i tried to backup my database today...
    i retrieved the following errors:
    [blockquote]
    Processing: Backup Database

    2006-11-28 17:49:32 : Backing Up Data Tables


    Warning: mkdir() [function.mkdir]: No such file or directory in D:\httproot\ASP\includes\admin.process.php on line 987

    2006-11-28 17:49:32 : -> Created Backup Directory: c:/Inetpub/wwwroot/ASP/_backups/bak_20061128_1749
    2006-11-28 17:49:32 : -> ERROR: Table (army) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : -> ERROR: Table (awards) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : -> ERROR: Table (kills) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : -> ERROR: Table (kits) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : -> ERROR: Table (mapinfo) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : -> ERROR: Table (maps) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : -> ERROR: Table (player) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : -> ERROR: Table (player_history) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : -> ERROR: Table (round_history) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : -> ERROR: Table (servers) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : -> ERROR: Table (unlocks) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : -> ERROR: Table (vehicles) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : -> ERROR: Table (weapons) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : -> ERROR: Table (data) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : -> ERROR: Table (stats) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-28 17:49:32 : Done! :)
    [/blockquote]
    so information for you are:
    i have ALL rights in database that are available...
    i have ALL rights for access on harddrive...

    greets
    lumo
     
  2. artemstudent

    artemstudent New Member

    i have the same problem :(
    your folder don't have access to write, try this:
    1)backup your datebase
    2)(in /ASP/_backups) chmod 777 -R _backups/
    3)backup your datebase
    you have 1 min to do this :D
     
  3. shadow42

    shadow42 Member

    There was an error with this at one stage which I think was fixed in 1.4.2. If not then I'm sure there is a solution in the main bf2statistics 1.4 thread.

    Oh and artemstudent is correct it was a chmod issue. Also, the backup file location MUST be an absolute path accessible by MySQL AND the db user must have file level access right (BIG security issue, but it was intended to be a simple thing). Deatils of this are in the readme.
     
  4. lumo

    lumo New Member

    as above, i have all rights in database.

    i know how to backup database via sql, but does not work in asp (tried with same account in my sql query browser....)

    ok somehow rights were not set on directory asp... changed that...
    still the db user has ALL available rights!

    still those errors:
    [blockquote]
    Processing: Backup Database

    2006-11-29 12:10:01 : Backing Up Data Tables


    Warning: mkdir() [function.mkdir]: No such file or directory in D:\httproot\ASP\includes\admin.process.php on line 987

    2006-11-29 12:10:01 : -> Created Backup Directory: c:/Inetpub/wwwroot/ASP/_backups/bak_20061129_1210
    2006-11-29 12:10:01 : -> ERROR: Table (army) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : -> ERROR: Table (awards) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : -> ERROR: Table (kills) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : -> ERROR: Table (kits) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : -> ERROR: Table (mapinfo) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : -> ERROR: Table (maps) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : -> ERROR: Table (player) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : -> ERROR: Table (player_history) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : -> ERROR: Table (round_history) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : -> ERROR: Table (servers) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : -> ERROR: Table (unlocks) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : -> ERROR: Table (vehicles) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : -> ERROR: Table (weapons) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : -> ERROR: Table (data) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : -> ERROR: Table (stats) *NOT* Backed Up: Access denied for user 'bf2'@'%' (using password: YES)
    2006-11-29 12:10:01 : Done! :)

    [/blockquote]
     
  5. shadow42

    shadow42 Member

    Err, lumo have another look man and I think you'll see the issue. !dodge

    Your /ASP folder is "D:\httproot\ASP\"

    The backup folder the script is using is "c:/Inetpub/wwwroot/ASP/_backups"

    I suspect this location doesn't exist?? If you change the "Backup Path" (remember this is an absolute folder), I'm sure it will work. ;)

    Do I hear a "DOH!"? :p

    As for backing up your db, the native mySQL is superiour to this method. My backup routine is a quick and nasty data dump... It works, but it's not elegant. !dodge
     
  6. lumo

    lumo New Member

    hehe, ok, then i keep the backup from mysqlbrowser ;)
    greets
    PS: tanks for support