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
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
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.
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]
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!"? 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
