The database is stored in the easyopti folder. Unless you changed the location it is located in: C:\Program Files (x86)\MySQL\data\easyopti If you do not have a Program Files (x86): C:\Program Files\MySQL\data\easyopti
A good way to tell if this is your current data base is to open the easyopti folder and sort by date modified. The most recent date should match the last time you were in Crystal. Let us know if you have any questions or need any assistance. Erica
I previous had a back up program install on my server to back up crystal manually. This was install by Crystal PM. I have since switched servers and would like to move over that backup program.
There is a batch file called backup.bat that will backup the easyopti file. You can search for it in the bottom left corner of the desktop. It should be in the folder in Program Files/Crystal PM or Program Files (x86)/Crystal PM. This is the code for the backup.bat file from Crystal: @echo off @net stop mysql @xcopy /Y /E /C /G /R /K /I "c:\program files\mysql\data\easyopti\*.*" e:\backup\ @date /t > c:\backup.txt @echo Backup Completed @net start mysql @exit
It turns off MySQL, copies the files in the easyopti folder into a folder called backup on the e drive, then it turns MySQL back on. If you want a different folder name or a different drive, you can edit the batch file by right clicking and selecting Edit. My backup drive is F and I wanted the folder to be named easyopti plus that date and time so I replaced e:\backup\ with f:\easyopti_%date:~-10,2%%date:~-7,2%%date:~-4,4%_%time:~0,2%%time:~3,2%\
You can run that batch file in the task scheduler to run automatically. In Windows 7, If you have an admin password, right click the file and select run as administrator.
Note: If you try to delete or rename the easyopti folder after Crystal PM has been opened, even if you have closed Crystal, you will get a “Folder in Use” warning that says that action can’t be taken because a folder or file is in use. You have to stop MySQL, make the change, then start MySQL –OR- close Crystal, restart the computer, make the changes, then restart Crystal.
To stop MySql start the Command Prompt (just search for it).
Right click and select Run as administrator if you have a Win 7 Admin.
At the cursor type in net stop mysql and hit enter. It will reply "The MySQL service is stopping". Then "The MySQL service was stopped successfully".
Make whatever changes you want to the folder.
type net start msql and hit enter. It will reply "The MySQL service is starting." Then "The MySQL service was started successfully."
I tried posting a screen grab of the command prompt but it is fuzzy when I upload it.
Last Edit: Sept 23, 2014 6:40:02 GMT -6 by mdeyedoc
I'm going to post a question to this thread rather than start a new one since it's relevant however feel free to move it if necessary.
I have been using two backup batch files, one backs up to a hard drive folder and another backs up to a removable usb drive, and a backup is created for each day of the week which is the default configuration for those batch files. I also have a cloud based backup that copies the contents of those daily backups so the data is also stored offline.
Both of those batch files are run during off hours using Windows 10 pro task scheduler and it's been working fine until last week when I implemented a few changes to further secure all 9 office computers. Rather than having one administrator account on all pc's which are used by various staff members, I turned the main login account into a "standard user" account and created an administrator password protected account that staff members do not have access to. I used group policy editor to place certain limitations on the standard user accounts, primarily to restrict the ability to install programs.
The problem is that task scheduler no longer runs the two batch files.
How can I resolve this issue and allow task scheduler to run these 2 batch files via the standard user account in Windows 10 Pro?