Post by stephenphill on Nov 13, 2018 21:26:44 GMT -6
Hi, I have a problem that has been going on for a long time, but I am never on-site to call in to support to get help in normal hours.
We have two locations. The first has no problem with backups. The second has never had backup working correctly. I do know how to copy the 'db' files off the system for a manual backup, but of course I want automated backups to work.
Both locations have always stayed current with Crystal PM updates. Both have PCs with Windows 10 Pro. Both have external USB3 drives plugged in and the backup job configured to use a directory on the external drive.
The automated jobs can be made to run if I settle for "Backup To Folder" "Day of Week" mode, and I make the directories for it first. It can not make the directories. Currently I tried having it back up to a folder on my Desktop ( just as a test ) and my args file has:
C:\Program Files (x86)\CrystalPM>type backupmysql.args
-c -o C:\Users\admin\Desktop\CrystalBackup -dow -v -e stephenphill@pobox.com -check
and if I do NOT make the "buTuesday" dir it expects, when I run the backup by hand I get this error:
C:\Program Files (x86)\CrystalPM>"C:\Program Files (x86)\CrystalPM\backupMySQL.exe"
-- Crystal PM Backup Utility --
version 3.4
Backup Directory=C:\Users\admin\Desktop\CrystalBackup\buTuesday
Data Directory=C:/Program Files (x86)/MySQL/data\easyopti
checking db integrity
checking service mysql
getting tables available
.... many lines deleted ....
PASSED: wisresp
returned True
ERROR:System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Users\admin\Desktop\CrystalBackup\buTuesday'.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.Directory.InternalGetFileDirectoryNames(String path, String userPathOriginal, String searchPattern, Boolean includeFiles, Boolean includeDirs, SearchOption searchOption)
at System.IO.DirectoryInfo.GetFiles(String searchPattern, SearchOption searchOption)
at System.IO.DirectoryInfo.GetFiles()
at Startup.Backup.DirSize(DirectoryInfo d)
at Startup.Backup.mainCommand(String[] args)
Exiting
C:\Program Files (x86)\CrystalPM>
If first I go make the directory, then the backup gives this result:
PASSED: wisreq
checking table wisresp
PASSED: wisresp
returned True
Start Time : 11/13/2018 9:17:27 PM
End Time : 11/13/2018 9:17:32 PM
Run Time : 0mins 5secs
Backup Loc:C:\Users\admin\Desktop\CrystalBackup\buTuesday
Backup Size:0 Gigs
Disk Space Avail:417.6401 Gigs
Email Message Sent to stephenphill@pobox.com
Exiting
C:\Program Files (x86)\CrystalPM>
But it actually didn't make a backup - it never even made the "db" subdir in the backup location. The Backup Size 0 Gigs - and you can view the backup dir and there is nothing there at all.
This all works exactly the same when backing up to my external drive, I just tested a new folder to see if it is the same. But if overwriting an existing backup it will work, and the backup size is something larger than "0 Gigs".
And of course I don't want the day-of-week backups, I want a compressed zip with the date. But that fails 100% of the time, while the day-of-week I can make work sometimes.
Any ideas?
Thanks,
We have two locations. The first has no problem with backups. The second has never had backup working correctly. I do know how to copy the 'db' files off the system for a manual backup, but of course I want automated backups to work.
Both locations have always stayed current with Crystal PM updates. Both have PCs with Windows 10 Pro. Both have external USB3 drives plugged in and the backup job configured to use a directory on the external drive.
The automated jobs can be made to run if I settle for "Backup To Folder" "Day of Week" mode, and I make the directories for it first. It can not make the directories. Currently I tried having it back up to a folder on my Desktop ( just as a test ) and my args file has:
C:\Program Files (x86)\CrystalPM>type backupmysql.args
-c -o C:\Users\admin\Desktop\CrystalBackup -dow -v -e stephenphill@pobox.com -check
and if I do NOT make the "buTuesday" dir it expects, when I run the backup by hand I get this error:
C:\Program Files (x86)\CrystalPM>"C:\Program Files (x86)\CrystalPM\backupMySQL.exe"
-- Crystal PM Backup Utility --
version 3.4
Backup Directory=C:\Users\admin\Desktop\CrystalBackup\buTuesday
Data Directory=C:/Program Files (x86)/MySQL/data\easyopti
checking db integrity
checking service mysql
getting tables available
.... many lines deleted ....
PASSED: wisresp
returned True
ERROR:System.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Users\admin\Desktop\CrystalBackup\buTuesday'.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.Directory.InternalGetFileDirectoryNames(String path, String userPathOriginal, String searchPattern, Boolean includeFiles, Boolean includeDirs, SearchOption searchOption)
at System.IO.DirectoryInfo.GetFiles(String searchPattern, SearchOption searchOption)
at System.IO.DirectoryInfo.GetFiles()
at Startup.Backup.DirSize(DirectoryInfo d)
at Startup.Backup.mainCommand(String[] args)
Exiting
C:\Program Files (x86)\CrystalPM>
If first I go make the directory, then the backup gives this result:
PASSED: wisreq
checking table wisresp
PASSED: wisresp
returned True
Start Time : 11/13/2018 9:17:27 PM
End Time : 11/13/2018 9:17:32 PM
Run Time : 0mins 5secs
Backup Loc:C:\Users\admin\Desktop\CrystalBackup\buTuesday
Backup Size:0 Gigs
Disk Space Avail:417.6401 Gigs
Email Message Sent to stephenphill@pobox.com
Exiting
C:\Program Files (x86)\CrystalPM>
But it actually didn't make a backup - it never even made the "db" subdir in the backup location. The Backup Size 0 Gigs - and you can view the backup dir and there is nothing there at all.
This all works exactly the same when backing up to my external drive, I just tested a new folder to see if it is the same. But if overwriting an existing backup it will work, and the backup size is something larger than "0 Gigs".
And of course I don't want the day-of-week backups, I want a compressed zip with the date. But that fails 100% of the time, while the day-of-week I can make work sometimes.
Any ideas?
Thanks,