Serial NO. : S00201032-EN
Date of Editing : 2025-03-14
When changing a computer, the database backup does not include event log. The event log can be exported by 701Server and then import into new database on the new computer. The steps are as follows:
Step 1: Export Event Log
Open 701ServerSQL → Go to Settings → Select Export Log to SQL.
Step 2: Save the Log File
Choose a file path, rename the file, and click Save.
Step 3: Transfer the File
Copy the saved log file LogExport.SQL to the new computer where 701ServerSQL and the database are installed.
Step 4: Prepare the New System
On the new computer, for first run, please must right-click and select "Run as Administrator" to start both 701ServerSQL and 701ClientSQL. After successfully run, then close the software of 701ServerSQL and 701ClientSQL.
Step 5: Open the Log File
Open the exported log file using Notepad.
Step 6: Copy the Log Data
Press Ctrl + A to select all text in the file, then copy it.
Step 7: Open the Database
Open HeidiSQL (using MariaDB as an example).
Click on the [EventLog] table— it should be empty.
Step 8: Paste the Log Data
Click [Search], then right-click and select Paste to insert the copied log data.
Step 9: Execute the Query
Click [Execute] to run the SQL commands.
Step 10: Refresh and Verify
Select the EventLog table and press F5 to refresh.
The imported event logs should now be visible in the table.
.png)
Import and Export Operation Timing
Key Point: If the new computer has already generated event logs, you must first export these event logs and then delete them from the database. Then, after importing the old event logs into the database, re-import the new event logs.
This process ensures that the index sequence of the new event logs continues after the old event logs.
Detailed Steps
STEP 1 : Export the new event logs from the new computer (to prevent data loss).
STEP 2 : Delete the new event log from the database (to make space for importing the old event logs).
STEP 3 : Import the old event logs (to restore the original data completely).
STEP 4 : Re-import the new event logs (ensuring the index sequence follows the old event logs).
This process ensures that all event logs are arranged in chronological order, preventing data overwrites or inconsistencies.