How to move log-files to a new PPHLogger installation?

[mercurio]

Hello everybody.

I just installed PPHlogger on another server and tried to move log-files from an existing account onto a new account on the new server.

What I did is exporting

- pphl_xxxxx_logs.sql
- pphl_xxxxx_mpdl.sql

from my old servers' sql database and importing them into the new one. After that I just deleted the log-files for the new account on the new server and renamed the imported ones so that the file names match.

Now, when logging into the new account all I get is sql error messages. Somehow the tables I imported do not work with the account.

Does somebody know what I do have to change to make it work?

Is there an easier way of importing my old logs into the new account?

Thanks for your help!

[sdjl]

I find the best way of moving MySQL data is by using the command line (SSH, telnet, etc).

Login to SSH if you have it and do the following:

mysql -u USERNAME -p -D DATABASE > pphlogger-backup.sql

You can then tar the file up if you want before downloading or transferring to your other server.
Once at the new location, run the following to import the data:

mysql -u USERNAME -p -D DATABASE < pphlogger-backup.sql

David

[ebac]

Hi!

I moved my stats to a new server.

The dspLogs.php shows me all the hits in the correct way but dspCalendar.php shows the 'unique hits' only from the day I installed phlogger in the new server.

Moreover, if I click 'show all pageimpressions' in dspCalendar.php, it shows me the correct statistics (the entire statistic of the user)!

Why 'unique hits' only shows data from the day of new installation on?

Thank you

Enrico