Question:
How can I restore MySQL with only data files from the file system?
Answer:
In the event that a standard backup is not available or an option, it is possible to perform a restore as long as all files from the install location for Internal database are available. This can be done using the steps below.
Note! Do not use this method to attempt to move the Internal database version 1 to Internal database version 2. It will not work!
- Take a backup of the Internal database folder, being used for restore, by copying to a secondary location.
- If needed, install a clean copy of Internal database.
- Stop Internal database.
- Take a backup of the clean internal database folder located <Install Path>\DocuWare\Internal Database.
- Remove all files from <Install Path>\DocuWare\Internal Database\data\.
- From the original files being used as a "backup", copy all folders and the ibdata1 file in the data folder to the corresponding location above. (The remaining files are created upon starting the database. If these files are moved, you will not be able to start the database.)
- If there has been performance tuning done to the my.ini file, you may copy this file, which is located in the root folder of internal database.
- Start internal database.