With this migration script it is possible to migrate the existing traffic log data from IPCop 1.4 to IPCop 2.0. The script has to be executed on IPCop 1.4 where it will generate a SQL insert commands file. When executing the SQL insert commands on IPCop 2.0 the traffic log data will be inserted into the traffic accounting database and can be shown via the webui or with trafficsum on the new IPCop 2.0.

Procedure:

1. The latest Net-Traffic must be installed on IPCop 1.4.
2. Copy the file MigrateTrafficLog-1.0.2.tar.gz to your IPCop 1.4 box (by using SCP or WinSCP).
3. Login (ssh or Putty) into your IPCop 1.4 box as root and chdir to the place where you put the archive.
4. Unpack the archive with:
       tar zxvf MigrateTrafficLog-1.0.2.tar.gz
5. Execute the migration script with:
       ./genTrafficInsertSQL.pl
6. Copy the newly created file /root/trafficInsertSQL.sql to the new IPCop 2.0 box (by using SCP or WinSCP). Probably you have to copy it to your local PC first if you aren't able to copy it directly to your IPCop 2.0 box.
7. Login (ssh or Putty) into your IPCop 2.0 box as root and chdir to the place where you put the file.
8. Importiert the traffic log date with:
       sqlite3 /var/log/traffic/aggregate.db < trafficInsertSQL.sql
9. The file trafficInsertSQL.sql can be deleted now.